Which SQL Standard?
On Friday, 16 November 2012 02:39:24 UTC, Tim Richardson wrote:
Your experience with MS Access will not be good I think. It doesn't even
pretend to support SQL standards as far as I remember, and you'll have a
very difficult time getting support.
The advice to
man do a favor for yourself and don't use ms access database,
move to sqlite which is built in python :)
why?
http://database-management-systems.findthebest.com/saved_compare/Access-vs-SQLite
http://sqlite.phxsoftware.com/forums/p/666/3106.aspx
and you will find more reasons on google
how?
use
On Friday, 16 November 2012 20:32:23 UTC+11, Simon Carr wrote:
Which SQL Standard?
:)
But seriously, the SQL you develop to get anything working with Access will
be unusually idiosyncratic. I have bad memories ...
--
Hi Niphlod,
Thanks for your example. It's crystal clear. ;)
I got another doubt about multi-languages: on the online book I read that
in order to tell web2py which language is the default one, I have to use:
T.set_current_languages('it')
Now I am wondering if I need to use it in the controller
I created today a sql cloud database. And I got the same error.
I changed to path VARCHAR(255) and now it works. Anybody else having the
same problem?
-rif
marți, 7 august 2012, 18:27:13 UTC+3, Massimo Di Pierro a scris:
Why does 512 result in Specified key was too long; max key length is
No. You do not need it. You just cut and paste the link to the youtube
video page and it will embed the video automatically.
On Thursday, 15 November 2012 22:32:17 UTC-6, Andrew W wrote:
Does the plugin_wiki syntax work in auth.wiki ? (I'll try it tonight).
From the book (plugins
Please open a ticket and we will fix this asap.
On Friday, 16 November 2012 04:49:35 UTC-6, rif wrote:
I created today a sql cloud database. And I got the same error.
I changed to path VARCHAR(255) and now it works. Anybody else having the
same problem?
-rif
marți, 7 august 2012,
Done (http://code.google.com/p/web2py/issues/detail?id=1172)
Are the migrations issues to GoogleSQL still present?
-rif
vineri, 16 noiembrie 2012, 12:57:14 UTC+2, Massimo Di Pierro a scris:
Please open a ticket and we will fix this asap.
On Friday, 16 November 2012 04:49:35 UTC-6, rif
Very last doubt, I promise! :P
Let us assume that I am visiting the page at this url:
/en/portfolio
and I want to change to /it/portfolio, how can I set URL in order to do
that?
If I set it like this:
URL('it')
I will obtain:
/en/it
which is an invalid function.
Cheers,
David
On 16
Hash-flooding DoS attack reported for the Hash function (Ruby)
http://www.ruby-lang.org/en/news/2012/11/09/ruby19-hashdos-cve-2012-5371
Just for information, not a Dos for web2py.
In web2py can we limit the size of the parsed data? just in case there was
a DoS like this one
Kind regards
--
Hi Massimo,
I've just been checking it.
I think you need to change this...
Wiki __init__()
This line:
self.extra = self.extra or {}
should be:
self.extra = extra or {}
--
On Nov 16, 2012, at 5:17 AM, rif wrote:
Done (http://code.google.com/p/web2py/issues/detail?id=1172)
Are the migrations issues to GoogleSQL still present?
I am not aware of any issue. Can you point me to some something about this?
-rif
vineri, 16 noiembrie 2012, 12:57:14 UTC+2,
I was referring to http://web2py.com/books/default/chapter/29/06#Gotchas
vineri, 16 noiembrie 2012, 15:04:47 UTC+2, Massimo Di Pierro a scris:
On Nov 16, 2012, at 5:17 AM, rif wrote:
Done (http://code.google.com/p/web2py/issues/detail?id=1172)
Are the migrations issues to GoogleSQL still
Hi there!
I'm having some troubles using an image as a substitute for a submit
button...
I'm generating the form in the controller and using a local image as
follows:
INPUT(_type=image, _value=Editar, _width=16, _height=16, _alt=
Editar, _src=/+request.application+/static/images/edit.png),
Hi there! How do I get a var value which is being passed by post into a
controller by its name?
I mean, I don't want to get the values using request.args(0), because I'll
be stuck with the index. I'd rather do something like
request.args['dnsClass'], for example.
Any hints?
request.vars is a dict.
request.vars.keys() is a list of all the variables
request.vars['dnsClass'] is what you're searching for.
PS: your address bar will be
app/controller/function?dnsClass=INownername=
On Friday, November 16, 2012 2:46:14 PM UTC+1, Francisco Barretto wrote:
Hi there!
URL('it') is go to the it function in the same controller I'm in.
haven't played with that, but I guess web2py expects something like
/a/lang/c/f so, by some means of request.something
(function,controller,args,etc) you should be able to.
On Friday, November 16, 2012 12:23:52 PM UTC+1,
{{
import cStringIO
stream=cStringIO.StringIO()
estudiante_arancel_rows.export_to_csv_file(ofile=stream, represent=True)
response.headers['Content-Type']='application/vnd.ms-excel'
response.headers['Content-Disposition'] = attachment; filename=%s %
'data_sga.csv'
hi,
instead of showing 'app' application it shows it show init app
but if I go
http://mysite.com/app
it works
routes.py
#!/usr/bin/python
# -*- coding: utf-8 -*-
routes_in = (
('(.*):https?://(.*)mysite\.com:(.*)/', '/app/'),
)
def __routes_doctest():
pass
if __name__ == '__main__':
The title describes the problem.
Any suggestions as to what I might do? Would it be simpler if I just
uploaded to a directory? I'm archiving for auditability, so I suppose
there would still be a way to get at earlier versions of uploaded files.
Here is the model:
Note that CSS usually overrides html attributes.
Try setting the width with _style='width:16px' instead. (Only 16px?)
You can use Firefox with plugin Firebug to see what CSS rules are being
applied.
Regards, D
On Friday, November 16, 2012 1:18:39 PM UTC, Francisco Barretto wrote:
Hi
Thanks !
I spend some more time wrestling with this, and expanding my knowledge of
this feature of web2py, which I enjoy doing.
*GOOD NEWS*, I finally got it to work, on a simple web2py app. - just by
adding 2 lines in the right place.
(copy of working code below)
Now, I'm not sure if a bug
I will take a look at this.
Thanks
On Friday, 16 November 2012 09:53:13 UTC, Vasile Ermicioi wrote:
man do a favor for yourself and don't use ms access database,
move to sqlite which is built in python :)
why?
Glad you saw you the humorous side of it, I wasn't sure after I replied if
it would be taken the wrong way.
By the way I tried to create an adapter today for Access from the
MSSQLAdapter library. I managed to get Web2Py creating tables in Access but
only to the point where it had to create
Hi all!
I have quite a problematic issue, I would like to know how to define a
Field as unsigned in the DAL ?
I tested:
Field('triggerValue', 'unsigned integer', requires=IS_NOT_EMPTY(),notnull
=True),
and
Field('triggerValue', 'integer', unsigned=True,
requires=IS_NOT_EMPTY(),notnull
Which backend do you use? I think that this feature is database specific...
Richard
On Fri, Nov 16, 2012 at 11:12 AM, Joseph.Piron joseph.pi...@gmail.comwrote:
Hi all!
I have quite a problematic issue, I would like to know how to define a
Field as unsigned in the DAL ?
I tested:
You can use integer for development. In production, you can alter the
database with raw sql to change the field.
DAL will still think it's an integer. If needed, you can add validators to
make sure you're not working with negative numbers.
On Fri, Nov 16, 2012 at 5:15 PM, Richard Vézina
The problem might be in the code you stripped out. What does the code
around line 138 look like?
It appears you are referencing items somewhere where it does not exist.
What does the code look like that processes the form? Do you have a
redirect after
For the email field, you might need to
I think you might want to try:
1. copy all of the files in databases somewhere safe
2. delete all the files in databases
3. in the DB connection string, include (..., migrate=True,
fake_migrate_all=True)
4. Access /appadmin to trigger a migration
5. Revert DB connection string to (...,
I am working with mysql, there's no way to do this without an alter table ?
(Which would be executed at each request moreover)
On Nov 16, 2012 5:25 PM, Marin Pranjić marin.pran...@gmail.com wrote:
You can use integer for development. In production, you can alter the
database with raw sql to
I don't think that DAL has this field type.
You can use a validator to make sure the integer is positive.
See IS_INT_IN_RANGE and IS_EXPR in the online book.
On Friday, November 16, 2012 4:12:45 PM UTC, Joseph.Piron wrote:
Hi all!
I have quite a problematic issue, I would like to know
How does someone arrive at your login page? Is it via the Login link
generated by the auth.navbar()?
Anthony
On Friday, November 16, 2012 10:42:48 AM UTC-5, Rob_McC wrote:
Thanks !
I spend some more time wrestling with this, and expanding my knowledge of
this feature of web2py, which I
I have a SQLFORM.grid which I load using LOAD component.
Now i want to perform few onscreen auto calculations when I add data into
this table via sqlform.grid. So i have setup few jquery functions to do it.
It used to run smoothly before when I didnt have the SQLFORM.grid run via
LOAD. But
I confirm the bug using 2.2.1 (I am not using trunk...)
It is because in gluon/globals THREAD_LOCAL.instances do not exist and the
replacement THREAD_LOCAL.db_instances has a different architecture.
To correct (I hope it's in the trunk already):
dbstats = [TABLE(*[TR(PRE(row[0]), '%.2fms' %
I have similar problem, trying to set some bootstrap style... I think that
how LOAD works it remove everything but html...
I will investigate about that soon.
Interested in any input since then.
Richard
On Fri, Nov 16, 2012 at 1:05 PM, vivek vi...@digambernath.org wrote:
I have a
Niphlod,
I understand that web2py expects something like /a/lang/c/f or /lang/c/f,
but playing with request.something I didn't manage to obtain that. :)
Any tips?
Thanks for your help.
Have a good night.
David
On 16 November 2012 15:25, Niphlod niph...@gmail.com wrote:
URL('it') is go to the
To execute JavaScript as the component loads, use response.js in the
controller of the component you're loading. Search for response.js in the
book or on this forum to get started...
Regards,
Ales
On Friday, November 16, 2012 7:05:48 PM UTC+1, vivek wrote:
I have a SQLFORM.grid which I
I want to include the text from static in my email templates. I
currently have this, but it doesn't work:
style type=text/css
{{=LOAD(url=URL('static', 'css/web2py.css', scheme='http'),ajax=False)}}
{{=LOAD(url=URL('static', 'css/style.css', scheme='http'),ajax=False)}}
/style
But this doesn't
load is just a convenience wrapper to load a fragment and to trap form
submissions. Something in your js is not firing, but you need to show us
the code to pinpoint the cause
--
yet in trunk!
On Friday, November 16, 2012 7:24:44 PM UTC+1, Cédric Mayer wrote:
I confirm the bug using 2.2.1 (I am not using trunk...)
It is because in gluon/globals THREAD_LOCAL.instances do not exist and the
replacement THREAD_LOCAL.db_instances has a different architecture.
To
Haha!
Thanks LightDot
Richard
On Fri, Nov 16, 2012 at 2:44 PM, LightDot light...@gmail.com wrote:
To execute JavaScript as the component loads, use response.js in the
controller of the component you're loading. Search for response.js in the
book or on this forum to get started...
Regards,
On Friday, November 16, 2012 5:56:18 PM UTC+1, Joseph.Piron wrote:
I am working with mysql, there's no way to do this without an alter table
? (Which would be executed at each request moreover)
PS: once the table is altered externally there's no need to perform
anything on web2py. it's
No I can't, here I have to stock and let the user enter 2**31 and not
2**31-1
As everything else is possible, shouldn't it be possible to add a aprameter
to the field constructor to set unsigned ?
That would be really handy in situation such as mine where I have to deploy
the solution on many
Richard - I've been trying to get this working but am not having any luck.
I have the lazy_options_widget working with the first field being a
suggest_widget, but am trying to implement with your suggestion above using
a SELECT element as the first field, but it isn't working. I'm using this
ok, I played with it and understood an underlying design decision to let
the current request.uri_language to propagate to all URL() generated links.
In fact, parameter based router was thought to let different versions of
the same site to behave in a consistent way (i.e., if you accessed
On Friday, November 16, 2012 9:23:33 PM UTC+1, Joseph.Piron wrote:
No I can't, here I have to stock and let the user enter 2**31 and not
2**31-1
As everything else is possible, shouldn't it be possible to add a
aprameter to the field constructor to set unsigned ?
That would be really
Hmm...
I pass by reponse.js many little script that works just fine... But it
seems that I have to pass bootstrap.js to in order to have the all the
bootstrap feature to work. Is ti normal?
Richard
On Fri, Nov 16, 2012 at 2:53 PM, Niphlod niph...@gmail.com wrote:
load is just a convenience
Humour me back ... download SQL Server express edition and the accompanying
SQL Server Management Studio (Express edition) and have a look at it. It
runs well on Windows 7 XP desktops. People could also recommend postgres,
but for getting up and running quickly, and for its very friendly
Hi Jim,
I am not sure I follow...
What you have done so far?
On Fri, Nov 16, 2012 at 3:31 PM, Jim S j...@qlf.com wrote:
Richard - I've been trying to get this working but am not having any luck.
I have the lazy_options_widget working with the first field being a
suggest_widget, but am
It may be related to smartgrid...
Have you try with a straight sqlform??
Richard
On Fri, Nov 16, 2012 at 3:31 PM, Jim S j...@qlf.com wrote:
Richard - I've been trying to get this working but am not having any luck.
I have the lazy_options_widget working with the first field being a
Well, I can get it to work with smartgrid if I use a suggest_widget for the
first field. But, I'm trying to make my second SELECT element reload its
options based on the option selected in the first SELECT element. I was
trying to follow the JS that you posted earlier, but I can't get it to
if you have the default layout bootstrap.js is put at the end of the page.
trying to call something relying on that on a fragment that is put before
the last piece of the page is loaded will obviously not run.
and again, LOAD() (when not called with ajax=False) is just a nice shortcut
to $.ajax
Yes, it's broken: AttributeError: 'Wiki' object has no attribute 'extra'
I made the change below and it works.
On Saturday, November 17, 2012 12:54:14 AM UTC+13, villas wrote:
Hi Massimo,
I've just been checking it.
I think you need to change this...
Wiki __init__()
This line:
Thanks.
That's what I did.
On Friday, November 16, 2012 11:56:49 PM UTC+13, Massimo Di Pierro wrote:
No. You do not need it. You just cut and paste the link to the youtube
video page and it will embed the video automatically.
On Thursday, 15 November 2012 22:32:17 UTC-6, Andrew W wrote:
Jim,
You can put the jQuery directly in html create/update form like this :
script
$(select[name=FIRSTFIELDNAME]).change(function() {
var val = $(this).children(:selected).attr(value);
$(this).trigger($(this).attr(id) + __selected, [val]);
});
/script
To make sure you selector are good
I have to go... Sorry...
It surely a selector that not catch what it suppose to...
My form use formestyle=divs that maybe affect somehow...
Richard
On Fri, Nov 16, 2012 at 4:40 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Jim,
You can put the jQuery directly in html create/update
Thanks Richard, didn't think of changing the background to help me
diagnose. Will work on it more this afternoon but pick it up again on
Monday. Have a good weekend!
-Jim
On Friday, November 16, 2012 3:44:16 PM UTC-6, Richard wrote:
I have to go... Sorry...
It surely a selector that not
Will look at that.
Thanks Niphlod.
It is bizzard all my script work, but when I add this one they all stop
working, I thougth that it was because of web2py.js or bootstrap.js or
orther .js, but I don't think so now.
# Works fine
response.js = 'jQuery(document).ready(function(){
The last problematic script use to work if I use it with normal form (not a
form in a component).
Richard
On Fri, Nov 16, 2012 at 4:53 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
Will look at that.
Thanks Niphlod.
It is bizzard all my script work, but when I add this one they
You too!
Bye!
Richard
On Fri, Nov 16, 2012 at 4:47 PM, Jim S j...@qlf.com wrote:
Thanks Richard, didn't think of changing the background to help me
diagnose. Will work on it more this afternoon but pick it up again on
Monday. Have a good weekend!
-Jim
On Friday, November 16, 2012
FYI - I got it working by putting the JS in layout.html within my
$(document).ready(function() code. But, now it is working ok for adding a
new record, but doesn't display the value in the second SELECT on edit.
That one doesn't work with suggest_widget on the first field either. Even
if
FWIW, I just found why it didn't work earlier. I was editing the wrong
.html file. Meat Head. Blame it on Friday afternoon...
-Jim
On Friday, November 16, 2012 4:06:33 PM UTC-6, Jim S wrote:
FYI - I got it working by putting the JS in layout.html within my
$(document).ready(function()
This was discussed on this list and it is my understanding it has been
fixed at the Pyhton level:
http://www.h-online.com/security/news/item/Python-updates-for-hash-collision-DoS-problems-Update-1519585.html
On Friday, 16 November 2012 05:34:26 UTC-6, Ralo Tannahill wrote:
Hash-flooding DoS
have you inspected where it goes on error ? My bet would be on the calendar
setup ... seems that you're trying to bind a click on an element to trigger
the parent to show the calendar. But the calendar is supposedly yet
present on the input field. If so, why don't you just use live ?
e.g.
some where you have a Field(...,represent=something)
and something takes two arguments, not one. Can you show us the model?
On Friday, 16 November 2012 08:51:32 UTC-6, www.diazluis.com wrote:
{{
import cStringIO
stream=cStringIO.StringIO()
Yes:
att_id = db2.attachments.insert(
attachment = db2.attachments.attachment.store(...),
filename = fname,
Description =
r.attachments.attachment_brief_description,
)
needs
att_id = db2.attachments.insert(
style type=text/css
{{=open(os.path.join(request.folder,'static','css/web2py.css')).read()}}
{{=open(os.path.join(request.folder,'static','css/style.css')).read()}}
/style
On Friday, 16 November 2012 13:47:10 UTC-6, encompass wrote:
I want to include the text from static in my email
There is no way I will get away with that at work. However Oracle is
available so I might see if I can get a business case together for them to
set me up with a schema.
Again many thanks.
On Friday, 16 November 2012 21:08:49 UTC, Tim Richardson wrote:
Humour me back ... download SQL Server
I have already issued a bug report. for
auth.navbar(referrer_actions=None)
Peter
On Friday, 16 November 2012 18:03:12 UTC, Anthony wrote:
How does someone arrive at your login page? Is it via the Login link
generated by the auth.navbar()?
Anthony
On Friday, November 16, 2012 10:42:48 AM
Using latest trunk with Apache/Linux.
I'm having log in problems, especially with IE 9.
I've noticed that in the browser I get the cookie set:
NAME session_id_myapp VALUE
75.141.38.104-8a5232dc-03d5-4312-bc65-2157590a973b DOMAIN mydomain.com PATH
/ EXPIRES At the end of the Session
So
That is the process I first tried, based on info in the web2py book.
The problem for this was when web2py was regenerating the tables it
raised an error that auth_user already exists.
On Sat, Nov 17, 2012 at 3:55 AM, pbreit pbreitenb...@gmail.com wrote:
I think you might want to try:
1. copy
hmm... i got the latest trunk, and also started having a problem with
session... but still investigating.
On Friday, November 16, 2012 5:50:02 PM UTC-5, villas wrote:
Using latest trunk with Apache/Linux.
I'm having log in problems, especially with IE 9.
I've noticed that in the browser
Hello everyone .. it has been a while ! ... I am back .. alive .. and
kicking at it again...
OK ! .. I have a problem with data that does not make it to the table when
the related form is shown to the user through a Modal ( in this case it is
the NyroModal that I chose to use for this
Hey Anthony:
Q
How does someone arrive at your login page? Is it via the Login link
generated by the auth.navbar()?
A:
I have tested a few ways... here are my findings
*Method 1*
- From home page,
http://127.0.0.1:8000/AuthRedirect/default/user/login?_next=/AuthRedirect/default/index
tested the same code in Version 2.2.1 (2012-10-21 16:57:04) stable, and
session works as expected, but not in trunk.
simplified version of what i'm doing:
def a():
products=db(db.products1).select()
session.category_products_keys = products.as_dict().keys()
print
correction... rearranged the code a bit, and all works as expected on my
side...
On Friday, November 16, 2012 8:43:24 PM UTC-5, Adi wrote:
tested the same code in Version 2.2.1 (2012-10-21 16:57:04) stable, and
session works as expected, but not in trunk.
simplified version of what i'm
I intend to create some sample code fragments.
I will try to post something by Monday.
On Thursday, November 15, 2012 9:16:09 PM UTC-6, Jim S wrote:
I would be interested in learning more. do you have any samples you could
share?
On Nov 15, 2012 8:52 PM, dlypka dly...@gmail.com javascript:
Never thought about doing it that way.
Better to use the python way in this case I suppose. :)
BR,
Jason
On Saturday, November 17, 2012 12:22:52 AM UTC+2, Massimo Di Pierro wrote:
style type=text/css
{{=open(os.path.join(request.folder,'static','css/web2py.css')).read()}}
I was including the css I use in my emails and it's telling me it is
more than 32768 Chars.
'message':'enter from 0 to 32768 characters'
Any way I can get around this issue? I suppose I could try to shorten
my css but I wish there was a better way. (Compressing the CSS would be
cool too.)
79 matches
Mail list logo