mssql_query to delete not working.

[ideasworking]

Hello,

About a week or so ago I upgrade PHP to version 5.2 and ever since I have had trouble with mssql_query. I'm trying to delete a record and the query fails to delete the record.

The query looks fine it's....

DELETE FROM GTG_LOG WHERE DateAndTime = '2007-1-8 1:29'

Here's my code. Any idea why this isn't working?
Thanks,
Lou

$RecDate=$_POST['OldRecordDate'];
$FirstofMonth = date("Y-m-d",mktime(0,0,0,date("m",strtotime($RecDate)) ,1,date("Y",strtotime($RecDate)))); 
$db = mssql_connect("SERVER\INSTANCE","sa","*****") or die("Unable to connect to server");
mssql_select_db("Reporting");
$QuerySQL = "DELETE FROM GTG_LOG WHERE DateAndTime = '".Date('Y-n-j G:i',strtotime($RecDate))."'";
$result = mssql_query($QuerySQL,$db) or die('Unable to delete record');
header ("Location: [URL unfurl="true"]http://intranet/logs.php?StartDate=".$FirstofMonth);[/URL]

 

[sleipnir214]

This: 2007-1-8 1:29

likely isn't a well-formatted date/time string.

Try: 2007-01-08 1:29

instead


Want the best answers? Ask the best questions! TANSTAAFL!

 

[ideasworking]

I took your advice and changed the date formatting. Now the query appears as

DELETE FROM [GTG_LOG] WHERE [DateAndTime] = '2007-01-08 01:29'

However it still doesn't work. Any other ideas?

TIA,
Lou

 

[sleipnir214]

If you paste that query into Query Analyzer, does it work?


Want the best answers? Ask the best questions! TANSTAAFL!

 

[ideasworking]

Thank you,

I should have tried that myself. I typically write values to this table that do not have seconds. However when I was making the changes a couple weeks ago I wrote some SPs that included seconds. There was no way that query was going to delete the record for 2007-01-08 01:29:34.

I have made the required changes and it's working ok. Now there are still problems... but I'll start a new post for those.

Thanks again,
Lou