Insert into opretter 2 poster hver gang
HejJeg bruger en MSSQL database og hver gang jeg laver en insert laver den 2 poster i databasen.
Her er min kode:
dato = datevalue(replace(request("dato"), ".", "/"))
dato = "" & datepart("YYYY", dato) & "/" & datepart("M", dato) & "/" & datepart("D", dato) & ""
SQL = "Insert into coli (dato, pakkenr1, varenr, beskrivelse, snnote, ref, note, status) Values ('" & dato & "',"
if request("pakkenr") <> "" then
SQL = SQL & "'" & request("pakkenr") & "', "
else
SQL = SQL & "null, "
end if
if request("varenr") <> "" then
SQL = SQL & "'" & request("varenr") & "', "
else
SQL = SQL & "null, "
end if
if request("beskrivelse") <> "" then
SQL = SQL & "'" & request("beskrivelse") & "', "
else
SQL = SQL & "null, "
end if
if request("snnote") <> "" then
SQL = SQL & "'" & request("snnote") & "', "
else
SQL = SQL & "null, "
end if
if request("ref") <> "" then
SQL = SQL & "'" & request("ref") & "', "
else
SQL = SQL & "null, "
end if
if request("note") <> "" then
SQL = SQL & "'" & request("note") & "', "
else
SQL = SQL & "null, "
end if
if request("status") <> "" then
SQL = SQL & "'" & request("status") & "')"
else
SQL = SQL & "null)"
end if
conn.execute(SQL)
response.redirect("indtast.asp")
