Stored Procudure not working

Results 1 to 2 of 2

Thread: Stored Procudure not working

  1. #1
    Rob Guest

    Default Stored Procudure not working

    When I put this stored in to my code, I get an<BR>"Expected end of statement error" which points to<BR>SP_. These stored procedures can go anywhere in the file correct?<BR> <BR><BR>CREATE PROCEDURE SP_Products <BR>@cat int <BR>AS <BR>SELECT Code,Title,Version,Status,"&Price&" FROM products WHERE Category = @cat ORDER BY CODE<BR><BR>Thanks,<BR><BR>Rob

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procudure not working

    Are you putting this sp into your asp code?<BR>The stored procedure must be in your database. Then you execute it thru a sentence like this:<BR>cmd.execute "sp_products " & CatValue <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