Re: [PHP-WIN] Script doesn't write to database...

2002-07-09 Thread Mathew Joseph
does it show an error or warning ? use mssql_rows_affected() and find if any row was affected. try using mssql_get_last_message() and find if any message was sent by the server. Mathew At 09:17 AM 7/9/2002 -0500, you wrote: >Mathew, > >Thanks for your reply. > >I have another table in the sam

Re: [PHP-WIN] Script doesn't write to database...

2002-07-09 Thread Mathew Joseph
i have a feeling that your database doesnt commit by default. you may have to explicitly call commit from ur PHP scripts or set auto_commit in ur sql server. Ofcourse if other update statements of yours are working without an explicit commit then i cant find anything wrong with ur code. Mathew

[PHP-WIN] Script doesn't write to database...

2002-07-09 Thread R.S. Herhuth
I have put together this script to read a row of data from SQL Server, perform a calculation and write back the results. the read and calculation are working but it doesn't write the data to SQL Server...what am I doing wrong here? CityStateZipLongitudeLatitudeLongitude RadiansLatitude Radians