Return multiple fields from stored procedure in ASP

• stacya

  Newbie

  Points: 2

  More actions

  March 30, 2004 at 7:40 am

  #84062

  All,

  I am trying to prevent SQL injection and need to come up with ways to return multiple values from a stored procedure. This is assuming that that is the way to go.

  What is the technique in the stored procedure as well as how does ASP access those returned values?

  Or, is there a better way to do this and eliminate dynamic SQL statements?

• stacya

  Newbie

  Points: 2

  More actions

  March 30, 2004 at 8:01 am

  #501079

  Sorry to bother you, I found the answer.

  The stored procedure returns a record set!