ID: 27465 User updated by: gary at koning dot com Reported By: gary at koning dot com -Status: Feedback +Status: Bogus Bug Type: ODBC related Operating System: win2k PHP Version: 4.3.4 New Comment:
after more testing, ereg() does not seem to be the problem Previous Comments: ------------------------------------------------------------------------ [2004-03-02 13:35:40] [EMAIL PROTECTED] Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2004-03-02 13:31:55] gary at koning dot com Description: ------------ I am converting an application to win2k/mssql from linux/mysql. Using ereg to validate form field data. Getting unuasual error message from the win2k odbc driver. Reproduce code: --------------- Validation code: if( !ereg("^([EMAIL PROTECTED],18})$",$stmp) ) Using odbc_do(), almost any simple query returning rows will result in the driver throwing an error message like: "Error converting data type varchar to numeric" I say almost because sometimes a row of data was returned. But even then, reloading the script would give the above error. Expected result: ---------------- Valid data from the odbc driver or a known error message. Actual result: -------------- Removing the call to ereg() will cause the query to return proper data. No further info at this time. (Took me 2 days to track this down). I beleive an old copy of active perl is installed on this box, if that has any bearing. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27465&edit=1