just another quickie (as I'm just sitting here waiting for pub o'clock) you don't need the hash marks around non-evaluation zones in CF
eg <cfset userid = #session.userid#> will work just fine with: <cfset userid = session.userid> a great resource for this is here: http://www.fusionauthority.com/alert/index.cfm?alertid=37#tech1 > -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 06 June 2003 16:43 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] form.fieldnames > > > this did it: > > <cfif IsDefined("form.fieldnames")> > > <CFLOCK > SCOPE="session" > TIMEOUT="30" > TYPE="Exclusive"> > > <cfif IsDefined("form.userid")> > <cfset userid = #form.userid#> > <cfelse> > <cfset userid = #session.userid#> > </cfif> > > <cfquery datasource="#dsn#"> > DELETE FROM artformjoin > WHERE userid = #variables.userid# > </cfquery> > > <cfset mylist = #form.artform#> > <cfset adds = ListLen(form.artform)> // s'pose I could do > ListLen(mylist) > > <cfloop from="1" to="#variables.adds#" index="id"> > <cfquery datasource="#dsn#"> > INSERT INTO artformjoin (userid, artformid) VALUES > (#variables.userid#, #ListGetAt(mylist, id)#) > </cfquery> > </cfloop> > > </CFLOCK> > > </cfif> > > it means the user has to select at least one artform - but > hey, if they're > not interested in at least _one_ artform, what the hell are they doing > registering for an arts web site? ;-) > > thanks for all the help. > > Ian W > > ----- Original Message ----- > From: "Stephen Moretti" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, June 06, 2003 4:32 PM > Subject: Re: [ cf-dev ] form.fieldnames > > > > > > > > > form variables were a structure in CF5 as well. > > > > > Thought so.... Wonder whether lunchtime beer and sunshine > had addled my > > brain. > > > > So Ian, what's the problem? Whats the code you've got now > and what errors > > are you getting. > > > > 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] > -- ** 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] -- ** 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]
