Than you VERY much for the info. I managed to get your videos on Vimeo.com
and have learned a lot . I am still new in python and this is a good start.
About table/filed...
With this app, its a single table with several fields of CHAR type, fields
are numbered e.g from 1 to 25, e.g wit this app, location 15 records
desired data.The field 'id' is of type int, & incremental.
Am now confused about the database request..could you please hint at what I
can do to fix the requests.
Regards
On Sunday, April 20, 2014 4:25:43 AM UTC+3, Massimo Di Pierro wrote:
>
> You can split a string with name.split() and you can print in HTML with
> {{=a}} where a is a string or other serializable type.
> We can help you much more if you tell us the names and types of the fields
> in your table. You app is going to be very slow because you open the
> database at every request, and fetch all records at every request. This can
> be simplified a lot.
>
> On Saturday, 19 April 2014 04:57:34 UTC-5, Maurice Waka wrote:
>>
>>
>> I am trying to use web2py to build an app. I have a simple print function
>> that a user submits a key word . The string or int key word is directed to
>> an sqlite db to retrieve a row and output the data. I need to know 1. how
>> to use the print on html. 2. How to split the string...so far i did the
>> list:string
>>
>> Here is my code:
>>
>> def first():
>> form = SQLFORM.factory(Field('visitor_name',
>> label = 'Please Type Your keyword here!',
>> requires= [IS_NOT_EMPTY(),
>> IS_LOWER(),'list:string']))
>> form.element('input[type=submit]')['_onclick'] = "return \
>> confirm('Are you sure you want to submit:');"
>> if form.process().accepted:
>> session.visitor_name = form.vars.visitor_name
>> redirect(URL('main'))
>> return dict(form=form)
>>
>> def main():
>> while True:
>> name = request.vars.visitor_name or redirect(URL('first'))
>> name2 = name[:]
>> for item in name2:break
>> name3 = ' '.join(name2)
>> import sqlite3
>> id = 0
>> location = ""
>> conn = sqlite3.connect("keywords.db")
>> c = conn.cursor()
>> c.execute('select * from kmedicals')
>> records = c.fetchall()
>> for record in records:
>> id = record[0]
>> location = record[15]
>> if id == name3:
>> print name3.capitalize(),':' '\n',location
>> break
>> sys.exit()
>> return dict(name=name)
>>
>> my view...default/main.html:
>>
>> {{extend 'layout.html'}}{{=name}}
>>
>>
--
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 Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
