[web2py] app uses SQLite but needs to also connect to MSSQL as well

2010-11-13 Thread mart
Hi, So, application "build system" uses SQLite for most current and future software builds. But would also like the application to connect to an MSSQL which which hosts legacy software builds. The legacy builds will continue to be used and even updated for some time, so daily updates would need t

[web2py] patch to make Rows.setvirtualfields work with SQLTABLE

2010-11-13 Thread Ivan Matveev
motivation: It wold by nice to have a tool to add arbitrary columns to db().select() result to be able to create multiple views of the same tables(including joins). That wold be especially valuable when dealing with legacy databases when you can't design the database according to the web user i

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Christopher Steel
Hi Branko, LOL, At first glance I had the same reaction but I just checked out timeEntry's features and it looks like a excellent fit for the Web2py community. In addition it appears to be fairly easy to customize everything but drop downs (although this may be possible) Now I love it... Good We

[web2py] Re: web2py 1.89.1 is OUT... update?

2010-11-13 Thread mart
Hi, yes, I did restart the server... The install (no upgrade) was obviously as smooth as ever. I did look a little deeper in the folder that was upgraded, and realized that I was upgrading something I grabbed from trunk instead of a the previous official release. In which case, I would not expect

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread Christopher Steel
Works fine for me from the web2py shell: 1) install plugin 2) run the web2py shell: http://web2py.com/book/default/chapter/04?search=shell OR 3) run shell from browser: http://127.0.0.1:8000/admin/shell/index/your app 3) set the variable: _debug_on=True On Nov 13, 8:53 pm, pierreth wrote:

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread blackthorne
I think that as long as you develop good code, choose a good interpreter, use assynchronous requests as adequate and good caching, you shouldn't have many constraints other than the database. There, I think there is no work-around. You have to make specific/manual DB handling for each DBMS to assur

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread mdipierro
I agree that there are things we can improve in web2py. Yet, if a complex application have many pieces that are untangled, the import mechanism does not necessarily help you. The solution is trying to design components that are relatively independent. If you can do this, web2py does not bet in the

Re: [web2py] The primary key constraint on legacy tables

2010-11-13 Thread Ivan Matveev
2010/11/14 Rishu : > Hi all, > I have a project in which I am supposed to use mysql. The database > already made up. I am facing an issue with the primary key check. > Whensover i insert a duplicate value for the primary key i end up with > a ticket rather than a graceful handling. > Here's the db

[web2py] Re: The primary key constraint on legacy tables

2010-11-13 Thread DenesL
Hi Rishu, keyed table support is only available for DB2, MS-SQL, Ingres and Informix so far, as noted in http://web2py.com/book/default/chapter/06#Legacy-Databases-and-Keyed-Tables but you can contribute to web2py by adding support for mysql by following point (E) at the bottom of http://groups.

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread pierreth
I think it would be cool to be able to run a web2py app in debug mode by using a flag on the command line.

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread pierreth
I think it would be cool to be able to run a web2py app in debug mode by using a flag on the command line.

[web2py] DateTime Widget over-written by Auto-Complete suggestions

2010-11-13 Thread villas
Using firefox 3.6.12. My datetime widget is begin partially obsured by the input field's autocomplete drop-down box which contains previous inputs. Maybe the Z-Index needs fiddling with, or something...? If anyone else needs a quick fix / work-around, I have simply added the lines hereunder nt

