[web2py] Compare database date with user input

Hi Web2py Users, *In drop down, I have some values like Due today , Due Tomorrow , Due Tomorrow. When user will select any option from the drop down. I want to fetch the data from the table according to the option. if I will select due today, Only today date record should be shown. if i sele

[web2py] How send a mail on edit the row in SQLFORm Grid

Hi I do not know how send or call controller function, when i will edit the row of sql form grid. I have go throw the web2py book, i have find some think onupdate property of mysql grid. But i am not able to use as i want. Any when help me in this. Thanks -- --- You received this message b

[web2py] Python script for Import data in MySQL

I am using the flowing script, its ruining but did not import state table import csv # initialize with empty ints and dicts name,cities,countries,states=[],[],[],[] with open('ind.csv','rb') as csvfile: reader = csv.reader(csvfile, delimiter=',') reader.next() #skip header for row

Re: [web2py] External Python Script

for column 'id' at row 1 row) csv_spliter.py:74: Warning: Incorrect integer value: ''3'' for column 'id' at row 1 row) Done Traceback (most recent call last): File "csv_spliter.py", line 89, in row) File "/usr/lib/python2.7/dist-

[web2py] Re: How to control smartgrid search widget height and width?

go to static folder under that u will find css folder select web2py.css(if u r using latest version of web2py) You will find some thing like *Grid * * The default style for SQLFORM.grid even using jquery-iu or another ui framework * will look better with the declarations below * if needed to

Re: [web2py] External Python Script

Hi Viniciusan Can you share the link of that thread. Thanks On Tuesday, 9 July 2013 17:13:39 UTC+5:30, viniciusban wrote: > > Yes, it is possible. > > I answered the same question yesterday, in another thread. > > On Tue, Jul 9, 2013 at 7:39 AM, Rohitraj Sharma > &g

[web2py] External Python Script

Can it is possible in web2py to run any external script by clicking on button . I have a script which read csv file and split into parts. I want to add that script in web2py frame work. Can it possible or not. Exapmle i have file test.py inside the static folder when ever i will click on button

[web2py] Re: Select table in drop down import the file and edit

g > with your set up. Maybe show the code for the main page and its view and > clarify exactly where the view code you have already shown resides. > > Anthony > > On Friday, July 5, 2013 12:58:47 AM UTC-4, Rohitraj Sharma wrote: >> >> No Anthony , i am loading as the

[web2py] Re: Select table in drop down import the file and edit

Thanks Anthony On Thursday, 4 July 2013 20:59:46 UTC+5:30, Anthony wrote: > > On Thursday, July 4, 2013 2:59:17 AM UTC-4, Rohitraj Sharma wrote: > >> http://127.0.0.1:8000/appname/default/form<http://127.0.0.1:8000/admin/default/design/child> >> > > That can'

Re: [web2py] Re: Example for JqGrid

links are not working On Tuesday, 8 June 2010 06:06:42 UTC+5:30, JayLotz wrote: > > Sorry, I have not used the plug-in with inline editing. > > > > On 06/07/2010 11:53 PM, Tomy wrote: > > Thanks Jason. I have already this plug-in(inline edit) used, but > validation(for Date and Time) is not wo

[web2py] csv split

I need a little help of you. I have three table county which contains ID and country name 2nd table is State table which contain state id, state name country id 3rd table is city table city id, city name, state id and county id. i have one master csv file of city table which contains name of cou

[web2py] Re: SQLFORM.grid custom applications

sorry bro in place of parentther should be table name db.children.city.requires = IS_IN_DB(db, db.tablename.id ,'%(name)s') On Thursday, 4 July 2013 14:02:52 UTC+5:30, Kamil wrote: > > Thanks, adding format='%('city_name)s' solves the first problem. That's > obviously in th

[web2py] Re: Select table in drop down import the file and edit

uest. I was asking what URL ends up getting > requested by the browser. > > Anthony > > On Thursday, June 27, 2013 1:12:00 AM UTC-4, Rohitraj Sharma wrote: >> >> >> Hi Anthony >> >> I am not able to get your question. I have one form controller with one &g

[web2py] Re: Select table in drop down import the file and edit

