that parses out to armyNavy_departments all day long.
-----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:57 PM To: CF-Talk Subject: RE: cfquery question??? does #request.departmenttable# contain special chars? i'd recommend escaping it with [brackets] either way, if you're on SQL Server or Access. `backticks` will do it for MySQL, and I don't know about anything else. --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 5:46 PM > To: CF-Talk > Subject: cfquery question??? > > > SELECT > title,template,layout,meta_description,short_description,keywords,conten > t,image_a,image_b,image_c, > build_date,state > FROM #request.departmentTable# > WHERE id = #url.id# > > how could this query above possibly bomb > when in cfquery tag, yet not in query analyzer > when i know that url.id = 175 and that the > column type is int? > > thanks > > ....tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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