[web2py] Re: DAL SQL exercise of the day

2010-04-14 Thread DenesL
One correct answer in, with explanation!. I apologize for not replying to the emails but my account has been blocked for some reason, the matter has been reported and hopefully will be resolved soon. On Apr 13, 4:32 pm, DenesL denes1...@yahoo.ca wrote: One answer in and while warm it uses

[web2py] Re: Using primarykey on the auth tables.

2010-04-14 Thread DenesL
Hi Chris, you don't need a primarykey, the aliasing of 'recid' as 'id' should be enough. -- To unsubscribe, reply using remove me as the subject.

[web2py] Re: DAL SQL exercise of the day

2010-04-14 Thread DenesL
Nobody else? Need more time? Speak up or else... I will will post the answer. -- To unsubscribe, reply using remove me as the subject.

[web2py] Re: dynamic mysql columns

2010-04-13 Thread DenesL
Very interesting method. In theory all tables can be defined and generated this way. Tables could be defined via forms, enforcing the proper creation sequence (tables with fields that reference other tables will have to be created later in the process). Or the generation has to be controlled via a

[web2py] Re: Controllers for a newbie

2010-04-13 Thread DenesL
On Apr 13, 10:06 am, greenpoise danel.sega...@gmail.com wrote: Hi all. Dont know where to begin when it comes to controllers. I used to develop client/server applications and the transition to webframeworks web developing in general has been tough for me. Do I simply use pure python on web2py

[web2py] DAL SQL exercise of the day

2010-04-13 Thread DenesL
Using the person dog tables, from the examples in the book, create a query to find which persons have less than 4 dogs (0-3). It seems deceivingly simple, but it requires you to apply several concepts and constructs, some only documented in this user group (not in the book yet). Massimo, please

[web2py] Re: DAL SQL exercise of the day

2010-04-13 Thread DenesL
One answer in and while warm it uses for/if ... it can be done with just DAL. On Apr 13, 4:28 pm, Thadeus Burgess thade...@thadeusb.com wrote: Also, reply only to DenesL, so you don't give away the answer! -- Thadeus -- To unsubscribe, reply using remove me as the subject.

[web2py] model files can not end with a comment

2010-04-12 Thread DenesL
In 1.76.3, and probably others, model files can not end with a comment line: Traceback (most recent call last): File D:\web2py\hg\gluon\restricted.py, line 171, in restricted ccode = compile(code.replace('\r\n', '\n'), layer, 'exec') File D:/web2py/hg/applications/mssqltest/models/db.py,

[web2py] Re: model files can not end with a comment

2010-04-12 Thread DenesL
Running on Windows here. @Yarko, yes, there seems to be an additional ingredient to this. A prerequisite seems to be the existence of a for statement somewhere. (!?!?). -- To unsubscribe, reply using remove me as the subject.

[web2py] Re: web2py URLs

2010-04-09 Thread DenesL
I like the semicolon idea. But doesn't it imply changing web2py, anywhere where args and vars are used, like the URL function?. On Apr 8, 2:22 pm, mdipierro mdipie...@cs.depaul.edu wrote: I think if ; is present it be used by default to delimit the args since there cannot be confusion there

[web2py] Re: building database querys from parts

2010-04-08 Thread DenesL
Yes q1 = db.software.os == os q2 = db.software.x == y filter1 = q1 q2 # q1 and q2 filter2 = q1 | q2 # q1 or q2 filter3 = ~q1 q2 # not q1 and q2 set1 = db(filter1) and then use select, count, delete, update on sets rows1=set1.select() see web2py book section 6.5 for more details On Apr 8,

[web2py] Re: Problem with MANY-MANY relationship

2010-04-08 Thread DenesL
Except from being less verbose, how is this different from calling somefunc under form.accepts? form=SQLFORM(...) # create, update or delete if form.accepts(...): somefunc(...) On Apr 8, 5:34 am, Ishbir ishbi...@gmail.com wrote: The way that you are doing it in crud, do the same way in DAL.

[web2py] new feature for Firebird and Oracle users

2010-04-08 Thread DenesL
Firebird and Oracle do not have auto-increment numeric fields, so generators or sequences with a trigger are used to assign the value of the field when they are needed. Until now the names of generators, sequences, and triggers were static, which was a problem when trying to access legacy

[web2py] Re: recaptcha in LOAD not working

