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
finally have a need to add SSL to one more, but when I do the
first one (which is further down the file) comes up "untrusted".
Since this is pretty far off topic I'd be obliged if someone who has
configured this before can email me off list for some assistance.
Much thanks!
Skip
er... so... does anybody know if there is any plan to finish the
> PDO-dblib driver?
>
> TIA
>
>
> -- Forwarded message --
> From: Javier Ruiz <[EMAIL PROTECTED]>
> Date: Apr 2, 2007 9:54 AM
> Subject: Re: [PHP] PDO mssql + multiple rowsets
>
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
> around for i
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 app, but you
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 to pass th
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 database.
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)
>
> CGI vars are not automat
t; checking for specified location of the MySQL UNIX socket... no
> ...
> make
> ...
> Build complete.
> (It is safe to ignore warnings about tempnam and tmpnam).
>
> On 1/11/07, Frank M. Kromann <[EMAIL PROTECTED]> wrote:
> >
> > The only other t
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 &
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,
>
> I am trying to compile
PHP5 is more than just OO features, SimpleXML, SPL, Filter and the newly
added Date/Time functions just to mention a few. If you need any of those
PHP5 is the way to go.
The first version of PHP5 was released in 2004, so it's been arround for a
while now. In most cases you can still use the old PH
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.
>
> unfortunatelly, it's not mentioning about zip fil
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
> PostgreSQL.
>
> T
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 mean..in maths
you
> can wr
> On Thu, October 6, 2005 8:29 pm, Rick Emery wrote:
> > 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 seeking advice.
>
> You may want to consider using the Sybase drivers if they are
> available as up-to-date RPMs.
Hi Rick,
FreeTDS is still a fast moving target and so is PHP in some areas. Getting
pre-compiled RPM's would often force you to run older versions. Compiling
from source enables you to keep up to date with the latest features and
bug-fixes. If you are running this on multiple computers it's not a
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 sample of gmp_a
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.
> >
> > Chris
>
> Trying a PEAR or
Hi,
Though the ISAPI version is getting more stable it's still not as stable
as the CGI version. As an alternative to CGI you can use FastCGI. It
installs a module in the IIS web server and will preload a number of PHP
processes. This will make the web requests perform almost as fast as the
ISAPI
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't have this file
:( Could Y
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 some h
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
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 prefectly in
> Mozilla
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(totalamount as decimal(10,2)) as totalamount
>
>
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. :-)
>
> Sorry. I hope someone else
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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsu
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 (plus ncurses
>
Hi Kelvin,
You can use both PERL and PHP (prefered :-)).
You need to download, compile and install FreeTDS (http://freetds.org). If
you are using PHP you need to recompile it using --with-mssql. This will
enable the mssql extension. You can then create a php script to read the
text file, parse it
Hi Kelvin,
You can use both PERL and PHP (prefered :-)).
You need to download, compile and install FreeTDS (http://freetds.org). If
you are using PHP you need to recompile it using --with-mssql. This will
enable the mssql extension. You can then create a php script to read the
text file, parse it
I do that all the time without any problems.
Could you give us a (small) sample script ?
- Frank
> Hey,
> Does anyone know WHY form scripts, that submit to themselves, dont work on
> windows boxes?? Example :
> I have a script called mail.php. The first part of the script displays the
> form wh
Hi,
IBM DB/2 uses Call Level Interface (CLI) for communication between clients and server.
The ODBC driver from IBM is a simple one to one wrapper arround CLI, as CLI and ODBC
share the same specifications.
Using ODBC will give you an extra layer though. On *nix platforms you can compile usen
Some databsaes allows batches of sql statements. Thes can be passed to the db server
in one query and the statements are usally separated by ;
If you are executing a batch of statements each returning a result you will have to
process each result in your code. This is supported by ODBC, MS SQL
Hi Jason
You can download and install FreeTDS (www.freetds.org). Then you can compule with the
option --with-sybase=/usr/local/freetds. Thsi way you get the Sybase extension and
this includes aliases for mssql_*.
Be aware the FreeTDS can be used with MSSQL server 4 and 6 and in some cases also
map replace my old mail() calls? Don't I have to get a server that
> supports it or something??
>
> the regex thing I already got working...
>
> thanks...
>
> At 21:53 17/9/2001 -0700, Frank M. Kromann wrote:
> >Take a look at http://php.net/manual/en/function.imap-r
Take a look at http://php.net/manual/en/function.imap-rfc822-parse-adrlist.php
This function will do the trick. You can also have a look at
http://php.net/manual/en/function.imap-mail.php. This is an extended mail function and
it works on both WIndows and *nix.
- Frank
> I had to write my own
Hi Eric,
You can use COM in PHP if your scripts run on Windows 32. You can also use Java clases
directly from yor php scripts.
- Frank
> What is PHP's equivalent to ASP/COM or JSP/EJB? Basically, I want to get an
> idea of what methods there are of having multi tier development in PHP. Any
>
Have a look at these two settings in your php.ini
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
- Frank
> Hi,
> I've hit a little problem... When retreiving large TEXT data (equivilant to
> MyS
Hi all,
The dll is not broken.
The type UNIQUEIDENTIFYER is a 16 byte binary value and is returned as such.
With versions of the php_mssql.dll distributed with php4.0.5 or before did not include
proper support for binary data. This has been changed in php4.0.6.
I have hust added a small funct
I would use gmktime() to create a UTC timestamp stored in the database, and then use
the knowledge about each users timezone to convert this information when showing it.
- Frank
> I have a quick question regarding timezones ...
>
> On the local side a record is inserted into the DB by someone
you just have to execute a statement starting and ending the transaction.
BEGIN TRANSACTION
COMMIT
ROLLBACK
Yuu send thes commands to the server with mssql_query() as any other SQL statement.
- Frank
> I am trying to implement transactions using PHP and MSSQL 7 (Microsoft). Please
>tell me
fmk Wed Apr 25 12:45:14 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Remove c++ comment
Move errormessage when FBExec is not running. This error should not show if we
connect through a port number.
Index: php4/ext/fbsql/php_fbsql.c
diff
fmk Wed Apr 25 11:01:23 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
make fbsql_field_flags return a value
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.12 php4/ext/fbsql/php_fbsql.c:1.13
--- php4/ext/fbsql/php_fbsq
fmk Wed Apr 25 11:00:55 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h
Log:
removed unused code
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.3 php4/ext/fbsql/php_fbsql.h:1.4
--- php4/ext/fbsql/php_fbsql.h:1.3 Tue Apr
> >>
> >>or somthing like that which works in C
> >>
> >>- James
> >>
> >> > -Original Message-
> >> > From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
> >> > Sent: 23 April 2001 19:24
> >> &
Hi James,
No problem. I change it to
#define PHP_CONFIG_FILE_PATH getenv("SystemRoot")
What about all the other directories ? These should be configureable too.
- Frank
> > fmk Mon Apr 23 10:33:22 2001 EDT
> >
> > Modified files:
> > /php4/main config.w32.h php_ini.c
> > +
fmk Mon Apr 23 10:33:22 2001 EDT
Modified files:
/php4/main config.w32.h php_ini.c
Log:
Fix build on WIn32
Should the new directorys be static?
Index: php4/main/config.w32.h
diff -u php4/main/config.w32.h:1.40 php4/main/config.w32.h:1.41
--- php4/main/co
You can use
$temp = ord("A");
And you will then see that it's 65 end not 99 :-)
- Frank
> Is there any function in PHP that I could use to know the number of the
> ASCII table of letter "A" for example?
>
>
> something like: $tmp=function_name("A");
>
> $tmp==99 ("A" is 99 in ASCII table).
fmk Tue Apr 17 10:39:43 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h php_fbsql.c
Log:
Adding fbsql_fetch_assoc() functon
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.2 php4/ext/fbsql/php_fbsql.h:1.3
--- php4/ext/fbsql/p
According to the documentation http://php.net/manual/en/function.mysql-result.php
mysql_result takes 2 and an optional third parameter. The second parameter should be
the row number.
- Frank
> Hi, can some one please help me figure out why the value $device isn't being passed
>on out of the s
fmk Mon Apr 16 09:27:12 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing memory leek on CancelFetch.
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.10 php4/ext/fbsql/php_fbsql.c:1.11
--- php4/ext/fbsql/php_fbsql.c
fmk Tue Apr 10 11:44:51 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing database password to actually work
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.9 php4/ext/fbsql/php_fbsql.c:1.10
--- php4/ext/fbsql/php_f
fmk Wed Apr 4 13:10:14 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h php_fbsql.c
Log:
Adding empty RSHUTDOWN function.
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.1 php4/ext/fbsql/php_fbsql.h:1.2
--- php4/ext/fbsql/php
You can use something like this:
this will change the mime type and filename of the content send to the browser.
- Frank
> On 4/3/01 12:34 PM, "Spunk S. Spunk III" <[EMAIL PROTECTED]> wrote:
>
> > I've got a script that returns a smil file in a header but I'd like to
> > change the name of
fmk Tue Apr 3 11:09:02 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing crash when listing databsaes
Fixing rowcount to woirk when the result contains an array og data.
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsq
Hi All,
PHP is unable to resolve the variable you are trying to use within a stting. If you
use complex array structures you have to write it like this:
$sql = "insert into sessions(session_id, user_id, session_expiration) values
('$sess_id', " . $user_fields['USER_ID'] . "', sysdate + (" .
fmk Thu Mar 22 16:58:59 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Removing extra check for warnings.
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.6 php4/ext/fbsql/php_fbsql.c:1.7
--- php4/ext/fbsql/php_fbsql.c:1
fmk Thu Mar 22 13:16:23 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Adding warning when query fails
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.5 php4/ext/fbsql/php_fbsql.c:1.6
--- php4/ext/fbsql/php_fbsql.c:1.5
fmk Wed Mar 21 13:53:45 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
setting right params to zend_get_parameters_ex
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.4 php4/ext/fbsql/php_fbsql.c:1.5
--- php4/ext/fbsql/
fmk Wed Mar 21 11:56:34 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
changed arg types from pval* to zval**
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.3 php4/ext/fbsql/php_fbsql.c:1.4
--- php4/ext/fbsql/php_fbsq
fmk Tue Mar 20 12:25:55 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing crash when result conrains 0 rows
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.2 php4/ext/fbsql/php_fbsql.c:1.3
--- php4/ext/fbsql/php_fbs
fmk Tue Mar 20 11:21:45 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Converting to c-style comments.
Adding prototypes to all exported function
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.1 php4/ext/fbsql/php_f
fmk Fri Mar 16 11:48:40 2001 EDT
Modified files:
/php4/ext/standard array.c
Log:
Fixing build on Win32 by adding missing BLS_FETCH();
Index: php4/ext/standard/array.c
diff -u php4/ext/standard/array.c:1.102 php4/ext/standard/array.c:1.103
--- php4
2000
+++ php4/ext/printer/CREDITSThu Mar 15 22:15:58 2001
@@ -0,0 +1,2 @@
+PRINTER
+Daniel Beulshausen, Frank M. Kromann
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
fmk Tue Mar 13 13:02:52 2001 EDT
Modified files:
/php4/win32 php_modules.dsw
Log:
Adding FrontBase extension to modules
Index: php4/win32/php_modules.dsw
diff -u php4/win32/php_modules.dsw:1.38 php4/win32/php_modules.dsw:1.39
--- php4/win32/php_modules.dsw:
oup "Source Files"
# PROP Default_Filter "cpp;c;cxx;rc;def;r;odl;idl;hpj;bat"
# Begin Source File
SOURCE=.\php_fbsql.c
# End Source File
# End Group
# Begin Group "Header Files"
# PROP Default_Filter "h;hpp;hxx;hm;inl"
# Begin Source File
SOURCE=.\php_fbsql.h
# End Source File
# End Gr
fmk Tue Mar 13 08:39:48 2001 EDT
Modified files:
/php4/ext/pcre php_pcre.c
Log:
Fixing compiler warning on win32
Index: php4/ext/pcre/php_pcre.c
diff -u php4/ext/pcre/php_pcre.c:1.89 php4/ext/pcre/php_pcre.c:1.90
--- php4/ext/pcre/php_pcre.c:1.89
. |
+--+
- | Authors: Frank M. Kromann <[EMAIL PROTECTED]> |
+ | Authors: Frank M. Kromann [EMAIL PROTECTED]> |
+--+
*/
-/* $Id: php_
lt;[EMAIL PROTECTED]> |
- | Frank M. Kromann <[EMAIL PROTECTED]> Support for DB/2 CLI |
+ | Frank M. Kromann <[EMAIL PROTECTED]> Support for DB/2 CLI |
+--+
*/
-/* $Id: php_odb
fmk Fri Mar 9 15:37:56 2001 EDT
Modified files:
/php4/ext/mssql php_mssql.h php_mssql.c
Log:
Adding a new function mssql_next_result() allowing the query to return more than one
result.
This can be done with a stored procedure or by sending more than o
fmk Wed Mar 7 08:33:14 2001 EDT
Modified files:
/php4/main main.c
Log:
Removing a compiler warning
Index: php4/main/main.c
diff -u php4/main/main.c:1.355 php4/main/main.c:1.356
--- php4/main/main.c:1.355 Sat Mar 3 17:45:19 2001
+++ php4/main/main.c
fmk Sat Mar 3 18:41:27 2001 EDT
Modified files:
/php4/ext/standard info.c
Log:
Changed code layout to remove PHP warning when running php as a CGI.
Index: php4/ext/standard/info.c
diff -u php4/ext/standard/info.c:1.129 php4/ext/standard/info.c:1.130
--- p
IF you dont specify --with-apache or --with-apxs configure options you will build the
CGI !
- Frank
>Ok, I give up... how do I build PHP as a CGI-Binary? I've spent two days
>searching the configure file for this.
>
>Julia
>
>--
>[ Julia Anne Case ] [Ships are safe inside the harb
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 an extra single quote.
- Frank
>I trying to in
Hi All,
the key komponent is ntwdblib.dll installed in winnt\system32. The dll uses
other dll's to comunicate with the server dbmssocn.dll (tcp/ip) and dbmsnp.dll
(NetBios). All the communication dll's should be installed with the ODBC driver. Just
copy ntwdblib.dll from the SQL server to the
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
>database with the following
76 matches
Mail list logo
