Order By Column Question (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

dzirkelb1 -> Order By Column Question (1/25/2005 11:30:19)

I have a simple question (I think) for ordering. On my search form, I will have a drop down box containing all of the column names. Next to it will be 2 radio buttons for asc or desc. How do I put this into my sql so when they select a column, then select asc or desc, it will all work correctly?

I am playing around with

SELECT * FROM Table ORDER BY '::SortColumn::'

but that doesn't work...when I type in the column I wish to search by, it simply refreshes the data and doesn't actually sort it. I don't have much of an idea on how to put the asc or desc in depending on the user input.



Spooky -> RE: Order By Column Question (1/25/2005 13:40:24)

Without the quotes - its a name of a column, not an input.

SELECT * FROM Table ORDER BY ::SortColumn::



dzirkelb1 -> RE: Order By Column Question (1/25/2005 14:45:45)

Placing that at the end of my code produces:

Database Results Error
Description: Extra ) in query expression 'IIf((''&''=''), True, CPercentage>=+0) And IIf((''&''=''), True, CPercentage<=+0) And IIf((''&''=''), True, HPercentage>=+0) And IIf((''&''=''), True, HPercentage<=+0) And IIf((''&''=''), True, APercentage>=+0) And IIf((''&''=''), True, APercentage<=+0) A'.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for all form fields that are used in the query.



I want to input which column to sort by...also, I want the user to choose asc or desc. Any ideas on what I'm doing wrong?



Spooky -> RE: Order By Column Question (1/25/2005 14:46:56)

If it works without that code, then Id suggest you were using the later version include files which may not allow it.



dzirkelb1 -> RE: Order By Column Question (1/25/2005 15:11:11)

here is my sql statement: 

SELECT * FROM qryTotalScores

WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) And IIf(('::GreatEvalDate::'&''=''), True, EvalDate>=::GreatEvalDate::) 
ORDER BY ::SortColumn::


that produces the error...the link to the site is http://www.msultd.com/kfc/reports.asp

I have another page which works with the following code: 
SELECT  EvalCode, StoreID, ShopDate, WasherBucket, TowelDispensers, PumpsClean, TrashContainers, TrashOnLot, Landscaping, OutsideSignage, FrontWindowsAndDoors, ReaderBoardA, ReaderBoardB, OutsideImagePercentage, Toilet, SinkMirrorWalls, FloorTrash, TowelSoupDispenser, RestroomPercentage, Stocked, Clean, FountainBarPercentage, HotDogs, DashboardDiner, FreshFoodPercentage, BeerStocked, OtherBeverage, DoorsCleanLit, CoolersPercentage, FloorsAndRugs, Merchandise, Shelves, CleanlinessPercentage, FrontedFaced, CigarettesOuts, CandyOuts, OtherOuts, AppropriateSignageDisplay, MerchandisingImage, OtherMerchandisingPercentage, FriendlySmile, Understanding, EyeContact, Efficient, ThankYou, EmloyeeAppearance, CustomerServicePercentage, TotalScore, Supervisor, DistrictManager

FROM QryTotalScore


WHERE IIF(('::GreatOutsideImagePercentage::'&''=''), True, OutsideImagePercentage>=::GreatOutsideImagePercentage::+0) 
AND IIf(('::LessOutsideImagePercentage::'&''=''), True, OutsideImagePercentage<= ::LessOutsideImagePercentage::+0)

AND IIf(('::GreatRestroomPercentage::'&''=''), True, RestroomPercentage>= ::GreatRestroomPercentage::+0)
AND IIf(('::LessRestroomPercentage::'&''=''), True, RestroomPercentage<= ::LessRestroomPercentage::+0)

AND IIf(('::GreatFountainBarPercentage::'&''=''), True, FountainBarPercentage>= ::GreatFountainBarPercentage::+0)
AND IIf(('::LessFountainBarPercentage::'&''=''), True, FountainBarPercentage<= ::LessFountainBarPercentage::+0)

AND IIf(('::GreatFreshFoodPercentage::'&''=''), True, FreshFoodPercentage>= ::GreatFreshFoodPercentage::+0)
AND IIf(('::LessFreshFoodPercentage::'&''=''), True, FreshFoodPercentage<= ::LessFreshFoodPercentage::+0)

AND IIf(('::GreatCoolersPercentage::'&''=''), True, CoolersPercentage>= ::GreatCoolersPercentage::+0)
AND IIf(('::LessCoolersPercentage::'&''=''), True, CoolersPercentage<= ::LessCoolersPercentage::+0)

AND IIf(('::GreatCleanlinessPercentage::'&''=''), True, CleanlinessPercentage>= ::GreatCleanlinessPercentage::+0)
AND IIf(('::LessCleanlinessPercentage::'&''=''), True, CleanlinessPercentage<= ::LessCleanlinessPercentage::+0)

AND IIf(('::GreatOtherMerchandisingPercentage::'&''=''), True, OtherMerchandisingPercentage>= ::GreatOtherMerchandisingPercentage::+0)
AND IIf(('::LessOtherMerchandisingPercentage::'&''=''), True, OtherMerchandisingPercentage<= ::LessOtherMerchandisingPercentage::+0)

AND IIf(('::GreatCustomerServicePercentage::'&''=''), True, CustomerServicePercentage>= ::GreatCustomerServicePercentage::+0)
AND IIf(('::LessCustomerServicePercentage::'&''=''), True, CustomerServicePercentage<= ::LessCustomerServicePercentage::+0)

AND IIf(('::GreatTotalScore::'&''=''), True, TotalScore>= ::GreatTotalScore::+0)
AND IIf(('::LessTotalScore::'&''=''), True, TotalScore<= ::LessTotalScore::+0)

AND IIf(('::GreatShopDate::'=''), True, ShopDate>= '::GreatShopDate::')
AND IIf(('::LessShopDate::'=''), True, ShopDate<= '::LessShopDate::')

AND IIf(('::StoreID::'=''), True, StoreID= '::StoreID::')
AND IIf(('::Supervisor::'=''), True, Supervisor= '::Supervisor::')
AND IIf(('::DistrictManager::'=''), True, DistrictManager= '::DistrictManager::')

ORDER BY ::SortColumn::


However, I really see no difference in the two codes. Its link can be found: http://www.msultd.com/breaktime/clients/reports.asp

Any ideas? How can it work on one and not the other? I'm sure its a simple typo!!



Spooky -> RE: Order By Column Question (1/25/2005 15:14:54)

If you place a break directly after the SQL, what is the result after a sort?

fp_sQry = "Select....."
Response.write fp_sQry
response.end



dzirkelb1 -> RE: Order By Column Question (1/25/2005 15:19:37)

It won't let me modify my asp code? Gives me an error says "the contents of a front page component have been modified. These contents will be overwritten when you save this page"

Shall I diet it?



Spooky -> RE: Order By Column Question (1/25/2005 15:21:39)

If you want to risk it :-)



dzirkelb1 -> RE: Order By Column Question (1/25/2005 15:23:08)

This page has just been created today...aka, only thing that took time was the sql statements. I'll just copy and paste them into notepad as a backup, diet it, and get back to ya in a sec.



dzirkelb1 -> RE: Order By Column Question (1/25/2005 15:59:36)

Its on a diet, and still gets error. I added code requested and it simply displays my sql code...it is displayed here:

http://www.msultd.com/kfc/reports.asp



Spooky -> RE: Order By Column Question (1/25/2005 16:21:58)

Now that its on a diet, try :

fp_sQry= "SELECT ....... SORT BY "&Replace(request.form("SortColumn"),"'","''")

(and remove those 2 lines we added)



dzirkelb1 -> RE: Order By Column Question (1/25/2005 16:35:52)

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/kfc/reports.asp, line 339, column 2207


line 339 is my sql code



Spooky -> RE: Order By Column Question (1/25/2005 16:44:40)

Whats the exact code for that?

btw - if you are using a link (GET) then you should perhaps use this code :

Replace(request.querystring("SortColumn"),"'","''")



dzirkelb1 -> RE: Order By Column Question (1/25/2005 16:50:23)

I'm not using a link for this one...it posts the search to the same page...for now at least. The exact code is as follows: 

