ColdFusion - Database Access

Thread preview

Thread	Last Post	Replies

MySql DateAdd	31 Mar 2007 09:44 GMT	1
i have the code below which displays a diary of time, next to each time i need to diplay fisrtname. i am having a problem with the dateadd function on this line, how do i need to format that for MySql
cfquery and BIG resultset	31 Mar 2007 01:14 GMT	6
Stumble upon some code that is trying to use CFQuery to bring back ~50,000 records. Not surprisingly, ColdFusion MX slow to a halt and JRun eventually throw an Out of Memory Error. Assume I cannot reduce the number of records I am returning and process is
Cannot get all rows from cfProcResult	31 Mar 2007 00:00 GMT	1
We upgraded one of our servers (A) from CF 6 to 7.02. Another server (B) has CF 7.01. On server B (CF 7.01) the code works (below), all rows of each dataset are returned.
Separate from Comma	30 Mar 2007 14:22 GMT	2
Is there a way to separate an oracle db field that contains such info: LastName,FirstName or FirstName Lastname into Lastname, Firstname using toad not a function or stored proc. James,Aaron or Aaron James into James, Aaron (not there is a space btw last
new 2 stored procedure	29 Mar 2007 22:27 GMT	19
I have knowledge of cursor,procedure but didnt have a chance to write a stored procedure...Can anyone help with this ? I want to select * from table BPAR where ID= #url.var# ; url.var is an integer...How will I implement that with CF and stored procedure? Thanks all.
weird error	29 Mar 2007 19:25 GMT	3
I'm getting this weird error while transferring my application to remote server. First i created database than datasouce, and this the error i get: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming tabular data stream
need to query one day ago....	29 Mar 2007 15:20 GMT	2
Hi all... I am trying to run a query which will pull records inserted yesterday and today. I have the today figured out, however was wondering if anyone has a simple solution to the yesterday. My current query is:
use "ListContains' in a WHERE clause	28 Mar 2007 21:56 GMT	7
I believe I have a syntax problem and could you some help. First, I have a field in an Access DB called 'degree" that conatins a list of numbers. This list can be any combination of the numbers 4 through 32. On my search page I have a selection box in a form to select a value of ...
how to refresh a data source when adding fields?	27 Mar 2007 21:24 GMT	2
I have a MSSQL2K database which I add and remove fields on every so often. Generally speaking the new field doesn't show up in a query until I either restart the CF server or refresh the data source (in cfadmin) by renaming it. Same goes if I change the order of the fields in the ...
Damn Dates	27 Mar 2007 08:30 GMT	8
I have sql 2005 where my dates are stored perfectly in uk format (15/01/2007). When i run a recordset through my DM and CF 7.02 the recordset immediately converts the date to US format. I can't see anywhere in CF or DM to stop it doing this. Its getting up my nose and very ...
Can't Disable Datasource	27 Mar 2007 01:44 GMT	9
We've hit a problem with datasources on CF7, Solaris 9, Oracle9/10; disabling a datasource doesn't work. Tick the box to disable it, it keeps on working. doo this and also untick maintain connections, it keeps working. This is a serious bug as we can't properly manage our DB ...
Indexing Query Results	26 Mar 2007 17:42 GMT	1
I am trying to find out if there's a way I can index query results as arrays or structs when they are returned, instead of looping through and putting each value into an array or struct. For instance, this page:
query prob	26 Mar 2007 05:20 GMT	2
Having a little beginners bad-luck with the following code; <html> <head> <cfparam name="lastname" type="string">
Date problem sorting results	26 Mar 2007 01:18 GMT	3
When I try to sort results using a date field I receive no results. I do not receive an error message just no results. If I take out the ? AND eventdat=#FORM.eventdat# ? code from the page it works fine. WHERE 0=0
problem with recordset and access	24 Mar 2007 07:29 GMT	1
I am following a tutorial from lynda.com (creating dynamic applications with dreamweaver and coldfusion). I have completed all steps successfully and my DSN works fine. I have created a number of dynamic fors that worked well. However, the 1 that gives me problem has ...