Have modified for the most part successfully the Doctors LP, The issue I am having is I modified the "Physicians" page for what I had needed. Everything except the search feature is working GREAT!!!! The search feature is not working I enter criteria and it shows as if fetching data. But when you access actions in debugging it shows the "filter" action as false.

I have gone over and over the variables and actions. As well as the code about a hundred times and just can not find where I have made the error.....

Any assistance with this matter would be GREATLY appreciated.

Is there anyone available to take a quick look at the code? The filter/search feature is the last bit of functionality I need to get working properly and it has me stumpped! I have gone through it time and time again and it's as if the filter action is not executing.

Hello Jfkidd,
Please attach your configuration and we may be able to help find the problem.
Thanks,

The following is for the Search Module:

<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<recordsPerPage>0</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableHide_OnNoQuery>false</enableHide_OnNoQuery>
<enableHide_OnNoResults>false</enableHide_OnNoResults>
<enableAdvancedParsing>true</enableAdvancedParsing>
<enableCompoundIIFConditions>true</enableCompoundIIFConditions>
<enableQueryDebug>false</enableQueryDebug>
<enableQueryDebug_Edit>false</enableQueryDebug_Edit>
<enableQueryDebug_Admin>false</enableQueryDebug_Admin>
<enableQueryDebug_Super>true</enableQueryDebug_Super>
<enableQueryDebug_Log>false</enableQueryDebug_Log>
<enableQueryDebug_ErrorLog>false</enableQueryDebug_ErrorLog>
<autoRefreshInterval />
<skipRedirectActions>false</skipRedirectActions>
<skipSubqueryDebugging>false</skipSubqueryDebugging>
<enableAdmin_Edit>true</enableAdmin_Edit>
<enableAdmin_Admin>false</enableAdmin_Admin>
<enableAdmin_Super>false</enableAdmin_Super>
<enableAJAX>true</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<enableAJAXManual>false</enableAJAXManual>
<includeJavascriptUtilities>true</includeJavascriptUtilities>
<includeJavascriptValidation>true</includeJavascriptValidation>
<javascriptOnComplete />
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>true</showAll>
<useExplicitSystemVariables>true</useExplicitSystemVariables>
<enabledForcedQuerySplit>false</enabledForcedQuerySplit>
<searchItems />
<queryItems />
<listItems />
<messageItems />
<query />
<filter />
<customConnection />
<listItem />
<listAItem />
<defaultItem />
<noqueryItem><SCRIPT>
function clearFilter()
{
document.getElementById('txtFlt_Stock_ID').value = "";
document.getElementById('cboFlt_Dealership').selectedIndex = 0;
}
</SCRIPT>

<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td class=SubHead nowrap width=150>Stock Number</td>
<td class=NormalTextBox nowrap width=100% colspan=3><input type=textbox id=txtFlt_Stock_ID name=txtFlt_Stock_ID value="[filter[TABID,SYSTEM]_Stock_ID,S]" style="WIDTH: 100%;"></td>
</tr>
<tr>
<td class=SubHead nowrap width=150>Dealership</td>
<td class=NormalTextBox nowrap width=100% ><select id=cboFlt_Dealership name=cboFlt_Dealership style="WIDTH: 50%;" onChange="lxFetch(lxList,0,'Action=Filter');">
<option value=""/>

