[web2py] Re: Web2py Application Exhibition -- Winners!

2010-08-06 Thread Jason Lotz
Kind of a shame only two apps entered. Being a bit of a newbie to web development (coming from database and basic native apps programming) I was hoping to see what people have come up with to get an idea of some possibilities for web apps. Hope we could do something like this again. Maybe I'll su

[web2py] Re: Fresh install on vps.net, forbidden on admin/default/index

2010-06-22 Thread Jason Lotz
Step 1 - Shutdown apache Step 2 - Become www-data user Step 3 - Start web2py from terminal cmd Step 4 - Kill web2py (ctl + z) Step 5 - Restart Apache This is the work-around provided by cjs on the vps.net forum. http://www.vps.net/forum/public-forums/tutorials-and-how-tos/2115-web2py-on-vps-net F

Re: [web2py] Re: Show custom form field.requires

2010-06-07 Thread Jason Lotz
n Jun 7, 8:43 pm, Jason Lotz wrote: Thanks mr.freeze!! That got me in the right direction. The dept_id comes from long time with Oracle and M$ SQLServer, also I thought it would be nice to make the database structure easily compatible with other platforms. I don't know about PostgreSQL

Re: [web2py] Re: Show custom form field.requires

2010-06-07 Thread Jason Lotz
#x27;, db.department)) Passing the format parameter to the department table will create the default validators and represent attributes so that it shows the name instead of the id. The dept_id field on the department table seems redundant as the table will already have an ID field automaticall

Re: [web2py] Re: Example for JqGrid

2010-06-07 Thread Jason Lotz
? On 7 Jun., 16:33, Jason Lotz wrote: Eban Software has a pretty nice web2py plugin with out-of-the-box inline editing configured. http://app.ebansoftware.net/editable_jqgrid/default/index Install plugin and use with # Controller def show_grid(): return dict(jqgrid=plugin_editable_jqgrid

[web2py] Re: Example for JqGrid

2010-06-07 Thread Jason Lotz
Eban Software has a pretty nice web2py plugin with out-of-the-box inline editing configured. http://app.ebansoftware.net/editable_jqgrid/default/index Install plugin and use with # Controller def show_grid(): return dict(jqgrid=plugin_editable_jqgrid(db.shout,grid_name='test',db_name='db')

[web2py] Show custom form field.requires

2010-06-07 Thread Jason Lotz
Creating a custom crud.read form and I would like to show the field.requires=IS_IN_DB field rather than the table.id . Sorry if that doesn't make much sense. I have two related tables. db.define_table('employee', Field('firstName'), Field('lastName'), Field('dept_id')) db.define_table('department'

