<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.
