Re: [web2py] Re: existing tables in plugin_wiki

got it. thanks. On 8/1/2012 11:38 AM, Massimo Di Pierro wrote: This is a bug in plugin_wiki but the bug is triggered by record_id: id id should be a number. On Wednesday, 1 August 2012 10:07:17 UTC-5, Larry Wapnitsky wrote: I'm attempting to access database tables created in my db.py fil

Re: [web2py] Re: existing tables in plugin_wiki

what about search? i specify one field to show, and it shows me all search fields? On 8/1/2012 11:38 AM, Larry G. Wapnitsky wrote: got it. thanks. On 8/1/2012 11:38 AM, Massimo Di Pierro wrote: This is a bug in plugin_wiki but the bug is triggered by record_id: id id should be a number

Re: [web2py] Re: LEFT JOIN query issues

grrr ...there's always something in a programming language! Thanks, Limedrop On 8/2/2012 5:43 PM, Limedrop wrote: This gets me every now and then... In python it should be "==" rather than "=" |left=db.mr_link.on(db.mr_link.recipID==db.recipient.id))| On Friday, August 3, 2012 8:08:38 AM UT

Re: [web2py] Re: Back-and-forth between DAL & SQLAlchemy

Thanks, Massimo. I'll give this a read and see if I can adapt it properly. As usual, your hard work is greatly appreciated. On 8/15/2012 6:34 PM, Massimo Di Pierro wrote: I meant this: http://web2py.com/AlterEgo/default/show/189 On Wednesday, 15 August 2012 14:22:36 UTC-5, Larry Wapnitsky w

Re: [web2py] Re: Back-and-forth between DAL & SQLAlchemy

mind if I post my SQLAlchemy code on Monday? I'm still a bit "off" with what I'm trying to accomplish in web2py. Thanks On 8/17/2012 3:41 PM, Massimo Di Pierro wrote: It depends on context. Web2py DAL is closer to SQL than on ORM. Assuming db.define_table('person',Field('name'),Field('email'))

Re: [web2py] Re: Back-and-forth between DAL & SQLAlchemy

also, do you think I might be better off doing this in MongoDB rather than MySQL/SQLAlchemy? On 8/17/2012 3:41 PM, Massimo Di Pierro wrote: It depends on context. Web2py DAL is closer to SQL than on ORM. Assuming db.define_table('person',Field('name'),Field('email')) you have two options: 1)

Re: [web2py] Re: quick SQL question

Not familiar with raw SQL. Fairly new to MySQL over the past year On 5/2/2012 1:49 PM, Richard Vézina wrote: Maybe raw SQL?? Richard On Wed, May 2, 2012 at 10:54 AM, Larry Wapnitsky > wrote: Here's the actual query: http://pastie.textmate.org/3848916

Re: [web2py] Re: quick SQL question

that's essentially what I did in code. On 5/2/2012 2:14 PM, Richard Vézina wrote: You could try also this : a = [ row.ipaddress for row in db().select(db.ips.ipaddress) if row.ipaddress.split('.')[3] == '35' ] db(db.ips.ipaddress.belongs(tuple(a))).select(db.ips.ipaddress).first().ipaddress

Re: [web2py] Re: plugin wiki issues

It's been working up to this point...not sure why it won't work now... On 5/8/2012 4:25 PM, villas wrote: Hi Larry, it sounds like your DB is not configured properly for your username. I don't use MySql but maybe this prob sounds familiar to those that do. Anyone? Sorry I can't think of any

Re: [web2py] Re: plugin wiki issues

and it just worked on my test db server with the exact same config.. On 5/8/2012 4:25 PM, villas wrote: Hi Larry, it sounds like your DB is not configured properly for your username. I don't use MySql but maybe this prob sounds familiar to those that do. Anyone? Sorry I can't think of anyt

Re: [web2py] Re: plugin wiki issues

nix that last comment...didn't have the plugin loaded. did not work On 5/8/2012 4:25 PM, villas wrote: Hi Larry, it sounds like your DB is not configured properly for your username. I don't use MySql but maybe this prob sounds familiar to those that do. Anyone? Sorry I can't think of anyt

Re: [web2py] Re: plugin wiki issues

even tried it as rootno dice. On 5/8/2012 4:25 PM, villas wrote: Hi Larry, it sounds like your DB is not configured properly for your username. I don't use MySql but maybe this prob sounds familiar to those that do. Anyone? Sorry I can't think of anything more D On Tuesday, 8 May

Re: [web2py] datatable plugin customization

I tried those, but documentation seems to be missing as well. On 5/8/2012 4:35 PM, Richard Vézina wrote: ho, I think those plugin could be quite outdated... If you really need a table plugin, look to Datatables or PowerTable (or PowerGrid : http://labs.blouweb.com/PowerGrid/) form Bruno. Th

Re: [web2py] datatable plugin customization

n_wiki, but I didn't touch it since a long time and to me it was so difficult to configure so I abandonned it. With DataTables, I definitely help set it up. Richard On Tue, May 8, 2012 at 4:36 PM, Larry G. Wapnitsky <mailto:la...@kvetsch.com>> wrote: I tried those, but documen

Re: [web2py] datatable plugin customization

etup jqgrid with plugin_wiki, but I didn't touch it since a long time and to me it was so difficult to configure so I abandonned it. With DataTables, I definitely help set it up. Richard On Tue, May 8, 2012 at 4:36 PM, Larry

Re: [web2py] Re: jqgrid assistance

right...realized that after I sent it (long day) any ideas? On 5/15/2012 9:53 AM, Massimo Di Pierro wrote: It is not really a comment: http://lachy.id.au/log/2005/05/script-comments On Monday, 14 May 2012 14:25:07 UTC-5, Larry Wapnitsky wrote: Here's what it's generating: | White

Re: [web2py] Re: alternates to pyjamas/pyjs?

stefaan- As I just posted on the pyjs group (with a stupid typo :)): pyjs was installed from git. 1) hulahop doesn't work. 2) error message when running the following: ['/home/lwapnitsky/workspace/pyjamas/eclipse_build.py', '-d', '-I /home/lwapnitsky/workspace/pyjamas', 'test.py'] Tracebac

