I am sorry, I missed the beginning of this thread.... Did you try just
putting [] around the type?
SELECT
Email,
[Type] <!--- HERE IS WHAT I AM TALKING ABOUT. --->
FROM
[YOUR_TABLE]
WHERE
[AUTO_NUM_COLUMN] = #URL.id#
......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: David Pedersen [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 12:44 PM
To: CF-Talk
Subject: Re: dereference a scalar variable
I changed all "Type" to "myType" and I am still getting the same error.
> "Type" is reserved. Try aliasing it in your query to something else?
>
> > Does anyone know how to fix this error or can give me a direction to
> take on solving this issue? I have a .cfc the is suppose to get the
> record by the "AutoNum" in the SQL DB. I pass the variable through
> the url, and I need it to return an "Email" and "Type" columns from
> the db. I can get it to bring back the "Email" with no problem but it
> wants to throw a fit when it comes to the "Type" column. Any help
> would greatly be appreciated, if you need any other information let me
> know.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:269560
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
