Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Location
    New York
    Posts
    15

    Unanswered: stuck on a stored procedure problem

    Can you see anything wrong with this code? I tried modifying all the code around MySQL keeps pointing to this line, so it's gotta be in here:
    DECLARE updateLinks CURSOR FOR SELECT categoryToCategoryID, level, sortHistory, sortTitleHistory FROM b2casp.categoryToCategory WHERE sortHistory REGEXP oldSortHistory AND sortTitleHistory REGEXP oldsortTitleHistory;

    Any ideas please?

  2. #2
    Join Date
    May 2006
    Location
    New York
    Posts
    15
    solved, it's supposed to be on top of proc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •