[PHP-WIN] Re: ODBC - What Perl can and PHP not

2005-05-13 Thread John Lim
Sounds like a permissions problem. Your web server's userid must have access to the required odbc driver files. "Markus Tacker" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hoi all, > > I am a bit curious about that issue. > I have a ODBC datasource with an AcuODBC driver.

[PHP-WIN] Re: include_path and relative vs. absolute paths

2004-08-17 Thread John Lim
Good question. I had the same problem when i switched from .asp to .php Suppose you want to use relative paths, eg. reference child1.php from file1.php, where the file locations are: path/file1.php path/child/child1.php The trick is to generate an absolute path for the current file, and find

[PHP-WIN] Re: COM function

2004-06-23 Thread John Lim
Sorry, Linux does not support COM. "Heekw" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > I couldn't run the com progam on my server but everthing well on my pc. > The only different is server is using UNIX version while pc is Window > version. > It game me error like this -

[PHP-WIN] ADOdb db abstraction library moved to sourceforge

2004-06-15 Thread John Lim
important news http://lists.sourceforge.net/lists/listinfo/adodb-news adodb-general: for general postings http://lists.sourceforge.net/lists/listinfo/adodb-general Bugs should still be reported at the existing forums at http://phplens.com/lens/lensforum/topics.php?id=4 Thank you. John Lim -- PHP

[PHP-WIN] Re: Question about PHP on Win2k Advanced Server

2004-04-16 Thread John Lim
Hi, FastCGI provides the best reliability on Windows. It's as close to 99.99% as you can get. Zend has a commercial windows enabler built on FastCGI at http://zend.com There is also a free FastCGI installer at http://php.weblogs.com/easywindows which i wrote. Regards, John "Anthony M. Saffer"

[PHP-WIN] Re: AdoDB error

2004-03-30 Thread John Lim
Hi This is due to internal changes in spl extension from PHP5 b4 to PHP5 rc1. This problem was fixed in adodb 4.21. Download from http://php.weblogs.com/adodb "Bruno Reato" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi!! i'm newbie in PHP's world and i trying execute a simple

Re: [PHP-WIN] Character Problem

2004-02-25 Thread John Lim
The most elegant way is probably: "Meteorlet Woody" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > I got it. > > for ( $i = 0; $i <= 255; $i++ ) > { > $Dictionary[] = sprintf("%c",$i); > } > ?> > > === 2004-02-25 18:00:06 === > > >Hi,everyone! > > > > When I want to cre

Re: [PHP-WIN] fastcgi on windows standalone

2004-01-26 Thread John Lim
Hi, for PHP 4.3.x info with FastCGI, have a look at http://php.weblogs.com/fastcgi_with_php_and_iis PS: Shane's instructions work with 4.3.x also, if you read carefully. "Richard Stupek" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Unfortunately that only applies for PHP 4.2 an

[PHP-WIN] Re: php4isapi.dll causes instability in memory

2004-01-18 Thread John Lim
Hi, I can feel your pain. I had this problem too. The only high performance stable solution for IIS that i know is FastCGI. See http://php.weblogs.com/fastcgi_with_php_and_iis John Lim "Brian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > PHP 4.3.4 Wi

Re: [PHP-WIN] Using the installshield vs manually

2003-06-17 Thread John Lim
e and keep a > Windows box secure :) With the latest windows update patch system from Microsoft, security is not as big an issue as it used to be. In fact, if you look at IIS 6.0, you will see that it has improved a lot, taking some of the best ideas of Apache... Bye, John Lim PS: Daniel,

[PHP-WIN] Re: IIS 6 PHP issue?

2003-06-10 Thread John Lim
Hi, As far as i have tested, PHP works fine in FastCGI mode with IIS6, Win2003. This is probably a better and more reliable option that ISAPI. See http://php.weblogs.com/fastcgi_with_php_and_iis - Original Message - From: "Bob Rathke Jr." <[EMAIL PROTECTED]> Newsgroups: php.windows To: <

[PHP-WIN] Re: Not rhetorical: Why upgrade php when current version is working fine?

2003-03-07 Thread John Lim
Hi I think any version of PHP 4.0.6 is ok, provided you close all known security holes. I believe there are a few, you should check php.net for more info. Regards, John "Jim Beach" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I imagine there are some people with opinions on this l

