On Nov 19, 7:53 am, cjrh wrote:
> On Nov 19, 4:30 am, mdipierro wrote:
> > I could use some help from editors in revising the book. ;-)
> I will do it later today. I have some other fixes lined up too.
Done.
Ciao Massimo!
Thank you so much for your extremely quick response!
I followed your suggestions and it works now. Gonna design a
controller...
I encountered problems during automatic migrations several times but
can't yet explain why (»extreme programming«). The model an the MSSQL
DB came out o
On Nov 19, 9:26 am, Branko Vukelic wrote:
> Something tells me the books needs a bug tracker. :)
That would be best.
I am relatively new to webfaction and want to upgrade the web2py version
(1.85.3) that was installed by webfaction when I started out there.
What is the safest way to upgrade with the minimum interruption of service?
If I unpack the latest source of web2py - how do I restart apache?
Regards
Joh
Hi Massimo,
Error 1 described above still exists; even in trunk.
Also, if the same specified-out-of-sequence table is selected in
appadmin an error results:
File "E:\Dev\w2p\web2py_hg\gluon\sql.py", line 1537, in __allocate
raise RuntimeError, "
Using a recursive select but encountered a broken r
I upgrade from admin and works ok (altougth experimental by now)
to restart apache, via ssh shell, execute './restart' under apache2/
bin/ , located under something like
/home/golden/webapps/web2py/apache2/bin/restart
On 19 nov, 09:24, Johann Spies wrote:
> I am relatively new to webfaction a
Hi Johann,
> What is the safest way to upgrade with the minimum interruption of service?
I haven't figured out that yet ;-( All I can say is don't use the
upgrade web2py now function this causes your web2py installation to
produce errors.
> If I unpack the latest source of web2py - how do I r
Thanks Annet and Golden Tiger.
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge of God
and of Jesus our Lord! His divine power has given us everything we need for
life and godliness through the full knowledge of the one who called us by
his own glory and e
hi
On Nov 18, 6:27 pm, Carlos wrote:
> Hi selecta,
>
> When can I see your project?,
dec 15th
> will it be free open-source?,
yes
> what features does it have?.
for example a basic facebook like chat plugin and a tagging plugin
>
> Unless no info should not be revealed before this exhibitio
On Nov 18, 3:05 pm, cjrh wrote:
> "I have a field that is a uuid which is
> only supposed to be calculated once, on insertion."
>
> Best way to do this currently? I would use "default" if within the
> context of a controller, but these are records I create manually in
> admin. There is a field t
I suggest FogBugz for tracking bugs:
http://www.fogcreek.com/fogbugz/StudentAndStartup.html
It's free for students and groups of two or less... Joel's pretty
nice; he might donate/discount a few licenses for a good cause.
Otherwise you could try to finish the editing project before the free
trial
Oh, also I was just reading about Web2Py support on Cherokee via
uWSGI:
- http://web2pyslices.com/main/slices/take_slice/64
-
http://groups.google.com/group/web2py/browse_thread/thread/5213ca17c3352c2e/221cebcfa01609b1?#221cebcfa01609b1
It's not mentioned in the official book, yet. Is uWSGI offici
On 18 November 2010 14:03, mdipierro wrote:
> This is a reasonable error now.
>
> when you change a field type (but not the name) web2py tries to
> convert the data. In this case postgres fails because it does not know
> how to convert dates to integers.
>
> You have to do it in multiple steps:
>
Il giorno 19/nov/2010, alle ore 13.59, John Kim ha scritto:
> Oh, also I was just reading about Web2Py support on Cherokee via
> uWSGI:
> - http://web2pyslices.com/main/slices/take_slice/64
> -
> http://groups.google.com/group/web2py/browse_thread/thread/5213ca17c3352c2e/221cebcfa01609b1?#221ceb
Ok, i checked it, you found very hard to see errata :) i think there
is enough to start editing, following lines shows suggestion/errata i
checked and accepted
SUGGESTION #1 Undocumented IS_IN_SET
http://groups.google.com/group/web2py/browse_frm/thread/418417e058ef9428
You can use dictionary to
Are you aware of mercurial online book howto (http://hgbook.red-bean.com/)
??
I don't remember exactly how it works, but the online book is under version
control and example were updating with version of mercurial or something
like this...
Maybe we could get good idea from there to improve doc pr
I did the upgrade by admin 2 times and that broke my system.
Now I am taking advantage of the application feature of webfaction,
I create a pure new instalation of web2py names per example "myapp2" I test
this app throught IP:PORT addr
Copy the applications from old web2py to new.
$cp /webapps/m
On Nov 19, 8:52 am, mdipierro wrote:
> True! To avoid the confusion I made "blocked" an alias for "disabled"
> so now both work the same (in trunk).
Fixed the book.
On Nov 19, 4:17 pm, Richard Vézina
wrote:
> Maybe we could get good idea from there to improve doc process of web2py?
We should improve the process. In particular, I would like to be able
to do offline editing, and pull other people's changes, and push my
own changes when I have some. Sounds ve
We are making an ERP-like system too:
http://code.google.com/p/gestionlibre/source/browse/ABOUT
Initial model is almost done, now I'm focused on basic controllers to
register invoices, receipts and so on (sales)
This ERP is based on a previous system done in VisualBasic (following
double-entry bo
How is the performance with 60 table definitions -- does that
noticeably slow things down?
On Nov 19, 9:33 am, Mariano Reingart wrote:
> We are making an ERP-like system
> too:http://code.google.com/p/gestionlibre/source/browse/ABOUT
>
> Initial model is almost done, now I'm focused on basic con
I have around 60 tables + near a 100 views under postgres it performs like a
charm.
Richard
On Fri, Nov 19, 2010 at 9:46 AM, Anthony wrote:
> How is the performance with 60 table definitions -- does that
> noticeably slow things down?
>
> On Nov 19, 9:33 am, Mariano Reingart wrote:
> > We are
Maybe mention this in the book:
http://groups.google.com/group/web2py/msg/c72adffd2e2585a8
On Nov 19, 9:07 am, GoldenTiger wrote:
> Ok, i checked it, you found very hard to see errata :) i think there
> is enough to start editing, following lines shows suggestion/errata i
> checked and accepted
Is it going to be open source?
Do you know tryton and Open ERP??
They are built with python.
Richard
On Fri, Nov 19, 2010 at 9:33 AM, Mariano Reingart wrote:
> We are making an ERP-like system too:
> http://code.google.com/p/gestionlibre/source/browse/ABOUT
>
> Initial model is almost done,
My application follows a book metaphor -- record with number of pages and
subrecords with consecutive page numbers. I'm using crud.update and wish to
run a piece of code to update the total number of pages on the record and
reassign page numbers when a record is deleted to keep them consecutive.
On Fri, Nov 19, 2010 at 11:53 AM, Richard Vézina
wrote:
> Is it going to be open source?
Yes, the license will be Affero-GPL:
http://code.google.com/p/gestionlibre/source/browse/LICENSE
> Do you know tryton and Open ERP??
Yes, but I think they are too much complex for small and medium enterpris
Yes you are right. I think Open ERP have been fork by some of the original
developper into Tryton to minimize the complexity.
I would be really interesting in this project. I can help with the time I
have (I mean not much ;-)
Richard
On Fri, Nov 19, 2010 at 10:16 AM, Mariano Reingart wrote:
> O
thanks !
On Thu, Nov 18, 2010 at 5:24 PM, mart wrote:
> Hey,
>
> It took me a few tries before getting this to work. So, I see 2 things
> that you may want to try to look at:
>
> 1) I don't really use windows, but I think the first line is
> problematic. (unless more recent windows versions have
Nice! I think I can contribute.
But, One problem I found in your models, is the tables and fields being
named in Spanish. As English is an IT Universal Language, I guess some
people will find difficult to mantain, contribute and extend the system
because of Spanish models.
I started a Scrum Mana
Hi,
If anyone have a answer - pls. reply:
*My model:*
db.define_table('newcomp',
Field('uuid', length=64, default=uuid.uuid1()),
Field('name'),
Field('address'))
db.newcomp.uuid.writable=False
when I run this directly from the controller, or in db admin tool is works
fine. When I
Hi,
I have one proposal: extend auth_membership with a new "reference
auth_context" in order to support a multi-tenant architecture (single
web2py application with multiple tenants / contexts).
This would be optional, so that everything works exactly the same as
now, plus a new option to support
Yes, I agree, development will be done in english, look at this
"facturalibre" branch:
http://code.google.com/p/gestionlibre/source/browse/?r=2ecd5bfdd8378bedf65737d3b99863a77275edcf
The "default" branch is a early version migrated from a current
database without translation, just to get somethin
I've set my routes logging to be false, but on appengine every call
about 10 / 15 debug logs are written, how can a switch them off.
Here's my routes.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
# default_application, default_controller, default_function
# are used when the respective element is
On Nov 19, 2010, at 8:03 AM, Carlos wrote:
>
> I have one proposal: extend auth_membership with a new "reference
> auth_context" in order to support a multi-tenant architecture (single
> web2py application with multiple tenants / contexts).
>
> This would be optional, so that everything works exa
I don't fully understand this proposal, but, it shouldn't be posted on
web2py-developers?
BTW, is there a patch available?
PS: I think we have to use web2py-developers more, just to not mix
issues that aren't relevant to users (and in fact, they may cause
confusion, wasted time, etc.)...
Regards
the only thing on multiprocessing's queue that I don't like (it's not
its fault, but psycopg's one) is that I have to create multiple
connections (one for every process) to the database.
Multiprocessing's queue, threading one, deque are where you end up
with your hands dirty
if you need persi
I really like the new admin design, it looks great.
I've really only got one thing thats bugging me about it, the red X's
next to everything on the edit page's files is very distracting. I
feel its too bold and doesn't fit into the theme. A friend said they
look like errors instead of delete butto
> {{for company in companies:}}
>
> {{=uuid}}
> {{=address}}
>
>{{pass}}
Shouldn´t this be like
{{=company.uuid}}
{{=company.address}}
or maybe
{{=companies[company].uuid}}
{{=campanies[company].address}}
Kenneth
Nice! Much better than the red X.
BTW: please send the icon, I want to replace my X icon right now!
2010/11/19 ra3don
> I really like the new admin design, it looks great.
>
> I've really only got one thing thats bugging me about it, the red X's
> next to everything on the edit page's files is
This ought to be simple and yet...
How do I write the following query in web2py?
UPDATE dest, src
SET dest.field = src.field
WHERE src.dest_id = dest.id
I only need to run it once. Tried via database administration module, but
the problem seems to be that the source and destination field names ar
For both local and remote machine, the Controllers and Views are
identical:
***BUT*** On the local machine I get this ERROR response
Traceback (most recent call last):
File "gluon/restricted.py", line 178, in restricted
File "C:\web2py\applications\mobyjoe/views\default/showLists.html",
line
I'm attempting to upgrade to a new version of web2py (1.69 to 1.89.4).
It seems that when the views are rendered now Web2py auto swaps any
special HTML characters.
For instance I have:
someJavascriptFunction({{=simplejson.dumps(aPythonVar)}});
This errors because the quotes in the aPythonVar ar
Nevermind. Figured it out right after I posed.
You use the XML function. My example becomes:
someJavascriptFunction({{=XML(simplejson.dumps(aPythonVar))}});
On Fri, Nov 19, 2010 at 12:06 PM, Mark Larsen wrote:
> I'm attempting to upgrade to a new version of web2py (1.69 to 1.89.4).
>
> It s
I figured out a way to do this... rewrote my query as a nested select:
UPDATE dest SET dest.field = (SELECT src.field FROM src, dest WHERE
src.dest_id = dest.id);
Does SQLite support UPDATE statements with multiple tables or does one have
to nest select statements to achieve this?
Thanks,
Audra
Oops, for logical clarity, it should be:
UPDATE dest
SET dest.field =
(SELECT src.field FROM src, dest WHERE src.dest_id = dest.id);
On Fri, Nov 19, 2010 at 11:20 AM, Audra Rudys wrote:
> I figured out a way to do this... rewrote my query as a nested select:
> UPDATE dest SET dest.field = (SELEC
>
> Oops, for logical clarity, it should be:
> UPDATE dest
> SET dest.field =
>(SELECT src.field
>
FROM src, dest
>
WHERE src.id = dest.src_id);
>
(Please disregard earlier message about logical clarity, it sent before I
had a chance to revise the query!)
>
> On Fri, Nov 19, 2010 at 1
This is a syntactical issue:
1) the functio must take form as arguement
def deletepage(form):
decrements total number of pages
decrements page number of each page after the one deleted
2) when registering the callback no ()
crud.settings.update_ondelete = deletepage
On Nov 19, 9:09 am, Au
Let's discuss this on web2py-developers (feel free to join and I will
approve you). Can you explain more in detail how this would work?
On Nov 19, 10:03 am, Carlos wrote:
> Hi,
>
> I have one proposal: extend auth_membership with a new "reference
> auth_context" in order to support a multi-tenant
On this on the local machine you may have an old web2py version.
On Nov 19, 11:01 am, JoeCodeswell wrote:
> For both local and remote machine, the Controllers and Views are
> identical:
>
> ***BUT*** On the local machine I get this ERROR response
>
> Traceback (most recent call last):
> File "g
On Nov 19, 11:21 am, Mariano Reingart wrote:
> I don't fully understand this proposal, but, it shouldn't be posted on
> web2py-developers?
> BTW, is there a patch available?
>
> PS: I think we have to use web2py-developers more, just to not mix
> issues that aren't relevant to users (and in fact,
Actually you cannot this with the DAL. Since this is a one-time step,
I would do
db.executesql("UPDATE dest SET dest.field = (SELECT src.field FROM
src, dest WHERE src.dest_id = dest.id);")
On Nov 19, 11:21 am, Audra Rudys wrote:
> Oops, for logical clarity, it should be:
> UPDATE dest
> SET de
+1 I like the new icon too
On Nov 20, 12:41 am, Bruno Rocha wrote:
> Nice! Much better than the red X.
>
> BTW: please send the icon, I want to replace my X icon right now!
>
> 2010/11/19 ra3don
>
>
>
>
>
>
>
>
>
> > I really like the new admin design, it looks great.
>
> > I've really only got
Hello, how many fields can i define in a model?
Best regards
António
web2py has no limits. Some databases limit to 255
On Nov 19, 9:47 am, António Ramos wrote:
> Hello, how many fields can i define in a model?
>
> Best regards
> António
Let me say that the admin page is nice but as a Lotus Note programmer i have
a excelent admin interface.
Please check it out
http://www.alanlepofsky.net/alepofsky/alanblog.nsf/dx/best-looking-lotus-notes-ever/content/M2?OpenElement
Its just an idea,
Its a lot easier to find and app by an associated
I tried out web2py a while ago and had no issues with it at all.
I just came back to check it out again and get a feel for all of the
new features and I am having issues.
I have tried both the Current and Nightly Builds of both the Mac and
Source Code options here: http://web2py.com/examples/def
Which version exactely do you have? Are you running with apache
+mod_wsgi?
Massimo
On Nov 19, 11:45 am, Will Stevens wrote:
> I tried out web2py a while ago and had no issues with it at all.
>
> I just came back to check it out again and get a feel for all of the
> new features and I am having i
Thanks for the hint, Massimo.
The remote version is web2py Version 1.83.2 (2010-08-15 08:16:30)
The local version isVersion 1.81.5 (2010-07-22 23:56:21)
I'll upgrade.
Thanks again,
Joe
On Nov 19, 9:31 am, mdipierro wrote:
> On this on the local machine you may have an old web2py vers
Thanks for the help! That solved the timing problem!
On Fri, Nov 19, 2010 at 11:26 AM, mdipierro wrote:
> This is a syntactical issue:
>
> 1) the functio must take form as arguement
>
> def deletepage(form):
> decrements total number of pages
> decrements page number of each page after the
I need to get a value from a read-only field when I submit my form, but the
value comes across as none when I reference it (form.vars.field). Other
values from the same record are accessible, so I think my syntax is right.
I'm thinking of creating a hidden field and putting the value into it so
t
2010/11/19 António Ramos :
> Let me say that the admin page is nice but as a Lotus Note programmer i have
> a excelent admin interface.
> Please check it out
> http://www.alanlepofsky.net/alepofsky/alanblog.nsf/dx/best-looking-lotus-notes-ever/content/M2?OpenElement
> Its just an idea,
> Its a lot
Thanks for confirming the DAL limitation here & suggestion. I ended up
doing that, and it worked.
On Fri, Nov 19, 2010 at 11:33 AM, mdipierro wrote:
> Actually you cannot this with the DAL. Since this is a one-time step,
> I would do
>
> db.executesql("UPDATE dest SET dest.field = (SELECT src.f
If it is readonly, the value of the field is known. You should get it
from the source (probably form.record.). If you pass it as a
hidden field you have a security vulnerability.
On Nov 19, 1:41 pm, Audra Rudys wrote:
> I need to get a value from a read-only field when I submit my form, but the
>
That worked, I was able to access the readonly value using
form.record. . Thanks!
On Fri, Nov 19, 2010 at 1:45 PM, mdipierro wrote:
> If it is readonly, the value of the field is known. You should get it
> from the source (probably form.record.). If you pass it as a
> hidden field you have a s
I tried by rsyncing the 'uploads' directory combined with csv-export and
csv-import but I could not import the csv-file. The second app complained
about the format of the file.
Is there another way?
Regards
Johann
--
May grace and peace be yours in abundance through the full knowledge of God
I have tried both version 1.89.4 and the nightly build. I have tried
the Mac and Source Code versions for both.
I prefer using the Source Code options and I am starting it with:
python2.5 web2py.py
or
python web2py.py (which is python 2.6.1 on my Snow Leopard system).
I am not specifying a we
Can I see the format of the file? Like the first few lines?
This should not be happening.
On Nov 19, 2:07 pm, Johann Spies wrote:
> I tried by rsyncing the 'uploads' directory combined with csv-export and
> csv-import but I could not import the csv-file. The second app complained
> about the fo
Is there a folder web2py/deposit?
On Nov 19, 2:28 pm, Will Stevens wrote:
> I have tried both version 1.89.4 and the nightly build. I have tried
> the Mac and Source Code versions for both.
>
> I prefer using the Source Code options and I am starting it with:
>
> python2.5 web2py.py
>
> or
>
> p
On 19 November 2010 22:41, mdipierro wrote:
> Can I see the format of the file? Like the first few lines?
> This should not be happening.
>
>
"forms.id
","forms.form_id","forms.title","forms.phase","forms.purpose","forms.created_on","forms.created_by","forms.updated_on","forms.updated_by"
1,"ESP0
not initially when I download and unzip the source code. however as
soon as I run the command 'python web2py.py', the NEWINSTALL file goes
away and the folder web2py/deposit does get created (and it is empty).
in the admin section of web2py I then try to import the file
'web2py.plugin.wiki.w2p.gz
here is nothng odd with this file. Which web2py version? How are you
doing the import? Can you also post the model (perhaps confidentially)
so I can try debug it?
On Nov 19, 2:46 pm, Johann Spies wrote:
> On 19 November 2010 22:41, mdipierro wrote:
>
> > Can I see the format of the file? Like th
Glad you guys liked the idea, for those interested, here is the icon i used.
http://drise.servehttp.com/Uploads/images/delete_icon.png
Joel.
On Fri, Nov 19, 2010 at 1:43 PM, Branko Vukelic wrote:
> 2010/11/19 António Ramos :
> > Let me say that the admin page is nice but as a Lotus Note progr
It's a bit different from the overall admin style, so I'll have to
look for / make a more appropriate one. It's also a bit larger than
our current delete icon, fyi. I've already tried to make a simple
trash basket, but it's hell of a task at those small sizes. :)
On Fri, Nov 19, 2010 at 10:21 PM,
Tango is really good for small-ass icons like the ones we use (15px).
However, I hate tango, so I used abstract symbols. A trash can is not
an abstract symbol, so it really looks like shit at 15px... unless
it's Tango. :) Ooh. I hate to admit defeat, but I think I'm going to
have wave the white fla
On Thu, Nov 18, 2010 at 10:58 PM, mdipierro wrote:
>
>> I find the migrations to not work that well and fail silently.
>
> there is one catch with migrations. If you use sqlite, you cannot
> change the type of field because sqlite will accept but will not
> actually change the column type. It is b
On Fri, Nov 19, 2010 at 2:31 PM, Anthony wrote:
> On Nov 19, 11:21 am, Mariano Reingart wrote:
>> I don't fully understand this proposal, but, it shouldn't be posted on
>> web2py-developers?
>> BTW, is there a patch available?
>>
>> PS: I think we have to use web2py-developers more, just to not m
On Nov 19, 2010, at 2:20 PM, Branko Vukelic wrote:
>
> Here's the best I've been able to produce so far. Not too disappointing?
Under the circumstances, not bad. But...
OS X uses a red-circle-with-slash for a delete (or move-to-trash) icon. I've
also seen a red X used for the same purpose. Both
Do you want to try the attached image.
I used to program in Foxpro and this is back in the day... 1997
Its 15 x 17px
On 20 November 2010 11:47, Jonathan Lundell wrote:
> On Nov 19, 2010, at 2:20 PM, Branko Vukelic wrote:
> >
> > Here's the best I've been able to produce so far. Not too disapp
Hello, can cron tasks write output to web2py console?
I think not but it would be interesting to have the possibility to debug or
just print messages to the console.
Also in the admin i think that is important to have a task manager page to
see all the cron tasks running in the server without sear
a="""
OK
123456
J01
Brochure Template
412
Design & Layout
1
Chris Spence
2008-10-29T00:00:00
240
true
13:00
17:00
"""
html=TAG(a)
print html.element('status')[0]
print html.element('task id')[0]
On Nov 19, 4:31 pm, Steve Shepherd wrote:
> Hi Folks
>
> Can someone post a code e
The recycle makes people think they can recover the deleted file. That
may not be true.
On Nov 19, 4:47 pm, Jonathan Lundell wrote:
> On Nov 19, 2010, at 2:20 PM, Branko Vukelic wrote:
>
>
>
> > Here's the best I've been able to produce so far. Not too disappointing?
>
> Under the circumstances,
Yes, I know. It occured to me as well. But without it, it looks like a
plain box, which is worse. Anyway, excluding the pixel-art and
tango-styled images, I guess trash can cannot be drawn at 15px. I call
wontfix.
Since we're here, though, I think Jonathan's remark about red circle
with white X ac
On Fri, Nov 19, 2010 at 11:51 PM, Steve Shepherd wrote:
> Do you want to try the attached image.
> I used to program in Foxpro and this is back in the day... 1997
> Its 15 x 17px
Doesn't quite fit in, does it?
--
Branko Vukelić
bg.bra...@gmail.com
stu...@brankovukelic.com
Check out my blog: h
The URL pulls in the 1.4.3 version, locally web2py is using 1.4.4
Replacing 1.4.3 in the google apis URL with 1.4.4 should work, I got a
file with version 1.4.4 when I tried.
Ron
On Nov 19, 2010, at 3:11 PM, Branko Vukelic wrote:
>
> Here's the round delete icon.
I think a red X works better.
There are just random off the web, not to scale.
Apple uses something more like this:
I've seem something along these lines in iOS, though I can't say it says
"delete" to me:
The exact shape of the X icon is not that important. I suggested the
round variant simply because it rocks better with the test icon.
As for the edit icon, if I remember correctly, it was dropped, and I
think it's a good call. Edit is something you use more often than the
other two functions, so i
Hi! Please, how can i catch IntegrityError im trying with "from pyodbc
import IntegrityError" but is not working.
Thanks!
In case anyone is interested, lots of options here (move the slider to
16 to show only the 16x16 icons):
http://www.iconfinder.com/search/?q=delete
http://www.iconfinder.com/search/?q=trash
A couple specific possibilities:
http://www.iconfinder.com/icondetails/9826/16/delete_file_icon
http://www.i
Nice!
Its one more récipe to be included somewhere in the book.
Enviado via iPhone
Em 19/11/2010, às 20:57, mdipierro escreveu:
> a="""
>
> OK Status>
>
> 123456 ID>
>
> J01 ID>
> Brochure Template Name>
> Job>
>
> 412 ID>
> Design & Layout Name>
> Task>
>
> 1 ID>
> Chris Spence
All good points, Mariano. Thanks.
Anthony
On Nov 19, 5:46 pm, Mariano Reingart wrote:
> On Fri, Nov 19, 2010 at 2:31 PM, Anthony wrote:
> > On Nov 19, 11:21 am, Mariano Reingart wrote:
> >> I don't fully understand this proposal, but, it shouldn't be posted on
> >> web2py-developers?
> >> BTW,
I am trying to query multiple IDs which is generated dynamically..
i try like this :
to_get=[1,2,4,5]
q= db.casedb.id in toget
db(q).select(db.casedb.ALL)
that results in whole set of records instead of id specified in to_get..
How to achieve this? have to loop through?
Eratta :
to_get=[1,2,4,5]
q= db.casedb.id in to_get # Guess this wont work?
db(q).select(db.casedb.ALL)
On Sat, Nov 20, 2010 at 7:54 AM, Phyo Arkar wrote:
>
> to_get=[1,2,4,5]
>
> q= db.casedb.id in toget
> db(q).select(db.casedb.ALL)
This can be done in Query easily as
SELECT * FROM table WHERE table.id IN (1,2,4,5)
Theres no DAL equvlient ? i have to execute SQL?
On Sat, Nov 20, 2010 at 8:00 AM, Phyo Arkar wrote:
> Eratta :
>
>
>
>
> to_get=[1,2,4,5]
>
> q= db.casedb.id in to_get # Guess this wont work?
>
> db(q).select(d
GOT IT
db.table.key.belongs
I cant find it in web2py book is there is?
On Sat, Nov 20, 2010 at 8:11 AM, Phyo Arkar wrote:
> This can be done in Query easily as
>
> SELECT * FROM table WHERE table.id IN (1,2,4,5)
>
> Theres no DAL equvlient ? i have to execute SQL?
>
>
> On Sat, Nov 20, 2010 a
http://web2py.com/book/default/chapter/06#belongs
2010/11/19 Phyo Arkar
> GOT IT
>
> db.table.key.belongs
>
>
> I cant find it in web2py book is there is?
>
>
> On Sat, Nov 20, 2010 at 8:11 AM, Phyo Arkar wrote:
>
>> This can be done in Query easily as
>>
>> SELECT * FROM table WHERE table.id
Not mentioned in the book that you can get the NOT IN SQL expression
my_list = [1,2,3,4]
NOT IN LIST: db(~(db.product.id.belongs(my_list))).select()
IN LIST: db(db.product.id.belongs(my_list)).select()
2010/11/19 Bruno Rocha
> http://web2py.com/book/default/chapter/06#belongs
>
>
>
> 2010/11
It's not that there is a problem with the red X suggesting that it is to
delete the file, it's just all of those red X's in a line on the page seem
to be overwhelming. Most of us associate red with negative.
I'd like to suggest another fix:
How about we turn the red X into a checkbox (think Gmail
Cool thanks Bruno!
On Sat, Nov 20, 2010 at 8:30 AM, Bruno Rocha wrote:
>
> Not mentioned in the book that you can get the NOT IN SQL expression
>
> my_list = [1,2,3,4]
>
> NOT IN LIST: db(~(db.product.id.belongs(my_list))).select()
>
> IN LIST: db(db.product.id.belongs(my_list)).select()
>
>
>
On Nov 19, 9:06 pm, Joel Clay wrote:
> How about we turn the red X into a checkbox (think Gmail) You check the box
> and at the top there are links to perform actions (in this case delete). In
> my opinion, this kills two birds with one stone -- it increases ease of
> deletion of multiple files an
Apache, mod_wsgi, linux, MySQL, web2py 1.89.4, source
I tried to change the admin password and got this error ticket.
Error ticket for "admin"
Ticket ID
Version
web2py™ Version 1.89.4 (2010-11-19 02:50:05)
Python Python 2.6.5: /usr/bin/python
Traceback
Traceback (most recent call last):
File
1 - 100 of 109 matches
Mail list logo
