--0-1967513926-956877340=:7985
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Note: forwarded message attached.
__________________________________________________
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--0-1967513926-956877340=:7985
Content-Type: message/rfc822
X-Apparently-To: [EMAIL PROTECTED] via web4204.mail.yahoo.com
Return-Path: <[EMAIL PROTECTED]>
X-Track: 22: 40
Received: from www.houseoffusion.com (HELO hof001.houseoffusion.com) (207.31.122.140)
by mta105.mail.yahoo.com with SMTP; 27 Apr 2000 16:12:32 PDT
Received: from sag.support.net ([209.144.180.21])
by hof001.houseoffusion.com (Post.Office MTA v3.5.3 release 223
ID# 0-54969U100L100S0V35) with ESMTP id com
for <[EMAIL PROTECTED]>; Thu, 27 Apr 2000 19:18:24 -0400
Received: from sog.support.net ([209.144.180.7]) by sag.support.net
(Post.Office MTA v3.1 release PO205e ID# 0-34426U200L100S0)
with ESMTP id AAA138 for <[EMAIL PROTECTED]>;
Thu, 27 Apr 2000 16:17:22 -0700
Message-Id: <[EMAIL PROTECTED]>
Date: Thu, 27 Apr 2000 16:18:09 -0700
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED] (paul smith)
Subject: Re: Add single quotes to each element on a list
In-Reply-To: <037001bfb09b$e57da760$[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Reply-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
Content-Type: text/plain
Content-Length: 1623
<cfset NewselState = "'#Form.selState#'">
<cfset NewselState = REReplaceNoCase(NewselState, ",", "','", "ALL")>
or something like this
At 06:57 PM 4/27/00 -0400, you wrote:
>Hello,
>
>I have a multiple selection list of states in the US
><cfselect display="rstate_name"
> multiple="yes"
> size="5"
> required="yes"
> message="Please select a state!"
> value="rstate_code"
> query="selByState"
> name="selState">
> </cfselect>
>
>When the user selects several out of the list and submit, the selected state
>Code are passed as
>selState = 'AL,AK,AS,AZ,AR,CA,CO,CT,DC,DE,FL,GA'
>
>I wonder if there is a way to make the list like
>selState = 'AL','AK','AS','AZ','AR','CA','CO','CT','DC','DE','FL','GA'
>
>because on the next page i am writing some SQL like this
> SELECT *
> FROM ORIA_STAKEHOLDER
> WHERE RSTATE_CODE IN (#selState#)
>
>I should have single quotes on each of the elements so I could get correct
>result.
>
>Any input is appreciated, HTH
>
>Sylvia
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>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.eGroups.com/list/cf-talk
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.
--0-1967513926-956877340=:7985--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