[PHP-WIN] A Date and Time Library for all seasons

2003-01-25 Thread John Lim
Download: http://php.weblogs.com/adodb_date_time_library PHP native date functions use integer timestamps for computations. Because of this, dates are restricted to the years 1901-2038 on Unix and 1970-2038 on Windows due to integer overflow for dates beyond those years. This has been frustrating

[PHP-WIN] Re: Isapi Module

2002-11-07 Thread John Lim
Apparently the ISAPI module is quite stable. The problem is that not all extensions are thread-safe. That is why it works fine for some people and not for others. Make sure you do some testing yourself first. Regards, John "Charles P. Killmer" <[EMAIL PROTECTED]> wrote in message news:B141BE87473

Re: [PHP-WIN] Update 4.1.2 > 4.2 : MSSQL Error S1000 (Parallel Requests)

2002-04-23 Thread John Lim
I am having problems too. My ADOdb regression tests for msaccess/odbc and vfp/odbc fail every time. No data is being retrieved :-( Uggh. "Christoph Grottolo" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > "Lars Schwarz" <[EMAIL PROTECTED]> schrieb im New

[PHP-WIN] Re: Tutorials on stored procedures using SQL Server

2002-04-14 Thread John Lim
Try www.sqlteam.com "R.S. Herhuth" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Anyone know of any internet based tutorials on using stored procedures > with SQL Server? > > Thanks, > ROn -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe

[PHP-WIN] Re: ASP vs PHP

2002-03-30 Thread John Lim
Hello Ciro, For database access and automatic generation of forms, see http://phplens.com/ You can create search/edit/new record forms automatically through the web user interface with little coding. It also has a low level PHP interface for deep coding. This is a commercial product, developed by

Re: [PHP-WIN] PHP ide

2002-03-15 Thread John Lim
See http://php.weblogs.com/editors My favorite on windows is homesite. Craig Morrison <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Dan Zarrella wrote: > > > > I'm curious to see everyone's opion on php-ide's/editors, which one is the > > best, most comp

[PHP-WIN] Re: inserting date into oracle!!!

2002-02-21 Thread John Lim
INSERT into table (datecol) VALUES (TO_DATE('2002-02-30','-MM-DD')) or INSERT into table (datecol) VALUES (SYSDATE) Bye, John Nicole Amashta <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > OK, it has been a long while since I've used Oracle, but from wha

[PHP-WIN] Re: Compiling PHP code

2002-02-01 Thread John Lim
Visit http://zend.com They have an Encoder product that does this. Regards, John Nicole Amashta <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > OK, this may sound far fetched, or maybe not. By any chance would it be > possible to "compile" php code into some s

Re: [PHP-WIN] Re: Is ISAPI stable ?

2002-01-31 Thread John Lim
ED]... > > Hi there. When you say "bugs", what do you mean? When I have bugs in my > > code, it doesn't run, period. But if you mean "warnings" ? which will > > let your code run but there are some handling errors? Just trying to > > find out your t

Re: [PHP-WIN] Re: Is ISAPI stable ?

2002-01-31 Thread John Lim
mean "warnings" ? which will > let your code run but there are some handling errors? Just trying to > find out your terminology... > > Angie Tollerson > Alliance Technologies > Web Programmer > (515)245-7628 > [EMAIL PROTECTED] > > >>> "John Lim&qu

[PHP-WIN] Re: Is ISAPI stable ?

2002-01-30 Thread John Lim
Hi, PHP's ISAPI error handling is still not thread safe. If your code has no errors PHP will run fine. However if there are bugs in your PHP script, they are not handled properly and eventually your process will crash in ISAPI after repeated calls to the error-prone script. Regards, John Samue

Re: [PHP-WIN] Is ISAPI stable ?

2002-01-20 Thread John Lim
Hi I have found that there are bugs in the isapi version when you have errors in your PHP code. PHP 4.1.1 does not clean up properly at times and eventually will crash. If your PHP code has no errors you might find ISAPI to be reliable. I run test suites for the ADODB library with deliberate sc

Re: [PHP-WIN] API

2001-12-17 Thread John Lim
Hi Silverio, I think there has been some confusion about PHP. PHP.EXE is a compiler, not a library of code nor a callable DLL. So there is no callable API as such. Your question is as strange as asking how to call a C++ compiler's API. You pass a .cpp file to a C++ compiler. You pass a .php file

