Stored Procedurs

Results 1 to 2 of 2

Thread: Stored Procedurs

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedurs

    I&#039;m trying to call a stored Procedure called GS_Catalog and pass it one parameter a variable called @VArRetailer type int. The database column for that field is of the datatype int. My problem is in the ASP call<BR><BR>Dim Retailer<BR>Retailer = cint(<BR>crs.Open "Exec GS_Catalog Retailer",ccn<BR><BR> is too large for an int data type in VB Scirpt if I try anything else it passes it as nvarchar to the procedure and it will not execute. It will not let me use the ret.ID either.

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedurs

    crs.Open "Exec GS_Catalog " & ,ccn<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