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.
