The workaround of the hidden fields seems to be much more complex for this
simple issue, isn't it?
In this specific case, we make a search in my point of view the most
appropriate action should be a POST since we submit data to be processed. A
drawback of that change will be that with the post, a u
it's not a bug per se. The problem is that there isn't around a javascript
widget that maps the "python notation" to format datetime to strings (or
parse, the reverse operation) with a perfect 1:1 mapping . In this case,
you're facing the inability for the calendar widget to know what "%Z" is.
there isn't any order defined between left and "normal" joins.
the exact same select would be created either with
db().select(left=[], join=[])
or
db().select(join=[], left=[])
If that's what you're pointing, you're out of luck ^_^
On Tuesday, May 6, 2014 10:19:51 PM UTC+2, Richard wrote:
>
>
Back in 2011 I proposed using quoted identifiers for databases supporting
it:
https://groups.google.com/d/msg/web2py/aSPtD_mGXdM/4Eflv-edEUEJ
I think the check_reserved option is a valid fix, but databases like
PostgreSql that allow using any word as identifier by quoting it should use
this in
Dear web2py users,
Could you please help/suggest me how to deal with following dilemma:
I have developed a web2py application and have a graphic design from an
outsource designer in the form of static pictures (png) and vector layouts in
illustrator format (.aoi). Now, I would like to apply the
I'm trying to setup auth_membership and I already have quite a few users
who have registered. The current schema is user_21, 22, 23 etc... should I
just use appadmin to change their role to "Editor", User, etc... or is
there a better way to do it?
Also, how could I show them their role as read-
Is there a way to temporarily override the language translation for an edit
form (a smartgrid edit form) or would you recommend not adding the %Z
format string in the language table? I could then add a represent with the
timezone when needed rather than rely on the language translation (it come
Hi Anthony, thx for your help, I was using table inside lambda then table
value was always the last table.
Good point! I'll use as you said
2014-05-07 3:22 GMT-03:00 Anthony :
> You're already looping over the tables when you define your functions, so
> just use the table value from the loop in
Yes, to me in the context of my particular select it was making issue that
the order was not respected. However, as a workaround I can just define my
join as a left join because my join was a one-one relation, but I see that
it could happen I could just not get the proper SQL from my web2py query..
On Wednesday, May 7, 2014 4:00:33 AM UTC-4, Paolo Valleri wrote:
>
> The workaround of the hidden fields seems to be much more complex for this
> simple issue, isn't it?
> In this specific case, we make a search in my point of view the most
> appropriate action should be a POST since we submit da
On Wednesday, May 7, 2014 9:31:29 AM UTC-4, Diogo Munaro wrote:
>
> Hi Anthony, thx for your help, I was using table inside lambda then table
> value was always the last table.
>
If you are iterating over some items to create lambdas, you must pass each
item to the lambda as an argument with a d
it's not a matter of order, it's a matter of how the select gets
constructed in the code. I'd still like to see what query presents this
"issue" because ideally there shouldn't be problems with the current
implementation.
On Wednesday, May 7, 2014 3:35:50 PM UTC+2, Richard wrote:
>
> Yes, to me
I'd go to disregard the %Z if you need to play with widgets that are not
supporting all the timezone related things. The final agenda is NOT letting
the user know that your backend is storing UTC dates ^_^
On Wednesday, May 7, 2014 2:37:45 PM UTC+2, Michael Beller wrote:
>
> Is there a way to te
then create whatever groups you need and associate the users to those
groups.
On Wednesday, May 7, 2014 2:37:01 PM UTC+2, LoveWeb2py wrote:
>
> I'm trying to setup auth_membership and I already have quite a few users
> who have registered. The current schema is user_21, 22, 23 etc... should I
>
No that is the right way.
On Tuesday, 6 May 2014 18:38:58 UTC-5, Kyle Flanagan wrote:
>
> Is there an appropriate web2py way to write to the filesystem?
>
> My ultimate goal is to have a custom export class for SQLFORM.grid which
> will allow the user to download a CSV of the data, but also stor
I know this is such a noob question, Niphlod. I'm starting to get a better
feel for it now. I created the groups and started to associate users.
Two things:
How could I show the user what group they're assigned too in their profile?
Would I just edit the user.html view or could I put something i
You can test it in recent DAL. It's still experimental, but well
supported in PostgreSQL. Just add the following options when
instantiating a new DAL object:
ignore_field_case=False, entity_quoting=True
mic
2014-05-07 11:26 GMT+02:00 Álvaro J. Iradier :
> Back in 2011 I proposed using quoted
Would I have to switch to CRUD instead of SQLFORM?
On Wednesday, May 7, 2014 11:05:15 AM UTC-4, LoveWeb2py wrote:
>
> I know this is such a noob question, Niphlod. I'm starting to get a better
> feel for it now. I created the groups and started to associate users.
>
> Two things:
> How could I sh
The three bars in the upper right of your Firefox are a part of the
browser, not your page. That's how the recent Firefox menu looks like.
The web2py welcome app currently comes with Bootstrap 2, not 3. If you wish
to use a bootswatch theme or any similar, you'll need to use an older,
Bootstrap
I don't think there is a straight definitive answer to what you're asking.
It depends on the expertise and preference of both the designer and the
web2py developer you'll end up working with.
Since you already have the design made, I would proceed with looking for a
web2py developer and then as
On Tuesday, May 6, 2014 5:29:48 PM UTC-7, duncan macneil wrote:
>
> Hi all,
>
> I've been trying out the www.bluemix.net IBM PaaS.
>
> It took me a bit of digging to realise there is in fact a Python runtime.
> But you need a buildpack. The setup is different enough from Heroku to
> warrant this
Is there a straightforward way to get a Rows object representing ALL the
rows referred to by SQLFORM.grid?
Something similar to grid.rows, which is good, but it only gives a Rows
object with the rows currently being displayed on that page.
I'd like to allow the user to search using the grid,
Sorry about that guys... finally found the answer:
grid = SQLFORM.grid(db.auth_user,
editable = auth.has_membership('managers'),
deletable = auth.has_membership('managers'))
On Wednesday, May 7, 2014 11:38:08 AM UTC-4, LoveWeb2py wrote:
>
> Would I have to switch to CRUD instead of SQ
Are you saying you simply want to display all the records in case the user
does a search? What if the query returns thousands of records? Anyway, in
the case of a search, you can always set "paginate" to be sufficiently high:
grid = SQLFORM.grid(..., paginate=200 if request.get_vars.keywords els
So, I progressed to being able to successfully create a custom search
widget for SQLFORM.smartgrid . Along the way I discovered that you can
only put one form there (may be I'm wrong, then I would appreciate hints).
As an alternate solution I implemented all fields in a single form, but
decid
I have rewrited the code to a hidden input with the default value
start_date.
Thanks for you're response!
Op dinsdag 6 mei 2014 15:46:04 UTC+2 schreef Kyle Flanagan:
>
> Try the following:
>
> import datetime
> db.bookings.start_date.default = datetime.date(start_year,
> start_month,start_day
>
Hi guys,
I am having a bit of trouble sending html emails that are styled with an
external CSS file.
I can get them to display properly if I include the styles inline, but if I
want to do something like http://www.mysite.com/static/css/mystyle.css";> it does not get
included.
Any help is greatl
My IT group assures me they are unable to install a more recent version of
PostgreSQL than v. 8.4 because of SSL compliance issues and web2py isn't
happy with that version. I have been developing on v. 9.3 without issue
but once I switch to v. 8.4 selects on any table do not work:
File "/U
Dear users,
I have created a web2py forum software, now currently only in the Dutch but
wil be ported to english.
The current features are:
- Categories and forums beneath them
- Posting topics and replys
- Search function
- Edit topic and reply function for the user or admin
- And a admin can cl
Hi all,
I have created a forum software application written in web2py, viewable on
the address www.uforum.nl (currently only in NL language).
It has the following features:
- Categories and Forums beneath them
- You can create topics and add replys when logged in
- It has a search function thro
No one? Any hints on how to further debug this issue?
Am Samstag, 3. Mai 2014 19:08:06 UTC+2 schrieb pete...@gmail.com:
>
> It just shows the created_year column, count column is missing completly..
> (Not even a table header is shown for the count column)
>
> Am Samstag, 3. Mai 2014 14:45:29 UTC
thanks,
works in the same way, I have table with links and when I click on it I
have message "not authorized" and nothing happen.
I try to select some rows from table and display them in Views, with links
to edit or view single record from table
SQLFORM is a good idea but there is another probl
Hey Massimo,
i follwo the link, read the manual and download your markmin-app,
but i could not find the answer - sorry iam a beginner in web2py.
Look, i have a grid with a Button "print" :
grid = SQLFORM.grid(query,
orderby=~db.task.modified_on,create=False,details=False,editable=False,
On Wednesday, 7 May 2014 13:37:25 UTC-5, Peter Pan wrote:
>
> Hey Massimo,
>
> i follwo the link, read the manual and download your markmin-app,
> but i could not find the answer - sorry iam a beginner in web2py.
>
> Look, i have a grid with a Button "print" :
>
> grid = SQLFORM.grid(query,
> or
>
> LightDot is correct, this is due to the fact that web2py comes with
> bootstrap 2. I had the exact same issue as you, I was trying to use a theme
> from Bootswatch and it ended up breaking the navbar and messing up the
> placement of things on my page. Googling themes for bootstrap 2 and us
No, I want to be able to construct a Rows object containing all the records
matching the sorting and query on the gird.
I might be able to better illustrate with an example:
model:
...
db.define_table('People',
Field('name', 'string'),
Field('age', 'integer'))
db.People.insert(name="Abe",
if request.get_vars.keywords:
rows = SQLFORM.grid(..., paginate=100).rows
Just set paginate higher than the maximum number of possible rows (if
necessary, you can precede it with a count of the rows in the table).
Anthony
On Wednesday, May 7, 2014 3:12:13 PM UTC-4, Kyle Flanagan wrote:
This SQL failed :
SELECT table_number.number_computed,
view_number_part2.part2_number,
AVG(table_value.field_value) AS field_value
FROM table_number
JOIN view_number_part2 ON (view_number_part2.number_part2_id =
number_part2.id)
LEFT JOIN number_part2 ON (number_part2.lot_nu
Well, once you have the html and css, you just use it. Layout.html is not
set it stone, it's just what other pages refer to. You could replace
layout.html with your own html, or you could disregard it entirely and go
your own route. You don't have to do things the way the examples do.
In your c
Nice, Thank you for sharing.
On Tuesday, 6 May 2014 10:57:47 UTC-5, Stefan van den Eertwegh wrote:
>
> Dear users,
>
> I have created a web2py forum software, now currently only in the Dutch
> but wil be ported to english.
> The current features are:
> - Categories and forums beneath them
> - Pos
This is probably a bug. Can you open a ticket about this?
On Tuesday, 6 May 2014 16:04:17 UTC-5, pete...@gmail.com wrote:
>
> No one? Any hints on how to further debug this issue?
>
> Am Samstag, 3. Mai 2014 19:08:06 UTC+2 schrieb pete...@gmail.com:
>>
>> It just shows the created_year column, cou
Greetings,
This might be a really dumb or simple question or might better suited to
ask in the IRC channel, but I can't seem to find an answer to this anywhere
on google. I've been trying to test various bits of code to see how it runs
on the web2py framework but without tying it to a specific
Please try installing psycopg2
On Tuesday, 6 May 2014 18:22:36 UTC-5, David Rager wrote:
>
> My IT group assures me they are unable to install a more recent version of
> PostgreSQL than v. 8.4 because of SSL compliance issues and web2py isn't
> happy with that version. I have been developing o
Hello,
To save a form in a session, I use the following line
session.form_vars = request.vars
And it works very well, the problem is that form values are linked tables.
When showing the session by
{{=session.form_vars}}
It shows variable (name: 1) instead of the display value on entry.
*Ho
I could be wrong, but I think that the best way to design and send HTML
emails is with inline CSS.
The way the email processors handle the emails always breaks the email if
it is using and external
file. Try googling HTML Email Guidelines and you will see this is one of
the main issues...
--
ok. now you just have to explain what do you mean by "running in web2py
environment".
If you don't want to use models or controllers (and surely do not want
views), why do you need an MVC (Model-View-Controller) framework
environment to work in?
On Wednesday, May 7, 2014 10:38:52 PM UTC+2, Sp
start smaller.
post a model, some data, the DAL select statement and what you want back
as a resultset.
>From the looks of it, from statements are fine but there are far too many
group by
On Wednesday, May 7, 2014 10:13:02 PM UTC+2, Richard wrote:
>
> This SQL failed :
>
> SELECT table_n
Why can't you use the scheduler for this? You can put your code in a
function in a module and then import it into a model file to make it
available to the scheduler.
Anthony
On Wednesday, May 7, 2014 4:38:52 PM UTC-4, Spencer Underwood wrote:
>
> Greetings,
>
> This might be a really dumb or s
Was actually looking at this today and there are a couple of CSS Inliners
written in Python that could perhaps be integrated in your workflow.
Haven't tried them yet but here are two.
http://pythonhosted.org/pynliner/
https://pypi.python.org/pypi/premailer/
On Tuesday, May 6, 2014 2:35:18 PM UT
I don't wanna be one of those guys who just compares on price alone but
I will obviously be comparing price to other options. (By which I mean
'value for money' not 'lowest price' SmartCloud got criticism for being
'more expensive' than the lowest common denominator, but I doubt those who
hi,
i use smartgrid with links and have a represent for that table. when the
links is clicked it returned an error, so that i must make a condition for
that.
e.g.
*models/db.py*
# on_define_shop
def on_define_shop(table):
# represent
* if 'shop' in request.function :*
table.website.represent =
Hello all.
Is there a way to have a custom library file where I can put some custom
functions ?
For example in default.py:
def index():
a = 4
b = my_custom_function(a)
return dict(b = b)
And in my library file:
def my_custom_function(my_var):
var = my_var + 3
return var
52 matches
Mail list logo
