Where would this go

Where would this go

Postby mmuhlenkort2000 » Mon Aug 29, 2016 9:30 pm

I'm creating a user id based on the first three letters of the first and last name and the last 3 characters of the ID field -- Select UPPER (concat(left(userlastname,3), left(userfirstname,3), right(user_id,3))) as 'Gateway_User_Id' from user -- I've tried in vain to place it correctly to create and fillin the appropriate field -- when I show the form nothing happens or I get a SQL error stating the query is incorrect -- the query executes fine in when run in the database -- I'm new to nuBuilder so don't slam me to hard -- :D
mmuhlenkort2000
 
Posts: 2
Joined: Wed Aug 24, 2016 4:14 am

Return to Custom Code