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" <[EMAIL PROTECTED]>
>To: "'Tag Libraries Users List'" <[EMAIL PROTECTED]>
>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:[EMAIL PROTECTED]]
>>Sent: 15 July 2002 15:06
>>To: [EMAIL PROTECTED]
>>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:[EMAIL PROTECTED]>
>
>>For additional commands, e-mail:
>>
><mailto:[EMAIL PROTECTED]>
>
>
>
>--
>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
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:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
