I'm not 100% sure what you're asking, but how about this:
<cfquery name="getseminars">
select * from MyTable where MyVar='SeminarsFor'
</cfquery>
<cfoutput>
The name of your seminar is: #valuelist(getseminars.MyValue)<br>
</cfoutput>
This will return all the seminars as a comma delimited list.
David Cummins
Systems Developer
Ubiquity Software Ltd
Rick Moon wrote:
>
> Hello,
>
> The "why" for the following is an email unto itself, so if possible any
> ideas on "how" would be greatly appreciate.
>
> The cfquery name="MyQuery" is selecting from the following db table:
>
> MyKey | MyVar | MyValue
> ---------------------------------------------
> 0001 | ClientName | Rick
> 0002 | SeminarsFor | aerospace
> 0003 | RAMPrice | stable
>
> Now I need to write (without looping or cfifing or cfswitching) or (changing
> the the table itself) and (caching of some sort is desired):
>
> The name of your seminar is: #MyQuery.SeminarsFor#
> The state of CA is: #SomeOtherQuery.HighTaxes#
>
> The only way I've been able to do it so far is to rebuild the above table
> into:
> ClientName | SeminarsFor | RAMPrice
> --------------------------------------------
> Rick | aeospace | stable
>
> But this constant table manipulation isn't practical.
>
> Is the answer in sql? structures? arrays? or ?
>
> TIA,
>
> Rick
>
> __________________________________________________
>
> Do You Yahoo!?
>
> Talk to your friends online with Yahoo! Messenger.
>
> http://im.yahoo.com
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
