I think I understand what you mean. I added
response.write strSQL into the page, hopefully in the
correct position. (Complete updated page is at bottom
of post)
I tried the page to see if it was working. I received
and error.
***********************************
Error Type:
Active Server Pages, ASP 0116 (0x80004005)
The Script block lacks the close of script tag (%>).
/morrie/processingpage1.asp, line 4
***********************************
I thought it was suppose to go at the end of the page
so I added it there.
***********************************
Reran the page and received a new error.
***********************************
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/morrie/processingpage1.asp, line 16, column 32
strSQL = "Insert INTO answers ("mpt01, mpt02, mpt03,
mpt04, mpt05, mpt06, mpt07, mpt08, mpt09, mpt10,
mpt11, mpt12, mpr01, mpr02, mpr03, mpr04, mpr05,
mpr06, mpr07, mpr08, mpr09, mpr10, mpr11, mpr12)
***********************************
Added the � after mpr12
Looked back at your example on hidden files and the
debugging page to try and figure out why it would give
that �Expected end of statement� error. I�m guessing
it�s because of
Insert INTO answers (�mpt01, mpt02�) strSQL2=�Values
(�
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/morrie/processingpage1.asp, line 16, column 32
strSQL = "Insert INTO answers ("mpt01, mpt02, mpt03,
mpt04, mpt05, mpt06, mpt07, mpt08, mpt09, mpt10,
mpt11, mpt12, mpr01, mpr02, mpr03, mpr04, mpr05,
mpr06, mpr07, mpr08, mpr09, mpr10, mpr11, mpr12")
Not sure how to fix this. Should it be something like
this?
Values(�<%=mpt01%>, <%=mpt02%>�)
***********************************
Any Suggestions?
***********************************
<HTML><HEAD>
<TITLE>processingformalpha.asp</TITLE>
<body bgcolor="#FFFFFF"></HEAD>
<%
accessdb=server.mappath("morriedb.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE="
strconn=strconn & accessDB & ";"
'strconn=strconn & "USER ID=;PASSWORD=;"
mySQL="select * from answers"
call query2table(mySQL,strconn)
response.write strSQL
strSQL = "Insert INTO answers ("mpt01, mpt02, mpt03,
mpt04, mpt05, mpt06, mpt07, mpt08, mpt09, mpt10,
mpt11, mpt12, mpr01, mpr02, mpr03, mpr04, mpr05,
mpr06, mpr07, mpr08, mpr09, mpr10, mpr11, mpr12")
strSQL2="VALUES ("
strSQL = strSQL & ",[mpt01]"
strSQL2 = strSQL2 & "'" & request.form("mpt01") & "'"
strSQL = strSQL & ",[mpt02]"
strSQL2 = strSQL2 & "'" & request.form("mpt02") & "'"
strSQL = strSQL & ",[mpt03]"
strSQL2 = strSQL2 & "'" & request.form("mpt03") & "'"
strSQL = strSQL & ",[mpt03]"
strSQL2 = strSQL2 & "'" & request.form("mpt03") & "'"
strSQL = strSQL & ",[mpt04]"
strSQL2 = strSQL2 & "'" & request.form("mpt04") & "'"
strSQL = strSQL & ",[mpt05]"
strSQL2 = strSQL2 & "'" & request.form("mpt05") & "'"
strSQL = strSQL & ",[mpt06]"
strSQL2 = strSQL2 & "'" & request.form("mpt06") & "'"
strSQL = strSQL & ",[mpt07]"
strSQL2 = strSQL2 & "'" & request.form("mpt07") & "'"
strSQL = strSQL & ",[mpt08]"
strSQL2 = strSQL2 & "'" & request.form("mpt08") & "'"
strSQL = strSQL & ",[mpt09]"
strSQL2 = strSQL2 & "'" & request.form("mpt09") & "'"
strSQL = strSQL & ",[mpt10]"
strSQL2 = strSQL2 & "'" & request.form("mpt10") & "'"
strSQL = strSQL & ",[mpt11]"
strSQL2 = strSQL2 & "'" & request.form("mpt11") & "'"
strSQL = strSQL & ",[mpt12]"
strSQL2 = strSQL2 & "'" & request.form("mpt12") & "'"
strSQL = strSQL & ",[mpr01]"
strSQL2 = strSQL2 & "'" & request.form("mpr01") & "'"
strSQL = strSQL & ",[mpr02]"
strSQL2 = strSQL2 & "'" & request.form("mpr02") & "'"
strSQL = strSQL & ",[mpr03]"
strSQL2 = strSQL2 & "'" & request.form("mpr03") & "'"
strSQL = strSQL & ",[mpr04]"
strSQL2 = strSQL2 & "'" & request.form("mpr04") & "'"
strSQL = strSQL & ",[mpr05]"
strSQL2 = strSQL2 & "'" & request.form("mpr05") & "'"
strSQL = strSQL & ",[mpr06]"
strSQL2 = strSQL2 & "'" & request.form("mpr06") & "'"
strSQL = strSQL & ",[mpr07]"
strSQL2 = strSQL2 & "'" & request.form("mpr07") & "'"
strSQL = strSQL & ",[mpr08]"
strSQL2 = strSQL2 & "'" & request.form("mpr08") & "'"
strSQL = strSQL & ",[mpr09]"
strSQL2 = strSQL2 & "'" & request.form("mpr09") & "'"
strSQL = strSQL & ",[mpr10]"
strSQL2 = strSQL2 & "'" & request.form("mpr10") & "'"
strSQL = strSQL & ",[mpr11]"
strSQL2 = strSQL2 & "'" & request.form("mpr11") & "'"
strSQL = strSQL & ",[mpr12]"
strSQL2 = strSQL2 & "'" & request.form("mpr12") & "'"
can be replaced with
FOR counter=2 To 12
if counter <10 then
paddedcounter="0" & counter
else
paddedcounter=counter
end if
strSQL = strSQL & ",[mpr" & paddedcounter & "]"
strSQL2 = strSQL2 & "'" & request.form("mpr" &
paddedcounter) & "'"
<!--#include virtual="Connections/lib_dbtable.asp"-->
</BODY>
</HTML>
%>
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
