http://www.learnasp.com/learn/dbtroubleshoot2.asp
will be invaluable if you are having SQL troubles,
On Sun, 16 Jan 2005 04:56:46 +0900, Charles Carroll
<[EMAIL PROTECTED]> wrote:
> 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/
