php-windows Digest 29 Jul 2004 04:13:59 -0000 Issue 2336
Topics (messages 24270 through 24275):
Re: Truncating data
24270 by: Bowden, Zeb
24271 by: Robert Twitty
Installing PHP 5.0 on IIS6/win2003
24272 by: Brian Rottman
24273 by: Chris
Compiling php 5.0.0 Errors
24274 by: Anthony Cummings
php installation problem
24275 by: PHP MySQL
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 ---
Instead of:
SELECT varchar_field FROM table
Try:
SELECT convert(text,varchar_field) FROM table
There might be a more efficient way but this has always worked for me...
-zeb
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Truncating data
Hey!
Okay I have a simple script that is nothing more than a query run
against
a Microsoft SQL Server database which returns a VARCHAR(2400) field to
display in a text area field for user modification. The problem is that
even though all of the data exists in the database, when it is displayed
in the Textarea not all the data is there. I've taken care to make sure
that all quotes are taken care of and things like that, but it still
truncates the data.
This is driving me nuts...any assistance would be greatly appreciated!
Ron
--- End Message ---
--- Begin Message ---
You just ran into a limitation of PHP's mssql extension on Windows. This
extension was built with DB-Library, which is obsolete and does not
support the new or extended SQL Server 7.0/2000 data types. DB-Library
assumes all varchar fields have a max size of 255, which was the case for
SQL Server 6.5. varchar fields in 7.0 and 2000 have a max size of 8000,
and will be truncated to 255 by DB-Library.
Rather than changing all of your stored procedures to accomodate an old
technology, you should use ODBTP, http://odbtp.sourceforge.net. It
includes an odbtp/mssql hybrid extension that supports all of the mssql
extension's functions. Thus, you will not have to change your current PHP
scripts to use it. See http://odbtp.sourceforge.net/phpext.html#mssql.
-- bob
On Wed, 28 Jul 2004, Bowden, Zeb wrote:
> Instead of:
> SELECT varchar_field FROM table
> Try:
> SELECT convert(text,varchar_field) FROM table
>
> There might be a more efficient way but this has always worked for me...
>
> -zeb
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 28, 2004 8:37 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Truncating data
>
> Hey!
>
> Okay I have a simple script that is nothing more than a query run
> against
> a Microsoft SQL Server database which returns a VARCHAR(2400) field to
> display in a text area field for user modification. The problem is that
> even though all of the data exists in the database, when it is displayed
> in the Textarea not all the data is there. I've taken care to make sure
> that all quotes are taken care of and things like that, but it still
> truncates the data.
>
> This is driving me nuts...any assistance would be greatly appreciated!
> Ron
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--- End Message ---
--- Begin Message ---
Is there any howto's out there about installing PHP 5.0 on win2003/IIS6?
All of the docs @ php.net are still for 4.x and the user comments have
been wiped out.
Thanks.
--- End Message ---
--- Begin Message ---
Don't know of any how tos out there, but just finish an install of 5 running
IIS6 on a 2k3 server. We found an exe to install, but we also downloaded the
binaries. If you still need help email me at [EMAIL PROTECTED] and I'll
let you know what we did to get it working.
Chris Shrum
"Brian Rottman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there any howto's out there about installing PHP 5.0 on win2003/IIS6?
> All of the docs @ php.net are still for 4.x and the user comments have
> been wiped out.
>
> Thanks.
--- End Message ---
--- Begin Message ---
I am trying to compile a custom/streamline php dist using Visual Studio's
nmake. I downloaded the stable source and have built all my dependent libs
(hopefully). But I keep getting an error looking for a "winres.h" file for
template.rc. The exact error is as follows...
rc /fo Release_TS\php5ts.dll.res /d FILE_DESCRIPTION="\"PHP Script
Interpreter\"" /d FILE_NAME="\"php5ts.dll\"" /d PRODUCT_NAME="\"PHP Script
Interpreter\"" win32\build\template.rc
win32\build\template.rc(8) : fatal error RC1015: cannot open include file
'winres.h'.
NMAKE : fatal error U1077: 'rc' : return code '0x1'
Stop.
I can't find that file anywhere in the php sources. Does anyone have any
ideas because I'm all out?
Some more info about my environment
Configure Command:
C:\php_work\php-5.0.0>cscript /nologo
configure.js --disable-debug --with-gd=shared --enable-apache2handler=shared
--enable-memory-limit --with-mysql
Configure Output:
Saving configure options to config.nice.bat
Checking for cl.exe ... <in default path>
Checking for link.exe ... <in default path>
Checking for nmake.exe ... <in default path>
Checking for lib.exe ... <in default path>
Checking for bison.exe ... <in default path>
Checking for flex.exe ... <in default path>
Checking for re2c.exe ... <not found>
Checking for zip.exe ... <in default path>
Checking for lemon.exe ... <not found>
Checking for arpa\nameser.h ... ..\win32build\include
Checking for library resolv.lib ... ..\win32build\lib\resolv.lib
Build dir: Release_TS
PHP Core: php5ts.dll and php5ts.lib
Checking for wspiapi.h ... <in default path>
Enabling IPv6 support
Checking for NewAPIs.h ... <in default path>
Checking for httpd.h ... <in default path>
Checking for library libhttpd.lib ... <in LIB path> libhttpd.lib
Checking for library libapr.lib ... <in LIB path> libapr.lib
Checking for library libaprutil.lib ... <in LIB path> libaprutil.lib
Enabling SAPI sapi\apache2handler
Enabling SAPI sapi\cgi
Enabling SAPI sapi\cli
Enabling extension ext\bcmath
Enabling extension ext\calendar
Checking for library oleaut32.lib ... <in LIB path> OleAut32.Lib
Enabling extension ext\com_dotnet
Checking for mscoree.h ... <in default path>
Enabling extension ext\ctype
Enabling extension ext\ftp
Checking for library libjpeg.lib ... ..\win32build\lib\libjpeg.lib
Checking for library freetype2.lib ... ..\win32build\lib\freetype2.lib
Checking for library libpng.lib ... ..\win32build\lib\libpng.lib
Checking for library zlib.lib ... ..\zlib\zlib.lib
Checking for gd.h ... ext\gd\libgd
Enabling extension ext\gd [shared]
Checking for iconv.h ... ..\win32build\include
Enabling extension ext\iconv
Checking for library libxml2_a.lib;libxml2.lib ...
..\win32build\lib\libxml2_a.lib
Checking for library iconv_a.lib;iconv.lib ... ..\win32build\lib\iconv_a.lib
Checking for libxml/parser.h ... ..\win32build\include
Enabling extension ext\libxml
Checking for library libmysql.lib ... ..\win32build\lib\libmySQL.lib
Checking for mysql.h ... ..\win32build\include
Enabling extension ext\mysql
Enabling extension ext\odbc
Enabling extension ext\pcre
Enabling extension ext\session
Enabling extension ext\spl
Enabling extension ext\sqlite
Enabling extension ext\standard
Enabling extension ext\tokenizer
Enabling extension ext\zlib
Checking for library zlib.lib ... ..\zlib\zlib.lib
Checking for zlib.h ... ..\zlib
Enabling extension ext\dom
Enabling extension ext\simplexml
Enabling extension ext\wddx
Enabling extension ext\xml
Creating build dirs...
Generating files...
Generating Makefile
Generating main/internal_functions.c
[content unchanged; skipping]
Generating main/config.w32.h
Done.
Type 'nmake' to build PHP
--- End Message ---
--- Begin Message ---
Hello list,
While installing php....after i have configured everything, i am not able to get php
running. While trying to run a test page consisting of the code:
<?php
echo "Hello!";
php?>
I get a dialog box saying that "You have chosen to download a file from this
location". Upon opening the file, i get the whole code and not just "Hello".
Please can you tell me what went wrong. I am using PHP 4.3.4, Apache 1.3.2. and
Windows 2000.
Also can u please tell me how do u know that php has been installed in my PC. While
double clicking php.exe, a window gets opened and nothing seems to happen with it. We
have to close it manually. Is it unusual or is it supposed to be like that only.
Please help.
Thanks in advance,
penjo
Yahoo! India Matrimony: Find your life partneronline.
--- End Message ---
