From thelist at lists.evolt.org Mon Aug 12 00:02:00 2002 From: thelist at lists.evolt.org (Tip Harvester) Date: Mon Aug 12 00:02:00 2002 Subject: [thelist] Tip Harvest for the Week of Monday Aug 05, 2002 Message-ID: <200208120501.g7C51FZx006824@leo.evolt.org> The tip harvest for the Week of Monday Aug 05, 2002 has been added to the lists.evolt.org site. Get it at: http://lists.evolt.org/index.cfm/a/harvest/b/show/c/Week-of-Mon-20020805.html Week at a glance listing at: http://lists.evolt.org/index.cfm/a/harvest/b/week/c/Week-of-Mon-20020805.html Search the tips at: http://lists.evolt.org/index.cfm/a/harvest/b/search/ Harvest Summary --------------- Number of messages: 449 Number of tips : 23 Tip Authors ----------- aardvark (1) Chris Blessing (1) Daniel Medley (1) Dave Cantrell (1) David Kaufman (1) Drew Shiel (1) Erika Meyer (1) Janet Nabring-Stager (1) Jay Blanchard (1) jeduthun (1) jon steele (1) Madhu Menon (1) mark at mark.ac (1) Nicole (1) Pat Meeks (1) R.Livsey (1) Rob Sylvan (1) Shashank Tripathi (1) Simon Willison (1) spinhead (1) tony crockford (1) Wade Armstrong (1) Tip Types --------- asp components, xmlhttp (1) Credit cards (1) Free XML Training Class (1) how to behave as a customer service rep (1) How to email a company (1) HTML, forms and overlapping tags (1) Javascript in multiple frameset environments (1) learning css (1) Linux Server (1) PHP (1) reset (2) search engines (1) testing (1) TextPad workspaces (1) useful resources (1) user experience (1) Working out problems (1) From dbindel at austin.rr.com Mon Aug 12 00:10:01 2002 From: dbindel at austin.rr.com (David Bindel) Date: Mon Aug 12 00:10:01 2002 Subject: [thelist] Trying to center using CSS In-Reply-To: Message-ID: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > -----Original Message----- > From: Amy Johnson > > I have embedded DIVS set up and am able to > center things as I need to. However, I can't center the primary > DIV. I would like it to center within different size screens, 17", > 19", 21", etc. > > DIV.ht contains all of my web page. So I want for > DIV.ht, which is a set width, to always be centered in DIV.main. > I don't think percentages will work for the left value of DIV.ht > since it is a fixed width. But left:auto doesn't work either. > This seems like it should be obvious. What am I missing? > > DIV.ht {position: absolute; > height: 550px; > width: 600px; > top: 70px; > left: auto; > } The CSS you need is as follows: div.ht { width: 600px; height: 550px; margin-left: auto; margin-right: auto; } HTH, David Bindel -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPVdC47wc2umqeOxSEQKBsACfW5uwmYpiAh1wB7hg3vPJk2XWgDkAnRQk dJHCKns1ikh9/VNMNEagwFEt =eCCg -----END PGP SIGNATURE----- From lists at leto.co.nz Mon Aug 12 00:16:01 2002 From: lists at leto.co.nz (Sarah Wedde) Date: Mon Aug 12 00:16:01 2002 Subject: [thelist] Trying to center using CSS In-Reply-To: Message-ID: Amy, I think it may be because you have an absolutely positioned div. You could try - DIV.ht { width: 600px; height: 550px; margin: 70px auto 0px auto;} to get the same positioning. Sarah From axe at suburbia.com.au Mon Aug 12 00:31:01 2002 From: axe at suburbia.com.au (Chris) Date: Mon Aug 12 00:31:01 2002 Subject: [thelist]
Whitespace Message-ID: Hello, Is there any 'correct' way to avoid & from adding whitespace to a given HTML doc? On my page I have something along the lines of:
Some Heading
....
And the problem is between the
and the I am seeing a large gap where no gap was before I inserted the . Is there any way to prevent this? Oh, and good to see thelist messages flowing again. :) Regards, Chris From fffrancis at fstorr.demon.co.uk Mon Aug 12 01:14:01 2002 From: fffrancis at fstorr.demon.co.uk (fstorr) Date: Mon Aug 12 01:14:01 2002 Subject: [thelist] Running msxml In-Reply-To: <000a01c24186$b8167da0$b1276844@beldamar> Message-ID: <000001c241c7$210b9620$4363989e@DHGQCD0J> How are you running msxml? Are you trying to do an XSL conversion from the command prompt? If so you need the MSXML command line program. You can download it from Microsoft's web site. Otherwise you will need to providse a little more information. __________ Hi I've downloaded the command line prompt (msxsl.exe) from Microsoft's site. Then gone to the command line and typed something like: C:\xmlstuff xpath.xml xpath.xsl Xmlstuff is a directory on my c drive, xpath.xml and the equivalent .xsl file are the 2 files I want msxml to play with. All I ever get back is: 'msxml' is not recoginized an an internal or external command, operable program or batch file. This happens on any file, trying to do any operation. Thanks! Francis From szh at softhome.net Mon Aug 12 01:27:45 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 01:27:45 2002 Subject: [thelist] Customizing E-Mail Link Message-ID: <01a101c241c9$250df9a0$280987cb@haidersystem> Hello Experts, I just forgot the way to customizing mailto link. I looked in some books but couldn't find. How to customize a mailto link so that it opens a window for new mail with subject and content already written? Thank you, Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From szh at softhome.net Mon Aug 12 01:36:41 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 01:36:41 2002 Subject: [thelist] Line Break in Titles References: <20020812013047.53886.qmail@web13508.mail.yahoo.com> Message-ID: <019f01c241c9$1fb85040$280987cb@haidersystem> From: "jon steele" To: Sent: August 12, 2002, Monday 6:30 AM Subject: Re: [thelist] Line Break in Titles > Alternative (js enabled only) > > link2 It worked very well. I love JS. What a language... Thanks for the help. Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From sfmalo at 24caratdesign.com Mon Aug 12 01:43:01 2002 From: sfmalo at 24caratdesign.com (Sharon F. Malone) Date: Mon Aug 12 01:43:01 2002 Subject: [thelist] Javascript on the fly ... not flying References: <007501c24187$a8360c60$7398b2d1@oemcomputer> <002701c2419f$dc28ebb0$0201a8c0@yoda> Message-ID: <001101c241c9$2bc41d60$7b9eb2d1@oemcomputer> On Sunday, August 11, 2002 6:30 PM Ion wrote: > The image is not relatively in the same place. You're working from a > different directory (and 1 level deeper) than the original. You are also > losing the background color by removing the stylesheet reference (I get > my "remind-me" ugly color). No, I made an image subdirectory in the newhtml dir and copied all the images into it. So it's an identical setup (just 1 level deeper). Interesting. Testing in IE5.5, N6.2 and NN4.7, I get the correctly sized window to display in which is the close window link and a white background ... and just the little square box with the red "x" (which is the major problem here). Could you tell me which browser/version you're using and if it's a Mac (re the icky background color you're getting?). I'm not even sure that it's a problem of determining which style sheet to include in the code (I deleted any reference to either one). Just experimenting, trying to figure out why the images won't display. > > Boy, I'm in deep yogurt and really need some JS help. I took over a > site to make various revisions and have a deadline of 8/20 to finish > them all. Have a ~major~ problem with one page only, a page that calls > images on the fly (in the lefthand column underneath the navigation). I > can't get the images to display. Tried going with a simple openWindow > function listing the width, height, etc. in the then an blah blah> in the body, but that doesn't resize the images. > > > > The original page is at: http://www.sur-sys.com > > and select Services from the menu. > > > > My revised page is at: > http://www.sur-sys.com/newhtml/services_new.html > > > > The site pages had no DTD so I selected 4.01 Trans. Also I added an > imported stylesheet as well as making a remote.js file. So I only left > the JS that refers to this function in the tag on the Services > page. You'll notice in the JS on the Services page I removed the > reference in the content to any style sheet (thinking the script got > confused wondering which sheet to refer to) ... but that didn't do any > good. > > > > ???????? > --------------------------------------------------------------------------- Sharon F. Malone "web design and Internet writing services" http://www.24caratdesign.com sfmalo at 24caratdesign.com From mark at cyberfuddle.com Mon Aug 12 01:47:13 2002 From: mark at cyberfuddle.com (Mark Gallagher) Date: Mon Aug 12 01:47:13 2002 Subject: [thelist] Line Break in Titles References: <008301c24144$5e059180$c50987cb@haidersystem> <002f01c2418d$f4d3a360$0201a8c0@yoda> Message-ID: <3D5758C1.9040002@cyberfuddle.com> lon.kraemer wrote: >>Is it possible to add line breaks in the titles of links and images? > > Here's two ways I know of: > #1 Using ASP. > <% title="This title " & vbCrLf & "should break" %> > link1 Won't that simply send option 2? > #2 A hard return in your actual markup. > link2 Which is actually a bug (AIUI) in Internet Explorer. You'll notice that (AFAICT) no other browser supports this. Opera treats the line break as a space, and Mozilla puts in ugly pipe thingies. A line break shouldn't affect the title. -- Mark Gallagher Desperately attempting - and failing - to stay on topic since 1999 fuddleriffic - http://cyberfuddle.com/ blog - http://cyberfuddle.com/infinitebabble/ From sfmalo at 24caratdesign.com Mon Aug 12 01:52:24 2002 From: sfmalo at 24caratdesign.com (Sharon F. Malone) Date: Mon Aug 12 01:52:24 2002 Subject: [thelist] Javascript on the fly ... not flying References: <007501c24187$a8360c60$7398b2d1@oemcomputer> Message-ID: <001701c241ca$466ddec0$7b9eb2d1@oemcomputer> On Sunday, August 11, 2002 3:54 PM Kid wrote: > I found that many image rotating javascripts worked in IE or NS only. > > That could be the problem. Another thing is some javascript code > breaks if it line wraps. Don't think that's the problem. It is already a working script on the present site which I tested out in IE5.5, N6.2 and NN4.7. I just can't get it to work now. I essentially haven't even touched the script except to separate it from the rest of the scripting code on the current Services page (which code has nothing to do with this script from what I can tell) ... and all that code is now in a remote.js file. By the way, I tried this out leaving all the present scripts intact in the tag, erasing the remote.js file from the , etc. In other words, leaving it the same except taking out any reference to a .css file (which shouldn't affect calling the images, I think). Won't work. A real mystery at this point. I'm thinking of removing the DTD and seeing what happens. > > At 3:37 PM -0700 8/11/02, Sharon F. Malone wrote: > >Have a ~major~ problem with one page only, a page that calls images > >on the fly (in the lefthand column underneath the navigation). I > >can't get the images to display. > > > -- From szh at softhome.net Mon Aug 12 01:56:40 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 01:56:40 2002 Subject: [thelist] Dreamweaver 4: Layout Tables References: <5.1.0.14.2.20020812022539.01fe2cb8@203.197.12.4> Message-ID: <019b01c241c9$1838c200$280987cb@haidersystem> From: "Madhu Menon" To: Sent: August 12, 2002, Monday 1:56 AM Subject: Re: [thelist] Dreamweaver 4: Layout Tables > Use fixed width cells? Or perhaps only for the columns where you don't want > the text to expand beyond a point. I always use fixed width cells but it does not always work. Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From kstevens89 at comcast.net Mon Aug 12 02:03:01 2002 From: kstevens89 at comcast.net (Kid Stevens) Date: Mon Aug 12 02:03:01 2002 Subject: [thelist] Customizing E-Mail Link In-Reply-To: <01a101c241c9$250df9a0$280987cb@haidersystem> References: <01a101c241c9$250df9a0$280987cb@haidersystem> Message-ID: Email us for more information about this product. At 11:17 AM +0500 8/12/02, Syed Zeeshan Haider wrote: >Hello Experts, >I just forgot the way to customizing mailto link. I looked in some books >but couldn't find. >How to customize a mailto link so that it opens a window for new mail >with subject and content already written? > >Thank you, >Syed Zeeshan Haider. >http://syedzeeshanhaider.faithweb.com/ > > >-- >For unsubscribe and other options, including >the Tip Harvester and archive of thelist go to: >http://lists.evolt.org Workers of the Web, evolt ! -- Sincerely, Kid Stevens "Reading maketh a full man; conference a ready man; and writing an exact man." -Francis Bacon From szh at softhome.net Mon Aug 12 02:08:03 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 02:08:03 2002 Subject: [thelist] Dreamweaver 4: Layout Tables References: Message-ID: <019c01c241c9$1a304c40$280987cb@haidersystem> From: "Bob Boisvert" To: Sent: August 12, 2002, Monday 2:58 AM Subject: RE: [thelist] Dreamweaver 4: Layout Tables > Have you tried setting the height of the I have added some code into the form 2 but everything else doesn't work! the form is being used as an order form so when the code is added the order info isn't being sent, which indicated the adding to a mailing list code is disabling the other code? Which doesn't seem logical! Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele Sent: Monday, August 12, 2002 10:32 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Hey Andrew, Sure you can. Create a checkbox in the form: Then on the receiving page... if(isset($addToList) && $addToList == "yes"){ //assuming there's a form field called email $throwItIn = mysql_query("insert into mylistofemails values('".$_POST['email']."'); } --- Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From andrew at uk-webdeveloper.co.uk Tue Aug 13 07:45:01 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 07:45:01 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <3D584351.7070902@star-chaser.com> Message-ID: this is really useful too, however it is kicking out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource any ideas? Thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Gary Bland Sent: Tuesday, August 13, 2002 12:23 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- Yes but you really need to check to see if the email address is already there so you don't end up with someone putting the same email address in several times. Here is one Of mine just adjust the INSERT to fit your need. $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From list01 at theparagon.org Tue Aug 13 08:11:13 2002 From: list01 at theparagon.org ({ schaapy }) Date: Tue Aug 13 08:11:13 2002 Subject: [thelist] CSS: colour attributes In-Reply-To: <5.1.0.14.2.20020810024508.00a8e688@mail.interlog.com> Message-ID: All it is - is shorthand. #ffffff = #fff #ff0000 = #f00 #336699 = #369 What's happening is your six digit hex numbers are being but down into simpler terms. You're browser knows that #fff means #ffffff. This isn't really a big deal unless you're writing ALOT of CSS - then it's nice to cut out characters to save space. Or course things like #c5ccdf; can't really be shortened so they are simply left in their full state. --------------------- Aaron Schaap www.theparagon.org > From: Frank > Reply-To: thelist at lists.evolt.org > Date: Sat, 10 Aug 2002 03:20:55 -0400 > To: thelist at lists.evolt.org > Subject: [thelist] CSS: colour attributes > > > As far as I understand, colour can be specified in a number of ways in HTML > and CSS > > "white" a limited number of named colours. > > "#FFFFFF" hexadecimal, three groups of two. > > rgb(255,255,255) three groups representing, red, green blue. > > I've been seeing this "#FFF" all over the place for a long time. At first, > I thought that it was simply sloppy code. Then I found Eric Meyer using it. > I can't seem to find a reference that details the composition of the > statement, even on the w3c. I'm feeling kind'a stumped, kind'a dumb. > > Can someone point me in the right direction? > > Thanks. > > > Frank Marion > framar at interlog.com > > > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > From mliotta at r337.com Tue Aug 13 08:17:45 2002 From: mliotta at r337.com (Matt Liotta) Date: Tue Aug 13 08:17:45 2002 Subject: [thelist] CF: CMS Tips and Tricks? In-Reply-To: Message-ID: <001b01c2428f$1bd1b540$6401a8c0@FREEWILL> My company has a Flash MX based front-end for our CMS/Portal system that includes a WYSIWYG HTML editor. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: 4155778070 at messaging.sprintpcs.com > -----Original Message----- > From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org] > On Behalf Of .jeff > Sent: Monday, August 12, 2002 7:40 PM > To: thelist at lists.evolt.org > Subject: RE: [thelist] CF: CMS Tips and Tricks? > > frank, > > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > From: Frank > > > > Thanks, but they both break the cardinal rule: Cross > > browser compatibility (Neither work in Moz or NS6+). > > But I'll do a search for the terms "browser-based > > WYSIWYG editor" > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > you're searching for the holy grail. it just doesn't exist yet in any > sort of mature form. there are a few examples you'll find of some *very* > basic offerings that provide similar support in ns6/moz, but i promise > you'll be highly disappointed (believe me, i've been looking for a *long* > time). > > for the sort of functionality you're seeking you're stuck with one of two > options -- java and flash. > > all the java ones i've seen have left me less than impressed. i have seen > two flash implementations but they're far from complete. > > http://www.active-web.cc/html/wysiwyg/ > http://www.illogicz.com/flashmx/texteditor/ > > .jeff > > http://evolt.org/ > jeff at members.evolt.org > http://members.evolt.org/jeff/ > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! From nansmith at heritageconcord.org Tue Aug 13 08:20:37 2002 From: nansmith at heritageconcord.org (Nan Smith) Date: Tue Aug 13 08:20:37 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: Why don't you try: $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); if ($result){ echo "

You are already in our system

"; { else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; } If there is a match, then there is a result, and the number of rows does not matter. Nan -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: Tuesday, August 13, 2002 8:47 AM To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this is really useful too, however it is kicking out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource any ideas? Thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Gary Bland Sent: Tuesday, August 13, 2002 12:23 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- Yes but you really need to check to see if the email address is already there so you don't end up with someone putting the same email address in several times. Here is one Of mine just adjust the INSERT to fit your need. $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From richardgray at onetel.co.uk Tue Aug 13 08:22:46 2002 From: richardgray at onetel.co.uk (Rich Gray) Date: Tue Aug 13 08:22:46 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: You've probably got a syntax error somewhere in your sql query so can you post the code before the error? What does echo mysql_error() just after the mysql_query line display? Rich -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 05:47 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this is really useful too, however it is kicking out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource any ideas? Thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Gary Bland Sent: Tuesday, August 13, 2002 12:23 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- Yes but you really need to check to see if the email address is already there so you don't end up with someone putting the same email address in several times. Here is one Of mine just adjust the INSERT to fit your need. $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From n.beresford at anansi.co.uk Tue Aug 13 08:30:01 2002 From: n.beresford at anansi.co.uk (Norman Beresford) Date: Tue Aug 13 08:30:01 2002 Subject: [thelist] US based ASP hosting In-Reply-To: Message-ID: Hi all Could someone recommend some ASP hosting where the servers are in the US. It's for a few simple sites, just needs to support SSL for one of the sites. Ideally cheap but with good support. Norman From Gary at star-chaser.com Tue Aug 13 08:36:00 2002 From: Gary at star-chaser.com (Gary Bland) Date: Tue Aug 13 08:36:00 2002 Subject: [thelist] php add email to a mysql db References: Message-ID: <3D590AFC.3000302@star-chaser.com> Andrew Maynes wrote: > this is really useful too, however it is kicking out this > > Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource > > any ideas? > > Thank you > > Andrew > I didn't know you needed all the code.I posted it as an example. Just add this line to the end of it $result = mysql_query($sql) or die ("couldn't execute query"); Gary -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today From andrew at uk-webdeveloper.co.uk Tue Aug 13 08:44:55 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 08:44:55 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: this produces this Parse error: parse error, unexpected T_ELSE in Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Nan Smith Sent: Tuesday, August 13, 2002 02:13 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db Why don't you try: $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); if ($result){ echo "

You are already in our system

"; { else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; } If there is a match, then there is a result, and the number of rows does not matter. Nan -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: Tuesday, August 13, 2002 8:47 AM To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this is really useful too, however it is kicking out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource any ideas? Thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Gary Bland Sent: Tuesday, August 13, 2002 12:23 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- Yes but you really need to check to see if the email address is already there so you don't end up with someone putting the same email address in several times. Here is one Of mine just adjust the INSERT to fit your need. $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From andrew at uk-webdeveloper.co.uk Tue Aug 13 08:52:00 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 08:52:00 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From stephane.deschamps at francetelecom.com Tue Aug 13 09:00:42 2002 From: stephane.deschamps at francetelecom.com (DESCHAMPS =?iso-8859-1?Q?St=E9phane?= DvSI/SICoR) Date: Tue Aug 13 09:00:42 2002 Subject: [thelist] CF: CMS Tips and Tricks? In-Reply-To: <001b01c2428f$1bd1b540$6401a8c0@FREEWILL> Message-ID: <004401c242cf$f9d7d410$289bf8c1@SDeschamatnw> Jeff, As for Java, I've been presented Instranet, it's done through a Java applet, and it's really impressive, although very expensive. Cut-and-paste complex data (tables PLUS images PLUS formatted text) and there was no layman-perceivable loss. (of course what I say represents my opinion and not my company's and blah blah blah, and I'm not affiliated in any way blah blah blah) > > all the java ones i've seen have left me less than > impressed. i have > seen > > two flash implementations but they're far from complete. > > > > http://www.active-web.cc/html/wysiwyg/ > > http://www.illogicz.com/flashmx/texteditor/ From auguste at mac.com Tue Aug 13 09:09:01 2002 From: auguste at mac.com (Androse) Date: Tue Aug 13 09:09:01 2002 Subject: [thelist] back web? In-Reply-To: References: Message-ID: Vu "[thelist] back web?", du 13/08/02 ? 7:02 -0400 : >can somebody explain what a registry key referring to *Backweb* means? Which >programs use this - the only reference I see in the multiple keys is to >Logitech (mouse and keyboard). Any connection with the 'BackWeb' application that pionneered Push technology (remember that ? the huge Wired mag cover and all ? ah!) along with comcast (i think)... ? From jjsteele22 at yahoo.com Tue Aug 13 09:15:16 2002 From: jjsteele22 at yahoo.com (jon steele) Date: Tue Aug 13 09:15:16 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: <20020813135516.17162.qmail@web13501.mail.yahoo.com> In this situation you could add the email to the database using another caller of some kind, like a pop-up window. I don't understand how adding the code to insert the email into database on the next page in the order will screw up the order code...you are simply adding an extra query to the rest of the php script. Anyway, hth. --- Andrew Maynes wrote: > this is really useful and helped alot, however I had better run this by you. > > The form I am using already has an email field which I dont want to change, > except to add a little tick box next to it. This is the existing form element > in form 1. > >
> > > I have added some code into the form 2 but everything else doesn't work! the > form is being used as an order form so when the code is added the order info > isn't being sent, which indicated the adding to a mailing list code is disabling > the other code? Which doesn't seem logical! > > Andrew > > > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele > Sent: Monday, August 12, 2002 10:32 > To: thelist at lists.evolt.org > Subject: Re: [thelist] php add email to a mysql db > > > Hey Andrew, > > Sure you can. > > Create a checkbox in the form: > > > > Then on the receiving page... > > if(isset($addToList) && $addToList == "yes"){ > //assuming there's a form field called email > $throwItIn = mysql_query("insert into mylistofemails > values('".$_POST['email']."'); > } > > > --- Andrew Maynes wrote: > > Hi all > > > > glad we are back online, is it just me or is everyoner getting 2-3 mails of > the > > same post? > > > > anyway here is the question, I have a form that I would like to get the email > > inserted into a MySQL db is this possible? I mean possible to use the > existing > > form elements and adding a tick box sent me a weekly newsletter? > > > > Thank you > > > > Andrew > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > > > -- > > For unsubscribe and other options, including > > the Tip Harvester and archive of thelist go to: > > http://lists.evolt.org Workers of the Web, evolt ! > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com From chris at webbtech.co.uk Tue Aug 13 09:22:06 2002 From: chris at webbtech.co.uk (Chris Marsh) Date: Tue Aug 13 09:22:06 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: <000201c242d0$728206b0$effea8c0@development.idlenet.com> Andrew > this produces this > > Parse error: parse error, unexpected T_ELSE in [..] Not that I'm a PHP programmer, but I suspect a mere typo (the second curlybrace is the wrong way round) is the culprit. Regards Chris Marsh From andrew at uk-webdeveloper.co.uk Tue Aug 13 09:31:13 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 09:31:13 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <3D590AFC.3000302@star-chaser.com> Message-ID: nope, now getting... Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /usr/home/public_html/demo/order2.php on line 12 couldn't execute query with include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $$sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO mailinglux(email) VALUES ('$email')"; $result = mysql_query($sql) or die ("couldn't execute query"); if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } ---------- Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From nansmith at heritageconcord.org Tue Aug 13 09:34:01 2002 From: nansmith at heritageconcord.org (Nan Smith) Date: Tue Aug 13 09:34:01 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: oh, sorry. In my haste, I put in a backwards bracket. The bracket in front of the else should face the other way. Nan -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: Tuesday, August 13, 2002 9:38 AM To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this produces this Parse error: parse error, unexpected T_ELSE in Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Nan Smith Sent: Tuesday, August 13, 2002 02:13 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db Why don't you try: $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); if ($result){ echo "

You are already in our system

"; { else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; } If there is a match, then there is a result, and the number of rows does not matter. Nan -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: Tuesday, August 13, 2002 8:47 AM To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this is really useful too, however it is kicking out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource any ideas? Thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Gary Bland Sent: Tuesday, August 13, 2002 12:23 To: thelist at lists.evolt.org Subject: Re: [thelist] php add email to a mysql db Andrew Maynes wrote: > Hi all > > glad we are back online, is it just me or is everyoner getting 2-3 mails of the > same post? > > anyway here is the question, I have a form that I would like to get the email > inserted into a MySQL db is this possible? I mean possible to use the existing > form elements and adding a tick box sent me a weekly newsletter? > > Thank you > > Andrew > --- Yes but you really need to check to see if the email address is already there so you don't end up with someone putting the same email address in several times. Here is one Of mine just adjust the INSERT to fit your need. $sql = "SELECT email FROM TableName WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { $sql = "INSERT INTO TableName(name,email,phone,company,message) VALUES ('$name','$email','$phone','$company','$message')"; -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From kstevens89 at comcast.net Tue Aug 13 09:36:12 2002 From: kstevens89 at comcast.net (Kid Stevens) Date: Tue Aug 13 09:36:12 2002 Subject: [thelist] Mozilla is giving me strange errors In-Reply-To: <3D58EDF5.9000109@members.evolt.org> References: <3D58EDF5.9000109@members.evolt.org> Message-ID: What OS are you on? At 9:31 PM +1000 8/13/02, Lachlan Cannon wrote: >Does anyone know why Mozilla isn't displaying my page >http://luminosity.f2o.org/thoughts/admin/add/ ? > >PS Yes I'm aware that not delivering the file as application/xhtml+xml >will 'solve' the problem.. I want to know what's causing it, and be able >to fix that. > >Thanks, >-- >Lach >__________________________________________ >Web: http://illuminosity.net/ >E-mail: lach at illuminosity.net >MSN: luminosity @ members.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 ! -- Sincerely, Kid Stevens "Liberty cannot be preserved without a general knowledge among the people.... Let us dare to read, think, speak and write." -John Adams From kstevens89 at comcast.net Tue Aug 13 09:40:10 2002 From: kstevens89 at comcast.net (Kid Stevens) Date: Tue Aug 13 09:40:10 2002 Subject: [thelist] US based ASP hosting In-Reply-To: References: Message-ID: Do you need SSL or ASP? They are not related. At 2:20 PM +0100 8/13/02, Norman Beresford wrote: >Hi all > >Could someone recommend some ASP hosting where the servers are in the US. >It's for a few simple sites, just needs to support SSL for one of the sites. >Ideally cheap but with good support. > >Norman > >-- >For unsubscribe and other options, including >the Tip Harvester and archive of thelist go to: >http://lists.evolt.org Workers of the Web, evolt ! -- Sincerely, Kid Stevens "Liberty cannot be preserved without a general knowledge among the people.... Let us dare to read, think, speak and write." -John Adams From richardgray at onetel.co.uk Tue Aug 13 09:48:00 2002 From: richardgray at onetel.co.uk (Rich Gray) Date: Tue Aug 13 09:48:00 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: You forgot the echo mysql_error() ... and you don't seem to have selected the database ... Try something like this... $link = mysql_connect("$dbhost","$dbuser","$dbpass") or die("Can't connect"); if (mysql_select_db("mydatabase",$link)) { $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); if (mysql_num_rows($result) > 0) echo "

You are already in our system

"; else { if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_query("insert into mailinglux values('$email')"); } } else { echo "Can't select the database"; exit; } -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 06:46 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From richardgray at onetel.co.uk Tue Aug 13 09:59:00 2002 From: richardgray at onetel.co.uk (Rich Gray) Date: Tue Aug 13 09:59:00 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: You forgot the echo mysql_error() ... and you don't seem to have selected the database ... Try something like this... $link = mysql_connect("$dbhost","$dbuser","$dbpass") or die("Can't connect"); if (mysql_select_db("mydatabase",$link)) { $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); if (mysql_num_rows($result) > 0) echo "

You are already in our system

"; else { if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_query("insert into mailinglux values('$email')"); } } else { echo "Can't select the database"; exit; } -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 06:46 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From richardgray at onetel.co.uk Tue Aug 13 10:04:00 2002 From: richardgray at onetel.co.uk (Rich Gray) Date: Tue Aug 13 10:04:00 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: You forgot the echo mysql_error() ... and you don't seem to have selected the database ... Try something like this... $link = mysql_connect("$dbhost","$dbuser","$dbpass") or die("Can't connect"); if (mysql_select_db("mydatabase",$link)) { $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); if (mysql_num_rows($result) > 0) echo "

You are already in our system

"; else { if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_query("insert into mailinglux values('$email')"); } } else { echo "Can't select the database"; exit; } -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 06:46 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From andrew at uk-webdeveloper.co.uk Tue Aug 13 10:06:29 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 10:06:29 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <20020813135516.17162.qmail@web13501.mail.yahoo.com> Message-ID: this is what I had originally thought, I must be missing something. The rest of the code checks a couple of form fields and then emails the results to both the site admin and the form filler. I did have a problem with a conflict there but that is sorted now as it was a mail problem. Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele Sent: Tuesday, August 13, 2002 02:55 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db In this situation you could add the email to the database using another caller of some kind, like a pop-up window. I don't understand how adding the code to insert the email into database on the next page in the order will screw up the order code...you are simply adding an extra query to the rest of the php script. Anyway, hth. --- Andrew Maynes wrote: > this is really useful and helped alot, however I had better run this by you. > > The form I am using already has an email field which I dont want to change, > except to add a little tick box next to it. This is the existing form element > in form 1. > >
> > > I have added some code into the form 2 but everything else doesn't work! the > form is being used as an order form so when the code is added the order info > isn't being sent, which indicated the adding to a mailing list code is disabling > the other code? Which doesn't seem logical! > > Andrew > > > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele > Sent: Monday, August 12, 2002 10:32 > To: thelist at lists.evolt.org > Subject: Re: [thelist] php add email to a mysql db > > > Hey Andrew, > > Sure you can. > > Create a checkbox in the form: > > > > Then on the receiving page... > > if(isset($addToList) && $addToList == "yes"){ > //assuming there's a form field called email > $throwItIn = mysql_query("insert into mylistofemails > values('".$_POST['email']."'); > } > > > --- Andrew Maynes wrote: > > Hi all > > > > glad we are back online, is it just me or is everyoner getting 2-3 mails of > the > > same post? > > > > anyway here is the question, I have a form that I would like to get the email > > inserted into a MySQL db is this possible? I mean possible to use the > existing > > form elements and adding a tick box sent me a weekly newsletter? > > > > Thank you > > > > Andrew > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > > > -- > > For unsubscribe and other options, including > > the Tip Harvester and archive of thelist go to: > > http://lists.evolt.org Workers of the Web, evolt ! > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From pinyo at greatnexus.com Tue Aug 13 10:09:39 2002 From: pinyo at greatnexus.com (Pinyo Bhulipongsanon) Date: Tue Aug 13 10:09:39 2002 Subject: [thelist] Mozilla is giving me strange errors Message-ID: <20020813150729.68219.qmail@wm1.netfirms.com> On Tue, 13 Aug 2002 07:51:50 -0600, Kid Stevens wrote : > What OS are you on? > > At 9:31 PM +1000 8/13/02, Lachlan Cannon wrote: > >Does anyone know why Mozilla isn't displaying my page > >http://luminosity.f2o.org/thoughts/admin/add/ ? > > > >PS Yes I'm aware that not delivering the file as application/xhtml+xml > >will 'solve' the problem.. I want to know what's causing it, and be able > >to fix that. > > > >Thanks, > >-- > >Lach > >__________________________________________ > >Web: http://illuminosity.net/ > >E-mail: lach at illuminosity.net > >MSN: luminosity @ members.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 ! > > > -- > Sincerely, > Kid Stevens > > "Liberty cannot be preserved without a general knowledge among the people.... > Let us dare to read, think, speak and write." > -John Adams > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > > Mozilla does not deal with linked stylesheet well when doing DIV positioning. You must include the positioning CSS tags inline on the DIV tag. -- pinyo at greatnexus.com Looking for tutorials and articles on web site development, visit us at http://greatnexus.com While you are there, drop by and join our web community at http://greatnexus.com/edgeboard/ From andrew at uk-webdeveloper.co.uk Tue Aug 13 10:12:04 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 10:12:04 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <20020813135516.17162.qmail@web13501.mail.yahoo.com> Message-ID: this is what I had originally thought, I must be missing something. The rest of the code checks a couple of form fields and then emails the results to both the site admin and the form filler. I did have a problem with a conflict there but that is sorted now as it was a mail problem. Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele Sent: Tuesday, August 13, 2002 02:55 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db In this situation you could add the email to the database using another caller of some kind, like a pop-up window. I don't understand how adding the code to insert the email into database on the next page in the order will screw up the order code...you are simply adding an extra query to the rest of the php script. Anyway, hth. --- Andrew Maynes wrote: > this is really useful and helped alot, however I had better run this by you. > > The form I am using already has an email field which I dont want to change, > except to add a little tick box next to it. This is the existing form element > in form 1. > > > > > I have added some code into the form 2 but everything else doesn't work! the > form is being used as an order form so when the code is added the order info > isn't being sent, which indicated the adding to a mailing list code is disabling > the other code? Which doesn't seem logical! > > Andrew > > > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele > Sent: Monday, August 12, 2002 10:32 > To: thelist at lists.evolt.org > Subject: Re: [thelist] php add email to a mysql db > > > Hey Andrew, > > Sure you can. > > Create a checkbox in the form: > > > > Then on the receiving page... > > if(isset($addToList) && $addToList == "yes"){ > //assuming there's a form field called email > $throwItIn = mysql_query("insert into mylistofemails > values('".$_POST['email']."'); > } > > > --- Andrew Maynes wrote: > > Hi all > > > > glad we are back online, is it just me or is everyoner getting 2-3 mails of > the > > same post? > > > > anyway here is the question, I have a form that I would like to get the email > > inserted into a MySQL db is this possible? I mean possible to use the > existing > > form elements and adding a tick box sent me a weekly newsletter? > > > > Thank you > > > > Andrew > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > > > -- > > For unsubscribe and other options, including > > the Tip Harvester and archive of thelist go to: > > http://lists.evolt.org Workers of the Web, evolt ! > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From ben at inchima.com Tue Aug 13 10:30:50 2002 From: ben at inchima.com (Ben Phillips) Date: Tue Aug 13 10:30:50 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: <001001c242d6$6cc59d80$0300a8c0@BS> there are a few syntax errors in the code. i've altered them below: > this is the code: > > include("settings.inc"); > > mysql_connect("$dbhost","$dbuser","$dbpass"); > > $sql = "SELECT email FROM mailinglux WHERE > email='$email'"; > $result=mysql_query($sql); > $num=mysql_numrows($result); mysql_numrows() should be mysql_num_rows(). > if ($num > 0) when using if statements, surround all blocks in curly brackets. so: if ($num > 0) { // do stuff when $num > 0 echo "..."; } else { // do stuff when $num isn't > 0 mysql_error() ... } it's a lot easier to read, for you and for others, and will also make spotting errors easier. benji. inchima.com From evolt at accessibleinter.net Tue Aug 13 10:33:41 2002 From: evolt at accessibleinter.net (Bill Mason) Date: Tue Aug 13 10:33:41 2002 Subject: [thelist] Mozilla is giving me strange errors In-Reply-To: <200208131307.g7DD7sN09525@relay.evolt.org> Message-ID: <5.1.1.6.0.20020813071737.009f4190@accessibleinter.net> At 06:07 AM 08/13/2002, Lachlan Cannon wrote: >Does anyone know why Mozilla isn't displaying my page >http://luminosity.f2o.org/thoughts/admin/add/ ? > >PS Yes I'm aware that not delivering the file as application/xhtml+xml >will 'solve' the problem.. I want to know what's causing it, and be able >to fix that. It's working fine in my 1.1b nightly build, 2002080614. What version are you having a problem in? Bill Mason Accessible Internet evolt at accessibleinter.net http://www.accessibleinter.net/ From bill at webmarketingworx.com Tue Aug 13 10:34:32 2002 From: bill at webmarketingworx.com (Bill Haenel) Date: Tue Aug 13 10:34:32 2002 Subject: [thelist] MySQL/PHP - copy record? Message-ID: Howdy all - I'll bet someone on this list has had to do this before - more than once even. (I can think of one person who's probably done it many times - hmmmm...) Anyway, I have a record in a MySQL DB and I want to put a button on my form that says 'copy this record'. I can think of several ways this can be done using PHP, but what I'd really like to do it make it happen almost (if not) 100% by query, to avoid messy coding. Is there a way to do this all via SQL? All info from one record to the other would be duped except for date (not datestamp) and id. BH From bill at webmarketingworx.com Tue Aug 13 10:37:52 2002 From: bill at webmarketingworx.com (Bill Haenel) Date: Tue Aug 13 10:37:52 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: > Warning: mysql_numrows(): supplied argument is not a valid MySQL > result resource > in /usr/home/public_html/demo/order2.php on line 12 > couldn't execute query > > $$sql = "SELECT email FROM mailinglux WHERE Extra '$' on $sql? "$$sql" -- (see above) BH From evoltlist at rogers.com Tue Aug 13 10:45:32 2002 From: evoltlist at rogers.com (Ingrid Z) Date: Tue Aug 13 10:45:32 2002 Subject: [thelist] SQL 2000 update statement - thanks References: <01c24274$257d3f80$b2e6059a@rudy> Message-ID: <00ee01c242d7$184bd520$33c52a18@userf1xcwzruul> Thanks Rudy and Paul, Rudy, your suggestion has helped. All I have to do now is re-sort the order before I dump into the text file, so the order total column appears with the orders for that user. The shopping cart will be re-structured anyway, this is an interim solution. Thanks very much, Ingrid > if not, try > > insert into summary (custname, ordertotal) > select custname, sum(orderamt) > from orders > group by custname > > rudy > http://lists.evolt.org Workers of the Web, evolt ! > From andrew at uk-webdeveloper.co.uk Tue Aug 13 10:57:44 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 10:57:44 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: Excellent This works but there are still a few problems and this isnt using a tick box which was the original plan! Thak you all for the help I will try to get the tick box working but I think it cant work because the form element is the email? Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Rich Gray Sent: Tuesday, August 13, 2002 11:32 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db You forgot the echo mysql_error() ... and you don't seem to have selected the database ... Try something like this... $link = mysql_connect("$dbhost","$dbuser","$dbpass") or die("Can't connect"); if (mysql_select_db("mydatabase",$link)) { $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); if (mysql_num_rows($result) > 0) echo "

You are already in our system

"; else { if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_query("insert into mailinglux values('$email')"); } } else { echo "Can't select the database"; exit; } -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 06:46 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From pixelmech at yahoo.com Tue Aug 13 11:06:01 2002 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Tue Aug 13 11:06:01 2002 Subject: [thelist] DOM: accessing properties of "children" array - another solution In-Reply-To: <3D58E9E3.9070404@ihug.co.nz> Message-ID: <20020813160033.68575.qmail@web12607.mail.yahoo.com> Thanks Duncan - I see the key here is being able to grab all the TD elements using getElementsByTagName coming off the TR - great! I didn't know you could do that. I may adjust my other script now, I think this is better! Tom --- Duncan O'Neill wrote: > Tom, > > this might give you some ideas. > Works in PC/ IE5.5, Moz 1.0, Opera 6.0 > > > > > Changing bgColor > > > > >
in the properties panel? Yes, but it does not always work. Works sometimes but mostly not. >or tried to controlling it with CSS? No, I didn't but now I wonder why I didn't think of it earlier. It has solved the problem. Thanks to you. >I don't usually have this problem when laying out table in Dreamweaver 4. How do you avoid the problems? Do you use CSS for controling the dimensions of cells? >Are you by any chance using MX? Not at all, man. I think new versions come as early as we (at least me) have not become enough experts of older versions. Thanks again, Bob. Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From szh at softhome.net Mon Aug 12 02:12:27 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 02:12:27 2002 Subject: [thelist] Line Break in Titles References: <008301c24144$5e059180$c50987cb@haidersystem> <002f01c2418d$f4d3a360$0201a8c0@yoda> Message-ID: <019e01c241c9$1de3de60$280987cb@haidersystem> From: "lon.kraemer" To: Sent: August 12, 2002, Monday 4:22 AM Subject: Re: [thelist] Line Break in Titles > #1 Using ASP. > <% title="This title " & vbCrLf & "should break" %> > link1 Sorry, I don't know ASP. > #2 A hard return in your actual markup. > link2 Yes it worked very well. Thank you for the help. Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From szh at softhome.net Mon Aug 12 02:13:20 2002 From: szh at softhome.net (Syed Zeeshan Haider) Date: Mon Aug 12 02:13:20 2002 Subject: [thelist] Dreamweaver 4: Layout Tables References: <5.1.0.14.2.20020812022539.01fe2cb8@203.197.12.4> Message-ID: <019d01c241c9$1c0644c0$280987cb@haidersystem> From: "Kid Stevens" To: Sent: August 12, 2002, Monday 2:55 AM Subject: Re: [thelist] Dreamweaver 4: Layout Tables > I set my cells with CSS. > > tbody.tricell {width: 460px > } > .fcell {width: 120px; > } > .scell {width: 140px; > } > .tcell {width: 220px; > } CSS has solved the problem. Thank you, Kid Stevens. Thanks again! Syed Zeeshan Haider. http://syedzeeshanhaider.faithweb.com/ From php at erasinar.com Mon Aug 12 02:20:01 2002 From: php at erasinar.com (Wahyu Harsono) Date: Mon Aug 12 02:20:01 2002 Subject: [thelist] dynamic dns server software? References: <3D52E585.36FA2822@nlcnet.org> Message-ID: <000b01c241cc$58bb5100$0400a8c0@bb> Try DNS2GO ( Windows ), on http://www.deerfield.com G'Luck ----- Original Message ----- From: "Benjamin C. Varadi" To: Sent: Friday, August 09, 2002 4:41 AM Subject: [thelist] dynamic dns server software? > Had no luck with this on webdesign-l. Y'all have any thoughts? > > -BEN > > -------- Original Message -------- > >> Anyone know what software exists to provide dynamic dns hosting (y'know, > >> like ods.org or dyndns.org)? Web searches just show me a ton of > >> providers. > > I guess I didn't phrase my question well enough. I'm looking for > software to *provide* dynamic service. My understanding of how this > works is that a client program sends a sort of "authenticated ping" > periodically to the server, which checks the client IP address against > Apache's DNS records & makes changes if necessary. > > I feel like this is probably more complex than it seems, though, and if > turnkey or (ideally) open-source scripts existed to set up a server in > this manner, I'd love to know about it. > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > From webguru at vsnl.net Mon Aug 12 02:24:24 2002 From: webguru at vsnl.net (Madhu Menon) Date: Mon Aug 12 02:24:24 2002 Subject: [thelist] Customizing E-Mail Link In-Reply-To: <01a101c241c9$250df9a0$280987cb@haidersystem> Message-ID: <5.1.0.14.2.20020812121939.01f53b50@203.197.12.4> At 11:47 AM 12-08-02, Syed Zeeshan Haider wrote: >How to customize a mailto link so that it opens a window for new mail >with subject and content already written? Send me email Will not work reliably across all systems and e-mail clients. Use a server-side script to do this if you want reliability. Regards, Madhu <<< * >>> Madhu Menon User Experience Consultant e-mail: webguru at vsnl.net Weblog: http://madman.weblogs.com From kstevens89 at comcast.net Mon Aug 12 02:29:01 2002 From: kstevens89 at comcast.net (Kid Stevens) Date: Mon Aug 12 02:29:01 2002 Subject: [thelist] Dreamweaver 4: Layout Tables In-Reply-To: <019b01c241c9$1838c200$280987cb@haidersystem> References: <5.1.0.14.2.20020812022539.01fe2cb8@203.197.12.4> <019b01c241c9$1838c200$280987cb@haidersystem> Message-ID: Depends on the browser and the OS and yes it still does break once and awhile. True CSS support is still a ways off. By the time it gets to be perfect someone will come along and make a mess by getting a new standard going. At 10:57 AM +0500 8/12/02, Syed Zeeshan Haider wrote: > >> > Use fixed width cells? Or perhaps only for the columns where you don't >>want >> > the text to expand beyond a point. > >I always use fixed width cells but it does not always work. > >Syed Zeeshan Haider. >http://syedzeeshanhaider.faithweb.com/ -- Sincerely, Kid Stevens "Reading maketh a full man; conference a ready man; and writing an exact man." -Francis Bacon From mark at cyberfuddle.com Mon Aug 12 02:41:00 2002 From: mark at cyberfuddle.com (Mark Gallagher) Date: Mon Aug 12 02:41:00 2002 Subject: [thelist] Trying to center using CSS References: Message-ID: <3D5768A4.90404@cyberfuddle.com> Amy Johnson wrote: > I am creating my first tableless site using CSS. In general, I think > it is going ok. I have embedded DIVS set up and am able to center > things as I need to. However, I can't center the primary DIV. I > would like it to center within different size screens, 17", 19", 21", > etc. > > Below is some of my CSS code. DIV.main is meant to be the entire > screen. DIV.ht contains all of my web page. So I want for DIV.ht, > which is a set width, to always be centered in DIV.main. I don't > think percentages will work for the left value of DIV.ht since it is > a fixed width. But left:auto doesn't work either. This seems like > it should be obvious. What am I missing? First off, why do they have fixed heights? Why does DIV.main's height: statement give no unit for its value? Why is DIV.main positioned absolutely? Why have you set a background-color, but no foreground color? Sorry if that seems too inquisitve, but if this is your first time, it's good to start thinking of these issues straight away :-). Oh yeah, why are .main and .ht classes instead of ids? Try this: body { margin: 0; padding: 0; } div.main { background-color: black; color: white; width: 100%; margin: 0; text-align: center; } div.ht { height: 550px; width: 600px; margin-top: 70px; } That should work. Here the "text-align: center;" statement comes into play, as div.ht being relatively positioned means that it can, in fact, be affected by the text-alignment of its container element (presumably div.main). You can also try: div.main { background-color: black; color: white; position: absolute; top: 0px; right: 0px; bottom: 0px; left: 0px; width: 100%; text-align: center; } div.ht { position: absolute; top: 70px; width: 600px; height: 550px; margin: auto; } Here the "margin: auto;" statement tells the browser "automatically calculate symmetrical values for the margin". > DIV.main {background-color: black; position: absolute; height: > 700; width: 100%; top: 0px; bottom: 0px; left: 0px; right: 0px; > text-align: center; } > > DIV.ht {position: absolute; height: 550px; width: 600px; > top: 70px; left: auto; } In future, it'd be easier to see this sort of thing if you posted a URL - that way we can *see* what the problem is, but can still find the stylesheet if need be :-) The order in which you place each statement within an element's definition in your CSS is not particularly important (unless you're trying to take advantage of cascades within an element, which is not very useful[0]), but it can make it easier to find stuff. Personally, I usually structure my definitions like so: element { color/background statements; positional statements (position, top, right, bottom, left); width/height statements; alignment statements (float, text-align, vertical-align); margin/padding statements; other non-fonty statements; border statements; font-related matters[1] (font-size, font-style, font-weight, font-family); } This way if I'm looking for information on what colours I've defined, I can look at the top of each definition. Fonts, the bottom, and so on. [0] Except where exploiting browser bugs, of course. [1] IE3 has a bug that occurs whenever font-family is included in a definition, but not as the very last statement. Unfortunately, I don't remember what it is exactly. -- Mark Gallagher Desperately attempting - and failing - to stay on topic since 1999 fuddleriffic - http://cyberfuddle.com/ blog - http://cyberfuddle.com/infinitebabble/ From jeff at members.evolt.org Mon Aug 12 02:48:00 2002 From: jeff at members.evolt.org (.jeff) Date: Mon Aug 12 02:48:00 2002 Subject: [thelist] Javascript on the fly ... not flying In-Reply-To: <007501c24187$a8360c60$7398b2d1@oemcomputer> Message-ID: sharon, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Sharon F. Malone > > My revised page is at: > http://www.sur-sys.com/newhtml/services_new.html ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< the first step to debugging this setup is to view the source of the document in the popup. if you're using ie, also check the properties for the image and the properties for the document. this will give you an idea of whether or not things are being setup like you expect. clicking the top image, here's what i get: view-source: Survey Systems, Inc. - Form Sample


Close this window

image properties: http://www.sur-sys.com/newhtml/images/formdesign_l.gif page properties: http://www.sur-sys.com/newhtml/services_new.html i can't view the contents of the /newhtml/images directory so i can't tell if that image actually exists, but with a different name, or not. you could save yourself a lot of headache by using root relative references instead. simply precede the src path with a leading slash. that'll force the browser to look in the /images directory instead. now, some general comments about the site and the scripting. you need to class the links around the images or remove any transparency placed on the images wrapped with links. the way it is now there's an ugly background color change when hovering over the images for the popup links. the scripting for the popups is needlessly keeping non-javascript users from viewing the large images. take a look at the following article to some ideas on how to avoid this. Links & JavaScript Living Together in Harmony http://www.evolt.org/article/thelist/17/20938/ now, to apply the concepts in the article above to your specific situation, this is what i'd do. 1) move the makeImgWindow() function call from the href attribute to the onclick event handler. 2) add a "return false" to the onclick event handler after the makeImgWindow() function call to cancel the href for javascript enabled browsers. 3) add a target attribute to the tag. 4) change the href attribute value to the path to the image that will be shown in the popup. 5) change the makeImgWindow() function call so the image name isn't hardcoded, instead using this.href. 6) alter the makeImgWindow() function so it doesn't have a partially hardcoded path to the image to be displayed in the popup. the result will be a more flexible function, a link that non-javascript users can use to view the large image, and a function call in the tag that'll be easier to maintain later on. the altered makeImgWindow() function: function makeImgWindow(imgPath, heading) { // Assemble content for the new window. content = 'Survey Systems, Inc. - ' + heading + '

' + '
Close this window

' + ''; // If imgWindow does not exist or is closed, define // imgWindow as a new window. if(!imgWindow || imgWindow.closed) { imgWindow = window.open('', '', 'width=525,height=700'); } else { // If the imgWindow already exists, bring it to // the front. imgWindow.focus(); } // Write the content to the new window. imgWindow.document.write(content) // End writing content. imgWindow.document.close(); } an example altered tag: the following tip will also prove useful i hope. when building strings in javascript, force yourself to wrap them with single-quotes. when you end up writing out long strings of html you'll be glad you did. so, instead of this: content = "Close this window" you'll end up with this: content = 'Close this window'; now the html will be more recognizable and you won't have to bother with nearly as much quote escaping. good luck, .jeff http://evolt.org/ jeff at members.evolt.org http://members.evolt.org/jeff/ From mark at cyberfuddle.com Mon Aug 12 02:54:41 2002 From: mark at cyberfuddle.com (Mark Gallagher) Date: Mon Aug 12 02:54:41 2002 Subject: [thelist] Customizing E-Mail Link References: <01a101c241c9$250df9a0$280987cb@haidersystem> Message-ID: <3D5769F8.3000005@cyberfuddle.com> Kid Stevens wrote: > Email us for more > information about this product. -- Mark Gallagher Desperately attempting - and failing - to stay on topic since 1999 fuddleriffic - http://cyberfuddle.com/ blog - http://cyberfuddle.com/infinitebabble/ From sfmalo at 24caratdesign.com Mon Aug 12 02:58:01 2002 From: sfmalo at 24caratdesign.com (Sharon F. Malone) Date: Mon Aug 12 02:58:01 2002 Subject: [thelist] Javascript on the fly ... not flying - SOLUTION sorta and question References: <007501c24187$a8360c60$7398b2d1@oemcomputer> <001701c241ca$466ddec0$7b9eb2d1@oemcomputer> Message-ID: <00ae01c241d5$78432120$7b9eb2d1@oemcomputer> I changed the name of my test file (services_new.html) back to services.html and uploaded it quickly to the site early this morn. Considering the hour, I thought 'twould be a good time to do this. Well, voila, on the fly ~is~ flying again. So it did have something to do with both the html and images dir files being situated at the root level rather than 1 level down. How confusing. Seems the calling is being done from the root level only. It's because I don't understand how these files are being generated. As an example, the code below creates a MUCH bigger version of the formdesign.gif image (whose size is 200x245). When I first looked in the Images dir I couldn't find a formdesign_I.gif or any of its fellow _I gifs that end up being called. No such animals! Are they lurking somewhere? Could someone explain how this works? And thanks for your help, Ion and Kid. Best, Sharon > On Sunday, August 11, 2002 3:54 PM Kid wrote: > > > I found that many image rotating javascripts worked in IE or NS only. > > > > That could be the problem. Another thing is some javascript code > > breaks if it line wraps. > > Don't think that's the problem. It is already a working script on the present site which I tested out in IE5.5, N6.2 and NN4.7. I just can't get it to work now. I essentially haven't even touched the script except to separate it from the rest of the scripting code on the current Services page (which code has nothing to do with this script from what I can tell) ... and all that code is now in a remote.js file. By the way, I tried this out leaving all the present scripts intact in the tag, erasing the remote.js file from the , etc. In other words, leaving it the same except taking out any reference to a .css file (which shouldn't affect calling the images, I think). Won't work. > > A real mystery at this point. I'm thinking of removing the DTD and seeing what happens. > > > > At 3:37 PM -0700 8/11/02, Sharon F. Malone wrote: > > >Have a ~major~ problem with one page only, a page that calls images > > >on the fly (in the lefthand column underneath the navigation). I > > >can't get the images to display. --------------------------------------------------------------------------- Sharon F. Malone "web design and Internet writing services" http://www.24caratdesign.com sfmalo at 24caratdesign.com From sfmalo at 24caratdesign.com Mon Aug 12 03:45:01 2002 From: sfmalo at 24caratdesign.com (Sharon F. Malone) Date: Mon Aug 12 03:45:01 2002 Subject: [thelist] Javascript on the fly ... not flying - reply to Jeff References: Message-ID: <00fc01c241db$f6d6a2e0$7b9eb2d1@oemcomputer> On: Monday, August 12, 2002 12:48 AM, Jeff wrote: ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > > From: Sharon F. Malone > > > > My revised page is at: > > http://www.sur-sys.com/newhtml/services_new.html > ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< [snippet] I just sent a "SOLVED sorta" message relating how I got it to work at the first level setup. I was working at the second level (newhtml dir with accompanying Images subdir). And am still wondering why it didn't work at the 2nd level (an exact replication of the 1st level). > > Survey Systems, Inc. - Form Sample


Close this window

This brings up something else. I removed the Content instruction on the first line of the script referring to a stylesheet in the original coding. That's because I created an additional css file as an import file. I decided to leave out any CSS reference because some browsers would not be able to read the stylesheet ... that is, unless I could name both style sheets here. But, wasn't sure how to write that correctly in a JS context. As the present site stands now, this is the first line of the Content: // Assemble content for the new window. content = " " So if I wanted to refer to both here, would that be: content = " " > i can't view the contents of the /newhtml/images directory so i can't tell if that image actually exists, but with a different name, or not. That's the mystery to me. No, the formdesign_I.gif does not exist. However, the formdesign.gif does. > you could save yourself a lot of headache by using root relative references instead. simply precede the src path with a leading slash. that'll force the browser to look in the /images directory instead. Thanks. > now, some general comments about the site and the scripting. > > you need to class the links around the images or remove any transparency placed on the images wrapped with links. the way it is now there's an ugly background color change when hovering over the images for the popup links. Yes, thanks. I'll do that. Noticed that too, but wanted to get this first problem solved (the most essential one!!!). > > the scripting for the popups is needlessly keeping non-javascript users from viewing the large images. take a look at the following article to some ideas on how to avoid this. Yes, noticed that too, have done that an other sites, and will correct that. This is a site I just took over so I decided to leave the present scripting untouched until I could get it working again!!! > > now, to apply the concepts in the article above to your specific situation, this is what i'd do. And, thank you ~so~ much for the code steps you listed (and I snipped) and leading me through this. Best, Sharon --------------------------------------------------------------------------- Sharon F. Malone "web design and Internet writing services" http://www.24caratdesign.com sfmalo at 24caratdesign.com From Ashok at MagicalKenya.com Mon Aug 12 05:18:01 2002 From: Ashok at MagicalKenya.com (Ashok at MagicalKenya.com) Date: Mon Aug 12 05:18:01 2002 Subject: [thelist] Page Render condition Message-ID: You could try doing a 'soft' reload of your page when its load ing by using the onLoad event , something like : HTH Ashok ------ Ashok Hariharan http://www.hazard0us.org ------ From kris at midtempo.net Mon Aug 12 05:43:01 2002 From: kris at midtempo.net (kris burford) Date: Mon Aug 12 05:43:01 2002 Subject: [thelist] css to print landscape Message-ID: <4.2.0.58.20020812113524.016b9440@mail.btinternet.com> hi all, is there a way you can set a print stylesheet to output as landscape? tia kris From steve.cook at evitbe.com Mon Aug 12 06:08:01 2002 From: steve.cook at evitbe.com (Steve Cook) Date: Mon Aug 12 06:08:01 2002 Subject: [thelist] css to print landscape Message-ID: <3B55A5A1F233D41183A800D0B74D4D523078A3@SBS> http://www.w3.org/TR/1998/REC-CSS2-19980512/page.html#page-size-prop That should answer your question. I'm not sure what browser support is like for these properties though. .steve ------------------------------------- Cookstour - http://www.cookstour.org ------------------------------------- > -----Original Message----- > From: kris burford [mailto:kris at midtempo.net] > Sent: den 12 augusti 2002 12:40 > To: thelist at lists.evolt.org > Subject: [thelist] css to print landscape > > > hi all, > > is there a way you can set a print stylesheet to output as landscape? > > tia > From n.beresford at anansi.co.uk Mon Aug 12 06:16:01 2002 From: n.beresford at anansi.co.uk (Norman Beresford) Date: Mon Aug 12 06:16:01 2002 Subject: [thelist] Data Protection Act In-Reply-To: <4.2.0.58.20020812113524.016b9440@mail.btinternet.com> Message-ID: Hi all As our webservers are now UK based we feel we need to make our clients aware of the Data Protection Act and it's impact on them. To this end I've written a brief primer to the subject and was hoping for some feedback on it. http://www.anansi.co.uk/dpa.html Cheers in advance Norman From jyee at vt.edu Mon Aug 12 06:37:00 2002 From: jyee at vt.edu (Jackson Yee) Date: Mon Aug 12 06:37:00 2002 Subject: [thelist] Whitespace Message-ID: <3D57E258@zathras> ----- Original Message ----- From: "Chris" To: "Thelist" Sent: Monday, August 12, 2002 01:30 Subject: [thelist] Whitespace > Is there any 'correct' way to avoid & from > adding whitespace to a given HTML doc? Have you tried adding the CSS styles form { margin: 0px; padding: 0px; } to the page? is a block-level element like

and

, so it might come with default margins. Regards, Jackson Yee jyee at vt.edu http://www.jacksonyee.com/ From Ashok at MagicalKenya.com Mon Aug 12 06:43:01 2002 From: Ashok at MagicalKenya.com (Ashok at MagicalKenya.com) Date: Mon Aug 12 06:43:01 2002 Subject: [thelist] Running msxml Message-ID: Msxsl.exe makes use of the msxml4.dll component (part of the MSXML parser) ... you execute it like : c:\> msxsl.exe file.xml file.xsl .... Do you have the MSXML parser installed on your computer ? ------ Ashok Hariharan http://www.hazard0us.org ------ From webdad at tampabay.rr.com Mon Aug 12 07:36:01 2002 From: webdad at tampabay.rr.com (Bob Boisvert) Date: Mon Aug 12 07:36:01 2002 Subject: [thelist] Dreamweaver 4: Layout Tables In-Reply-To: <019c01c241c9$1a304c40$280987cb@haidersystem> Message-ID: Syed Zeeshan Haider wrote: How do you avoid the problems? Do you use CSS for controling the dimensions of cells? Make sure you have an   in the cell to keep it open.
 
I do use CSS occasionally. HTH Bob From adhawan at balaram.com Mon Aug 12 08:29:01 2002 From: adhawan at balaram.com (Amit Dhawan) Date: Mon Aug 12 08:29:01 2002 Subject: [thelist] Query on Internet Explorer Browser Message-ID: <000e01c241c2$4d0b4400$0200a8c0@server3.com> Hi there, I would really appreciate if you could answer my query. Whenever I view an image in Internet Explorer Browser version 6.0, it appears to be blurred. Whereas the same image appears absolutely perfect under Internet Explorer Browser version 5.0 or Internet Explorer Browser version 5.5. I am using 800X600 pixels as the resolution to view the results. What could be the reason for the difference in the results in two different versions of the same browser? Thanks in advance. Regards, Amit Dhawan Software Engineer. From david_kutcher at hotmail.com Mon Aug 12 08:47:01 2002 From: david_kutcher at hotmail.com (David Kutcher) Date: Mon Aug 12 08:47:01 2002 Subject: [thelist] MS Action Pack Message-ID: So I've been looking into legitimizing some of the software I've been using for "testing purposes" and I came across Microsoft's Action Pack for $299 http://members.microsoft.com/partner/SalesMarketing/partnermarket/actionpack /actionpack_standard.aspx This pack gives you licenses as follows for 1 yr: Product Title, Number Of Licenses, Number of Client Access Licenses Microsoft Windows 2000 Advanced Server, 1, 5 Microsoft Exchange 2000 Enterprise Server, 1, 5 Microsoft SQL Server 2000, 1, 5 Microsoft Small Business Server 2000, 1, 5 Microsoft Internet Security and Acceleration Server, 1 Microsoft Mobile Information Server 2002, 1 Microsoft SharePoint Portal Server 2001, 1, 5 Microsoft Windows XP Professional, 5 Microsoft Office XP Professional with FrontPage, 5 Microsoft Visio 2002, 5 Microsoft Project 2000, 5 Microsoft Publisher 2002, 5 Microsoft MapPoint 2002, 5 Have any of you used this service from MS? Besides going open source, have any of you found cost-effective alternatives (like buying licenses on ebay)? Thank you, David From chris at webbtech.co.uk Mon Aug 12 08:54:01 2002 From: chris at webbtech.co.uk (Chris Marsh) Date: Mon Aug 12 08:54:01 2002 Subject: [thelist] Web Hosting Message-ID: <000801c24207$8a2ec380$effea8c0@development.idlenet.com> Dear all Firstly, apologies if I caused any annoying bounce mayhem some time ago. I found myself unable to access the web at all, and lost my domain to boot. Secondly, I have a client that is looking for hosting in the UK. They need a SQLServer database, ASP, and an admin console that allows them to create user accounts and modify permissions on files and directories accordingly. Any recommendations would be gratefully received. TIA Regards Chris Marsh From cd-ml at aardvark.net.au Mon Aug 12 09:00:01 2002 From: cd-ml at aardvark.net.au (Craig) Date: Mon Aug 12 09:00:01 2002 Subject: [thelist] Query on Internet Explorer Browser References: <000e01c241c2$4d0b4400$0200a8c0@server3.com> Message-ID: <000b01c24208$4f5ef530$370302c0@max1> IE might be resizing it. To turn it off, in Internet Options, under Multimedia, uncheck 'Enable Automatic Image Resizing'. Craig. ----- Original Message ----- From: "Amit Dhawan" To: Sent: Monday, August 12, 2002 3:07 PM Subject: [thelist] Query on Internet Explorer Browser > Hi there, > > I would really appreciate if you could answer my query. > > Whenever I view an image in Internet Explorer Browser version 6.0, it > appears to be blurred. Whereas the same image appears absolutely perfect > under Internet Explorer Browser version 5.0 or Internet Explorer Browser > version 5.5. I am using 800X600 pixels as the resolution to view the > results. What could be the reason for the difference in the results in two > different versions of the same browser? > > Thanks in advance. > > Regards, > > Amit Dhawan > Software Engineer. > > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > From eric.d.means at boeing.com Mon Aug 12 09:19:01 2002 From: eric.d.means at boeing.com (Means, Eric D) Date: Mon Aug 12 09:19:01 2002 Subject: [thelist] Query on Internet Explorer Browser Message-ID: <9CFB687ADA93234DB835E8E4CA98B92803D6C6D5@XCH-STL-07.mw.nos.boeing.com> -----Original Message----- From: Amit Dhawan [mailto:adhawan at balaram.com] Sent: Monday, August 12, 2002 12:37 AM To: thelist at lists.evolt.org Subject: [thelist] Query on Internet Explorer Browser > Whenever I view an image in Internet Explorer Browser version 6.0, it > appears to be blurred. Whereas the same image appears absolutely perfect > under Internet Explorer Browser version 5.0 or Internet Explorer Browser > version 5.5. I am using 800X600 pixels as the resolution to view the > results. What could be the reason for the difference in the results in two > different versions of the same browser? The images may have been shrunk: IE 6.0 automatically resizes images so that they fit in the current window size. If you hover over the image with your mouse, a small toolbar and a button should appear (the tool bar in the top left, the button in the bottom right of the image). If you click on the button in the bottom right, the image will return to its actual size. (You can turn off this behavior in Tools->Options->Advanced, IIRC.) From ben_dyer at imaginuity.com Mon Aug 12 09:27:45 2002 From: ben_dyer at imaginuity.com (Ben Dyer) Date: Mon Aug 12 09:27:45 2002 Subject: [thelist] Query on Internet Explorer Browser In-Reply-To: <000b01c24208$4f5ef530$370302c0@max1> References: <000e01c241c2$4d0b4400$0200a8c0@server3.com> Message-ID: <5.1.1.6.0.20020812092340.01a4fd78@mail.imaginuity.com> At 08:57 AM 8/12/2002, Craig wrote: >IE might be resizing it. To turn it off, in Internet Options, under >Multimedia, uncheck 'Enable Automatic Image Resizing'. To disable this behavior for images on your page, add in this tag: and it will supress that behavior for any images on the page (but, obviously, not if you link directly to an image). --Ben Ben Dyer, Senior Internet Developer, Imaginuity Interactive http://www.imaginuity.com/ Not an Emergency: "AudioGalaxy doesn't work anymore." Emergency: "The server is on fire, bring the extinguisher!" Please adjust your e-mail priorities accordingly. ------------------------------------------------------------------------ http://www.radicalbender.com/ http://www.evolt.org/ From VHeilman at eAngler.com Mon Aug 12 09:30:01 2002 From: VHeilman at eAngler.com (Vince Heilman) Date: Mon Aug 12 09:30:01 2002 Subject: [thelist] css to print landscape Message-ID: -- [ Picked text/plain from multipart/alternative ] This is from the "CORE CSS" book, but it also says that this is not supported yet in either Netscape or IE. I've tried it for applications in both NN6 & IE6 with no luck. -Vince > -----Original Message----- > From: kris burford [mailto:kris at midtempo.net] > Sent: Monday, August 12, 2002 6:40 AM > To: thelist at lists.evolt.org > Subject: [thelist] css to print landscape > > > hi all, > > is there a way you can set a print stylesheet to output as landscape? > > tia > > kris > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > From jjsteele22 at yahoo.com Mon Aug 12 09:32:45 2002 From: jjsteele22 at yahoo.com (jon steele) Date: Mon Aug 12 09:32:45 2002 Subject: [thelist] Whitespace In-Reply-To: Message-ID: <20020812142837.80474.qmail@web13506.mail.yahoo.com> --- Chris wrote: > Hello, > > Is there any 'correct' way to avoid & from > adding whitespace to a given HTML doc? > > On my page I have something along the lines of: > >
Some Heading
> > > > > .... >
> > > And the problem is between the
and the I am seeing a large gap > where no gap was before I inserted the . > > Is there any way to prevent this? That is a margin problem with respect to the form tag. __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com From roselli at earthlink.net Mon Aug 12 10:03:01 2002 From: roselli at earthlink.net (aardvark) Date: Mon Aug 12 10:03:01 2002 Subject: [thelist] N6 bug -- form labels overlapping form fields Message-ID: <200208121501.g7CF1kB4022139@leo.evolt.org> on this page: http://lenderconsulting.com/order_form/ (please don't fill out the form, there's no reason to for this) in some versions of Netscape (so far, not 6.01, 6.2, or mozilla 1.0) the form labels overlaps the form fields -- or rather sit behind them a bit... as if all the text was pushed to the right 30px or so... the page is valid HTML 4.01 Transitional and valid CSS... i cannot reproduce it, but i have seen this before... i was convinced it's a bug, and know i had heard of it as one, but can't find the documentation i need to prove it... looking to see if anyone with N6 can reproduce it, and let me know what version they have... then i have to get that version and start hacking away... -- Read the evolt.org case study Usability: The Site Speaks for Itself http://amazon.com/exec/obidos/ASIN/1904151035/evoltorg02-20 ISBN: 1904151035 From edc at wnc.quik.co.nz Mon Aug 12 10:11:13 2002 From: edc at wnc.quik.co.nz (michael ensor) Date: Mon Aug 12 10:11:13 2002 Subject: [thelist] css to print landscape References: Message-ID: <014901c24211$a8a72a00$246237d2@oemcomputer> Use the media attributes in CSS, check out this: http://www.w3.org/TR/html14/ hth ----- Original Message ----- From: "Vince Heilman" To: Sent: Tuesday, August 13, 2002 2:24 AM Subject: RE: [thelist] css to print landscape > -- > [ Picked text/plain from multipart/alternative ] > > > > This is from the "CORE CSS" book, but it also says that this is not > supported yet in either Netscape or IE. I've tried it for applications in > both NN6 & IE6 with no luck. > > -Vince > > > > > -----Original Message----- > > From: kris burford [mailto:kris at midtempo.net] > > Sent: Monday, August 12, 2002 6:40 AM > > To: thelist at lists.evolt.org > > Subject: [thelist] css to print landscape > > > > > > hi all, > > > > is there a way you can set a print stylesheet to output as landscape? > > > > tia > > > > kris > > -- > > For unsubscribe and other options, including > > the Tip Harvester and archive of thelist go to: > > http://lists.evolt.org Workers of the Web, evolt ! > > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/08/02 From brad at beldamar.com Mon Aug 12 10:15:21 2002 From: brad at beldamar.com (Brad Miller) Date: Mon Aug 12 10:15:21 2002 Subject: [thelist] Running msxml In-Reply-To: <000001c241c7$210b9620$4363989e@DHGQCD0J> Message-ID: <000201c2420f$9a7a1570$b1276844@beldamar> First off you need to call the program properly. >From your command prompt (where ever the fies reside) you should type: msxsl xpath.xml xpath.xsl -o output.html Notice the "-o output.html" This tells the parser what your output is. Without that it won't know what to do with the transformation. You can get a list of all the switches for MSXSL here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnxslgen/ht ml/msxsl.asp If you are typing this in correctly and still getting the error then it sounds like you don't have the MSXML 4.0 parser installed. The MSXSL command line program requires msxml4.dll which can be obtained from this link. http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?ur l=/msdn-files/027/001/766/msdncompositedoc.xml Watch for wrappig on that URL. Brad Miller www.beldamar.com www.x-etc.com brad at beldamar.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ A virus in a document is OK (provided the DTD allows it) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From AWilliams at rfbd.org Mon Aug 12 11:07:01 2002 From: AWilliams at rfbd.org (Williams, Alice) Date: Mon Aug 12 11:07:01 2002 Subject: [thelist] Web Hosting Message-ID: <1819AC6AEA6DFE41B2406903CB5674670132C166@20SEXCH1.RFBD.org> -- Hi Chris, Check out azc.com, I'm using it for a site and can access file directories, upload files and set permissions, setting permissions may have some limit on number of accounts but it's a start. Thanks Alice -----Original Message----- From: Chris Marsh [mailto:chris at webbtech.co.uk] Sent: Mon 8/12/2002 9:52 AM To: thelist at lists.evolt.org Cc: Subject: [thelist] Web Hosting Dear all Firstly, apologies if I caused any annoying bounce mayhem some time ago. I found myself unable to access the web at all, and lost my domain to boot. Secondly, I have a client that is looking for hosting in the UK. They need a SQLServer database, ASP, and an admin console that allows them to create user accounts and modify permissions on files and directories accordingly. Any recommendations would be gratefully received. TIA Regards Chris Marsh -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- [ winmail.dat was deleted, please don't send attachments with your message. ] From pixelmech at yahoo.com Mon Aug 12 11:19:14 2002 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Mon Aug 12 11:19:14 2002 Subject: [thelist] Javascript on the fly ... not flying In-Reply-To: <001701c241ca$466ddec0$7b9eb2d1@oemcomputer> Message-ID: <20020812161328.48208.qmail@web12601.mail.yahoo.com> Sharon, Not sure if you solved this yet, but when I run into problems like this I take a "Back to basics" approach. I pull the javascript out and place it in a new document, and put anything its supposed to effect in as well - a simple skeleton document, no css, no nothing else. But in the DTD you want to use. Clean the code up and format it the way it should be. Then go from there, I find I make much better progress this way. Then you can add in elements and find the problem. Tom --- "Sharon F. Malone" wrote: > On Sunday, August 11, 2002 3:54 PM Kid wrote: > > > I found that many image rotating javascripts worked in IE or NS > only. > > > > That could be the problem. Another thing is some javascript code > > breaks if it line wraps. > > Don't think that's the problem. It is already a working script > on the present site which I tested out in IE5.5, N6.2 and NN4.7. I > just can't get it to work now. I essentially haven't even touched > the script except to separate it from the rest of the scripting > code on the current Services page (which code has nothing to do > with this script from what I can tell) ... and all that code is now > in a remote.js file. By the way, I tried this out leaving all the > present scripts intact in the tag, erasing the remote.js > file from the , etc. In other words, leaving it the same > except taking out any reference to a .css file (which shouldn't > affect calling the images, I think). Won't work. > > A real mystery at this point. I'm thinking of removing the DTD > and seeing what happens. > > > > At 3:37 PM -0700 8/11/02, Sharon F. Malone wrote: > > >Have a ~major~ problem with one page only, a page that calls > images > > >on the fly (in the lefthand column underneath the navigation). I > > >can't get the images to display. > > > > > > -- > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! ===== var me = tom.pixelmech.webDeveloper(); http://www.pixelmech.com/ http://www.maccaws.com/ [Making A Commercial Case for Adopting Web Standards] __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com From Jonathan_A_McPherson at rl.gov Mon Aug 12 11:27:05 2002 From: Jonathan_A_McPherson at rl.gov (Jonathan_A_McPherson at rl.gov) Date: Mon Aug 12 11:27:05 2002 Subject: [thelist] CSS max-width question. Message-ID: All, I'm designing my first site of any considerable size since I first started frequenting evolt/thelist, and I'm trying to get a table-free layout going... I want my site to be wrapped in a centered box no wider than 800px. (I'm developing this on a 1600x1200 flatscreen, so I'm keenly aware of how unreadable text gets when the lines become longer). I want the box to size to less than 800px if the browser window gets smaller (i.e. if the user doesn't like to browse fullscreen or has a lower-res display -- 800x600, 640x480). "max-width: 800px;" works beautifully in Mozilla -- but in IE, it lets the site expand indefinitely, allowing the lines of text to become almost unreadably long in higher resolutions. "width: 800px;" stops it from expanding, but also constrains it so that it doesn't contract properly in lower resolutions. "width: 75%;" makes it too wide for high resolutions and too narrow at low resolutions. Any suggestions? I'm sure this is a common quandary.. -- Jonathan McPherson, LMIT/SD&I Software Engineer & Web Systems Analyst email / jonathan_a_mcpherson at rl dot gov From contact at hepi.fsnet.co.uk Mon Aug 12 11:41:01 2002 From: contact at hepi.fsnet.co.uk (Jason Hepi) Date: Mon Aug 12 11:41:01 2002 Subject: [thelist] Web Hosting In-Reply-To: <000801c24207$8a2ec380$effea8c0@development.idlenet.com> Message-ID: Chris wrote : > I have a client that is looking for hosting in the UK. They > need a SQLServer database, ASP, and an admin console that allows them to > create user accounts and modify permissions on files and directories > accordingly. Any recommendations would be gratefully received. Chris, The best hosting package I have been able to find is at www.catalyst2.com. They really are very good - ASP, SQL2000, IIS5, MSXML, Register Custom DLL, .Net, mySQL, PHP4, Perl, CGI, lots of email accounts, secure SSL folders and 5000mb packages. Also - if there is a feature that you want and it isn't part of a package I think they'll generally try to sort it out for you. Jason. From roselli at earthlink.net Mon Aug 12 11:58:01 2002 From: roselli at earthlink.net (aardvark) Date: Mon Aug 12 11:58:01 2002 Subject: [thelist] CSS max-width question. In-Reply-To: Message-ID: <200208121656.g7CGuaB4024186@leo.evolt.org> > From: Jonathan_A_McPherson at rl.gov [...] > "max-width: 800px;" works beautifully in Mozilla -- but in IE, it lets > the site expand indefinitely, allowing the lines of text to become > almost unreadably long in higher resolutions. [...] i'm sitcking with that in a few of mine, only because i know the support will come at some point, and the alternatives (as you cite) are unacceptable by either the client or me... -- Read the evolt.org case study Usability: The Site Speaks for Itself http://amazon.com/exec/obidos/ASIN/1904151035/evoltorg02-20 ISBN: 1904151035 From roselli at earthlink.net Mon Aug 12 12:24:20 2002 From: roselli at earthlink.net (aardvark) Date: Mon Aug 12 12:24:20 2002 Subject: [thelist] N6 bug -- form labels overlapping form fields In-Reply-To: <200208121501.g7CF1kB4022139@leo.evolt.org> Message-ID: <200208121708.g7CH8pB4024348@leo.evolt.org> well, i got one reply offlist with a suggestion to just reformat the form... but while tracking down bugs, i think i've narrowed it down a bit thanks to bugzilla: bug #85306, reported June 11, 2001 http://bugzilla.mozilla.org/show_bug.cgi?id=85306 'use of label within th with text-align: right style doesn't render correctly' looks like it was fixed in the august 25, 2001 nightly build, meaning the first milestone/version release that would have seen the fix would have been mozilla 0.9.4, completed Sept. 14, 2001... so, given that information, what versions of Netscape run what versions of mozilla? or what versions of Netscape would have pre- 0.9.3 versions of mozilla under the hood? it seems the
blah blah blah blah
hth, -- ===================================================== Duncan O'Neill "Smith The Reporter" http://homepages.ihug.co.nz/~dbaxo/urban_legend.htm ===================================================== From ben at inchima.com Tue Aug 13 06:23:01 2002 From: ben at inchima.com (Ben Phillips) Date: Tue Aug 13 06:23:01 2002 Subject: [thelist] back web? In-Reply-To: Message-ID: <000801c242bb$b75b0b70$0300a8c0@BS> > can somebody explain what a registry key referring to > *Backweb* means? Which programs use this - the only reference > I see in the multiple keys is to Logitech (mouse and > keyboard). I've made a google search and I don't like what I > read about the company. Is this part of the infiltrating > .exe that dumps code on our machine and channel back some > info? Can I safely delete this. Also there were a couple > other weird entries relating to simcard??? I run XP. download lavasoft's ad-aware: http://www.lsfileserv.com/aaw.html it scans your memory, registry and drives for spyware and zaps most of them. benji inchima.com From jay.blanchard at niicommunications.com Tue Aug 13 06:30:01 2002 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Tue Aug 13 06:30:01 2002 Subject: [thelist] CF: CMS Tips and Tricks? In-Reply-To: <5.1.0.14.2.20020812181219.00a9bd68@mail.interlog.com> Message-ID: <000b01c242bc$c3db4fd0$8102a8c0@000347D72515> [snip] 1) Images in the body of an article. Up to this date, my system permitted one image per article, as defined by a template. I would like to allow the non-technical user to simply choose to upload an image and have it inserted in the middle of an article. (The article is typed or pasted into a large text-area, right now.) How can I have multiple images intermingled with copy, that is not based on a hard coded template? One solution I thought of, but seems a too clumsy to me is to return a 'code' (eg: [[261-2.jpg]] ) and have the user paste it in, but that seems a little complex for some of my users (trust me, they would muck it up). [/snip] If you are maintaining the images (image URL's actually) and the article in a database you could do something such as this; (template pseudo-code, using PHP) \n"); print($Author . "
\n"); print($Image1URL . "
"\n); // first image at top of article $paragraph_break = 1; while(print($ArticleBody)){ if($thisline == double_line_break){ $paragraph_break++; if($paragraph_break == 3){ print($Image2URL . "
\n"); // second image before paragraph 3 } } } ?> I hope this gives you some ideas. Count the paragraph breaks and insert images where you want them between paragraphs. You could also do the sam thing for small images that are "within" paragraphs by counting lines in the body. HTH! Jay From luminosity at members.evolt.org Tue Aug 13 06:37:00 2002 From: luminosity at members.evolt.org (Lachlan Cannon) Date: Tue Aug 13 06:37:00 2002 Subject: [thelist] Mozilla is giving me strange errors Message-ID: <3D58EDF5.9000109@members.evolt.org> Does anyone know why Mozilla isn't displaying my page http://luminosity.f2o.org/thoughts/admin/add/ ? PS Yes I'm aware that not delivering the file as application/xhtml+xml will 'solve' the problem.. I want to know what's causing it, and be able to fix that. Thanks, -- Lach __________________________________________ Web: http://illuminosity.net/ E-mail: lach at illuminosity.net MSN: luminosity @ members.evolt.org __________________________________________ From jay.blanchard at niicommunications.com Tue Aug 13 06:54:01 2002 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Tue Aug 13 06:54:01 2002 Subject: [thelist] CF: CMS Tips and Tricks? In-Reply-To: <000b01c242bc$c3db4fd0$8102a8c0@000347D72515> Message-ID: <000c01c242c0$19f42560$8102a8c0@000347D72515> [snip] I would like to allow the non-technical user to simply choose to upload an image and have it inserted in the middle of an article. [/snip] Dang, I should read this more closely, I missed the point which is allowing the user to choose an image. The pseudo-code I provided before will send you in the right direction for placing the image, but selection is a horse of a different color. Let's say the article has no images associated with it through some ID column between tables. So we want to do this... +---------+ +--------+ +---------+ | Article | | Select | | Output | | Input |---->| Images |---->| Article | | | | | | | +---------+ +--------+ +---------+ Article could be submitted to hidden form fields until images (actually image URL's) are selected and then all can be written to the database. Images could be thumbs with checkboxes or number lists (1st Pic, 2nd Pic, etc.) so that images could be selected independent of the article. Can also serve for update purposes. HTH! Jay From andrew at uk-webdeveloper.co.uk Tue Aug 13 07:06:01 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 07:06:01 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <20020812213217.91322.qmail@web13503.mail.yahoo.com> Message-ID: this is really useful and helped alot, however I had better run this by you. The form I am using already has an email field which I dont want to change, except to add a little tick box next to it. This is the existing form element in form 1.

E-mail Address
E-mail Address
E-mail Address
E-mail Address
> onmouseout="changeBgColor('0000ff');"> > > >
blahblahblahblah
> > > > > hth, ===== var me = tom.pixelmech.webDeveloper(); http://www.pixelmech.com/ http://www.maccaws.com/ [Making A Commercial Case for Adopting Web Standards] __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com From pixelmech at yahoo.com Tue Aug 13 11:17:04 2002 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Tue Aug 13 11:17:04 2002 Subject: [thelist] US based ASP hosting In-Reply-To: Message-ID: <20020813160222.7965.qmail@web12603.mail.yahoo.com> I've had great success with ORCSWEB: www.orcsweb.com Tom --- Norman Beresford wrote: > Hi all > > Could someone recommend some ASP hosting where the servers are in > the US. > It's for a few simple sites, just needs to support SSL for one of > the sites. > Ideally cheap but with good support. > > Norman > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! ===== var me = tom.pixelmech.webDeveloper(); http://www.pixelmech.com/ http://www.maccaws.com/ [Making A Commercial Case for Adopting Web Standards] __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com From framar at interlog.com Tue Aug 13 11:24:01 2002 From: framar at interlog.com (Frank) Date: Tue Aug 13 11:24:01 2002 Subject: [thelist] back web? In-Reply-To: References: <3D563F27.16134.B63ECE0C@localhost> Message-ID: <5.1.0.14.2.20020813121729.00ae7688@mail.interlog.com> At 07:02 AM 8/13/2002 -0400, you wrote: > can somebody explain what a registry key referring to > *Backweb* means? Spy-ware. If you are running some sort of 'free' peer to peer client (such as Kazaa, Audio Galaxy, etc...) This is usually installed without the user's knowledge or consent. May I suggest an excellent piece of software to remove this, and most other spy-ware? http://www.lavasoftusa.com/ Further information on the matter... http://www.simplythebest.net/info/spyware.html http://www.kimsoft.com/kim-spy.htm http://boards.cexx.org/spytech/ http://www.spychecker.com/ Frank Marion framar at interlog.com From Josh.S.Feingold at irs.gov Tue Aug 13 11:37:25 2002 From: Josh.S.Feingold at irs.gov (Feingold Josh S) Date: Tue Aug 13 11:37:25 2002 Subject: [thelist] How does Google access protected sites Message-ID: <67C18A40A655D3119CDD0004ACE530C60541C446@chm0010mb01.atsc.irs.gov> -- [ Picked text/plain from multipart/alternative ] I noticed that Google gets access to sites that usually need a username and password to enter. Does anyone know how Google manages to do this? Josh From Ashok at MagicalKenya.com Tue Aug 13 11:41:27 2002 From: Ashok at MagicalKenya.com (Ashok at MagicalKenya.com) Date: Tue Aug 13 11:41:27 2002 Subject: [thelist] SQL 2000 update statement Message-ID: >Currently, am using this... >Update ProdSummary Set TheTotalOrder = @total where LastName = @last > >I want to update only ONE row that has that LastName.. >From what i can guess you have multiple rows in the table that have the same LastName key, but you would like to update only a single row.... I hope you have an additional unique identifier on each row containing sale information... If you dont maybe this could help you : if your update is done in a stored procedure , you can use the SQL Server 'set rowcount' property to update a single row... for example : if your table is like this : last-name value --------- ------ smith 50 smith 20 johnson 30 jameson 20 normally an update like : update table set value=100 where last-name='smith' will update both the 'smith' rows to the value 100... BUT if you do this within a stored procedure, with a set rowcount: create procedure update_proc as begin --....code.... Set rowcount 1 -- set sql rowcount to 1 update table set value=100 where last-name='smith' Set rowcount 0 -- reset rowcount to all --....more code.... end the command 'set rowcount 0' instructs sql server to return/update just a single row of any subsequent query.... this procedure above will update only a single row containing the last-name 'smith' , the difficult question for you now is , how do you know which 'smith' the query has updated...?! I used Set Rowcount in this way a long time back with SQL Server 4.2 to simulate a sequential cursor....(they didnt have t-sql cursors in that version...) ------ Ashok Hariharan http://www.hazard0us.org ------ From evoltlist at rogers.com Tue Aug 13 11:42:29 2002 From: evoltlist at rogers.com (Ingrid Z) Date: Tue Aug 13 11:42:29 2002 Subject: [thelist] SQL 2000 update statement - thanks References: <01c24274$257d3f80$b2e6059a@rudy> Message-ID: <00ee01c242d7$184bd520$33c52a18@userf1xcwzruul> Thanks Rudy and Paul, Rudy, your suggestion has helped. All I have to do now is re-sort the order before I dump into the text file, so the order total column appears with the orders for that user. The shopping cart will be re-structured anyway, this is an interim solution. Thanks very much, Ingrid > if not, try > > insert into summary (custname, ordertotal) > select custname, sum(orderamt) > from orders > group by custname > > rudy > http://lists.evolt.org Workers of the Web, evolt ! > From Gary at star-chaser.com Tue Aug 13 11:42:38 2002 From: Gary at star-chaser.com (Gary Bland) Date: Tue Aug 13 11:42:38 2002 Subject: [thelist] php add email to a mysql db References: Message-ID: <3D591E11.2020800@star-chaser.com> Andrew Maynes wrote: > nope, now getting... > > Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource > in /usr/home/public_html/demo/order2.php on line 12 > couldn't execute query > > > with > > include("settings.inc"); > > mysql_connect("$dbhost","$dbuser","$dbpass"); > > $$sql = "SELECT email FROM mailinglux WHERE > email='$email'"; > $result=mysql_query($sql); > $num=mysql_numrows($result); > if ($num > 0) > echo "

You are already in our system

"; > else { > > $sql = "INSERT INTO mailinglux(email) VALUES > ('$email')"; > > > $result = mysql_query($sql) or die ("couldn't execute query"); > > > if(!EmailOK($email)) { > > echo "The email address you submitted is not valid."; > > exit; > } > > mysql_db_query($dbname, "insert into mailinglux values('','$email')"); > } > > ---------- > You have a typo $$sql = "SELECT email FROM mailinglux WHERE -- Gary Bland StarChaser Web Architecture http://star-chaser.com Building Tomorrow's World Today From garrett at polytechnic.co.uk Tue Aug 13 11:43:12 2002 From: garrett at polytechnic.co.uk (Garrett Coakley) Date: Tue Aug 13 11:43:12 2002 Subject: [thelist] Mozilla is giving me strange errors In-Reply-To: <20020813150729.68219.qmail@wm1.netfirms.com> References: <20020813150729.68219.qmail@wm1.netfirms.com> Message-ID: <20020813164827.0eee9283.garrett@polytechnic.co.uk> On 13 Aug 2002 15:07:29 -0000 "Pinyo Bhulipongsanon" wrote: (please remember to trim your replies to thelist) > Mozilla does not deal with linked stylesheet well when doing DIV > positioning. You must include the positioning CSS tags inline on the > DIV tag. Do you have a citation or a link to a bugzilla entry for this? Can't say I've ever come across any problems using positioning with a linked stylesheet. G. -- ----------------------------------------------------------------------- WORK: http://www.gencon.co.uk PLAY: http://polytechnic.co.uk From Ashok at MagicalKenya.com Tue Aug 13 11:43:35 2002 From: Ashok at MagicalKenya.com (Ashok at MagicalKenya.com) Date: Tue Aug 13 11:43:35 2002 Subject: [thelist] SQL 2000 update statement Message-ID: >Currently, am using this... >Update ProdSummary Set TheTotalOrder = @total where LastName = @last > >I want to update only ONE row that has that LastName.. >From what i can guess you have multiple rows in the table that have the same LastName key, but you would like to update only a single row.... I hope you have an additional unique identifier on each row containing sale information... If you dont maybe this could help you : if your update is done in a stored procedure , you can use the SQL Server 'set rowcount' property to update a single row... for example : if your table is like this : last-name value --------- ------ smith 50 smith 20 johnson 30 jameson 20 normally an update like : update table set value=100 where last-name='smith' will update both the 'smith' rows to the value 100... BUT if you do this within a stored procedure, with a set rowcount: create procedure update_proc as begin --....code.... Set rowcount 1 -- set sql rowcount to 1 update table set value=100 where last-name='smith' Set rowcount 0 -- reset rowcount to all --....more code.... end the command 'set rowcount 0' instructs sql server to return/update just a single row of any subsequent query.... this procedure above will update only a single row containing the last-name 'smith' , the difficult question for you now is , how do you know which 'smith' the query has updated...?! I used Set Rowcount in this way a long time back with SQL Server 4.2 to simulate a sequential cursor....(they didnt have t-sql cursors in that version...) From pinyo at greatnexus.com Tue Aug 13 11:44:01 2002 From: pinyo at greatnexus.com (Pinyo Bhulipongsanon) Date: Tue Aug 13 11:44:01 2002 Subject: [thelist] US based ASP hosting Message-ID: <20020813151048.47925.qmail@wm3.netfirms.com> On Tue, 13 Aug 2002 07:58:45 -0600, Kid Stevens wrote : > Do you need SSL or ASP? They are not related. > > At 2:20 PM +0100 8/13/02, Norman Beresford wrote: > >Hi all > > > >Could someone recommend some ASP hosting where the servers are in the US. > >It's for a few simple sites, just needs to support SSL for one of the sites. > >Ideally cheap but with good support. > > > >Norman > > > >-- > >For unsubscribe and other options, including > >the Tip Harvester and archive of thelist go to: > >http://lists.evolt.org Workers of the Web, evolt ! > > > -- > Sincerely, > Kid Stevens > > "Liberty cannot be preserved without a general knowledge among the people.... > Let us dare to read, think, speak and write." > -John Adams > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt ! > > > This is a current topic on my forum http://greatnexus.com/edgeboard/index.php?a=topic&forum=3&topic=1 I think the best recommendation so far is to use the search engine at http://www.hostsearch.com/ -- pinyo at greatnexus.com Looking for tutorials and articles on web site development, visit us at http://greatnexus.com While you are there, drop by and join our web community at http://greatnexus.com/edgeboard/ From ben at inchima.com Tue Aug 13 11:44:10 2002 From: ben at inchima.com (Ben Phillips) Date: Tue Aug 13 11:44:10 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: <001201c242d9$141b5ff0$0300a8c0@BS> > $$sql = "SELECT email FROM mailinglux WHERE > email='$email'"; > $result=mysql_query($sql); > $num=mysql_numrows($result); try $sql = "SELECT ... instead of $$sql = "SELECT ... and it's mysql_num_rows not mysql_numrows. benji. From andrew at uk-webdeveloper.co.uk Tue Aug 13 11:44:13 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 11:44:13 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: Message-ID: Thgis has done the job -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Rich Gray Sent: Tuesday, August 13, 2002 11:32 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db You forgot the echo mysql_error() ... and you don't seem to have selected the database ... Try something like this... $link = mysql_connect("$dbhost","$dbuser","$dbpass") or die("Can't connect"); if (mysql_select_db("mydatabase",$link)) { $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); if (mysql_num_rows($result) > 0) echo "

You are already in our system

"; else { if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_query("insert into mailinglux values('$email')"); } } else { echo "Can't select the database"; exit; } -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Andrew Maynes Sent: 13 August 2002 06:46 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db this 'Parse error: parse error, unexpected T_VARIABLE ' is displayed when I put this mysql_error() in and when its out this Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource is displayed this is the code include("settings.inc"); mysql_connect("$dbhost","$dbuser","$dbpass"); $sql = "SELECT email FROM mailinglux WHERE email='$email'"; $result=mysql_query($sql); $num=mysql_numrows($result); if ($num > 0) echo "

You are already in our system

"; else { mysql_error() $sql = "INSERT INTO mailinglux(email) VALUES ('$name')"; if(!EmailOK($email)) { echo "The email address you submitted is not valid."; exit; } mysql_db_query($dbname, "insert into mailinglux values('','$email')"); } Thank you Andrew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From andrew at uk-webdeveloper.co.uk Tue Aug 13 11:44:26 2002 From: andrew at uk-webdeveloper.co.uk (Andrew Maynes) Date: Tue Aug 13 11:44:26 2002 Subject: [thelist] php add email to a mysql db In-Reply-To: <001001c242d6$6cc59d80$0300a8c0@BS> Message-ID: excellent thank you Andrew -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Ben Phillips Sent: Tuesday, August 13, 2002 03:34 To: thelist at lists.evolt.org Subject: RE: [thelist] php add email to a mysql db there are a few syntax errors in the code. i've altered them below: > this is the code: > > include("settings.inc"); > > mysql_connect("$dbhost","$dbuser","$dbpass"); > > $sql = "SELECT email FROM mailinglux WHERE > email='$email'"; > $result=mysql_query($sql); > $num=mysql_numrows($result); mysql_numrows() should be mysql_num_rows(). > if ($num > 0) when using if statements, surround all blocks in curly brackets. so: if ($num > 0) { // do stuff when $num > 0 echo "..."; } else { // do stuff when $num isn't > 0 mysql_error() ... } it's a lot easier to read, for you and for others, and will also make spotting errors easier. benji. inchima.com -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02 From roblgs at cscoms.com Tue Aug 13 11:44:30 2002 From: roblgs at cscoms.com (Rob Schumann) Date: Tue Aug 13 11:44:30 2002 Subject: [thelist] Accessibility and (browser-based) wysiwyg editors Message-ID: <20020813223450-r01010800-a12587a1-0910-0108@210.203.180.27> Hi, I'm constructing a small CMS and have been toying with how to handle in text style changes by the client editing their site content through whatever the given interface turns out to be. The choice seems simple: Develop my own simplified tagging system and allow editing through the standard and