Lookup List (not based on a table) and advanced search

Hi,
To make your pages working modify function GetFullFieldName in the include/dbcommon.php file.

Take a look at this article to find where and how make this change:

search and sort lookup values

I am sorry ... I am still confused... the link you suggested is for lookup lists that are based on another table in the database... In my case, the lookup lists are not (they were based on a list of values)...
Should I be entering these lookup values into a table to get this to work?
Karen

Karen,
I'm sorry i gave you wrong link.

Here is article you need:

http://www.xlinesoft.com/phprunner/docs/us...sql_queries.htm
BTW, your issue is related to JOIN clause, not the Lookup wizard.

tks

BTW, your issue is related to JOIN clause, not the Lookup wizard.

Are you sure the problem is with SQL? All sorts work (including on lookup fields) and ALL searches work EXCEPT those that are searching on the Lookup List fields?
Anyway, I tried to make changes as suggested in the article you sent (but once again, that article referred to values in another table NOT a Lookup List based on VALUES that I typed in).
So here is what I tried:
Old Query:
SELECT

`voters`.`LastName`,

`voters`.`FirstName`,

`voters`.`Phone`,

`voters`.`PhoneNotes`,

`voters`.`Street`,

`voters`.`houseNum`,

`voters`.`Party`,

`voters`.`group`,

`voterIssues`.`issueA`,

`voterIssues`.`issueB`,

`voterIssues`.`issueC`,

`voterIssues`.`issueD`,

`voterIssues`.`issueE`,

`voterIssues`.`issueF`,

`VotingHistory`.`SuperVoter`

FROM `voterIssues`

RIGHT OUTER JOIN `voters` ON (`voterIssues`.`voterID` = `voters`.`voterID`)

RIGHT OUTER JOIN `VotingHistory` ON (`VotingHistory`.`HVoterID` = `voters`.`voterID`)
New Query:
SELECT

`voters`.`voterID`,

`voters`.`LastName`,

`voters`.`FirstName`,

`voters`.`Phone`,

`voters`.`PhoneNotes`,

`voters`.`Street`,

`voters`.`houseNum`,

`voters`.`Party`,

`voters`.`group`,

`voterIssues`.`issueA`,

`voterIssues`.`issueB`,

`voterIssues`.`issueC`,

`voterIssues`.`issueD`,

`voterIssues`.`issueE`,

`voterIssues`.`issueF`,

`voterIssues`.`voterID`,

`VotingHistory`.`SuperVoter`

`VotingHistory`.`HVoterID`,

INNER JOIN `voters` ON (`voterIssues`.`voterID` = `voters`.`voterID`)

INNER JOIN `VotingHistory` ON (`VotingHistory`.`HVoterID` = `voters`.`voterID`)
Error from Within phpRunner ... I can't go past the edit SQL query:
Cannot retrieve columns information. Please modify SQL query and try again.

Error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to user near'. 'HVoterID'',

INNER JOIN 'voters' ON ('voterIssues'.'voterID' = 'voters'.'voter' at line 19
(note error message must be cut off because nowhere do I refer to a field voters.voter)
help?

Karen,
please zip and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a full set of generated PHP files, your database creation script with sample data.

I'll find what's wrong with your project running it on my test box.

sent email with files...
thanks SOOOO much for any help you can give me...
Karen

Karen,

I am now trying to use version 3.1 and am getting the old "unknown column..." error... I used to have to open the include/dbcommon.php file and find function GetFullFieldName.
EXAMPLE.. Find a section that returns fullfield name for UserName field and put correct table name prefix there (replace Cars with Users).
if("Cars"==$table && $field=="Username") return "Users.UserName";
I guess I still need to do this in version 3.1?
Same steps apply?

Hello, Karen
yes, you need to edit GetFullFieldName function in the include/commonfunctions.php file.