[web2py] Re: Reverse Search with .like

2010-05-07 Thread Russell
You might want to try something like this:. from gluon.sql import Expression db(table1.field1.like(Expression("('%' || table2.field2 || '%')".select(db.table1.field1) Not very pretty, but it does work. On May 8, 9:13 am, mdipierro wrote: > Can you try > > from gluon.sql import Quer

[web2py] Re: Downloading from "private" folder

2010-06-23 Thread Russell
If you look at the ReportLab example in chapter 9 of the book, it uses the private folder to make the PDF file, which is then deleted. So I guess that private is for temporary working stuff - a folder that can be cleaned out if necessary. And, if such a file is worth keeping, I guess it should be

[web2py] Re: dynamically growing form?

2010-06-23 Thread Russell
I would create a form with all 10 rows, hide all but the first 2 rows, and then use jquery to progressively display the rest of the rows. Add something like this to each of the rows... form.element(_id=this_reference_id).append( A(' add', _href='#', _onclick="jQuery('#%s').show()" % next_reference

[web2py] Re: upload bug in filename

2010-06-24 Thread Russell
As an aside, the mixing of \\ and / is unsightly but does not seem to cause a problem on widows. If you want to tidy it up, it's around line 786 of main.py: request.folder = os.path.join(request.env.web2py_path, 'applications', request.application) + '/' On Jun 25, 11:15 am, Y

[web2py] Re: trying to get email to work

2010-02-03 Thread Russell
Just curious...The code shows the mail.send routine in a loop and the whole thing could take some time to run. Should there be some limit to the number of records that can be thrown into such a loop? About how many records before this sort of thing should be handed off to a daemon? On Feb 4, 4:

[web2py] Re: call response.flash = "smoething" from view

2010-02-06 Thread Russell
Try this if you want to make yourself a loading gif... http://www.ajaxload.info/ On Feb 6, 6:24 pm, Iceberg wrote: > Elegant and universal! Exactly what I am looking for. Thanks! > > On Feb6, 1:35am, sveinh wrote: > > > If I understand you correctly, you want to indicate to the user that > > i

[web2py] UnicodeDecodeError sending email

2010-02-07 Thread Russell
luon\tools.py", line 281, in send text = text.decode(encoding).encode('utf-8') File "c:\Python25\Lib\encodings\utf_8.py", line 16, in decode return codecs.utf_8_decode(input, errors, True) What's changed? Thanks Russell -- You received this message because you are subscr

[web2py] Re: csv import

2010-02-15 Thread Russell
My experience with CSV import suggests that you need to delete the id column. Also the lack of validation is a bit of a trap...once I edited an exported CSV with MS Excel, which silently reformatted all the dates to something like 1/2/2010. The edited file was 'successfully' imported into SQLite

[web2py] Re: Long running tasks queue

2010-02-19 Thread Russell
Would it be possible to start/stop/monitor such a background process from admin? If so, it would seem to be generically useful and a powerful compliment to cron. A plug-in perhaps? On Feb 19, 10:06 am, mdipierro wrote: > I would not use cron for this. cron starts a job at reguar intervals > bu

[web2py] Re: Any way to close a window from the controller?

2010-02-19 Thread Russell
You could use javascript for this. The command is 'top.close()' For example, say you want the window to close as soon as the controller has done it's work... $(document).ready(function() { top.close(); }); Alternatively if you wanted more control, you could return top.close() from the web2py

[web2py] local_import works on windows, fails on Linux

2010-03-08 Thread Russell
I have a local module in /web2py/applications/test/modules/helpers.py Which is imported like this: h = local_import('helpers', reload=True) This works on my windows box, but fails when I moved the application to Linux: File "gluon/compileapp.py", line 258, in local_import_aux(name,reload

[web2py] Re: local_import works on windows, fails on Linux

2010-03-08 Thread Russell
n Mar 9, 10:31 am, Russell wrote: > > > I have a local module in /web2py/applications/test/modules/helpers.py > > > Which is imported like this: > > > h = local_import('helpers', reload=True) > > > This works on my windows box, but fails when I moved

[web2py] Re: how to access db from module

2010-03-09 Thread Russell
You might need to import the DAL? >From >http://groups.google.com/group/web2py/browse_thread/thread/159b44bfbb634df2/83751f3fd6e51578 from gluon.sql import DAL, Field db=DAL('sqlite://storage',folder='/path/to/databases/folder/') db.define_table() etc. etc. On Mar 10, 12:43 pm,

[web2py] Re: How to use SUM()

2010-03-09 Thread Russell
The number is stored in a dictionary called '_extra'. The top part of what you are getting is the dictionary key. Do something like this to get just the number... row = db(...).select(db.some_table.amount.sum())[0] answer = row.'_extra['SUM(some_table.amount) '] See pg 169 of the book. On Mar

[web2py] Re: how to access db from module

2010-03-10 Thread Russell
s new feature - thanks. > > However my tables rely on auth, which relies on being passed globals() > containing request, response, and session. Will I need to fake them? > > On Mar 10, 11:01 am, Russell wrote:> You might > need to import the DAL? > > > Fromhttp://groups.g

[web2py] using functions in an update query

2010-03-16 Thread Russell
le of how to do this with the DAL? Thanks Russell -- 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...@google

[web2py] Re: using functions in an update query

2010-03-16 Thread Russell
27;Tiger Woods') > > > or > > > [p.update(product_name = 'Tiger Woods') for p in > > db(db.products.id>0).select()] > > > On Mar 16, 12:06 pm, Russell wrote: > > > > Hi, > > > > I'm trying to update some text fields in a da

[web2py] prepend a string to a field

2010-03-24 Thread Russell
ile "", line 1, in TypeError: cannot concatenate 'str' and 'Expression' objects I have found a work-around, but it is pretty ugly: >>> db(db.person.id>0).update(name = db.person.name[0:0] + "x" + db.person.name) Does anyone have a better sol

[web2py] Re: prepend a string to a field

2010-03-24 Thread Russell
"%s%s" % ("x",db.person.name)) > > On Mar 24, 9:57 pm, "mr.freeze" wrote: > > > Try this: > > db(db.person.id>0).update(name = "%s%s" % (db.person.name,"x")) > > > On Mar 24, 9:52 pm, Russell wrote: >

[web2py] Re: prepend a string to a field

2010-03-24 Thread Russell
A bigger problem... On further testing, it looks like db(db.person.id>0).update(name = db.person.name + "x") does NOT work. The DAL seems to treat this as an integer addition and the field is updated to 0 (at least on sqlite). On Mar 25, 4:11 pm, Russell wrote: > Thanks v

[web2py] Re: prepend a string to a field

2010-03-24 Thread Russell
gluon.sql import Expression > > db(db.person.id>0).update(name = Expression('person.name || "x"')) > > > I'm almost positive there is a better way. > > > On Mar 24, 10:43 pm, Russell wrote: > >> A bigger problem... > > >> O

[web2py] Re: problems using web2py ajax function

2010-03-28 Thread Russell
Is there a reason not to simply place the constant in the args? ajax('show_month/3',[],'test') or if you want to be explicit... ajax('show_month?month_to_show=3',[],'test') On Mar 29, 4:24 am, mdipierro wrote: > Normally if I want to pass a constant, I put it in a hidden field and > then pass t

[web2py] Re: new SQLFORM

2010-04-05 Thread Russell
Just a thought... It occurs to me that, as SQLFORM is a set of fields, wouldn't it be better if SQLFORMs had their own widget class? It would allow for customization and, potentially you could then combine SQLTABLE with SQLFORM into one tidy concept. By this I mean that SQLTABLE could deliver a

[web2py] jquery submit within LOAD

2010-04-23 Thread Russell
Blah I've tried butting an ID on the loaded form but this doesn't seem to help. Thanks Russell -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

[web2py] Re: jquery submit within LOAD

2010-04-24 Thread Russell
how to. If you find out a way I would take a patch to > support it. > > Massimo > > On Apr 23, 11:59 pm, Russell wrote: > > > Hi, > > > When I put an onchange submit into an {{=LOAD()}} it seems to submit > > the main page's form and not the LOADed form.

[web2py] Can't customise auth email validators

2010-04-25 Thread Russell
il_custom_validators: table_user[username].requires = tmpvalidator Thanks Russell -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

[web2py] Re: Can't customise auth email validators

2010-04-25 Thread Russell
Okay, I've thought more about this and can see why you might want to overwrite the validators...you don't want IS_NOT_IN_DB(db, auth_table.email) validation on login! So maybe just a case-sensitive flag? On Apr 26, 12:01 pm, Russell wrote: > Hi, > > Auth.login overwrit

[web2py] Re: Can't customise auth email validators

2010-04-25 Thread Russell
auth.settings.register_onvalidation = login_email_lower auth.settings.verify_email_onvalidation = login_email_lower On Apr 26, 12:34 pm, mdipierro wrote: > I will look into this. > > On Apr 25, 7:26 pm, Russell wrote: > > > Okay, I've thought more about this and can see why you might want to >

[web2py] Re: Cannot compile: there are errors in your app:

2010-04-30 Thread Russell
You might want to check any dynamic {{extend}} statements within your views. When the app is compiled the views are 'extended' but any paths based on run-time objects just don't work. For example this works uncompiled... {{extend os.path.join(request.controller, 'custom_layout.html')}} But it w

[web2py] Re: Wiki example from book on gae

2010-05-01 Thread Russell
Initially this example didn't run for me on postgresql. I assume that this is because 'page' is a reserved word...changed the table name to 'webpage' and all was good. On May 2, 7:04 am, mdipierro wrote: > If you comment this line: > > db.document.page_id.requires = IS_IN_DB(db, 'page.id', '%(ti

[web2py] Re: How to get current user_id and group_id?

2010-05-01 Thread Russell
auth.user_id and auth.user_group(auth.user_id) On May 2, 12:37 pm, Sverre wrote: > How can I retrieve current user_id and group_id? I need the to put the > ownership of something into a table.

[web2py] Re: Weird Behavior - Query returning zero rows when it should return all rows

2010-08-18 Thread Russell
Use 'T' or 'F' rather than 'True' of 'False'. Web2py saves boolean data as 'char' with length 1. On Aug 19, 1:49 am, Narendran wrote: > Hi, > I added a new boolean field to a table. And I manually updated the > value of the field outside web2py. Now, I get zero rows for any > condition I put on

[web2py] Re: build a row base questionnaire

2010-08-22 Thread Russell
In my experience, it is a bit awkward to do this using SQLFORM. You could try something like this: db.define_table('q_and_a', Field('question'), Field('answer')) rows = db(db.q_and_a.id>0).select() import random random.seed() asked = random.sample(rows, 3)) form=SQLFORM.factory( Fi

[web2py] Re: build a row base questionnaire

2010-08-23 Thread Russell
;',limitby=(0,3)) >     form=SQLFORM.factory(*[Field('a%s'%i, label = a.question) for i,a > in enumerate(asked)]) >     if form.accepts(request.vars,session): >            score = sum((check(a.answer,request.vars.get('a%s'%i,'')) > for i,a in en

[web2py:29533] Re: Modifying form auth.register() to display Password2 label

2009-08-27 Thread Russell
The example on the bottom of page 212 in the new book shows you how to do it. On Aug 27, 6:40 pm, ed wrote: > Hi, > It tried modifying the default.py auth.register() form with the > following code: > def user(): >     if request.args(0)=='register': >         response.flash=T('Register') >      

[web2py:31766] IS_EMAIL() validation bug?

2009-09-27 Thread Russell
ever.com', 'invalid email!') In[1]: IS_EMAIL()('@whatever.com') Out[1]: ('@whatever.com', None) Thanks Russell --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py:32421] Re: FORM factory

2009-10-07 Thread Russell
Personally, I like the way the widget renders the error by default - it's pretty tidy and does what you want most of the time. If you want to remove the error from the widget you could look at the section called "Switch off errors" on page 220 of the manual. On Oct 8, 5:03 am, Thadeus Burgess w

[web2py:33896] auth.settings.controller is not backward compatible

2009-10-27 Thread Russell
Hi, Upgrading to Version 1.68.2 broke the Auth in my applications. The bug: when a user is visiting a controller other than 'default' and the the login cookie expires, the ?_next parameter incorrectly bounces them back to the 'default' controller. I've narrowed it down to the new auth.settings.

[web2py:34014] DAL Rows as dictionary?

2009-10-28 Thread Russell
Hi, The DAL Rows object returned by select is a list. But often a dictionary with id as the key is what is needed (ie, a frequently used lookup table). Typically I do this... item_list = db(db.items.id > 0).select() item_dict = {} for item in item_list: item_dict[item.id] =

[web2py:34632] Does your Response Flash get in the way?

2009-11-04 Thread Russell
s).fadeOut('slow'); return false; }); with: jQuery('.flash').hide().fadeIn(2000).animate({opacity: 1.0}, 2000).animate({ opacity: 'hide' }, 2000); This makes the response.flash fade in and then fade out. No clicking required. Thanks Russell --~--~-~-

[web2py:34685] Re: Does your Response Flash get in the way?

2009-11-05 Thread Russell
It does seem that a nice solution would be to position or shrink the flash message on the default layout so that it is unlikely to cover text. But it maybe we are trying to do too much with the flash message? There are some messages that only deserve a quick 'flash' - like 'logged in'. But ther

[web2py:13699] form_factory on GAE

2008-12-16 Thread Russell
Hi there, This function works on the web2py server, but throws a syntax error on GAE. def _test(): from gluon.sqlhtml import form_factory form=form_factory(SQLField('email')) return dict(form=form) Here's the traceback... ERROR2008-12-17 02:49:20,437 main.py] Traceback (most re

[web2py:13721] Re: form_factory on GAE

2008-12-17 Thread Russell
    ... >     db.define_field(...,db.Field(),...) > > so that you never import and use SQLField from gql.py > > On Dec 16, 9:22 pm, Russell wrote: > > > Hi there, > > > This function works on the web2py server, but throws a syntax error on > > GAE. > &

[web2py:20514] Re: SQLFORM

2009-04-25 Thread Russell
You might want to look at this thread... http://groups.google.co.nz/group/web2py/browse_thread/thread/405c0bcfc6a2df2f It shows how you can have several "submit" buttons and then use your controller to dynamically determine the specific redirect. On Apr 25, 6:24 pm, jmverm...@xs4all.nl wrote:

[web2py:21725] HTML helpers, TAG, cpickle, colgroup

2009-05-12 Thread Russell
D(),TBODY()) >>> print table When something like this would seem the preferable result... I know the work-around is to split it into two steps with "table.insert (0,TAG.colgroup())", but that does seem a little messy (and the

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-16 Thread Russell
Hi, I've had this problem come up quite a few times. It appears to be a migration issue and is usually fixed by this... auth.define_tables(migrate=False) Thanks Russell On Nov 17, 8:48 am, Carlos wrote: > Hi Massimo, > > I'll send you the requested files if/when I get

[web2py] Re: prevent post on reload

2011-01-16 Thread Russell
This JavaScript will refresh the page without reposting the data: window.location = window.location; On Jan 17, 4:04 am, weheh wrote: > I'm using components, not typical web2py way of doing things. > > On Jan 16, 3:51 am, Kenneth Lundström > wrote: > > > But isn t web2py taking care of this alr

[web2py] Re: SQLFORM.factory - RuntimeError: you must specify a Field(...,uploadfolder=...)

2011-03-29 Thread Russell
I've just been struck by the same issue when upgrading to Version 1.94.6 (2011-03-27 18:20:38). To be clear, this used to work, but does NOT work anymore: form=SQLFORM.factory(Field('document', 'upload')) This works on the current version: form=SQLFORM.factory(Field('document', 'upload', uploadfo

[web2py] Re: Best practice to start background process

2011-04-27 Thread Russell
I think that a simple system cron is the most reliable (per minute, per hour, per day). Then use some type of locking mechanism in your web2py script (either database or file). For example: locked = db((db.report_queue.status=='SystemLock')).select().first() if not locked: locked = db.report

[web2py] Re: Need advice on Cron in production

2011-05-17 Thread Russell
This works for me. I have a system crontab like this... */5 * * * * python /home/www-data/web2py/web2py.py -S init -M -N -R / home/www-data/web2py/applications/init/modules/cron.py And cron.py runs just like it should. Here's a basic layout that you can use to test it's working... ==modules/cr

[web2py] Re: Need advice on Cron in production

2011-05-17 Thread Russell
Yes, I have two lines in the crontab. A five minute one, and a daily one... */5 * * * * python /home/www-data/web2py/web2py.py -S init -M -N -R / home/www-data/web2py/applications/init/modules/scripts/cron_fivemin.py 1 22 * * 1-5 python /home/www-data/web2py/web2py.py -S init -M -N -R / home/www

[web2py] Re: Strange Error: Field does not belong to the table

2011-06-16 Thread Russell
Looks like the form.accepts is trying to update the database with the is_administrator value. You may need to deal with the update explicitly. Have you tried form.accepts(request.vars, session, dbio=False)? On Jun 14, 1:21 pm, Ross Peoples wrote: > I am trying to provide an editor for auth_use

Re: [web2py] Re: nyroModal

2011-11-06 Thread Russell McMurray
It works for me. 2011/11/5 Kenneth Lundström > Hi Russell, > > Have you defined nyroModalRemove somewhere? I'm getting > "parent.$.nyroModalRemove is not a function" when using your suggested > three lines. > > > Kenneth > > return_sc

Re: [web2py] 3 forms in 1

2013-06-18 Thread Tom Russell
Yes I was just reading and understood that the reason for my fields not showing up was because the fields in many of the tables have the same names. Changing that resolved that issue. It's actually a great book too, just wished I could read faster. Thanks. On Tue, Jun 18, 2013 at 1:04 PM, Richa

Re: [web2py] Re: 3 forms in 1

2013-06-18 Thread Tom Russell
Yes I am using smartgrid elsewhere, very nice. I did do the 3 forms but used the factory to do it. Works nicely so far. On Tue, Jun 18, 2013 at 1:24 PM, villas wrote: > I don't believe you can use SQLFORM in that way, you'll have to create > your own form - maybe try SQLFORM.factory. Better s

Re: [web2py] Re: SmartGrid

2013-06-19 Thread Tom Russell
aha that would be it. On Wed, Jun 19, 2013 at 5:26 PM, Niphlod wrote: > are you logged-in ? > For security reasons any modification to tables in grids is prevented on > anonymous access. > You can still give "write permissions" using user_signature=False, but > it's highly discouraged > > On We

[web2py] Change form layout

2013-06-24 Thread Tom Russell
I have a SQLForm and use the formset DIV for it but its not what I really want. Rather than having just one column with all of the fields required to be filled out, how do I set it so its like 3-4 columns? For example: Name Address City State Instead of: Name Address City State

Re: [web2py] Re: Change form layout

2013-06-24 Thread Tom Russell
/d/msg/web2py/QmoRmapiOwA/tZqeEbii6QgJ > > Anthony > > > On Monday, June 24, 2013 8:53:16 AM UTC-4, Tom Russell wrote: >> >> I have a SQLForm and use the formset DIV for it but its not what I really >> want. Rather than having just one column with all of the fields req

Re: [web2py] Re: Change form layout

2013-06-24 Thread Tom Russell
> > > On Monday, June 24, 2013 9:35:31 AM UTC-4, Tom Russell wrote: > >> Thanks for the response. So now I am really confused because I have no >> idea where to put this code if I am using a SQLFORM.factory? >> >> Basically I just want to add row fluid to make t

Re: [web2py] Re: Change form layout

2013-06-24 Thread Tom Russell
LFORM(..., formstyle=myformstyle) > > Anthony > > > On Monday, June 24, 2013 10:07:49 AM UTC-4, Tom Russell wrote: > >> Thanks for the responses. >> >> The formstyle looks interesting but I cannot make heads or tails out of >> the way to use it. Are there any examples

Re: [web2py] Re: Change form layout

2013-06-24 Thread Tom Russell
Ah, I see now. Thanks On Mon, Jun 24, 2013 at 10:50 AM, Anthony wrote: > No, 3 columns means: > > Col 1 Col 2 Col 3 > label widget comment > > It's still one field per row. When in doubt, try it out. :-) > > Anthony > > > On Monday, June 24, 201

[web2py] SQLForm Factory

2013-06-24 Thread Tom Russell
If I have a form factory with 3 tables, how would I define the fields I wanted shown for each? This is the code for my controller. I have tried to set it in several spots but all of them throw an error. def register_patient(): mark_not_empty(db.patient) mark_not_empty(db.emergencycontacts

Re: [web2py] Re: SQLForm Factory

2013-06-24 Thread Tom Russell
ctory() can take a list of specific fields rather than entire tables. > > Anthony > > > On Monday, June 24, 2013 11:15:28 AM UTC-4, Tom Russell wrote: >> >> If I have a form factory with 3 tables, how would I define the fields I >> wanted shown for each? >> >>

Re: [web2py] Re: SQLForm Factory

2013-06-24 Thread Tom Russell
individual fields instead of entire tables: > > SQLFORM.factory(db.mytable.myfield, db.mytable.myotherfield, db.wholetable > ) > > Anthony > > > On Monday, June 24, 2013 11:49:43 AM UTC-4, Tom Russell wrote: > >> I tried doing the specific fields like: >> >> f

Re: [web2py] Re: SQLForm Factory

2013-06-24 Thread Tom Russell
Ah yes both readable and writable have to be defined. Thanks again On Mon, Jun 24, 2013 at 6:12 PM, Anthony wrote: > Try writable=False. > > > On Monday, June 24, 2013 6:04:43 PM UTC-4, Tom Russell wrote: > >> Thanks for the tip. >> >> I did set one f

[web2py] Form Field

2013-06-24 Thread Tom Russell
I have a form and I load a pre existing value that I generate internally before I call the form. What I want to see on the form is the value shown up but just as plain text so the user cannot modify it. If I do readable-False then it just shows None for the value rather than the value. How would I

Re: [web2py] Re: Form Field

2013-06-24 Thread Tom Russell
readable at True in order to show the value but not allow it to be > edited. > > Anthony > > > On Monday, June 24, 2013 11:00:59 PM UTC-4, Tom Russell wrote: >> >> I have a form and I load a pre existing value that I generate internally >> before I call the form. Wh

Re: [web2py] Re: Form Field

2013-06-24 Thread Tom Russell
t; use the method I showed (i.e., set the default value for the field before > creating the form). > > Anthony > > > On Monday, June 24, 2013 11:23:01 PM UTC-4, Tom Russell wrote: > >> Yes I tried that: >> >> Field('medical_record_number', label=&#x

Re: [web2py] Re: Form Field

2013-06-24 Thread Tom Russell
l submit > a value for that field if they are determined, so you might want to check > for that variable on the server and delete it if submitted. > > Anthony > > > On Tuesday, June 25, 2013 12:15:04 AM UTC-4, Tom Russell wrote: > >> I ended up doing this in the

Re: [web2py] Re: Form Field

2013-06-24 Thread Tom Russell
ome_value > db.mytable.myfield.writable = False > > Anthony > > On Tuesday, June 25, 2013 1:02:40 AM UTC-4, Tom Russell wrote: > >> Yes I understand that. What would be the best way to handle this? >> Seemingly, the couple of items suggested did not work for me s

[web2py] Confused about app

2013-06-24 Thread Tom Russell
So I took and modified the welcome app to my needs and added another app. If I login with the welcome app and with a link, open the other app and have it set with auth.requires_login(), it requires the user to login again. How does one handle this stuff in web2py? Do I need another app the way I ha

Re: [web2py] Re: Confused about app

2013-06-25 Thread Tom Russell
> http://web2py.com/books/default/chapter/29/09#Central-Authentication-Service > > Il giorno martedì 25 giugno 2013 07:51:08 UTC+2, Tom Russell ha scritto: > >> So I took and modified the welcome app to my needs and added another app. >> If I login with the welcome app and

[web2py] Multi Table Form

2013-06-25 Thread Tom Russell
I have the following form that uses 3 different tables and when I submit the data it all seems to submit correctly but when I view the data in a smart grid with linked tables in the columns clicking on the link does not show any record for the row of linked data. My smartgrid code: def manage_pat

Re: [web2py] Re: Confused about app

2013-06-25 Thread Tom Russell
did implement the CAS stuff but now I get an error saying 'DAL' object has no attribute 'auth_user' for the app I have. On Tue, Jun 25, 2013 at 10:53 AM, Anthony wrote: > On Tuesday, June 25, 2013 10:12:32 AM UTC-4, Tom Russell wrote: > >> Well agreed, but I set

Re: [web2py] Re: Confused about app

2013-06-25 Thread Tom Russell
ect has no attribute 'auth_user' On Tue, Jun 25, 2013 at 11:14 AM, Anthony wrote: > On Tuesday, June 25, 2013 11:04:22 AM UTC-4, Tom Russell wrote: > >> Yes I customized welcome and then added a new app via the admin >> interface. I did not directly copy the welc

[web2py] Smartgrid Links

2013-06-25 Thread Tom Russell
I have a smartgrid with a link like so: links = [lambda row: A(T('Create Appointment'),_href=URL("AppointmentManager","appointment_create",args=[ row.id]))] grid = SQLFORM.smartgrid(db.patient, deletable=True, editable=True, create=True, maxtextlength=64, paginate=25, links=links, links_i

Re: [web2py] Re: Confused about app

2013-06-25 Thread Tom Russell
Ah, I forgot to add the following line to my consumer app: auth = Auth(db,cas_provider = ' http://127.0.0.1:8000/welcome/default/user/cas') On Tue, Jun 25, 2013 at 10:12 AM, Tom Russell wrote: > Well agreed, but I set that up in the welcome app so it would seem like > that sho

Re: [web2py] Re: Smartgrid Links

2013-06-25 Thread Tom Russell
("AppointmentManager", "yourcontroller", "appointment_create", args=[ > row.id]) > > You can also used keyword arguments "a", "c", and "f" with URL(). > > Anthony > > On Tuesday, June 25, 2013 12:08:57 PM UTC-4, Tom Russell wr

[web2py] SQLFORM.smartgrid

2013-06-25 Thread Tom Russell
Another question on the smartgrid. I have linked tables in my smartgrid like: grid = SQLFORM.smartgrid(db.patient, deletable=True, editable=True, create=False, maxtextlength=64, paginate=25, links=links, links_in_grid=True, linked_tables=['emergencycontacts','dependents']) When clicking on t

Re: [web2py] Re: SQLFORM.smartgrid

2013-06-26 Thread Tom Russell
IN_DB(db,'field.id > ','%(patient)s')), > > > On Wednesday, 26 June 2013 10:36:03 UTC+5:30, Tom Russell wrote: >> >> Another question on the smartgrid. >> >> I have linked tables in my smartgrid like: >> >> grid = SQLFORM.smartgri

Re: [web2py] Re: SQLFORM.smartgrid

2013-06-26 Thread Tom Russell
7;Son', 'Daughter', 'Other'])), ) db.define_table( 'emergencycontacts', Field('patient','reference patient', writable=False, readable=False), Field('em_first_name', label='First Name'), Field('em_mi

Re: [web2py] Re: SQLFORM.smartgrid

2013-06-26 Thread Tom Russell
"represent" attribute > for any reference fields that reference this table. > > Anthony > > > On Wednesday, June 26, 2013 10:24:32 AM UTC-4, Tom Russell wrote: > >> db.define_table('patient', >> #db.patient.id.readable=False # Since we

[web2py] Add button to smartgrid?

2013-06-26 Thread Tom Russell
I need to add a button to the smartgrid but not like doing create=True because I have a form factory that has 2 other tables associated with the one. I know in html I can simply add a line for a button but since I am not using html for this how would I add a button to that page to reference my own

Re: [web2py] sqlform.factory widget in field problem

2013-06-26 Thread Tom Russell
To group inside a field I do something like this with 3 different tables: form=SQLFORM.factory(db.patient, db.emergencycontacts, db.dependents) fs0=form[0][:26] #patient rows fs1=form[0][26:37] #emergency contacts fs2=form[0][37:41] #dependents fs3=form[0][-1] # submi

[web2py] Ref another table in another app

2013-06-26 Thread Tom Russell
How would I do this: I need to create an appointment for a patient so from my list of patients i have a link to call another app to do the appointment. I have the link set so it looks like this: links = [lambda row: A(T('Create Appointment'),_href=URL("AppointmentManager","default", "appointment_

Re: [web2py] sqlform.factory widget in field problem

2013-06-26 Thread Tom Russell
Saved mine too, got it originally from http://www.web2pyslices.com/slice/show/1457/adding-fieldset-and-legend-to-forms On Wed, Jun 26, 2013 at 12:39 PM, António Ramos wrote: > That is a very clever solution. > Saved my day. > > Thank you > > > > > 2013/6/26 Tom

[web2py] Appointment Manager

2013-06-26 Thread Tom Russell
I am using the appointment manager from https://github.com/mdipierro/web2py-appliances/tree/master/AppointmentManager . I have tweaked it to my needs and works well so far but there is an issue trying to use SQLFORM.grid. I get an error () takes exactly 1 argument (2 given) by doing this: def

Re: [web2py] Appointment Manager

2013-06-26 Thread Tom Russell
>> a simple json feed function returning a well formatted json object with >> simplejson dump. >> >> Richard >> >> >> On Wed, Jun 26, 2013 at 12:55 PM, Tom Russell wrote: >> >>> I am using the appointment manager from >>> https://gith

Re: [web2py] sqlform.factory widget in field problem

2013-06-26 Thread Tom Russell
Another solution can be: {{extend 'layout.html'}} Education CV {{=education_form}} Student {{=student_form}} School {{=school_form}} On Wed, Jun 26, 2013 at 12:47 PM, Tom Russell wrote: > Saved mine too, got it originally from > http://www.web2pyslices.com/slice/show/1457

Re: [web2py] Appointment Manager

2013-06-26 Thread Tom Russell
>> "{{=T('October')}}", >> "{{=T('November')}}", >> "{{=T('December')}}"], >> dayNames: ["{{=T('Sunday')}}", >>

[web2py] JQuery Issue

2013-06-26 Thread Tom Russell
I cannot seem to get some jquery code to work right and not sure why. Basically when I click a checkbox I want another field to appear below that one. This is my form code: @auth.requires_login() def register_patient(): mark_not_empty(db.patient) mark_not_empty(db.emergencycontacts) m

Re: [web2py] Re: JQuery Issue

2013-06-27 Thread Tom Russell
#x27;).hide(); >}); > }); > }); > > > On Wednesday, June 26, 2013 9:09:00 PM UTC-5, Tom Russell wrote: >> >> I cannot seem to get some jquery code to work right and not sure why. >> Basically when I click a checkbox I want another field to appear below that &

Re: [web2py] Re: JQuery Issue

2013-06-27 Thread Tom Russell
k thanks I will try that On Thu, Jun 27, 2013 at 10:58 AM, Jim Steil wrote: > I'd try putting some alert() messages in to try to trace the flow and > check the values of variables. > > > > On Thu, Jun 27, 2013 at 9:53 AM, Tom Russell wrote: > >> Thats wei

Re: [web2py] Re: JQuery Issue

2013-06-27 Thread Tom Russell
So If I do something like: jAlert('This is a custom alert box', 'Alert Dialog'); and nothing shows up, could it be that the jquery lib is not being made available? On Thu, Jun 27, 2013 at 11:00 AM, Tom Russell wrote: > k thanks I will try that > > > > On

[web2py] Use model in another app

2013-06-27 Thread Tom Russell
I have 2 apps and one I want to use the model/db from it in the other in a SQLFORM.grid. I have read through and googled and cannot find a way to do this. Is this possible and how? Thanks, Tom -- --- You received this message because you are subscribed to the Google Groups "web2py-users" gr

Re: [web2py] Re: JQuery Issue

2013-06-27 Thread Tom Russell
on in > your page (with javascript) that is preventing the execution of your stuff > later on. > > -Jim > > On Thursday, June 27, 2013 10:26:56 AM UTC-5, Tom Russell wrote: > >> So If I do something like: >> >> jAlert('This is a custom alert box', 

Re: [web2py] sqlform.factory widget in field problem

2013-06-27 Thread Tom Russell
tyle,form)) On Thu, Jun 27, 2013 at 5:31 PM, António Ramos wrote: > Using this suggestion , my submit button is inside the last fieldset. > How do i take it outside? > > > 2013/6/26 Tom Russell > >> To group inside a field I do something like this with 3 different tables: >&

Re: [web2py] sqlform.factory widget in field problem

2013-06-28 Thread Tom Russell
t; 2013/6/28 Tom Russell > >> Here's the rest of my code doing what I posted before... >> >> if form.process().accepted: >> id = db.patient.insert(**db.patient._filter_fields(form.vars)) >> form.vars.patient=id >> id = >> db.

[web2py] confused about db.py settings

2013-06-28 Thread Tom Russell
I am confused about how I have my db.py set up for tables etc. At the top I have what is generated for me: if not request.env.web2py_runtime_gae: ## if NOT running on Google App Engine use SQLite or other DB db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) else:

Re: [web2py] Re: confused about db.py settings

2013-06-28 Thread Tom Russell
auth in > one database, then you stop using it and use another database, which has no > auth set up. That can't work. > > Simply define db just once, not twice. Use the definition web2py has > suggested for you and change the database name if you want to. > > Regards, >

  1   2   >