>- see footer for list info -< That's the one, Duncan! Many thanks. Cheers 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 14:29:29 +0000 > > >- see footer for list info -< > What about > <cfset myvar = queryname["@var"]> > > > Fife Council requests that you "Think Green" and only print this > email if absolutely necessary > > >>> "Terry Riley" <[EMAIL PROTECTED]> 08/12/2008 14:02 >>> > >- 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 -< > > > _______________________________________________ > > 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 -<
