beer-monkey.com
|
Posted: 01/23/2002, 1:50 AM |
|
What does this error mean and how can it be solved? It was entered in a lookup SQL box of a listbox field diplaying phone numbers from a table where the branch_id of the phone number matches that of the branch_id of the record....
Syntax error (missing operator) in query expression 'branch_id ='.
|
|
|
Alistair McFadyen
|
Posted: 01/23/2002, 3:22 AM |
|
Looks like the value of branch_id isn't being passed into the SQL statement, as it should say something like: branch_id=5
|
|
|
beer-monkey.com
|
Posted: 01/23/2002, 4:35 AM |
|
This is the lookup SQL that seems to produce the error->
SELECT number_id, phone
FROM phones
WHERE branch_id = " & GetParam("branch_id") & "
Any ideas how the error can be avoided?
ERROR-> Syntax error (missing operator) in query expression 'branch_id ='.
|
|
|
Nicole
|
Posted: 01/23/2002, 5:51 AM |
|
Hello,
you get the error when no branch_id is passed to the form through url. The workaround is to build WHERE clause depending on value of passed branch_id.
|
|
|
beer-monkey.com
|
Posted: 01/23/2002, 7:56 AM |
|
nicole
i didn't really understand your msg, apparently it should just be a standard one-to-many relationship whereby the branch details are matched to the appropriae contact numbers via a lookup box and the branch_id.... but it's driving me nuts..... its seems so simple...
any more help would be most appreciated hun
Thanks in advance
|
|
|