Ahh thanks (doh), is there an easier way to get just the Requirements1,2,3 and the Proposed1,2,3,4 into a list, than doing my usual one by one method?

:)

Thanks

>Shouldn't you be doing something like this
>
>stReturn.a= ListGetAt( Valuelist( qGetSiteConfig.Config_VariableName
>),  ListFindNoCase(  valuelist( qGetSiteConfig.Config_Name ),
>"RequirementsTitle"))
>
>
>----- Original Message -----
>From: Carl V <[EMAIL PROTECTED]>
>Date: Sun, 08 Aug 2004 15:53:46 -0400
>Subject: CFC db return
>To: CF-Talk <[EMAIL PROTECTED]>
>
>I am having one of those brain freezes??  :)
>any help is appreciated
>
>I have a config.cfc
>goes along the lines of...
>
><cfquery qGetSiteConfig>
>Config_Name,
>Config_VariableName
>FROM siteConfig
></cfquery>
>
>and yes I have set the vars for stReturn
><cfset stReturn.data = ""> >
>which cfdumps like this..
>CONFIG_NAME - CONFIG_VARIABLENAME
>1 RequirementsTitle -  mySearch
>2 Requirements1 - myDescription
>3 Requirements2 - myProfile
>4 Requirements3 - myNotes
>5 ProposedTitle - myFriends
>6 Proposed1 - myResume
>7 Proposed2 - myProfile
>8 Proposed3 - myObservation
>9 Proposed4 - myVideo
>
>Here is what I am trying to do...
>stReturn.a= ListGetAt(qGetSiteConfig.Config_VariableName,
>ListFindNoCase(qGetSiteConfig.Config_Name, "RequirementsTitle"))
>
>stReturn.b = ListGetAt(qGetSiteConfig.Config_VariableName,
>ListFindNoCase(qGetSiteConfig.Config_Name, "ProposedTitle"))
>
>I have tried looping over the list but only seems to return 1 record
>when I do a ListLen()
>
>What I am trying to do is on another page is output those results..
>but I am trying to separate them...eg. I need the two titles in
>separate variables so I can put them on different part of the menu,
>then get all the list of "Requirements1,2,3" and put them in a list
>and then put the "Proposed1,2,3,4" in a list. So if there are more
>than 2-3 it just loops through...and does not matter if there is more
>or less in the list..
>
>Hope this makes sense?
>
>Am I going about this the right way? or am I way off, as I am still
>learning all about CFC's
>
>Thanks
>
>Carl :)________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to