There is a way around this. Look up SET NOCOUNT....
-----Original Message-----
From: Darryl Lyons [mailto:[EMAIL PROTECTED]]
Sent: August 19, 2001 6:47 PM
To: CF-Talk
Subject: RE: "disappearing queries"
Thanks.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 18, 2001 1:10 AM
To: CF-Talk
Subject: RE: "disappearing queries"
I believe that CFQuery will not handle SQL that returns/processes more
than one recordset. So if you do an INSERT then a SELECT in a
proc/query, you won't get any results back. For stored procedures, you
should be using CFSTOREDPROC/CFPROCPARAM/CFPROCRESULT instead.
---
Billy Cravens
HR Systems, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Darryl Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 7:33 PM
To: CF-Talk
Subject: "disappearing queries"
Has anyone ever had any problems displaying result sets from a stored
procedure using temporary tables? The query works fine in SQL Query
Analyser, but CF just won't bring back results. Even stranger is that as
soon as the query is run, the debug info comes up with 0 results, and
then CF says the query doesn't exist..
Error below. (Note that the "asdasdsadsd" is referenced properly in the
cfoutput tag)
asdasdsadsd (Records=0, Time=15ms)
Bottom of Form 0
Error Occurred While Processing Request
SQL =
{ CALL cm_qry_listing_obj('1','47','1','1') }
Error Diagnostic Information QUERY The QUERY attribute of the tag does
not specify the name of an available query The error occurred while
processing an element with a general identifier of (CFOUTPUT), occupying
document position (5:1) to (5:30). Date/Time: 08/17/01 10:31:58 Browser:
Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address:
210.11.100.2
-----------------------------------
Regards,
Darryl Lyons
Senior Systems Developer
Fuzion: http://www.fuzion.com.au
Email : [EMAIL PROTECTED]
Phone : (07) 3620 1000
Fax : (07) 3620 1001
Technical Support : (07) 3230 8811
'merging business + technology'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
