All pastes #427246 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-04-06 18:15 UTC
rendered paste body
  alternativid = 0
  overskrift = ret(request.form("overskrift"))
  beskrivelse = ret(request.form("beskrivelse"))
  tekst = ret(request.form("editorinput"))
  vis = request.form("vis")
  dato = date()
  tid = time()
  
  if vis = "on" then
    vis = "Ja"
  else
    vis = "Nej"
  end if
  
  sql = "insert into " & ownerTName & " (alternativid, overskrift, beskrivelse, tekst, vis, dato, tid) values (" & alternativid & ", '" & overskrift & "', '" & beskrivelse & "', '" & tekst & "', '" & vis & "', '" & dato & "', '" & tid & "')"
  conn.execute(sql)
  
  sql = "select * from " & ownerTName & " where alternativid = " & alternativid
  set rs = conn.execute(sql)
  
  id = rs("id")
  alternativid = id
  
  sql = "update " & ownerTName & " set alternativid = '" & alternativid & "' where id = " & id
  conn.execute(sql)
  
  conn.close
  set conn = nothing
  
  response.redirect(docName)