run a test on your query page do <CFPARAM for url.thread> than your <CFSET> then <CFOUTPUT>#Url.thread#/#threadnumber#</cfoutput> see what values come back.... j ps Your url link in your email says it's outputtin formthread. do you mean thread
-----Original Message----- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 4:23 PM To: CF-Talk Subject: supposedly simple query I have this VERY simple query like <cfquery name="getmessages" datasource="mydns"> select * from message where thread = #threadnumber# </cfquery> where #threadnumber# is set by <cfset threadnumber=#trim(URL.thread)#> coming from a <cflocation url="messages.cfm?thread=<cfoutput>#formthread#</cfoutput>"> If I hard code in a number no problem it works but for some odd reason using the above I get [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'thread = 45'. Both fields are intergers. What ya think. Jeremy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