+ > jQuery(this).val(), target='form') > > That will issue an ajax request. I was asking what URL ends up getting > requested by the browser. > > Anthony > > On Thursday, June 27, 2013 1:12:00 AM UTC-4, Rohitraj Sharma wrote: >> >> >> Hi An

[web2py] Re: SQLFORM.grid custom applications

Try This Hope this will help you db.define_table('city', Field(''city_name'),format='%('city_name)s') db.define_table('shop', Field('name'), Field('city','reference parent')) db.children.city.requires = IS_IN_DB(db, db.parent.id,'%(name)s') On Thursday, 4 July 2013 04:26:56 UTC+5:30, Kam

[web2py] Re: Select table in drop down import the file and edit

June 2013 19:09:00 UTC+5:30, Anthony wrote: > > Using the browser developer tools, what URL gets requested when the ajax > call is made? > > On Wednesday, June 26, 2013 2:44:18 AM UTC-4, Rohitraj Sharma wrote: >> >> I want to select some particular table from databas

[web2py] Export file without id of related table

Export file from the two linked tables Here is the example of DB Schema def get_name(c): row = db(db.child.id == c).select(db.child.name).first() return row.name *Child Table* * * db.define_table('child', Field('name') ) *P

[web2py] Re: Select table in drop down import the file and edit

On Thursday, 27 June 2013 10:52:46 UTC+5:30, Rohitraj Sharma wrote: > > This is for fetching data from database > > def im(): > task=db(db.mydb).select() > return dict(rows=task) > > > > For importing file from database > def import_table(): > form = SQ

[web2py] Re: Select table in drop down import the file and edit

The fallowing are python file not php. By mistake i write php On Thursday, 27 June 2013 10:52:46 UTC+5:30, Rohitraj Sharma wrote: > > This is for fetching data from database > > def im(): > task=db(db.mydb).select() > return dict(rows=task) > > > > For impo

[web2py] Re: Select table in drop down import the file and edit

these function destroyUrl: 'destroy_user.py' }); }); CRUD DataGrid   Double click the row to begin editing. Name Phone Email Mobile {{for i,row in enumerate(rows):}} {{=row.name}} {{=row.phone}} {{=row.email}} {{=row.mobile}} {{pass}} New Destroy Save Cancel

[web2py] Re: Select table in drop down import the file and edit

2:44:18 AM UTC-4, Rohitraj Sharma wrote: >> >> I want to select some particular table from database in a drop dowan. >> Then import csv file. edit that file and update. . Can Any one can help me >> plz >> >> i am using the fallowing code for that >> >

[web2py] Re: SQLFORM.smartgrid

You can use labda function in your db Field('companyField name',db.linked table name, represent=lambda c, row:field name of linked table(c), requires=IS_IN_DB(db,'field.id','%(patient)s')), On Wednesday, 26 June 2013 10:36:03 UTC+5:30, Tom Russell wrote: > > Another question on the smartgrid. >

[web2py] Select table in drop down import the file and edit

I want to select some particular table from database in a drop dowan. Then import csv file. edit that file and update. . Can Any one can help me plz i am using the fallowing code for that View jQuery(function() { jQuery('#table').change(function() { web2py_component("{{=URL('default',

[web2py] regarding mail captcha setings

hi i have one contact page where i have db.define_table('message', SQLField('your_name',requires=IS_NOT_EMPTY()), SQLField('your_email',requires=IS_EMAIL()), SQLField('your_message','text',default=VALUE), SQLField('timestamp',default=str(datetime.datetime.now( def tlscontact()

[web2py] REAGARDING WEBGRID AND POWER GRID

I HAVE MADE ONE APPLICATION WHERE I USED WEB GRID AND POWER GRID ITS WORK IN LOCAL HOST BUT WHEN I DEPLOY ON GOOGLE APPS ENGINE IYS SHOW FOR WEB GRID invalid view (default/ Registration_Certificate_Repository.html) AND FOR POWER GRID Internal error Ticket issued: unknown AND MY SECOUND PROBLEM

[web2py] access control(RBAC)

i have so many group, i want according to group user can access the data. For example admin have all controls of CURD,normal user can view data , manager van view and edit, some other user can view only few tabs of menu.Please help me i am able to do . i have more then 50 tabs, tab have also show

[web2py] configuration of mail in appengine

i want to configure the mail in google appengine. i try in smtp server gae , but its not work.