Checkboxes and Null Values

	Home Register Search Help Login

Sponsors

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

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

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

Search Forums

Recent Posts

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

Checkboxes and Null Values

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

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> General Web Development >> Checkboxes and Null Values

Page: [1]


dzirkelb1 Posts: 1313 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	Checkboxes and Null Values - 2/5/2008 11:47:28 I have a checkbox where if you select it, its value is one. If you don't select it, it's value is null. Is there a way to make it so if it is not selected, its value is 0? Here is the check box: <input type="checkbox" name="C1ParkingLot" value="1"> thanks!


swoosh Posts: 1438 Joined: 5/18/2002 From: Beaver Falls, PA Status: offline	RE: Checkboxes and Null Values - 2/5/2008 11:55:30 Would this work: <input type="hidden" name="box1" value="0" /> <input type="checkbox" name="box1" value="1" /> What happens here is that when the checkbox is left unchecked, the hidden field�s value gets submitted, as-is. When the check box is checked, the hidden field�s POST value gets overwritten by the activated checkbox�s. Unactivated: Hidden field�s value. Activated: Check box�s value. _____________________________ Swoooosh Just Do It! (in reply to dzirkelb1)


dzirkelb1 Posts: 1313 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: Checkboxes and Null Values - 2/5/2008 12:02:57 That is a good idea, but it doesn't work correctly. When I check nothing, 0 is sent like it should be. however, when I check it, then the request.form's value is 0,1...it sends both when it is checked. Any other ideas? (in reply to swoosh)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkboxes and Null Values - 2/5/2008 12:37:19 If Trim(request.form("C1ParkingLot") & "") = "" Then myVal = "0" else myVal = request.form("C1ParkingLot") End if _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1313 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: Checkboxes and Null Values - 2/5/2008 13:20:59 I'm trying to get away from doing that rdouglas, as i already wrote the sql statement and there are like a hundred checkboxes being sent...I dont want 100 if then statements. (in reply to rdouglass)

dzirkelb1

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

RE: Checkboxes and Null Values - 2/5/2008 13:27:33

This is the query:

