Re: [PHP-DB] Calculating daylight savings time

What I need to do is figure this out for more than one location at a time. I am displaying Sabbath times for several different cities around the world at once (New York, London, Paris, Jerusalem, Sydney) - i.e. a certain amount of time before sunset, different for each city and each city is in

[PHP-DB] Queries probably timing out

I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in another.. I think the queries are failing due to timeout on the server. The server is not dedicated to me and I may not be able to affect the timeout settings...though I'll ask my hosting company (Positive Internet). If

Re: [PHP-DB] Queries probably timing out

- Original Message - From: Dillon, John [EMAIL PROTECTED] To: PHP-DB List [EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:47 AM Subject: [PHP-DB] Queries probably timing out I'm doing queries on tables with 45,000 rows in one table and 1-2000 rows in

Re: [PHP-DB] problems compiling with-informix

I run Informix (SE7.25.UC4 - UC5 had a major bug) on RH8.0. It wouldn't run on RH9.0 because of the glibc 2.3.x conflict. I beleive Informix only supports glibc 2.2.x. at the moment. If it's possible, use RH8.0 as I know it works. - Paul - - Original Message - From: [EMAIL PROTECTED]

Re: [PHP-DB] Mcrosoft SQL Server and for xml auto queries

The win32 version of the mssql extension does not support the FOR XML clause because it sends the results using ntext, which is the new UNICODE text type introduced in SQL Server 7.0. The mssql extension was built with DB-Library, which cannot read ntext fields. DB-Library is obsolete, and

Re: [PHP-DB] Queries probably timing out

What leads you to believe that it's a query timeout? Is the php script timing out waiting for the database? Do you get an error saying something about Max Execution Time? If so, you may want to set that higher in your script. Go check out:

Re: [PHP-DB] Calculating daylight savings time

Here's the example code I was talking about in the docs, you should really read the user submitted notes in the docs, they're very helpful, moreso than the docs from time to time. (this is not my code..) leafrink at hotmail dot com 28-Feb-2003 07:26 Wrote this function after a fair bit of

[PHP-DB] Returning Results

OK, I'll apologize in advance if this is a little off topic, but I think it'll be close enough. I have a form (searchform.php) that collects data for a search (e.g., firstname, lastname). That form submits to a separate PHP script (search.php) that queries a database to find matching rows and

RE: [PHP-DB] Returning Results

Hi Richard, When you submit the form, why not have a hidden field in the form like: input type=hidden name=backtopage value=?php echo $_SERVER['PHP_SELF']; ? Then use that 'backtopage' variable in your script where you direct the results to. Or.. if you don't want to use a hidden field.. parse

[PHP-DB] Problems with input and modify data on a form.

I have a problem with some programs, I am using 4 frames, 3 of them are for input data, the top frame is using for input information (right now only alow show existing information), in the middle frame appear information and with the bottom frame it's possible navigate through the records, I

RE: [PHP-DB] Returning Results

Thanks for the response, Aaron. But my problem isn't finding out who the referrer was. My problem is how to get the results of the database query back to the referrer without using any html. I think I need to get it into the request somehow. I'm probably making things wy more difficult than

RE: [PHP-DB] Queries probably timing out

I set set_time_limit (10*60); high up. Error message: Lost connection to MySQL server during query Query is: $query=CREATE TABLE IF NOT EXISTS $tbl1 SELECT TestData1.Year, TestData1.Period,TestData1.Co,TestData1.Acct,TestData1.Dept,TestData1.Descri ption,TestData1.Net,TestData1.Net*.175 AS

[PHP-DB] IBM DB2 PHP 4.3.2 behaviour

For the most part, I got my code running with IBM DB2 8.1.3 But its slower than dirt. Maybe 1 out of 10 times, a page would exceed the 30 second time limit. I understand on a fresh database startup, it takes time to get things together to run. But sometimes it would seem like its going fast,

[PHP-DB] Programs

begin 666 formfill.zip M4$L#!!0(`-*!R\H$P'/[EMAIL PROTECTED]0!```49F]R;69I;PO86-E'1A MBYG:69S]W2SL$PT8^!E.,+ \/___R^7.SZ=;7A_K/SM_OQ7.]*;6YXNJG^ MQ:XIZM'R_Q?3#7Y=XTF]O]QC[M*\U*EVIEKI4J7Q1/!\+N9-(9_C$P, M('B3Q96$091!AT0!V0G`^M#A0*7D,QY:O6K94;=BHQ'CI7L#%.RL=ETUN

RE: [PHP-DB] IBM DB2 PHP 4.3.2 behaviour

Gerard Samuel mailto:[EMAIL PROTECTED] wrote on Tuesday, August 19, 2003 2:32 PM: I understand on a fresh database startup, it takes time to get things together to run. But sometimes it would seem like its going fast, then othertimes, crawl slower than snails. I've found that, with an

Re: [PHP-DB] Queries probably timing out

IF it's a linux server apparently there's a glibc problem from a while back that causes this. Check to see if it's a redhat server. If that's the case, all you can do is get your host to upgrade. Or host your own server. It's starting to sound like a OS issue after searching around on google.

[PHP-DB] Re: Problems with input and modify data on a form.

begin 666 empresa01.zip M4$L#!!0([EMAIL PROTECTED]'[EMAIL PROTECTED]F5S83 Q+G-Q;.1= MZ8[-K;^;R#O02 :QMHE[4O,[EMAIL PROTECTED])+Q;8D*I143A2'KLGEP#7H)V.\ \ M49[';W3/.:266FRW[P:T;I .591*4IWU.PN9O[#J7^U/Y;/-[8?W=RS_].YW MYJW'Q[]!?YEVP\?[_[*/,=9A[*]8*5X2,L?SZ[OH?UQ]O_LINWOU^_/Q

[PHP-DB] Re: Problems with input and modify data on a form.

begin 666 formfill.zip M4$L#!!0(`-*!R\H$P'/[EMAIL PROTECTED]0!```49F]R;69I;PO86-E'1A MBYG:69S]W2SL$PT8^!E.,+ \/___R^7.SZ=;7A_K/SM_OQ7.]*;6YXNJG^ MQ:XIZM'R_Q?3#7Y=XTF]O]QC[M*\U*EVIEKI4J7Q1/!\+N9-(9_C$P, M('B3Q96$091!AT0!V0G`^M#A0*7D,QY:O6K94;=BHQ'CI7L#%.RL=ETUN

[PHP-DB] sobig virus

Hi I have had 40+ virused emails to the address I use for this list. Possible they came from another source but this is the most likely. Please check your virus scanners are up to date - 2 day old Norton virus definitions did not pick it up. Thanks Peter -- PHP Database Mailing List

Re: [PHP-DB] IBM DB2 PHP 4.3.2 behaviour

Matt Schroebel wrote: Gerard Samuel mailto:[EMAIL PROTECTED] wrote on Tuesday, August 19, 2003 2:32 PM: understand on a fresh database startup, it takes time to get things together to run. But sometimes it would seem like its going fast, then othertimes, crawl slower than snails. I've found

RE: [PHP-DB] [SPAM?] [PHP-DB] Re: That movie

Actually, the attached message was sent from a computer infected with a virus. There is an unusually high number of messages that fit symantec's description of some worms out there today. My best guess is it is one of these two worms.

Re: [PHP-DB] Query runs fine on Console but not in PHP

Thanks for your response. My script is running on Linux. I am trying to retrieve simple data such as text and numbers. I am not sure what the TDS protocol setting should be. What are the typical settings and how can I check it? Would appreciate any tips for debugging. Thanks. - Original

[PHP-DB] Re: That movie

Please see the attached file for details. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] [SPAM?] [PHP-DB] Re: That movie

This mail is probably spam. The original message has been attached along with this report, so you can recognize or block similar unwanted mail in future. See http://spamassassin.org/tag/ for more details. Content preview: Please see the attached file for details. -- PHP Database Mailing List