Re: OT? Passing comma delimited list to where clause in stored procedure

2004-10-29 Thread Marc Campeau
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

OT? Passing comma delimited list to where clause in stored procedure

2004-10-28 Thread Casey C Cook
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

Re: OT? Passing comma delimited list to where clause in stored procedure

2004-10-28 Thread Dave Carabetta
On Thu, 28 Oct 2004 18:09:46 -0700, Casey C Cook [EMAIL PROTECTED] wrote: 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