ssql = "INSERT INTO tblMasterEvaluations"
ssql = ssql & " (DayOfWeek, DayPart, [Time], StoreID, EvalDate, GivenReceipt, CostOfProduct, CarryOutDriveThru, ThankYou, FoodBuy, Drink,"
ssql = ssql & " D1InsectsAndPests, D1RudeBehavior, D1MainEntreeTemperature, D1EntreeOrdered, D1OtherChicken, DCustomerDealBreakerComments,"
ssql = ssql & " C1ParkingLot, C1Landscaping, C1TrashContainers, C1Sidewalks, C1Dumpsters, C2Doors, C2ExteriorLighting, C2DtMenuboard, C2Windows, C2DTSpeaker, C3Stocked, C3Clean, C3Odor, C3NoBathroomCheck, C4Clean, C4Caution, C5Ceiling, C5Pictures, C5Decor, C5Walls, C5LightFixtures, C6Counters, C6Menuboards, C6DisplayCases, C6SelfServiceArea, C6Menus, C6AdvertisingMaterials, C7Tables, C7Booths, C7Seats, C7TrashContainers, C8SuppliesStored, CCleanlinessComments."
ssql = ssql & " M1Building, M1DTmenuboard, M1Lights, M1DTSpeaker, M1Signs, M1Grass, M1Advertising, M1ParkingLot, M1Sidewalks, M1DTLane, M2Floor, M2Walls, M2Ceiling, M2Lights, M2Doors, M3Entryway, M3Advertising, M3Menuboards, M3Menus, M4Restrooms, M5Tables, M5MusicVolume, M5Temperature, M5Seats, M5Booths, M6BrixLevel, M6TypeOfDrink, M6Carbonation, MMaintenanceComments,"
ssql = ssql & " P1FreshMoistTender, P1AcceptableColor, P1WithoutExcessiveShortening, P1BreadedProperly, P1ProperTemperature, P2Temperature, P2Fresh, P2HotSideItem, P2AcceptableAppearance, P2FilledProperly, P2ProperTemperature, P2OtherText, P3Temperature, P3ColdSideItem, P3AcceptableAppearance, P3FilledProperly, P3ProperTemperature, P3Other, P4Temperature, P4Fresh, P4BreadSideItem, P4AcceptableAppearance, P4ProperTemperature, PProductQualityComments,"
ssql = ssql & " H1FriendlyGreeting, H1GreetingDTWindow, H2AppreciativeClosing, H3Smile, H3Eyecontact, H3FocusedAttention, H4ProblemLast, H4LASTExecuted, H4Listen, H4Apologize, H4Satisfy, H4Thank, H4HoldingCabinet, H5ProfessionalManner, H6Uniforms, H6WellGroomed, H6NeatAndClean, H6PersonalHygiene, H6EmployeeWhoWaited, H7Upsize, H7UpsizeText, HHospitalityComments,"
ssql = ssql & " A1Brand, A1Other, A1ColdSide, A1Drink, A1Piece, A1HotSide, A1Bread, A1Buffet, A2Sides, A2Packaging, A2ChickenType, A2Napkins, A2ChickenPieces, A2Condiments, A3CorrectAmount, A3CorrectChange, A4ConfirmOrder, AAccuracyComments,"
ssql = ssql & " S1GreetedInTime, S2GreetedInTime, S2HoldTime, S3CustomerService, S3OrderTimeMin, S3OrderTimeSec, S3WindowTimeMin, S3WindowTimeSec, S3TotalTimeMin, S3TotalTimeSec, S3Customers, SSpeedWithServiceComments,"
ssql = ssql & " CGreeting, CClosing, PKID)"
ssql = ssql & " VALUES ('"&request.form("DayOfWeek")&"', '"&request.form("DayPart")&"', #"&request.form("Time")&"#, '"&request.form("StoreID")&"', #"&request.form("EvalDate")&"#, '"&request.form("GivenReceipt")&"', "&request.form("CostOfProduct")&", "&request.form("CarryOutDriveThru")&", "&request.form("ThankYou")&", '"&request.form("FoodBuy")&"', '"&request.form("Drink")&"',"
ssql = ssql & " "&request.form("D1InsectsAndPests")&", "&request.form("D1RudeBehavior")&", "&request.form("D1MainEntreeTemperature")&", "&request.form("D1EntreeOrdered")&", '"&request.form("D1OtherChicken")&"', '"&request.form("DCustomerDealBreakerComments")&"',"
ssql = ssql & " "&request.form("C1ParkingLot")&", "&request.form("C1Landscaping")&", "&request.form("C1TrashContainers")&", "&request.form("C1Sidewalks")&", "&request.form("C1Dumpsters")&", "&request.form("C2Doors")&", "&request.form("C2ExteriorLighting")&", "&request.form("C2DtMenuboard")&", "&request.form("C2Windows")&", "&request.form("C2DTSpeaker")&", "&request.form("C3Stocked")&", "&request.form("C3Clean")&", "&request.form("C3Odor")&", "&request.form("C3NoBathroomCheck")&", "&request.form("C4Clean")&", "&request.form("C4Caution")&", "&request.form("C5Ceiling")&", "&request.form("C5Pictures")&", "&request.form("C5Decor")&", "&request.form("C5Walls")&", "&request.form("C5LightFixtures")&", "&request.form("C6Counters")&", "&request.form("C6Menuboards")&", "&request.form("C6DisplayCases")&", "&request.form("C6SelfServiceArea")&", "&request.form("C6Menus")&", "&request.form("C6AdvertisingMaterials")&", "&request.form("C7Tables")&", "&request.form("C7Booths")&", "&request.form("C7Seats")&", "&request.form("C7TrashContainers")&", "&request.form("C8SuppliesStored")&", '"&request.form("CCleanlinessComments")&"'."
ssql = ssql & " "&request.form("M1Building")&", "&request.form("M1DTmenuboard")&", "&request.form("M1Lights")&", "&request.form("M1DTSpeaker")&", "&request.form("M1Signs")&", "&request.form("M1Grass")&", "&request.form("M1Advertising")&", "&request.form("M1ParkingLot")&", "&request.form("M1Sidewalks")&", "&request.form("M1DTLane")&", "&request.form("M2Floor")&", "&request.form("M2Walls")&", "&request.form("M2Ceiling")&", "&request.form("M2Lights")&", "&request.form("M2Doors")&", "&request.form("M3Entryway")&", "&request.form("M3Advertising")&", "&request.form("M3Menuboards")&", "&request.form("M3Menus")&", "&request.form("M4Restrooms")&", "&request.form("M5Tables")&", "&request.form("M5MusicVolume")&", "&request.form("M5Temperature")&", "&request.form("M5Seats")&", "&request.form("M5Booths")&", '"&request.form("M6BrixLevel")&"', '"&request.form("M6TypeOfDrink")&"', "&request.form("M6Carbonation")&", '"&request.form("MMaintenanceComments")&"',"
ssql = ssql & " "&request.form("P1FreshMoistTender")&", "&request.form("P1AcceptableColor")&", "&request.form("P1WithoutExcessiveShortening")&", "&request.form("P1BreadedProperly")&", "&request.form("P1ProperTemperature")&", "&request.form("P2Temperature")&", "&request.form("P2Fresh")&", "&request.form("P2HotSideItem")&", "&request.form("P2AcceptableAppearance")&", "&request.form("P2FilledProperly")&", "&request.form("P2ProperTemperature")&", '"&request.form("P2OtherText")&"', "&request.form("P3Temperature")&", "&request.form("P3ColdSideItem")&", "&request.form("P3AcceptableAppearance")&", "&request.form("P3FilledProperly")&", "&request.form("P3ProperTemperature")&", '"&request.form("P3OtherText")&"', "&request.form("P4Temperature")&", "&request.form("P4Fresh")&", "&request.form("P4BreadSideItem")&", "&request.form("P4AcceptableAppearance")&", "&request.form("P4ProperTemperature")&", '"&request.form("PProductQualityComments")&"',"
ssql = ssql & " "&request.form("H1FriendlyGreeting")&", "&request.form("H1GreetingDTWindow")&", "&request.form("H2AppreciativeClosing")&", "&request.form("H3Smile")&", "&request.form("H3Eyecontact")&", "&request.form("H3FocusedAttention")&", "&request.form("H4ProblemLast")&", "&request.form("H4LASTExecuted")&", "&request.form("H4Listen")&", "&request.form("H4Apologize")&", "&request.form("H4Satisfy")&", "&request.form("H4Thank")&", "&request.form("H4HoldingCabinet")&", "&request.form("H5ProfessionalManner")&", "&request.form("H6Uniforms")&", "&request.form("H6WellGroomed")&", "&request.form("H6NeatAndClean")&", "&request.form("H6PersonalHygiene")&", '"&request.form("H6EmployeeWhoWaited")&"', "&request.form("H7Upsize")&", '"&request.form("H7UpsizeText")&"', '"&request.form("HHospitalityComments")&"',"
ssql = ssql & " "&request.form("A1Brand")&", "&request.form("A1Other")&", "&request.form("A1ColdSide")&", "&request.form("A1Drink")&", "&request.form("A1Piece")&", "&request.form("A1HotSide")&", "&request.form("A1Bread")&", "&request.form("A1Buffet")&", "&request.form("A2Sides")&", "&request.form("A2Packaging")&", "&request.form("A2ChickenType")&", "&request.form("A2Napkins")&", "&request.form("A2ChickenPieces")&", "&request.form("A2Condiments")&", "&request.form("A3CorrectAmount")&", "&request.form("A3CorrectChange")&", "&request.form("A4ConfirmOrder")&", '"&request.form("AAccuracyComments")&"',"
ssql = ssql & " "&request.form("S1GreetedInTime")&", "&request.form("S2GreetedInTime")&", "&request.form("S2HoldTime")&", "&request.form("S3CustomerService")&", "&request.form("S3OrderTimeMin")&", "&request.form("S3OrderTimeSec")&", "&request.form("S3WindowTimeMin")&", "&request.form("S3WindowTimeSec")&", "&request.form("S3TotalTimeMin")&", "&request.form("S3TotalTimeSec")&", "&request.form("S3Customers")&", '"&request.form("SSpeedWithServiceComments")&"',"
ssql = ssql & " '"&request.form("CGreeting")&"', '"&request.form("CClosing")&"', "&request.form("hidPKID")&")"

Maybe I could do a function of some sort so I don't have to do 100 if then statements? I am just looking for the fastest way to correct this problem, for as you can see, there are a lot of request.forms's in the query.

(in reply to dzirkelb1)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Checkboxes and Null Values - 2/5/2008 14:24:17 quote: Maybe I could do a function of some sort so I don't have to do 100 if then statements? That's not too far off: <% Function fixTheCheckbox(itemIn) itemIn = trim(itemIn & "") If itemIn = "" Then fixTheCheckbox = "0" else fixTheCheckbox = itemIn End if End Function%> Then call the function like so: ... ssql = ssql & " "&fixTheCheckbox(request.form("D1InsectsAndPests"))", ... ... That any better? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dzirkelb1)


dzirkelb1 Posts: 1313 Joined: 10/5/2004 From: Cedar Rapids, Iowa Status: offline	RE: Checkboxes and Null Values - 2/5/2008 14:35:36 That seems to have done the trick and should be good for the insert into, just a butload of copying and pasting, but easier than its alternative...thanks! (in reply to rdouglass)

Page: [1]

All Forums >> Web Development >> General Web Development >> Checkboxes and Null Values

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