Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
I know this isn't a complete query/example but I am hoping I gave enough information. Thank you.
<cffunction name="myFunction" output="false" access="remote" returntype="string" hint=""> <cfargument required="true" type="string" name="Name" /> <cfargument required="true" type="string" name="Age" /> <cfquery ...> UPDATE MYDB.table set Status = 'Complete', Notes = 'blah' where Age = <cfqueryparam value = "#Trim(ARGUMENTS.Age)#" CFSQLType = "CF_SQL_VARCHAR"> </cfquery> --------this is where i want to insert a record for each of the ones that were updated above.... <cfquery ...> INSERT INTO myDB.Table2 (ID, age, blah) VALUES ... </cfquery>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.