Glad that you found the problem :)
Carol Walter napsal(a):
To all who helped.
Thank you very much. I found the problem. There is a leading blank
on the last name field that I couldn't see. It was coming from my
program code.
Thanks for all your help.
Carol
On May 11, 2009, at 4:23 PM,
To all who helped.
Thank you very much. I found the problem. There is a leading blank
on the last name field that I couldn't see. It was coming from my
program code.
Thanks for all your help.
Carol
On May 11, 2009, at 4:23 PM, Carol Walter wrote:
I have copied the queries into psql an
I have copied the queries into psql and wrapped them in a BEGIN and
COMMIT. Even from psql the queries appear to work but don't store the
information. There don't appear to be errors in the log either.
Thanks for your help,
Carol
km_tezt=# begin;
BEGIN
km_tezt=# INSERT INTO "tblPeople"("f
I'd suggest you to copy the echoed queries and run them directly in
terminal (if you have access). Also if you have remote access to the
database and can use tools like pgAdmin or Navicat, that could help you
with testing. Or send me the table structure and I'll try them myself ;)
Carol Walter
Hello,
I have a PHP program that contains a number of postgres queries. At
the end of the program, it needs to write data to a database. You can
see the code that I'm using below. I have "die" clauses on all the
queries and I have the program echoing the queries that it runs to the
sc