>- see footer for list info -<
I wonder when RecordCount, ColumnList and CurrentRow came into being?
Witness the developer who just created the following table!
CREATE TABLE awesome (
awesomeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
recordCount INT,
columnList INT,
currentRow INT
)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Duncan Cumming
Sent: 30 July 2008 13:37
To: Coldfusion Development
Subject: RE: [CF-Dev] result_name.sql doesn't work?
>- 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 -<
_______________________________________________
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 -<
