[web2py:25017] Re: form_factory focus

2009-06-25 Thread annet
Problem solved. Thanks. Kind regards, Annet. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group

[web2py:25016] Re: autocomplete

2009-06-25 Thread annet
I think Jason is right, Vim is a text editor and pydiction is a dictionary file. I had a look at Vim a few days ago, and found the naming rather confusing. To me auto-completion is related to the user, I would call vim's completion feature code-completing, related to the developer. I guess they ca

[web2py:25015] Re: web2py 1.64.3

2009-06-25 Thread Trollkarlen
No comments on this ? /R On Jun 24, 3:09 pm, Robert Marklund wrote: > I upgraded to web2py 1.64.3 and then: > > crud started to set its own table name >          if request.extension != 'html': >              (_session, _formname) = (None, None) >          else: >             (_session, _formna

[web2py:25014] Re: question on text area and output

2009-06-25 Thread mdipierro
replace {{=body}} with {{=TAG[''](*[P(p) for p in body.split('\n')]) }} or, if you want to allow HTML tags in texts {{=XML(body.replace('\n',''),sanitize=True)}} of you want to allow WIKI syntax {{from gluon.contrib.markdown import WIKI}} {{=WIK(body)}} Massimo On Jun 25, 9

[web2py:25012] jEditable and Datatables

2009-06-25 Thread Hans
I've got datatables working well. After installing the app do csv import via appadmin to have some data to play with. you find csv example data in the /private folder. Unfortunately I've not got jEditable working. My js sucks ;-) Is anyone here able to help getting also jEditable working ? app +

[web2py:25011] Datatables + jEditable

2009-06-25 Thread Hans
... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegr

[web2py:25009] Re: autocomplete

2009-06-25 Thread Jason Brower
I am not sure that is what he is looking for. Are you looking to get autocomplete for commands as your program right? Perhaps this? http://www.web2py.com/AlterEgo/default/show/178 - j On Thu, 2009-06-25 at 10:11 -0700, Yannick wrote: > Hello, > > I think you can just create an Ajax from the fro

[web2py:25008] question on text area and output

2009-06-25 Thread coolaid
I would like to retain the the spacing information (next line, /n) when I retrieve text data from the database. for example, when I put following into a form test test test this is what I get out of the database in the views. test test test I'd like it retrieve test test test here is my cod

[web2py:25007] Re: slides source in powerpoint and keynote

2009-06-25 Thread Yarko Tymciurak
Please note the corrected URLs: http://www.web2py.com/examples/static/cookbook2.pdf.zip http://www.web2py.com/examples/static/cookbook2.key.zip http://www.web2py.com/examples/static/cookbook2.ppt.zip On Thu, Jun 25, 2009 at 7:03 PM, mdipierro wrote: > > I have re-uplodad the slides here in pdf

[web2py:25006] Re: executing db.py in models dir every app refresh

2009-06-25 Thread kuba
that was fast :) thank you for help - now i can code calmly --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe fr

[web2py:25005] slides source in powerpoint and keynote

2009-06-25 Thread mdipierro
I have re-uplodad the slides here in pdf, keynote and powerpoint http://www.webp2py.com/examples/static/cookbook2.pdf.zip http://www.webp2py.com/examples/static/cookbook2.key.zip http://www.webp2py.com/examples/static/cookbook2.ppt.zip feel free to use them as you see fit. If you are giving a pr

[web2py:25004] Re: executing db.py in models dir every app refresh

2009-06-25 Thread mdipierro
db=SQLDB(,pool_size=10) will do connection pooling and connections will be reused db.define_table(,migrate=False) it will not attempt to create the table if you know it there and you have not changed it. It will be much faster. Massimo On Jun 25, 6:46 pm, kuba wrote: > Hi guy

[web2py:25003] executing db.py in models dir every app refresh

2009-06-25 Thread kuba
Hi guys, I am total newbie to web2py, and one thing really irritates me. As i noticed every time I refresh application in web browser db.py and any other file in models dir are executed. In tutorial it states that whole db initialization should be specified there and as I understand during this p

[web2py:25002] Re: Maemo 2009

2009-06-25 Thread AchipA
Just to report back, both proposals got accepted in some form, so it's first row for web2py people :) @fpp: if you need anything with regard to web2py and/or Maemo, let me know so we could get organized in time On Jun 23, 7:59 pm, fpp wrote: > On 23 juin, 02:01, mdipierro wrote: > > > Well don

[web2py:25001] Re: xml

