Database Discussion - Geting/updating data from 2 tables

Print Page | Close Window

Geting/updating data from 2 tables

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10797
Printed Date: 30 March 2026 at 12:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Geting/updating data from 2 tables

Posted By: dj air
Subject: Geting/updating data from 2 tables
Date Posted: 09 June 2004 at 6:38am

hi guys,

i am making my tv guide and login manager applications conpatible with WWF V7 + V8

and i was going to make it work by getting the user configuration details from the tv/login manager and login/usercode etc details from the forum table.

my question is. is there an easy way to get the user details from the forum database and the configuration details from my applications.

so when you are logged in to the applications (using forum Usercode).., your username showed in the tv guide/login manager is actually from the forum table

From forum table
- Username, Password, salt, usercode, email address

from the other tables would be the configuration details for the user.

i know i could use 2 queries etc.. but i want to think about performance.

also i will need to update the password etc from the tv/login manager applications into the forum table

hope that makes sense

thanx in advanced

Replies:

Posted By: ljamal
Date Posted: 09 June 2004 at 10:24am

Are you using Access or MSSQL?
Either way you could use a join to return the info in one query.

If using Access updates would have to be done seperately.
With MSSQL, you can append SQL statement together with a ";" and they can be sent to be executed with one trip. Or you could use a stored procedure with the update.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: dj air
Date Posted: 10 June 2004 at 8:22am

thanx mate, i will be using both database types as my applications are access and SQL,

but that should help.