Re: [Tutor] SQL querying

2018-08-31 Thread Daryl Heppner
Haven't worked with mySQL but MS SQL Server (and any other ODBC connection) should connect importing pyodbc. Good luck! Daryl On Thu, Aug 30, 2018 at 6:26 PM Rafael Knuth wrote: > > Can I do SQL querying in Python? > What packages do I need for that purpose? (specifically for mySQL) Thanks. > __

Re: [Tutor] Need all values from while loop - only receiving one

2018-07-07 Thread Daryl Heppner
if self.dealID is not None: print(self.dealID) else: raise StopIteration Deal(root) On Wed, Jul 4, 2018 at 10:53 AM Alan Gauld via Tutor wrote: > > On 04/07/18 12:08, Daryl Heppner wrote: > > > If you have any suggestions for continued self-learning

Re: [Tutor] Need all values from while loop - only receiving one

2018-07-04 Thread Daryl Heppner
Hi Alan, Extremely valuable guidance - thank you! I will be adapting my script once I get to the office but at a first glance, this appears to be exactly what we need! I'll confirm once I've had a chance to implement this. If you have any suggestions for continued self-learning (books, courses,

Re: [Tutor] Need all values from while loop - only receiving one

2018-07-03 Thread Daryl Heppner
951 640876388.09096 642137720.0 502200.0 64480.0 1 true 1 15.0 rsf/year 36 37 18.0 rsf/year 24 landlord Company1 2.9 rsf landlord Company2 7.5 rsf 186607 2017-06-06 ReimbursableExpenseCam 12.87 net 12.87 RealEstateTax 7.45 net 7.45 On Tue, Jul 3, 2018 at 3:42

[Tutor] Need all values from while loop - only receiving one

2018-07-02 Thread Daryl Heppner
Hi folks, I'm trying to calculate the amount of rent per lease for the life of the lease, by month. The following code provides the correct results except for the monthnum and billper. Monthnum is intended to show the month within the lease and the billper should list each date for rent billing.