[thelist] ASP frustrations

[Salvatore Palmisano]

It really comes down to how you are updating the database table.  Are you
using straight SQL, or an rs.Update (or rs.Insert) method.
If records are being overwritten it sounds like an update (alter existing
record) method is being called, instead of an insert (new record) method.

Perhaps you should consider altering the table directly with SQL syntax as
opposed to relying on the particular methods.
Comment out the database update or insert calls and Response.Write as many
of your variables as possible.  This allows you to see whats about to be
written to the database as well as when.

--Salvatore Palmisano
Chief Information Officer
International Security Solutions, Inc.
spalmisano at usaiss.com

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Daniel McMurray
Sent: Friday, February 23, 2001 11:29 AM
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] ASP frustrations


There's a lot of code, and I'm not sure where the problem could be.  Pages
653-673 covers what I'm doing (a lot of it is explanation of the code, but
I found nothing about setting the database to "Don't overwrite" :-)
The whole of chapter 15 is where I'm drawing this from, but I don't need
the entire application that they've presented.

Since there is a little demand for the code, I'll let you know where to
get it, as opposed to trying to stick it in the email.  I'm using the
following files:

login.asp
clssfd.asp
register.asp
adduser.asp
menuforregisteredusers.asp

and they can be obtained by downloading a .zip file found at
ftp://ftp.wrox.com/Beginning/3382/3382ch15.zip

so THIS is what happens when one stupidly skips a few hundred pages.....

Thanks a lot!
Dan