2010-04-07 Thread DenesL
Hi selecta, can you send me a test app?. I have been testing and documenting ajax in web2py 1.76.3 in my spare time. Which jQuery, browser and web2py versions are you using?. On Apr 5, 5:05 pm, selecta gr...@delarue-berlin.de wrote: I tried to use Recaptcha in a LOAD div but I does not work

[web2py] Re: args problem in 1.76.5

2010-04-05 Thread DenesL
the args. On Apr 4, 6:55 pm, Jonathan Lundell jlund...@pobox.com wrote: On Apr 4, 2010, at 4:37 PM, DenesL wrote: It should be noted that there was some work done towards enabling an alternate setting that would allow the developer access to the unchanged (raw) args but it has not been finished

[web2py] Re: XML with custom TAG

2010-04-05 Thread DenesL
On Apr 5, 9:14 am, Jason Lotz jayl...@gmail.com wrote: I'm trying to pass an XML string with custom TAG to a view, but I'm having trouble with syntax. Required XML Syntax: rows row id=unique_rowid cellcell content/cell cellcell content/cell /row

[web2py] Vim snippets for web2py

2010-04-05 Thread DenesL
Leonardo Vidarte, one of the users in the spanish language group, has created some snippets [0] for Vim, for the snipMate plugin [1] to be exact, with all the API of web2py 1.76.3, including some basic snippets for template creation. Hopefully they will be useful to somebody. Additions are

[web2py] Re: args problem in 1.76.5

2010-04-04 Thread DenesL
It should be noted that there was some work done towards enabling an alternate setting that would allow the developer access to the unchanged (raw) args but it has not been finished yet. This would allow any character set in args which I believe mainly concerns non-English speaking

[web2py] Re: response.headers web2py-component-command is being cut short

2010-04-03 Thread DenesL
Still trying out things and documenting them but I already have a few suggestions. Regarding 'success' and 'complete' I just wanted to know if knowing 'success' runs first is in line with the way you thought it should work. The order in which they appear in the code is reversed, which does not

[web2py] Re: Validation per object

2010-04-02 Thread DenesL
with manual forms. Sorry DenesL but you did not answer the question as you supposed a model in place, so I would really appreciate a simple html form which preserves validation. Thank you Mengu's initial post uses a model and I believe I offered sample code to validate a form in his example. The form

[web2py] Re: Fetching a single field from multiple rows in gluon.sql.Rows as a tuple/list?

2010-04-01 Thread DenesL
thelist=[row.Name for row in db().select(db.Record.Name)] On Apr 1, 1:41 am, Magnitus eric_vallee2...@yahoo.ca wrote: Hi, assuming that I have a Record table with a field called Name in the database (all also that there are a bunch of other fields for that table). Assume that I make the

[web2py] Re: web2py forked

2010-04-01 Thread DenesL
LOL On Apr 1, 9:39 am, mr.freeze nat...@freezable.com wrote: Just kidding! Happy April Fools Day! -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send

[web2py] Re: response.headers web2py-component-command is being cut short

2010-04-01 Thread DenesL
into GETs. On Mar 28, 8:28 am, DenesL denes1...@yahoo.ca wrote: This makes an interesting readhttp://ajaxpatterns.org/On-Demand_Javascript -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com

[web2py] Re: response.headers web2py-component-command is being cut short

2010-04-01 Thread DenesL
you have experienced?. Also note that the 'success' function runs before the 'complete' function in web2py_ajax_page, I am not sure if you have those two reversed. Denes. On Apr 1, 11:55 am, DenesL denes1...@yahoo.ca wrote: According tohttp://api.jquery.com/jQuery.ajax/ dataType, one

[web2py] Re: DAL Oracle Query problems

2010-03-30 Thread DenesL
On Mar 30, 4:09 am, Jason Lotz jayl...@gmail.com wrote: I'm sorry if I am repeating an existing discussion. I searched and found similar issues but nothing that helped. I am trying to query an oracle db. raw sql: SELECT fld1, fld2 FROM tbl1 WHERE fld1 20; I can successfully run the

[web2py] Re: first attempt to use mysql web2py = unknown field type: INTEGER