2009-06-25 Thread pk
ok, then i have to wait... thanks On 25 Jun., 15:06, mdipierro wrote: > xml import? do not know. not a priority. > > On Jun 25, 1:44 am, pk wrote: > > > puh it`s to tricky... > > i think i have to wait still there is a function to read the same xml > > (for updating my tables) > > which i gener

[web2py:25000] Re: global logging to file

2009-06-25 Thread MikeEllis
This looks really useful. Thanks for writing it. I'm trying to import some existing python modules that have logging calls into a web2py app. Just putting log.py into my models directory helps some, but I'm not seeing any messages from my existing modules with level lower than logging.ERROR. I am

[web2py:24999] Re: Antwort: [web2py:24992] Re: Antwort: [web2py:24977] Re: db query problem

2009-06-25 Thread Trollkarlen
Thx it worked like a charm. /R On Jun 25, 6:32 pm, johann.scheibelho...@easytouch-edv.com wrote: > out of my head the following should work > > result = db(db.images.id>0).select(\ >          left=[db.image_info.on(db.image_info.image_id==db.images.id),\ >  db.image_keyword.on(db.image_keyword

[web2py:24998] Re: form_factory focus

2009-06-25 Thread DenesL
In the controller: focus=SCRIPT("$(document).ready(function() { $('#clubbyplace').focus () } )") ... return dict(..., focus=focus) and in the view somewhere: {{=focus}} --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Gro

[web2py:24997] Re: form_factory focus

2009-06-25 Thread mdipierro
http://kolodvor.net/2008/01/17/set-focus-on-first-field-with-jquery/ On Jun 25, 10:55 am, annet wrote: > In a function I have the following line of code: > > form=form_factory(SQLField('plaats',requires=IS_NOT_EMPTY > (),widget=lambda self, value:INPUT > (_type='text',_id='clubbyplace',_class='a

[web2py:24996] "News Feed" Design approach !!!!

2009-06-25 Thread Yannick
Hello mate, I just wonder what will be the best design approach in order to implement a "News Feed" like in Twitter or Facebook using web2py... Initially the general approach will be to read in the DB the "News" of all the friends of a user and display them on his profile every few second, but I

[web2py:24995] Re: autocomplete

2009-06-25 Thread Yannick
Hello, I think you can just create an Ajax from the front end and call an Auto complete action the return value from DB (if needed) : Like your action can be something like this: def autoComplete(): q='' if request.vars: q=request.vars.q if not q: return q rows= #

[web2py:24994] Antwort: [web2py:24992] Re: Antwort: [web2py:24977] Re: db query problem

2009-06-25 Thread Johann . Scheibelhofer
out of my head the following should work result = db(db.images.id>0).select(\ left=[db.image_info.on(db.image_info.image_id==db.images.id),\ db.image_keyword.on(db.image_keyword.image_id==db.images.id),\ db.keyword.on(db.keyword.id==db.image_keyword.keyword_id)]) Hans web2py@googlegr

[web2py:24993] Re: OR in query

2009-06-25 Thread JohnMc
Annet, Take a look at Fran's suggestion on another problem -- http://groups.google.com/group/web2py/t/360c47ff872043d9?hl=en You might be able to rework it for your solution. Use the beginning date as your first query. Then iterate looking for matches in the second query for those events in rang

[web2py:24992] Re: Antwort: [web2py:24977] Re: db query problem

2009-06-25 Thread Trollkarlen
that didnt do it. And i would like to doit with one query if possible. my db looks like this: db.define_table('images', SQLField('posted_on','datetime', default=request.now, writable=False, readable=False), SQLField('posted_by', db.auth_user, writable=False, readable=False), S

[web2py:24991] form_factory focus

2009-06-25 Thread annet
In a function I have the following line of code: form=form_factory(SQLField('plaats',requires=IS_NOT_EMPTY (),widget=lambda self, value:INPUT (_type='text',_id='clubbyplace',_class='ac_input',_name='plaats',requires=self.requires))) When the view is displayed I would like the input field to have

[web2py:24990] Re: OR in query

2009-06-25 Thread annet
Massimo, I work on Mac OS X Leopard Server for both development and production, so problem solved. Thanks. Kind regards, Annet. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post

[web2py:24989] Re: error messages in Auth.change_password

2009-06-25 Thread mdipierro
Try the trunk and the following customizations: auth.messages.invalid_email = 'Invalid email' auth.messages.invalid_login = 'Invalid login' auth.messages.invalid_user = 'Invalid user' auth.messages.is_empty = "Cannot be empty" auth.messages.mismatched_passw

[web2py:24988] Re: NOT a web2py question

2009-06-25 Thread Kuba Kucharski
>>> python "range" but in reverse >Just find replace into this: >tel = {"SPQ": "3[1,0-3]", "SPQ": "70(1-3)" } this is exactly what I was thinking of and asking about, thx once again. And, yes, this is me to blame ;) -- Kuba On Thu, Jun 25, 2009 at 8:23 AM, Trollkarlen wrote: > > Cleaner one

[web2py:24987] Re: OR in query

2009-06-25 Thread mdipierro
yes. execpt that or (|) does not work on GAE. On Jun 25, 10:14 am, annet wrote: > In a function I have: > > events=db((db.event.from_datum>=fromdate)& > (db.event.from_datum<=todate).select() > > The problem is that some events last more than one day, they have both > a from_date and to_date. In

[web2py:24986] OR in query

2009-06-25 Thread annet
In a function I have: events=db((db.event.from_datum>=fromdate)& (db.event.from_datum<=todate).select() The problem is that some events last more than one day, they have both a from_date and to_date. In the view the user selects a date an the number of weeks he wants to see the events for. For

[web2py:24985] Re: MySQL Library (Pythen newby)

2009-06-25 Thread mdipierro
you need to run from source and install MySQLdb On Jun 25, 8:28 am, Stefan wrote: > I want to add y mysql database. > When I start the framework  it says > > WARNING:root:importing mysqlite3.dbapi2 as sqlite3 > What does it mean? > > Which library do i need to use mysql ? > When I start it only

[web2py:24984] Howto import mysql database connection?

2009-06-25 Thread Stefan
I want to add y mysql database. When I start the framework it says WARNING:root:importing mysqlite3.dbapi2 as sqlite3 What does it mean? Which library do i need to use mysql ? When I start it only shows that it loads Database drivers available: SQLite2, Postgre Thanks! (Pythen newby) --~--

[web2py:24983] autocomplete

2009-06-25 Thread Nur Hisyam Mohamed
Hi, I'm new with python and web2py. I'm just wondering if it is possible for me to get "auto-complete" to be used for web2py. Usually what I do for other python modules is by using pydiction and use vim to get the auto-complete feature. However since the modules inside web2py are not registered

[web2py:24982] MySQL Library (Pythen newby)

2009-06-25 Thread Stefan
I want to add y mysql database. When I start the framework it says WARNING:root:importing mysqlite3.dbapi2 as sqlite3 What does it mean? Which library do i need to use mysql ? When I start it only shows that it loads Database drivers available: SQLite2, Postgre Thanks! (Pythen newby) --~--

[web2py:24980] Re: NOT a web2py question

2009-06-25 Thread DenesL
Nice. A couple of notes though: On Jun 25, 2:23 am, Trollkarlen wrote: > Cleaner one: > > Just find replace into this: > tel = {"SPQ": "3[1,0-3]", "SPQ": "70(1-3)" } it only works with square brackets so the second entry, "70(1-3)", will not work. > > def get_operator(number): > import re > fo

[web2py:24981] Re: NOT a web2py question

2009-06-25 Thread weheh
Now we know who to blame with our telephones start ringing in the middle of the night! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegr

[web2py:24979] Antwort: [web2py:24977] Re: db query problem

2009-06-25 Thread Johann . Scheibelhofer
Maybe I'm wrong but I think Robert needs a left join. something like... result = db(db.images.id==db.image_info.image_id).select(\ left=[db.keyword.on(db.keyword.id==db.image_keyword.keyword_id)]) web2py@googlegroups.com schrieb am 25.06.2009 15:19:50: > > On Jun 25, 1:51 pm, Robert Mar

[web2py:24978] Re: Using GAE DB model Directly into web2py?

2009-06-25 Thread Hans Donner
ad3) this because how web2py maps its ID field. if we also map ID to a second field (like id2), we can overcome some id limitations. ad4) GAE has some sort of joins (via references), but otherwise indeed no joins. A GAE database scheme should work with this restriction in mind so joins are not ne

[web2py:24977] Re: db query problem

2009-06-25 Thread Fran
On Jun 25, 1:51 pm, Robert Marklund wrote: > I would like to do a join but get results even if it was unsucessfull. > Like this > query = (db.images.id == db.image_info.image_id)  & > (db.images.id==db.image_keyword.image_id) > & \ >               (db.keyword.id==db.image_keyword.keyword_id) > I

[web2py:24976] Re: error messages in Auth.change_password

2009-06-25 Thread mdipierro
good point. these two strings come from the validators and do not have customization. Will fix that. On Jun 25, 7:35 am, "Sebastian E. Ovide" wrote: > Hi, > > Using Auth.change_password I noticed that if the 2 password do not match > web2py is giving the message "invalid expression!" and if the

[web2py:24975] Re: Newbie question : How to pass parameters from flash?

2009-06-25 Thread mdipierro
I do not know PHP but I think $_SERVER["REQUEST_URI"] is the same of request.env.request_uri URL(r=request,args=request,.args) there is no equivalent of script name. On Jun 25, 5:29 am, Fran wrote: > On Jun 25, 7:52 am, "Md.Mahbubur Rasheed" > wrote: > > > What is the equivalent of php $_SE

[web2py:24974] Re: xml

2009-06-25 Thread mdipierro
xml import? do not know. not a priority. On Jun 25, 1:44 am, pk wrote: > puh it`s to tricky... > i think i have to wait still there is a function to read the same xml > (for updating my tables) > which i generate automaticaly in my code. > massimo, when do you think will you release this functio

