Solved

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

Posted on 2003-12-06
1
179 Views
Last Modified: 2013-12-24
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>
0
Comment
Question by:phillystyle123
1 Comment
 
LVL 12

Accepted Solution

by:
jyokum earned 75 total points
ID: 9889950
<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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now