<%
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) And IIf(('::GreatEvalDate::'&''=''), True, EvalDate>=::GreatEvalDate::) SORT BY "&Replace(request.form("SortColumn"),"'","''")"
fp_sDefault="GreatCPercentage=&GreatCPercentage=&LessCPercentage=&LessCPercentage=&GreatHPercentage=&GreatHPercentage=&LessHPercentage=&LessHPercentage=&GreatAPercentage=&GreatAPercentage=&LessAPercentage=&LessAPercentage=&GreatMPercentage=&GreatMPercentage=&LessMPercentage=&LessMPercentage=&GreatPPercentage=&GreatPPercentage=&LessPPercentage=&LessPPercentage=&GreatSPercentage=&GreatSPercentage=&LessSPercentage=&LessSPercentage=&GreatRoundedActualScorePercentage=&GreatRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&GreatD1EntreeTemp=&GreatD1EntreeTemp=&LessD1EntreeTemp=&LessD1EntreeTemp=&GreatP2Temperature=&GreatP2Temperature=&LessP2Temperature=&LessP2Temperature=&GreatP3Temperature=&GreatP3Temperature=&LessP3Temperature=&LessP3Temperature=&GreatP4Temperature=&GreatP4Temperature=&LessP4Temperature=&LessP4Temperature=&CarryOutDriveThru=&CarryOutDriveThru=&GreatEvalDate=&GreatEvalDate=&SortColumn="
fp_sNoRecords="<tr><td colspan=188 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="KFC"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="EvalCode"
fp_sMenuValue="EvalCode"
fp_sColTypes="&EvalCode=3&StoreID=202&EvalDate=135&DayOfWeek=202&Time=135&DayPart=202&Rep=5&Period=202&CostOfProduct=6&CarryOutDriveThru=5&D1InsectsAndPests=5&D1RudeBehavior=5&D1MainEntreeTemperature=3&D1EntreeOrdered=5&D1EntreeTemp=5&D1OtherChicken=202&D1TotalPointsDocked=3&C1ParkingLot=5&C1Landscaping=5&C1TrashContainers=5&C1Sidewalks=5&C1Dumpsters=5&C1TotalPointsDocked=3&C2Doors=5&C2ExteriorLighting=3&C2DtMenuboard=3&C2Windows=3&C2DTSpeaker=3&C2TotalPointsDocked=3&C3Stocked=3&C3Clean=3&C3Odor=3&C3TotalPointsDocked=3&C4Clean=3&C4Caution=3&C5Ceiling=3&C5Pictures=3&C5Decor=3&C5Walls=3&C5LightFixtures=3&C4andC5TotalPointsDocked=3&C6Counters=3&C6Menuboards=3&C6DisplayCases=3&C6SelfServiceArea=3&C6Menus=3&C6AdvertisingMaterials=3&C7Tables=3&C7Booths=3&C7Seats=3&C7TrashContainers=3&C8SuppliesStored=3&C6andC7andC8TotalPointsDocked=3&CleanlinessPointsPossible=3&CTotalPointsEarned=3&CPercentage=5&H1FriendlyGreeting=3&H1GreetingDTWindow=3&H2AppreciativeClosing=3&H3Smile=3&H3Eyecontact=3&H3FocusedAttention=3&H1andH2andH3TotalPointsDocked=3&H4ProblemLAST=3&H4LASTExecuted=3&H4Listen=3&H4Apologize=3&H4Satisfy=3&H4Thank=3&H4HoldingCabinet=3&H5ProfessionalManner=3&HLASTBonus=3&H4andH5TotalPointsDocked=3&H6Uniforms=3&H6WellGroomed=3&H6NeatAndClean=3&H6PersonalHygiene=3&H6EmployeeWhoWaited=202&H6TotalPointsDocked=3&H7Upsize=3&H7UpsizeText=202&HTotalPointsEarned=3&HPercentage=5&A1Brand=3&A1Other=3&A1ColdSide=3&A1Drink=3&A1Piece=3&A1HotSide=3&A1Bread=3&A1Buffet=3&A1TotalPointsDocked=3&A2Sides=3&A2Packaging=3&A2ChickenType=3&A2Napkins=3&A2ChickenPieces=3&A2Condiments=3&A3CorrectAmount=3&A3CorrectChange=3&A2andA3TotalPointsDocked=3&A4ConfirmOrder=3&A4TotalPointsDocked=3&ATotalPointsEarned=3&APercentage=5&M1Building=3&M1DTmenuboard=3&M1Lights=3&M1DTSpeaker=3&M1Signs=3&M1Grass=3&M1Advertising=3&M1ParkingLot=3&M1Sidewalks=3&M1DTLane=3&M1TotalPointsDocked=3&M2Floor=3&M2Walls=3&M2Ceiling=3&M2Lights=3&M2Doors=3&M3Entryway=3&M3Advertising=3&M3Menuboards=3&M3Menus=3&M4Restrooms=3&M5Tables=3&M5MusicVolume=3&M5Temperature=3&M5Seats=3&M5Booths=3&M2andM3andM4andM5TotalPointsDocked=3&M6BrixLevel=3&M6BrixLevelText=202&M6TypeOfDrink=202&M6Carbonation=3&M6TotalPointsDocked=3&MTotalPointsEarned=3&MPercentage=5&P1FreshMoistTender=3&P1AcceptableColor=3&P1WithoutExcessiveShortening=3&P1BreadedProperly=3&P1ProperTemperature=3&P1TotalPointsDocked=3&P2Temperature=3&P2Fresh=3&P2AcceptableAppearance=3&P2FilledProperly=3&P2ProperTemperature=3&P2HotSideItem=3&P2OtherText=202&P3Temperature=3&P3Fresh=3&P3AcceptableAppearance=3&P3FilledProperly=3&P3ProperTemperature=3&P3ColdSideItem=3&P3OtherText=202&P2andP3TotalPointsDocked=3&P4Temperature=3&P4Fresh=3&P4AcceptableAppearance=3&P4ProperTemperature=3&P4BreadSideItem=3&P4TotalPointsDocked=3&PTotalPointsEarned=3&PPercentage=5&S1GreetedInTime=3&S2GreetedInTime=3&S2HoldTime=5&S1andS2TotalPointsDocked=3&S3CustomerService=3&S3OrderTimeMin=3&S3OrderTimeSec=3&S3WindowTimeMin=3&S3WindowTimeSec=3&S3TotalTimeMin=3&S3TotalTimeSec=3&S3Customers=202&S3TotalPointsDocked=3&STotalPointsEarned=3&SPercentage=5&TotalPointsEarned=5&RoundedRegularPercentage=5&DealBreakerPercentage=5&TotalPointsPossible=5&RoundedActualScorePercentage=5&"
fp_iDisplayCols=188
fp_fCustomQuery=True
BOTID=6
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<tr>
<td><%=FP_FieldVal(fp_rs,"EvalCode")%></td>
<td><%=FP_FieldVal(fp_rs,"StoreID")%></td>
<td><%=FP_FieldVal(fp_rs,"EvalDate")%></td>
<td><%=FP_FieldVal(fp_rs,"DayOfWeek")%></td>
<td><%=FP_FieldVal(fp_rs,"Time")%></td>
<td><%=FP_FieldVal(fp_rs,"DayPart")%></td>
<td><%=FP_FieldVal(fp_rs,"Rep")%></td>
<td><%=FP_FieldVal(fp_rs,"Period")%></td>
<td><%=FP_FieldVal(fp_rs,"CostOfProduct")%></td>
<td><%=FP_FieldVal(fp_rs,"CarryOutDriveThru")%></td>
<td><%=FP_FieldVal(fp_rs,"D1InsectsAndPests")%></td>
<td><%=FP_FieldVal(fp_rs,"D1RudeBehavior")%></td>
<td><%=FP_FieldVal(fp_rs,"D1MainEntreeTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"D1EntreeOrdered")%></td>
<td><%=FP_FieldVal(fp_rs,"D1EntreeTemp")%></td>
<td><%=FP_FieldVal(fp_rs,"D1OtherChicken")%></td>
<td><%=FP_FieldVal(fp_rs,"D1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C1ParkingLot")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Landscaping")%></td>
<td><%=FP_FieldVal(fp_rs,"C1TrashContainers")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Sidewalks")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Dumpsters")%></td>
<td><%=FP_FieldVal(fp_rs,"C1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C2Doors")%></td>
<td><%=FP_FieldVal(fp_rs,"C2ExteriorLighting")%></td>
<td><%=FP_FieldVal(fp_rs,"C2DtMenuboard")%></td>
<td><%=FP_FieldVal(fp_rs,"C2Windows")%></td>
<td><%=FP_FieldVal(fp_rs,"C2DTSpeaker")%></td>
<td><%=FP_FieldVal(fp_rs,"C2TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Stocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Clean")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Odor")%></td>
<td><%=FP_FieldVal(fp_rs,"C3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C4Clean")%></td>
<td><%=FP_FieldVal(fp_rs,"C4Caution")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Ceiling")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Pictures")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Decor")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Walls")%></td>
<td><%=FP_FieldVal(fp_rs,"C5LightFixtures")%></td>
<td><%=FP_FieldVal(fp_rs,"C4andC5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Counters")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Menuboards")%></td>
<td><%=FP_FieldVal(fp_rs,"C6DisplayCases")%></td>
<td><%=FP_FieldVal(fp_rs,"C6SelfServiceArea")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Menus")%></td>
<td><%=FP_FieldVal(fp_rs,"C6AdvertisingMaterials")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Tables")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Booths")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Seats")%></td>
<td><%=FP_FieldVal(fp_rs,"C7TrashContainers")%></td>
<td><%=FP_FieldVal(fp_rs,"C8SuppliesStored")%></td>
<td><%=FP_FieldVal(fp_rs,"C6andC7andC8TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"CleanlinessPointsPossible")%></td>
<td><%=FP_FieldVal(fp_rs,"CTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"CPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"H1GreetingDTWindow")%></td>
<td><%=FP_FieldVal(fp_rs,"H2AppreciativeClosing")%></td>
<td><%=FP_FieldVal(fp_rs,"H3Smile")%></td>
<td><%=FP_FieldVal(fp_rs,"H3Eyecontact")%></td>
<td><%=FP_FieldVal(fp_rs,"H3FocusedAttention")%></td>
<td><%=FP_FieldVal(fp_rs,"H1andH2andH3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H4ProblemLAST")%></td>
<td><%=FP_FieldVal(fp_rs,"H4LASTExecuted")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Listen")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Apologize")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Satisfy")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Thank")%></td>
<td><%=FP_FieldVal(fp_rs,"H4HoldingCabinet")%></td>
<td><%=FP_FieldVal(fp_rs,"H5ProfessionalManner")%></td>
<td><%=FP_FieldVal(fp_rs,"HLASTBonus")%></td>
<td><%=FP_FieldVal(fp_rs,"H4andH5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H6Uniforms")%></td>
<td><%=FP_FieldVal(fp_rs,"H6WellGroomed")%></td>
<td><%=FP_FieldVal(fp_rs,"H6NeatAndClean")%></td>
<td><%=FP_FieldVal(fp_rs,"H6PersonalHygiene")%></td>
<td><%=FP_FieldVal(fp_rs,"H6EmployeeWhoWaited")%></td>
<td><%=FP_FieldVal(fp_rs,"H6TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H7Upsize")%></td>
<td><%=FP_FieldVal(fp_rs,"H7UpsizeText")%></td>
<td><%=FP_FieldVal(fp_rs,"HTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"HPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Brand")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Other")%></td>
<td><%=FP_FieldVal(fp_rs,"A1ColdSide")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Drink")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Piece")%></td>
<td><%=FP_FieldVal(fp_rs,"A1HotSide")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Bread")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Buffet")%></td>
<td><%=FP_FieldVal(fp_rs,"A1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Sides")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Packaging")%></td>
<td><%=FP_FieldVal(fp_rs,"A2ChickenType")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Napkins")%></td>
<td><%=FP_FieldVal(fp_rs,"A2ChickenPieces")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Condiments")%></td>
<td><%=FP_FieldVal(fp_rs,"A3CorrectAmount")%></td>
<td><%=FP_FieldVal(fp_rs,"A3CorrectChange")%></td>
<td><%=FP_FieldVal(fp_rs,"A2andA3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"A4ConfirmOrder")%></td>
<td><%=FP_FieldVal(fp_rs,"A4TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"ATotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"APercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Building")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTmenuboard")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Lights")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTSpeaker")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Signs")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Grass")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Advertising")%></td>
<td><%=FP_FieldVal(fp_rs,"M1ParkingLot")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Sidewalks")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTLane")%></td>
<td><%=FP_FieldVal(fp_rs,"M1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Floor")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Walls")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Ceiling")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Lights")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Doors")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Entryway")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Advertising")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Menuboards")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Menus")%></td>
<td><%=FP_FieldVal(fp_rs,"M4Restrooms")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Tables")%></td>
<td><%=FP_FieldVal(fp_rs,"M5MusicVolume")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Seats")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Booths")%></td>
<td><%=FP_FieldVal(fp_rs,"M2andM3andM4andM5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"M6BrixLevel")%></td>
<td><%=FP_FieldVal(fp_rs,"M6BrixLevelText")%></td>
<td><%=FP_FieldVal(fp_rs,"M6TypeOfDrink")%></td>
<td><%=FP_FieldVal(fp_rs,"M6Carbonation")%></td>
<td><%=FP_FieldVal(fp_rs,"M6TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"MTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"MPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"P1FreshMoistTender")%></td>
<td><%=FP_FieldVal(fp_rs,"P1AcceptableColor")%></td>
<td><%=FP_FieldVal(fp_rs,"P1WithoutExcessiveShortening")%></td>
<td><%=FP_FieldVal(fp_rs,"P1BreadedProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P1ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"P2Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P2Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P2AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P2FilledProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P2ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P2HotSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P2OtherText")%></td>
<td><%=FP_FieldVal(fp_rs,"P3Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P3Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P3AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P3FilledProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P3ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P3ColdSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P3OtherText")%></td>
<td><%=FP_FieldVal(fp_rs,"P2andP3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"P4Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P4Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P4AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P4ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P4BreadSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P4TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"PTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"PPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"S1GreetedInTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S2GreetedInTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S2HoldTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S1andS2TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"S3CustomerService")%></td>
<td><%=FP_FieldVal(fp_rs,"S3OrderTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3OrderTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3WindowTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3WindowTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3Customers")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"STotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"SPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"TotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"RoundedRegularPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"DealBreakerPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"TotalPointsPossible")%></td>
<td><%=FP_FieldVal(fp_rs,"RoundedActualScorePercentage")%></td>
		</tr>
		<!--#include file="../_fpclass/fpdbrgn2.inc"-->


Entire html mixed with asp is: 

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Reports</title>
</head>

<body>

<form BOTID="6" METHOD="POST" action="reports.asp">
	<input type="hidden" name="fpdbr_6_PagingMove" value="  |<  ">
	<table BORDER="0">
		<tr>
			<td><b>GreatCPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatCPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatCPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessCPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessCPercentage" VALUE="<%=Server.HtmlEncode(Request("LessCPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatHPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatHPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatHPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessHPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessHPercentage" VALUE="<%=Server.HtmlEncode(Request("LessHPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatAPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatAPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatAPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessAPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessAPercentage" VALUE="<%=Server.HtmlEncode(Request("LessAPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatMPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatMPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatMPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessMPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessMPercentage" VALUE="<%=Server.HtmlEncode(Request("LessMPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatPPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatPPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatPPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessPPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessPPercentage" VALUE="<%=Server.HtmlEncode(Request("LessPPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatSPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatSPercentage" VALUE="<%=Server.HtmlEncode(Request("GreatSPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessSPercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessSPercentage" VALUE="<%=Server.HtmlEncode(Request("LessSPercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatRoundedActualScorePercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatRoundedActualScorePercentage" VALUE="<%=Server.HtmlEncode(Request("GreatRoundedActualScorePercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>LessRoundedActualScorePercentage</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessRoundedActualScorePercentage" VALUE="<%=Server.HtmlEncode(Request("LessRoundedActualScorePercentage"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatD1EntreeTemp</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatD1EntreeTemp" VALUE="<%=Server.HtmlEncode(Request("GreatD1EntreeTemp"))%>"></td>
		</tr>
		<tr>
			<td><b>LessD1EntreeTemp</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessD1EntreeTemp" VALUE="<%=Server.HtmlEncode(Request("LessD1EntreeTemp"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatP2Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatP2Temperature" VALUE="<%=Server.HtmlEncode(Request("GreatP2Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>LessP2Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessP2Temperature" VALUE="<%=Server.HtmlEncode(Request("LessP2Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatP3Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatP3Temperature" VALUE="<%=Server.HtmlEncode(Request("GreatP3Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>LessP3Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessP3Temperature" VALUE="<%=Server.HtmlEncode(Request("LessP3Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatP4Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatP4Temperature" VALUE="<%=Server.HtmlEncode(Request("GreatP4Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>LessP4Temperature</b></td>
			<td>
			<input TYPE="TEXT" NAME="LessP4Temperature" VALUE="<%=Server.HtmlEncode(Request("LessP4Temperature"))%>"></td>
		</tr>
		<tr>
			<td><b>CarryOutDriveThru</b></td>
			<td>
			<input TYPE="TEXT" NAME="CarryOutDriveThru" VALUE="<%=Server.HtmlEncode(Request("CarryOutDriveThru"))%>"></td>
		</tr>
		<tr>
			<td><b>GreatEvalDate</b></td>
			<td>
			<input TYPE="TEXT" NAME="GreatEvalDate" VALUE="<%=Server.HtmlEncode(Request("GreatEvalDate"))%>"></td>
		</tr>
	</table>
	<br>
	<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " --><p> </p>
</form>
<table width="100%" border="1">
	<thead>
		<tr>
			<th ALIGN="LEFT"><b>EvalCode</b></th>
			<th ALIGN="LEFT"><b>StoreID</b></th>
			<th ALIGN="LEFT"><b>EvalDate</b></th>
			<th ALIGN="LEFT"><b>DayOfWeek</b></th>
			<th ALIGN="LEFT"><b>Time</b></th>
			<th ALIGN="LEFT"><b>DayPart</b></th>
			<th ALIGN="LEFT"><b>Rep</b></th>
			<th ALIGN="LEFT"><b>Period</b></th>
			<th ALIGN="LEFT"><b>CostOfProduct</b></th>
			<th ALIGN="LEFT"><b>CarryOutDriveThru</b></th>
			<th ALIGN="LEFT"><b>D1InsectsAndPests</b></th>
			<th ALIGN="LEFT"><b>D1RudeBehavior</b></th>
			<th ALIGN="LEFT"><b>D1MainEntreeTemperature</b></th>
			<th ALIGN="LEFT"><b>D1EntreeOrdered</b></th>
			<th ALIGN="LEFT"><b>D1EntreeTemp</b></th>
			<th ALIGN="LEFT"><b>D1OtherChicken</b></th>
			<th ALIGN="LEFT"><b>D1TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>C1ParkingLot</b></th>
			<th ALIGN="LEFT"><b>C1Landscaping</b></th>
			<th ALIGN="LEFT"><b>C1TrashContainers</b></th>
			<th ALIGN="LEFT"><b>C1Sidewalks</b></th>
			<th ALIGN="LEFT"><b>C1Dumpsters</b></th>
			<th ALIGN="LEFT"><b>C1TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>C2Doors</b></th>
			<th ALIGN="LEFT"><b>C2ExteriorLighting</b></th>
			<th ALIGN="LEFT"><b>C2DtMenuboard</b></th>
			<th ALIGN="LEFT"><b>C2Windows</b></th>
			<th ALIGN="LEFT"><b>C2DTSpeaker</b></th>
			<th ALIGN="LEFT"><b>C2TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>C3Stocked</b></th>
			<th ALIGN="LEFT"><b>C3Clean</b></th>
			<th ALIGN="LEFT"><b>C3Odor</b></th>
			<th ALIGN="LEFT"><b>C3TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>C4Clean</b></th>
			<th ALIGN="LEFT"><b>C4Caution</b></th>
			<th ALIGN="LEFT"><b>C5Ceiling</b></th>
			<th ALIGN="LEFT"><b>C5Pictures</b></th>
			<th ALIGN="LEFT"><b>C5Decor</b></th>
			<th ALIGN="LEFT"><b>C5Walls</b></th>
			<th ALIGN="LEFT"><b>C5LightFixtures</b></th>
			<th ALIGN="LEFT"><b>C4andC5TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>C6Counters</b></th>
			<th ALIGN="LEFT"><b>C6Menuboards</b></th>
			<th ALIGN="LEFT"><b>C6DisplayCases</b></th>
			<th ALIGN="LEFT"><b>C6SelfServiceArea</b></th>
			<th ALIGN="LEFT"><b>C6Menus</b></th>
			<th ALIGN="LEFT"><b>C6AdvertisingMaterials</b></th>
			<th ALIGN="LEFT"><b>C7Tables</b></th>
			<th ALIGN="LEFT"><b>C7Booths</b></th>
			<th ALIGN="LEFT"><b>C7Seats</b></th>
			<th ALIGN="LEFT"><b>C7TrashContainers</b></th>
			<th ALIGN="LEFT"><b>C8SuppliesStored</b></th>
			<th ALIGN="LEFT"><b>C6andC7andC8TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>CleanlinessPointsPossible</b></th>
			<th ALIGN="LEFT"><b>CTotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>CPercentage</b></th>
			<th ALIGN="LEFT"><b>H1FriendlyGreeting</b></th>
			<th ALIGN="LEFT"><b>H1GreetingDTWindow</b></th>
			<th ALIGN="LEFT"><b>H2AppreciativeClosing</b></th>
			<th ALIGN="LEFT"><b>H3Smile</b></th>
			<th ALIGN="LEFT"><b>H3Eyecontact</b></th>
			<th ALIGN="LEFT"><b>H3FocusedAttention</b></th>
			<th ALIGN="LEFT"><b>H1andH2andH3TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>H4ProblemLAST</b></th>
			<th ALIGN="LEFT"><b>H4LASTExecuted</b></th>
			<th ALIGN="LEFT"><b>H4Listen</b></th>
			<th ALIGN="LEFT"><b>H4Apologize</b></th>
			<th ALIGN="LEFT"><b>H4Satisfy</b></th>
			<th ALIGN="LEFT"><b>H4Thank</b></th>
			<th ALIGN="LEFT"><b>H4HoldingCabinet</b></th>
			<th ALIGN="LEFT"><b>H5ProfessionalManner</b></th>
			<th ALIGN="LEFT"><b>HLASTBonus</b></th>
			<th ALIGN="LEFT"><b>H4andH5TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>H6Uniforms</b></th>
			<th ALIGN="LEFT"><b>H6WellGroomed</b></th>
			<th ALIGN="LEFT"><b>H6NeatAndClean</b></th>
			<th ALIGN="LEFT"><b>H6PersonalHygiene</b></th>
			<th ALIGN="LEFT"><b>H6EmployeeWhoWaited</b></th>
			<th ALIGN="LEFT"><b>H6TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>H7Upsize</b></th>
			<th ALIGN="LEFT"><b>H7UpsizeText</b></th>
			<th ALIGN="LEFT"><b>HTotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>HPercentage</b></th>
			<th ALIGN="LEFT"><b>A1Brand</b></th>
			<th ALIGN="LEFT"><b>A1Other</b></th>
			<th ALIGN="LEFT"><b>A1ColdSide</b></th>
			<th ALIGN="LEFT"><b>A1Drink</b></th>
			<th ALIGN="LEFT"><b>A1Piece</b></th>
			<th ALIGN="LEFT"><b>A1HotSide</b></th>
			<th ALIGN="LEFT"><b>A1Bread</b></th>
			<th ALIGN="LEFT"><b>A1Buffet</b></th>
			<th ALIGN="LEFT"><b>A1TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>A2Sides</b></th>
			<th ALIGN="LEFT"><b>A2Packaging</b></th>
			<th ALIGN="LEFT"><b>A2ChickenType</b></th>
			<th ALIGN="LEFT"><b>A2Napkins</b></th>
			<th ALIGN="LEFT"><b>A2ChickenPieces</b></th>
			<th ALIGN="LEFT"><b>A2Condiments</b></th>
			<th ALIGN="LEFT"><b>A3CorrectAmount</b></th>
			<th ALIGN="LEFT"><b>A3CorrectChange</b></th>
			<th ALIGN="LEFT"><b>A2andA3TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>A4ConfirmOrder</b></th>
			<th ALIGN="LEFT"><b>A4TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>ATotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>APercentage</b></th>
			<th ALIGN="LEFT"><b>M1Building</b></th>
			<th ALIGN="LEFT"><b>M1DTmenuboard</b></th>
			<th ALIGN="LEFT"><b>M1Lights</b></th>
			<th ALIGN="LEFT"><b>M1DTSpeaker</b></th>
			<th ALIGN="LEFT"><b>M1Signs</b></th>
			<th ALIGN="LEFT"><b>M1Grass</b></th>
			<th ALIGN="LEFT"><b>M1Advertising</b></th>
			<th ALIGN="LEFT"><b>M1ParkingLot</b></th>
			<th ALIGN="LEFT"><b>M1Sidewalks</b></th>
			<th ALIGN="LEFT"><b>M1DTLane</b></th>
			<th ALIGN="LEFT"><b>M1TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>M2Floor</b></th>
			<th ALIGN="LEFT"><b>M2Walls</b></th>
			<th ALIGN="LEFT"><b>M2Ceiling</b></th>
			<th ALIGN="LEFT"><b>M2Lights</b></th>
			<th ALIGN="LEFT"><b>M2Doors</b></th>
			<th ALIGN="LEFT"><b>M3Entryway</b></th>
			<th ALIGN="LEFT"><b>M3Advertising</b></th>
			<th ALIGN="LEFT"><b>M3Menuboards</b></th>
			<th ALIGN="LEFT"><b>M3Menus</b></th>
			<th ALIGN="LEFT"><b>M4Restrooms</b></th>
			<th ALIGN="LEFT"><b>M5Tables</b></th>
			<th ALIGN="LEFT"><b>M5MusicVolume</b></th>
			<th ALIGN="LEFT"><b>M5Temperature</b></th>
			<th ALIGN="LEFT"><b>M5Seats</b></th>
			<th ALIGN="LEFT"><b>M5Booths</b></th>
			<th ALIGN="LEFT"><b>M2andM3andM4andM5TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>M6BrixLevel</b></th>
			<th ALIGN="LEFT"><b>M6BrixLevelText</b></th>
			<th ALIGN="LEFT"><b>M6TypeOfDrink</b></th>
			<th ALIGN="LEFT"><b>M6Carbonation</b></th>
			<th ALIGN="LEFT"><b>M6TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>MTotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>MPercentage</b></th>
			<th ALIGN="LEFT"><b>P1FreshMoistTender</b></th>
			<th ALIGN="LEFT"><b>P1AcceptableColor</b></th>
			<th ALIGN="LEFT"><b>P1WithoutExcessiveShortening</b></th>
			<th ALIGN="LEFT"><b>P1BreadedProperly</b></th>
			<th ALIGN="LEFT"><b>P1ProperTemperature</b></th>
			<th ALIGN="LEFT"><b>P1TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>P2Temperature</b></th>
			<th ALIGN="LEFT"><b>P2Fresh</b></th>
			<th ALIGN="LEFT"><b>P2AcceptableAppearance</b></th>
			<th ALIGN="LEFT"><b>P2FilledProperly</b></th>
			<th ALIGN="LEFT"><b>P2ProperTemperature</b></th>
			<th ALIGN="LEFT"><b>P2HotSideItem</b></th>
			<th ALIGN="LEFT"><b>P2OtherText</b></th>
			<th ALIGN="LEFT"><b>P3Temperature</b></th>
			<th ALIGN="LEFT"><b>P3Fresh</b></th>
			<th ALIGN="LEFT"><b>P3AcceptableAppearance</b></th>
			<th ALIGN="LEFT"><b>P3FilledProperly</b></th>
			<th ALIGN="LEFT"><b>P3ProperTemperature</b></th>
			<th ALIGN="LEFT"><b>P3ColdSideItem</b></th>
			<th ALIGN="LEFT"><b>P3OtherText</b></th>
			<th ALIGN="LEFT"><b>P2andP3TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>P4Temperature</b></th>
			<th ALIGN="LEFT"><b>P4Fresh</b></th>
			<th ALIGN="LEFT"><b>P4AcceptableAppearance</b></th>
			<th ALIGN="LEFT"><b>P4ProperTemperature</b></th>
			<th ALIGN="LEFT"><b>P4BreadSideItem</b></th>
			<th ALIGN="LEFT"><b>P4TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>PTotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>PPercentage</b></th>
			<th ALIGN="LEFT"><b>S1GreetedInTime</b></th>
			<th ALIGN="LEFT"><b>S2GreetedInTime</b></th>
			<th ALIGN="LEFT"><b>S2HoldTime</b></th>
			<th ALIGN="LEFT"><b>S1andS2TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>S3CustomerService</b></th>
			<th ALIGN="LEFT"><b>S3OrderTimeMin</b></th>
			<th ALIGN="LEFT"><b>S3OrderTimeSec</b></th>
			<th ALIGN="LEFT"><b>S3WindowTimeMin</b></th>
			<th ALIGN="LEFT"><b>S3WindowTimeSec</b></th>
			<th ALIGN="LEFT"><b>S3TotalTimeMin</b></th>
			<th ALIGN="LEFT"><b>S3TotalTimeSec</b></th>
			<th ALIGN="LEFT"><b>S3Customers</b></th>
			<th ALIGN="LEFT"><b>S3TotalPointsDocked</b></th>
			<th ALIGN="LEFT"><b>STotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>SPercentage</b></th>
			<th ALIGN="LEFT"><b>TotalPointsEarned</b></th>
			<th ALIGN="LEFT"><b>RoundedRegularPercentage</b></th>
			<th ALIGN="LEFT"><b>DealBreakerPercentage</b></th>
			<th ALIGN="LEFT"><b>TotalPointsPossible</b></th>
			<th ALIGN="LEFT"><b>RoundedActualScorePercentage</b></th>
		</tr>
	</thead>
	<tbody>
	

<%
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) And IIf(('::GreatEvalDate::'&''=''), True, EvalDate>=::GreatEvalDate::) SORT BY "&Replace(request.form("SortColumn"),"'","''")"
fp_sDefault="GreatCPercentage=&GreatCPercentage=&LessCPercentage=&LessCPercentage=&GreatHPercentage=&GreatHPercentage=&LessHPercentage=&LessHPercentage=&GreatAPercentage=&GreatAPercentage=&LessAPercentage=&LessAPercentage=&GreatMPercentage=&GreatMPercentage=&LessMPercentage=&LessMPercentage=&GreatPPercentage=&GreatPPercentage=&LessPPercentage=&LessPPercentage=&GreatSPercentage=&GreatSPercentage=&LessSPercentage=&LessSPercentage=&GreatRoundedActualScorePercentage=&GreatRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&GreatD1EntreeTemp=&GreatD1EntreeTemp=&LessD1EntreeTemp=&LessD1EntreeTemp=&GreatP2Temperature=&GreatP2Temperature=&LessP2Temperature=&LessP2Temperature=&GreatP3Temperature=&GreatP3Temperature=&LessP3Temperature=&LessP3Temperature=&GreatP4Temperature=&GreatP4Temperature=&LessP4Temperature=&LessP4Temperature=&CarryOutDriveThru=&CarryOutDriveThru=&GreatEvalDate=&GreatEvalDate=&SortColumn="
fp_sNoRecords="<tr><td colspan=188 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="KFC"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="EvalCode"
fp_sMenuValue="EvalCode"
fp_sColTypes="&EvalCode=3&StoreID=202&EvalDate=135&DayOfWeek=202&Time=135&DayPart=202&Rep=5&Period=202&CostOfProduct=6&CarryOutDriveThru=5&D1InsectsAndPests=5&D1RudeBehavior=5&D1MainEntreeTemperature=3&D1EntreeOrdered=5&D1EntreeTemp=5&D1OtherChicken=202&D1TotalPointsDocked=3&C1ParkingLot=5&C1Landscaping=5&C1TrashContainers=5&C1Sidewalks=5&C1Dumpsters=5&C1TotalPointsDocked=3&C2Doors=5&C2ExteriorLighting=3&C2DtMenuboard=3&C2Windows=3&C2DTSpeaker=3&C2TotalPointsDocked=3&C3Stocked=3&C3Clean=3&C3Odor=3&C3TotalPointsDocked=3&C4Clean=3&C4Caution=3&C5Ceiling=3&C5Pictures=3&C5Decor=3&C5Walls=3&C5LightFixtures=3&C4andC5TotalPointsDocked=3&C6Counters=3&C6Menuboards=3&C6DisplayCases=3&C6SelfServiceArea=3&C6Menus=3&C6AdvertisingMaterials=3&C7Tables=3&C7Booths=3&C7Seats=3&C7TrashContainers=3&C8SuppliesStored=3&C6andC7andC8TotalPointsDocked=3&CleanlinessPointsPossible=3&CTotalPointsEarned=3&CPercentage=5&H1FriendlyGreeting=3&H1GreetingDTWindow=3&H2AppreciativeClosing=3&H3Smile=3&H3Eyecontact=3&H3FocusedAttention=3&H1andH2andH3TotalPointsDocked=3&H4ProblemLAST=3&H4LASTExecuted=3&H4Listen=3&H4Apologize=3&H4Satisfy=3&H4Thank=3&H4HoldingCabinet=3&H5ProfessionalManner=3&HLASTBonus=3&H4andH5TotalPointsDocked=3&H6Uniforms=3&H6WellGroomed=3&H6NeatAndClean=3&H6PersonalHygiene=3&H6EmployeeWhoWaited=202&H6TotalPointsDocked=3&H7Upsize=3&H7UpsizeText=202&HTotalPointsEarned=3&HPercentage=5&A1Brand=3&A1Other=3&A1ColdSide=3&A1Drink=3&A1Piece=3&A1HotSide=3&A1Bread=3&A1Buffet=3&A1TotalPointsDocked=3&A2Sides=3&A2Packaging=3&A2ChickenType=3&A2Napkins=3&A2ChickenPieces=3&A2Condiments=3&A3CorrectAmount=3&A3CorrectChange=3&A2andA3TotalPointsDocked=3&A4ConfirmOrder=3&A4TotalPointsDocked=3&ATotalPointsEarned=3&APercentage=5&M1Building=3&M1DTmenuboard=3&M1Lights=3&M1DTSpeaker=3&M1Signs=3&M1Grass=3&M1Advertising=3&M1ParkingLot=3&M1Sidewalks=3&M1DTLane=3&M1TotalPointsDocked=3&M2Floor=3&M2Walls=3&M2Ceiling=3&M2Lights=3&M2Doors=3&M3Entryway=3&M3Advertising=3&M3Menuboards=3&M3Menus=3&M4Restrooms=3&M5Tables=3&M5MusicVolume=3&M5Temperature=3&M5Seats=3&M5Booths=3&M2andM3andM4andM5TotalPointsDocked=3&M6BrixLevel=3&M6BrixLevelText=202&M6TypeOfDrink=202&M6Carbonation=3&M6TotalPointsDocked=3&MTotalPointsEarned=3&MPercentage=5&P1FreshMoistTender=3&P1AcceptableColor=3&P1WithoutExcessiveShortening=3&P1BreadedProperly=3&P1ProperTemperature=3&P1TotalPointsDocked=3&P2Temperature=3&P2Fresh=3&P2AcceptableAppearance=3&P2FilledProperly=3&P2ProperTemperature=3&P2HotSideItem=3&P2OtherText=202&P3Temperature=3&P3Fresh=3&P3AcceptableAppearance=3&P3FilledProperly=3&P3ProperTemperature=3&P3ColdSideItem=3&P3OtherText=202&P2andP3TotalPointsDocked=3&P4Temperature=3&P4Fresh=3&P4AcceptableAppearance=3&P4ProperTemperature=3&P4BreadSideItem=3&P4TotalPointsDocked=3&PTotalPointsEarned=3&PPercentage=5&S1GreetedInTime=3&S2GreetedInTime=3&S2HoldTime=5&S1andS2TotalPointsDocked=3&S3CustomerService=3&S3OrderTimeMin=3&S3OrderTimeSec=3&S3WindowTimeMin=3&S3WindowTimeSec=3&S3TotalTimeMin=3&S3TotalTimeSec=3&S3Customers=202&S3TotalPointsDocked=3&STotalPointsEarned=3&SPercentage=5&TotalPointsEarned=5&RoundedRegularPercentage=5&DealBreakerPercentage=5&TotalPointsPossible=5&RoundedActualScorePercentage=5&"
fp_iDisplayCols=188
fp_fCustomQuery=True
BOTID=6
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<tr>
<td><%=FP_FieldVal(fp_rs,"EvalCode")%></td>
<td><%=FP_FieldVal(fp_rs,"StoreID")%></td>
<td><%=FP_FieldVal(fp_rs,"EvalDate")%></td>
<td><%=FP_FieldVal(fp_rs,"DayOfWeek")%></td>
<td><%=FP_FieldVal(fp_rs,"Time")%></td>
<td><%=FP_FieldVal(fp_rs,"DayPart")%></td>
<td><%=FP_FieldVal(fp_rs,"Rep")%></td>
<td><%=FP_FieldVal(fp_rs,"Period")%></td>
<td><%=FP_FieldVal(fp_rs,"CostOfProduct")%></td>
<td><%=FP_FieldVal(fp_rs,"CarryOutDriveThru")%></td>
<td><%=FP_FieldVal(fp_rs,"D1InsectsAndPests")%></td>
<td><%=FP_FieldVal(fp_rs,"D1RudeBehavior")%></td>
<td><%=FP_FieldVal(fp_rs,"D1MainEntreeTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"D1EntreeOrdered")%></td>
<td><%=FP_FieldVal(fp_rs,"D1EntreeTemp")%></td>
<td><%=FP_FieldVal(fp_rs,"D1OtherChicken")%></td>
<td><%=FP_FieldVal(fp_rs,"D1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C1ParkingLot")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Landscaping")%></td>
<td><%=FP_FieldVal(fp_rs,"C1TrashContainers")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Sidewalks")%></td>
<td><%=FP_FieldVal(fp_rs,"C1Dumpsters")%></td>
<td><%=FP_FieldVal(fp_rs,"C1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C2Doors")%></td>
<td><%=FP_FieldVal(fp_rs,"C2ExteriorLighting")%></td>
<td><%=FP_FieldVal(fp_rs,"C2DtMenuboard")%></td>
<td><%=FP_FieldVal(fp_rs,"C2Windows")%></td>
<td><%=FP_FieldVal(fp_rs,"C2DTSpeaker")%></td>
<td><%=FP_FieldVal(fp_rs,"C2TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Stocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Clean")%></td>
<td><%=FP_FieldVal(fp_rs,"C3Odor")%></td>
<td><%=FP_FieldVal(fp_rs,"C3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C4Clean")%></td>
<td><%=FP_FieldVal(fp_rs,"C4Caution")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Ceiling")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Pictures")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Decor")%></td>
<td><%=FP_FieldVal(fp_rs,"C5Walls")%></td>
<td><%=FP_FieldVal(fp_rs,"C5LightFixtures")%></td>
<td><%=FP_FieldVal(fp_rs,"C4andC5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Counters")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Menuboards")%></td>
<td><%=FP_FieldVal(fp_rs,"C6DisplayCases")%></td>
<td><%=FP_FieldVal(fp_rs,"C6SelfServiceArea")%></td>
<td><%=FP_FieldVal(fp_rs,"C6Menus")%></td>
<td><%=FP_FieldVal(fp_rs,"C6AdvertisingMaterials")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Tables")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Booths")%></td>
<td><%=FP_FieldVal(fp_rs,"C7Seats")%></td>
<td><%=FP_FieldVal(fp_rs,"C7TrashContainers")%></td>
<td><%=FP_FieldVal(fp_rs,"C8SuppliesStored")%></td>
<td><%=FP_FieldVal(fp_rs,"C6andC7andC8TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"CleanlinessPointsPossible")%></td>
<td><%=FP_FieldVal(fp_rs,"CTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"CPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"H1GreetingDTWindow")%></td>
<td><%=FP_FieldVal(fp_rs,"H2AppreciativeClosing")%></td>
<td><%=FP_FieldVal(fp_rs,"H3Smile")%></td>
<td><%=FP_FieldVal(fp_rs,"H3Eyecontact")%></td>
<td><%=FP_FieldVal(fp_rs,"H3FocusedAttention")%></td>
<td><%=FP_FieldVal(fp_rs,"H1andH2andH3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H4ProblemLAST")%></td>
<td><%=FP_FieldVal(fp_rs,"H4LASTExecuted")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Listen")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Apologize")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Satisfy")%></td>
<td><%=FP_FieldVal(fp_rs,"H4Thank")%></td>
<td><%=FP_FieldVal(fp_rs,"H4HoldingCabinet")%></td>
<td><%=FP_FieldVal(fp_rs,"H5ProfessionalManner")%></td>
<td><%=FP_FieldVal(fp_rs,"HLASTBonus")%></td>
<td><%=FP_FieldVal(fp_rs,"H4andH5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H6Uniforms")%></td>
<td><%=FP_FieldVal(fp_rs,"H6WellGroomed")%></td>
<td><%=FP_FieldVal(fp_rs,"H6NeatAndClean")%></td>
<td><%=FP_FieldVal(fp_rs,"H6PersonalHygiene")%></td>
<td><%=FP_FieldVal(fp_rs,"H6EmployeeWhoWaited")%></td>
<td><%=FP_FieldVal(fp_rs,"H6TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"H7Upsize")%></td>
<td><%=FP_FieldVal(fp_rs,"H7UpsizeText")%></td>
<td><%=FP_FieldVal(fp_rs,"HTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"HPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Brand")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Other")%></td>
<td><%=FP_FieldVal(fp_rs,"A1ColdSide")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Drink")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Piece")%></td>
<td><%=FP_FieldVal(fp_rs,"A1HotSide")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Bread")%></td>
<td><%=FP_FieldVal(fp_rs,"A1Buffet")%></td>
<td><%=FP_FieldVal(fp_rs,"A1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Sides")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Packaging")%></td>
<td><%=FP_FieldVal(fp_rs,"A2ChickenType")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Napkins")%></td>
<td><%=FP_FieldVal(fp_rs,"A2ChickenPieces")%></td>
<td><%=FP_FieldVal(fp_rs,"A2Condiments")%></td>
<td><%=FP_FieldVal(fp_rs,"A3CorrectAmount")%></td>
<td><%=FP_FieldVal(fp_rs,"A3CorrectChange")%></td>
<td><%=FP_FieldVal(fp_rs,"A2andA3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"A4ConfirmOrder")%></td>
<td><%=FP_FieldVal(fp_rs,"A4TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"ATotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"APercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Building")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTmenuboard")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Lights")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTSpeaker")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Signs")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Grass")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Advertising")%></td>
<td><%=FP_FieldVal(fp_rs,"M1ParkingLot")%></td>
<td><%=FP_FieldVal(fp_rs,"M1Sidewalks")%></td>
<td><%=FP_FieldVal(fp_rs,"M1DTLane")%></td>
<td><%=FP_FieldVal(fp_rs,"M1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Floor")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Walls")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Ceiling")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Lights")%></td>
<td><%=FP_FieldVal(fp_rs,"M2Doors")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Entryway")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Advertising")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Menuboards")%></td>
<td><%=FP_FieldVal(fp_rs,"M3Menus")%></td>
<td><%=FP_FieldVal(fp_rs,"M4Restrooms")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Tables")%></td>
<td><%=FP_FieldVal(fp_rs,"M5MusicVolume")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Seats")%></td>
<td><%=FP_FieldVal(fp_rs,"M5Booths")%></td>
<td><%=FP_FieldVal(fp_rs,"M2andM3andM4andM5TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"M6BrixLevel")%></td>
<td><%=FP_FieldVal(fp_rs,"M6BrixLevelText")%></td>
<td><%=FP_FieldVal(fp_rs,"M6TypeOfDrink")%></td>
<td><%=FP_FieldVal(fp_rs,"M6Carbonation")%></td>
<td><%=FP_FieldVal(fp_rs,"M6TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"MTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"MPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"P1FreshMoistTender")%></td>
<td><%=FP_FieldVal(fp_rs,"P1AcceptableColor")%></td>
<td><%=FP_FieldVal(fp_rs,"P1WithoutExcessiveShortening")%></td>
<td><%=FP_FieldVal(fp_rs,"P1BreadedProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P1ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P1TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"P2Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P2Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P2AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P2FilledProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P2ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P2HotSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P2OtherText")%></td>
<td><%=FP_FieldVal(fp_rs,"P3Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P3Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P3AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P3FilledProperly")%></td>
<td><%=FP_FieldVal(fp_rs,"P3ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P3ColdSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P3OtherText")%></td>
<td><%=FP_FieldVal(fp_rs,"P2andP3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"P4Temperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P4Fresh")%></td>
<td><%=FP_FieldVal(fp_rs,"P4AcceptableAppearance")%></td>
<td><%=FP_FieldVal(fp_rs,"P4ProperTemperature")%></td>
<td><%=FP_FieldVal(fp_rs,"P4BreadSideItem")%></td>
<td><%=FP_FieldVal(fp_rs,"P4TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"PTotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"PPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"S1GreetedInTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S2GreetedInTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S2HoldTime")%></td>
<td><%=FP_FieldVal(fp_rs,"S1andS2TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"S3CustomerService")%></td>
<td><%=FP_FieldVal(fp_rs,"S3OrderTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3OrderTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3WindowTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3WindowTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalTimeMin")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalTimeSec")%></td>
<td><%=FP_FieldVal(fp_rs,"S3Customers")%></td>
<td><%=FP_FieldVal(fp_rs,"S3TotalPointsDocked")%></td>
<td><%=FP_FieldVal(fp_rs,"STotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"SPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"TotalPointsEarned")%></td>
<td><%=FP_FieldVal(fp_rs,"RoundedRegularPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"DealBreakerPercentage")%></td>
<td><%=FP_FieldVal(fp_rs,"TotalPointsPossible")%></td>
<td><%=FP_FieldVal(fp_rs,"RoundedActualScorePercentage")%></td>
		</tr>
		<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
<p> </p>
<p> </p>

</body>

</html>



Spooky -> RE: Order By Column Question (1/25/2005 19:02:18)

You have an extra quote at the end of the string

It should be :
fp_sQry= "SELECT ....... SORT BY "&Replace(request.form("SortColumn"),"'","''")



dzirkelb1 -> RE: Order By Column Question (1/26/2005 10:02:00)

I took out the quotations and now get this error:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'FP_SetLocaleForPage'
D:\INETPUB\WWWROOT\KFC\../_fpclass/fpdbrgn1.inc, line 4

Line 4 is FP_SetLocaleForPage on that file...however, I haven't found the line to ever be accurate when the error shows.


Also, isn't that quotation the one that closes the whole statement? Like, "SELECT......."?




dzirkelb1 -> RE: Order By Column Question (1/26/2005 10:50:37)

There may be a problem with my page besides what we are trying to do as I simply removed the sort by code, and produced an error...I added a " at the end, and produced an error...both referred to the line of code for the sql statement or the same as above, the fpdbrgn1.inc file line 4.



dzirkelb1 -> RE: Order By Column Question (1/26/2005 13:04:26)

I started from scratch with a new spooky diet to ensure I didn't miss anything...(i did the macro this time). Now, It is coming up, but, it is producing a database error:

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

I added the code you requested above of:
Response.write fp_sQry
response.end

and it types the following code on my screen: 
* FROM qryTotalScores WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0) And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) SORT BY


its basically the whole code minus anything past the SORT BY

So, basically reset my data to ensure the diet was made correctly. here is my asp code: 
<%
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) SORT BY "&Replace(request.form("SortColumn"),"'","''")
fp_sDefault="GreatCPercentage=&GreatCPercentage=&LessCPercentage=&LessCPercentage=&GreatHPercentage=&GreatHPercentage=&LessHPercentage=&LessHPercentage=&GreatAPercentage=&GreatAPercentage=&LessAPercentage=&LessAPercentage=&GreatMPercentage=&GreatMPercentage=&LessMPercentage=&LessMPercentage=&GreatPPercentage=&GreatPPercentage=&LessPPercentage=&LessPPercentage=&GreatSPercentage=&GreatSPercentage=&LessSPercentage=&LessSPercentage=&GreatRoundedActualScorePercentage=&GreatRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&GreatD1EntreeTemp=&GreatD1EntreeTemp=&LessD1EntreeTemp=&LessD1EntreeTemp=&GreatP2Temperature=&GreatP2Temperature=&LessP2Temperature=&LessP2Temperature=&GreatP3Temperature=&GreatP3Temperature=&LessP3Temperature=&LessP3Temperature=&GreatP4Temperature=&GreatP4Temperature=&LessP4Temperature=&LessP4Temperature=&CarryOutDriveThru=&CarryOutDriveThru="
fp_sNoRecords="<tr><td colspan=188 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="KFC"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&EvalCode=3&StoreID=202&EvalDate=135&DayOfWeek=202&Time=135&DayPart=202&Rep=5&Period=202&CostOfProduct=6&CarryOutDriveThru=5&D1InsectsAndPests=5&D1RudeBehavior=5&D1MainEntreeTemperature=3&D1EntreeOrdered=5&D1EntreeTemp=5&D1OtherChicken=202&D1TotalPointsDocked=3&C1ParkingLot=5&C1Landscaping=5&C1TrashContainers=5&C1Sidewalks=5&C1Dumpsters=5&C1TotalPointsDocked=3&C2Doors=5&C2ExteriorLighting=3&C2DtMenuboard=3&C2Windows=3&C2DTSpeaker=3&C2TotalPointsDocked=3&C3Stocked=3&C3Clean=3&C3Odor=3&C3TotalPointsDocked=3&C4Clean=3&C4Caution=3&C5Ceiling=3&C5Pictures=3&C5Decor=3&C5Walls=3&C5LightFixtures=3&C4andC5TotalPointsDocked=3&C6Counters=3&C6Menuboards=3&C6DisplayCases=3&C6SelfServiceArea=3&C6Menus=3&C6AdvertisingMaterials=3&C7Tables=3&C7Booths=3&C7Seats=3&C7TrashContainers=3&C8SuppliesStored=3&C6andC7andC8TotalPointsDocked=3&CleanlinessPointsPossible=3&CTotalPointsEarned=3&CPercentage=5&H1FriendlyGreeting=3&H1GreetingDTWindow=3&H2AppreciativeClosing=3&H3Smile=3&H3Eyecontact=3&H3FocusedAttention=3&H1andH2andH3TotalPointsDocked=3&H4ProblemLAST=3&H4LASTExecuted=3&H4Listen=3&H4Apologize=3&H4Satisfy=3&H4Thank=3&H4HoldingCabinet=3&H5ProfessionalManner=3&HLASTBonus=3&H4andH5TotalPointsDocked=3&H6Uniforms=3&H6WellGroomed=3&H6NeatAndClean=3&H6PersonalHygiene=3&H6EmployeeWhoWaited=202&H6TotalPointsDocked=3&H7Upsize=3&H7UpsizeText=202&HTotalPointsEarned=3&HPercentage=5&A1Brand=3&A1Other=3&A1ColdSide=3&A1Drink=3&A1Piece=3&A1HotSide=3&A1Bread=3&A1Buffet=3&A1TotalPointsDocked=3&A2Sides=3&A2Packaging=3&A2ChickenType=3&A2Napkins=3&A2ChickenPieces=3&A2Condiments=3&A3CorrectAmount=3&A3CorrectChange=3&A2andA3TotalPointsDocked=3&A4ConfirmOrder=3&A4TotalPointsDocked=3&ATotalPointsEarned=3&APercentage=5&M1Building=3&M1DTmenuboard=3&M1Lights=3&M1DTSpeaker=3&M1Signs=3&M1Grass=3&M1Advertising=3&M1ParkingLot=3&M1Sidewalks=3&M1DTLane=3&M1TotalPointsDocked=3&M2Floor=3&M2Walls=3&M2Ceiling=3&M2Lights=3&M2Doors=3&M3Entryway=3&M3Advertising=3&M3Menuboards=3&M3Menus=3&M4Restrooms=3&M5Tables=3&M5MusicVolume=3&M5Temperature=3&M5Seats=3&M5Booths=3&M2andM3andM4andM5TotalPointsDocked=3&M6BrixLevel=3&M6BrixLevelText=202&M6TypeOfDrink=202&M6Carbonation=3&M6TotalPointsDocked=3&MTotalPointsEarned=3&MPercentage=5&P1FreshMoistTender=3&P1AcceptableColor=3&P1WithoutExcessiveShortening=3&P1BreadedProperly=3&P1ProperTemperature=3&P1TotalPointsDocked=3&P2Temperature=3&P2Fresh=3&P2AcceptableAppearance=3&P2FilledProperly=3&P2ProperTemperature=3&P2HotSideItem=3&P2OtherText=202&P3Temperature=3&P3Fresh=3&P3AcceptableAppearance=3&P3FilledProperly=3&P3ProperTemperature=3&P3ColdSideItem=3&P3OtherText=202&P2andP3TotalPointsDocked=3&P4Temperature=3&P4Fresh=3&P4AcceptableAppearance=3&P4ProperTemperature=3&P4BreadSideItem=3&P4TotalPointsDocked=3&PTotalPointsEarned=3&PPercentage=5&S1GreetedInTime=3&S2GreetedInTime=3&S2HoldTime=5&S1andS2TotalPointsDocked=3&S3CustomerService=3&S3OrderTimeMin=3&S3OrderTimeSec=3&S3WindowTimeMin=3&S3WindowTimeSec=3&S3TotalTimeMin=3&S3TotalTimeSec=3&S3Customers=202&S3TotalPointsDocked=3&STotalPointsEarned=3&SPercentage=5&TotalPointsEarned=5&RoundedRegularPercentage=5&DealBreakerPercentage=5&TotalPointsPossible=5&RoundedActualScorePercentage=5&"
fp_iDisplayCols=188
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


It includes the include files, just didn't want to paste everything on the code as its very large.




Spooky -> RE: Order By Column Question (1/26/2005 13:37:09)

Is there an error without the sort code?



dzirkelb1 -> RE: Order By Column Question (1/26/2005 14:01:32)

the page displays fine without the sort code; however, I have to add a " at the end. If I add that " at the end with the sort code, then it also produces an error.

The error is:

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/kfc/reports.asp, line 340, column 2135



Spooky -> RE: Order By Column Question (1/26/2005 14:08:05)

ARRRGGGGH!
Sorry - I always do that, its "ORDER" not "SORT" [:@]

<%
SortColumn = Replace(Request("SortColumn"),"'","''")
If SortColumn = "" then SortColumn = " your_default_sort desc "

fp_sQry = "SELECT ........ ORDER BY "& SortColumn



dzirkelb1 -> RE: Order By Column Question (1/26/2005 14:20:41)

Still getting an error on this...here is my code: 

<%
SortColumn = Replace(Request("SortColumn"),"'","''") 
If SortColumn = "" then SortColumn = "EvalCode DESC"
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) ORDER BY "&Replace(request.form("SortColumn"),"'","''")
fp_sDefault="GreatCPercentage=&GreatCPercentage=&LessCPercentage=&LessCPercentage=&GreatHPercentage=&GreatHPercentage=&LessHPercentage=&LessHPercentage=&GreatAPercentage=&GreatAPercentage=&LessAPercentage=&LessAPercentage=&GreatMPercentage=&GreatMPercentage=&LessMPercentage=&LessMPercentage=&GreatPPercentage=&GreatPPercentage=&LessPPercentage=&LessPPercentage=&GreatSPercentage=&GreatSPercentage=&LessSPercentage=&LessSPercentage=&GreatRoundedActualScorePercentage=&GreatRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&GreatD1EntreeTemp=&GreatD1EntreeTemp=&LessD1EntreeTemp=&LessD1EntreeTemp=&GreatP2Temperature=&GreatP2Temperature=&LessP2Temperature=&LessP2Temperature=&GreatP3Temperature=&GreatP3Temperature=&LessP3Temperature=&LessP3Temperature=&GreatP4Temperature=&GreatP4Temperature=&LessP4Temperature=&LessP4Temperature=&CarryOutDriveThru=&CarryOutDriveThru="
fp_sNoRecords="<tr><td colspan=188 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="KFC"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&EvalCode=3&StoreID=202&EvalDate=135&DayOfWeek=202&Time=135&DayPart=202&Rep=5&Period=202&CostOfProduct=6&CarryOutDriveThru=5&D1InsectsAndPests=5&D1RudeBehavior=5&D1MainEntreeTemperature=3&D1EntreeOrdered=5&D1EntreeTemp=5&D1OtherChicken=202&D1TotalPointsDocked=3&C1ParkingLot=5&C1Landscaping=5&C1TrashContainers=5&C1Sidewalks=5&C1Dumpsters=5&C1TotalPointsDocked=3&C2Doors=5&C2ExteriorLighting=3&C2DtMenuboard=3&C2Windows=3&C2DTSpeaker=3&C2TotalPointsDocked=3&C3Stocked=3&C3Clean=3&C3Odor=3&C3TotalPointsDocked=3&C4Clean=3&C4Caution=3&C5Ceiling=3&C5Pictures=3&C5Decor=3&C5Walls=3&C5LightFixtures=3&C4andC5TotalPointsDocked=3&C6Counters=3&C6Menuboards=3&C6DisplayCases=3&C6SelfServiceArea=3&C6Menus=3&C6AdvertisingMaterials=3&C7Tables=3&C7Booths=3&C7Seats=3&C7TrashContainers=3&C8SuppliesStored=3&C6andC7andC8TotalPointsDocked=3&CleanlinessPointsPossible=3&CTotalPointsEarned=3&CPercentage=5&H1FriendlyGreeting=3&H1GreetingDTWindow=3&H2AppreciativeClosing=3&H3Smile=3&H3Eyecontact=3&H3FocusedAttention=3&H1andH2andH3TotalPointsDocked=3&H4ProblemLAST=3&H4LASTExecuted=3&H4Listen=3&H4Apologize=3&H4Satisfy=3&H4Thank=3&H4HoldingCabinet=3&H5ProfessionalManner=3&HLASTBonus=3&H4andH5TotalPointsDocked=3&H6Uniforms=3&H6WellGroomed=3&H6NeatAndClean=3&H6PersonalHygiene=3&H6EmployeeWhoWaited=202&H6TotalPointsDocked=3&H7Upsize=3&H7UpsizeText=202&HTotalPointsEarned=3&HPercentage=5&A1Brand=3&A1Other=3&A1ColdSide=3&A1Drink=3&A1Piece=3&A1HotSide=3&A1Bread=3&A1Buffet=3&A1TotalPointsDocked=3&A2Sides=3&A2Packaging=3&A2ChickenType=3&A2Napkins=3&A2ChickenPieces=3&A2Condiments=3&A3CorrectAmount=3&A3CorrectChange=3&A2andA3TotalPointsDocked=3&A4ConfirmOrder=3&A4TotalPointsDocked=3&ATotalPointsEarned=3&APercentage=5&M1Building=3&M1DTmenuboard=3&M1Lights=3&M1DTSpeaker=3&M1Signs=3&M1Grass=3&M1Advertising=3&M1ParkingLot=3&M1Sidewalks=3&M1DTLane=3&M1TotalPointsDocked=3&M2Floor=3&M2Walls=3&M2Ceiling=3&M2Lights=3&M2Doors=3&M3Entryway=3&M3Advertising=3&M3Menuboards=3&M3Menus=3&M4Restrooms=3&M5Tables=3&M5MusicVolume=3&M5Temperature=3&M5Seats=3&M5Booths=3&M2andM3andM4andM5TotalPointsDocked=3&M6BrixLevel=3&M6BrixLevelText=202&M6TypeOfDrink=202&M6Carbonation=3&M6TotalPointsDocked=3&MTotalPointsEarned=3&MPercentage=5&P1FreshMoistTender=3&P1AcceptableColor=3&P1WithoutExcessiveShortening=3&P1BreadedProperly=3&P1ProperTemperature=3&P1TotalPointsDocked=3&P2Temperature=3&P2Fresh=3&P2AcceptableAppearance=3&P2FilledProperly=3&P2ProperTemperature=3&P2HotSideItem=3&P2OtherText=202&P3Temperature=3&P3Fresh=3&P3AcceptableAppearance=3&P3FilledProperly=3&P3ProperTemperature=3&P3ColdSideItem=3&P3OtherText=202&P2andP3TotalPointsDocked=3&P4Temperature=3&P4Fresh=3&P4AcceptableAppearance=3&P4ProperTemperature=3&P4BreadSideItem=3&P4TotalPointsDocked=3&PTotalPointsEarned=3&PPercentage=5&S1GreetedInTime=3&S2GreetedInTime=3&S2HoldTime=5&S1andS2TotalPointsDocked=3&S3CustomerService=3&S3OrderTimeMin=3&S3OrderTimeSec=3&S3WindowTimeMin=3&S3WindowTimeSec=3&S3TotalTimeMin=3&S3TotalTimeSec=3&S3Customers=202&S3TotalPointsDocked=3&STotalPointsEarned=3&SPercentage=5&TotalPointsEarned=5&RoundedRegularPercentage=5&DealBreakerPercentage=5&TotalPointsPossible=5&RoundedActualScorePercentage=5&"
fp_iDisplayCols=188
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


It is producing the following error:

Description: Syntax error in ORDER BY clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for all form fields that are used in the query.


I added a text box for the column to search by (will be drop down when complete), and if you enter in a column name, then it sorts it accordingly...but, ascending. So, it is sorting by column name now; however, it is asking for a default or else it provides an error. Also, I wish to have the user select asc or desc...how do I incorporate that in?




Spooky -> RE: Order By Column Question (1/26/2005 21:38:41)

You havent changed the query string as above?

fp_sQry = "SELECT ........ ORDER BY "& SortColumn



dzirkelb1 -> RE: Order By Column Question (1/27/2005 10:10:14)

Woops, I replaced it so it works great now!!

Now, step two...I wish to add a drop down or radio button, whatever, so they can choose desc or asc for the column they wish to sort....here is what I have been playing around with: 

SortColumn = Replace(Request("SortColumn"),"'","''")
ColumnFilter = Replace(Request("ColumnFilter"), "'", "''")
If SortColumn = "" then SortColumn = "EvalCode"
If ColumnFilter = "" then ColumnFilter = "ASC"
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) ORDER BY "& SortColumn & ColumnFilter


This brings up the error:
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

Thanks! I'm real close!!!



Spooky -> RE: Order By Column Question (1/27/2005 13:42:55)

Ensure you leave a space - otherwise the code will be "order by EvalCodeASC " :

If SortColumn = "" then SortColumn = "EvalCode "
If ColumnFilter = "" then ColumnFilter = "[space]ASC"



dzirkelb1 -> RE: Order By Column Question (1/27/2005 14:12:41)

When I add the space, I then get an error when opening the page:

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/kfc/reports.asp, line 357, column 2118


Here is the code: 

<%
SortColumn = Replace(Request("SortColumn"),"'","''")
ColumnFilter = Replace(Request("ColumnFilter"), "'", "''")
If SortColumn = "" then SortColumn = "EvalCode"
If ColumnFilter = "" then ColumnFilter = " ASC"
fp_sQry="SELECT * FROM qryTotalScores  WHERE IIf(('::GreatCPercentage::'&''=''), True, CPercentage>=::GreatCPercentage::+0) And IIf(('::LessCPercentage::'&''=''), True, CPercentage<=::LessCPercentage::+0) And IIf(('::GreatHPercentage::'&''=''), True, HPercentage>=::GreatHPercentage::+0) And IIf(('::LessHPercentage::'&''=''), True, HPercentage<=::LessHPercentage::+0) And IIf(('::GreatAPercentage::'&''=''), True, APercentage>=::GreatAPercentage::+0) And IIf(('::LessAPercentage::'&''=''), True, APercentage<=::LessAPercentage::+0) And IIf(('::GreatMPercentage::'&''=''), True, MPercentage>=::GreatMPercentage::+0) And IIf(('::LessMPercentage::'&''=''), True, MPercentage<=::LessMPercentage::+0) And IIf(('::GreatPPercentage::'&''=''), True, PPercentage>=::GreatPPercentage::+0) And IIf(('::LessPPercentage::'&''=''), True, PPercentage<=::LessPPercentage::+0) And IIf(('::GreatSPercentage::'&''=''), True, SPercentage>=::GreatSPercentage::+0) And IIf(('::LessSPercentage::'&''=''), True, SPercentage<=::LessSPercentage::+0) And IIf(('::GreatRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage>=::GreatRoundedActualScorePercentage::+0) And IIf(('::LessRoundedActualScorePercentage::'&''=''), True, RoundedActualScorePercentage<=::LessRoundedActualScorePercentage::+0) And IIf(('::GreatD1EntreeTemp::'&''=''), True, D1EntreeTemp>=::GreatD1EntreeTemp::+0) And IIf(('::LessD1EntreeTemp::'&''=''), True, D1EntreeTemp<=::LessD1EntreeTemp::+0) And IIf(('::GreatP2Temperature::'&''=''), True, P2Temperature>=::GreatP2Temperature::+0) And IIf(('::LessP2Temperature::'&''=''), True, P2Temperature<=::LessP2Temperature::+0)  And IIf(('::GreatP3Temperature::'&''=''), True, P3Temperature>=::GreatP3Temperature::+0) And IIf(('::LessP3Temperature::'&''=''), True, P3Temperature<=::LessP3Temperature::+0) And IIf(('::GreatP4Temperature::'&''=''), True, P4Temperature>=::GreatP4Temperature::+0) And IIf(('::LessP4Temperature::'&''=''), True, P4Temperature<=::LessP4Temperature::+0) And IIf(('::CarryOutDriveThru::'&''=''), True, CarryOutDriveThru=::CarryOutDriveThru::+0) ORDER BY "& SortColumn & ColumnFilter
fp_sDefault="GreatCPercentage=&GreatCPercentage=&LessCPercentage=&LessCPercentage=&GreatHPercentage=&GreatHPercentage=&LessHPercentage=&LessHPercentage=&GreatAPercentage=&GreatAPercentage=&LessAPercentage=&LessAPercentage=&GreatMPercentage=&GreatMPercentage=&LessMPercentage=&LessMPercentage=&GreatPPercentage=&GreatPPercentage=&LessPPercentage=&LessPPercentage=&GreatSPercentage=&GreatSPercentage=&LessSPercentage=&LessSPercentage=&GreatRoundedActualScorePercentage=&GreatRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&LessRoundedActualScorePercentage=&GreatD1EntreeTemp=&GreatD1EntreeTemp=&LessD1EntreeTemp=&LessD1EntreeTemp=&GreatP2Temperature=&GreatP2Temperature=&LessP2Temperature=&LessP2Temperature=&GreatP3Temperature=&GreatP3Temperature=&LessP3Temperature=&LessP3Temperature=&GreatP4Temperature=&GreatP4Temperature=&LessP4Temperature=&LessP4Temperature=&CarryOutDriveThru=&CarryOutDriveThru="
fp_sNoRecords="<tr><td colspan=188 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="KFC"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&EvalCode=3&StoreID=202&EvalDate=135&DayOfWeek=202&Time=135&DayPart=202&Rep=5&Period=202&CostOfProduct=6&CarryOutDriveThru=5&D1InsectsAndPests=5&D1RudeBehavior=5&D1MainEntreeTemperature=3&D1EntreeOrdered=5&D1EntreeTemp=5&D1OtherChicken=202&D1TotalPointsDocked=3&C1ParkingLot=5&C1Landscaping=5&C1TrashContainers=5&C1Sidewalks=5&C1Dumpsters=5&C1TotalPointsDocked=3&C2Doors=5&C2ExteriorLighting=3&C2DtMenuboard=3&C2Windows=3&C2DTSpeaker=3&C2TotalPointsDocked=3&C3Stocked=3&C3Clean=3&C3Odor=3&C3TotalPointsDocked=3&C4Clean=3&C4Caution=3&C5Ceiling=3&C5Pictures=3&C5Decor=3&C5Walls=3&C5LightFixtures=3&C4andC5TotalPointsDocked=3&C6Counters=3&C6Menuboards=3&C6DisplayCases=3&C6SelfServiceArea=3&C6Menus=3&C6AdvertisingMaterials=3&C7Tables=3&C7Booths=3&C7Seats=3&C7TrashContainers=3&C8SuppliesStored=3&C6andC7andC8TotalPointsDocked=3&CleanlinessPointsPossible=3&CTotalPointsEarned=3&CPercentage=5&H1FriendlyGreeting=3&H1GreetingDTWindow=3&H2AppreciativeClosing=3&H3Smile=3&H3Eyecontact=3&H3FocusedAttention=3&H1andH2andH3TotalPointsDocked=3&H4ProblemLAST=3&H4LASTExecuted=3&H4Listen=3&H4Apologize=3&H4Satisfy=3&H4Thank=3&H4HoldingCabinet=3&H5ProfessionalManner=3&HLASTBonus=3&H4andH5TotalPointsDocked=3&H6Uniforms=3&H6WellGroomed=3&H6NeatAndClean=3&H6PersonalHygiene=3&H6EmployeeWhoWaited=202&H6TotalPointsDocked=3&H7Upsize=3&H7UpsizeText=202&HTotalPointsEarned=3&HPercentage=5&A1Brand=3&A1Other=3&A1ColdSide=3&A1Drink=3&A1Piece=3&A1HotSide=3&A1Bread=3&A1Buffet=3&A1TotalPointsDocked=3&A2Sides=3&A2Packaging=3&A2ChickenType=3&A2Napkins=3&A2ChickenPieces=3&A2Condiments=3&A3CorrectAmount=3&A3CorrectChange=3&A2andA3TotalPointsDocked=3&A4ConfirmOrder=3&A4TotalPointsDocked=3&ATotalPointsEarned=3&APercentage=5&M1Building=3&M1DTmenuboard=3&M1Lights=3&M1DTSpeaker=3&M1Signs=3&M1Grass=3&M1Advertising=3&M1ParkingLot=3&M1Sidewalks=3&M1DTLane=3&M1TotalPointsDocked=3&M2Floor=3&M2Walls=3&M2Ceiling=3&M2Lights=3&M2Doors=3&M3Entryway=3&M3Advertising=3&M3Menuboards=3&M3Menus=3&M4Restrooms=3&M5Tables=3&M5MusicVolume=3&M5Temperature=3&M5Seats=3&M5Booths=3&M2andM3andM4andM5TotalPointsDocked=3&M6BrixLevel=3&M6BrixLevelText=202&M6TypeOfDrink=202&M6Carbonation=3&M6TotalPointsDocked=3&MTotalPointsEarned=3&MPercentage=5&P1FreshMoistTender=3&P1AcceptableColor=3&P1WithoutExcessiveShortening=3&P1BreadedProperly=3&P1ProperTemperature=3&P1TotalPointsDocked=3&P2Temperature=3&P2Fresh=3&P2AcceptableAppearance=3&P2FilledProperly=3&P2ProperTemperature=3&P2HotSideItem=3&P2OtherText=202&P3Temperature=3&P3Fresh=3&P3AcceptableAppearance=3&P3FilledProperly=3&P3ProperTemperature=3&P3ColdSideItem=3&P3OtherText=202&P2andP3TotalPointsDocked=3&P4Temperature=3&P4Fresh=3&P4AcceptableAppearance=3&P4ProperTemperature=3&P4BreadSideItem=3&P4TotalPointsDocked=3&PTotalPointsEarned=3&PPercentage=5&S1GreetedInTime=3&S2GreetedInTime=3&S2HoldTime=5&S1andS2TotalPointsDocked=3&S3CustomerService=3&S3OrderTimeMin=3&S3OrderTimeSec=3&S3WindowTimeMin=3&S3WindowTimeSec=3&S3TotalTimeMin=3&S3TotalTimeSec=3&S3Customers=202&S3TotalPointsDocked=3&STotalPointsEarned=3&SPercentage=5&TotalPointsEarned=5&RoundedRegularPercentage=5&DealBreakerPercentage=5&TotalPointsPossible=5&RoundedActualScorePercentage=5&"
fp_iDisplayCols=188
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>



Spooky