[web2py:24973] Re: NOT a web2py question

2009-06-25 Thread mdipierro
fantastic! On Jun 25, 1:23 am, Trollkarlen wrote: > Cleaner one: > > Just find replace into this: > tel = {"SPQ": "3[1,0-3]", "SPQ": "70(1-3)" } > > def get_operator(number): > import re > for key, value in tel: >   if re.match(value, number): >     return key > > pre-compile the re before with

[web2py:24972] Re: Firebird: welcome application registration page

2009-06-25 Thread mdipierro
Thanks Alexey On Jun 25, 1:23 am, Alexei Vinidiktov wrote: > I'm glad to report that 'password2' is now accepted by web2py auth in > revision 1072. > > Tested on my local Ubuntu box. > > > > On Thu, Jun 25, 2009 at 12:42 PM, mdipierro wrote: > > > I may have just fixed it. Could you please check

[web2py:24971] Re: Multiple Form functionality is Broken ??

2009-06-25 Thread Trollkarlen
Can this be the same problem as I described in the "web2py 1.64.3" mail. /R On Jun 25, 6:02 am, mdipierro wrote: > Please email me this (again?) so that I can reproduce the problem. > > Massimo > > On Jun 24, 10:51 pm, Yannick wrote: > > > Hello Massimo, > > Sorry to bother but was wondering i

