Re: attributes..

2003-07-28 Thread Rick Ross
As a follow up, all of the XPath testers I have used return a simple string
for that Xpath statement.


- Original Message -
From: "Rick Ross" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 8:31 PM
Subject: X: attributes..


I'm trying to use the value of an xml attribute in calculations later on in
the page.   Perhaps I'm mistaken, but given the following xml:
  
  
  
  

and the following JSP:
  
  
  SELECT * FROM orders WHERE date = ?
  
  
I get no rows returned.   I realize that the x:set is setting a node-set (or
at least that is my guess) but I dont see how to get that XPath to give me a
string.

Can anyone help?  Thanks.


Rick


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



X: attributes..

2003-07-28 Thread Rick Ross
I'm trying to use the value of an xml attribute in calculations later on in the page.  
 Perhaps I'm mistaken, but given the following xml:
  
  
  
  

and the following JSP:
  
  
  SELECT * FROM orders WHERE date = ?
  
   
I get no rows returned.   I realize that the x:set is setting a node-set (or at least 
that is my guess) but I dont see how to get that XPath to give me a string.

Can anyone help?  Thanks.


Rick

Formatting timestamps retrieved in a sql result set

2003-07-28 Thread Narayan, Anand
After executing a query I want to format any date and time values
using a custom pattern before displaying them.
How would I accomplish this?

Heres the query I am executing in my JSP:

SELECT parameter.PARM_ID "id",
parameter.LAST_CHANGE_DATE "updateTime",
parameter.LAST_CHANGE_BY "updateUser"
FROM PARAMETER parameter
ORDER BY parameter.LAST_CHANGE_DATE asc,parameter.LAST_CHANGE_BY asc


Here is part of the display code. I want to format ${row.updateTime}
to a different date time format.   THANKS


...
...
...
 >
   
   
   



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Getting default data source into JSP

2003-07-28 Thread Shawn Bayern
On Mon, 28 Jul 2003, Michael Duffy wrote:

> I'm thick - how do I refer to it in the JSP?  Shawn Bayern's "JSTL In
> Action" says that the constant is Config.SQL_DATA_SOURCE, and its
> variable name is javax.servlet.jsp.jstl.sql.dataSource.  What scope is
> this variable in, and how can I get at it in my JSP?
>
> It sounds like I'll have to use the rt library [...]

There is indeed a standard constant and a standard name for the
context-initialization parameter, but the data is not necessarily saved in
a particular scope with a particular name.  (If I remember correctly, this
was designed to give greater flexibility to implementations and future
versions of JSTL.)

To retrieve the data, you'll want to use the Config class itself, which
abstracts the variables for programmers.  I can't think of any way to
retrieve the information in a standard fashion using just the 'el' tags.

-- 
Shawn Bayern
"JSTL in Action"   http://www.jstlbook.com


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Getting default data source into JSP

2003-07-28 Thread Michael Duffy

I'd like to write a simple JSP that would display all
the JDBC meta-data for the default data source.  

I'm thick - how do I refer to it in the JSP?  Shawn
Bayern's "JSTL In Action" says that the constant is
Config.SQL_DATA_SOURCE, and its variable name is
javax.servlet.jsp.jstl.sql.dataSource.  What scope is
this variable in, and how can I get at it in my JSP?

It sounds like I'll have to use the rt library, since
I'd like to have JSP code that will look like this:



Any advice would be appreciated.  Thanks - MOD

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Getting XML data from Apache

2003-07-28 Thread Michael Duffy

Hi Chris, 

I'm not 100% sure that I understand what you mean by
getting XML from Apache using the POST method.  I
thought POST was a method for an HTTP client to send a
request to an Apache/HTTP server.  Do you mean you'd
like to know how to get your XML stream into the
response that's sent back?

One way would be for a servlet would add the XML
stream as an attribute to the request or session so
your JSP could get at it using
request.getAttribute("xmlKey").  

I'll apologize in advance if I've misunderstood. - MOD


--- "Hardin, Christopher (Chris), ALABS"
<[EMAIL PROTECTED]> wrote:
> I'm new to Tomcat and JSTL so please forgive this
> simple question.
> 
> All of the examples I've seen that process XML data
> get the data from a file, a URL, or using c:set.  I
> need to get XML data from Apache using the POST
> method.  What is the best way to do this?  Please
> include examples if possible.  Thank you in advance
> for any help.
> 
>
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Getting XML data from Apache

2003-07-28 Thread Hardin, Christopher (Chris), ALABS
I'm new to Tomcat and JSTL so please forgive this simple question.

All of the examples I've seen that process XML data get the data from a file, a URL, 
or using c:set.  I need to get XML data from Apache using the POST method.  What is 
the best way to do this?  Please include examples if possible.  Thank you in advance 
for any help.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]