Okay, I'll try that. Thanks for the help.
Dale
dalezjc
Last Activity: Sep 24 '07, 04:19 PM
Joined: Jun 2 '06
Location:
-
Now I'm getting the following error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/staneval/update.asp, line 74
set rsUpdate = conn.Execute "Update usertbl SET written_exam = '" & _ Trim(Request.Fo rm("written_exa m")) & "' " & _Leave a comment:
-
Removed comma and stll the same error.Leave a comment:
-
user_id is a int. And here's the complete error message:
Code:Microsoft VBScript compilation error '800a0401' Expected end of statement /staneval/update.asp, line 74 set rsUpdate = conn.Execute "Update usertbl SET written_exam = '" & Trim(Request.Form("written_exam")) & "' , " & _Leave a comment:
-
Update Query Help
Hi,
I searched the forum for answer to this, but couldn't fnd anything, although there were some articles that came close.
Below is my update query code, but I keep getting "expected end of statement" errors. I'm a newbie to ASP so I assume it's a syntax error of some sort.
...Code:set Conn=Server.CreateObject("ADODB.Connection") set rsUpdate = server.CreateObject("ADODB.Recordset") -
Okay, got it working with the following:
...Code:if request("lastname") <> "" AND request("overall_qual") <> "" AND request("eval_type") <> "" AND request("existing_certs") <> "" then SQL = SQL & " (location LIKE '" & Request("location") &"') AND (grade LIKE '" & Request("grade")Leave a comment:
-
Thanks for suggestions Jared. I like your style. Now I'm trying to combine the following queries, but am getting an error message:
if (request("lastn ame") AND request("overal l_qual") AND request("eval_t ype") AND request("existi ng_certs") ) <> "" then
SQL = SQL & " (location LIKE '" & Request("locati on") AND grade LIKE '" & Request("grade" ))...Leave a comment:
-
Combination Quries
I'm building my first query form in ASP and it's going to be a combination search form. My search form has the following fields: lastname, qualification, location, grade, certifications, and eval_type.
I'm a newbie to ASP so this is probably not the way to be doing this, but here's what I have so far:
[code=asp]<%
'Search for lastname only
If overall_qual = "" AND location = "" AND grade...
No activity results to display
Leave a comment: