Hi Jeremy,
Try <cfset branchlist = valuelist(GetBranches.BranchCode, "'")>
Description
Gets the values of each record returned from an executed query. ColdFusion does not evaluate the arguments.
Returns
A delimited list of the values of each record returned from an executed query. Each value is enclosed in single quotation marks.
Category Query functions
Function syntax QuotedValueList(query.column [, delimiter ])
B)
Jeremy wrote:
Heya,
Quick question, Firstly been up since very very early. So me not making sense to muchly.
I have a list.
Sydney, Melbourne, Perth, Mars
This comes from a query which I then set into a list. Now previously i was able to make this list work to the way I wanted because it was all numeric. BUT NOW...They want to use AlphaNumeric.
<cfset branchlist = "#valuelist(GetBranches.BranchCode)#">
I need to put '' marks around each branch code. Do you know if this can be done. i.e. 'Sydney','Melbourne', etc etc.
I'm sure this can be done. Just a bit lost and tired on how to go about doing it.
J
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
