Hi All,
I've got a very strange problem happening with QofQ in CFMX 6.1
I'm sure the problem is fixed with the additions to QofQ in CF 7, but
6.1 is defo a problem.
There's a simple enough fix, so i figure i'll post it here so anyone
that googles for it at a later stage will find the solution.
If you have a query, with mainly numbers in one column (but some text
too), and try to do a query of query on it, CF gives the following
error message:
"some text from query" must be interprettable as a valid number in the
current locale.
The problem (i guess) is that CF looks at the first few records and
determines the field type. In my case, the first 100 records were
numeric, then i had some text.
So to solve it, i just added some text in the first row of the query.
I can then do a QofQ later on to remove it.
<cfset qSpList = queryNew("course_id,course_type,course_name") />
<cfset queryAddRow(qSpList) />
<cfset querySetCell(qSpList,"course_id","xx") />
<cfset querySetCell(qSpList,"course_type","xx") />
<cfset querySetCell(qSpList,"course_name","xx") />
I hope that helps someone at some stage.
Gav
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
