Ilssac,    I tried the Order By and the Group By like you have it, but when I do a Group By, it combines my 2 rows and only outputs the first results row. How can I have only specific columns from the 2nd row outputing onto the first row of the Group when everything is being output dynamically? What do the 3 different outputs you have below mean? What do you mean by Record Set? Do you just mean outputting the whole table record set? Is there more to this than just Order By something and Output the query with a Group By something? Is that what the other 3 outputs you have below are for? Andy ... View more

Dan,    This is how I did the output query: <CFOUTPUT QUERY="PNRBOMSearch" group="APV_ItemID"> How do you have an Order By on an output query tag? Andy ... View more

Here's what my code looks like for this table. Is there anything I can do since the code is being output dynamically? <table width=*% align="center" cellspacing="0" cellpadding="4" border="0"> <tr>     <td><B>ECO</B>   </td>     <td><B>ECO ItemID</B>   </td>     <td><B>APVID</B>   </td>     <td><B>APV ItemID</B>   </td>     <td><B>Part Number   </B></td>     <td align="center"><B>PNR</B></td>     <td align="center"><B>BOM</B></td>     <td align="center"><B>Open Jobs Affected</B></td> </tr> <!---------------- OUTPUT Company SEARCH RESULTS ----------------> <cfform name="EditItem" method="post" action="Queue_PNR_BOM_action.cfm"> <CFOUTPUT QUERY="PNRBOMSearch"> <input type="hidden" name="ECID#ItemID#" value="#ECID#"> <input type="hidden" name="ItemID#ItemID#" value="#ItemID#"> <input type="hidden" name="PNR_Doc_Type#ItemID#" value="PNR Req"> <input type="hidden" name="BOM_Doc_Type#ItemID#" value="BOM Req"> <tr>     <td>     <cfif ECID is not "">     <a href="item_display.cfm?ECID=#ECID#">#ECID#</a>     <cfelse>       </cfif></td>         <td width="auto">     <cfif ItemID Is Not "">     #ItemID#     <cfelse>       </cfif></td>         <td width="auto">     <cfif APVID Is Not "">     #APVID#     <cfelse>       </cfif></td>         <td width="auto">     <cfif APV_ItemID Is Not "">     #APV_ItemID#     <cfelse>       </cfif></td>         <td width="auto">     <cfif Part_Number Is Not "">     #Part_Number#     <cfelse>       </cfif></td> <td align="center"> <cfif Approval_Initials Is Not "" and Document_Type EQ "PNR Req"> #Approval_Initials# <cfelse> <select name="PNR_Approval_Initials#ItemID#"> <option value="">Select Initials</option> <cfloop query="ShowInitials"> <cfif Engineer_Initials EQ 1> <option value="#Initials#">#Initials#</option> </cfif> </cfloop> </select> </cfif> </td> <td align="center"> <cfif Approval_Initials Is Not "" and Document_Type EQ "BOM Req"> #Approval_Initials# <cfelse> <select name="BOM_Approval_Initials#ItemID#"> <option value="">Select Initials</option> <cfloop query="ShowInitials"> <cfif Engineer_Initials EQ 1> <option value="#Initials#">#Initials#</option> </cfif> </cfloop> </select> </cfif> </td>     <!--- <td> <select name="BOM_Approval_Initials#ItemID#"> <option value="">Select Initials</option> <cfloop query="ShowInitials"> <cfif Engineer_Initials EQ 1> <option value="#Initials#" <cfif #Initials# EQ #PNRBOMSearch.Approval_Initials#>selected</cfif>>#Initials#</option> </cfif> </cfloop> </select> </td> ---> <td><input name="Open_Jobs_Affected#ItemID#" type="text" value="#Trim(Open_Jobs_Affected)#" size="30"></td> </tr> <!--- </CFLOOP> ---> </cfoutput> <tr> <td>   </td> </tr> <tr> <td colspan="4" align="center"> <input type="submit" value="Update">  <input type="reset" value="Reset"></td> </tr> </table> <cfoutput>      <input type="hidden" name="listofids" value="#ValueList(PNRBOMSearch.ItemID)#">      <!--- <input type="hidden" name="listofapvids" value="#ValueList(PNRBOMSearch.APV_ItemID)#"> ---> </cfoutput> </cfform> Andy ... View more

