Add records using user’s ID
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14485
Printed Date: 30 March 2026 at 1:37am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Add records using user’s ID
Posted By: padoxky
Subject: Add records using user’s ID
Date Posted: 30 March 2005 at 8:34am
|
Help me!
I designed a form that insert new records to database. Only it to be used when a user login with he/her username and password or as an administrator if i want to add new records to each user's profile using user's ID. How am i going do that?
 padoxky. ------------- NgWebDesigns |
Replies:
Posted By: michael
Date Posted: 30 March 2005 at 6:06pm
|
Update Usertable Set Field='Value' where USerID= XXX ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: padoxky
Date Posted: 31 March 2005 at 5:53am
|
I want the records i insert to display in rows just like this table below:
John's profiles &n bsp; &nbs p; Account Id: 099
DATE DESCRIPTION & nbsp; CREDIT CHARGES BALANCE
-----------------------------------------------------------------
30/03/05 Steve paid in $40.00 0 0 $40.00
-----------------------------------------------------------------
31/03/05 John paid in $35.00 0 0 $75.00
-----------------------------------------------------------------
01/04/05 mike paid in $20.00 0 &nb sp; 0 $95.00
Just like this format.
Plz help ------------- NgWebDesigns |
Posted By: michael
Date Posted: 31 March 2005 at 9:06pm
|
No offense, you really gotta put your question beter. I don't think anyone really knows what you want. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: padoxky
Date Posted: 01 April 2005 at 3:48am
|
i want whenever i insert a records to user profile to display like the table below:
Mike's Profile
Account No: 098763
DATE DESCRIPTION CHARGES BALANCE
-----------------------------------------------------
23/09/04 John paid in $2 0 $2.00
-----------------------------------------------------
27/09/05 Steve paid in $4 0 $ 6.00
-----------------------------------------------------
09/08/05 Eric paid in $10 0 $16.00
I want it to display like this whenever i add a new records in Mike's profile.
Not to update the previous records but, add and display new records to the table show here in Mike's porfile. ------------- NgWebDesigns |
Posted By: padoxky
Date Posted: 08 June 2005 at 6:09am
|
Are you guys not going to help me out please what i ask you guys ok
------------- NgWebDesigns |
Posted By: bootcom
Date Posted: 08 June 2005 at 10:25am
Erm, even Im having a hard time understanding this thread,  but it sounds like you just want to add new records to the database, if thats the case its basic SQL/ ASP
|
Posted By: padoxky
Date Posted: 15 June 2005 at 6:34am
|
No not all. I want to create account statment for each members so that they can veiw they account statement. I as the administrator i have to create this statement for each member through my admin page.
Just like bank account statement. Any help? ------------- NgWebDesigns |
Posted By: padoxky
Date Posted: 15 June 2005 at 6:38am
|
Just something like this site
www.us.hsbc.com/business/online/BB_html/welcome.html I want something like that Please help with that. ------------- NgWebDesigns |
Posted By: solarfish
Date Posted: 22 June 2005 at 5:37am
|
For clarity I think you need to show us the database tables too, I'm wondering if you only have a single 'user profile' table in which case you will find it nearly impossible to do what you want. What you should have is a 'user' table, an 'account' table and an 'account line' table. The account table would have a foreign key to the user table so you could tell who owned the account and the account line table would have a foreign key to the account table so you would know which account a posting belonged to.
For presentation, in your select SQL, you would join these three tables to provide the 'statement' data you are looking for.
To be honest I think you need to gain a better understanding of relational database design first before trying to tackle this requirement from the front end. I would suggest picking up a basic book on databases and reading that, it will give you a far better idea of how things really work rather than trying to 'reverse engineer' a pretty screen on another site.
|
Posted By: padoxky
Date Posted: 22 June 2005 at 6:06am
|
I only have user's table, active table and admin table for web sittings/reports all in my access dbase.
I don't know if you can help send me the database table design to my mailbox. i will appreciate it i really need it seriously for my project. If you have any cue where i can get online tutorial on database i wouldn't mind getting it from you.
Thanks for advice hope to hear from you. ------------- NgWebDesigns |