I too am a Java guy. The nice part of Java is that it's cross platform
and cross database. Using JDBC and pure java JDBC drivers you can move
your applications to different databases on just about any relevant
platform. This will allow you to run your java applications on Windows,
Mac, Linux,
We are using XSLT and XSL:FOP for our reports. We generate a simple XML
file then transform it into a nicely laid out PDF. You can layout the
pdf's easily with a nice product called XSLFast www.xslfast.com.
Joe
On Thursday, February 19, 2004, at 07:33 PM, Matt Silva wrote:
I'm looking for a
I referred the left join because sub selects are not available in 4.0
(which is the release version) only 4.1. If I'm wrong on this please
somebody tell me.
Joe
On Wednesday, January 21, 2004, at 10:45 PM, Randy Johnson wrote:
SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM
I think this is the package I used. The one that I used actually wrote
and init script so if you reboot mysql will start automagically. I
think this is the one.
Joe
On Thursday, January 22, 2004, at 08:51 AM, Eve Atley wrote:
I successfully used the packages from Server Logistics for this
wow! That is nice
On Thursday, January 22, 2004, at 01:28 PM, Eve Atley wrote:
This one actually installs a preference pane that allow you to
manipulate
settings, start/stop server, and change root password. It's quite nice.
- Eve
-Original Message-
From: sulewski [mailto:[EMAIL
Does anyone know if this or mycc has been compiled for Mac OS X?
On Wednesday, January 21, 2004, at 10:40 AM, Hassan Shaikh wrote:
Hi,
I've learned from fabFORCE.net that DB Designer 4 is bought by MySQL
AB. Could any one from MySQL AB please comment on the new acquisition
and shed some
I believe this would work
select table1.* table1 left join table2 on (table1.id=table2.id) where
tab2.id not null
The left join will match the values together. Null values are inserted
where matches are not made. Since 4 will not make a match null values
will be put in place of the table2
Hello,
For my final solution I decided to use the inner join method. The query
is created dynamically based upon a user interface component that
allows people to build queries using parenthesis, ands and or's. Plus
there is another field that I didn't include in the original question
so as
I think I figured out the time problem. If I make s2 in the or s1 and
remove any instances of s2 it works very fast with the 'or'.
Joe
On Tuesday, January 20, 2004, at 09:50 AM, sulewski wrote:
Hello,
For my final solution I decided to use the inner join method. The
query is created
I'm running on 10.2.8 just fine. I hear panther speeds up the ibooks.
But that is just what I read.
On Tuesday, January 20, 2004, at 03:16 PM, Nicholas wrote:
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my
I'm a java person and I'm happy to say you didn't rouse me. There are
many fine quality in lamp and java. I don't know PHP but I've seen some
really nice apps written in php. It looks like a nice clean language
and very nice for web development.
On Tuesday, January 20, 2004, at 03:34 PM,
Okay, I think I'm missing something obvious. I have two tables
Table 1 Table 2
___ _
ID rdid vid
___ _
ID in table 1 links to rdid in table 2. This
I think you can just put the alias after the field like so,
select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
SectionId,Title,Summary...
On Monday, January 19, 2004, at 02:16 PM, Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
by Roger ?
I only ask because at that time I saw the query and thought to myself
that
the left outer join solution posted by Roger
would not give you the results you had expected.
- Original Message -
From: sulewski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 19, 2004 3:47
do it? :)
- Original Message -
From: sulewski [EMAIL PROTECTED]
To: Jamie Murray [EMAIL PROTECTED]
Sent: Monday, January 19, 2004 4:41 PM
Subject: Re: SQL Query Question
I asked a similar question but this time it's different. Last time I
was looking for places where the record in table 1
, sulewski wrote:
Okay, I think I'm missing something obvious. I have two tables
Table 1 Table 2
___ _
ID rdid vid
___ _
ID in table 1 links to rdid in table 2
Hello,
Hopefully you sql guru's can help me out a bit. :)
Here is the short example of what I want to accomplish. I wish to
have the difference between two different select queries.
So if one query pulls records 1,2,3 and 4 and the second pulls records
1 and 4 I wish to have only the records 2
have null values. I did try what you said and it didn't work.
But thanks,
Joe
On Friday, January 16, 2004, at 11:49 AM, Roger Baklund wrote:
* sulewski
[...]
What I need is all records in table 1 that will
not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join
, 2004, at 11:49 AM, Roger Baklund wrote:
* sulewski
[...]
What I need is all records in table 1 that will
not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join to the rows you do NOT want with a left join, and put as a
condition in
the WHERE clause
is why I
didn't get Roger's post.
Thank you very much guys. You saved the day.
Joe
On Friday, January 16, 2004, at 12:31 PM, gerald_clark wrote:
That is the whole point of a left join.
It joins to a null record when the appropriate right record does not
exist.
sulewski wrote:
Roger,
Thank you
20 matches
Mail list logo