php-windows Digest 8 Feb 2001 23:27:46 -0000 Issue 435

Thu, 08 Feb 2001 15:14:22 -0800 


php-windows Digest 8 Feb 2001 23:27:46 -0000 Issue 435

Topics (messages 5459 through 5474):

Re: COUNT(*) fails in PHP3
        5459 by: Tom Mathews

Re: Slow response from Netscape
        5460 by: Tom Mathews
        5462 by: Art Spaziano
        5463 by: Lee Goddard

Re: Modules not loading
        5461 by: Tom Mathews
        5464 by: Erik Ableson
        5466 by: alain samoun
        5468 by: Erik Ableson
        5469 by: Piotr Fetras

Re: PHP is not stable under Windows platform...
        5465 by: Asendorf, John

MSSQL Functions Again
        5467 by: Toby Miller
        5474 by: Frank M. Kromann

test please ignore
        5470 by: aaron

php access query problem
        5471 by: aaron
        5473 by: Gonzalo Vera

Inserting Binary Data into MS Access 2000 DB
        5472 by: Randall Barber

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------


I run php4 on windows, linux and solaris with MySQL, MSSQL and Oracle 8i and the 
aggregate
functions seem to be fine. Same goes fro php3 on windows and linux with MySQL (except 
that the
aggregate functions are a bit limited here, so its not always worth bothering!).
Do you get an error message, either from php or you rdbms? Hard to tell what's wrong 
without a
bit more info.

Tom

Piotr Fetras wrote:

> hi all !
>
> I have problems while executing SQL with aggregation functions, even simple
>
> SELECT COUNT(*) FROM aTable
>
> stalls. It seems to be a problem in PHP3 itself since other odbc-based applications 
>run well.
> There is simple but stupid solution for this problem: add "group by" phrase:
>
> SELECT COUNT(*) FROM aTable GROUP BY 1
>
> and it goes on.
> Is it the same in PHP4 ???
>
> piofet
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]



Yep, but it may not be anything to do with the cookie - do you have any
JavaScript floating around on the same page? Netscape 4.x caches all script
that it finds before displaying the page (some people think its better this
way - once the page is up there are no delays, but in commercial situations
the user has usually buggered off by the time the page actually appears!).
You should also check that you don't have any open tags floating around
(like a <table> with no </table>, <select with no </select>.... as Netscapes
behaviour is a bit erratic with this kind of thing - sometimes it thinks
about it and then works, sometimes it thinks about it and then works badly,
sometimes it thinks about it and then ignores the whole section!

Tom

Doug Brewer wrote:

> I am experiencing a long delay from Netscape (4.76, Win) when setting
> cookies. The user submits the form, and it takes 15-20 seconds for a
> response. The browser states "host contacted, waiting for reply...."
>
> It works instantaneously with IE, and on a mac on both browsers.
> Anyone else experience this? Netscape 6 seems to work OK too.
>
> Doug Brewer
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]



I've seen this when the form uses METHOD=post and the browser is on the 
same machine
as the server.

Changing to the 'get' method will take care of it but I wish there were a 
better solution.
This problem only occurs on Windows.


Art


>From: "Doug Brewer" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Date: Wed, 7 Feb 2001 12:18:53 -0600
>Message-ID: <[EMAIL PROTECTED]>
>MIME-Version: 1.0
>Content-Type: text/plain;
>         charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>Subject: Slow response from Netscape
>
>
>I am experiencing a long delay from Netscape (4.76, Win) when setting
>cookies. The user submits the form, and it takes 15-20 seconds for a
>response. The browser states "host contacted, waiting for reply...."
>
>
>It works instantaneously with IE, and on a mac on both browsers.
>Anyone else experience this? Netscape 6 seems to work OK too.
>
>
>Doug Brewer


===========================================================
Art Spaziano                                                    Email: 
[EMAIL PROTECTED]
Product/Application Development                       Phone: (+1) 781 280 
4604
===========================================================
NuSphere MySQL - Seriously Open Software
===========================================================




You may find that the problem is not cookies but your JS caching, or
even HTML display: a table, for eg, will take a while to display
whilst its contents are loaded - you may find setting sizes explicitly
helps.

lee