Re: [web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread Thadeus Burgess
The biggest contributing factor is that web2py is executed and not import. The coder must always be sure to align objects and database in the correct order, including any auxiliary functions, class mappings, queries. He/she has to worry about the "order" of everything. Sometimes you can't have such

[web2py] The primary key constraint on legacy tables

2010-11-13 Thread Rishu
Hi all, I have a project in which I am supposed to use mysql. The database already made up. I am facing an issue with the primary key check. Whensover i insert a duplicate value for the primary key i end up with a ticket rather than a graceful handling. Here's the db model: db.define_table('docume

[web2py] Re: Idea on web2py wizard

2010-11-13 Thread mdipierro
I do not remember the reason for that suggestion. My only concerns are: 1) I would be best to have just one verison online (the most updated one) even if hosted at multiple places. 2) not break the link in web2py admin (or make a case for changing the link). Are you Boris the only one maintaining

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread Christopher Steel
We got an app for that... ;) http://code.google.com/p/uc-debug/ It's a plugin... On Nov 13, 5:47 pm, pierreth wrote: > On Nov 13, 5:07 pm, Jonathan Lundell wrote: > > > On Nov 13, 2010, at 12:47 PM, pierreth wrote: > > > If this is an application-specific flag (that is, unless the web2py core

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread b00m_chef
Let me just say that the chance that your app will have the traffic of facebook or twitter or even livejournal (yes it is still alive) is so small, that you really don't need to worry about it too much at such an early stage. On Nov 13, 3:11 pm, Branko Vukelic wrote: > On Sat, Nov 13, 2010 at 9

[web2py] Re: Circular references

2010-11-13 Thread blackthorne
Thank you, sorry, I should know this... On Nov 13, 10:50 pm, villas wrote: > Hi Blackthorne > > Sounds like you need a parent_id field in your comments table which > would be self-referencing. See this section in the > book:http://www.web2py.com/book/default/chapter/06#Self-Reference-and-Aliases

