Hi -
I am trying to do some work with a database that is set-up in web2py. I am
able to connect to the db server from my script but I have essentially
tried to do exactly the same in my external routine as in web2py and it is
giving me this error:
pydal.contrib.pg8000.errors.ProgrammingError:
can you post the full stack trace?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Grou
Hi - Thanks for the response.
I did find the documentation and set migrate=False and was able to get it
working.
However, the follow up question is, what to do if I do want to change the
tables? EG: What if I want to add a new field.
It seems that I'm now locked out of making changes on both e
19, 2015 at 6:23:24 PM UTC+1, Tom Stratton wrote:
>>
>> Hi - Thanks for the response.
>>
>> I did find the documentation and set migrate=False and was able to get it
>> working.
>>
>> However, the follow up question is, what to do if I do want to change
I'm finding that a lot of users are hitting Enter instead of Tab and I'm
getting half-filled-in forms. I'd like to set the button to NOT default but
not sure where to go about making that change.
Anyone have a solution?
Thanks
Tom
--
Resources:
- http://web2py.com
- http://web2py.com/book (D
Thanks -
I found several methods on SO that involved manipulation of the OUTPUT from
web2py that gets rendered in the browser. Implemented a solution that was
very specific to the forms that I want to have filled in.
I had hoped for a web2py specific way to manage the submit button behavior
be
Follow up to this (and a big Thank You for saving me a lot of digging!)
I had field names with "$" in them which caused the same error. I believe
that the rules for field names may be the same as the rules for variable
names. I'm guessing that trying to reference a.b.c instead of a.b[c] is
caus
ngines support. Those are documented in the book.
>
> 2015-03-02 19:46 GMT+01:00 Tom Stratton >:
>
>> Follow up to this (and a big Thank You for saving me a lot of digging!)
>>
>> I had field names with "$" in them which caused the same error. I believe
&g
Hi -
I am working with some unicode lists that I am inserting into a postgres
database. From the documentation I see that fields of type list:string are
converted to | separated strings before being inserted into the db.
When attempting to insert a list of values that contains unicode
charact
Did you remember to restart web2py?
See:
http://www.ridgesolutions.ie/index.php/2013/02/20/web2py-make-your-app-the-default-web-application/
And there is also a "reload routes" button in the admin interface.
Hope that helps.
On Thursday, April 2, 2015 at 1:25:43 PM UTC-7, 朱伟 wrote:
>
> I wrote
Update - I found the bug reported here:
https://github.com/web2py/web2py/issues/697
I have also suggested a fix but I am not deep enough into the code to know
if it might break other behaviors.
See the bug tracker for my suggested fix and let me know here if you have
any thoughts about what els
I have google for the last hour to try and figure out how to run the
unittests in the tests folder for pydal and have come up short.
Is there something simple I am missing?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
On Thursday, April 2, 2015 at 10:57:41 PM UTC-7, Tom Stratton wrote:
>
> Update - I found the bug reported here:
> https://github.com/web2py/web2py/issues/697
>
> I have also suggested a fix but I am not deep enough into the code to know
> if it might break other behaviors.
&g
Hi -
I wanted to change my default application and did some research.
First I did the simple:
```
default_application='p'
default_controller = "pkg"
default_function = "packages"
```
And it seemed to work fine but I was not satisfied so I did this:
```
routers = dict(
BASE = dict(default_appli
Hi -
I'm struggling to find a way to do an "ilike" style search within a list of
strings field in the db.
For example, my field may contain ['Donald Duck', 'Minnie Mouse']
I'd like that record returned when I am searching for '%mouse%'
Maybe I need to cast the list to a string but this is just
gt; to specify the controller and function when initially constructing the Auth
> object.
>
> Note, you will also have to move the /views/default/user.html view to
> /views/pkg/user.html (and change "user.html" to match the name of your new
> user action if you have changed th
For me, with the postgres adapter, the "contains" method is only returning
information when one of the items in the list is an exact match (case
insensitive) for the item I search for.
so if the list is ['John Doe', 'Michael Smith', 'Karen Jones', 'Anne Baker']
contains('Michael Smith') returns
Hi -
I've had several unicode issues pop up with postgres and pydal in the last
couple of weeks - it may be a version issue.
What versions of web2py and pydal are you using, what database adapter, and
what - specifically - is giving you the crash?
Is the problem when you try to read from the d
- contains('%Smith')
> and (for case-insensitive query)
> - contains('%smith', case_sensitive=False)
>
> Paolo
>
> On Tuesday, April 28, 2015 at 9:26:24 PM UTC+2, Tom Stratton wrote:
>>
>> For me, with the postgres adapter, the "contains"
Hi -
I'm setting up to be able to work on some fixes for issues in pydal as they
relate to web2py and I'm fairly new to this - the submodule of pydal inside
web2py is hanging me up.
When I fork web2py on github (to be able to clone it locally) and I use the
—recursive command on the clone I ge
Hi Leonardo -
I think that the issue probably lies in the pg8000 adapter in pydal. I'm
trying to hunt down a couple of unicode errors in that module. It would
really help me if you could post the stack trace of the error that you get.
The error message itself is not much help in finding the so
21 matches
Mail list logo