ASP mellemrum
Hvorfor indsætter den mellemrum foran code_no og item når der skrives ny record???<%
for i = 0 To 30
Set myConn = Server.CreateObject("ADODB.Connection")
myconn.open "DBQ=xxx.mdb;Driver={Microsoft Access Driver (*.mdb)};"
good = server.HTMLEncode(Request.Form("number" & i))
If good <> "" then
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM sold WHERE code_no = '" & good & "'"
rs.Open strSQL, myConn, 3, 3
If Not (rs.BOF Or rs.EOF) Then
rs("hits") = rs("hits") + 1
rs.Update
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
Else
rs.addnew
rs("item") = server.HTMLEncode(Request.Form("item" & i))
rs("code_no") = server.HTMLEncode(Request.Form("number" & i))
rs("hits") = 1
rs.Update
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
End If
End If
next
%>
