php-windows Digest 30 Sep 2002 19:03:14 -0000 Issue 1364

Topics (messages 16070 through 16077):

String truncate problem of varchar when interfacing with a MS SQL server
        16070 by: Filip De Graeve
        16071 by: Svensson, B.A.T. (HKG)

Connecting to MS SQLserver problem??
        16072 by: Gard Rødahl

PHP 2 for WINDOWS
        16073 by: Edgar
        16074 by: brother - Martin Bagge

Any Squirrelmail users running on Windows NT 5 under IIS 5?
        16075 by: R.S. Herhuth

porting to 4.2.3 - variable interpolation
        16076 by: Ignatius Reilly

Re: Anyone know how to set IMAP
        16077 by: konchim

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]


----------------------------------------------------------------------
--- Begin Message ---
Hello,

First of all I've been looking for days on the net, trying to find a
solution before I came here.
I've found similar cases, but never a solution...

This is my problem:

When using the php_mssql extension to access a database (of which I can't
make changes to its design)
running on MS SQL Server 2000, -whether it's on windows or linux-
containing fields with the attribute e.g. "varchar(800)", they all get
truncated at 255 characters in length.

I know that MY SQL etc only supports varchar up to 255 chars, and from then
on blob is used;
but it seems that with MS SQL 2k varchar is supported up to about 8000 chars
in length. The problem is,
when you retrieve such a varchar, php only gets 255 chars.

I don't know how to work around this problem;
is it possible that this is a bug, or that I have to run a certain command
on the MS SQL before I
fetch that variable? If so, which command would it be?


I'd appreciate all help ...
thanks a lot!

Kind regards,
Filip De Graeve
[EMAIL PROTECTED]


--- End Message ---
--- Begin Message ---
> I don't know how to work around this problem; is it possible that this is a bug,
> or that I have to run a certain command on the MS SQL before I fetch that variable?

No, its a settings problem for you: default column widths are set to 255 characters.

> If so, which command would it be?

It is for 99% dependent on your data communication/exchange protocol,
which one are you using? ODBC? If so, check out these manual page:

http://www.php.net/manual/en/function.odbc-longreadlen.php
http://www.php.net/manual/en/function.odbc-field-len.php
--- End Message ---
--- Begin Message ---
I'm trying to connect to a mssqlserver from PHP, i have got the
php_mssql.dll and this one has
also been untagged in the php.ini file.
But for some reason does ALL the php scripts timeout when the php_mssql.dll
is being setup in
the .ini file. I'm running the php.exe from c:/PHP through ISAPI in IIS5,
and i've put the php_mssql.dll file in the same dir.
The ntwdblib.dll is also present in the system32 folder.

Any ideas? Have I missed something here?

Gard



--- End Message ---
--- Begin Message ---
Hello,

I'am looking for a php release 2 for windows...
And some documentation of this release functions.

Thank you.

Bye.


--- End Message ---
--- Begin Message ---
Edgar wrote:

> Hello,
> 
> I'am looking for a php release 2 for windows...
> And some documentation of this release functions.

I couldn't find any php2 releases for windows at the "php museum".

http://ftp.proventum.net/pub/php/win32/

looks like the first version for windows was 3.0.11.

/brother
--- End Message ---
--- Begin Message ---

I'm trying to get Squirrel Mail running under Windows NT 5 running IIS 5
and I was wondering if someone might be able to give me a hand. 
Specifically I'm getting a ton of "Warning: Cannot add header
information - headers already sent..." errors.  I was wondering if there
is a setting (or settings) that I might need to send to get this thing running.

Thanks,
Ron
--- End Message ---
--- Begin Message ---
Hullo,

After upgrading from 4.2.2 to 4.2.3, I met an annoying problem:

I POST a form with fields budget_w1, budget_w2, ...

$_POST['budget_w{$i}'] used to work, but does not anymore with 4.2.3:
Notice: Use of undefined constant budget_w - assumed 'budget_w' in
c:\apache\...

Anybody can give me a hint?

Merci!

Ignatius
____________________________________________

--- End Message ---
--- Begin Message ---
I can't use the mail function
I know how to send attachments and get mail in php
but i don't know how to set the function at windows and apache or php

"Manuel Lemos" <[EMAIL PROTECTED]>
???????:[EMAIL PROTECTED]
> Hello,
>
> On 09/29/2002 02:03 PM, Konchim wrote:
> > Anyone know how to set IMAP
> > I use WinXP apache Php4.0
> > where can i download a Dll for php IMAP?
>
> The IMAP extension comes with standard PHP distribution for Windows and
> is in the extensions directory.
>
>
> > And How to set it use my SMTP Account?
> > I didn't have Email server can i use PHP's Mail Function?
>
> I do not know if you can configure that.
>
> Anyway, if you are looking for composing and sending MIME formatted
> messages with attachments, HTML with embedded images or text and HTML
> versions in the same message, you may want to look into this class that
> provides that with plenty of explanatory examples:
>
> http://www.phpclasses.org/mimemessage
>
> --
>
> Regards,
> Manuel Lemos
>


--- End Message ---

Reply via email to