Post reply

Stored Procedure Running More Than Once

  • March 8, 2007 at 7:57 am

    #693821

    Sorry I meant to address Kris Sledge in my last post

  • March 8, 2007 at 8:03 am

    #693831

    If it is a input type submit, and has an onclick event, the safest thing to do is change it to an input type button and use the javascript form.submit() to submit the form after the check is performed. We have been bitten by this one many times and it is a pain to track down. At the least, changing the input type is a simple try to see if it fixes the problem.

    Good luck!!

  • March 8, 2007 at 9:56 am

    #693871

    My solution does need some error handling. (sp_releaseapplock in CATCH block etc)

    Also, it would probably be better to use the SP name plus the @HashedBasketId for the resource just in case there is confusion with other SPs.

     

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply