RE: Preview a query string
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: Select * from contacts where 1 and company like '%#Form.company#%' and city like '%#Form.city#%' and state like '%#Form.state#%' #myquery# #PreserveSingleQuotes(myquery)# > -Original Message- > From: Luis Lebron [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 3:32 PM > To: CF-Talk > Subject: Preview a query string > > > I am building a dynamic query that looks like this: > > > Select * from contacts where 1 > > > and company like '%#Form.company#%' > > > > and city like '%#Form.city#%' > > > > and state like '%#Form.state#%' > > > > > > How can I print the actual query string so that I can check > it's syntax? > > > > thanks, > > > Luis > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preview a query string
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 Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: "Luis Lebron" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 3:32 PM Subject: Preview a query string > I am building a dynamic query that looks like this: > > > Select * from contacts where 1 > > > and company like '%#Form.company#%' > > > > and city like '%#Form.city#%' > > > > and state like '%#Form.state#%' > > > > > > How can I print the actual query string so that I can check it's syntax? > > > > thanks, > > > Luis > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preview a query string
> Remove the 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 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Preview a query string
Build the whole thing first: Select * from contacts where 1 and company like '%#Form.company#%' and city like '%#Form.city#%' and state like '%#Form.state#%' #myquery# #PreserveSingleQuotes(myquery)# > -Original Message- > From: Luis Lebron [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 3:32 PM > To: CF-Talk > Subject: Preview a query string > > > I am building a dynamic query that looks like this: > > > Select * from contacts where 1 > > > and company like '%#Form.company#%' > > > > and city like '%#Form.city#%' > > > > and state like '%#Form.state#%' > > > > > > How can I print the actual query string so that I can check > it's syntax? > > > > thanks, > > > Luis > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preview a query string
Comment out your tags and replace with 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 like this: Select * from contacts where 1 and company like '%#Form.company#%' and city like '%#Form.city#%' and state like '%#Form.state#%' How can I print the actual query string so that I can check it's syntax? thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preview a query string
Remove the 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 that looks like this: > > > Select * from contacts where 1 > > > and company like '%#Form.company#%' > > > > and city like '%#Form.city#%' > > > > and state like '%#Form.state#%' > > > > > > How can I print the actual query string so that I can check it's syntax? > > > > thanks, > > > Luis > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Preview a query string
I am building a dynamic query that looks like this: Select * from contacts where 1 and company like '%#Form.company#%' and city like '%#Form.city#%' and state like '%#Form.state#%' How can I print the actual query string so that I can check it's syntax? thanks, Luis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4