Hi Stephen,
You can use simple union all .
Ex.
select id, fname + space(1)+isnull(lname,'') as fullname from tablename
where lname is not null
union all
select id, fname + space(1)+isnull(lname,'') as fullname from tablename
where lname is null
Thanks,
Elan
I've got one that's really
select id, fname + space(1)+isnull(lname,'') as fullname from tablename
where lname is not null
union all
select id, fname + space(1)+isnull(lname,'') as fullname from tablename
where lname is null
hi elan
i think i know where you're going with that, but you would have to do
something else
Cheryl,
Very impressive. Even on my machine playing slw downloads these pages
came up - well - like a miracle; very fast. If I had the time the energy
and the brain I would learn how to do that!! ;-)
I agree the drawings are right for the site; and good in their own right.
Joseph
Hi all,
I'm looking for a tool like the smart type assistant tool
at http://blazingtools.com/sta.html
(Not an affiliate link, I'm in no way associated with the above
product except as a highly satisfied user).
This thing is so unbelievably phenomenal, that it
has skyrocketed my productivity,
rudy suggested:
select contactID, (fname + ' ' + lname) as fullname, email
from contacts
where active = 1
order by
case when lname is null then '999' else lname end
, case when fname is null then '999' else fname end
, email
however, it's a nice
If you do Union them, does that still allow you to 'order by' the sub queries, or does
it just undo the 'order by'. I'm not sure if that's even the best way, just trying to
understand. I definitely don't get Rudy's example below. Sorry to be so thick.
-Stephen
http://www.mechavox.com
On
Correction, I've taken almost all images out. Other than the
Portfolio page, which has screen shots, all pages have only 2 pages.
Jan
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
Drew,
Thanks for the info. I can't believe that I have over 100 emails
to view today, all valid. I'll probably spend the entire day on
it. I am interested in total fluid design sans table, and will
experiment with it, hopefully, today.
Jan
http://www.jdvisions.com
Trusz, Andrew wrote:
Jan,
I've just spent a little time playing with Drew's code and put boxes
around the classes to see how things line up. If you add margins and
paddings while viewing the output in Mozilla and IE, it's easy to see how
they differ.
Drew (or actually anyone) - do you use CSS for creating calendars
Scott,
I dare say that the mere thought of making a calendar in CSS would make even the
most experienced CSS-Head cringe and whimper for his mommy (I'm currently huddled up
with my thumb in my mouth). That said, I've googled it and didn't turn up anything
more than using CSS to style an HTML
Scott,
I haven't run across anything particularly about calendars, but you might
check out
http://css.nu/articles/table-in-css.html
which has an article about creating table-like displays with CSS; this
might be appropriate if your calendar is to be displayed in ye old grid format.
Personally,
Several people have tried creating calendars with pure css/no tables on the
css-d list (hosted by evolt.org) and the consensus has been that calendars
are tabular data and a table is the best thing to use for them.
I suspect a search of the css-d archives would turn up some of the posts.
Whether
Stephen,
Thanks for the pointer to an example site -- believe it or not, I was
just looking at buying that very same book today! (27.95 @
bookpool.com). It appears I'm not the only one to loathe trying to do a
calendar in css :^) -- but I was willing if someone said it was useful
(hopefully I
Hi Amanda -
Thanks for your input -- it appears that doing a calendar in css would
be analogous to hammering a nail with a Crescent Wrench (I've done that
before :^). It works but it's a lot more trouble than it's worth. Also,
I'll check your link for creating table-like displays...
Scott
btw
Cheryl D. Wise wrote:
Jan,
It can be a percentage or it can be a combination of fixed and percent. The
reason we went with a fixed size is because we needed a minimum size for the
content div and unfortunately IE doesn't support min-width or max-width. At
this point only Mozilla based browsers
If you do Union them, does that still allow you to 'order by' the sub
queries
no
a query that includes a UNION is called a fullselect and its components
are called subselects
the subselects are not allowed to have an ORDER BY, only the fullselect
sometimes you will see this --
select foo
16 matches
Mail list logo