Hi,

Added a "Last Modified #####" tag to each content item in the content list. Just realised that the modified date isnt actually updating when making changes.

Just a quick question really, can I achieve the updating of the date in the SQL Stored Proc or do I need to do this in my code i.e =now()

Think I can fiugre the rest out.

Thanks,

Imar,

Ignore me :o) - just had to engage my brain

Just changed the InsertUpdateSingleItem stored proc to:

  UPDATE [Content]
  SET Title = @title, IntroText = @introText, BodyText = @bodyText, ContentTypeId = @contentTypeId, CategoryId = @categoryId, Visible = @visible,
                        UpdateDateTime = { fn NOW() }
  WHERE (Id = @id)

which works fine.

Thanks

Thanks for the update. Glad you got it working with { fn NOW() }. Didn't know that existed; I always use GetDate() or Current_Timestamp instead.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.