Web Wiz Support and Community Forums : SQL help copying users

Web Wiz Support and Community Forums : SQL help copying users https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 17 Apr 2026 16:07:37 +0000 Mon, 19 Sep 2005 15:16:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16613 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL help copying users : Ok, I tried the multiple user...]]> https://forums.webwiz.net/sql-help-copying-users_topic16613_post90779.html#90779 Author: HawkMultimedia
Subject: 16613
Posted: 19 September 2005 at 3:16pm

Ok, I tried the multiple user upload tool from Rudster, but had no luck. I've got two user tables I need to copy into my tblAuthor table. I've created a rudimentary SQL statement, but I know it won't work because of the usercode and encryption. Could someone help me find a way to get these ~550 users into WWF? I would greatly appreciate it and am also willing to compensate for one's investment of time into this.

INSERT INTO FRMtblAuthor (Real_name, Username, Password)

SELECT (First_Name + Last_Name, UserName and Password) from users

INSERT INTO FRMtblAuthor (Real_name, Username, Password, Author_email)

SELECT (First_Name + Last_Name, UserName, Password, E-mail_Address) from entity_empoyee

I don't know how to add a space between the First_Name and Last_Name. I know I also need to supply a default time for the time_offset fields, I'm just not well-versed enough in SQL to know how to do it.

Thanks,

Patrick

]]> Mon, 19 Sep 2005 15:16:17 +0000 https://forums.webwiz.net/sql-help-copying-users_topic16613_post90779.html#90779