Re: [web2py] Re: Can I/how would I create a self-signed certificate using IIS?

2014-01-17 Thread Keith Planer
can also buy a CA for LAN here, but it is not going to continue for > very long, Goddady stop recently to emit new certificate for LAN : > http://www.instantssl.com/ssl-certificate-products/ssl/ssl-certificate-intranetssl.html?ap=ce046 > Ref.: > http://support.godaddy.com/help/art

[web2py] I want to pre-populate a custom form with values from the db

2014-01-17 Thread Keith Planer
So here's my method as-is right now: def diagnosis_lookup(): ... var=request.args(0) ... if var is not None: query=db((db.diagnosis.consumer_id==request.args(0))).select(orderby =~db.diagnosis.id) form = FORM( TABLE( TR(

[web2py] Re: Can I/how would I create a self-signed certificate using IIS?

2014-01-16 Thread Keith Planer
I understand this link might have some guidance for me, but the link is down: http://www.web2py.com/AlterEgo/default/show/140 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Can I/how would I create a self-signed certificate using IIS?

2014-01-16 Thread Keith Planer
I'm trying to get remote admin working for my web2py server. I followed instructions from here which didn't work for me, I got "Error opening metabse: 0x80040154" when I tr

[web2py] 2nd page of results don't show up on my SQLFORM.grid

2013-12-31 Thread Keith Planer
def patient_lookup(): db.consumer.id.readable=False var = request.args(0) grid = [] links=[lambda row: A('Note',_href=URL('default', 'notes',args=[row.id ])), lambda row: A('Diagnosis',_href=URL('default', 'diagnosis_lookup' ,args=[row.id])), lambda row: A('Ord

[web2py] Re: Passing form input to a query.

2013-12-31 Thread Keith Planer
And that did, thank you. On Tuesday, December 31, 2013 6:10:02 AM UTC-6, Niphlod wrote: > > use form.vars holds a dict with the values matched with the _name keys, so > something like form.vars.lname should definitely work > > On Tuesday, December 31, 2013 11:10:00 AM UTC+1, Kei

[web2py] Re: I don't want 'Login Successful' or 'Success' popping up on the screen in my app.

2013-12-31 Thread Keith Planer
eing done), so you can also do something like: > > response.flash = session.flash = None > > any time after the SQLFORM or Auth code has run (but before the function > returns and the view is executed). > > Anthony > > On Monday, December 30, 2013 3:31:51 AM UTC-5, Keith Planer wrot

[web2py] Passing form input to a query.

2013-12-31 Thread Keith Planer
This is probably a beyond-simple problem but I can't figure it out. var = request.args(0) query=db.consumer.lname grid = '' form = FORM("Last Name: ",INPUT(_name='lname'),INPUT(_type='submit')) if form.accepts(request.vars, session): query=(db.consumer.lname=???)

[web2py] Re: ValueError: invalid literal for int() with base 10: ''

2013-12-30 Thread Keith Planer
I'm having the same problem, but I'm struggling with saving the database. The corrupted field is a 'date' type. On Wednesday, May 27, 2009 1:15:36 AM UTC-5, ニコノコ wrote: > > I found the source of my problem. I have records with null values. And > since sqlite don't enforce data typing, I assume t

[web2py] Re: Calendar widget in a custom form?

2013-12-30 Thread Keith Planer
Nevermind, found it. requires=IS_EMPTY_OR(IS_DATE()) On Monday, December 30, 2013 11:31:36 AM UTC-6, Keith Planer wrote: > > One other small problem, the field doesn't allow for nothing to be entered > now. How do I make it optional? > > On Monday, December 30, 2013 8:3

[web2py] Re: Calendar widget in a custom form?

2013-12-30 Thread Keith Planer
ssion Date: ",INPUT(_class='date',_name= > 'adm_date',widget=SQLFORM.widgets.date.widget,requires=IS_DATE()))... > > > > Il giorno lunedì 30 dicembre 2013 09:48:06 UTC+1, Keith Planer ha scritto: >> >> After adding some input validation I've re

Re: [web2py] Re: Calendar widget in a custom form?

2013-12-30 Thread Keith Planer
dgets.date.widget,requires=IS_DATE()))... > > > > Il giorno lunedì 30 dicembre 2013 09:48:06 UTC+1, Keith Planer ha scritto: > >> After adding some input validation I've realized that the calendar widget >> is not popping up. Is there anything I need to add to the co

[web2py] Calendar widget in a custom form?

2013-12-30 Thread Keith Planer
After adding some input validation I've realized that the calendar widget is not popping up. Is there anything I need to add to the controller or elsewhere? form=FORM(TABLE(...TR("Admission Date: ",INPUT(_name='adm_date',widget= SQLFORM.widgets.date.widget,requires=IS_DATE()))... -- Resources

[web2py] I don't want 'Login Successful' or 'Success' popping up on the screen in my app.

2013-12-30 Thread Keith Planer
How do I keep session.flash and response.flash from doing their things when I don't want to? Specifically I don't want the messages popping up after a user logs in or when they make a new entry to the DB. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github

[web2py] Help me understand how to create a search

2013-12-23 Thread Keith Planer
I'm new to web2py, and Python. I created a database, and I want to create a page where I can return records from a table of people, using their first and last names as search terms. What I have so far is: def patient_lookup(): #form = SQLFORM.grid(db.consumer, deletable = True) form=SQL