after updating form using cfloop - how to dislay results using form parameters

I'm updating my form like this:

<CFLOOP INDEX=Counter FROM=1 TO=#ListLen(ExAutoArtID)#>
   <CFQUERY NAME="UpdateExBuilder" DATASOURCE="Ikonltd">
       UPDATE ExBuilder
       SET OrderID=#ListGetAt(OrderID,Counter)#,
ExID=#ListGetAt(ExID,Counter)#,
AutoArtID=#ListGetAt(AutoArtID,Counter)#
       WHERE ExAutoArtID=#ListGetAt(ExAutoArtID,Counter)#
   </CFQUERY></CFLOOP>

my problem is:

how can i display my update results when (for instance) #form.ExID# doesn't equal 17 but 17,17,17 depending upon how many records i insert?

so how do i get this to fly;

<cfquery name="Ex" deflault="dsn">
Select Extitle from Exhibitions where ExID=#form.ExID#
</cfquery>

<cfoutput>#Ex.Extitle#</cfoutput>
phillystyle123Asked:
Who is Participating?
 
jyokumConnect With a Mentor Commented:
<cfquery name="Ex" deflault="dsn">
Select Extitle from Exhibitions where ExID IN (<cfqueryparam value="#form.ExID#" list="yes" cfsqltype="cf_sql_numeric">)
</cfquery>

<cfoutput query="Ex">
#Ex.Extitle#<br />
</cfoutput>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.