n my insert query, but that doesn't seem
to work either.
Thanks,
Carol
On Jun 16, 2009, at 12:08 PM, Jason Gerfen wrote:
Jason Gerfen wrote:
Carol Walter wrote:
Hello,
I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is
failing and I don't know how to troublesh
Hello,
I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing
and I don't know how to troubleshoot the problem. The error message
that it is giving is quite vague. The error message is as follows:
Warning: pg_query_params() [function.pg-query-params]: Query failed:
ERROR
Hello,
I have a php 5 and PostgreSQL 8.3.6. I wrote the original program
using pg_query. Now, I need to replace pg_query with
pg_query_params. I'm having trouble doing so. In this code pg_query
works but pg_query_params doesn't work. The code snippet is as follows:
if ($submit_info
I have several modules in a PHP program that access a postgres
database. The program needs to create a new "Name" record in a table
is it has a new name or use a name chosen from the database if it
doesn't have a new name. I want to load the chosen id in person_id if
the name is already t
From: Carol Walter
Date: May 18, 2009 4:12:16 PM GMT-04:00
To: danaketh
Subject: Re: [PHP-DB] Assigning the current value of a sequence to a
variable - Postgres 8.3.6
Hello,
Oh, of course. Sorry for the silly question.
Thanks for your help.
Carol
On May 18, 2009, at 3:45 PM
Hello,
I have a program that looks for a name in a database. If the name is
found the id of the record is assigned to a variable. Later in the
program that value is used to insert records associated with the name
into the database using a variable called person_id. If the name is
not f
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
ggest 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 n
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
', 'D', 'Oz', 't', 't');
Second query: INSERT INTO
"tblContactInformation"("contactItem","contactType") VALUES ('f...@indiana.edu
', '0010')
Can't execute 2nd query
Actually, neither query execut
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
par
;
if ($get_name == "Submit") { echo "People Id = " . $peopleId. ">"; }
Thank you for your time,
Carol Walter
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
12 matches
Mail list logo