Importing new info in tblAuthor & Linking Tables

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jadam Members Profile Find Members Posts Newbie Joined: 20 March 2005 Location: Windsor, CT USA Status: Offline Points: 19	Post Options Post Reply Quote jadam Report Post Thanks(0) Quote Reply Topic: Importing new info in tblAuthor & Linking Tables Posted: 31 July 2008 at 9:21pm
	Note: I did search the forums but couldn't find the answer.... Is it possible to reorder the Author_ID column? I imported 706 records and now the numbering is off. Also, I am trying to figure out a way to link the tbl.Author table with a members table that contains all my members information. I have an existing table of all my members that I have imported into the webwiz db and I can't figure out how to link the two. I've setup a column in the member table called User_name to correspond with the tblAuthor column. Any help would be greatly appreciated! Joe

Scotty32 Members Profile Find Members Posts Moderator Group Joined: 30 November 2002 Location: Manchester, UK Status: Offline Points: 1682	Post Options Post Reply Quote Scotty32 Report Post Thanks(0) Quote Reply Posted: 31 July 2008 at 9:38pm
	You cant re-order the Author_ID column as that is the users ID. I think you might of made a slight mistake - if you wish to continue using your existing members table then you should of used the Member API which integrates your site into the forum. The Member Import is to import your old site and move it TO the forum. If you have not started to use your forum yet then I would advise you to start again from scratch.
	S2H.co.uk - WebWiz Mods and Skins For support on my mods + skins, please use my forum.

jadam Members Profile Find Members Posts Newbie Joined: 20 March 2005 Location: Windsor, CT USA Status: Offline Points: 19	Post Options Post Reply Quote jadam Report Post Thanks(0) Quote Reply Posted: 31 July 2008 at 9:42pm
	Thanks for the info, if I use the API will I lose the lost password, registration, etc, futures?

Scotty32 Members Profile Find Members Posts Moderator Group Joined: 30 November 2002 Location: Manchester, UK Status: Offline Points: 1682	Post Options Post Reply Quote Scotty32 Report Post Thanks(0) Quote Reply Posted: 31 July 2008 at 9:45pm
	sorry, what is it you are trying to do? As I said, the Import feature is to Import your exisiting users into webwizforum - and then to discard your old table. The API is to be used with your existing site, so I believe you would use the forgotten password and registration of your existing site. As I said, please describe what it is you wish to do
	S2H.co.uk - WebWiz Mods and Skins For support on my mods + skins, please use my forum.

jadam Members Profile Find Members Posts Newbie Joined: 20 March 2005 Location: Windsor, CT USA Status: Offline Points: 19	Post Options Post Reply Quote jadam Report Post Thanks(0) Quote Reply Posted: 31 July 2008 at 9:56pm
	I have a database of over 700 members with lots of data (over 30 columns worth) that the forum db doesn't need. I am trying to figure out a way so that my members can log into the web site and do not have to re-login to the forum. I want to only update one db when the user makes a change to their email address, password, etc. I also need the ability to have visitors access the forums. I have the web site built and the forum installed, I just haven't written the code to tie the two together. I thought that if I used the functions_member_API I would still have to update the forum tables whenever there was a change of information. Sorry thatI have been so vague..... I'm new to ASP and SQL having spent most of my time using Aestiva HTML/OS for several years.... Joe

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum