>- see footer for list info -<
I dunno, didn't stop them with RecordCount, ColumnList and CurrentRow.  If they 
just give it a slightly more imaginative title than 'sql' I think that would be 
the way to go.  e.g. 'CFSQL', 'query_sql' or whatever.  Although there's a host 
of other variables you can get too...

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

>>> "Adrian Lynch" <[EMAIL PROTECTED]> 30/07/2008 12:11 >>>
>- see footer for list info -<
Ermmmmmmmmmmmm, I didn't write that email, some dude walked into my office
and thought it would be funny to show me up!

*looks around embarrassed*

But seriously, you can't tap on new vars to the query name as it'll cause
too much grief. The result attribute was the right way to go...

-----Original Message-----
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] Behalf Of Duncan Cumming
Sent: 30 July 2008 12:03
To: Coldfusion Development
Subject: RE: [CF-Dev] result_name.sql doesn't work?


>- see footer for list info -<
SELECT sql AS
myColumnNamedSQLtoNotConflictWithColdfusionsPseudocolumnNamedSQL


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

>>> "Adrian Lynch" <[EMAIL PROTECTED]> 30/07/2008 11:42 >>>
>- see footer for list info -<
But then how would you output a column named sql?

Adrian

-----Original Message-----
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] Behalf Of Nick Middleweek
Sent: 29 July 2008 17:33
To: Coldfusion Development
Subject: Re: [CF-Dev] result_name.sql doesn't work?


>- see footer for list info -<
Ah yes, I was getting mixed up with the name and result_name structs.
Strange that you need both, they could've grouped them into one struct under
name...

... sorry I'm still learning CF and it's idiosyncrasies...


Thanks though!


_______________________________________________

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