Hi,
I think I have to install oracle client on my RedHat7.2 to connect a Oracle8i
windows2000 server. Is it right?
aiQa
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
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
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
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
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
* 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
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
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
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
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
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
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
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]
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
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
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 =
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
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);
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);
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
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
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
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
$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);
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
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
$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
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
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
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
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
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
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
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:
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
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
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
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
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
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.
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
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 =
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 =
44 matches
Mail list logo
