Thanks a lot, Bruno.
That really helps, but since my legacy DBs are too much and too
complex (MSSQL Server are only readable to me), I decide to create my
own connections and queries to my MSSQL Server.
Thanks again.
On Jan 18, 3:57 pm, Bruno Rocha wrote:
> You need to map the existent table and
So you can use:
results = msdb.execute_sql("SELECT * FROM table.")
--
Bruno Rocha
[http://rochacbruno.com.br]
Hi all
I have installed PDFMiner a tool for extracting information from PDF
document and convert in to text.
http://www.unixuser.org/~euske/python/pdfminer/
From command line I can manually convert PDF files to text. But I want to
use this functionality in my web2py application. In my applicat
Hi,
Thanks for your reply, I almost got the modal form dialog to work ...
First the form dialog doesn't appear as a modal dialog, it leaves the
original page, i.e. the url changes from: http://127.0.0.1:8000/init/admin/index
to http://127.0.0.1:8000/init/default/user/login, therefore the
underlyi
Does the first problem has anything to do with auth_menu:
in menu.py:
if 'auth' in globals():
if not auth.is_logged_in():
response.auth_menu = [
['Login',request.function=='user' and
request.args(0)=='login',URL('default','user/login')],
['Gebruikersnaam opvra
Cool, How can i forgot the executesql!
thank you very much!!!
On Jan 18, 4:19 pm, Bruno Rocha wrote:
> So you can use:
>
> results = msdb.execute_sql("SELECT * FROM table.")
>
> --
>
> Bruno Rocha
> [http://rochacbruno.com.br]
This is not recognized asa string:
"{{this is a string}}" in:
{{=PRE("{{this is a string}}"))}in a web page
but it works on the command line:
>>PRE("{{this is a string}}").xml()
Dear all ,
how can i use the VideoLibrary from web2py appliances , i installed
the pack to my web2py but its not converting any videos !! , how can
i
fix it and is this application can be used in in a website and i can
deploy it ??
Hi,
Could you not use {{=XML(string...)}}
Regards,
Nils
On Jan 18, 2012 9:43 a.m., "davidjensen" wrote:
> This is not recognized asa string:
> "{{this is a string}}" in:
> {{=PRE("{{this is a string}}"))}in a web page
> but it works on the command line:
> >>PRE("{{this is a string}}").xml
Hi,
Thanks for the reply.
Yes for this specific project, I have managed to generate some monthly
computed data at the entry time, so that I can show reports like
accounts ledger, receive-payment in month range. Still this is in
adequate, but okay for now. For another project that I am trying to
m
Does anyone have an opinion about the web2py video lectures from
codeschool.org ? I had a look at the first video and I thought it was
quite a nice intro:
http://www.youtube.com/playlist?list=PL978B2CE2D788F745
Just had a little surprise -- feels like a bug to me but let's hear
from the experts.
Having read in the web2py book that models are executed in name-sort
order, I changed the names of my model files to have more explicit
ordering -- from db.py and appconfig.py to 100-db.py and 000-
appconfig.py.
Ok, guys & gals, I'm in dire need of some advice.
I'm using web2py components extensively and they work fine, of course. But
I need to find a solution to make browser history aware of components being
loaded.
I'm aware of projects such as:
- history.js ( https://github.com/balupton/History.js/
Rocket doesn't seem to like the --interfaces parameter. This is my command
line string:
python web2py.py -a ""
--interfaces="0.0.0.0:8001:/home/ross/Desktop/web2py/scripts/service/ca.crt:/home/ross/Desktop/web2py/scripts/service/ca.key"
When this is run, I get the following:
ERROR:Rocket.Error
Ah you want the whole URL to be in a dialog. I spent ages figuring
this out and the answer is already included in web2py!! You just
include the code below and then you can just replace any url with
dialog(url) and it will show up in a dialog. Brilliant!!
// create dialogbox
document.write("")
$(d
You will find that the underscore is required for a lot file names, not
just models, as using a hypen in a variable name is invalid in Python.
Modules are the same way. You can't do this:
import my-module
The Python syntax is invalid. The same is true for models. I believe it
also applies to c
It bombs on PRE, CODE, and now XML
On Jan 18, 3:13 am, nils wrote:
> Hi,
> Could you not use {{=XML(string...)}}
> Regards,
> Nils
> On Jan 18, 2012 9:43 a.m., "davidjensen" wrote:
>
>
>
>
>
>
>
> > This is not recognized asa string:
> > "{{this is a string}}" in:
> > {{=PRE("{{this is a str
On 17 jan, 21:58, Massimo Di Pierro
wrote:
> Please open a ticket. What's the latest version that worked? Can you
> show how you expose the service?
The last version I used is 1.94.5 from march/april last year.
Are older web2py archives available somewhere for testing ?...
Here is the code I'm u
Hi Massimo,
here I am.
I tried other browsers as well, so it seems to be more fundamental then my
Mac.
Asked a windows users as well, and he get's the same error. So it looks
more and more likely (even so I don't understand this stuff) that something
with our department's network setup is weird?
Dear All ,
i am going to build a online music training center , so a lot have
recommended me with the GAE , i dont know what is it and , i really
dont know from where to start , i need help guys because this is
something so big for python and web2py and us the web2py developers
so we can prove to
Thank you Michael,
I will play some more with it today. I may come back with some
questions...
I anybody else having problems with redirects in http://web2py.com/demo_admin
?
Please me know it would help isolate the problem. I suspect it is a
session issue since I fiddle with admin authentication
Because the {{ }} operator have precedence over everything else.
when web2py finds
{{=PRE("{{this is a string}}"))}
interprets it as
OPEN{{ =PRE("{{this is a stringCLOSE}}"))}
when you want to put < and > in HTML you have to escape them with <
and >
similarly if you want t
Got it. The problem is that you are using an internal object here
(rows.response)
status, response.flash = client.accept(rows.colnames,
rows.response)
and something has changed in there. Notice the error is not in the
server but in the client. rows is a Rows object generated by
db().selec
On Wed, Jan 18, 2012 at 9:42 AM, Web2Py Freak wrote:
> Dear All ,
>
> i am going to build a online music training center , so a lot have
> recommended me with the GAE , i dont know what is it and , i really
> dont know from where to start , i need help guys because this is
> something so big for
Hi,
that's my model
db.define_table('report',
Field('person', 'reference auth_user',
#requires=IS_IN_DB(db, db.auth_user.id, "%(last_name)s" ), # <--
look here
),
Field('text'),)
and that's a function:
def report():
grid = SQLFORM.smartgrid(db.auth_user,
linked
Not change soo fast, de current version must be in pypi ande develop en
git, must be branches for github for devel and mater(current stable
version).
Only need little code organization
2012/1/17 pbreit
> Web2py changes too fast to use anything but source, in my opinion.
--
Alvaro Lizama Mo
Have you tried removing the last , after the IS_IN_DB()?
On Wed, Jan 18, 2012 at 7:05 AM, Martin Weissenboeck wrote:
> Hi,
>
> that's my model
>
> db.define_table('report',
>Field('person', 'reference auth_user',
> #requires=IS_IN_DB(db, db.auth_user.id, "%(last_name)s" ), #
> <--
You could also define the string in the controller and pass it to the view:
def action():
return dict(mystring=PRE('{{this is a string}}'))
View:
{{=mystring}}
Or if you need to do this frequently in views, you could define a special
helper:
class BRACE(DIV):
def xml(self):
I'm not experiencing any redirects (Windows IE and Chrome).
Anthony
On Wednesday, January 18, 2012 9:42:59 AM UTC-5, Massimo Di Pierro wrote:
>
> Thank you Michael,
>
> I will play some more with it today. I may come back with some
> questions...
>
> I anybody else having problems with redirec
firefox on ubuntu
no problems
On Wed, Jan 18, 2012 at 4:53 PM, Anthony wrote:
> I'm not experiencing any redirects (Windows IE and Chrome).
>
> Anthony
>
>
> On Wednesday, January 18, 2012 9:42:59 AM UTC-5, Massimo Di Pierro wrote:
>
>> Thank you Michael,
>>
>> I will play some more with it tod
Hello Massimo,
It would be great if you could tag a release while committing to github.
It will enable us to fetch the latest stable release from github easily
- Instead of looking at the VERSION file and backtracking the commit no
to checkout to.
Thanks,
Praneeth
A field has two attributes, requires and represent. If web2py finds a
'reference auth_user" but no requires, it assumes
db.report.person.requires=IS_IN_DB(db, db.auth_user.id,
db.auth_user._format)
db.report.person.represent = lambda id: db.auth_user._format %
db.auth_user[id]
If you give a custo
Any chance you can open the browser, clear cache. list the steps you
take until you encounter the problem.
This is clearly something subtle and fixing is very valuable to us.
Other apps may have this problem and we do not know.
Thanks for your help on this.
Massimo
On Jan 18, 4:15 am, Michael Aye
Will do.
On Jan 18, 10:17 am, Praneeth wrote:
> Hello Massimo,
>
> It would be great if you could tag a release while committing to github.
> It will enable us to fetch the latest stable release from github easily
> - Instead of looking at the VERSION file and backtracking the commit no
> to chec
What line?
On Jan 17, 10:16 pm, ttsujie wrote:
> First I don't know that it's need to update default version setting
> after update version at app.yaml.
> After update default version, that go good.
> I'm sorry for lack of my GAE knowlege.
> (I'm ashamed..)
>
> Anyway if someone encounter the sam
I forgot you also need to include in your controller instructions to
open and close the dialog e.g.
if form.process(.
response.js="$('#dialogdiv').dialog('close');"
elif form.errors:
pass
else:
response.js="$('#dialogdiv').dialog('open').focus();"
On Jan 18, 1:44 p
Hi,
Thanks for your reply, I am not sure I completely understand your
solution.
In which file(s) do I put the following lines of code:
> // create dialogbox
> document.write("")
> $(document).ready(function(){
> $('#dialogdiv').dialog({autoOpen : false, modal : false, width :
> 'auto'});
I'm trying to make alive the existing application with DB2 database
(currently running with PostgreSQL 9.x with no problem). I'm using latest
DB2 Express version and I just find out, that all fields defined in DAL as
'text' are created in DB2 as 'CLOB' datatype. Table is created succesfully
but
Hi, I am interested to run web2py on an android tablet pc. Please could you
describe what you have done?
Thx, Martin
Am 17.01.2012 20:49 schrieb "fpp" :
> Hi,
>
> I have this very old web2py app that has been working 24/7 since early
> 2008...
>
> One instance runs on my phone (Nokia N900, a Linu
> I forgot you also need to include in your controller instructions to
> open and close the dialog e.g.
How would I include that in the user function:
def user():
form=auth()
if isinstance(form,FORM):
if 'auth' in globals():
if not auth.is_logged_in():
Master branch must be de stable release and de devel branch for the trunk :)
We should implement this workflow is a easy way to work with git
http://nvie.com/posts/a-successful-git-branching-model/
2012/1/18 Massimo Di Pierro
> Will do.
>
> On Jan 18, 10:17 am, Praneeth wrote:
> > Hello Mass
Hi,
TYMR is a social network (developed in web2py) for creating, managing
& promote any type of events.
This all-in-one solution is private at the moment, but the web2py
community can be a part of this exclusive network by registering here:
http://tymr.com/register/web2py
Any feedback is truly a
Thank you very much - that is the solution! I have spent some hours...
Therefore I think, this is a very important hint - is it in the book?
2012/1/18 Massimo Di Pierro
> A field has two attributes, requires and represent. If web2py finds a
> 'reference auth_user" but no requires, it assumes
>
>
Put the jquery stuff in a file and include it in any view where you
want to call the dialog function.
The document.write just adds a container for the dialog box. You could
just as easily put the html in the page directly but I put it here so
that it is all together in one js file which can be inc
Looks very cool!
The inside looks amazing!
I'll try it later today, thanks!
Javier Q
Dear All ,
What is the best way to integrate Paypal with web2py ?
Very Good, the code be available?
Ovidio Marinho Falcao Neto
Web Developer
ovidio...@gmail.com
ovidiomari...@itjp.net.br
ITJP - itjp.net.br
83 8826 9088 - Oi
83 9334 0266 - Claro
I felt a little heavy, you can say something?
Ovidio Marinho Falcao Neto
Web Developer
ovidio...@gmail.com
ovidiomari...@itjp.net.br
ITJP - itjp.net.br
83 8826 9088 - Oi
83 9334 0266 - Claro
Massimo,
I submitted issue 625 with a patch to populate.py which allows it to take
the compute field into consideration when populating the database.
Thanks,
Tsvi Mostovicz
ttm...@gmail.com
www.linkedin.com/in/tsvim
On Mon, Jan 16, 2012 at 22:45, Anthony wrote:
> No, I don't think populate
I will study this...
On Jan 18, 12:26 pm, Alvaro Lizama Molina wrote:
> Master branch must be de stable release and de devel branch for the trunk :)
>
> We should implement this workflow is a easy way to work with git
>
> http://nvie.com/posts/a-successful-git-branching-model/
>
> 2012/1/18 Mass
Nice. Thank you. Will commit it tonight.
On Jan 18, 1:41 pm, Tsvi Mostovicz wrote:
> Massimo,
>
> I submitted issue 625 with a patch to populate.py which allows it to take
> the compute field into consideration when populating the database.
>
> Thanks,
>
> Tsvi Mostovicz
> ttm...@gmail.comwww.lin
Hi Jim,
Did you get this working, since I too don't see the referenced field in a
query?
Thanks,
Adnan
I tried to create an event (just for testing) and got an error when tried
to submit.
Actually, I was redirected to http://tymr.com/event/draft/697 which is
e404-not found
Marin
Hi all,
I get the following weird behavior. I defined a common_fields, being
request_tenant as such:
db._common_fields.append(Field('request_tenant',default=session.table_token,writable=False))
session.table_token is a uuid generated by the controller.
There I have the following code:
session
Sorry for the delayed response. I'm going to have to ask them about docs. I
haven't found them in the obvious places.
Well, I'd really like to use pydev, but I just find that it's too resource
intensive. I do a lot of work on a souped up netbook and eclipse *really*
churns. PyCharm is a Java application too, but it positively sings beside
eclipse. I'm generally really committed to open source (I eat sleep and
Massimo, thanks a lot for taking the time to look into this !
So :
1) as usual, you are right :-)
2) your "quick fix" doesn't work, maybe because my column type is
datetime.date, not datetime.datetime ?
3) it doesn't matter for now, because I added a three-line hack
instead to replace the datet
On 18 jan, 18:46, Martin Weissenboeck wrote:
> Hi, I am interested to run web2py on an android tablet pc. Please could you
> describe what you have done?
I think I should, yes :-)
As often, it is not difficult, but not trivial either because Android
is strange, with plenty of small pitfalls, no
thank you
this is working example
controller:
import os, tempfile
os.environ['MPLCONFIGDIR'] = tempfile.mkdtemp()
import cStringIO
import matplotlib
matplotlib.use('Agg')
import matplotlib.pyplot as plt
import numpy as np
def draw():
x = np.array([10, 8, 13, 9, 11, 14, 6, 4, 12, 7, 5])
At the time you assign the default value, session.table_token is None, so
that is the default value. Instead, you can either assign the default value
after you create the session.table_token, or use a lambda:
db._common_fields.append(Field('request_tenant', default=lambda:
session.table_token))
I am trying to generate sqltables with the experimental IMAPAdapter
select output, but with some rows, an exception is raised at the
sqlhtml module. It has to do with unicode and charsets when sqlhtml
processes the rows object returned by the adapter's select method, but
I cannot find a proper way
hmmm, i don't know about "best", but here is an integration i did a few
years ago: http://www.web2pyslices.com/slices/take_slice/106 i'm not sure
how paypal has changed since then, this may no longer be a good way to do
the integrationbut feel free to evaluate and use if you desire.
Google App Engine is a cloud based computing environment. it's best to get
info about it from the source: http://code.google.com/appengine/ it has
advantages and dis-advantages as do all environments. the largest thing to
consider is the google Big Table datastore as it compares to traditiona
the GAE pricing for data reads is pretty clear now, $0.70/ Million Ops,
each row read counts as a read op, and the size of the row does not matter.
Not sure I understand the question.
You need two functions. One returns the image. One returns the view
that embeds the image.
On Jan 18, 3:24 pm, andrej burja wrote:
> thank you
>
> this is working example
>
> controller:
> import os, tempfile
> os.environ['MPLCONFIGDIR'] = tempfile.mkdtemp()
>
I also wonder who could've set that bad tone, I haven't seen anything on
the request list.
is it dificult to do something like this in web2py?
http://blog.aizatto.com/2009/12/07/ruby-on-rails-finite-state-machine-plugin-workflow/
Moving from SQLite to Postgres and when running Database
Administration we're getting unknown field type errors when using a db
reference i.e. Field('Client', db.Client)
Any advice or work arounds?
TIA,
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 204, in restri
I though the pypi package was automated now?
Awesome. So easy, I dont know why I didnt think of that. Thank you.
On Jan 18, 1:57 am, Annet wrote:
> Did you have a look at the wiki example in the web2py
> book:http://www.web2py.com/books/default/chapter/29/3#A-wiki?
>
> Instead of a 'page' table you have the table from which you retrieve
Try migrate = false, fake migrate = true to fix web2py metadata... Since
you change from sqlite to postgres web2py maybe is mixed up.
Richard
On Wed, Jan 18, 2012 at 7:25 PM, Simon Ashley wrote:
> Moving from SQLite to Postgres and when running Database
> Administration we're getting unknown f
Adnan
I did not get this working, but that doesn't mean it has been resolved.
I've given up on the search that is included in grid/smartgrid and have
been working on a solution whereby you can override the default behavior
and provide your own. I've got a ticket open
(http://code.google.com
Congratulations!
from the error looks like you have
Field('Client', 'db.Client'),
instead of
Field('Client', db.Client),
is that possible?
On Jan 18, 6:25 pm, Simon Ashley wrote:
> Moving from SQLite to Postgres and when running Database
> Administration we're getting unknown field type errors when using a db
I think I got it, but I don't understand the solution. If I understand
correctly, since the model is run before the controller, default is set to
None. But why does lambda solve this?
Sent from my phone
On 18 בינו 2012, at 23:39, Anthony wrote:
At the time you assign the default value, session.
On Wednesday, January 18, 2012 11:45:33 PM UTC-5, tsvim wrote:
>
> I think I got it, but I don't understand the solution. If I understand
> correctly, since the model is run before the controller, default is set to
> None. But why does lambda solve this?
>
When you set the default to a callable
77 matches
Mail list logo
