Recent content by tvunix10

I figured it out! In my sproc I had "engine=memory" on a whim I changed that to "engine=InnoDB" and it started working as expected.

I created another simple stored procedure that copies one of my tables into a temp table and returns all the rows from the temp table. That works, so looks likes stored procedures work. Maybe a mysql version issue?

I moved a database and stored procedure from Host Gator to here for testing. The pocedure takes 2 strings and returns results fine on HG but on x10 it returns zero rows. Are stored procedures allowed? Anyone else experience this?