Værdi af Tekstfelt til Select value
Følgende kode (test2.asp):<%@LANGUAGE=\"VBSCRIPT\"%><%
\' *** Update Record: construct a sql update statement and execute it
MM_editAction = CStr(Request(\"URL\"))
If (Request.QueryString <> \"\") Then
MM_editAction = MM_editAction & \"?\" & Request.QueryString
End If
If (CStr(Request(\"MM_update\")) <> \"\" And CStr(Request(\"MM_recordId\")) <> \"\") Then
MM_tableName = \"tabel001\"
MM_tableCol = \"ID\"
MM_recordId = \"\" + Request.Form(\"MM_recordId\") + \"\"
MM_fields = \"select,Pris1,none,none,NULL\"
MM_redirectPage = \"\"
\' create the sql update statement
MM_updateStr = \"update \" & MM_tableName & \" set \"
MM_fieldsArray = Split(MM_fields, \",\")
For i = LBound(MM_fieldsArray) To UBound(MM_fieldsArray) Step 5
FormVal = CStr(Request.Form(MM_fieldsArray(i)))
Delim = MM_fieldsArray(i+2)
If (Delim = \"none\") Then Delim = \"\"
AltVal = MM_fieldsArray(i+3)
If (AltVal = \"none\") Then AltVal = \"\"
EmptyVal = MM_fieldsArray(i+4)
If (EmptyVal = \"none\") Then EmptyVal = \"\"
If (FormVal = \"\") Then
FormVal = EmptyVal
Else
If (AltVal <> \"\") Then
FormVal = AltVal
ElseIf (Delim = \"\'\") Then \' escape quotes
FormVal = \"\'\" & Replace(FormVal,\"\'\",\"\'\'\") & \"\'\"
Else
FormVal = Delim + FormVal + Delim
End If
End If
If (i <> LBound(MM_fieldsArray)) Then
MM_updateStr = MM_updateStr & \",\"
End If
MM_updateStr = MM_updateStr & MM_fieldsArray(i+1) & \" = \" & FormVal
Next
MM_updateStr = MM_updateStr & \" where \" & MM_tableCol & \" = \" & MM_recordId
\' finish the sql and execute it
Set MM_updateCmd = Server.CreateObject(\"ADODB.Command\")
MM_updateCmd.ActiveConnection = \"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\xxxxxxxxx\\test.mdb\"
MM_updateCmd.CommandText = MM_updateStr
MM_updateCmd.Execute
End If
%> <%
set Recordset1 = Server.CreateObject(\"ADODB.Recordset\")
Recordset1.ActiveConnection = \"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\xxxxxxxxxxx\\test.mdb\"
Recordset1.Source = \"SELECT * FROM tabel001\"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open
Recordset1_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
</head>
<body bgcolor=\"#FFFFFF\">
<form name=\"form001\" method=\"post\" action=\"<%=MM_editAction%>\">
<p>ID =
<input type=\"text\" name=\"textfield\" value=\"<%=(Recordset1.Fields.Item(\"ID\").Value)%>\">
</p>
<p>Pris 1 =
<input type=\"text\" name=\"pris1\">
<br>
Pris 2 =
<input type=\"text\" name=\"pris2\">
<br>
<br>
Selct =
<select name=\"select\">
<option value=\"java script:document.form001.pris1.value\">Pris
1</option>
<option value=\"java script:document.form001.pris2.value\">Pris
2</option>
</select>
<br>
<br>
<input type=\"submit\" name=\"Submit\" value=\"Submit\">
</p>
<input type=\"hidden\" name=\"MM_recordId\" value=\"<%= Recordset1.Fields.Item(\"ID\").Value %>\">
<input type=\"hidden\" name=\"MM_update\" value=\"true\">
</form>
</body>
</html>
Giver følgende fejl:
Microsoft JET Database Engine fejl \'80040e14\'
Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket \"java script:document.form001.pris1.value\".
/wu2000/www/test/TMP9esrs2fb96.asp, linje 48
Hvad er problemet???????
