tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Butler <butle...@manxsoft.net>
Subject Re: help!! why UNION of multiple tables is not working
Date Tue, 12 Jul 2005 15:52:27 GMT
Don Albertson wrote:

> missterie@gmail.com wrote:
>
>> Yes..I have. I mean for example, when you do a simple query like this
>> Select 1,2,3 UNION Select 4,5,6, it should display all rows for all
>> select statements but it only displays 3,6.
>>  I thought a UNION could be used for multiple tables with unrelated
>> data, as long as am selecting the same fields or number of fields?
>
>
>
> What happens if you replace the sql tags with scriptlet code that
> creates a Connection, a Statement, executes the query text and returns 
> the ResultSet?  Does that returned ResultSet contain what you expect?
>
>
>
>
>>  
>>
>> On 7/12/05, McCormack, Chris <Chris.McCormack@littlewoods.co.uk> wrote:
>>
>>> Have you checked the row coming back from t2 exists in t1 also ? 
>>> That would explain only one row being returned.
>>>
>>> -----Original Message-----
>>> From: missterie@gmail.com [mailto:missterie@gmail.com]
>>> Sent: 12 July 2005 15:30
>>> To: taglibs-user@jakarta.apache.org
>>> Subject: help!! why UNION of multiple tables is not working
>>>
>>>
>>> I have Tomcat 5.0, Servlet 2.4, jstl and standard taglibs 1.1.
>>> And all the required dependencies.
>>> I want to get a UNION of multiple tables
>>>
>>> so like
>>>   <sql:query dataSource="" var="row">
>>> SELECT name, user, addr from t1
>>> UNION
>>> SELECT name, user, addr from t2
>>>
>>> </sql:query>
>>>
>>> However, the UNION of  multiple tables does not bring forth the right
>>> result. It displays the last table fields. In this case, only
>>> field in t2.
>>> Is this a jstl and standard taglin issue or does this
>>> have to do with the fact that I have mysql version 3.23?
>>>
>>> I am still trying to understand how these taglibs work.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
>>> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
>>>
>>>
>>>
>>> *****************************************************************************

>>>
>>> This e-mail and its attachments are confidential and are intended 
>>> for the above named recipient only. If this has come to you in 
>>> error, please notify the sender immediately and delete this e-mail 
>>> from your system. You must take no action based on this, nor must 
>>> you copy or disclose it or any part of its contents to any person or 
>>> organisation. Statements and opinions contained in this email may 
>>> not necessarily represent those of Littlewoods Group Limited or its 
>>> subsidiaries. Please note that e-mail communications may be 
>>> monitored. The Registered Office of Littlewoods Group Limited and 
>>> its subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. 
>>> Registered number of Littlewoods Group Limited is 5059352.
>>> *****************************************************************************

>>>
>>>
>>>
>>>
>>>
>>> This message has been scanned for viruses by BlackSpider MailControl 
>>> - www.blackspider.com
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
>>
>>
>
>
Is it not UNION ALL ?

-- 
Regards

Dave Butler
butlerdi-at-manxsoft-dot-net

Also on Skype as butlerdi

Get Skype here http://www.skype.com/download.html


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


Mime
View raw message