Hooker Posted August 1, 2008 Share Posted August 1, 2008 I have a table of "jobs" and a trigger to start the proceedure when a record is inserted into the table, the proceedure is passed the UID of the entry. I was wondering if there is a way to use a SELECT statement to find that record and then assign several variables within a stored proceedure based on the result set (one record, 5 fields). Link to comment https://forums.phpfreaks.com/topic/117716-solved-stored-procedures/ Share on other sites More sharing options...
fenway Posted August 5, 2008 Share Posted August 5, 2008 Variables? Huh? Link to comment https://forums.phpfreaks.com/topic/117716-solved-stored-procedures/#findComment-608966 Share on other sites More sharing options...
Hooker Posted August 5, 2008 Author Share Posted August 5, 2008 Oops, forgot to flag this as solved, i already worked it out using a CURSOR. Link to comment https://forums.phpfreaks.com/topic/117716-solved-stored-procedures/#findComment-609016 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.