Re: [web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread Branko Vukelic
On Sat, Nov 13, 2010 at 9:49 PM, Jason Brower wrote: > These are encouraging. > In large deployment I mean it in the most external sense of it.  Facebook is > big, myspace is big, those kinds of object were what I was aiming for.  And For that kind of large deployment, you'll probably hit the lim

[web2py] Re: Idea on web2py wizard

2010-11-13 Thread Anthony
On Nov 13, 5:18 pm, blackthorne wrote: > Or else, just integrate the SQL designer inhttp://gaesql.appspot.com/ > for the job. I think it's even better for this kind of thing... Hmm, I notice it still uses SQLField in web2py table definitions instead of Field.

Re: [web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Branko Vukelic
On Sat, Nov 13, 2010 at 11:42 PM, villas wrote: > @Everyone > If anyone suggests a replacement timepicker,  please post a link. > Preferably to a demo. I've looked around for a good timepicker a lot back when someone said we needed a datetime picker. And my conclusion was that there is currently

[web2py] Re: Circular references

2010-11-13 Thread villas
Hi Blackthorne Sounds like you need a parent_id field in your comments table which would be self-referencing. See this section in the book: http://www.web2py.com/book/default/chapter/06#Self-Reference-and-Aliases -D On Nov 13, 10:11 pm, blackthorne wrote: > hi, > I have this problem. I want to

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread pierreth
On Nov 13, 5:07 pm, Jonathan Lundell wrote: > On Nov 13, 2010, at 12:47 PM, pierreth wrote: > > If this is an application-specific flag (that is, unless the web2py core > takes it into consideration), why wouldn't you just set it in your > first-parsed model? This is what I did. But I believe

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread villas
@Stefan There's a lot of stuff out there! Please could we have a link? I found one really cool timepicker but it was using UI. Please bear in mind that Massimo has said that he does NOT wish to include jQuery UI with Web2py at present. @Everyone If anyone suggests a replacement timepicker, ple

[web2py] Re: Idea on web2py wizard

2010-11-13 Thread blackthorne
Or else, just integrate the SQL designer in http://gaesql.appspot.com/ for the job. I think it's even better for this kind of thing... On Nov 13, 9:31 pm, Kenneth Lundström wrote: > +1 > > I was thinking the same when I was using the wizard first time. Maybe so > that you still could do like you

[web2py] Circular references

2010-11-13 Thread blackthorne
hi, I have this problem. I want to do a blog with posts that allows comments. I also want those comments to be able to have other comments, like a thread. I just can't do this in web2py at least using the wizard... help?

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
Thanks DenesL ^ ^ On Nov 13, 3:57 pm, DenesL wrote: > > rows=db(db.user.email=...@b.com).select() > > that did not paste properly, should be > > rows=db(db.User.Email=="a...@b.com").select()

Re: [web2py] Re: provide a development flag for applications II

2010-11-13 Thread Jonathan Lundell
On Nov 13, 2010, at 12:47 PM, pierreth wrote: > > On Nov 13, 3:42 pm, mdipierro wrote: >> I lost the context of this. Can you explain more? >> > > Here is the old thread: > https://groups.google.com/group/web2py/browse_thread/thread/65b6f8197af3eebd/f9c9488f71ba6893?hl=en&lnk=gst&q=provide+a+de

[web2py] Re: How to switch back to English for the Admin interface?

2010-11-13 Thread Stefan Scholl
On Nov 12, 3:03 pm, mdipierro wrote: > The admin (admin) has a selector at the bottom, it uses cookies to > keep the preferred selected language. Since Version 1.89.1, released 2010-11-12 15:14:36 (In case somebody reads this thread in a few years and thinks I'm blind.)

[web2py] Re: MSSQL Select statements

2010-11-13 Thread DenesL
> rows=db(db.user.email=...@b.com).select() that did not paste properly, should be rows=db(db.User.Email=="a...@b.com").select()

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
Brian, Thanks ^ ^ this i understand. Thanks for taking time and give me a great example! On Nov 13, 3:48 pm, Brian M wrote: > Crim, > > Yes, the criteria are any python variables you might like substituted > into your query. I probably shouldn't have used only 'strings' in my > example, sorry. >

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread winti
Hello, the jquery timepicker is a good alternative to the clockpicker. For my point of view, the clockpicker is "good enough" if it's working as expected. I would suggest to provide additional functionality, as timeentry and other jquery widgets for ui enhancements in plugins. The clockpicker misbe

[web2py] Re: MSSQL Select statements

2010-11-13 Thread DenesL
You have CREATE TABLE [User]( Email varchar(50), Name varchar(50), PIN int, Phone varchar(50), Address varchar(50), Mileage int, MealPref varchar(50), PRIMARY KEY (Email)); that translates into this web2py model db.define_table('User', Field('Email','string',50), Field('Name','string',50),

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Brian M
Crim, Yes, the criteria are any python variables you might like substituted into your query. I probably shouldn't have used only 'strings' in my example, sorry. my_city = 'somewhere' my_state = 'MN' start_date = date(2010, 11, 13) end_date = date(2010, 11, 15) results = db.executesql("SELECT * FR

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
Ah thanks this i like too ^ ^ my only question on it is when you say: results = db.executesql("SELECT foo,bar FROM my_table WHERE blah = ? and something = ?" , ('criteria 1', 'criteria 2'), True) what do you mean by 'criteria 1' ... what kind of criteria? is that where i put a python bit of code

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
you can down load the sql code here http://www.megaupload.com/?d=ARORZKPF no i cant use it .. so i take it i have to define the table in web2py? thanks a lot for your help ^ ^ On Nov 13, 3:09 pm, DenesL wrote: > Hi Crim, > > if you can use db.user.email that means you have defined the table i

Re: [web2py] Idea on web2py wizard

2010-11-13 Thread Kenneth Lundström
+1 I was thinking the same when I was using the wizard first time. Maybe so that you still could do like you do now, write evertything or then you could select everything from a dropdown box and checkboxes. Kenneth In the table creation step, how about having some columns with all the avai

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Brian M
I use web2py and MS SQL with raw SQL queries often. results = db.executesql("SELECT foo,bar FROM my_table WHERE blah = ? and something = ?" , ('criteria 1', 'criteria 2'), True) The two extra pieces at the end will let you safely bind in query parameters and the final True arg makes it so that th

[web2py] Idea on web2py wizard

2010-11-13 Thread blackthorne
In the table creation step, how about having some columns with all the available options for each table field such as "unique", "required", "notnull", "nonempty" as checkboxes. The types could also come from a dropbox with: "string", integer", ... I don't know if this kind of thing could be applie

[web2py] Re: Crud.select

2010-11-13 Thread yamandu
Very often we need to browse results of a query. It´s not possibe with this plugin, is it? Another probem is that when in a action you want for example change the representation of a field ony for that action. Using the pugin jqgrid does not work because it seems to redo the previous representatio

[web2py] Apache virtualhosts and many domains

2010-11-13 Thread Kenneth Lundström
I´ve read many posts about domains linked to different apps but still I don´t know how to do it with Apaches virtual hosts. I have looked at the web2py slices number 14. Does anybody have two virtual hosts files or entries that you could send that I could look at? Kenneth

[web2py] Re: MSSQL Select statements

2010-11-13 Thread mdipierro
yes On Nov 13, 3:10 pm, Crim wrote: > Nice i like the idea of raw sql statements ... but when i execute a > select statement would it return anything ex > > variable = db.executesql("select") > > would that work? (would test when i get home but im at work right now) > > On Nov 13, 2:41 pm, md

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
Nice i like the idea of raw sql statements ... but when i execute a select statement would it return anything ex variable = db.executesql("select") would that work? (would test when i get home but im at work right now) On Nov 13, 2:41 pm, mdipierro wrote: > web2py DAL only sees tables that

[web2py] Re: MSSQL Select statements

2010-11-13 Thread DenesL
Hi Crim, if you can use db.user.email that means you have defined the table in web2py. As I understand it, as per your previous posts, that table was not created with web2py so it must be a legacy table. You can access it depending on two things: 1) If the table has an auto incrementing field sim

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Anthony
Yes, I suppose it depends on the application, use cases, user skill, etc. Note, it appears that to use the keyboard with Time Entry, you have to either read some instructions, or fiddle around until you figure it out -- so, not the best for casual users just entering one or two times, but yes, prob

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread villas
Yes, you are right, users get up to all kinds of things :) However, I think it is still true to say: a. Form filling should still be efficient without using a mouse. b. TimeEntry is better than Clockpick (not least because the latter is broken). If we wish to take it further, I suggest one of the

Re: [web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread Jason Brower
These are encouraging. In large deployment I mean it in the most external sense of it. Facebook is big, myspace is big, those kinds of object were what I was aiming for. And with Massimo's comment about the database size. I think your right, the framework does become less relavent. In what ways

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread pierreth
On Nov 13, 3:42 pm, mdipierro wrote: > I lost the context of this. Can you explain more? > Here is the old thread: https://groups.google.com/group/web2py/browse_thread/thread/65b6f8197af3eebd/f9c9488f71ba6893?hl=en&lnk=gst&q=provide+a+development+flag+for+applications#f9c9488f71ba6893

Re: [web2py] Re: Error when using new wizard

2010-11-13 Thread Kenneth Lundström
Where can I start to look for the problem. Is the problem written in some log? Kenneth It is a file permission issue. On Nov 13, 12:33 am, Kenneth Lundström wrote: Centos 5.5, Apache 2 and mod_wsgi. I tried using the "New simple application". I gave it a name och pressed create. I get "una

[web2py] Re: provide a development flag for applications II

2010-11-13 Thread mdipierro
I lost the context of this. Can you explain more? On Nov 13, 2:13 pm, pierreth wrote: > Massimo wrote: > > Date: Thu, 29 Jan 2009 09:47:25 -0800 (PST) > Subject: Re: provide a development flag for applications > > OK let's just use WEB2PY_MODE than and it will appear in > > request.env.web2py_mod

[web2py] Re: MSSQL Select statements

2010-11-13 Thread mdipierro
web2py DAL only sees tables that are defined via the DAL. For raw sql you can do db.executesql("") On Nov 13, 2:39 pm, Crim wrote: > thanks for the in-depth reply ^ ^ > > im using existing tables and i master and another one stuff setup to > do the same thing but this is a school project so i

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread mdipierro
We are considering making this even easier. Two non-exclusive proposals on the table are: 1) make conditional models that are executed only for some controllers 2) promote the global objects (request,session,response,T,cache) to be thread local (as in Flask) so that they can be imported by modules

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
thanks for the in-depth reply ^ ^ im using existing tables and i master and another one stuff setup to do the same thing but this is a school project so im not to picky at the moment xD but thanks for the info for future use. Can i do the db(db.user.email == s).select() if i dont instantiate it

[web2py] Re: Crud.select

2010-11-13 Thread mdipierro
{{=plugin_wiki('jqgrid',table)}} already does ajax search, pagination, etc. crud.select should be able to do some of these without ajax. On Nov 13, 1:08 pm, yamandu wrote: > crud.select() is not yet very usable. > I pesonaly wished it support: > -any query or rows (just like SQLTABLE) > -paginat

Re: [web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Branko Vukelic
On Sat, Nov 13, 2010 at 8:36 PM, villas wrote: > Hi Anthony > > Please bear in mind that anyone doing serious form filling should not > have to use a mouse at all.  Use the arrow keys instead - it flies. Should not, but they do. People should use Ctrl+V for paste (or Shift+Ins), but they don't. Y

[web2py] provide a development flag for applications II

2010-11-13 Thread pierreth
Massimo wrote: Date: Thu, 29 Jan 2009 09:47:25 -0800 (PST) Subject: Re: provide a development flag for applications OK let's just use WEB2PY_MODE than and it will appear in request.env.web2py_mode Notice we aready have request.env.web2py_path request.env.web2py_version Massimo ---

[web2py] Re: web2py 1.89.1 is OUT... update?

2010-11-13 Thread Brian M
Alex, I too am seeing that .load files are not being saved - add Chrome on windows 7 to the list. Firebug shows an error : area is not defined var data = area.textarea.value I suspect this is due to the regular editor not being defined (it is just a plain textarea instead of the usual edito

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Niphlod
uhm are you using existing tables or you are using web2py to create them ?? dbo shouldn't affect at all the query, but a few hints nonetheless : master is a really nasty place to create tables "master" db should be left untouched in web2py you define a database when you istantiate

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread b00m_chef
I disagree that web2py would become messy wrt the code-base. The solution I found was to simply put all my actual logic code in "modules", then, I simply call up the specific object method in the controller function linked to the particular html file (view). I therefore don't keep any code in the "

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread villas
Hi Anthony Please bear in mind that anyone doing serious form filling should not have to use a mouse at all. Use the arrow keys instead - it flies. Most people entering times will be using an increment of say 15 or 30 mins which makes it go at jet speed. -D On Nov 13, 7:08 pm, Anthony wrote:

[web2py] Re: How to make a modal+ajax form "manually"?

2010-11-13 Thread villas
On Nov 13, 4:20 pm, Daniel Gonzalez wrote: > Thank you very much villas! LOL many other people have helped me so I'm just passing it down the line :) -D

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Anthony
Oh, didn't realize you could configure the minutes to jump in increments -- that helps. I still like the ClockPick UI better if we could get it (or something similar) to work properly. Anthony On Nov 13, 1:57 pm, villas wrote: > On Nov 13, 5:06 pm, Branko Vukelic wrote: > > > Oh, noes! This wi

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
im not using web2py to do the second select statement the one "FROM [master].[dbo].[User]" just the: if db(db.User.Email == s).select(): print "success" i connected to my db and want to select the table user and the column email On Nov 13, 1:05 pm, mdipierro wrote: > There is no webpy API

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Anthony
I agree. If you go to the Spinners tab and check "Expand", things improve somewhat (particularly the explicit version, with "+", "-", and "NOW"), but still a hassle that you have to cycle through all the numbers (or manually type). Anthony On Nov 13, 12:06 pm, Branko Vukelic wrote: > Oh, noes! T

[web2py] Re: Crud.select

2010-11-13 Thread yamandu
crud.select() is not yet very usable. I pesonaly wished it support: -any query or rows (just like SQLTABLE) -pagination -it could be ajaxable Support the first two would be great for everyday use, I guess. I tried webgrid, it´s great but does not work in my hosting because of python version 2.4. I

[web2py] Re: MSSQL Select statements

2010-11-13 Thread mdipierro
There is no webpy API to generate "FROM [master].[dbo].[User]" only "FROM [User]" On Nov 13, 12:45 pm, Crim wrote: > what cant i use? the web2py statement? > > On Nov 13, 12:26 pm, mdipierro wrote: > > > You cannot this in web2py. perhaps you can create a database view. > > > On Nov 13, 12:11

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread villas
On Nov 13, 5:06 pm, Branko Vukelic wrote: > Oh, noes! This widget suffers from so many usability issues I can't > believe it still exists. Hi Branko I am not saying it is necessarily the best, but for me it is better than clockpick. It seems that hardly anyone is using just a Time widget. The

[web2py] Re: MSSQL Select statements

2010-11-13 Thread Crim
what cant i use? the web2py statement? On Nov 13, 12:26 pm, mdipierro wrote: > You cannot this in web2py. perhaps you can create a database view. > > On Nov 13, 12:11 pm, Crim wrote: > > > > > > > > > alright so i got a connection between my MSSql server any web2py. that > > has been all sorted

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread Carlos
Hi Massimo, I did not delete anything when this problem appeared, I just switched from sqlite to postresql in the DAL. Should I worry about this problem appearing again (in my local machine or in a production environment)?. Should I test anything else?. Thanks, Carlos On Nov 13, 12:30 pm,

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread mdipierro
On Nov 13, 12:23 pm, Carlos wrote: > Hi, > > Maybe the problem is that, for the same app, I started with sqlite and > then switched to progresql?. > > Anyways, I just dropped the database in progresql and deleted all > files in /databases/, and it seems to be working ok now (so far). > > Can you

Re: [web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Branko Vukelic
On Sat, Nov 13, 2010 at 7:28 PM, mdipierro wrote: > talking about timeentry or clockpicker? Timeentry -- Branko Vukelić bg.bra...@gmail.com stu...@brankovukelic.com Check out my blog: http://www.brankovukelic.com/ Check out my portfolio: http://www.flickr.com/photos/foxbunny/ Registered Linu

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread mdipierro
talking about timeentry or clockpicker? On Nov 13, 11:06 am, Branko Vukelic wrote: > Oh, noes! This widget suffers from so many usability issues I can't > believe it still exists. > > 1. controls are microscopic > 2. it's not obvious you can switch between fields by clicking on them > since field

[web2py] Re: MSSQL Select statements

2010-11-13 Thread mdipierro
You cannot this in web2py. perhaps you can create a database view. On Nov 13, 12:11 pm, Crim wrote: > alright so i got a connection between my MSSql server any web2py. that > has been all sorted out but now im having issues with how to select a > tuple from web2py > > in web2py i have this code:

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread Carlos
Hi, Maybe the problem is that, for the same app, I started with sqlite and then switched to progresql?. Anyways, I just dropped the database in progresql and deleted all files in /databases/, and it seems to be working ok now (so far). Can you please confirm the above (switching from sqlite to p

[web2py] MSSQL Select statements

2010-11-13 Thread Crim
alright so i got a connection between my MSSql server any web2py. that has been all sorted out but now im having issues with how to select a tuple from web2py in web2py i have this code: if db(db.User.Email == s).select(): print "success" which should check if the users email is in the db

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread Carlos
Hi Massimo, I did not delete any *.table files located at: .\web2py\applications\(app)\databases\ Should I try deleting them?. How can this get corrupted?. What else should I try?. Thanks, Carlos On Nov 13, 10:54 am, mdipierro wrote: > Corrupted database/*.table > > did you delete t

Re: [web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread Thadeus Burgess
What is large deployment? Is it a large codebase that you must manage for an internal dashbaord, or just alot of users/database io that needs to scale out for worldwide access? If its the first case, web2py can get really complicated in dealing with lots of models and difficult to manage in an ef

[web2py] Re: PostgreSQL replication

2010-11-13 Thread ron_m
SymmetricDS looks like the best alternative so far for the application I am working on. The application they developed for is a close match to the kind of data sync I need. Thanks for the link to the article. I will run a test implementation. On Nov 11, 11:56 pm, shem p wrote: > Maybe any of this

Re: [web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Branko Vukelic
Oh, noes! This widget suffers from so many usability issues I can't believe it still exists. 1. controls are microscopic 2. it's not obvious you can switch between fields by clicking on them since fields are enclosed in a single box with no visible separators 3. you cannot jump to desired values (

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread mdipierro
Ok timeEntry it is. I will replace it today. On Nov 13, 8:24 am, Nathan Freeze wrote: > This would be a good slice :) > > On Sat, Nov 13, 2010 at 6:29 AM, villas wrote: > > If you want to try it... > > > 1). Download files: > >http://keith-wood.name/timeEntry.html > > Optionally this: > >http://

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread mdipierro
Corrupted database/*.table did you delete them? On Nov 12, 3:45 pm, Carlos wrote: > Hi, > > I'm getting the following error in my local installation with > postgresql when using auth.define_tables(migrate=True): > > (relation "auth_user" already > exists) > > web2py™       Version 1.89.1 (2010-1

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread mdipierro
I agree with Villas. The larger the development the more the database becomes the bottleneck and the framework irrelevant. Massimo On Nov 13, 8:35 am, villas wrote: > Hi Jason > > I guess you have to define 'large deployment' first of all.  Number of > records and size of DB? Number of concurren

[web2py] Re: A quick Q on blocked urls by auth

2010-11-13 Thread mdipierro
should be in request.vars._next On Nov 13, 2:40 am, rāma wrote: > How do you get the initial url which initiated the redirect to a login > screen. I need to build a dictionary for custom login errors based on > these urls. Can this information be accessed from the login view?

[web2py] Re: Error when using new wizard

2010-11-13 Thread mdipierro
It is a file permission issue. On Nov 13, 12:33 am, Kenneth Lundström wrote: > Centos 5.5, Apache 2 and mod_wsgi. > > I tried using the "New simple application". I gave it a name och pressed > create. I get "unable to create application 'testing'". > > Kenneth > > > What is your setup?  apache?mo

[web2py] Private message module

2010-11-13 Thread noPE
Does any module exist in web2py that I can use so that authenticated users in my application might be able to send Private Messages to each other.

[web2py] databases folder not created in shell

2010-11-13 Thread DenesL
When a new app is created in shell mode the databases folder is missing, which causes it to fail with the following: web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-2010 Version 1.89.1 (2010-11-12 15:14:36) Database drivers available: SQLite3 Traceback (most recent ca

Re: [web2py] Re: How to make a modal+ajax form "manually"?

2010-11-13 Thread Daniel Gonzalez
Thank you very much villas! All of you guys are awesome. Everyone in this community :). This is why I love web2py, an amazing framework, and a more amazing community! I hope I can be helpful too some day in the near future :) El sáb, 13-11-2010 a las 07:36 -0800, villas escribió: > Hi Demetrio >

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread demetrio
I had the same problem, that code works fine. Thx dspiteself On 12 nov, 22:23, dspiteself wrote: > there was a problem loading my static files in the designer > > I would push it but our project uses git here is a patch. > /*** > fix web2py bug

[web2py] Re: How to make a modal+ajax form "manually"?

2010-11-13 Thread villas
Hi Demetrio You don't need to use plugin_wiki to use it. There is a warning that is 'may' be old, but there's no harm in trying it :) 1. Create a new test app from the Appadmin interface. (e.g. named TestApp). 2. Download plugin from: http://www.web2py.com/plugins/static/web2py.plugin.mmodal

Re: [web2py] bug in the book or in the code? linkedin instruction

2010-11-13 Thread Michele Comitini
You can try with oauth10a_account.py under gluon/contrib/login_method, it uses standard OAuth 1.0a protocol. See this example: http://code.google.com/r/michelecomitini-facebookaccess/source/browse/#hg/applications/linkedInOauth mic 2010/11/13 Kuba Kucharski : > Hi, long time no see, guys > > I

[web2py] Re: postgresql error ... (relation "auth_user" already exists)

2010-11-13 Thread Carlos
Hi all, Can anybody please help with this?. Thanks!, Carlos On Nov 12, 3:45 pm, Carlos wrote: > Hi, > > I'm getting the following error in my local installation with > postgresql when using auth.define_tables(migrate=True): > > (relation "auth_user" already > exists) > > web2py™       Vers

Re: [web2py] Re: How to make a modal+ajax form "manually"?

2010-11-13 Thread Daniel Gonzalez
Thank you very much villas! This can works to me, but in that documentation doesn't says anything about javascript modal windows. Does somebody know how to make the jQuery modal windows without using the plugin PluginMModal()? I will need to create it manually. demetrio El sáb, 13-11-2010 a la

Re: [web2py] Re: keeping the data inserted in the sql form after submit.

2010-11-13 Thread Napoleon Moreno
Easy! thanks a lot! On Sat, Nov 13, 2010 at 9:23 AM, villas wrote: > Hi Napoleon > > Yes, look up 'keepvalues' in this chapter of the book. > http://www.web2py.com/book/default/chapter/07 > > -D > > On Nov 13, 1:52 pm, Napoleon Moreno wrote: > > Good day. > > > > Is it posible keep the data in

[web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread villas
Hi Mr Freeze! Well, if others like it, it may end up in trunk :) If not, I'll make a slice for it. Best wishes, -D On Nov 13, 2:24 pm, Nathan Freeze wrote: > This would be a good slice :) > > On Sat, Nov 13, 2010 at 6:29 AM, villas wrote: > > If you want to try it... > > > 1). Download files:

[web2py] Re: Discussion: Why is web2py bad for large deployments?

2010-11-13 Thread villas
Hi Jason I guess you have to define 'large deployment' first of all. Number of records and size of DB? Number of concurrent users? Large data model or number of forms etc? Number of servers -- or replication? Global coverage? In principle I don't think there's any reason why Web2py would be wo

Re: [web2py] Re: web2py 1.89.1 is OUT

2010-11-13 Thread Nathan Freeze
This would be a good slice :) On Sat, Nov 13, 2010 at 6:29 AM, villas wrote: > If you want to try it... > > 1). Download files: > http://keith-wood.name/timeEntry.html > Optionally this: > http://plugins.jquery.com/files/jquery.mousewheel.3.0.2.zip > > 2). Add to views/layout.html >{{respons

[web2py] Re: keeping the data inserted in the sql form after submit.

2010-11-13 Thread villas
Hi Napoleon Yes, look up 'keepvalues' in this chapter of the book. http://www.web2py.com/book/default/chapter/07 -D On Nov 13, 1:52 pm, Napoleon Moreno wrote: > Good day. > > Is it posible keep the data in the form AFTER the submit. > > It is show me a new form. I need the inserted data continu

[web2py] keeping the data inserted in the sql form after submit.

2010-11-13 Thread Napoleon Moreno
Good day. Is it posible keep the data in the form AFTER the submit. It is show me a new form. I need the inserted data continue in the form. Is it posible? Thanks

[web2py] Re: How to make a modal+ajax form "manually"?

2010-11-13 Thread villas
Hi Demetrio Check out www.web2py.com/book chapter 13 and read about components and the LOAD function which may help. -D On Nov 13, 11:48 am, demetrio wrote: > Hi everyone, > > i'm doing a desktop like iGoogle, with boxes containing information > from different sources (it can be the same applic

[web2py] Re: Selecting a few latest records

2010-11-13 Thread villas
Hi Ruiwen, See also 'orderby' in the book. Do something like this: db().select(db.person.ALL, orderby=~db.yourtable.created_date, limitby=(0, 15)) Don't overlook the tilde (~), this is important because it makes reverse order i.e. latest dates first -D On Nov 13, 10:10 am, Ruiwen Chua wrote:

  1   2   >