[PHP-DB] DBM module

2001-10-19 Thread Pierre-Alain Joye
Hello, Currentlu testing the dbm functions (for a wrapper class), stopped with dbm. Configure does not recognize the dbm library (db-3.3.11). gdbm, db3 has been recognized. Wich library do I need to use the dbm function (with or without dba), any link ? thank's pa -- PHP Database Mailing

Re: [PHP-DB] How to write errorhandling??

2001-10-21 Thread Pierre-Alain Joye
Hello,  Warning: Cannot add header information - headers already sent by (output  started at  e:\projects\globosapiens\07_production\actual\account\include\user.php:256)  in e:\projects\globosapiens\07_production\actual\account\include\user.php  on line 260  Where is the problem??? I can't see

Re: [PHP-DB] Ms-Access to Mysql converter

2001-11-01 Thread Pierre-Alain Joye
On Thu, 1 Nov 2001 16:17:38 +0550 [EMAIL PROTECTED] wrote: Most of them availalbe in the downloads section of mysql.com : http://www.mysql.com/downloads/contrib.html Look at the sections clients, converter and using MySql with Other Products hth pa -- PHP Database Mailing List

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:27:20 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) pa -- PHP Database Mailing List

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 09:19:44 -0500 (EST) Joao Prado Maia [EMAIL PROTECTED] wrote: On Wed, 21 Nov 2001, Manuel Lemos wrote: If we fixed these problems and more, we could talk about having a unified API. Otherwise for the Oracle OCI_ASSOC, I would prefer not to change it for speed,

[PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
Well I strongly need thoses $15 000 $ so What is the purpose ? As a average php user/developper I don_t really care about the pure cross plateform/database issue but I do care about a standard, clean, secure (my- bugs-free) and easy way to use a database, and PEAR::BD + Thomas V Cox

Re: [PHP-DB] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
On Wed, 21 Nov 2001 16:14:04 +0100 (MET) Luc Saint-Elie [EMAIL PROTECTED] wrote: En réponse à Pierre-Alain Joye [EMAIL PROTECTED]: This definition defines more a common interface to connect to a db, execute queries, fetch the result and eventually gives errors reports ;). Somehow

Re: [PHP-DB] Re: [PEAR-DEV] Re: Common DB Abstraction Layer: Re: [PEAR-DEV] Adoption of Metabase

2001-11-21 Thread Pierre-Alain Joye
I probably used a bad choice of words. What I really meant was: What is the objective of PEAR::DB as a database abstraction library ? To abstract as much as possible like Metabase already does, or to provide a unified API to databases and leave the implementation related to database specific

