I know, it is wierd. I thought I was going mad yesterday!
This is the sql
<cfset sqlString = "
INSERT INTO tds_core (SURNAME,
PREFERRED_FORENAME,
PRN2,
curstatus,
disabil,
profile_status
)
VALUES ('#ff_SURNAME#',
'#ff_PREFERRED_FORENAME#',
'#ff_PRN2#'...