2. PHPRunner General questions
  3. Where Clause error use in lookup table
This topic is locked

Where Clause error use in lookup table

 		7/13/2009 4:21:07 AM
PHPRunner General questions
D
 d_gan author

My r_package table consist of ID, Application Name, Application Category, Application Type, Status
In the editor view, for Package field I have make it lookup the r_package table Where Application Type show only show the "Business" type.
Where Table is r_package, Link Field and Display Field is Application Name,

Where Clause I have tried

"Application Type='Business'"
It Show

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type='Business'' at line 1


" Application Type =Business"

also error


'Application Type=Business'
it show You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Type like Business' at line 1
All this it display error, I currently using phprunner 5.1 with mysql is 4.1 and PHP4

Does it have anything do with my PC regional Setting or Database UTF8_latin_ci?
K
 		KevinMillican 7/13/2009

`Application Type` should be quoted. Try:
`Application Type` = 'Business'
D
 		d_gan author 7/13/2009

`Application Type` should be quoted. Try:

`Application Type` = 'Business'



Thank for quick reply. I tried "`Application Type` = 'Business' " and it working perfectly <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=42670&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> Thank You Kevin