[wdvltalk] Re: Sorting ADO recordsets
> 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 from sometable union select bar from someothertable order by 1 but be aware that the ORDER BY here applies to the fullselect, and it is the combined entire result set that is sorted, and not the last subselect > I definitely don't get Rudy's example below. Sorry to be so thick. hey, man, don't fret just try it and see what you get ask questions if it doesn't work or you don't understand that's why we're here ;o) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 reliably support those css attributes. Thanks, I agree a fixed width is better. IE doesn't seem to render %'s as well as the other browsers. BTW, I'm just down the street from you at my dad's in Orange County this week. What! nobody in their right mind that doesn't have to work in Orange County goes there at all during the week or even weekends. It's the 3 hour drive problem. Traffic is so very slow, bumper to bumper, it takes at lease 3 hours to get from Riverside to Orange County let alone Los Angeles. Where does your Dad live in Orange County? Aren't you going to Europe? You're going to visit your Dad first? Jan The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
Thanks Cheryl -- It's beginning to sound like a job for Masochist Man :^) lol Cheryl D. Wise wrote: 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 the examples would still be "live" on the net or not is another thing. css-discuss [EMAIL PROTECTED] http://www.css-discuss.org/mailman/listinfo/css-d Cheryl D. Wise Microsoft MVP WiserWays, LLC 713 353-0139 www.wiserways.com mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [ 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 rather than tables? I create a few calendars every month at work and tables are quick and dirty, but it would be fun to try something new :^). • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 - our baby girl is named Amanda (born 6/19) Amanda Birmingham wrote: 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, though, I think this might be going a bit far (unless you're just doing it for the challenge :) Eschewing tables for general layout tasks keeps presentation details from overwhelming our html ... but I believe tables are still totally appropriate for representing data that really *is* tabular in nature. A calendar may well be a case of such data. My 2c :) Amanda Birmingham Web Application Developer >: Drew (or actually anyone) - do you use CSS for creating calendars : rather than tables? I create a few calendars every month at work and : tables are quick and dirty, but it would be fun to try something new : :^). : : Scott • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 not a lemming). Thanks again -- Scott Stephen Caudill wrote: 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 table... that may be a good excercise none-the-less and it's something I could give you some pointers on (as I've done it myself). Also, I found a tutorial by Eric Meyer on CSS styled tables for calendaring: http://www.ericmeyeroncss.com/projects/03/ That's a great site and Eric's one of the leading advocates/experts in CSS, spend some time looking about. hth, Stephen http://www.mechavox.com On Tuesday, July 22, 2003 4:54 PM, [EMAIL PROTECTED] commented: : : Drew (or actually anyone) - do you use CSS for creating calendars : rather than tables? I create a few calendars every month at work and : tables are quick and dirty, but it would be fun to try something new : :^). : : Scott • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 the examples would still be "live" on the net or not is another thing. css-discuss [EMAIL PROTECTED] http://www.css-discuss.org/mailman/listinfo/css-d Cheryl D. Wise Microsoft MVP WiserWays, LLC 713 353-0139 www.wiserways.com mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [ 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 rather than tables? I create a few calendars every month at work and tables are quick and dirty, but it would be fun to try something new :^). The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
Cheryl Very nice pages. All pages show up very well in NS4.7, NS7.2, IE6.0, and Opera7.11. I read your .css sheet. Should the width amount in the body section of css be a px amount or can a % be used? The reason I'm asking is because of higher screen resolutions. Jan Cheryl D. Wise wrote: Jan, I converted www.pinespc.org from HTML 3.2 to XHTML when I took it over. I use nothing but CSS for presentation, no tables. Exclusive of images I reduced the page from 27k to 8k plus 5k for the css. Total page reduction without removing any images 14k. I then replaced the javascript rollovers (images of text) with css based text links. Took out another 16k for the images. So without removing a singe 'important' image the page size was reduced by 30k out of the 57-78k they started at. Pages render virtually identically cross browser and cross platform (I've tested with IE 5.2 & Safari on the Mac, IT 6, Opera 6 & 7, NN 6.2 & 4.8 and Mozilla). There is only one page that renders differently and that is the preschool page because NN 4.x can't get the floated images right so I've hidden those images from it. Some people tell me they prefer the page without the images but one of the church members drew them so they stayed. Personally I kind of like them. Cheryl D. Wise Microsoft MVP WiserWays, LLC 713 353-0139 www.wiserways.com mailto:[EMAIL PROTECTED] The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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, though, I think this might be going a bit far (unless you're just doing it for the challenge :) Eschewing tables for general layout tasks keeps presentation details from overwhelming our html ... but I believe tables are still totally appropriate for representing data that really *is* tabular in nature. A calendar may well be a case of such data. My 2c :) Amanda Birmingham Web Application Developer >: Drew (or actually anyone) - do you use CSS for creating calendars : rather than tables? I create a few calendars every month at work and : tables are quick and dirty, but it would be fun to try something new : :^). : : Scott The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 table... that may be a good excercise none-the-less and it's something I could give you some pointers on (as I've done it myself). Also, I found a tutorial by Eric Meyer on CSS styled tables for calendaring: http://www.ericmeyeroncss.com/projects/03/ That's a great site and Eric's one of the leading advocates/experts in CSS, spend some time looking about. hth, Stephen http://www.mechavox.com On Tuesday, July 22, 2003 4:54 PM, [EMAIL PROTECTED] commented: : : Drew (or actually anyone) - do you use CSS for creating calendars : rather than tables? I create a few calendars every month at work and : tables are quick and dirty, but it would be fun to try something new : :^). : : Scott The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 rather than tables? I create a few calendars every month at work and tables are quick and dirty, but it would be fun to try something new :^). Scott Drew's code with boxes: table replacement? .nav{float:left; width:20%; border: 1px dashed;} .main{float:left; width:77%; border: 1px solid black;} .dual{float:left; width:48%; border: 1px blue solid;} .next{clear:both;} navigation more nav Introduction Left column Right column next navigation2 Introduction2 Left column2 Right column2 The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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, while you're experimenting, try a totally fluid design sans table. css .left{float:left; width:32%;} .next{clear:both;} xhtml stuff stuff stuff That will give you 3 columns with a little extra to handle cross-browser width calculation problems. Be sure to clear or you get really interesting results when the browser tries to cram the next box in the 1% left over. Or a more complex design: css .nav{float:left; width:22%;} .main{float:left; width:77%;} .dual{float:left; width:48%;} .next{clear:both;} xhtml navigation Introduction Left column Right column With current browsers (post 4x) you can actually combine classes which makes the css even more flexible. Although this does tend to annoy some people. When using tables in css, read the Table chapter closely. The rules are different for table markup. drew The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Sorting ADO recordsets
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 Tuesday, July 22, 2003 9:21 AM, Furry, Tim commented: : rudy suggested: : :select contactID, (fname + ' ' + lname) as fullname, emailfrom :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 technique to know if the fields are empty rather : than null (in which case you test lname='' instead of lname is null) : : Tim: : Sweet, rudy. :-) Little stuff like this make me realize how much I : still need to learn, even though I've been building SQL databases for : 3-4 years now. My usual approach to a problem like this is to do a : couple of sub-selects and then UNION them. It'd be interesting to : compare speeds between the two methods. : : Tim : ___ : Tim Furry : Web Developer : Foulston Siefkin LLP The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Sorting ADO recordsets
Thanks Guys! I guess I should have noted that I'm using SQL server. I really liked the idea of your first solution, Rudy (NULLS LAST), but it isn't supported in MS SQL Server. Right now I'm leaning toward either splitting it into multiple SQL statements or using the sort option to put the nulls last as Rudy suggested, but am not sure how to go about this. I'd appreciate a point at a tutorial or a concrete example. My knowlege of SQL is kinda limited and I've been introduced to some new ideas so thanks to everyone. -Stephen http://www.mechavox.com On Tuesday, July 22, 2003 6:54 AM, rudy commented: :: "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 (union of 4 selects?) because not only lname can go : null, fname can too : : and where's the ORDER BY? the whole problem is that the result has : to be sorted in a particular way, so there must be an ORDER BY : : ;o) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Sorting ADO recordsets
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 technique to know if the fields are empty rather than null (in which case you test lname='' instead of lname is null) Tim: Sweet, rudy. :-) Little stuff like this make me realize how much I still need to learn, even though I've been building SQL databases for 3-4 years now. My usual approach to a problem like this is to do a couple of sub-selects and then UNION them. It'd be interesting to compare speeds between the two methods. Tim ___ Tim Furry Web Developer Foulston Siefkin LLP The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] OT: Want Keylogger (autoreplace) Tool for Resale
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, especially since I exchange tons of emails each day. I'm now saving at least 30-60 minutes a day just because of this tool. There is a huge market for a product like this, but the useless developers won't return my emails. Have you developed a tool like this and would like to market it? If you have, please contact me for details about a joint venture. I can market it to my existing client base and subscribers quite easily. TIA! Ravi Jayagopal Founder & Software Architect http://WebmasterInABox.net The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
Jan, while you're experimenting, try a totally fluid design sans table. css .left{float:left; width:32%;} .next{clear:both;} xhtml stuff stuff stuff That will give you 3 columns with a little extra to handle cross-browser width calculation problems. Be sure to clear or you get really interesting results when the browser tries to cram the next box in the 1% left over. Or a more complex design: css .nav{float:left; width:22%;} .main{float:left; width:77%;} .dual{float:left; width:48%;} .next{clear:both;} xhtml navigation Introduction Left column Right column With current browsers (post 4x) you can actually combine classes which makes the css even more flexible. Although this does tend to annoy some people. When using tables in css, read the Table chapter closely. The rules are different for table markup. drew -Original Message- From: Jan [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 9:51 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: CSS J.R. I am still using tables for layout, and most of the css thread was about padding, margins, and how to center a table. Believe me, I'm definitely going to learn how to do tables in my css instead of my html pages. You just won't be able to believe how much I have decreased my download times by improving, and using more css. Jan http://www.jdvisions.com J.R. Pitts wrote: > Not that ANYBODY asked me, or that ANYONE cares, but this whole > thread...this is why I still use tables for layout. > > J.R. Pitts * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: CSS
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 Joseph Harris Smile Poetry Weekly (fortnightly) www.smilepoetryweekly.com Batty Balls and other Wicket Wit www.ah-mah-son.com > Jan, > > I converted www.pinespc.org from HTML 3.2 to XHTML when I took it over. I > use nothing but CSS for presentation, no tables. Exclusive of images I > reduced the page from 27k to 8k plus 5k for the css. Total page reduction > without removing any images 14k. I then replaced the javascript rollovers > (images of text) with css based text links. Took out another 16k for the > images. > > So without removing a singe 'important' image the page size was reduced by > 30k out of the 57-78k they started at. Pages render virtually identically > cross browser and cross platform (I've tested with IE 5.2 & Safari on the > Mac, IT 6, Opera 6 & 7, NN 6.2 & 4.8 and Mozilla). There is only one page > that renders differently and that is the preschool page because NN 4.x can't > get the floated images right so I've hidden those images from it. Some > people tell me they prefer the page without the images but one of the church > members drew them so they stayed. Personally I kind of like them. > > > Cheryl D. Wise > Microsoft MVP > WiserWays, LLC > 713 353-0139 > www.wiserways.com > mailto:[EMAIL PROTECTED] > > > -Original Message- > From: Jan > > J.R. > I am still using tables for layout, and most of the css thread was about > padding, margins, and how to center a table. > > Believe me, I'm definitely going to learn how to do tables in my css instead > of my html pages. You just won't be able to believe how much I have > decreased my download times by improving, and using more css. > > Jan > http://www.jdvisions.com > > J.R. Pitts wrote: > > Not that ANYBODY asked me, or that ANYONE cares, but this whole > > thread...this is why I still use tables for layout. > > > . The WDVL Discussion List from WDVL.COM . > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] >Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Sorting ADO recordsets
> "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 (union of 4 selects?) because not only lname can go null, fname can too and where's the ORDER BY? the whole problem is that the result has to be sorted in a particular way, so there must be an ORDER BY ;o) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Sorting ADO recordsets
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 buggin me: > > I have a recordset that contains contact info, nearly all of which is > optional, unfortunately. What I am doing is sorting by the last name, > then the first name, then the email address and plunking these into a > select list. > > What I end up with (in ascending order) is a bunch of email addresses at > the top (those without first or last names in the db), then first names > (no last name in the db) then the neatly ordered first and last names. > > What I'd like is to have the records with a first and last name come > first, then the ones with just first names, then the ones with only an > email address. > > My code looks like this: > > select contactID, (fname + ' ' + lname) as fullname, email > from contacts > where active = 1 > order by lname, fname, email > > would someone kindly throw me a bone? > > Thanks, > Stephen > http://www.mechavox.com > > . The WDVL Discussion List from WDVL.COM . > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] >Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]