The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Query works in display mode but cannot export
I am trying to get a query together to create a csv file to import users into our new vB Forum.
This query looks ok in display mode: SELECT ID, LastName, FirstName, Nickname, Email, Pwd, IF (Nickname is null or Nickname = '', CONCAT (REPLACE (LastName, ' ' , ''), ',', REPLACE (FirstName, ' ', '')), CONCAT (REPLACE (LastName, ' ', '') , '.', REPLACE (Nickname, ' ', ''))) as UserName FROM `memberinfo2` WHERE MemberTypeCD = 'MEMB' and StatusCD = 'ACTV' If I try to export it to a csv file, I don't get the data but get a file of meta tags I also tried to just add a new field and update the field using a similiar query but could not get it to update update memberinfo2Prod set ForumUserName = IF (Nickname is null or Nickname = '', CONCAT (REPLACE (LastName, ' ' , ''), ',', REPLACE (FirstName, ' ', '')), CONCAT (REPLACE (LastName, ' ', '') , '.', REPLACE (Nickname, ' ', ''))) WHERE MemberTypeCD = 'MEMB' and StatusCD = 'ACTV' |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|