Re: [PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP

2001-11-02 Thread Pierre-Alain Joye
that produce a gif and then calling that gif as part of the report. But I need to rotate this gif 90 degrees CW. Can I do that with PHP? Platform - W2K MySQL PHP 4.04 Let me clarify this. The app is written in PHP and I cannot find anything that references rotating an

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 10:46:38 - Dave Carrera [EMAIL PROTECTED] wrote: Hi All I am trying to count how many product names in my db have the same category id and then show it ie: Catid 1 Product 1 Catid 1 Product 2 Catid 2 Product 3 Catid 3 Product 4 Catid 3 Product 5 Result

Re: [PHP-DB] a Count() ?

2002-03-16 Thread Pierre-Alain Joye
On Sat, 16 Mar 2002 11:50:11 - DL Neil [EMAIL PROTECTED] wrote: Hi Dave, SELECT * FROM tblNm; SELECT * FROM tblNm GROUP BY Catid1; SELECT Catid1, count(*) FROM tblNm GROUP BY Catid1; As I said 'follow your instincts' and take it one step at a time: Code the simplest query first,

RE: [PHP-DB] Date problem

2002-05-12 Thread Pierre-Alain Joye
i get $postdate from my mysql database,the problem is that i want to increase that date by 6 months?? its stored in mysql as date field http://www.mysql.com/doc/D/a/Date_and_time_functions.html check DATE_ADD :) hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] foreach

2002-06-03 Thread Pierre-Alain Joye
On Mon, 3 Jun 2002 12:48:47 -0400 James Kupernik [EMAIL PROTECTED] wrote: and I'm getting this: Warning: Invalid argument supplied for foreach() Why is that? are you sure $cart is an array ? pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Differences between two mySQL Databases

2002-06-25 Thread Pierre-Alain Joye
On Tue, 25 Jun 2002 14:29:08 -0700 Michael Robbins [EMAIL PROTECTED] wrote: I'm looking for a utility that can compare two database structures and generate a SQL statement that will duplicate the differences. I'm using mySQL and I have both live and development databases. While working

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 Dib, Walid (MED, Stagiaire GEMS) [EMAIL PROTECTED] wrote: Hello, I downloaded the application PHPEd and DBG, I need débugger but I cannot bind the two applications is what somebody has an idea. Thank you in advance I did not use DBG on

Re: [PHP-DB] Form not working...

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 19:11:46 +1000 Adam Royle [EMAIL PROTECTED] wrote: What you said (Mike) is mostly correct, although the GetSQLValueString() function in Scott's code automatically puts the quotes around the values if the datatype definition of text is passed to the function. Adam the

Re: [PHP-DB] PHPed and DBG

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 10:41:26 +0200 Dib, Walid (MED, Stagiaire GEMS) [EMAIL PROTECTED] wrote: Hello, I downloaded the application PHPEd and DBG, I need débugger but I cannot bind the two applications is what somebody has an idea. Thank you in advance the link to the forum :

Re: [PHP-DB] Why do these values not match?

2002-06-26 Thread Pierre-Alain Joye
On Wed, 26 Jun 2002 06:52:14 -0700 (PDT) Manuel [EMAIL PROTECTED] wrote: Any idea why this problem does not manifest itself in Foxpro, Excel or Visual Basic? This problem happens also with VB. But later :), By example if you use decimal type, smallest non-zero number is

Re: [PHP-DB] OSCON: anybody interested in my Oracle talk?

2002-06-26 Thread Pierre-Alain Joye
Hello, I m sure I will not be in OSCON, but if there is a possibily for you to go to International PHP Conf, you will make certainly a very good session there, not lost your job and certainly see me ;)). International PHP Conference 2002 call for papers :

Re: [PHP-DB] Re: Unified DB Query function

2002-07-01 Thread Pierre-Alain Joye
On Mon, 01 Jul 2002 14:55:01 -0300 Manuel Lemos [EMAIL PROTECTED] wrote: Hello, On 07/01/2002 06:46 AM, Casey Allen Shobe wrote: I'm trying to write a unified database query function for an application I have which currently accesses data from both DB2 and Microsoft SQL from a Linux

Re: [PHP-DB] blob versus file

2002-07-01 Thread Pierre-Alain Joye
On Mon, 1 Jul 2002 14:17:53 +0200 andy [EMAIL PROTECTED] wrote: Hi there, I am wondering if anybody has experiance in saving images to blob in mysql. I do save images with 1 K and 4 KB to blob fields while I used to save them to file. It seams to me that this is much slower accessing the

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 2 Jul 2002 05:45:40 +0200 Andy [EMAIL PROTECTED] wrote: is the increase of the network traffic noticable? The query is pretty small just text. Do u really think this might increase the traffic? Try to heavely charge a DB with images inside it. Do the same without DB, that depends if

Re: [PHP-DB] blob versus file

2002-07-02 Thread Pierre-Alain Joye
On Tue, 02 Jul 2002 12:57:56 +0200 Michael Bretterklieber [EMAIL PROTECTED] wrote: Hi, one point that you should keeped in mind is, if you have a cluster of webservers connecting to the same db-server, then you have to mount the filesystems, where you store the images on all webservers.

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
On Wed, 17 Jul 2002 10:06:11 +0200 Ulf Wendel [EMAIL PROTECTED] wrote: Hi, are there some DAO pattern implementations available for PHP to query MySQL, Postgres and/or DB2? Which one do you preferr? What mean DAO ? It can be confused (dao, ado, ...). Did you try PEAR::DB_DataObject

Re: [PHP-DB] DAO implementations

2002-07-17 Thread Pierre-Alain Joye
Update your vacation message, we are the 17th :) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: PicoSQL!

