This is what I have on the action page
<cfloop index="i" from="1" to="#form.recordcount#">
<cfparam name="linkbroken" default="0">
<cfset locsongid="form.songid" & i>
<cfset loclinkbroken="form.linkbroken" & i>
<cfquery datasource="VhDatabase" name="update" dbtype="ODBC">
update musicselection
set linkbroken='#Evaluate(loclinkbroken)#'
where songid='#Evaluate(locsongid)#'
</cfquery>
</cfloop>
This is the error I get
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (22:1) to (22:61).
Date/Time: 12/13/00 10:48:37
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 127.0.0.1
HTTP Referer: