Hi again after reading chapter 6,
I have found what I'm looking for.
I did the following and got thre results I wanted.
{{for r in row:}}
<p>{{=r.surname}}<p>
{{pass}}
One other question I would like to ask.
web2py works a lot like codeigniter for php using MVC, does web2py let you
use jquery to send data using json ajax back to the controllers.
For example using: <div
id='tracks_selected'onclick='getTracks($album->track_id) in the view.
Then use the following jquery
function getTracks(id) {
$.post("/media/getTracks", { id:id },
function(data){
$('#tracks').html(data);
});
}-
Which would go the a controller /media/tracks with the id number to be
processes in the controller?
On Monday, 9 March 2015 13:56:38 UTC, Garry Smith wrote:
>
> Hi Thanks for the reply,
>
> I have got query 2 working with the following:-
>
> qry = request.vars.upn_no
> q = (db.pupils.upn_no == qry)
> s = db(q)
> row = s.select(db.pupils.upn_no,db.pupils.surname)
>
> which gives me the following.
>
> pupils.upn_no pupils.surname
>
> 5555 Dalglish
>
> Once in the view is their a way off changing column headings and just
> showing what you want from the db.
>
>
>
>
>
>
> On Monday, 9 March 2015 13:48:17 UTC, Jim S wrote:
>>
>> thelist=[row.first_name for row in db(db.user.upn == 444).select()]
>>
>> Have you read chapter 6 from the book? It is well worth your time and
>> should help with most of your questions.
>> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer
>>
>> -Jim
>>
>>
>>
>>
>>
>>
>> On Monday, March 9, 2015 at 8:31:13 AM UTC-5, Garry Smith wrote:
>>>
>>> I'm new to web2py, but do have a php and mysql background using
>>> codeigniter.
>>> I'm trying to write a couple of queries but sure how to do them.
>>> These are the queries I'm trying to write,
>>>
>>> query1
>>>
>>> SELECT user.s_name, user.f_name, user.year, pe.date, pe.sport, pe.id
>>> FROM user
>>> INNER JOIN pe
>>> ON user.user_id=pe.user_id
>>> WHERE pe.date = DATE(NOW())
>>> ORDER BY user.year"
>>>
>>> query 2
>>>
>>> SELECT user.upn, user.f_name, user.s_name where user.upn = '4444'
>>>
>>> I tried this on the second query,
>>> thelist=[row.first_name for row in db().select(db.pupils.first_name,
>>> db.pupils.upn')]
>>>
>>> which pulls all records, need to know where to put " where upn = '4444'"
>>>
>>> Thanks in advance.
>>>
>>>
>>>
>>>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
