did in the other way
<cfset emailList = ArrayNew(1)>
<cfset MailQuery = QueryNew("Name,age,mark")>
<!--- made this more flexible just enter the max number of entries --->
<cfset maxNumber = 4>
<cfset counter = 1>
<cfloop index="i" from="1" to="#maxNumber#" step="1">
<cfset temp = QueryAddRow(MailQuery)>
<cfset temp = QuerySetCell(MailQuery,"Name",Evaluate("FORM.name#i#"),#counter#)>
<cfset temp = QuerySetCell(MailQuery,"age", Evaluate("FORM.age#i#"),#counter#)>
<cfset temp = QuerySetCell(MailQuery,"mark",Evaluate("FORM.marks#i#"),#counter#)>
<cfset counter = counter + 1>
</cfloop>
<cfdump var="#MailQuery#">
<cfquery name="test" dbtype="query">
select * from MailQuery where name <> '' and age <> '' and mark <> ''
</cfquery>
<cfdump var="#test#">
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
