>- see footer for list info -< Already tried that, Duncan, but thanks anyway!
The 'as xxx' seems to be ignored totally. Terry (free event listings at http://www.confexdb.co.uk) ----- Original Message ----- > *From:* "Duncan Cumming" <[EMAIL PROTECTED]> > *To:* <[email protected]> > *Date:* Mon, 08 Dec 2008 13:49:30 +0000 > > >- 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 -< > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.552 / Virus Database: 270.9.15/1835 - Release Date: > 07/12/2008 16:56 > > -- 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 -<
