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

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

[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

[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] 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: 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: 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: 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

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

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: 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] 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

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

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

[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] 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

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

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

[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

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 "

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] 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_

[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] 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] 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.

[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

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] 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: 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: How to keep and manipulate data in memory with web2py

Very nice. Thank you!

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

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] 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] 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

[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

[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

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: 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

[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 :

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] 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] 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

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 ?

[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

[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: 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] 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!

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] 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

[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