On Sat, 15 Jan 2005 12:49:38 -0800 (PST), Craig
<[EMAIL PROTECTED]> wrote:
> 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) & "'"
>
strSQL=strSQL & strSQL2
response.write strSQL
> <!--#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?
response.write strSQL
will give you chance with your eyes and my eyes to see if your code
constructed a correct SQL statement
> 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.
Processing pages are fine. You have been given incorrect advice.
and 50 fields are just one updates statement to DB same as 2 fields.
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/
