2. PHPRunner General questions
  3. Lookup wizard problem - custom expression
This topic is locked

Lookup wizard problem - custom expression

 		12/31/2008 8:36:31 AM
PHPRunner General questions
J
 jacekq author

Hi there,
I've prepared table with looup field from another table that works OK in PHPR:


But there is an error when I try to run website:


I think the problem is that PHPR adds additional sign (`) at the beginning and the end of the SQL expression.
Best Regards,

Jacek
hichem 12/31/2008

Hi there,

I've prepared table with looup field from another table that works OK in PHPR:


But there is an error when I try to run website:


I think the problem is that PHPR adds additional sign (`) at the beginning and the end of the SQL expression.
Best Regards,

Jacek


That|S not the issue here. Try copy/paste the sql as it appears in the error message and run it against your database. The problem is elsewhere than formating of the sql by PHPR. I think it's to do with your sql query itself.
Hope this helps
Sergey Kornilov admin 1/2/2009

Jacek,
post your application to demo account and open a ticket at http://support.xlinesoft.com