[web2py] Re: Warning that TK libraries aren't installed

2016-03-21 Thread Bill Lugg
That was the ticket. Thanks! Bill Lugg -- 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

[web2py] Warning that TK libraries aren't installed

2016-03-20 Thread Bill Lugg
rements page that would help me with this - I very easily could have missed it. Thanks for the help. Bill Lugg -- 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) -

[web2py] App using CAS doesn't have Profile option in User dropdown

2016-03-09 Thread Bill Black
I added an app to serve as CAS and another app (A) to use that service. Authentication works and all but in the app A, user menu has only 'Logout' option. I need access to the 'Profile'. So I manually added it (/appa/default/user/profile) and when I click on it, it gives me 404 error. I can go to

[web2py] Re: Join subqueries

2016-03-02 Thread Bill Black
list(db.tbl_holder)) > > > > > > > > > > > > > On Monday, February 29, 2016 at 9:33:31 PM UTC+3, Bill Black wrote: >> >> // I've left out fields that are irrelevant to the problem >> >> Table quiz | name (varchar) >>

[web2py] Re: Join subqueries

2016-02-29 Thread Bill Black
at do you want to do, > please > > > On Monday, February 29, 2016 at 8:11:09 AM UTC+3, Bill Black wrote: >> >> SELECT a.*,b.num_passed >> FROM (SELECT q.id,q.name,count(t.id) AS num_q >> FROM quiz AS q >> JOIN question AS t ON q.id=t.qu

[web2py] Join subqueries

2016-02-28 Thread Bill Black
SELECT a.*,b.num_passed FROM (SELECT q.id,q.name,count(t.id) AS num_q FROM quiz AS q JOIN question AS t ON q.id=t.quiz_id GROUP BY q.id) AS a JOIN (SELECT quiz_id,count(passed) AS num_passed FROM result GROUP BY quiz_id) AS b ON a.id=b.quiz_id; I need to join these two selects. I've

[web2py] Re: Bulk Importing a large number of records from a CSV file to SQLite Table

2015-10-29 Thread Bill Lugg
was right under my nose, but I just didn't find it the first time I looked. Thanks for the pointer though. Bill Lugg On Thursday, October 29, 2015 at 6:00:05 PM UTC-6, Anthony wrote: > > Did you see > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#CSV

[web2py] Re: Newby question about referencing fields in a lookup table

2015-10-29 Thread Bill Lugg
I just did this and it works great. The format attribute was already there, but set to f_itemtype. I just didn't realize what it was there for. Now I understand. Thanks for the help. Bill Lugg On Thursday, October 29, 2015 at 5:55:57 PM UTC-6, Anthony wrote: > > And you can make

[web2py] Re: Newby question about referencing fields in a lookup table

2015-10-29 Thread Bill Lugg
That was the answer. Thanks for the help. Bill Lugg On Saturday, October 24, 2015 at 9:01:40 PM UTC-6, DenesL wrote: > > > The second argument of IS_IN_DB should be the key to the reference. > And the third should be a format string to represent that key. > > So your

[web2py] Bulk Importing a large number of records from a CSV file to SQLite Table

2015-10-29 Thread Bill Lugg
I have a CSV file with more than 1,800 records that I'd like to load into one of the SQLite tables in my web2py applications. Is there an easy way to do this in web2py that I'm missing? I haven't been able to find anything in the searches I've done so far. Thanks. Bill

[web2py] Newby question about referencing fields in a lookup table

2015-10-24 Thread Bill Lugg
hat I want to make a fixed list from 1 to 4, inclusive. I was going to use the requires=IS_IN_SET construct for this; am I headed in the right direction? Thanks for the help with this. Bill Lugg -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

[web2py] Trying to use dict to filter values for a 2nd dropdown list based on the value of 1st dropdown list

2013-11-07 Thread Dr. Bill Y.K. Lim
Hi, I am new to Python and web2py and I am not sure if my approach below is correct - in any case I have a problem with it: I have added 2 extra fields in db.py as follows: from applications.myapp.modules.countriesandcities import * auth.settings.extra_fields['auth_user']=[ Field('country'),

[web2py] using generateDS & web2py application wizard for making web applications from xsd files

2013-03-18 Thread Bill Thayer
Over the weekend I was working on and exploring the possibility of using generateDS.py to create python objects for an xsd file and modifyiing its included django script to instead create the web2py.metadata file that comes with the appadmin appli

[web2py] Re: RuntimeError: Unable to handle upload

2013-02-05 Thread Bill Thayer
, stream) = table.filename.retrieve(record.filename) pathname = os.path.join(directory,filename) import shutil #In fileutils.py the developer mentioned he suspects a bug in shutil.copyfileobj #but I didn't know how to get the length of a cStringIO

[web2py] Re: RuntimeError: Unable to handle upload

2013-02-02 Thread Bill Thayer
Yes. That is what I meant. On Saturday, February 2, 2013 1:49:55 PM UTC-6, Alan Etkin wrote: > > Your code also threw the same error so before I un-commented the if >> statements in dal.py I added some print statements >> > > Did you try the store command as I posted it (passing pathname and > f

[web2py] Re: RuntimeError: Unable to handle upload

2013-02-02 Thread Bill Thayer
So I just replaced the first if statement with 'if True:' so that the code would execute. Looks like a unicode object does not have an attribute 'file' (InteractiveConsole) >>> import test_tamoto_rpc as trpc >>> trpc.upload_file() C:\Users\bthayer\Documents\car\carfiles.txt wiki_media.id wiki_m

[web2py] Re: RuntimeError: Unable to handle upload

2013-02-02 Thread Bill Thayer
Hi Alan, Just now getting back to this days later... Your code also threw the same error so before I un-commented the if statements in dal.py I added some print statements and can see the list of fields, then the name of the filename field as 'filename' followed by wiki_media.filename.9b724ad1

[web2py] Re: RuntimeError: Unable to handle upload

2013-01-29 Thread Bill Thayer
he -S option but it's the same result. Regards, Bill On Tuesday, January 29, 2013 5:20:08 AM UTC-6, Alan Etkin wrote: > > I am attempting to write a function that will eventually go in to a >> migration script to upload legacy data files. As you can see I > > > "U

[web2py] Re: web2py world conference 2013

2013-01-29 Thread Bill Thayer
I'll mention it on my Dallas Python mailing list too. Don't know how many web2py users we have in Texas though. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an emai

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Bill Thayer
I defined WEB2PY_HOME in my environment variables and then added %WEB2PY_HOME% to my path system variable. This way I can change it's value depending on the version I am developing on at the time. -Bill On Monday, January 28, 2013 9:49:12 AM UTC-6, Alec Taylor wrote: > > On Tue, J

[web2py] RuntimeError: Unable to handle upload

2013-01-28 Thread Bill Thayer
C:\Users\bthayer\Documents\car\carfiles.txt Traceback (most recent call last): File "", line 1, in File "test_tamoto_rpc.py", line 33, in upload_file filedata=stream.read()) File "C:\web2py-1045bab06391\web2py-1045bab06391\gluon\dal.py", line 8276, in inser

[web2py] 'NoneType' object has no attribute 'split'

2013-01-28 Thread Bill Thayer
I think I figured this one out so I am posting the solution. On the manages wiki_pages page from the manage pages memu item, I would click on a media button and get the error below. Turns out that in the course of testing my application I had uploaded files without a title and web2py does not

[web2py] Re: ORA-01722: invalid number - Does field order matter?

2013-01-28 Thread Bill Thayer
Hi Massimo, Is there a way that you know to get the SQL call so that I can verify the values are going to the correct place? Regards, Bill On Monday, January 28, 2013 9:48:57 AM UTC-6, Massimo Di Pierro wrote: > > You are right that db.table.insert(**args) the order of the args

[web2py] ORA-01722: invalid number - Does field order matter?

2013-01-27 Thread Bill Thayer
Hello, I am borrowing code from the CategoryPlugin sliceand ran into a unique Oracle error but I suspect that the insert command is not inserting by named fields. From my stack trace the argument below shows the columns in

[web2py] Re: Exposing validators as JSON?

2013-01-21 Thread Bill Thayer
Nice! Looking for loads_json in serializers.py; Found custom_json instead that takes an object, checks it for a custom attribute and a callable. then returns the objects custom_json() method...[I call it a method but in Python I guess it's an attribute?]...Basically, before calling json() I ne

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
On Sunday, January 20, 2013 11:52:59 PM UTC-6, Bill Thayer wrote: > > Borrowing code from SQLFORM.dictform I think I'm close to rendering nested > dicts dumped from json: > > The browser is simply writing a bunch of the > received an error saying: > Generator expres

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
Borrowing code from SQLFORM.dictform I think I'm close to rendering nested dicts dumped from json: The browser is simply writing a bunch of the

[web2py] Re: json validation

2013-01-20 Thread Bill Thayer
Thank you, My revised function looks like this: def json_parameters(param_names): """takes an array of parameter names which are attributes to a design cell then looks up the default value and unit in the attributes table and returns an array of json dictionary objects to be inserted

[web2py] Re: Exposing validators as JSON?

2013-01-20 Thread Bill Thayer
only my vision so someone else may have a different view of a 'json:reference my_other_table' usage. -Bill On Sunday, January 20, 2013 12:54:00 PM UTC-6, Alan Etkin wrote: > > would a 'json:reference mytable' field type similar to 'list:refere

[web2py] Re: 'DAL' object has no attribute 'auth_wiki' - trunk version

2013-01-20 Thread Bill Thayer
Yes. working now. Thanks. On Friday, January 18, 2013 9:28:27 AM UTC-6, Alan Etkin wrote: > > Working on trying out the json support but db won't get past this error. > > > Fixed in trunk. Please check it works for you (it did for me) > --

Re: [web2py] json validation

2013-01-19 Thread Bill Thayer
wow I'd never have thought of that - Thanks! Valid JSON On Saturday, January 19, 2013 6:37:08 PM UTC-6, Jonathan Lundell wrote: > > On 19 Jan 2013, at 4:21 PM, Bill Thayer > > wrote: > > My app stores EDA information (cad programs for designing microchips) so > st

[web2py] Re: PowerFormWizard 0.1.4 - Bug Fixes and auto_validation (+ a new plugin for grids)

2013-01-19 Thread Bill Thayer
Hi Bruno, Forgive me if I missed your updates. The link below does not work today. Where can I find the latest information. Regards, Bill > >> *# Whats next? >> *working on a new plugin for the 'Power' family, it is a JSON based >> tableless grid (which is mu

[web2py] Re: Exposing validators as JSON?

2013-01-19 Thread Bill Thayer
+1 would a 'json:reference mytable' field type similar to 'list:reference mytable' or perhaps a format=lambda row: row.json() be possible? -Bill On Tuesday, January 15, 2013 6:14:40 PM UTC-6, Derek wrote: > > That would be cool, perhaps you could add a class to the

[web2py] json validation

2013-01-19 Thread Bill Thayer
b.attribute.name.lower()==a.lower()).select(db.attribute.name, db.attribute.default_value, db.attribute.unit) row = rows[0] param = ('{}'.format(row.default_value), '{}'.format(row.unit)) params.update({'{}'.format(row.name):param}) return json(params) Any idea which is correct or how to fix it? Thank you, Bill --

[web2py] 'DAL' object has no attribute 'auth_wiki' - trunk version

2013-01-17 Thread Bill Thayer
Working on trying out the json support but db won't get past this error. Traceback (most recent call last): File "C:\web2py_src_2.2.1\web2py\gluon\restricted.py", line 212, in restricted exec ccode in environment File "C:/web2py_src_2.2.1/web2py/applications/TAMOTO/models/db.py"

[web2py] aµzing...

2013-01-17 Thread Bill Thayer
page. Anyone solve this yet? Thank you, Bill --

[web2py] Re: Solution for ORA-00932: inconsistent datatypes: expected - got CLOB

2013-01-02 Thread Bill Thayer
Another case: format=lambda row: '{} {}'.format(row.thickness, row.material) will throws the Oracle Error. format='%(thickness)s %(material)s', will not throw the error --

[web2py] Re: Memory error with numpy large array

2012-12-12 Thread Bill Thayer
On Wednesday, December 12, 2012 12:15:12 PM UTC-6, Bill Thayer wrote: > > I am having the same issue trying to serve large cad files. > > 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. Traceback (most rece

[web2py] Re: Memory error with numpy large array

2012-12-12 Thread Bill Thayer
I am having the same issue trying to serve large cad files. -Bill On Tuesday, May 17, 2011 3:02:50 AM UTC-5, Kostas M wrote: > > I tried the same application in a Linux (Ubuntu) machine, after the > installation of the latest numpy version (1.6.0). > > No MemoryError ticket occured in web2py... > > --

[web2py] Re: Lazy table bug in define table?

2012-12-06 Thread Bill Thayer
Would using an integer field or a list:reference help out? --

[web2py] Re: is there a way to not use crud.archive

2012-12-05 Thread Bill Thayer
Perhaps check your controllers to see if an update call is being made. Seems I had an app created with the wizard that added update code to the controllers. On Wednesday, December 5, 2012 2:18:46 PM UTC-6, pumplerod wrote: > > I went through the admin interface and deleted from there. Then I we

[web2py] Re: How to know if you're getting a Set when you're expecting a dict?

2012-11-13 Thread Bill Thayer
Looks like I worked most of the bugs out of this. Hope it saves someone a lot of time. If you know of a more *obvious or elegant* solution please post it. Also, my slug field is returning a tuple now. Still works as a slug but I wish I didn't have the |slug|None| format. def insert_wiki_if_n

[web2py] Re: How many error tickets does a typical newbie handle?

2012-11-13 Thread Bill Thayer
Do I then need to use an iterator for my update function? This is related to my other post where I am getting key errors https://groups.google.com/d/msg/web2py/3dgZiuDAZDc/DZnJYgaifjIJ --

[web2py] Re: How to know if you're getting a Set when you're expecting a dict?

2012-11-12 Thread Bill Thayer
After finding some code in a class called RecordUpdater in gluon/dal.py i think I figured out how to get past my arguments as a set or a dictwellI was getting a keyerr for 'name' so I put it in a try-catch but now I'm getting a keyerror for 'id' In the code below I've only been working o

[web2py] Re: Salting tables with legacy data, when to turn on record versioning?

2012-11-12 Thread Bill Thayer
Did you get your answer? --

[web2py] Re: How many error tickets does a typical newbie handle?

2012-11-12 Thread Bill Thayer
No the app never really got to 100%. Even when I try to simplify it farther and takes a different approach there is always a 'roadblock' of errors or related errors. I get about 90% (I feel) finished and can't get to the last 10% without some round of errors that never gets 100% solved so I chal

[web2py] How to know if you're getting a Set when you're expecting a dict?

2012-11-12 Thread Bill Thayer
'Set' object has no attribute '__getitem__' db.person._after_insert.append(lambda f,id: pprint(f,id)) #book's example #my code in model file after table definition code. db.extracted_linear._after_insert.append( lambda f, id:wiki_update_or_insert( 'extracted_linear', f["name

Re: [web2py] deploying web2py apache wsgi

2012-11-11 Thread Bill Thayer
I had a couple of posts on this topic and omi chib has a blog at http://ochiba77.blogspot.com/2011/10/how-to-setup-web2py-apache-wsgi.html Wish I had more time for a better response but search for my topics and you should find some good info on setting up apache. --

[web2py] Hope someone knows the answer to this one {was:....web2py math?}

2012-11-07 Thread Bill Thayer
So the same code above is now throwing an error and when I even visit http://127.0.0.1:8000/PROD/default/index. I know I don't feel right using request variable in my model file so I changed 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Traceback (most recent call last): File "C:\web2py_src_2.2.1\web2

[web2py] Re: Here is one of my 81 tickets today....web2py math?

2012-11-07 Thread Bill Thayer
LOL Thanks, On my re-design my previous table had requires=lambda v,r: IS_INTEGER_IN_RANGE(0, int((r.pstop-r.pstart)*1)), but that no longer works so I changed it and applied typecasting when I forgot forgot my order of ops. Thanks a bunch. --

[web2py] Re: join in DAL

2012-11-07 Thread Bill Thayer
different controller function that returned all records I could: db(query, ignore_common_filters=True).select(...) # copied from http://www.web2py.com/books/default/chapter/29/06?search=common_filter Again I'm not that good at this but it seems logical. -Bill --

[web2py] Re: How many error tickets does a typical newbie handle?

2012-11-06 Thread Bill Thayer
etc... Still, I am probably going to get fired & divorced for this project being so late after all the hours I put on it. -Bill --

[web2py] Here is one of my 81 tickets today....web2py math?

2012-11-06 Thread Bill Thayer
I'm no genius but (6-5)*1 should be 1 and 5 is between 0 and 10,000 I think Pstart:GHzPstop:GHzPoints: enter an integer between 0 and -49995 GHz from decimal import * def loadpull_points_in_range(pstop, pstart): return IS_INT_IN_RANGE(0, int(Decimal(pstop)-Deci

[web2py] Re: auth.wiki() run Function

2012-11-06 Thread Bill Thayer
f you are not using markmin it might be {{=MARKMIN(@{controller/function/args)}} however that is just a wild guess. (Maybe I shiould just keep to myself if I don't know exxactly but perhaps your pointed in a good direction.) Regards, Bill On Tuesday, November 6, 2012 6:51:16 AM UTC-6,

Re: [web2py] SQLFORM.grid exports the whole table

2012-11-06 Thread Bill Thayer
FWIW, My users will be filtering test station settings to upload the csv to thier test bench software. My users will need only thier own filtered data in the CSVso big Me Too! here --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-06 Thread Bill Thayer
Gave it a try...no luck. --

[web2py] Re: How to add a column?

2012-11-05 Thread Bill Thayer
Very Interesting. Thank you! --

[web2py] Re: How many error tickets does a typical newbie handle?

2012-11-05 Thread Bill Thayer
Niphold, Really appreciate your taking the time to spell this procedure out. It will come in handy for me and others too I bet! Thanks, Bill --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-05 Thread Bill Thayer
null automatically of course. When I tried using appadmin to change the values (note this has nothing to do with the widget except the widget happens to be rendered on the edit or create page) the values do not update. Not saying it's the widget, I just don't know. Regards, Bill --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-05 Thread Bill Thayer
7;reference collars'), Field('person_id', 'reference person', widget=AutocompleteWidgetSelectOrAddOption(request, db.person.first_name, id_field=db.person.id, limitby=(0,10), min_length=2, form_title=T('Add new person'), controller="default", function="add_person", button_text = T('Add new')) ), format='%()s' ) Regards, Bill --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-05 Thread Bill Thayer
;ll drop use of SQLFORM in favor of this widget.Thank you for the sample app. It made a big difference. Regards, Bill --

[web2py] How to add a column?

2012-11-05 Thread Bill Thayer
Can't beleive this question does not come up in the search box. How do i add a column to a table using SQLlite? Simply adding hte field to the define table statement throws an error. Using SQLlite I cannot add a Field. I get an error message: OperationalError: no such column: source_via.substr

[web2py] How many error tickets does a typical newbie handle?

2012-11-05 Thread Bill Thayer
. If just the tickets for what I am going through this morning could be eliminated that would be huge! FWIW, Bill --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-05 Thread Bill Thayer
Thank youRichard. I've have exhausted everything I could think of to get it to work. --

Re: [web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-11-04 Thread Bill Thayer
I still haven't gotten this to work but do need this functionality desperatley. Anyone else have any luck? --

[web2py] Solution for ORA-00932: inconsistent datatypes: expected - got CLOB

2012-10-31 Thread Bill Thayer
This is a tricky error to figure out so I am documenting it here ORA-00932: inconsistent datatypes: expected - got CLOB To get this error I had at the bottom of a table definition... ... auth.signature, format=IS_UPPER()('%(slug)s'), migrate=settings.migrate) Trying to make the slug

[web2py] Re: Oracle: long text inserting

2012-10-30 Thread Bill Thayer
et to the cursor object? -Bill --

[web2py] Re: Oracle: long text inserting

2012-10-30 Thread Bill Thayer
, Bill It's not the length of your statement, it's the length (as the error > message says) of your literal. > Oracle does not support character literals with more than 8000 characters. > You need to use e.g. a prepared statement (with bind variables) in your > program

[web2py] Re: Implementing a self-modifying form in web2py

2012-10-28 Thread Bill Thayer
Without testing it out it sounds like you are describing the default behavior from the list: Fields. I think there is a multiple = True argument perhaps. Check out http://web2py.com/books/default/chapter/29/06?search=list%3A#Many-to-many,-list:,-and-contains about 2/3 down the page if it soesn

[web2py] Re: Looking for a way to combine auto-complete with adding a non-existing item.

2012-10-27 Thread Bill Thayer
option! Regards, Bill --

[web2py] Re: Where does auth.wiki save pages to?

2012-10-24 Thread Bill Thayer
Something like that sounds like you just write a controller to query the db.wiki_page then use the example view from the book. Don't know of a stratight db call but I will need the same function soon myself. This view might work with the right controller: {{if len(articles):}} Articles {{f

Re: [web2py] Re: All app redirected to https

2012-10-23 Thread Bill Thayer
2.2.1 stable seems to be going through http for me on Chrome. --

[web2py] Re: Wiki Body CLOB ORA-01704: string literal too long?

2012-10-23 Thread Bill Thayer
Hi Massimo, Sorry I didn't get back right away. After playing around...well re-entering the entire menu one line at a time...I discovered that if I took out the capitol letters in the slugs then it worked. Regards, Bill --

[web2py] Re: Where does auth.wiki save pages to?

2012-10-21 Thread Bill Thayer
Ok, Actually i am just getting there myself on my application. There is a cloud() function and a search() function inside gluon.tools so chances are writing a pre-defined search might get you 3/4 the way there. Wish I had a better strategy to give to you. Regards, Bill On Sunday, October 21

[web2py] Re: Where does auth.wiki save pages to?

2012-10-21 Thread Bill Thayer
When you say listing pages created by auth.wiki I take that to mean a listing to display within the web browser. On mine I do have my index() controller return auth.wiki and as long as I am logged into my application I see an option under the [wiki] menu that says "manage pages". On Friday, O

[web2py] Re: auth.wiki() '_create' doesn't redirect properly

2012-10-18 Thread Bill Thayer
Back on the original topic. When I click on a menu item I also get re-directed back to the _create page. Is this a permission thing perhaps? Now that I mention it, isn't there supposed to be a field to select the permission level for the page? --

[web2py] Re: auth.wiki() '_create' doesn't redirect properly

2012-10-18 Thread Bill Thayer
This is in my db.py. Allen told me to add the second line after calling auth.define_tables auth.define_tables(username=True, signature=False, migrate=True,fake_migrate =True) auth.wiki(resolve=False) the second line calls the wiki() function to create the tables. Regards, Bill --

[web2py] Wiki Body CLOB ORA-01704: string literal too long?

2012-10-18 Thread Bill Thayer
rs - - - DC-IV > DC-IV - - - Load Pull > @Load-Pull - - Models > @Models . . . https://groups.google.com/d/msg/web2py/f66R-f3QvDo/gZR40A87SJ4J - Discussion from September 09 where Massimo posted a fix to sql.py (a file only used for backward compatibility) but I'm not convinced it's a CLOB problem. -Bill --

[web2py] Re: How to access the auth tables in appadmin?

2012-10-18 Thread Bill Thayer
set correctly. On Thursday, October 18, 2012 11:21:39 AM UTC-5, mikech wrote: > > Thanks Bill. > What I'm trying to find out is how do I access the tables involved with > security. Do I need to create views, or is there already some associated > with the appadmin? > >

[web2py] Re: auth.wiki usage - Another Oracle DB Gotcha

2012-10-18 Thread Bill Thayer
Oh. So that's why a reference field should not be named the same as the table it's referencing. In this case I didn't make the name but generally I do that all the time. Didn't realize that it makes error messages clearer. Duh. -Bill --

Re: [web2py] [FYI] Pyodel is now a plugin

2012-10-18 Thread Bill Thayer
Just tried it again. Logged in with my email and password then it took me to a blank page with one line on top that says to sign in with google password. On Thursday, October 18, 2012 8:23:58 AM UTC-5, Alan Etkin wrote: > > >El martes, 16 de octubre de 2012 18:12:46 UTC-3, Bi

[web2py] Re: How to access the auth tables in appadmin?

2012-10-17 Thread Bill Thayer
Try this: In db.py: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth = Auth(db) crud, service, plugins = Crud(db), Service(), PluginManager() auth.define_tables(username=True) # arg makes it so you can use a username instead of email to login On Wednesday, October 17

[web2py] Re: Auth Wiki functionality?

2012-10-17 Thread Bill Thayer
parts tables. Thanks for the advice! -Bill On Tuesday, October 16, 2012 9:17:25 PM UTC-5, Massimo Di Pierro wrote: > > Try: > > @{component:default/part_manage.load} > > Or customize the part_manage.html to not {{extend 'layout.html'}} > > On Tuesday, 16 Octo

[web2py] Re: Problem with adding Grids in book

2012-10-16 Thread Bill Thayer
o the permissions table and make 3 entries: permission = Create & group=manager; permission = read & group=manager; permission = update & group=manager, This is a quick answer on my way out the door hope it helped. -Bill On Tuesday, October 16, 2012 6:33:19 PM UTC-5, mikech wrote: >

[web2py] Auth Wiki functionality?

2012-10-16 Thread Bill Thayer
#x27;s already a know technique for my application that you know of? Regards, Bill --

[web2py] What are these odd menu dots from the auth.wiki menu?

2012-10-16 Thread Bill Thayer
--

Re: [web2py] [FYI] Pyodel is now a plugin

2012-10-16 Thread Bill Thayer
Hi Alan. I went through the registration process, got the Google sign in. Signed in with google too and then did not get re-directed back. -Bill On Wednesday, September 12, 2012 11:49:47 AM UTC-5, Alan Etkin wrote: > > El miércoles, 12 de septiembre de 2012 12:19:02 UTC-3, Tito G

[web2py] Re: auth.wiki usage - Another Oracle DB Gotcha

2012-10-16 Thread Bill Thayer
quot;, line 1687, in log_execute ret = self.cursor.execute(*a, **b) DatabaseError: ORA-00904: "WIKI_TAG"."WIKI_PAGE": invalid identifier On Tuesday, October 16, 2012 12:20:30 PM UTC-5, Massimo Di Pierro wrote: > > On Tuesday, 16 October 2012 11:23:29 UTC-5, Bill Th

[web2py] Re: auth.wiki usage - Another Oracle DB Gotcha

2012-10-16 Thread Bill Thayer
NOCYCLE ; Then create your trigger: CREATE OR REPLACE TRIGGER "SCHEMANAME"."WIKI_PAGE_TRIGGER" BEFORE INSERT ON wiki_page FOR EACH ROW BEGIN SELECT wiki_page_sequence.nextval INTO :NEW.id FROM DUAL; END; / ALTER TRIGGER "SCHEMANAME"."WIKI_PAGE_TRIGGER" ENABLE; I did not have this issue with tables created by web2py. Regards, Bill --

[web2py] Re: auth.wiki usage

2012-10-15 Thread Bill Thayer
After checking SQL developer and discovering the Triggers were not made for web2py_storage_tamoto table I recalled this post: https://groups.google.com/d/msg/web2py/r7qMRK2Eir0/D91Ine9NMzkJ from earlier today. That error occured at line 2865 in dal.py so the triggers never got created. So using

[web2py] Re: web2py memory leak

2012-10-15 Thread Bill Thayer
with session.connect enabled. I shouldn't have any cron jobs running since I am using this mornings release of 2.1.1 and you said cron was disabled by default. I do have logging enabled but I'm not getting an extraordinary amount of logged messages. Regards, Bill On Monday, October 15,

[web2py] Re: auth.wiki usage

2012-10-15 Thread Bill Thayer
plication. No tables other than auth_ and web2py_session_ defined here yet. -Bill On Monday, October 15, 2012 4:30:17 PM UTC-5, Massimo Di Pierro wrote: > > I am using sqlite and I tried sessions in db (again) and I cannot > reproduce this problem. > > On Monday, 15 October 2012 16:03

[web2py] Re: auth.wiki usage

2012-10-15 Thread Bill Thayer
So a small incremental approach is best for me while I fight through all of the challenges. Thanks, Bill On Monday, October 15, 2012 4:21:24 PM UTC-5, villas wrote: > > Hi Bill > > My experience is that it isn't a good idea to do experimental development > on a tricky DB. It is

[web2py] Re: auth.wiki usage

2012-10-15 Thread Bill Thayer
Thought I'd start over with a brand new application & get the wiki working but I am running into difficulty before I even get to the wiki part. I created a brand new app and started by moving my 0.py file into models then edited db.py like so: if not request.env.web2py_runtime_gae: ## if NO

[web2py] Re: web2py memory leak

2012-10-15 Thread Bill Thayer
That's all I have right now. Haven't tried it with SQLLite. On Monday, October 15, 2012 3:35:25 PM UTC-5, Massimo Di Pierro wrote: > > I this only work Oracle? > > On Monday, 15 October 2012 14:56:44 UTC-5, Bill Thayer wrote: >> >> >> Perhaps someone can

[web2py] Re: web2py memory leak

2012-10-15 Thread Bill Thayer
Perhaps someone can check session.connect with Oracle for a rocket server memory leak? To reproduce on windows 7 using web2py 2.1.1 from source: 1) Create a new simple application called simpleapp where simpleapp is the name of an application with an Oracle table for storing sessions 2) Create a

[web2py] Re: auth.wiki usage

2012-10-14 Thread Bill Thayer
the index displays the login page but after logging in returns the login page without logging in the user (user is in db) editing the user from auth_user edit user page returns the edit user page without committing the changes. registering a new user or adding one from auth_user simply returns th

[web2py] Re: auth.wiki usage

2012-10-14 Thread Bill Thayer
#code now looks like this, put the represent= inside the # call to extra_fileds . . . auth.settings.extra_fields["wiki_media"] = [ Field("filedata", "blob", represent = lambda value,row: \ A('get it', _href=URL('download', args=value))),] auth.define_tables(username=True, migr

[web2py] Re: auth.wiki usage

2012-10-14 Thread Bill Thayer
length=12)] auth.settings.extra_fields["wiki_media"] = [Field("filedata", "blob"),] auth.wiki(resolve=False) db.wiki_media.filename.uploadfield='filedata' db.wiki_page.filedata.represent = lambda value,row: \ A('get it', _href=URL('download',

[web2py] Re: auth.wiki usage

2012-10-14 Thread Bill Thayer
& 'WIKI_MEDIA'.'IS_ACTIVE'. Those columns were missing when I manually created the Oracle wiki_ tables. Thank you for your help. My spirits are getting better now. Just need to figure out why my auth_tables are accessible. Regards, Bill On Sunday, October 14, 2012 4:06:

  1   2   >