Prev: can you not set a variable that's in the same scope as a querystructure
Next: can you not set a variable that's in the same scope as a query structure
From: paross1 on 22 Apr 2008 10:13
I don't think that you can do that, but you might try something like this:

cfquery datasource="mydb" name="note_this_name" >
select columnone, columntwo, [b]NULL AS not_a_column_name[/b]
from tbl_mytable
</cfquery>

[i]Create the "extra" column in the query, then set a value later using
cfset.[/i]

<cfset note_this_name.not_a_column_name =
"i_will_never_be_able_to_use_this_variable" >

[i] it will now have a value[/i]

<cfoutput>#note_this_name.not_a_column_name#</cfoutput>

Phil


From: happysailingdude on 22 Apr 2008 11:43
hi Ian and Phil

thanks very much indeed for your replies.

I didn't implement Ian's suggestion, as whilst i can see where your coming
from and it might well work - Phil's suggestion looked like the easiest one to
try first and sure enough it did the trick so i didn't go any further than that.

Thanks very much to you both for taking the time to reply - is much
appreciated.

PS Phil: just for the benefit of anyone else trying to solve the same problem
that i had; do you think that solution would work on all databases (ours is
MySQL - but would it work on any DB do you think?)

cheers

 | 
Pages: 1
Prev: can you not set a variable that's in the same scope as a querystructure
Next: can you not set a variable that's in the same scope as a query structure