[web2py] Re: jQuery UI tabs selected tab.

2011-10-22 Thread annet
Hi Richard, Thanks for your reply. I tried in web2py_ajax.html: script type=text/javascript $(function(){ // Tabs $('#tabs').tabs(); $(.selector).tabs({selected: 3}); }); /script (for convenience I used the constant 3) ... and in the view I tried: script type=text/javascript

[web2py] CouchDB NoSQLAdapter.represent for datetime

2011-10-22 Thread H.C. v. Stockhausen
Hi I am just testing the CouchDB Adapter and it fails when registering a new user. I tired both w2py's default auth and janrain. The problem appears to be the time_stamp field. - w2py Version 1.99.2 (2011-09-26 06:55:33) stable - driver CouchDB-0.8-py2.6.egg Traceback File

[web2py] dal aggregation sum fields None

2011-10-22 Thread apple
I am summing some data using the DAL: cash_price = db.orderline.cash_price.sum() lines = db(db.orderline.order_ == id).select(cash_price).first() However if there are no lines then lines[cash_price] is None. So I added: lines[cash_price]=lines[cash_price] or 0 But this does not

[web2py] Help making nav menu work please!

2011-10-22 Thread noremac
Hey guys I am in the process of making an online store. My products are stored in the db with basic table. db.define_table('products', Field('MainCategory', 'string'), Field('SubCategory', 'string'), Field('Title', 'string'), Field('Price', 'double'), Field('image', 'upload',

Re: [web2py] dal aggregation sum fields None

2011-10-22 Thread Bruno Rocha
for me it is a case for coalesce in pure SQL. I know dal offers coalesce support but I did not try yet. http://zerp.ly/rochacbruno Em 22/10/2011 09:47, apple simo...@gmail.com escreveu: I am summing some data using the DAL: cash_price = db.orderline.cash_price.sum() lines =

[web2py] Re: dal aggregation sum fields None

2011-10-22 Thread Anthony
On Saturday, October 22, 2011 7:47:08 AM UTC-4, apple wrote: I am summing some data using the DAL: cash_price = db.orderline.cash_price.sum() lines = db(db.orderline.order_ == id).select(cash_price).first() However if there are no lines then lines[cash_price] is None. So I

[web2py] Re: Foreign key name getting other value, images app

2011-10-22 Thread Anthony
Check out http://web2py.com/book/default/chapter/06#Record-Representation. Perhaps the format argument of the image table is set to %(title)s, which will display the title of the referenced image record rather than the id in dropdowns and tables. Anthony On Saturday, October 22, 2011 12:40:41

[web2py] Registration Password

2011-10-22 Thread horridohobbyist
Why is password not a required field in registration? I just found that if you don't enter a password, you can't login, even though registration was successful. Apparently, login will not accept an empty password. Richard

[web2py] Re: Registration Password

2011-10-22 Thread Anthony
Actually, by default, Auth requires a password of at least 4 characters, which is enforced by the CRYPT validator. If you enter 1-3 characters, you'll get an error. However, it you leave it blank, it appears that CRYPT will automatically insert a uuid as the password (I'm not sure why). If you

[web2py] How to port this simple game to a web2py app?

2011-10-22 Thread Andreas Christoffersen
Hi Group, I've been looking for an excuse to get started with web and python. Finally I thought up this little game for a friend, but how to port it to web2py? The game is like one of those old adventure books. There is a story, but at some point the player must decide on an action. For each

[web2py] Re: RIA Framework Recomendation

2011-10-22 Thread puercoespin
No flex!! Nor Silverlight...:(( I think the standard Javascript/html5 is the right direcction you have to looking for.. On 22 oct, 00:10, Ialejandro ialejandr...@gmail.com wrote: Hi everyone!! This time, I really need your help. I need to build a true RIA with web2py, we have several

[web2py] Re: Foreign key name getting other value, images app

2011-10-22 Thread Paul
Anthony, many thanks. I see that it is the image table format = '%(title)s that causes this to display. I originally though it was the constraint db.comment.image_id.requires line with specified '%(title)s', but it does not seem to be. Thank you for your help along this path. My apologies for

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Vasile Ermicioi
arguments for flex: - layouts: horizontal, vertical, absolute, circular etc - lots of ready components (titlewindow, datagrid, charts, form elements, ) - easy skinning (fxg - via flash cs tools) - no cross browser issues - flash ubiquity including mobile devices

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Phyo Arkar
What you said will be true 5 years ago , and i would say the same if I haven't wrote an app in Qooxdoo. On 10/22/11, Vasile Ermicioi elff...@gmail.com wrote: if your only restriction is time then go with flex, you will be able to export your app as a native iphone app, will work on browser

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Vasile Ermicioi
What you said will be true 5 years ago ie7 still the most used browser so it still true the only restriction is time, so I still advise flex, it is a proved technology 1) best argument for flex is why people use flex over pure as3 qooxdoo have many good things, but it is like coding in pur

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Vasile Ermicioi
mxml is a markup language: flex = mxml+as3

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Phyo Arkar
Yes i have build a Webcam chat side like chatroulette in MXML +AS3 + Red5 and i hated it. WIth qooxdoo , theres ZERO need for HTML / any markup at all. On 10/23/11, Vasile Ermicioi elff...@gmail.com wrote: mxml is a markup language: flex = mxml+as3

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Vasile Ermicioi
seems you miss the beauty of flex: binding, layout and user interface in mxml and logic in as3 I don't want to argue, this man asked for recommendation, I told him my point

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Phyo Arkar
I just venting my opinion too :). Take it easy. On 10/23/11, Vasile Ermicioi elff...@gmail.com wrote: seems you miss the beauty of flex: binding, layout and user interface in mxml and logic in as3 I don't want to argue, this man asked for recommendation, I told him my point

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Phyo Arkar
I love AS3 a lot but i just hate MXML. Theres no really need for that markup language at all. On 10/23/11, Phyo Arkar phyo.arkarl...@gmail.com wrote: I just venting my opinion too :). Take it easy. On 10/23/11, Vasile Ermicioi elff...@gmail.com wrote: seems you miss the beauty of flex:

[web2py] Getting Too many tables error on GAE , HELP!

2011-10-22 Thread Phyo Arkar
def get_totals(): response.generic_patterns = ['json'] query=(db.item.id==db.sale.id_items) total_price = 0 total_cost = 0 total_items = 0 rows = db(query).select(db.item.base_price,db.item.price,db.sale.total_items) for r in rows:

[web2py] Re: SQLFORM.grid / Powergrid

2011-10-22 Thread greenpoise
I appreciate all the help and leads. I wish I was at a point where I could adopt or add functionality to the widgets! but I am not there!! :-) I tried powergrid and was very impressed with it. It is indeed very very nice. Thanks again Dan On Oct 21, 8:02 pm, Bruno Rocha

[web2py] Re: Getting Too many tables error on GAE , HELP!

2011-10-22 Thread Phyo Arkar
Anyone get this problem? I am using web2py 1.98.2 on GAE . WHat is the work around for it? On 10/23/11, Phyo Arkar phyo.arkarl...@gmail.com wrote: def get_totals(): response.generic_patterns = ['json'] query=(db.item.id==db.sale.id_items) total_price = 0 total_cost

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Anthony
On Saturday, October 22, 2011 3:38:10 PM UTC-4, elffikk wrote: ie7 still the most used browser so it still true http://marketshare.hitslink.com/browser-market-share.aspx?qprid=2qpcustomd=0 http://www.w3counter.com/globalstats.php?year=2011month=9

[web2py][GAE]BadValueError: Incomplete key found for reference property

2011-10-22 Thread Phyo Arkar
Here is another GAE error: While i am doing this : def get_items(): response.generic_patterns = ['json'] query=(db.item.id=0) #out=[{name: Fusion Noodle}, {name: Burger Jumbo}, {name: Sushi}] return response.json(db(query).select(db.item.id,db.item.name)) I

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Phyo Arkar
Wow Nice statistics! So IE have 80% market share is no longer true! GG! On Sun, Oct 23, 2011 at 3:09 AM, Anthony abasta...@gmail.com wrote: On Saturday, October 22, 2011 3:38:10 PM UTC-4, elffikk wrote: ie7 still the most used browser so it still true

[web2py] DAL total record count

2011-10-22 Thread lucas
hello one and all, i think this is easy. how do you get the actual record/row total/ count for a particular table in web2py under DAL? thank you in advance and have a great weekend. lucas

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Vasile Ermicioi
as you see ie6+ie7+ie8 is about 1/3 of the market I use html (including html5) only for websites: widescreen, tablets, or phones here goes jquery co I use flex for administration, drag drop and/or other interactive parts we need real time charts, drag drop operations.. well a true RIA this

Re: [web2py] DAL total record count

2011-10-22 Thread Phyo Arkar
query=(db.item.id0) db(query).count() On 10/23/11, lucas sjluk...@gmail.com wrote: hello one and all, i think this is easy. how do you get the actual record/row total/ count for a particular table in web2py under DAL? thank you in advance and have a great weekend. lucas

Re: [web2py] DAL total record count

2011-10-22 Thread Anthony
Now you can also do db(db.item) instead of db(db.item.id0), so db(db.item).count(). You can also use count() as an aggregate function in a select, as described here: http://web2py.com/book/default/chapter/06#Grouping-and-Counting. If you just need to check whether a table is empty, a more

[web2py] Re: Getting Too many tables error on GAE , HELP!

2011-10-22 Thread Phyo Arkar
So because of join operation , it have problem with DAL over GAE right? What is recommend work around for one to many relationship ? Just use single table? That gonna be awful.. On 10/23/11, Phyo Arkar phyo.arkarl...@gmail.com wrote: Anyone get this problem? I am using web2py 1.98.2 on GAE

Re: [web2py][GAE]BadValueError: Incomplete key found for reference property

2011-10-22 Thread howesc
what's the model? what version of web2py are you using?

[web2py] Re: Getting Too many tables error on GAE , HELP!

2011-10-22 Thread howesc
the default datastore for GAE is a NOSQL system of key-value pairs. it does not have the full concept of referenced tables, and does not support a join operation. your options are to flatten your schema, putting all the necessary data in a single record rather than splitting it into many

Re: [web2py] Re: Getting Too many tables error on GAE , HELP!

2011-10-22 Thread Phyo Arkar
Oh Hell, To join programatically!! Ewww!! Finally bad (relational) database designs are gonna look good in GAE,, I think i am gonna brainwash myself and Jump onto NoSQL Bandwagon too On Sun, Oct 23, 2011 at 5:46 AM, howesc how...@umich.edu wrote: the default datastore for GAE is a NOSQL system

Re: [web2py][GAE]BadValueError: Incomplete key found for reference property

2011-10-22 Thread Phyo Arkar
I am using 1.98.2 here is my model : db.define_table(item, SQLField(name, text, length=512, notnull=True, default=None), SQLField(base_price, integer, notnull=True, default=None), SQLField(price, integer, notnull=True, default=None) ) Table definition from datetime

[web2py] HersPOS - New Version released 0.03 Web2py + Qooxdoo POS

2011-10-22 Thread Phyo Arkar
New Features : -FIltering by date -Added tabs and seperated items tables / Sales table. -Demo avaliable on Gae , partially workling (No Sales Table working but Item table works). Due to no join avaliable , please suggest me a work around. Thanks Phyo.

[web2py] Re: Web2py and Rest

2011-10-22 Thread Anaconda
there is a video tutorial and a post by Massimo on reddit showing how to use this feature, I was not able to make post request but used @services.run to make post requests. The book covers section on services but not the @restful feature. On Oct 21, 12:53 pm, BrendanC bren...@gmail.com wrote: I

[web2py] Ajax question: In a controller, how do I format data by a view so that I can return HTML from the controller back to ajax function?

2011-10-22 Thread Brent Jacobs
Hi all, I need some help please. I have a function/controller which is called by ajax calls. In the function I want to get some data from a model, format the data into html, and then return the HTML. It makes sense that I should be able to pass the model data to a view and then pass the html

[web2py] Re: a couple of related questions

2011-10-22 Thread Massimo Di Pierro
About [1] the user_signature=True is default but the signature only works if you are logged in. I do not understand [2] On Oct 20, 9:40 pm, niknok nikolai...@gmail.com wrote: I have a person table[1] with a parent field with a clickable representation view of the record. If I put this on a

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Miroslav Gojic
Usage of browsers is next /for September 2011/ IE - 51% Firefox - 21% Chrome - 15% Safari - 8% others - 5% Browsers from mobile devices are 10% and 90% from notebook and net-book ... - - Miroslav Gojic - - On Sun, Oct 23, 2011 at 00:02, Vasile Ermicioi elff...@gmail.com wrote: as you see

Re: [web2py] Re: RIA Framework Recomendation

2011-10-22 Thread Miroslav Gojic
On my last post I was use data from Wikipedia but on next link statistics are different 2011 Internet Explorer Firefox Chrome Safari Opera September 22.9 % 39.7 %30.5 % 4.0 % 2.2 % August 22.4 % 40.6 %30.3 % 3.8 % 2.3 %