php-windows Digest 18 Sep 2005 20:36:04 -0000 Issue 2778
Topics (messages 26354 through 26356):
Re: Calling MSSQL Stored Procedure
26354 by: Robert Twitty
26355 by: Alf Stockton
Re: FrontPage or something else?
26356 by: Armando
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 ---
Hi Alf
The ODBTP client works on all platforms. It includes a Win32 PHP
extension (php_odbtp.dll). If you install it, you may find that it
will produce better reslts than the packaged mssql extesnion under
Windows. The reason is because the PHP win32 mssql extension was built
with DB-Library, which Microsoft stop supporting after SQL Server 6.5.
Try setting $ActualDate to an ISO date string: "YYYY-MM-DD HH:MM:SS" Note,
use 24hr time values. I tested it with the mssql driver, and it works.
-- bob
> >
> Thank you Bob. I decided to try it without the odbtp as I only found
> source files at http://odbtp.sourceforge.net which looked like they
> needed building on Linux and my problem does not include Linux. ie
> Neither the client nor the server is a Linux/Unix machine.
>
> Long story short; your alteration to my code altered the results to the
> following :-
>
> InParameter($stmt, $php_var='1126950445', $name='Today', $maxLen=4000,
> $type=56);
> OutParameter($stmt, $php_var='', $name='RETURN_VALUE', $maxLen=4000,
> $type=47);
> ------------------------------------------------------------------------
> (mssql): spGetActivePromotions ||
> ------------------------------------------------------------------------
> 8144: Procedure or function spGetActivePromotions has too many arguments
> specified.
>
> and when I go to google to find out what "8144: Procedure or function"
> really means I find Microsoft link, support.microsoft.com/?kbid=885712
> which tells me :-
>
> You receive this error message in the *Microsoft SQL-DMO (ODBC SQLState:
> 42000)* dialog box. This problem occurs if there are more than 16 files
> in the database that you try to attach, including the data files and the
> log files in the database.
>
> Comments/suggestions please.BTW. The important part of your
> correction/suggestion was the PrepareSP rather than Prepare and the
> $ActualDate = time();
>
> --
>
> Regards,
> Alf Stockton www.stockton.co.za
>
> Q: What is the difference between Texas and yogurt?
> A: Yogurt has culture.
>
> My email disclaimer is available at www.stockton.co.za/disclaimer.html
>
>
--- End Message ---
--- Begin Message ---
Robert Twitty wrote:
Hi Alf
The ODBTP client works on all platforms. It includes a Win32 PHP
extension (php_odbtp.dll). If you install it, you may find that it
will produce better reslts than the packaged mssql extesnion under
Windows. The reason is because the PHP win32 mssql extension was built
with DB-Library, which Microsoft stop supporting after SQL Server 6.5.
I am attempting the above and I copied the php_odbtp_mssql.dll into
c:\php\ext and altered the php.ini but now I need to know what do I set
the $driver= in my php script to. It is currently set to $driver=mssql
and I cannot find an ODBTP alternative & when I restart Apache, Apache
keeps telling me it cannot find php_odbtp_mssql.dll. Even when I restart
the server.
--
Regards,
Alf Stockton www.stockton.co.za
I must have a prodigious quantity of mind; it takes me as much as a
week sometimes to make it up.
-- Mark Twain, "The Innocents Abroad"
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
I can't (and wouldn't try to) speak for anyone else.. but I'd avoid FP
like the plague. I myself mostly do coding by hand with Vim to do the
majority of my development, though it's not designed to be a development
platform.
I've assisted people in developing web/database enabled sites where
their primary tool was FP and it was frustrating to say the least. FP
tends to put in a lot of fluff that you don't need, and it's pretty
pathetic when trying to do anything more difficult than basic
select/insert/update/delete SQL queries.
Also to consider is, if you develop in ASP.NET, you may lock yourself
out of the multi-platform capability of your app, which will effectively
limit the audience of people able to use it. Naturally MS is going to
tell you ASP.NET is the best way to do it, because once you do, the
amount of work you'd have to do to move it to a different platform would
be astronomical.
If you really want the application to live a long time, your best bet is
to develop it with open and universally accepted standards (I recommend
having it checked against W3C's site for conformance), so that it is not
only cross-browser compatible, but cross-platform compatible as well.
In my personal experience, the majority of sites I develop (unless
there's a specific reason not to make them so) run perfectly well in
either a Windows- or Linux-based operating system environment.
I'm sure there are tons of viable development environments for what
you're looking for, so hop on over to sourceforge and check it out. As
for your web pages, remember they do not need to be 'rich' to be user
friendly. I often find that people get annoyed with the flashiness of
websites because there's often too much. There's absolutely nothing
wrong with richness in your web app, but keep it limited and keep it
simple. That will keep the users happy and wanting to use it. Cheers!
Armando
Tony Aldemir wrote:
Hi There,
I am trying to decide what software to use along with PHP so that I can
create a decent looking/rich WEB enabled and database aware application for
my end-users.
It seems that trying to develop rather sophisticated/user friendly and rich
WEB pages using raw html code intermingled with PHP code would be
practically prohibitive due to its labor intensity. Plus you have to know
all that html jazz to make your pages look rich and professional.
Long story short, I went to Microsoft's WEB site to see if I can use
FrontPage2003 in conjunction with PHP. The answer is "YES", after making
some config. Changes to FrontPage (e.g. disabling ASP.NET capabilities of
FP, etc.). However, Microsoft was also very quick to turn around and
suggest I the same article that ASP.NET may be a much better direction to go
in order to develop database aware WEB site capabilities/apps. That are also
rich and professional looking.
I felt rather disappointed, after thinking that I finally found a very cost
effective way to develop WEB enabled apps. (i.e. PHP + Apache + MySQL), I am
not sure anymore.
I am also concerned about making my WEB app. multi DB capable. That brought
in the ADODB libs., and I am yet to successfully connect to MySQL DB using
ADODB (i.e. adodb.inc.php), but that is another subject to discuss.
The bottom line question I have is this: What is recommended by the PHP
gurus, who have been successfully using PHP for quite a while? What
software tool(s) is suggested to build function rich, database capable,
robust WEB applications that are also intuitive and user friendly due to
their presentation layer being strong and rich (e.g. forms, etc.)?
Sorry for the length of this email, but I believe this is an important
decision to make before I start investing my blood and tears into an
application that hopefully will live relatively long life instead of
becoming obsolete in a couple of years.
Any suggestions or guidance would be greatly appreciated.
Kind Regards,
Tony Aldemir
--- End Message ---
