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.
-----Original Message-----
From: Nick Middleweek [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 9:50 AM
To: ActiveServerPages
Subject: RE: Problems with UPDATE ? - Dates?
Hello again!
What other ways are there to insert dates in SQL strings?
I mean I've used the following...
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 = '23/08/2002', Active = True WHERE
Items.PK_ID=1
Are there any other ways to do this?
Thanks,
Nick
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
