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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net