Re: [web2py] Re: alternates to pyjamas/pyjs?

solved some of the issues...time to get crackin'! On 5/30/2012 12:01 PM, stefaan wrote: I cannot help much with the hulahop (that's needed for pyjd only, which i haven't used myself). I normally compile on the command line, using the pyjsbuild tool found inside the pyjamas/bin folder, and tes

Re: [web2py] Is anyone using GWT?

Cool. If you have any tips for the n00b to Pyjs, send them my way (privately, not via the group so that we don't clog this up). On 6/7/2012 12:41 PM, Carl Roach wrote: > Larry, I really enjoyed coding in Pyjs. GWT/Java involves a lot of > hoops which I'm jumping through. I'm looking at porting m

Re: [web2py] Re: 1.99.4 Active Directory LDAP Issue

genius! I just need to read through and figure out how to do the proper name/group mapping from AD to web2py. Great framework, BTW, Massimiliano! On 2/23/2012 8:08 AM, Massimiliano wrote: auth.settings.create_user_groups = False

Re: [web2py] Re: multiple 'requires'

you are a god amongst men! thank you! On 2/23/2012 12:19 PM, Niphlod wrote: db.ips.ipaddress.requires = [IS_NOT_IN_DB(db, 'ips.ipaddress')] db.ips.ipaddress.requires.append(IS_IPV4())

Re: [web2py] inserting username into database

The issue is not putting the username into the web2py database, but another database that's storing information. On 2/23/2012 2:32 PM, Richard Vézina wrote: I am not sure how you connect to LDAP, but there is utilities to connect LDAP with web2py. You should read about those in the book search

Re: [web2py] inserting username into database

#x27;), Field('b_or_w', 'string', length=1), migrate=False) db.ips.ipaddress.requires = [IS_NOT_IN_DB(db, 'ips.ipaddress')] db.ips.ipaddress.requires.append(IS_IPV4()) the field 'reportedby' needs to be filled in with the username taken from AD for the logged in user. On 2/2

Re: [web2py] inserting username into database

ill have to change also the type of the field for : list:reference type See book chapter 6 whit keyword list:reference Richard On Thu, Feb 23, 2012 at 2:43 PM, Larry G. Wapnitsky <mailto:la...@kvetsch.com>> wrote: I need to have the username added to another SQL table on su

Re: [web2py] inserting username into database

.auth_user" and by the way that was wrong model definition I didn't catch at first read... Richard On Thu, Feb 23, 2012 at 2:53 PM, Larry G. Wapnitsky mailto:la...@kvetsch.com>> wrote: it's only one user that I need to enter into the database at a

Re: [web2py] inserting username into database

o it works. Richard On Thu, Feb 23, 2012 at 3:07 PM, Larry G. Wapnitsky <mailto:la...@kvetsch.com>> wrote: I'm pretty lost in everything you've described. I've been working with web2py for 2+ days and am slowly getting the hang of it. If you could dumb it

Re: [web2py] inserting username into database

an other for your other program that access ips table. Then you will have to trigger data synchronisation between the 2 tables. Richard On Thu, Feb 23, 2012 at 3:16 PM, Larry G. Wapnitsky <mailto:la...@kvetsch.com>> wrote: I apologize, but there is a bit of a language barrier he

Re: [web2py] inserting username into database

ronisation between the 2 tables. Richard On Thu, Feb 23, 2012 at 3:16 PM, Larry G. Wapnitsky <mailto:la...@kvetsch.com>> wrote: I apologize, but there is a bit of a language barrier here. What you've written is very confusing to me On 2/23/2012 3:14 PM, Richard Véz

Re: [web2py] inserting username into database

that works even better than what I found. Thanks, Anthony! On 2/23/2012 3:48 PM, Anthony wrote: db.define_table('ips', Field('id', 'id'), Field('ipaddress','string', length=15, unique=True), Field('dateadded', 'datetime', default=request.now), Field('reporte

Re: [web2py] Re: DAL validation issue

Thanks, Niphlod. Still learning, and asking questions is how I do it. I'll work on your suggestions from this and the other thread. On 3/20/2012 5:10 PM, Niphlod wrote: You are using validators in the wrong way, and also the forms in a twisted one.maybe a little refresh reading the book i

Re: [web2py] Re: Two forms, one page

Thanks, Niphlod & pbreit. Still learning, and asking questions is how I do it. I'll work on your suggestions f FYI, Niphlod - this is the same app as in the other thread. On 3/20/2012 5:38 PM, Niphlod wrote: why not using SQLFORM.factory for having one form for all the data ? in the control

Re: [web2py] Re: Customizing a widget

Thank you, Bruno and Anthony. Perfect. On 3/27/2012 12:06 PM, Anthony wrote: You can use a dictionary, list of tuples, or a separate "labels" argument: IS_IN_SET({'b':'black', 'w':'white'}) IS_IN_SET([('b', 'black'), ('w', 'white')]) IS_IN_SET(['b', 'w'], labels=['black', 'white']) Anthony

[web2py] pop-up verification

Last question of the day, I promise... So, I have data that exists in my database. If a user enters a value that already exists, I want to prompt them with an "are you sure?" type question before the function that adds/updates the data continues. How do I interrupt my current function to do