Sorry for bothering but I can not find clue myself:
this code works in Oracle:
db.define_table('headers', SQLField('ADDRESS', 'string', length=255))
and this - does not:
db.define_table('headers', SQLField('ADDRESS', 'string', length=512))
gives ORA-00911 error (bad symbol!)
sql log shows corre
Can you create a custom database view and map the field?
On Apr 1, 12:06 am, Kevin Butler wrote:
> This was posted as a comment
> tohttp://mdp.cti.depaul.edu/AlterEgo/default/show/55:
> Which reads:
>
> > web2py can import tables saved in csv format therefore it can access legacy
> > data.
> >
Is it really backward compatible? Have you tried?
On Apr 1, 12:00 am, David Niergarth wrote:
> One postgres-specific change we made to our copy of gluon.sql to make
> things a bit easier was to add the import
>
> import psycopg2.extras
>
> and change the line
>
> self._pool_conne
Yes but it is not really a bug. appadmin select box is designed to be
used by the administrator, not to be exposed to untrusted users. Admin
must login from localhost or via https using secure session cookies.
This is as secure as SSH. After all the administrator is the
administrator, he already h
yes
On Apr 1, 12:00 am, Vidul Petrov wrote:
> Thank you, Massimo.
>
> One more question - a role can have many groups and vice versa, an
> user can belong to many groups and vice versa?
>
> On Apr 1, 7:16 am, mdipierro wrote:
>
> > This is already in Auth. Auth actually does more than unix-lik
This was posted as a comment to
http://mdp.cti.depaul.edu/AlterEgo/default/show/55:
Which reads:
> web2py can import tables saved in csv format therefore it can access legacy
> data.
> web2py can also access existing databases directly (MySQL, PostgreSQL, SQLite
> and Oracle) if
> each table h
Yarko,
Does that injection still exist? And, we need a web2py 1.6 soon :P
On Apr 1, 1:00 am, Vidul Petrov wrote:
> Thank you, Massimo.
>
> One more question - a role can have many groups and vice versa, an
> user can belong to many groups and vice versa?
>
> On Apr 1, 7:16 am, mdipierro wrote:
Thank you, Massimo.
One more question - a role can have many groups and vice versa, an
user can belong to many groups and vice versa?
On Apr 1, 7:16 am, mdipierro wrote:
> This is already in Auth. Auth actually does more than unix-like group
> based access control. It does Role based access co
One postgres-specific change we made to our copy of gluon.sql to make
things a bit easier was to add the import
import psycopg2.extras
and change the line
self._pool_connection(lambda : psycopg2.connect(msg))
to
self._pool_connection(lambda :
psycopg2.extras.DictConn
Just to fill in on the good-natured comaraderie here...
Once I saw the "porting" note here, I posted a twitter note that
"we looked, and wanted to port... but web2py already has all this"
(friendly jab ;-)...
It only took about 5 minutes after posting for the Pinax team to find it and
wail
I wondered if that might be the case. db._cursor will do just what we
need. Thanks.
--David
On Mar 31, 11:12 pm, mdipierro wrote:
> The problem is that not all adaptors support the same API and some are
> undocumented. You can use
>
> db._cursor.execute("select first, last from names where id=%
This is already in Auth. Auth actually does more than unix-like group
based access control. It does Role based access control (group based
is a particular case).
gid=auth.add_group(role='Manager')
auth.add_membership(gid, auth.user.id)
auth.add_permission(gid,'call function f')
@auth.requires_pe
The problem is that not all adaptors support the same API and some are
undocumented. You can use
db._cursor.execute("select first, last from names where id=%(id)s;",
{'id': id})
db._cursor.fetchall()
On Mar 31, 10:54 pm, David Niergarth wrote:
> For our application we are not using the ORM fea
I agree. Anyway you can alway block them by adding a line like
routes_in=[
(...),
(...),
('.*','/yourapp/default/error_action'), # catch all not mapped before
]
On Mar 31, 9:52 pm, Iceberg wrote:
> Sorry for chiming in, but I do not see it is necessary to block the
> default urls. As long as th
IMHO such lightweight applications/utilities would make WEB2PY the
only so capable MVC player.
In addition I'd like to request comments on, let's call it feature -
now that Auth is in not an add-on, is there are a place for (optional)
UNIX-like users/resources management?
In short: each resource
Pagination would be excellent and is a must, I may write a small
function that does this exact thing. :)
One thing I would like to see, is a nice tutorial on how to provide a
search function within your website. Bonus points for using sphinx as
the backend :)
On Mar 31, 11:29 pm, Yarko Tymciurak
For our application we are not using the ORM features of the DAL (see
P.S. explanation). All of our non-auth queries use db.executesql(sql).
It seems like executesql() should support the optional mapping-or-
tuple argument that the underlying DB API 2.0 cursor supports. For
example,
cursor.ex
As of right now, we're trying to get some screen shots for the Dojo as
of right now and then Massimo will put them up on the website. I plan
on doing the screen shots fairly soon, may be even tonight. :)
On Mar 31, 11:30 pm, David Niergarth wrote:
> Hello,
>
> I was at the PyCon dojo and got to
Hello,
I was at the PyCon dojo and got to meet several of you afterward. The
dojo project is a very good example for showing the breadth of web2py.
I heard a couple of people say "How come nobody knows about web2py
yet?" afterward. You may want to consider putting the dojo example on
the web2py d
Hello,
I was at the PyCon dojo and got to meet several of you afterward. The
dojo project is a very good example for showing the breadth of web2py.
I heard a couple of people say "How come nobody knows about web2py
yet?" afterward. You may want to consider putting the dojo example on
the web2py d
Not sure what you would want to port here; If I take this at face value,
here's what is currently documented (I've highlited what I thought might be
interesting from a web2py perspective).
In general, I think idea of having a package of light weight applications /
utilities is something both usef
Sorry for chiming in, but I do not see it is necessary to block the
default urls. As long as they can do proper jobs and do no harms, why
do we need to block it? Just let it be.
And in case you did not know yet, you might found the option 2 in this
post helps.
http://www.web2py.com/AlterEgo/def
Perhaps we should do it ourself for real.
On Mar 31, 7:11 pm, Yarko Tymciurak wrote:
> Guys - this is a Joke (see also the "fued between pinax and
> django")
> see: http://www.ponyransom.com/
>
> and: http://www.pinaxenvy.com/
>
> On Tue, Mar 31, 2009 at 6:28 PM, mdipierro wrote:
>
>
On Tue, Mar 31, 2009 at 8:52 PM, DenesL wrote:
>
> On Mar 31, 6:58 pm, Yarko Tymciurak wrote:
> > On Tue, Mar 31, 2009 at 2:40 PM, mdipierro
> wrote:
> >
> > > I do not think the CSV formatting belongs in the model. There may be
> it was only a suggestion, it has to be tied to the field somehow
On Mar 31, 6:58 pm, Yarko Tymciurak wrote:
> On Tue, Mar 31, 2009 at 2:40 PM, mdipierro wrote:
>
> > I do not think the CSV formatting belongs in the model. There may be
it was only a suggestion, it has to be tied to the field somehow
> > difference places in an app where importing is done suin
Hi DenesL, Massimo, thanks for your help on this, it works... Coming
from JAVA/J2EE world few months ago I didn't know I'll enjoy Python
and Web2py that much... I hope and wish this interesting experience
will benefit to someone else very soon...
Just for the info in case someone else follow this
Hi DenesL, Massimo, thanks for your help on this, it works... Coming
from JAVA/J2EE world few months ago I didn't know I'll enjoy Python
and Web2py that much... I hope and wish this interesting experience
will benefit to someone else very soon...
Just for the info in case someone else follow this
Thanks Denes! Your code suggestion worked for me. All I needed to do
was the 'x in r' and it worked like a charm! :-)
On Mar 30, 10:25 pm, DenesL wrote:
> On Mar 30, 7:00 pm, DJ wrote:
>
> > I would like someone to help me with the syntax. I want to show pre-
> > selected values in a multiple c
Guys - this is a Joke (see also the "fued between pinax and
django")
see: http://www.ponyransom.com/
and: http://www.pinaxenvy.com/
On Tue, Mar 31, 2009 at 6:28 PM, mdipierro wrote:
>
> http://twitter.com/jtauber/status/1420954914
>
> James. Are you here?
>
> Massimo
> >
>
--~--~--
On Tue, Mar 31, 2009 at 2:40 PM, mdipierro wrote:
>
> I do not think the CSV formatting belongs in the model. There may be
> difference places in an app where importing is done suing different
> conventions. And why for csv and not xml? etc.
I agree w/ Massimo...
Also, you can find "smart" dat
http://twitter.com/jtauber/status/1420954914
James. Are you here?
Massimo
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To
Yes - I can provide CSS and graphic design if needed for any of the
community projects! Just let me know.
On Mar 30, 7:08 pm, mdipierro wrote:
> Fantastic Yarko,
>
> @Mike. When talking about design, do you refer to CSS? We could very
> much use that.
>
> On Mar 30, 5:49 pm, Yarko Tymciurak wro
Here's what I want to do - be able to show/update selected values in a
multiple checkbox form.
checkbox values come from a predefined table: ['A', 'B', 'C', 'D"]
user settings (separate field) that have been saved are: ['A', 'C']
So when user wants to update his settings, I want to show A, C as
I do not think the CSV formatting belongs in the model. There may be
difference places in an app where importing is done suing different
conventions. And why for csv and not xml? etc.
I will just post an example of how to create your own importer. It is
very short and easy.
Massimo
On Mar 31, 1
gosh... I wonder how this would work... right now, the csv library is called
in more places than you'd imagine... and needs some cleanup / encapsulation
as it is...
On Tue, Mar 31, 2009 at 1:31 PM, DenesL wrote:
>
> We could have a field.csv_in (similar to field.requires) that runs
> when table
On Tue, Mar 31, 2009 at 8:53 PM, LordMax wrote:
>
> Problem.
> In Admin when I must edit something in the editor I've some trouble.
> No syntax highlighting and no resize.
The editor used explicitely checks for the browser name. I use
Minefield (the development-version of Firefox) which is also
Let me go over this quickly:
> var data = $.toJSON( # I convert JSON object to simple text
here you create a JSON encoded 'data' object, which is in line with
the following jQuery (Javascript) code:
> $.ajax({
> type: 'POST',
>
Hi to all.
I've finally buy the manual... wow 260 page... I don't sleep tonight.
^___^
I must use some strange browser.
For me I use Opera that's the best browser (for me, no browser war
please ^___^ )
but I want create usb key with all the usefull thing to work so I must
put web2py and a brows
We could have a field.csv_in (similar to field.requires) that runs
when table.import_from_csv_file is called and passes it the current
value (this could go inside the current 'fix' function).
So you can do, e.g.
table.field.csv_in=IS_DATETIME('%d/%m/%Y %H:%M',error_message='must be
D/MM/ HH:
You response is received by the JS so no coversion is necessary> My
guess is
function Save() {
var data = $.toJSON( # I convert JSON object to simple text
here));
$.ajax({
type: 'POST',
url: '{{=URL(
On Tue, Mar 31, 2009 at 12:45 PM, Yarko Tymciurak wrote:
> *snip*
> What is not
>
(sorry - didn't see that remnant text - it should not be there...)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framew
On Tue, Mar 31, 2009 at 12:35 PM, AchipA wrote:
>
> Talking about future needs... What would you do/how would you display
> in the admin if the columns are to be read-only only for certain
> groups ? For example editors can modify most parameters of an article,
> but only a publisher should be ab
Massimo,
I tried the Dojo everything worked out fine. I didn't take screen
shots, but if no one else is up for it I'll do it :P Only one question
aboutit though. Why do you use db.Field() for declaring SQL Fields
rather than SQLField() within the documentation? This may cause
confusion for newbies
Talking about future needs... What would you do/how would you display
in the admin if the columns are to be read-only only for certain
groups ? For example editors can modify most parameters of an article,
but only a publisher should be able to change it's status.
On Mar 31, 5:06 pm, Yarko Tymciu
Massimo,
I am not sure if I understand you correctly.
the routes_in looks something like:
('.*:/create','/init/default/create'),
('.*:/mycases','/init/default/mycases'),
create & mycases are functions in default.py. After this routes
rewrite, I am able to type /create and it redirects to
/init/
On 31 mar, 02:30, DenesL wrote:
> Jose, do your test tables have integer indexes?.
Yes. The field primary key is integer auto-increment.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" grou
Thanks Massimo But inside my callback method i do receive another JSON
message as response and I want to parse it for display... Do you know
How i can do it then ?
Thanks,
Yannick P.
On Mar 31, 12:22 pm, mdipierro wrote:
> You have a logical problem. the sj.loads must be in the action that
> re
On Mar 31, 10:48 am, Fran wrote:
> On Mar 31, 5:13 pm, Yarko Tymciurak wrote:
>
> > Before you export from excel, you should be able to set your date field
> > format to something that will work, for example, in format cells -> number
> > -> Custom
> > set the field to -mm-dd hh:mm:ss
>
>
You have a logical problem. the sj.loads must be in the action that
receives the ajax call "action" in your case. It cannot be embedded in
the JS code that makes the call.
On Mar 31, 9:24 am, Yannick wrote:
> Hello mate
> I'm trying to parse the JSON object inside the callback method from my
> c
Can you summerize what the problem is?. I thought this:
# SQLField('timestamp','double',default=now),
was the bug and you fixed it.
On Mar 31, 8:14 am, murray3 wrote:
> still struggling to get a solution with this GAE issue.
> anyone with experience of similar?
> any help appreciated
> Chri
On Mar 31, 5:13 pm, Yarko Tymciurak wrote:
> Before you export from excel, you should be able to set your date field
> format to something that will work, for example, in format cells -> number
> -> Custom
> set the field to -mm-dd hh:mm:ss
>
> That matches what you are saying the field "sho
Hi Marco,
you got mdifferent preffered language set in your browsers.
*** indicates application is using some language file and *** marks
variables which were not translated yet.
So check language prefferences in your browsers and make translation in
tour application administration. :)
Michal
hello everybody, I've created a little web2py application to manage
customers and contacts in my company. I've put the application on a
server and I've discovered some problems with rispect to i18n: for
some PC over the network some dates and strings appear with *** in
front of them but not if I c
On Tue, Mar 31, 2009 at 10:12 AM, Timothy Farrell wrote:
>
> Beyond that, epydoc is virtually unsupported now (having no activity for
> more than a year now). I've used it for quite a while, but it chokes on
> some perfectly valid Python. To accommodate it, you sometimes have to
> jump backwards
Before you export from excel, you should be able to set your date field
format to something that will work, for example, in format cells -> number
-> Custom
set the field to -mm-dd hh:mm:ss
That matches what you are saying the field "should be", and excel should
then export in this format to
Beyond that, epydoc is virtually unsupported now (having no activity for
more than a year now). I've used it for quite a while, but it chokes on
some perfectly valid Python. To accommodate it, you sometimes have to
jump backwards through fiery hoops. =(
I don't know Sphinx, but it is THE pyt
On Tue, Mar 31, 2009 at 8:03 AM, mdipierro wrote:
>
> I do not understarstand
What I am saying is that you "solved" the problem of write permissions on a
column in appadmin by ignoring the permissions. If I now want to be able
to see the various permissions in appadmin, there will be another
> So don't blame IE (even i don't like it neither), but this is not error,
> that's correct.
Thanks a lot for telling me! I didn't know this.
Best regards,
Stefaan.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"
Hello mate
I'm trying to parse the JSON object inside the callback method from my
client side, I got a message saying "No JSON object could be
decoded"... Do you please have any idea about what I'm doing wrong in
my callback method...Below you can see the sample of the callback
method, and format
still struggling to get a solution with this GAE issue.
anyone with experience of similar?
any help appreciated
Chrism
On Mar 29, 11:59 pm, murray3 wrote:
> Here it is I have commented much whilst testing for mistake
> thanks for any help
> chrism
> --
> model:
>
> import uuid
>
> tr
It was clear from me at pycon that Sphinx is considered the present
and future of python documentation.
On Mar 31, 7:48 am, Grahack wrote:
> Massimo, could you please detail why Epydoc is limited. I personaly
> use it with ReST formatting and find it OK, but am interested to see
> the lacks.
> I
The problem is that web2py has not way of knowning is excel is set to
US or EU date format.
On Mar 31, 4:26 am, Fran wrote:
> My Database Table (sqlite) not readable in Web2Py if I CSV import a
> bad date!
>
> Field format in CSV should be: 2009-03-31 10:46:51
> Excel converts this silently to:
I do not understarstand
On Mar 30, 11:45 pm, Yarko Tymciurak wrote:
> I looked at your post into trunk, Massimo - expedient... but can we have
> this be something more... functional before next release?
> I am thinking like this:
>
> istead of:
>
> ignore_rw=True
>
> appadmin would serve be
download this file:
http://tomqyp.javaeye.com/upload/picture/pic/34353/2878e3c1-6215-316d-aac8-f69a4a08e0cc.jpg
and upload the file on web2py app, web2py will say :"timeout:timed
out".
--~--~-~--~~~---~--~~
You received this message because you are subscribed to t
In sphinx you could:
- get data from docstrings (like epydoc)
- write your own instructions/tips using reST
and all on one site with (imo) great design.
On Mar 31, 2:48 pm, Grahack wrote:
> Massimo, could you please detail why Epydoc is limited. I personaly
> use it with ReST formatting and fin
Massimo, could you please detail why Epydoc is limited. I personaly
use it with ReST formatting and find it OK, but am interested to see
the lacks.
I see an 'autodoc' extension for Sphinx. Is it the kind of thing you
want to do?
On Mar 31, 6:29 am, Yarko Tymciurak wrote:
> I've looked
> athttp:
Hi Stefan,
the problem is not in IE but in your hostname. Hostname simply must NOT
contain anything but letters, nubers and '-' character. Anything else is
corretly assumed as malformed url and should not work.
So don't blame IE (even i don't like it neither), but this is not error,
that's cor
...if the servername contains an underscore ("_").
I think it is a bug in internet explorer, so no need to change web2py
for that.
A workaround is to use the ip address instead of the servername.
Hopefully this post can prevent other people from spending half a day
on this ;)
Best regards,
Stef
My Database Table (sqlite) not readable in Web2Py if I CSV import a
bad date!
Field format in CSV should be: 2009-03-31 10:46:51
Excel converts this silently to: 31/03/2009 10:46
The record gets imported into DB but then a query on this table gives:
Traceback (most recent call last):
File "C:
My Database Table (sqlite) not readable in Web2Py if I CSV import a
bad date!
Field format in CSV should be: 2009-03-31 10:46:51
Excel converts this silently to: 31/03/2009 10:46
The record gets imported into DB but then a query on this table gives:
Traceback (most recent call last):
File "C:
70 matches
Mail list logo