Re: [PHP] MSSQL Support

2001-09-19 Thread Frank M. Kromann
also for version 7 and 2000. These two has a bunch of new column types and features no accessable from DB-Library and FreeTDS. - Frank > I'm compiling PHP and have a request from one of my developers for MSSQL > support in mod_php (4.0.6). However, I don't see a configure option

Re: RE: [PHP] write to multiple sql tables

2001-10-03 Thread Frank M. Kromann
and FrontBase (that I know of) If you want to insert/update data in multiple tables you might also want to choose a database with support for transactions, as this will ensure the consistancy of your data. - Frank > > PHP can only handle a query at a time. If the database in qu

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Frank M. Kromann
Hi, You should compile php with this option --with-mssql or --with-mssql=/path/to/freetds. This will enable the mssql extension. Enabling the DBX extension is not enough. DBX is just a wrapper arround other extensions. You still need to compile each of these extensions. - Frank > I need s

Re: [PHP] Unable to compile php with MSSQL support / configure: error: Directory /usr is not a FreeTDS installation directory

2007-01-10 Thread Frank M. Kromann
Hi, --with-mssql=/usr or --with-mssql=shared,/user should work with your configuration. It's looking for /usr/include/tds.h or /usr/include/freetds/tds.h. If the file was not found in any of those locations you will get the error you are describing here. - Frank > Hi, > >

Re: [PHP] Unable to compile php with MSSQL support / configure: error: Directory /usr is not a FreeTDS installation directory

2007-01-11 Thread Frank M. Kromann
The only other thing I can think of is permissions, but that would be too simple. - Frank > Hi Frank, > > Thanks for the reply but the tds.h is located under /usr/include/freetds > but the error persists. > > Any other ideas? > > On 1/10/07, Frank M. Kromann &

Re: [PHP] Unable to compile php with MSSQL support / configure: error: Directory /usr is not a FreeTDS installation directory

2007-01-12 Thread Frank M. Kromann
and ./configure. - Frank > Hi Frank, > > The problem gets stranger... > > I've downloaded the 5.1.6 and guess what? the ./configure --with-mssql runs > fine in the same machine... > > 5.0.4 > ./configure --with-mssql > ... > checking for MSSQL support

Re: [PHP] Bug? (_ENV in PHP v5.2.0)

