Populating tblAuthor from SQLServer 2K
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10901
Printed Date: 08 April 2026 at 2:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Populating tblAuthor from SQLServer 2K
Posted By: kayaker411
Subject: Populating tblAuthor from SQLServer 2K
Date Posted: 17 June 2004 at 9:07am
There are posts regarding importing but my question is bit different (if not I'll accept a link as a response to this post  )
I want to import a bunch of users from another sql2k db into tblAuthor. I am not using encrypted passwords and I want people to be automatically logged in. If I do a simple insert statement or use the Enterprise Manager Import Utility will User_code automatically populate or does it get it's unique value after an insert is made into that column? Should i include it in my insert statement? I have the same question for the salt field. Is this the same for each user? TIA! Rich |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 June 2004 at 10:47am
|
The User_code and Salt fields are not automactiaclly populated and do require a unquie value. The Salt field is not use if you are not using encrypted passwords, but I would recommened doing so as the forum has not be fully tested with encrypted passwords disabled and so there are a few porpblems if this option is disabled. The User_code field contains a unquie hex value that is around 20 characters long. You can put whatever you like in this field as long as it is unquie and not easy to guess as it is used in cookies to login users. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: kayaker411
Date Posted: 21 June 2004 at 9:57am
|
Thanx for the info boRg.
I used a little script to loop through a recordset containing the results of my other members table and do an insert on each into tblAuthors. Inefficient but there's only about 90. I put the username into the user_code field. After a user logs in the system appends a value to the user_code and we're off and running. So far I have not encountered any problems with encrypted passwords being disabled. I'll post back here if I do though. Thanks again! |