2. ASPRunnerPro General questions
  3. MySql Where statement
This topic is locked

MySql Where statement

 		6/10/2008 12:28:58 PM
ASPRunnerPro General questions
A
 ashumak author

WHERE (((teaminfo.[Series])="Int. Men A")) OR (((teaminfo.[Series])="Int. Men B")) OR (((teaminfo.[Series])="Int. Men C")) OR (((teaminfo.[Series])="Sr. Men")) OR (((teaminfo.[Series])="Masters"));
ASPRunner doesn't like this. I pulled it from Access. Anyone able to tell me what the correct line would be for aa MySql dbase?
Alan
Sergey Kornilov admin 6/10/2008

Alan,
MySQL uses bactick character ` to wrap field names.
teaminfo.`Series`
A
 		ashumak author 6/10/2008

And I thoiught I tried that. It didn't work, but it did on the second attempt!

Thanks again!!!

Alan