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")
should be
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)"
and once you fix that you will have the real strSQLafter you add
strSQL2 to end and before you execute it is time to print it.
On Sat, 15 Jan 2005 11:48:28 -0800 (PST), Craig
<[EMAIL PROTECTED]> wrote:
>
> 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
>
>
>
>
>
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/
