Try this...
<cfset varMyIndex = "#varMyIndex#" + 1>
<cfset varMyNewIndex = "#FORM.fldName##varMyIndex#">
And the insert
VALUES ('#varMyNewIndex#')
Stuart Duncan
MaracasMedia Inc
[EMAIL PROTECTED]
<cfset varMyIndex = 0>
<cfloop condition="varMyIndex LESS THAN OR EQUAL TO 500">
<cfset varMyIndex = "#varMyIndex#" + 1>
<cfif '#FORM.fldName("#varMyIndex#")#' IS NOT ''>
<cfquery name="qryInsertRecs" datasource="myDatasource">
INSERT INTO TABLE(fldName)
VALUES ('#FORM.fldName("#varMyIndex#")#')
</cfquery>
</cfif>
</cfloop>
At 01:38 AM 1/6/01 +0000, you wrote:
><cfset varMyIndex = 0>
><cfloop condition="varMyIndex LESS THAN OR EQUAL TO 500">
> <cfset varMyIndex = "#varMyIndex#" + 1>
><cfif '#FORM.fldName("#varMyIndex#")#' IS NOT ''>
> <cfquery name="qryInsertRecs" datasource="myDatasource">
> INSERT INTO TABLE(fldName)
> VALUES ('#FORM.fldName("#varMyIndex#")#')
> </cfquery>
></cfif>
></cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
