WEB Need help converting MSSQL proc to MySQL - Will PayPal$

Discussion in 'OT Technology' started by Supergeek, Jun 22, 2009.

  1. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    Posted originally in Computers and Programming, but got no responses. I need your halp. :wtc:

    If you don't care about the $20 I offered, I can do something else, like get a sub to OT and make my avatar anything you want (within reason) if you can help me get this going.

    http://forums.offtopic.com/showthread.php?p=117436034#post117436034
     
  2. brds

    brds OT Supporter

    Joined:
    Jun 26, 2006
    Messages:
    17,652
    Likes Received:
    15
    Location:
    Atlanta
    Are you just trying to make tables?
     
  3. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    It's a procedure that returns @ROUTE as the result, using @A_NUMBER and @B_NUMBER as inputs.

    If you look at the original proc, you'll see it's trying to PRINT @ROUTE at the end. From what I've read about procedures (converting this one is my first time using them) my "work in progress" version should work, but it's bouncing errors.

    Error 1064 is a MySQL version error, which really doesn't help me much.
     
  4. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    We've got someone looking at it now. Thanks anyway.
     

Share This Page