phillystyle123
asked on
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,Count er)#,
AutoArtID=#ListGetAt(AutoA rtID,Count er)#
WHERE ExAutoArtID=#ListGetAt(ExA utoArtID,C ounter)#
</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#</cf output>
<CFLOOP INDEX=Counter FROM=1 TO=#ListLen(ExAutoArtID)#>
<CFQUERY NAME="UpdateExBuilder" DATASOURCE="Ikonltd">
UPDATE ExBuilder
SET OrderID=#ListGetAt(OrderID
ExID=#ListGetAt(ExID,Count
AutoArtID=#ListGetAt(AutoA
WHERE ExAutoArtID=#ListGetAt(ExA
</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#</cf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.