As others have pointed out but I'll reiterate, you should use the [ ]
notation available in scoped variables.

In other words, your query would be

<CFQUERY>
INSERT INTO mytable
(course, degree, emp_course_id...)
VALUES
(     <cfqueryparam cfsqltype="char" value="#form['course#i#']#">,
      <cfqueryparam cfsqltype="char" value="#form['degree#i#']#">,
       <cfqueryparam cfsqltype="char" value="#form['emp_course_id#i#']#">
)
</CFQUERY>


If your variables are not in the form scope but rather in the variables
scope use

value="#variables['course#i#']#">


Jason Cronk
[EMAIL PROTECTED]




----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to 
[email protected] with the words 'unsubscribe cfcdev' as the subject of the 
email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting 
(www.cfxhosting.com).

An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]


Reply via email to