https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 14:47:38 +0000 Mon, 21 Jun 2004 09:57:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10901 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post60131.html#60131 Author: kayaker411
Subject: 10901
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!]]> Mon, 21 Jun 2004 09:57:34 +0000 https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post60131.html#60131 https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post59861.html#59861 Author: WebWiz-Bruce
Subject: 10901
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, butI would recommened doing so as the forum has not be fully tested withencrypted passwords disabled and so there are a few porpblems if thisoption is disabled.

The User_code field contains a unquie hex value that is around 20characters long. You can put whatever you like in this field as long asit is unquie and not easy to guess as it is used in cookies to loginusers.
]]> Thu, 17 Jun 2004 10:47:19 +0000 https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post59861.html#59861 https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post59853.html#59853 Author: kayaker411
Subject: 10901
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]]> Thu, 17 Jun 2004 09:07:48 +0000 https://forums.webwiz.net/populating-tblauthor-from-sqlserver-2k_topic10901_post59853.html#59853