navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Order By Column Question

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Order By Column Question 		Page: [1]
 
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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::

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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?

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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.

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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!!

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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?

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Order By Column Question - 1/25/2005 15:21:39   
If you want to risk it :-)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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.

(in reply to Spooky)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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

(in reply to dzirkelb1)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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"),"'","''")

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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>

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		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"),"'","''")

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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......."?


(in reply to Spooky)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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.

(in reply to dzirkelb1)
dzirkelb1

 

Posts: 1300
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline

  		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.


(in reply to dzirkelb1)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Order By Column Question - 1/26/2005 13:37:09   
Is there an error without the sort code?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to