Dan,      That's what I tried, but it only displays the first item row with the PNR Initials, but then the BOM initials have a drop down menu still in it and not the "AG" initials that are in the database already for that item. It basically deletes the 2nd row  or the 2nd item and only displays the first row of information. Do I need to run 2 different output queries with the group attribute? One for the PNR Initals column and one for the BOM initials column? I've tried this too, but the table gets really messed up and doesn't line up normal. Andy ... View more

Dan,     I do have this on the display page: <input type="hidden" name="ECID#ItemID#" value="#ECID#"> <input type="hidden" name="ItemID#ItemID#" value="#ItemID#"> <input type="hidden" name="PNR_Doc_Type#ItemID#" value="PNR Req"> <input type="hidden" name="BOM_Doc_Type#ItemID#" value="BOM Req">     Is this what you are talking about? Andy ... View more

Dan,      I don't understand what you mean when you say "I'd look for a logic error on your form page." What does that mean? Can you give me an example of something? Thanks. Andy ... View more

Owain,     Thank you! You are awesome! This does work! Everything inserts correctly now! There is one problem on my display page now though. I have 2 different columns- 1 for PNR Initials and 1 for BOM Initials, but when I insert everything into the database, I only have 1 column to handle both the PNR and BOM initials. The way I tell them apart is with another column that is called Document_Type. If it says "PNR Req", then I know to output it into the PNR Initials column. If it says "BOM Req", then I know to outupt it into the BOM Initials column.      Although the inserting works correctly, the display page does not put them next to each other. For instance, I updated the PNR Initial to "VP" and hit the update or insert button and it inserted the PNR Initial into the database. Then I went back to the display page to insert the BOM Initial to "AG". It inserted it correctly. But now when I go back to the display page, there are 2 different rows with the first row that has the drop down menu in the PNR Column and "AG" in the BOM column. But then there is another row that has "VP" in the PNR column and the drop down menu in the BOM column. Since I've updated both columns, it should just show the PNR Initials and the BOM Initials in their recpective columns, but all in the same row and not on 2 separate rows. How do I get it so they show up on the same row? Here's what my display page looks like now: APVID Header 1 APV ItemID Part Number PNR BOM 5 5 aaa5 Drop Down Menu AG 9 5 aaa5 VP Drop Down Menu It should look like this: APVID APV ItemID Part Number PNR BOM 5 and 9 5 aaa5 VP AG The APV ItemID is linked to a column in another table. That table is the ECO_Items table that has the ItemID column that has all the items. The info. above for the APV ItemID and Part number can always all be the same, but the PNR and BOM columns have to display the correct initals in each on 1 line. I tried the maxrows on the output query, but that did not work. Any other ideas? Thanks. Andy ... View more

Owain,      Thanks. This works on the first time that I try inserting this data, but if I go back to the link again later and try and update the other remaining initials that I didn't fill out yet, I get an error. Here's what it says: Element PNR_Approval_Initials1 is undefined in a Java object of type class coldfusion.filter.FormScope referenced as   The error occurred in F:\prot_intra\ECO_Register\Queue_PNR_BOM_action.cfm: line 24 22 : <cfloop index="aid" list="#form.listofids#" delimiters=","> 23 : <!--- <cfif isDefined("form.PNR_Approval_Initials#aid#")> ---> 24 : <cfif form["PNR_Approval_Initials#aid#"] neq ""> 25 : 26 : <cfquery Datasource="#application.DataSource#"> What does this mean? Why would this not work again? Andy ... View more

I was finally able to figure out how to have the user's initials selected and having the drop down menu only display the initials that I have checked off depending on what group they belong to. Here's the correct code below. Thanks everyone for your help. <select name="Initials"> <cfloop query="ShowReceivedByInitials"> <cfif ShowReceivedByInitials.Received_By_Initials EQ 1> <option value="#ShowReceivedByInitials.Initials#" <cfif #ShowReceivedByInitials.Initials# EQ #ShowItem.Received_By#>selected</cfif>>#ShowReceivedByInitials.Initials#</option> </cfif> </cfloop> </select> Andy ... View more

Dan,    I don't understand how to do the query you said to do. I am able to get the correct initials selected, but then the list of all the other initials do not display in the drop down menu. I want them to display in case someone needs to update the initials to someone else. Here's what I have: <select name="Initials"> <cfloop query="ShowReceivedByInitials"> <cfif #ShowReceivedByInitials.Initials# EQ #ShowItem.Received_By# and ShowReceivedByInitials.Received_By_Initials EQ 1> <option value="#ShowReceivedByInitials.Initials#">#ShowReceivedByInitials.Initials# </option> </cfif> </cfloop> </select> Andy ... View more

Oh yes. Sorry about that. The ShowItem.Received_By is from this query: <CFQUERY NAME="ShowItem" Datasource="#application.DataSource#"> SELECT Company, Company_Name, First_Name, Middle, Last_Name, ContactID, Contact_Num, ItemID, RFQID, RFQID_SPEC, M2M_Quote_Number, Rev, Standard_Part_Number, Generic_Description, GHz_Socket, Received_By, Assigned_By, RFQ_Leader, Jsquad_Coordinator, Entry_Date, New_Custom_PO_Received_Date, Complete_Date, Highest_Quantity_Request, Sales_Order_Number, Order_Request, Customer_Reason_Rejecting, Budgetary_Quote, RFQ_Expected_Value, Possible_Status, Sales_Status, Additional_Comments, End_Customer_Name, Follow_UpID, Follow_Up_ItemID FROM ((((Contacts LEFT JOIN RFQ_Numbers ON Contacts.ContactID = RFQ_Numbers.Contact_Num) LEFT JOIN Companies ON Contacts.Company = Companies.Company_Name) LEFT JOIN RFQ_SPEC ON RFQ_Numbers.RFQID = RFQ_SPEC.RFQID_SPEC) LEFT JOIN Follow_Up_Notes ON RFQ_SPEC.ItemID = Follow_Up_Notes.Follow_Up_ItemID) Where    ItemID=#url.ItemID# <!--- And Contacts.RFQ_Num >=0  ---> ORDER BY ItemID </CFQUERY>       This query relates all of my tables together. I have a table called RFQ_SPEC with all the part info. and user's initials in this table. The User's table field Initials equals the Received_By field in the RFQ_SPEC table. Andy ... View more

Thank you. I had to change a few things in the code to get it to work, but I still don't know how to get the drop down to have the correct initials be selected when the page loads. Here's how the code is working with just getting the initials to be populated correctly. For the other response I received, what I'm talking about with something being checked is I have a Users table with the user's name, iniitials, etc. There are also columns that are check boxes for if the user belongs in certain groups for certain drop down menus or not such as Received By, Assigned By, or RFQ Leader. <select name="Initials"> <cfloop query="ShowReceivedByInitials"> <cfif ShowReceivedByInitials.Received_By_Initials EQ 1> <option value="#ShowReceivedByInitials.Initials#">#ShowReceivedByInitials.Initials# </option> </cfif>#Initials# </cfloop> </select> How do I fix this now so that the correct initials are selected and displayed in the drop down when the page loads? I tried this, but it doesn't select the correct initials: <select name="Initials"> <cfloop query="ShowReceivedByInitials"> <cfif ShowReceivedByInitials.Received_By_Initials EQ 1> <option value="#Initials#"></cfif><cfif #ShowReceivedByInitials.Initials# EQ #ShowItem.Received_By#>selected</cfif>#Initials#</option> </cfloop> </select> Thanks. Andy ... View more

Dave,    Thank you! This finally worked! I kept the quote after the .cfm instead of the cgi.http_host#  Thanks again. Andy ... View more

Yes, this is a .cfm page. I have this code on a template page in Dreamweaver and then when I save it, it just updates the pages based on this template. The only problem I've noticed is that it does not update the relative paths in the javascripts. It only updates it within the other code. This is the error I get: ColdFusion was looking at the following text: \' The CFML compiler was processing: An expression      that began on line 37, column 20. Your expression might be missing an ending "#" (it might look      like #expr ). The body of a      cfoutput tag beginning on line 34, column 2.   The error occurred in E:\Ironwoodelectronics\index.cfm: line 37 35 : <script> 36 :    function getICNumber() { 37 :            $('#ICNumber').load("#cgi.http_host#/incICNumber.cfm",{ManufacturerID:$('#select_ManufacturerID').val()}); 38 :    } 39 :    function getPackage() { This is what the source shows below when I view source. It looks like it's erroring out at the function getPackage() { for some reason. $('#ICNumber').load(&quot;#cgi.http_host#/incICNumber.cfm&quot;,{ManufacturerID:$('#select_ManufacturerID').val()});</b> 38 :      } 39 :      function getPackage() { ... View more

I tried this, but this did not work. It said something about the  complier was not correct or something. I put the cfoutput tags around  the whole javascript tag. Was I not supposed to do that? How else do I  write it? Below is what I tried. Do I not need the quotes? There are  other # symbols in the javascript that could be causing the problem too  like the #ICNumber or #Package, etc. <cfoutput> <script>      function getICNumber() {           $('#ICNumber').load("#cgi.http_host#/incICNumber.cfm",{ManufacturerID:$('#select_ManufacturerID').val()});      }      function getPackage() {           $('#Package').load("#cgi.http_host#/incPackage.cfm",{ManufacturerID:$('#select_ManufacturerID').val(),ICNumber:$('#select_IC_Number').val()});      }            function getPackageType() {           $('#PackageType').load("#cgi.http_host#/incPackageType.cfm",{FunctionID:$('#select_FunctionID').val()});           $('#Pitch').html("");      }      function getPitch() {           $('#Pitch').load("#cgi.http_host#/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val()});      }      function getBody() {           $('#Pitch').load("#cgi.http_host#/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val(),PitchID:$('#select_PitchID').val()});      }      function getArray() {           $('#Pitch').load("#cgi.http_host#/incPitch.cfm",{FunctionID:$('#select_FunctionID').val(),PackageID:$('#select_PackageID').val(),PitchID:$('#select_PitchID').val(),BodyID:$('#select_BodyID').val()});      } </script> </cfoutput> ... View more

How do I write the code for CGI.HTTP_HOST? Is it like this: .load("CGI.HTTP_HOST/incICNumber.cfm" ... View more

The window opens up just fine. When the drop downs are displayed in this window, only one shows up at first. There are supposed to be 2 that show up from the beginning. When I choose something out of the first one, the 2nd one does not show up at all. The advanced search link uses the onclick or show/hide function in Dreamweaver. It's not the window.open or href target="_blank". This is not the problem though because on the www. site it works and on the one without the www. it does not work. We do not want to re-direct the one without the www. to the www. one. That's why I'm trying to figure out how to do it within the javascript code instead. Andy ... View more

Azadi, The code you sent didn't work either. When I type in the name "La Rue" it comes up with a lot of contacts that don't even have La Rue in the name anywhere. It comes up with fewer results when "Don La Rue" is typed in, but still doesn't narrow it down to just Don La Rue. Do you have any other ideas? Thanks. Andy ... View more

I have updated the code with what I have attached below. I can search for a last name such as "La Rue" and find the person. But if I type in "Don La Rue", it won't work. How do I do this with searching for all these instances with each field that may have 2 names in each field? ... View more

Mikey, Thank you. That web site worked. Here's what I did below. Is there anyway to display the initials that have zero for a count? Thanks again. Andy ... View more

Dan, No, I'm not familiar with the count function. Is SQL the only way to make this work? Andy ... View more

Steve, Can you show me an example of how to use findnocase() and then how to strip things off? I don't understand how to use these. I looked at the help menu, but I don't understand it. Thanks. Andy ... View more

I'm not sure I understand since I can get this code to work on my company search page with the feedback info table. I have attached the company search code. The only part of the code that is different is the where statement and I did not change the join statement at all. Do you have any ideas on how I could change the where statement? I think it's not working because of trying to search for a name on 3 different fields and the company search works since it's only searching on 1 field. <CFQUERY NAME="CompanySearch" Datasource="#application.DataSource#"> SELECT ContactID, RFQID, RFQID_SPEC, ItemID, Company, Company_Name, Company_Classification, First, Middle, Last, Standard_Part_Number, Generic_Description, Sales_Order_Number, CFID, CF_ItemID, CF_RFQID, CF_Date_Registered, CF_Handled_By, CF_Feedback_Concerns, CF_Resolution, CF_Comments FROM ((((Contacts LEFT JOIN RFQ_Numbers ON RFQ_Numbers.Contact_Num = Contacts.ContactID) LEFT JOIN Companies ON Contacts.Company = Companies.Company_Name) LEFT JOIN RFQ_SPEC ON RFQ_Numbers.RFQID = RFQ_SPEC.RFQID_SPEC) LEFT JOIN Customer_Feedback_Register ON RFQ_SPEC.ItemID = Customer_Feedback_Register.CF_ItemID) WHERE Company_Name LIKE '%#SearchCompany#%' AND CF_RFQID >0 And (CF_Feedback_Concerns is Not Null or CF_Resolution is Not Null or CF_Comments Is Not Null) <!--- And Contacts.RFQ_Num >=0 ---> ORDER BY #set_order# </CFQUERY> Andy ... View more