PostgreSQL query many escape characters?
| From: | Carol Walter | Date: | Fri, 01 May 2009 16:58:35 +0000 |
| Subject: | PostgreSQL query many escape characters? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46161@lists.php.net to get a copy of this message | ||
Hello,
I am very new to this process, so please forgive me if this is a silly question. I have a number of PostgreSQL tables that use the naming convention that capitalizes the first character of each word, therefor the data names require quotes. When I put together my queries using parameters for the selected columns and the table names and use pg_query_params instead of pg_query to build the query? Doing it without the parameterization looks like this...
$query = "SELECT tp.\"peopleId\",\"fName\",\"mName\",\"lName\",\"contactItem\"
FROM \"tblPeople\" tp
LEFT JOIN \"brdgPeopleContactInformation\" bpci ON tp.\"peopleId\" = bpci.\"peopleId\"
LEFT JOIN \"tblContactInformation\" tci ON bpci.\"contactInformationId\" =
tci.\"contactInformationId\"
WHERE (\"lName\" like '$l_name' AND \"fName\" IS NULL) OR (\"lName\" like '$l_name' AND \"fName\"
LIKE '$f_name')
ORDER BY \"lName\",\"fName\",\"mName\"";
$SciName = pg_query($query);
This actually works, believe it or not, but my next query where I'm doing an insert to the tables does not.
Thank you in advance for your time.
Carol