Web Wiz Forums - SQL help copying users

Print Page | Close Window

SQL help copying users

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=16613
Printed Date: 17 April 2026 at 11:28am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL help copying users

Posted By: HawkMultimedia
Subject: SQL help copying users
Date 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