Thread: loop over query
View Single Post
  #1 (permalink)  
Old 07-24-2008, 07:31 PM
chrispilie
 
Posts: n/a
Diggs:
Default 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>



Reply With Quote
Sponsored Links