Doug Brewer wrote:
> 
> I am experiencing a long delay from Netscape (4.76, Win) when setting
> cookies. The user submits the form, and it takes 15-20 seconds for a
> response. The browser states "host contacted, waiting for reply...."
> 
> It works instantaneously with IE, and on a mac on both browsers.
> Anyone else experience this? Netscape 6 seems to work OK too.
> 
> Doug Brewer



Had the same problem with LDAP and GD, but not with any of the others.
I tried copying stuff into different paths, but that didn't seem to help
either.
Eventually I gave up and just used the module instead of the CGI (faster
as well!)

Tom

Erik Ableson wrote:

>
>
> I'm seeing an interesting problem here - just installed the CGI
> version of php4 running under Win32 Apache and php is working, but
> when I try to call a module function it claims that it's an unknown
> function:
>
> Call to undefined function: ldap_connect() in d:\apps\apache
> group\apache\htdocs\test.php on line 7
>
> I've got the ldap.dll file in the extensions folder and I've dropped
> copies into Winnt and system folders just in case to no avail.
>
> Hints & tips always appreciated,
> Erik Ableson
>
>    ----------------------------------------------------------------
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>


Title: RE: [PHP-WIN] Modules not loading

It's the latest precompiled version and I've tried uncommenting them in the php.ini file which just results in it complaining that it can't find modules, and doesn't handle the .php files as text/html properly.  Running without the .ini file works fine for other modules, as far as I can tell, but not the ldap one.

Go figure...

Erik

>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 07, 2001 5:07 PM
>To: Erik Ableson; [EMAIL PROTECTED]
>Subject: Re: [PHP-WIN] Modules not loading
>
>
>Where did you get your build?
>The modules have to be integrated at compilation time.
>It seems that the ldap module either is not part of your build
>or has not be
>activated in the php.ini file.
>Alain
>
>On Wed, Feb 07, 2001 at 03:38:50PM -0600, Erik Ableson wrote:
>> I'm seeing an interesting problem here - just installed the
>CGI version of
>> php4 running under Win32 Apache and php is working, but when
>I try to call a
>> module function it claims that it's an unknown function:
>>
>> Call to undefined function: ldap_connect() in d:\apps\apache
>> group\apache\htdocs\test.php on line 7
>>
>> I've got the ldap.dll file in the extensions folder and I've
>dropped copies
>> into Winnt and system folders just in case to no avail.
>>
>> Hints & tips always appreciated,
>> Erik Ableson
>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail:
>[EMAIL PROTECTED]
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail:
>[EMAIL PROTECTED]
>
> 



I wonder if you could have another php.ini somewhere in your system? Do
a find for php.ini and see the result.
Alain

> Erik Ableson wrote:
> 
> It's the latest precompiled version and I've tried uncommenting them
> in the php.ini file which just results in it complaining that it can't
> find modules, and doesn't handle the .php files as text/html
> properly.  Running without the .ini file works fine for other modules,
> as far as I can tell, but not the ldap one.
> 
> Go figure...
> 
> Erik
> 
> >-----Original Message-----
> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, February 07, 2001 5:07 PM
> >To: Erik Ableson; [EMAIL PROTECTED]
> >Subject: Re: [PHP-WIN] Modules not loading
> >
> >
> >Where did you get your build?
> >The modules have to be integrated at compilation time.
> >It seems that the ldap module either is not part of your build
> >or has not be
> >activated in the php.ini file.
> >Alain
> >
> >On Wed, Feb 07, 2001 at 03:38:50PM -0600, Erik Ableson wrote:
> >> I'm seeing an interesting problem here - just installed the
> >CGI version of
> >> php4 running under Win32 Apache and php is working, but when
> >I try to call a
> >> module function it claims that it's an unknown function:
> >>
> >> Call to undefined function: ldap_connect() in d:\apps\apache
> >> group\apache\htdocs\test.php on line 7
> >>
> >> I've got the ldap.dll file in the extensions folder and I've
> >dropped copies
> >> into Winnt and system folders just in case to no avail.
> >>
> >> Hints & tips always appreciated,
> >> Erik Ableson
> >
> >> --
> >> PHP Windows Mailing List (http://www.php.net/)
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >> To contact the list administrators, e-mail:
> >[EMAIL PROTECTED]
> >
> >--
> >PHP Windows Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail:
> >[EMAIL PROTECTED]
> >
> >
> 
>     ---------------------------------------------------------------
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]


