[wdvltalk] Sorting ADO recordsets
I've got one that's really buggin me: I have a recordset that contains contact info, nearly all of which is optional, unfortunately. What I am doing is sorting by the last name, then the first name, then the email address and plunking these into a select list. What I end up with (in ascending order) is a bunch of email addresses at the top (those without first or last names in the db), then first names (no last name in the db) then the neatly ordered first and last names. What I'd like is to have the records with a first and last name come first, then the ones with just first names, then the ones with only an email address. My code looks like this: select contactID, (fname + ' ' + lname) as fullname, email from contacts where active = 1 order by lname, fname, email would someone kindly throw me a bone? Thanks, Stephen http://www.mechavox.com The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: set WDVLTALK pw=yourpassword in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: [SCR] http://www.goodriddancegirl.com/
d'oh! :) I Love This List! Guess that's another one for the to-do list Thanks Stephen, Stephen http://www.mechavox.com Hi Stephen, nice clean site works well WIN2k IE6 800*600 and win 98 IE6 1024*768. One question are you going to add meta tags for description and keywords? Regards Stephen Hutchinson The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Best way to add 2 images to the same row???
hey marvc (is it marv? marvin? something else?), I think you just need to set the cellspacing attribute of the table... e.g.: table cellspacing=0 .. lots of table code /table hth, Stephen Caudill http://www.mechavox.com The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: popup tags on text links??
:) LOL! Happens to the best of us. Glad I could be of assistance! -Stephen http://www.mechavox.com The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: Password protection
Can I add a 'me too please' to Peter's request.The difference is I start from incompetence in the area.My site host is 34sp which I think has good facilities for such a thing.I am just putting together a book which I would like to be securely available only to those who pay.And I am with PayPal. I'm hoping to have this ready to go within a few weeks. Any advice on what I might sensibly need, exactly (oh! and I do mean exactly) where everything should go and how to get it working. I see from my logs that I get a very wide range of browsers (including NN4) so I would prefer to be guided to something that is likely to work everywhere (if that is possible). I have a simple set-up for an earlier book, but it is not protected at all, except that the page url is not obvious! Thanks for all suggestions Joseph Okay, I'm willing to help (as are others), but as I said, it requires some server side scripting and any specific examples will be language dependant, so if you'll let us know what server side language we're talking about, we can take a stab (yeesh, I feel like I've got a frog in my pocket, with all those we's). Without getting language specific and speaking in broad generalities: I would say you'd need to have the user register and log in before you send them off to Paypal. Upon receipt of notification of payment from Paypal (I have no clue how their system works), note this in the database. The page that has the downloads should check to see if the user is logged in and if they have authorization to download (they made payment), if they don't meet this criteria, redirect them to a page that states they are not authorized for that resource. At its simplest, this could be done with a single table in the database. Wow, hopefully that was some help. It's late here and my brain's too Amstel-addled to tell if I'm making sense :) -Stephen http://www.mechavox.com The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: monitors sizing?
Just at a glance, you have your main layout table set to 906px wide. Looks like you'd have to change the layout. I noted you're using dreamweaver for an IDE and static HTML pages, did you set up a DW template? or are you looking at having to change every page? I just looked at some of the interior pages and apparently you are not using any kind of standard template. I don't see any way around hand editing every page. You might want to look really closely at the methodology with which you are developing your pages and see if you can come up with some ways to make your life easier. a few suggestions you might look into: -using server side includes -some sort of server scripting -try not to use nested tables -read the specs for xhtml and live by them I hope this helps some, Stephen Caudill The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [kinda OT] IIS 5 / Win2k server configuration
I have a SMC Barricade router. When I say newbie, I mean not incredibly experienced, but Im not quite a total newbie (Im halfway through my net+ class)... My DSL is a business account, but it did not occur to me that my ISP might not allow an outside server... That might explain alot. It seems to me that I have everything set up correctly (virtual server on the router is configured, IIS 5 installed, site created and IP assigned to it, gateways set, blah blah blah), I just figured I must have missed something. Still a good possibility though. But I will check with my ISP. If anyone knows of a good (intermediate) tutorial though, I would still like a link... The object of this is for me to get some good experience building and administering from the ground up, my own intranet, extranet and network on which they reside. I do appreciate the tips though, Andrew. Thanks, Stephen The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] 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: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]