[PHP-WIN] Re: ISAPI Status

2001-12-14 Thread John Lim
I have also experienced crashes with PHP 4.1.0 and ISAPI when stress testing with ab (apachebench). I am still using CGI. I suspect the problems are deep in the code, and might not show up with simple tests. My test code is about 50K lines of PHP, which really stresses things up. Perhaps apache

Re: [PHP-WIN] PHP 4.1.0 Win32 Error

2001-12-13 Thread John Lim
Hi ! This is a bug in PHP 4.1.0 when using persistent connections in a CGI script. Turning off persistent connections or switching to ISAPI avoids this problem. I have reported it to bugs.php.net. -- John "Rygars" <[EMAIL PROTECTED]> wrote in message 002d01c183a7$3a002670$e39d5dd

[PHP-WIN] Re: Constructor functions

2001-12-08 Thread John Lim
Just set a class property instead of returning a value in your constructor. Constructors do not return values. Regards, John Bharath Bhushan Lohray <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > how do i get the values returned by the constructor function ? >

[PHP-WIN] Re: ADODB - FieldCount? Where is it????

2001-11-02 Thread John Lim
You probably have a syntax error in your SQL. To see why, set: $conn->debug = true; Errors in your SQL will cause $rs = $conn->Execute($sql) to return false to $rs, causing the problem. John Asendorf <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I'm gettin

[PHP-WIN] Re: Help, connection object in php

2001-10-29 Thread John Lim
Hi Aaron, You sound like an ASP convert to PHP. The answer is yes. You might like the adodb database library that works like ADO at http://php.weblogs.com/adodb Regards, John Aaron <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is is possible to set the con

[PHP-WIN] Re: How to use REST FTP command

2001-09-25 Thread John Lim
We are using the built-in ftp functions on W2K with PHP 4.0.6. Works fine. Is that what you require? See http://php.net/ftp Bye. John "Tomas Vasek" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hallo, > > is any possibility to use ftp commands (REST, RETR,

[PHP-WIN] Re: How to make a script run itself ?

2001-09-15 Thread John Lim
Check out the at command. It's available in Linux and Windows NT/2000. You can run a php script from the command line using php.exe -q [filename] "Steen rabøl" <[EMAIL PROTECTED]> wrote in message 004501c13de1$22f0d8f0$030a@srjhp">news:004501c13de1$22f0d8f0$030a@srjhp... Hi I need to p

[PHP-WIN] Re: MKDIR on Windows?

2001-09-09 Thread John Lim
The directory wwwroot is readonly to the webserver user. The fix is to change your file permissions. bye, john "Niels Ulrik Reinwald" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi, > > I have: > > > > mkdir("test", 0777); > > > > > which returns: > >

[PHP-WIN] Re: bug in class?

2001-09-09 Thread John Lim
Hi Alain, ADODB has more functions in a class and it doesn't crash as a CGI on Windows. Must be something else. Ciao, John "Alain Samoun" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a class with several functions, 20 at this time. If I add a new >

[PHP-WIN] Re: webserver root

2001-09-07 Thread John Lim
PHP 4.0.7 or 4.0.8 is going to fix this problem as it will search for files in the current directory. I forget which version. The patch is already in CVS. To find the document root, here's some code taken from http://phplens.com // Finds the DOCUMENT_ROOT - works with Apache, IIS and PWS functio

[PHP-WIN] Re: PHP hog on CPU resources

2001-09-02 Thread John Lim
Doesn't seem like its the CPU that's causing it to run slowly if it only hits 55%. You've got 45% of your CPU idling. Slowdowns are caused by some bottleneck hitting 100%. Look deeper into the problem (hard disk, database, etc) to find the bottleneck... Regards, John "Aaron Bolyes" <[EMAIL PRO

[PHP-WIN] Re: Having PHP inside of ASP using the #include VIRUTAL= directive??

2001-07-30 Thread John Lim
Hi Porting a counter program from PHP to ASP should be quite easy so why don't you do so? Regards, John "Elias" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I don't think you can get the file processed twice by the server. > It's either PHP or ASP. > > "K

[PHP-WIN] Re: Interbase/PHP/Apache implimentation

