Ask a Question related to Coldfusion Database Access, Design and Development.
-
damion #1
Re: query of query throwing weird exception
One workaround:
I had added rows to a cfsearch query, and set a numeric value in custom1 field
that that query provides. A query of queries generated the "Unsupported
Numeric type conversion in Query of Queries" error. After reading somewhere
that it is because insertion of numbers into queries fails due to CF treating
them as text values, I started guessing at conversion possibilities. This works:
CFSET junk = querysetcell(myquery,"myfield","" &
my_integervariable,currentrow)
Appending the integer value to an empty string, before inserting it in query
row, seems to make a subsequent query of queries work! Bizzarre. Blows my
mind! I don't really know why!
Regards,
Damion
damion Guest
-
#40772 [NEW]: PDO::query() does not raise exception
From: vunnuk_o at ukr dot net Operating system: Win XP PHP version: 5.2.1 PHP Bug Type: PDO related Bug description: ... -
#32101 [Com]: Exception in unknown on line 0 when throwing exception inside exception handler
ID: 32101 Comment by: dhopkins at DonHopkins dot com Reported By: ceefour at gauldong dot net Status: No... -
#39345 [NEW]: foreach($query as $row) gives PDO exception at ext\pdo_odbc\odbc_stmt.c:363
From: frederic dot fanchamps at skynet dot be Operating system: Windows XP PHP version: 5.1.6 PHP Bug Type: ODBC related Bug... -
Weird Query Hangs
I am running Coldfusion 6, and I am trying to do debug an action page for a form. Basically, I isolated the problem to one query, and then I... -
Weird! Problem of query the date for January and October
It's weird! I am writing an asp code to retireving data from the MS access. Any records before today will not be populated. It works fine except...



Reply With Quote

