tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chuck Amadi <chuck.am...@breconbeacons.org>
Subject Re: db taglibs questions
Date Tue, 16 Jul 2002 08:51:30 GMT
Igor Bursin wrote:

>Hello, Kevin.
>I do not need to show results sql query through web. I want to write down
>results of sql query in variables that further them to use...
>
>----- Original Message -----
>From: "Kevin Passey" <kpassey@kdpsoftware.co.uk>
>To: "'Tag Libraries Users List'" <taglibs-user@jakarta.apache.org>
>Sent: Monday, July 15, 2002 6:31 PM
>Subject: RE: db taglibs questions
>
>
>>Igor,
>>
>>Here is some of my code that displays database stuff in a table - I've
>>
>only
>
>>given the row
>>
>> <TR>
>>                <td><sql:getColumn position="1"/></td>
>>                <td><sql:getColumn position="2"/></td>
>>                <td><sql:getColumn position="3"/></td>
>>                <td><sql:getColumn position="4"/></td>
>>                <td><sql:getColumn position="5"/></td>
>>                <td><sql:getColumn position="6"/></td>
>>                <td><sql:getColumn position="7"/></td>
>>                <td><sql:getColumn position="8"/></td>
>>                <td><sql:getColumn position="9"/></td>
>>                <td><sql:getColumn position="10"/></td>
>>                <td><sql:getColumn position="11"/></td>
>>                <td><sql:getColumn position="12"/></td>
>>                <td><sql:getColumn position="13"/></td>
>>                <td><sql:getColumn position="14"/></td>
>>   </TR>
>>
>>Hope this helps
>>
>>Regards
>>
>>Kevin Passey
>>
>>-----Original Message-----
>>From: Igor Bursin [mailto:igoryan@sampo.ru]
>>Sent: 15 July 2002 15:06
>>To: taglibs-user@jakarta.apache.org
>>Subject: db taglibs questions
>>
>>
>>Hello!
>>I'm using DBTags Tag library.
>>I executes simple  query:
>><sql:statement id="stmt1" conn="conn1">
>><sql:query>
>>select string_value, number_value from my_table
>></sql:query>
>></sql:statement>
>>How i can output result:
>><sql:setColumn position="1"> to the string or int variable (not to JSP
>>directly) ?
>>(i try <% A= <sql:setColumn position="1"> %>, but get error)
>>
>>Best regards, Igor Bursin.
>>
>>
>>--
>>To unsubscribe, e-mail:
>>
><mailto:taglibs-user-unsubscribe@jakarta.apache.org>
>
>>For additional commands, e-mail:
>>
><mailto:taglibs-user-help@jakarta.apache.org>
>
>
>
>--
>To unsubscribe, e-mail:   <mailto:taglibs-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:taglibs-user-help@jakarta.apache.org>
>
Hi alternatively you can use the notaion i use this more often as it's a 
bit clearer and only use the

<sql:getColumn position="1"/> for utilising pure sql queries like 
<sql:query>
select count (surname) from vol_member
</sql:query>

<TR>
                <td><sql:getColumn colName="surname"/></td>
                <td><sql:getColumn colName="forenames"/></td>
                <td><sql:getColumn colName"address"/></td>

</TR>

The best solution is to somehow utilise all the features during the 
learning process trial & error and check out the Tag Summary fot DBTags 
Library.#
Pretty neet stuff.

-- 
Regards 
Chuck Amadi
ICT Dept Systems Programmer
Rhaglenydd Systemau Adran ICT





--
To unsubscribe, e-mail:   <mailto:taglibs-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-user-help@jakarta.apache.org>


Mime
View raw message