I think I have accomplished what was once thought impossible or at least improbable. I have passed variables to a Modal window, allowed the user to execute a form there, passed the variable back to the parent page using javascript, updated a form variable in a hidden form and displayed the results using coldfusion. In other words Server -> client and used that javascript variable as a cf variable. Mixing client and server side data.<\/p>\n
Q1. check to see if multiple sources are available for a particular order number(shows we have duplicate order numbers from different if result is greater than 1 source we have duplicates. So we want the user to select which source they want to use. \t\t here is the modal window order_chksource.cfm page. It contains a form for the selection of source and the javascript to pass back the selected value to the form on the parent page. UPDATE: I think I have accomplished what was once thought impossible or at least improbable. I have passed variables to a Modal window, allowed the user to execute a form there, passed the variable back to the parent page using javascript, … Continue reading
\nsystems)
\n<cfquery name=\"chksource\" datasource=\"yourDS\">
\n\t\tselect distinct source from the table
\n where order_number = #someordernumber#
\n<\/cfquery><\/code><\/p>\n
\nFirst we create a form with hidden input field. We then create the list of sources using valuelist().
\nWe then pass the valuelist to the window.showModalDialog function where the user can select the options.
\nAfter the source is selected we pass it back to the form.
\nWe can then set a coldfusion variable to the form value using cfset and javascript document.write. <\/p>\n<cfif #chksource.recordcount# gt 1>
\n\t\t\t<cfform name=\"srcform\">
\n\t\t\t<cfinput name=\"sourcesel\" type=\"hidden\" \/>
\n\t\t\t<\/cfform>
\n
\n\t\t\t<cfset sources_list=ValueList(chksource.source)>
\n
\n\t\t\t<script language=\"javascript\" type=\"text\/javascript\">
\n\t\t\tvar returnValue=window.showModalDialog(\"order_chksource.cfm?
\nsource=
\n\t\t\tdocument.srcform.sourcesel.value= returnValue;
\n\t\t\t<\/script>
\n
\n<cfset sourcesel = \"<script type='text\/javascript' language='javascript'>
\ndocument.write(document.srcform.sourcesel.value);
\n<\/script>\">
\n\t\t\t<cfoutput>#sourcesel#<\/cfoutput>
\n<\/cfif>
\n<\/code><\/p>\n
\n<HEAD>
\n<TITLE>New Window<\/TITLE>
\n<script language=\"JavaScript\">
\n<!--
\nfunction sendAndClose(selObj,restore){
\n \/\/alert('x='+ selObj.value);
\n if (selObj.selectedIndex != 0 ){
\n returnValue=selObj.value;
\n self.close();
\n }
\n}
\n\/\/-->
\n<\/script>
\n
\n<\/HEAD>
\n<BODY>
\nYour tin is duplicated in Source systems (<cfoutput>#url.source#<\/cfoutput>). Select the source you want to view.
\n<FORM onsubmit=\"return false;\">
\n <select name=\"menu1\" onChange=\"sendAndClose(this,0)\">
\n <option>--Select--<\/option>
\n <cfloop list=\"#url.source#\" index=\"src\" delimiters=\",\">
\n <cfoutput><option value=\"#src#\">#src#<\/option><\/cfoutput>
\n <\/cfloop>
\n <\/select>
\n<\/FORM>
\n<\/center>
\n<\/BODY>
\n<\/HTML><\/code><\/p>\n
\nWhile I can display the variable as
\nI could not use the variable in a cfquery as part of the where clause.
\nThe output prints the