So it's pretty obvious I need to do this in babysteps!
********************************************************
Steps
********************************************************
1) Make sure this form is right...(Insert laughter
here)....er I mean trouble shoot! =)
2) Edit the included lib_dbtable? Not sure if I need
to but I see there is a thisvalue in there. If I do
have to edit it do I need to edit it for each page I
make that calls it?
3) Put the submit for the subnum to be posted to the
next page into the form.
4) Give a sacrifice to the computer gods
********************************************************
New Processing Form
I didn't even try and run it I know there are probably
basic errors in it.
Questions:
1) Do I need to put values into the Values(" or is
that filled in with the statments that follow it?
2) I tried to use your better idea but I wasn't sure
if I closed it properly or if I missed any parts. =/
3) Am I gaining any ground =) hehe
********************************************************
<HTML><HEAD>
<TITLE>nwind.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)
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 & q & request.form("mpr" &
paddedcounter) & q
<!--#include virtual="Connections/lib_dbtable.asp"-->
</BODY>
</HTML>
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
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/
