response.write "0" 000Provider=SQLNCLI11; Locale Identifier=1033; Data Source=host01.bronboek.net,1433; Initial Catalog=boekencentrale; User ID=boek; Password=boek!; **** ***** SELECT C.[Bronboek3ID], C.[Bronboek6ID], C.[ShopcastID], C.[EbookID], C.[Affiliate], C.[CoyType], ISNULL(C.[CoyStatus], 0) AS [CoyStatus], C.[CoyDomain], C.[CoyDomainDev], C.[CoyName], C.[Street], C.[HouseNo], C.[HouseNoAdd], C.[Zipcode], C.[City], C.[Country], C.[Phone], C.[CoyWWW], C.[CoyEmail], C.[CoyCoC], C.[CoyVAT], C.[CoyIBAN], C.[CoyHost], C.[CoyRoot], C.[CoyFolder], C.[CoyDBselect], C.[CoyDBWebCatalog], C.[CoyDBdsn], C.[CoyDBiart], C.[CoyDBuser], C.[CoyDBpass], C.[CoyDBshare], C.[CoyDBbulk], ISNULL(C.[AddBasic], 0) AS [Basic], ISNULL(C.[AddCB], 0) AS [CB], ISNULL(C.[AddCBH], 0) AS [CBH], ISNULL(C.[AddTitelbank], 0) AS [TB], ISNULL(C.[AddEbooks], 0) AS [EB], C.[MetaTitle], C.[MetaKeywords], C.[MetaDescription], C.[MetaAddTitle], C.[MetaAddKeys], C.[MetaAddDesc], C.[Lang], ISNULL(C.[UseSSL], 0) AS [SSL], C.[AnalyticsID], C.[CaptchaSitekey], C.[CaptchaSecret], C.[AddThisID], C.[MailChimpKey], C.[MisterSales], C.[SmartSuppID], C.[ZendeskID], C.[TrustedshopID], C.[SocialFbID], C.[SocialFbApp], C.[SocialFbTabs], C.[SocialTwID], C.[SocialTwHex], C.[SocialYtID], C.[SocialInID], C.[SocialInWidget], CP.[LevAfhalen] AS [DelPick], CP.[LevAfhalenBetaalVooraf] AS [PickPay], CP.[LevPost] AS [DelMail], ISNULL(CP.[LevPostCost], 0) AS [DelMailCost], ISNULL(CP.[LevPostFreeFrom], 0) AS [DelMailFree], CP.[LevOther] AS [DelOther], CP.[LevOtherName] AS [DelOtherName], CP.[LevOtherCost] AS [DelOtherCost], CP.[ShipDefault], ISNULL(CP.[BetIdeal], 0) AS [BetIdeal], CP.[IdealType], CP.[iDealApi], CP.[iDealApiTest], ISNULL(CP.[iDealVars], '') AS [iDealVars], ISNULL(CP.[iDealKey], '') AS [iDealKey], ISNULL(CP.[iDealKeyTest], '') AS [iDealKeyTest], ISNULL(CP.[BetPaypal], 0) AS [BetPaypal], CP.[PayPalApiUser], CP.[PayPalApiPass], ISNULL(CP.[BetProforma], 0) AS [BetProforma], ISNULL(CP.[BetProformaPdf], 0) AS [BetProformaPdf], ISNULL(CP.[BetFactuur], 0) AS [BetFactuur], ISNULL(CP.[BetFactuurPdf], 0) AS [BetFactuurPdf], ISNULL(CP.[BetIncasso], 0) AS [BetIncasso], ISNULL(CP.[BetCard], 0) AS [BetCard], CP.[CardHost], CP.[CardPrefix], CP.[CardMD5], CP.[LIABuser], CP.[LIABpass], CP.[LIABboekenbon], CP.[LIABentertainment], CP.[LIABvvv], ISNULL(CP.[CouponCodes], 0) AS [CouponCodes], CP.[ZipSecret] AS [ZipKey], ISNULL(CP.[CadeauService], 0) AS [CadeauService], ISNULL(CP.[PriorityService], 0) AS PriorityService, ISNULL(CP.[Spaarpunten], 0) AS [Points], CP.[SpaarpuntenValue] AS [PointsValue] FROM [boekencentrale].dbo.[Company] C LEFT OUTER JOIN [boekencentrale].dbo.[CompanyPay] CP ON C.[CoyID] = CP.[CoyID] WHERE C.[CoyID] = 'schrijvertje'