Weird SQL bug with page

[ironhide1975]

Just trying to do an simple update script with my ASP page and when it gets to this update it just hangs and then I get a timeout error.

UPDATE [Page_Content] set DateOff = '03/31/2008 12:00:00 AM' WHERE ContentID = '472'

I can copy this and it works fine if I execute it in SQL Query Manager, but for some reason the ASP page hangs and its a simple update and execute.

Any ideas?

Login user is DBO all priviledges as well.

 

[xwb]

What is DateOff? Is it a string or a date field? If it is a date field, you may need to convert it to a date first.

Have a look at dateformat and convert.

 

[ironhide1975]

Actually found out I was trying to update a record set while trying to loop through it. This caused the hang. I put the primary key in an array and updated them later and that worked.