[web2py:24970] db query problem

2009-06-25 Thread Robert Marklund
I would like to do a join but get results even if it was unsucessfull. Like this query = (db.images.id == db.image_info.image_id) & (db.images.id==db.image_keyword.image_id) & \ (db.keyword.id==db.image_keyword.keyword_id) I want to get the resulting rows even doe no keywords exis

[web2py:24969] error messages in Auth.change_password

2009-06-25 Thread Sebastian E. Ovide
Hi, Using Auth.change_password I noticed that if the 2 password do not match web2py is giving the message "invalid expression!" and if the password is not valid the message is "value not in database!". Is it possible to change those strings with some more user friendly ones ? thanks Sebastian E.

[web2py:24968] Antwort: [web2py:24967] Re: global logging to file

2009-06-25 Thread Johann . Scheibelhofer
Trying to attach the file in this posting. Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this grou

[web2py:24967] Re: global logging to file

2009-06-25 Thread Hans
Richard, the following solution works for me in production without any problems. I use it for periodic, unattended functions (cron). I've send Massimo the code in case he wants to include it into web2py or make it available as optional add-on download. Hans ''' To use the per application log

[web2py:24966] Re: web2py slides 1.64.4 typos

2009-06-25 Thread weheh
Massimo, thanks for the great new slides. However, could you please change the slides to black text on a white background? That way, we can print the presentation without burning through an ink/toner cartridge? --~--~-~--~~~---~--~~ You received this message because

[web2py:24965] Re: Newbie question : How to pass parameters from flash?

2009-06-25 Thread Fran
On Jun 25, 7:52 am, "Md.Mahbubur Rasheed" wrote: > What is the equivalent of php $_SERVER ??? I think $_SERVER["REQUEST_URI"] is replaced by URL(r=request) $_SERVER["SCRIPT_NAME"] is replaced by URL(r=request, c='script_name', f='function_within_script') F --~--~-~--~~-