Hjælp med indsættelse af data i DB via ASP!
Jeg har to sider...I den ene ser det sådan her ud:
<%
If Session("login") = "JA" Then
Session("Customer") = request.querystring("customer")
Session("login") = "JA"
Session.Timeout = 30
Else
Session("login") = "NEJ"
Session.Timeout = 30
Response.Redirect "http://www.dr.dk"
End If
%>
Du er logget ind som <% response.write Session("Customer")%>
<form method="POST" action="createorder.asp">
<input type="text" name="CustomerRef">
<input type="text" name="T1" size="20">
<input type="submit" value="Ok" name="Ok">
Det ser fint nok ud, så er der den anden fil:
<%
If Session("login") = "JA" Then
Session("login") = "JA"
Session("Customer") = request.querystring("customer")
Session.Timeout = 30
Else
Session("login") = "NEJ"
Session.Timeout = 30
Response.Redirect "http://www.dr.dk"
End If
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../cgi-data/database.mdb")
Conn.Open DSN
strSQL = "Insert into orderliste ("
strSQL = strSQL & "customer, "
strSQL = strSQL & "CustomerRef, "
strSQL = strSQL & "status, "
strSQL = strSQL & "dato, "
strSQL = strSQL & "sælger) "
strSQL = strSQL & "values( "
strSQL = strSQL & Session("Customer"),
strSQL = strSQL & Request.form("CustomerRef"),
strSQL = strSQL & "'Ingen', "
strSQL = strSQL & "'10-10-2004', "
strSQL = strSQL & "'Domino')"
conn.Execute(strSQL)
set rsCreateOrder = Nothing
set Conn = Nothing
Response.Redirect "Opslag.asp"
%>
Men det virker ikke...... hvorfor???