Title: RE: [PHP-WIN] Modules not loading

Well - finally got it to work by using the apache module rather than the cgi and by dropping the dll's into the Winnt directory...

>-----Original Message-----
>From: "alain"@samoun.com [mailto:"alain"@samoun.com]
>Sent: Thursday, February 08, 2001 11:25 AM
>To: Erik Ableson
>Cc: [EMAIL PROTECTED]
>Subject: Re: [PHP-WIN] Modules not loading
>
>
>I wonder if you could have another php.ini somewhere in your system? Do
>a find for php.ini and see the result.
>Alain
>
>> Erik Ableson wrote:
>>
>> It's the latest precompiled version and I've tried uncommenting them
>> in the php.ini file which just results in it complaining
>that it can't
>> find modules, and doesn't handle the .php files as text/html
>> properly.  Running without the .ini file works fine for
>other modules,
>> as far as I can tell, but not the ldap one.
>>
>> Go figure...
>>
>> Erik
>>
>> >-----Original Message-----
>> >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>> >Sent: Wednesday, February 07, 2001 5:07 PM
>> >To: Erik Ableson; [EMAIL PROTECTED]
>> >Subject: Re: [PHP-WIN] Modules not loading
>> >
>> >
>> >Where did you get your build?
>> >The modules have to be integrated at compilation time.
>> >It seems that the ldap module either is not part of your build
>> >or has not be
>> >activated in the php.ini file.
>> >Alain
>> >
>> >On Wed, Feb 07, 2001 at 03:38:50PM -0600, Erik Ableson wrote:
>> >> I'm seeing an interesting problem here - just installed the
>> >CGI version of
>> >> php4 running under Win32 Apache and php is working, but when
>> >I try to call a
>> >> module function it claims that it's an unknown function:
>> >>
>> >> Call to undefined function: ldap_connect() in d:\apps\apache
>> >> group\apache\htdocs\test.php on line 7
>> >>
>> >> I've got the ldap.dll file in the extensions folder and I've
>> >dropped copies
>> >> into Winnt and system folders just in case to no avail.
>> >>
>> >> Hints & tips always appreciated,
>> >> Erik Ableson
>> >
>> >> --
>> >> PHP Windows Mailing List (http://www.php.net/)
>> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >> For additional commands, e-mail: [EMAIL PROTECTED]
>> >> To contact the list administrators, e-mail:
>> >[EMAIL PROTECTED]
>> >
>> >--
>> >PHP Windows Mailing List (http://www.php.net/)
>> >To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >For additional commands, e-mail: [EMAIL PROTECTED]
>> >To contact the list administrators, e-mail:
>> >[EMAIL PROTECTED]
>> >
>> >
>>
>>     ---------------------------------------------------------------
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> To contact the list administrators, e-mail:
>> [EMAIL PROTECTED]
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail:
>[EMAIL PROTECTED]
>
> 



yeah,
i have similiar problems, really annoying and time consuming
gd works with php3 (dynamically loaded by ld function) but ldap fails 

also odbc behave odd: it must be comment in php.ini dll's section to work ! - older I 
am less I undestand ...

piotr

>>> Erik Ableson <[EMAIL PROTECTED]> 02/07/01 10:38pm >>>
I'm seeing an interesting problem here - just installed the CGI version of
php4 running under Win32 Apache and php is working, but when I try to call a
module function it claims that it's an unknown function:

Call to undefined function: ldap_connect() in d:\apps\apache
group\apache\htdocs\test.php on line 7

I've got the ldap.dll file in the extensions folder and I've dropped copies
into Winnt and system folders just in case to no avail.

Hints & tips always appreciated,
Erik Ableson




I haven't had really good luck with the ISAPI module.  My suggestion would
be to learn C and fix the source code for us  :)  or wait patiently for a
more stable version of the ISAPI module to come out.

---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631

The benefit to the government of replacing all $1 Federal Reserve notes with
$1 coins would be $522.2 million per year, according to estimates of the
General Accouting Office released on April 7, 2000.


> -----Original Message-----
> From: sam [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 08, 2001 4:14 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] PHP is not stable under Windows platform...
> 
> 
> Hi,
> 
>     My problem is that I have installed the PHP under win2k, and it
> seems
> OK, but when I use a lot of sockets, it may cause system halt 
> !!  But it
> will
> not happen when I use CGI mode to run PHP by IIS. Maybe some thing
> wrong when I install PHP, if you have ever met such problem, 
> please tell
> 
> me how to solve this problem, thanks !!
> 
> ps.I'm sure that ISAPI mode can run faster, so I don't like to use CGI
> mode.
> 
> Sam.
> 
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 



Hey all,

Actually, Frank might know this, but I was wondering if anyone is using the MSSQL 
functions on Win2000 instead of NT. If so, are you using an installation of MSSQL 
Server to allow your MSSQL functions to work or did you just copy the DLL's (like 
Frank suggested in my earlier post). I might have to move one of our sites to Win2000 
from WinNT and wondered if there are any known conflicts I should try to prepare for.

