Calling stored procedure returns only one line

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
Posts: 78
Joined: Tue Jan 27, 2015 1:10 pm

Calling stored procedure returns only one line

Post by Scoperzor » 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?

Post Reply

Return to “Databases”