[RESOLVED] MySQL parameter is not a parameter

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)...

SQL Code:

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

Kevin,

I found this: How can I use a MySql User Defined Variable in a .NET MySqlCommand?

Quote:

---

I have to add

;Allow User Variables=True

to the connection string

---

Excellent find my friend :thumb:
thanks