I got the fix but after I got lost.
I need to add:
********************************************************
strSQL2 to end
********************************************************
Or
strSQL2 to the end
Example:
strSQL = strSQL & ",[mpr12]"
strSQL2 = strSQL2 & "'" & request.form("mpr12") & "'"
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) & "'"
strSQL2 to end
<!--#include virtual="Connections/lib_dbtable.asp"-->
</BODY>
</HTML>
%>
********************************************************
When you say I need to print it do you mean like a
hardcopy so I can check for errors against that second
page you gave me? Or print to screen using a debugger
to look for errors? Or does print have another meaning
and I'm completely missing the point. I did look over
the page you have about SQL mistakes everyone makes.
I may have side stepped those.
********************************************************
I know i have questions on other things and I'm not
sure if I should be asking them now or later so I'll
just throw them out there.
********************************************************
A)I used a form action on the last processing pages to
forward to the following page. I don't know how to do
that with the set up now. I'll try and find that on
your webpage later today. I know most of the answers
are on there some place it's just a matter of me
figuring out what I'm really asking so I can look it
up.
B) Should I be using the connection string on each
processing page or just call a seperate .asp page to
connect to the db so I don't have to change all pages
if something changes with the connection
string/settings? <!--#include
virtual="Connections/morriedb.asp"-->
C) Is using processing the pages the way to go or
should I really be integrating it into the pages that
have the questions themselves? I was told a long time
ago to use processing pages. The justification was
that a heavy load of questions on one page, fifty for
example, will significantly strain the server and
increase page load times. Where as if you use
processing pages it smooths things out because the
page doesn't handle as much. I could see where using
SQL could nullify that these problems.
I sorta feel like I'm in over my head and drowning and
you keep pushing my head up above water. =) I'm
trying to swim I just keep needing the little arm
floaties.
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
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/
