David,
Thank you for the attempt to understand the challenge at hand.
ValueList is a clever attempted work around, except I won't be able to use a
"where" statement in the query. Every MyVar needs to be available at once.
Questions attempting clarification of the problem are encouraged and so are
solutions :-)
Rick
----- Original Message -----
From: "David Cummins" <[EMAIL PROTECTED]>
> <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.
__________________________________________________
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.
