[thelist] Database/ASP Samples PLease

[Matthias Ritzkowski]

Ok -

I will attempt my luck at this one.
Let's say you have a table with UserID, report1, report2, report3, etc
The report fields could be varchar, values are "Y" and "N"
Upon a user logging in, you track his UserID and send him to your page.
The trick is how to build the page from the serverside (this is how I would
do it).
I use server-side checkboxes, which retrieve their state (checked or not)
from a database query like
SELECT REPORT1, REPORT2, REPORT3 WHERE USERID = strUSERID

if REPORT1.Value = "Y" then
code to set the chkbox1 to checked
else
code to set chkbox 1 to unchecked

You also need a Submit button which fires an update query and checks for the
states of all checkboxes to update any changes the user might have done.

Does this help?
Matthias

-----Original Message-----
From: Sanders, Robert (IndSys, Pwr. Equip., IM)
[mailto:robert.sanders at indsys.ge.com]
Sent: Monday, September 17, 2001 09:10
To: 'thelist at lists.evolt.org'
Subject: [thelist] Database/ASP Samples PLease


I would very much welcome the opportunity to review some ASP used to connect
to a database. I've been working towards this same end but to no avail. If
avyone has some code that they wouldnt mind sharing I would appreciate if
they'd forward it to me so I could attempt to figure out what I'm doing
wrong. I really just want to create a "My Reports" web page for our business
reports but need an ASP for the end users to subscribe to reports initially
and then revisit that same page and be able to unsubscribe or subsribe to
additional reports. That is, the p[age must display (via check boxes) what
reports a user has already subscribed to.

Thanks for the much needed help.

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !