Posted By

krisdb on 03/08/07


Tagged

sql


Versions (?)

Update


 / Published in: SQL
 

  1. strsql = "update Events set " &_
  2. "eventTitle = '"&StripTicks(request.form("eventTitle"))&"'," &_
  3. "shortDescription = '"&StripTicks(request.form("eventShortDesc"))&"'," &_
  4. "longDescription = '"&StripTicks(request.form("eventLongDesc"))&"'," &_
  5. "startdate = '"&sEventDateStart&"'," &_
  6. "enddate = '"&sEventDateEnd&"'," &_
  7. "startTime = '"&request.form("eventStartTime")&"'," &_
  8. "endTime = '"&request.form("eventEndTime")&"', " &_
  9. "keywords = '"&StripTicks(request.form("eventsKeywords"))&"' " &_
  10. "where eventId = " &eventId
  11. updateDatabase(strsql)

Report this snippet  

You need to login to post a comment.