[web2py] Re: Support for MS Access?

2014-11-24 Thread ksotiris
it and is working ok... But never knows ... Can any admin of the web2py to check and add these changes to the source of the web2py ? Τη Τετάρτη, 19 Νοεμβρίου 2014 2:24:16 μ.μ. UTC+2, ο χρήστης Leonel Câmara έγραψε: > > Good job ksotiris, maybe you could contribute this adapter and

[web2py] Re: Support for MS Access?

2014-11-19 Thread ksotiris
Finally, everything is working correctly. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Goo

[web2py] Re: Support for MS Access?

2014-11-06 Thread ksotiris
I have write an adapter making this addition in dal.py line 116: 'msaccess://DRIVER={Microsoft Access Driver(*.mdb)};UID=user;PWD=pass; DBQ=database line 371: try: import odbtp DRIVERS.append('MSACCESS(odbtp)') LOGGER.warning('Msaccess with odbtp support is experimen

[web2py] Re: Support for MS Access?

2014-11-05 Thread ksotiris
thank you Leonel ...!!! , it 's ok now. With the console all work fine now. I have"Internal Server Error" with wsgi + msaccess adapter. I will make some tries and will come back. Τη Τρίτη, 4 Νοεμβρίου 2014 1:12:06 μ.μ. UTC+2, ο χρήστης Leonel Câmara έγραψε: > > No it's not a dict if you do it

[web2py] Re: Support for MS Access?

2014-11-04 Thread ksotiris
;SERVER=(?P[\d\.]+);DBQ=(?P[^;]+);UID=(?P[^;]+);PWD=(?P.+)' ruri='DRIVER={Microsoft Access Driver (*.mdb)};SERVER=192.168.1.182; DBQ=c:\\v3.mdb;UID=admin;PWD=' m = REGEX_URI.match(ruri) Τη Δευτέρα, 3 Νοεμβρίου 2014 6:33:47 μ.μ. UTC+2, ο χρήστης Leonel Câmara

Re: [web2py] Re: Support for MS Access?

2014-11-03 Thread ksotiris
Can anybody help me with the REGEX_URI ? I use the ruri='DRIVER={Microsoft Access Driver (*.mdb)};SERVER=192.168.1.182;DBQ=c:\\v3.mdb;UID=admin;PWD=' m = self.REGEX_URI.match(ruri) and i would like to get driver=m.group(driver) # => {Microsoft

Re: [web2py] Re: Support for MS Access?

2014-10-29 Thread ksotiris
*I think we found the solution for msaccess...!!! yes, is the odbtp + python-odbtp* *STEP 1: odbtp * download odbtp-1.1.4.tar.gz >sudo tar xzf odbtp-1.1.4.tar.gz >cd odbtp-1.1.4 SOS !! for Building ODBTP client library on a 64-bit OS please read odbtp-1.1.4/README.64bitOS >sudo ./configure >su

[web2py] Re: Support for MS Access?

2014-10-22 Thread ksotiris
Τη Δευτέρα, 20 Οκτωβρίου 2014 8:56:24 μ.μ. UTC+3, ο χρήστης Leonel Câmara έγραψε: > > Either way, just convert your access database to anything else, it's bound > to be better for your sanity. Seriously, any time spent migrating is better > spent than making access work with web2py. > > yes I k

[web2py] Re: Support for MS Access?

2014-10-20 Thread ksotiris
I found 2 errors: when using db.(db.table).select() i get the following sql query : sql=SELECT .,., ...FROM WHERE . IS NOT NULL : the primary key, i think that's why " .. is not null" errors : db.executesql crashes the same as the db.(db.table).select() when using the same sql query. If

[web2py] Re: Support for MS Access?

2014-10-19 Thread ksotiris
finally the solution is in this site: http://linuxapuntes.blogspot.gr/2013/01/ms-access-desde-ubuntu-con-python-and.html step 1 (install lib) : >> sudo apt-get install mdbtools libmdbodbc1 pyodbc step 2 create a template file and use the odbcinst -i -d -f templatefile to add this to dobcinst.i

[web2py] Re: Conditional deletes (ondelete etc) in sqlform.grid

2014-02-20 Thread ksotiris
>deletable = False >if 'edit' in request.args: >record = db[table](request.args[-1]) >if some condition of record: >deletable = True >grid = SQLFORM.grid(db[table], deletable = deletable) Plus to above Idea: We have smartgrid with "orders" link table "products_in_order" and we wa

Re: [web2py] Bunch/Batch/Bulk insert Re-use db.define_table field definition in SQLFORM.factory() ?

2014-02-15 Thread ksotiris
Hello web2py-users, I am new to web2py framework. I have a question about the followings: > @Steve it exactly what I have in mind, except in my case the form has to > be generic for many differents tables, but if you only one table to bunch > insert, that way it works fine... > > Notice, if

Re: [web2py] Bunch/Batch/Bulk insert Re-use db.define_table field definition in SQLFORM.factory() ?

2014-02-15 Thread ksotiris
Hello web2py-users, I am new to web2py framework. I have a question about the followings: Notice, if you create more inputs then the number your users will need (not > 3 records for instance) you get in trouble if you have not null requires or > IS_IN_DB or other validators)... So I use an ot