http://web2py.com/books/default/chapter/29/6#belongs
belongs take a set or a _select() - mind the _ in front of the select - :
you're using it in the wrong way :D
db(db.movies.id.belongs(
db(db.ratings.id>0)._select(db.ratings.imovie)
)).select(db.movies.ALL)
should work. If not, please p
On Sun, Jun 24, 2012 at 3:19 PM, Annet wrote:
>
>> Thanks Annet, but that also didn't work for me.
>
>
> No offence but, in which folder is your routes.py file? I first put
> routes.py in init's root folder, however, I had to put it in web2py's root
> folder, to solve the problem.
>
> Annet.
My r
> Thanks Annet, but that also didn't work for me.
>
No offence but, in which folder is your routes.py file? I first put
routes.py in init's root folder, however, I had to put it in web2py's root
folder, to solve the problem.
Annet.
--
Hi I'm trying do make a query:
I want to get all the movies that have ratings on my database.
db.ratings is a many to many relationship with db.users and db.movies
I did:
In [7]: db(db.ratings.imovie.belongs(db.movies))._select(db.movies.ALL)
Out[7]: 'SELECT movies.id, movies.imdb_id FROM ratin
Thank you Anthony ... I renamed the calendar.js and indeed ... the popup
does not show up anymore ( good ! ) .. however ... the select_datewidget
does not work - what am I doing wrong ??? what am I missing ?? .. Any
suggestions ??? how do I make the select_datewidget be used by default now
If you are using SQLFORM.grid, try SQLFORM.grid(..., upload=None). If you
are using Crud, try crud.settings.download_url=None. If it's a standard
SQLFORM, by default there should be no "[file]" link for download.
Anthony
On Saturday, June 23, 2012 8:13:11 PM UTC-4, Matt wrote:
>
> Hi there,
>
>
The validator only controls how the date is input and displayed in forms,
not when you are simply referring to the field in the Row object.
Anthony
On Saturday, June 23, 2012 6:02:42 PM UTC-4, ctrlSoft wrote:
>
> hi, my datetime field format is
> Field('deadline','datetime', requires=IS_DATETIM
The datepicker is handled client-side by code in /static/js/web2py.js:
http://code.google.com/p/web2py/source/browse/applications/welcome/static/js/web2py.js#28.
The datepicker attaches to fields with class "date" and "datetime" (and
there's a time entry widget for fields with class "time"). To
What Bootstrap 2 features are you now unable to use with web2py?
On Saturday, June 23, 2012 7:29:37 PM UTC-4, cyan wrote:
>
>
> Hi,
>
> I've seen a couple of threads in the group discussing bringing bootstrap 2
> together with web2py, and someone mentioned that this will become true in
> the com
Hi there,
The UploadWidget is great. However it does come with a few minor
peculiarities.
I'm aware you can do the standard db.table.image.required = IS_IMAGE() to
disable the delete button.
However I'm wanting _not_ to display the ugly:
[file]
link..(Altering the DOM seems overkill.)
Is
Hi,
I've seen a couple of threads in the group discussing bringing bootstrap 2
together with web2py, and someone mentioned that this will become true in
the coming web2py release.
I just wonder what state this development is in now, are we finally going
to be able to use all the features offe
PyCon Argentina is pleased to announce an extended set of 5 financial
aid grants up to $1500 ARS pesos, around 300 USD each grant (according
current currency exchange), to help speakers to cover travel and
lodging costs.
Do not wait to apply, applications will be analysed in a
rolling-basis, the fi
do so in view:
{{=yourTable.deadline.date().strftime('%d-%m-%Y')}}
Ovidio Marinho Falcao Neto
Web Developer
ovidio...@gmail.com
ovidiomari...@itjp.net.br
ITJP - itjp.net.br
83 8826 9088 - Oi
83 9334
hi, my datetime field format is
Field('deadline','datetime', requires=IS_DATETIME(format=('%d-%m-%Y
%H:%M:%S')), label=T('Deadline')),
but in view row.deadline is displayed in this format 2012-06-27 11:00:00
and in exported csv the same.
how do i set datetime format that is displayed in vi
This is all I have in my routes.py file and I don't ever see 'default' in
my URLs:
routers = dict(
BASE = dict(
default_application = 'runway',
)
)
--
>
> > You're forgetting another "layer". DAL leverages on DBAPI
> implementation of
> > sql drivers.
>
> Well, that's not exactly good news for transparency and ease of
> documentation.
>
DB API is just a specification for Python database drivers to follow to
ensure some degree of similarit
>
> > I believe so. The shared lock does not last forever -- only as long as
> it
> > takes to execute the select. Once the data have been read, the shared
> lock
> > (for that particular select) is released.
>
> Yes, if autocommit is on. The part you didn't quote was that
> autocommit can b
OK Thanks, I will do some testing on the grid to see if it can handle what
I need.
niphlod thanks for the info on sharing files between multiple servers this
will come in handle. I do need all the files on one server for this
specific requirement as I am uploading banners which could come from
cur
Did you also change:
init = dict(
to
social = dict(
Please show the complete contents of your routes.py file.
Anthony
On Saturday, June 23, 2012 3:03:54 AM UTC-4, Alec Taylor wrote:
>
> Thanks Annet, but that also didn't work for me. The only modification
> I made was removing the ba
On Jun 23, 2012, at 12:03 AM, Alec Taylor wrote:
>
> Thanks Annet, but that also didn't work for me. The only modification
> I made was removing the basicRegister element and replaced default
> application with "social"
I'm on the road this weekend, but when I get back we can arrange to do a litt
In trunk but I am behing a firewall and I can ony commit to google code,
not github, until later.
On Friday, 22 June 2012 17:21:51 UTC-5, backseat wrote:
>
> I have a combo box on a form to select a company name. The list of valid
> company names is derived from a query, q, and so I have:
>
>
On Friday, 22 June 2012 15:33:52 UTC-5, Bruce Wade wrote:
>
> Hi,
>
> I have 2 questions:
>
> First what is the process of having images uploaded from 1 or more servers
> to be stored on a single server using web2py upload field?
>
> Second is it yet possible to use SQLFORM.grid with mongodb? If
I know that for SQLite (what I'm using for the proof of concept) it's
actually NOCASE.
On Saturday, June 23, 2012 4:28:44 AM UTC-4, Niphlod wrote:
>
> Do you know the required syntax to make it happen on the db engine you are
> using ?
> Remember also that if your db is going to be "filled" (
Hi there,
Hi there,
I have used pyjamas with css successfully before.
The secret was to change the view a bit to insert a link to the .css file.
Activity
Best regards,
Stefaan.
--
Plan A: On your DB use a case-insensitive collation order and make a
unique index on it.
Plan B: On your DB set up a trigger to save the data (eg lowercase) into a
unique index field.
Plan C: Similar to B, but use 'compute' in web2py to update the field.
This is only good if the data wil
Do you know the required syntax to make it happen on the db engine you are
using ?
Remember also that if your db is going to be "filled" (updated, or
inserted) by web2py, you can apply a custom validator: only data inserted
or updated from within web2py will be "checked"
On Saturday, June 23,
Thanks Annet, but that also didn't work for me. The only modification
I made was removing the basicRegister element and replaced default
application with "social"
On Sat, Jun 23, 2012 at 3:10 PM, Annet wrote:
> Hi Alec,
>
> I had a routes related problem a few weeks ago. Jonathan and Anthony help
27 matches
Mail list logo
