loop over query
I have an access database table that contains a column that I would change all
the values to the same variable. The table is forever being populated with more
rows as data is entered regularly. I have tried numerous attempts to build an
insert query inside cfloop tags and I never seem to get the right result. Here
is a snipet.
<cfif FORM.Updated IS "no">
<CFLOOP INDEX="Update" LIST="#FORM.Updated#">
<CFQUERY Name="#Update#" DataSource="#db#">
INSERT INTO QTYTracking (Updated)
VALUES ('#FORM.Updated#')</CFQUERY></CFLOOP>
</cfif>
|