Order By Column Question

	Home Register Search Help Login

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

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

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, PHP, and Database >> Order By Column Question

Page: [1]


dzirkelb1 Posts: 1433 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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

Posts: 1433
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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 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: 1433 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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

Posts: 1433
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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 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: 1433 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: 1433
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: 26680 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 Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	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 (in reply to Spooky)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	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 _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

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

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?

(in reply to Spooky)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	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 _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

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

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

(in reply to Spooky)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	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" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

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

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

(in reply to Spooky)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Order By Column Question - 1/27/2005 19:12:25 Line 357 is what code? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)

dzirkelb1

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

RE: Order By Column Question - 1/28/2005 9:59:58

Odd...I played around with it yesterday quite a bit, and now am getting line 432 error...so, I copied and pasted the code above into my code to replicate yesterday's error...but, I am still getting 432...here's the error:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: " "]'
/kfc/reports.asp, line 432

I did a find for and the only strings it found were in the spaces between my submission form and my results form.

Line 432 is :<td><%if FP_FieldVal(fp_rs,"CPercentage") < 70 then %>
That whole tidbit is:

	<td><%if FP_FieldVal(fp_rs,"CPercentage") < 70 then %>
	<font color="#FF0000"><b><%=FP_FieldVal(fp_rs,"CPercentage")%></b></font>
	<%else%>
	<%=FP_FieldVal(fp_rs,"CPercentage")%>
	<%end if%>
	</td>

Line 357 is my sql statement...it is:

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

The whole asp code is:

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
SortColumn = Replace(Request("SortColumn"),"'","''")
ColumnFilter = Replace(Request("ColumnFilter"), "'", "''")
If SortColumn = "" then SortColumn = "EvalCode"
If ColumnFilter = "" then ColumnFilter = " ASC"
 
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
%>

(in reply to Spooky)


Spooky Posts: 26680 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Order By Column Question - 1/28/2005 12:12:17 You would have to use a numeric comparison, however the output from the database is not numeric if using the FPfieldval() function <% If fp_rs("CPercentage") &""="" then intCPercentage = 0 else intCPercentage = fp_rs("CPercentage") if cInt(intCPercentage ) < 70 then %> _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to dzirkelb1)


dzirkelb1 Posts: 1433 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: Order By Column Question - 1/28/2005 12:32:09 You...are a genious. It works perfectly (after I figured on my test I had to do [space]asc than just asc)...I'll put it that way for the values sent...thanks a million!!! (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP, PHP, and Database >> Order By Column Question

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts