| | |
delete and refresh search results
Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
Hello all..I am working on a search script that I am using AJAX and dynamic html to show results within a table. based on the users search criteria, I display the results and a summary of those results as well. I allow the user to delete results by row and a function is called to refresh the search criteria and redisplay the results and summary based on the results minus the deleted row. Everything works fine on the first deletion, but if I try to delete a second row of the refreshed results, I end up with the original result set redisplaying. My code is as follows:
I need the function submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\" to work each time the users deletes a row, not just on the first pass...
any suggestions/help would be greatly appreciated...........
javascript Syntax (Toggle Plain Text)
//initial function to display search results function submit_createBatch_search() { var orderString = orderSearchArray.join("~"); document.getElementById("orderString").value = orderString; //alert(orderString); var location = document.getElementById('location').value; var chemicals = document.getElementById('chemicals').value; var startDate = document.getElementById('startDate').value; var endDate = document.getElementById('endDate').value; var page = "dbQuery.php?mode=getSearchData&location=" + location + "&chemicals=" + chemicals + "&startDate=" + startDate + "&endDate=" + endDate + "&orderString=" + orderString ; var returnData = process_AJAX(page,1); var resultArray = returnData.split("||"); //alert (resultArray); //the table below displays the results of the search and allows the user to delete any particular row by calling the function 'submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\" --> carring the bc_id of the array var dataTable = document.getElementById('SearchTable'); var numRows = dataTable.rows.length; if (numRows > 1) { //Delete all previous data in result table for (var i = numRows; i > 1; i--) { var rowIndexValue = i - 1; dataTable.deleteRow(rowIndexValue); } } ////ensures that there is data in the response text if (resultArray[0] != '') { orderResultArray.length = 0; for (var i = 0; i < resultArray.length -1; i++) { var resultArrayContent = resultArray[i].split("~"); var newRow = dataTable.insertRow(-1); var ID = newRow.insertCell(0); var bc_id = newRow.insertCell(1); var location = newRow.insertCell(2); var releaseDate = newRow.insertCell(3); var chemical = newRow.insertCell(4); var uom = newRow.insertCell(5); var carrier = newRow.insertCell(6); var grower = newRow.insertCell(7); var farm = newRow.insertCell(8); var field = newRow.insertCell(9); var rowID = i + 1; ID.innerHTML="<img src= '../images/delete.gif' onClick='submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\");'/>"; bc_id.innerHTML=resultArrayContent[0]; location.innerHTML=resultArrayContent[1]; releaseDate.innerHTML=resultArrayContent[2]; chemical.innerHTML=resultArrayContent[3]; uom.innerHTML=resultArrayContent[4]; carrier.innerHTML=resultArrayContent[8]; grower.innerHTML=resultArrayContent[5]; farm.innerHTML=resultArrayContent[6]; field.innerHTML=resultArrayContent[7]; field.innerHTML=resultArrayContent[9]; orderResultArray.push(resultArrayContent[0]); } } ////////the following table displays the summary results of the above table var BatchTable = document.getElementById('BatchSummary'); var numRows = BatchTable.rows.length; if (numRows > 1) { //Delete all previous data in result table for (var i = numRows; i > 1; i--) { var rowIndexValue = i - 1; BatchTable.deleteRow(rowIndexValue); } } ////ensures that there is data in the response text if (resultArray[0] != '') { for (var i = 0; i < resultArray.length -1; i++) { var resultArrayContent = resultArray[i].split("~"); var newRow = BatchTable.insertRow(-1); var Title = newRow.insertCell(0); var blankA = newRow.insertCell(1); var blankB = newRow.insertCell(2); var blankC = newRow.insertCell(3); var blankF = newRow.insertCell(4); var blankAA = newRow.insertCell(5); Title.innerHTML="<B>Batch Summary</B>"; blankA.innerHTML=""; blankB.innerHTML=""; blankC.innerHTML=""; blankF.innerHTML=""; blankAA.innerHTML=""; var newRow2 = BatchTable.insertRow(-1); var ChemicalLabel = newRow2.insertCell(0); var Chemical = newRow2.insertCell(1); var blankG = newRow2.insertCell(2); var BatchLabel = newRow2.insertCell(3); var Batch = newRow2.insertCell(4); ChemicalLabel.innerHTML="Product:"; Chemical.innerHTML=resultArrayContent[3]; blankG.innerHTML=""; BatchLabel.innerHTML="Batch Name:"; Batch.innerHTML="<input name=\"batch\" type=\"text\" size=\"30\" maxlength=\"25\" />"; var newRow3 = BatchTable.insertRow(-1); var AmountLabel = newRow3.insertCell(0); var Amount = newRow3.insertCell(1); var blankH = newRow3.insertCell(2); var PilotLabel = newRow3.insertCell(3); var Pilot = newRow3.insertCell(4); AmountLabel.innerHTML="Amount:"; Amount.innerHTML=resultArrayContent[10]; blankH.innerHTML=""; PilotLabel.innerHTML="Pilot:"; Pilot.innerHTML="<select name=\"pilot\"><option>Chris Haak</option> </select>"; var newRow4 = BatchTable.insertRow(-1); var blankD = newRow4.insertCell(0); var blankE = newRow4.insertCell(1); var blankBB = newRow4.insertCell(2); var MixingLabel = newRow4.insertCell(3); var MixingLocation = newRow4.insertCell(4); blankD.innerHTML=""; blankE.innerHTML=""; blankBB.innerHTML=""; MixingLabel.innerHTML="Junge Mixing Location:"; MixingLocation.innerHTML="<select name=\"mixingLocation\"><option>Virden</option> <option>Lincoln</option></select>"; var newRow5 = BatchTable.insertRow(-1); var CarrierLabel = newRow5.insertCell(0); var Carrier = newRow5.insertCell(1); var blank1 = newRow5.insertCell(2); var blank2 = newRow5.insertCell(3); CarrierLabel.innerHTML="Carrier:"; Carrier.innerHTML=resultArrayContent[8]; blank1.innerHTML=""; blank2.innerHTML=""; var newRow6 = BatchTable.insertRow(-1); var CAmountLabel = newRow6.insertCell(0); var CarrierAmount = newRow6.insertCell(1); var blank3 = newRow6.insertCell(2); var blank4 = newRow6.insertCell(3); CAmountLabel.innerHTML="Amount:"; CarrierAmount.innerHTML=resultArrayContent[11]; blank3.innerHTML=""; blank4.innerHTML=""; //alert(resultArray.length); } var newRow7 = BatchTable.insertRow(-1); var blank5 = newRow7.insertCell(0); var blank6 = newRow7.insertCell(1); var Save = newRow7.insertCell(2); var Cancel = newRow7.insertCell(3); blank5.innerHTML=""; blank6.innerHTML=""; Save.innerHTML="<button type=button name=\"Save\" onClick=\"save_Batch();\">Save</button>"; Cancel.innerHTML="<button type=button name=\"Cancel\" onClick=\"cancel_Batch();\">Cancel</button>"; } }///end of function for search results ///the following function resummarizes and redisplays the results after the user deletes one of the search results function submit_Resummarize_Batch_search(deleteOrderId) { for (var i=0; i<orderResultArray.length; i++) { if (deleteOrderId == orderResultArray[i]) { orderResultArray.splice(i,1); } } var orderString = orderResultArray.join("~"); document.getElementById("orderString").value = orderString; //alert(orderString); var page = "dbQuery.php?mode=getSearchData&orderString=" + orderString; var returnData = process_AJAX(page,1); var resultArray = returnData.split("||"); //alert (resultArray); /// redisplaying the search results after deleting a row var dataTable = document.getElementById('SearchTable'); var numRows = dataTable.rows.length; if (numRows > 1) { //Delete all previous data in result table for (var i = numRows; i > 1; i--) { var rowIndexValue = i - 1; dataTable.deleteRow(rowIndexValue); } } ////ensures that there is data in the response text if (resultArray[0] != '') { orderResultArray.length = 0; for (var i = 0; i < resultArray.length -1; i++) { var resultArrayContent = resultArray[i].split("~"); var newRow = dataTable.insertRow(-1); var ID = newRow.insertCell(0); var bc_id = newRow.insertCell(1); var location = newRow.insertCell(2); var releaseDate = newRow.insertCell(3); var chemical = newRow.insertCell(4); var uom = newRow.insertCell(5); var carrier = newRow.insertCell(6); var grower = newRow.insertCell(7); var farm = newRow.insertCell(8); var field = newRow.insertCell(9); var rowID = i + 1; ID.innerHTML="<img src= '../images/delete.gif' onClick='submit_Resummarize_Batch_search("+resultArrayContent[0]+");'/>"; bc_id.innerHTML=resultArrayContent[0]; location.innerHTML=resultArrayContent[1]; releaseDate.innerHTML=resultArrayContent[2]; chemical.innerHTML=resultArrayContent[3]; uom.innerHTML=resultArrayContent[4]; carrier.innerHTML=resultArrayContent[8]; grower.innerHTML=resultArrayContent[5]; farm.innerHTML=resultArrayContent[6]; field.innerHTML=resultArrayContent[7]; field.innerHTML=resultArrayContent[9]; //alert(resultArray.length); } } ////////this redisplays the summary results after the users deletes a row var BatchTable = document.getElementById('BatchSummary'); var numRows = BatchTable.rows.length; if (numRows > 1) { //Delete all previous data in result table for (var i = numRows; i > 1; i--) { var rowIndexValue = i - 1; BatchTable.deleteRow(rowIndexValue); } } ////ensures that there is data in the response text if (resultArray[0] != '') { for (var i = 0; i < resultArray.length -1; i++) { var resultArrayContent = resultArray[i].split("~"); var newRow = BatchTable.insertRow(-1); var Title = newRow.insertCell(0); var blankA = newRow.insertCell(1); var blankB = newRow.insertCell(2); var blankC = newRow.insertCell(3); var blankF = newRow.insertCell(4); var blankAA = newRow.insertCell(5); Title.innerHTML="<B>Batch Summary</B>"; blankA.innerHTML=""; blankB.innerHTML=""; blankC.innerHTML=""; blankF.innerHTML=""; blankAA.innerHTML=""; var newRow2 = BatchTable.insertRow(-1); var ChemicalLabel = newRow2.insertCell(0); var Chemical = newRow2.insertCell(1); var blankG = newRow2.insertCell(2); var BatchLabel = newRow2.insertCell(3); var Batch = newRow2.insertCell(4); ChemicalLabel.innerHTML="Product:"; Chemical.innerHTML=resultArrayContent[3]; blankG.innerHTML=""; BatchLabel.innerHTML="Batch Name:"; Batch.innerHTML="<input name=\"batch\" type=\"text\" size=\"30\" maxlength=\"25\" />"; var newRow3 = BatchTable.insertRow(-1); var AmountLabel = newRow3.insertCell(0); var Amount = newRow3.insertCell(1); var blankH = newRow3.insertCell(2); var PilotLabel = newRow3.insertCell(3); var Pilot = newRow3.insertCell(4); AmountLabel.innerHTML="Amount:"; Amount.innerHTML=resultArrayContent[10]; blankH.innerHTML=""; PilotLabel.innerHTML="Pilot:"; Pilot.innerHTML="<select name=\"pilot\"><option>Chris Haak</option> </select>"; var newRow4 = BatchTable.insertRow(-1); var blankD = newRow4.insertCell(0); var blankE = newRow4.insertCell(1); var blankBB = newRow4.insertCell(2); var MixingLabel = newRow4.insertCell(3); var MixingLocation = newRow4.insertCell(4); blankD.innerHTML=""; blankE.innerHTML=""; blankBB.innerHTML=""; MixingLabel.innerHTML="Junge Mixing Location:"; MixingLocation.innerHTML="<select name=\"mixingLocation\"><option>Virden</option> <option>Lincoln</option></select>"; var newRow5 = BatchTable.insertRow(-1); var CarrierLabel = newRow5.insertCell(0); var Carrier = newRow5.insertCell(1); var blank1 = newRow5.insertCell(2); var blank2 = newRow5.insertCell(3); CarrierLabel.innerHTML="Carrier:"; Carrier.innerHTML=resultArrayContent[8]; blank1.innerHTML=""; blank2.innerHTML=""; var newRow6 = BatchTable.insertRow(-1); var CAmountLabel = newRow6.insertCell(0); var CarrierAmount = newRow6.insertCell(1); var blank3 = newRow6.insertCell(2); var blank4 = newRow6.insertCell(3); CAmountLabel.innerHTML="Amount:"; CarrierAmount.innerHTML=resultArrayContent[11]; blank3.innerHTML=""; blank4.innerHTML=""; //alert(resultArray.length); } var newRow7 = BatchTable.insertRow(-1); var blank5 = newRow7.insertCell(0); var blank6 = newRow7.insertCell(1); var Save = newRow7.insertCell(2); var Cancel = newRow7.insertCell(3); blank5.innerHTML=""; blank6.innerHTML=""; Save.innerHTML="<button type=button name=\"Save\" onClick=\"save_Batch();\">Save</button>"; Cancel.innerHTML="<button type=button name=\"Cancel\" onClick=\"cancel_Batch();\">Cancel</button>"; } }///end of function for search results
I need the function submit_Resummarize_Batch_search(\""+resultArrayContent[0]+"\" to work each time the users deletes a row, not just on the first pass...
any suggestions/help would be greatly appreciated...........
Last edited by peter_budo; Jul 6th, 2008 at 3:44 pm. Reason: Corecting tags, use [code=langauage] not [code = javascript] :-)
I keep hitting "escape", but I'm still here!!!!
:}
:}
![]() |
Similar Threads
- Updating an Access database with a secondary form (VB.NET)
- OEM PC -Windows XP Home (oem) does not complete installation-set up loops (Troubleshooting Dead Machines)
- Cachecachekit! (Viruses, Spyware and other Nasties)
- For Ny4windserboy02: rundll.exe not responding on shutdown....HijackThis log included (Viruses, Spyware and other Nasties)
- trojan.cachecachekit and more (Viruses, Spyware and other Nasties)
- Need Expert Help (Viruses, Spyware and other Nasties)
- I have a probelem with pop-ups and shortcuts left on my desktop (Viruses, Spyware and other Nasties)
- Inundated with popups (Viruses, Spyware and other Nasties)
- Need help (Visual Basic 4 / 5 / 6)
Other Threads in the JavaScript / DHTML / AJAX Forum
- Previous Thread: Please Help Me!
- Next Thread: Help please
| Thread Tools | Search this Thread |
acid2 ajax ajaxcode ajaxexample ajaxhelp ajaxjspservlets animate array automatically beta box browser bug calendar captchaformproblem cart close codes column css cursor date debugger decimal dependent design disablefirebug dom download dropdown element embed engine enter error events ext file firefox focus form frameworks getselection google gwt gxt hiddenvalue highlightedword hint html htmlform ie7 iframe index java javascript javascripthelp2020 jawascriptruntimeerror jquery jsp libcurl listbox maps masterpage media menu microsoft mimic mp4 onmouseoutdivproblem onmouseover paypal pdf php player position post problem programming progressbar prototype redirect regex safari scale scriptlets scroll search security select software sql text textarea unicode w3c website window windowofwords windowsxp