[web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
is is the default/test.html template {{=jqgrid_table}} {{=LOAD('default','details',args=1,ajax=True,target='my_form')}} // Notice the two extra options (grid_load='URL(...)',target='id') in the controller default/index. grid_load = url to the form

Re: [web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
Template (Its showed twice). I´ve checked: www.web2py.com/AlterEgo/default/show/252 But it doesent´t helped very much. It seems I am stucked, right before finish... ;-( Any help is appreciated, would so cool if I could get this done today. Dieter Asman On 20 Mai, 17:23, Jason Lotz wrote: web2py

Re: [web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
if form.accepts(request.vars, session): response.flash = 'form accepted' elif form.errors: response.flash = 'form has errors' else: response.flash = 'please fill out the form' return dict(form=form) On 20 Mai, 16:55, Ja

Re: [web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
colNames:col_names, colModel:col_models, pager: pager, rowNum:10, rowList:[10,100,1000], sortorder: 'desc', multiselect: true, multiboxonly:true, viewrecords: true, editurl:edit_url, caption: caption }); Thank you in advance. Dieter Asm

Re: [web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
= 'form accepted' elif form.errors: response.flash = 'form has errors' else: response.flash = 'please fill out the form' return dict(form=form) ## Now the Grid is showed, but no form. do you have any further

Re: [web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
lling the form. May i missed something..? Could you tell me how to set up the form? should the view look something like that?: {{=jqgrid_table}} jQuery("#grid_id").jqGrid({ onSelectRow: function(postdata) { web2py_ajax_page('get','/myapp/default/form/&

[web2py] Re: [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-20 Thread Jason Lotz
quot; >     elif form.errors: >         response.flash="form is invalid" >     else: >         response.flash="please fill the form" >     return dict(form=form,vars=form.vars) > > > > The JQGrid works, bu

[web2py] [SOLVED] jqgrid onSelectRow trigger web2py_component

2010-05-16 Thread Jason Lotz
y_component(action,target) > { >     jQuery(document).ready(function() > { web2py_ajax_page('get',action,null,target); }); > > } > > I think you just want to call web2py_ajax_page instead of > web2py_component. > > On May 16, 11:50 pm, Jason Lotz wrote: > > &

[web2py] jqgrid onSelectRow trigger web2py_component

2010-05-16 Thread Jason Lotz
I was using an iframe to show the details of a selected row from jqgrid. Which worked. However I realized that it is a pain to get iframe to recognize parent size so resizing produces an awkward looking form. I came across web2py LOAD helper and thought it to be a good fix to my frame resizing issu

[web2py] [SOLVED] Re: jqgrid onSelectRow refresh iframe

2010-05-15 Thread Jason Lotz
On May 15, 6:42 pm, Jason Lotz wrote: > Yes I got it working. Using the jqgrid_plugin, very nicely prepared by > parroit, I added an onSelectRow event to trigger the reload of an > iframe on the same page. The id of the selected row is posted as args > to the url. The controller f

[web2py] Re: jqgrid onSelectRow refresh iframe

2010-05-15 Thread Jason Lotz
gt; This could be a nice feature, and also it would be cool to let the > grid show Images from the "upload" Field. > > Dieter Asman > > On 14 Mai, 11:32, Jason Lotz wrote: > > > > > Sorry to keep replying to myself. Just wanted to let you know my > > pr

[web2py] Re: jqgrid onSelectRow refresh iframe

2010-05-14 Thread Jason Lotz
).attr('src',"/MyApp/ default/details/"+(postdata));} }); ## Controller def details(): id = request.args[0] // everything else return dict() Jay On May 14, 5:58 pm, Jason Lotz wrote: > The first and obvious thing I see I did wrong was trying to put python > int

[web2py] Re: jqgrid onSelectRow refresh iframe

2010-05-14 Thread Jason Lotz
understand how I can make it dynamic src, or how to get jquery to communicate with the server. Jay On May 14, 4:59 pm, Jason Lotz wrote: > Now I have two containers, one includes jqgrid_plugin the other > includes iframe to display /default/details view. Both work fine on > the initial loa

[web2py] jqgrid onSelectRow refresh iframe

2010-05-14 Thread Jason Lotz
Now I have two containers, one includes jqgrid_plugin the other includes iframe to display /default/details view. Both work fine on the initial load of the page. Using jqgrid onSelectRow event I tried to add a function to update the iframe page. ## View {{=plugin_jqgrid(db.test,columns=['field

[web2py] Re: XML with custom TAG

2010-04-05 Thread Jason Lotz
Brilliant, Thanks!! Jay On Apr 5, 10:56 pm, DenesL wrote: > On Apr 5, 9:14 am, Jason Lotz wrote: > > > I'm trying to pass an XML string with custom TAG to a view, but I'm > > having trouble with syntax. > > > Required XML Syntax: > >

[web2py] XML with custom TAG

2010-04-05 Thread Jason Lotz
I'm trying to pass an XML string with custom TAG to a view, but I'm having trouble with syntax. Required XML Syntax: cell content cell content The code string in the controller: rowxml=TAG.rows(*[TAG.row(*[TAG.cell(r[f]) for f in rowflds]) for r in rows

[web2py] Re: DAL Oracle Query problems

2010-04-01 Thread Jason Lotz
Thanks!! It is noted... Jay On Mar 30, 10:18 pm, DenesL wrote: > On Mar 30, 4:09 am, Jason Lotz wrote: > > > > > > > I'm sorry if I am repeating an existing discussion. I searched and > > found similar issues but nothing that helped. > > > I am

[web2py] Re: use of the modules directory?

2010-04-01 Thread Jason Lotz
The 'modules' folder is for manually installing packages in the application. http://web2py.com/book/default/section/4/18 Jay On Apr 1, 1:45pm, Miguel wrote: > Hi > > What is the purpose of the modules directory? I did not find an > explanation in the web2py book. > > Also what is the "web2py"

[web2py] Re: use of the modules directory?

2010-04-01 Thread Jason Lotz
The 'modules' folder is for manually installing packages in the application. http://web2py.com/book/default/section/4/18 Jay On Apr 1, 1:45 pm, Miguel wrote: > Hi > > What is the purpose of the modules directory? I did not find an > explanation in the web2py book. > > Also what is the "web2py

[web2py] DAL Oracle Query problems

2010-03-30 Thread Jason Lotz
I'm sorry if I am repeating an existing discussion. I searched and found similar issues but nothing that helped. I am trying to query an oracle db. raw sql: SELECT fld1, fld2 FROM tbl1 WHERE fld1 < 20; I can successfully run the query in SQLPlus and using cx_Oracle directly in web2py. > import

Re: [web2py] Re: global name 'cx_Oracle' is not defined

2010-03-28 Thread Jason Lotz
has anything to do with versions. Are you using the source version of web2py? If not, the windows binary distribution of web2py comes with its own python interpreter and it will not see modules you installed in the "other" python. Massimo On 27 Mar, 22:50, Jason Lotz wrote: The on

Re: [web2py] Can't use db in InteractiveConsole

2010-03-28 Thread Jason Lotz
You don't need to run the import as web2py will automatically import the required modules. Your error comes because you haven't defined your 'db' variable. You must first define your 'db' variable which defines the connection to the database. Example: >>> db = DAL('sqlite://database') >>> r

[web2py] Re: global name 'cx_Oracle' is not defined

2010-03-27 Thread Jason Lotz
it is normally installed > under Python, web2py should be able t use it. > > On 27 Mar, 13:07, Jason Lotz wrote: > > > > > I have tried to build and install from source but I get another error. > > >  >python setup.py build > > running build > > running

[web2py] Re: googling web2py

2010-03-27 Thread Jason Lotz
>From Japan I get ~107,000. -- Jay On Mar 28, 10:23 am, mdipierro wrote: > When you google "web2py" how may hits do you get? from which country? > > When I do it from the US I get ~106,000. The number has been steady > for one year. Before that is was much higher ~600,000. > > When I did it fr

Re: [web2py] global name 'cx_Oracle' is not defined

2010-03-27 Thread Jason Lotz
issing? -- Jay On 03/28/2010 02:17 AM, Thadeus Burgess wrote: I think that it means to run the source version of cx_oracle not the binary version. This would entail downloading the source of cx_Oracle and installing it into your python's site-packages. -Thadeus On Sat, Mar 27, 201

[web2py] global name 'cx_Oracle' is not defined

2010-03-27 Thread Jason Lotz
I am trying to connect to an established oracle database. Working in Windows I downloaded and installed cx_Oracle. In the Python Shell I am able to make a connection. >>> db = DAL('oracle://user/passw...@tns') Traceback (most recent call last): File "", line 1, in File "gluon/sql.py", lin