2002-07-24 Thread Pierre-Alain Joye
On Thu, 25 Jul 2002 09:27:04 +0200 Pentothal [EMAIL PROTECTED] wrote: Last but not least: it distributed under GPL ! AFAIK, that may causes problems. We cannot link GPL with non GPLized codes. pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: Why not simply does the where clause like : for a whole month, here is july: WHERE YEAR(t_event_date)='2002' AND MONTH(t_event_date)='7' For a specific day, here the current day WHERE t_event_date=NOW() That means you

Re: [PHP-DB] Fw: Date Add

2002-08-04 Thread Pierre-Alain Joye
On Sun, 4 Aug 2002 17:42:17 +0200 Pierre-Alain Joye [EMAIL PROTECTED] wrote: On Sun, 4 Aug 2002 17:30:31 +0200 John Fishworld [EMAIL PROTECTED] wrote: For a specific day, here the current day WHERE DAYOFMONTH(t_event_date)=DAYOFMONTH(NOW()) AND MONTH(t_event_date)=MONTH(NOW()) if you store

Re: [PHP-DB] form validation question - regex not working

2002-08-21 Thread Pierre-Alain Joye
On Thu, 22 Aug 2002 03:10:02 +0800 Jason Wong [EMAIL PROTECTED] wrote: On Thursday 22 August 2002 02:54, [EMAIL PROTECTED] wrote: As you can see, the list address ([EMAIL PROTECTED]), and my address ([EMAIL PROTECTED]) would be treated as invalid. Not very clever is it? Well, anyway there

Re: [PHP-DB] how to display tree structure from database???

2002-08-27 Thread Pierre-Alain Joye
Hello, http://membres.lycos.fr/sqlpro/Tree/SQL_tree.htm provides a good way to store trees in a DB, docs are in french, nut sqlimages are universal. hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] form variables not beeing passed to next page

2002-08-30 Thread Pierre-Alain Joye
On Fri, 30 Aug 2002 12:09:22 +0200 simon [EMAIL PROTECTED] wrote: Worked fine in 4.06? Have I missed something? REGISTER_GLOBAL is set to OFF from 4.2.x, code should be: if(isset($_POST['sumbit'])) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Indepth Tutorial... need help.

2002-09-03 Thread Pierre-Alain Joye
On Tue, 03 Sep 2002 08:56:43 -0400 Matt Zur [EMAIL PROTECTED] wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: http://www.phpbuilder.com http://www.devshed.com http://www.devarticles.com Well, if you do not find something here :-)

Re: [PHP-DB] Using a variable as a variable name

2002-09-04 Thread Pierre-Alain Joye
hello, You can find syntax description in the documentation (variable variables section) $myvar1 = MYVAR1 CONTENT; $myvar2 = MYVAR2 CONTENT; $i = 0; $myvar = 'myvar'.++$i; echo \n; echo $$myvar; echo \n; $myvar = 'myvar'.++$i; echo \n; echo $$myvar; echo \n; can do it hth pa -- PHP

Re: [PHP-DB] Need help urgent!!

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 19:48:31 +0300 Thomas \omega\ Henning [EMAIL PROTECTED] wrote: I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from 1 php to the other how i fix it? Read the documentation, register_globals is SET to off by default.

Re: [PHP-DB] Valid IP

2002-09-26 Thread Pierre-Alain Joye
On Thu, 26 Sep 2002 11:39:40 -0500 Wilmar Perez [EMAIL PROTECTED] wrote: Hello guys I know this should be asked in another list but don't want to subcribe just for a simple question. I apologise in advance if that bothers anyone. I'm trying to check valid IPs that come from a form

Re: [PHP-DB] Register Globals Question

2002-09-30 Thread Pierre-Alain Joye
On Mon, 30 Sep 2002 18:41:13 -0400 MET [EMAIL PROTECTED] wrote: It is deprecated as it creates a massive security hole. For bad and horrible codes, php itself never got security holes with that :-). pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Getting POSTed values

2002-10-04 Thread Pierre-Alain Joye
On Fri, 04 Oct 2002 20:13:57 -0700 Shoulder to Shoulder Farm [EMAIL PROTECTED] wrote: Hi all, Sorry, but I REALLY don't want to subscribe to the PHP general list, it's so high volume, so here goes. --T How can I get values that were posted from a form to a PHP document turned into

