Thanks Dan, In the interim, I solved my problem. As you said, the first query needed to be INSERT (that I figured out after spending some 'thoughtful' time with my beloved code :>, and I also eliminated the extra pg_connect. After that, it still wouldn't work.
Looking at the mess from pgsql (the graphical PostgreSQL interface) I noticed that the row that I was working on hadn't 'moved' [normally it moves to the bottom of the heap as the 'current record'. Seems like the index file was a little 'messed' up and was patiently waiting for me do to a 'vacuum' of the db. Once I cleaned up the database, everything worked as expected. I guess I should vacuum more frequently? Btw, you wouldn't happen to know any 'timer' script that I can program for seconds? Regards, Andre On Tuesday 18 June 2002 03:58 pm, you wrote: > On Mon, Jun 17, 2002 at 10:46:27AM -0400, Andre Dubuc wrote: > > I'm tryiing to append entries in a db textarea field 'rbook'. Everything > > works fine IF there is an existing entry. However, if no entries exist, > > it nothing is written to the db. (PostgreSQL 7.2) > > I'm not familliar with PostgreSQL, but it sure looks like your problem > stems from your using UPDATE queries. If a record doesn't exist, there's > no record to update. You need to use INSERT queries in that case. > > Also, you only need one pg_connect() statement. While that's not your > problem, it's a waste to have them in there. Just keep the one at the > top. Ditch the ones inside your if/else structure. > > --Dan -- Please pray the Holy Rosary to end the holocaust of abortion. Remember in your prayers the Holy Souls in Purgatory. May God bless you abundantly in His love! For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
