Thank you , Massimo.
Would please write down the statement for calculating the count of Things
for every person?
instead of
>>> for row in persons_and_things.select():
print row.person.name, row.thing.name
Alex Boat
Alex Chair
Bob Shoes
Curt Boat
I would like to get
Alex 2
Bob 1
Hi Ricardo,
Thanks for the response, but I don't understand why it should be a
windows limit. I have many files with much larger names in windows, never
had such a problem. Besides this only occurs when we are uploading it in
web2py. Could SQLite database be a constraint ? I am using s
Any takers? Won't bother again if no response to this one...
-Jim
On Tue, Nov 12, 2013 at 1:36 PM, Jim S wrote:
> I have a SQLFORM.grid on my page. I have an upload field in the
> referenced table/query. In edit mode on the SQLFORM.grid the upload field
> is displayed as a link with the te
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=db.person.id.count%28%29
On Wednesday, 13 November 2013 19:21:31 UTC-6, webpypy wrote:
>
> Hi,
>
> I have three tables ( emp , dept ) and (many to many).
>
> How to get (for each dept), how many times each dept is
No but open a ticket. Can you help make it happen?
On Wednesday, 13 November 2013 10:45:36 UTC-6, Kariloy Markief wrote:
>
> Well, sorry to bring this back from the grave but after some hours
> debugging I've come to realize that I'm having the same problem has
> Bernardo. So I was wondering, ha
Thank you so much! was this covered in some documentation i may have
missed?
On Wednesday, November 13, 2013 8:51:06 AM UTC-8, Niphlod wrote:
>
> because db.table.field is NOT a string.
>
> statA = request.vars.stat1
> order='db.allstats.'+statA
>
> should be
>
> statA = request.vars.stat1
> ord
Hi,
I have three tables ( emp , dept ) and (many to many).
How to get (for each dept), how many times each dept is referenced?
deptnumber of occurrences
--
.
.
.
Regards,
Ashraf
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentat
A serious issue has been reported on web2y-developers. The issue has to do
with the memdb module. You are using it if you use session in Memcache on
Google App Engine. The bug affects systems on high load and creates
duplicates sessions (occasionally two users get new session with the same
id a
I think you could modify rocket to return a 404 for a request with an etag
or if-not-modified request in that particular folder, that should probably
do it, to prevent downloads from the same device. for downloads from
different devices, the approach like niphlod said would work, set a
timefram
Sure, there is a way to do that. Do you want to have users send out invite
codes to their friends, or is this a beta test type thing where once codes
are used up they can't use again, or is this for tracking sources?
On Friday, November 8, 2013 5:57:08 AM UTC-7, Dragan Matic wrote:
>
> When usin
Regardless, it's the same message just a different driver manager. I'd say
one of the settings being passed just won't work for mssql express, i'd
guess 'pooling'.
On Wednesday, November 13, 2013 3:25:38 PM UTC-7, Niphlod wrote:
>
> @derek: except that he's using unixodbc ^_^
>
> Anyway, goo
You're using eval, but are you returning executable javascript from your
function 'paginatore' ?
On Tuesday, November 12, 2013 7:17:52 AM UTC-7, Luca Dalla Palma wrote:
>
>
> Hello,
> this is my *view*
>
>
> on the *controller *I build a function containing the folowing code:
>
> pippone='ciao'
@derek: except that he's using unixodbc ^_^
Anyway, googling "[unixODBC][Driver Manager]Data source name not found"
leads you to several hundreds blogposts on the matter.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source co
Possible...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]Data source name not found and no default
driver specified.
This usually happens in one of the following scenarios:
- you referenced your connection incorrectly (e.g. spelled the DSN n
You can submit a pull request, so go right ahead and do it.
On Wednesday, November 13, 2013 5:31:30 AM UTC-7, Mirko wrote:
>
> http://www.techempower.com/benchmarks/
> A lot of web frameworks but no web2py in this list... :(
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documenta
Well, if you don't know you are secure, then you should have a security
audit. If you don't know anyone who does security audits, can't do it
yourself, and can't pay anyone to do it, then you will just have to settle
for being insecure. If security is paramount then you'd likely want to get
sof
Hello everyone,
i just started my web2py carrier, and so far I am intrigued. Anyway I have
the following question, as i could not really find it the docs.
Does the DAL support the geopoint field of the google Big Table data store,
and thus location based queries as described by in app engine d
I substituted periods for commas and that seems to work. I'll have to find
one of these unwritten rules manuals, although that sounds like a
contradiction in terms.
On Wednesday, November 13, 2013 8:25:37 AM UTC-7, Richard wrote:
>
> I thougth you were having trouble with filename... I just rem
Do you know Rentila?? http://www.rentila.com/
I think it RoR, it is very worth to try before trying to implement
something...
What you want to do is not as easy as it seems to be, as you explained
there is many things to consider.
For a local deployment behind firewall you can trust web2py to be
A friend wants me to build a loaning system applocation for him. This raises a
few flags considering that it deals with money and people's personal
information. But I'm particularly concerned about the security of web2py... I
want to be able to assure him that the system will be secure. I have n
On Tuesday, November 12, 2013 11:23:25 PM UTC+1, LightOfMooN wrote:
>
> I don't want worker without timeout. I just want scheduler task not to be
> stopped because of timeout from one of thousands records. Why scheduler
> doesn't execute tasks with status=='TIMEOUT'?
>
because any task that ti
http://web2py.com/books/default/chapter/29/04/the-core?search=routes.py#URL-rewrite
On Wednesday, 13 November 2013 01:13:46 UTC-6, Naitik patel wrote:
>
> Hi
>
> Everyone,
>
>
> I have done project in web2py .I want to do url rewriting in web2py.
> means some url like */app/controller/function* l
Does it unzip? I am trying it with OSX 10.7.3 and it works fine.
On Tuesday, 12 November 2013 20:24:30 UTC-6, TC wrote:
>
> I attempted using the auto upgrade package. The Welcome web site page
> came up but all the links give an Internal Error ticket number which I
> can't see without Admin an
because db.table.field is NOT a string.
statA = request.vars.stat1
order='db.allstats.'+statA
should be
statA = request.vars.stat1
order=db.allstats[statA]
On Wednesday, November 13, 2013 3:32:20 AM UTC+1, Noah Corradin wrote:
>
> can someone explain to me why the following does not perform the
nice shot, but scheduler isn't supported in MEMDB.
On Wednesday, November 13, 2013 6:25:40 AM UTC+1, Joel Rathgaber wrote:
>
> Hey all,
>
> I was attempting to set up a scheduler using a memcache backed MEMDB as
> the store, but I keep getting this error.
>
> int() argument must be a string or
you have 2.7 while webfaction sits on 2.6 ?
On Wednesday, November 13, 2013 8:29:01 AM UTC+1, Pascal Polleunus wrote:
>
> Hi,
> In models/db.py, I do this settings = local_import("settings")
>
> In modules/settings.py, there's the following lines:
>
> FOO = "abc"
> BAR = "{}def".format(FOO)
>
>
>
db.table.field.requires.append(what_you_need)
On Wednesday, November 13, 2013 6:43:38 AM UTC+1, User wrote:
>
> So since a time field automatically has an IS_TIME validator how would you
> specify additional validators after the db.define_table statement?
>
> On Tuesday, November 12, 2013 3:51:12
you can't have a column in the grid with a groupby that is not the groupby
itself or an aggregate of another column, just like you can't in SQL.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/
Well, sorry to bring this back from the grave but after some hours
debugging I've come to realize that I'm having the same problem has
Bernardo. So I was wondering, has by any chance 'sasl_method=PLAIN' have
been enabled as a possibility since then? Because, if so it isn't being
obvious to me.
For what it's worth, I worked through a series of apparently random
connection errors when I was using MSSQL database. Searching the net it
appeared to be a problem with MSSQL and not web2py DAL. I decided to change
the database to Postgres. There were some challenges getting Postgres
installed
i think you can achieve it using session for store the items after that
checkout and then submit it (like online shopping cart method)
ref:
https://github.com/mdipierro/web2py-appliances/tree/master/PosOnlineStore
or if you want grid solution (create the header first and then you can add,
edit,
I thougth you were having trouble with filename... I just remember the old
not written rules... You do what you want...
On Tue, Nov 12, 2013 at 9:34 AM, John Felps wrote:
> Why? RFC 1738 states "Thus, only alphanumerics, the special characters
> "$-_.+!*'(),", and reserved characters used for th
a, sorry, my fault, didn't notice that the id field is none. thanks for
show me my own mistake. is there a way to arrange the result for that?
e.g. expected result :
root
- child 1
- child 2
thanks and best regards,
stifan
p.s.
i've change the code into :
*models/db_wizard.py*
# coding: utf8
fr
Hello,
this is my *view*
on the *controller *I build a function containing the folowing code:
pippone='ciao'
stringa.append("jQuery('#paginatore').html('%s');" % pippone())
print pippone
return stringa
The console says
ciao
(the HTML generated appears to be right)
When the function returns, I
Why? RFC 1738 states "Thus, only alphanumerics, the special characters
"$-_.+!*'(),", and reserved characters used for their reserved purposes may
be used unencoded within a URL." A comma is a valid 'special character'.
The system I'm working with uses special characters to delineate special
me
Thank you very much for the reply. i was able to figure it out but ill look
into this method as well.
On Tuesday, November 5, 2013 9:04:57 PM UTC-8, Kiran Subbaraman wrote:
>
> I would use the ajax+callback mechanism that exists in web2py to do
> this. Look at the simple wiki example, and *sear
Hello,
I'm thinking about implementing a form for ordering parts, and before
starting this work I'd like to have some advice. Here is the base
functionality wanted:
- The form would include multiple similar lines made of 3 fields, to hold a
"part_reference", a "part_description" and a "quanti
Hi,
In models/db.py, I do this settings = local_import("settings")
In modules/settings.py, there's the following lines:
FOO = "abc"
BAR = "{}def".format(FOO)
When I execute this command on my server (WebFaction):
web2py.py --no-banner -S app_name -M -N -R
applications/app_name/cron/jobs.py
t
can someone explain to me why the following does not perform the way i
thought it would
This works:
results=db(db.allstats.ptype==ptype).select(db.allstats.ALL,
orderby=db.allstats.attack)
But this does not:
statA = request.vars.stat1
order='db.allstats.'+statA
results = db(db.allstats.pt
Hey all,
I was attempting to set up a scheduler using a memcache backed MEMDB as the
store, but I keep getting this error.
int() argument must be a string or a number,
not 'MemcacheClientObj'
Traceback:
Traceback (most recent call last):
File "/usr/home/jrathgaber/bunnyhugdev/web2py/gluon/
I attempted using the auto upgrade package. The Welcome web site page came
up but all the links give an Internal Error ticket number which I can't see
without Admin and the admin interface gives another Internal Error. I
completely removed the 2.7.2 version for a totally fresh install of 2.7.4
Hi
Everyone,
I have done project in web2py .I want to do url rewriting in web2py.
means some url like */app/controller/function* like this type.
but I want to change that url as per my requirement.
what are the setting I have to do ?
please help me for that?
Regards,
Naitik patel
--
Resour
Hello Johann,
It's why I created this view with the concept of cube to BI. I carry a lot
of information forlater summarize according to the parameters of the users,
but this I do in web2py.
I'm working with web2py like my small BI ...
Then the assembly is accomplished in various ways as defined
On 13 Nov 2013, at 1:44 AM, Noah wrote:
> I understand that Web2Py's urls work like this:
> 127.0.0.1:9292///
>
> I'm building an app that has user logins and I want to have a sort of profile
> page for each user that has an easy to remember URL. Similar to on twitter
> where to go to a user'
I changed to chrome and it's working ok.
The problem persists with Firefox. I already tried some configs
changes, but with no success.
Fortunately, It's not a rocket problem.
On Sat, Nov 9, 2013 at 11:53 PM, Vinicius Assef wrote:
> On Sat, Nov 9, 2013 at 10:52 AM, Niphlod wrote:
>>
>> @vinici
Hello Johann,
It's why I created this view with the concept of cube to BI. I carry a lot
of information forlater summarize according to the parameters of the users,
but this I do in web2py.
I'm working with web2py like my small BI ...
Then the assembly is accomplished in various ways as defined
Why not use the 'group by' in the creation of the view and then you can
just view the view using the grid with no need to group by again in the
grid?
Regards
Johann
On 13 November 2013 03:06, Meir wrote:
>
> Hello,
>
> I have the following problem: I have created a view in the legacy database.
http://www.techempower.com/benchmarks/
A lot of web frameworks but no web2py in this list... :(
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You receiv
On Wed, Nov 13, 2013 at 10:00 AM, Rahul wrote:
> Hi All,
> I get an error like below when I upload a file (.pptx [could be with
> other extensions too not tested]) in latest web2py - downloaded from trunk
> yesterday as below. I am on Win7 and IE9 .The file name looks insanely huge
> as hig
All you need to do is return data as an array. That's all the controller
does.
So you need to learn how to retrieve data using the DAL, and put it into an
array.
For example, you can get rows from a query, and iterate over the returned
rows, building up the array.
On Wednesday, November 13
Thanks Tim,
I have a question:
In your example, data is present in controller itself, how can I store the
data effectively in database and then use that data for plotting graphs?
Can you please provide an example of how this can be stored/retrieved from
db? I searched the net and found people
All,
To correct the file has 89 character and not 60. That was a typo in my
earlier post. a sixty character file works fine for upload. By character I
mean name of the file - something like
[Toney Catters expose Primary divisor from Fontect to Int Focount view and
enyamic seaport.pptx]
Regard
Hi All,
I get an error like below when I upload a file (.pptx [could be with
other extensions too not tested]) in latest web2py - downloaded from trunk
yesterday as below. I am on Win7 and IE9 .The file name looks insanely huge
as highlighted below. I am able to upload pptx files prior to
I understand that Web2Py's urls work like this:
127.0.0.1:9292///
I'm building an app that has user logins and I want to have a sort of
profile page for each user that has an easy to remember URL. Similar to on
twitter where to go to a user's page you just navigate to
twitter.com/. How does on
54 matches
Mail list logo
