Calling stored procedure returns only one line
Posted: Wed Sep 23, 2015 7:54 am
I am calling a MySQL stored procedure with revDataFromQuery, and it is only yielding one line of results regardless of the input criteria I give. The table it refers to has 4 entries in it, and if I run the query with the exact same criteria in Sequel Pro, I can return a range of results, but in Livecode it only ever returns the first line of the query.
If I input NULL for each criteria, it returns all 4 lines in Sequel Pro, but gives an error in Livecode. If I use one or more criteria, it returns the correct number of lines only in Sequel Pro.
Anyone with some insight into this?
If I input NULL for each criteria, it returns all 4 lines in Sequel Pro, but gives an error in Livecode. If I use one or more criteria, it returns the correct number of lines only in Sequel Pro.
Anyone with some insight into this?