Re: [PHP-DB] Variable won't be passed from HTTP address bar

2002-10-18 Thread Pierre-Alain Joye
On Fri, 18 Oct 2002 13:26:20 +0200 Michel Bakkenes - bakkenes.net [EMAIL PROTECTED] wrote: Ok.. I'm not a newbie I thought.. I do have experience with PHP, but I never suffered from this error. I used on my own redhat 8.0 server the following test-script: if($action==test){ echo Test;}

Re: [PHP-DB] Warning message

2002-11-07 Thread Pierre-Alain Joye
On Thu, 7 Nov 2002 13:37:49 -0500 Anderson, Jerrad [EMAIL PROTECTED] wrote: I'm using PHP on apache that's sitting on a Windows 2k server. When I don't define a variable i'm getting a warning message on the screen.. anyway to suppress these errors? Warning: Undefined variable:

Re: [PHP-DB] php oop books

2003-01-12 Thread Pierre-Alain Joye
On Sun, 12 Jan 2003 14:58:36 -0500 Michael Scappa [EMAIL PROTECTED] wrote: I know this is a bit off topic, can anyone recommend a good php / oop book? I've been through php.net's library and nothing really on there. Thanks I do Not a good book about OOphp, but a good site:

Re: [PHP-DB] Concatenate two strings

2003-01-15 Thread Pierre-Alain Joye
On Wed, 15 Jan 2003 14:47:59 - Bruno Pereira [EMAIL PROTECTED] wrote: How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 $valor=$valor1 . . $valor2; See http://www.php.net/manual/pt_BR/language.operators.string.php

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: No, this is not the problem. I did not test your code but a color channel start at 0 and finished at 255, corresponding to 256 possibilities. pierre -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 14:36:38 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: No, this is not the problem. $i and $j start from 0, anyway. The real problem, as I see it, is the following: I have a big loop, to create something like a checkerboard, but with 13 or so colors. If the loop

Re: [PHP-DB] Re: Images-weird!!

2003-02-02 Thread Pierre-Alain Joye
On Sun, 02 Feb 2003 15:29:44 -0800 (PST) Mihail Bota [EMAIL PROTECTED] wrote: Yeah, I had the idea with truecolor, but I do not have GD2 installed. I have to install it, first. Still, I do not understand! I only have 13 colors, why is allocating only 255? I am not using the indexes in the

Re: [PHP-DB] efficient next/prev page generation

2003-02-14 Thread Pierre-Alain Joye
Hello, See http://www.pearfr.org/docs/dbpager.php?lang=en, a tutorial about PEAR::DB_Pager, which paging datas, from a DB result or a simple array. It can help you to find a good method. hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On 12 Jun 2003 16:01:01 -0500 Cory Hicks [EMAIL PROTECTED] wrote: FAW, I would look at PEAR and then run, don't walkand get the DB_Pager It smokes anything else I have tried... little tutorial on: http://www.pearfr.org/index.php/en/article/db_pager hth pierre -- PHP

Re: [PHP-DB] PHP Paging

2003-06-12 Thread Pierre-Alain Joye
On Thu, 12 Jun 2003 16:45:00 -0500 Sallee, Helen [EMAIL PROTECTED] wrote: If you are on UNIX, you could just use a cgi script and use sendmail command. paging datas (Page 1 fo 3 1 2 3 ), not send a msg to a pager :) pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] MySQL editor

2003-06-19 Thread Pierre-Alain Joye
Hello, Not really the same purpose, but so powerfull :) http://www.fabforce.net/dbdesigner4/ pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
On Mon, 23 Jun 2003 10:33:59 -0300 Tim Winters [EMAIL PROTECTED] wrote: Interesting Pierre, Is this something you have ever used? I have tested it for a few weeks ago (and starting to translate the doc to fr ;). I use it in a current project. However be sure this is really something good and

Re: [PHP-DB] PDF Implementation

2003-07-17 Thread Pierre-Alain Joye
On Thu, 17 Jul 2003 09:01:53 -0500 [EMAIL PROTECTED] wrote: Good Morning All , Has anyone successfully implemented PDF functionality within their PHP / MySQL projects? My needs are very basic, so I'd like to use something like ezPDF creation to avoid buying a license. But I haven't