2001-07-14 Thread John Lim
Hi Jordan I have been trying to use interbase with the IIS sapi unsuccessfully (PHP 4.0.6). I suspect that it is not thread-safe as CGI works fine. It really is up to someone who can debug the php_ibase.dll source to fix this as it apparently not an apache specific problem. Regards, john "Jordan

Re: [PHP-WIN] Speed

2001-05-22 Thread John Lim
Aha, an ex-ASP programmer! I've heard that the stop and start is faster, but it really doesn't matter with PHP. In ASP its an issue because ASP does a context switch every time from HTML to the VBScript/JScript compiler. PHP doesn't do any context switches so there's no overhead to stop and start

Re: [PHP-WIN] Any good editor for PHP in Windows?

2001-05-20 Thread John Lim
Whoops, I just realised I posted to the wrong thread. Sorry for the confusion. If you want to see a list of editors for windows/linux, visit http://php.weblogs.com/editors "John Lim" <[EMAIL PROTECTED]> wrote in message 9e5mo7$nb2$[EMAIL PROTECTED]">news:9e5

Re: [PHP-WIN] Canceling a Query

2001-05-19 Thread John Lim
You mentioned that the results don't return many rows. So if you are using a lot of aggregate functions (max, min, etc), it's possible to precalculate them every night and join on the precalculated values. Much faster. I also believe there are data warehousing solutions that automatically precalc

Re: [PHP-WIN] MS Access + Linux + PHP

2001-05-19 Thread John Lim
The ADODB database library implements a similar solution to Tim's, but using HTTP as the transport layer, and a hybrid of CSV and the PHP serialize( ) function for the data. It's very complete as you can perform select/delete/insert/update and get the error messages from the windows server transp

Re: [PHP-WIN] Any good editor for PHP in Windows?

2001-05-19 Thread John Lim
Create a shortcut and run from the command-line: php.exe -q -q means suppress HTTP headers ""elias"" <[EMAIL PROTECTED]> wrote in message 9e57sk$9k$[EMAIL PROTECTED]">news:9e57sk$9k$[EMAIL PROTECTED]... > www.editplus.com > www.sapien.com (PrimalScript) > > -elias > > ""news.php.net"" <[EMAIL

Re: [PHP-WIN] PHP and Multiple databases

2001-05-18 Thread John Lim
Hello, You can try this database library http://php.weblogs.com/adodb This features support for all the above databases. If you are familiar with ASP/ADO, this will be a good fit, as its API is based on ADO. Regards, John "Scott Ellis" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">n

Re: [PHP-WIN] Canceling a Query

2001-05-16 Thread John Lim
Hello, This is a workaround. Can you use T-SQL's: SET ROWCOUNT ? This limits the number of rows returned by a query. -- John ""Brinkman, Theodore"" <[EMAIL PROTECTED]> wrote in message FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_xch01">news:FE8510398BFE854F9653B5C32DBB652FD4F39E@oh_daytn_x

Re: [PHP-WIN] Testing php in Win2000?

2001-05-16 Thread John Lim
You need to install IIS on windows 2000, and then install the PHP executables from php.net. If you are using windows 2000, IIS is probably preinstalled. Look for a wwwroot directory on your hard disk. Regards, John "Geoff" <[EMAIL PROTECTED]> wrote in message 9dpbks$qgs$[EMAIL PROTECTED]">news:9

Re: [PHP-WIN] the /php/pear/DB abstraction

