Re: Find a file

2016-07-02 Thread tdsperth
Hi Thanks for your suggestions - I did get it to work with some os.path calls and using flask get files. Cheers Colin -- https://mail.python.org/mailman/listinfo/python-list

Find a file

2016-06-30 Thread tdsperth
Hi All I have a web app that allows me to choose a file - the file name is returned but I need to find the path to the file so I can add it as an attachment to a email. The files I am returning could be in different folders/directories. Thanks for any help. Cheers Colin -- https://mail.pyt

Python Array

2016-03-30 Thread tdsperth
I am creating the following aData = [] # get my data from database for row in rows: aData.append({row["tierid"]:"name":row["tiername"],"description":row["tierdesc"],"option":row["tieroption"],"price":str(row["tierprice"])}}) when I display the output the order the data was entered is not w

pymysql question

2016-02-18 Thread tdsperth
Hi All I have many mysql tables in a conversion I am doing - the table field names are a mixture of lower case and upper case - do I have to covert all to one case to over come Python not finding the field. rows ocur.fetchall() for row in rows: print(row['newname']) #which fails becaus

Re: Python and Word OLE

2016-01-18 Thread tdsperth
On Friday, January 15, 2016 at 2:04:08 PM UTC+8, tdsp...@gmail.com wrote: > Hi All > > I am trying to change the active printer using win32com.client with the > following code > > > > wordapp = win32com.client.Dispatch('Word.Application') > worddoc = wordapp.Documents.Open(mypathfile) > print

Python and Word OLE

2016-01-14 Thread tdsperth
Hi All I am trying to change the active printer using win32com.client with the following code wordapp = win32com.client.Dispatch('Word.Application') worddoc = wordapp.Documents.Open(mypathfile) print(wordapp.ActivePrinter) "\\server\queries" wordapp.ActivePrinter = "\\server\letters" //fails

Re: Data Entry

2016-01-12 Thread tdsperth
On Wednesday, January 13, 2016 at 9:52:17 AM UTC+8, tdsp...@gmail.com wrote: > Hi All > > I have written a small web app using cgi for testing for changes to data from > a python script that does a lot of database updating depending on certain > conditions > > form = cgi.FieldStorage() > cRefN

Data Entry

2016-01-12 Thread tdsperth
Hi All I have written a small web app using cgi for testing for changes to data from a python script that does a lot of database updating depending on certain conditions form = cgi.FieldStorage() cRefNo = form.getvalue('refno') cElectSupp = form.getvalue('electsupp') print('Electrical Sup

Re: Mac Question

2016-01-01 Thread tdsperth
On Friday, January 1, 2016 at 7:13:41 PM UTC+8, Chris Angelico wrote: > On Fri, Jan 1, 2016 at 9:56 PM, wrote: > > Hi All > > > > I am trying to create a directory on a windows drive from my macbook air > > with python but get a permissions error because the windows ntfs drive is > > read only

Mac Question

2016-01-01 Thread tdsperth
Hi All I am trying to create a directory on a windows drive from my macbook air with python but get a permissions error because the windows ntfs drive is read only - does anyone know away to overcome this issue - I have looked for a utility but have yet to find an answer. Regards and Happy New

Re: write data in Excel using python

2015-11-16 Thread tdsperth
On Tuesday, November 17, 2015 at 1:14:56 AM UTC+8, SW wrote: > hi, > I am trying to write Excel file suing output from another software where the > output comes as myturnlist.Show() > > The first part is for the output from the software which is saved in the > clipboard. > > The big middle pa