[thelist] javascript mailto link in IE
Kathy Long
kathy at site-etc.com
Tue Apr 30 17:23:01 CDT 2002
I put this link on a page:
javascript:location='mailto:?SUBJECT=This may interest
you&BODY='+escape(location.href)
and I tried:
javascript:location.href='mailto:?SUBJECT=This may interest
you&BODY='+escape(location.href)
but the problem is in IE on a PC which opens the mail program just fine but
opens a blank page in the browser with that link printed to the page. Works
fine on a Mac and on both platforms in IE and Netscape.
Anyone know how to work around this in IE on a PC so it stays on the same
page when you press that link?
Kathy
> From: thelist-request at lists.evolt.org
> Reply-To: thelist at lists.evolt.org
> Date: Fri, 26 Apr 2002 18:48:46 -0500 (CDT)
> To: thelist at lists.evolt.org
> Subject: thelist digest, Vol 1 #2253 - 39 msgs
>
> Send thelist mailing list submissions to
> thelist at lists.evolt.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.evolt.org/mailman/listinfo/thelist
>
> You can reach the person managing the list at
> thelist-admin at lists.evolt.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of thelist digest..."
>
>
> Today's Topics:
>
> 1. RE: site check (Jay Blanchard)
> 2. RE: site check (Micah Freedman)
> 3. RE: Duplicate Records in SQL (Scott Dexter)
> 4. Re: site check (NanHarbisonSmith at aol.com)
> 5. Re: site check (Samir M. Nassar)
> 6. Site Check-Car site (Robin Wilkes)
> 7. Re: site check (Susan Wallace)
> 8. CSS: fix it to browser top/bottom? (Erika Meyer)
> 9. Re: site check (sasha)
> 10. Re: CSS: fix it to browser top/bottom? (Mark Gallagher)
> 11. Re: CSS: fix it to browser top/bottom? (aardvark)
> 12. RE: CSS: fix it to browser top/bottom? (.jeff)
> 13. RE: CSS: fix it to browser top/bottom? (Erika Meyer)
> 14. Re: CSS: fix it to browser top/bottom? (Martin)
> 15. Re: Textarea Javascript (Andrew Clover)
> 16. Re: site check (Richard Bennett)
> 17. Re: Flash Shopping Cart (John Dowdell)
> 18. Re: REFC Delimiter (Andrew Clover)
> 19. Re: Brain fart html w/asp (revisited) (Andrew Clover)
> 20. Re: CSS: fix it to browser top/bottom? (Andrew Clover)
> 21. ASP:: Personal Info > Write to Text or Email off? (kevin D. white)
> 22. RE: ASP:: Personal Info > Write to Text or Email off? (Chris W. Parker)
> 23. Re: ASP:: Personal Info > Write to Text or Email off? (kevin D. white)
> 24. RE: ASP:: Personal Info > Write to Text or Email off? (Luther, Ron)
> 25. Re: higher-gen db's... sigh (Techwatcher)
> 26. Re: site check (lon.kraemer)
> 27. Re: site check (James Aylard)
> 28. site check ({ schaapy })
> 29. Re: site check (Chris George)
> 30. PHP/MySQL dates, times and autoincrements (John Corry)
> 31. RE: PHP/MySQL dates, times and autoincrements (Chris W. Parker)
> 32. counting returned rows in mySQL (Benjamin)
> 33. Re: PHP/MySQL dates, times and autoincrements (David Kutcher)
> 34. Re: counting returned rows in mySQL (David Kutcher)
> 35. Re: ASP:: Personal Info > Write to Text or Email off? (Warden, Matt)
> 36. Re: site check (lon.kraemer)
> 37. Multiple CSS Classes (David Bindel)
> 38. Re: Multiple CSS Classes (sasha)
> 39. Re: Multiple CSS Classes (James Aylard)
>
> --__--__--
>
> Message: 1
> From: "Jay Blanchard" <jay.blanchard at niicommunications.com>
> To: <thelist at lists.evolt.org>
> Subject: RE: [thelist] site check
> Date: Fri, 26 Apr 2002 12:02:42 -0500
> Reply-To: thelist at lists.evolt.org
>
> [snip]
> Could I get a quick site check at http://www.20car.com
>
> I already know about the 640x480 issues
>
> -sigh-
> Looking at navigation issues primarly
> can you get there and does it make any sense?
> colors? yep we are outside the websafe palette
> text size on macs
> any other oddball issues..
> [/snip]
>
> Other than the not so obvious link back to the home page it looked and acted
> fine, WinXP, IE6 and Linux, NN4.7
>
> JB
>
>
>
> --__--__--
>
> Message: 2
> From: "Micah Freedman" <micahf at earthlink.net>
> To: <thelist at lists.evolt.org>
> Subject: RE: [thelist] site check
> Date: Fri, 26 Apr 2002 13:09:34 -0400
> Reply-To: thelist at lists.evolt.org
>
>
>> Could I get a quick site check at http://www.20car.com
>
> It seems to work fine, but I find it a bit chart-junky. All those
> boxes and rules are noisy and distracting. I don't know where to
> look. The right-hand nav looks more like the kind of content one
> ignores on news sites than navigation.
>
> Functionally, it seems fine (in IE55/win2k), but visually it's
> busy.
>
> IMO, of course.
>
> M
>
>
> --__--__--
>
> Message: 3
> Subject: RE: [thelist] Duplicate Records in SQL
> Date: Fri, 26 Apr 2002 12:15:26 -0500
> From: "Scott Dexter" <sgd at ti3.com>
> To: <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
>
> try using a "Having count(name)>1" in your statment:
>
> SELECT ID
> FROM tblFOO
> group by ID
> having count(name)>1
>
> sgd
>
>> -----Original Message-----
>> From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
>>
>> I have a table where I want to find duplicate records, and
>> eliminate them
>>
>>
>> SELECT Name, Category, Date
>> FROM tblFOO
>> WHERE Name = Name
>> AND Category = Category
>> AND LastDate = LastDate
>>
>
> --__--__--
>
> Message: 4
> From: NanHarbisonSmith at aol.com
> Date: Fri, 26 Apr 2002 13:15:48 EDT
> Subject: Re: [thelist] site check
> To: thelist at lists.evolt.org
> Reply-To: thelist at lists.evolt.org
>
> --
> [ Picked text/plain from multipart/alternative ]
> The navigation bar on every page is pretty far down the page for people to be
> able to use conveniently, don't you think?
>
> Nan
>
> Could I get a quick site check at http://www.20car.com
>
>>
>> I already know about the 640x480 issues
>>
>> -sigh-
>> Looking at navigation issues primarly
>> can you get there and does it make any sense?
>> colors? yep we are outside the websafe palette
>> text size on macs
>> any other oddball issues..
>> [/snip]
>
>
> Nan Harbison Smith
> 481 Elm Street
> Concord, MA 01742
> 978-369-1224
> 978-369-1681
>
> Give a man a fish and you feed him for a day; teach him
> to use the Internet and he won't bother you for weeks.
>
>
>
> --__--__--
>
> Message: 5
> Subject: Re: [thelist] site check
> From: "Samir M. Nassar" <nassarsa at redconcepts.net>
> To: !Evolt <thelist at lists.evolt.org>
> Date: 26 Apr 2002 12:42:23 -0500
> Reply-To: thelist at lists.evolt.org
>
> The text on the website, especially the links, is incredibly small. I
> can barely read it.
>
> Resolution: 1280 * 1024
> Browser: Opera 6
> OS: Linux
>
> Samir M. Nassar
> RedConcepts.NET - Open Source, Public Service
> http://www.redconcepts.net
>
>
> --__--__--
>
> Message: 6
> From: Robin Wilkes <rwilkes at csudh.edu>
> To: "'thelist at lists.evolt.org'" <thelist at lists.evolt.org>
> Date: Fri, 26 Apr 2002 10:26:57 -0700
> Subject: [thelist] Site Check-Car site
> Reply-To: thelist at lists.evolt.org
>
>
> The res. problem doesn't seem to me to be a big issue. You have enough white
> space to reduce the size of your pages to show up at 800/600 without bottom
> scroll bar. I do my designing at 800/600 as I've seen a lot of data that
> most people use this resolution. Also, if someone sees your page at a higher
> res., scroll bars will not be an issue-I doubt if very few people are using
> a lower res. anymore.
>
> As for navigation and color the site seems to work fine and looks decent
> (possibly too many colors though). The balance is good. In the navigation
> area, I didn't spend too much time surfing your site so there may be
> problems I didn't catch.
>
> Good site for what it is.
>
> Robin Wilkes
> Web Developer and Webmaster
> California State University Dominguez Hills
> Carson, CA
>
>
> --__--__--
>
> Message: 7
> Date: Fri, 26 Apr 2002 12:37:08 -0500
> To: thelist at lists.evolt.org
> From: Susan Wallace <susanhw at webcastle.com>
> Subject: Re: [thelist] site check
> Reply-To: thelist at lists.evolt.org
>
> It seems to function properly, I think it's a bit confusing as far as
> navigation, and the background bleeding into the tables with the details is
> distracting. The text size is all the same, even though you have the links
> in blue, it all blends together to me.
>
> One thought was to change the wording on your headers. You have:
>
> Our Latest Drivers- The Drivers List
>
> Our Latest Builders - The Builders List
>
> etc.
>
> Why not shorten them to one word titles, and then make them stand out a bit
> more - maybe increase the size of the text
>
> So you would have
>
> DRIVERS
>
> BUILDERS
>
> -- something that indicates "Oh, I'm a builder, this is for me".
>
> I would take the Parts and Cars boxes that are on the right and somehow
> incorporate them into the center of the page, thus moving the General links
> and phone contact information up "above the fold".
>
> Just my $.02
> :)
>
> Susan
>
>
> At 11:51 AM 4/26/02, you wrote:
>> Could I get a quick site check at http://www.20car.com
>>
>> I already know about the 640x480 issues
>>
>> -sigh-
>> Looking at navigation issues primarly
>> can you get there and does it make any sense?
>> colors? yep we are outside the websafe palette
>> text size on macs
>> any other oddball issues..
>>
>> TIA
>>
>>
>> the head lemur
>> News: http://www.lemurzone.com/news/
>> Interviews: http://www.lemurzone.com/pixelview/
>> Standards: http://webstandards.org
>> Community: http://www.evolt.org
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>
>
> --__--__--
>
> Message: 8
> Date: Fri, 26 Apr 2002 10:41:04 -0700
> To: thelist at lists.evolt.org
> From: Erika Meyer <emeyer at lclark.edu>
> Subject: [thelist] CSS: fix it to browser top/bottom?
> Reply-To: thelist at lists.evolt.org
>
> I haven't been at the edge in so long, I think I done lost sight of it...
>
> Anyone tried to fix a menu to the top (or bottom) of a browser? I
> was thinking about trying to slap some breadcrumbs at the top or
> bottom of this site, and I was wondering if it's worth a try or...
>
> not.
>
> What would you do,
> if your mother asked you?
>
> Erika
> --
>
> ~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> Erika Meyer
> Web Communications Consultant
> Lewis & Clark College
> Portland, Oregon USA
> Phone: 503-768-7972
> http://www.lclark.edu/~emeyer/
> ~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>
>
> --__--__--
>
> Message: 9
> From: sasha <sasha at bittersweet2.com>
> To: thelist at lists.evolt.org
> Date: Fri, 26 Apr 2002 14:00:43 -0400
> Subject: Re: [thelist] site check
> Reply-To: thelist at lists.evolt.org
>
> This will probably sound mean, but it certainly isn't
> intended that way.
>
> You seriously need to ditch the background image. It
> totally detracts from the site. It would look 100%
> better if it was just a plain background.
>
> There is no solid color theme. Bronze, pale gold,
> putty, pale blue... and cyan?? Each of the interior
> pages have a different color scheme, which is only
> confusing to the user. Have I moved to a different
> site?
>
> The layout is good. Navigation? Not so good. So many
> links! You have links named inconsistantly. On the
> side, it is "Our Parts Specials", but at the bottom, it
> is "Specials", in the content (middle front page), you
> have "Our Latest Specials - The Specials List".
>
> Overall: too cluttered and noisy.
>
> Christy "sasha" Siepker
> http://www.bittersweet2.com
>
> 4/26/2002 12:51:06 PM, "the head lemur"
> <headlemur at clearskymail.com> wrote:
>
>> Could I get a quick site check at http://www.20car.com
>>
>> I already know about the 640x480 issues
>>
>> -sigh-
>> Looking at navigation issues primarly
>> can you get there and does it make any sense?
>> colors? yep we are outside the websafe palette
>> text size on macs
>> any other oddball issues..
>>
>> TIA
>>
>>
>> the head lemur
>> News: http://www.lemurzone.com/news/
>> Interviews: http://www.lemurzone.com/pixelview/
>> Standards: http://webstandards.org
>> Community: http://www.evolt.org
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>>
>
>
>
>
> --__--__--
>
> Message: 10
> Date: Sat, 27 Apr 2002 04:08:09 +1000
> From: Mark Gallagher <mark at cyberfuddle.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] CSS: fix it to browser top/bottom?
> Reply-To: thelist at lists.evolt.org
>
> Erika Meyer wrote:
>> I haven't been at the edge in so long, I think I done lost sight of it...
>>
>> Anyone tried to fix a menu to the top (or bottom) of a browser? I
>> was thinking about trying to slap some breadcrumbs at the top or
>> bottom of this site, and I was wondering if it's worth a try or...
>>
>> not.
>
> It's not. However, it's done thusly:
>
> #menu {
> position: fixed;
> top: 0em;
> right: 0em;
> left: 0em;
> height: 2em;
> }
>
> This will work in Mozilla. It'll probably work in Opera. It won't work
> in IE.
>
>
> --
> Mark Gallagher
>
>
>
> --__--__--
>
> Message: 11
> From: "aardvark" <roselli at earthlink.net>
> To: thelist at lists.evolt.org
> Date: Fri, 26 Apr 2002 14:14:39 -0400
> Subject: Re: [thelist] CSS: fix it to browser top/bottom?
> Reply-To: thelist at lists.evolt.org
>
>> From: Erika Meyer <emeyer at lclark.edu>
> [...]
>> Anyone tried to fix a menu to the top (or bottom) of a browser? I was
>> thinking about trying to slap some breadcrumbs at the top or bottom of
>> this site, and I was wondering if it's worth a try or...
>>
>> not.
>
> anchoring it regardless of scroll? or just stuff it there regardless of
> scroll...
>
> the top of the page for either is easy...
>
> the bottom... welll... there's been a discussion raging on CSS-D for
> a few days now... there is no resolution as of yet, but i'm waiting...
>
>> What would you do,
>> if your mother asked you?
>
> i'd tell her it was yours and i'd never seen it before...
>
>
> --__--__--
>
> Message: 12
> From: ".jeff" <jeff at members.evolt.org>
> To: <thelist at lists.evolt.org>
> Subject: RE: [thelist] CSS: fix it to browser top/bottom?
> Date: Fri, 26 Apr 2002 11:45:00 -0700
> Reply-To: thelist at lists.evolt.org
>
> erika,
>
>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>> From: Erika Meyer
>>
>> Anyone tried to fix a menu to the top (or bottom) of a
>> browser? I was thinking about trying to slap some
>> breadcrumbs at the top or bottom of this site, and I
>> was wondering if it's worth a try or...
>>
>> not.
>> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>
> you mean like this?
>
> http://documents.pape.com/
>
> this only works in ie5.5+/win though. everyone else just gets a regular
> top/bottom of the page treatment. i probably would have tried to support
> more browsers, but the client indicated that the entire audience (it's very
> small and definable) was win/ie5.5+ so i didn't concern myself.
>
> erik mattheis was working on something similar that supposedly works in more
> browsers. erik? got a live, working sample?
>
> ..jeff
>
> http://evolt.org/
> jeff at members.evolt.org
> http://members.evolt.org/jeff/
>
>
>
> --__--__--
>
> Message: 13
> Date: Fri, 26 Apr 2002 12:11:53 -0700
> To: thelist at lists.evolt.org
> From: Erika Meyer <emeyer at lclark.edu>
> Subject: RE: [thelist] CSS: fix it to browser top/bottom?
> Reply-To: thelist at lists.evolt.org
>
> aardvark said:
>> i'd tell her it was yours and i'd never seen it before...
>
> Thank you, thank you,
> thing 1 and thing 2....
>
> The idea is (was) to anchor a menu to the browser window so it will
> always be there as if it were in a frameset. So I think that would
> be "anchoring it" (as opposed to "just stuff it there").
>
> I think I've gotten over it, now.
> Though it would appear to be a handy thing to be able to do.
>
> I've often wished I could...
> and at times wondered if I should...
>
> CSS-D?
> maybe that's where I should be.
>
> - E
> --
> aardvark said:
>> anchoring it regardless of scroll? or just stuff it there regardless of
>> scroll...
>
>
> --__--__--
>
> Message: 14
> Date: Fri, 26 Apr 2002 20:17:15 +0100
> Subject: Re: [thelist] CSS: fix it to browser top/bottom?
> From: Martin <martin at members.evolt.org>
> To: thelist at lists.evolt.org
> Reply-To: thelist at lists.evolt.org
>
>
> On Friday, April 26, 2002, at 08:11 pm, Erika Meyer wrote:
>
>> CSS-D?
>> maybe that's where I should be.
>
> Could get confusing between you & Eric...
>
> Cheers
> Martin
> _______________________________________________
> email: martin at easyweb.co.uk PGP ID: 0xA835CCCB
> martin at members.evolt.org snailmail: 30 Shandon Place
> tel: +44 (0)774 063 9985 Edinburgh,
> url: http://www.easyweb.co.uk Scotland
>
>
> --__--__--
>
> Message: 15
> Date: Fri, 26 Apr 2002 19:58:50 +0000
> From: Andrew Clover <and at doxdesk.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Textarea Javascript
> Reply-To: thelist at lists.evolt.org
>
> Josh S Feingold <Josh.S.Feingold at irs.gov> wrote:
>
>> I noticed that this:
>
>> textarea = document.form.textarea.value
>
>> does not work
>
> No. If you have an form element with name 'textarea', many browsers will
> put it in global scope for you. This means you can write a shortcut like:
>
> t= textarea.value;
>
> This is one of the many idiotic features which was added to JavaScript to
> make it "easier" for new coders, but actually has the effect of making the
> language far more confusing for everybody. In your line above, you're
> reading the value of the textarea, and then assigning it to the object
> in global scope with the name 'textarea' - which is the form field object
> you just read from. Since you can't assign directly to a form field object,
> an error is caused.
>
> Declare all your new variables with 'var', so it knows you're talking about
> a variable and not some other nonsense the browser has "helpfully" decided
> to shove into global scope for you.
>
> And it generally helps to avoid shortcuts. eg.:
>
> var t= document.forms['form'].elements['textarea'].value;
>
> is best. But you'll still be screwed by JavaScript's namespace tomfoolery
> if, for example, you have an input with name="elements".
>
> JS is really really poorly designed.
>
> --
> Andrew Clover
> mailto:and at doxdesk.com
> http://and.doxdesk.com/
>
> --__--__--
>
> Message: 16
> From: "Richard Bennett" <richard.bennett at skynet.be>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] site check
> Date: Fri, 26 Apr 2002 15:04:24 -0500
> Reply-To: thelist at lists.evolt.org
>
> Hi,
> I agree with other's comments about colors, boxes, and inconsistency.
> I'd like to add:
> * Why do ...Drivers... and ...Builders... have dots, and the other links
> not?
> * If you set your font-size using % in the CSS instead of pt or px, then IE
> users can set the text-size to be readable on their browser/screen-res,
> using [Ctrl]+mousewheel, and Mac and Linux users will also be able to read
> the text better.
> * You might want to replace the long "AOL USERS:" text with a link, "AOL
> users click here" linking to the explanation.
> Currently it gives the impression that there is something wrong with this
> site. Especially as it's repeated throughout the site.
> * Sometimes Clicking on Location or Sales Policy pops up the whole website
> in a new window again.
>
> The site works well for checking out a car, navigating the photos is easy.
> Getting back to the start-page is less clear, as the company logo looks a
> little like an advertising banner, so it isn't clear if it will take you to
> some other site, or to the beginning.
>
> Cheers,
> Richard.
>
>
>
> ----- Original Message -----
> From: "the head lemur" <headlemur at clearskymail.com>
>
>
> Could I get a quick site check at http://www.20car.com
>
>
>
> --__--__--
>
> Message: 17
> Date: Fri, 26 Apr 2002 13:04:37 -0700
> To: thelist at lists.evolt.org
> From: jdowdell at macromedia.com (John Dowdell)
> Subject: Re: [thelist] Flash Shopping Cart
> Reply-To: thelist at lists.evolt.org
>
> At 8:25 PM 4/25/2, Janet FitzGerald wrote:
>> [snip]
>> Ok, here's my question: How is the .txt file created, and how do I make
>> the main shoppingcart.swf call the instances in the other fruit movies?
>> I can't find anything in the actionscript that specifically calls for
>> these movies so that I can exchange the fruit for the art glass that I
>> want to use. I'm totally missing something here.
>
> I'm not sure what the question about Flash is, sorry.
>
> Like Sasha I'm guessing this might be something like "How can I dynamically
> change images in Flash?" and loading a new sub-movie into the file is
> indeed a common way.
>
> In a later post there was another description of something which didn't do
> what you wanted, and I think this might be "How can I format numbers as
> currency in Flash?", for which there's a technote searchable under term
> "currency".
>
> But I might be guessing the wrong questions about shareable experience,
> from those descriptions of private experience...?
>
> jd
>
>
>
>
>
>
>
> --__--__--
>
> Message: 18
> Date: Fri, 26 Apr 2002 20:16:00 +0000
> From: Andrew Clover <and at doxdesk.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] REFC Delimiter
> Reply-To: thelist at lists.evolt.org
>
> Eric D Means <eric.d.means at boeing.com> wrote:
>
>> You would have to get PHP to rewrite URLs with escaped ampersands in order
>> for URL rewriting to validate, which is what he's asking about.
>
> This is PHP bug 14653, about which yohgaki at php.net says:
>
> Of course we know the default is not correct.
> We just use legacy one for compatibility.
>
> Of course this makes no sense, since the only browsers that don't decode
> & to & before use are ancient and decrepit. Contrary to the claim in
> that bug report, Netscape 3 *does* understand it properly.
>
> And in any case, any standards-compliant url-decoder would read an
> incorrectly submitted query string, eg.
>
> blah.php?foo=1&bar=2
>
> as the two intended parameters 'foo' and 'bar', and one malformed
> parameter 'amp' which can be ignored. So changing the default to '&'
> would solve the problem (which is worse than just validation - look what
> happens if one of your parameters is called 'sect' or any other valid
> entity name now or in the future), and it would hurt nobody.
>
> It would be easiest just to use ';' instead though. HTML says this can
> be used as a seperator instead of an ampersand, and PHP already supports
> that.
>
> You can fix this yourself if you have access to the php.ini. Change the line:
>
> arg_separator.output = "&"
>
> to:
>
> arg_separator.output = ";"
>
> --
> Andrew Clover
> mailto:and at doxdesk.com
> http://and.doxdesk.com/
>
> --__--__--
>
> Message: 19
> Date: Fri, 26 Apr 2002 20:50:14 +0000
> From: Andrew Clover <and at doxdesk.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Brain fart html w/asp (revisited)
> Reply-To: thelist at lists.evolt.org
>
> Chris W. Parker <cparker at swatgear.com> wrote:
>
>> what you can do instead of have two forms, or a nested form
>> (which i don't think works?)
>
> (no, it doesn't.)
>
>> for example you will have one form but allow the user to either
>> "save Article" or "Submit for Review" their article.
>
> You can't have a form with two different destinations. There's
> two approaches to this, the client-side way and the server-side
> way.
>
> The client-side way consists of using JavaScript to change the
> destination of the form before it is submitted:
>
> <form method="post" action="submit.asp"><div>
> <input type="radio" name="action" value="save"
> onclick="this.form.action= 'save.asp';" /> Save
> <input type="radio" name="action" value="submit" checked
> onclick="this.form.action= 'submit.asp';" /> Submit
> </div></form>
>
> The obvious drawback of this technique is that it won't work if
> client-side-scripting is unsupported or disabled.
>
> The server-side way is generally better:
>
> <form method="post" action="submitorsave.asp"><div>
> <input type="radio" name="action" value="save" /> Save
> <input type="radio" name="action" value="submit" checked /> Submit
> </div></form>
>
> (or, probably better to use two buttons:)
>
> <form method="post" action="submitorsave.asp"><div>
> <input type="submit" name="action" value="Save" />
> <input type="submit" name="action" value="Submit" />
> </div></form>
>
> Then the submitorsave.asp script has to look at the submitted
> 'action' value to see what exactly to do.
>
> This may be quite tricky if the actions for different buttons on
> the form have to do very different things. In this case it is
> better to use shared functions, so the script just calls whichever
> one is necessary for the action. Exactly how you declare a function
> to be shared across scripts depends on what language and framework
> you are using. I believe the idiom for ASP+VBScript is to use
> includes. This is awful but then so is most of the rest of VBScript
> so at least it's a good fit. ;-)
>
> But I would imagine the 'save' and 'submit' actions would be similar
> enough that it would make sense to put them in the same script
> anyway.
>
> --
> Andrew Clover
> mailto:and at doxdesk.com
> http://and.doxdesk.com/
>
> --__--__--
>
> Message: 20
> Date: Fri, 26 Apr 2002 20:55:04 +0000
> From: Andrew Clover <and at doxdesk.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] CSS: fix it to browser top/bottom?
> Reply-To: thelist at lists.evolt.org
>
> Mark Gallagher <mark at cyberfuddle.com> wrote:
>
>> position: fixed;
>
>> This will work in Mozilla. It'll probably work in Opera. It won't work
>> in IE.
>
> It will work in IE5/Mac, but any hovering effects won't work there (so
> avoid DHTML onmouseover-reliant menus).
>
> To get it to work on IE/Win, see:
>
> http://and.doxdesk.com/software/js/fixed.html
>
> --
> Andrew Clover
> mailto:and at doxdesk.com
> http://and.doxdesk.com/
>
> --__--__--
>
> Message: 21
> From: "kevin D. white" <simplecypher at bitshift.ws>
> To: <thelist at lists.evolt.org>
> Date: Fri, 26 Apr 2002 15:04:12 -0600
> Subject: [thelist] ASP:: Personal Info > Write to Text or Email off?
> Reply-To: thelist at lists.evolt.org
>
> -----BEGIN PGP SIGNED MESSAGE-----
>
> I have a client who is in a bind and in turn is putting me in a bind....
>
> The client's IT department absolutely, categorically, under pain of death
> refuses to allow the Web server to access a database of any kind. Doesn't
> matter what type of database or if the database is local on the box or
> remote. No database, period, period.
>
> Here's the problem:
>
> I have a form that collects personally identifiable information (Name,
> email address, phone number). I Really want to store that data in a
> remote, secure database. Since I can't do that, my client wants me to
> store that personal data on a SINGLE TEXT FILE on the server. I am
> lobbying very hard to just email that stuff off right to client.
>
> I worried about the following:
> 1. File locking - The site is in ASP 3.0 on Win2K
> 2. Security - The file is plain-text
>
> Am I crazy? Am I paranoid?
>
> Did I mention this client's box has already been hacked once before?
>
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQIVAwUBPMnAw+4zpFgPJZelAQGiHRAAwVHTGNUCPsCziaX+ytFa4i3+D8cyPOmS
> jGsYTZt0px0CNj+QlK3zgf/FPbhYjJRdjuGPFAb84yvoNTpi/xhclpbdaNhzhPrH
> gIXni6SUPaTIxsIOp8aOOtw7Hjzm0l5OtpqcKIraZK7sgLAszR2KTc6MK+VIbIM3
> 9asshFPn5JjPT2qekjADhDLk/CijaDaxFmkRVCxXZYB76kBfdYyjvtKRRrCfRnsi
> ZYH03bYx7EmLH9mJ/nszGstgrdzsFFJmfJfkVuv7SuS8ek72aKqUSIZ8FBuJjrC7
> 2vTyMOnBINMr5R3zbfN8uHNDDcSiqB39U30hBzAbeQhHc2E33gdrdeJkMXo7lnNY
> KlhnBNTbUmUDKvzweTrvn1dp4rge9t5mKCTCxtiVU8ViNZ/aYnbdjgGzbWFYAyxz
> YIm304MfEV4hY+OrY26o/FRX6MsLZ4yiZzOTldk6c2Kff/h8YDIsuzFobyxX4+iX
> k853xpFONeadotG7E4NX1Tnt8BoCAzHZGSP77m/6qIzxAkYF0Ab0w2bDHWfYMVZV
> awV2jmhkk++FDw5lCjfJ3hIy/GuCL7TzTpdpLogAe/eYy5Zr8mzlTy31t8gpv8Vi
> 0Co2QDfr/A8eAh1j+WVAbyMZdgjsUjJkmSjMatNEu6Kuli/qvuzqcvClNVm9l/Rk
> 2E8MAGCpSt4=
> =LXq1
> -----END PGP SIGNATURE-----
>
>
>
> --__--__--
>
> Message: 22
> Subject: RE: [thelist] ASP:: Personal Info > Write to Text or Email off?
> Date: Fri, 26 Apr 2002 14:19:23 -0700
> From: "Chris W. Parker" <cparker at swatgear.com>
> To: <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
>
> kevin,
>
> someone please tell me if this is offtopic or not...
>
> ----
>
> what's the difference between storing a plain-text text file on a server
> rather than a database? that seems pretty lame of them to insist that
> there be no database but a text file is ok. dumb.
>
> i'd vote for email off.
>
> chris.
>
>
>> -----Original Message-----
>> From: kevin D. white [mailto:simplecypher at bitshift.ws]
>> Sent: Friday, April 26, 2002 2:04 PM
>> To: thelist at lists.evolt.org
>> Subject: [thelist] ASP:: Personal Info > Write to Text or Email off?
>>
>>
>> -----BEGIN PGP SIGNED MESSAGE-----
>>
>> I have a client who is in a bind and in turn is putting me in
>> a bind....
>>
>> The client's IT department absolutely, categorically, under
>> pain of death
>> refuses to allow the Web server to access a database of any
>> kind. Doesn't
>> matter what type of database or if the database is local on the box or
>> remote. No database, period, period.
>>
>> Here's the problem:
>>
>> I have a form that collects personally identifiable information (Name,
>> email address, phone number). I Really want to store that data in a
>> remote, secure database. Since I can't do that, my client wants me to
>> store that personal data on a SINGLE TEXT FILE on the server. I am
>> lobbying very hard to just email that stuff off right to client.
>>
>> I worried about the following:
>> 1. File locking - The site is in ASP 3.0 on Win2K
>> 2. Security - The file is plain-text
>>
>> Am I crazy? Am I paranoid?
>>
>> Did I mention this client's box has already been hacked once before?
>>
>>
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>>
>> iQIVAwUBPMnAw+4zpFgPJZelAQGiHRAAwVHTGNUCPsCziaX+ytFa4i3+D8cyPOmS
>> jGsYTZt0px0CNj+QlK3zgf/FPbhYjJRdjuGPFAb84yvoNTpi/xhclpbdaNhzhPrH
>> gIXni6SUPaTIxsIOp8aOOtw7Hjzm0l5OtpqcKIraZK7sgLAszR2KTc6MK+VIbIM3
>> 9asshFPn5JjPT2qekjADhDLk/CijaDaxFmkRVCxXZYB76kBfdYyjvtKRRrCfRnsi
>> ZYH03bYx7EmLH9mJ/nszGstgrdzsFFJmfJfkVuv7SuS8ek72aKqUSIZ8FBuJjrC7
>> 2vTyMOnBINMr5R3zbfN8uHNDDcSiqB39U30hBzAbeQhHc2E33gdrdeJkMXo7lnNY
>> KlhnBNTbUmUDKvzweTrvn1dp4rge9t5mKCTCxtiVU8ViNZ/aYnbdjgGzbWFYAyxz
>> YIm304MfEV4hY+OrY26o/FRX6MsLZ4yiZzOTldk6c2Kff/h8YDIsuzFobyxX4+iX
>> k853xpFONeadotG7E4NX1Tnt8BoCAzHZGSP77m/6qIzxAkYF0Ab0w2bDHWfYMVZV
>> awV2jmhkk++FDw5lCjfJ3hIy/GuCL7TzTpdpLogAe/eYy5Zr8mzlTy31t8gpv8Vi
>> 0Co2QDfr/A8eAh1j+WVAbyMZdgjsUjJkmSjMatNEu6Kuli/qvuzqcvClNVm9l/Rk
>> 2E8MAGCpSt4=
>> =LXq1
>> -----END PGP SIGNATURE-----
>>
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>>
>
> --__--__--
>
> Message: 23
> From: "kevin D. white" <simplecypher at bitshift.ws>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] ASP:: Personal Info > Write to Text or Email off?
> Date: Fri, 26 Apr 2002 15:40:57 -0600
> Reply-To: thelist at lists.evolt.org
>
> -----BEGIN PGP SIGNED MESSAGE-----
>
> Quite agree. But "rules are rules." The company is big (Fortune 100) and
> the client certainly does not have the clout to change their IT policies.
> I don't even think their IT department knows about the text-file
> suggestion. I'm positive this is my client's way of getting the data,
> by-passing the IT department, and avoiding thousands of emails a day. The
> form is really, really high-traffic. Which also makes me worry about the
> file constantly being locked for writing.
>
> Email certainly isn't very secure but it just has to be a better idea than
> storing thousands of name-email-phone combinations in a text-file.
>
> Right?
>
> Right?
>
>
> - ----- Original Message -----
> From: "Chris W. Parker" <cparker at swatgear.com>
> :
> : what's the difference between storing a plain-text text file on a server
> : rather than a database? that seems pretty lame of them to insist that
> : there be no database but a text file is ok. dumb.
> :
> : i'd vote for email off.
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQIVAwUBPMnJXe4zpFgPJZelAQFLdBAAnOeaj8W/HQc9fuof8W8KjbDzZa51nZZ7
> 7E9QbjwFwhInKaIsCIzeXdTzLJqQGIkCt45Bi1sI8oRGxd59HWEQMiRIWSHbLgUp
> 83+JL+rZ6e6rwC0pGtLBKpIIkSojdjxXNUusVYXyTMtO+I6bsyH3g3X2TI14Pc0C
> LSzQLmRODeui88bcIcAZWJdrEMgNYxBkbw7vSpYEGJSq2Gftyp/hDr44jUWwt3AW
> DTY66ELydFVEcorUCtpdWuFrskfbTGsWQgFN9gncYebEiJyjM5Kp25k5xYUc3LjS
> hRmjXMqRjfY8kGof98NkKOizhGT1VCRkwy4em1mcGwDbB3kDuf0b2gWT4+JAcjyT
> I1gucJnb0o9kv6L/rxF5UYyg1bx0MkkBNlZungKBXgwIejDJGzVb1m2TD6hOUc6w
> JMRjhTbL/YQRmU9AB+ZrXSQ/1lR+k2gUQ+nP6zkgoFVb83gzIk1g3B3ki+v3BmyE
> kpaQH4+8QaMIC1kPxapVA7095PAkhuayg9lvgB/BZs6hY2BIqzTsV25SnhLRaAr1
> cgOLBz0uR63bQ9bn/V4UHiMTaerSYSbdljZs+xvJ20nwW+twT5JpmJ//xtrTw2Te
> yVm9Dwu2tEdR/7tS87do6vWPQg3V6tOCO/A9OUoM9HXraGGxoNNhOmAml0Svm/rh
> X6FkxzJY5rg=
> =y//u
> -----END PGP SIGNATURE-----
>
>
>
> --__--__--
>
> Message: 24
> Subject: RE: [thelist] ASP:: Personal Info > Write to Text or Email off?
> Date: Fri, 26 Apr 2002 16:45:20 -0500
> From: "Luther, Ron" <Ron.Luther at COMPAQ.com>
> To: <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
>
> Hi Kevin,
>
> I think Ryan is pretty much right. If the client's IT department is not going
> to allow the Web server to access a database, they are probably not going to
> allow write access to a file on the Web server either ... and if this is being
> done without their knowledge and involvement it's probably not going to be
> pleasant for either of you.
>
> I think I'd prefer requesting a meeting involving you, the client, and IT ...
> explain the business need you are trying to meet and ask for recommendations
> on how they want you to handle that.
>
> Good Luck, sounds like a tough one!
>
> RonL.
>
> -----Original Message-----
> From: kevin D. white [mailto:simplecypher at bitshift.ws]
>
> The client's IT department absolutely, categorically, under pain of death
> refuses to allow the Web server to access a database of any kind. Doesn't
> matter what type of database or if the database is local on the box or
> remote. No database, period, period.
>
> Here's the problem:
>
> I have a form that collects personally identifiable information (Name,
> email address, phone number). I Really want to store that data in a
> remote, secure database. Since I can't do that, my client wants me to
> store that personal data on a SINGLE TEXT FILE on the server. I am
> lobbying very hard to just email that stuff off right to client.
>
>
> --__--__--
>
> Message: 25
> From: "Techwatcher" <techwatcher at accesswriters.com>
> To: thelist at lists.evolt.org
> CC: jay.blanchard at niicommunications.com
> Date: Fri, 26 Apr 2002 18:01:51 -0400
> Subject: [thelist] Re: higher-gen db's... sigh
> Reply-To: thelist at lists.evolt.org
>
> Hi, all
>
> Don't mind me, I'm just depressed at the end of a long, bad week...
>
>> From: "Jay Blanchard" <jay.blanchard at niicommunications.com>
>>
>> I have a table where I want to find duplicate records, and eliminate
> them
>>
>> tblFOO
>> ID Name Category LastDate
>> 1 Tom HR 2002-03-05
>> 2 Dick R&D 2002-03-05
>> 3 Harry Mgmt 2002-03-05
>> 4 Tom HR 2002-03-05
>> 5 Moe Mgmt 2002-03-06
>> 6 Larry BOD 2002-03-05
>> 7 Curly Support 2002-03-06
>>
>> SELECT Name, Category, Date
>> FROM tblFOO
>> WHERE Name = Name
>> AND Category = Category
>> AND LastDate = LastDate
>>
>> returns all records, because 'Name = Name' is true, as are the other
> items.
>> In the table where I am doing this I would not know any of the
> values, so I
>> cannot be more specific about criteria. The ID number for each record
> is
>> unique. This is in MySQL, so there is no UNION available. Has anybody
> done
>> this before?
>>
>> TIA!
>>
>> Jay
>
> This is the kind of problem for which APL or J (among many others) has
> literally one-line solutions. That's why I still keep them on whatever
> computer I'm currently using: to solve this sort of problem.
>
> I wonder whether dp/it/software engineering educators will eventually
> figure out that canned db programs can't do the whole job. This rant is
> also in reference to the fellow who had to use Mysql (or was it sql?)
> to draw from two "legacy" databases.
>
> Once I wrote an (online) documentation tool for Merrill Lynch traders
> (as consultant, not employee). I used APL, and it took whatever text or
> fields you wanted to give it, then allowed a free-form, English-
> language search on the resulting db. That took about 12 weeks,
> including a week or two of figuring out where I could find some soon-to-
> be data (this ops techie had been keeping notes about new software
> coming in), who the experts were (to interview), and the initial
> relevant dimensions for the software tools I was documenting.
>
> Took another week or so to work out my structure and design issues, and
> another week at the end to teach an employee programmer about the
> system, the tools I'd created to update the db at intervals (or ad hoc,
> when anyone knew new tools had been added to the system).
>
> Then the mgr said, "Oh, but we wanted it for SQL." Took another whole
> week to write a few more programs to strip the descriptions down to
> keywords, make sure the keywords weren't showing up (individually) in
> most descriptions but were (in aggregate) hitting every description...
> and present him with a much less functional SQL-compatible db. Also, of
> course, to build new front-end, and design (and print on card stock)
> the quick-ref card for users (keywords and how to input them).
>
> I know we have to have dumbed-down word processors (for the
> secretaries), but do we have to rely 100% on dumbed-down db languages
> too? Even us professionals?
>
> sigh. mope.
>
> --__--__--
>
> Message: 26
> From: "lon.kraemer" <lwkraemer at directvinternet.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] site check
> Date: Fri, 26 Apr 2002 17:05:16 -0500
> Reply-To: thelist at lists.evolt.org
>
> Hi buddy!
>
> I agree with most of what's been said up to this point, esp. too busy with
> lined boxes/deeply nested tables.
>
> Colors? _I_ know you're color-blind. We've talked about this. You might be
> better served using something like: http://www.colorschemer.com/online/ and
> trusting a selected scheme. Then follow through with more consistancy (esp.
> links) across the site. It becomes VERY difficult to determine what is/is
> not a link because of the variety of styles. Speaking of which, the majority
> of your CSS styling is declared inline. Most (if not all) of this could and
> probably should be moved to your external stylesheet.
>
> In terms of width, it's slightly too wide even for 800X (horiz. scrollbar)
> and anything less starts to obscure your right nav menu. I really think
> you'd be better off using a more traditional left side nav menu layout. One
> menu should be sufficient since you're not using images, so the bottom menu
> can go bye bye.
>
> I know you're a stickler for assessibility too. Your excessive use of
> · may bite in screenreaders as will interspersing spaces in words,
> e.g. D R I V E R S. I'd stick to standard punctuation.
>
> I'd drop the Updated 04/26/2002 13:01:19. This can work against you if it's
> too far past. Drop the redundant "Our Latest Whatever-", for the same
> reason.
>
> Since you're migrating to a new domain name, I think you need to emphasize
> the fact more. Note the old domain for regular users, reminding them to
> change their bookmark. A short explanation might be in order too. I hope
> you're retaining the old domain and redirecting?
>
> I think you should move the location/contact info/hours above the fold. As
> another listee noted, the top graphic could easily be mistaken for a banner
> ad (similar size, etc.) and leave users wondering where they are at.
>
> +1 on dropping/obsfucating the AOL thingy. A commercial site isn't the
> proper venue to be grandstanding this type of issue.
>
> --
> Lon Kraemer
> -----------------------------------------
>
>
>> Could I get a quick site check at http://www.20car.com
>>
>> I already know about the 640x480 issues
>>
>> -sigh-
>> Looking at navigation issues primarly
>> can you get there and does it make any sense?
>> colors? yep we are outside the websafe palette
>> text size on macs
>> any other oddball issues..
>>
>> TIA
>>
>>
>> the head lemur
>> News: http://www.lemurzone.com/news/
>> Interviews: http://www.lemurzone.com/pixelview/
>> Standards: http://webstandards.org
>> Community: http://www.evolt.org
>
>
>
> --__--__--
>
> Message: 27
> From: "James Aylard" <webmaster at equilon-mrc.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] site check
> Date: Fri, 26 Apr 2002 15:20:55 -0700
> Reply-To: thelist at lists.evolt.org
>
> lon and head lemur,
>
>> · may bite in screenreaders as will interspersing spaces in words,
>> e.g. D R I V E R S. I'd stick to standard punctuation.
>
> I didn't see the spacing issue on the site, so maybe lemur altered it.
> But just a reminder that you can achieve this effect in CSS without messing
> up the underlying text, thereby sparing users with screen-readers:
>
> <style type="text/css">
> .spacedOut {
> letter-spacing: .3em ;
> }
> </style>
>
> James Aylard
>
>
> --__--__--
>
> Message: 28
> From: "{ schaapy }" <list01 at theparagon.org>
> To: <thelist at lists.evolt.org>
> Date: Fri, 26 Apr 2002 18:25:21 -0400
> Subject: [thelist] site check
> Reply-To: thelist at lists.evolt.org
>
> I'm working on a newcomers page for my local paper. Right now it's up at
> http://www.hollandsentinel.com/specialsection/newcomers2002/ it's just a
> beta so the text is just random crap - don't mind that.
>
> http://www.hollandsentinel.com/specialsection/newcomers2002/newcomers.css
> <--- my css file
>
> My question(s) is:
> 1. For some reason the 6th paragraph doesn't want to be under the control of
> my "text" class. Which I put in my TD that holds all of this content. I put
> a table in there and thinking that might have caused a problem but have no
> idea why.
>
> ..text {
> color: #666;
> font-size: 10px;
> font-family: verdana, arial;
> background-color: #fff;
> }
>
> 2. Is there a way to push my whole site up in the topleft corner without
> having to use "topmargin, leftmargin, marginheight, and marginwidth"?
>
> 3. My text always gets smaller in Netscape 4.x as well. Is there a good way
> to avoid that?
>
> That should be it - comments/helpful tips are welcome on the site as a
> whole.
>
> ---------------------------
> Aaron Schaap
> www.theparagon.org
>
>
>
> --__--__--
>
> Message: 29
> Date: Fri, 26 Apr 2002 16:26:00 -0600
> Subject: Re: [thelist] site check
> From: Chris George <chrisg at gsnet.com>
> To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
>
> On 4/26/02 4:20 PM, "James Aylard" <webmaster at equilon-mrc.com> wrote:
>
> [snip]
>> a reminder that you can achieve this effect in CSS without messing
>> up the underlying text, thereby sparing users with screen-readers:
>>
>> <style type="text/css">
>> .spacedOut {
>> letter-spacing: .3em ;
>> }
>> </style>
>>
>> James Aylard
>
> I was just thinking that myself. It also won't be ignored by search engine
> spiders either...
>
> My .01 on a Friday afternoon...
>
> Chris.
>
>
> --__--__--
>
> Message: 30
> From: "John Corry" <webshot at members.evolt.org>
> To: <thelist at lists.evolt.org>
> Cc: "Rudy" <r937 at interlog.com>
> Date: Fri, 26 Apr 2002 12:26:11 -1000
> Subject: [thelist] PHP/MySQL dates, times and autoincrements
> Reply-To: thelist at lists.evolt.org
>
> I'm about 75% done with the most complex thing I've ever built and I need a
> little help to get the rest of the way there.
>
> 1) I'm working A LOT with dates and times in PHP/MySQL. PHP seems to rely on
> timestamps, but the MySQL datetime type is a string. Generally, it seems like
> I might be best off working with timestamps in my scripts, and converting to
> the MySQL datetime format when I store values in the db. Can anyone confirm
> that I'm thinking straight or clue me in to anything I might be missing?
>
> 2) In my hand rolled ordering process, a user goes through a series of forms,
> all of the values are finally displayed on a 'confirm your order' page (and
> all the values they entered are on the page as hidden form fields) with a
> submit button to 'confirm'. OK...now I have to write the script that happens
> when you confirm. This script will
> 1) create a customer in the customer table
> 2) create a recipient (of flowers) in the recipient table
> 3) create an order in the orders table
>
> Ok...I have to run the queries so that I insert the new customer and new
> resipient first, then get their ID numbers to store in the orders table. So,
> MySQL has a LAST_INSERT_ID() function. Does MySQL support using a SELECT
> statement for a value in an insert statment? (as in, 'insert into orders
> (ordCust) values (select custID from customers where custID =
> LAST_INSERT_ID())')? If not...how do I get the users id? I am using
> sessions...I guess I could store the session id in a column and match that
> way, but still I have to run the 2 insert queries (insert the customer and the
> recipient, then select the customer and recipient id's, then insert the order.
> That's 4 queries...is that OK? Is there a more streamlined way to do this?
>
> I'm in way over my head here and it is not fun :(
>
> <tip type="rhetorical">
> Bored with static web page design? Thinking of trying to build a dynamic,
> database driven site with processes and transactions and advanced user
> interaction? I reccomend taking your time, going slow, progressing in baby
> steps. Having a major deadline looming, and no idea of what you're doing...it
> sucks.
> </tip>
>
> John
>
>
> --__--__--
>
> Message: 31
> Subject: RE: [thelist] PHP/MySQL dates, times and autoincrements
> Date: Fri, 26 Apr 2002 15:37:58 -0700
> From: "Chris W. Parker" <cparker at swatgear.com>
> To: <thelist at lists.evolt.org>
> Reply-To: thelist at lists.evolt.org
>
> john,
>
> i feel your pain.
>
> chris.
>
> <tip type="Resources" author="Chris Parker">
> Can't find what you're looking for? Ever heard of Google Groups? try
> http://groups.google.com. It's a very handy place to search for answers.
> And you can be selective with where and what groups you search.
> </tip
>
>> -----Original Message-----
>> From: John Corry [mailto:webshot at members.evolt.org]
>> Sent: Friday, April 26, 2002 3:26 PM
>> To: thelist at lists.evolt.org
>> Cc: Rudy
>> Subject: [thelist] PHP/MySQL dates, times and autoincrements
>>
>>
>> I'm about 75% done with the most complex thing I've ever
>> built and I need a little help to get the rest of the way there.
>>
>> 1) I'm working A LOT with dates and times in PHP/MySQL. PHP
>> seems to rely on timestamps, but the MySQL datetime type is a
>> string. Generally, it seems like I might be best off working
>> with timestamps in my scripts, and converting to the MySQL
>> datetime format when I store values in the db. Can anyone
>> confirm that I'm thinking straight or clue me in to anything
>> I might be missing?
>>
>> 2) In my hand rolled ordering process, a user goes through a
>> series of forms, all of the values are finally displayed on a
>> 'confirm your order' page (and all the values they entered
>> are on the page as hidden form fields) with a submit button
>> to 'confirm'. OK...now I have to write the script that
>> happens when you confirm. This script will
>> 1) create a customer in the customer table
>> 2) create a recipient (of flowers) in the recipient table
>> 3) create an order in the orders table
>>
>> Ok...I have to run the queries so that I insert the new
>> customer and new resipient first, then get their ID numbers
>> to store in the orders table. So, MySQL has a
>> LAST_INSERT_ID() function. Does MySQL support using a SELECT
>> statement for a value in an insert statment? (as in, 'insert
>> into orders (ordCust) values (select custID from customers
>> where custID = LAST_INSERT_ID())')? If not...how do I get the
>> users id? I am using sessions...I guess I could store the
>> session id in a column and match that way, but still I have
>> to run the 2 insert queries (insert the customer and the
>> recipient, then select the customer and recipient id's, then
>> insert the order. That's 4 queries...is that OK? Is there a
>> more streamlined way to do this?
>>
>> I'm in way over my head here and it is not fun :(
>>
>> <tip type="rhetorical">
>> Bored with static web page design? Thinking of trying to
>> build a dynamic, database driven site with processes and
>> transactions and advanced user interaction? I reccomend
>> taking your time, going slow, progressing in baby steps.
>> Having a major deadline looming, and no idea of what you're
>> doing...it sucks.
>> </tip>
>>
>> John
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>>
>
> --__--__--
>
> Message: 32
> Date: Fri, 26 Apr 2002 18:36:42 -0400
> To: thelist at lists.evolt.org
> From: Benjamin <kalos at carolina.rr.com>
> Subject: [thelist] counting returned rows in mySQL
> Reply-To: thelist at lists.evolt.org
>
> A simple way to get the number of rows your query has returned (using Perl
> & mySQL) is to use
>
> my $count = $sth->rows;
>
> Or just
>
> print "$sth->rows";
>
>
> --__--__--
>
> Message: 33
> From: "David Kutcher" <david_kutcher at hotmail.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] PHP/MySQL dates, times and autoincrements
> Date: Fri, 26 Apr 2002 18:43:26 -0400
> Reply-To: thelist at lists.evolt.org
>
> Rather than make it overly difficult for yourself as a newbie, why not do
> this:
>
> 1. insert the new customer (insert statement)
> 2. get the customer id back based on unique information or using multiple
> fields to make sure you obtain the correct user (select statement)
> 3. insert the order with the customer id (insert statement)
>
> Yea, there are other, better ways to do it, but as your tip said, why not
> try the simplest route first, then move towards the complex?
>
> David
> www.confluentforms.com
>
>
> --__--__--
>
> Message: 34
> From: "David Kutcher" <david_kutcher at hotmail.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] counting returned rows in mySQL
> Date: Fri, 26 Apr 2002 18:48:54 -0400
> Reply-To: thelist at lists.evolt.org
>
> I'm confused why you would do this.
>
> Why not just $num_results = mysql_num_rows($result);
> where $result = mysql_query();
>
> ?
>
> I'm confused.
>
> David
> www.confluentforms.com
>
>
> ----- Original Message -----
> From: "Benjamin" <kalos at carolina.rr.com>
>
>
>> A simple way to get the number of rows your query has returned (using Perl
>> & mySQL)
>
> --__--__--
>
> Message: 35
> Date: Fri, 26 Apr 2002 19:01:41 -0400 (EDT)
> From: "Warden, Matt" <mwarden at mattwarden.com>
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] ASP:: Personal Info > Write to Text or Email off?
> Reply-To: thelist at lists.evolt.org
>
> On Apr 26, kevin D. white had something to say about Re: [thelist] ASP::...
>
>
>> Email certainly isn't very secure but it just has to be a better idea than
>> storing thousands of name-email-phone combinations in a text-file.
>>
>> Right?
>
> i'd be too afraid to use a solution as unreliable as email.
>
> here's a thought: why not batch it?
>
> your script writes the info to File A. Every 20 minutes, some other
> process runs that copies all information from File A to the full database
> in File B. That way, FIle B is only accessed once every 20 minutes and
> File A never gets large enough for it to cause problems.
>
> whatcha think?
>
> --
> mattwarden
> mattwarden.com
>
>
> --__--__--
>
> Message: 36
> From: "lon.kraemer" <lwkraemer at directvinternet.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] site check
> Date: Fri, 26 Apr 2002 18:05:15 -0500
> Reply-To: thelist at lists.evolt.org
>
> James,
>
> It's there... in the home page section headers above the car pix. (e.g. "Our
> Latest Drivers- D R I V E R S")
>
> +1 on this use of CSS. This also emphasizes my point to encapsulate styles
> in the external stylesheet. There I see only these classes in his external:
> ..note {
> margin-left : 20px;
> }
> ..edit {
> font-size : 8pt;
> }
> ....for which I'd have NO clue where they'd be used. (no comment about pt)
>
> One point I was trying to make is that dependence on inline styles defeats
> most of the major benefits of using CSS. If Lemur was using classes more
> efficiently, he'd immediately see that he has WAY to many styles declared
> for individual/same selectors (I noted links). When/if he decides to change
> this, his only recourse is to do a 1-to-1 manual replacement on each page
> for each link.
>
> Alan, have you subscribed to the css-discuss list?
> http://two.pairlist.net/mailman/listinfo/css-discuss
>
> --
> Lon Kraemer
> -----------------------------------------
>
>
>> lon and head lemur,
>>
>>> · may bite in screenreaders as will interspersing spaces in
> words,
>>> e.g. D R I V E R S. I'd stick to standard punctuation.
>>
>> I didn't see the spacing issue on the site, so maybe lemur altered it.
>> But just a reminder that you can achieve this effect in CSS without
> messing
>> up the underlying text, thereby sparing users with screen-readers:
>>
>> <style type="text/css">
>> .spacedOut {
>> letter-spacing: .3em ;
>> }
>> </style>
>>
>> James Aylard
>
>
>
> --__--__--
>
> Message: 37
> From: "David Bindel" <dbindel at austin.rr.com>
> To: <thelist at lists.evolt.org>
> Date: Fri, 26 Apr 2002 18:17:52 -0500
> Subject: [thelist] Multiple CSS Classes
> Reply-To: thelist at lists.evolt.org
>
> Does anyone know how to set an element to use multiple CSS classes?
>
> The way I am doing it right now is separating the classes by a space
> (<span class="bold underline">), but I have noticed that the order in
> which you specify the classes in the class attribute *can* have the
> effect of ignoring either class for unapparent reasons in Internet
> Explorer.
>
> Example:
> <style type="text/css">
> ..bold {font-weight: 700;}
> ..underline {text-decoration: underline;}
> </style>
> <span class="bold underline">This text should be bold and
> underlined.</span>
>
> Is there a correct way of specifying multiple CSS classes?
>
> Thanks in advance,
> David Bindel
>
>
> --__--__--
>
> Message: 38
> From: sasha <sasha at bittersweet2.com>
> To: thelist at lists.evolt.org
> Date: Fri, 26 Apr 2002 19:37:32 -0400
> Subject: Re: [thelist] Multiple CSS Classes
> Reply-To: thelist at lists.evolt.org
>
> Having 2 classes applied to the same element like that
> is technically incorrect syntax (if I'm not mistaken).
>
> If you can't/don't want to have one class that does
> both:
>
> mystyle { font-weight: bold; text-decoration: underline
> }
>
> Your only option is to do this:
>
> <span class="bold_class" style="text-decoration:
> underline">whatever</span>
>
> Unless of course, you don't mind using b/i or nesting
> multiple span tags.
>
> Christy "sasha" Siepker
> http://www.bittersweet2.com
>
> 4/26/2002 7:17:52 PM, "David Bindel"
> <dbindel at austin.rr.com> wrote:
>
>> Does anyone know how to set an element to use multiple
> CSS classes?
>>
>> The way I am doing it right now is separating the
> classes by a space
>> (<span class="bold underline">), but I have noticed
> that the order in
>> which you specify the classes in the class attribute
> *can* have the
>> effect of ignoring either class for unapparent reasons
> in Internet
>> Explorer.
>>
>> Example:
>> <style type="text/css">
>> .bold {font-weight: 700;}
>> .underline {text-decoration: underline;}
>> </style>
>> <span class="bold underline">This text should be bold
> and
>> underlined.</span>
>>
>> Is there a correct way of specifying multiple CSS
> classes?
>>
>> Thanks in advance,
>> David Bindel
>>
>> --
>> For unsubscribe and other options, including
>> the Tip Harvester and archive of thelist go to:
>> http://lists.evolt.org Workers of the Web, evolt !
>>
>
>
>
>
> --__--__--
>
> Message: 39
> From: "James Aylard" <webmaster at equilon-mrc.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] Multiple CSS Classes
> Date: Fri, 26 Apr 2002 16:46:31 -0700
> Reply-To: thelist at lists.evolt.org
>
> sasha,
>
>> Having 2 classes applied to the same element like that
>> is technically incorrect syntax (if I'm not mistaken).
>
> Sorry -- you _are_ mistaken! :) Multiple classes may be applied to an
> element by using a space-separated list as the value of the class attribute.
> However, IE/Win32 -- up to and including IE 6 -- does not handle
> multiple-class selectors properly, so using multiple classes on an element
> is a bit risky. If used simply, they are fine, such as:
>
> <style type="text/css">
> .foo {
> color: #ffff00 ;
> }
> .bar {
> background-color: #ff0000 ;
> }
> </style>
> ....
> <p class="foo bar">This will have yellow text with a red background.</p>
>
> But, relying on the html snippet above, IE won't handle this properly
> since it does not properly interpret multiple-class selectors:
>
> <style type="text/css">
> .foo.bar {
> font-weight: bold ;
> }
> </style>
>
> James Aylard
>
>
>
> --__--__--
>
> _______________________________________________
> Help: http://lists.evolt.org/mailman/listinfo/thelist
>
> Archives: http://lists.evolt.org
>
> End of thelist Digest
>
More information about the thelist
mailing list