Take a look at this page for the proper INTO syntax. May change depending on which version of mysql you're using. It looks like you have to do something like INTO @visaudactvols if you're trying to use a variable.
http://dev.mysql.com/doc/refman/4.1/en/select.html -- Josh ----- Original Message ----- From: "Pete" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, March 06, 2007 10:23 AM Subject: SQL for Access vs MySQL > Hi > > Hoping someone might be able to assist - its 4am and I have just been > called > by a client coz their system crashed. They have just moved from using an > Access DB to MySQL. > > They have a piece of code: > > select * > into visaudactvols > from visualauditrecs > > The error says Undeclared variable: visaudactvols > > Any quick reply would be greatfully appreciated. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
