[wdvltalk] RE: SCR http://www.ingentus.com/clients/ifg/index.htm
Hi Jac, The Maroon is a bit overpowering on the home page but once in the site it's ok. You have achieved something different for a Mortgage Company! I really like the home page icons. The text for the links in the site are a bit hard to read and some of the mouse overs make them worse. That's my thoughts. Regards Stephen Hutchinson -Original Message- From: jac [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 January 2004 2:42 p.m. To: [EMAIL PROTECTED] Subject: [wdvltalk] SCR http://www.ingentus.com/clients/ifg/index.htm don't know about this one... the client was looking for something funky, young and memorable as the majority of his clients would be young couples (first time buyers) - kinda like the last thing you'd expect of a mortgage site. But...I don't know if I got it right and I'm blue in the face from looking at it and messing around with it - can someone please have a look and let me know what they think. the homepage (index), about us first time buyers are linked. Obviously there's a lot to be done to the pages but I don't want to go any further until I get someone else's opinion other than my own. http://www.ingentus.com/clients/ifg/index.htm excuses excuses... the colours of the logo didn't help a lot either - as you'll see the maroon red and dark blue make up the logo, not a lot to work with :o( thanks again all my best jac. Jaclyn Ward ingentus.com -- M: 00 353 (0)87 6160 580 T: 00 353 (0)21 4323 907 F: 00 353 (0)21 4323 907 E: [EMAIL PROTECTED] W: www.ingentus.com 43 Capwell Avenue, Turners Cross, Cork City, Ireland. NOTE: THIS IS A CONFIDENTIAL COMMUNICATION. This transmission is intended only for the use of the individuals or entity to which it is addressed. If you are not the intended recipient, or the person responsible for delivering the message to the intended recipient, please return it immediately. Although this e-mail and any attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by us for any loss or damage arising in any way from its unauthorized modification or use. . 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: UK web host
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 21 January 2004 9:12 pm, Cheryl D. Wise wrote: I was asked if I knew of a good web host in the UK. Since I don't have any experience with UK hosts I thought I'd ask here since I know a fair number of you are in the UK. I'm with One and One (http://www.oneandone.co.uk/) with a dedicated server, and they've been good so far. Their connectivity is excellent. I've performed downloads on my server (updating sofware etc) and seem around 7Mb/sec on it before. It got Slashdotted recently, but held up to the strain fine and the site remained quick and responsive. They do a fair variety from very basic (and very cheap) packages, right up to high-end servers. Cheers David P -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFAD5tKrz7S5k65yyYRAiI0AKCyn52wqXtlKRmzSTHNxaObexhsmACfVL5a laeri8U05CIrBGJmyHlHndk= =pxfY -END PGP SIGNATURE- 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: MySql front won't select
SELECT * FROM test WHERE 1 = orange; joseph i can see what you were trying to do if it had worked it would have been something new of course the number 1 will never equal the string orange you have to use a column name and everything will be, um, cool ;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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] MySql front won't select - 2nd time
I have a table 'test' in database 'test' with two columns and 20 rows. I have used both DBManager and MySql Front to select with this SELECT*FROM test WHERE 1=orange; (after much sweat) this appears to be acceptable syntax. However, while the two fields are acknowledged both programs tell me there are '0' rows. a) have I missed something from the query? OR b) is there a fault in the program? OR c) might I have missed a step which makes the table contents clear to the program? Joseph 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: MySql front won't select - 2nd time
SELECT*FROM test WHERE 1=orange; (after much sweat) this appears to be acceptable syntax. hey, did you not like my poem? i suspect you want the 1 to refer to the first column you can do this only in the ORDER BY clause in the WHERE, each item is interpreted as a literal or column you have two literals there, a numeric 1 and a string orange there's no way in hell that 1 will ever equal orange what are the two column names in your table? rudy 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: SCR http://www.ingentus.com/clients/ifg/index.htm
--- jac wrote: --- : ... Obviously there's a lot to be done to the : pages but I don't want to go any further until I get someone : else's opinion other than my own. Mozilla 1.6, Win2k Pro Jac, I really think the pages could use a splash of constrasting color. Something about the iconography awash in a sea of maroon lacks 'oomph' to me. I've also been leaning heavily toward not having my content stretch to fit the browser window because it simply is not comfortable for my eyes[scr1], and I have excellent sight. Here is a passage from Web Style Guide - Basic Design Principles for Creating Web Sites: -- The ideal line length for text layout is based on the the physiology of the human eye... At normal reading distance the arc of the visual field is only a few inches - about the width of a well-designed column of text, or about 12 words per line. Research shows that reading slows and retention rates fall as line length begins to exceed the ideal width, because the reader then needs to use the muscles of the eye and neck to track from the end of one line to the beginning of the next line. If the eye must traverse great distances on the page, the reader is easily lost and must hunt for the beginning of the next line. Quantitative studies show that moderate line lengths significantly increase the legibility of text. -- I also found a great article[1] on this subject. Now... The site is solid. It functions as expected in my chosen browser and is handled with your usual level of pro- fessionalism. I think your client will be happy with it as is, but it could only do better if it had a bit more color or perhaps some collaged photographs, etc... Cheers, Stephen http://www.mechavox.com/ [scr1] http://neohero.municode.com/scr/jac-ifg.jpg [1] http://www.netmechanic.com/news/vol2/design_no4.htm 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] SCR http://www.ingentus.com/clients/ifg/index.htm
jac wrote: don't know about this one... the client was looking for something funky, young and memorable as the majority of his clients would be young couples (first time buyers) - kinda like the last thing you'd expect of a mortgage site. But...I don't know if I got it right and I'm blue in the face from looking at it and messing around with it - can someone please have a look and let me know what they think. the homepage (index), about us first time buyers are linked. Obviously there's a lot to be done to the pages but I don't want to go any further until I get someone else's opinion other than my own. Tim: What, no Flash? No hip-hop beat in the background? No spinning gifs? LOL Although you're messing with an unusual color scheme (and very different from your usual design output), I kind of like it...it's definitely different than what a first-time user would expect. Only thing I'd change would be the text content header from the yellow to the maroon...the yellow (or orange, whatever you prefer) isn't very easy to read on a white background, at least for me. Might end up using some other design element to pull the yellow back in if you change the text. Tim 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Why does this overlap? (...or Why Does IE suck?)
on http://gojohnniego.com/endorsements.asp On some widths in IE, words on the right side of the center (main) content column will overlap into the td cell next to it. You can see this by slowing reducing the width of your viewing window. I've tried fixing this with various margin settings, but it always seems to happen. I've even wrapped it up in a margined DIV. This doesn't happen in Opera. My next is to add a blank td in, but I'd like to know WHY this happens, as I've run into it before. Thanks. J.R. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?)
One problem you have is the use of the xml prolog. This causes IE6 to act in quirks mode (making it like IE5.5). Remove that and see what happens. I'd suggest a review of the standards for the use of tables: http://www.w3.org/TR/CSS21/tables.html Validator says there are a number of xhtml errors. Those need to be fixed as well before why can be solved. Actually, if you want to use the table for layout, change the doctype to just html not xhtml. You might even validate then. This is not a layout which calls for a table so you're just complicating things by using xhtml. Misuse css for style only and some of your problems will probably just resolve themselves. drew -Original Message- From: J.R. Pitts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:25 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Why does this overlap? (...or Why Does IE suck?) on http://gojohnniego.com/endorsements.asp On some widths in IE, words on the right side of the center (main) content column will overlap into the td cell next to it. You can see this by slowing reducing the width of your viewing window. I've tried fixing this with various margin settings, but it always seems to happen. I've even wrapped it up in a margined DIV. This doesn't happen in Opera. My next is to add a blank td in, but I'd like to know WHY this happens, as I've run into it before. Thanks. J.R. * 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?)
Thanks, I'll give it a shot. The entire quirks mode of CSS for layout is why I still use tables for layout. J.R. -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?) One problem you have is the use of the xml prolog. This causes IE6 to act in quirks mode (making it like IE5.5). Remove that and see what happens. I'd suggest a review of the standards for the use of tables: http://www.w3.org/TR/CSS21/tables.html Validator says there are a number of xhtml errors. Those need to be fixed as well before why can be solved. Actually, if you want to use the table for layout, change the doctype to just html not xhtml. You might even validate then. This is not a layout which calls for a table so you're just complicating things by using xhtml. Misuse css for style only and some of your problems will probably just resolve themselves. drew -Original Message- From: J.R. Pitts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:25 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Why does this overlap? (...or Why Does IE suck?) on http://gojohnniego.com/endorsements.asp On some widths in IE, words on the right side of the center (main) content column will overlap into the td cell next to it. You can see this by slowing reducing the width of your viewing window. I've tried fixing this with various margin settings, but it always seems to happen. I've even wrapped it up in a margined DIV. This doesn't happen in Opera. My next is to add a blank td in, but I'd like to know WHY this happens, as I've run into it before. Thanks. J.R. * 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?)
The entire quirks mode of CSS for layout is why I still use tables for layout. well, that's easy to fix just code for standards mode i.e. validate your html, and then your css ;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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Why does this overlap? (...or Why Does IE suck ?)
Why so? That is, what about quirks makes table layout a good solution? drew -Original Message- From: J.R. Pitts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:22 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?) Thanks, I'll give it a shot. The entire quirks mode of CSS for layout is why I still use tables for layout. J.R. -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: Why does this overlap? (...or Why Does IE suck?) One problem you have is the use of the xml prolog. This causes IE6 to act in quirks mode (making it like IE5.5). Remove that and see what happens. I'd suggest a review of the standards for the use of tables: http://www.w3.org/TR/CSS21/tables.html Validator says there are a number of xhtml errors. Those need to be fixed as well before why can be solved. Actually, if you want to use the table for layout, change the doctype to just html not xhtml. You might even validate then. This is not a layout which calls for a table so you're just complicating things by using xhtml. Misuse css for style only and some of your problems will probably just resolve themselves. drew -Original Message- From: J.R. Pitts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:25 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Why does this overlap? (...or Why Does IE suck?) on http://gojohnniego.com/endorsements.asp On some widths in IE, words on the right side of the center (main) content column will overlap into the td cell next to it. You can see this by slowing reducing the width of your viewing window. I've tried fixing this with various margin settings, but it always seems to happen. I've even wrapped it up in a margined DIV. This doesn't happen in Opera. My next is to add a blank td in, but I'd like to know WHY this happens, as I've run into it before. Thanks. J.R. * 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. * 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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
[wdvltalk] RE: [OT] Is M$ trying to pirate XML?
I remember that an older version of WordPerfect had SGML. Plus, they had the first wordprocessing software that did HTML. Please correct me if I'm wrong but isn't XML just a subset of SGML? A decaf version (XML) versus expresso (SGML)? I hope the Patent Office says no. As they're just using something that already exists. Chris 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: [SQL] Tricky join
Sorry about the double post -- I'd forgotten that my list settings were to not receive my own messages and I was sitting here going, what's wrong with the list?? :) Anyway, I realize that the following statement works, but it's really kind of a kludge and I was hoping for something better: SELECT um.userMovieID, um.userID, um.movieEditionID, (SELECT TOP 1 borrower_userID FROM MovieCheckouts mc1 WHERE mc1.userMovieID=um.userMovieID ORDER BY dateCheckedOut DESC) AS borrower_userID, (SELECT TOP 1 dateCheckedOut FROM MovieCheckouts mc1 WHERE mc1.userMovieID=um.userMovieID ORDER BY dateCheckedOut DESC) AS dateCheckedOut, (SELECT TOP 1 dateCheckedIn FROM MovieCheckouts mc1 WHERE mc1.userMovieID=um.userMovieID ORDER BY dateCheckedOut DESC) AS dateCheckedIn FROM UsersMovies um WHERE um.movieEditionID IN ([id list]) That's awfully unwieldy. Anyone got a better way? Thanks. At 04:37 PM 1/22/2004, Howard Cheng wrote: SELECT um.userMovieID, um.userID, um.movieID, t.borrower_userID, t.dateCheckedOut, t.dateCheckedIn FROM UsersMovies um LEFT JOIN ( SELECT TOP 1 userMovieID, borrower_userID, dateCheckedOut, dateCheckedIn FROM MovieCheckouts mc WHERE mc.userMovieID=um.userMovieID ORDER BY dateCheckedOut DESC ) AS t ON um.userMovieID = t.userMovieID WHERE um.movieID IN ([id list goes here]) :: Howard Cheng http://www.howcheng.com/ howcheng at ix dot netcom dot com AIM: bennyphoebe ICQ: 47319315 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: Home network Public address.
You have to use the router utility to find out what the ip address of the router is. You will also need to figure out port forwarding (check your router documentation) to forward requests to that ip address to your computers internal network address. Better yet, upload the files to your webserver send you friend the url and let him download it from there. Once he's downloaded it delete it from your webserver. (Don't link the file to any pages on your website so nobody else will stumble on them while they are there.) Cheryl D. Wise Certified Professional Web Developer MS-MVP-FrontPage www.wiserways.com mailto: [EMAIL PROTECTED] 713.353.0139 Office -Original Message- From: Yumin My OS is winXPpro with SSI installed. In the past, it connected to cable-modem and then go to Internet. Although the IP address is dynamical, I can know it each time via ipconfig. My friend can come and fetch the files in the wwwroot/ftproot. Now I installed a router. My winXP connects to router with a network cable and the router connects to cable-modem to Internet. I check my IP address by ipconfig, it only tell me 192.168.2.102 without public address. In case of home network, can my friend come again to fetch the files in my PC? 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: Home network Public address.
That looks like the standard router address, which is not your true IP. Your router will have to be configured to allow outside connections. Contact the manufacturer for instructions. AuntySpam, SLP Coordinator, pspug.org http://www.pspug.org/edu/edu.shtml http://www.pspug.org/edu/slp/assign.shtml http://www.pspug.org/edu/slp/slpparticipants.htm Original Message From: Yumin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 4:59 PM Subject: [wdvltalk] Home network Public address. : Hello all: : : My OS is winXPpro with SSI installed. In the past, it : connected to : cable-modem and : then go to Internet. Although the IP address is dynamical, I : can know it : each time : via ipconfig. My friend can come and fetch the files in the : wwwroot/ftproot. : : Now I installed a router. My winXP connects to router with a : network cable : and the router : connects to cable-modem to Internet. I check my IP address by : ipconfig, it : only tell me : 192.168.2.102 without public address. : : In case of home network, can my friend come again to fetch : the files in : my PC? : : Yumin : : : . 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%% : : To unsubscribe via postal mail, please contact us at: : Jupitermedia Corp. : Attn: Discussion List Management : 475 Park Avenue South : New York, NY 10016 : : Please include the email address which you have been contacted : with. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: [SQL] Tricky join
Any ideas? Thanks. you sure that's sql server, not access? when did sql server start using autoincrement? isn't it identity? as far as the syntax is concerned, i can see what you're trying to do in the subquery, you've got um as a correlation variable in there, and yet you are trying to do a join to the same subquery as a derived table i'm not sure i can explain it, but that won't work try it like this -- select um.userMovieID, um.userID, um.movieID , mc.borrower_userID, mc.dateCheckedOut, mc.dateCheckedIn from UsersMovies um left outer join MovieCheckouts mc on um.userMovieID = mc.userMovieID and mc.dateCheckedOut = ( select max(dateCheckedOut) from MovieCheckouts where userMovieID = mc.userMovieID ) where um.movieID IN ([id list goes here]) that uses a correlated subquery too, but what this one does is group the movies in the mc table by userMovieID, and take the latest, and use that as the row to get in the left outer join not sure i can explain that, either let me know if it works rudy 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: [SQL] Tricky join
Yeehaw, it's Rudy to the rescue! At 05:25 PM 1/22/2004, you wrote: Any ideas? Thanks. you sure that's sql server, not access? when did sql server start using autoincrement? isn't it identity? You're right, but I always create the tables in SQL Enterprise Manager so I'd forgotten the syntax. :) as far as the syntax is concerned, i can see what you're trying to do in the subquery, you've got um as a correlation variable in there, and yet you are trying to do a join to the same subquery as a derived table i'm not sure i can explain it, but that won't work Yeah, I can see why it doesn't work -- the um alias hasn't been established at the time of the subquery, or something like that. try it like this -- select um.userMovieID, um.userID, um.movieID , mc.borrower_userID, mc.dateCheckedOut, mc.dateCheckedIn from UsersMovies um left outer join MovieCheckouts mc on um.userMovieID = mc.userMovieID and mc.dateCheckedOut = ( select max(dateCheckedOut) from MovieCheckouts where userMovieID = mc.userMovieID ) where um.movieID IN ([id list goes here]) that uses a correlated subquery too, but what this one does is group the movies in the mc table by userMovieID, and take the latest, and use that as the row to get in the left outer join not sure i can explain that, either let me know if it works Not sure I can explain it either, but I understand what the concept. (: It seems to work fine, but then again I only have one record in the database now as I'm still early in development, so we'll see, but the logic behind it is impeccable. As always, thanks a ton. :: Howard Cheng http://www.howcheng.com/ howcheng at ix dot netcom dot com AIM: bennyphoebe ICQ: 47319315 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] Is M$ trying to pirate XML?
- Original Message - Sent: January 22, 2004 8:47 AM Subject: [wdvltalk] RE: [OT] Is M$ trying to pirate XML? I remember that an older version of WordPerfect had SGML. Plus, they had the first wordprocessing software that did HTML. Please correct me if I'm wrong but isn't XML just a subset of SGML? A decaf version (XML) versus expresso (SGML)? I hope the Patent Office says no. As they're just using something that already exists. It's been described as a subset by some, as it is based on it in some ways but requires different tools to implement. XML is like a cross between SGML and HTML. It has the flexibility developers need to define types of content and how they are related while being less complex than full-blown SGML. Since for all practical purposes it encompasses HTML, existing Web content can remain as it currently stands. Because it has most of the power of SGML, a single tagged text document could conceivably drive not only display of Web sites, but production of paper documents. Here's an old conversation about subset: http://lists.w3.org/Archives/Public/w3c-sgml-wg/1996Nov/0058.html I just happen to be redoing a site for someone that was involved with this as far back as '92, http://markgroen.com/sagebrush/archives/index.htm but the history actually starts about 1986 and earlier if you include it's development: http://www.sgmlsource.com/history/roots.htm I haven't read the patent application myself, but suspect they are actually just trying to patent a certain process they are doing with their Word/Office documents, actually using xml or sgml is like using javascript in that anyone can write code for it. On the other hand, we are talking about M$ here eh, so I could be completely wrong. hth! cheers, Mark MG Web Services Web Site Hosting and Development www.markgroen.com [EMAIL PROTECTED] 604-780-6917 Bowen Island, Canada 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: MySql front won't select - 2nd time
Rudy, SELECT*FROM test WHERE 1=orange; (after much sweat) this appears to be acceptable syntax. hey, did you not like my poem? Just shows what MySql does to one - can you refresh my memory on this. i suspect you want the 1 to refer to the first column you can do this only in the ORDER BY clause in the WHERE, each item is interpreted as a literal or column you have two literals there, a numeric 1 and a string orange there's no way in hell that 1 will ever equal orange what are the two column names in your table? Would you believe I sent this at 13.54 and it only returned to me (and presumably reached the list) at 19.18.After a lot of swearing and making dents in the desk with my head in the intervening hours it occurred to me that numbers (oops, integers) might not be a good idea for column headings. The program picks up some things are wrong - though it give no answers - but this it didn't challenge; just didn't do anything with it. So you are spot on, I changed 1,2 to one,twop (nobody says I'm a good typist) and it worked. I have also been fooled by the difficulty in getting MySql Front to show things have happened. The refresh button does not always do it on one click. DB Manager is only a little better. So I have now made a giant leap for me, and a very tiny step for mankind. (which could still be better than the Mars probe) Thanks Rudy, Joseph 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%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: Home network Public address.
- Original Message - Sent: January 22, 2004 4:59 PM Subject: [wdvltalk] Home network Public address. .. my IP address by ipconfig, it 192.168.2.102 without public address. That's the address assigned for your computer/router, if not correct check the documentation. If you can connect to your web server, Cheryl's idea sounds best as routers are tricky things if you don't know what you are doing and it will only take seconds for sniffers out on the net to know you are open and exploit you and then you will be sad. There's lots of ways to get your ip address the other way around, put a link on your desktop to www.ipchicken.com is one way. Then phone your friend and tell him what it is along with the password to your router (you did read the part about changing the default password on your router right?). Simply zipping up the files with a password and ftp'ing is fast, and he/she will then be able to get the files whenever they want them without worrying about whether or not you're up and running and that gives you time to read your router documentation a bit more. hth... cheers, Mark 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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] Re: MySql front won't select - 2nd time
hey, did you not like my poem? Just shows what MySql does to one - can you refresh my memory on this. soiteny ;o) SELECT * FROM test WHERE 1 = orange; joseph i can see what you were trying to do if it had worked it would have been something new of course the number 1 will never equal the string orange you have to use a column name and everything will be, um, cool ;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] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.