Not Found
|
-
The database search failed due to an unexpected error.
This is the HTML code that was being processed:
<mgiSearchDatabase databaseName="VWW"
searchString="Client='Sample' AND Division='Sales' AND Contest='*' ORDER BY Progress DESC"
resultsPerPage="50"
page="1"
resultVariableName="ResultsSearch">
<noedit>
<mgiSet name="Client_Number">&mgiDBFieldClient_Number;</mgiSet>
<mgiSet name="Client">&mgiDBFieldClient;</mgiSet>
<mgiSet name="Division">&mgiDBFieldDivision;</mgiSet>
<mgiSet name="Name">&mgiDBFieldName;</mgiSet>
<mgiSet name="Goal">&mgiDBFieldGoal;</mgiSet>
<mgiSet name="Progress">&mgiDBFieldProgress;</mgiSet>
<mgiSet name="End_Date_Month">&mgiDBFieldEnd_Date_Month;</mgiSet>
<mgiSet name="End_Date_Day">&mgiDBFieldEnd_Date_Day;</mgiSet>
<mgiSet name="End_Date_Year">&mgiDBFieldEnd_Date_Year;</mgiSet>
<mgiSet name="Julian_End_Date">&mgiDBFieldJulian_End_Date;</mgiSet>
<mgiSet name="Julian_Current_Date">&mgiDBFieldJulian_Current_Date;</mgiSet>
<mgiSet name="Winner">&mgiDBFieldWinner;</mgiSet>
<mgiSet name="Category">&mgiDBFieldCategory;</mgiSet>
<mgiSet name="Contest">&mgiDBFieldContest;</mgiSet>
<mgiSet name="Comments">&mgiDBFieldComments;</mgiSet>
<mgiSet name="Notes">&mgiDBFieldNotes;</mgiSet>
<mgiSet name="Color">&mgiDBFieldColor;</mgiSet>
<mgiSet name="GWidth">300</mgiSet>
<mgiSet name="PWidth"><mgiMath resultPrecision="2" displayPrecision="0">(( <mgiGet name="Progress"> / <mgiGet name="Goal"> )*100)* 3</mgiMath></mgiSet>
<mgiSet name="Ppercent"><mgiMath resultPrecision="2" displayPrecision="0">(( <mgiGet name="Progress"> / <mgiGet name="Goal"> )*100)</mgiMath></mgiSet>
<mgiComment> Put Commas in Goal Number </mgiComment>
<mgiIf lhs={mgiGet name="Goal"} relationship=">" rhs="1000">
<mgiSet name="Count"><mgiString mode="getCharacterCount"><mgiGet name="Goal"></mgiString></mgiSet>
<mgiSwitch value={mgiGet name="Count"}>
<mgiCase value="6">
<mgiSet name="ShowGoal">$<mgiString mode="insert" stringToInsert="," index="4" quoteResult="No"><mgiGet name="Goal"></mgiString></mgiSet>
</mgiCase>
<mgiCase value="7">
<mgiSet name="ShowGoal">$<mgiString mode="insert" stringToInsert="," index="6" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Goal"></mgiString></mgiString>
</mgiSet>
</mgiCase>
<mgiCase value="8">
<mgiSet name="ShowGoal">$<mgiString mode="insert" stringToInsert="," index="7" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Goal"></mgiString></mgiString></mgiSet>
</mgiCase>
<mgiCase value="9">
<mgiSet name="ShowGoal">$<mgiString mode="insert" stringToInsert="," index="8" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="4" quoteResult="No"><mgiGet name="Goal"></mgiString></mgiString></mgiSet>
</mgiCase>
<mgiCase value="10">
<mgiSet name="ShowGoal">$<mgiString mode="insert" stringToInsert="," index="10" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="6" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Goal"></mgiString></mgiString></mgiString></mgiSet>
</mgiCase>
</mgiSwitch>
<mgiElse>
<mgiSet name="ShowGoal"><mgiGet name="Goal"> Points</mgiSet>
</mgiIf>
<mgiComment> Put Commas in Progress Number </mgiComment>
<mgiIf lhs={mgiGet name="Progress"} relationship=">" rhs="1000">
<mgiSet name="Count"><mgiString mode="getCharacterCount"><mgiGet name="Progress"></mgiString></mgiSet>
<mgiSwitch value={mgiGet name="Count"}>
<mgiCase value="5">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="3" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiSet>
</mgiCase>
<mgiCase value="6">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="4" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiSet>
</mgiCase>
<mgiCase value="7">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="6" quoteResult="No">
<mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiString>
</mgiSet>
</mgiCase>
<mgiCase value="8">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="7" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiString></mgiSet>
</mgiCase>
<mgiCase value="9">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="8" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="4" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiString></mgiSet>
</mgiCase>
<mgiCase value="10">
<mgiSet name="ShowProgress">$<mgiString mode="insert" stringToInsert="," index="10" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="6" quoteResult="No"><mgiString mode="insert" stringToInsert="," index="2" quoteResult="No"><mgiGet name="Progress"></mgiString></mgiString></mgiString></mgiSet>
</mgiCase>
<mgiCase>
<mgiSet name="ShowProgress">$<mgiGet name="Progress"></mgiSet>
</mgiCase>
</mgiSwitch>
<mgiElse>
<mgiSet name="ShowProgress"><mgiGet name="Progress"></mgiSet>
</mgiIf>
<mgiComment> Determine how many days left in contest </mgiComment>
<mgiSet name="Julian_Day"><mgiJulianDay dateOnly="yes"></mgiSet>
<mgiSet name="Today"><mgiJulianDay julianDay={mgiGet name="Julian_Day"} format="DayOfYear"></mgiSet>
<mgiSet name="End_Date"><mgiJulianDay julianDay={mgiGet name="Julian_End_Date"} format="DayOfYear"></mgiSet>
<mgiSet name="DaysLeft"><mgiMath resultPrecision="2" displayPrecision="0"><mgiGet name="End_Date">-<mgiGet name="Today"></mgiMath></mgiSet>
</noedit>
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td class="eleven" align="left" valign="top" width="300"><b><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular"><mgiGet name="Name"></font></b>
</td>
<noedit><mgiIf lhs={mgiGet name="Goal"} relationship="<>" rhs="0">
<td class="eleven" align="left" valign="top"><b>| Goal:
<mgiGet name="ShowGoal"></b>
</td>
<mgiElse>
<td class="eleven" align="left" valign="top"></td>
</mgiIf></noedit>
</tr>
<tr>
<td class="eleven" colspan="2" align="left" valign="top">
<table width="580" border="0" cellspacing="1" cellpadding="0">
<tr>
<td bgcolor={mgiGet name="Color"} width={mgiGet name="PWidth"}><noedit><mgiIf lhs={mgiGet name="Goal"} relationship="<>" rhs="0"><img src="../Graphics/shim.gif" alt="Progress Bar" width={mgiGet name="PWidth"} height="10" border="0"></mgiIf></noedit></td>
<td class="ten"> <mgiGet name="ShowProgress"> - <noedit><mgiIf lhs={mgiGet name="Goal"} relationship="<>" rhs="0"><mgiGet name="Ppercent">% of Goal</mgiIf></noedit></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="eleven" colspan="2" align="left" valign="top">
<mgiGet name="Comments">
</td>
</tr>
<tr>
<td class="eleven" colspan="2" align="right" valign="top">
<mgiComment>
<form action="DataUpdate.htm" method="Post" name="DataUpdate">
<div align="right">
<input type="hidden" name="Client_Number" value={mgiGet name="Client_Number"} border="0">
<mgiButton imageLocation="http://voyagerworldwide.com/Graphics/UpdateButton.jpg">
</div>
</form>
</mgiComment>
</td>
<td class="eleven" align="left" valign="top">
</td>
</tr>
<tr>
<td class="eleven" colspan="2" align="left" valign="top" bgcolor="#666699"><img src="../CLIENTS_AREA/GRAPHICS/shim.gif" alt="" width="1" height="1" border="0"></td>
</tr>
</table>
</mgiSearchDatabase> |
Try this...
|
-
Check the syntax of your search criteria and try the search again.
|