[web2py:15612] Re: An example of MSSQL database connection and installing modules to support it

2009-01-30 Thread ondrejs
The error message seems to indicate that SQLDriverConnectW function is not present in your setup. Would you please try issuing pyodbc connect from python itself? Something like this: >>> import pyodbc >>> pyodbc.connect(unicode("Driver={SQL >>> Server};Server=Localhost;uid=sa;pwd=pwds")) On

[web2py:15613] Re: db operations seems slow in a web2py on GAE

2009-01-30 Thread Iceberg
Thank Robin for the insight. I guess you are saying: Although writing only one record is somewhat slow in GAE, writing multiple (dozens/ hundreds/thousands/or even more) records can be finished in similar time due to the scalability of GAE, if using the batch get/put/delete properly. That is cool.

[web2py:15614] Re: Using Try Except to detect a specific MS SQL server error and flash a custom error msg

2009-01-30 Thread NetHead
Adding that import statement at the top of my controller did it! The IntegrityError: is now being explicitly caught, and when I purposely threw in a "division by 0" assignment in, your ticketing sytem then caught that as a DivisionByZero: error. Kewl! Thanks again! Todd B. On Jan 29, 8:23 pm

[web2py:15615] Re: An example of MSSQL database connection and installing modules to support it

2009-01-30 Thread Karl Gingerich
H, you are right ondrej, I get: Traceback (most recent call last): File "", line 1, in pyodbc.Error: ('0', '[0] [iODBC][Driver Manager]dlopen({SQL Server}, 6): image not found (0) (SQLDriverConnectW)') in python also. Any suggestions Karl :v) 2009/1/30 ondrejs <.s...@gmail.co

[web2py:15616] gluon.utils

2009-01-30 Thread Robin B
t2 used to have t2.is_gae, I could not find anything like that in utils.py It will be important for example recaptcha: httpresp = urllib2.urlopen (request) on GAE you must use urlfetch. how should we flag GAE in a standard way? maybe request.env.web2py_runtime ? Robin --~--~-~--~~

[web2py:15617] syntax error in gluon/contrib/gql.py

2009-01-30 Thread angleto
--- gluon/contrib/gql.py(revision 682) +++ gluon/contrib/gql.py(working copy) @@ -489,7 +489,7 @@ def count(self): self._db['_lastsql']='count' return len(self.select()) -def delete(self) +def delete(self): self._db['_lastsql']='delete'

[web2py:15618] Re: db operations seems slow in a web2py on GAE

2009-01-30 Thread Robin B
The batch get,put,delete will be added for bulk performance. We have discussed adding db table namespaces based on application names on the list, and it will also be added. http://groups.google.com/group/web2py/browse_thread/thread/57fd68115975382f/6205b3d0f8e0b913?hl=en&lnk=gst&q=dal+namespace#

[web2py:15619] Re: gluon.utils

2009-01-30 Thread Fran
On Jan 30, 3:29 pm, Robin B wrote: > t2 used to have t2.is_gae, I could not find anything like that in > utils.py tools.py (note the new name) has this setting already: mail.settings.server='gae' However that assumes you're using Mail which should be separable from Auth/Crud. I agree having a m

[web2py:15620] "deletable=True" not working in SQLFORM

2009-01-30 Thread NetHead
Hello again! Say... has anyone had any problems getting the "deletable" function to work properly with SQL FORMs?My database is MS SQL Server, btw. Here's my code: items_form=SQLFORM(db_bosswalk.BW_items, record=items_records[0], deletable=True, showid=False, delete_label='Delete this item

[web2py:15621] Re: synchronisation

2009-01-30 Thread mdipierro
Sorry, there is no short answer to this one. There was a xml-rpc applicance but I cannot find it. I thought was posted on appliances. I will look for it. Massimo On Jan 29, 7:36 pm, INeedHelp wrote: > i am currently working on synchronisation. > I have 2 or more "projectA" in different comput

[web2py:15622] Re: syntax error in gluon/contrib/gql.py

2009-01-30 Thread mdipierro
thanks. fixed in trunk On Jan 30, 9:32 am, angleto wrote: > --- gluon/contrib/gql.py        (revision 682) > +++ gluon/contrib/gql.py        (working copy) > @@ -489,7 +489,7 @@ >      def count(self): >          self._db['_lastsql']='count' >          return len(self.select()) > -    def delete

[web2py:15623] Re: gluon.utils

2009-01-30 Thread mdipierro
make a proposal. It is not easy to auto-detect gae since you may have the google modules without being on gae On Jan 30, 10:35 am, Fran wrote: > On Jan 30, 3:29 pm, Robin B wrote: > > > t2 used to have t2.is_gae, I could not find anything like that in > > utils.py > > tools.py (note the new nam

[web2py:15624] Re: synchronisation

2009-01-30 Thread mdipierro
Correction... it is where I thought it was: http://mdp.cti.depaul.edu/appliances/default/show/18 Mind that this is an example. May need work and customization. Make sure your tables have UUIDs Massimo On Jan 30, 1:11 pm, mdipierro wrote: > Sorry, there is no short answer to this one. There wa

[web2py:15625] Re: gluon.utils

2009-01-30 Thread Robin B
web2py.urlfetch, works on every platform :) Robin On Jan 30, 1:13 pm, mdipierro wrote: > make a proposal. It is not easy to auto-detect gae since you may have > the google modules without being on gae > > On Jan 30, 10:35 am, Fran wrote: > > > On Jan 30, 3:29 pm, Robin B wrote: > > > > t2 use

[web2py:15626] Re: gluon.utils

2009-01-30 Thread Robin B
As far as detection, if your application passes though gaehandler.py, then you can be certain you are on GAE. Robin On Jan 30, 1:13 pm, mdipierro wrote: > make a proposal. It is not easy to auto-detect gae since you may have > the google modules without being on gae > > On Jan 30, 10:35 am, Fra

[web2py:15627] Re: gluon.utils

2009-01-30 Thread mdipierro
t2 has a urlopen that works cross-platform. we can move it in gluon.tools Massimo On Jan 30, 1:20 pm, Robin B wrote: > web2py.urlfetch, works on every platform :) > > Robin > > On Jan 30, 1:13 pm, mdipierro wrote: > > > make a proposal. It is not easy to auto-detect gae since you may have > >

[web2py:15628] Re: "deletable=True" not working in SQLFORM

2009-01-30 Thread NetHead
NOTE to everyone: I did a little experiment by coding a test controller using the basic SQLFORM example from page 169 of Massimo's book, and picked a different table in my database that had no direct relationships to any of the other tables. Delete's using the check box now worked. So again..

[web2py:15629] Re: "deletable=True" not working in SQLFORM

2009-01-30 Thread NetHead
Okay one last bit of additional experimentation info to share here: I coded two simple hardcoded functions and called them explicitly from the browser to see if my delete problem was related specifically to the SQLFORM feature, or to Web2py in general. It appears that my problem is rooted di

[web2py:15630] I am looking for an html/css/photoshop wizard to redo the web page layout.

2009-01-30 Thread mdipierro
I am looking for an html/css/photshop wizard to redo the web page layout. Something that looks polished like http://merbivore.com/ http://jquery.com/ Also the content needs to be reorganized. Your work will be acknowledged. You have two weeks. Massimo --~--~-~--~~~--

[web2py:15631] 1.56rc2 is in trunk

2009-01-30 Thread mdipierro
Please try create a new empty app. The scaffolding db.py module contains instructions for Mail, Auth, Crud. Please try it. report bug. send me comments. Is this confusing? Is this helpful? Does it belong there or should it only be in docs? Notice the new generic.html and image preview with SQLF