News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Wez Furlong's Blog:
Calling SQLBindParameter and avoiding a datetime overflow.
November 25, 2005 @ 06:44:58

Wez Furlong has this post today with a look at a problem he had with dates and gSOAP.

I've spent a lot of time with ODBC recently, working on interfacing our PostalEngine product with SQL Server. One of the things that caused me a LOT of trouble is binding date/time values into our stored procedure calls. One of the reasons that it was hard work was lack of documentation-by-example.

When this [code] is run, the execute fails with SQLSTATE 22008, Date time overflow. Everything looks correct in the code, and most of the values we're passing are based on the description of the parameter provided by ODBC, so what's going on?

After "several hours", he figures it out, the problem being a result of the precision field. He also includes an example of the "magic number" to put in their field to get things to parse correctly...

0 comments voice your opinion now!
sqlbindparameter SOAP datetime overflow sqlbindparameter SOAP datetime overflow


blog comments powered by Disqus

Similar Posts

Christian Schaefer's Blog: Beware of the timezone! Working with PHP DateTime & Doctrine for MongoDB

Squirrel Hacker Blog: PHP DateTime is missing methods in 5.2

Secunia.com: PHP Integer Overflow Vulnerability and Security Bypass

LaughingMeme.com: Looking at PHP5ís DateTime and DateTimeZone

Hardened-PHP Project: PHP HTML Entity Encoder Heap Overflow Vulnerability


Community Events





Don't see your event here?
Let us know!


composer language version series list framework tool security artisanfiles opinion community conference interview voicesoftheelephpant podcast symfony introduction library release laravel

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework