Re: web facing static text db

Django is an excellent framework. you can use it with sqlite. cheers On Sat, Apr 30, 2016 at 7:17 PM, Gordon Levi wrote: > "Fetchinson ." wrote: > > >Hi folks,go > > >I have a vo ery specific set of requirements for a task and was >

mssql date format

Hi, I am pulling data from an mssql server database and got a date in this format: 733010 please advise what of date is this and how to i convert it to a readable date? i use pyssql to connect to the database and pull data fro the database. thanks in advance, cheers --

Re: pymssql

Thanks heaps for your comments, manage to get it work using the as_dict` parameter of the `cursor` object, cus=conn.cursor(as_dict=True) cus.execute("SELECT budget_code,budget_description,rate_type FROM glbud") for row in cus:

Re: pymssql

te_type) the above code it doesn't print out anything and it doesn't give me any error. any assistance will be very much appreciated. On Fri, Sep 9, 2016 at 1:38 PM, Lawrence D’Oliveiro <lawrenced...@gmail.com> wrote: > On Friday, September 9, 2016 at 12:48:50 PM UTC+12, sum abiut wrote

pymssql

Hi, i have used pymssql to connet to windows database but i want to be able iterate and only print out some specific fields. here is what i did conn=pymssql.connect(server,username,password,database) cus=conn.cursor() cus.execute("SELECT * FROM glbud ") for row in cus:

Julian date to calendar date conversion

Hi, how to convert julian date to a calander date cheers -- https://mail.python.org/mailman/listinfo/python-list

Re: Julian date to calendar date conversion

Thanks On Tue, Sep 13, 2016 at 12:37 PM, MRAB <pyt...@mrabarnett.plus.com> wrote: > On 2016-09-13 02:12, sum abiut wrote: > >> Hi, >> how to convert julian date to a calander date >> >> Have a look at the jdcal module on PyPI: > > https:/

Re: mssql date format

t datetime >>> datetime.datetime.fromordinal(733010) >>> >> datetime.datetime(2007, 11, 30, 0, 0) On Mon, Sep 12, 2016 at 12:15 PM, MRAB <pyt...@mrabarnett.plus.com> wrote: > On 2016-09-12 01:37, sum abiut wrote: > >> Hi, >> I am pulling data from

Re: SQLObject 3.3.0

Thanks for the info On Mon, May 8, 2017 at 1:25 AM, Oleg Broytman wrote: > Hello! > > I'm pleased to announce version 3.3.0, the first stable release of branch > 3.3 of SQLObject. > > > What's new in SQLObject > === > > Features > > > * Support for

converting Julian date to normal date

i am using python,and django as my web framework. I use sqlalchemy to connect to MSSQL data that is running Epicor database. Epicor is using julian * date. How to you convert julian date to normal date* *cheers,* -- https://mail.python.org/mailman/listinfo/python-list

Re: jilian to Gregorian date conversion error

did it like this rate.columns.date_applied.between(covert,convert1) where convert and convert1 are the range of date cheers, On Thu, Apr 26, 2018 at 4:47 AM, Dennis Lee Bieber <wlfr...@ix.netcom.com> wrote: > On Wed, 25 Apr 2018 13:43:15 +1100, sum abiut <suab...@gmail.com&

Re: jilian to Gregorian date conversion error

. appreciate any assistances. cheers, On Sun, Apr 29, 2018 at 2:39 AM, Dennis Lee Bieber <wlfr...@ix.netcom.com> wrote: > On Thu, 26 Apr 2018 15:43:43 +1100, sum abiut <suab...@gmail.com> > declaimed > the following: > > >ok so i have fixed that using th

Re: julian 0.14 library

: > > On Wed, Apr 4, 2018 at 12:24 PM, sum abiut <suab...@gmail.com> wrote: > >> Hi, > >> Has anyone try this https://pypi.python.org/pypi/julian/0.14 > >> > >> i got this error trying to import julian > >> > >>>>> import julian &

jilian to Gregorian date conversion error

Hi, i get the error message: an integer is required when i am try to convert from julian date to Gregorian date in my view.py, after i have query the db i want to convert the applied date from julian date to Gregorian date but i got the above error,

Re: jilian to Gregorian date conversion error

Thanks date example is 736788 in julian On Wed, Apr 25, 2018 at 12:34 PM, Dennis Lee Bieber wrote: > On Wed, 25 Apr 2018 00:55:39 +0100, MRAB > declaimed the following: > > > >Also, the integer is interpreted as a "proleptic Gregorian

julian 0.14 library

Hi, Has anyone try this https://pypi.python.org/pypi/julian/0.14 i got this error trying to import julian >>> import julian Traceback (most recent call last): File "", line 1, in File "/usr/local/lib/python2.7/dist-packages/julian/__init__.py", line 1, in from julian.julian import

Re: Bitstream -- Binary Data for Humans

Thanks On 6/03/2018 7:13 AM, "Sébastien Boisgérault" < sebastien.boisgera...@gmail.com> wrote: Hi everyone, I have released bitstream, a Python library to manage binary data (at the byte or bit level), hopefully without the pain that this kind of thing usually entails :) If you have struggled

How to print out html tags excluding the attributes

I want to use regular expression to print out the HTML tags excluding the attributes. for example: import re html = 'Hitest test' tags = re.findall(r'<[^>]+>', html) for a in tags: print(a) the output is : But I just want the tag, not the attributes --