I have a comma delimited list returned from a multi select field on my
input form. I then take the list and use the following code:
ListQualify(#form.TypeofPets#,"'",",","ALL")
which gets the user selected result set such as the following:
'Dogs','Cats','Horses'
I then pass this variable into a stored procedure:
<cfstoredproc procedure="FAVORITE_PET_PKG.GET_PETS" datasource="pet"
returncode="No">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#TypeOfPets#"
type="In" dbvarname="inTypeOfPets">
<cfprocresult name="FavPets">
</cfstoredproc>
The stored procedure query looks like the following:
select pet_stuff1, pet_stuff2
from mypettable
where pet_type in (inTypeOfPets)
The problem is even though my input string looks like
'Dogs','Cats','Horses' the ticks are getting stripped out of the variable
(Dogs,Cats,Horses), how do I retain the ticks? inTypeOfPets is defined as
a varchar2. Im using CF MX and oracle 9.2.
Thanks in advance for your help.
Thanks again,
Casey Cook
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182894
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