2007-01-16 Thread Frank M. Kromann
Hi Eli, Check variable_order in php.ini (http://us2.php.net/manual/en/ini.core.php#ini.variables-order) if the E is missing you will not get any environment variables. - Frank > Hi, > > System: > Win32 > PHP 5.2.0 > Apache 2.0.54 (PHP in CGI mode) >

Re: [PHP] Size Limit PHP + MSSQL

2007-02-23 Thread Frank M. Kromann
There are two settings in php.ini mssql.textsize and mssql.textlimit. When tese are set to -1 (default) the values used are configured on the server and is usually 4k. - Frank > Is there size limit for select queries in php? > > I am trying to grab a very long string that exists in the

Re: [PHP] shell_exec, batch files, and IIS on Windows

2007-02-27 Thread Frank M. Kromann
The user that runs the php script under iis (IUSER_) should have permissions to execute the cmd.exe file, the .bat file and all the commands included in the .bat file. - Frank > The manual entry for shell_exec has a comment that notes to execute .bat > files with shell_exec, you need t

Re: [PHP] Re: Classes in PHP5 || Puzzling Problem || Trying to Set $this->$name = $value

2007-03-08 Thread Frank M. Kromann
Sounds like a PHP version problem. PHP 4 will output 0 and PHP 5 will give 1. The constructor must be named the same as the class name in PHP 4 for this to work. You can have both constructors in your class so it will work in both versions. - Frank > I don't know the details of your

RE: [PHP] PDO mssql + multiple rowsets

2007-03-28 Thread Frank M. Kromann
It Is doable. The native mssql/dblib extension does support that features. I just have'nt had the time to code it for pdo_dblib. - Frank > I too have been having problems getting the PDO dblib for mssql to play > well (getting the same error actually). If you find a reason or work &

Re: Fwd: [PHP] PDO mssql + multiple rowsets

2007-04-04 Thread Frank M. Kromann
Support for multiple result sets will be added as soon as I (or someone else) get the time to do so. - Frank > I've seen there's an open bug on the missing feature I pointed out in my > first email, but it's even not assigned and I cannot get an answer from the > develop

Re: [PHP] Anyone good with multiple SSL on Apache?

2010-03-08 Thread Frank M. Kromann
You can only have one SSL per IP address. The SSL connection between the client and server is done before the host header name is made available to Apache. - Frank On 3/8/10 2:13 PM, Skip Evans wrote: Hey all, I have an Apache virtual config running a bunch of sites, one with SSL. I

Re: [PHP] Anyone good with multiple SSL on Apache?

2010-03-08 Thread Frank M. Kromann
Not that I know of. - Frank On 3/8/10 2:21 PM, Skip Evans wrote: D'oh! ...and I suppose there is just no way around that, eh? Skip Frank M. Kromann wrote: You can only have one SSL per IP address. The SSL connection between the client and server is done before the host header name is

Re: [PHP] gmp in windows snaps

2005-03-31 Thread Frank M. Kromann
Hi Jon, You need to install the gmp extension. Not sure if this is included in the snaps builds, but you should be able to download it from my site: http://kromann.info/php.php. - Frank > I asked this in the windows section yesterday and received no answer. > > I have copied the

Re: [PHP] Works in Mozilla, not in IE

2004-06-28 Thread Frank M. Kromann
Hi Robert, This line header("Content-Disposition: attachment; filename=customers.xls"); forces IE to save. If you change attachment to inline it will open the Excel in the plug-in imbeded in the browser. - Frank > I have the script below from another source, and it works

RE: [PHP] Works in Mozilla, not in IE

2004-06-28 Thread Frank M. Kromann
You also need to change header("Content-type: application/octet-stream"); to header("Content-type: application/vnd.ms-excel"); - Frank > That just made IE put it out in "data" style, Excel didn't open up. > > :( > > Any other thought

[PHP] Getting line count of a text file

2007-09-12 Thread Frank J. Schima
e of bytes exhausted (tried to allocate 35 bytes) in /path/to/myprogram.php on line 16 Line 16 is the first line above. I'm sure there is a better - more memory efficient - way to do this. Any suggestions? Thanks! Frank Schima Foraker Design <http://www.foraker.com>

Re: [PHP] Getting line count of a text file

2007-09-12 Thread Frank J. Schima
ng and deploying on *nix, shell commands are fine with me. "Frank J. Schima" <[EMAIL PROTECTED]> wrote: > Hi all, > > > In PHP 5, I'm counting the number of lines in a text file using the > following code: > $myfile = file ( '/path/to/m

Re: [PHP] Getting line count of a text file

2007-09-12 Thread Frank J. Schima
r all the suggestions. FYI, it was a (very) minor pain to make that into a string. I ended up using this: $count = system("wc -l /path/to/myfile.txt | awk -F' ' '{print " . '$' . "1}'"); I didn't need to escape anything because t

Re: [PHP] Calculations

2006-06-27 Thread Frank M. Kromann
Take a look at the pow() function http://php.net/pow - Frank > Hi there list. > Thanks for your help with my other questions. > > I was carrying on working through, and stumbled across a problem when trying > to times something by the 'power' of something. By this I

Re: [PHP] PHP on IIS and MS SQL 2000

2006-07-23 Thread Frank M. Kromann
Replace php_mssql.dll with php_dblib.dll. You aæso need to create a freetds.conf file but you remove the limitations created by ntwdblib and you get a thread safe environment. - Frank > Our story is > We started building our application back in 2002 on FreeBSD/Apache with > P

Re: [PHP] PHP 5.2.0 Session Handling Bug? Can someone test this please?

2006-11-16 Thread Frank J. Schima
I didn't fiddle too much with it as I didn't see the point. I've tested this on PHP 5.1.6 and it is not affected. Thanks. Col. Frank Schima Foraker Design <http://www.foraker.com> 303-449-0202

Re: [PHP] Problems with Zip+IE6

2006-12-12 Thread Frank M. Kromann
Hello, if you use: header("Content-Type: application/zip"); header("Content-Disposition: attachment; filename=\"somefile.zip\""); That works for me with IE 6/7 and other browsers. - Frank > damn! that's a pretty good article, thanks a lot. > > u

Re: [PHP] Are PHP5 features worth it?

2006-12-19 Thread Frank M. Kromann
e old PHP4 style for programming with objects, but getting access to all the new features would make the update worth the effort. - Frank > On Tue, 2006-12-19 at 19:05 +0100, Niels wrote: > > Hi list, > > > > I'm writing a PHP program and I've got a number of concer

[PHP] Failing FastCGI PHP

2006-05-11 Thread Frank de Bot
interval has been backed off to 600 seconds" Is this a bug a php or fastcgi? Regards, Frank de Bot -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Failing FastCGI PHP

2006-05-13 Thread Frank de Bot
() #7 0x894e4e0 in ?? () #8 0x894e4c0 in ?? () etc etc etc... Thus useless :P At the moment it has been running remarkably stable for a few days. So now and then a failure. Probably because of a request being given to a php-fastcgi process handling a slow upload of a file... :-/ Frank de Bot

Re: [PHP] Updating content on the line. (cli)

2004-03-03 Thread Frank M. Kromann
At least on Windows you can send chr(13), and then rebuild the entire line. - Frank > Well I bet it would work on Win32, it just depends on how much CYGWIN > your willing to include with your program. I think all you would need is > the basic CYGWIN DLL(s) and a terminal like bash (plu

Re: [PHP] ?=

2004-03-16 Thread Frank M. Kromann
Asuming the content is generated by php, take a look at htmlentities(). http://php.net/htmlentities - Frank > How do I get this to work? the input box is only showing > > He said, > > frown" size="50"> > > > > James Hicks > > -- &g

Re: [PHP] Re: why won't mssql work?

2004-03-29 Thread Frank M. Kromann
If you are using the Apache module you need to restart Apache each time you make changes to php.ini. - Frank > EP> And as far as IIS, I am running apache. > > Heh. Well, then I guess I can't help you there, as I've never run > Apache on a Windows machine. :-) &g

RE: [PHP] Displaying a money datatype from mssql - Solution

2004-04-02 Thread Frank M. Kromann
This is a bug in php 4.3.5 and it's fixed in the upcomming 4.3.6 release. - Frank > Recap: > In the query I had; > SELECT totalamount > > And it was returning; > Total Amount > 5.41108926696E-309 > > I tried to modify the query to; > SELECT cast(totalamou

Re: [PHP] php_ftp.dll missing

2004-10-24 Thread Frank M. Kromann
Hi Thomas, What version of php are you using? Both PHP4 and PHP5 has the ftp extension build-in so there is no need to load it. - Frank > Hello! > I don't have a file named php_ftp.dll, where can I find it? > > I've added extension php_ftp.dll but Apache says I don

Re: [PHP] Installing on Windows.... CGI v. ISAPI?

2004-12-29 Thread Frank M. Kromann
s the ISAPI version, but without the troubles. Read more here: http://www.caraveo.com/fastcgi/ - Frank > GH wrote: > > #2 which method is better to install PHP with IIS? ISAPI or CGI? > > ISAPI... no idea what it stands for though, but installing PHP that way > will make it a m

Re: [PHP] Re: Trying to compile PECL fileinfo on Windows

2005-01-29 Thread Frank M. Kromann
FileInfo is not available on win32. - Frank > Chris wrote: > > Hi, > > > > Are there any places that might have instructions on compiling PECL > > extensions on Windows? I tried going the pear install route, > > but fileinfo is not considered stable yet. >

Re: [PHP] carriage return

2005-08-05 Thread Frank de Bot
Diana Castillo wrote: How can I with php detect when there is a carriage return at the end of the text field in a mysql table? Something like this perhaps: $res = mysql_query($query); $row = mysql_fetch_object($row) if (preg_match("/\r$/",$row->textfield) { echo "Got CR"; } else { e

Re: [PHP] Bug or programmer-error?

2005-08-06 Thread Frank de Bot
Rob Ziere wrote: Dear PHP_friends, I have found a strange behaviour of the "include" function. Here it is . // 1. this works fine include ("../../gps_info/fetch_fields.php"); // 2. this works fine $doc_root=$_SERV

Re: [PHP] Average time spent on a page

2005-08-06 Thread Frank de Bot
[EMAIL PROTECTED] wrote: Hi, How can i found out the average time users spent on a page. Anyone know a tutorial? Thanks in advance for your help !!! A hello world page will take me around 15 secs I guess... A full blown website with everything you can imagine a few months orso. -- PHP G

Re: [PHP] Linux/PHP and Windows/MSSQL

2005-10-06 Thread Frank M. Kromann
27;s not a big task to copy all files from one test/development box to a number of other systems, as long as the configurations are the same. - Frank > Knowing that I'm not the only one to want to connect to Microsoft SQL > Server on Windows from PHP and Apache on Linux, I'm seeki

Re: [PHP] Linux/PHP and Windows/MSSQL

2005-10-07 Thread Frank M. Kromann
fference there. The mssql extension implements about twice as many functions as the sybase extension. - Frank -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MS SQL Question

2001-02-07 Thread Frank M. Kromann
The table "extended" is not known to the update command. You shoud use a syntax like this: UPDATE table1 SET table1.field1 = (select field2 from table2 where table2.id=table1.id). - Frank >I am trying to update a table with data from another table within the same >d

Re: [PHP] RE: [PHP-WIN] MSSQL Functions

2001-02-07 Thread Frank M. Kromann
ver to the php server. You will need to use the ODBC manager to create client configurations as the tools for this will not be installed. - Frank >Toby, > >Yes, the client is requires because the MSSQL module uses some libraries >from the client to function. I don't know wh

Re: [PHP] FDF Toolkit uncompression error

2001-02-09 Thread Tim Frank tfrank
DL the file on a windows machine and then FTP the file to my unix box in ASCII mode (NOT BINARY). I don't know why or what was causing the problem, but that is how I fixed it. Now I'm trying to install it ;) Hope that helps Tim Frank >>>>>>>>>>>>

[PHP] Re: [PHP-WIN] INSERT into MSSQL Server

2001-02-13 Thread Frank M. Kromann
It is only the ' charactor there has a "problem" you have to excape any special character before inserting. the text Joe's should be inserted like this" INSERT INTO table1 (int_field, char_field) VALUES (1, 'Joe''s') A single quote is escaped by

[PHP] Maybe an HTML prob?

2006-11-29 Thread Frank Reichenbacher, Bio-Concepts, Inc.
I am trying to pass the results of a form to a simple php mail() routine. Everything works except the checkbox, Permission". No matter what state the checkbox is in, the php says it is whatever the "value" is set to on the form. I must not be trying to pull the checkbox state correctly. I've trie

RE: [PHP] Maybe an HTML prob?

2006-11-29 Thread Frank Reichenbacher, Bio-Concepts, Inc.
Re: [PHP] Maybe an HTML prob? > > On Wed, November 29, 2006 12:52 pm, Frank Reichenbacher, Bio-Concepts, > Inc. wrote: > > $Permission = $_POST["Permission"]; > > if ($Permission = "Yes") { > > In addition to the aforementioned = versus == error, yo

RE: [PHP] Maybe an HTML prob?

2006-11-29 Thread Frank Reichenbacher, Bio-Concepts, Inc.
Aha! The secret handshake. That was it. Thanks to Brad and to David for pointing me to an invaluable online php resource. Frank > -Original Message- > From: Brad Fuller [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 29, 2006 12:42 > To: php-general@lists.php.net &

RE: [PHP] security and .htaccess

2006-12-04 Thread Frank Reichenbacher, Bio-Concepts, Inc.
> -Original Message- > From: tedd [mailto:[EMAIL PROTECTED] > Sent: Monday, December 04, 2006 08:29 > To: php-general@lists.php.net; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP] security and .htaccess > > > At 8:57 PM -0700 12/3/06, Frank Reichen

<    1   2   3   4   5   6