Ian,
No * required in the DELETE.
<cfquery datasource="#dsn#">
DELETE
FROM artformjoin
WHERE userid = #variables.userid#
</cfquery>
Use form[field] to reference the content of your form field.
<cfquery datasource="#dsn#">
INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#,
#form[field]#)
</cfquery>
Be aware that form.artform will be a comma delimited list of artform ids if
the user selects more than one artform in form.
You probably need some this like this.
<cfif field eq 'artform'>
<cfloop list="#form[field]#" index="artformid">
<cfquery datasource="#dsn#">
INSERT INTO artformjoin (userid, artformid) VALUES
(#variables.userid#, #artformid#)
</cfquery>
</cfloop>
</cfif>
Stephen
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
