FindNL Business Test Thing

INSERT INTO tbFindNLdirectory (`iID`, `iBusinessType`, `sContactFullName`, `sContactEmailAddress`, `sContactCompanyPosition`, `sCompanyBusinessName`, `sCompanyWebsiteAddress`, `sCompanyPhoneNumber`, `sCompanyFaxNumber`, `sCompanyLocation`, `sCompanyProvince`, `sCompanyCity`, `iCompanyStreetNumber`, `sCompanyStreetAddress`, `sCompanyPostalCode`, `sCompanyLatitude`, `sCompanyLongitude`, `sCompanyHoursOfOperationMonday`, `sCompanyHoursOfOperationTuesday`, `sCompanyHoursOfOperationWednesday`, `sCompanyHoursOfOperationThursday`, `sCompanyHoursOfOperationFriday`, `sCompanyHoursOfOperationSaturday`, `sCompanyHoursOfOperationSunday`, `sCompanyWheelchairAccessible`, `sPaymentTypeVisa`, `sPaymentTypeMastercard`, `sPaymentTypeAmex`, `sPaymentTypeDiners`, `sPaymentTypePaypal`, `sCompanyPaymentTypesOther`, `sCompanyAcceptDebitCards`, `sCompanyAtmOnSite`, `iDiscountAmount`, `sDiscountItem`, `sDiscountRestrictions`, `sDiscountDescription`, `sUpgradePhotoOne`, `sUpgradePhotoTwo`, `sUpgradePhotoThree`, `sUpgradePhotoFour`, `sUpgradePhotoFive`, `sDiscount1000words, `sDiscountBacklink`, `sDiscountInternalLink`, `sPaymentSetupFee`, `sPaymentYearlyFee`, `sPaymentLifetimeListing`, `sDiscountEmployee`, `iDiscountAmountSetupFee`, `iDiscountAmountYearlyFee`, `iDiscountNumberOfYears`, `sDiscountStartBillingDate`, `sDiscountStartBillingAmount`, `sPaymentMethodCash`, `sPaymentMethodCreditCard`, `sPaymentMethodCheck`, `sPaymentMethodPaypal`, `sPaymentMethodEmailMoneyTransfer`, `sPaymentDetails`) VALUES ('5', '5', 'a', 'a', 'a', 'a', 'a', '(709) 257-2634', 'a', 'a', 'a', 'a', 'Alberta', '142.334', '-43.655', '9am - 5pm', '9am - 5pm', '9am - 5pm', '9am - 5pm', '9am - 5pm', 'a', 'a', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'a', 'yes', 'yes', '$142.55', 'Seagulls', 'Do not eat them', 'a', 'sl_solutions_body_text1.gif', 'wmconsultinga_3.sflb.ashx.jpg', 'Swoosh_Only_GIF.gif', 'swoosh.gif', 'logo-design-example-swoosh.gif', 'a', 'http://www.abc.com', 'http://www.online-onslaught.com', '$4500.33', '$5,000/month', 'yes', 'yes', 'Deborah Bourden', '$4500.33', '$5,000/month', '30', 'a', 'strStepSixAmountToStartBilling', 'yes', 'yes', 'please let this work. One misplaced $ has been screwing this up') FindNL Business Test Thing

Business Name	Add a New Business



The business has been added to the FindNL directory. Whoo-hoo. Now comes the stuff like nl2br and validation of that form via javascript. Just takes a bit of time.