How do I provide a complex query which selects data from varius
tables to jqgrid?
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 knowl
I am finishing a new project today, which every content is wrote in markmin
http://natalanimal.com.br/
This is a site of an animal protection association, which aims to raise
donations and sponsors to animals at Christmas.
I made it based on e-store, I am almost finishing some details.
Thank you
done
On Nov 9, 11:21 pm, Bruno Rocha wrote:
> Minor suggestion for MARKMIN()
>
> If I am fetching the Markmin content from database, and database field is
> empty (None), MARKMIN raises an error.
>
> I am solving this problem with :
>
> MARKMIN(myfield or ' ')
>
> But, I think MARKMIN can itself
If you start up web2py with key/cert for SSL, web2py runs in SSL mode.
In the startup message it says you can connect via http, but if you attempt
to connect via plain http, you will get a
"Bad Request"
in your browser.
[d...@thinkbox web2py]$ python web2py.py -c mycert.pem -k mycert.pem -i
192
You are definitely correct. I mis-read what you had, but what I put
up, you can still use as well if you need to pass args via the URL.
In any case, if I am understanding this correctly, it seems to be more
of a problem of getting the selected value of the option, correct?
There are probably sev
Minor suggestion for MARKMIN()
If I am fetching the Markmin content from database, and database field is
empty (None), MARKMIN raises an error.
I am solving this problem with :
MARKMIN(myfield or ' ')
But, I think MARKMIN can itself resolve what to do if the received arg is
NoneType)
File "/
On Nov 9, 2010, at 9:06 PM, Ruiwen Chua wrote:
>
> Is there no way around it? Or..?
>
> I'd just prefer my URLs to be clean. The users dont' really need to
> see all the additional information.
You might try setting error_handler instead of routes_onerror.
>
> //Ruiwen
>
> On Nov 10, 11:36 am
Is there no way around it? Or..?
I'd just prefer my URLs to be clean. The users dont' really need to
see all the additional information.
//Ruiwen
On Nov 10, 11:36 am, mdipierro wrote:
> No. Why?
>
> On Nov 9, 5:16 am, Ruiwen Chua wrote:
>
>
>
>
>
>
>
> > Hi all,
>
> > I'm trying to route error
Are you sure there are records coming back? Try doing a "print
records" and make sure data is coming back. Sounds like it just may
be an empty result set from the query.
On Nov 9, 6:50 pm, Lorin Rivers wrote:
> I think I'm close:
> given this controller
>
> my_macaddr = db4().select(db4.data_ta
You should be able to access the variables passed by your form
through: request.vars
ex. Given a form with this control:
You can access this in the controller through: request.vars.chatText
On Nov 9, 6:04 pm, Lorin Rivers wrote:
> OK, I answered my own question from before.
>
> I now have i
Oh! I think i have to read the whole book before asking questions xD
Thanks man!
On Nov 9, 9:47 pm, DenesL wrote:
> Hi Cesar,
>
> that is the default
> behaviourhttp://web2py.com/book/default/chapter/10#Confirmation-on-Delete
>
> On Nov 9, 8:41 pm, CesarBustios wrote:
>
>
>
>
>
>
>
> > Hi, aft
No. Why?
On Nov 9, 5:16 am, Ruiwen Chua wrote:
> Hi all,
>
> I'm trying to route errors like 400, 403 and 404 to nice, clear URLs
> like '/error/', '/forbidden/' and '/whoops/'.
>
> Unfortunately, the Web2Py Book's section on error routing
> (http://www.web2py.com/book/default/chapter/04?search=
you may have different python versions installed. Check the one used
by modwsgi
On Nov 9, 3:02 pm, azarkowsky wrote:
> Hi,
>
> I'm relatively new to web2py and am attempting to set up my production
> environment for the first time. I'm running Apache2.2 with mod_wsgi,
> python 2.7, & web2py 1.88
http://code.google.com/p/android-scripting/issues/detail?id=276
On Nov 9, 6:18 pm, pallav wrote:
> I checked and the line was already commented out.
>
> I don't know how to run web2py with the switch -N because I have to
> run it from inside the interactive python shell by typing import
> web2py.
On Nov 9, 7:16 pm, Ruiwen Chua wrote:
> Hi all,
>
> I'm trying to route errors like 400, 403 and 404 to nice, clear URLs
> like '/error/', '/forbidden/' and '/whoops/'.
>
> Unfortunately, the Web2Py Book's section on error routing
> (http://www.web2py.com/book/default/chapter/04?search=error#Ro
Hi Cesar,
that is the default behaviour
http://web2py.com/book/default/chapter/10#Confirmation-on-Delete
On Nov 9, 8:41 pm, CesarBustios wrote:
> Hi, after clicking the submit button (when deleting), is there a way
> to send a confirmation message like saying "Are you sure man, really
> really
Hi Massimo and Cesar. First of all another one zillion thxz to the
Extremely Amazing Framework ever created !
I have a sittuation that is not the same as Cesar:
http://groups.google.com/group/web2py/browse_thread/thread/c83cd69dee02c9b1/065c44106598d69b?lnk=gst&q=upload+#065c44106598d69b
but some
Hi,
I'm relatively new to web2py and am attempting to set up my production
environment for the first time. I'm running Apache2.2 with mod_wsgi,
python 2.7, & web2py 1.88.2 on Win XP SP3. If I run web2py without
Apache by running: 'python web2py.py -a "" -i 127.0.0.1 -p
8000' I can access both m
Alex,
Thanks. I thought based on the book that the 2nd argument of ajax was
passing the values to request.vars.variable. I pasted some of the
code from the book below for reference (http://web2py.com/book/default/
chapter/10?search=ajax#The-ajax-Function). Based on this I originally
had the cod
Hi, after clicking the submit button (when deleting), is there a way
to send a confirmation message like saying "Are you sure man, really
really sure???" or something like that?
Thanks!
nice service, and a cost-effective way to get publicity.
On Nov 10, 12:50 am, mdipierro wrote:
> http://blog.twilio.com/2010/11/attention-pythonistas-twilio-has-a-con...
I think I'm close:
given this controller
my_macaddr = db4().select(db4.data_table.MacAddr, distinct=True)
def display_form():
form = FORM(TR("Select a MAC Address :",
SELECT(_name='MacAddrSelect',
*[OPTION(my_macaddr[i].MacAddr, _value=str(my_macaddr[i].MacAddr)) for i in
range(len(my_ma
I checked and the line was already commented out.
I don't know how to run web2py with the switch -N because I have to
run it from inside the interactive python shell by typing import
web2py.web2py and hitting enter.
What does the switch -N do? I can try to simulate the same effect by
modifying th
OK, I answered my own question from before.
I now have in my controller:
my_macaddr = db4().select(db4.data_table.MacAddr, distinct=True)
def display_form():
form = FORM(TR("Select a MAC Address :",
SELECT(_name='MacAddrSelect',
*[OPTION(my_macaddr[i].MacAddr, _value=str(my_macaddr[i].Mac
thanks Massimo, works great !
cheers,
Stef
On 09-11-2010 20:12, mdipierro wrote:
> No but you can do
>
> db(condition).update(**d) or db.table.insert(**d)
> On Nov 9, 1:00 pm, Stef Mientki wrote:
>> hello,
>>
>> I wonder if there is a "insert or replace" or another mechanism, when insert
>> fail
On 05-11-2010 23:26, Tomeu Roig wrote:
>
> Hi, before to make the insert, you need change the string ascii to utf8,
>
> Newvalue=value.encode(utf-8)
>
first of all a small type, quotes around utf-8 needed.
Newvalue=value.encode( ' utf-8' )
But then it still doesn't work in my situation.
I
You can define all the functions of the default controller that you
want to match:
FUNCTIONS = ["A", "B", "C"]
routes_in = (
('/', '/myapplic/default/index'),
('/(%s)' % "|".join(FUNCTIONS), r'/myapplic/default/\1'))
routes_out = (
('/myapplic/default/index', '/'),
('/myapplic/default/(%s)' % "|
On Nov 9, 3:52 pm, mdipierro wrote:
> This could be another typos in the book.
>
> layout.html should be
>
> {{extend 'plugin_layout_name/layout.html'}}
> {{include}}
Fixed in the book.
Speedwise, you should use many2many if you plan to search the referee
by the refereed. If you only need the refereed after you already have
the referee you can use list:reference. If you are on GAE
list:reference is better because native and GAe has no joins.
On Nov 9, 2:43 pm, Carlos wrote:
> Hi
Right. I would not use crud.select(table,query) but simply
rows=db(query).select()
On Nov 9, 2:38 pm, Carlos wrote:
> Hi Massimo,
>
> Thanks, but do you mean to loop through the rows after calling
> crud.select (which returns a list a of dictionaries)?.
>
> Or what do you mean by 'build your row'
Hi all,
I am wondering, with respect to many-to-many relationships, is it
better to use "list:reference" or a separate table (with foreign
keys)?.
I refer to 'simple' many-to-many where no extra attributes need to be
stored (otherwise the separate table is the only choice).
Thanks,
Carlos
Hi Massimo,
Thanks, but do you mean to loop through the rows after calling
crud.select (which returns a list a of dictionaries)?.
Or what do you mean by 'build your row' in each loop?.
Is it possible to create a dummy/transient table field in order to
assign the required dynamic value during thi
Has anybody else here had a similar problem?
massimo
On Nov 9, 11:29 am, David Zejda wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi :)
>
> E.g. now the exception was raised by the web2py internal db
> initialization routine:
>
> 28: db = SQLDB('mysql://myus:myp...@localhost:330h
As a debug check. I'd like to see what you gate if you "print data"
before the update.
Just in case what you put it in it is not what you get.
On Nov 9, 1:25 pm, Omri wrote:
> in the qooxdoo application, I define data as
> data = {name: "Prüfung", textfield : "Etwas mit umlaut- üäüöö"}
> and then
in the qooxdoo application, I define data as
data = {name: "Prüfung", textfield : "Etwas mit umlaut- üäüöö"}
and then send it through an asynchronous call (using
qx.io.remote.Rpc.callAsync)
On Tue, Nov 9, 2010 at 19:42, mdipierro wrote:
> can you print data? What is in data?
>
> On Nov 9, 12:2
{{=IMG(_src=URL(r=request,a='base',c='static',f='base/card/logos/' +
logo[0].link) _width="228px")}}
should be
{{=IMG(_src=URL('static','base/card/logos/%s' % slogo[0].link),
_width="228px")}}
, was missing
On Nov 9, 1:07 pm, annet wrote:
> I get an error on the following code:
>
> {{=IMG(_src=
No but you can do
db(condition).update(**d) or db.table.insert(**d)
On Nov 9, 1:00 pm, Stef Mientki wrote:
> hello,
>
> I wonder if there is a "insert or replace" or another mechanism, when insert
> fails ?
>
> thanks,
> Stef Mientki
I get an error on the following code:
{{=IMG(_src=URL(r=request,a='base',c='static',f='base/card/logos/' +
logo[0].link) _width="228px")}}
Traceback (most recent call last):
File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/
restricted.py", line 186, in restricted
ccode = compile
hello,
I wonder if there is a "insert or replace" or another mechanism, when insert
fails ?
thanks,
Stef Mientki
Sorry there is not. You may better off looping
{{for row in rows:}}
... build your row ...
{{pass}}
On Nov 9, 12:37 pm, Carlos wrote:
> Hi all,
>
> I'm using crud.select / SQLTABLE, and I need to show one column with
> links/actions generated dynamically based on conditions found for each
> row
can you print data? What is in data?
On Nov 9, 12:20 pm, Omri wrote:
> I did some tryouts and it seems that the only problem is with the
> update method, and then only when called through service.jsonrpc. I
> created the following model:
>
> db.define_table("debug_stuff",
> Field("name",
true
On Nov 9, 12:19 pm, Branko Vukelic wrote:
> On Tue, Nov 9, 2010 at 4:12 PM, Bruno Rocha wrote:
> > I Just included PySerial and another modules to access peripherals on host
> > machine.
> > I just take web2py, include my app folder and the modules/binaries I needed,
> > I dont think it bro
Many things you can already do:
On Nov 9, 11:40 am, blackthorne wrote:
> I think it would be important to have it all, but at least...
> generate model
> sync model
> create application (skeleton)
mkdir applications/myapp
cp -r applications/welcome/* application/myapp
> install packet applicati
Hi all,
I'm using crud.select / SQLTABLE, and I need to show one column with
links/actions generated dynamically based on conditions found for each
row data.
I believe I can not use 'represent' because that's linked to a single
field only (lambda field: ...).
Is there something like "lambda row:
I see two options:
1) use
db.table.field.represent = lambda value: DIV(value)
and give any representation you want to the field value.
2) If this does not work make your own SQLTABLE helper:
def mytable(rows, cols):
return TABLE(*[TR(*[TD(row[c]) for c in cols]) for row in rows)
On
I did some tryouts and it seems that the only problem is with the
update method, and then only when called through service.jsonrpc. I
created the following model:
db.define_table("debug_stuff",
Field("name", length=100),
Field("textfield", "text"),
format="%(name)s")
and d
On Tue, Nov 9, 2010 at 4:12 PM, Bruno Rocha wrote:
> I Just included PySerial and another modules to access peripherals on host
> machine.
> I just take web2py, include my app folder and the modules/binaries I needed,
> I dont think it broke any license. or I am wrong?
You can't break GPL if you
I think it would be important to have it all, but at least...
generate model
sync model
create application (skeleton)
install packet application
compile application
pack application
uninstall application
update language files
change admin password
upload (from url) & install packed application
Sec
I want to customize the result of SQLTABLE so that it can make me a
nice table without lines and lines of code in my view file. To
achieve that, I need for example to:
1) Add columns to hold icons and links and extra stuff.
2) Customize the rows, e.g. links which depend on content, different
i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi :)
E.g. now the exception was raised by the web2py internal db
initialization routine:
28: db = SQLDB('mysql://myus:myp...@localhost:330h6/mydb', pool_size=10)
Traceback (most recent call last):
File "/opt/web2py/gluon/restricted.py", line 188,
After upgraded I got exception when try to redirect using
redirect(URL()).
I used to do :
return redirect(URL(r=request, f='modelo'))
but it works no more, gives me a ticket that don´t tells the error
just the line.
The folowing is an exerpt from the ticket thrown by the book example:
def redire
Interesting about form validation design
http://webdesign.tutsplus.com/articles/design-theory/user-experience-designing-form-validation-the-right-way/
How can I add the JavaScript:
var server_time="test"
to the vars dict:
callback = URL(r=request,c='plugin_jqgrid',f='data',
vars=dict(tablename=table._tablename,
columns=','.join(columns),
fieldname=fieldname or '',
On Tue, Nov 9, 2010 at 1:44 PM, Bruno Rocha wrote:
> I just need to find out how to edit .svg in a Mac. I'll try InkScape for
> Mac/X11
It's an Inkscape SVG, so Inkscape would be your best bet. Just so you
know, line wrapping is manual (that's how I did it, that is).
--
Branko Vukelić
bg.bra
This could be another typos in the book.
layout.html should be
{{extend 'plugin_layout_name/layout.html'}}
{{include}}
but replacing the file entirely is fine.
On Nov 9, 4:25 am, John Murphy wrote:
> There are numerous web2py themes, but none of them are very good. So I
> decided to make a n
There are numerous web2py themes, but none of them are very good. So I
decided to make a nice one based on:
http://demo.woothemes.com/?name=meta-morphosis.
I'm creating a layout plugin according to these instructions:
- http://web2py.com/book/default/chapter/13#Layout-plugins
- http://www.web2py.c
On Tue, Nov 9, 2010 at 3:04 PM, Branko Vukelic wrote:
> On Tue, Nov 9, 2010 at 1:44 PM, Bruno Rocha wrote:
>> I just need to find out how to edit .svg in a Mac. I'll try InkScape for
>> Mac/X11
>
> It's an Inkscape SVG, so Inkscape would be your best bet. Just so you
> know, line wrapping is manu
This is not a well defined concept. You can look into sessions/ and
figure out which files were modified within the last N minutes.
On Nov 9, 4:50 am, salbefe wrote:
> Hello,
>
> I would like to know how can I obtain the number of the current users
> that are logged on.
>
> Thanks in advance!
wait. You should not need to delete files. The language is set by your
browser.
On Nov 9, 3:41 am, Stefan Scholl wrote:
> Oops, found it 5 minutes later.
>
> In case somebody wants to switch back to English, too:
>
> Delete (or rename) your language in applications/admin/languages
I am working on Inkscape for Mac! very nice!, I should never open coreldraw
or Illustrator anymore.
Thank you!
2010/11/9 Branko Vukelic
> On Tue, Nov 9, 2010 at 3:04 PM, Branko Vukelic
> wrote:
> > On Tue, Nov 9, 2010 at 1:44 PM, Bruno Rocha
> wrote:
> >> I just need to find out how to edit .
Perfect. Thanks. I did not know.
On Nov 9, 1:54 am, Branko Vukelic wrote:
> On Tue, Nov 9, 2010 at 8:05 AM, mdipierro wrote:
> >> - 'logout' in french ('deconnexion') is too long for the button area
> >> (top right buttons in the design view).
>
> > this is a major problem. Now that all buttons
I just need to find out how to edit .svg in a Mac. I'll try InkScape for
Mac/X11
2010/11/9 Branko Vukelic
> On Tue, Nov 9, 2010 at 2:54 AM, Bruno Rocha wrote:
> > Branko, I want to have a portuguese version, do you mind if I edit the
> file
> > translating into portuguese?
>
> Sure, Bruno. Here
Well, shell mode is not quite what I was looking for but thank you.
Many of us, prefer to use a common IDE such as Netbeans or Emacs or
Wing, or even an OS like Emacs. The command-line is a first class tool
for developers and it is great to integrate with my IDE or bash
script.
It would be nice to
On Nov 9, 2:27 pm, Bruno Rocha wrote:
> I use this script to create my custom web2py.exe
>
> http://code.google.com/p/web2py/source/browse/setup_exe.py
I just saw the Makefile in the web2py folder now. It does everything
it seems, except on Windows if you don't have a make available :(
Will tr
What operations specifically do you want to do in shell mode?
On Nov 9, 7:20 am, blackthorne wrote:
> Well, shell mode is not quite what I was looking for but thank you.
> Many of us, prefer to use a common IDE such as Netbeans or Emacs or
> Wing, or even an OS like Emacs. The command-line is a f
On Nov 9, 3:34 pm, mdipierro wrote:
> It is a delicate process that can go wrong and the produced binaries
> may violate the GPL license.
That's a fair point. I think I am going to use Portable Python
(2.6.1) and the source distro of web2py. That also gives me a no-
install version. Among oth
I use this script to create my custom web2py.exe
http://code.google.com/p/web2py/source/browse/setup_exe.py
2010/11/9 cjrh
> Is there a recipe somewhere showing how the binary win version of
> web2py is produced? I would like to make my own custom zip for
> easier in-house distribution, and u
http://blog.twilio.com/2010/11/attention-pythonistas-twilio-has-a-contest-just-for-you-ends-1114.html
I discourage making your own binaries using setup_exe.py unless you
need to package additional binary python modules that do not come with
the official distribution.
It is a delicate process that can go wrong and the produced binaries
may violate the GPL license.
Instead this process is easier:
ht
I would like to make a custom binary distro zip of web2py, using a
different version of python (2.6 or 2.7) and incorporating PIL.
Are there any recipes somewhere showing how to setup the toolchain? I
already know about the file setup_exe.py in the web2py folder, I
reckon that will feature promin
On Nov 9, 12:16 am, mdipierro wrote:
> This is not the first image I have seen this this format (thin and
> long) but I am not sure I understand what it is intended for.
Beauty. DeviantArt has a great many like this for Photoshop
tutorials, for example.
Is there a recipe somewhere showing how the binary win version of
web2py is produced? I would like to make my own custom zip for
easier in-house distribution, and using different version of python,
for example.
You can use from the command line
-S Run in shell mode
appname connect with an app
-M execute the app models
$python web2py.py -S appname -M
to generate SQL code you have to use _ before DAL methods such as:
db(...)_select()
2010/11/9 blackthorne
> Is there a way so that I can use all web2py
Is there a way so that I can use all web2py operations, such as
generating the SQL code from the model definition from the command-
line or is the web interface our only option?
Thank you
Best regards
I Just included PySerial and another modules to access peripherals on host
machine.
I just take web2py, include my app folder and the modules/binaries I needed,
I dont think it broke any license. or I am wrong?
2010/11/9 mdipierro
> I discourage making your own binaries using setup_exe.py unles
Hi all,
I'm trying to route errors like 400, 403 and 404 to nice, clear URLs
like '/error/', '/forbidden/' and '/whoops/'.
Unfortunately, the Web2Py Book's section on error routing (http://
www.web2py.com/book/default/chapter/04?search=error#Routes-on-Error)
is pretty sparse, and I haven't been a
Hello,
I would like to know how can I obtain the number of the current users
that are logged on.
Thanks in advance!
Oops, found it 5 minutes later.
In case somebody wants to switch back to English, too:
Delete (or rename) your language in applications/admin/languages
Just upgraded web2py and now I get everything in German. That's not a
good idea if you are a programmer. The programming world and all the
terms are English. And in case of an error I can't ask here, because
you can't understand the error messages. :-(
Is there a way to switch back the Admin inter
Just upgraded web2py and now I get everything in German. That's not a
good idea if you are a programmer. The programming world and all the
terms are English. And in case of an error I can't ask here, because
you can't understand the error messages. :-(
Is there a way to switch back the Admin inter
80 matches
Mail list logo
