[PHP-DB] Oracle client on linux

2002-01-25 Thread aiQa
Hi, I think I have to install oracle client on my RedHat7.2 to connect a Oracle8i windows2000 server. Is it right? aiQa

[PHP-DB] table overheading

2002-01-25 Thread Everton Yoshitani
hello anyone know why ooverhead happen? some of my table are overheading where a run delete and updates queries. --- Everton B Yoshitani [[EMAIL PROTECTED]] UF Communications, Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] Oracle client on linux

2002-01-25 Thread Helge A. Kraenz (FF)
Yeah. Without client no libraries for PHP (or other clients). Helge -Original Message- From: aiQa [mailto:[EMAIL PROTECTED]] Sent: Freitag, 25. Januar 2002 09:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle client on linux Hi, I think I have to install oracle client on my

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE:[PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Stig S. Bakken
On Tue, 2002-01-22 at 22:17, Alex Black wrote: Template classes are also foundation components of modern applications. They are certainly important, but they do not prevent interoperability in the same way that different database abstraction packages do. application, using APIs that

[PHP-DB] Re: [PEAR-DEV] Re: [binarycloud-dev] Re: [PEAR-DEV] Re:[metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Stig S. Bakken
On Tue, 2002-01-22 at 22:24, Björn Schotte wrote: * Alex Black wrote: Of course, but no one forces you to do that. I, as a developer, can choose if I want to use PEAR::Metabase in my application or PEAR::DB. Yes, which is not a good idea. If you're tying to get people to use a common

Re: [PHP-DB] Oracle client on linux

2002-01-25 Thread aiQa
Hi, ..and Has anyone installed oracle 8i client on linux? When I start ./runInstaller, It says that it installs x.jde and hangs. Thanks, aiQa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] Re: [PEAR-DEV] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Björn Schotte
* Stig S. Bakken wrote: this effort. I don't understand why this is an issue for you, could you explain? I already explained it several times. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] problem with LOAD DATA INFILE for date format

2002-01-25 Thread DL Neil
Hi Hendra An alternative would be to:- 1 LOAD DATA the table, but format each date field as a string. 2 add a date column 3 use UPDATE to convert/re-format the data from the string to date field 4 remove the string column This solution does not require you to tackle another tool and face the

[PHP-DB] Oracle Database procedures

2002-01-25 Thread Sridhar Moparthy
Hi All, Could you please help me on how to call Oracle stored procedures from PHP4.X. Also how to get the returned data in PHP from Oracle stored procedure? Thanks In advance. Sridhar Moparthy. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] Oracle client on linux

2002-01-25 Thread Anthony Carlos
There's a bunch of requirements that have to be met in order for the software installer to work. In case you're installing onto a remote machine, do you have XWindows running on your Linux machine? Does your terminal program support XWindows? From: aiQa [EMAIL PROTECTED] Date: Fri, 25 Jan 2002

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Take a look at this documentation from Thies Arntzen. It's required reading for anyone using Oracle and PHP! I hope it gets you started. If not, ask for more help! Good luck, Anthony Carlos PS: It shows how to bind PHP variables to Oracle variables... From: Sridhar Moparthy [EMAIL

Re: [PHP-DB] Oracle Database procedures

2002-01-25 Thread Anthony Carlos
Sridhar, Sorry, it's available at: http://conf.php.net/pres/index.php?p=slides%2Fociid=oci2 Good luck! --Anthony From: Anthony Carlos [EMAIL PROTECTED] Date: Fri, 25 Jan 2002 09:50:26 -0500 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Oracle Database procedures Sridhar, Take a look

RE: [PHP-DB] Another dynamic sql.

2002-01-25 Thread Gurhan Ozen
Seems like it will NOT work because you are selecting $car which is already chosen by the user (i.e. which is a known value). I don't know how you laid out your table but shouldn't your query be something like SELECT price from FROM varetabell where carid=$car ?? Gurhan -Original

Re: [PHP-DB] Another dynamic sql.

2002-01-25 Thread Raymond Lilleødegård
My example was a litle confusing here I see. My table have multiple price columns. something like this: carid convertible stationvagon etc. etc 1100100100 - Original Message - From: Gurhan Ozen [EMAIL PROTECTED]

[PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Kevin Won
I'm having a problem with varchar fields out of mssql which are only returning value lenghts = 256 characters. I know that the php.ini setting in mssql for textlength must be set to get more than 4096 chars, I've set this value higer and my TEXT types return correctly, but my varchar

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
Hello!!! What is the Length of the varchar field, in your database??? Dan On Friday, January 25, 2002, at 01:22 PM, [EMAIL PROTECTED] wrote: I'm having a problem with varchar fields out of mssql which are only returning value lenghts = 256 characters. I know that the php.ini setting

Re: [PHP-DB] Another dynamic sql.

2002-01-25 Thread Richard Crawford
Raymond, What sort of error are you getting? One of the most useful tools in your toolbox is the print() function. Try doing something like this: $sSQL = SELECT '$car' FROM varetabell WHERE carid='$carid'; print ($sSQL); $sql = mysql_query($sSQL); $myrow = mysql_fetch_array($sql); $x =

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Dan Brunner
If you need something that big Use a TEXT type instead. Dan On Friday, January 25, 2002, at 01:35 PM, [EMAIL PROTECTED] wrote: thanks for your reply. It's 5000. Kevin Won - ITG Web Developer, Systems Administrator

[PHP-DB] fwrite()

2002-01-25 Thread James Kupernik
I'm trying to take the contents of a table and write them to a file on my server. Everything seems to function ok (AKA no errors) but no file gets written ... I can't figure out why. Can anyone shine some light on this dark problem? $db = mysql_connect(localhost,cloft,spring);

Re: [PHP-DB] fwrite()

2002-01-25 Thread daniel
I'm trying to take the contents of a table and write them to a file on my server. Everything seems to function ok (AKA no errors) but no file gets written ... I can't figure out why. Can anyone shine some light on this dark problem? $db = mysql_connect(localhost,cloft,spring);

RE: [PHP-DB] fwrite()

2002-01-25 Thread Gurhan Ozen
You don't have anything to write to the file.. mysql_query() function returns true or false, it doesn't return the actual qurey result you'd see in mysql monitor. You have to use some other functions such as mysql_fetch_array(), mysql_num_rows() to retrieve the data before you can write it into a

[PHP-DB] Off: greatbridge.org

2002-01-25 Thread Jancs
Hi there! Does someone know what happened with this company? They had a nice php tool for postgres database management... now all sites are down Janis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] fwrite()

2002-01-25 Thread James Kupernik
Still when I make the changes suggested the file will not be created, yet I get no form of an error message. Is there something else I'm missing? I'm trying to take the contents of a table and write them to a file on my server. Everything seems to function ok (AKA no errors) but no file gets

Re: [PHP-DB] fwrite()

2002-01-25 Thread daniel
Still when I make the changes suggested the file will not be created, yet I get no form of an error message. Is there something else I'm missing? Please post your new code for review. Daniel J. Lashua -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] fwrite()

2002-01-25 Thread Jamie Kupernik
$prefilename = date(m-d-y); $filename = $prefilename.txt; $db = mysql_connect(localhost,cloft,spring); mysql_select_db(countryloft); // get requests from table $result = mysql_query(SELECT * FROM catalogreq WHERE PROCESSED IS NULL);

RE: [PHP-DB] Off: greatbridge.org

2002-01-25 Thread Matt Stone
I think they ran out of funding - try www.sourceforge.com , search for postgresql admin you will find it there - plus a few others. - Matt. -Original Message- From: Jancs [mailto:[EMAIL PROTECTED]] Sent: 25 January 2002 21:15 To: [EMAIL PROTECTED] Subject: [PHP-DB] Off: greatbridge.org

Re: [PHP-DB] dynamic sql

2002-01-25 Thread Miles Thompson
Michael, Yes. Just go ahead, and echo $sql to see what you have. You can build quite complex queries this way, dependent upon input from picklists, checkboxes, etc., adding and dropping conditions according to whether or not they have been selected/set. So why not $sql = UPDATE $fieldlist

Re: [PHP-DB] fwrite()

2002-01-25 Thread daniel
$prefilename = date(m-d-y); $filename = $prefilename.txt; $db = mysql_connect(localhost,cloft,spring); mysql_select_db(countryloft); // get requests from table $result = mysql_query(SELECT * FROM catalogreq WHERE PROCESSED

RE: [PHP-DB] fwrite()

2002-01-25 Thread Gurhan Ozen
Jamie, The main problem here is , you are selecting the rows that are some null values. mysql_fetch* doesn't return any null columns. Yes, you read it right, if you have a table with say, 5 columns and if 3 columns in a row are null then you'll only have 2 columns that are not null . Make sure

Re: [PHP-DB] help! sqlserver only returns 256 from varchar types

2002-01-25 Thread Brian Bruns
which library are you using to connect to SQL Server? Is this php running on windows or are you trying from unix? On Fri, 25 Jan 2002, Kevin Won wrote: I'm having a problem with varchar fields out of mssql which are only returning value lenghts = 256 characters. I know that the

[PHP-DB] help plz

2002-01-25 Thread Shelly Wilds
hi yall, i've been searching for the command that prints back how long page took to process. i found the command that prints @mysql_rows_affected(). but i can't seem to find how i print out how long it took for page to be processed. any ideas? tx, shelly

[PHP-DB] Pictures+MySQL+PHP

2002-01-25 Thread K
Hello, last time I asked about inserting pictures into MySQL, but how can I do it (inserting into BLOB column, picutures) using PHP? After inserting it into table I would also like to select and display the picutre (I inserted before) using my Internet browser. Any suggestion how to do it

RE: [PHP-DB] Pictures+MySQL+PHP

