Hello All

I have a stored procedure that would take an input value from a select box on the webpage and display the results in the page below.

How would I do something like this. I am very new to List X.

Please help (I have posted my code below)

Thanks

<?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>true</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>30000</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>true</enabledForcedQuerySplit>
<searchItems />
<queryItems />
<listItems>
<anyType xsi:type="ListFormatItem">
<Index>0</Index>
<GroupStatement>Drop Down List</GroupStatement>
<ListHeader><TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0>

<select id='frmClassification" name='frmClassification" onchange="lxFetch([ModuleID],0,'');", "class="SearchNormalText">
<option value="">select</option>
{SUBQUERY,

frmClassification,

Query="Select JobClassificationID, JobClassificationDescription from OOW.Jobclassification",

Format="<option vaue='\[JobClassificationID\]'>\[JobClassificationDescription\]</option>",

SelectedFormat="<option value='\[JobClassificationID\]' SELECTED>\[JobClassificationDescription\]</option>",
SelectedField="JobClassificationID",
Selecteditems="[frmClassification,form]", UseCache="False"}</select></ListHeader>
<ListFooter></table></ListFooter>
</anyType>
<anyType xsi:type="ListFormatItem">
<Index>1</Index>
<GroupStatement>My Eligibility Header</GroupStatement>
<ListHeader><TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0>



<TR mygroup="Group A" bgcolor="#8FB9E9" BORDER=1 CELLSPACING=1 FORECOLOR="#FFFFFF">
<TD WIDTH=5% FONT COLOR="#FFFFFF" align="left" nowrap>Sequence</TD>
<TD WIDTH=10% FONT COLOR="#FFFFFF" align="left" nowrap>Last Name</TD>
<TD WIDTH=10% FONT COLOR="#FFFFFF" align="center">First Name</TD>
<TD WIDTH=10% FONT COLOR="#FFFFFF" align="center">Classification</TD>
<TD WIDTH=10% FONT COLOR="#FFFFFF" align="right">Status</TD>
<TD WIDTH=15% FONT COLOR="#FFFFFF" align="right">Local</TD>
<TD WIDTH=15% FONT COLOR="#FFFFFF" align="right">Last Work</TD>
<TD WIDTH=10% FONT COLOR="#FFFFFF" align="right">Days Charged</TD>
<TD WIDTH=15% FONT COLOR="#FFFFFF" align="right">OOW Date</TD>
</TR>
</ListHeader>
<ListFooter></TABLE></ListFooter>
</anyType>
</listItems>
<messageItems />
<query>exec oow.getoowinformationwebsite [frmClassification,Form]</query>
<filter />
<customConnection>Provider=SQLOLEDB.1;Password=89score;Persist Security Info=True;User ID=sa;Initial Catalog=C_2200;Data Source=BSFS6</customConnection>
<listItem><TR bgcolor="#CCCCCC" mygroup="Group A">
<TD WIDTH=5% align="left">[DisplayOrder]</TD>
<TD WIDTH=10% align="left">[LastName]</TD>
<TD WIDTH=10% align="left">[FirstName]</TD>
<TD WIDTH=10% align="left">[JobClassificationDescription]</TD>
<TD WIDTH=10% align="right">[PrimaryStatusCode]</TD>
<TD WIDTH=15% align="right">[HomeLocal]</TD>
<TD WIDTH=20% align="left">[LastWorkDate]</TD>
<TD WIDTH=15% align="left">[DaysCharged]</TD>
<TD WIDTH=15% align="right">[OOWDate]</TD>
</TR>
</listItem>
<listAItem><TR bgcolor="#FFFFFF" mygroup="Group A">
<TD WIDTH=5% align="left">[DisplayOrder]</TD>
<TD WIDTH=10% align="left">[LastName]</TD>
<TD WIDTH=10% align="left">[FirstName]</TD>
<TD WIDTH=10% align="left">[JobClassificationDescription]</TD>
<TD WIDTH=10% align="right">[PrimaryStatusCode]</TD>
<TD WIDTH=15% align="right">[HomeLocal]</TD>
<TD WIDTH=20% align="left">[LastWorkDate]</TD>
<TD WIDTH=15% align="left">[DaysCharged]</TD>
<TD WIDTH=15% align="right">[OOWDate]</TD>
</TR></listAItem>
<defaultItem />
<noqueryItem />
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>