Обсуждение: ERROR: parser: parse error at or near

Поиск
Список
Период
Сортировка

ERROR: parser: parse error at or near

От
"* *"
Дата:
Thanx to those who responded.  Unfortunately I haven't been able to solve my
problem.  Using this statement I get the error:

ERROR:  parser: parse error at or near "="

SQL = "Select users . first_name, users . last_name, profiles .
profile_name, countries . city, countries . province, countries . country,
users . email_address from profiles INNER JOIN companies ON profiles .
owner_id_bus. = companies . company_id INNER JOIN users ON companies .
default_contact_id = users . user_id INNER JOIN countries ON companies .
location_id = countries . id WHERE profiles . profile_name='" + strName +
"'";

If I put single quotes on profiles i get the error
ERROR:  parser: parse error at or near "'"

If I put double quotes on profiles i get 2 compile errors





_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com