passing multiple parameters to stored procedure


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: passing multiple parameters to stored procedure

  1. #1
    Jeff Guest

    passing multiple parameters to stored procedure


    Need help with passing multiple arguments to stored procedure


    // This line works

    ls_href="ContractedResults.asp?myparam1=" + ls_parm1;

    ---------------------------------------------------------------------


    var ls_parm1, ls_parm2, ls_parm3, ls_href;

    ls_parm1=document.thisForm.txtNDC.value;
    ls_parm2=document.thisForm.txtTrade.value;
    ls_parm3=document.thisForm.txtGeneric.value;



    // this line does not work

    ls_href="ContractedResults.asp?myparam1=" + ls_parm1 + "?myparm2=" + ls_parm2
    + "?myparm3=" + ls_parm3;




  2. #2
    Sergey Guest

    Re: passing multiple parameters to stored procedure


    To pass multiple parameters in URL separate them with &
    Your line will look like this:
    ls_href="ContractedResults.asp?myparam1=" + ls_parm1 + "& myparm2=" + ls_parm2
    + "&myparm3=" + ls_parm3

    sergey

    "Jeff" <jeffm@earthlink.net> wrote:
    >
    >Need help with passing multiple arguments to stored procedure
    >
    >
    >// This line works
    >
    >ls_href="ContractedResults.asp?myparam1=" + ls_parm1;
    >
    >---------------------------------------------------------------------
    >
    >
    >var ls_parm1, ls_parm2, ls_parm3, ls_href;
    >
    >ls_parm1=document.thisForm.txtNDC.value;
    >ls_parm2=document.thisForm.txtTrade.value;
    >ls_parm3=document.thisForm.txtGeneric.value;
    >
    >
    >
    >// this line does not work
    >
    >ls_href="ContractedResults.asp?myparam1=" + ls_parm1 + "?myparm2=" + ls_parm2
    >+ "?myparm3=" + ls_parm3;
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center