har en kod som ser ut som foljer:
<% If Request.QueryString("action") = "check" then
Function SQLSafe(str)
str = Replace(str, "'", "''")
SQLSafe = str
End Function
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=wbsql", "xxx", "xxxx"
email = replace(Request.Form("Email"),"'","''")
OrderID = replace(Request.Form("OrderId"),"'","''")
if Request.Form("email") OR Request.Form("OrderId") = "" then
response.write "False"
else
SQL = "SELECT Customers.C_Email, Orders.CustomerID, Orders.OStatus FROM Customers INNER JOIN Orders ON Customers.customerID = Orders.customerID WHERE Customers.C_email = '" &Email& "' AND Orders.OrderID = " &OrderID
set objRS = Conn.execute(SQL)
If objRS.EOF Then
Response.Write "<br>"
Response.Write "No such Combination"
Else
Response.Write "<br>"
'Response.Write "<br>"
Response.Write "<b>Status:</b> "& objRS("OStatus") &" "
End If
'if NOT rs.eof then
'response.write ("no such tracking number")
end if
end if
%>
problemet e att da de lamnar ett av falten tomma sa far jag ett felmeddelande incorrect type near = sa jag valde att lagga in en if sats under connect men da jag la in den far jag felmeddelandet
Type mismatch: '[string: "asdf"]'