CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Somewhat Newbie Question

Print topic Send  topic

Author Message
J.
Posted: 01/13/2004, 8:39 PM

Good evening:

I am setting up a DB driven classified listing site. Here is what I am trying to accomplish to give you some history so that I can make some sense...

1. User accesses the site.
2. They are prompted with a greeting and have to fill out a registration form to access the listings.
3. Once logged in they can view the listings, etc. - I want to add a link to indivudual listing pages that will allow them to fill out an online Bid form. I want this bid form to automatically populate with the information from the listing page - I also want it to populate the user information from when they logged in -

My question is, how to I pass the user login (registration) information as well as the classified listing information to the bid form? My database is setup with several tables - one for user registration, one for classified detail information, one for bidding information...

Can anyone help me understand how I can pass all this information on to other forms? Essentially I want to maintain a 'session' that stores all the user information, etc., until they log out so that it is accessible and the server knows that that particular user is the information it should populate the other forms with.

I am a newbie so some of this may not make much sense.

Thanks in advance.

J.
peterr


Posts: 5971
Posted: 01/14/2004, 2:39 AM

The user login is always stored in the "UserLogin" session variable, therefore you don't need to do anything to pass this information. And you can retireve the session's value using the "Retrieve Value for Control" action in the "Before Show" event.

However, using sessions will consume some server memory and it is not recommended to create too many sessions, for *everything*.
A simple way to obtain various information is to use code with the CCDLookup function in the "Before Show" event and populate the field's value there.
A sample is shown at http://docs.codecharge.com/studio/html/ProgrammingTechn...gleDBValue.html , although you may need to expand the WHERE statement and use your parameters there. In the above example, the WHERE statement is:
"user_id=".CCGetUserID()

_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
peterr


Posts: 5971
Posted: 01/14/2004, 2:42 AM

I forgot to add that using CCDLookup function too frequently is also not efficient, but it should be an easy way to get started.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.