I was not precisely calling from a native Android or native IOS app.
I was using a PhoneGap client, which is different. It is looks like a web
browser but is not a browser client.
PhoneGap can only use HTML5 storage unless you write a native Android / IOS
PhoneGap extension/plugin.
So my techniqu
Thank you, Niphlod and DenesL. Thats what I need. "Find, exclude, sort" and
row manipulation slipped through my attention before.
--
Yes psycopg2 is installed.
But i test the same aplication with another postgresql version (8.4)now my
application running fine.
http://comments.gmane.org/gmane.comp.python.web2py/42824
I think the problem is the postgresql version 8.1. So i migrated my database to
PostgreSQL 8.4 for solved my
It's working... somewhat, but how do i remove duplicates?
On Wednesday, 2 January 2013 00:29:28 UTC, DenesL wrote:
>
> Hi sasogeek,
>
> try something like this:
>
> # process first tag
> rows =
> db((db.contents.msg.contains(mytags[0]))|(db.contents.description.contains(mytags[0]))|(db.contents.t
Say I have a look-up tables as follows:
db.define_table('continent',
Field('name')
)
db.define_table('country',
Field('name'),
Field('in_continent', db.continent, requi)
)
Now, if I then have a table as defined:
I would then like to have an SQLFORM in which field country presents a
Thanks Alan for your help.
Have two more questions related to this:
1. In a thread bellow Massimo suggested to deprecate "embed', but without
it, the video will not be embedded, only link will be displayed. Should I
stick to embed, or look for some other solution?
https://groups.google.com/d
yes.
On Tuesday, 1 January 2013 21:41:17 UTC-6, Alex Glaros wrote:
>
> thanks Bruno and Anthony
>
> I get it now.
>
> Does it "reference" work with Postgres?
>
> thanks
>
> Alex
>
>
> On Tuesday, January 1, 2013 6:32:53 PM UTC-8, Anthony wrote:
>>
>> db.define_table('PersonSkill',
>> Field('
you have psycopg2 installed?
On Tuesday, 1 January 2013 17:58:54 UTC-6, visuallinux wrote:
>
> Dear All.
>
> I am trying to migrate my web2py applications to the new version 2.3.2 and
> deploy with nginx + uwsgi but i am received the following error:
>
>
> DEBUG: connect attempt 4, connection er
thanks Bruno and Anthony
I get it now.
Does it "reference" work with Postgres?
thanks
Alex
On Tuesday, January 1, 2013 6:32:53 PM UTC-8, Anthony wrote:
>
> db.define_table('PersonSkill',
> Field('person_id','reference Person'),
> Field('skill_id','reference Skill'),
> Field('Year
El martes, 1 de enero de 2013 20:58:54 UTC-3, visuallinux escribió:
>
> Dear All.
>
> I am trying to migrate my web2py applications to the new version 2.3.2 and
> deploy with nginx + uwsgi but i am received the following error:
>
It seems that the adapter is failing to set a postgres parameter. I
Your correction is in trunk but I did not try it. Thanks. Please check it
again.
On Tuesday, 1 January 2013 20:15:31 UTC-6, Ignacio Ocampo wrote:
>
> Currently the function __build_url_opener is:
>
> def __build_url_opener(self, uri):
> """
> Build the url opener for managing
> El martes, 1 de enero de 2013 22:11:55 UTC-3, Adi escribió:At the moment
I'm using
> plugin_wiki to display youtube videos on web pages. How would I replace
it with
> auth.wiki() without creating new wiki pages, and wiki menu?
The built-in MARKMIN helper is the simplest tool to embed video:
Is there any update on this bug?
I am also experiencing it. I am using the workaround suggested by JungHyun
Kim
I am using 2.3.2.
On Monday, August 20, 2012 12:49:14 PM UTC-4, JungHyun Kim wrote:
>
> Hello!
>
> I have a problem with upload field.
>
> I tried to upload a file through one form wi
db.define_table('PersonSkill',
Field('person_id','reference Person'),
Field('skill_id','reference Skill'),
Field('YearsOfExperience','integer'))
web2py knows the primary key of the referenced table, so you don't have to
specify the name of that field. Specifying the table name is suff
Currently the function __build_url_opener is:
def __build_url_opener(self, uri):
"""
Build the url opener for managing HTTP Basic Athentication
"""
# Create an OpenerDirector with support
# for Basic HTTP Authentication...
auth_handler = urllib2
Right, but web2py has auto-named the primary key "id" in both tables Person
and Skill.
If I rename the "id" field Person_id in PersonSkill table, it won't be
copied/referenced correctly from table Person.
Is the only way to handle this by renaming the Person table field from "id"
to "Person_
can you please type out the syntax for me? mine below gets syntax errors.
I added the *Person*.id and *Skill*.id so it would know which field in the
table to reference
db.define_table('PersonSkill',
Field('person_id','reference Person.id'),
Field('skill_id','reference Skill.id'
The name of a reference does not have to be the name of the field it is
referencing -- in fact, usually it is not the same name (in web2py, the
referenced field is typically "id"). In web2py, it is common for the
reference field to simply have the same name as the referenced table,
though some
At the moment I'm using plugin_wiki to display youtube videos on web pages.
How would I replace it with auth.wiki() without creating new wiki pages,
and wiki menu?
{{=plugin_wiki.widget('youtube', code=video.strip(), width=270,
height=230)}}
Thanks,
Adnan
--
Hi sasogeek,
try something like this:
# process first tag
rows =
db((db.contents.msg.contains(mytags[0]))|(db.contents.description.contains(mytags[0]))|(db.contents.tags.contains(mytags[0]))).select()
# process next tags
for tag in mytags[1:]:
rr=db((db.contents.msg.contains(tag))|(db.conten
Dear All.
I am trying to migrate my web2py applications to the new version 2.3.2 and
deploy with nginx + uwsgi but i am received the following error:
DEBUG: connect attempt 4, connection error:
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/dal.py", line 6771, in __init_
Hi Martin,
try adding
db.child.color.readable=False
to the f1 function, before creating the grid.
Denes.
--
Hi Andriy,
orderby maps into a database dependent order-by function, so I would say it
is not possible to use orderby for that purpose.
But as Niphlod points out you can use the sort function of the Rows object
and accomplish your objective in two steps:
rows = db().select(db.person.ALL)
sorte
Thanks for the responses, and Happy New Years to you guys too!
dlypka, for your cookieless solution, it assumes that the client app can't
store/extract tokens? In the Google Android link above, it says that both
Android and iOS can read and extract the tokens/cookies. So when the
Android app ca
Happy New Year!
I hope everyone has a wonderful 2013.
Maybe someone can give me a suggestion about how to fix the following
problem.
I am trying to modify the web2py-estore app which is old, but still works.
It does not come with any auth settings or db.py so I copied the db.py from
the "welco
You can't have duplicated field names
db.define_table('PersonSkill',
> Field('*Person_id*','reference Person'),
> Field('*Skill_id*','reference Skill'),
> Field('YearsOfExperience','integer'))
>
--
what is the syntax for renaming a reference field in order to avoid
duplicate names in a table?
example:
db.define_table('PersonSkill',
Field('*id*','reference Person'),
Field('*id*','reference Skill'),
Field('YearsOfExperience','integer'))
The "id" field name would be
relief. :-)
On Tuesday, 1 January 2013 16:14:51 UTC-6, mweissen wrote:
>
> Oh - excuse me, my mistake.
>
> What I did: I have a large image on my page and I changed the headline.
> The "Preview" shows the new headline and the picture. But the big picture
> makes the "Edit Source" button scoll dow
Oh - excuse me, my mistake.
What I did: I have a large image on my page and I changed the headline.
The "Preview" shows the new headline and the picture. But the big picture
makes the "Edit Source" button scoll down and disappear. Therefore I tried
the back button of the browser - with no result.
Hi,
I have a smartgrid and I want to show the names in different colors.
This is my model:
db.define_table('child',
Field('name'),
Field('color', default='black'),
Field('parent','reference auth_user'),
)
db.child.name.represent=lambda id, row: SPAN(row.name, _style="color:%s;"
http://web2py.com/books/default/chapter/29/07#The-process-and-validate-methods
Typo in the list.
http://web2py.com/books/default/chapter/29/04
scheduler.queur_task(
--
Changelog is correct, section on the book not.
However, here's the patch to the book (also updating the sample function on
field.Method that doesn't run just like it was intended)
On Tuesday, January 1, 2013 10:35:18 PM UTC+1, DenesL wrote:
>
>
> Field.Virtual('total_price', lambda row:
> row.i
> El lunes, 21 de mayo de 2012 07:44:23 UTC-3, szimszon escribió:Sorry,
invalid.
I am using a modified Mongodb adapter on dal.py and some queries result in
the problem you posted. The issue has little info about this. Could you
describe the cause of the issue with more detail?
--
Field.Virtual('total_price', lambda row:
row.item.unit_price*row.item.quantity)
works.
Book sample code needs to be fixed. ;)
--
OK. Tnx.
2013. január 1., kedd 17:38:14 UTC+1 időpontban Massimo Di Pierro a
következőt írta:
>
> I deleted it to avoid confusion. The official is github.com/web2py/web2py.
>
> On Tuesday, 1 January 2013 02:21:40 UTC-6, szimszon wrote:
>>
>> Where is the web2py repo from https://github.com/mdipie
The preview button by default "replaces" the code textarea with the
"resulted" html page (to be more precise, it appends a new div where the
html preview is placed and hides the textarea).
At that point, at the top of that "area", "Preview" button is replaced by a
"Edit Source" that will hide
I think it should be
db.define_table('item',
Field('unit_price','double'),
Field('quantity','integer'),
Field.Virtual('total_price', lambda row:
row.time.unit_price*row.time.quantity)
)
On Tuesday, 1 January 2013 13:51:11 UTC-6, DenesL wrote:
>
> Model:
>
> db.define_table('item',
> Fiel
Ok. Let's say, I make some changes; then I want to have a preview. I press
the preview button - the page looks nice, but I did not find any chance to
save this new page. Going back to the page I see the old code.
Did I miss anything?
2013/1/1 Niphlod
> uhm, chiming in because I'm the one to bla
you can't with DAL using standard database syntax: what you need can only
be achieved by a function on the database and without knowing what engine
is there might be different syntaxes for it.
you can however order a rowset "in python" using the DAL.
http://web2py.com/books/default/chapter/29/
uhm, chiming in because I'm the one to blame for addind the preview
functionality.
"Preview" is meant to show you how the code you inserted will look like.
I don't know any other wiki/cms/etc that saves your input when you press a
"preview" button.it's just a preview of the status you're a
jqueryui is far more customizable, generally well supported and with a lot
of widgets.
That being said, if you're happy with the tools that boostrap's framework
provide, there's no need to use jqueryUI's ones (and that's a sentence as
general as it could be with any other framework/lib/etc of y
seems a bug with python
http://bugs.python.org/issue5285
On Tuesday, January 1, 2013 7:53:56 PM UTC+1, Alec Taylor wrote:
>
> I have written a very simple function for testing auth; via REST:
>
> @service.jsondef login():
> try:
> args = json.loads(request.body.read())
> us
@alec: that was to change the default behaviour of having a first_name
accompanied by last_name and so on on the auth_user table. This is a
different problem, no ?
@encompass : are you using a custom auth instance ?
On Tuesday, January 1, 2013 7:55:37 PM UTC+1, Alec Taylor wrote:
>
> Hey Jason,
Model:
db.define_table('item',
Field('unit_price','double'),
Field('quantity','integer'),
Field.Virtual('total_price', lambda row: row.unit_price*row.quantity)
)
just trying to access item table via appadmin gives:
Traceback (most recent call last):
File "C:\w2p\web2py_2.3.2_src\appl
Hey Jason,
Reported this same issue a few days ago; I think they're working on it:
https://groups.google.com/d/topic/web2py/D8VewP3g-R0
On Wed, Jan 2, 2013 at 5:52 AM, encompass wrote:
> I am getting an error when trying to view the database in the admin
> AttributeError: 'Row' object has no at
I have written a very simple function for testing auth; via REST:
@service.jsondef login():
try:
args = json.loads(request.body.read())
username = HTMLParser.unescape.__func__(HTMLParser, args['user'])
password = HTMLParser.unescape.__func__(HTMLParser, args['pass'])
I am getting an error when trying to view the database in the admin
AttributeError: 'Row' object has no attribute 'first_name'
How would I get around this as the database admin is pretty useful. :)
BR,
Jason Brower
--
I have some experience with Boostrap and the associated javascript tools
it comes with. I just stumbled across the jQueryUI lines in layout.html
last night so I thought I'd look it up.
It would seem to me there's quite a bit of overlap in the functionality of
the two. I'm curious why jQueryUI
I have a table with 'name' Field:
db.define_table('person', Field('name', 'string'))
'name' is in format 'Name Lastname', ie, "Mark Twain". Can I sort such
records by Lastname when selecting with "orderby"? Like this:
db(db.person).select(db.person.name, orderby=?)
I thought about writing lamb
Attempt #3:
You are right, the client is certifiably *bad*.
Firebug didn't catch the plugin traffic, so I took a peak at it with
Charles and this is the request it made:
*Video URL*
Host 127.0.0.1:8000 Accept-Encoding identity;q=1, *;q=0 User-Agent
Mozilla/5.0
(Windows NT 6.0; WOW64) Appl
:-)
On Tuesday, 1 January 2013 10:45:47 UTC-6, dlypka wrote:
>
> Yes it is my New Year's Resolution to make time to put it in a Slice.
>
> On Tuesday, January 1, 2013 10:35:49 AM UTC-6, Massimo Di Pierro wrote:
>>
>> Perhaps this should go in a web2pyslice?
>>
>> On Monday, 31 December 2012 21:2
Yes it is my New Year's Resolution to make time to put it in a Slice.
On Tuesday, January 1, 2013 10:35:49 AM UTC-6, Massimo Di Pierro wrote:
>
> Perhaps this should go in a web2pyslice?
>
> On Monday, 31 December 2012 21:28:04 UTC-6, dlypka wrote:
>>
>> I developed a solution for this.
>> I poste
This may be a bug. Please open a ticket.
On Tuesday, 1 January 2013 09:51:47 UTC-6, mweissen wrote:
>
> I am playing a little bit with the new wiki.
>
> If I make some changes in the "Body" and I click on "Preview", these
> changes will be displayed as expected.
> But these changes will be lost:
I deleted it to avoid confusion. The official is github.com/web2py/web2py.
On Tuesday, 1 January 2013 02:21:40 UTC-6, szimszon wrote:
>
> Where is the web2py repo from https://github.com/mdipierro/ ?
>
> Happy New Year for everyone!
>
--
If the server returns partial content it is because the server made a range
request. Something is wrong. Probably in the client. But you find out more,
please let us know.
On Monday, 31 December 2012 21:53:49 UTC-6, Magnitus wrote:
>
> Attempt #4:
>
> You are right, the client is no good.
>
> Fi
Perhaps this should go in a web2pyslice?
On Monday, 31 December 2012 21:28:04 UTC-6, dlypka wrote:
>
> I developed a solution for this.
> I posted it here:
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/YVYQHRJmcos
>
> Happy New Year!
>
>
> On Monday, December 31, 2012 4:38:40 PM UTC
I am playing a little bit with the new wiki.
If I make some changes in the "Body" and I click on "Preview", these
changes will be displayed as expected.
But these changes will be lost: the back-button of the browser does not
work and the menu item "Edit Page" returns to page without the changes.
Hi Fernando,
I can send you my conf files, if you want to compare, but also you need to
check if your firewall port is open in /etc/iptables.firewall.rules, and
that all files and folders are owned by www-data. If you just installed,
you should also restart uwsgi and nginx. I installed from source,
Hi freeze, happy new year to you too.
The most efficient query would require a pivot like function in your db
back-end and it would not use the dal.
Storing table and field names instead of references should make the task
easier too.
Denes
--
Sorry, the earlier patch contained some typos. Here is the corrected
version.
On Monday, 31 December 2012 05:18:12 UTC+8, Massimo Di Pierro wrote:
>
> Seems like a good idea. What do other think? If the difference is only in
> the type, could we simply override the value of type using a class va
"official" web2py repo has been for a while now
https://github.com/web2py/web2py
On Tuesday, January 1, 2013 9:21:40 AM UTC+1, szimszon wrote:
>
> Where is the web2py repo from https://github.com/mdipierro/ ?
>
> Happy New Year for everyone!
>
--
I have a database table db.content with fields db.content.message,
db.content.description and db.content.tags. i have another field
db.personal.mytags and the keywords a user puts in db.personal.mytags
doesn't change. i want to create a view where a user will see only
information in db.content.
Where is the web2py repo from https://github.com/mdipierro/ ?
Happy New Year for everyone!
--
63 matches
Mail list logo