Click to See Complete Forum and Search --> : Send a javascript array to Sql


William Blincoe
09-23-2004, 08:33 AM
I am trying to send an array to a sql stored procedure
from a asp page (javascript).
For example

the array has 3 document numbers in one string
"doc123, doc456, doc789"

goes to sql stored procedure called getdocs(@docnum)

how does sql convert the string to use in the sql
select statement "select a.* from maintable where a.docnum = @docnum)

javaNoobie
09-23-2004, 09:48 PM
i think u might u need to break up the array and generate your own sql statement..