2002-01-25 Thread Gurhan Ozen
Kamil, If getting info in your private email is making you so pleased maybe you shoudl never post any questions here, it is contradictory to the philisophy of the list. I have also asked about inserting / retrieving pictures in mysql database in past and I have received so many con replies that

Re: [PHP-DB] help! sqlserver only returns 256 from varchartypes

2002-01-25 Thread Kevin Won
It's php 4.0.6 on win2k/apache. kevin Brian Bruns [EMAIL PROTECTED] 01/25/02 02:19PM which library are you using to connect to SQL Server? Is this php running on windows or are you trying from unix? On Fri, 25 Jan 2002, Kevin Won wrote: I'm having a problem with varchar fields out of

Re: [PHP-DB] help! sqlserver only returns 256 from varchartypes

2002-01-25 Thread Kevin Won
It's php 4.0.6 on win2k/apache. kevin Brian Bruns [EMAIL PROTECTED] 01/25/02 02:19PM which library are you using to connect to SQL Server? Is this php running on windows or are you trying from unix? On Fri, 25 Jan 2002, Kevin Won wrote: I'm having a problem with varchar fields out of

[PHP-DB] Save generated page locally

2002-01-25 Thread Howard Picken
Hi guys I have a local server being used to generate page which are then uploaded as static pages to another server. I would like have the script call up the Windows save as dialog when a new page has generated so a folder on the local unit can be selected etc. I've been looking for an example

RE: [PHP-DB] Save generated page locally

2002-01-25 Thread Gurhan Ozen
Hi Howard, I didn't fully understand your question.. Wouldn't you rather have the server upload the file automatically without asking the user where to save it? You can do it by using PHP's FTP functions.. See: http://www.php.net/manual/en/ref.ftp.php Gurhan -Original Message- From:

RE: [PHP-DB] help plz

2002-01-25 Thread Gurhan Ozen
Hi Shelly, It is just the old trick. You can get the time at the beginning of the page and at the end of the page and just calculate the difference in between two. Since the default timeout value in PHP is 30secs. it will probably be a short timeperiod so you can probably you use time() function

[PHP-DB] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE:[PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Alex Black
I'm currently writing The PEAR Manifest, a document that clearly defines PEAR once and for all. I'll post the first draft on pear-dev here when it's done, but to answer your question, there has been talk about a core set of packages for a while. In the manifest these are called PFC (PHP

[PHP-DB] Re: [PEAR-DEV] Re: [binarycloud-dev] Re: [PEAR-DEV] Re: [metabase-dev] RE: [PEAR-DEV] New Metabase Aniversary release

2002-01-25 Thread Manuel Lemos
Hello, Björn Schotte wrote: * Stig S. Bakken wrote: this effort. I don't understand why this is an issue for you, could you explain? I already explained it several times. I understand your concern of this PEAR-DB x Metabase merger may open a precedent that will motivate others to

Re: [PHP-DB] Save generated page locally

2002-01-25 Thread olinux
Here's an article that may help: Dynamic generation of static webpages http://www.phpbuilder.com/columns/loris20010420.php3 I think what you are referring to would best be accomplished using a macro: You can download AutoMate 4.5 at downloads.com - it's a simple program olinux --- Howard

[PHP-DB] Re: Session limitations

2002-01-25 Thread Alan McFarlane
There is no limit AFAIK if you are using the default 'files' handling code for sessions, however if you're writing the session data to a database, there will be a limit depending on the type of field you use to store the data; i.e.: mysql text fields can store up to 64K Hayan Al Mamoun [EMAIL

Re: [PHP-DB] Pictures+MySQL+PHP

2002-01-25 Thread CK Raju
that I changed my mind. Gurhan OzenStoring images in the database is not a good idea , just store the path of Gurhan Ozenthe images in the database and keep your images in your hard disk... Gurhan Ozen Since everything is on hard-disk, I personally feel, the image can be stored anywhere.

[PHP-DB] Sum Columns

2002-01-25 Thread mike
Hello, I've been experimenting with adding decimal columns. From the mysql docs I got this SELECT sum(value) FROM pets; So I did this $result = mysql_query(SELECT sum(value) FROM pets,$db); $myrow = mysql_fetch_array($result); print $myrow[value]; I also tried

Re: [PHP-DB] Sum Columns

2002-01-25 Thread Paul DuBois
At 23:19 -0600 1/25/02, [EMAIL PROTECTED] wrote: Hello, I've been experimenting with adding decimal columns. From the mysql docs I got this SELECT sum(value) FROM pets; So I did this $result = mysql_query(SELECT sum(value) FROM pets,$db); $myrow =

Re: [PHP-DB] Sum Columns

2002-01-25 Thread Jason Wong
On Saturday 26 January 2002 13:19, [EMAIL PROTECTED] wrote: Hello, I've been experimenting with adding decimal columns. From the mysql docs I got this SELECT sum(value) FROM pets; So I did this $result = mysql_query(SELECT sum(value) FROM pets,$db); $myrow =