Remove the cfquery /cfquery tags and put an output around it...
Paul Giesenhagen
QuillDesign
- Original Message -
From: Luis Lebron [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 2:32 PM
Subject: Preview a query string
I am building a dynamic query
Comment out your CFQUERY/CFQUERY tags and replace with
CFOUTPUT/CFOUTPUT
HTH,
Jeff
- Original Message -
From: Luis Lebron [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 1:32 PM
Subject: Preview a query string
I am building a dynamic query that looks
Build the whole thing first:
cfsavecontent variable=myquery
Select * from contacts where 1
cfif Form.company IS NOT All
and company like '%#Form.company#%'
/cfif
cfif Form.city IS NOT All
and city like '%#Form.city#%'
/cfif
Remove the cfquery /cfquery tags and put an output around it...
Or, you know, like, take the easy route.
(Too much blood in my caffeine stream I guess.)
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
I'd vote for avoiding any rewriting of code and enabling query output in the
debugging information. You can see the text of the query that was
dynamicallay created if you select Show Query Information (plus the time,
etc) -- that's what that part of the debugging info is for! :)
Regards,
John
Thanks, this works.
Luis
-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 2:45 PM
To: CF-Talk
Subject: RE: Preview a query string
Build the whole thing first:
cfsavecontent variable=myquery
Select * from contacts where 1
6 matches
Mail list logo