|
| |
PLEASE HELP ME IN "Microsoft VBScript compilation (0x800A0400)Expected statement"
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
kinyee
Posts: 5
Joined: 4/6/2008
Status: offline
 |
PLEASE HELP ME IN "Microsoft VBScript compilation ... - 4/6/2008 21:01:33
THIS IS MY ERROR TYPE
Microsoft VBScript compilation (0x800A0400)
Expected statement
/order/updatemonthly.asp, line 68
" values (" & Request.Form("date") &" ," & _
AND THIS IS MY STATEMENT
<%
set rs = conntemp.Execute("SELECT * FROM MonthlyReport")
Progress_date = request.form("date")
Math = request.form("math")
BM = request.form("bm")
English = request.form("eng")
Physical_education = request.form("physical")
Child_id = request.form("cid")
Staff_id = request.form("sid")
conntemp.Execute '"Insert into MonthlyReport (Progress_date,Math,BM,English,Physical_education,Child_id,Staff_id)"' & _
" values ('" & Request.Form("date") &"' ," & _
" '" & Request.Form("math") & "'," & _
" '" & Request.Form("bm") &" '," &_
" '" & Request.Form("eng") &"'," &_
" '" & Request.Form("physical") & "'," &_
" '" & Request.Form("cid") & "'," &_ " '" & Request.Form("sid") & "')"
%>
I DUN KNOW WHAT IS HAPPEN TO THE STATEMENT...PLEASE HELP!!THANK YOU.
|
|
|
|
kinyee
Posts: 5
Joined: 4/6/2008
Status: offline
|
RE: PLEASE HELP ME IN "Microsoft VBScript compilat... - 4/6/2008 21:15:32
thanks for remind but i still cannot solve my problem which is
" values ('" & Request.Form("date") &"' ," & _
| |
|
|
|
kinyee
Posts: 5
Joined: 4/6/2008
Status: offline
|
RE: PLEASE HELP ME IN "Microsoft VBScript compilat... - 4/6/2008 23:46:45
yaya..i still get the same problem as 1st i get
| |
|
|
|
kinyee
Posts: 5
Joined: 4/6/2008
Status: offline
|
RE: PLEASE HELP ME IN "Microsoft VBScript compilat... - 4/7/2008 9:28:12
If I move out the '
it will show this statement
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/kindergarten/updatemonthly.asp, line 57
| |
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: PLEASE HELP ME IN "Microsoft VBScript compilat... - 4/7/2008 15:09:44
If you do it this way, what does the SQL string say when you view the web page?
sSQL = "Insert into MonthlyReport (Progress_date,Math,BM,English,Physical_education,Child_id,Staff_id)" & _
" values ('" & Request.Form("date") &"' ," & _
" '" & Request.Form("math") & "'," & _
" '" & Request.Form("bm") &" '," &_
" '" & Request.Form("eng") &"'," &_
" '" & Request.Form("physical") & "'," &_
" '" & Request.Form("cid") & "'," &_
" '" & Request.Form("sid") & "')"
response.write sSQL
response.end
conntemp.Execute (sSQL)
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
