Thanks for your reply Tore, It's sorted now, I found a KB article... http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
and sent that to my hosting company. They acted quickly, impressed. I am having a nightmare though with dates. I have a text area that someone types in the date "07/08/2002". When it gets saved into Access it seems to get changed to "08/07/2002". Although if I orginally typed in "31/08/2002", then the date stays as is. Are there any ways to force the dates to stay in a particular format? Thanks, Nick :> -----Original Message----- :> For SQL Server: :> :> UPDATE Items :> SET Name = 'Squeeky toy', :> FK_User = 12, :> Description = 'blue and white spider', :> Starting_Bid = 4, :> Bid_Increment = 1, :> Image_URL = 'http://localhost/bwe/jon.gif', :> Expires = CONVERT(DateTime, '23/08/2002', 101), :> Active = True :> WHERE Items.PK_ID=1 :> :> HTH, :> Tore. --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
