[web2py] Re: MongoDB Adapter error in select

Hi Massimo, i did it and get output (test on user_auth table): mongoqry_dict ={'email': 'myem...@gmail.com'} mongofields_dict = SON([('id':1), ('first_name':1), ('last_name': 1), ('email':1), ('password':1), ('registration_key': 1), ('reset_password_key':1), ('registration_id':1) ]) mongo_list_d

[web2py] Combination of fields must be unique

E.g.: For a letter to be unique and identifiable it needs unique(location && name) How do I make a requirement that a combination of fields must be unique? Thanks for all information, Alec Taylor

Re: [web2py] Looking for web2py help - is there a group for recruiting?

What is the project about that you need help with? On Wed, May 9, 2012 at 10:27 PM, David Rager wrote: > We will be looking for some web2py programming help in June - curious > where the best place is to find folks. Is it here? > > Thanks! > -- -- Regards, Bruce Wade http://ca.linkedin.com/

[web2py] Looking for web2py help - is there a group for recruiting?

We will be looking for some web2py programming help in June - curious where the best place is to find folks. Is it here? Thanks!

[web2py] Re: FYI: Trunk on Fluxflex

:-) On Wednesday, 9 May 2012 19:16:36 UTC-5, Kevin Smith wrote: > > Hi All, > > For easy testing, I created a Fluxflex app that pulls from the Trunk based > Nus's web2py-for-fluxflex. > > You can find it here: http://www.fluxflex.com/library/131 > > Best, > > Kevin Smith >

[web2py] Re: SQLFORM.smartgrid : error when setting fields to be displayed as a fields dictionary.

Can you try: form = SQLFORM.grid( db.t_xlsfile, fields=[ db.t_xlsfile.f_xlsfile, ], ), do you get the same error. Can you try web2py trunk as well? On Wednesday, 9 May 2012 19:08:31 UTC-5, François Delpierre wrote:

[web2py] Re: MongoDB Adapter error in select

Should be an easy fix but I need your help. Before line 4711 of dal.py return processor(rows,fields,colnames,False) can you add print rows print fields print colnames what is the output when it fails? On Wednesday, 9 May 2012 05:42:56 UTC-5, Francisco Costa wrote: > > I've enumerated fields a

Re: [web2py] override smartgrid 'add' button

Are you trying to remove the header? I do not think we have an option for that. You can try hide it using jquery. On Wednesday, 9 May 2012 12:26:09 UTC-5, Franzé Jr. wrote: > > About smartgrid, I have a doubt: > > > Name of my table > > > How to disable this when I've generated the smartgrid ?

Re: [web2py] Re: form in layout.html?

On Wednesday, May 9, 2012 6:23:53 PM UTC-4, sebastian wrote: > > the ajax_trap=True fixed the form which nows call search_bar... but > redirect(URL('services', vars={'qry':form.vars.qry})) is rendered inside > the component > > What I'm trying to do, is to include a simple form in the layout

[web2py] FYI: Trunk on Fluxflex

Hi All, For easy testing, I created a Fluxflex app that pulls from the Trunk based Nus's web2py-for-fluxflex. You can find it here: http://www.fluxflex.com/library/131 Best, Kevin Smith

Re: [web2py] The next "welcome"?

No Documentation? On Wed, May 9, 2012 at 7:11 PM, Anthony wrote: > I know we just switched the "welcome" app to Bootstrap, but this new > framework looks very enticing: http://html9responsiveboilerstrapjs.com/. > :-) > > -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . .

[web2py] SQLFORM.smartgrid : error when setting fields to be displayed as a fields dictionary.

