Exactly. So, you have 4 columns that are for each certification. Those belong in their own table that may look like this:
profileID (FK) certID (FK) certExp certCompanu certImage certOnFile You'd have another table of cert types: certID (PK) certName And then another table for the profiles profileID (PK) and anything pertaining to the profile itself, like contact info etc. -----Original Message----- From: Adam Bourg [mailto:[email protected]] Sent: Monday, January 24, 2011 1:34 PM To: cf-talk Subject: Re: Coldfusion8: Multiple checks within a CFIF for a valid date Yes sir, so you're saying create 3 tables? This is what the total table looks like (The, exp, company, image and onFile follow the same pattern for all) profileID, -- Bit cprAdultExp, -- Date cprAdultcompany, -- NvarChar cprAdultImage, -- Nvarchar cprAdultOnFile,Boolean cprInfantChildExp, cprInfantChildcompany, cprInfantChildImage, cprInfantChildOnFile, cprFPRExp, cprFPRcompany, cprFPRImage, cprFPROnFile, aedExp, aedcompany, aedImage, aedOnFile, firstAidExp, firstAidcompany, firstAidImage, firstAidOnFile, emtExp, emtcompany, emtImage, emtOnFile, waterSafetyInstructionExp, waterSafetyInstructioncompany, waterSafetyInstructionImage, waterSafetyInstructionOnFile, bloodPathogensExp, bloodPathogenscompany, bloodPathogensImage, bloodPathogensOnFile, oxygenAdminExp, oxygenAdmincompany, oxygenAdminImage, oxygenAdminOnFile, lifegaurdingExp, lifegaurdingcompany, lifegaurdingImage, lifegaurdingOnFile, wildernessResponderExp, wildernessResponderCompany, wildernessResponderImage, wildernessResponderOnFile, certNotes -- nvarchar(4000) >One more note ... > >Do you have any control over table schemas? If you have to filter on >that many columns, and every row has all those columns, then the table >really needs to be broken into three, one with the profiles, one with >the certifications, and one joining the two with the expiration date. >That would make the data retrieval really easy. > >That would really be your best bet. > >--- Ben--> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
