ColdFusion General :: I need some help....
This thread was displayed: 156 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Cornel Ivanescu  07-28-2006 16:53:49 GMT +2
|
Hi,
I have a dropdown in a form page that is populated by a query, the issue is that if I do a single edit it works fine - multiple edit it defaults the dropdowns to the first value and I can't figure how to change that I feel like I am going in circles I just can;t seem to get my brain around it...
here is the dropdown code:
<td class="KT_th"><label for="ordtyp_<cfoutput>#cnt1#</cfoutput>">Service:</label></td>
<td>
<select name="ordtyp_<cfoutput>#cnt1#</cfoutput>" id="ordtyp_<cfoutput>#cnt1#</cfoutput>">
<cfoutput query="Recordset3">
<option value="#Recordset3.name_prd#" <cfif (isDefined("rsjobs_ord.ordtyp") AND Recordset3.name_prd EQ rsjobs_ord.ordtyp)>selected="selected"</cfif>>#Recordset3.name_prd#</option>
</cfoutput>
</select>
<cfoutput>#tNGs.displayFieldError("jobs_ord", "ordtyp", cnt1)#</cfoutput>
The query is at the begining of the file and it looks like this:
<cfquery name="Recordset3" datasource="detective">
SELECT name_prd
FROM product_prd
</cfquery>
Thank you guys,
Cornel
|
|
|
Razvan Racasanu[InterAKT]  07-28-2006 17:25:00 GMT +2
|
Hello,
Please attach an archive containing the entire file and the database dump so we can try and duplicate this.
Regards,
Razvan RACASANU
|
|
|
Cornel Ivanescu 08-07-2006 16:11:01 GMT +2
|
Hi Razvan, I replied to your message as a private reply to you in this forum beggining of last week with all the required things and access to the site/instructions to see the behavio, and no response... Please let me know what is going on... Cornel
|
|
|
Razvan Racasanu[InterAKT] 08-08-2006 09:54:27 GMT +2
|
Hello,
I'm sorry for the late reply, but we have been under very high load recently. There are some problems in ColdFusion referencing nested recordsets, so try to rewrite the dropdown as this:
<option value="#Recordset2[Recordset2.CurrentRow]["acct_name"]#" <cfif (isDefined("rsjobs_ord.rcustomer") AND Recordset2[Recordset2.CurrentRow]["acct_name"] EQ rsjobs_ord.rcustomer)>selected="selected"</cfif>>#Recordset2[Recordset2.CurrentRow]["acct_name"]#</option>
If this does not work, can you post in a private message FTP connection details so we can try and debug this?
Regards,
Razvan RACASANU
|
|
|
Razvan Racasanu[InterAKT] 08-10-2006 11:19:28 GMT +2
|
Hello,
I have corrected the file changestatus2.cfm. It seems that the code should have been the other way around, because it seems to loose the reference to the outer recordset when this is called from a nested one:
<option value="#Recordset2.acct_name#" <cfif (isDefined("rsjobs_ord.rcustomer") AND Recordset2.acct_name EQ rsjobs_ord['rcustomer'][rsjobs_ord.CurrentRow])>selected="selected"</cfif>>#Recordset2.acct_name#</option>
Regards,
Razvan RACASANU
|
|
|
