as long as you response.write strSQL before executing it all things
will be clear and you and I can discuss if there is anything
incomplete about the strSQL.
On Sat, 15 Jan 2005 06:04:53 -0800 (PST), Craig
<[EMAIL PROTECTED]> wrote:
> 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 the Yahoo! Terms of Service.
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/