Hi, When I try to select the fields to be displayed as follow : form = SQLFORM.smartgrid( db.t_xlsfile, fields=dict( t_xlsfile=[ db.t_xlsfile.f_xlsfile, ], ), I immediately get this strange error :

[web2py] Re: How can I disable autocomplete for specific fields?

I remember that I had a similar problem once and, as a result, I posted this . Maybe it could help you. On Wednesday, 9 May 2012 17:24:02 UTC+1, Cindy Michalowski wrote: > > Hello a

Re: [web2py] Re: form in layout.html?

the ajax_trap=True fixed the form which nows call search_bar... but redirect (URL('services', vars={'qry':form.vars.qry})) is rendered inside the component What I'm trying to do, is to include a simple form in the layout.html that calls a function (as it is now, with the ajax_trap trick), and

[web2py] Re: form in layout.html?

As it is, your component is not an Ajax component, and it is also not set up to trap form submissions via Ajax. So, when you submit the form, it will be submitted to the function of the parent page, not to the search_bar function. If you want the component to be loaded via Ajax, then set ajax=T

[web2py] Re: form in layout.html?

in default.py I have def search_bar(): form = FORM('Search ',INPUT(_name='qry')) if form.process().accepted: response.flash='' if form.vars.qry: redirect(URL('services', vars={'qry':form.vars.qry})) return form and in layout.html {{=LOAD('default','search

Re: [web2py] Why the web2py shell returns different results?

El miércoles, 9 de mayo de 2012 22:48:29 UTC+2, Ricardo Pedroso escribió: > > On Wed, May 9, 2012 at 7:56 PM, sesenmaister > wrote: > > When I use web2py 1.99.7 shell (web2py.exe -S welcome) : > > > unicode('Äpple','utf-8') > > Traceback (most recent call last): > > File "", line 1

Re: [web2py] Re: Reloading modules

Oi Ricardo, Thanks. I add the option to use sql lite and databse keeps data when I restart app engine SDK. And about the module reloading... did you have any problems with it? On Wed, May 9, 2012 at 5:54 PM, Ricardo Pedroso wrote: > On Wed, May 9, 2012 at 8:35 PM, Alex Benfica wrote: >> >> I'm

Re: [web2py] Re: Reloading modules

On Wed, May 9, 2012 at 8:35 PM, Alex Benfica wrote: > > I'm having a seriuos problem having to stop and start Google App Engine SDK > when I want edit modules, otherwise, they are not reloaded. > The problem is that, doing this, I lose the entire database content on GAE > SDK... You can persist t

Re: [web2py] Why the web2py shell returns different results?

On Wed, May 9, 2012 at 7:56 PM, sesenmaister wrote: > When I use web2py 1.99.7 shell  (web2py.exe -S welcome) : > unicode('Äpple','utf-8') > Traceback (most recent call last): >   File "", line 1, in > UnicodeDecodeError: 'utf8' codec can't decode byte 0x8e in position 0: > unexpected code b

[web2py] Re: How to keep and manipulate data in memory with web2py

Very nice. Thank you!

[web2py] Re: Reloading modules

I'm having a seriuos problem having to stop and start Google App Engine SDK when I want edit modules, otherwise, they are not reloaded. The problem is that, doing this, I lose the entire database content on GAE SDK... Is there a way to edit web2py modules and get then reloaded each time I run

[web2py] Re: web2py resources

What about for some of the jquery/JSON specific ideas? What recommendations do you have for those of us who are clueless in those factions? :) On Thursday, May 3, 2012 9:46:35 PM UTC-4, Anthony wrote: > > On Thursday, May 3, 2012 8:20:28 PM UTC-4, newnomad wrote: >> >> For those without any pri

[web2py] Re: How to keep and manipulate data in memory with web2py

Here are the __init__ and __call__ functions for the CacheInRam class: http://code.google.com/p/web2py/source/browse/gluon/cache.py#133 http://code.google.com/p/web2py/source/browse/gluon/cache.py#165 Looks like the both acquire and release locks during the course of the function call, but they d

[web2py] Why the web2py shell returns different results?

When I use web2py 1.99.7 shell (web2py.exe -S welcome) : >>> unicode('Äpple','utf-8') Traceback (most recent call last): File "", line 1, in UnicodeDecodeError: 'utf8' codec can't decode byte 0x8e in position 0: unexpected code byte >>> unicode('Äpple','iso-8859-1') u'\x8epple' When running

[web2py] Re: How to keep and manipulate data in memory with web2py

> Thanks for confirming this. The only kind of updates would be adding new >> key-value pairs. Having confirmed that this sort of updates will be >> consistent on the cache, I am now a little worried about the performance of >> doing so, given the mention of the mutex-lock design of the cache.

[web2py] Re: How to keep and manipulate data in memory with web2py

> > Thanks for confirming this. The only kind of updates would be adding new > key-value pairs. Having confirmed that this sort of updates will be > consistent on the cache, I am now a little worried about the performance of > doing so, given the mention of the mutex-lock design of the cache. >

Re: [web2py] override smartgrid 'add' button

About smartgrid, I have a doubt: Name of my table How to disable this when I've generated the smartgrid ? Thanks in advance, On Tue, May 8, 2012 at 9:12 PM, Derek wrote: > I'd like to change the link 'Add' in the smartgrid to use my 'register' > instead of the default 'new' function. > So,

[web2py] How can I disable autocomplete for specific fields?

Hello all, I've been looking for a way to turn off autocomplete for certain fields. Specifically, I have some fields that use the datepicker. Sometimes the list of autocomplete options blocks the datepicker, making it inconvenient for the user who has to drag the datepicker to a different location

Re: [web2py] Display text in SELECT list

Great Jim, off course like in the represent, pretty good idea... I happy you solve your issue. :) Richard On Wed, May 9, 2012 at 11:09 AM, Jim Steil wrote: > Whoo Hoo! Victory > > Here is the way I got it working: > > In my controller I have the following: > > techSet = db((db.auth_

Re: [web2py] Display text in SELECT list

Whoo Hoo! Victory Here is the way I got it working: In my controller I have the following: techSet = db((db.auth_user.id==db.helpdeskTech.userId) & \ (db.helpdeskTech.helpdeskId==ticket.helpdeskId)) db.ticket.assignedTo.requires = IS_NULL_OR(IS_IN_DB(techSe

Re: [web2py] datatable plugin customization

Ok, I think that web2py admin plugin is for web2py created plugin... For the kind of plugin like Datatables you have to include it by your self like this : @import "{{=URL('static', 'plugin_added/jquery-ui-1.8.17.custom/css/smoothness/jquery-ui-1.8.17.custom_DISPLAY_TWEAKS_RV.css')}}"; @import "

[web2py] Re: How to keep and manipulate data in memory with web2py

> I've looked deeper into this, and in web2py doc: >> http://www.web2py.com/examples/static/epydoc/web2py.gluon.cache.CacheInRam-class.html, >> >> it mentions: This is implemented as global (per process, shared by all >> threads) dictionary. A mutex-lock mechanism avoid conflicts. >> >> Does

Re: [web2py] datatable plugin customization

I installed the plugin directly through the admin interface. I never specified anything regarding interface, so I'm assuming that it's using the default settings. As for jQuery, I haven't had time to learn that yet, which is why I'm relying on the plugins that have been created already. On

Re: [web2py] datatable plugin customization

jQuery UI theme init : $(document).ready( function () { var oTable = $('#example').dataTable( { "sDom": 'R<"H"lfr>t<"F"ip<', "bJQueryUI": true, "sPaginationType": "full_numbers" } ); } ); http://www.datatables.net/release-datatables

Re: [web2py] datatable plugin customization

Think that your css are not loaded, I mean the datatables css... Or you didn't specified that you want to use the jQuery UI theme. But what you want exactly? Truncate switch from web2py allow to trunc long text field at particular length, personnaly I don't truncate... For example you have to mani

[web2py] SQLCustomType str -> list:int not working, 1.99.7

Hi I just updated my web2py from 1.99.4 to 1.99.7 and a select to my db stopped working. The field is a SQLCustomType that has native type "string" and type "list:integer", this worked fine before but now it doesn't decode the value. BaseAdapter parse_value in dal.py if isinstance(value, uni

Re: [web2py] Re: MySQL issues

Yes, that is what it turned out to be. You can refer to the discussion I appended to your initial notice on the BIGINT change. -Jim On 5/8/2012 11:56 PM, Massimo Di Pierro wrote: bigint types for ids perhaps? On Tuesday, 8 May 2012 07:04:35 UTC-5, Jim S wrote: Funny thing - After th

Re: [web2py] datatable plugin customization

OK. Here's the screenshot: shifted datatables On Tuesday, May 8, 2012 5:16:48 PM UTC-4, Richard wrote: > > Good, feel free to ask for DTs... I also have to leave :) > > Richard > > On Tue, May 8, 2012 at 4:43 PM, Larry G. Wapnits

[web2py] login form error when change db to mongodb

Hey Guys. I is newbie developer web with web2py. I change db DAL to db = DAL ('mongodb://localhost:27017/apps') and when i register with auth libary (http://127.0.0.1:8000/welcome/default/user/register?_next=/welcome/default/index) the error

[web2py] Re: set request function forn _env in run @ shell.py

http://code.google.com/p/web2py/issues/detail?id=786 On Tuesday, May 8, 2012 11:59:04 PM UTC-5, Massimo Di Pierro wrote: > > please open a google code issue. I need to test and do not want to forget. > seems reasonable. > > On Tuesday, 8 May 2012 09:09:32 UTC-5, Carlos wrote: >> >> Hi, >> >> Th

[web2py] Re: MongoDB Adapter error in select

Seems DAL alway looks the first "column" if all tables is ID field (after remove _id column from mongo) { "_id" : ObjectId("4de83c816afb62e8367163b1"), "first_name" : "koko", "last_name":"yo", "password" } * * On Wednesday, May 9, 2012 7:42:56 PM UTC+9, Francisco Costa wrote: > > I've

[web2py] Re: MongoDB Adapter error in select

Lets hope Massimo fix that today in trunk On Wednesday, May 9, 2012 12:28:50 PM UTC+1, kokoyo wrote: > > Hi Costa , first im sorry for my wrong post above,It should be a new > post with new question. Actually i have same problem like you, > i did a quick test and have not solved this issue yet,

[web2py] Re: MongoDB Adapter error in select

Hi Costa , first im sorry for my wrong post above,It should be a new post with new question. Actually i have same problem like you, i did a quick test and have not solved this issue yet, here is what i did: set driver to use mongodb in: DB.py : if not request.env.web2py_runtime_gae: ## if

[web2py] Re: MongoDB Adapter error in select

I've enumerated fields and colnames and they are like this: fields: id text integer string colnames: city age _id name I believe they don't match and thats why there's this error: File "/opt/web2py/gluon/dal.py", line 8134, in select return adapter.select(self.query,fields,attributes) File "

[web2py] Re: db.table.insert() inserts a field with id=None but returns an id number

Sorry for the frequent e-mails. I just solved the problem - I forgot to set the type of the ID field to INTEGER PRIMARY KEY AUTOINCREMENT, since Sqliteman does not show it as an option. Best, Omri On Wednesday, May 9, 2012 12:15:31 PM UTC+2, Omri Har-Shemesh wrote: > > Additional information: >

[web2py] Re: db.table.insert() inserts a field with id=None but returns an id number

Additional information: after going through my revision history, it seems that the problem started after I changed the type of a field from "string" (didn't notice I forgot to define it as "integer" and therefore it defaulted to string, even though the default=0 was specified). Then, since sqlit

[web2py] Re: global name 'reponse' is not defined

Hello stefaan, Thanks for the help! I am using Chrome on Window 7, I have tried to install "RSS feed Reader" extension and "Feedy xt", but both still can not display it correctly as show in the book! they still display it as text as below. Tony. On Tuesday, May 8, 2012 10:44:25 AM UTC+1, ste

[web2py] db.table.insert() inserts a field with id=None but returns an id number

Hi, I suddenly came across a weird bug, where when I add a record to a specific table (it doesn't happen with other tables), it inserts the record with the id field == null, but returns a number as if it is the id. Furthermore, the number returned is close to (but not exactly) the number of reco

Re: [web2py] Re: DAL and schema

I made some progress. I was trying to connect to the wrong database. That caused my 'hanging' problem of yesterday. I have succeeded in creating auth_user in a different schema than 'public' using MyDAL but when I try to access it with appadmin it does not know about the schema. The model was in

Re: [web2py] CRUD example from chapter 29 not working

Hallo Alec, Welcome to Web2py! I've just come from the world of Django to web2py in order to leverage > PySimpleSOAP integration for APIs alongside your JSON, XMLRPC and RESTful > XML support. > > So I began going through your docs, noted a few problems (typos and the > like) here and there, but