{SUBQUERY,Name="qryDealership",Query="SELECT DISTINCT Dealership AS lu_Dealership FROM ATC_Pub_Units ORDER BY Dealership",Format="
<option value=""[lu_Dealership]"">[lu_Dealership]</option>
",SelectedFormat="
<option value=""[lu_Dealership]"" SELECTED>[lu_Dealership]</option>
",SelectedField="lu_Dealership",SelectedItems="[filter[TABID,SYSTEM]_Dealership,S]"}

</select></td>
</tr>
<tr class=FileManager_Pager>
<td colspan=4 align=right style="PADDING-RIGHT: 16px;"><span style="PADDING-RIGHT: 16px;"><img id="tbiFilter" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/TBI_Filter.gif' onClick="lxFetch(lxList, 0, 'Action=Filter');" onMouseOver="this.src='[PORTALPATH,System]/Images/TBI_FilterMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/TBI_Filter.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/TBI_FilterMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/TBI_Filter.gif'"></span><img id="tbiClear" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/TBI_Clear.gif' onClick="clearFilter(); lxFetch(lxList, 0, 'Action=Filter');" onMouseOver="this.src='[PORTALPATH,System]/Images/TBI_ClearMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/TBI_Clear.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/TBI_ClearMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/TBI_Clear.gif'"></td>
</tr>
</table></noqueryItem>
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>

and this is the Data Grid:

<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<recordsPerPage>50</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>true</enablePageSelection>
<enableRecordsPerPage>true</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableHide_OnNoQuery>false</enableHide_OnNoQuery>
<enableHide_OnNoResults>false</enableHide_OnNoResults>
<enableAdvancedParsing>true</enableAdvancedParsing>
<enableCompoundIIFConditions>true</enableCompoundIIFConditions>
<enableQueryDebug>false</enableQueryDebug>
<enableQueryDebug_Edit>false</enableQueryDebug_Edit>
<enableQueryDebug_Admin>false</enableQueryDebug_Admin>
<enableQueryDebug_Super>true</enableQueryDebug_Super>
<enableQueryDebug_Log>false</enableQueryDebug_Log>
<enableQueryDebug_ErrorLog>false</enableQueryDebug_ErrorLog>
<autoRefreshInterval />
<skipRedirectActions>false</skipRedirectActions>
<skipSubqueryDebugging>false</skipSubqueryDebugging>
<enableAdmin_Edit>false</enableAdmin_Edit>
<enableAdmin_Admin>true</enableAdmin_Admin>
<enableAdmin_Super>false</enableAdmin_Super>
<enableAJAX>true</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<enableAJAXManual>false</enableAJAXManual>
<includeJavascriptUtilities>true</includeJavascriptUtilities>
<includeJavascriptValidation>true</includeJavascriptValidation>
<javascriptOnComplete />
<enableMultipleColumnSorting>true</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>false</showAll>
<useExplicitSystemVariables>true</useExplicitSystemVariables>
<enabledForcedQuerySplit>false</enabledForcedQuerySplit>
<searchItems />
<queryItems>
<anyType xsi:type="QueryOptionItem">
<Index>0</Index>
<VariableType><Session></VariableType>
<QuerySource>filter[TABID,SYSTEM]_Dealership</QuerySource>
<QueryTarget>@FilterDealership</QueryTarget>
<QueryTargetLeft>ATC_Pub2print.Dealership IN (</QueryTargetLeft>
<QueryTargetRight>)</QueryTargetRight>
<QueryTargetEmpty>1=1</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>1</Index>
<VariableType><Session></VariableType>
<QuerySource>filter[TABID,SYSTEM]_Stock_ID</QuerySource>
<QueryTarget>@FilterStock_ID</QueryTarget>
<QueryTargetLeft>Stock_ID LIKE '</QueryTargetLeft>
<QueryTargetRight>%'</QueryTargetRight>
<QueryTargetEmpty>1=1</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>2</Index>
<VariableType><form>></VariableType>
<QuerySource>txtATC_Stk_Num</QuerySource>
<QueryTarget>@ATC_Stk_Num</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>3</Index>
<VariableType><form>></VariableType>
<QuerySource>txtDealership</QuerySource>
<QueryTarget>@Dealership</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>4</Index>
<VariableType><form>></VariableType>
<QuerySource>cboDealership</QuerySource>
<QueryTarget>@Dealership</QueryTarget>
<QueryTargetLeft />
<QueryTargetRight />
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>5</Index>
<VariableType><form>></VariableType>
<QuerySource>txtImage_URL</QuerySource>
<QueryTarget>@Image_URL</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>6</Index>
<VariableType><form>></VariableType>
<QuerySource>txtStock_ID</QuerySource>
<QueryTarget>@Stock_ID</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>7</Index>
<VariableType><form>></VariableType>
<QuerySource>txtCar_ID</QuerySource>
<QueryTarget>@CarIDfrm</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>8</Index>
<VariableType><form>></VariableType>
<QuerySource>txtMileage</QuerySource>
<QueryTarget>@Mileage</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>9</Index>
<VariableType><form>></VariableType>
<QuerySource>txtAddress</QuerySource>
<QueryTarget>@Address</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>10</Index>
<VariableType><form>></VariableType>
<QuerySource>txtSource</QuerySource>
<QueryTarget>@Source</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>11</Index>
<VariableType><QueryString></VariableType>
<QuerySource>CurrentCar_ID</QuerySource>
<QueryTarget>@Car_ID</QueryTarget>
<QueryTargetLeft />
<QueryTargetRight />
<QueryTargetEmpty>-1</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>12</Index>
<VariableType><form>></VariableType>
<QuerySource>txtPrice</QuerySource>
<QueryTarget>@Price</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>13</Index>
<VariableType><form>></VariableType>
<QuerySource>txtPhone</QuerySource>
<QueryTarget>@Phone</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>14</Index>
<VariableType><form>></VariableType>
<QuerySource>txtModel</QuerySource>
<QueryTarget>@Model</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>15</Index>
<VariableType><form>></VariableType>
<QuerySource>txtColor</QuerySource>
<QueryTarget>@Color</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>16</Index>
<VariableType><form>></VariableType>
<QuerySource>txtYear</QuerySource>
<QueryTarget>@Year</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>17</Index>
<VariableType><form>></VariableType>
<QuerySource>txtTrim</QuerySource>
<QueryTarget>@Trim</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>18</Index>
<VariableType><form>></VariableType>
<QuerySource>txtMake</QuerySource>
<QueryTarget>@Make</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>19</Index>
<VariableType><form>></VariableType>
<QuerySource>txtCity</QuerySource>
<QueryTarget>@City</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>20</Index>
<VariableType><form>></VariableType>
<QuerySource>txtZip</QuerySource>
<QueryTarget>@Zip</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>21</Index>
<VariableType><form>></VariableType>
<QuerySource>txtVIN</QuerySource>
<QueryTarget>@VIN</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>22</Index>
<VariableType><form>></VariableType>
<QuerySource>txtDID</QuerySource>
<QueryTarget>@DID</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>23</Index>
<VariableType><form>></VariableType>
<QuerySource>txtST</QuerySource>
<QueryTarget>@ST</QueryTarget>
<QueryTargetLeft>'</QueryTargetLeft>
<QueryTargetRight>'</QueryTargetRight>
<QueryTargetEmpty>NULL</QueryTargetEmpty>
<Protected>true</Protected>
<EscapeHTML>false</EscapeHTML>
<EscapeListX>0</EscapeListX>
</anyType>
</queryItems>
<listItems>
<anyType xsi:type="ListFormatItem">
<Index>0</Index>
<GroupStatement>Header/Footer</GroupStatement>
<ListHeader><script language=javascript>//DECLARE THE RECORD ID BEFORE CHECKS - THIS ENSURES ONLY ONE OPEN EDITOR AT A TIMEvar lxCar_IDsEditID = '';
</script><table width=100% border=0 cellpadding=0 cellspacing=0 class=DataGrid_Container>
<tr class=DataGrid_Header><td nowrap="nowrap" style="WIDTH:32px;">&nbsp;</td>
<td nowrap="nowrap" style="WIDTH:10px;">&nbsp;</td><td nowrap="nowrap" style="WIDTH:64px;" align="left"><a {SORT,Stock_ID,Stock#,"Stock# <img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Stock# <img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,1}>{SORTHEADER,1}</a></td><td nowrap="nowrap" style="WIDTH:150px;" align="left"><a {SORT,Dealership,Dealer,"Dealer <img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Dealer <img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,2}>{SORTHEADER,2}</a></td><td nowrap="nowrap" style="WIDTH:64px;" align="left"><a {SORT,Year,Year,"Year<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Year<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,3}>{SORTHEADER,3}</a></td><td nowrap="nowrap" style="WIDTH:96px;" align="left"><a {SORT,Make,Make,"Make<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Make<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,4}>{SORTHEADER,4}</a></td><td nowrap="nowrap" style="WIDTH:96px;" align="left"><a {SORT,Model,Model,"Model<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Model<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,5}>{SORTHEADER,5}</a></td><td nowrap="nowrap" style="WIDTH:96px;" align="left"><a {SORT,Trim,Trim,"Trim<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Trim<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,6}>{SORTHEADER,6}</a></td><td nowrap="nowrap" style="WIDTH:96px;" align="left"><a {SORT,Color,Color,"Color<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Color<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,7}>{SORTHEADER,7}</a></td><td nowrap="nowrap" style="WIDTH:96px;" align="left"><a {SORT,Mileage,Mileage,"Mileage<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Mileage<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,8}>{SORTHEADER,8}</a></td><td nowrap="nowrap" style="WIDTH:64px;" align="left"><a {SORT,Price,Price,"Price<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortAscending.gif border=0>", "Price<img src=[LOCALHOSTALIAS,SYSTEM]/Images/SortDescending.gif border=0>",,9}>{SORTHEADER,9}</a></td><td nowrap="nowrap" style="WIDTH:32px;">&nbsp;</td>
</tr>
<tbody>
</ListHeader>
<ListFooter><tr class=FileManager_Pager><td style="WIDTH: 100%; PADDING-LEFT: 32px;" colspan=4>[FORMAT,[TOTALRECORDS,System],{0:#,##0}] Units</td>
</tr>
</tbody>
</table>
</ListFooter>
</anyType>
</listItems>
<messageItems>
<anyType xsi:type="MessageActionItem">
<Index>0</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:22;1;8;'[Action,QueryString]'='Filter'</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>1</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>12:9;31;24;5;1;<Session>filter[TABID,SYSTEM]_Dealership[cboFlt_Dealership,Form]False0</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>2</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>12:9;28;21;5;1;<Session>filter[TABID,SYSTEM]_StockID[txtFlt_StockID,Form]False0</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>3</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:22;1;6;'[Action,QueryString]'='Save'</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>4</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>10:8;421;5;0;SaveDataIF EXISTS (SELECT * FROM ATC_Pub2print WHERE Car_ID=@Car_ID)
BEGIN
UPDATE ATC_Pub2print SET
Dealership=@Dealership,
Address=@Address,
City=@City,
ST=@ST,
Zip=@Zip,
Phone=@Phone,
ATC_Stk_Num=@ATC_Stk_Num,
DID=@DID,
Year=@Year,
Make=@Make,
Model=@Model,
Price = @Price,
VIN=@VIN,
Color=@Color,
Mileage=@Mileage,
Image_URL=@Image_URL,
Source=@Source,
Car_ID=@CarIDfrm,
Trim=@Trim,
Stock_ID=@Stock_ID
WHERE Car_ID=@Car_ID
ENDFalse</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>5</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:22;1;8;'[Action,QueryString]'='Delete'</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>6</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>10:10;47;5;0;DeleteDataDELETE FROM ATC_Pub2print
WHERE Car_ID=@Car_ID
False</ActionInformation>
<Level>1</Level>
</anyType>
</messageItems>
<query>SELECT Dealership, Address, City, ST, Zip, Phone, ATC_Stk_Num, DID, Year, Make, Model, Price, VIN, Color, Mileage, Image_URL, Source, Car_ID, Trim, Stock_ID
FROM ATC_Pub2print
ORDER BY [SORTTAG]
</query>
<filter />
<customConnection />
<listItem><tr class=DataGrid_Item >
<td nowrap="nowrap">
<img id="tbiEdit[Car_ID]" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/GI_Edit.gif' onclick="if (lxCar_IDsEditID=='') lxFetch(lxEdit,0,'Action=Edit&CurrentCar_ID=[Car_ID]&Page=[PAGENUMBER,System]','Car_ID_[Car_ID]'); return false;" onmouseover="this.src='[PORTALPATH,System]/Images/GI_EditMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/GI_Edit.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/GI_EditMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/GI_Edit.gif'"></div></td>
<td nowrap="nowrap"></td>
<td nowrap="nowrap">[Stock_ID]</td>
<td nowrap="nowrap">[Dealership]</td>
<td nowrap="nowrap">[Year]</td>
<td nowrap="nowrap">[Make]</td>
<td nowrap="nowrap">[Model]</td>
<td nowrap="nowrap">[Trim]</td>
<td nowrap="nowrap">[Color]</td>
<td nowrap="nowrap">[Mileage]</td>
<td nowrap="nowrap">[Price]</td>
<td nowrap="nowrap"><img id="tbiDelete[Car_ID]" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/GI_Delete.gif' onclick="lxFetch([MODULEID,System],0,'Action=Delete&CurrentCar_ID=[Car_ID]&Page=[PAGENUMBER,System]');" onmouseover="this.src='[PORTALPATH,System]/Images/GI_DeleteMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/GI_Delete.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/GI_DeleteMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/GI_Delete.gif'"></td>
</tr>
<tr><td colspan=11 id=Car_ID_[Car_ID]></td></tr></listItem>
<listAItem><tr class=DataGrid_AlternatingItem >
<td nowrap="nowrap">
<img id="tbiEdit[Car_ID]" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/GI_Edit.gif' onclick="if (lxCar_IDsEditID=='') lxFetch(lxEdit,0,'Action=Edit&CurrentCar_ID=[Car_ID]&Page=[PAGENUMBER,System]','Car_ID_[Car_ID]'); return false;" onmouseover="this.src='[PORTALPATH,System]/Images/GI_EditMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/GI_Edit.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/GI_EditMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/GI_Edit.gif'"></div></td>
<td nowrap="nowrap"></td>
<td nowrap="nowrap">[Stock_ID]</td>
<td nowrap="nowrap">[Dealership]</td>
<td nowrap="nowrap">[Year]</td>
<td nowrap="nowrap">[Make]</td>
<td nowrap="nowrap">[Model]</td>
<td nowrap="nowrap">[Trim]</td>
<td nowrap="nowrap">[Color]</td>
<td nowrap="nowrap">[Mileage]</td>
<td nowrap="nowrap">[Price]</td>
<td nowrap="nowrap"><img id="tbiDelete[Car_ID]" border=0 style="CURSOR: hand; CURSOR: pointer;" src='[PORTALPATH,System]/Images/GI_Delete.gif' onclick="lxFetch([MODULEID,System],0,'Action=Delete&CurrentCar_ID=[Car_ID]&Page=[PAGENUMBER,System]');" onmouseover="this.src='[PORTALPATH,System]/Images/GI_DeleteMO.gif'" onmouseout = "this.src='[PORTALPATH,System]/Images/GI_Delete.gif'" onmousedown = "this.src='[PORTALPATH,System]/Images/GI_DeleteMD.gif'" onmouseup = "this.src='[PORTALPATH,System]/Images/GI_Delete.gif'"></td>
</tr>
<tr><td colspan=11 id=Car_ID_[Car_ID]></td></tr></listAItem>
<defaultItem />
<noqueryItem />
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>

Thank you for your assistance

Sorry, Can you attach this as a file?

I have attached the XML files for both the Search and Inventory Display Module

Hi,

I tried to open both the files you have attached and it is giving me an error. Would you mind uploading the files again? I will look into the issue.

Thanks,
Sindura
R2integrated