AW: [PHP-WIN] Insert range in Excel

2005-01-15 Thread Sven Schnitzke
fully control it. So you may produce such a text in the first place. Will be a lot faster than COMing around... d) If you have data that can be calculated from a seed (consecutives or any other building rule) you may automate "auto fill in". Do that by recording a macro when creati

AW: [PHP-WIN] Re: [PHP] php editor

2005-01-15 Thread Sven Schnitzke
e ? I don't know, since it works like a charm. If one can get it it's worth a try -- Sven Schnitzke > -Ursprüngliche Nachricht- > Von: Jason Barnett [SMTP:[EMAIL PROTECTED] > Gesendet am: Donnerstag, 13. Januar 2005 23:07 > An: php-windows@lists.php.net > Be

AW: AW: [PHP-WIN] Word COM Object

2005-01-07 Thread Sven Schnitzke
e break...and so on... > > The obvious problem is that if I use the Word COM object to insert the > HTML...the HTML isnt parsed and all I get is the HTML source code...but > the page breaks work great. If I save the file first as HTML then open it > using the Word COM object then save it

AW: [PHP-WIN] Word COM Object

2005-01-07 Thread Sven Schnitzke
Hi, sorry for accidentally sending private mail first ! Now to the list: to insert a pagebreak just leave out the parameter entirely. It's default: $word->Selection->InsertBreak(); but for clarity you may want to specify it, so do it the positional way (it's the 1st one): $w

AW: [PHP-WIN] Function reference

