problem med sql (mysql)
HejJeg har lidt problemer med at få noget sql kode til at virke, håber en her kan give mig en hånd. Hele koden er:
<% if mode = "submit_person" then %>
<%
SQL = "Update ind_ordre SET design_per='"& Request.Form("add_person") &"' WHERE ordre_nr ="& Request.QueryString("ordrenr") & ";"
strName = Request.Form("add_person")
response.write SQL
Conn.execute SQL
Conn.Close
set Conn = Nothing%>
The design person has been addet/edited:<br>
<% response.write strName %>
<%
SQL = "Select * From userlist where FullName="& strName & ";"
set rs = Conn.execute(SQL)
%>
<%=rs("loginname")%>
<%Conn.close%>
<%Response.Redirect "ordre_list_admin.asp?mode=show&ordrenr=" & Request.Querystring("ordrenr")%>
<% end if %>
den del der giver problemer :
<% response.write strName %>
<%
SQL = "Select * From userlist where FullName="& strName & ";"
set rs = Conn.execute(SQL)
%>
<%=rs("loginname")%>
<%Conn.close%>
jeg får denne fejl:
Microsoft VBScript runtime error '800a01a8'
Object required
/system/ordre_list_admin.asp, line 844
linie 844 er:
set rs = Conn.execute(SQL)
hva er problemet?