2001-05-16 Thread John Lim
Hello Monty, As an author of a database class library (http://php.weblogs.com/adodb) I can understand the need for good error messages. I decided in adodb to avoid using virtualised error messages because of this issue. It's more important to give good error messages than attempting to map to a

Re: [PHP-WIN] R: [PHP-WIN] PHP4 and MS Access

2001-05-05 Thread John Lim
If you are familiar with ADO, you can try ADODB at http://php.weblogs.com/adodb -john "Ermanno Iannacci" <[EMAIL PROTECTED]> wrote in message 003401c0d3a7$26925fa0$51fda8c0@ciccio">news:003401c0d3a7$26925fa0$51fda8c0@ciccio... > Use ODBC functions. > http://www.php.net/manual/en/ref.odbc.php > >

Re: [PHP-WIN] XML-RPC for Windows

2001-05-04 Thread John Lim
I also had the same problem when i tried a couple of months ago on Windows (on IIS). It appears to only work under Unix. -John ""Paul Meagher"" <[EMAIL PROTECTED]> wrote in message 01a801c0d3d6$4adaf6e0$6c35de18@datavore">news:01a801c0d3d6$4adaf6e0$6c35de18@datavore... > I have haven't been able

Re: [PHP-WIN] how to create a PHP4 library

2001-05-04 Thread John Lim
Add dollars in front of every variable, remove all type declarations and add dollars into my pocket :-) I just realised you probably mean you want to create a php extension. Visit zend.com for docs, or read the tutorial in PHP Cookbook by Sterling Hughes, Sams Publishing. ""Andre Steffens"" <[EM

Re: [PHP-WIN] Images in MySql

2001-04-22 Thread John Lim
Hi Xon, Some options i can think of. 1. Can u change HTTP write permissions yourselves via telnet with chmod or chgrp? That would be the simplest if possible. 2. If you have to store in MySQL, storing in the file system gives better performance. But storing in MySQL is not so bad. 3. Consider

Re: [PHP-WIN] mysql & ODBC Data source

2001-04-13 Thread John Lim
Oh forgot to mention that you don't need ODBC to connect PHP to MySQL. The MySQL client libraries are built into PHP already. Regards, John ""Ivan Pavlovic"" <[EMAIL PROTECTED]> wrote in message 006001c0c3f4$bc2323f0$[EMAIL PROTECTED]">news:006001c0c3f4$bc2323f0$[EMAIL PROTECTED]... Hi I need to

Re: [PHP-WIN] Funny errors with IF

2001-04-13 Thread John Lim
Before you can use any variable, you need to set it to value first. I don't know where you got these examples from, but I believe the authors presume that you have initialised the variables somewhere else. If you are learning php, i suggest you use simpler examples, as these examples probably ass

Re: [PHP-WIN] mysql & ODBC Data source

2001-04-13 Thread John Lim
Hi ivan, No mysql does not modify odbc. But you can download the mysql odbc driver from http://mysql.com if u need such a driver. Regards, John ""Ivan Pavlovic"" <[EMAIL PROTECTED]> wrote in message 006001c0c3f4$bc2323f0$[EMAIL PROTECTED]">news:006001c0c3f4$bc2323f0$[EMAIL PROTECTED]... Hi I n

Re: [PHP-WIN] Zend IDE/Debugger Install missing files?

2001-04-09 Thread John Lim
It's not needed. Ignore it. I have Zend Debugger working in W2K. Regards, John "Adam Robertson" <[EMAIL PROTECTED]> wrote in message 9ak79o$u0v$[EMAIL PROTECTED]">news:9ak79o$u0v$[EMAIL PROTECTED]... > Hi all, > > I'm trying to install the new Zend IDE and Debug server on my win2k / Apache > / M

Re: [PHP-WIN] A **NEW** "X-powered" dilemma... sessions using memory instead of files

2001-04-09 Thread John Lim
Hi, I believe the mm session handler is only available on Unix. John "Asendorf, John" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I was trying to run sessions using memory instead of files. So I changed the > session.save.handler in php.ini from "files" t

Re: [PHP-WIN] Insert query in Oracle database using php and COM

2001-04-03 Thread John Lim
Have you tried with PHP 4.0.5 RC1 from http://php4win.de ? There were many COM bugs in PHP 4.0.4 and earlier. Best of luck -- John "Julian" <[EMAIL PROTECTED]> wrote in message 99vl70$aqu$[EMAIL PROTECTED]">news:99vl70$aqu$[EMAIL PROTECTED]... > i did this : > > $oConn = new COM("ADODB.Conne

Re: [PHP-WIN] How to use COM

2001-03-17 Thread John Lim
Visit http://php.weblogs.com/com_php for more info on COM with PHP. john "Thomas" <[EMAIL PROTECTED]> wrote in message 98omg2$2n4$[EMAIL PROTECTED]">news:98omg2$2n4$[EMAIL PROTECTED]... > Hi all again, > > i' am a very bloody greenhorne with php and maybe i have many questions. > Heres one a

Re: [PHP-WIN] Pass double-byte string to Word.application COM

2001-03-17 Thread John Lim
Hi Richard, Double-byte COM is only supported in PHP 4.0.5 which is in beta. Get it at http://php4win.de/ John For PHP news, visit http://php.weblogs.com/ "Richard Hsiao" <[EMAIL PROTECTED]> wrote in message 9