[PHP-DB] Re: MSSQL date format problem

[Peter Misun]

believe or not, I solved it just by updating from PHP 4.3.1 to 4.3.2 :-)

5o


Peter Misun wrote:

> hi,
>
> I have seen solution for my problem, but I couldn't find and I'm in a hurry - please 
> help.
>
> Problem is, how to set default datetime format while using mssql functions?
> With ODBC, there is format:   -mm-dd hh:mm:ss[.fff]
> but wih using db-library there is:  mmm dd  hh:mmxx   where xx is either AM or PM
> how to set default datetime format?
>
> I have used
>   ini_set("mssql.datetimeconvert","0");
> in my php scripts and it works fine for MSSQL 7, but not for MSSQL 2000
>
> please help
>
> 5o

--

Mgr. Peter Misun
MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia
tel: +421/ 2/ 602 00 127, 111,  fax: +421/ 2/ 602 00 180



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MSSQL date format problem

[Peter Misun]

hi,

I have seen solution for my problem, but I couldn't find and I'm in a hurry - please 
help.

Problem is, how to set default datetime format while using mssql functions?
With ODBC, there is format:   -mm-dd hh:mm:ss[.fff]
but wih using db-library there is:  mmm dd  hh:mmxx   where xx is either AM or PM
how to set default datetime format?

I have used
  ini_set("mssql.datetimeconvert","0");
in my php scripts and it works fine for MSSQL 7, but not for MSSQL 2000

please help

5o



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: header problem with IIS

[Peter Misun]

problem was with switch in W2k server
there is -  Performance Options -> Application response   - and it can be switched to 
"Applications" or "Background services"
after switching from second one to first one (app...), everything works fine now  
(without CGI Error)

5o


Peter Misun wrote:

> running PHP4.1.3 on IIS 5 and everything work's fine
>
> I have only problem with using header() function
> problem is, after submiting form in first.php:
> echo "\n";
> and having in second.php:
>   header('location:third.php');
>
> it produces error in browser like this:
>   CGI Error
>   The specified CGI application misbehaved by not returning a complete set of
>   HTTP headers. The headers it did return are:
>
> what headers?!?
> after reloading/refreshing page by user, everything is ok
>
> in logfiles of IIS I found out, that
>   first.php has protocol code 200
>   second.php has protocol code 302
>   third.php has protocol code 502  (what leads to that error)
>   third.php after refreshing/reloading has protocol code 200
>
> please, help
>
> 5o

--

Mgr. Peter Misun
MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia
tel: +421/ 2/ 602 00 127, 111,  fax: +421/ 2/ 602 00 180



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MS-SQL date format problem

[Peter Misun]

as Robert and me observed (from source code) - that switch isn't there in 4.1.2
after installing 4.3.1 there is no problem with date format - switch is working

5o


Robert Twitty wrote:

> I don't have access to the source code for PHP 4.1.2,  but I would not be
> suprised if this was the case.  However, it is a better practice to use
> CONVERT rather than relying on the underlying driver, that way you will
> always be certain about the format.
>
> -- bob
>
> On Tue, 13 May 2003, Peter Misun wrote:
>
> >
> > ups, i'm using PHP 4.1.2 on Win32
> > maybe that earlier version doesn't support this switch?
> >
> > I can try upgrade but I don't want to - so if you know ...
> >
> > 5o

--

Mgr. Peter Misun
MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia
tel: +421/ 2/ 602 00 127, 111,  fax: +421/ 2/ 602 00 180



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php