Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > ASP & COM design question

Thread Tools

ASP & COM design question

Tim Baur
Posts: n/a
Hi guys. I'm new to ASP, but not Visual Basic. I recently find myself
with a project that will involve a SQL Server / COM back end with an ASP
front end. The system handles help desk type requests from external users.

At the core of my DB schema is a request table. This entity has one or
more assignment records and each assignment record has one or more
assignment log records. The log tracks assignment actions such as hold,
release, open, close, etc.

In VB, I would normally create Request, Assignment, and AssignmentLog for
the data. I would also create two custom collections for Assignments and
AssignmentLogs. Given any Request ID, I could populate everything else
with encapsulated queries and recordsets. The request object could
implement properties to give the currently assigned helper, open state,
elapsed time, etc.

My question to you is; how to I implement this model for the Web? As I
understand it, web objects are stateless. If my request object can't
persist its data in memory, then does it have to fire a query every time
the caller wants a property value? Will I always have to pass the
RequestID in as a parameter?

Or, am I just misunderstanding how this works?
Reply With Quote
Tim Baur
Posts: n/a
"Curt_C [MVP]" <> wrote in
news:#(E-Mail Removed):

> Nope.. you got it right.
> Its a hassle... You can store the base in the Session but its only
> going to save you a little bit of energy.
> I'd suggest moving to ASP.NET possibly, you can do much more at that
> level with whatyou are describing

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
class design/ design pattern question Bartholomew Simpson C++ 2 06-12-2007 08:51 PM
Class design/design pattern resources TomTom MCSD 2 10-09-2004 07:38 AM
OO design in servlet design question dave Java 5 07-17-2004 12:58 PM
Xilinx Schematic design vs VHDL code design ZackS VHDL 5 07-09-2004 07:51 AM
Looking for help/resources on Writing a nice detailed design / tech design for code SpamProof Java 3 12-01-2003 06:06 AM