Use the "to" property of the getColumn tag (see doco).
e.g. <sql:getColumn position="1" to="field1" />
You can also use the optional scope parameter to set the scope.
e.g. <sql:getColumn position="1" to="field1" scope="page" />
I think it defaults to page scope (others are request,session,....), which
means you'd use the pageContext.getAttribute() method to extract the value
(pageContext.getAttribute("field1")). Hope this helps.
Steve
-----Original Message-----
From: Igor Bursin [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:53 AM
To: Tag Libraries Users List
Subject: Re: db taglibs questions
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]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
