I don't think you need to use CFOUTPUT at all with CFLOCATION like that. <CFLOCATION URL="messages.cfm?thread=#formthread#"> should work just fine.
Yup, just checked, I use it like that all the time. > The cfoutput in your cflocation is causing unwanted spacing in your URL. > > Try: > > <cfoutput> > <cflocation url="messages.cfm?thread=#formthread#"> > </cfoutput> > > instead of: > > <cflocation url="messages.cfm?thread=<cfoutput>#formthread#</cfoutput>"> > > Adam. > > > > -----Original Message----- > > From: Jeremy Bunton [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 15, 2002 3: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 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
