Member Avatar for smitha_aa

Hi,

I have web page which has an array.I want that array to be passed in to stored procedure?Can anybody tell me how to do this?

wen the stored procedure is executed i want the following output.

a[0]=a,a[1]=b,a[2]=c etc...

  • 4 Contributors
  • 5 Replies
  • 184 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by ChrisHunter
Member Avatar for radhakrishna.p
Edited by radhakrishna.p because: providing some useful information about the soution for the problem
Member Avatar for smitha_aa

Hi,

I'm still not able to pass array in stored procedure(MY SQL).Can please anyone help me..
Thanks,

Member Avatar for ChrisHunter

Have you tried looping through the array and executing the procedure for each index in the array?

Member Avatar for Ketsuekiame

Nevermind, misread MY SQL as MS SQL

Edited by Ketsuekiame
Member Avatar for ChrisHunter

I tried to do something similar for an SQL Server 2005 project i'm working on but realised creating types (which would solve my problem) wasn't introduced untill the 2008 version.

Take a look at these links:

Link 1

Link 2

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.