CFLOCATION performs a browser-side redirect. On your second page, CFDUMP the URL scope and see if you are passing the variables correctly. m!ke
_____ From: Ali [mailto:[EMAIL PROTECTED] Sent: Sun 3/9/2008 2:24 PM To: CF-Talk Subject: Is cflocation like a link?? Hi: I was working on a page which was sending some URL variables to another page and I figured out that using cflocation could help me there but every time I use cflocation the following error comes back: Syntax error (missing operator) in query expression 'Tbl_Users.UserID = Tbl_AccOrders.UserID AND Tbl_Accessories.PrID = Tbl_AccOrders.PrID AND Tbl_AccOrders.OrederID = 23 AND Tbl_AccOrders.UserID = 98'. I checked it with a usual link and sending URL variables and it worked just fine but when I use cflocation it seems something goes wrong!!! I wonder what is different in sending data from a page to another in CFLOCATION and a uaual link with ?variablex=... I write down more of my code for more clearance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