2010-03-28 Thread DenesL
Depending on your table definitions you still have two options: 1) If your tables define a primary key on an integer field not named 'id' you can alias it: http://groups.google.com/group/web2py/msg/86838b9b792a236e 2) If your tables define multiple fields as primary key you could still use them

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-28 Thread DenesL
This makes an interesting read http://ajaxpatterns.org/On-Demand_Javascript -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py] response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
In my dft controller I have: response.headers['web2py-component- command']='''jQuery('.DB').click(function(e) { $(e.target).removeClass('click2loadTables'); } )''' response.headers['web2py-component-command'] is correctly set to: jQuery('.DB').click(function(e) {\n $

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
But works fine when typed like this: response.headers['web2py-component- command']='''jQuery('.DB').click(function(e) { $(e.target).removeClass('click2loadTables');} )''' Any ideas?. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
I was just getting there, since I tried adding some comments to the code which only made it worse. Good to know. Thanks. On Mar 26, 3:24 pm, mdipierro mdipie...@cs.depaul.edu wrote: Yes. response.headers cannot be multi-line. Massimo On 26 Mar, 14:15, DenesL denes1...@yahoo.ca wrote

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
Ended up moving the code into a SCRIPT tag as part of the response. This is in reply to a web2py LOAD. Any objections to doing this?. On Mar 26, 3:35 pm, DenesL denes1...@yahoo.ca wrote: I was just getting there, since I tried adding some comments to the code which only made it worse. Good

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
the web2y-component- command mechanism exists. Why do you need new lines in there? On 26 Mar, 14:53, DenesL denes1...@yahoo.ca wrote: Ended up moving the code into a SCRIPT tag as part of the response. This is in reply to a web2py LOAD. Any objections to doing this?. -- You received

[web2py] Re: response.headers web2py-component-command is being cut short

2010-03-26 Thread DenesL
On Mar 26, 4:53 pm, mdipierro mdipie...@cs.depaul.edu wrote: I a not sure. I know I tried once and it did not work (firefox). It did work for me with Firefox 3.6.2 on Win. I could not find specs anywhere about this. Can anybody expand our limited knowledge on the subject?. Or propose

[web2py] Re: Passing values to widgets

2010-03-26 Thread DenesL
It depends on what specifically you are trying to accomplish. You could set the validator instead, for example: rr=db(db.food.name.like('m%')).select() db.ate.food_id.requires=IS_IN_SET([(r.id,r.name) for r in rr]) Denes On Mar 26, 6:26 pm, Avik Basu avikb...@gmail.com wrote: Is there a

[web2py] Re: about syntax in web2py

2010-03-19 Thread DenesL
return may only occur syntactically nested in a function definition, you don't have one. On Mar 19, 9:06 am, tandnk50 dn.tan7...@gmail.com wrote: I wrote statements but invalid syntax and i don't know the problem, for example  : def func(): for i in range(3):      for j in range(2):      

[web2py] Re: about syntax in web2py

2010-03-19 Thread DenesL
Can you show the action's whole source?. On Mar 19, 9:38 am, tandnk50 dn.tan7...@gmail.com wrote: I'm sorry . But my above code writeen in a action, the 'return dict()' is for the action On 19 Tháng Ba, 20:34, DenesL denes1...@yahoo.ca wrote: return may only occur syntactically nested

[web2py] Re: about syntax in web2py

2010-03-19 Thread DenesL
=studens) On 19 Tháng Ba, 20:47, DenesL denes1...@yahoo.ca wrote: Can you show the action's whole source?. On Mar 19, 9:38 am, tandnk50 dn.tan7...@gmail.com wrote: I'm sorry . But my above code writeen in a action, the 'return dict()' is for the action On 19 Tháng Ba, 20:34

[web2py] Re: Using the Template System to Generate Emails

2010-03-19 Thread DenesL
Annet, maybe this will help http://groups.google.com/g/4247fb7b/t/4b6d3b0c8a822c83/d/7964e5b019d1c3d9 On Mar 19, 12:49 pm, annet annet.verm...@gmail.com wrote: In my application all functions related to sending mail from it work. The main function reads like: def send_mail():

[web2py] Re: Validation per object

2010-03-15 Thread DenesL
On Mar 15, 6:28 am, Mengu whalb...@gmail.com wrote: First of all, I am not sure what is the problem you are trying to solve. Even if you have custom forms and you build all the form html manually you can still use the existing validation mechanism. I don't want to use crud or sqlform or

[web2py] Re: Using the Template System to Generate Emails

2010-03-14 Thread DenesL
On Mar 14, 4:18 am, annet annet.verm...@gmail.com wrote: Hi Denes, This send_mail function works: def send_mail(): nfas=db(db.nfa.nfatype==4).select(db.nfa.ALL,orderby=db.nfa.bedrijf)     for nfa in nfas:         context=dict(nfa=nfa)         message=response.render('clublocatormail/

[web2py] Re: IMG Helper

2010-03-13 Thread DenesL
On Mar 13, 12:57 pm, Matthew McNaughton mamcnaugh...@gmail.com wrote: Greetings team, Hi Matthew and welcome I'm fairly new to HTML and WEB2PY and I am having some problems with code below. I am trying to write a view that pulls information from a database, called applications, and

[web2py] Re: IMG Helper

2010-03-13 Thread DenesL
On Mar 13, 1:15 pm, Matthew McNaughton mamcnaugh...@gmail.com wrote: Thanks for the quick response. The database holds the actual image not the URL? Are you asking or telling?. Without your model definition I can't tell, it all depends on how you defined the logo field. web2py helpers like

[web2py] Re: IMG Helper

2010-03-13 Thread DenesL
Note: that means you must define the following in the controller def download(): return response.download(request,apps) On Mar 13, 6:31 pm, Kuba Kucharski kuba.kuchar...@gmail.com wrote: so.. =IMG(_src=URL(r=request, f='download'... -- Kuba On Sun, Mar 14, 2010 at 12:20 AM, Kuba

[web2py] Re: KeyError while submitting a form

2010-03-12 Thread DenesL
SQLite does not support this AFAIK. Keyed tables (the ones that define a primarykey) so far are only supported on DB2, MS SQL, Ingres and Informix. Others (except SQLite) can be added following the instructions in: http://groups.google.com/group/web2py/browse_thread/thread/db150376b06d47fc

[web2py] Re: Should IS_TIME accept format?

2010-03-12 Thread DenesL
On Mar 11, 5:29 pm, mdipierro mdipie...@cs.depaul.edu wrote: can you show an example and I will try? Never mind, form has to be recreated to include any changes. On Mar 11, 3:10 pm, mdipierro mdipie...@cs.depaul.edu wrote: I do not know. The problem is that the JS may not work with other

[web2py] Re: Should IS_TIME accept format?

2010-03-12 Thread DenesL
To drop the seconds value as in the example format '%H:%M' above. On Mar 12, 8:07 am, mdipierro mdipie...@cs.depaul.edu wrote: The 'time' fields have a JS time picker. If you choose to do   db.table.field.requires.formatter=lambda v: v.strftime('%H-%M') instead of  

[web2py] Re: KeyError while submitting a form

2010-03-12 Thread DenesL
On Mar 12, 11:53 am, MarKco ilsecondodasinis...@gmail.com wrote: Thank you very much. I created a new project with almost the same controllers and views, but with the table extended by the ID field (I actually did not choose a key in explicit way, so Web2py provided one by itself). web2py

[web2py] Re: Using the Template System to Generate Emails

2010-03-12 Thread DenesL
Hi Annet, long time no see. From the gluon/tools.py source under class Mail function send: to: list or tuple of receiver addresses; will also accept single object Hope this helps, Denes. On Mar 12, 12:34 pm, annet annet.verm...@gmail.com wrote: I am trying to work out a working version of

[web2py] IS_DATE bug introduced with rev.242

2010-03-11 Thread DenesL
The changes made to IS_DATE in rev.242 (workaround to problem with year1900) are buggy. Example: requires=IS_DATE(format=%A) with today's date will show 'Saturday' instead of 'Thursday' because the formatter is changing the year to 2000. Denes. -- You received this message because you are

[web2py] Should IS_TIME accept format?

2010-03-11 Thread DenesL
Currently IS_TIME does not a accept a format parameter, unlike IS_DATE or IS_DATETIME. This can be worked around in some cases by setting formatter to a lambda for example, but was this an omission? Should it have format? I could create a patch later. Denes. -- You received this message

[web2py] Re: Should IS_TIME accept format?

2010-03-11 Thread DenesL
wrote: I do not know. The problem is that the JS may not work with other formats. On Mar 11, 2:03 pm, DenesL denes1...@yahoo.ca wrote: Currently IS_TIME does not a accept a format parameter, unlike IS_DATE or IS_DATETIME. This can be worked around in some cases by setting formatter

[web2py] Re: Relase of the first HL7 based on web2py framework

2010-03-08 Thread DenesL
A w2p file would make this easier to download and try but I did not see one. Otherwise you need an hg client, or am I missing something?. On Mar 7, 3:33 pm, mdipierro mdipie...@cs.depaul.edu wrote: I would like to congratulate with Debebe who did most of the work and I was glad to help. He is

[web2py] Re: Relase of the first HL7 based on web2py framework

2010-03-08 Thread DenesL
http://web2py.com/HLv3/static/web2py.app.hl7.w2p On Mar 8, 12:41 pm, mdipierro mdipie...@cs.depaul.edu wrote: hmmm. I do not know what the problem is. Anyway: http://web2py.com/HLv3/statoc/web2py.app.hl7.w2p -- You received this message because you are subscribed to the Google Groups

[web2py] Re: date fieds layout problem

2010-03-05 Thread DenesL
Works fine on IE6, which version are you using?. On Mar 5, 4:27 pm, Andrea Parodi andrea.par...@ebansoftware.net wrote: Sorry for double post, my mistake... I thought first was lost... Anyway, create an app from scratch, define following in model: db.define_table('mytable',

[web2py] New features not documented in PDF book (2 ed)

2010-03-04 Thread DenesL
New features not documented in the PDF book (2nd edition) as highlights in release order sequence (newer to older): 1.76.3 repost of 1.76.2 with crud captcha fix http://groups.google.com/group/web2py/browse_thread/thread/658c72a8c08040d9# 1.76.2 *** use 1.76.3 *** Main changes include: 1) major

[web2py] Re: did you know?

2010-03-04 Thread DenesL
+1 On Mar 4, 10:14 am, Thadeus Burgess thade...@thadeusb.com wrote: Nice! -Thadeus On Thu, Mar 4, 2010 at 9:08 AM, mdipierro mdipie...@cs.depaul.edu wrote: http://gluonframework.wordpress.com/2010/03/04/web2py-learner/ -- You received this message because you are subscribed to the

[web2py] Re: uservoice and decimal

2010-03-04 Thread DenesL
Other that pointing them in the right direction?. On Mar 4, 8:06 am, mdipierro mdipie...@cs.depaul.edu wrote: There is a comment on uservoice about decimal. DAL already has support for decimal although it is not documented in the book. On SQLite it is mapped into double because SQLite does

[web2py] Re: online book correction protocol

2010-03-04 Thread DenesL
In http://groups.google.com/group/web2py/msg/7b9661eac4f788e0 Massimo said: - - - - - - quote - - - - - - I made some of you editors (if you are not and want to be just ask) Please follow these few rules: - Try use wiki instead of editing book section - Do not rearrange or edit text in book

[web2py] Re: did you know?

2010-03-04 Thread DenesL
LOL On Mar 4, 1:06 pm, Thadeus Burgess thade...@thadeusb.com wrote: I'm pointing my Learner to the web2py mailing list :) Bowahahahahahahahaha! Maybe it can start writing web2py code for me . -Thadeus -- You received this message because you are subscribed to the Google Groups

[web2py] Re: online book correction protocol

2010-03-04 Thread DenesL
So the entries in errata are finding their way into the book and are being deleted afte, right?. On Mar 4, 9:39 pm, mdipierro mdipie...@cs.depaul.edu wrote: The fact is that some new users may want to be able to report issues (and they can edit errata) but they cannot edit the book. -- You

[web2py] Re: Problem with IS_IN_SET validator where valid list is dynamic

2010-03-03 Thread DenesL
An ajax autocomplete field would be a better option IMO. There is an experimental AutocompleteWidget in web2py but I believe it still has some issues plus it might not allow enough customization of the query depending on your particular needs in this case. You can create your own widget though.

[web2py] Re: Helper functions

2010-03-03 Thread DenesL
To handle the missing view you could modify the generic one to suit your needs. That is the one that gets executed when there is no corresponding view for a controller. On Mar 3, 6:57 pm, mr.freeze nat...@freezable.com wrote: Functions that take arguments or start with a double underscore are

[web2py] Re: Javascript Comment Bug

2010-03-03 Thread DenesL
Templates are converted to python programs. In python the comments start with a # or are enclosed in triple quotes. So {{#...}} or {{'''...'''}} or {{...}} should work. What you have is a Javascript comment which is just another HTML string in the template. {{=review.id}} will still be converted

[web2py] Re: Problem with IS_IN_SET validator where valid list is dynamic

2010-03-02 Thread DenesL
Your setup seems to work for me. value not allowed would happen if you don't select a last name from the drop box. Are the values in the drop box OK? What is in last_names? Which web2py version? Denes. On Mar 2, 1:46 pm, hschill...@nasa.gov hschill...@grc.nasa.gov wrote: I have a form with a

[web2py] Re: Problem with IS_IN_SET validator where valid list is dynamic

2010-03-02 Thread DenesL
, hschill...@nasa.gov hschill...@grc.nasa.gov wrote: On Mar 2, 3:49 pm, DenesL denes1...@yahoo.ca wrote: Your setup seems to work for me. Thanks for trying it. value not allowed would happen if you don't select a last name from the drop box. I definitely do. Are the values in the drop box OK

[web2py] Re: unfair trolling

2010-03-01 Thread DenesL
Having mirrors would be another option. On Feb 28, 4:13 pm, mdipierro mdipie...@cs.depaul.edu wrote: I moved  because vps.net was cheaper and had automatic daily weakly and monthly backup. Except for the fact that vps.net seems to be down on Saturdays I am very happy with their support. They

[web2py] Re: zen html

2010-03-01 Thread DenesL
selecta, thanks for bringing this up. I will start using it with Pspad. :) On 25 feb, 10:49, selecta gr...@delarue-berlin.de wrote: Sometimes you still have to write html in web2py which is annoying. It might not be new to all of you but I just discovered zen html that really speeds up the

[web2py] typo in admin/static/styles.css

2010-03-01 Thread DenesL
In line 23 whitespace should be white-space. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For

[web2py] Re: Is the web2py site down?

2010-02-27 Thread DenesL
It works for me. On Feb 27, 4:17 am, nakul mishra nkl@gmail.com wrote: Yes u are right. I also checked but its not responding On Sat, Feb 27, 2010 at 9:30 AM, Neno nen...@gmail.com wrote: http://www.web2py.com/doesn't seem to be responding... -- Regards Nakul -- You received this

[web2py] newly created app fails in shell mode in 1.75.4

2010-02-25 Thread DenesL
Using 1.75.4, a newly created app fails to start in shell mode (-M -N - S) with: web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-2010 Version 1.75.4 (2010-02-18 14:55:03) Database drivers available: pysqlite2, MSSQL/DB2 Traceback (most recent call last): File

[web2py] Re: newly created app fails in shell mode in 1.75.4

2010-02-25 Thread DenesL
On Feb 25, 11:10 am, Thadeus Burgess thade...@thadeusb.com wrote: Permission error when running in shell mode? Strange, huh?. It happens on both WinXP and 2003 server. And just clicking on 'database administration' in app's admin fixes it. head scratch/ -- You received this message because

[web2py] web2py help resources

2010-02-24 Thread DenesL
Primary source of help: web2py groups - Groups in English: http://groups.google.com/group/web2py/topics http://groups.google.com/group/web2py-developers/topics Grupo de usuários brasileiros do web2py: http://groups.google.com/group/web2py-users-brazil/topics

[web2py] Re: Two records inserted instead of one

2010-02-24 Thread DenesL
On acceptance (accepts==True) the SQLFORM form would do the insert for you. This explains your duplicate record. With FORM you would have to do your own insert inside the acceptance test. form=FORM(...) if form.accepts(...): #insert record here On Feb 24, 8:49 am, mdmcginn

[web2py] Re: {{=form.custom.begin}} - How set an ID to form

2010-02-24 Thread DenesL
The problem is that form.custom.begin is evaluated when the form is created. Changing '_id' after it has been created does not recalculate form.custom.begin, but you can do so manually: form['_id']='my_form_id' form.custom.begin=XML(%s %s) %(form.tag,form._xml()[0])) Denes. On Feb 24, 9:50 am,

[web2py] Re: {{=form.custom.begin}} - How set an ID to form

2010-02-24 Thread DenesL
function that creates a form. On Feb 24, 9:00 pm, mdipierro mdipie...@cs.depaul.edu wrote: You are right. Perhaps it should be re-initialized inside accept? What do you think? On Feb 24, 9:38 am, DenesL denes1...@yahoo.ca wrote: The problem is that form.custom.begin is evaluated when the form

[web2py] Re: {{=form.custom.begin}} - How set an ID to form

2010-02-24 Thread DenesL
24, 2010 at 9:55 PM, Thadeus Burgess thade...@thadeusb.com wrote: And hence the inherent flaw in SQLFORM :) Though I can't complain since I have not devoted time to redesigning the system as I so very much would like to do. -Thadeus On Wed, Feb 24, 2010 at 9:48 PM, DenesL denes1

[web2py] Re: what distinguishes update form from create form

2010-02-23 Thread DenesL
It is the 'record' parameter in SQLFORM. form=SQLFORM(table) # insert form form=SQLFORM(table, record=r) # update form On Feb 23, 5:47 am, hamdy.a.farag hamdy.a.fa...@inbox.com wrote: can't get it sorry !! is not there a special form variable that distinguishes between insertion and update ?

[web2py] posts delayed in all groups

2010-02-23 Thread DenesL
FYI All Google groups seem to be having issues today. Posts are being delayed, sometimes for hours. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send

[web2py] Re: creating Microsot Excel type charts

2010-02-22 Thread DenesL
Maybe the code around line 250 in http://trac.sahanapy.org/browser/models/01_RESTlike_controller.py could be modified to do it. On Feb 22, 9:28 am, Ramon ramonnova...@hotmail.com wrote: Hello, I am going to use web2py for a database project soon. I have a quick question. I would like to

[web2py] Re: LOAD and response.view

2010-02-22 Thread DenesL
try response.view = 'your_controller_name/blank.html' On Feb 22, 1:09 pm, vihang vihan...@gmail.com wrote: Hi, I tried the following code def index(): return dict(message=Accounting Dashboard) def AP(): response.view = 'blank.html' return

[web2py] web2py help resources

2010-02-22 Thread DenesL
Primary source of help: web2py groups - Groups in English: http://groups.google.com/group/web2py/topics http://groups.google.com/group/web2py-developers/topics Grupo de usuários brasileiros do web2py:

[web2py] web2py help resources

2010-02-22 Thread DenesL
Primary source of help: web2py groups - Groups in English: http://groups.google.com/group/web2py/topics http://groups.google.com/group/web2py-developers/topics Grupo de usuários brasileiros do web2py: http://groups.google.com/group/web2py-users-brazil/topics

[web2py] ajax flow

2010-02-21 Thread DenesL
I am trying to understand the flow of the ajax example given in http://groups.google.com/group/web2py/msg/0d9a3d7ab6ed95fb so I added some print statements to the code, and now I need some help. This is the printout (I am using 1.75.1 and I changed index to addPerson) with my comments and

[web2py] Re: ajax

2010-02-21 Thread DenesL
Adding person with ajax_create active works for me on 1.75.1 On 20 feb, 19:16, mdipierro mdipie...@cs.depaul.edu wrote: Now I am very puzzled. Can you email me the entire app? Massimo On Feb 20, 12:52 pm, Jose jjac...@gmail.com wrote: On 20 feb, 18:45, mdipierro mdipie...@cs.depaul.edu

[web2py] Re: ajax

2010-02-20 Thread DenesL
Aw crap! and here is little me thinking I know how to use web2py. This one requires some painfully detailed walk-through. Am I the only one?. On 20 feb, 02:39, mdipierro mdipie...@cs.depaul.edu wrote: En even better solution. Drop this code in your model somewhere: def ajax_create(field,  

[web2py] Re: ajax

2010-02-20 Thread DenesL
? I agree it is not easy but you do not really need to understand it to use it. I prefer to understand. Massimo On Feb 20, 9:37 am, DenesL denes1...@yahoo.ca wrote: Aw crap! and here is little me thinking I know how to use web2py. This one requires some painfully detailed walk-through. Am

[web2py] Re: trying to set default value in form

2010-02-20 Thread DenesL
INPUT(_name='title',_value=session.data['title']) On 20 feb, 17:36, weheh richard_gor...@verizon.net wrote: I'm trying to set the default value of a form ... something like this: form=FORM(T('Title: '),       INPUT(_name='title',default=session.data['title']),      

[web2py] Re: new from the slice house: request a slice!

2010-02-19 Thread DenesL
+1 -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at

[web2py] New features not documented in printed book (2nd ed.)

2010-02-19 Thread DenesL
New features not documented in the printed version of the 2nd ed. book as highlights in release order sequence: 1.75.4 - bug fix in BEAUTIFY 1.75.3 *** skip, use 1.75.4 *** - better BEAUTIFY - Linux PAM (Pluggable Authentication Modules) support

[web2py] Re: optgroup support

2010-02-17 Thread DenesL
Problem is that you can not use TAG.optgroup because it does not work with the SELECT helper. Here is a little example: def index(): OG=TAG.OPTGROUP g1=[ OPTION( r.name, _value=r.id ) for r in db(db.person.age=30).select() ] g2=[ OPTION( r.name, _value=r.id ) for r in

[web2py] Re: optgroup support

2010-02-17 Thread DenesL
So for future reference: you can create OPTGROUPs with TAG.OPTGROUP but do NOT use it with the SELECT helper, you must use TAG.SELECT as in the following example: def index(): OG=TAG.OPTGROUP g1=[ OPTION( r.name, _value=r.id ) for r in db(db.person.age=30).select() ] g2=[ OPTION(

[web2py] New features not documented in Book (2 ed)

2010-02-16 Thread DenesL
New features not documented in Book (2nd edition) 1.75.2 - no more cron with -S option - ability to override/upgrade and app - gluon.tools.prettydate http://groups.google.com/group/web2py/msg/03ea6109ec90f0c8 - crud.archive http://groups.google.com/group/web2py/msg/d4892f347889fc6e - better

[web2py] Re: New features not documented in Book (2 ed)

2010-02-16 Thread DenesL
Thanks (it is copy/paste of the original). Do you know of any docs on usage?. On Feb 16, 11:21 am, Jonathan Lundell jlund...@pobox.com wrote: On Feb 16, 2010, at 7:16 AM, DenesL wrote: New features not documented in Book (2nd edition) 1.75.2 - no more cron with -S option - ability

[web2py] New features not documented in Book (2 ed)

2010-02-16 Thread DenesL
New features not documented in Book (2nd edition) 1.75.2 - no more cron with -S option - ability to overwrite/upgrade and app http://groups.google.com/group/web2py/msg/4f3ba5eedeced6a6 - gluon.tools.prettydate http://groups.google.com/group/web2py/msg/03ea6109ec90f0c8 - crud.archive

[web2py] Re: how to deploy web2py for a single app?

2010-02-15 Thread DenesL
See book, section 4.14 On 15 feb, 04:19, pistacchio pistacc...@gmail.com wrote: hi, massimo, thanks. it worked. is this info somewhere in the new online book? i think that from now on those kind of questions and answer should point to the documentation. if it is documented, maybe it is in a

[web2py] Re: URL and URLs

2010-02-14 Thread DenesL
It seems that using LOCALE in the regex would do the job but setting locale is a big can of worms. On 14 feb, 03:04, mdipierro mdipie...@cs.depaul.edu wrote: We could create a switch in routes that allows to change the URL validation regex. I would take a patch. I would not change the default

[web2py] Re: adding additional elements to custom form while leaving rest untouched

2010-02-14 Thread DenesL
Just insert your table in the form: form.insert(0,your_table) and in the view use {{=form}} On 14 feb, 16:01, selecta gr...@delarue-berlin.de wrote: Ah no that won't work since the extra elements are in a different HTML table. I really need form starts table with data and switches

[web2py] URL and URLs

2010-02-13 Thread DenesL
Shouldn't URL create only URLs that are usable with web2py? Example: u=URL(r=request, args='Capítulo 1') produces an URL ending with /Cap%A1tulo%201 which generates an Invalid request when used. And why are these characters not allowed in URLs? Denes. -- You received this message because you

[web2py] Re: URL and URLs

2010-02-13 Thread DenesL
in there causes trouble. On Feb 13, 12:02 pm, DenesL denes1...@yahoo.ca wrote: Shouldn't URL create only URLs that are usable with web2py? Example: u=URL(r=request, args='Capítulo 1') produces an URL ending with /Cap%A1tulo%201 which generates an Invalid request when used. And why

[web2py] Re: Requiring arguments

2010-02-12 Thread DenesL
Only if you trust the contents of request.args[0], it will still blow up with 'abc' in it for example. On Feb 11, 8:14 pm, mdipierro mdipie...@cs.depaul.edu wrote: I define def error(message=''): session.flash=message redirect(URL(r=request,f='error_page')) and def

<    3   4   5   6   7   8   9   10   11   12   >