SP _ errors

[vlitim]

I have a stored procedure that does a bulk insert and a number of other updates, what I need to do is return a value to an asp page that syas whether the process havs been successful or not! is this possible?

Tim

 

[krisbrixon]

you can use an output parameter:

http://www.aspalliance.com/stevesmith/articles/sprocs.asp

or look at records affected:

http://www.activeserverpages.ru/ADO/dameth02_1.htm

Kris
- To err is human, but to really foul things up requires a computer.

 

[vlitim]

the problem I am getting is that the sp is erroring so the asp page just displays the error

Could not bulk insert. File 'c:\bulk\pos\us\ingram_micro\0502.csv' does not exist.

what I need to do is be able to return to the page a custom error from the sp, depending on when it errored. if I put on error resume next at the top of the page it gets rid of this but the asp

strSQL = ""&sp&" '"&filename&"' "
set disti=posconn.execute(strSQL)
------------DOESN't GET TO HERE??????-------------
disti.close

so I can't get anything that the sp returned!