Wednesday, June 11, 2008

Result set was not generated by a SELECT statement

This obscure error occurred when using PHP ODBC to retrieve values from a stored procedure. It turns out this occurs when the stored procedure SELECTs data from one or more TEXT columns. Convert these columns to VARCHAR(8000) and you're good to go.

1 comment:

alexanderfeil said...

Thank you so much for your hint! This saved my ass. It's not only text but also image and perhaps other stuff. But in the end it helped. Cheers, Alex