two stored procedure

Results 1 to 2 of 2

Thread: two stored procedure

  1. #1
    Join Date
    Dec 1969

    Default two stored procedure

    Hello all...I have a form with a drop down list, a text box and a submit button.<BR><BR>onChange for the dropdown menu I would like to call one stored procedure that does a search and return some data to the page.<BR><BR>if user enters text in the text field and press submit I want to call a different stored procedure to do a search and return data to the same page. What&#039;s the best way to go about doing this? Thanks.

  2. #2
    Join Date
    Dec 1969

    Default Just do it all on the server...

    &#060;%<BR>If Request("theTextField") = "" Then<BR> ... do first SP using the selected field ...<BR>Else<BR> ... do the other SP ...<BR>End If<BR>%&#062;<BR><BR>Why make it any harder than that?<BR><BR>

Posting Permissions

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