Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
in the record or keep it the same if I choose. Does that make sense? On Friday, May 2, 2014 9:57:23 AM UTC-4, LoveWeb2py wrote: This is very helpful, Richard. I have about 20 fields so I think I would have to iterate through the fields and insert the request.vars to the database. Ahhh after looking

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
like that : def transition_form(): for f, v in request.vars: db.table[f].default = v form = SQLFORM(db.table, ...) ... Richard On Fri, May 2, 2014 at 10:18 AM, LoveWeb2py atayl...@gmail.comjavascript: wrote: Basically... right now I have a magnifying glass

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
think I should upgrade i'll make the change, but if I could stick with 2.3 I would prefer to do so On Friday, May 2, 2014 3:10:15 PM UTC-4, LoveWeb2py wrote: for this part: {f: row[f] for f in db.table.fields} what do I put for fields... could I just leave it as fields? On Friday, May 2

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
when I try to type vars={f: row[f] for f in db.table.fields})))] I get invalid syntax and the ^ points to the for in the dict comprehension. When I use regular python it works fine. Any thoughts? On Friday, May 2, 2014 3:16:24 PM UTC-4, LoveWeb2py wrote: I just realized I might be running

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
Okay... I think I see the issue. My web2py is running Python 2.6 and my Interpreter is 2.7. dictionary comprehension changed between those versions. I'm going to try and construct a dict comprehension for 2.6 and try it again. On Friday, May 2, 2014 3:40:53 PM UTC-4, LoveWeb2py wrote: Okay

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
/1747817/python-create-a-dictionary-with-list-comprehension You can adapt Richard On Fri, May 2, 2014 at 3:44 PM, LoveWeb2py atayl...@gmail.comjavascript: wrote: Okay... I think I see the issue. My web2py is running Python 2.6 and my Interpreter is 2.7. dictionary comprehension changed

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread LoveWeb2py
Web2py admin console has a red line at for f, v in request.vars: and then says too many values to unpack. my function is def transition_form(): for f, v in request.vars: db.table[f].default = v form = SQLFORM(db.table, user_signature=True) return dict(form=form) Should I have extra

[web2py] retrieve records and create SQLFORM?

2014-04-29 Thread LoveWeb2py
Hello, I'm trying to create a search function that allows users to search the database without accessing the SQLFORM. Is there a good way to display multiple results based on the record id? Could I create a unique SQLFORM view just on the record IDs that are retrieved? Basically my search

Re: [web2py] retrieve records and create SQLFORM?

2014-04-29 Thread LoveWeb2py
should think to use SQLFORM.grid that provide all what you want as far as I understand what you need. Richard On Tue, Apr 29, 2014 at 9:27 AM, LoveWeb2py atayl...@gmail.comjavascript: wrote: Hello, I'm trying to create a search function that allows users to search the database

Re: [web2py] retrieve records and create SQLFORM?

2014-04-29 Thread LoveWeb2py
awesome! On Tuesday, April 29, 2014 10:04:40 AM UTC-4, Richard wrote: This should return a list of ids : [row.id for row in db(SQL WHERE CLAUSE).select(db.table.id)] Richard On Tue, Apr 29, 2014 at 10:02 AM, LoveWeb2py atayl...@gmail.comjavascript: wrote: Thank you, Richard! This is great

Re: [web2py] retrieve records and create SQLFORM?

2014-04-29 Thread LoveWeb2py
, LoveWeb2py atayl...@gmail.comjavascript: wrote: Okay i'll give that a try. So I'll iterate through my list first and then use that clause? For id in records: [row.id for row in db(db.search_queries == id).select(db.table.id)] ?? Put something like that into the controller as SQLFORM

[web2py] Re: init.js Images not Loading initially

2014-04-25 Thread LoveWeb2py
default_application = syntheticdr default_controller = default default_function = intro is my current setup (I've since put in yours) and here is my index function in default.py def index(): return redirect(URL('intro')) Could it be creating some type of loop? On Friday, April 25, 2014

[web2py] Re: init.js Images not Loading initially

2014-04-25 Thread LoveWeb2py
That fixed it! I had to reload my web2py instance on pythonanywhere. Thank you so much! On Friday, April 25, 2014 6:32:06 AM UTC-4, Leonel Câmara wrote: The images don't seem to be there.I'm getting. 1. GET http://www.syntheticturfdrs.com/css/style.css 400 (BAD REQUEST)

[web2py] init.js Images not Loading initially

2014-04-24 Thread LoveWeb2py
Hello, I'm running www.syntheticturfdrs.com I'm using web2py to control the back end and the site is hosted on pythonanywhere. For some reason my images don't load intially, but if I browse to another site (lets say products) and then go back to welcome the images load. Does anyone have any

[web2py] Change button to loading after clicked

2014-04-23 Thread LoveWeb2py
Hello, I'm using the form=FORM('Search text:', INPUT(_name='texttofind', INPUT(_type='submit')) which generates a button and a search field on a web page when I type {{=form}} How can I change the button to loading when a user clicks it I found this documentation on jquery

[web2py] appointment application doesn't work out of box

2014-04-20 Thread LoveWeb2py
Hello, I'm trying to create a website for my Mom that she can use to book appointments. She has a day spa and really could use something like the appointment manager. I have a fresh copy of web2py installed (latest version) and a fresh install of the appointment manager app. I installed the

[web2py] errors with input form

2014-04-17 Thread LoveWeb2py
I created a search function where users can type in a set of numbers and search for them using: form=FORM('What is your n umber', INPUT(_name='numtofind', INPUT(_type='submit')) if form.accepts(request,session): numtofind = request.vars.numtofind Let's say a users number is 12345 a normal

[web2py] Current date/time for datetime field (time is wrong)

2014-04-15 Thread LoveWeb2py
Hello, I love the calendar that pops up in the 'datetime' field with a time/date selector. However, when my customers use it their time is always off. Is there a way to prepopulate the field with the current time, or make a button for them to click which will take their local system time? --

[web2py] httpd internal 500 error -- out of the blue just from typing service httpd restart

2014-04-14 Thread LoveWeb2py
I've done this 100 times. service httpd restart and it works fine I am running web2py with python 2.7 and using the wsgihandler.py with apache. I've checked the error logs and it says [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC

Re: [web2py] httpd internal 500 error -- out of the blue just from typing service httpd restart

2014-04-14 Thread LoveWeb2py
. However, now mysql doesn't work and i'm working on that. On Monday, April 14, 2014 11:57:33 AM UTC-4, marco mansilla wrote: El Mon, 14 Apr 2014 11:28:25 -0700 (PDT) LoveWeb2py atayl...@gmail.com javascript: escribió: I've done this 100 times. service httpd restart and it works fine

[web2py] Using record_versioning - possible to place links only on right side of grid=SQLFORM?

2014-04-11 Thread LoveWeb2py
Hello, I'd like to just have my links on the right side of the SQLFORM Grid and my buttons on the left and right. I've tried modifying the sqlhtml.py and changing links_placement = 'right', and buttons_placement = 'both', but both the links and buttons still appear. I'm guessing the record

[web2py] Does not contain for grid

2014-04-10 Thread LoveWeb2py
Is there a way to search for something that Does not Contain on the grid return? I was trying to put something together with wildcards and such, but haven't been able to return results in a certain row that does not contain. For example abcd abcde abcde abcde 1394e lajskl3 djklsajk3

<    1   2   3   4