Go get the next userID. SELECT "user_id" from "t_user" where "user_name" = '#form.User_Name#' ; #form.User_Name#
#client.User_ID# INSERT INTO "t_user" ( "user_id", "user_name", "title", "prof_title", "name_honorific", "name_first", "name_middle", "name_last", "name_suffix", "gender_code", "password", "addr1", "addr2", "city", "state_code", "postal_code", "country", "user_class_id", "status", "created_id", "created_dtm", "last_upd_id", "last_upd_dtm" ) VALUES ( #variables.RandomKey#, #form.User_name#, #form.title#, #form.prof_title#, #form.name_honorific#, #form.name_first#, #form.name_middle#, #form.name_last#, #form.name_suffix#, #form.gender_code#, #variables.EncryptedPassword#, '', '', '', '', '', '', 4, 'P', #variables.RandomKey#, CURRENT TIMESTAMP, #variables.RandomKey#, CURRENT TIMESTAMP ) ;