Thanks,
Toby




Hi Toby,

Ther is no difference in how MSSQL Server works on NT or Windows 2000. That goes for 
both Client and server tools.

You should be able to do the same trick (copying ntwdblib.dll to winnt\system32) on a 
Windows 2000 maschine.

You will get IIS5 on Windows 2000 where yoy have IIS4 on NT. IIS is in my opinion much 
more stable !

- Frank

>Hey all,
>
>Actually, Frank might know this, but I was wondering if anyone is using the MSSQL 
>functions on Win2000 instead of NT. If so, are you using an installation of MSSQL 
>Server to allow your MSSQL functions to work or did you just copy the DLL's (like 
>Frank suggested in my earlier post). I might have to move one of our sites to Win2000 
>from WinNT and wondered if there are any known conflicts I should try to prepare for.
>
>Thanks,
>Toby
>
>






test





I have the query
$cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
Equipment01 WHERE Location = '415C'");

which returns the proper results but when I add  AND 'Equip Type' = 'C' to
the end of it I get no results.  Is my syntax correct?  Thanks, Aaron

$cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
Equipment01 WHERE Location = '415C' AND 'Equip Type' = 'C'");






What DB are you using?

 Gonzalo.

> I have the query
> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
> Equipment01 WHERE Location = '415C'");

> which returns the proper results but when I add  AND 'Equip Type' = 'C' to
> the end of it I get no results.  Is my syntax correct?  Thanks, Aaron

> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
> Equipment01 WHERE Location = '415C' AND 'Equip Type' = 'C'");





I have spent the last week trying to figure this out.

At home:  Win2k Pro.  IIS Running.  Access 2000.  
Table:       NAME text
                PIC     OLE Insert

PHP Code---------------------This works at home

<?php
$dbConn = odbc_connect("MYDB","","");
$b_pic = addslashes( fread( fopen($userPicFile, "r"), filesize($userPicFile)));
$insQry = "INSERT INTO MyTable (NAME,PIC) VALUES ('$name','$b_pic')";
odbc_exec($dbConn, $insQry);
?>

--------------------------------------

At work: WinNT 4.0. Running IIS. Access 2000.
Table:    FIRST text
            LAST text
            PIC   OLE Insert

PHP Code------------------------This returns an error

<?php
$dbConn = odbc_connect("MYDB","","");
$b_pic = addslashes( fread( fopen($userPicFile, "r"), filesize($userPicFile)));
$insQry = "INSERT INTO MyTable (FIRST,LAST,PIC) VALUES 
('$firstName','$lastName','$b_pic')";
odbc_exec($dbConn, $insQry);
?>

------------------------------------------
The error (it is always this error when the binary data is part of the string):

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect , 
SQL state 07001 in SQLExecDirect in c:\inetpub\wwwroot\mailjob-upload.php on line 6

This is the same code with one extra field.  At work if I make it the same as my 
databse at home, it still generates this error.
The database is being accessed via a SystemDSN Microsoft Access Driver (*.mdb).  No 
user, no password.

I've done a search on the net for SQL 07001 and found NOTHING useful.
If I eliminate ALL the binary variables (like $b_pic) the query works.  I.e. INSERT 
INTO MyTable (FIRST,LAST) VALUES ('$firstName','$lastName');

I have a database that has 30 elements to insert, of which, 6 are binary fields 
(files).
Thanks in advance.
Randall Barber

P.S. - I even used Access Qry builder and cut/paste the statement into the script.  No 
go.  I can print the string (after substitution) and everything looks ok.  All special 
characters are escaped (i.e.  \').

Reply via email to