2. PHPRunner General questions
  3. Error 256 Unknown Column when searching
This topic is locked

Error 256 Unknown Column when searching

 		5/15/2007 11:11:09 AM
PHPRunner General questions
B
 bowmansam author

I have a php runner 3.1 project based on a mysql database.
My database does not contain "friendly" fieldnames. For example c_FN for "customer first name"
I have created the project with all field names changed by manually changing the SQL so for example:
SELECT c_FN AS 'First Name' FROM tblCustomers.
The output displays fine, but whenever I search on ANY field I get error 256 "Unknown column 'tblitemsordered.Transaction ID' in 'where clause'"
Admin 5/16/2007

Hi,
could you show me SQL query for your tblitemsordered table ?

What is your PHPRunner build number ? It's displayed in PHPRunner window title.

This error shouldn't appear in latest PHPRunner 3.1
BTW instead of changing SQL query you can edit field labels on Choose fields tab in PHPRunner.
B
 		bowmansam author 5/16/2007

Hi,

could you show me SQL query for your tblitemsordered table ?

What is your PHPRunner build number ? It's displayed in PHPRunner window title.

This error shouldn't appear in latest PHPRunner 3.1
BTW instead of changing SQL query you can edit field labels on Choose fields tab in PHPRunner.


Build 151
SQL Code is:
select `IO_Ref`,

`IO_TID` AS 'Transaction ID',

`IO_OrderDate` AS 'Order Date',

`IO_OrderTime` AS 'Order Time',

`IO_PN` AS 'Part Number',

`IO_Description` AS 'Part Description',

`IO_Price` AS 'Price',

`IO_VAT` AS 'VAT',

`IO_Qty` AS 'Qty'

From `tblitemsordered`
NB I have just tried creating the labels using the "choose fields" method instead, but I still get the same problem.
J
 		Jane 5/16/2007

Please download and install the latest build of the PHPRunner 3.1:

http://www.asprunner.com/files/phprunner-setup.exe

Then open and rebuild your project.
If it doesn't help publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.