[RESOLVED] MySQL parameter is not a parameter

[kebo]

Ladies and Gentlemen, good morning.

I have the following MYSQL statement that runs fine outside of my application (i.e. in some other sql front end like Heidi, mySQL workbench, etc)...

SET @rowNum=0;
SELECT CONCAT('tray ',@rownum:=@rownum + 1,' - ' ,quantity, ' screws') as title,imagePath as path
FROM tray_test_table
WHERE lotID=96
ORDER BY timestamp ASC

When I run it in my .net application I get an exception because @rownum is being considered a parameter. Has anyone encountered this, and might anyone know of a work around?
Thanks for looking.
kevin