Benjamin-
first of all, the ADODB that ruprecht is talking about is different than the
one i'm talking about. go to http://php.weblogs.com/ADODB for the one i'm
talking about. the one i'm talking about does have support for the one he's
talking about built in, though. the one i'm talking about is what appears
to be a decent attempt to standardize all of the DB functions/extensions in
php into a set of DB calls that could potentially be used on any database,
as long as you had the right extensions loaded already. basically it
defines a few of the standard DB functions connect(), execute($somequery),
close, etc... and depending on what DB type you pass it, these standard
functions wrap around the appropriate DB functions for your DB (like
mysql_connect(), mssql_query(), ovrimos_execute(), etc...) so it turns out
that using this package doesn't help me, because it's still limited by the
functionality of mssql_*() functions.
what limits do i speak of? 2 in particular (in the current php -> they
should be gone by 4.3)
1. if a table in your DB has a column full of MSSQL's 'real' type, if the
precision of the data is too high, like 3.4439999932, php just straight up
crashes. no error log, no nuthin.
workaround: instead of "Select real1, string1 from table", do "select
round(real1,{some lower precision}), string1 from table"
2. if you have multiple SQL statments in a call to mssql_query(), and some
of them don't actually return a result set like:
mssql_query("declare var1 float
set var1=12.34
select var1 as var");
mssql_next_result() won't do the right thing and you won't be able to get to
the result set generated by the last statement. Also, for some reason, when
this problem occurs, it causes all subsequent mssql_*() functions to do
zilch. workaround: figure out a way to only have 1 SQL statement per call
to mssql_query() (not easy sometimes depending on what you're doing)
well, this has been long, but i hope informative, too.
-jerome
----Original Message Follows----
From: Ruprecht Helms <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Benjamin Walling <[EMAIL PROTECTED]>
Hi Benjamin Walling,
> I'm starting to migrate from ASP to PHP. What are you finding that you
> can't to with mssql_*? I'd be interested in knowing what limitations I
may
> be facing.
By myself I'm using ADODB in my actual Project. But this Project
is in VBA based on Access. ADO itselv consits of ActiveX-Components and
I don't know of the securance of this Components at the moment. From MS
you can hear from time to time that are always big bugs in Security.
For example Exchange-Server, IIS, SQL-Server, ...
To take PHP is the right way. I suggest you take mysql (Linux-Version),
Adabas D or Oracle as database and connect it with php. Then you have
less trouble in security. The linuxbased mysqlversion is much stable
and is freeware (the win-version of mysql is shareware).
Regards,
Ruprecht
----------------------------------
E-Mail: Ruprecht Helms <[EMAIL PROTECTED]>
Date: 18-May-02
Time: 09:39:50
to be informed -> http://www.rheyn.de <-
This message was sent by XFMail
----------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
