[web2py] Re: Manual Form Submission

2013-05-08 Thread Doug Girard
uest.get_vars, session=None, formname= > 'new_order').accepted: > > Since you are using the form to add new records, I assume you really want > the former (i.e., do a POST instead of a GET). > > Anthony > > On Wednesday, May 8, 2013 3:01:10 PM UTC-4, Doug Girard w

[web2py] Manual Form Submission

2013-05-08 Thread Doug Girard
I wanted to try and create my own view of a form and still have it submit the data to my table... I've got what seems to be a working form etc, but when i submit, it appears to do nothing... Model: # WORK ORDERS TABLE db.define_table('work_order', Field('work_date', 'datetime'), Field('

[web2py] Re: Simple Select Query Question

2013-05-08 Thread Doug Girard
Thank you, worked like a charm! In my application, we are tracking the techs, but they do not have permission to use the app, so they are not in the the auth table. I will keep all of your input in mind as I continue to work in web2py, this is great info especially for a beginner like me!! On

[web2py] Re: Simple Select Query Question

2013-05-07 Thread Doug Girard
ou want to extract the first > and last names from just a single row, then you'll have to do so explicitly. > > Anthony > > > On Tuesday, May 7, 2013 1:11:32 PM UTC-4, Doug Girard wrote: >> >> Below is a snippet of my code, where I am using FullCal

[web2py] Simple Select Query Question

2013-05-07 Thread Doug Girard
Below is a snippet of my code, where I am using FullCalendar. This code is working, giving me a 'tooltip' when hovering over an event, but my tip: * =db(db.tech.id==row.tech).select(db.tech.first_name, db.tech.last_name)* Returns a full table like: tech.first_nametech.last_name on and on wi

[web2py] Re: FullCalendar Example Question

2013-05-07 Thread Doug Girard
datetime()}}'), > {{pass}} > {{if row.end_datetime:}} > end: new Date('{{=row.end_datetime()}}'), > {{pass}} > } > {{pass}} > ], > > > Le lundi 6 mai 2013 18:23:50 U

[web2py] FullCalendar Example Question

2013-05-06 Thread Doug Girard
I am using some of the code from the AppointmentManager appliance to include FullCalendar in my application. I want to use 'onmouseover' from jquery to show some data associated with the events that are displayed on the calendar. Where would I add my code for that? Would it be in the view under

[web2py] sqlform.smartgrid noob question

2013-05-02 Thread Doug Girard
In my controller, I'm using: def inventory(): form = SQLFORM.smartgrid(db.equipment,onupdate=auth.archive) return locals() In my view: {{extend 'layout.html'}} Inventory{{=form}} I thought that the smartgrid would give me "add" "edit" "delete" and "view" buttons, but I am only getting

[web2py] Newbie Tables Question

2013-04-17 Thread Doug Girard
I want to create a form which I can add multiple 'items' of different 'types' that have different 'attributes' For example, lets use two types of food, pizza and steak You would start by selecting the type of food. Say pizza Upon selecting this type you would get more form fields, specific to t