If you give me FTP access to your server for 10 minutes when chatting
with me I will fix teh combined code of yours and mine,
On Sun, 16 Jan 2005 09:31:45 +0900, Charles Carroll
<[EMAIL PROTECTED]> wrote:
> 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/
