>- see footer for list info -<
Can you use an Alias?

Select @Var as someothervarname?


Fife Council requests that you "Think Green" and only print this email if 
absolutely necessary

>>> "Terry Riley" <[EMAIL PROTECTED]> 08/12/2008 13:38 >>>
>- see footer for list info -<
Afternoon, all

I have a situation where a MySQL query used to update a table field has 
also created a user-defined variable in that query of the type '@var'.

It is easy enough to grab the value by issuing a 'select @var' against 
the same datasource, and I can see the its value in the variables scope 
dump.

What I can't do is turn that variable into a CF one to use it later in 
the script, using something like <cfset myvar = [EMAIL PROTECTED]> - which 
falls over because of the '@' character.

How can I convert the @var to a cf variable?

Cheers
Terry
(free event listings at http://www.confexdb.co.uk)



-- 
No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.552 / Virus Database: 270.9.15/1835 - Release Date: 07/12/2008 
16:56


_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo 

--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<


**********************************************************************
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed and 
should not be disclosed to any other party. 
If you have received this email in error please notify your system manager and 
the sender of this message.

This email message has been swept for the presence of computer viruses but no 
guarantee is given that this e-mail message and any attachments are free from 
viruses.

Fife Council reserves the right to monitor the content of all incoming and 
outgoing email.

Fife Council
************************************************


_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<

Reply via email to