Re: [PHP-DB] export queries to plain/text

2004-03-15 Thread Norma Ramirez - TECNOSOFT
What I need exactly is to send the outputs from queries made in the command line of postgresql to an plain text file, cvs or something like that, so the function suggested frwrite don't work for that case because it's from the command line. Than'ks Norma R -- PHP Database Mailing List

[PHP-DB] export queries to plain/text

2004-03-13 Thread Norma Ramirez - TECNOSOFT
Hi all, does any one know how to export queries to plain/text files in postgresql? Thank's Norma R

[PHP-DB] Remove log files in Postgres

2004-03-01 Thread Norma Ramirez - TECNOSOFT
Hi all, does any one know a configuration parameter or command line that automatically remove in a period of time the log files in postresql database? Thanks a lot. Norma Ramirez

[PHP-DB] Free PHP Editor

2003-08-14 Thread Norma Ramirez - TECNOSOFT
Hi all, after look and evaluate the options that all you kindly recommended, I decide to use the free version of Maguma, it has several capabilities that makes good, with a bit disadvantages but I think is pretty good. Another option is php edit, but unfortunately is not yet available a formal

[PHP-DB] Store images in postgres database

2003-08-14 Thread Norma Ramirez - TECNOSOFT
Hi everybody ! I haven´t could store images on my postgres database tables from my php form. I did it on mysql and this works but now I´m working on postgres,I created a table in my postgres db like this: CREATE TABLE planos(id serial primary key, image OID, filesize int(8), filename

[PHP-DB] Free php editor!!

2003-08-02 Thread Norma Ramirez - TECNOSOFT
Hi, does any one know if exist a free php editor like DreamWeaver? =) I know DreamW it´s too much than an editor with all of the duties... but I need something free... Thank´s Norma Ramirez

Re: [PHP-DB] Bar codes in PHP

2003-07-29 Thread Norma Ramirez - TECNOSOFT
Later on librarians are using the bar code scanner, which will pick up the unique id and look up in the database for further processing. Hardik this part it´s exactly what I want to know, how by using a php form, read or pick up as you say, the bar code and make an input to the database or

[PHP-DB] Bar codes in PHP

2003-07-28 Thread Norma Ramirez - TECNOSOFT
Hi all, does someone know how to capture or read bar codes from php? It will be great if I could do inputs to my database directly from bar codes in the products. Ideas??? Thank´s Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED]

Re: [PHP-DB] Bar codes in PHP

2003-07-28 Thread Norma Ramirez - TECNOSOFT
Thank´s Brad, that sounds simple, I gonna try and later I´ll tell the results. =) Norma Ramirez Area de Desarrollo Web -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] change datatype in postgres

2003-07-24 Thread Norma Ramirez - TECNOSOFT
Thank´s Xaos, help´s a lot. = Regards, Norma R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] change datatype in postgres

2003-07-23 Thread Norma Ramirez - TECNOSOFT
Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a simple alter table like other databases??? and, o.k drop the old column buy copy the data into a new one? how? with an update query? Thank´s again and sorry if bother =) -- PHP Database Mailing List

[PHP-DB] export mysql table to .dbf

2003-07-21 Thread Norma Ramirez - TECNOSOFT
Hi all, does any one how export data from mysql to fox 2.0? I have to capture data from a php form and store in mysql database, and then export those data or generate a .dbf table. Thank´s a lot. Norma Ramirez

Re: [PHP-DB] export mysql table to .dbf

2003-07-21 Thread Norma Ramirez - TECNOSOFT
Thank´s Stephen, I gonna try it looks very useful... Norma Ramirez -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Norma Ramirez - TECNOSOFT
Check out this page:http://www.ros.co.nz/pdf/, is a useful class and you can implement with any kind of database. Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:01 AM Subject:

Re: [PHP-DB] Delete constraint

2003-07-09 Thread Norma Ramirez - TECNOSOFT
Thank´s a lot Pascal, it works just fine and all those links have very useful information. =) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Delete constraint

2003-07-08 Thread Norma Ramirez - TECNOSOFT
Hi all, coul I delete a constraint made over a postgresql table? (In the parent table). The child doesn`t have records. By the way, does any one know a good postgresql administrator like mysqladmin?? Thank´s Norma Ramirez

[PHP-DB] ODBC conection with DB2

2003-06-17 Thread Norma Ramirez - TECNOSOFT
Hi, I need to do a ODBC conexión with DB2 over AS400 for a php aplication, my aplication is in a web server wiht linux red hat 7.0, I´ve already downloaded the unixODBC driver and the iSeriesODBC from IBM page, but when I run the installation command: rpm -ivh iSeriesODBC-5.1.0-0.xx..rpm.

[PHP-DB] Get last id in postgresql

2003-06-16 Thread Norma Ramirez - TECNOSOFT
Hi all, I´m starting with posgresql and i trying to use pg_last_oid to get the last id in a insert query, but this function returns me a big number like 21318 and bigger, but the table just have 3 or 4 records. Could some one help? Any ideas? This is the script i´m using $insert = insert into