Hey, I don't know about SQL, but in ColdFusion, we get that error when you try to use a simple value as a complex value (ex. using a string like it was a struct). So, what would that mean? Is it possible that the values in your ## are misspelled or accidentally referencing the wrong variables?
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 2:14 PM To: CF-Talk Subject: Re: dereference a scalar variable the actually error message and the lines of code where the error occurred would be very helpful. I've seen the "Dereference a scalar variable" error before but it's hard to help without seeing the code causing the error. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

