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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to