2004-10-06 Thread Sven Schnitzke
Dale, best thing you can do is start by developing the script using Word's VBA using builtin calltips, help and object browser then translate it to PHP. The most important thing to observe is that PHP's COM implementation does not implement multidimensional variant arrays (at least as of 4.3.3

[PHP-WIN] updating from xls -> [filter] -> mysql

2004-05-21 Thread Sven Schnitzke
Win2000 platform running PHP as a module on Apache2 the excel > application doesn't end after the script ends > > The script ends: > > $exapp->Quit(); > unset($exapp); > ?> > > What could be the problem? > > /Jesper > > > -Ursprungligt me

AW: [PHP-WIN] updating from xls -> [filter] -> mysql

2004-05-21 Thread Sven Schnitzke
t; dialog of Excel. With Excel 8 there seems to be a glitch as it returns localized colour names and does not accept english ones (At least my German version behaves this way; didn't scrutinize too deeply though). If you are interested I will send you a basic PHP COM script doing EXCEL I/O to

AW: [PHP-WIN] start an external program (isqlw.exe)

2004-03-08 Thread Sven Schnitzke
; > And there are more ways to do a server-side initiated programm execution. > > But I must admit that the whole thinggie could end up in a "security-hell" > or could people give the wrong ideas. In this matter I agree with Frank. So > my addition to this thread ends. >

AW: [PHP-WIN] start an external program (isqlw.exe)

2004-03-07 Thread Sven Schnitzke
Hi, > You can start certain programms at the client side using COM. But > (unfortunately ?) only when using PHP on windows webservers. Programm should > be installed at client side off course ... certain programs ... what do you have in mind ? -- Sven > -Ursprüngliche Nachricht- >

AW: [PHP-WIN] Re: Emailing via mail(), secondary servers

2004-02-18 Thread Sven Schnitzke
To both of you crusaders, first of all you are by far off topic now, so please relocate to a suitable list. And as I don't see this quarrel get to any kind of "solution" I would like to add my very personal unwanted comment: Besides and above any substantial point in any of your proceedings it

AW: [PHP-WIN] imitating browser

2004-02-03 Thread Sven Schnitzke
Hi, may I assume you want to automatically feed the otherwise human answers to the dialog presented by the search engine/catalog ? This is possible but at least a little tedious. First you shold make sure that there positively isn't any HTTP RPC (no misspelling, I mean remote proc call) access to

AW: [PHP-WIN] open directory and read the file

2003-12-23 Thread Sven Schnitzke
Simply do a >while ($file = readdir($handle)){ and make your directory current inserting chdir('c:\apache\htdocs'); just before the line where you finally check success of the fopen using > if ($handle_file = fopen ($find_file, "r")) { > ... > } >

AW: [PHP-WIN] mssql_connect problem

2003-12-17 Thread Sven Schnitzke
Cesar, Luis, as a non-native english speaking member of this list I would greatly appreciate to have the foreign languages spoken here at the count of one. Besides ... spanish orthography seems a bit off-topic to me. Please don't take this as an offence, Sven > -Ursprüngliche Nachricht--

AW: [PHP-WIN] Inconsistent php sematics witrh trim() ... or can't trim() handle assignment with same variable?

2003-12-16 Thread Sven Schnitzke
Hello Anders, fyi: \n is LF only (ASCII 10), \r is CR only (ASCII 13), Win newline is CRLF or \r\n and linux/unix newline is \n. LFCR is not a valid newline, so maybe this is the trouble. Wild guess: trim trims spaces, tabs and any kind of newline (so called white space) but no standalone CRs.

AW: [PHP-WIN] cUrl

2003-12-09 Thread Sven Schnitzke
Hi, apparently you downloaded the source - which you are supposed to compile yourself, using the MINGW toolset (http://www.mingw.org). But you might want to look for curl-7.10.8-win32-ssl.zip, if you trust your source in using a precompiled program. It contains a compiled Win32 CURL.EXE bundled w

AW: [PHP-WIN] form vars missing...

2003-09-29 Thread Sven Schnitzke
Take a peek into the manual, section "using PHP" keyword "register_globals" and consider the fact that the default ini setting has been changed from "on" to "off" starting with PHP 4.2.0 . Regards, -- Sven > -Ursprüngliche Nachricht- > Von: Jas [SMTP:[EMAIL PROTECTED] > Gesendet am:

AW: [PHP-WIN] a Directory Crawler

2003-09-24 Thread Sven Schnitzke
s_file($file)) { // here comes the action; I spit out a handle, you may open, read end extract print("" . $file . ""); } } } closedir($dir_handle); } } ?> -- Sven Schnitzke > -Ursprüngliche Nachricht-

AW: [PHP-WIN] php, excel - release problem

2003-09-20 Thread Sven Schnitzke
Hi, use of excel constants is facilitated by php.ini setting com.autoregister_typelibs on This is better than explicitly loading typelibs because you won't get rid of an explicitly loaded typelib anymore. As with the stickyness of excel: Yes, it has been an issue in earlier releases but AFAIK P

AW: [PHP-WIN] Re: MS Word COM Object formatting

2003-08-25 Thread Sven Schnitzke
Hi, sadly enough it's not that easy. But it is possible: $word->visible = 0; $word->Options->ConfirmConversions = false; // menu: options->general->confirm conversions // search for HTML Converter $fcList = $word->FileConverters(); $count = $fcList->Count(); for($i=1; $i<=$count; $i++) { $fc =

AW: [PHP-WIN] Re: Forms-PHP-and-errors

2003-07-09 Thread Sven Schnitzke
Hi, as to your new error message: If goes: if (condition) statement; so add the round braces around the condition and PHP will be happy. In my reply I referred to vars coming from POST action as $_POST['var_name_here']. This is an implication of register_globals = off which in turn is a good idea a

AW: [PHP-WIN] Re: Fatal error with 'DB.php' - solution

2003-07-06 Thread Sven Schnitzke
Hi Walter, fyi - you DON'T HAVE TO put PHP.INI into c:\WINNT, nothing of the like is being compiled anywhere. Where your systems searches for PHP.INI depends on the mode PHP is run, because it always is first searched for in the folder containing the _processes_ .EXE file: In CGI/EXE mode that is

[PHP-WIN] Value of $_SERVER['GATEWAY_INTERFACE'] in ISAPI mode

2003-06-08 Thread Sven Schnitzke
Hello list, does anybody know positively what PHP _is supposed to_ report for GATEWAY_INTERFACE when run in ISAPI mode ? I am using PHP with Apache 1.3.23 and get CGI1/1. I double checked Apache conf and removed any CGI related directives and still get this answer but I doubt that it is the one

AW: [PHP-WIN] doing $mc=new myclass(); or $mc= &new myclass(); ?

2003-06-06 Thread Sven Schnitzke
Hi Peter, with new() logically this doesn't make any difference because PHP is using the reference concept anyway. $b = &anything tells PHP to get hold of final effective "anything" and if it evaluates to something referenceable: _not_ build a copy of it and then set variable "b" to reference i

AW: [PHP-WIN] PHP, COM and Excel

2003-06-05 Thread Sven Schnitzke
Hi Neill, don't wonder 'bout the lack of sites. You are entering commercial area with using Excel. If you are heading for heavy use you might want to take look at BiffWriter http://www.web-aware.com/biff/ It does write Excel files directly without the overhead of COM (and Excel itself, for that

AW: [PHP-WIN] php.ini directory

2003-06-02 Thread Sven Schnitzke
yes it is. Search order for PHP.INI is a) current dir b) WINDIR c) C:\PHP4 Where current dir is the folder PHP*.EXE is residing when executing in CLI and CGI modes and the folder containing the webserver when in ISAPI mode. -- Sven > -Ursprüngliche Nachricht- > Von: =?ISO-8859-2?Q?Katon

AW: [PHP-WIN] Re: Subject: FOpen problems

2003-05-28 Thread Sven Schnitzke
Hi Will, you might want to take a look at http://www.php.net/register_globals There has been a change in default behaviour concerning this option: Prior to this option the default was like having this option ON. Early Versions of PHP4 equally defaulted this option to ON. Newer PHP versions for s

AW: [PHP-WIN] Output to Excel File

2003-04-02 Thread Sven Schnitzke
Hi, I recently experimented a bit with Excel using COM (Excel 8 aka Excel97 and PHP 4.3 / 4.4-dev on WIN98SE). It is quite hairy, especially because the PHP COM implementation does not yet implement all the needed VARIANT subtypes (most notably multi dimensional safe arrays), so a lot of objects

AW: [PHP-WIN] Re: Subject: + character in a command line argument

2003-04-01 Thread Sven Schnitzke
uild. CMDLINE reads: plus.php \"a+b.txt\" So to solve your problem you should settle for filenames without a plus sign in it. It's bad with *nix anyway. If you lack that option take a modern version of PHP, quote the filenames and pray. -- Sven Schnitzke > -Ursprüngliche Nachrich

AW: [PHP-WIN] + character in a command line argument

2003-03-31 Thread Sven Schnitzke
nt of + in filenames has been changed with PHP 4.3. Since then a+b.txt is one filename, quoted or not. -- Sven Schnitzke > -Ursprüngliche Nachricht- > Von: mmy [SMTP:[EMAIL PROTECTED] > Gesendet am: Sonntag, 30. März 2003 11:30 > An: [EMAIL PROTECTED] > Betreff: [PHP-WI

AW: [PHP-WIN] Simple Addition issue

2003-03-25 Thread Sven Schnitzke
It looks like the comma (',') is in this case interpreted as the decimal separator, not (as you apparently suppose) the grouping separator. >> You have a difference in the "locale" between your SQL Server and PHP. You might want to try getting e.g. 14.133,00 (to the cent) or tell PHP to use

AW: [PHP-WIN] Error, does anyone see anything wrong?

2003-03-25 Thread Sven Schnitzke
Take a look at line 17; most likely there is a ';' missing to indicate the end of the previous statement. -- Sven > -Ursprüngliche Nachricht- > Von: P.Bijl [SMTP:[EMAIL PROTECTED] > Gesendet am: Dienstag, 25. März 2003 01:20 > An: [EMAIL PROTECTED] > Betreff: [PHP-WIN] Error,

AW: [PHP-WIN] Sending mail on Windows 98

2003-03-14 Thread Sven Schnitzke
Hi, in short: for SMTP delivery on windows you need an SMTP port _within reach_ of the sending machine. The dialup network program of Windows does by itself no autodial. So to bring up the dialup dialog you would have to get an [auto]dialer reacting upon port 25. (A mail proxy with [auto]dial func

AW: [PHP-WIN] com_load_typelib()

2003-03-06 Thread Sven Schnitzke
Ok I see. Try INI setting com.autoregister_typelib = true and leave out the call of com_load_typelib() That gives you one instance of M$ Word that is dropped with Quit. Loading is slower so you might try to use that with ini_set() only when needed. I don't know if it's honored that way though. Ch

AW: [PHP-WIN] com_load_typelib()

2003-03-06 Thread Sven Schnitzke
What do you need the typelib for ? I suggest you try the example in the doc of com_load_typelib, just comment out the call to this particular function and smile. (Background: com_load_typelib apparently does not attach to a running instance, so you get orphans en masse.) Generally you have to qui

AW: [PHP-WIN] Mail Function Problem

2003-03-06 Thread Sven Schnitzke
Hi Jason, this is not a PHP problem. As the message states: The intranet SMTP server you are addressing does not support "proxy function" and refuses to forward your mail to e.g. hotmail. OTOH if you want to send directly you have to do ini_set("SMTP", "SMTP_server_you_want_to_drop_your_mail_at") j

AW: [PHP-WIN] php.ini

2003-03-01 Thread Sven Schnitzke
Hi Tony, in my config (WIN98SE, PHP4.4.0-dev dec 02 ISAPI mode, Apache 1.3.23) GD2 works fine. So it should be possible to get yours going. What about my suggestions on the error logging and stuff? No comments from PHP? Just silently passing away? If it is so that sounds like rests of an old ins

AW: [PHP-WIN] Re: why is this mail code not working on a windows server?

2003-02-25 Thread Sven Schnitzke
Hi, specify "SMTP" as just the part after the @ in the mail address, e.g vt4.net in your case. Then it should work. Cheers, -- Sven > -Ursprüngliche Nachricht- > Von: Per Christian [SMTP:[EMAIL PROTECTED] > Gesendet am: Samstag, 22. Februar 2003 14:59 > An: [EMAIL PROTECTED] > Betref

AW: [PHP-WIN] reading lines from a file

2003-02-11 Thread Sven Schnitzke
nt, and as far as I am asked with as little judgement as possible. Cheer up and be confident in the judgement of the respectively responsible. There are aspects to consider unmentioned and irrelevant w/resp to this NG. So I'd suggest to keep cool. Cheers, -- Sven Schnitzke (another self-empl

AW: [PHP-WIN] Problem closing COM object

2003-02-03 Thread Sven Schnitzke
t unwanted hint: Changing lots of data usually means a lot of writing to display: com_set(ex, "ScreenUpdating", false) before any such task makes excel hurry up a lot. Hope this helps, Cheers, -- Sven Schnitzke > -Ursprüngliche Nachricht- > Von: Chris Kranz [SMTP:[EMAI

AW: [PHP-WIN] win32 php.ini default behavior better in php executable directory?

2002-12-28 Thread Sven Schnitzke
Hello Petar, it already works this way. But beware of using different versions of PHP: you have to keep apart the Dll's too, because the interface description of e.g. php4ts.dll changes from time to time. So clean up %WINDIR%, %WINSYSDIR% etc of any PHP stuff and put your basic dlls in the same fol

AW: [PHP-WIN] accesing to a dll

2002-12-16 Thread Sven Schnitzke
Hello Omar, I would greatly appreciate you to toroughly read all of the details of the link and the respective functions. Maybe it is even translated to a spanish version. There is nothing to be compiled in. But you have to be familiar with the dll concept in general and the interface descriptio

AW: [PHP-WIN] Re: enabling extensions

2002-11-08 Thread Sven Schnitzke
Hello Tim I am using PHP 4.2.2 on Win98 for eval and I have encountered problems with extension_dir too. Basically it comes to that: PHP is not yet consistent in the usage and basing of relative pathnames in the different contexts (extensions, session_save, ...). In addition, absolute pathnames

AW: [PHP-WIN] PHP Editor

2002-11-05 Thread Sven Schnitzke
For a slim editor you might want to take a look at http://www.winsyntax.com Sven > -Ursprüngliche Nachricht- > Von: Mgr. Brian Kabela [SMTP:[EMAIL PROTECTED]] > Gesendet am: Montag, 4. November 2002 02:37 > An: [EMAIL PROTECTED] > Betreff: [PHP-WIN] PHP Editor > > Is there a Ed

WG: [PHP-WIN] PHP_SELF

2002-10-15 Thread Sven Schnitzke
Hi, is the real name of your table test_tabel as in the code sample or test_table as in the text ? Sven Schnitzke -Ursprüngliche Nachricht- Von:Rodrigo San Martin [SMTP:[EMAIL PROTECTED]] Gesendet am:Sonntag, 13. Oktober 2002 09:33 An: [EMAIL PROTECTED] Betreff

[PHP-WIN] Dying socket client kills serveer too ??

2002-09-07 Thread Sven Schnitzke
I tried to have a look at "socket_last_error" before reading but that does not help since it says: 0. "socket_select" lets loose upon the killing of the client, putting the socket into the "read" array. So I have to look at it... Any hints on how I get around this? Thank