Batch Updates using recordsets.

Results 1 to 2 of 2

Thread: Batch Updates using recordsets.

  1. #1
    ASP Programmer Guest

    Default Batch Updates using recordsets.

    Hello, does anyone know how to send in an array as a parameter to a stored procedure.<BR>I have a situation where I want to send in an array thro ADO and read it in SQL Server Stored proc.<BR>CreateParameter has no datatype of Array or Variant.<BR><BR>Help will be really appreciated...

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default You cant.

    No way can you send an array to the backend. What you can do is pass a delinited string and then parse through the string in the backend.<BR><BR><BR>use the join function to create a delimited string of the array and then pass that string.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts