Re: Report with data from 2 unrelated siblings
Thanks Ted, Tamar's article doesn't seem to help, her example has one record per unrelated sibling whereas I can have none or many. Maybe I'll tackle this on Monday when the brain is fresh. Frank. Frank Cazabon On 09/11/2018 11:49 AM, Ted Roche wrote: I know you can do this in SQL, but it's Friday and I'm too tired to work it out again :) Tamar is a great authority on SQL (she wrote a book on it!) and I know she wrote several articles on unrelated siblings. Here's one: http://www.tomorrowssolutionsllc.com/ConferenceSessions/Making%20the%20Most%20of%20SQL-SELECT.pdf and you might poke around on her website for others. On Fri, Nov 9, 2018 at 10:27 AM Frank Cazabon wrote: Hi, CREATE CURSOR Merchants ; (MerchantID i,; MerchantName c(10)) INSERT INTO Merchants (MerchantID, MerchantName) VALUES (1, "Freddie") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (2, "Brian") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (3, "Roger") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (4, "John") CREATE CURSOR Emails; (EmailID i,; MerchantID i,; Email c(30)) INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (1, 2, "br...@queen.com") INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (2, 2, "br...@gmail.com") INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (3, 4, "j...@queen.com") CREATE CURSOR Templates ; (TemplateID i,; TemplateName c(10)) INSERT INTO Templates (TemplateID, TemplateName) VALUES (1, "template 1") INSERT INTO Templates (TemplateID, TemplateName) VALUES (2, "template 2") CREATE CURSOR MerchantTemplates; (MerchantTemplateID i,; MerchantID i,; TemplateID i) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (1, 2, 1) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (2, 2, 2) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (3, 4, 1) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (4, 4, 2) I need to create a report like this (the email and template columns must be side by side): *Merchant** * *Email** * *Template* Freddie Brian br...@queen.com Template 1 Brian br...@gmail.com Template 2 Roger John j...@queen.com Template 1 John Template 2 This was my attempt to build the data, but I get doubling up: SELECT MerchantName; ,Email; ,TemplateName ; FROM Merchants ; LEFT JOIN Emails ON Merchants.MerchantID = Emails.MerchantID; LEFT JOIN MerchantTemplates ON Merchants.MerchantID = MerchantTemplates.MerchantID; LEFT JOIN Templates ON MerchantTemplates.TemplateId = Templates.TemplateID Can I do this in SQL or do I need to build my cursor up procedurally? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/5a4f8b95-f78c-b498-102f-d1b3a3447...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Report with data from 2 unrelated siblings
No, that won't work. Frank. Frank Cazabon On 09/11/2018 12:21 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: This was my attempt to build the data, but I get doubling up: Will putting a DISTINCT in your SELECT fix that? [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fb9c2d47-be3f-050a-e869-2f0ede592...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
On Thu, Nov 8, 2018 at 10:32 PM wrote: > VFP9SP2 > > Strange...code that has been working for years using my > mbss.b...@gmail.com as the sender now doesn't want to work. Good ol' > Error 1429. See screenshot: https://www.screencast.com/t/Bxe0x4CX You (almost) always get a 1429 from an OLE object. "The Transport failed to connect to the server" is your error. Google that for clues. I don't see any details on which object you are using to script the mail, (although I'm amused by the array "crap") but I'd hazard a guess the object is trying to connect to an outdated server URI, or the server is requiring a higher level of secure connection (TLS 1.x, TLS 2.x, etc.) than your server offers. Or your network has an issue finding the server or your DNS is broken, etc. What have you tried to debug this? Can you code a simple email to the server from the command window and get the same error? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4vyqfwrtlys5szhze5reebnyg0x2pksnx4-oaijn7a...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
It was when I used it yesterday. John John Weller 01380 723235 07976 393631 I know GMail had changed policy awhile back (2 yrs ago?) whereby I had to set it to use "Less secure apps" option to enable this emailing. Has it changed yet again? I saw John and Fred replied to this saying it works for them. John and Fred -- is yours still working without issue? Koen -- what alternative do you suggest? Thanks, --Michael ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01c701d47853$b24e4680$16ead380$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
CDO and Gmail is still working for me. Fred On Fri, Nov 9, 2018 at 9:17 AM wrote: > On 2018-11-09 02:51, Koen Piller wrote: > > Gmail has changed its policy. Advise you to switch to an other > > mailprovider > > Koen > > > Hi Koen, > > I know GMail had changed policy awhile back (2 yrs ago?) whereby I had > to set it to use "Less secure apps" option to enable this emailing. Has > it changed yet again? I saw John and Fred replied to this saying it > works for them. John and Fred -- is yours still working without issue? > > Koen -- what alternative do you suggest? > > Thanks, > --Michael > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksryxua+sn3kghrsrydxfrznis5zpxwhuiqjxojo2uj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Report with data from 2 unrelated siblings
This was my attempt to build the data, but I get doubling up: Will putting a DISTINCT in your SELECT fix that? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/6cc0ec5d4f2ef1abdc5b8d69cbe0b...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
On 2018-11-09 02:51, Koen Piller wrote: Gmail has changed its policy. Advise you to switch to an other mailprovider Koen Hi Koen, I know GMail had changed policy awhile back (2 yrs ago?) whereby I had to set it to use "Less secure apps" option to enable this emailing. Has it changed yet again? I saw John and Fred replied to this saying it works for them. John and Fred -- is yours still working without issue? Koen -- what alternative do you suggest? Thanks, --Michael ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/8f08758742264cb073eab8524066c...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
Me too, Send out about 700-800 a day with CDO and Gmail accounts. No problems. Fred On Fri, Nov 9, 2018 at 3:17 AM John Weller wrote: > I also use CDO and Gmail for unattended emails, so far without a problem. > What alternative provider do you suggest? > > John > > John Weller > 01380 723235 > 07976 393631 > > -Original Message- > From: ProfoxTech On Behalf Of Koen Piller > Sent: 09 November 2018 07:52 > To: profoxt...@leafe.com > Subject: Re: CDO Email issues all of the sudden? VFP9SP2 app running for > years without issue > > Gmail has changed its policy. Advise you to switch to an other mailprovider > Koen > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksrq7dkdfpraxcjn4qb6y-+djxwqyev-48wvkfe5wp9...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Report with data from 2 unrelated siblings
I know you can do this in SQL, but it's Friday and I'm too tired to work it out again :) Tamar is a great authority on SQL (she wrote a book on it!) and I know she wrote several articles on unrelated siblings. Here's one: http://www.tomorrowssolutionsllc.com/ConferenceSessions/Making%20the%20Most%20of%20SQL-SELECT.pdf and you might poke around on her website for others. On Fri, Nov 9, 2018 at 10:27 AM Frank Cazabon wrote: > Hi, > > CREATE CURSOR Merchants ; > (MerchantID i,; > MerchantName c(10)) > > INSERT INTO Merchants (MerchantID, MerchantName) VALUES (1, "Freddie") > INSERT INTO Merchants (MerchantID, MerchantName) VALUES (2, "Brian") > INSERT INTO Merchants (MerchantID, MerchantName) VALUES (3, "Roger") > INSERT INTO Merchants (MerchantID, MerchantName) VALUES (4, "John") > > CREATE CURSOR Emails; > (EmailID i,; > MerchantID i,; > Email c(30)) > > INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (1, 2, > "br...@queen.com") > INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (2, 2, > "br...@gmail.com") > INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (3, 4, > "j...@queen.com") > > CREATE CURSOR Templates ; > (TemplateID i,; > TemplateName c(10)) > > INSERT INTO Templates (TemplateID, TemplateName) VALUES (1, "template 1") > INSERT INTO Templates (TemplateID, TemplateName) VALUES (2, "template 2") > > CREATE CURSOR MerchantTemplates; > (MerchantTemplateID i,; > MerchantID i,; > TemplateID i) > > INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, > templateID) VALUES (1, 2, 1) > INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, > templateID) VALUES (2, 2, 2) > INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, > templateID) VALUES (3, 4, 1) > INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, > templateID) VALUES (4, 4, 2) > > I need to create a report like this (the email and template columns must > be side by side): > *Merchant** > * *Email** > * *Template* > Freddie > > > Brian > br...@queen.com > Template 1 > Brian > br...@gmail.com > Template 2 > Roger > > > John > j...@queen.com > Template 1 > John > > Template 2 > > This was my attempt to build the data, but I get doubling up: > > SELECT MerchantName; > ,Email; > ,TemplateName ; > FROM Merchants ; > LEFT JOIN Emails ON Merchants.MerchantID = Emails.MerchantID; > LEFT JOIN MerchantTemplates ON Merchants.MerchantID = > MerchantTemplates.MerchantID; > LEFT JOIN Templates ON MerchantTemplates.TemplateId = > Templates.TemplateID > > Can I do this in SQL or do I need to build my cursor up procedurally? > > -- > > Frank. > > Frank Cazabon > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4sipnyte4g+ckfmcmetvlqgshg99m3xdv+xjckxp3m...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Report with data from 2 unrelated siblings
Hi, CREATE CURSOR Merchants ; (MerchantID i,; MerchantName c(10)) INSERT INTO Merchants (MerchantID, MerchantName) VALUES (1, "Freddie") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (2, "Brian") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (3, "Roger") INSERT INTO Merchants (MerchantID, MerchantName) VALUES (4, "John") CREATE CURSOR Emails; (EmailID i,; MerchantID i,; Email c(30)) INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (1, 2, "br...@queen.com") INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (2, 2, "br...@gmail.com") INSERT INTO Emails (EmailId, MerchantID, Email) VALUES (3, 4, "j...@queen.com") CREATE CURSOR Templates ; (TemplateID i,; TemplateName c(10)) INSERT INTO Templates (TemplateID, TemplateName) VALUES (1, "template 1") INSERT INTO Templates (TemplateID, TemplateName) VALUES (2, "template 2") CREATE CURSOR MerchantTemplates; (MerchantTemplateID i,; MerchantID i,; TemplateID i) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (1, 2, 1) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (2, 2, 2) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (3, 4, 1) INSERT INTO MerchantTemplates (MerchantTemplateID, MerchantID, templateID) VALUES (4, 4, 2) I need to create a report like this (the email and template columns must be side by side): *Merchant** * *Email** * *Template* Freddie Brian br...@queen.com Template 1 Brian br...@gmail.com Template 2 Roger John j...@queen.com Template 1 John Template 2 This was my attempt to build the data, but I get doubling up: SELECT MerchantName; ,Email; ,TemplateName ; FROM Merchants ; LEFT JOIN Emails ON Merchants.MerchantID = Emails.MerchantID; LEFT JOIN MerchantTemplates ON Merchants.MerchantID = MerchantTemplates.MerchantID; LEFT JOIN Templates ON MerchantTemplates.TemplateId = Templates.TemplateID Can I do this in SQL or do I need to build my cursor up procedurally? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e4283eeb-cf5d-5eeb-64b3-ade899753...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue
I also use CDO and Gmail for unattended emails, so far without a problem. What alternative provider do you suggest? John John Weller 01380 723235 07976 393631 -Original Message- From: ProfoxTech On Behalf Of Koen Piller Sent: 09 November 2018 07:52 To: profoxt...@leafe.com Subject: Re: CDO Email issues all of the sudden? VFP9SP2 app running for years without issue Gmail has changed its policy. Advise you to switch to an other mailprovider Koen ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/004601d47815$5b5fd340$121f79c0$@johnweller.co.uk ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.