2. PHPRunner General questions
  3. Correct WHERE clause syntax in Lookup Table
This topic is locked

Correct WHERE clause syntax in Lookup Table

 		8/8/2007 3:25:40 PM
PHPRunner General questions
D
 daveDiamond author

I've grown out of control with frustration using PHPR 4 build 265. It seems I'm an idiot and can't figure out the proper syntax for the following WHERE clause:

"total_signed_up < 50"

or

'total_signed_up' < 50

or

'total_signed_up < 50'


Is this even remotely close? I consistently get the dreaded "unable to retrieve data using the Where condition you've entered." I've nearly given up here. I've got a deadline too.
I CAN get it to work with a SQL queries via phpMyAdmin but no dice in PHPR. Any help is appreciated.
Dave
D
 		daveDiamond author 8/8/2007

Oops! Sorry. Didn't realize I posted in the wrong forum. Admin please move if necessary.
I figured it out though. The correct syntax was:

"total_signed_up <= '50' "