Try [thread]
> -----Original Message-----
> From: Jeremy Bunton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 16 October 2002 9:23 a.m.
> 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
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
