From jcbullas at nildram.co.uk Mon Dec 8 02:58:30 2003 From: jcbullas at nildram.co.uk (John C Bullas (soton.ac.uk relay)) Date: Mon, 08 Dec 2003 08:58:30 +0000 Subject: [thelist] Wanted in Hampshire...... APS > CD transfer In-Reply-To: <3FD37795.1020905@nota-bene.org> References: <6.0.1.1.0.20031206130150.0245bc70@pop3.nildram.co.uk> <3FD37795.1020905@nota-bene.org> Message-ID: <6.0.0.22.0.20031208085507.023d3ba0@pop3.nildram.co.uk> At 06:55 PM 12/7/2003, you wrote: > > >> >>Hope this is not too off topic... barter in return for usage thereof? > >When in doubt, include a tip like this: Why did I get this reply in response to a question seeking a PIECE OF HARDWARE to transfer APS cartridges to CD? (ultimately to deliver a Javascript based on line photo album) Still baffled FB From jcbullas at nildram.co.uk Mon Dec 8 03:20:24 2003 From: jcbullas at nildram.co.uk (John C Bullas (soton.ac.uk relay)) Date: Mon, 08 Dec 2003 09:20:24 +0000 Subject: [thelist] Coding page to auto-download pdf file Message-ID: <6.0.0.22.0.20031208092013.02401008@pop3.soton.ac.uk> At 03:34 AM 12/8/2003, you wrote: >I?ve been searching for this info all night! How do I make a PDF-type text >link where, when clicked, a pdf file I?ve specified automatically downloads >and opens on the person?s screen? like this... http://groups.yahoo.com/group/Practical-HTML/message/234 Useful? Download Page seems to work..... John >Thanks! > >- Jaycinda From rich at f1central.net Mon Dec 8 03:27:11 2003 From: rich at f1central.net (Rich Gray) Date: Mon, 8 Dec 2003 10:27:11 +0100 Subject: [thelist] complicated sql In-Reply-To: Message-ID: [chop] > How do I write a query to retrieve BANDS.band_name, > SHOWINFO.show_date, and > PHOTOS.photo_name? I had this: [chop] I'm no SQL expert but ...how about... select s.show_date,b.band_name,p.photo_name from showinfo as s inner join bands as b on (b.band_id = s.band_id) inner join photos as p on (p.photo_bandid = s.band_id) order by s.show_date HTH Rich From jcbullas at nildram.co.uk Mon Dec 8 03:23:56 2003 From: jcbullas at nildram.co.uk (John C Bullas (soton.ac.uk relay)) Date: Mon, 08 Dec 2003 09:23:56 +0000 Subject: [thelist] Coding page to auto-download pdf file In-Reply-To: References: Message-ID: <6.0.0.22.0.20031208091715.023cc0b0@pop3.nildram.co.uk> At 03:34 AM 12/8/2003, you wrote: >I?ve been searching for this info all night! How do I make a PDF-type text >link where, when clicked, a pdf file I?ve specified automatically downloads >and opens on the person?s screen? like this... http://groups.yahoo.com/group/Practical-HTML/message/234 Useful? Download Page seems to work..... John >Thanks! > >- Jaycinda >-- >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester >and archives of thelist go to: http://lists.evolt.org >Workers of the Web, evolt ! ******************* John C Bullas ************** Transportation Group School of Civil Engineering and the Environment University of Southampton UK **** Eudora Mail 6.0.0.22 + McAfee Virus Scan 4.5.1 **** From jcbullas at nildram.co.uk Mon Dec 8 03:25:40 2003 From: jcbullas at nildram.co.uk (John C Bullas (soton.ac.uk relay)) Date: Mon, 08 Dec 2003 09:25:40 +0000 Subject: [thelist] load external CSS script In-Reply-To: <6.0.0.22.0.20031207113207.01bddb58@mail.godsman.com> References: <003601c3b836$490d0280$0300000a@hershel2000> <3FCBA8CD.7010607@cc.ysu.edu> <6.0.1.1.0.20031201230555.0248ca10@pop3.nildram.co.uk> <6.0.0.22.0.20031207113207.01bddb58@mail.godsman.com> Message-ID: <6.0.0.22.0.20031208091415.023f2a38@pop3.nildram.co.uk> At 06:34 PM 12/7/2003, you wrote: >Does anyone know of a script that will load an external CSS file based on >which browser is being used? I'm not much of a JavaScript expert, and need >a cut and paste solution. > >Thank you. http://www.scriptygoddess.com/archives/001155.php Next! FB http://www.soton.ac.uk/~johnb/webcam/ From koksa.uh at seznam.cz Mon Dec 8 03:28:19 2003 From: koksa.uh at seznam.cz (Tomas Kokoska) Date: Mon, 8 Dec 2003 10:28:19 +0100 Subject: [thelist] complicated sql References: Message-ID: <00a001c3bd6d$9e4a72f0$ca09000a@kukulin> What about JOIN ? SQLQuery = "SELECT s.show_date, b.band_name, p.photo_name FROM showinfo s INNER JOIN bands b ON s.band_id = b.id LEFT JOIN photos p ON s.band_id = p.photo_bandid ORDER BY s.show_date" I have used LEFT JOIN to join photos table presuming you don't have to have photo for each band. Final result depends on data structure (have you just one photo for each band (1:1) or can you have more photos or none?) So, if that query written above wouldn't work how you would expected, try to describe your situation more exactly. Tom > Hey everyone, I have a complicated SQL query but I can't produce the results > that I want... > > I have three tables. it looks something like this: > (the site is for a venue/club) > > BANDS > band_id | band_name > > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, and > PHOTOS.photo_name? I had this: > > SQLQuery = "select * from showinfo, bands, photos where (bands.band_id = > photos.photo_bandid and showinfo.band_id = bands.band_id) order by > showinfo.show_date" > > But that didn't quite work... > > Any ideas what I'm doing wrong? I'd really appreciate the help. > > Thanks! > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From tonyc at boldfish.co.uk Mon Dec 8 03:36:07 2003 From: tonyc at boldfish.co.uk (Tony Crockford) Date: Mon, 08 Dec 2003 09:36:07 -0000 Subject: [thelist] site check please In-Reply-To: <3FD3E86D.9070104@teltest.com> References: <3FD3E86D.9070104@teltest.com> Message-ID: On Mon, 08 Dec 2003 15:56:45 +1300, Paul Bennett wrote: > The visuals were designed by a local design company and I am concerned > with some css breaking in browsers I can't test for, as well as long > download times for some of the background images. > (feedback from non New Zealand people on dial-up would be great) > *Any* feedback is appreciated Layout is broken in Opera 7.23 on WinXP - I can screenshot if you want it. I'm on ADSL and some of the pages take a while to come together. (esp international students!) - dial up will be worse for sure. http://www.webpageanalyzer.com/ suggests a load time for that page of around 25 seconds, plus build time. (built in test in Firebird - hope your search results don't get screwed) on that page you've one gif for each flag - could they not be combined? Your CSS could have more shorthand td.courseDescTitle { background-color: #e0e8ec; font-weight: bold; font-family: verdana, sans-serif; font-size: 11px; } could become: td.courseDescTitle { background: #E0E8EC; font: bold 11px verdana, sans-serif; } and you'd shave a few bytes by dropping the px of the zero values ;o) On a personal taste note, I didn't like to see the people's heads cut off. It took a while to get used to the navigation made a little worse by the graphics flashing in on every page, can't some of the image be common to all pages? (I see why it isn't but loading a different 64 k image at each level?) I'd split it into the header background and the side menu background. Hmm. must. do. work. hth Tony From timmee at timmee.org Mon Dec 8 04:20:16 2003 From: timmee at timmee.org (timmee) Date: Mon, 8 Dec 2003 12:20:16 +0200 Subject: [thelist] site check please References: <3FD3E86D.9070104@teltest.com> Message-ID: <002901c3bd74$e2877510$2900005a@mint.co.za> ----- Original Message ----- From: "Paul Bennett" To: Sent: Monday, December 08, 2003 4:56 AM Subject: [thelist] site check please > http://www.teltest.co.nz/r.php I am on a laptop running XP. On the home page I see some ugly JPEG artifacts on the student photo and the red text. The backgrounds do take forever to download (compared to the rest of the site). Why do the backgrounds need to be so wide that my browser scrolls horisontally? I am on 1024 x 768 res. The horisontal scrolling does not appear on all pages (not on the domestic application form, for instance. it does occur on the careers.php page). Timmee From richard.bennett at skynet.be Mon Dec 8 04:18:38 2003 From: richard.bennett at skynet.be (Richard Bennett) Date: Mon, 8 Dec 2003 11:18:38 +0100 Subject: [thelist] site check please References: <3FD3E86D.9070104@teltest.com> Message-ID: <043a01c3bd74$a58b4650$2a00000a@PORTABLE> Hi, We have a site preparing to go live soon and I would like some usability / download / rendering feedback from people on Os's and browsers inaccessible to us. The site has emerged successfully from a round of independent student-based usability testing and has been tested visually in IE 5 Mac, IE 6, Mozilla / Phoenix, NS6, Opera 7 --> Basically it seems to work ok, and fast enough. I was suprised that the font-size couldn't be varied in ie6 (ctrl+mousewheel) on the inside pages though, as it was definately too small for people with bad eyesight or large monitors/resolutions. I'm not so mad about the splashpage either, it's kind of inconsistant with the rest, and out of balance. The woman with her head chopped off really jars somewhere, the 'International Students' foto looks much more enhancing, even with their cheesy grins :o) Personally I would have gone for either fixed-width, centered on the page, or liquid design. This is liquid top, with fixed-width content, giving a slightly disjointed CMS-look, especially at large browser size. I'm not all that keen on the olive coloured thatch either, wouldn't a different color have livened it up a bit, and complemented the blue and red better? It worked fine in all browsers I tried, with or without javascript, flash etc, and was usable on opera's PDA simulator. HTH Richard. From thelist at meidomus.com Mon Dec 8 04:17:45 2003 From: thelist at meidomus.com (Burhan Khalid) Date: Mon, 08 Dec 2003 13:17:45 +0300 Subject: [thelist] dilemmas with php_self In-Reply-To: <000101c3bb69$78780e80$a4e8020a@direcway.com> References: <000101c3bb69$78780e80$a4e8020a@direcway.com> Message-ID: <3FD44FC9.7070101@meidomus.com> Direcway wrote: > A novice question here: > > I have a page with 2 drop down list boxes. One for states and one for > cities. > > Selections made in the state list box accesses the database and populates > the second drop down list box with cities. > > I'm using php_self as the form action to do this and everything works just > fine ... > accept, I am unable to call the next page in the series after the > user makes a selection in the second drop > down list. > > It seems that once I've used the ACTION=$HTTP_SERVER_VARS['PHP_SELF'], I'm > stuck with it and unable to access the next page using the action attribute > for the second form control. I've tried a number of different modifications > like using conditional if(s) to select for different form action attributes > after the first selection is made without success. I guess I just don't > understand what's going on here. What do I have to do to access the next > page and successfully pass my variables for city and state? A few ways you can approach this. The javascript way : When the user selects from the second drop down, change the form's action attribute to wherever you want it to send, then append the values as a get request (action ="?state=TX&city=Austin"). You can access the selected value of the dropdown using javascript and dom. The PHP way : Create a session [ http://www.php.net/session ] and then load the variables into that session. If the both the variables have been loaded, then you can use header [ http://www.php.net/header ] to redirect to your next page. ( if you can post some code that you've been working with, that would be great ) Warmly, -- Burhan Khalid thelist[at]meidomus[dot]com http://www.meidomus.com ----------------------- "Documentation is like sex: when it is good, it is very, very good; and when it is bad, it is better than nothing." From psm2713 at hotmail.com Mon Dec 8 05:07:11 2003 From: psm2713 at hotmail.com (Ken Moore) Date: Mon, 08 Dec 2003 04:07:11 -0700 Subject: [thelist] complicated sql Message-ID: Hi all, Comitque wrote: >Hey everyone, I have a complicated SQL query but I can't produce the >results >that I want... So, what so you want? Ken >I have three tables. it looks something like this: >(the site is for a venue/club) > >BANDS >band_id | band_name > >SHOW INFO >show_id | show_date | band_id (same id as the bands.band_id) > >PHOTOS >photo_id | photo_name | photo_bandid (same id as the bands.band_id) > >How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, and >PHOTOS.photo_name? I had this: > >SQLQuery = "select * from showinfo, bands, photos where (bands.band_id = >photos.photo_bandid and showinfo.band_id = bands.band_id) order by >showinfo.show_date" > >But that didn't quite work... > >Any ideas what I'm doing wrong? I'd really appreciate the help. > >Thanks! _________________________________________________________________ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx From j.dobson at find-a-part.com Mon Dec 8 05:55:04 2003 From: j.dobson at find-a-part.com (John Dobson) Date: Mon, 8 Dec 2003 11:55:04 -0000 Subject: [thelist] robots.txt and subdomains Message-ID: Hello all We have several subdomains set up that we do not want indexed by the SE's. For example http://abc.foo.com http://def.foo.com http://ghi.foo.com these collectively point at a single subfolder on the site /root/foobar/specialform.asp so that http://abc.foo.com/specialform.asp http://def.foo.com/specialform.asp etc resolve I want to make sure that all the files in the foobar folder are not indexed. Do I need to put a robots.txt in both the root folder for the main site and another robots.txt in the foobar folder? I know that you are only meant to have one robots.txt, but the foobar folder/specialform and the main site are navigationally isolated from each other. I want to get this right, because likewise I do not want to stop our main site http://www.foo.com being indexed, especially as there are files with the same page name in both locations. My feeling is to place robots.txt in foobar folder that disallows all from everything. like... User-agent: * Disallow: / And to have one in the root folder for the main site such as... User-agent: * Disallow: Is this right? Can anyone help with this? TIA John Dobson From darren at web-bitch.co.uk Mon Dec 8 06:04:43 2003 From: darren at web-bitch.co.uk (darren) Date: Mon, 8 Dec 2003 12:04:43 +0000 Subject: [thelist] SQL apostrophe disorder In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B45A1D8F@ireland.spinhead.com> References: <72E9FAA171D63B48AAC707C72900E6B45A1D8F@ireland.spinhead.com> Message-ID: <798540218.20031208120443@web-bitch.co.uk> On Sunday, December 7, 2003 at 02:17, Joel D Canfield wrote: JDC> I'm accessing an app's stored procedure to write our HelpDesk requests JDC> direct to the MSSQL db. I just can't seem to get the apostrophical fix JDC> right. hokay, i think this is it..... set @columns = 'WO_NUM, PARENTWOID, WOID, TASK, TYPE, REQUEST, REQDATE, OPENBY, OPENDATE, MODIBY, MODIDATE, CLSDBY, CLSDDATE, ELAPSETIME, ELAPSEMIN, PRIORITY, DUEDATE, RESPONS, ASSNDATE, COMPLETED, HOURS, RATE, CHARGE, WS_NUM, DEPT_NUM, DEPT, PHONE, PHONE_EXT, LOCATION, DESCRIPT, WO_TEXT1, WO_TEXT2, WO_TEXT3, WO_TEXT4, WO_TEXT5, WO_TEXT6, WO_DATE1, WO_DATE2, WO_NUM1, WO_INT1, NOTE, FT, COMPFLAG, STATUS, AGENTDATE, AGENTLEVEL, AWS_NUM, LOOKUP1, LOOKUP2, GUIDO, EMAILADDR, USERID, WOTYPE2, WOTYPE3' set @values = ' ''apostrophe between one and two 1''''2'', ''Non-PX2'', ''Canfield, Joel'', ''12/2/03 1:12:01 PM'', ''web'', ''12/2/03 1:12:01 PM'', ''web'', ''12/2/03 1:12:01 PM'', NULL, NULL, NULL, NULL, ''99 - FYI'', ''3/10/04 1:12:01 PM'', ''HelpDesk'', ''12/2/03 1:12:01 PM'', NULL, NULL, ''0'', ''0'', NULL, NULL, NULL, NULL, NULL, NULL, ''Repeatability: AlwaysDescription: apostrophe between three and four 3''''4'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''0'', NULL, ''Pending'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''Computer'', '''' ' exec @rc = spAddTask @columns, @values, @WorkOrderNumber OUTPUT you might need to check the proc so that brackets are put around the columns field in the exec: EXEC ('INSERT INTO TASKS (' + @Columns + ') VALUES (' + @WO2 + @Values + ')' ) as it was throwing an error on my mssql2k without them. also make sure @wo2 is being populated correctly. it may be null, due to the @workOrderNumber being null. hth, darren. From joshua at waetech.com Mon Dec 8 07:52:10 2003 From: joshua at waetech.com (Joshua Olson) Date: Mon, 8 Dec 2003 08:52:10 -0500 Subject: [thelist] complicated sql References: Message-ID: <0f5701c3bd92$7a1f1c80$0300a8c0@client1> ----- Original Message ----- From: "Comitque" Sent: Sunday, December 07, 2003 10:28 PM > BANDS > band_id | band_name > > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, and > PHOTOS.photo_name? I had this: > > SQLQuery = "select * from showinfo, bands, photos where (bands.band_id = > photos.photo_bandid and showinfo.band_id = bands.band_id) order by > showinfo.show_date" Hello, There is a problem with this structure that will keep you from being able to return all this information in one *logical* query. >From this structure, you have bands, shows that the band is in, and pictures of the band. The pictures are not really for any particular show. Therefore, a single query to return all the information doesn't really apply here. If the pictures were for single shows, then you would need to add show_id to the PHOTOS table, and then you could do something like this: SELECT BANDS.band_name, SHOWINFO.show_date, PHOTOS.photo_name FROM BANDS INNER JOIN SHOWINFO ON SHOWINFO.band_id = BANDS.band_id INNER JOIN PHOTOS ON PHOTOS.band_id = BANDS.band_id AND PHOTOS.show_id = SHOWINFO.show_id ORDER BY SHOWINFO.show_date If a band didn't have photos for a particular show, but the band was in the show, then the above query would return nothing. If you want a record if the band was in the show EVEN IF there are no available photos, then you could try: SELECT BANDS.band_name, SHOWINFO.show_date, PHOTOS.photo_name FROM BANDS INNER JOIN SHOWINFO ON SHOWINFO.band_id = BANDS.band_id LEFT OUTER JOIN PHOTOS ON PHOTOS.band_id = BANDS.band_id AND PHOTOS.show_id = SHOWINFO.show_id ORDER BY SHOWINFO.show_date Good luck, From rob.smith at THERMON.com Mon Dec 8 08:29:13 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Mon, 8 Dec 2003 08:29:13 -0600 Subject: [thelist] complicated sql Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E5258@smtmb.tmc.local> Hey, > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, > and PHOTOS.photo_name? I had this: I would have written your Sql query a little bit different. May help.. SQLQuery = "select b.band_name, s.show_date, p.photo_name from showinfo s, bands b, photos p where b.band_id = p.photo_bandid and s.band_id = b.band_id Order by s.show_date" Let us know, Rob p.s. if this doesn't work, you may want to check your primary/foreign keys, also the data itself. From john at johnallsopp.co.uk Mon Dec 8 09:12:00 2003 From: john at johnallsopp.co.uk (john at johnallsopp.co.uk) Date: Mon, 8 Dec 2003 10:12:00 -0500 (EST) Subject: [thelist] table height: 100% with CSS Message-ID: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> Hi Maybe I'm having a stupid moment, but I can't see how to make a table 100% high in CSS. I'm trying to make a manual form that looks sensible onscreen but which prints three columns so the user can print and fill out by hand. Without putting loads of
s in I can't see how to make the table a full page deep. Any clues? Cheers J From mail at webmarketingworx.com Mon Dec 8 09:08:21 2003 From: mail at webmarketingworx.com (Bill Haenel) Date: Mon, 8 Dec 2003 10:08:21 -0500 Subject: [thelist] PHP GD library Message-ID: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Anyone here have any experience in using GD to create good quality thumbnails? I have attempted it and the results are fair to poor. My professional photographer client will not be satisfied with less than good to excellent. I have also attempted to resize images to larger sizes, and although the results are a bit better than the thumbnails, they are at least slightly less than acceptable in several cases. PHP Version is 4.2.3 GD Version is 1.6.2 Advice? Thanks, Bill Haenel From john at videoisland.com Mon Dec 8 09:08:24 2003 From: john at videoisland.com (John Handelaar) Date: Mon, 8 Dec 2003 15:08:24 -0000 Subject: [thelist] Wanted in Hampshire...... APS > CD transfer In-Reply-To: <6.0.0.22.0.20031208085507.023d3ba0@pop3.nildram.co.uk> Message-ID: > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org]On Behalf Of John C Bullas > (soton.ac.uk relay) > Sent: 08 December 2003 08:59 > To: thelist at lists.evolt.org > Subject: Re: [thelist] Wanted in Hampshire...... APS > CD transfer > > At 06:55 PM 12/7/2003, you wrote: > > > > > >> > >>Hope this is not too off topic... barter in return for usage thereof? > > > >When in doubt, include a tip like this: > > > > Why did I get this reply in response to a question seeking a PIECE OF > HARDWARE to transfer APS cartridges to CD? > (ultimately to deliver a Javascript based on line photo album) > > Still baffled John, Because, as a matter of courtesy, thelist has a long-standing tradition of including an on-topic web-development-related tip of some kind to 'pay' for your maybe-off-topic post. It's how we keep the signal to noise ratio here as high as possible. However, I (and I hope everyone else) fully accept that since you're a relatively recent arrival, nobody told you before, so fair enough -- but please remember in future :-) Evolt.org's list server is also home to the spiffy CSS-specific list CSS-d, managed by Eric Meyer. To sign up to it, go to that list's page here: http://www.css-discuss.org And please read the introduction before subscribing. Meantime, tips please from anyone insisting on continuing this thread - though ideally please reply to John offlist. jh On behalf of evolt.org From Jono at brookgroup.com Mon Dec 8 09:08:32 2003 From: Jono at brookgroup.com (Jono Young) Date: Mon, 08 Dec 2003 10:08:32 -0500 Subject: [thelist] Illustrator to Photoshop color shift; slightly ot. In-Reply-To: <000501c3bca1$6c3dc590$e7b80a18@family5wkvnahw> Message-ID: I have run into this problem before, but only with graphics created by other people. Here are some things I do to fix the problem: 1. Make sure both your Illustrator Documents and Photoshop document are set to RGB, or CMYK color. 2. In Illustrator, go to Edit wrote: > I create a graphic in Illustrator 8, I move it over to photoshop 7 and I get > a funky washed out color shift. Why is this and how can I correct this? -- Jono Young Designer/Illustrator From joel at spinhead.com Mon Dec 8 09:16:27 2003 From: joel at spinhead.com (Joel D Canfield) Date: Mon, 8 Dec 2003 07:16:27 -0800 Subject: [thelist] complicated sql Message-ID: <72E9FAA171D63B48AAC707C72900E6B47450@ireland.spinhead.com> > How do I write a query to retrieve BANDS.band_name, > SHOWINFO.show_date, and PHOTOS.photo_name? I had this: You need a join: select bands.band_name , showinfo.show_date , photos.photo_name from bands left join showinfo on bands.band_id = showinfo.band_id left join photos on bands.band_id = photos.photo_bandid (and you could include filtering:) where bands.band_name = 'Shellshock Rome' and showinfo.show_date between #2004-02-07# and #2004-04-30# You can write it all out on one line as: select bands.band_name , showinfo.show_date , photos.photo_name from bands left join showinfo on bands.band_id = showinfo.band_id left join photos on bands.band_id = photos.photo_bandid but I've grown fond of rudy's layout for easy troubleshooting joel From roselli at earthlink.net Mon Dec 8 09:42:58 2003 From: roselli at earthlink.net (aardvark) Date: Mon, 8 Dec 2003 10:42:58 -0500 Subject: [thelist] load external CSS script In-Reply-To: <6.0.0.22.0.20031207113207.01bddb58@mail.godsman.com> References: <6.0.1.1.0.20031201230555.0248ca10@pop3.nildram.co.uk> Message-ID: > From: ".:: godsman ::." > > Does anyone know of a script that will load an external CSS file based > on which browser is being used? I'm not much of a JavaScript expert, > and need a cut and paste solution. what about using assorted CSS hacks to hide the CSS from certain browsers? for instance, you can use the @import directive to bring styles into a page, but since NN4.x doesn't support it, you can use it bring in styles that would hose NN4.x (padding, margin, line-height, etc.)... the CSS-D wiki has some good links: Browser Detection: http://css-discuss.incutio.com/?page=BrowserDetection CSS Hacks: http://css-discuss.incutio.com/?page=CssHacks -- my latest book project: Web Graphics for Non-Designers http://www.amazon.com/exec/obidos/ASIN/1590591712/evoltorg02-20 ISBN: 1590591712 From frank at frankmarion.com Mon Dec 8 01:26:48 2003 From: frank at frankmarion.com (Frank) Date: Mon, 08 Dec 2003 02:26:48 -0500 Subject: [thelist] JS: Rounding floats Message-ID: <6.0.0.22.2.20031208021433.06aa4bf0@127.0.0.1> I'm trying to "dollar format" some calculated floats. I'm currently using this // Rounds number to x decimal places, defaults to 2 function round_num(number,x) { x = (!x ? 2 : x); return Math.round(number*Math.pow(10,x))/Math.pow(10,x); } The downside is that if the calculation turns out to end in a zero, the zero is omitted. Thus 5.00 = 5 1.50 = 1.5 Does anyone have a very tight and concise manner of either padding for the dollar-format display? -- Frank Marion From webdev at mountain.ch Mon Dec 8 02:31:28 2003 From: webdev at mountain.ch (Mark Howells) Date: Mon, 8 Dec 2003 09:31:28 +0100 Subject: [thelist] load external CSS script In-Reply-To: <6.0.0.22.0.20031207113207.01bddb58@mail.godsman.com> References: <003601c3b836$490d0280$0300000a@hershel2000> <3FCBA8CD.7010607@cc.ysu.edu> <6.0.1.1.0.20031201230555.0248ca10@pop3.nildram.co.uk> <6.0.0.22.0.20031207113207.01bddb58@mail.godsman.com> Message-ID: > Does anyone know of a script that will load an external CSS file based > on which browser is being used? I'm not much of a JavaScript expert, > and need a cut and paste solution. Wouldn't it just be easier to code the CSS so that it works in all the browsers? It's not that difficult, if you accept that the site may look marginally different across different browsers. Best regards Mark Howells http://www.mark.ac/ From J.C.Bullas at soton.ac.uk Mon Dec 8 03:19:47 2003 From: J.C.Bullas at soton.ac.uk (John C Bullas (TRG: Univ. of Southampton)) Date: Mon, 08 Dec 2003 09:19:47 +0000 Subject: [thelist] Coding page to auto-download pdf file In-Reply-To: References: Message-ID: <6.0.0.22.0.20031208091715.023cc0b0@pop3.nildram.co.uk> At 03:34 AM 12/8/2003, you wrote: >I?ve been searching for this info all night! How do I make a PDF-type text >link where, when clicked, a pdf file I?ve specified automatically downloads >and opens on the person?s screen? like this... http://groups.yahoo.com/group/Practical-HTML/message/234 Useful? Download Page seems to work..... John >Thanks! > >- Jaycinda >-- >* * Please support the community that supports you. * * >http://evolt.org/help_support_evolt/ > >For unsubscribe and other options, including the Tip Harvester >and archives of thelist go to: http://lists.evolt.org >Workers of the Web, evolt ! ******************* John C Bullas ************** Transportation Group School of Civil Engineering and the Environment University of Southampton Highfield SOUTHAMPTON SO17 1BJ Tel +44 (0)2380 59 2192 Fax +44 (0) 2380 59 3152 Homepage: http://www.soton.ac.uk/~johnb/ Blog: http://freeroller.net/page/johnbullas/Weblog **** Eudora Mail 6.0.0.22 + McAfee Virus Scan 4.5.1 **** From abhayk at netsolutionsindia.com Mon Dec 8 03:59:23 2003 From: abhayk at netsolutionsindia.com (Abhay S. Kushwaha) Date: Mon, 8 Dec 2003 15:29:23 +0530 Subject: [thelist] site check please In-Reply-To: <3FD3E86D.9070104@teltest.com> References: <3FD3E86D.9070104@teltest.com> Message-ID: <20031208152923.00003bfb.abhayk@netsolutionsindia.com> Hi Paul: Couldn't take a good look but I noticed the background stopped after a while in the longer pages (ex: Electronic Resources in Library) and the rest of the page had a plain white background. (Moz 1.5, Win2k3). [abhay] On Mon, 08 Dec 2003 15:56:45 +1300, Paul Bennett wrote: > http://www.teltest.co.nz/r.php From neirynck at kristof.f2o.org Mon Dec 8 08:36:35 2003 From: neirynck at kristof.f2o.org (Kristof Neirynck) Date: Mon, 8 Dec 2003 15:36:35 +0100 (CET) Subject: [thelist] complicated sql In-Reply-To: References: Message-ID: <65005.193.190.147.133.1070894195.squirrel@f2o.org> > I have three tables. it looks something like this: > (the site is for a venue/club) > > BANDS > band_id | band_name > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, > and PHOTOS.photo_name? 1. Look at your tables again. The data you're looking for is not stored in them. There is no way to link a picture to a band and a show. 2. Alter the database bands : id (PK), name shows : id (PK), date photos : id (PK), name, band (FK), show (FK) 3. Set up a new query. SELECT b.name , s.date , p.name FROM bands AS b , shows AS s , photos AS p WHERE s.id = p.show AND b.id = p.band ORDER BY shows.date; 4. Test it. I didn't, so it might be flawed. -- Kristof From MPlunkett at MSA.com Mon Dec 8 09:51:19 2003 From: MPlunkett at MSA.com (Plunkett, Matt) Date: Mon, 8 Dec 2003 10:51:19 -0500 Subject: [thelist] complicated sql Message-ID: > BANDS > band_id | band_name > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, and > PHOTOS.photo_name? I had this: > SQLQuery = "select * from showinfo, bands, photos where (bands.band_id = > photos.photo_bandid and showinfo.band_id = bands.band_id) order by > showinfo.show_date" > But that didn't quite work... I don't see any reason for your SQL not to work as written (except that I would suggest explicitly naming only the columns you want selected)...how is it not working? From poohbear at designshift.com Mon Dec 8 10:50:51 2003 From: poohbear at designshift.com (Sarah Sweeney) Date: Mon, 08 Dec 2003 12:50:51 -0400 Subject: [thelist] ASP/JScript/SQL Server and date formatting Message-ID: <3FD4ABEB.1070802@designshift.com> I am working on a site using ASP and JScript. I have a page where I am trying to output a list of events which are saved in an SQL Server database. I want to use some JScript date functions (e.g. getDay(), getMonth(), etc) on the date as it is returned from the database, but it seems that JScript doesn't like the format the date is returned in. If I output "typeof mydate", it returns "date", but if I try to output "mydate.getMonth()", I get the error message "'mydate' is null or not an object". Does anyone know how I can get past this? TIA Sarah From Tab.Alleman at MetroGuide.com Mon Dec 8 11:01:11 2003 From: Tab.Alleman at MetroGuide.com (Tab Alleman) Date: Mon, 8 Dec 2003 12:01:11 -0500 Subject: [thelist] SQL apostrophe disorder Message-ID: Joel D Canfield wrote: > I'm accessing an app's stored procedure to write our HelpDesk requests > direct to the MSSQL db. I just can't seem to get the apostrophical fix > right. > > It fails with an error about 2 not being a valid something or other; > obviously, it's not working with the double apostrophes. Doesn't work > with single or triple, either. > > Am I missing an obvious escape mechanism for single quotes? Are these > quoted right? > My WAG would be that you should replace: '''apostrophe between one and two 1''2'', With ''apostrophe between one and two 1'''2'' > > ------------------------------ > Data I'm sending: > > DECLARE @RC int; > DECLARE @Columns varchar(4000); > DECLARE at WorkOrderNumber int; > EXEC @RC = spAddTask '(WO_NUM, PARENTWOID, WOID, TASK, TYPE, REQUEST, > REQDATE, OPENBY, OPENDATE, MODIBY, MODIDATE, CLSDBY, CLSDDATE, > ELAPSETIME, ELAPSEMIN, PRIORITY, DUEDATE, RESPONS, ASSNDATE, > COMPLETED, HOURS, RATE, CHARGE, WS_NUM, DEPT_NUM, DEPT, PHONE, > PHONE_EXT, LOCATION, DESCRIPT, WO_TEXT1, WO_TEXT2, WO_TEXT3, > WO_TEXT4, WO_TEXT5, WO_TEXT6, WO_DATE1, WO_DATE2, WO_NUM1, WO_INT1, > NOTE, FT, COMPFLAG, STATUS, AGENTDATE, AGENTLEVEL, AWS_NUM, LOOKUP1, > LOOKUP2, GUIDO, EMAILADDR, USERID, WOTYPE2, WOTYPE3)', '''apostrophe > between one and two 1''2'', ''Non-PX2'', ''Canfield, Joel'', > ''12/2/03 1:12:01 PM'', ''web'', ''12/2/03 1:12:01 PM'', ''web'', > ''12/2/03 1:12:01 PM'', NULL, NULL, NULL, NULL, ''99 - FYI'', > ''3/10/04 1:12:01 PM'', ''HelpDesk'', ''12/2/03 1:12:01 PM'', NULL, > NULL, ''0'', ''0'', NULL, NULL, NULL, NULL, NULL, NULL, > ''Repeatability: AlwaysDescription: apostrophe between three and four > 3''4'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, > NULL, ''0'', NULL, ''Pending'', NULL, NULL, NULL, NULL, NULL, NULL, > NULL, NULL, ''Computer'', ''''', @WorkOrderNumber OUTPUT > > ------------------------------------------------------------------------ > ---------------------- > > CREATE PROCEDURE [dbo].[spAddTask] > /********************************************************************* > ** PURPOSE: > ** This stored procedure is used to get and increment the work > ** order number and add a task. > ** > ** TABLES/VIEWS USED: > ** TASKS > ** PARAMETERS: > ** @Columns = Contains the column list > ** @Values = Contains the column values > ** @WorkOrderNumber = Used to return the work order number > ** RETURNS: > ** None > ** EXAMPLE: > ** EXEC spAddTask ,, > ** VERSION REVISION DATE AUTHOR COMMENTS > ** 1.0 01/10/2002 Frank Picardi Created > **********************************************************************/ > @Columns varchar(4000) > , at Values text > , at WorkOrderNumber int = NULL OUTPUT > AS > > DECLARE > @WO2 varchar(16), > @WOID int > SET NOCOUNT ON > -- Get the next work order number and update counter > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE > BEGIN TRANSACTION > UPDATE LASTHD SET LAST = LAST + 1 > SELECT @WorkOrderNumber = LAST > FROM LASTHD > UPDATE LASTWOID SET LASTWOID = LASTWOID + 1 > SELECT @WOID = LASTWOID FROM LASTWOID > > SELECT @WO2 = convert(varchar(15), @WorkOrderNumber) + ',' + > convert(varchar(15), @WOID) + ',' > + convert(varchar(15), @WOID) + ',' > EXEC ('INSERT INTO TASKS ' + @Columns > + ' VALUES (' + @WO2 + @Values+ ')' ) > > --SELECT @@ERROR > COMMIT TRANSACTION > SET TRANSACTION ISOLATION LEVEL READ COMMITTED > SET NOCOUNT OFF > > GO > > ------------------------------------------------------------------------ > ---------------------- > > CREATE TABLE [dbo].[TASKS] ( > [WO_NUM] [int] NOT NULL, > [TASK] [varchar] (50), > [TYPE] [varchar] (30), > [REQUEST] [varchar] (30), > [REQDATE] [datetime] NULL, > [OPENBY] [varchar] (255), > [OPENDATE] [datetime] NULL, > [MODIBY] [varchar] (255), > [MODIDATE] [datetime] NULL, > [CLSDBY] [varchar] (15), > [CLSDDATE] [datetime] NULL, > [ELAPSETIME] [varchar] (20), > [ELAPSEMIN] [int] NULL, > [PRIORITY] [varchar] (30), > [DUEDATE] [datetime] NULL, > [RESPONS] [varchar] (30), > [ASSNDATE] [datetime] NULL, > [COMPLETED] [datetime] NULL, > [HOURS] [float] NULL, > [RATE] [float] NULL, > [CHARGE] [float] NULL, > [WS_NUM] [int] NULL, > [DEPT_NUM] [varchar] (30), > [DEPT] [varchar] (30), > [PHONE] [varchar] (30), > [PHONE_EXT] [varchar] (8), > [LOCATION] [varchar] (30), > [DESCRIPT] [text], > [WO_TEXT1] [varchar] (40), > [WO_TEXT2] [varchar] (40), > [WO_TEXT3] [varchar] (40), > [WO_TEXT4] [varchar] (40), > [WO_TEXT5] [varchar] (40), > [WO_TEXT6] [varchar] (40), > [WO_DATE1] [datetime] NULL, > [WO_DATE2] [datetime] NULL, > [WO_NUM1] [float] NULL, > [WO_INT1] [int] NULL, > [NOTE] [text], > [FT] [bit] NULL, > [COMPFLAG] [varchar] (30), > [STATUS] [varchar] (25), > [AGENTDATE] [datetime] NULL, > [AGENTLEVEL] [tinyint] NULL, > [AWS_NUM] [varchar] (40), > [LOOKUP1] [varchar] (30), > [LOOKUP2] [varchar] (30), > [GUIDO] [varchar] (40), > [EMAILADDR] [varchar] (100), > [USERID] [int] NULL, > [PARENTWOID] [int] NULL, > [WOID] [int] NULL, > [WOTYPE2] [varchar] (30), > [WOTYPE3] [varchar] (30) > ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] > GO From mlist at nykris.com Mon Dec 8 11:30:11 2003 From: mlist at nykris.com (mlist) Date: Mon, 8 Dec 2003 17:30:11 -0000 Subject: [thelist] Printing in Mozilla 1.4 Message-ID: Hi, Wonder if anyone can help. I've got a page - see attached - that if you try to print in Mozilla 1.4 (Windows, Mac, Linux) it crops the page and only prints the one page. Try the attached page - anyone got any ideas as to how to fix this so Mozilla prints OK? Thanks, M From stef at nota-bene.org Mon Dec 8 11:50:23 2003 From: stef at nota-bene.org (s t e f) Date: Mon, 08 Dec 2003 18:50:23 +0100 Subject: [thelist] Wanted in Hampshire...... APS > CD transfer In-Reply-To: <6.0.0.22.0.20031208085507.023d3ba0@pop3.nildram.co.uk> References: <6.0.1.1.0.20031206130150.0245bc70@pop3.nildram.co.uk> <3FD37795.1020905@nota-bene.org> <6.0.0.22.0.20031208085507.023d3ba0@pop3.nildram.co.uk> Message-ID: <3FD4B9DF.40407@nota-bene.org> > > > Why did I get this reply in response to a question seeking a PIECE OF > HARDWARE to transfer APS cartridges to CD? > (ultimately to deliver a Javascript based on line photo album) > > Still baffled John, I just realised that replying to you offlist wasn't such a good idea since you may not be the only one to wonder. The story is: you asked for APS-to-CD hardware, and said you hoped you were not too off-topic, and if so what was the "barter in return for usage thereof". I then replied to this question by explaining how one pays back for off-topic, by giving a tip to thelist. Now that I'm at home (and looked into my dictionary) it seems like "barter" is to be understood as its first meaning, actual exchange for one good with another. I hope this makes my response clearer. Keep in mind that english is not (like many thelist contributors) my native language, so please just don't go "I'm baffled" too often on us poor strangers ;-) -- s t e f http://www.nota-bene.org/ From k.neirynck at belgacom.net Mon Dec 8 12:23:04 2003 From: k.neirynck at belgacom.net (Kristof Neirynck) Date: Mon, 08 Dec 2003 19:23:04 +0100 Subject: [thelist] complicated sql In-Reply-To: References: Message-ID: <3FD4C188.7050300@belgacom.net> > I have three tables. it looks something like this: > (the site is for a venue/club) > > BANDS > band_id | band_name > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, > and PHOTOS.photo_name? 1. Look at your tables again. The data you're looking for is not stored in them. There is no way to link a picture to a band and a show. 2. Alter the database bands : id (PK), name shows : id (PK), date photos : id (PK), name, band (FK), show (FK) 3. Set up a new query. SELECT b.name , s.date , p.name FROM bands AS b , shows AS s , photos AS p WHERE s.id = p.show AND b.id = p.band ORDER BY s.date; 4. Test it. I didn't, so it might be flawed. -- Kristof From kristof at f2o.org Mon Dec 8 12:26:40 2003 From: kristof at f2o.org (Kristof Neirynck) Date: Mon, 08 Dec 2003 19:26:40 +0100 Subject: [thelist] complicated sql In-Reply-To: References: Message-ID: <3FD4C260.1010806@f2o.org> Comitque wrote: > I have three tables. it looks something like this: > (the site is for a venue/club) > > BANDS > band_id | band_name > SHOW INFO > show_id | show_date | band_id (same id as the bands.band_id) > PHOTOS > photo_id | photo_name | photo_bandid (same id as the bands.band_id) > > How do I write a query to retrieve BANDS.band_name, HOWINFO.show_date, > and PHOTOS.photo_name? [snip] 1. Look at your tables again. The data you're looking for is not stored in them. There is no way to link a picture to a band and a show. 2. Alter the database bands : id (PK), name shows : id (PK), date photos : id (PK), name, band (FK), show (FK) 3. Set up a new query. SELECT b.name , s.date , p.name FROM bands AS b , shows AS s , photos AS p WHERE s.id = p.show AND b.id = p.band ORDER BY s.date; 4. Test it. I didn't, so it might be flawed. -- Kristof From christopher at ideadesigners.com Mon Dec 8 12:35:47 2003 From: christopher at ideadesigners.com (Christopher Joseph) Date: Mon, 08 Dec 2003 18:35:47 +0000 Subject: [thelist] PHP Shopping Cart With Web Services Message-ID: <3FD4C483.3080805@ideadesigners.com> Does anyone know of an open source PHP shopping cart which uses web services between the business functionality and the user interface? -- Christopher Joseph ------------------- [Internet] http://www.ideadesigners.com [iseries & web technologies] mailto: christopher at ideadesigners.com [Telephone] mobile: +44 7966 003860 Office: +44 1494 731814 ext. 832 Direct: +44 1494 731832 [Instant Message] ICQ: 78019724 YIM = Josephc_98 MSN = christopher at ideadesigners.com From gilles at balour.org Mon Dec 8 13:08:04 2003 From: gilles at balour.org (Gilles Beauregard) Date: Mon, 08 Dec 2003 14:08:04 -0500 Subject: [thelist] site check please In-Reply-To: <3FD3E86D.9070104@teltest.com> References: <3FD3E86D.9070104@teltest.com> Message-ID: <6.0.1.1.1.20031208140650.03764c90@pop.1and1.com> Allo! >http://www.teltest.co.nz/r.php Some 404 and the email seem to not be spam proof. Otherwise, the speed seem good. Gilles B. From jcbullas at nildram.co.uk Mon Dec 8 13:11:56 2003 From: jcbullas at nildram.co.uk (John C Bullas) Date: Mon, 08 Dec 2003 19:11:56 +0000 Subject: [thelist] robots.txt and subdomains In-Reply-To: References: Message-ID: <6.0.1.1.0.20031208190930.02483268@pop3.nildram.co.uk> > > >I want to make sure that all the files in the foobar folder are not indexed. you need to assume anything that will try to index your site will conform to the robots standard... which it won't :) ....Otherwise you need to explicitly allow the right crawlers in and block all the others? and thre others can play at being the nice guys so it needs to be by IP? FB I believe in... if you don't want it found, don't put it on the web From joel at spinhead.com Mon Dec 8 13:42:41 2003 From: joel at spinhead.com (Joel D Canfield) Date: Mon, 8 Dec 2003 11:42:41 -0800 Subject: SOLVED: RE: [thelist] SQL apostrophe disorder Message-ID: <72E9FAA171D63B48AAC707C72900E6B47454@ireland.spinhead.com> > set @values = ' ''apostrophe between one and two 1''''2'' Bingo! I tried one quote, two, three - I didn't get to four! It writes to the db as a single quote. Here's my theory: normally, we'd need two quotes: one as the character, one to escape it. However, within the multiple nested quoting they've got going on with this SP (I think it's unnecessary obfuscation) each quote needs to be escaped *again*, leading to four. Or, perhaps the two need to be enclosed within quotes, so we've got two quotes within quotes? I dunno; I just know *I* won't be writing anything like this on purpose. Thanks, darren. joel From hershelr at netvision.net.il Mon Dec 8 14:04:21 2003 From: hershelr at netvision.net.il (Hershel Robinson) Date: Mon, 08 Dec 2003 15:04:21 -0500 Subject: [thelist] Web UI Question Message-ID: <004201c3bdc6$78e25920$0300000a@hershel2000> I work for a online financial services corporation and we have web pages with lots of numeric figures, like dollar amounts and loan rates and whatnot (mostly whatnots actually). Anyhow, I noticed at a certain other site that they have their inputs for numeric values right justified. I discussed doing this with my boss and he is concerned that right justified inputs might seem odd when the user enters the data. So I set up event handlers to switch the style from left justified for data entry to right justified for data display. We (presently) support IE6 only. So when the user enters the field, he types in a left justified input. When he leaves, the number jumps to the right side. It looks nice that way, all the numbers lined up together right justified. When he goes back in to edit one of these numbers, then it jumps to the left again. This IS a bit weird, but the display looks nice. Any one have any thoughts on this? Thanks, Hershel From paul at teltest.com Mon Dec 8 14:27:35 2003 From: paul at teltest.com (Paul Bennett) Date: Tue, 09 Dec 2003 09:27:35 +1300 Subject: [thelist] site check please In-Reply-To: References: <3FD3E86D.9070104@teltest.com> Message-ID: <3FD4DEB7.6020801@teltest.com> Tony Crockford wrote: > On Mon, 08 Dec 2003 15:56:45 +1300, Paul Bennett > wrote: > >> The visuals were designed by a local design company and I am >> concerned with some css breaking in browsers I can't test for, as >> well as long download times for some of the background images. >> (feedback from non New Zealand people on dial-up would be great) >> *Any* feedback is appreciated > > > Layout is broken in Opera 7.23 on WinXP - I can screenshot if you want > it. > > I'm on ADSL and some of the pages take a while to come together. (esp > international students!) - dial up will be worse for sure. > > http://www.webpageanalyzer.com/ suggests a load time for that page of > around 25 seconds, plus build time. (built in test in Firebird - hope > your search results don't get screwed) > > on that page you've one gif for each flag - could they not be combined? the plan is to have all flags linking to translated sections of the site in the future > > > Your CSS could have more shorthand > good point - I will go through the files and trim them down a bit > On a personal taste note, I didn't like to see the people's heads cut > off. It took a while to get used to the navigation made a little > worse by the graphics flashing in on every page, can't some of the > image be common to all pages? (I see why it isn't but loading a > different 64 k image at each level?) I'd split it into the header > background and the side menu background. the largest bg image should be around 40 k - (which is still too high for my liking) - this is a result of having to code topreviously signed off graphic designers visuals (a long story) - graphic designers who are *print* designers and not *web* designers......sigh -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From lists at frankmarion.com Mon Dec 8 13:59:23 2003 From: lists at frankmarion.com (Frank) Date: Mon, 08 Dec 2003 14:59:23 -0500 Subject: [thelist] JS: Rounding floats Message-ID: <6.0.0.22.2.20031208145853.06ac5b18@127.0.0.1> I'm trying to "dollar format" some calculated floats. I'm currently using this // Rounds number to x decimal places, defaults to 2 function round_num(number,x) { x = (!x ? 2 : x); return Math.round(number*Math.pow(10,x))/Math.pow(10,x); } The downside is that if the calculation turns out to end in a zero, the zero is omitted. Thus 5.00 = 5 1.50 = 1.5 Does anyone have a very tight and concise manner of either padding for the dollar-format display? -- Frank Marion lists at frankmarion.com Keep the signal high. From paul at teltest.com Mon Dec 8 14:33:07 2003 From: paul at teltest.com (Paul Bennett) Date: Tue, 09 Dec 2003 09:33:07 +1300 Subject: [thelist] site check please In-Reply-To: <002901c3bd74$e2877510$2900005a@mint.co.za> References: <3FD3E86D.9070104@teltest.com> <002901c3bd74$e2877510$2900005a@mint.co.za> Message-ID: <3FD4E003.90407@teltest.com> timmee wrote: >----- Original Message ----- >From: "Paul Bennett" >To: >Sent: Monday, December 08, 2003 4:56 AM >Subject: [thelist] site check please > > > > > >>http://www.teltest.co.nz/r.php >> >> > > > >I am on a laptop running XP. On the home page I see some ugly JPEG artifacts >on the student photo and the red text. > a result of *trying* to keep image size small > >The backgrounds do take forever to download (compared to the rest of the >site). Why do the backgrounds need to be so wide that my browser scrolls >horisontally? I am on 1024 x 768 res. > the graphic designer required the content section colour to stretch right across the page on some pages. Unfortunatley specifying width: 100% on an absolutely positioned element in IE gives the element a width of 100% of the browser window - hence the scroll on two of the "choose a course" pages. I brought this up with the graphic designer who replied: "that's ok"....(.heavy sigh..). Any ideas for a (non js) workaround? -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From paul at teltest.com Mon Dec 8 14:35:55 2003 From: paul at teltest.com (Paul Bennett) Date: Tue, 09 Dec 2003 09:35:55 +1300 Subject: [thelist] site check please In-Reply-To: <043a01c3bd74$a58b4650$2a00000a@PORTABLE> References: <3FD3E86D.9070104@teltest.com> <043a01c3bd74$a58b4650$2a00000a@PORTABLE> Message-ID: <3FD4E0AB.7080803@teltest.com> Richard Bennett wrote: >Hi, > > >Basically it seems to work ok, and fast enough. >I was suprised that the font-size couldn't be varied in ie6 >(ctrl+mousewheel) on the inside pages though, as it was definately too small >for people with bad eyesight or large monitors/resolutions. > will work on that >I'm not so mad about the splashpage either, it's kind of inconsistant with >the rest, and out of balance. > quote from designer: "Its like a book, you have a nice front cover and then....." Unfortunately, apart from containing words, the web is in fact not like a book at all - out of my hands though I'm afraid, I'm just the guy who tries to make things work ;) >The woman with her head chopped off really jars somewhere, the >'International Students' foto looks much more enhancing, even with their >cheesy grins :o) >Personally I would have gone for either fixed-width, centered on the page, >or liquid design. This is liquid top, with fixed-width content, giving a >slightly disjointed CMS-look, especially at large browser size. >I'm not all that keen on the olive coloured thatch either, wouldn't a >different color have livened it up a bit, and complemented the blue and red >better? > again - designer issue >It worked fine in all browsers I tried, with or without javascript, flash >etc, and was usable on opera's PDA simulator. > well that's comforting :) Thans Richard -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From comitque at hotmail.com Mon Dec 8 15:06:16 2003 From: comitque at hotmail.com (Andrew Martin) Date: Mon, 8 Dec 2003 13:06:16 -0800 Subject: [thelist] complicated sql References: <0CEC8258A6E4D611BE5400306E1CC9271E5258@smtmb.tmc.local> Message-ID: Hey, thanks everyone for the tips. I'll try it all out and let you know if I can solve this. Thanks again for your help! ----- Original Message ----- From: "Rob Smith" To: Sent: Monday, December 08, 2003 6:29 AM Subject: RE: [thelist] complicated sql > Hey, > > > How do I write a query to retrieve BANDS.band_name, SHOWINFO.show_date, > > and PHOTOS.photo_name? I had this: > > I would have written your Sql query a little bit different. May help.. > > SQLQuery = "select b.band_name, s.show_date, p.photo_name from showinfo s, > bands b, photos p where b.band_id = p.photo_bandid and s.band_id = b.band_id > Order by s.show_date" > > Let us know, > > Rob > > p.s. if this doesn't work, you may want to check your primary/foreign keys, > also the data itself. > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From rob.smith at THERMON.com Mon Dec 8 15:16:58 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Mon, 8 Dec 2003 15:16:58 -0600 Subject: [thelist] table height: 100% with CSS Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E5265@smtmb.tmc.local> > Any clues? Yup. CSS Table Test
 
Rob From wil at inaridesign.com Mon Dec 8 14:32:22 2003 From: wil at inaridesign.com (Wil Cone) Date: Mon, 8 Dec 2003 14:32:22 -0600 Subject: [thelist] table height: 100% with CSS In-Reply-To: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> Message-ID: <006d01c3bdca$628b5dd0$6501a8c0@DF6HFN01> It's complicated. See http://www.quirksmode.org/css/100percheight.html - Wil > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of > john at johnallsopp.co.uk > Sent: Monday, December 08, 2003 9:12 AM > To: thelist at lists.evolt.org > Subject: [thelist] table height: 100% with CSS > > > Hi > > Maybe I'm having a stupid moment, but I can't see how to make > a table 100% high in CSS. > > I'm trying to make a manual form that looks sensible onscreen > but which prints three columns so the user can print and fill > out by hand. Without putting loads of
s in I can't see > how to make the table a full page deep. > > Any clues? > > Cheers > J From russ at unrealisticexpectations.com Mon Dec 8 15:39:14 2003 From: russ at unrealisticexpectations.com (Russ) Date: Mon, 8 Dec 2003 15:39:14 -0600 Subject: [thelist] table height: 100% with CSS In-Reply-To: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> Message-ID: <010c01c3bdd3$ba5927a0$8de7b6cc@BubbaHoTep> > Maybe I'm having a stupid moment, but I can't see how to make > a table 100% high in CSS. > > I'm trying to make a manual form that looks sensible onscreen > but which prints three columns so the user can print and fill > out by hand. Without putting loads of
s in I can't see > how to make the table a full page deep. Try this:
content
HTH, Russ From John at persol.net Mon Dec 8 14:43:27 2003 From: John at persol.net (John Mitchell) Date: Mon, 8 Dec 2003 20:43:27 -0000 Subject: [thelist] passing data to an asp page Message-ID: <58D59D1389D3204791F3233735C4B39235A0D6@share.persol.net> Hi there, Please, I want to collect details from a form that a user fills in. When the user fills in the form, depending on the value the user will select from the menu box in the form, a corresponding page will be loaded. Example: if the user selects HEALTH, a page called health.asp will be loaded but the rest of the details already filled in (like, name, address, etc) will be displayed on health.asp as well as health.asp's own contents. I have written couple of scripts to do this but there are just not working. Any help? john From rob.smith at THERMON.com Mon Dec 8 16:04:37 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Mon, 8 Dec 2003 16:04:37 -0600 Subject: [thelist] Graphics Art Question - Fireworks MX Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E5266@smtmb.tmc.local> Hello, I have an image in Fireworks MX (PC) and I have two options on the marquee tool: square and circle. However, I want a marquee selection that has rounded corners. Now, I've stumbled across one method but it's not what I'm after. I select the square tool and on the properties, I select feather and notch up the ticker to about 10. I make my selection, ctr+shift+i (invert) and then delete. I get this neat rounded corner square selection, but with feathered edges. :-? Can you offer the how to? Rob Smith From simon.perry at si-designs.co.uk Mon Dec 8 16:16:25 2003 From: simon.perry at si-designs.co.uk (Simon Perry) Date: Mon, 08 Dec 2003 22:16:25 +0000 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> References: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: <3FD4F839.1060305@si-designs.co.uk> Bill Haenel wrote: >Anyone here have any experience in using GD to create good quality >thumbnails? > >I have attempted it and the results are fair to poor. My professional >photographer client will not be satisfied with less than good to >excellent. > >I have also attempted to resize images to larger sizes, and although the >results are a bit better than the thumbnails, they are at least slightly >less than acceptable in several cases. > >PHP Version is 4.2.3 >GD Version is 1.6.2 > >Advice? > >Thanks, >Bill Haenel > > Bill, The usual cause of problems is the limited colour palette and running out of allocated colours very quickly. This results in washed out or even near black images depending on the original photo. IIRC your version of GD only offers imagecreate() and not imagecreatetruecolor(). To get round this create a blank thumbnail image and save it first. This ensures that you have a evenly distributed palette of 256 colours to work from. If you skip this step then GD will allocate the first colours it finds until it has 256 and from then only it will only use those 256 colours even if they are all shades of one colour! If possible I would install a leter version of GD >2.01 as this will give you access to imagecreatetruecolor() and allow you to use a 16m colour palette. It is still advisable to create and save the thumbnail image first. You can then also use imagecopyresampled() to scale your original image as this is far more sophisticated than imagecopyresized(). If you are still having issues post a code sample we can have a look at. Simon From aholmes at pureguru.com Mon Dec 8 16:21:21 2003 From: aholmes at pureguru.com (Aaron Holmes) Date: Mon, 8 Dec 2003 17:21:21 -0500 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: Hi Bill, If at all possible, upgrade GD to version 2. This allows you to use the GD resampling, and results in a better looking result. http://ca2.php.net/manual/en/function.imagecopyresampled.php This is the easiest way to get the better quality that you need (AFAIK) Cheers and good luck! Sincerely yours, Aaron Holmes CEO Gurix Web Professionals Welland, Ontario Canada Corporate e-mail: aholmes at gurix.com V: 905.324.3241 F: 905.734.1398 http://www.gurix.com Subscribe to "Balancing Today's Technology," our free, monthly, electronic newsletter about using technology in business by e-mail to: join-todaystech at gurix.com -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Bill Haenel Sent: Monday, December 08, 2003 10:08 AM To: evolt.org's thelist Subject: [thelist] PHP GD library Anyone here have any experience in using GD to create good quality thumbnails? I have attempted it and the results are fair to poor. My professional photographer client will not be satisfied with less than good to excellent. I have also attempted to resize images to larger sizes, and although the results are a bit better than the thumbnails, they are at least slightly less than acceptable in several cases. PHP Version is 4.2.3 GD Version is 1.6.2 Advice? Thanks, Bill Haenel -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From daniel at bitblaze.com Mon Dec 8 16:26:39 2003 From: daniel at bitblaze.com (Daniel Schlyder) Date: Mon, 8 Dec 2003 23:26:39 +0100 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> References: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: <3516495265.20031208232639@bitblaze.com> [08.12.2003 16:08:21] Bill Haenel: > Anyone here have any experience in using GD to create good quality > thumbnails? > I have attempted it and the results are fair to poor. My professional > photographer client will not be satisfied with less than good to > excellent. > PHP Version is 4.2.3 > GD Version is 1.6.2 I think you need the truecolour support in GD 2.x. Either upgrade GD, upgrade PHP to 4.3+ (which comes with a 2.x compatible version of GD), or check if ImageMagick is available, as an alternative to GD. Regards, Daniel Schlyder From mailing.lists at creed.co.uk Mon Dec 8 16:36:43 2003 From: mailing.lists at creed.co.uk (Andy Warwick) Date: Mon, 8 Dec 2003 22:36:43 +0000 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> References: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: On Dec 08, 2003, at 15:08, Bill Haenel wrote: > Anyone here have any experience in using GD to create good quality > thumbnails? Hi Bill Yes. See for some recent examples from a job I just finished. > PHP Version is 4.2.3 > GD Version is 1.6.2 > > Advice? Suggest you upgrade--if possible--to GD 2.0.1 or greater, so you can use imagecopyresampled(), which gives a much better result. If you can also upgrade to PHP 4.3, it comes with a bundled version of the GD lib, which should be used in preference, as it is better maintained and more stable. (Yes, they forked it, because the PHP team were fed up with slow progress of the original maintainers.) Try using a truecolour image as your destination as well, using imagecreatetruecolor(). See , especially the comments section. If you need any more help, such as sample code I've used, contact me offlist. HTH -- Andy Warwick Creed New Media. From rodrigo at cedha.org.ar Mon Dec 8 17:44:43 2003 From: rodrigo at cedha.org.ar (Rodrigo Galindez) Date: Mon, 8 Dec 2003 20:44:43 -0300 Subject: [thelist] Preventing spam spiders from reading mailto links. References: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: <000901c3bde5$42832fc0$fa00a8c0@bonscott> Hmm ... I used to make a little graphic with the mail address ... Just my 2 cents. Rodrigo Galindez Information Management Assistant Center for Human Rights and Environment (CEDHA) Gral Paz 186 10 A 5000 - Cordoba - Argentina Tel/fax 54-351-4256278 rodrigo at cedha.org.ar www.cedha.org.ar ----- Original Message ----- From: "Philip Weller" To: Sent: Sunday, December 07, 2003 2:13 AM Subject: [thelist] Preventing spam spiders from reading mailto links. > Hello, all. > > Recently, while admiring the HTML on a site I was visiting (as Web geeks > often do) I noticed that they were hiding their e-mail address from spam > bots by rendering it in escaped character entities. I've since implemented > this technique in my just launched personal site (www.philipweller.com). > > I was wondering if those of you much more experienced than myself might have > some real-world feedback as to the effectiveness of this technique. Are > there any techniques you use and can recommend? (I'm aware of Daniel > Benjamin's Hiveware Enkoder (http://hiveware.com/enkoder_form.php) and think > he's providing a wonderful service, but I've chosen not to use it because it > relies on JavaScript and won't work for users who've disabled it.) > > Many Thanks, > Philip Weller > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! From daniel at bitblaze.com Mon Dec 8 18:13:48 2003 From: daniel at bitblaze.com (Daniel Schlyder) Date: Tue, 9 Dec 2003 01:13:48 +0100 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <000001c3bc80$e00c15b0$4930e918@Thelonius> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: <5322923734.20031209011348@bitblaze.com> [07.12.2003 06:13:38] Philip Weller: > Recently, while admiring the HTML on a site I was visiting (as Web geeks > often do) I noticed that they were hiding their e-mail address from spam > bots by rendering it in escaped character entities. I've since implemented > this technique in my just launched personal site (www.philipweller.com). > I was wondering if those of you much more experienced than myself might have > some real-world feedback as to the effectiveness of this technique. Are > there any techniques you use and can recommend? (I'm aware of Daniel > Benjamin's Hiveware Enkoder (http://hiveware.com/enkoder_form.php) and think > he's providing a wonderful service, but I've chosen not to use it because it > relies on JavaScript and won't work for users who've disabled it.) Well, I won't say that I'm experienced, but I tested five email harvesters earlier this year. I'm pretty sure there are better ones out there, but these are the ones I found easily when googling and searching a few download indexes. 1) Advanced Email Extractor Pro (http://www.mailutilities.com/aee/) 2) AtomPark Email Hunter 1.51 (http://www.massmailsoftware.com/extractweb/) 3) E-Mail Seeker 3.0 (http://www.e-mailseeker.com/) 4) Fast Email Extractor 4.3 (http://www.lencom.com/FEE.html) 5) Web Data Extractor 3.62 (http://www.webextractor.com/) Here's my results: program: 1 2 3 4 5 method: in plain text Y Y Y with s around @ Y with @ as @ Y in mailto link Y Y Y Y Y in mailto link created through PHP redirection Y in mailto link created by JavaScript in mailto link created by form processing page As you can see from these results, Advanced Email Extractor Pro may be able to harvest your address, then again, perhaps it just understands the entity for '@'. If you test this, please let me know of your results. If you don't want to use JavaScript, you might want to use the last method I tested. Then again, perhaps not. I think it's extremely ugly. :) Anyways, here's the code, since I'm too tired to explain. In your page:

mailto.php: email-image.php: Personally, I plan to write e-mail addresses like this on my new site: foo at bar.baz and then replace them with proper mailto links using JavaScript to manipulate DOM on page load. Regards, Daniel Schlyder From paul at teltest.com Mon Dec 8 19:50:16 2003 From: paul at teltest.com (Paul Bennett) Date: Tue, 09 Dec 2003 14:50:16 +1300 Subject: [thelist] Printing in Mozilla 1.4 In-Reply-To: References: Message-ID: <3FD52A58.7040705@teltest.com> mlist wrote: >Hi, > >Wonder if anyone can help. I've got a page - see attached - that if you try >to print in Mozilla 1.4 (Windows, Mac, Linux) it crops the page and only >prints the one page. Try the attached page - anyone got any ideas as to how >to fix this so Mozilla prints OK? > > (1) - attachments are stripped from theList (2) url please? > > > > -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From cs1spw at bath.ac.uk Mon Dec 8 20:20:58 2003 From: cs1spw at bath.ac.uk (Simon Willison) Date: Mon, 08 Dec 2003 20:20:58 -0600 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> References: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: <3FD5318A.8020805@bath.ac.uk> Bill Haenel wrote: > Anyone here have any experience in using GD to create good quality > thumbnails? > > I have attempted it and the results are fair to poor. My professional > photographer client will not be satisfied with less than good to > excellent. I had problems with the quality of thumbnails from GD, so I switched to ImageMagick and was delighted with the quality it produced. I use the command-line ImageMagick "convert" tool to generate the thumbnails for this online gallery page, as well as the lo-res versions of the photos: http://etc.lawrence.com/galleries/stanford03/ From dleonard56 at earthlink.net Mon Dec 8 21:02:48 2003 From: dleonard56 at earthlink.net (Dan) Date: Mon, 08 Dec 2003 22:02:48 -0500 Subject: [thelist] Help with Javascript Message-ID: <3FD53B58.4040303@earthlink.net> Hi all, I'm charged with the task of redesigning my church's web site, but know just enough about HTML, CSS, and JavaScript to get myself into trouble! I'm using JavaScript for a fading text effect when a user mouses over the navigation bar (it's a script I got from a DHTML library web site). The effect seems to be working fine for me in Mozilla1.5, IE5+, Opera7, Safari, and even NN4.72, but I'm getting the text doubled up on top of itself when I view it in IE5.2 for Mac. Could someone well-versed in JavaScript take a look at the script to see if something's amiss with my implementation of the script? web site-- http://www.gentleshepherdmcc.com/redesign/draft5.htm javascript-- http://www.gentleshepherdmcc.com/redesign/js/textfader.js Thanks for any help you can give me. Dan From ken at adOpenStatic.com Mon Dec 8 21:19:07 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 9 Dec 2003 14:19:07 +1100 Subject: [thelist] complicated sql References: <72E9FAA171D63B48AAC707C72900E6B47450@ireland.spinhead.com> Message-ID: <008b01c3be03$3519abc0$33345e81@careersAD.unsw.edu.au> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Joel D Canfield" Subject: RE: [thelist] complicated sql > How do I write a query to retrieve BANDS.band_name, > SHOWINFO.show_date, and PHOTOS.photo_name? I had this: You need a join: ... ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ...actually, what the OP needs to do is post some sample data, and what the expected output should look like! Otherwise, since there is no logically obvious relationship between the data in question, I think we're all just trying to make educated guesses as to what the output should look like. Cheers Ken Microsoft MVP - Windows Server (IIS) From mail at webmarketingworx.com Mon Dec 8 21:19:44 2003 From: mail at webmarketingworx.com (Bill Haenel) Date: Mon, 8 Dec 2003 22:19:44 -0500 Subject: [thelist] PHP GD library In-Reply-To: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> Message-ID: <001b01c3be03$4b5029f0$2c00a8c0@webmarketingworx> Sorry to respond to my own post, but wanted to let everyone know I went with an ImageMagick solution, so don't waste your time looking into it unless you REALLY feel inspired. BTW, the IM solution is much better than the GD v1.6. Thanks, Bill Haenel > Anyone here have any experience in using GD to create good > quality thumbnails? > > Thanks, > Bill Haenel From gilles at balour.org Mon Dec 8 22:10:55 2003 From: gilles at balour.org (Gilles Beauregard) Date: Mon, 08 Dec 2003 23:10:55 -0500 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <000001c3bc80$e00c15b0$4930e918@Thelonius> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: <6.0.1.1.1.20031208230907.02ebcad0@pop.1and1.com> Allo! >ots by rendering it in escaped character entities. I've since implemented >this technique in my just launched personal site (www.philipweller.com). Sorry, your trick is not working? Best chance next time. Your favorite spam crawler! Just kidding. This trick is already crack by most recent email harvester. Good luck Gilles B. From bhurtt at mindspring.com Mon Dec 8 22:41:16 2003 From: bhurtt at mindspring.com (Brian Hurtt) Date: Mon, 8 Dec 2003 22:41:16 -0600 Subject: [thelist] Image Horizontal Alignment with CSS... In-Reply-To: <5.1.0.14.2.20031205105910.03b90680@baratta.com> Message-ID: middle and absmiddle are vertical settings, not horizontal. for horizontal you want 'center' -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Anthony Baratta Sent: Friday, December 05, 2003 1:11 PM To: thelist at lists.evolt.org Subject: [thelist] Image Horizontal Alignment with CSS... Howdy... I've stumbled across a problem implementing horizontal alignment to images that are embeded inside a table cell and a div. Here's a code snip:
FYI - The div is part of our CMS application. Anyway - left and right work, but middle and absmiddle do not. I've tried a few things: * If I add a class or an ID to the image, I can manipulate the horizontal alignment with CSS e.g. div#UserContentSpace img#Test {display: block; margin: auto;} or .Test {display: block; margin: auto;} Either of the above only work with Mozilla. IE ignores it. I can't target the table cell itself due to constraints with the CMS application that drives this site. I can target the image directly via Class or ID attributes and CSS. I've read the CSS specs at W3.org, played with a couple examples at other web sites, and have come away confused. Any clues are appreciated. --- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative." -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From gozz at gozz.com Mon Dec 8 23:07:37 2003 From: gozz at gozz.com (Erik Mattheis) Date: Mon, 8 Dec 2003 23:07:37 -0600 Subject: [thelist] IIS custom error (CF) Message-ID: <9B34FC5E-2A05-11D8-A178-0030657D18E2@gozz.com> I have IIS 5.1 set up to use the URL /index.cfm as the 404 error handler. It doesn't work if the requested page is CF or if ".cfm" The following process /index.cfm: /nothinghere/ /nothinghere/index.html /nothinghere/index.asp The following return the a 404 page ... the one with a binch of etc: /nothinghere/index.cfm /nothinghere/nothere.cfm /nothinghere/index.cfm/ /nothinghere/index.cfm/nothing/ /nothinghere/nothere.cfm/nothing/ Any idea what's happening? From ken at adOpenStatic.com Tue Dec 9 00:58:10 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 9 Dec 2003 17:58:10 +1100 Subject: [thelist] passing data to an asp page References: <58D59D1389D3204791F3233735C4B39235A0D6@share.persol.net> Message-ID: <04dd01c3be21$ce8a3c70$33345e81@careersAD.unsw.edu.au> There are a number of ways you can do this. a) You can use some client-side javascript to set where the form submits to depending on what the user selects from the drop-down list. b) You can have the form submit to a set ASP page, and then use server.execute or server.transfer in that page to run the desired page (depending on what the user has selected) c) You can have the form submit to a set ASP page, then use Response.Redirect, to redirect the user to the appropriate page, however you need some way persist the posted form data (eg by placing it in the querystring) Cheers Ken Microsoft MVP - Windows Server (IIS) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "John Mitchell" Subject: [thelist] passing data to an asp page Please, I want to collect details from a form that a user fills in. When the user fills in the form, depending on the value the user will select from the menu box in the form, a corresponding page will be loaded. Example: if the user selects HEALTH, a page called health.asp will be loaded but the rest of the details already filled in (like, name, address, etc) will be displayed on health.asp as well as health.asp's own contents. I have written couple of scripts to do this but there are just not working. From Brian at hondaswap.com Tue Dec 9 01:23:57 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Tue, 09 Dec 2003 02:23:57 -0500 Subject: [thelist] PHP GD library In-Reply-To: <3516495265.20031208232639@bitblaze.com> References: <001901c3bd9d$1f032200$2c00a8c0@webmarketingworx> <3516495265.20031208232639@bitblaze.com> Message-ID: <3FD5788D.10700@hondaswap.com> upgrade to GD 2.0. you really need it here's a couple functions i use for a thumb generator for jpg only. // form //
// handler // ############################################################################################# $IMG_ORG_HEIGHT = "*"; #Width of original image stored on server $IMG_ORG_WIDTH = "*"; #Height of original image stored on server #set to "*" to prevent resizing on the dimension #you will not lost X to Y ratio $IMG_HEIGHT = "60"; # Accepted height of resized image $IMG_WIDTH = "80"; # Accepted width of resized image # read about "*" above $IMG_ROOT = "./images"; # Relative path to folder where uploaded images will be stored; no ending slash! # Like this: $IMG_ROOT = "./img"; # Remeber to set proper attributes to that folder. 777 will work :) $use_imagecreatetruecolor = true; // these flags enble ImageCreateTrueColor(); ImageCopyResampled(); $use_imagecopyresampled = true; $JPG_QUALITY = 80; // output jpeg quality ############################################################################################# if(!$HTTP_POST_FILES ["image"]["tmp_name"] || $HTTP_POST_FILES ["image"]["tmp_name"] =="none") die("Your images may be no larger than 100KB in size. Please make it smaller, and try again."); if( ! $f_org = resizer_main("image","",$IMG_ORG_WIDTH,$IMG_ORG_HEIGHT))die("
No Image received...
"); if( ! $f_res = resizer_main("image","res_",$IMG_WIDTH,$IMG_HEIGHT))die("
Not resized :(
"); $sz_org =getimagesize( "$IMG_ROOT/$f_org" ); $sz_res =getimagesize( "$IMG_ROOT/$f_res" ); $fs_org= filesize("$IMG_ROOT/$f_org" ); $fs_res= filesize("$IMG_ROOT/$f_res" ); $html =<<< EHTML // put what you want to echo out after upload here.... may include your template.... // ie: Resized image: Original image: EHTML; echo $html; // and now, the functions.... probably include these remotely ############################################################################################# function resizer_main($image, $dest_file_prefix,$w, $h){ //image_name = uploaded image. Name or your file field in your form. //w,h - width and height to fit image in global $use_imagecreatetruecolor, $use_imagecopyresampled, $IMG_ROOT, $JPG_QUALITY, $HTTP_POST_FILES; $image_name = $HTTP_POST_FILES [$image]["name"]; $image = $HTTP_POST_FILES [$image]["tmp_name"]; if(trim($image) == "" || trim($image) =="none") return false; $arr_img = image_from_upload($image); if( $arr_img["w"] != $w && $arr_img["h"] != $h){ $wh = get_sizes($arr_img["w"], $arr_img["h"], $w, $h); $img_res = img_get_resized( $arr_img["img"], $arr_img["w"], $arr_img["h"], $wh["w"], $wh["h"], $use_imagecreatetruecolor, $use_imagecopyresampled); } else { //wow it is exactly like needed!!! $img_res = $arr_img["img"]; } $file_name = make_filename($image_name, $dest_file_prefix); ImageJPEG($img_res,"$IMG_ROOT/$dest_file_prefix$file_name", $JPG_QUALITY); return "$dest_file_prefix$file_name"; } function image_from_upload($uploaded_file){ $img_sz = getimagesize( $uploaded_file ); ## returns array with some properties like dimensions and type; ####### Now create original image from uploaded file. Be carefull! GIF is often not supported, as far as I remember from GD 1.6-2.0 switch( $img_sz[2] ){ case 1: $img_type = "GIF"; //$img = ImageCreateFromGif($uploaded_file); die("
Sorry, Only JPG's are supported.
"); break; case 2: $img = ImageCreateFromJpeg($uploaded_file); $img_type = "JPG"; break; case 3: $img = ImageCreateFromPng($uploaded_file); $img_type = "PNG"; break; case 4: $img_type = "SWF"; //$img = ImageCreateFromSwf($uploaded_file); die("
Sorry, Only JPG's are supported.
"); break; default: die("
Sorry, Only JPG's are supported.
"); }//case return array("img"=>$img, "w"=>$img_sz[0], "h"=>$img_sz[1], "type"=>$img_sz[2], "html"=>$img_sz[3]); } function get_sizes($src_w, $src_h, $dst_w,$dst_h ){ //src_w ,src_h-- start width and height //dst_w ,dst_h-- end width and height //return array w=>new width h=>new height mlt => multiplier //the function tries to shrink or enalrge src_w,h in such a way to best fit them into dst_w,h //keeping x to y ratio unchanged //dst_w or/and dst_h can be "*" in this means that we dont care about that dimension //for example if dst_w="*" then we will try to resize by height not caring about width //(but resizing width in such a way to keep the xy ratio) //if both = "*" we dont resize at all. #### Calculate multipliers $mlt_w = $dst_w / $src_w; $mlt_h = $dst_h / $src_h; $mlt = $mlt_w < $mlt_h ? $mlt_w:$mlt_h; if($dst_w == "*") $mlt = $mlt_h; if($dst_h == "*") $mlt = $mlt_w; if($dst_w == "*" && $dst_h == "*") $mlt=1; #### Calculate new dimensions $img_new_w = round($src_w * $mlt); $img_new_h = round($src_h * $mlt); return array("w" => $img_new_w, "h" => $img_new_h, "mlt_w"=>$mlt_w, "mlt_h"=>$mlt_h, "mlt"=>$mlt); } function img_get_resized($img_original,$img_w,$img_h,$img_new_w,$img_new_h,$use_imagecreatetruecolor=false, $use_imagecopyresampled=false){ //$img_original, -- image to be resized //$img_w, -- its width //$img_h, -- its height //$img_new_w, -- resized width //$img_new_h -- height //$use_imagecreatetruecolor, $use_imagecopyresampled allow use of these function //if they exist on the server if( $use_imagecreatetruecolor && function_exists("imagecreatetruecolor")){ // echo("Using ImageCreateTruecolor (better quality)
"); $img_resized = imagecreatetruecolor($img_new_w,$img_new_h) or die("
Failed to create destination image.
"); } else { // echo("Using ImageCreate (usual quality)
"); $img_resized = imagecreate($img_new_w,$img_new_h) or die("
Failed to create destination image.
"); } if($use_imagecopyresampled && function_exists("imagecopyresampled")){ // echo("Using ImageCopyResampled (better quality)
"); imagecopyresampled($img_resized, $img_original, 0, 0, 0, 0,$img_new_w, $img_new_h, $img_w,$img_h) or die("
Failed to resize @ ImageCopyResampled()
"); }else{ // echo("Using ImageCopyResized (usual quality)
"); imagecopyresized($img_resized, $img_original, 0, 0, 0, 0,$img_new_w, $img_new_h, $img_w,$img_h) or die("
Failed to resize @ ImageCopyResized()
"); } return $img_resized; } function make_filename($image_name){ ## creates unique name, here I assume that it will never happen that in same second ## two files with same name on user's site will be uploaded. However you can use your ## ways to generate unique name. Function unqueid() for example. //$file_name = time()."_$image_name"; $file_name = uniqid('s').'.jpg'; #kick the original extension $pos = strrpos($file_name, '.'); //gif sin't supported, so hardcode jpg extention $file_name = substr($file_name, 0,$pos).".jpg"; return $file_name; } From stowaway at uklinux.net Tue Dec 9 01:32:54 2003 From: stowaway at uklinux.net (joe) Date: Tue, 09 Dec 2003 07:32:54 +0000 Subject: [thelist] Graphics Art Question - Fireworks MX In-Reply-To: <0CEC8258A6E4D611BE5400306E1CC9271E5266@smtmb.tmc.local> References: <0CEC8258A6E4D611BE5400306E1CC9271E5266@smtmb.tmc.local> Message-ID: <3FD57AA6.3020104@uklinux.net> Rob Smith wrote: >I have an image in Fireworks MX (PC) and I have two options on the marquee >tool: square and circle. However, I want a marquee selection that has >rounded corners. > > > hey Rob After making your selection, instead of featherng, try Select > Smooth Marquee hth joe From ngilas2003 at yahoo.com Tue Dec 9 03:17:56 2003 From: ngilas2003 at yahoo.com (Stevenson N) Date: Tue, 9 Dec 2003 01:17:56 -0800 (PST) Subject: [thelist] Dynamically populating a select list Message-ID: <20031209091756.35352.qmail@web60605.mail.yahoo.com> I have tried using: var oNewOption = document.createElement("OPTION"); oDestination.options.add(oNewOption); oNewOption.text = "Two"; oNewOption.value = "2"; But am getting the following js error message: <><><<><><<><><< Invalid Argument <><><<><><<><><< Also on using: oDestination.options[ oDestination.options.length ] = new Option( "Two", "2") I get the following js error message: <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< Object doesn't support this property or method <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< on using: oDestination.options.length = oDestination.options.length + 1; oDestination.options[ Destination.options.length ].value = "2"; oDestination.options[ oDestination.options.length ].text = "Two2"; I get the following js error message: <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< 'options[...]' null or not an object <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< What's wrong with my code given that all this are done on an IFRAME? --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard From ben.morrison at dogstardesign.co.uk Tue Dec 9 03:40:40 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Tue, 09 Dec 2003 09:40:40 +0000 Subject: [thelist] Graphics Art Question - Fireworks MX In-Reply-To: <0CEC8258A6E4D611BE5400306E1CC9271E5266@smtmb.tmc.local> Message-ID: On 8/12/03 10:04 pm, "Rob Smith" wrote: > I have an image in Fireworks MX (PC) and I have two options on the marquee > tool: square and circle. However, I want a marquee selection that has > rounded corners. Haven't done this before in fireworks, but could you use the rounded corner vector tool and turn that into a mask instead? Then either use the mask as needed or flatten the mask, you can then use the magic wand tool to select the mask - which is a rounded corner box. benjer From ldelahunty at britstream.com Tue Dec 9 04:05:11 2003 From: ldelahunty at britstream.com (Liam Delahunty) Date: Tue, 9 Dec 2003 10:05:11 -0000 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: I've a number of techniques and online forms for generating the code here: http://www.liamdelahunty.com/tips/email_obfuscation_for_spambots/ I've got the following types: 0. Replaces the at @ sign with @ in the link text and tag. It appears as a readable link in the browser 1. JavaScript to add the two sections name + @ + domain. 2. Bin2hex 3. Ascii encode 4. Hex & Ascii encode I tend to use the ASCII encode on sites. None of my addresses on pages above have been harvested by spam bots. On your web site consider using a unique email address such as web_contact@, just for contacts via the web site so you can filter off messages once/if it gets harvested by spambots. Kind regards, Liam Delahunty, Mega Products Limited -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Philip Weller Sent: 07 December 2003 05:14 To: thelist at lists.evolt.org Subject: [thelist] Preventing spam spiders from reading mailto links. Hello, all. Recently, while admiring the HTML on a site I was visiting (as Web geeks often do) I noticed that they were hiding their e-mail address from spam bots by rendering it in escaped character entities. I've since implemented this technique in my just launched personal site (www.philipweller.com). I was wondering if those of you much more experienced than myself might have some real-world feedback as to the effectiveness of this technique. Are there any techniques you use and can recommend? (I'm aware of Daniel Benjamin's Hiveware Enkoder (http://hiveware.com/enkoder_form.php) and think he's providing a wonderful service, but I've chosen not to use it because it relies on JavaScript and won't work for users who've disabled it.) Many Thanks, Philip Weller -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From andy at message.uk.com Tue Dec 9 04:54:05 2003 From: andy at message.uk.com (Andy Budd) Date: Tue, 9 Dec 2003 10:54:05 +0000 Subject: [thelist] site check please In-Reply-To: <3FD3E86D.9070104@teltest.com> Message-ID: <01E2B0CA-2A36-11D8-BED2-003065480AC6@message.uk.com> Paul Bennett wrote: > We have a site preparing to go live soon and I would like some > usability / download / rendering feedback from people on Os's and > browsers inaccessible to us > http://www.teltest.co.nz/r.php > (Please refrain from using the site name in public posts if possible - > I don't want Evolt munging search results!) > > The visuals were designed by a local design company and I am concerned > with some css breaking in browsers I can't test for, as well as long > download times for some of the background images. > (feedback from non New Zealand people on dial-up would be great) > *Any* feedback is appreciated Looks really nice. Couple of layout problems on Safari. On the home page ============== The bottom of the Future Student's box doesn't line up with the bottom of the blue box at the top (and it looks like it should). There is a white gap between the pic of the man and the pic of the matting. There is a strange blue line across the bottom of the layout. Other pages ========= On some of the pages (e.g. Whakatauki and Values) the blue "swoosh" containing the words future students, no longer lines up with the blue bar at the top. Andy Budd http://www.message.uk.com/ From gilles at balour.org Tue Dec 9 05:17:31 2003 From: gilles at balour.org (Gilles Beauregard) Date: Tue, 09 Dec 2003 06:17:31 -0500 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <5322923734.20031209011348@bitblaze.com> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <5322923734.20031209011348@bitblaze.com> Message-ID: <6.0.1.1.1.20031209061407.0327cdb0@pop.1and1.com> Allo! >in mailto link created by JavaScript Depend on the Javascript script use, the email can be harvest by the last version of email harvester. Javascript is not a long term solution. To date, monged address is the best solution. mailto:gilles.AT.balour.DOT.org work fine, but be imaginative when you munged your address. Have a nice and spam free day. Gilles B. From Brian at hondaswap.com Tue Dec 9 05:24:17 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Tue, 09 Dec 2003 06:24:17 -0500 Subject: [thelist] Help with Javascript In-Reply-To: <3FD53B58.4040303@earthlink.net> References: <3FD53B58.4040303@earthlink.net> Message-ID: <3FD5B0E1.50701@hondaswap.com> Dan wrote: > Hi all, > > I'm charged with the task of redesigning my church's web site, but know > just enough about HTML, CSS, and JavaScript to get myself into trouble! > I'm using JavaScript for a fading text effect when a user mouses over > the navigation bar (it's a script I got from a DHTML library web site). > The effect seems to be working fine for me in Mozilla1.5, IE5+, Opera7, > Safari, and even NN4.72, but I'm getting the text doubled up on top of > itself when I view it in IE5.2 for Mac. Could someone well-versed in > JavaScript take a look at the script to see if something's amiss with my > implementation of the script? > > web site-- http://www.gentleshepherdmcc.com/redesign/draft5.htm > javascript-- http://www.gentleshepherdmcc.com/redesign/js/textfader.js > > Thanks for any help you can give me. > Dan > > how about simply removing it? I think i speak for most people here when I say i hate dhtml stuff. From ngilas2003 at yahoo.com Tue Dec 9 05:27:23 2003 From: ngilas2003 at yahoo.com (Stevenson N) Date: Tue, 9 Dec 2003 03:27:23 -0800 (PST) Subject: [thelist] Dynamically populating a select list Message-ID: <20031209112723.28302.qmail@web60604.mail.yahoo.com> I have tried using: var onfiltered= document.createElement("OPTION"); oDestination.options.add(oNewOption); oNewOption.text = "Two"; oNewOption.value = "2"; But am getting the following js error message: <><><<><><<><><< Invalid Argument <><><<><><<><><< Also on using: oDestination.options[ oDestination.options.length ] = new Option( "Two", "2") I get the following js error message: <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< Object doesn't support this property or method <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< on using: oDestination.options.length = oDestination.options.length + 1; oDestination.options[ Destination.options.length ].value = "2"; oDestination.options[ oDestination.options.length ].text = "Two2"; I get the following js error message: <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< 'options[...]' null or not an object <><><<><><<><><<<><><<><><<><><<<><><<><><<><><< What's wrong with my code given that all this are done on an IFRAME? --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard From koksa.uh at seznam.cz Tue Dec 9 05:45:42 2003 From: koksa.uh at seznam.cz (Tomas Kokoska) Date: Tue, 9 Dec 2003 12:45:42 +0100 Subject: [thelist] passing data to an asp page References: <58D59D1389D3204791F3233735C4B39235A0D6@share.persol.net> Message-ID: <00d301c3be49$f97e4d40$ca09000a@kukulin> i see no problem here. (1) page with form: (2) page ie. health.asp
"> "> "> ...
You can use this without change if your inputs are of these types: text, hidden, password minor changes must be done if you use radio, checkbox, select, or textarea, but I think you can manage. Feel free to ask again if you can?t. tom ----- Original Message ----- From: "John Mitchell" To: Sent: Monday, December 08, 2003 9:43 PM Subject: [thelist] passing data to an asp page Hi there, Please, I want to collect details from a form that a user fills in. When the user fills in the form, depending on the value the user will select from the menu box in the form, a corresponding page will be loaded. Example: if the user selects HEALTH, a page called health.asp will be loaded but the rest of the details already filled in (like, name, address, etc) will be displayed on health.asp as well as health.asp's own contents. I have written couple of scripts to do this but there are just not working. Any help? john -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From koksa.uh at seznam.cz Tue Dec 9 05:57:49 2003 From: koksa.uh at seznam.cz (Tomas Kokoska) Date: Tue, 9 Dec 2003 12:57:49 +0100 Subject: [thelist] passing data to an asp page References: <58D59D1389D3204791F3233735C4B39235A0D6@share.persol.net> Message-ID: <00e301c3be4b$ab2b1d60$ca09000a@kukulin> bad day for me. please change this:
with this: just the brackets. IE is too generous to work with the first one allowing me to make mistakes. ----- Original Message ----- From: "John Mitchell" To: Sent: Monday, December 08, 2003 9:43 PM Subject: [thelist] passing data to an asp page Hi there, Please, I want to collect details from a form that a user fills in. When the user fills in the form, depending on the value the user will select from the menu box in the form, a corresponding page will be loaded. Example: if the user selects HEALTH, a page called health.asp will be loaded but the rest of the details already filled in (like, name, address, etc) will be displayed on health.asp as well as health.asp's own contents. I have written couple of scripts to do this but there are just not working. Any help? john -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From cosming at as.ro Tue Dec 9 05:34:33 2003 From: cosming at as.ro (Cosmin G) Date: Tue, 9 Dec 2003 13:34:33 +0200 Subject: [thelist] Database schema Message-ID: <004801c3be4c$218174f0$fc69e9d5@voltec01> Hi. I've been asked to develop a database for a computer website. Right now I have the following tables: categories (1 - cpu's, 2 - hard-drives, ) producer product exchange rate All products have some common values (price, warranty period, description) and there are some fields which are product specific (such as cpu frequency, cpu cache memory, etc). Right now I've stored all the product specific fields in the products table and prefixed them with the name of the category they refer to. Is this a good approach or should I put them in separate tables? The table is getting pretty unmanageable already. From rytames at telusplanet.net Tue Dec 9 07:55:07 2003 From: rytames at telusplanet.net (Ryan Tames) Date: Tue, 09 Dec 2003 05:55:07 -0800 Subject: [thelist] Graphics Art Question - Fireworks MX In-Reply-To: <0CEC8258A6E4D611BE5400306E1CC9271E5266@smtmb.tmc.local> Message-ID: <3FD563BB.30088.568AAA1@localhost> On 8 Dec 2003 at 16:04, Rob Smith wrote: I've never used fireWorks, however: in most current graphics applications, you use the vector (pen or shape) tool, and make a shape, and then covert that from a path too a selection. Also you could fill it with a solid color on a new layer, and use the auto-selection tool on the solid color, and change layers; Using that selection, on the layer you want to use it on. Also, you could use a shape, like the second option above, convert it to black and white, and then convert it to a mask. >From the mask, (if present) use the 'mask -> selection' option, and apply it to the layer you want it on. Hmmm... theres probally two other ways: 1) use the rounded corner selection tool. 2) combine two selections into one. the first being the base shape, and the others being circles, set to the proper place to round the corners. > Hello, > > I have an image in Fireworks MX (PC) and I have two options on the > marquee tool: square and circle. However, I want a marquee selection > that has rounded corners. > > Now, I've stumbled across one method but it's not what I'm after. I > select the square tool and on the properties, I select feather and > notch up the ticker to about 10. I make my selection, ctr+shift+i > (invert) and then delete. I get this neat rounded corner square > selection, but with feathered edges. :-? > > Can you offer the how to? > > Rob Smith > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! -- Ryan Tames, CIWa - Webmaster, Multimedia, Poet, Chef, Coder, Artiste` PGP Public key: c:\finger webmaster at tames.2y.net [Adventures of a man and his Pocket DV]: http://pocketdv.tames.2y.net/ [TagaT Web Enabled Tag Board]: http://tagat.tames.2y.net/ [Ryan Tames Pro-Portfolio]: http://portfolio.tames.2y.net/ From John at persol.net Tue Dec 9 03:50:58 2003 From: John at persol.net (John Mitchell) Date: Tue, 9 Dec 2003 09:50:58 -0000 Subject: [thelist] passing data to an asp page(solution found) Message-ID: <58D59D1389D3204791F3233735C4B39235A0DA@share.persol.net> Hi guys, I found the solution to the problem. Thanks to all those who showed interest. Here is a sample of what I did: ==============================================

 

Name:
Health:
 

 

=============================================== > -----Original Message----- > From: John Mitchell > Sent: Monday, December 08, 2003 8:43 PM > To: 'thelist at lists.evolt.org' > Subject: passing data to an asp page > > Hi there, > Please, I want to collect details from a form that a user fills in. > When the user fills in the form, depending on the value the user will > select from the menu box in the form, a corresponding page will be > loaded. Example: if the user selects HEALTH, a page called health.asp > will be loaded but the rest of the details already filled in (like, > name, address, etc) will be displayed on health.asp as well as > health.asp's own contents. > > I have written couple of scripts to do this but there are just not > working. > > Any help? > > john From jeff at jeffhowden.com Tue Dec 9 09:22:07 2003 From: jeff at jeffhowden.com (Jeff Howden) Date: Tue, 9 Dec 2003 07:22:07 -0800 Subject: [thelist] IIS custom error (CF) In-Reply-To: <9B34FC5E-2A05-11D8-A178-0030657D18E2@gozz.com> Message-ID: erik, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Erik Mattheis > > I have IIS 5.1 set up to use the URL /index.cfm as the > 404 error handler. > > It doesn't work if the requested page is CF or if > ".cfm" ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< did you go into the app mappings and set the .cfm file extension to "check file exists"? .jeff ------------------------------------------------------ Jeff Howden - Web Application Specialist Resume - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From dunstan at 1976design.com Tue Dec 9 09:29:42 2003 From: dunstan at 1976design.com (Dunstan Orchard) Date: Tue, 09 Dec 2003 15:29:42 +0000 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; Message-ID: <3FD5EA66.5050101@1976design.com> Is the an ASP equivalent of PHP's syntax: $var = ($a == 0) ? 'hello' : 'goodbye'; I can't seem to find anything, but I know you can do it in JS, so I presumed it was OK in ASP as well. Thanks - Dunstan If you're building a database to store blog entires, or press releases or similar, always include a time element in your date/time storage. You might not think you need it now, but somewhere down the line you probably will, and then you'll have a whole bunch of changes to make to your code as you scramble to add it in. ------------------------------------- Dorset, England Work: http://www.1976design.com/ Play: http://www.1976design.com/blog/ Learn: http://webstandards.org/ From stephane.deschamps at francetelecom.com Tue Dec 9 09:48:30 2003 From: stephane.deschamps at francetelecom.com (DESCHAMPS =?iso-8859-1?Q?St=E9phane?= DSI/SICOR) Date: Tue, 9 Dec 2003 16:48:30 +0100 Subject: [thelist] JS obj.value (was RE: Ok, *real* stupid Q...) In-Reply-To: Message-ID: <007e01c3be6b$e56cb270$ba10b30a@FTUCOKT82QZJU6> > -----Message d'origine----- de jsWalter > > OK, assuming that 'objElement' is properly defined as a > reference to a Form > Element... > > (I know 'objElement' is properly defined because > 'objElement.id' gives me > the correct ID string) > > any idea why Mozilla, Firebird, NN 7x returns nothing when > using this... > > objElement.getAttribute("value") > > ??? > > IE 5//6 Mac/PC, Safari, Konqueror all give me the value > contained in that > Element. > > Nothing online tell me why this does not work. Hi js, Is it a value that is empty when the page is loaded? Then Mozilla et al. are correct: the attribute is empty. When you enter a value in a form field its *property* changes, but I'm not sure the attribute is changed. What does objElement.value return? stef*notabene http://evolt.org/user/notabene/22696/ http://www.nota-bene.org/ From evolt at scottbrady.net Tue Dec 9 10:03:24 2003 From: evolt at scottbrady.net (Scott Brady) Date: Tue, 09 Dec 2003 09:03:24 -0700 Subject: [thelist] XML and the Degree Sign Message-ID: <3FD5F24C.9030305@scottbrady.net> I'm working on a ColdFusion application that has some pages (which I didn't write) that utilize XML and XSLT to present data pulled from a database. We have some data that includes the degree symbol (ASCII 176) and XML seems to be choking on that. We already use XMLFormat() on the data that should take care of any characters XML can't handle. Trying to view the generatred XML page in a browser (IE5.5, on which the intranet this app runs is standardized) results in a page that says the XML page can not be displayed ("An invalid character was found in text content").. Other than stripping out the degree symbols in the data first (which is a bit of a kluge and leads to a time when I see us having to strip out other characters), is there something else we can try? Scott -- --------------------------- Scott Brady http://www.scottbrady.net/ From rob.smith at THERMON.com Tue Dec 9 10:30:55 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Tue, 9 Dec 2003 10:30:55 -0600 Subject: [thelist] Very Strange CDONTS Behavior Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E526B@smtmb.tmc.local> Hi, I've got a CDONTS implementation on our site but something very strange is happening and I haven't the slightest explanation of the behavior. Your typical CDONTS mail message includes your FROM, TO, SUBJECT and BODY. I'm implementing it like this: myCDONTSMail.From = "this at email-address.com" myCDONTSMail.To = "that at email-address.com" myCDONTSMail.Subject = "My subject" strBody = " formatted text " & request.form("With some ASP") & "" myCDONTSMail.Body = strBody myCDONTSMail.bodyformat = 0 myCDONTSMail.mailformat = 0 myCDONTSMail.Send Set myCDONTSMail = Nothing This works for all of our Americas correspondence, and for all of our employees all over the world. However, when the address is from the European regions, the body is missing.!?!? Thus, giving us a blank e-mail message. Any of you have a clue why? Rob From Julie.Dodd at LC.CA.GOV Tue Dec 9 10:34:50 2003 From: Julie.Dodd at LC.CA.GOV (Dodd, Julie) Date: Tue, 09 Dec 2003 08:34:50 -0800 Subject: [thelist] Graphics Art Question - Fireworks MX Message-ID: <51D39629CA5DD711B640000802E087AB03141189@ldcmsx01.lc.ca.gov> > On 8/12/03 10:04 pm, "Rob Smith" wrote: > > > I have an image in Fireworks MX (PC) and I have two options on the marquee > > tool: square and circle. However, I want a marquee selection that has > > rounded corners. Hi Rob, if you click and hold the marquee tool, an option for a round corner selection should appear. HTH, julie From mark at mark.ac Tue Dec 9 10:36:43 2003 From: mark at mark.ac (Mark Howells) Date: Tue, 9 Dec 2003 17:36:43 +0100 Subject: [thelist] Image Horizontal Alignment with CSS... In-Reply-To: References: Message-ID: > > > > > >
height="150">
hspace="0" > src="/images/image.jpg" width="201" align="middle"> >
>
I doubt that using "center" will help you here. The following things spring immediately to mind. - Does IE recognize the single quotes around the ID attribute in the HTML? - Try removing the align attribute from the HTML: that's what CSS is for. The browser may get confused if you have two definitions. 75% of all unexplainable CSS bugs are down to incorrect, invalid or illogical source code. - You don't say which version of IE you are having problems with. Maybe the combination of browser and platform has a problem with your definitions. - Check all your alignment and margin settings for ,
and . There may be a conflict there somewhere. - Do you really need to use a table to contain the layout? Mark Howells http://www.mark.ac/ From rob.smith at THERMON.com Tue Dec 9 10:47:36 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Tue, 9 Dec 2003 10:47:36 -0600 Subject: [thelist] Graphics Art Question - Fireworks MX Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E526C@smtmb.tmc.local> >> I have an image in Fireworks MX (PC) and I have two options on the >> marquee tool: square and circle. However, I want a marquee selection >> that has rounded corners. > > After making your selection, instead of featherng, try Select > > Smooth Marquee Hi Joe, Yes. That did the trick. The first time you do this, it will give you the rounded corner marquee. However a small caveat: If you do that twice, you get a feathered rounded corner marquee. Thanks! Rob From Graham.Bird at rspb.org.uk Tue Dec 9 11:07:48 2003 From: Graham.Bird at rspb.org.uk (Bird, Graham) Date: Tue, 9 Dec 2003 17:07:48 -0000 Subject: [thelist] Default position of popup windows Message-ID: <665521262709BB4088F780D667B8ECE53E17B1@saturn.RSPB.ORG.UK> Hi, Does anyone know what controls the position of a javascript popup if position is not specified? In my IE6, popups are appearing on the far right (very appropriate), whereas in Mozilla they appear top left (as I would expect). This happens on all websites I visit. Cheers, Graham From rob.smith at THERMON.com Tue Dec 9 11:09:34 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Tue, 9 Dec 2003 11:09:34 -0600 Subject: [thelist] Graphics Art Question - Fireworks MX Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E526D@smtmb.tmc.local> > I have an image in Fireworks MX (PC) and I have two options on the marquee > tool: square and circle. However, I want a marquee selection that has > rounded corners. Haven't done this before in fireworks, but could you use the rounded corner vector tool and turn that into a mask instead? Then either use the mask as needed or flatten the mask, you can then use the magic wand tool to select the mask - which is a rounded corner box. benjer, Wow, I haven't thought about that way. Neat. In fact, you can even do more complex shapes this way. Make a bunch of polygons, union all the paths fill with a solid color, then mask out the extra information. Thanks! Rob From scott at Publiccto.com Tue Dec 9 11:16:13 2003 From: scott at Publiccto.com (Scott Wolpow) Date: Tue, 09 Dec 2003 12:16:13 -0500 Subject: [thelist] Need Browser In-Reply-To: References: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: <6.0.0.22.0.20031209120845.02791cf0@netalytical.com> I need a customizable browser that does the following: Mandatory Supports Javascript and CSS and PSS (Print Style Sheets) Secure Login Also need Custom tool bar for both Nav, Back up and Print functions Logon before it opens Lock in URL it goes to (It will be used for an online app Has a "message" light. (When they login it scans through a message fields and lets them know if there is a message for them, not email though, but that would also be nice) Relatively inexpensive, Perpetual license. If you know of a solution let me know. If you can develop one let me know off list. Thanks (US) Cheers (UK) Scott From evolt_org at striderweb.com Tue Dec 9 12:09:45 2003 From: evolt_org at striderweb.com (Stephen Rider) Date: Tue, 9 Dec 2003 12:09:45 -0600 Subject: [thelist] "spamminess" site check - realtymort.com Message-ID: Hi evolters -- I work for a company that has had a website for a number of years. We've never had _great_ ranking on Google, but we've always been there. The boss-man is absolutely driven to raise the rankings in search engines (I explained to him that Google's entire business model depends on web coders not being able to directly manipulate the rankings, but he doesn't want to hear it...), so he keeps insisting that I keep tweaking word order in Title tags and such, in a vain attempt to find the perfect "keyword" optimization. In an attempt to help this issue (and several other such as browser compatibility), I rewrote the site about six months ago using pure XHTML and CSS, which among other things majorly increase the content-to-noise ratio of the pages, improved structure, etc.... We've hovered around 80th place when searching for the phrase "chicago apartments" (it's primarily a building management company). Google redesigned their algorithm in November, and suddenly the page is nowhere to be found! It pops up if I search very specifically (as in the specific company name) so we're still in the database, but we don't show up anywhere under various types of keyword searches. Here is the site: I thought the site was well done in terms of readabiloity to search engines and such, and I'm not doing anything blatantly "spammy", AFAIK. Am I missing something? Is there something I'm doing horribly wrong here? Notes: 1) The Site Map is brand-spanking new (as in, "yesterday"), so that's not part of the issue. I added that in attempt to alleviate the problem. Bad move or good move? 2) There are two domains pointing to the same site, so that may be part of the problem (but wasn't before). goes to the same site. 3) The words "Chicago Apartments" was recently added to the beginning of all page titles... not sure if this is the problem or not, just an FYI. Doesn't seem to be too terrible of a crime, but slightly "spammy" Please take a look. All advice is appreciated. More generally, do you all know of a good source of "search engine optimization" advice? Regards, (and tips forthcoming) Steve Rider From evolt_org at striderweb.com Tue Dec 9 12:17:10 2003 From: evolt_org at striderweb.com (Stephen Rider) Date: Tue, 9 Dec 2003 12:17:10 -0600 Subject: [thelist] Tip Message-ID: Hi -- When putting a URL into an email, put it inside angle brackets, like so: . This makes it easier for people who want to visit the site to do so, as it clearly delineates to the email program what is the link and what is not. I often click on a link and get a 404 because the email program thought a closing parentheses or period was part of the URL. (Such as if someone typed http://www.evolt.org). Steve From pixelmech at yahoo.com Tue Dec 9 12:28:59 2003 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Tue, 9 Dec 2003 10:28:59 -0800 (PST) Subject: [thelist] Help with Javascript In-Reply-To: <3FD5B0E1.50701@hondaswap.com> Message-ID: <20031209182859.27407.qmail@web12602.mail.yahoo.com> > how about simply removing it? I think i speak for most people here > when I say i hate dhtml stuff. +1 Tom ===== http://www.pixelmech.com/ :: Web Development Services http://www.DMXzone.com/ :: JavaScript Author / Every Friday! http://www.thywordistruth.net/ :: Eternal Life [Those who say that I am finished, and am through, will have to run over my dead body to beat me...] From pixelmech at yahoo.com Tue Dec 9 12:30:30 2003 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Tue, 9 Dec 2003 10:30:30 -0800 (PST) Subject: [thelist] Dynamically populating a select list In-Reply-To: <20031209112723.28302.qmail@web60604.mail.yahoo.com> Message-ID: <20031209183030.85574.qmail@web12605.mail.yahoo.com> --- Stevenson N wrote: > What's wrong with my code given that all this are done on an > IFRAME? read: http://www.mattkruse.com/javascript/dynamicoptionlist/ To get a handle on that first. Not sure the iframe has anything to do with it (caveat: didn't read your code :P ) Tom ===== http://www.pixelmech.com/ :: Web Development Services http://www.DMXzone.com/ :: JavaScript Author / Every Friday! http://www.thywordistruth.net/ :: Eternal Life [Those who say that I am finished, and am through, will have to run over my dead body to beat me...] From paul at teltest.com Tue Dec 9 12:38:21 2003 From: paul at teltest.com (Paul Bennett) Date: Wed, 10 Dec 2003 07:38:21 +1300 Subject: [thelist] [PHP].csv file upload weirdness Message-ID: <3FD6169D.8030703@teltest.com> Hello there (thanks to all those who helped with the site check earlier this week) I have a script to load a .csv file to populate a database. The sql statement barfed at having single quotes in the file , so I removed them and re-uploaded the file. Trouble is, I get the same sql error, on the same line, even though *all* single quotes have been removed from the file. Even renaming the file and uploading it gives the same error. It is like the old file is cached in the tmp directory and being processed instead of the new one. I have checked for stray single quotes in Excel and Homesite and found not a one. Any ideas on how I can avoid this? Can I clear the tmp directory using php? confusedly yours, -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From paul at teltest.com Tue Dec 9 12:41:23 2003 From: paul at teltest.com (Paul Bennett) Date: Wed, 10 Dec 2003 07:41:23 +1300 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <5322923734.20031209011348@bitblaze.com> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <5322923734.20031209011348@bitblaze.com> Message-ID: <3FD61753.1000100@teltest.com> Daniel Schlyder wrote: > > >In your page: > >

> > > src="email-image.php?u=username&d=domain&font=4" > alt="username at domain" > style="vertical-align: middle" /> >

> > >mailto.php: > > >if (isset($_POST['u'])) >{ > header('Location: mailto:' . $_POST['u'] . '@' . $_POST['d']); >} > >?> > forgive me if I've missed something, but if you're going through all this trouble why not just use the php mail() function on this script? -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From steve at striderweb.com Tue Dec 9 12:23:46 2003 From: steve at striderweb.com (Stephen Rider) Date: Tue, 9 Dec 2003 12:23:46 -0600 Subject: [thelist] Web Graphics tip Message-ID: One more: When downsizing a large photographic image for the web, do it in steps if it's being reduced more than 50%. Reduce in 50% increments, and between each such step, apply an "Unsharp Mask" or similar filter. This will allow you to retain a good amount of perceived detail (such as edges) that would be otherwise lost by resizing in one big step. Regards, Steve From psm2713 at hotmail.com Tue Dec 9 13:02:11 2003 From: psm2713 at hotmail.com (Ken Moore) Date: Tue, 09 Dec 2003 12:02:11 -0700 Subject: [thelist] Database schema Message-ID: Hi all, Cosmin G wrote: >Hi. I've been asked to develop a database for a computer website. Right now >I have the following tables: >categories (1 - cpu's, 2 - hard-drives, ) >producer >product >exchange rate >All products have some common values (price, warranty period, description) >and there are some fields which are product specific (such as cpu >frequency, >cpu cache memory, etc). Right now I've stored all the product specific >fields in the products table and prefixed them with the name of the >category >they refer to. Is this a good approach or should I put them in separate >tables? The table is getting pretty unmanageable already. As a database programmer for 20 years, I have got several ideas. But I will need more info. Since I have just had a nearly unsolvable problem solved off-line (thank you very much Chris Rosser) I would be happy to help if you want to write with more details at psm2713 at hotmail.com. Specifically, what is the main purpose of the DB. The key is to design well. Once you have done that, many other problems become much easier. Ken. _________________________________________________________________ Winterize your home with tips from MSN House & Home. http://special.msn.com/home/warmhome.armx From joshua at waetech.com Tue Dec 9 13:59:16 2003 From: joshua at waetech.com (Joshua Olson) Date: Tue, 9 Dec 2003 14:59:16 -0500 Subject: [thelist] IIS custom error (CF) References: <9B34FC5E-2A05-11D8-A178-0030657D18E2@gozz.com> Message-ID: <052801c3be8e$ed376590$0300a8c0@client1> ----- Original Message ----- From: "Erik Mattheis" Sent: Tuesday, December 09, 2003 12:07 AM > I have IIS 5.1 set up to use the URL /index.cfm as the 404 error > handler. > > It doesn't work if the requested page is CF or if ".cfm" Erik, Under the website's properties, make sure that the "Check that file exists" is checked for the mapping for the CFM extension. You can find this under Home Page->Configuration...->.cfm Application Mapping->Edit Setting this checkbox should fix the problem. Good luck, <><><><><><><><><><> Joshua Olson Web Application Engineer WAE Tech Inc. http://www.waetech.com 706.210.0168 From Tab.Alleman at MetroGuide.com Tue Dec 9 14:21:03 2003 From: Tab.Alleman at MetroGuide.com (Tab Alleman) Date: Tue, 9 Dec 2003 15:21:03 -0500 Subject: [thelist] Database schema Message-ID: Cosmin G wrote: > Hi. I've been asked to develop a database for a computer website. > Right now I have the following tables: > categories (1 - cpu's, 2 - hard-drives, ) > producer > product > exchange rate > All products have some common values (price, warranty period, > description) and there are some fields which are product specific > (such as cpu frequency, cpu cache memory, etc). Right now I've stored > all the product specific fields in the products table and prefixed > them with the name of the category they refer to. Is this a good > approach or should I put them in separate tables? The table is > getting pretty unmanageable already. I favor splitting category-specific columns into separate tables. From evolt at goonies.info Tue Dec 9 14:30:33 2003 From: evolt at goonies.info (Minh Lee Goon) Date: Tue, 09 Dec 2003 14:30:33 -0600 Subject: [thelist] table height: 100% with CSS In-Reply-To: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> References: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> Message-ID: <3FD630E9.30207@goonies.info> You can use the deprecated cousin of the width attribute, called height. If you have multiple rows (e.g. a header row and a content row) in your table, you should specify the height of the header row as well (
) and the rest of the table will be 100% less 200px. Minh Lee > Maybe I'm having a stupid moment, but I can't see how to make a table 100% > high in CSS. From cs1spw at bath.ac.uk Tue Dec 9 14:35:59 2003 From: cs1spw at bath.ac.uk (Simon Willison) Date: Tue, 09 Dec 2003 14:35:59 -0600 Subject: [thelist] Web UI Question In-Reply-To: <004201c3bdc6$78e25920$0300000a@hershel2000> References: <004201c3bdc6$78e25920$0300000a@hershel2000> Message-ID: <3FD6322F.6040808@bath.ac.uk> Hershel Robinson wrote: > When he goes back in to edit one of these numbers, then it jumps to the left > again. This IS a bit weird, but the display looks nice. > > Any one have any thoughts on this? Ask some users. Or even better, run some usability tests and watch what the users do - if they seem unduly distrurbed by it, ditch it. Personally it sounds just fine to me - I've seen interfaces that do this before (doesn't Excel do exactly this?) and never been troubled by them. From joel at spinhead.com Tue Dec 9 14:52:27 2003 From: joel at spinhead.com (Joel D Canfield) Date: Tue, 9 Dec 2003 12:52:27 -0800 Subject: [thelist] Database schema Message-ID: <72E9FAA171D63B48AAC707C72900E6B45A1DA5@ireland.spinhead.com> Right now I've stored all the product specific > fields in the products table and prefixed them with the name > of the category > they refer to. Is this a good approach or should I put them > in separate > tables? The table is getting pretty unmanageable already. All the product stuff should go in 'products' What fields do you have in there? It's hard to imagine (for me, anyway) so many fields that it would be unmanageable. Maybe there *is* stuff in there that belongs elsewhere, but it's hard to say without seeing a field list. joel From Ed at ComSimplicity.com Tue Dec 9 15:16:04 2003 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Tue, 9 Dec 2003 13:16:04 -0800 Subject: [thelist] Database schema In-Reply-To: <004801c3be4c$218174f0$fc69e9d5@voltec01> Message-ID: > Right now I've stored all the product specific fields in the products > table and prefixed them with the name of the category they refer to. > Is this a good approach or should I put them in separate tables? The > table is getting pretty unmanageable already. It depends upon what you're doing with the data, but I'd be inclined to set up one table for each category. IMO, a good schema is one that accurately models the real world, and CPUs and hard drives aren't really the same kind of things. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ed McCarroll MailTo:Ed at ComSimplicity.com ComSimplicity (310) 838-4330 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - From joel at spinhead.com Tue Dec 9 15:20:47 2003 From: joel at spinhead.com (Joel D Canfield) Date: Tue, 9 Dec 2003 13:20:47 -0800 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; Message-ID: <72E9FAA171D63B48AAC707C72900E6B45A1DA7@ireland.spinhead.com> > Is the an ASP equivalent of PHP's syntax: > > $var = ($a == 0) ? 'hello' : 'goodbye'; If I'm understanding correctly (PHP rookie) this means if $a is zero, $var should be 'hello', otherwise it should be 'goodbye' If so, the shortest version I'm aware of in VBScript would be (with the variables renamed in a more VBScript manner, at least in my opinion): If (intA = 0) Then strVar = "hello" Else strVar = "goodbye" If there's a cool 'immediate if' shortcut like the PHP versoin, I'd love to know it. joel From tonyc at boldfish.co.uk Tue Dec 9 16:11:29 2003 From: tonyc at boldfish.co.uk (Tony Crockford) Date: Tue, 09 Dec 2003 22:11:29 -0000 Subject: [thelist] MySQl madness Message-ID: Maybe it's my choice of music or maybe it's just old age but how can the following list be ordered by cd_title? cd_ref cd_title cd_desc 5 Used Unrestored good used condition fully working 2 A1 Restored Perfect restored Condition 1 A1 Unrestored Perfect unrestored Condition 4 Pattern only Very poor condition to be used onlt for patterm ma... 3 Urgent action Poor Condition. Preservation required to prevent l... This is the mySQL query: SELECT * FROM cond_def ORDER BY cd_title How can U come before A? what am I not seeing? help me folks ;o) TIA Tony -- listening to: fame academy - perfect http://www.xebit.net From rob.smith at THERMON.com Tue Dec 9 16:46:07 2003 From: rob.smith at THERMON.com (Rob Smith) Date: Tue, 9 Dec 2003 16:46:07 -0600 Subject: [thelist] Graphics Art Question - Fireworks MX Message-ID: <0CEC8258A6E4D611BE5400306E1CC9271E5270@smtmb.tmc.local> > On 8/12/03 10:04 pm, "Rob Smith" wrote: > > > I have an image in Fireworks MX (PC) and I have two options on > > the marquee > > tool: square and circle. However, I want a marquee selection that has > > rounded corners. > Hi Rob, if you click and hold the marquee tool, an option for a round > corner selection should appear. julie, As I stated in my original email: ...the marquee tool: square and circle. (appears) You do not get an option for rounded corners in MM Fireworks MX for PC. Rob Geek note: technically speaking there is no such thing as squares or circles, only perfect rectangles, and perfect ovals exist. From evolt at funkwit.com Tue Dec 9 17:02:27 2003 From: evolt at funkwit.com (Paul Cowan) Date: Wed, 10 Dec 2003 10:02:27 +1100 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; In-Reply-To: <3FD5EA66.5050101@1976design.com> References: <3FD5EA66.5050101@1976design.com> Message-ID: <634785272.1071050547@[192.168.2.62]> Dunstan Orchard wrote: > Is the an ASP equivalent of PHP's syntax: > > $var = ($a == 0) ? 'hello' : 'goodbye'; > > I can't seem to find anything, but I know you can do it in JS, so I > presumed it was OK in ASP as well. As you say, it works in JS, so in ASP you could do: var = (a == 0) ? 'hello' : 'goodbye'; Unless, by "ASP", you meant "VBScript", in which case no, there's no direct equivalent. You have to do something like: if (a = 0) then var = "hello" else var = "goodbye" which isn't really the same thing at all, but will do what you want. Cheers, Paul From evolt_org at striderweb.com Tue Dec 9 17:01:16 2003 From: evolt_org at striderweb.com (Stephen Rider) Date: Tue, 9 Dec 2003 17:01:16 -0600 Subject: [thelist] Web Graphics tip Message-ID: <98374D72-2A9B-11D8-97E3-000A957FB6EA@striderweb.com> One more: When downsizing a large photographic image for the web, do it in steps if it's being reduced more than 50%. Reduce in 50% increments, and between each such step, apply an "Unsharp Mask" or similar filter. This will allow you to retain a good amount of perceived detail (such as edges) that would be otherwise lost by resizing in one big step. Regards, Steve From tonyc at boldfish.co.uk Tue Dec 9 17:44:46 2003 From: tonyc at boldfish.co.uk (Tony Crockford) Date: Tue, 09 Dec 2003 23:44:46 -0000 Subject: [thelist] Need Browser In-Reply-To: <6.0.0.22.0.20031209120845.02791cf0@netalytical.com> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <6.0.0.22.0.20031209120845.02791cf0@netalytical.com> Message-ID: On Tue, 09 Dec 2003 12:16:13 -0500, Scott Wolpow wrote: > I need a customizable browser that does the following: > > Mandatory > Supports Javascript and CSS and PSS (Print Style Sheets) > Secure Login > > Also need > Custom tool bar for both Nav, Back up and Print functions > Logon before it opens > > Lock in URL it goes to (It will be used for an online app > > Has a "message" light. (When they login it scans through a message > fields and lets them know if there is a message for them, not email > though, but that would also be nice) > > Relatively inexpensive, Perpetual license. > If you know of a solution let me know. If you can develop one let me > know off list. > Thanks (US) > Cheers (UK) > Scott Not sure if this is of any use: http://www.faronics.com/main.asp?pg=winselect We've used it on an Intranet used by Kids in public space and only found one glitch - somehow they get the help screens up (still haven't duplicated it, crafty little buggers!) but it will let you lock down windows browser, mouse and keyboard. Is that what you meant? hth Tony -- listening to: Favourite TV Classics - Puccini - Nessun Dorma (Turandot) http://www.xebit.net From gozz at gozz.com Tue Dec 9 17:46:09 2003 From: gozz at gozz.com (Erik Mattheis) Date: Tue, 9 Dec 2003 17:46:09 -0600 Subject: [thelist] IIS custom error (CF) In-Reply-To: <9B34FC5E-2A05-11D8-A178-0030657D18E2@gozz.com> Message-ID: > I have IIS 5.1 set up to use the URL /index.cfm as the 404 error > handler. > > It doesn't work if the requested page is CF or if ".cfm" Thank you Jeff and Josh! Home Directory > Configuration > .cfm > Check that file exists (ticked on) From greg at mapleleafweb.com Tue Dec 9 18:06:21 2003 From: greg at mapleleafweb.com (Greg Farries) Date: Tue, 9 Dec 2003 17:06:21 -0700 Subject: [thelist] "spamminess" site check - realtymort.com In-Reply-To: Message-ID: Steve wrote: > 1) The Site Map is brand-spanking new (as in, "yesterday"), so that's > not part of the issue. I added that in attempt to alleviate the > problem. Bad move or good move? Good move, but make sure not to go overboard and include to many links. According to the "Webmaster Guidelines" [http://www.google.com/webmasters/guidelines.html] at google, - Make a site with a clear hierarchy and text links. Every page should be reachable from at least one static text link. - Offer a site map to your users with links that point to the important parts of your site. If the site map is larger than 100 or so links, you may want to break the site map into separate pages. You might want to check out, http://www.useit.com/alertbox/20020106.html > 2) There are two domains pointing to the same site, so that may be > part of the problem (but wasn't before). > goes to the same site. Why not just forward traffic from aptrentals.com to realtymort.com and avoid the whole issue of multiple domains with the same content? According to google, - Don't create multiple pages, subdomains, or domains with substantially duplicate content. For more information, check out, http://www.webmasterworld.com/forum3/16277.htm > More generally, do you all know of a good source of "search engine > optimization" advice? http://www.webmasterworld.com http://searchenginewatch.com/ http://directory.google.com/Top/Computers/Internet/Searching/ HTH Cheers, Greg Farries Project Manager http://mapleleafweb.com Phone: 403.329.2286 Fax: 403.382.7148 Email: greg at mapleleafweb.com -------------- Canada's Premier Political Education Website From psm2713 at hotmail.com Tue Dec 9 18:15:48 2003 From: psm2713 at hotmail.com (Ken Moore) Date: Tue, 09 Dec 2003 17:15:48 -0700 Subject: [thelist] CRM Software needed. Message-ID: Hi all, Does anyone know of a good Customer Relation Management system that can be modified? MS Access would be nice. TIA, Ken _________________________________________________________________ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx From ken at adOpenStatic.com Tue Dec 9 18:30:40 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Wed, 10 Dec 2003 11:30:40 +1100 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; References: <3FD5EA66.5050101@1976design.com> Message-ID: <00b701c3beb4$d6e8d640$33345e81@careersAD.unsw.edu.au> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Dunstan Orchard" Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; : Is the an ASP equivalent of PHP's syntax: : : $var = ($a == 0) ? 'hello' : 'goodbye'; : : I can't seem to find anything, but I know you : can do it in JS, so I presumed it was OK in : ASP as well. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ASP is not a language. You can write ASP pages in JScript if you want. So the first step is probably telling us what language you want to write your ASP code in. Cheers Ken Microsoft MVP - Windows Server (IIS) From daniel at bitblaze.com Tue Dec 9 18:41:56 2003 From: daniel at bitblaze.com (Daniel Schlyder) Date: Wed, 10 Dec 2003 01:41:56 +0100 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <3FD61753.1000100@teltest.com> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <5322923734.20031209011348@bitblaze.com> <3FD61753.1000100@teltest.com> Message-ID: <14748172937.20031210014156@bitblaze.com> [09.12.2003 19:41:23] Paul Bennett: > Daniel Schlyder wrote: >>In your page: >> >>

>> >> >> > src="email-image.php?u=username&d=domain&font=4" >> alt="username at domain" >> style="vertical-align: middle" /> >>

>> >> >>mailto.php: >> >>> >>if (isset($_POST['u'])) >>{ >> header('Location: mailto:' . $_POST['u'] . '@' . $_POST['d']); >>} >> >>?> >> > forgive me if I've missed something, but if you're going through all > this trouble why not just use the php mail() function on this script? Because then it would no longer be a mailto link. To a user, the above form could be made to look more or less like a regular mailto link by applying CSS to the graphical submit button and modifying the PHP script that generates the image displaying the email address, and once clicked, it will open his or hers email client, as you would expect. Of course, if you want an address to be absolutely safe from spam, you'd just hide it server-side, behind a contact form, and send the submitted data using mail(). Regards, Daniel Schlyder From david at calteg.org Tue Dec 9 19:30:50 2003 From: david at calteg.org (David Siedband) Date: Tue, 9 Dec 2003 17:30:50 -0800 Subject: [thelist] Database schema In-Reply-To: References: Message-ID: <7CDE4D7E-2AB0-11D8-9077-0003938911D8@calteg.org> I would have the products table contain only the fields that are common to all product types. Then I'd have tables like ProdCPU, ProdMonitor, ProdOpticalDrives, ProdHardDrive to store the fields that are unique to particular product types and use joins to acquire these fields when you display items of that category. Each of these tables that extends the products table would have a foreign key with the unique ID of the item in the products table to join them to. -- Dave On Dec 9, 2003, at 12:21 PM, Tab Alleman wrote: > Cosmin G wrote: >> Hi. I've been asked to develop a database for a computer website. >> Right now I have the following tables: >> categories (1 - cpu's, 2 - hard-drives, ) >> producer >> product >> exchange rate >> All products have some common values (price, warranty period, >> description) and there are some fields which are product specific >> (such as cpu frequency, cpu cache memory, etc). Right now I've stored >> all the product specific fields in the products table and prefixed >> them with the name of the category they refer to. Is this a good >> approach or should I put them in separate tables? The table is >> getting pretty unmanageable already. > > I favor splitting category-specific columns into separate tables. > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From Olwen.Williams at safeair.co.nz Tue Dec 9 19:40:39 2003 From: Olwen.Williams at safeair.co.nz (Williams, Olwen - SAL) Date: Wed, 10 Dec 2003 14:40:39 +1300 Subject: [thelist] Database schema Message-ID: I'd be inclined to use an attribute type matrix. A one to may relationship of product type to attribute type, with the corresponding structure of products to product attributes. Olwen Williams olwen.williams at safeair.co.nz -----Original Message----- From: Ed McCarroll [mailto:Ed at ComSimplicity.com] Sent: Wednesday, December 10, 2003 10:16 AM To: thelist at lists.evolt.org Subject: RE: [thelist] Database schema > Right now I've stored all the product specific fields in the products > table and prefixed them with the name of the category they refer to. > Is this a good approach or should I put them in separate tables? The > table is getting pretty unmanageable already. It depends upon what you're doing with the data, but I'd be inclined to set up one table for each category. IMO, a good schema is one that accurately models the real world, and CPUs and hard drives aren't really the same kind of things. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ed McCarroll MailTo:Ed at ComSimplicity.com ComSimplicity (310) 838-4330 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! ____________________________________________________________________ CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Safe Air Ltd immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Safe Air. _____________________________________________________________________ For more information on the Safe Air Group, visit us online at http://www.safeair.co.nz/ _____________________________________________________________________ From ken at adOpenStatic.com Tue Dec 9 20:13:47 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Wed, 10 Dec 2003 13:13:47 +1100 Subject: [thelist] Database schema References: Message-ID: <040701c3bec3$3f0358f0$33345e81@careersAD.unsw.edu.au> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Ed McCarroll" Subject: RE: [thelist] Database schema : > Right now I've stored all the product specific fields : > in the products table and prefixed them with the : > name of the category they refer to. Is this a good : > approach or should I put them in separate tables? The : > table is getting pretty unmanageable already. : : It depends upon what you're doing with the data, but I'd : be inclined to set up one table for each category. IMO, : a good schema is one that accurately models the real : world, and CPUs and hard drives aren't really the : same kind of things. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I would argue that a good database schema reflects the entities, their attributes and the relationships between them. If the entity is a "computer component", and you are storing the same attributes for each component, then there's nothing wrong with having both hard disks, and CPUs stored in a "components" table. What is absolutely fundamental is accurate ER/EER modelling of the entities/relationships/attributes, plus a good idea of the types of things that the system is expected to do. The database schema will pretty much fall into place after that. Cheers Ken Microsoft MVP - Windows Server (IIS) From ken at adOpenStatic.com Tue Dec 9 20:17:59 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Wed, 10 Dec 2003 13:17:59 +1100 Subject: [thelist] Database schema References: <004801c3be4c$218174f0$fc69e9d5@voltec01> Message-ID: <041301c3bec3$d53d9970$33345e81@careersAD.unsw.edu.au> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Cosmin G" Subject: [thelist] Database schema : Hi. I've been asked to develop a database for a computer website. : Right now I have the following tables: : categories (1 - cpu's, 2 - hard-drives, ) : producer : product : exchange rate : All products have some common values (price, warranty : period, description) and there are some fields which are : product specific (such as cpu frequency, cpu cache memory, : etc). Right now I've stored all the product specific : fields in the products table and prefixed them with the name : of the category they refer to. Is this a good approach or : should I put them in separate tables? The table is : getting pretty unmanageable already. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ In order to solve this type of problem (given two+ possible ways of designing my tables): a) You *must* have an ER/EER diagram (or model, or whatever you want to call it). b) You *must* have some kind of systems model (a detailed DFD - or data flow diagram is probably most helpful in this situation). DO NOT start seriously modelling your data until you have (a) and (b) above (you certainly can play around with various types of things, but once you seriously start writing code, it'll become vastly more expensive to change the underlying database design). If you have both of these, then the database schema will write itself. Seriously, you need to use the tools that are out there that have been developed to solve exactly these types of problems ("what database schema should I use?") Once you have these things, then come back to us about any of the other thornier issues you may be having. Cheers Ken Microsoft MVP - Windows Server (IIS) From paul at teltest.com Tue Dec 9 20:43:51 2003 From: paul at teltest.com (Paul Bennett) Date: Wed, 10 Dec 2003 15:43:51 +1300 Subject: [thelist] MySQl madness In-Reply-To: References: Message-ID: <3FD68867.2060100@teltest.com> Tony Crockford wrote: > Maybe it's my choice of music or maybe it's just old age but how can > the following list be ordered by cd_title? > > cd_ref cd_title cd_desc > 5 Used Unrestored good used condition fully > working > 2 A1 Restored Perfect restored Condition > 1 A1 Unrestored Perfect unrestored Condition > 4 Pattern only Very poor condition to be used > onlt for patterm ma... > 3 Urgent action Poor Condition. Preservation > required to prevent l... > > > This is the mySQL query: > > SELECT * FROM cond_def ORDER BY cd_title try 'order by cd_title ASC' to ascend in alphabetic order also check there is no space in front of the 'Used Unrestored' title -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From ken at adOpenStatic.com Tue Dec 9 20:45:17 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Wed, 10 Dec 2003 13:45:17 +1100 Subject: [thelist] MySQl madness References: Message-ID: <054d01c3bec7$a52c5060$33345e81@careersAD.unsw.edu.au> Is there some kind of non-printing character prepended to the U? Echo the ASCII value of each character in that field to eliminate that possibility. Cheers Ken Microsoft MVP - Windows Server (IIS) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Tony Crockford" Subject: [thelist] MySQl madness : Maybe it's my choice of music or maybe it's just old age but how can the : following list be ordered by cd_title? : : cd_ref cd_title cd_desc : 5 Used Unrestored good used condition fully working : 2 A1 Restored Perfect restored Condition : 1 A1 Unrestored Perfect unrestored Condition : 4 Pattern only Very poor condition to be used onlt for patterm ma... : 3 Urgent action Poor Condition. Preservation required to prevent l... : : : This is the mySQL query: : : SELECT * FROM cond_def ORDER BY cd_title : : How can U come before A? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From syoung at unitec.ac.nz Tue Dec 9 21:35:46 2003 From: syoung at unitec.ac.nz (Stuart Young) Date: Wed, 10 Dec 2003 16:35:46 +1300 Subject: [thelist] "spamminess" site check - realtymort.com Message-ID: Steve Rider wrote: --------------- We've hovered around 80th place when searching for the phrase "chicago apartments" (it's primarily a building management company). Google redesigned their algorithm in November, and suddenly the page is nowhere to be found! It pops up if I search very specifically (as in the specific company name) so we're still in the database, but we don't show up anywhere under various types of keyword searches. More generally, do you all know of a good source of "search engine optimization" advice? --------------- Hugely famous topic on the WWW right now, you can't fail to find massive amounts of detail on this subject if you look. The Google update has been named the Florida update by Webmasterworld, a search engine optimisation specialist site. http://www.webmasterworld.com/ check out their Search Engine Optimisation (SEO) glossary to understand all the terms SEO professionals talk about in their forums. http://www.webmasterworld.com/glossary/ SearchEngineGuide and Search Engine Watch are good SEO websites. http://www.searchengineguide.com/ http://www.searchenginewatch.com/ The front pages of both sites are jam packed full of articles, resources and tips on the Florida update. Some of the best articles explaining the Florid update I've found are: Been Gazumped by Google? Trying to make Sense of the "Florida" Update! http://www.searchengineguide.com/lloyd/2003/1125_bl1.html Florida Fever: The Google Update Uproar http://www.searchengineguide.com/hotchkiss/2003/1204_gh1.html Q. I heard Google's dropping pages that show signs of search engine optimization. Do I need to deoptimize my web pages? http://www.searchenginewatch.com/searchday/article.php/3286101#deoptimize P.S. I was lucky, my commercial sites went up in the Florida update not down and out. cheers Dr Stuart Young, +64 (0)9-815 4321 Ex 8656 Lecturer, School of Computing and Information Technology, UNITEC Institute of Technology, Auckland, New Zealand http://hyperdisc.unitec.ac.nz/staff/syoung.htm I would provide a URL for my official staffpage, but its too long and complex From mdinowit at houseoffusion.com Tue Dec 9 21:57:40 2003 From: mdinowit at houseoffusion.com (Michael Dinowitz) Date: Tue, 9 Dec 2003 22:57:40 -0500 Subject: [thelist] "spamminess" site check - realtymort.com References: Message-ID: <32ce01c3bed1$c23ff6c0$6401a8c0@dinowitz.com> I have the problem even worse. House of Fusion (www.houseoffusion.com) has been a major ColdFusion community site for almost 8 years now and if you do a search for ColdFusion on Google, we don't even come up. We do have several tens of thousands of links indexed by google (I run and archive some very large volume mailing lists), but none under the most basic keyword. > Hi evolters -- > > I work for a company that has had a website for a number of years. > We've never had _great_ ranking on Google, but we've always been there. > > The boss-man is absolutely driven to raise the rankings in search > engines (I explained to him that Google's entire business model depends > on web coders not being able to directly manipulate the rankings, but > he doesn't want to hear it...), so he keeps insisting that I keep > tweaking word order in Title tags and such, in a vain attempt to find > the perfect "keyword" optimization. > > In an attempt to help this issue (and several other such as browser > compatibility), I rewrote the site about six months ago using pure > XHTML and CSS, which among other things majorly increase the > content-to-noise ratio of the pages, improved structure, etc.... > > We've hovered around 80th place when searching for the phrase "chicago > apartments" (it's primarily a building management company). Google > redesigned their algorithm in November, and suddenly the page is > nowhere to be found! It pops up if I search very specifically (as in > the specific company name) so we're still in the database, but we don't > show up anywhere under various types of keyword searches. > > Here is the site: > > > I thought the site was well done in terms of readabiloity to search > engines and such, and I'm not doing anything blatantly "spammy", AFAIK. > Am I missing something? Is there something I'm doing horribly wrong > here? > > Notes: > 1) The Site Map is brand-spanking new (as in, "yesterday"), so that's > not part of the issue. I added that in attempt to alleviate the > problem. Bad move or good move? > > 2) There are two domains pointing to the same site, so that may be part > of the problem (but wasn't before). goes > to the same site. > > 3) The words "Chicago Apartments" was recently added to the beginning > of all page titles... not sure if this is the problem or not, just an > FYI. Doesn't seem to be too terrible of a crime, but slightly "spammy" > > Please take a look. All advice is appreciated. > > More generally, do you all know of a good source of "search engine > optimization" advice? > > Regards, (and tips forthcoming) > Steve Rider > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From damiencola at wanadoo.fr Tue Dec 9 23:12:00 2003 From: damiencola at wanadoo.fr (Damien COLA) Date: Wed, 10 Dec 2003 06:12:00 +0100 Subject: [thelist] MySQl madness In-Reply-To: Message-ID: <001001c3bedc$24a10200$0100a8c0@ELECTRA> This maybe if you have a space character before U, thenit will be placed before A and if you list the results in HTML you may not be able to see the space character if you've already using a space character when displaying results. because HTML will display only one space when there are more than one. -----Original Message----- This is the mySQL query: SELECT * FROM cond_def ORDER BY cd_title How can U come before A? what am I not seeing? help me folks ;o) From jcbullas at nildram.co.uk Tue Dec 9 00:40:36 2003 From: jcbullas at nildram.co.uk (John C Bullas) Date: Tue, 09 Dec 2003 06:40:36 +0000 Subject: [thelist] Preventing spam spiders from reading mailto links. In-Reply-To: <000001c3bc80$e00c15b0$4930e918@Thelonius> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> Message-ID: <6.0.1.1.0.20031209063537.02475158@pop3.nildram.co.uk> At 05:13 07/12/2003, Philip Weller wrote >Hello, all. > > (I'm aware of Daniel >Benjamin's Hiveware Enkoder (http://hiveware.com/enkoder_form.php) and think >he's providing a wonderful service, but I've chosen not to use it because it >relies on JavaScript and won't work for users who've disabled it.) an easy way is to "mung" the mailto: address BUT this assumes "clued up" users! OR direct people to a webform instead of an email address....... you have the form set to send "from" some obscure address on your own domain you set a challenge response service up for that domain....... you have the only approved incoming address as the one the form sends from the rest get the "spamArrest" treatment.... if someone gets wise to this you can easily block this "from" and start a new one ;) FB I sadly use a little javascript for munging my emails where I want to use mailto: (inconsiderate ain't I?) >Many Thanks, >Philip Weller From Brian at hondaswap.com Wed Dec 10 00:02:32 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Wed, 10 Dec 2003 01:02:32 -0500 Subject: [thelist] "spamminess" site check - realtymort.com In-Reply-To: <32ce01c3bed1$c23ff6c0$6401a8c0@dinowitz.com> References: <32ce01c3bed1$c23ff6c0$6401a8c0@dinowitz.com> Message-ID: <3FD6B6F8.3020804@hondaswap.com> >>Here is the site: >> just something i noticed that is definitly holding you back a little... you format your links as such: technically, thats not a page. google will index faster and show mroe relevence to over the above. From russ at unrealisticexpectations.com Wed Dec 10 00:21:58 2003 From: russ at unrealisticexpectations.com (Russ) Date: Wed, 10 Dec 2003 00:21:58 -0600 Subject: [thelist] More on Search Engines In-Reply-To: <32ce01c3bed1$c23ff6c0$6401a8c0@dinowitz.com> Message-ID: <00c401c3bee5$ea91fc90$1d03a8c0@autolycus> I'm probably going to cause a lot of problems by noting this, but... There's a company (http://www.brainfusionstudios.com) out there that has performed a "trick" that appears as if it won't get them into trouble with the search engines, because it's somewhat legit from a spider's view--at least in my understanding of how spiders work. Remember that spiders really don't see things like colors and images, but they read pages a lot like a text-only browser, if I'm recalling my SEO information correctly. Start here: http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=brainfusionst udios Check out some of the links like "denver dating service". The real link (since the above is timing out for me) redirects you through http://brainfusionstudios.com/sales/denvergraphicdesign.htm. This page uses some type of technology (I'm guessing CGI) that actually writes text to the page based upon what you've searched/clicked on--in this case, denvergraphicdesign--populates the copy on the page accordingly. Take a moment and stop your browser on the denvergraphicdesign.htm page and view the source. The same happens for chicagographicdesign.htm and others. Now, this is where it gets fun. There's a div with an ID of "zyx". "zyx" comes from a linked style sheet at: http://brainfusionstudios.com/zyx.css. That style is: #zyx { position:absolute; left:-405px; top:-210px; width:400px; height:200px; z-index:1} What brainfusionstudios.com has done is placed copy at -405, -210--that's right, above and to the left of your browsers viewable space--so that you cannot see it with a modern browser. This is somewhat of a risk for anyone viewing the pages with a text browser (lynx viewer version: http://www.delorie.com/web/lynxview.cgi?url=http%3A%2F%2Fbrainfusionstud ios.com%2Fsales%2Fdenvergraphicdesign.htm) as they'll get to see everything on the page, however... They've created TONS of links to themselves this way--probably unbeknownst to some of their clients and to the rest of the world, but it should increase their link popularity and their site popularity WITHOUT appearing to be directing everything to one single page since the content gets rewritten, as well. Granted, I'm making some semi-educated guesses here, but these guys appear to be legitimately beating the system by fooling any relatively modern browser into not seeing the copy. Anyone using a text based browser--or heaven forbid--a person with a disability would find a lot of this stuff useless, but most of it is out of the way. It certainly does explain how www.sinatrafamily.com makes it to page 2 of the Google search results for "Chicago Web Design" however (http://www.google.com/search?q=chicago+web+design&hl=en&lr=&ie=UTF-8&oe =UTF-8&start=10&sa=N) and might explain why some of the results seem out of whack in certain areas. I've probably not answered any questions, and I apologize for that--it all seems relevant in regards to how Google has changed things and people appear to be getting strange results. > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Michael Dinowitz > Sent: Tuesday, December 09, 2003 9:58 PM > To: thelist at lists.evolt.org > Subject: Re: [thelist] "spamminess" site check - realtymort.com > > > I have the problem even worse. House of Fusion > (www.houseoffusion.com) has been > a major ColdFusion community site for almost 8 years now and > if you do a search > for ColdFusion on Google, we don't even come up. We do have > several tens of > thousands of links indexed by google (I run and archive some > very large volume > mailing lists), but none under the most basic keyword. > > > > Hi evolters -- > > > > I work for a company that has had a website for a number of years. > > We've never had _great_ ranking on Google, but we've always > been there. > > > > The boss-man is absolutely driven to raise the rankings in search > > engines (I explained to him that Google's entire business > model depends > > on web coders not being able to directly manipulate the > rankings, but > > he doesn't want to hear it...), so he keeps insisting that I keep > > tweaking word order in Title tags and such, in a vain > attempt to find > > the perfect "keyword" optimization. > > > > In an attempt to help this issue (and several other such as browser > > compatibility), I rewrote the site about six months ago using pure > > XHTML and CSS, which among other things majorly increase the > > content-to-noise ratio of the pages, improved structure, etc.... > > > > We've hovered around 80th place when searching for the > phrase "chicago > > apartments" (it's primarily a building management company). Google > > redesigned their algorithm in November, and suddenly the page is > > nowhere to be found! It pops up if I search very > specifically (as in > > the specific company name) so we're still in the database, > but we don't > > show up anywhere under various types of keyword searches. > > > > Here is the site: > > > > > > I thought the site was well done in terms of readabiloity to search > > engines and such, and I'm not doing anything blatantly > "spammy", AFAIK. > > Am I missing something? Is there something I'm doing > horribly wrong > > here? > > > > Notes: > > 1) The Site Map is brand-spanking new (as in, "yesterday"), > so that's > > not part of the issue. I added that in attempt to alleviate the > > problem. Bad move or good move? > > > > 2) There are two domains pointing to the same site, so that > may be part > > of the problem (but wasn't before). > goes > > to the same site. > > > > 3) > The words "Chicago Apartments" was recently added to the beginning > > of all page titles... not sure if this is the problem or > not, just an > > FYI. Doesn't seem to be too terrible of a crime, but > slightly "spammy" > > > > Please take a look. All advice is appreciated. > > > > More generally, do you all know of a good source of "search engine > > optimization" advice? From evolt at zamba.com Wed Dec 10 00:25:39 2003 From: evolt at zamba.com (Tony Page) Date: Wed, 10 Dec 2003 17:25:39 +1100 Subject: [thelist] Mod_rewrit and classic sysadmin response Message-ID: <01b001c3bee6$6e31f870$8e01a8c0@Workstation> I need to use mod_rewrite with my Gallery software but only a module called mod_rewrit is available on the server (Apache/Linux). After extensive google etc research trying to find some info on it ended in dismal failure (the only thing I found out was that it was supposed to be a "more secure" version of mod_rewrite, and that lots of other people were asking the same question as me) I finally received this classic comment from the Alabanza sysadmin: "We use mod_rewrit for security purposes and can not (sic) tell anyone how it works." One suggestion was to use mod_alias instead but I'm not sure whether this would work. It's also a pain because the Gallery program is designed to use mod_rewrite and config is virtually automatic. Anyone got any info on mod_rewrit or ideas about workarounds? Tony Page [ZambaGrafix] tel: +61 2 9953 4425 fax: +61 2 9909 8534 email: ajp at zambagrafix.com http://www.zambagrafix.com From english_offline at yahoo.com Wed Dec 10 00:36:38 2003 From: english_offline at yahoo.com (Administrative HQ) Date: Tue, 9 Dec 2003 22:36:38 -0800 (PST) Subject: [thelist] ASPEmail Help (Long) Message-ID: <20031210063638.77028.qmail@web11401.mail.yahoo.com> Hi. We're redesigning a site with a subdomain. It needs a visual workover but, first, there's a functional problem. There is a "Recommend a Friend" form which works on the main site but - on the subdomain returns an error notice: Persits.MailSender.4 error '800a0004' Cannot assign requested address. /sendmailinc.asp, line 47 ------ The source for the form can be seen is: Web Design- Ingla

 

") body=body & Request.Form.Key(x) & ": " & Request.Form.item(x) & vbCrLf 'body = body & item & ": " & Request.Form(item) & vbcrlf if Request.Form.key(x)="E-mail" or Request.Form.key(x)="e-mail" or Request.Form.key(x)="email" or Request.Form.key(x)="Email" then efrom=Request.Form.item(x) next 'Response.Write body rec=Request.item("recipient") subj=Request.Item("subject") 'set the email from if we have one ! if efrom="" then efrom="WebDesign at ingla.com" sendmail rec, efrom, subj, body, "",Request.Item("lang"),"","" if Request("to_friend")="y" then ' Response.Write body select case ucase(Request("Language")) case "EN" if request("email1") <> "" then efrom="WebDesign at ingla.com" subj=Request.item("name") & " recommends Ingla Design" body = "Hello " & Request("friend1")&"!" & vbCrLf & vbCrLf & Request.item("name") &" thinks our site will interest you. Please take a minute and visit us." & vbCrLf & vbCrLf &"You will be able to view the site if you visit" & vbcrlf & vbcrlf &"http://design.ingla.com" rec=Request("email1") sendmail rec, efrom, subj, body, "", "EN", "","" end if if request("email2") <> "" then efrom="WebDesign at ingla.com" subj=Request.item("name") & " recommends Ingla Design" body = "Hello " & Request("friend2")&"!" & vbCrLf & vbCrLf & Request.item("name") &" thinks our site will interest you. Please take a minute and visit us." & vbCrLf & vbCrLf &"You will be able to view the site if you visit" & vbcrlf & vbcrlf &"http://design.ingla.com" rec=Request("email2") sendmail rec, efrom, subj, body, "", "EN", "","" end if if request("email3") <> "" then efrom="WebDesign at ingla.com" subj=Request.item("name") & " recommends Ingla Design" body = "Hello " & Request("friend3")&"!" & vbCrLf & vbCrLf & Request.item("name") &" thinks our site will interest you. Please take a minute and visit us." & vbCrLf & vbCrLf &"You will be able to view the site if you visit" & vbcrlf & vbcrlf &"http://design.ingla.com" rec=Request("email3") sendmail rec, efrom, subj, body, "", "EN", "","" end if case "HE" 'DAVID do hebrew email here if request("email1") <> "" then efrom="forms at ingla.com" subj="מציע את אתרנו "& Request.item("name") body = "שלום " & Request("friend1")& vbCrLf & vbCrLf & Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה" & vbCrLf & vbCrLf &"www.ingla.com" rec=Request("email1") 'sendmail rec, efrom, subj, body, "", "HE", "","" 'and now in html body=""_ &""_ &"

Recommend us to a friend.

Your Name:  
Friend's Name:
Friend's Email:
 
 
Friend's Name 2:
Friend's Email 2:
 
 
Friend's Name 3:
Friend's Email 3:
 
 
 
------ There are 2 asp pages needed to send. ------ One is: sendmail.asp which reads as follows: <%@ Language=VBScript %> <%Response.Buffer=true%> <% 'sub sendmail(rec, from, subj, body, [cc], [lang], [attach], [other]) 'Copyright - Duddy Iczkovits 2002-2010 'duddy at iczkovits.com dim rec, efrom, subj, body, x efrom="" body="---------------------" & vbcrlf &"This form was received at server at:" & vbcrlf & "---------------------" & vbcrlf body=body& "Date: " & date & vbcrlf body=body& "Time: " & time & vbcrlf body= body & vbcrlf & "----------------" & vbcrlf & "User Info" & vbcrlf & "----------------" & vbcrlf body=body & "Browser: " & Request.ServerVariables("HTTP_USER_AGENT") & vbcrlf body=body & "Remote(usr) Ip: " & Request.ServerVariables("REMOTE_ADDR") & vbcrlf body=body & "Sever Ip: " & Request.ServerVariables("LOCAL_ADDR") & vbcrlf body=body & "Referer: " & Request.ServerVariables("HTTP_REFERER") & vbcrlf body=body & vbcrlf & "----------------" & vbcrlf & "Form Info" & vbcrlf& "----------------" & vbcrlf body=body & vbcrlf & "Lang: " & Request.item("Language") & vbcrlf 'Response.Write Request.Form.Count for x=1 to Request.Form.Count 'check if the item should be displayed (hidden) 'if item="recipient" or item="subject" or item="redirect" or item="conformation" then 'do nothing, cause we not want it 'else 'Response.Write ("
" & Request.Form.key(x) & ": "& Request.Form.Item(x) &"
"_ &""_ &""_ &""_ &""_ &""_ &""_ &"
"& Request("friend1")_ &" שלום
 
"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לקחת כמה דקות לבקר אותנו בכתובת הבאה
 
www.ingla.com
 
להתראות
" ' body=""&" שלום "& Request("friend1")_ ' &"


"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה "_ ' &"


"&"www.ingla.com" sendmail rec, efrom, subj, body, "", "HE", "","HTML" end if if request("email2") <> "" then efrom="forms at ingla.com" subj="מציע/ה לך את האתר שלנו "&Request.item("name") body = "שלום " & Request("friend2")& vbCrLf & vbCrLf & Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה" & vbCrLf & vbCrLf &"www.ingla.com" rec=Request("email2") 'sendmail rec, efrom, subj, body, "", "HE", "","" 'and now in html body=""_ &""_ &""_ &""_ &""_ &""_ &""_ &""_ &""_ &"
"& Request("friend2")_ &" שלום
 
"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לקחת כמה דקות לבקר אותנו בכתובת הבאה
 
www.ingla.com
 
להתראות
" 'body=""&" שלום "& Request("friend2")_ '&"


"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה "_ '&"


"&"www.ingla.com" sendmail rec, efrom, subj, body, "", "HE", "","HTML" end if if request("email3") <> "" then efrom="forms at ingla.com" subj="מציע/ה לך את האתר שלנו "&Request.item("name") body = "שלום " & Request("friend3")& vbCrLf & vbCrLf & Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה" & vbCrLf & vbCrLf &"www.ingla.com" rec=Request("email3") 'sendmail rec, efrom, subj, body, "", "HE", "","" 'and now in html body=""_ &""_ &""_ &""_ &""_ &""_ &""_ &""_ &""_ &"
"& Request("friend3")_ &" שלום
 
"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לקחת כמה דקות לבקר אותנו בכתובת הבאה
 
www.ingla.com
 
להתראות
" 'body=""&" שלום "& Request("friend3")_ '&"


"& Request.item("name") &" חושב/ת שהאתר שלנו יעניין אותך. נא לבקר אותנו בכתובת הבאה "_ '&"


"&"www.ingla.com" sendmail rec, efrom, subj, body, "", "HE", "","HTML" end if case "ES" 'david do spanish eamil here if request("email1") <> "" then efrom="forms at ingla.com" subj=Request.item("name") & " recomienda www.ingla.com" body = "Hola " & Request("friend1")&"!" & vbCrLf & vbCrLf & Request.item("name") &" cree que nuestro sitio te interesarב y nos pidiף que te enviemos esta invitaciףn."& vbCrLf & vbCrLf &"Por favor, toma un minuto de tu tiempo y visםtanos" & vbcrlf & vbcrlf &"www.ingla.com" rec=Request("email1") sendmail rec, efrom, subj, body, "", "ES", "","" end if if request("email2") <> "" then efrom="forms at ingla.com" subj=Request.item("name") & " recomienda www.ingla.com" body = "Hola " & Request("friend2")&"!" & vbCrLf & vbCrLf & Request.item("name") &" cree que nuestro sitio te interesarב y nos pidiף que te enviemos esta invitaciףn."& vbCrLf & vbCrLf &" Por favor, toma un minuto de tu tiempo y visםtanos." & vbCrLf & vbCrLf &"www.ingla.com" rec=Request("email2") sendmail rec, efrom, subj, body, "", "ES", "","" end if if request("email3") <> "" then efrom="forms at ingla.com" subj=Request.item("name") & " recomienda www.ingla.com" body = "Hola " & Request("friend3")&"!" & vbCrLf & vbCrLf & Request.item("name") &" cree que nuestro sitio te interesarב y nos pidiף que te enviemos esta invitaciףn." & vbCrLf & vbCrLf &"Por favor, toma un minuto de tu tiempo y visםtanos" & vbcrlf & vbcrlf &"www.ingla.com" rec=Request("email3") sendmail rec, efrom, subj, body, "", "ES", "","" end if end select Response.Redirect Request.item("redirect") else Response.Redirect Request.item("redirect") end if --> %> Thank you. Your form has been mailed.

------ The 2nd is: sendmailinc.asp which reads like this: <% dim Mail sub sendmail(rec, from, subj, body, cc, lang, attach, other) Set Mail = Server.CreateObject("Persits.MailSender") Mail.Host = Application("ServerAddress") 'Mail.AddAddress Request.Form("sTxtTo") Mail.AddAddress rec 'Mail.AddAddress "WebDesign at ingla.com" if cc<>"" then Mail.AddAddress cc Mail.Subject=subj if from<>"" then Mail.From=from else Mail.From="WebDesign at ingla.com" end if if ucase(other)="HTML" then Mail.IsHTML=TRUE select case ucase(lang) case "EN" 'nothing case "ES" Mail.AddCustomHeader("Content-Type: text/html;" & chr(13) & " charset=""windows-1252""") case "HE" Mail.AddCustomHeader("Content-Type: text/html;" & chr(13) & " charset=""windows-1255""") end select else select case ucase(lang) case "EN" 'nothing case "ES" Mail.CharSet="windows-1252" case "HE" Mail.CharSet="windows-1255" end select end if Mail.Body=body Mail.Send If Err <> 0 Then Response.Write "Error encountered: " & Err.Description End If end sub %> ------ Any help on finding the problem would be greatly appreciated. Thanks. David __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ From tonyc at boldfish.co.uk Wed Dec 10 00:39:35 2003 From: tonyc at boldfish.co.uk (Tony Crockford) Date: Wed, 10 Dec 2003 06:39:35 -0000 Subject: [thelist] MySQl madness In-Reply-To: <001001c3bedc$24a10200$0100a8c0@ELECTRA> References: <001001c3bedc$24a10200$0100a8c0@ELECTRA> Message-ID: On Wed, 10 Dec 2003 06:12:00 +0100, Damien COLA wrote: > This maybe if you have a space character before U, thenit will be placed > before A and if you list the results in HTML you may not be able to see > the space character if you've already using a space character when > displaying results. because HTML will display only one space when there > are more than one. > > -----Original Message----- > This is the mySQL query: > > SELECT * FROM cond_def ORDER BY cd_title > > How can U come before A? > > what am I not seeing? > > help me folks ;o Absolutely on the button. ten minutes after posting I spotted it, but too late to retract. How dumb am I? Thanks Tony From andrew at arcticcircle.co.za Wed Dec 10 01:18:38 2003 From: andrew at arcticcircle.co.za (Andrew Bayley) Date: Wed, 10 Dec 2003 09:18:38 +0200 Subject: [thelist] Help with Javascript Message-ID: Sometimes the "dhtml stuff" as you call it, can be useful. Like most things out there, it is not the tool, but the application of it that makes all the difference. There are a lot of sites out there that have benefited in one way or another from careful application of these scripts. However, I must conceed, that the fading menu is a bit over the top :-) how about simply removing it? I think i speak for most people here when I say i hate dhtml stuff. From mark at mark.ac Wed Dec 10 01:09:48 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 08:09:48 +0100 Subject: [thelist] table height: 100% with CSS In-Reply-To: <3FD630E9.30207@goonies.info> References: <50229.135.196.95.234.1070896320.squirrel@www.johnallsopp.co.uk> <3FD630E9.30207@goonies.info> Message-ID: > You can use the deprecated cousin of the width attribute, called > height. > ... though it's worth noting that because it's deprecated, newer browsers are less likely to support it. Regards From mark at mark.ac Wed Dec 10 01:13:14 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 08:13:14 +0100 Subject: [thelist] Need Browser In-Reply-To: References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <6.0.0.22.0.20031209120845.02791cf0@netalytical.com> Message-ID: <52423794-2AE0-11D8-A6C6-000393143F96@mark.ac> > We've used it on an Intranet used by Kids in public space and only > found one glitch - somehow they get the help screens up (still haven't > duplicated it, crafty little buggers!) f11 ? Regards Mark Howells http://www.mark.ac/ From jeff at jeffhowden.com Wed Dec 10 02:44:58 2003 From: jeff at jeffhowden.com (Jeff Howden) Date: Wed, 10 Dec 2003 00:44:58 -0800 Subject: [thelist] More on Search Engines In-Reply-To: <00c401c3bee5$ea91fc90$1d03a8c0@autolycus> Message-ID: russ, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Russ > > There's a company (http://www.brainfusionstudios.com) > out there that has performed a "trick" that appears as > if it won't get them into trouble with the search > engines, because it's somewhat legit from a spider's > view--at least in my understanding of how spiders work. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< it's not legit. it's a doorway page. it's sole purpose is to be spider food. if that weren't the case, there wouldn't be a need for the "tricky" css or the instant js redirect. ask any seo expert with an ounce of ethics (if you can find one) and they'll call it spam. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > The real link (since the above is timing out for me) > redirects you through > http://brainfusionstudios.com/sales/denvergraphicdesign.htm. > This page uses some type of technology (I'm guessing > CGI) that actually writes text to the page based upon > what you've searched/clicked on--in this case, > denvergraphicdesign--populates the copy on the page > accordingly. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< it'd be impossible/pointless to write the page based on your search words seeing as how search engines don't perform searches and they don't pass referers. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > There's a div with an ID of "zyx". "zyx" comes from a > linked style sheet at: > http://brainfusionstudios.com/zyx.css. > > That style is: #zyx { position:absolute; left:-405px; > top:-210px; width:400px; height:200px; z-index:1} > > What brainfusionstudios.com has done is placed copy at > -405, -210--that's right, above and to the left of your > browsers viewable space--so that you cannot see it with > a modern browser. [...] ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< i'm not sure i see the point of going through these css contortions to begin with since they're just doing an instant redirect via js anyway. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > This is somewhat of a risk for anyone viewing the pages > with a text browser (lynx viewer version: > http://www.delorie.com/web/lynxview.cgi?url=http%3A%2F%2Fbrainfusionstud > ios.com%2Fsales%2Fdenvergraphicdesign.htm) as they'll > get to see everything on the page, however... ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< what's an even greater risk is that anyone with js that ends up on one of these doorway pages will have a difficult time finding their way to a functional page of the site. what's sad is that it looks like they've combined *all* the copy from every functional page on their site, tossed in some locals into the mix and spray painted every one of these doorway pages with the copy. duplicate copy *will* get them penalized by google. it's only a matter of time. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > They've created TONS of links to themselves this way-- > probably unbeknownst to some of their clients and to the > rest of the world, but it should increase their link > popularity and their site popularity WITHOUT appearing > to be directing everything to one single page since > the content gets rewritten, as well. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< unfortunately for them, link popularity doesn't count nearly as much when you're linking to yourself, especially when all the pages with all the links are all doorway pages. how can you, or rather a search engine, tell they're doorway pages? simple, take an inventory of all the pages on the site and draw lines between all the pages that have links to each other with arrows showing which direction the link is going. it becomes apparent relatively quick which ones are functional and which ones are doorway pages. on a side-note, i found the constant click-redirect behavior on that site very annoying. they don't even have the decency to use the replace() method in js so the page i'm redirected from isn't in my browser history. i can only imagine what damage this "genius" must do to the site statistics. *shrug* when it comes to search engine ranking, imo, it comes down to the same old thing that's the draw for real-live viewers, content, content, content. look at evolt.org. zero search engine promotion. yet there are numerous search terms that we come up in the top 5 results. .jeff ------------------------------------------------------ Jeff Howden - Web Application Specialist Resume - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From ngilas2003 at yahoo.com Wed Dec 10 03:03:24 2003 From: ngilas2003 at yahoo.com (Stevenson N) Date: Wed, 10 Dec 2003 01:03:24 -0800 (PST) Subject: [thelist] Namespace Message-ID: <20031210090324.83562.qmail@web60604.mail.yahoo.com> Hi, Am currently using the namespace: because i can't use: with: Now my problem is, i need to add but i get the following error: Keyword xsl:variable may not be used in namespace http://www.w3.org/TR/WD-xsl. What name space may i use that is compatible both with : and Please assist!! --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard From tonyc at boldfish.co.uk Wed Dec 10 03:12:40 2003 From: tonyc at boldfish.co.uk (Tony Crockford) Date: Wed, 10 Dec 2003 09:12:40 -0000 Subject: [thelist] Need Browser In-Reply-To: <52423794-2AE0-11D8-A6C6-000393143F96@mark.ac> References: <000001c3bc80$e00c15b0$4930e918@Thelonius> <6.0.0.22.0.20031209120845.02791cf0@netalytical.com> <52423794-2AE0-11D8-A6C6-000393143F96@mark.ac> Message-ID: On Wed, 10 Dec 2003 08:13:14 +0100, Mark Howells wrote: >> We've used it on an Intranet used by Kids in public space and only >> found one glitch - somehow they get the help screens up (still haven't >> duplicated it, crafty little buggers!) > > f11 ? Nope, we mechanically restricted access to the function keys. need a close up camera, half the time they don't know how they did it ;o) From dchampion at clacks.gov.uk Wed Dec 10 03:26:10 2003 From: dchampion at clacks.gov.uk (Daniel Champion) Date: Wed, 10 Dec 2003 09:26:10 +0000 Subject: [thelist] "spamminess" site check - realtymort.com Message-ID: > you format your links as such: > technically, thats not a page. google will index faster and show mroe > relevence to over the above. Brian, I'm intrigued by this because I haven't seen this behaviour (quite the opposite in fact). What evidence do you have of Google behaving this way, because if you're right I'm looking at a couple of major site rewrites! For example on our main site every content page has a url which might appear to be a directory link... I was under the impression that Google didn't care a jot what a url ends with, their bot will visit it and index it. Daniel. -- Daniel Champion - Web Dev Mgr - Clackmannanshire Council e: dchampion at clacks.gov.uk t: 01259 452258 f: 01259 452240 w: http://www.clacksweb.org.uk ********************************************************************** This email and any attachments have been scanned for viruses prior to leaving Clackmannanshire Council. Clackmannanshire Council will not be liable for any losses as a result of viruses being passed on. www.clacksweb.org.uk ********************************************************************** From mark at mark.ac Wed Dec 10 03:23:46 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 10:23:46 +0100 Subject: [thelist] More on Search Engines In-Reply-To: References: Message-ID: <8E89C74C-2AF2-11D8-ADBF-000393143F96@mark.ac> > when it comes to search engine ranking, imo, it comes down to the same > old > thing that's the draw for real-live viewers, content, content, content. > look at evolt.org. zero search engine promotion. yet there are > numerous > search terms that we come up in the top 5 results. I'd have to agree with this point. I have never actively promoted my site (http://www.mark.ac/) or my current work projects with search engines in mind, yet a logical and valid (X)HTML structure and "proper", engine-friendly links - no "click here" links - ensure that my sites are high in the listings for their categories. Viz: Mark Howells Online http://www.google.com/search?q=photos+of+switzerland http://www.google.com/search?q=journal+switzerland http://www.google.com/search?q=weblog+switzerland Gossweiler Media http://www.google.com/search?q=zeitung+interlaken Alpenregion.ch http://www.google.com/search?q=restaurant+brienz As Jeff says: focus on content, rather than elaborate programming solutions, to get a good result. That is the best and IMO only decent solution. Best regards Mark Howells http://www.mark.ac/ From marcan at home.se Wed Dec 10 03:37:26 2003 From: marcan at home.se (Marcus Andersson) Date: Wed, 10 Dec 2003 10:37:26 +0100 Subject: SV: [thelist] Namespace In-Reply-To: <20031210090324.83562.qmail@web60604.mail.yahoo.com> Message-ID: <000401c3bf01$38f8d550$0500a8c0@marcusnb> You shouldn't use http://www.w3.org/TR/WD-xsl as your namespace since that is an old spec of XSL that MS produced before XSLT1.0 was ready. Read more about it here: http://www.netcrucible.com/xslt/msxml-faq.htm#Q4 The old MS spec(namespace if you want) doesn't, of course, support variable (as a lot of other things). I'm not really sure what you want to achieve with your attribute element so if you could post a more complete example then I might be able to help you on that one because what you want to do seems to be perfectly legal in XSLT1.0 (not in the way you tried though). /Marcus From ngilas2003 at yahoo.com Wed Dec 10 04:03:16 2003 From: ngilas2003 at yahoo.com (Stevenson N) Date: Wed, 10 Dec 2003 02:03:16 -0800 (PST) Subject: SV: [thelist] Namespace In-Reply-To: <000401c3bf01$38f8d550$0500a8c0@marcusnb> Message-ID: <20031210100316.15812.qmail@web60608.mail.yahoo.com> <><><><><><><><><><>><><><><>><><><><>><><><><>><><><><> I'm not really sure what you want to achieve with your attribute element so if you could post a more complete example then I might be able to help you on that one because what you want to do seems to be perfectly legal in XSLT1.0 (not in the way you tried though). <><><><><><><><><><>><><><><>><><><><>><><><><>><><><><> I want to dynamically generate a tree view. Find the example below: ----------------------------------------------------------------------------------------------------- namespace="mytree" implementation="../treeviewDiv/treeview.htc"
oTree
----------------------------------------------------------------------------------------------------- on using http://www.w3.org/1999/XSL/Transform i get The value of the 'name' attribute may not be 'xmlns:mytree'. --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard From evolt at reather.net Wed Dec 10 04:07:02 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 11:07:02 +0100 Subject: [thelist] Page check + CSS question... Message-ID: <018301c3bf05$5bb66e50$0700a8c0@xp10> I've been experimenting with CSS toolbars/menus after being asked to update an aging site which uses frames-driven navigation. After playing around with various things, I've come up with this page: http://exim.dyndns.org/faqs The current issues are: 1. If the content on the rhs is long enough and/or the viewer's browser window is small enough, the green div expands down to the bottom of the window. If not, there's an ugly maroon bar across the bottom of the green div (the page background is maroon). Is there a good way to solve this one? I've seen various tricks involving CSS height: 100%, but I haven't got any of these to work. 2. On this particular page, each question's answer is in a separate div, all the answers are hidden by Javascript calling "display: none;" when the body onload event fires, then clicking on each question calls the appropriate Javascript to 'reveal' the answer. However, the green div expands as the individual divs appear, which looks a little odd - is there any way to make the green div stay at its maximum size when the answers are hidden (i.e. for the page length to remain fixed, with elements moving down to fill it as they are revealed)? 3. Mozilla Firebird 0.6+ on Windows XP gives me a strange maroon bar across the top of the page. The page and its css validate, and Firebird is in 'standards compliance' mode - any idea what's causing this? 4. On IE6SP1+latest patches on my XP machine, clicking on the first question to reveal its answer causes some of the words in the very first paragraph to jump to the left. Is this an IE gremlin? Is there a workaround? Oh, and I'd be grateful for any comments (positive or negative) about how it looks on various browsers / OSes [I've tried IE, Netscape 7.1 and Firebird so far, all on Windows], and how the page is from a usability perspective... Thanks! James From mark at mark.ac Wed Dec 10 04:17:56 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 11:17:56 +0100 Subject: [thelist] Page check + CSS question... In-Reply-To: <018301c3bf05$5bb66e50$0700a8c0@xp10> References: <018301c3bf05$5bb66e50$0700a8c0@xp10> Message-ID: <1F23D21F-2AFA-11D8-ADBF-000393143F96@mark.ac> > http://exim.dyndns.org/faqs That's a 404? Mark Howells http://www.mark.ac/ From ben.morrison at dogstardesign.co.uk Wed Dec 10 04:20:10 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 10:20:10 +0000 Subject: [thelist] Page check + CSS question... In-Reply-To: <018301c3bf05$5bb66e50$0700a8c0@xp10> Message-ID: On 10/12/03 10:07 am, "James" wrote: > I've been experimenting with CSS toolbars/menus after being asked to update > an aging site which uses frames-driven navigation. After playing around > with various things, I've come up with this page: > http://exim.dyndns.org/faqs 404 :( -- benjer From evolt at reather.net Wed Dec 10 04:37:22 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 11:37:22 +0100 Subject: [thelist] Page check + CSS question... References: <018301c3bf05$5bb66e50$0700a8c0@xp10> <1F23D21F-2AFA-11D8-ADBF-000393143F96@mark.ac> Message-ID: <01cf01c3bf09$98935870$0700a8c0@xp10> Mark Howells wrote: >> http://exim.dyndns.org/faqs > > That's a 404? Just after I sent that linl, I managed to break mod_rewrite's configuration. It's temporarily fixed - please try again... James From chris.rosser at codemasters.com Wed Dec 10 04:40:24 2003 From: chris.rosser at codemasters.com (Chris Rosser) Date: Wed, 10 Dec 2003 10:40:24 -0000 Subject: [thelist] Page check + CSS question... Message-ID: >> I've been experimenting with CSS toolbars/menus after being asked to update >> an aging site which uses frames-driven navigation. After playing around >> with various things, I've come up with this page: >> http://exim.dyndns.org/faqs > 404 :( Seems to be at http://exim.dyndns.org/faq (just lose the s!) Chris }:) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. ********************************************************************** From jon at laughing-buddha.net Wed Dec 10 04:42:40 2003 From: jon at laughing-buddha.net (Jon Haworth) Date: Wed, 10 Dec 2003 10:42:40 -0000 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; References: <3FD5EA66.5050101@1976design.com> Message-ID: <00a901c3bf0a$57822130$050a0a0a@eris> Hi Dunstan, > Is the an ASP equivalent of PHP's syntax: > > $var = ($a == 0) ? 'hello' : 'goodbye'; I don't know very much about ASP, but Visual Basic has IIF ("inline if"), which might be worth a try: var = iif(a = 0, "hello", "goodbye") Cheers Jon From helge at flipmachine.com Wed Dec 10 14:13:21 2003 From: helge at flipmachine.com (Helge Karlsen) Date: Wed, 10 Dec 2003 12:13:21 -0800 Subject: [thelist] Page check + CSS question... In-Reply-To: References: Message-ID: P? Wed, 10 Dec 2003 10:40:24 -0000, skrev Chris Rosser >>> http://exim.dyndns.org/faqs > Validates fine. look's good in opera7.+ (The mid link mooves the layout a little bit when screen is halfe-sized..) all in all it's a nice one. Helge From marcan at home.se Wed Dec 10 05:20:32 2003 From: marcan at home.se (Marcus Andersson) Date: Wed, 10 Dec 2003 12:20:32 +0100 Subject: SV: SV: [thelist] Namespace In-Reply-To: <20031210100316.15812.qmail@web60608.mail.yahoo.com> Message-ID: <001501c3bf0f$a0f43740$0500a8c0@marcusnb> I would do like the following to get (what I guess) your target output: namespace="mytree" implementation="../treeviewDiv/treeview.htc"
I have removed usage of the xsl:element and xsl:attribute since I think it's much simpler to do like I did here. Note also that I declared mytree as a prefix in the stylesheet element which gives me the possibility to use it everywhere in the stylesheet (without additional declarations). The XSLT processor will then put it wherever needed in the output document. You would also need to change how you create your PI according to the example I provided. /Marcus From hershelr at netvision.net.il Wed Dec 10 05:23:06 2003 From: hershelr at netvision.net.il (Hershel Robinson) Date: Wed, 10 Dec 2003 06:23:06 -0500 Subject: [thelist] Web UI Question In-Reply-To: <3FD6322F.6040808@bath.ac.uk> Message-ID: <001301c3bf0f$fc75d060$0300000a@hershel2000> I received the following from thelist-bounces at lists.evolt.org <> on Tue, December 09, 2003 3:36 PM: > Hershel Robinson wrote: >> When he goes back in to edit one of these numbers, then it jumps to >> the left again. This IS a bit weird, but the display looks nice. >> >> Any one have any thoughts on this? > > Ask some users. Or even better, run some usability tests and watch > what the users do - if they seem unduly distrurbed by it, ditch it. > Personally it sounds just fine to me - I've seen interfaces that do > this before (doesn't Excel do exactly this?) and never been > troubled by them. I abandoned this when I saw that if you try to select part of existing text with the mouse, it's impossible because after the onmousedown event, the text switches to left justified and jumps away from where it was. :) Hershel From jay.blanchard at niicommunications.com Wed Dec 10 05:29:31 2003 From: jay.blanchard at niicommunications.com (Jay Blanchard) Date: Wed, 10 Dec 2003 05:29:31 -0600 Subject: [thelist] [PHP].csv file upload weirdness Message-ID: [snip] Hello there (thanks to all those who helped with the site check earlier this week) I have a script to load a .csv file to populate a database. The sql statement barfed at having single quotes in the file , so I removed them and re-uploaded the file. Trouble is, I get the same sql error, on the same line, even though *all* single quotes have been removed from the file. Even renaming the file and uploading it gives the same error. It is like the old file is cached in the tmp directory and being processed instead of the new one. I have checked for stray single quotes in Excel and Homesite and found not a one. Any ideas on how I can avoid this? Can I clear the tmp directory using php? [/snip] Can we see the line that makes it barf? Also, you shouldn't have to remove the single quotes if you are using PHP. You can use addslashes() to escape the single quotes or htmlentities() to change the single quotes to their respective HTML counterpart. The upload should not be cached. From andy at message.uk.com Wed Dec 10 05:35:08 2003 From: andy at message.uk.com (Andy Budd) Date: Wed, 10 Dec 2003 11:35:08 +0000 Subject: [thelist] More on Search Engines In-Reply-To: <00c401c3bee5$ea91fc90$1d03a8c0@autolycus> Message-ID: Russ wrote: > Granted, I'm making some semi-educated guesses here, but these guys > appear to be legitimately beating the system by fooling any relatively > modern browser into not seeing the copy. Not legitimate. The SE's don't like any text that is deliberately written for the SE's and hidden to users. Andy Budd http://www.message.uk.com/ From evolt at reather.net Wed Dec 10 06:19:22 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 13:19:22 +0100 Subject: [thelist] More on Search Engines References: <00c401c3bee5$ea91fc90$1d03a8c0@autolycus> Message-ID: <006a01c3bf17$d811bce0$0700a8c0@xp10> Russ wrote: [snip] > Granted, I'm making some semi-educated guesses here, but these guys > appear to be legitimately beating the system by fooling any relatively > modern browser into not seeing the copy. [snip] File a spam report to Google each time you notice one of these, making sure "hidden text or links" is ticked, and there's a good chance Google will remove the page(s) from their index. http://www.google.com/contact/spamreport.html Google's TOS page is here: http://www.google.com/webmasters/guidelines.html with perhaps the most important section being: 'Quality Guidelines - Basic principles: Avoid tricks intended to improve search engine rankings. A good rule of thumb is whether you'd feel comfortable explaining what you've done to a website that competes with you. Another useful test is to ask, "Does this help my users? Would I do this if search engines didn't exist?"' James From russ at unrealisticexpectations.com Wed Dec 10 06:32:56 2003 From: russ at unrealisticexpectations.com (Russ) Date: Wed, 10 Dec 2003 06:32:56 -0600 Subject: [thelist] More on Search Engines In-Reply-To: Message-ID: <00dd01c3bf19$beb42330$1d03a8c0@autolycus> > Russ wrote: > > > Granted, I'm making some semi-educated guesses here, but these guys > > appear to be legitimately beating the system by fooling any > relatively > > modern browser into not seeing the copy. > > Not legitimate. The SE's don't like any text that is deliberately > written for the SE's and hidden to users. > > Andy Budd > But, as far as I can tell, a spider won't be able to recognize that this is happening. They're doing it on several pages, not just their own doorway pages--call it SPAM if you like, but it's still individual pages that have some technology that customizes a pre-determined set of copy and replaces certain words based on the page you came through. It might not APPEAR to be legit to the rest of the planet, but I'm pretty sure a spider cannot pick up on their copy appearing as hidden since a spider isn't going to be able to recognize a location based upon CSS, and especially since a spider won't have the CSS applied for it; it'll simply appear as text on the page to the spider. No one has to like this; I certainly don't. I'm merely pointing out what they're doing AND that they're getting results for it. From ben.morrison at dogstardesign.co.uk Wed Dec 10 06:34:11 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 12:34:11 +0000 Subject: [thelist] Change Iframe background colour Message-ID: Ive been googling away for over an hour now and cant find a x-browser solution to change the background colour of an iframe, ie seems to work fine, but no luck in safari, here is my current code: function change_background() { document.frames.subscribe.document.body.style.backgroundColor="#CCFF66"; } I have tried (with no results): document.getElementById('subscribe').style.background="#CCFF66"; I also tried using css to set the iframe properties: #subscribe{ background:#CCFF66; } iframe { ? ?background:#CCFF66; } Any pointers much apreciated, I have read that the *new* version of safari will support iframe transparency. benjer From mark at mark.ac Wed Dec 10 06:45:23 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 13:45:23 +0100 Subject: [thelist] Page check + CSS question... In-Reply-To: <018301c3bf05$5bb66e50$0700a8c0@xp10> References: <018301c3bf05$5bb66e50$0700a8c0@xp10> Message-ID: Mac screenshots at http://www.mark.ac/media/evolt/ Re. the maroon strip at the top of the page: check the page margins and padding (on the body tag)? Regards Mark Howells http://www.mark.ac/ From evolt at reather.net Wed Dec 10 06:58:36 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 13:58:36 +0100 Subject: [thelist] "spamminess" site check - realtymort.com References: Message-ID: <009d01c3bf1d$533cb4b0$0700a8c0@xp10> Stephen Rider wrote: [snip] > The boss-man is absolutely driven to raise the rankings in search > engines (I explained to him that Google's entire business model > depends on web coders not being able to directly manipulate the > rankings, but he doesn't want to hear it...), so he keeps insisting > that I keep tweaking word order in Title tags and such, in a vain > attempt to find the perfect "keyword" optimization. [snip] > I thought the site was well done in terms of readabiloity to search > engines and such, and I'm not doing anything blatantly "spammy", > AFAIK. Am I missing something? Is there something I'm doing > horribly wrong here? Have you checked at http://inventory.overture.com/d/searchinventory/suggestion/ to see what variations on keywords people search for? > Notes: > 1) The Site Map is brand-spanking new (as in, "yesterday"), so that's > not part of the issue. I added that in attempt to alleviate the > problem. Bad move or good move? > > 2) There are two domains pointing to the same site, so that may be > part of the problem (but wasn't before). > goes to the same site. This could be a big problem. Unless you're prepared to have substantially different content on the two sites, you need to set things up so that a visitor to http://www.aptrentals.com/ gets *redirected* (i.e. a 301 or 302 redirect) to www.realtymort.com/ - you can't just serve exactly the same content for the two domains and expect Google not to mind :-) > 3) The words "Chicago Apartments" was recently added to the beginning > of all page titles... not sure if this is the problem or not, just an > FYI. Doesn't seem to be too terrible of a crime, but slightly > "spammy" IMHO your page titles are way too long, and your company name should only be mentioned in a few of them. Your home page is already #1 in Google for searches of your company name, so you should remove it from all the internal pages - it's not doing any good there, it's just diluting the impact of your keywords. http://www.google.com/search?q=realty+and+mortgage+co Take, for instance, your page at http://www.realtymort.com/listings/nearnorth.htm which has Realty & Mortgage Co. - Listings of Apartments for Rent in Chicago's Near North Side. Checking with http://inventory.overture.com/d/searchinventory/suggestion, we find that the most common searchs are "apartment chicago" (~10000 searches), "apartment in chicago" (~2300 searches), "chicago apartment for rent" (~2000 searches). So, are the most important keywords for your page really "Realty & Mortgage Co" (important keywords at the start of the tag)? If it were my page, I'd probably try <title>Chicago Near North Side Apartment or even Chicago Near North Side Apartment List if you're determined to be gramatically correct :-) If you really must, put your company name on the end like this: Chicago Near North Side Apartment List - Realty & Mortgage Co Also, get yourself a free Google API key https://www.google.com/accounts/NewAccount?continue=http://api.google.com/createkey&followup=http://api.google.com/createkey and then register for free keyword tracking at http://www.digitalpoint.com/tools/keywords/ Also, consider better/different text navigation for your pages. A site map will perhaps help, but each page could/should have breadcrumbs i.e.
parentpage's keywords and childrenpages' keywords tags. That way you make sure each page has incoming text links with relevant keywords. If your site is database driven, this is dead easy to set up. Just my $0.02, but perhaps this is a start! James From dleonard56 at earthlink.net Wed Dec 10 07:11:52 2003 From: dleonard56 at earthlink.net (Dan Leonard) Date: Wed, 10 Dec 2003 08:11:52 -0500 Subject: [thelist] Help with Javascript In-Reply-To: References: Message-ID: <3FD71B98.3070903@earthlink.net> Andrew Bayley wrote: >how about simply removing it? I think i speak for most people here when >I say i hate dhtml stuff. > > Duly noted! :) Thanks, Dan From Brian at hondaswap.com Wed Dec 10 07:22:44 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Wed, 10 Dec 2003 08:22:44 -0500 Subject: [thelist] More on Search Engines In-Reply-To: <00dd01c3bf19$beb42330$1d03a8c0@autolycus> Message-ID: <000201c3bf20$b54d8140$e6dffea9@breal> > Not legitimate. The SE's don't like any text that is deliberately > written for the SE's and hidden to users. Ok, but what about on legit CSS/XHTML sites... For example, I have: #############################################

sitename here

------------------ #heading { background: url(blah.jpg); } .hide { Display:none; } ########################################## So that on non-css browsers, they see a text h1, instead of my image embedded into the background. Technically, that's cheapting then, because its hidden to 98% of my users??? From mark at mark.ac Wed Dec 10 07:20:32 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 14:20:32 +0100 Subject: [thelist] Change Iframe background colour In-Reply-To: References: Message-ID: Have you tried this? document.frames["subscribe"].document.body.style.backgroundColor="#CCFF6 6" Sometimes, the abbreviated version of the DOM reference causes a glitch. Regards Mark Howells http://www.mark.ac/ From Brian at hondaswap.com Wed Dec 10 07:39:42 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Wed, 10 Dec 2003 08:39:42 -0500 Subject: [thelist] Page check + CSS question... In-Reply-To: Message-ID: <000801c3bf23$140cce50$e6dffea9@breal> >>Re. the maroon strip at the top of the page: check the page margins and padding (on the body tag)? I don't see a strip at all. Ie6/xp From evolt at reather.net Wed Dec 10 07:46:57 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 14:46:57 +0100 Subject: [thelist] Page check + CSS question... References: <018301c3bf05$5bb66e50$0700a8c0@xp10> Message-ID: <00dd01c3bf24$14616180$0700a8c0@xp10> Mark Howells wrote: > Mac screenshots at > > http://www.mark.ac/media/evolt/ Thanks for the speedy screenshots! BTW, nice site > Re. the maroon strip at the top of the page: check the page margins > and padding (on the body tag)? The CSS was like this: body { margin: 0; padding: 0; border: 0; background-color: #990033; } I've even added this too html { margin: 0; padding: 0; border: 0; background-color: #990033; } but it didn't help. James From ngilas2003 at yahoo.com Wed Dec 10 07:55:36 2003 From: ngilas2003 at yahoo.com (Stevenson N) Date: Wed, 10 Dec 2003 05:55:36 -0800 (PST) Subject: SV: SV: [thelist] Namespace In-Reply-To: <001501c3bf0f$a0f43740$0500a8c0@marcusnb> Message-ID: <20031210135536.43750.qmail@web60606.mail.yahoo.com> Thanks marcus, that worked like magic. --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard From pixelmech at yahoo.com Wed Dec 10 08:05:37 2003 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Wed, 10 Dec 2003 06:05:37 -0800 (PST) Subject: [thelist] regex: replacing bracket characters Message-ID: <20031210140537.32578.qmail@web12606.mail.yahoo.com> Hi, I want to replace the ( and ) characters in a string (for example, strip them out of the area code in a phone number). I can't seem to figure out the pattern for these characters. I've tried both: objRegExp = /()/g; objRegExp = /\(\)/g; Neither works. I realize that the brackets mean something in regex and I'm doing something wrong... Tom ===== http://www.pixelmech.com/ :: Web Development Services http://www.DMXzone.com/ :: JavaScript Author / Every Friday! http://www.thywordistruth.net/ :: Eternal Life [Those who say that I am finished, and am through, will have to run over my dead body to beat me...] From ben.morrison at dogstardesign.co.uk Wed Dec 10 08:06:54 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 14:06:54 +0000 Subject: [thelist] Page check + CSS question... In-Reply-To: <018301c3bf05$5bb66e50$0700a8c0@xp10> Message-ID: On 10/12/03 10:07 am, "James" wrote: > I've been experimenting with CSS toolbars/menus after being asked to update > an aging site which uses frames-driven navigation. After playing around > with various things, I've come up with this page: > http://exim.dyndns.org/faqs The click-open links. On safari there is no hand cursor to indicate a link, Add "#" to the href. A hover state would be nice too. Same mac issues as posted by mark. benjer From david at gigawatt.com Wed Dec 10 08:08:46 2003 From: david at gigawatt.com (David Kaufman) Date: Wed, 10 Dec 2003 09:08:46 -0500 Subject: [thelist] Mod_rewrit and classic sysadmin response References: <01b001c3bee6$6e31f870$8e01a8c0@Workstation> Message-ID: <001a01c3bf27$20c7ca60$1200a8c0@david> Tony Page wrote: > I need to use mod_rewrite with my Gallery software but [...] > "We use mod_rewrit for security purposes and can not (sic) tell anyone > how it works." > > Anyone got any info on mod_rewrit [...]? all the info you need about mod_rewrit is right there in that statement: it uses the worst form of security: obscurity. "we can't tell you anything about it" translates to: it's only "secure" because so few people have a) of it (yet), b) seen the source code (if anyone, yet), widely tested it (yet) and/or found any bugs or security holes in it ... yet. > [...] or ideas about workarounds? work around #1: find a better web hosting provider: (see www.pair.com) -dave From evolt at brasscannon.net Wed Dec 10 08:09:23 2003 From: evolt at brasscannon.net (Kevin Martin) Date: Wed, 10 Dec 2003 09:09:23 -0500 Subject: [thelist] Usability analysis paper online Message-ID: <20031210140923.GB12295@howie.kebm.net> Forwarded from a publishing list; it is actually more relevant to Evolt, IMHO: Some kind person has combined ALL the actual empirical studies (not those done by Joe Blow who makes a "million dollars on the web") on fonts, download time, positioning, links, graphics, animation vs. none, bullets...you name it into ONE article and actually included EVERY single source and reference correctly. It's easy to read, understand and follow. You guys have to see this. It simply has no equal. http://psychology.wichita.edu/optimalweb/print.htm Some of the data goes back to the '80s, but the wiring of people's eyes and fingers doesn't change on "Internet time." From jcbullas at nildram.co.uk Tue Dec 9 00:41:52 2003 From: jcbullas at nildram.co.uk (John C Bullas) Date: Tue, 09 Dec 2003 06:41:52 +0000 Subject: [thelist] Wanted in Hampshire...... APS > CD transfer In-Reply-To: <3FD4B9DF.40407@nota-bene.org> References: <6.0.1.1.0.20031206130150.0245bc70@pop3.nildram.co.uk> <3FD37795.1020905@nota-bene.org> <6.0.0.22.0.20031208085507.023d3ba0@pop3.nildram.co.uk> <3FD4B9DF.40407@nota-bene.org> Message-ID: <6.0.1.1.0.20031209064049.02474ec8@pop3.nildram.co.uk> At 17:50 08/12/2003, s t e f wrote > > >> >> >>Why did I get this reply in response to a question seeking a PIECE OF >>HARDWARE to transfer APS cartridges to CD? >>(ultimately to deliver a Javascript based on line photo album) >> >>Still baffled Thanks for the 2 offlist posts, I now know the error of my ways! Didn't get any real replies anyway :) John aka FB >John, >I just realised that replying to you offlist wasn't such a good idea since >you may not be the only one to wonder. From hershelr at netvision.net.il Wed Dec 10 08:18:25 2003 From: hershelr at netvision.net.il (Hershel Robinson) Date: Wed, 10 Dec 2003 09:18:25 -0500 Subject: [thelist] Help with Javascript In-Reply-To: <3FD71B98.3070903@earthlink.net> Message-ID: <003d01c3bf28$79e406d0$0300000a@hershel2000> >> how about simply removing it? I think i speak for most people here >> when I say i hate dhtml stuff. Most people here? I am not certain about that. I built a dynamic menu system with a tabbed interface look and my boss said that this new front-end interface put us over the competition. And this is in the (staid) finance industry. DHTML can be your friend. :) Hershel From evolt at reather.net Wed Dec 10 08:22:36 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 15:22:36 +0100 Subject: [thelist] More on Search Engines References: <000201c3bf20$b54d8140$e6dffea9@breal> Message-ID: <001101c3bf29$0f755d20$0700a8c0@xp10> Brian Cummiskey wrote: >> Not legitimate. The SE's don't like any text that is deliberately >> written for the SE's and hidden to users. > > Ok, but what about on legit CSS/XHTML sites... > > For example, I have: > > ############################################# > >
>

sitename here

>
> ------------------ > #heading { > background: url(blah.jpg); > } > > .hide { > Display:none; > } If someone reports you to Google for that, you'll (probably) get away with that - you're not trying to deceive anyone. You'll be in trouble if you try this, though:

cheap widget, bargain widgets, we sell cut price widgets here

------------------ #heading { background: url(blah.jpg); } .hide { Display:none; } - which is what you see so often. There are perfectly innocent uses for hidden divs, which is why no search engine has (yet) implemented an automatic penalty for them AFAIK. Google will (apparently) do a manual check of sites which get reported for 'bad' use of hidden divs. Honest SEO types are steering clear of hidden divs for fear of there being an automatic penalty some time soon... :-) James From mpember at optusnet.com.au Wed Dec 10 07:17:20 2003 From: mpember at optusnet.com.au (Michael Pemberton) Date: Wed, 10 Dec 2003 13:17:20 -0000 Subject: [thelist] Mail redundancy Message-ID: <3EB37B3A.8050401@optusnet.com.au> I have recently setup my own web / mail server from home. I am about to configure my domain to point to the new location, but have a few issues I want to work out first. Is there any hosts out there that would offer a cheap redundant mail service? My server should be up 24/7, but I'm just looking for a backup incase I lose power or and asteroid crashes into the house : ) Does anyone have any tips on what I should be looking for? tia -- Michael Pemberton evolt at mpember.net.au From ben.morrison at dogstardesign.co.uk Wed Dec 10 08:26:41 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 14:26:41 +0000 Subject: [thelist] Change Iframe background colour In-Reply-To: Message-ID: On 10/12/03 1:20 pm, "Mark Howells" wrote: > Have you tried this? > > document.frames["subscribe"].document.body.style.backgroundColor="#CCFF6 > 6" > > Sometimes, the abbreviated version of the DOM reference causes a glitch. Unfortunately that didn?t fix it either, maybe a link will help as could always be something else interfering perhaps: http://www.pup-e.co.uk/sitecheck/iframetest.htm benjer From ben.morrison at dogstardesign.co.uk Wed Dec 10 08:31:04 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 14:31:04 +0000 Subject: [thelist] More on Search Engines In-Reply-To: <000201c3bf20$b54d8140$e6dffea9@breal> Message-ID: On 10/12/03 1:22 pm, "Brian Cummiskey" wrote: > So that on non-css browsers, they see a text h1, instead of my image > embedded into the background. > > Technically, that's cheapting then, because its hidden to 98% of my > users??? Yes, which is another reason to be wary of image-replacement techniques. Other css tricks are: postion:absolute; left:-1000px; No way of knowing how it will be treated by search engines apart from the fact that it will be abused by spammers and then will be penalised by seacrh engines eventually. My 2 cents.... benjer From ben.morrison at dogstardesign.co.uk Wed Dec 10 08:37:04 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 14:37:04 +0000 Subject: [thelist] Page check + CSS question... In-Reply-To: <00dd01c3bf24$14616180$0700a8c0@xp10> Message-ID: On 10/12/03 1:46 pm, "James" wrote: >> Re. the maroon strip at the top of the page: check the page margins >> and padding (on the body tag)? try: From ben.morrison at dogstardesign.co.uk Wed Dec 10 08:38:01 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Wed, 10 Dec 2003 14:38:01 +0000 Subject: [thelist] Page check + CSS question... In-Reply-To: <00dd01c3bf24$14616180$0700a8c0@xp10> Message-ID: On 10/12/03 1:46 pm, "James" wrote: >> Re. the maroon strip at the top of the page: check the page margins >> and padding (on the body tag)? try: #content { position: absolute; Seems to fix safari and mac ie Sorry aboiut double post, entourage has a horrid pasting/sending shortcut. ben From MPlunkett at MSA.com Wed Dec 10 08:45:58 2003 From: MPlunkett at MSA.com (Plunkett, Matt) Date: Wed, 10 Dec 2003 09:45:58 -0500 Subject: [thelist] regex: replacing bracket characters Message-ID: -----Original Message----- > From: Tom Dell'Aringa > I want to replace the ( and ) characters in a string (for example, > strip them out of the area code in a phone number). I can't seem to > figure out the pattern for these characters. > objRegExp = /()/g; > objRegExp = /\(\)/g; Both of these regexps try to match (), not ( or ). Try /[\(\)]/ Brackets mean to match any character inside them. From evolt at david.us-lot.org Wed Dec 10 08:47:44 2003 From: evolt at david.us-lot.org (David Dorward) Date: Wed, 10 Dec 2003 14:47:44 +0000 Subject: [thelist] regex: replacing bracket characters In-Reply-To: <20031210140537.32578.qmail@web12606.mail.yahoo.com> References: <20031210140537.32578.qmail@web12606.mail.yahoo.com> Message-ID: On 10 Dec 2003, at 14:05, Tom Dell'Aringa wrote: > > I want to replace the ( and ) characters in a string (for example, > strip them out of the area code in a phone number). I can't seem to > figure out the pattern for these characters. > > I've tried both: > > objRegExp = /()/g; > objRegExp = /\(\)/g; > 1. You aren't saying you want to make a substitution (so add 's') s/\(\)/g 2. You aren't saying what you want to substitute them with (so add /) s/\(\)//g 3. You are trying to match "()" rather then "(" or ")" (so wrap them in brackets and stick a | between them) s/(\(|\))//g So: $ perl $foo = "+44 (7777) 123456"; $foo =~ s/(\(|\))//g; print $foo . "\n"; Outputs: +44 7777 123456 -- David Dorward http://dorward.me.uk/ From pixelmech at yahoo.com Wed Dec 10 08:49:10 2003 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Wed, 10 Dec 2003 06:49:10 -0800 (PST) Subject: [thelist] regex: replacing bracket characters [solved] In-Reply-To: Message-ID: <20031210144910.42979.qmail@web12606.mail.yahoo.com> --- "Plunkett, Matt" wrote: > Both of these regexps try to match (), not ( or ). Try > > /[\(\)]/ > > Brackets mean to match any character inside them. Ah, thank you Matt - works perfect! Tom ===== http://www.pixelmech.com/ :: Web Development Services http://www.DMXzone.com/ :: JavaScript Author / Every Friday! http://www.thywordistruth.net/ :: Eternal Life [Those who say that I am finished, and am through, will have to run over my dead body to beat me...] From Ed at ComSimplicity.com Wed Dec 10 09:04:08 2003 From: Ed at ComSimplicity.com (Ed McCarroll) Date: Wed, 10 Dec 2003 07:04:08 -0800 Subject: [thelist] More on Search Engines In-Reply-To: <00dd01c3bf19$beb42330$1d03a8c0@autolycus> Message-ID: > but I'm pretty sure a spider cannot pick up on their copy appearing > as hidden since a spider isn't going to be able to recognize a > location based upon CSS, and especially since a spider won't have > the CSS applied for it; it'll simply appear as text on the page to > the spider. Whatever an all-too-clever "SEO" can implement, sooner or later, a spyder can be written to detect. If a browser can interpret it, a spyder can be written to do likewise. Google's bread and butter depends upon their being at least as clever as the SEOs. The SEOs that I have faith in are the ones that work within, and endorse, Google's guidelines. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ed McCarroll MailTo:Ed at ComSimplicity.com ComSimplicity (310) 838-4330 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - From dougal at gunters.org Wed Dec 10 09:13:18 2003 From: dougal at gunters.org (Dougal Campbell) Date: Wed, 10 Dec 2003 09:13:18 -0600 (CST) Subject: [thelist] mod_rewrite for IIS4? Message-ID: <20031210085829.W80956@ns2.iguanasoft.com> Can anyone point me to an ISAPI for IIS4 which can operate similarly to mod_rewrite for Apache? I seem to recall seeing references to such a beast before, but I've searched all over and can't find it again. If you want to use CVS for source control, but you are using Windows tools that only support Visual Source Safe, try Igloo, which is a SCC/CVS bridge. http://www.jalindi.com/igloo/index.html -- Ernest MacDougal Campbell III, MCP+I, MCSE http://dougal.gunters.org/ http://spam.gunters.org/ Web Design & Development: http://www.mentalcollective.com/ This message is guaranteed to be 100% eror frea! From chris.rosser at codemasters.com Wed Dec 10 09:56:49 2003 From: chris.rosser at codemasters.com (Chris Rosser) Date: Wed, 10 Dec 2003 15:56:49 -0000 Subject: [thelist] Help with Javascript Message-ID: Hershel, >Most people here? I am not certain about that. I built a dynamic menu system >with a tabbed interface look and my boss said that this new front-end >interface put us over the competition. There's a major difference between using DHTML purely for aesthetics (e.g. faded text effects!) and using DHTML to add functionality... DHTML can be a great advantage where it genuinely adds useful features to a site, and is cross-browser compatible. However the majority of effects and scrollers you find at sites like dynamicdrive.com add nothing to the user experience, and seldom work across all browsers. Chris }:) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. ********************************************************************** From Tab.Alleman at MetroGuide.com Wed Dec 10 10:07:31 2003 From: Tab.Alleman at MetroGuide.com (Tab Alleman) Date: Wed, 10 Dec 2003 11:07:31 -0500 Subject: [thelist] (SQL2k) NULL and LIKE Message-ID: I don't get it. If I do this query: SELECT Browser FROM xmlErrorLog WHERE (TimeStamp BETWEEN '12/10/2003 00:00' AND '12/10/2003 23:59') AND (NOT (ClientIP LIKE '10.1.%')) AND (NOT (ClientIP LIKE '192.168.%')) I get 2 rows: NULL NULL But if I modify the query thus: SELECT Browser FROM xmlErrorLog WHERE (TimeStamp BETWEEN '12/10/2003 00:00' AND '12/10/2003 23:59') AND (NOT (ClientIP LIKE '10.1.%')) AND (NOT (ClientIP LIKE '192.168.%')) AND (NOT (Browser LIKE '%RedAlert%')) -- this is the only change I get no rows. So, NULL is LIKE '%RedAlert%'??? How so? Is this expected behavior? From dleonard56 at earthlink.net Wed Dec 10 10:28:25 2003 From: dleonard56 at earthlink.net (Dan Leonard) Date: Wed, 10 Dec 2003 11:28:25 -0500 Subject: [thelist] Help with Javascript In-Reply-To: <003d01c3bf28$79e406d0$0300000a@hershel2000> References: <003d01c3bf28$79e406d0$0300000a@hershel2000> Message-ID: <3FD749A9.3010904@earthlink.net> Hershel Robinson wrote: >>>how about simply removing it? I think i speak for most people here >>>when I say i hate dhtml stuff. >>> >>> > >Most people here? I am not certain about that. I built a dynamic menu system >with a tabbed interface look and my boss said that this new front-end >interface put us over the competition. And this is in the (staid) finance >industry. > >DHTML can be your friend. :) > >Hershel > > > Hi Hershel, My bad! In an attempt to trim my reply, I left out the beginning of Andrew's reply where he stated: "Sometimes the "dhtml stuff" as you call it, can be useful. Like most things out there, it is not the tool, but the application of it that makes all the difference. There are a lot of sites out there that have benefited in one way or another from careful application of these scripts. However, I must conceed, that the fading menu is a bit over the top " Sounds like you and Andrew are in agreement about DHTML having its usefulness for certain functions -- and I can see his point about perhaps not using it for gimmicky things like fading text, etc. Sorry for the confusion, Dan From mark at mark.ac Wed Dec 10 10:29:17 2003 From: mark at mark.ac (Mark Howells) Date: Wed, 10 Dec 2003 17:29:17 +0100 Subject: [thelist] HMTL Email Message-ID: Yes, that old arguing point again. It's essential that I apply some kind of formatting to an HTML email - text colour and margins, mainly - and I can't get it to respond to CSS, whether it's inline (on a span) or in the head of the email. Works fine in Apple Mail, but Entourage and Outlook Express - both Mac - ignore it. Any ideas? Thanks and best regards Mark Howells http://www.mark.ac/ From kyle.murphy at tempschedulingsystem.com Wed Dec 10 10:43:48 2003 From: kyle.murphy at tempschedulingsystem.com (Kyle Murphy) Date: Wed, 10 Dec 2003 10:43:48 -0600 Subject: [thelist] CF: cfcontent with mapped or unc drives Message-ID: <000201c3bf3c$c9155fb0$8c79b442@kmurphy> I am unable to access files on a mapped drive or through the unc path. I found out that this is a problem with ColdFusion & they offer a workaround here: http://www.macromedia.com/support/coldfusion/ts/documents/tn18259.htm I tried the workaround by copying the file locally using and then accessing the file through & it is still not working. I get "path not found" when using the mapped drive & I get "Access Denied" when using the unc path. Does anyone have any other ideas on how this could work correctly? Is this fixed in CFMX?? Thanks, Kyle From liorean at f2o.org Wed Dec 10 10:57:42 2003 From: liorean at f2o.org (liorean) Date: Wed, 10 Dec 2003 17:57:42 +0100 Subject: [thelist] mod_rewrite for IIS4? In-Reply-To: <20031210085829.W80956@ns2.iguanasoft.com> References: <20031210085829.W80956@ns2.iguanasoft.com> Message-ID: <3FD75086.1050904@f2o.org> Dougal Campbell wrote: > Can anyone point me to an ISAPI for IIS4 which can operate similarly to > mod_rewrite for Apache? I seem to recall seeing references to such a > beast before, but I've searched all over and can't find it again. Hmm, how about ? -- liorean ViewStyles, ViewScripts, ToggleStyles and GraphicsInfo bookmarklets and Theme Switcher, Cookies Handler scripts: From cs1spw at bath.ac.uk Wed Dec 10 10:59:22 2003 From: cs1spw at bath.ac.uk (Simon Willison) Date: Wed, 10 Dec 2003 10:59:22 -0600 Subject: [thelist] "spamminess" site check - realtymort.com In-Reply-To: <3FD6B6F8.3020804@hondaswap.com> References: <32ce01c3bed1$c23ff6c0$6401a8c0@dinowitz.com> <3FD6B6F8.3020804@hondaswap.com> Message-ID: <3FD750EA.8040208@bath.ac.uk> Brian Cummiskey wrote: >>> Here is the site: >>> > > > just something i noticed that is definitly holding you back a little... > > you format your links as such: > > technically, thats not a page. google will index faster and show mroe > relevence to over the above. I'm certain that isn't the case. The web server at www.realtymort.com is running Apache, and is configured so that accessing a directory will load content from index.htm (using the DirectoryIndex directive). If you load up http://www.realtymort.com/listings/ using Web Sniffer[1] (an excellent diagnostic tool) the returned page is served with a 200 HTTP status code - which means the page exists. Google cares not a jot about file extensions or even whether a URL looks like a file or a directory - as long as the content served comes back with a 200 response it's considered a web page. [1] http://web-sniffer.net/ From cgeorge at basecorp.com Wed Dec 10 11:09:07 2003 From: cgeorge at basecorp.com (Chris George) Date: Wed, 10 Dec 2003 10:09:07 -0700 Subject: [thelist] VSS "Deploy" shortcut? Message-ID: <6E85D194CD14D341AB3AF41DB59D1BAE0DE684@basefs01.corp.basecorp.com> Hey, Does anyone know if there's some sort of handy, apparently secret keyboard shortcut for the Deploy command under the Web menu in Visual Source Safe? After checking in/putting files in DWMX, I find that the extra step, no matter how fast I am with my mouse is eating up workflow. Any thoughts? Is there a way to map a keystroke on a PC to do the same thing? (I'm generally more comfortable with a Mac, so pardon my ignorance) Thanks! Chris. From russ at unrealisticexpectations.com Wed Dec 10 11:30:34 2003 From: russ at unrealisticexpectations.com (Russ) Date: Wed, 10 Dec 2003 11:30:34 -0600 Subject: [thelist] More on Search Engines In-Reply-To: Message-ID: <001801c3bf43$54e2f560$8de7b6cc@BubbaHoTep> > Whatever an all-too-clever "SEO" can implement, sooner or > later, a spyder can be written to detect. If a browser can > interpret it, a spyder can be written to do likewise. > Google's bread and butter depends upon their being at least > as clever as the SEOs. The SEOs that I have faith in are the > ones that work within, and endorse, Google's guidelines. It doesn't truly appear that anyone fully is aware of Google's guidelines; there are questions popping up all over the place regarding this. There are a lot of forums on SEO that have many, many professionals very confused and concerned with how to deliver results to their clients, so it's difficult to believe that these guidelines are entirely commonplace and/or that they're endorsed. Further, following one search engine would seem about as crazy as following one browser version. A spider might be able to written to go through and read CSS and see how it's applied, but how is that going to affect the speed of a spider and the lag in which it takes to spider sites? I don't know the answer to this, but anything that can be written to do more typically results in it taking more time to complete. Let me re-iterate that I didn't do this, I just noticed it as I was doing some work with a colleague who works in SEO, and I've merely put forth the results that I found. From jasonh at corestar.co.uk Wed Dec 10 11:52:43 2003 From: jasonh at corestar.co.uk (Jason Handby) Date: Wed, 10 Dec 2003 17:52:43 -0000 Subject: [thelist] (SQL2k) NULL and LIKE In-Reply-To: Message-ID: Hi Tab, > I don't get it. > > If I do this query: > > SELECT Browser FROM xmlErrorLog > WHERE (TimeStamp BETWEEN '12/10/2003 00:00' AND '12/10/2003 23:59') > AND (NOT (ClientIP LIKE '10.1.%')) > AND (NOT (ClientIP LIKE '192.168.%')) > > I get 2 rows: > NULL > NULL > > But if I modify the query thus: > > SELECT Browser FROM xmlErrorLog WHERE (TimeStamp BETWEEN '12/10/2003 > 00:00' AND '12/10/2003 23:59') > AND (NOT (ClientIP LIKE '10.1.%')) > AND (NOT (ClientIP LIKE '192.168.%')) > AND (NOT (Browser LIKE '%RedAlert%')) -- this is the only change > > I get no rows. > > So, NULL is LIKE '%RedAlert%'??? How so? Is this expected behavior? If you have ANSI_NULLS set to ON, then comparisons with NULL return UNKNOWN (rather than TRUE or FALSE). I'm guessing that (Browser LIKE '%RedAlert%') is returning UNKNOWN. And, because NOT(UNKNOWN) is UNKNOWN, which is not the same thing as TRUE, your WHERE clause is failing for those records. You could try ...AND (Browser IS NULL OR NOT(Browser LIKE '%RedAlert%')) instead? Jason From hershelr at netvision.net.il Wed Dec 10 12:15:58 2003 From: hershelr at netvision.net.il (Hershel Robinson) Date: Wed, 10 Dec 2003 13:15:58 -0500 Subject: [thelist] Help with Javascript In-Reply-To: <3FD749A9.3010904@earthlink.net> Message-ID: <006e01c3bf49$a992e4c0$0300000a@hershel2000> > Sounds like you and Andrew are in agreement about DHTML having its > usefulness for certain functions -- and I can see his point about > perhaps not using it for gimmicky things like fading text, etc. What are you talking about? Having links flash rainbow colors onmouseover is an amazing feat. Especially if you are building an air sickness bag distributor's web site, because your visitors may well be vomiting... Hershel Once an hour, look out the window at something far away. Allow your eyes to rest and focus on something in the distance for 30 seconds. Spending the entire day with your eyes focused on a screen closer than 2 feet to your face can and probably will eventually cause serious strain and possible damage to your eyes. From ironmike at inav.net Wed Dec 10 13:19:31 2003 From: ironmike at inav.net (Mike Hopkins) Date: Wed, 10 Dec 2003 13:19:31 -0600 Subject: [thelist] Need Browser References: <000001c3bc80$e00c15b0$4930e918@Thelonius><6.0.0.22.0.20031209120845.02791cf0@netalytical.com> <52423794-2AE0-11D8-A6C6-000393143F96@mark.ac> Message-ID: <005101c3bf52$8ae6a260$7b6b0143@trustyii> A good keylogger should let you replay anyone's "bad" keyboard entries. > > need a close up camera, half the time they don't know how they did it ;o) > -- From evolt at reather.net Wed Dec 10 13:53:30 2003 From: evolt at reather.net (James) Date: Wed, 10 Dec 2003 20:53:30 +0100 Subject: [thelist] More on Search Engines References: <001801c3bf43$54e2f560$8de7b6cc@BubbaHoTep> Message-ID: <025301c3bf57$4967df70$0700a8c0@xp10> Russ wrote: >> Whatever an all-too-clever "SEO" can implement, sooner or >> later, a spyder can be written to detect. If a browser can >> interpret it, a spyder can be written to do likewise. >> Google's bread and butter depends upon their being at least >> as clever as the SEOs. The SEOs that I have faith in are the >> ones that work within, and endorse, Google's guidelines. > > It doesn't truly appear that anyone fully is aware of Google's > guidelines; there are questions popping up all over the place > regarding this. There are a lot of forums on SEO that have many, many > professionals very confused and concerned with how to deliver results > to their clients, so it's difficult to believe that these guidelines > are entirely commonplace and/or that they're endorsed. There are, of course, SEOs that work "within the law" and those that work "outside the law" - just as there are 'get rich quick' schemes that are legal and those that are not so legal. IMHO Ed's comment that "whatever an SEO can think of, a bot can be written to detect" is spot on - it's just the case that most SE don't have the resources to chase the 1% (?) of webmasters who cheat. As soon as tricks become mainstream (like the old stuffing trick), the search engines are forced to act (which is why very few SEs actually take notice of the tag these days). So, why not pick the SEO who understands and works within the SE's guidelines? It certainly won't get your site to #1 quite as fast, or quite as often, as the unscrupulous SEOs, but it's *far* less likely to get your domain banned completely for sharp practice. > Further, following one search engine would seem about as crazy > as following one browser version. > A spider might be able to written to go through and read CSS and see > how it's applied, but how is that going to affect the speed of a > spider and the lag in which it takes to spider sites? I don't know > the answer to this, but anything that can be written to do more > typically results in it taking more time to complete. [snip[ AFAIK no mainstream spiders request and/or parse CSS. For a start, how would search engines deal with sites with robots.txt saying User-agent: * Disallow: /css or sites which rewrite requests for CSS files for Googlebot using mod_rewrite? Also, there are so many glitches/quirks in client's rendering of CSS that a bot could never be 100% sure what effect a particular html+CSS combination would have, and therefore whether it was 'bad' or not. Of course, I could be wrong... many of the sites I compete with use hidden divs stuffed with keywords and links to increase their rankings. If only I could report them all to Google in batch mode :-( James From Tab.Alleman at MetroGuide.com Wed Dec 10 14:31:43 2003 From: Tab.Alleman at MetroGuide.com (Tab Alleman) Date: Wed, 10 Dec 2003 15:31:43 -0500 Subject: [thelist] (SQL2k) NULL and LIKE Message-ID: Jason Handby wrote: > You could try > > ...AND (Browser IS NULL OR NOT(Browser LIKE '%RedAlert%')) > > instead? Yeah, that's what I ended up having to do. And still have to go back and do in a LOT of places....*sigh* From k.neirynck at belgacom.net Wed Dec 10 14:38:17 2003 From: k.neirynck at belgacom.net (Kristof Neirynck) Date: Wed, 10 Dec 2003 21:38:17 +0100 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B45A1DA7@ireland.spinhead.com> References: <72E9FAA171D63B48AAC707C72900E6B45A1DA7@ireland.spinhead.com> Message-ID: <3FD78439.1020901@belgacom.net> Joel D Canfield wrote: >>Is the an ASP equivalent of PHP's syntax: >> >>$var = ($a == 0) ? 'hello' : 'goodbye'; > > If there's a cool 'immediate if' shortcut like the PHP versoin, I'd love > to know it. This should work. Dim var as String var = iif(a = 0, "Hello", "goodbye") -- Kristof From evolt_org at striderweb.com Wed Dec 10 14:29:29 2003 From: evolt_org at striderweb.com (Stephen Rider) Date: Wed, 10 Dec 2003 14:29:29 -0600 Subject: [thelist] More on Search Engines In-Reply-To: <00dd01c3bf19$beb42330$1d03a8c0@autolycus> Message-ID: <8E356A64-2B4F-11D8-892F-000A957FB6EA@striderweb.com> I'll try to keep this short... On Wednesday, December 10, 2003, at 06:32 AM, Russ wrote: >>> Granted, I'm making some semi-educated guesses here, but these guys >>> appear to be legitimately beating the system by fooling any >>> relatively >>> modern browser into not seeing the copy. >> >> Not legitimate. The SE's don't like any text that is deliberately >> written for the SE's and hidden to users. > > But, as far as I can tell, a spider won't be able to recognize that > this > is happening. > > It might not APPEAR to be legit to the rest of the planet, but I'm > pretty sure a spider cannot pick up on I think this is becoming an argument over the meaning of the word "legitimate". Armed robbery quite often works, but is not a "legitimate" way to make money. You're not _supposed_ to do things aimed a search engines that are hidden from end users; or to put it another way, if you have to conceal it, it's probably not legit. Now please excuse me while I find a place to hide Christmas presents... ;) Steve Rider From pixelmech at yahoo.com Wed Dec 10 15:45:40 2003 From: pixelmech at yahoo.com (Tom Dell'Aringa) Date: Wed, 10 Dec 2003 13:45:40 -0800 (PST) Subject: [thelist] need good examples of 2 level navigation Message-ID: <20031210214540.38469.qmail@web12606.mail.yahoo.com> Hi there, Working on a site where there is going to be a "2 level" or "stacked" navigation. In other words, there is horizontal nav bar as the primary nav. When you click a link there, you are shown another horizontal list of links below that form a subsection of the link you just clicked. I don't need code, what I'm hoping for is good, usable examples that are clear to the user where they are. So far our designs are not cutting it just yet. TIA Tom ===== http://www.pixelmech.com/ :: Web Development Services http://www.DMXzone.com/ :: JavaScript Author / Every Friday! http://www.thywordistruth.net/ :: Eternal Life [Those who say that I am finished, and am through, will have to run over my dead body to beat me...] From evolt at pixelwright.com Wed Dec 10 16:04:54 2003 From: evolt at pixelwright.com (James Aylard) Date: Wed, 10 Dec 2003 14:04:54 -0800 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' :'goodbye'; References: <72E9FAA171D63B48AAC707C72900E6B45A1DA7@ireland.spinhead.com> <3FD78439.1020901@belgacom.net> Message-ID: <008601c3bf69$a699e280$5360398a@newcos.com> Kristof Neirynck wrote: >>> Is the an ASP equivalent of PHP's syntax: >>> >>> $var = ($a == 0) ? 'hello' : 'goodbye'; >> >> If there's a cool 'immediate if' shortcut like the PHP versoin, I'd >> love to know it. > > This should work. > > Dim var as String > var = iif(a = 0, "Hello", "goodbye") But not in VBScript... James Aylard From evolt at funkwit.com Wed Dec 10 16:07:40 2003 From: evolt at funkwit.com (Paul Cowan) Date: Thu, 11 Dec 2003 09:07:40 +1100 Subject: [thelist] ASP equivalent of $var = ($a == 0) ? 'hello' : 'goodbye'; In-Reply-To: <3FD78439.1020901@belgacom.net> References: <72E9FAA171D63B48AAC707C72900E6B45A1DA7@ireland.spinhead.com> <3FD78439.1020901@belgacom.net> Message-ID: <717894317.1071133660@[192.168.2.62]> Kristof Neirynck wrote: > This should work. > > Dim var as String > var = iif(a = 0, "Hello", "goodbye") No it shouldn't. iif() is not a valid VBScript function. You could create a replacement iif() yourself -- but note that it won't be quite the same, due to VBScript's lack of short-circuit evaluation. Cheers, Paul From evolt at funkwit.com Wed Dec 10 16:08:56 2003 From: evolt at funkwit.com (Paul Cowan) Date: Thu, 11 Dec 2003 09:08:56 +1100 Subject: [thelist] mod_rewrite for IIS4? In-Reply-To: <20031210085829.W80956@ns2.iguanasoft.com> References: <20031210085829.W80956@ns2.iguanasoft.com> Message-ID: <717970947.1071133736@[192.168.2.62]> Dougal Campbell wrote: > Can anyone point me to an ISAPI for IIS4 which can operate similarly to > mod_rewrite for Apache? I seem to recall seeing references to such a > beast before, but I've searched all over and can't find it again. Haven't used it, but have heard good things about it. Paul From russ at unrealisticexpectations.com Wed Dec 10 16:18:25 2003 From: russ at unrealisticexpectations.com (Russ) Date: Wed, 10 Dec 2003 16:18:25 -0600 Subject: [thelist] More on Search Engines In-Reply-To: <8E356A64-2B4F-11D8-892F-000A957FB6EA@striderweb.com> Message-ID: <006501c3bf6b$88453a30$8de7b6cc@BubbaHoTep> > I think this is becoming an argument over the meaning of the word > "legitimate". Armed robbery quite often works, but is not a > "legitimate" way to make money. You're not _supposed_ to do things > aimed a search engines that are hidden from end users; or to put it > another way, if you have to conceal it, it's probably not > legit. Now > please excuse me while I find a place to hide Christmas presents... ;) I think you're right and I'll clarify over my use of the word "legitimate". It doesn't appear that doing this is anything that could be flagged as wrong--so it appears to me to be legitimate. That, and I'm not an SEO guy. However, I do think it is, indeed, a "dirty trick" but the way it's set up is so that it's pretty difficult to find unless an SEO guy asks someone who is able to dig through the mud a bit and figure out what they did. Sorry if I used that incorrectly (I'm pretty sure I did), but what they're doing doesn't immediately set off any alarms...blah blah blah... Just saying. Russ From evolt at funkwit.com Wed Dec 10 16:19:18 2003 From: evolt at funkwit.com (Paul Cowan) Date: Thu, 11 Dec 2003 09:19:18 +1100 Subject: [thelist] (SQL2k) NULL and LIKE In-Reply-To: References: Message-ID: <718592952.1071134358@[192.168.2.62]> Tab Alleman wrote: > So, NULL is LIKE '%RedAlert%'??? How so? Is this expected behavior? No, NULL is not LIKE '%RedAlert%'. But it's not NOT LIKE '%RedAlert%', either. Tri-value boolean logic is a tricky thing. Remember, 'null' isn't a 'special value', as some people think of it -- it's an _absence_ of a value. Or, even better, it's an _unknown_ value. Whenever you see 'null', think 'unknown value' Is 'unknown value' LIKE '%RedAlert%'? We don't know. We can't know, because we don't know what the value is. It might be, it might not be. So the answer isn't 'yes', or 'no', it's 'unknown'. Conversely, is 'unknown value' NOT LIKE '%RedAlert%'? We don't know, for the same reason. Therefore, that evaluates to 'unknown' too. When it comes to logical operators, it's even more fun. What's 'true AND null'? What about 'false AND null'? What about 'true OR null', or 'false AND null'? Hours of fun for the whole family. Paul PS: null, false, true, and null, respectively. From david at calteg.org Wed Dec 10 16:23:45 2003 From: david at calteg.org (David Siedband) Date: Wed, 10 Dec 2003 14:23:45 -0800 Subject: [thelist] HMTL Email In-Reply-To: References: Message-ID: <84AAAA6A-2B5F-11D8-B755-0003938911D8@calteg.org> CSS support in e-mail clients that support HTML e-mail is highly varied and inconsistent. If are sending HTML e-mail I'd recommend sticking to table-based layouts and inline HTML styling. -- Dave On Dec 10, 2003, at 8:29 AM, Mark Howells wrote: > Yes, that old arguing point again. It's essential that I apply some > kind of formatting to an HTML email - text colour and margins, mainly > - and I can't get it to respond to CSS, whether it's inline (on a > span) or in the head of the email. Works fine in Apple Mail, but > Entourage and Outlook Express - both Mac - ignore it. > > Any ideas? > Thanks and best regards > Mark Howells > http://www.mark.ac/ > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester and > archives of thelist go to: http://lists.evolt.org Workers of the Web, > evolt ! From syoung at unitec.ac.nz Wed Dec 10 16:23:15 2003 From: syoung at unitec.ac.nz (Stuart Young) Date: Thu, 11 Dec 2003 11:23:15 +1300 Subject: [thelist] More on Search Engines Message-ID: "Jeff Howden" 10/12/2003 21:44:58 wrote: when it comes to search engine ranking, imo, it comes down to the same old thing that's the draw for real-live viewers, content, content, content. look at evolt.org. zero search engine promotion. yet there are numerous search terms that we come up in the top 5 results. ----------------------------------- indeed, don't bother with contortions to "please" the search engines, "Content is King" just follow the rule: add a page of real informational content packed with keywords every day. and follow this truely excellent A-Z of advice: http://www.webmasterworld.com/forum3/2010.htm cheers Dr Stuart Young, +64 (0)9-815 4321 Ex 8656 Lecturer, School of Computing and Information Technology, UNITEC Institute of Technology, Auckland, New Zealand http://hyperdisc.unitec.ac.nz/staff/syoung.htm I would provide a URL for my official staffpage, but its too long and complex From jeff at jeffhowden.com Wed Dec 10 17:10:07 2003 From: jeff at jeffhowden.com (Jeff Howden) Date: Wed, 10 Dec 2003 15:10:07 -0800 Subject: [thelist] More on Search Engines In-Reply-To: <00dd01c3bf19$beb42330$1d03a8c0@autolycus> Message-ID: russ, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Russ > > But, as far as I can tell, a spider won't be able to > recognize that this is happening. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< they will for sure when someone reports it to the engine as spam. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > They're doing it on several pages, not just their own > doorway pages--call it SPAM if you like, but it's still > individual pages that have some technology that > customizes a pre-determined set of copy and replaces > certain words based on the page you came through. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< i *highly* doubt there's any text customization going on at all. there'd be *zero* benefit. why? well, search engines don't click links so the visitors that this site'd gain the most from customizing the text for aren't coming from a page. these doorway pages (which is what they are no matter if there are a few or hundreds) aren't designed for humans so it's not like users are clicking links to drive some sort of magic text-replacement engine anyway. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > It might not APPEAR to be legit to the rest of the > planet, but I'm pretty sure a spider cannot pick up on > their copy appearing as hidden since a spider isn't > going to be able to recognize a location based upon > CSS, and especially since a spider won't have the > CSS applied for it; it'll simply appear as text on > the page to the spider. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< the hidden copy is for the poor, unsuspecting human that lands on one of these pages without javascript. it's probably an attempt to make the page not look like search engine spam to humans that see it so it's less likely to get reported. .jeff ------------------------------------------------------ Jeff Howden - Web Application Specialist Resume - http://jeffhowden.com/about/resume/ Code Library - http://evolt.jeffhowden.com/jeff/code/ From cosming at as.ro Wed Dec 10 18:04:54 2003 From: cosming at as.ro (Cosmin G) Date: Thu, 11 Dec 2003 02:04:54 +0200 Subject: [thelist] Re: Database schema References: <20031210031321.E425CDACB8@freemail.as.ro> Message-ID: <001001c3bf7a$940644e0$ece1e6c1@voltec01> Well, I think the best thing I can do is show everyone the .sql file, so here goes: phpMyAdmin MySQL-Dump # version 2.4.0 # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generation Time: Dec 11, 2003 at 01:21 AM # Server version: 4.0.14 # PHP Version: 4.3.1 # Database : `garett_garettvoltec` # -------------------------------------------------------- # # Table structure for table `categories` # DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` ( `cat_id` int(11) NOT NULL auto_increment, `category_name` varchar(50) NOT NULL default '', `tip_categorie` varchar(50) NOT NULL default '', `state` smallint(6) NOT NULL default '1', PRIMARY KEY (`cat_id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `exch_rate` # DROP TABLE IF EXISTS `exch_rate`; CREATE TABLE `exch_rate` ( `usd_rate` mediumint(9) NOT NULL default '0', `modified` timestamp(14) NOT NULL ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `manufacturer` # DROP TABLE IF EXISTS `manufacturer`; CREATE TABLE `manufacturer` ( `manuf_id` int(11) NOT NULL auto_increment, `manuf_name` varchar(45) NOT NULL default '', `website` varchar(70) NOT NULL default '', `logo` varchar(60) NOT NULL default '', PRIMARY KEY (`manuf_id`) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `product` # DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `prod_id` int(11) NOT NULL auto_increment, `cat_id` int(11) NOT NULL default '0', `manuf_id` int(11) NOT NULL default '0', `name` varchar(50) NOT NULL default '', `description` text NOT NULL, `state` smallint(6) NOT NULL default '0', `picture` varchar(255) NOT NULL default '', `price` int(11) NOT NULL default '0', `warranty` varchar(5) NOT NULL default '', `model` varchar(45) NOT NULL default '', `code_name` varchar(45) NOT NULL default '', `mb_ob` set('audio','video','LAN','modem') NOT NULL default '', `cpu_socket` varchar(15) NOT NULL default '', `cpu_freq` smallint(7) NOT NULL default '0', `cpu_fsb` smallint(6) NOT NULL default '0', `cpu_cache_l2` varchar(15) NOT NULL default '', `mb_chip` varchar(30) NOT NULL default '', `mb_format` varchar(5) NOT NULL default '', `mb_socket` varchar(50) NOT NULL default '', `mb_fsb` varchar(10) NOT NULL default '', `mb_cpu` varchar(20) NOT NULL default '', `mb_mem` varchar(12) NOT NULL default '', `mb_slots` tinyint(2) NOT NULL default '0', `mb_hdd` varchar(20) NOT NULL default '', `mb_vid_mode` varchar(15) NOT NULL default '', `hd_cap` varchar(15) NOT NULL default '', `hd_rpm` varchar(10) NOT NULL default '', `hd_interf` varchar(20) NOT NULL default '', `hd_access_time` tinyint(5) NOT NULL default '0', `hd_mem` tinyint(2) NOT NULL default '0', `mem_late` varchar(15) NOT NULL default '', `mem_tip` varchar(15) NOT NULL default '', `mem_capa` varchar(15) NOT NULL default '', `mem_freq` varchar(15) NOT NULL default '', `speaker_model` varchar(20) NOT NULL default '', `speaker_type` varchar(8) NOT NULL default '', `speaker_freq` varchar(50) NOT NULL default '', `speaker_signal_noise` varchar(50) NOT NULL default '', `mon_type` varchar(15) NOT NULL default '', `mon_diag` varchar(25) NOT NULL default '', `mon_max_res` varchar(25) NOT NULL default '', `case_type` varchar(45) NOT NULL default '', `car_power` varchar(15) NOT NULL default '', `md_tip` varchar(15) NOT NULL default '', `md_bla` varchar(15) NOT NULL default '', `md_model` varchar(15) NOT NULL default '', `kb_model` varchar(30) NOT NULL default '', `kb_conection` varchar(25) NOT NULL default '', `conex` varchar(30) NOT NULL default '', `print_tip` varchar(30) NOT NULL default '', `print_tip_pagina` varchar(30) NOT NULL default '', `print_speed` varchar(80) NOT NULL default '', `pv_chipset` varchar(50) NOT NULL default '', `pv_mem` varchar(50) NOT NULL default '', `pv_tip_mem` varchar(50) NOT NULL default '', `scan_tip` varchar(20) NOT NULL default '', `scan_interface` varchar(20) NOT NULL default '', `scan_resolution` varchar(20) NOT NULL default '', `scan_colors` varchar(30) NOT NULL default '', `scan_paper` varchar(30) NOT NULL default '', PRIMARY KEY (`prod_id`) ) TYPE=MyISAM; > Specifically, what > is the main purpose of the DB. It would be meant for a online store. And I've been asked to make it so that people could perform searches according to very specific details for each product, hence the big number of details in the 'products' table. The exchange rate table would contain the daily USD exchange rate since where I live prices revolve around the USD, (and no, I'm not living in America :) ), hence a product's price is determined along the lines of 50$*daily exch rate*VAT. Any suggestions deeply appreciated. ----- Original Message ----- From: To: Sent: Wednesday, 10 December, 2003 05:13 AM Subject: thelist Digest, Vol 10, Issue 18 > 1. Database schema (Cosmin G) > 22. RE: Database schema (Ken Moore) > 24. RE: Database schema (Tab Alleman) > 27. RE: Database schema (Joel D Canfield) > 28. RE: Database schema (Ed McCarroll) > > > ---------------------------------------------------------------------- > > Date: Tue, 9 Dec 2003 13:34:33 +0200 > From: "Cosmin G" > To: > Subject: [thelist] Database schema > Message-ID: <004801c3be4c$218174f0$fc69e9d5 at voltec01> > Content-Type: text/plain; > charset="iso-8859-1" > MIME-Version: 1.0 > Content-Transfer-Encoding: 7bit > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 1 > > Hi. I've been asked to develop a database for a computer website. Right now > I have the following tables: > categories (1 - cpu's, 2 - hard-drives, ) > producer > product > exchange rate > All products have some common values (price, warranty period, description) > and there are some fields which are product specific (such as cpu frequency, > cpu cache memory, etc). Right now I've stored all the product specific > fields in the products table and prefixed them with the name of the category > they refer to. Is this a good approach or should I put them in separate > tables? The table is getting pretty unmanageable already. > > > ------------------------------ > > Date: Tue, 09 Dec 2003 12:02:11 -0700 > From: "Ken Moore" > To: thelist at lists.evolt.org > Subject: RE: [thelist] Database schema > Message-ID: > Content-Type: text/plain; format=flowed > MIME-Version: 1.0 > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 22 > > Hi all, > > Cosmin G wrote: > > >Hi. I've been asked to develop a database for a computer website. Right now > >I have the following tables: > >categories (1 - cpu's, 2 - hard-drives, ) > >producer > >product > >exchange rate > >All products have some common values (price, warranty period, description) > >and there are some fields which are product specific (such as cpu > >frequency, > >cpu cache memory, etc). Right now I've stored all the product specific > >fields in the products table and prefixed them with the name of the > >category > >they refer to. Is this a good approach or should I put them in separate > >tables? The table is getting pretty unmanageable already. > > As a database programmer for 20 years, I have got several ideas. But I will > need more info. Since I have just had a nearly unsolvable problem solved > off-line (thank you very much Chris Rosser) I would be happy to help if you > want to write with more details at psm2713 at hotmail.com. Specifically, what > is the main purpose of the DB. > > The key is to design well. Once you have done that, many other problems > become much easier. > > Ken. > > Date: Tue, 9 Dec 2003 15:21:03 -0500 > From: "Tab Alleman" > To: > Subject: RE: [thelist] Database schema > Message-ID: > Content-Type: text/plain; > charset="us-ascii" > MIME-Version: 1.0 > Content-Transfer-Encoding: quoted-printable > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 24 > > Cosmin G wrote: > > Hi. I've been asked to develop a database for a computer website. > > Right now I have the following tables: > > categories (1 - cpu's, 2 - hard-drives, ) > > producer > > product > > exchange rate > > All products have some common values (price, warranty period, > > description) and there are some fields which are product specific > > (such as cpu frequency, cpu cache memory, etc). Right now I've stored > > all the product specific fields in the products table and prefixed > > them with the name of the category they refer to. Is this a good > > approach or should I put them in separate tables? The table is > > getting pretty unmanageable already.=20 > > I favor splitting category-specific columns into separate tables. > ------------------------------ > > Date: Tue, 09 Dec 2003 14:30:33 -0600 > From: Minh Lee Goon > To: thelist at lists.evolt.org > Subject: Re: [thelist] table height: 100% with CSS > Message-ID: <3FD630E9.30207 at goonies.info> > In-Reply-To: <50229.135.196.95.234.1070896320.squirrel at www.johnallsopp.co.uk> > References: <50229.135.196.95.234.1070896320.squirrel at www.johnallsopp.co.uk> > Content-Type: text/plain; charset=us-ascii; format=flowed > MIME-Version: 1.0 > Content-Transfer-Encoding: 7bit > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 25 > > You can use the deprecated cousin of the width attribute, called height. >
> > If you have multiple rows (e.g. a header row and a content row) in your > table, you should specify the height of the header row as well (. Opera doesn't allow that. But as long as you define your own attributes it should work fine. ------------------------------------------------------------------- ppk, freelance web developer Interaction, copywriting, JavaScript, integration http://www.quirksmode.org/ Column "Keep it Simple": http://www.digital-web.com/columns/keepitsimple/ ------------------------------------------------------------------ _________________________________________________________________ MSN Search, for accurate results! http://search.msn.nl From ben.morrison at dogstardesign.co.uk Thu Dec 11 03:39:10 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Thu, 11 Dec 2003 09:39:10 +0000 Subject: [thelist] Change Iframe background colour Message-ID: Is this possible? http://www.pup-e.co.uk/sitecheck/iframetest.htm I cant find a x-browser solution to change the background colour of an iframe, ie seems to work fine, but no luck in safari, here is my current code: function change_background() { document.frames.subscribe.document.body.style.backgroundColor="#CCFF66"; } I have tried (with no results): document.getElementById('subscribe').style.background="#CCFF66"; I also tried using css to set the iframe properties: #subscribe{ background:#CCFF66; } iframe { ? ?background:#CCFF66; } Any pointers much apreciated, I have read that the *new* version of safari will support iframe transparency. Benjer From bhurtt at mindspring.com Thu Dec 11 05:42:58 2003 From: bhurtt at mindspring.com (Brian Hurtt) Date: Thu, 11 Dec 2003 05:42:58 -0600 Subject: [thelist] Change Iframe background colour In-Reply-To: Message-ID: is there a reason you don't just set the background color in the iframe's src document (subscribe.htm)? -----Original Message----- From: thelist-bounces-bhurtt=mindspring.com at lists.evolt.org [mailto:thelist-bounces-bhurtt=mindspring.com at lists.evolt.org]On Behalf Of Ben Morrison Sent: Thursday, December 11, 2003 3:39 AM To: thelist at lists.evolt.org Subject: [thelist] Change Iframe background colour Is this possible? http://www.pup-e.co.uk/sitecheck/iframetest.htm I cant find a x-browser solution to change the background colour of an iframe, ie seems to work fine, but no luck in safari, here is my current code: function change_background() { document.frames.subscribe.document.body.style.backgroundColor="#CCFF66"; } I have tried (with no results): document.getElementById('subscribe').style.background="#CCFF66"; I also tried using css to set the iframe properties: #subscribe{ background:#CCFF66; } iframe { ? ?background:#CCFF66; } Any pointers much apreciated, I have read that the *new* version of safari will support iframe transparency. Benjer -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From ben.morrison at dogstardesign.co.uk Thu Dec 11 05:50:57 2003 From: ben.morrison at dogstardesign.co.uk (Ben Morrison) Date: Thu, 11 Dec 2003 11:50:57 +0000 Subject: [thelist] Change Iframe background colour In-Reply-To: Message-ID: On 11/12/03 11:42 am, "Brian Hurtt" wrote: > is there a reason you don't just set the background color in the iframe's > src document (subscribe.htm)? Its for a email system that is being hosted elsewhere, the cost for them to customise the pages for individual clients was excessive to say the least. Our solution is to have the forms, repsonse text etc very basicly styled. We can then use an iframe on our pages and change background colours etc as needed to match different clients. benjer From manuel at simplelogica.net Thu Dec 11 06:02:49 2003 From: manuel at simplelogica.net (Manuel =?ISO-8859-1?Q?Gonz=E1lez?= Noriega) Date: 11 Dec 2003 13:02:49 +0100 Subject: [thelist] Change Iframe background colour In-Reply-To: References: Message-ID: <1071144206.2831.13.camel@nofx> El jue, 11-12-2003 a las 12:50, Ben Morrison escribi?: > On 11/12/03 11:42 am, "Brian Hurtt" wrote: > > > is there a reason you don't just set the background color in the iframe's > > src document (subscribe.htm)? > > Its for a email system that is being hosted elsewhere, the cost for them to > customise the pages for individual clients was excessive to say the least. > > Our solution is to have the forms, repsonse text etc very basicly styled. We > can then use an iframe on our pages and change background colours etc as > needed to match different clients. > > benjer > > If client-side it's too difficult, could you try to do it serverside? Call the iframe passing it a client ID In the iframe use some script language to catch the client ID, look up the client's bgcolor and write a custom
height="200">) and the rest of the table will be 100% less 200px. > > Minh Lee > > > Maybe I'm having a stupid moment, but I can't see how to make a table 100% > > high in CSS. > ------------------------------ > > Date: Tue, 09 Dec 2003 14:35:59 -0600 > From: Simon Willison > To: "thelist at lists.evolt.org" > Subject: Re: [thelist] Web UI Question > Message-ID: <3FD6322F.6040808 at bath.ac.uk> > In-Reply-To: <004201c3bdc6$78e25920$0300000a at hershel2000> > References: <004201c3bdc6$78e25920$0300000a at hershel2000> > Content-Type: text/plain; charset=us-ascii; format=flowed > MIME-Version: 1.0 > Content-Transfer-Encoding: 7bit > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 26 > > Hershel Robinson wrote: > > When he goes back in to edit one of these numbers, then it jumps to the left > > again. This IS a bit weird, but the display looks nice. > > > > Any one have any thoughts on this? > > Ask some users. Or even better, run some usability tests and watch what > the users do - if they seem unduly distrurbed by it, ditch it. > Personally it sounds just fine to me - I've seen interfaces that do this > before (doesn't Excel do exactly this?) and never been troubled by them. > ------------------------------ > > Date: Tue, 9 Dec 2003 12:52:27 -0800 > From: "Joel D Canfield" > To: > Subject: RE: [thelist] Database schema > Message-ID: <72E9FAA171D63B48AAC707C72900E6B45A1DA5 at ireland.spinhead.com> > Content-Type: text/plain; > charset="us-ascii" > MIME-Version: 1.0 > Content-Transfer-Encoding: quoted-printable > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 27 > > Right now I've stored all the product specific > > fields in the products table and prefixed them with the name=20 > > of the category > > they refer to. Is this a good approach or should I put them=20 > > in separate > > tables? The table is getting pretty unmanageable already. > > All the product stuff should go in 'products' > > What fields do you have in there? It's hard to imagine (for me, anyway) > so many fields that it would be unmanageable. Maybe there *is* stuff in > there that belongs elsewhere, but it's hard to say without seeing a > field list. > > joel > ------------------------------ > > Date: Tue, 9 Dec 2003 13:16:04 -0800 > From: "Ed McCarroll" > To: > Subject: RE: [thelist] Database schema > Message-ID: > In-Reply-To: <004801c3be4c$218174f0$fc69e9d5 at voltec01> > Content-Type: text/plain; > charset="iso-8859-1" > MIME-Version: 1.0 > Content-Transfer-Encoding: 7bit > Precedence: list > Reply-To: "thelist at lists.evolt.org" > Message: 28 > > > Right now I've stored all the product specific fields in the products > > table and prefixed them with the name of the category they refer to. > > Is this a good approach or should I put them in separate tables? The > > table is getting pretty unmanageable already. > > It depends upon what you're doing with the data, but I'd be inclined to > set up one table for each category. IMO, a good schema is one that > accurately models the real world, and CPUs and hard drives aren't > really the same kind of things. > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > Ed McCarroll MailTo:Ed at ComSimplicity.com > ComSimplicity (310) 838-4330 From ken at adOpenStatic.com Wed Dec 10 18:21:50 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Thu, 11 Dec 2003 11:21:50 +1100 Subject: [thelist] VSS "Deploy" shortcut? References: <6E85D194CD14D341AB3AF41DB59D1BAE0DE684@basefs01.corp.basecorp.com> Message-ID: <021001c3bf7c$c9479f30$9600a8c0@careersAD.unsw.edu.au> Not one, but you could do it in three keystrokes. Alt, W, D VSS is not one of Microsoft's better products :-) Cheers Ken Microsoft MVP - Windows Server (IIS) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Chris George" Subject: [thelist] VSS "Deploy" shortcut? Hey, Does anyone know if there's some sort of handy, apparently secret keyboard shortcut for the Deploy command under the Web menu in Visual Source Safe? After checking in/putting files in DWMX, I find that the extra step, no matter how fast I am with my mouse is eating up workflow. Any thoughts? Is there a way to map a keystroke on a PC to do the same thing? (I'm generally more comfortable with a Mac, so pardon my ignorance) Thanks! Chris. From info at scribenewmedia.com Wed Dec 10 18:26:20 2003 From: info at scribenewmedia.com (Tony Grimes) Date: Wed, 10 Dec 2003 17:26:20 -0700 Subject: [thelist] GoLive Global Functions? Message-ID: A client of mine was going through a web directory and found a JavaScript file titled "CSScriptLib.js" and has the following comments at the top of the page: // -- Adobe GoLive JavaScript Library // -- Global Functions The page essentially contains only functions. Does anyone know what GoLive uses these for? Are they parts of canned scripts to add to web pages or are they just needed for GoLive to function? I've never used the program before, but the site was originally built with GL. Is it safe to delete this file if my client isn't using GoLive? He doesn?t want any on-page scripts to break if this page is required (I don't have access to the site itself, so I can't be sure if the functions are used). TIA Tony From magic32 at jps.net Wed Dec 10 18:48:35 2003 From: magic32 at jps.net (Roger Harness) Date: Wed, 10 Dec 2003 16:48:35 -0800 Subject: [thelist] parking domains Message-ID: Folks...quick question. A friend is going to have his site published in january sometime. But i dont even thing he knows who's going to host it yet. but he's got an article coming out, letting folks know what the website will be, so he wants to register (park?) the name now, so no one can take it. obviously that's maybe not the best way to do it, but oh well. so...is the only way he can park it is to first find the company hes going to use, then register it with them?? ive done a few sites, but embarassingly, i dont really know the answer to this. im googling, but all im finding is companies that want to take him aboard, and register for him. Is that the only way to safe-guard his website name?? Thanks folks, -Roger Harness Roger Harness http://www.rogerharness.com creative internet solutions From ken at adOpenStatic.com Wed Dec 10 19:39:17 2003 From: ken at adOpenStatic.com (Ken Schaefer) Date: Thu, 11 Dec 2003 12:39:17 +1100 Subject: [thelist] Re: Database schema References: <20031210031321.E425CDACB8@freemail.as.ro> <001001c3bf7a$940644e0$ece1e6c1@voltec01> Message-ID: <02d101c3bf87$9acf6880$9600a8c0@careersAD.unsw.edu.au> Personally, I don't think that posting your .sql statement is a good idea at all. I'm sure that if Rudy was still actively participating he'd say the same thing. Your "Product" table does look messy, and I can understand why you're starting to think that it's becoming unmanageable. However, as stated before, you're jumping the gun. You need to do some ER model *first*. You need to create some DFD (or similar) *first*. Once you have these things, the database schema will write itself. There are many different ways that this could be approached but without the appropriate modelling of the system, all you're doing is relying on experience/gut feeling, and it appers that this isn't getting you the answers you need. Do the model first. Post it up someplace, and then we can tell you what you need to do. Cheers Ken Microsoft MVP - Windows Server (IIS) PS One possiblity is to store the attribute as a value in a column: TABLE: PRODUCTATTRIBUTES ProductID Attribute AttributeValue 1 ScanResolution 300 DPI 1 Weight 2 kg 2 CPU_FSB 333 MHz but, I can give you another dozen different ways you can organise your data. Create your ER diagram please. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Cosmin G" Subject: [thelist] Re: Database schema : Well, I think the best thing I can do is show everyone the .sql file, so : here goes: : : phpMyAdmin MySQL-Dump : # version 2.4.0 : # http://www.phpmyadmin.net/ (download page) : # : # Host: localhost : # Generation Time: Dec 11, 2003 at 01:21 AM : # Server version: 4.0.14 : # PHP Version: 4.3.1 : # Database : `garett_garettvoltec` : # -------------------------------------------------------- : : # : # Table structure for table `categories` : # : : DROP TABLE IF EXISTS `categories`; : CREATE TABLE `categories` ( : `cat_id` int(11) NOT NULL auto_increment, : `category_name` varchar(50) NOT NULL default '', : `tip_categorie` varchar(50) NOT NULL default '', : `state` smallint(6) NOT NULL default '1', : PRIMARY KEY (`cat_id`) : ) TYPE=MyISAM; : # -------------------------------------------------------- : : # : # Table structure for table `exch_rate` : # : : DROP TABLE IF EXISTS `exch_rate`; : CREATE TABLE `exch_rate` ( : `usd_rate` mediumint(9) NOT NULL default '0', : `modified` timestamp(14) NOT NULL : ) TYPE=MyISAM; : # -------------------------------------------------------- : : # : # Table structure for table `manufacturer` : # : : DROP TABLE IF EXISTS `manufacturer`; : CREATE TABLE `manufacturer` ( : `manuf_id` int(11) NOT NULL auto_increment, : `manuf_name` varchar(45) NOT NULL default '', : `website` varchar(70) NOT NULL default '', : `logo` varchar(60) NOT NULL default '', : PRIMARY KEY (`manuf_id`) : ) TYPE=MyISAM; : # -------------------------------------------------------- : : # : # Table structure for table `product` : # : : DROP TABLE IF EXISTS `product`; : CREATE TABLE `product` ( : `prod_id` int(11) NOT NULL auto_increment, : `cat_id` int(11) NOT NULL default '0', : `manuf_id` int(11) NOT NULL default '0', : `name` varchar(50) NOT NULL default '', : `description` text NOT NULL, : `state` smallint(6) NOT NULL default '0', : `picture` varchar(255) NOT NULL default '', : `price` int(11) NOT NULL default '0', : `warranty` varchar(5) NOT NULL default '', : `model` varchar(45) NOT NULL default '', : `code_name` varchar(45) NOT NULL default '', : `mb_ob` set('audio','video','LAN','modem') NOT NULL default '', : `cpu_socket` varchar(15) NOT NULL default '', : `cpu_freq` smallint(7) NOT NULL default '0', : `cpu_fsb` smallint(6) NOT NULL default '0', : `cpu_cache_l2` varchar(15) NOT NULL default '', : `mb_chip` varchar(30) NOT NULL default '', : `mb_format` varchar(5) NOT NULL default '', : `mb_socket` varchar(50) NOT NULL default '', : `mb_fsb` varchar(10) NOT NULL default '', : `mb_cpu` varchar(20) NOT NULL default '', : `mb_mem` varchar(12) NOT NULL default '', : `mb_slots` tinyint(2) NOT NULL default '0', : `mb_hdd` varchar(20) NOT NULL default '', : `mb_vid_mode` varchar(15) NOT NULL default '', : `hd_cap` varchar(15) NOT NULL default '', : `hd_rpm` varchar(10) NOT NULL default '', : `hd_interf` varchar(20) NOT NULL default '', : `hd_access_time` tinyint(5) NOT NULL default '0', : `hd_mem` tinyint(2) NOT NULL default '0', : `mem_late` varchar(15) NOT NULL default '', : `mem_tip` varchar(15) NOT NULL default '', : `mem_capa` varchar(15) NOT NULL default '', : `mem_freq` varchar(15) NOT NULL default '', : `speaker_model` varchar(20) NOT NULL default '', : `speaker_type` varchar(8) NOT NULL default '', : `speaker_freq` varchar(50) NOT NULL default '', : `speaker_signal_noise` varchar(50) NOT NULL default '', : `mon_type` varchar(15) NOT NULL default '', : `mon_diag` varchar(25) NOT NULL default '', : `mon_max_res` varchar(25) NOT NULL default '', : `case_type` varchar(45) NOT NULL default '', : `car_power` varchar(15) NOT NULL default '', : `md_tip` varchar(15) NOT NULL default '', : `md_bla` varchar(15) NOT NULL default '', : `md_model` varchar(15) NOT NULL default '', : `kb_model` varchar(30) NOT NULL default '', : `kb_conection` varchar(25) NOT NULL default '', : `conex` varchar(30) NOT NULL default '', : `print_tip` varchar(30) NOT NULL default '', : `print_tip_pagina` varchar(30) NOT NULL default '', : `print_speed` varchar(80) NOT NULL default '', : `pv_chipset` varchar(50) NOT NULL default '', : `pv_mem` varchar(50) NOT NULL default '', : `pv_tip_mem` varchar(50) NOT NULL default '', : `scan_tip` varchar(20) NOT NULL default '', : `scan_interface` varchar(20) NOT NULL default '', : `scan_resolution` varchar(20) NOT NULL default '', : `scan_colors` varchar(30) NOT NULL default '', : `scan_paper` varchar(30) NOT NULL default '', : PRIMARY KEY (`prod_id`) : ) TYPE=MyISAM; : : > Specifically, what : > is the main purpose of the DB. : : It would be meant for a online store. And I've been asked to make it so that : people could perform searches according to very specific details for each : product, hence the big number of details in the 'products' table. : The exchange rate table would contain the daily USD exchange rate since : where I live prices revolve around the USD, (and no, I'm not living in : America :) ), hence a product's price is determined along the lines of : 50$*daily exch rate*VAT. : Any suggestions deeply appreciated. : From paul at teltest.com Wed Dec 10 19:51:01 2003 From: paul at teltest.com (Paul Bennett) Date: Thu, 11 Dec 2003 14:51:01 +1300 Subject: [thelist] parking domains In-Reply-To: References: Message-ID: <3FD7CD85.9020706@teltest.com> Roger Harness wrote: >Folks...quick question. A friend is going to have his site published in >january sometime. But i dont even thing he knows who's going to host it yet. >... > > many domain registraars (sp?) will let you park the domain for free with them until you host it - then when you host it you change the dns under the domain settings to point to the new host. Domain registrtaion doesn't need to affect your hosting decision, in my experience. HTH :) -- ------------------------------ Paul Bennett Internet Developer Teltest Electronic Design ------------------------------ Email: paul at teltest.com Phone: 64 4 237 4557 Web: http://www.teltest.com Wap: http://wap.teltest.com From damiencola at wanadoo.fr Wed Dec 10 20:57:57 2003 From: damiencola at wanadoo.fr (Damien COLA) Date: Thu, 11 Dec 2003 03:57:57 +0100 Subject: [thelist] need good examples of 2 level navigation In-Reply-To: <20031210214540.38469.qmail@web12606.mail.yahoo.com> Message-ID: <000301c3bf92$950ccb80$0100a8c0@ELECTRA> I like Macromedia's : http://www.macromedia.com -----Original Message----- I don't need code, what I'm hoping for is good, usable examples that are clear to the user where they are. So far our designs are not cutting it just yet. From david at calteg.org Wed Dec 10 21:58:11 2003 From: david at calteg.org (David Siedband) Date: Wed, 10 Dec 2003 19:58:11 -0800 Subject: [thelist] Re: Database schema In-Reply-To: <001001c3bf7a$940644e0$ece1e6c1@voltec01> References: <20031210031321.E425CDACB8@freemail.as.ro> <001001c3bf7a$940644e0$ece1e6c1@voltec01> Message-ID: <3FD7EB53.2030403@calteg.org> I think it would make sense to break up the products table a bit. Any time when you find yourself with a table where you would have a large amount of fields that are not getting used, it's a good candidate for breaking into more specificized tables that get joined to the original. This is a clue that the table is decribing multiple entity types, which is usually suboptimal. I would suggest putting the printer and scanner specific fields in a common table though to accomidate printer/scaner/fax devices. -- Dave Cosmin G wrote: >Well, I think the best thing I can do is show everyone the .sql file, so >here goes: > > ># ># Table structure for table `product` ># > >DROP TABLE IF EXISTS `product`; >CREATE TABLE `product` ( > `prod_id` int(11) NOT NULL auto_increment, > `cat_id` int(11) NOT NULL default '0', > `manuf_id` int(11) NOT NULL default '0', > `name` varchar(50) NOT NULL default '', > `description` text NOT NULL, > `state` smallint(6) NOT NULL default '0', > `picture` varchar(255) NOT NULL default '', > `price` int(11) NOT NULL default '0', > `warranty` varchar(5) NOT NULL default '', > `model` varchar(45) NOT NULL default '', > `code_name` varchar(45) NOT NULL default '', > `mb_ob` set('audio','video','LAN','modem') NOT NULL default '', > `cpu_socket` varchar(15) NOT NULL default '', > `cpu_freq` smallint(7) NOT NULL default '0', > `cpu_fsb` smallint(6) NOT NULL default '0', > `cpu_cache_l2` varchar(15) NOT NULL default '', > `mb_chip` varchar(30) NOT NULL default '', > `mb_format` varchar(5) NOT NULL default '', > `mb_socket` varchar(50) NOT NULL default '', > `mb_fsb` varchar(10) NOT NULL default '', > `mb_cpu` varchar(20) NOT NULL default '', > `mb_mem` varchar(12) NOT NULL default '', > `mb_slots` tinyint(2) NOT NULL default '0', > `mb_hdd` varchar(20) NOT NULL default '', > `mb_vid_mode` varchar(15) NOT NULL default '', > `hd_cap` varchar(15) NOT NULL default '', > `hd_rpm` varchar(10) NOT NULL default '', > `hd_interf` varchar(20) NOT NULL default '', > `hd_access_time` tinyint(5) NOT NULL default '0', > `hd_mem` tinyint(2) NOT NULL default '0', > `mem_late` varchar(15) NOT NULL default '', > `mem_tip` varchar(15) NOT NULL default '', > `mem_capa` varchar(15) NOT NULL default '', > `mem_freq` varchar(15) NOT NULL default '', > `speaker_model` varchar(20) NOT NULL default '', > `speaker_type` varchar(8) NOT NULL default '', > `speaker_freq` varchar(50) NOT NULL default '', > `speaker_signal_noise` varchar(50) NOT NULL default '', > `mon_type` varchar(15) NOT NULL default '', > `mon_diag` varchar(25) NOT NULL default '', > `mon_max_res` varchar(25) NOT NULL default '', > `case_type` varchar(45) NOT NULL default '', > `car_power` varchar(15) NOT NULL default '', > `md_tip` varchar(15) NOT NULL default '', > `md_bla` varchar(15) NOT NULL default '', > `md_model` varchar(15) NOT NULL default '', > `kb_model` varchar(30) NOT NULL default '', > `kb_conection` varchar(25) NOT NULL default '', > `conex` varchar(30) NOT NULL default '', > `print_tip` varchar(30) NOT NULL default '', > `print_tip_pagina` varchar(30) NOT NULL default '', > `print_speed` varchar(80) NOT NULL default '', > `pv_chipset` varchar(50) NOT NULL default '', > `pv_mem` varchar(50) NOT NULL default '', > `pv_tip_mem` varchar(50) NOT NULL default '', > `scan_tip` varchar(20) NOT NULL default '', > `scan_interface` varchar(20) NOT NULL default '', > `scan_resolution` varchar(20) NOT NULL default '', > `scan_colors` varchar(30) NOT NULL default '', > `scan_paper` varchar(30) NOT NULL default '', > PRIMARY KEY (`prod_id`) >) TYPE=MyISAM; > > > > > > From evolt at brasscannon.net Wed Dec 10 22:02:00 2003 From: evolt at brasscannon.net (Kevin Martin) Date: Wed, 10 Dec 2003 23:02:00 -0500 Subject: [thelist] Re: parking domains In-Reply-To: <20031211023831.D7F961A9DB@brasscannon.net> References: <20031211023831.D7F961A9DB@brasscannon.net> Message-ID: <20031211040200.GA16408@howie.kebm.net> Quoth "Roger Harness" > > Folks...quick question. A friend is going to have his site published in > january sometime. But i dont even thing he knows who's going to host it > yet. [...] Is that the only way to safe-guard his website name?? Registering the domain is the only way to ensure he'll have it when he wants it. He can register it with any of many registries or their resellers, and then put it anywhere he pleases -- but if it's not registered yet, and someone else has the same brainstorm, they can put it anywhere THEY please and your friend is out of luck. It's just that simple. He'll also need DNS; a domain does not exist until it has DNS from two servers. The DNS doesn't have to point anywhere interesting; those servers just have to say "Yeah, that domain exists" if they are asked about it. See http://www.handsonhowto.com/dns101.html (I ought to break this down -- there's still a lot I can do to make it simpler. Comments -- and followup questions! -- welcomed.) From Hershel at GalleryRobinson.com Wed Dec 10 08:54:53 2003 From: Hershel at GalleryRobinson.com (Hershel Robinson) Date: Wed, 10 Dec 2003 09:54:53 -0500 Subject: [thelist] regex: replacing bracket characters In-Reply-To: <20031210140537.32578.qmail@web12606.mail.yahoo.com> Message-ID: <004701c3bf2d$ae937a00$0300000a@hershel2000> > objRegExp = /()/g; > objRegExp = /\(\)/g; Those would match only the text '()'. Probably the second one actually. The first is probably meaningless, depending on what language you are using. You need either to use 2 expressions: objRegExp = /\(/g; objRegExp = /\)/g; and execute each separately or use an option like: objRegExp = /[\(\)]/g; which may or may not work depending on what language you are using to execute your regular expression. There are many and each implements them differently. Furthermore you need to be sure to replace the found text, as in: objRegExp = s/[\(\)]//g; Again, depending on the language. HTH Hershel From zamba at zamba.com Wed Dec 10 18:24:57 2003 From: zamba at zamba.com (Tony Page) Date: Thu, 11 Dec 2003 11:24:57 +1100 Subject: [thelist] Mod_rewrit and classic sysadmin response In-Reply-To: <001a01c3bf27$20c7ca60$1200a8c0@david> Message-ID: <000001c3bf7d$384e0400$8e01a8c0@Workstation> David Kaufman wrote: > all the info you need about mod_rewrit is right there in that > statement: it uses the worst form of security: obscurity. "we can't > tell you anything about it" translates to: it's only "secure" because > so few people have a) of it (yet), b) seen the source code (if > anyone, yet), widely tested it (yet) and/or found any bugs or > security holes in it ... yet. > >> [...] or ideas about workarounds? > > work around #1: find a better web hosting provider: (see www.pair.com) > > -dave Ain't that the truth! It may well come to the second option for this site, unfortunately my current technical financial set-up limits wholesale switching without considerable effort. I'm tempted to go for a dedicated server and put all the sites on that, but I'm concerned about putting all my eggs in one basket, so to speak. The prospect of a dozen clients on my neck simultaneously is not attractive! What do other small shops do, run a back-up server? As I'm in Australia, and frankly the best server/ISP deals are in the States, I have to make sure I've got a stable set-up. Tony From dianesoini at earthlink.net Wed Dec 10 20:11:31 2003 From: dianesoini at earthlink.net (Diane Soini) Date: Wed, 10 Dec 2003 18:11:31 -0800 Subject: [thelist] Re: thelist Digest, Vol 10, Issue 15 In-Reply-To: <200312082018.1atzkU3ni3NZFkN0@swallow> Message-ID: <5630CB0C-2B7F-11D8-84A0-00039358CB42@earthlink.net> What if you don't feel qualified to give a tip? I've wondered that. It seems that most of you know everything already. Here's my tip just in case: If you name your flash object instances with certain suffixes on them, the Actionscript editor will show you code hints when writing code for the object. For example, name a movieclip instance myMC_mc and the _mc will let Flash know it's a movieclip, and movieclip methods will come up in the code hints. You can find lists of the suffixes for movieclips and other Flash objects, including components, online. Here are two links: http://www.macromedia.com/livedocs/flash/mx2004/main/03_wri12.htm http://www.danieldura.com/quickref.htm On Monday, December 8, 2003, at 08:18 PM, thelist-request at lists.evolt.org wrote: > Meantime, tips please from anyone insisting on continuing this > thread - though ideally please reply to John offlist. > > > jh From dianesoini at earthlink.net Wed Dec 10 22:13:03 2003 From: dianesoini at earthlink.net (Diane Soini) Date: Wed, 10 Dec 2003 20:13:03 -0800 Subject: [thelist] More on Search Engines In-Reply-To: <200312100427.1au3qQ6qv3NZFjX0@robin> Message-ID: <505295CF-2B90-11D8-84A0-00039358CB42@earthlink.net> On Wednesday, December 10, 2003, at 04:27 AM, thelist-request at lists.evolt.org wrote: > when it comes to search engine ranking, imo, it comes down to the same > old > thing that's the draw for real-live viewers, content, content, content. > look at evolt.org. zero search engine promotion. yet there are > numerous > search terms that we come up in the top 5 results. I have to agree, but not because I have any special knowledge. I had no idea Google was making any kind of change. I recently redesigned my personal web site. I took special care to ensure that it was nearly 100% navigable in a text-only browser. (It almost looks better in a text only browser.) I put good, descriptive titles on every page, put relevant and keyword/description tags on most pages (relevant as in they weren't designed with SEO in mind, they simply describe the page), used

tags, and the like etc. Nothing else. I do have the advantage that the subject matter is narrow and the content is good (according to people who email me), however I see that I come up much higher on Google than I did before with zero effort on my part. Put in something even quite generic like "sierra club hikes" and I'm number one. You'd think sierraclub.org would be number one for that. And I'm in a small town. Merry Christmas to me! D From jsWalter at torres.ws Wed Dec 10 23:19:41 2003 From: jsWalter at torres.ws (jsWalter) Date: Wed, 10 Dec 2003 23:19:41 -0600 Subject: [thelist] help with Opera 7 and attributes... In-Reply-To: <20031210214540.38469.qmail@web12606.mail.yahoo.com> Message-ID: I have this... var el = document.getElementById('myelement'); el.getAttribute('myattribute'); This is always return empty string and prints 'Warning' in the alert box. Please, enlighten me. How do I retrieve the values of custom FORM Elements in Opera? Thanks Walter From rytames at telusplanet.net Thu Dec 11 01:45:46 2003 From: rytames at telusplanet.net (Ryan Tames) Date: Wed, 10 Dec 2003 23:45:46 -0800 Subject: [thelist] OT?: Motherboard: Kobian KOB KT266a FDSX In-Reply-To: <6.0.0.22.0.20031122195524.024d1008@pop3.nildram.co.uk> References: Message-ID: <3FD7B02A.3005.5A74775@localhost> On 22 Nov 2003 at 19:57, John C Bullas wrote: I can state, in my mother board, theres this big black plastic container covering the cpu. The fan is attached to that. I never attempted to take it apart to look inside, but it does look like a cooling device. well, more like a vacuum. but if theres logic built into it, it can easily control the electronic flow of the fan attached (by monitoring the heat inside the black box). and step the fan into (for instance) one of three variable speeds. > >A recent PC Magazine article mentioned a variable-speed fan, but did > >not say is was controlled by the motherboard. It was in a > >multiple-fan box, and if the box started to get too hot, or one fan > >failed, the remaining fan(s) sped up. > > you can get these (Volcano 11 and others) that use a temperature probe > under the processor to trip the fan speed, I had never heard of one > that got a variable voltage directly off of the board via CPUFAN1 plug > these fans still need a connection off the IDE power feed as they > suggest the power drain off the board may be too high > > FB > > > >- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > >- - - Ed McCarroll > >MailTo:Ed at ComSimplicity.com ComSimplicity > > (310) 838-4330 - - - - - - - - - - - - - - - - - - - - - - - - > >- - - - - - - - - - - - - - > > > >-- > >* * Please support the community that supports you. * * > >http://evolt.org/help_support_evolt/ > > > >For unsubscribe and other options, including the Tip Harvester > >and archives of thelist go to: http://lists.evolt.org > >Workers of the Web, evolt ! > > ********************************************** > John C Bullas nildram.co.uk > ***** Eudora Mail 6.0.0.22 + McAfee Virus Scan 4.5.1 ***** > ********************************************** > > -- > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! -- Ryan Tames, CIWa - Webmaster, Multimedia, Poet, Chef, Coder, Artiste` PGP Public key: c:\finger webmaster at tames.2y.net [Adventures of a man and his Pocket DV]: http://pocketdv.tames.2y.net/ [TagaT Web Enabled Tag Board]: http://tagat.tames.2y.net/ [Ryan Tames Pro-Portfolio]: http://portfolio.tames.2y.net/ From Brian at hondaswap.com Thu Dec 11 01:12:51 2003 From: Brian at hondaswap.com (Brian Cummiskey) Date: Thu, 11 Dec 2003 02:12:51 -0500 Subject: [thelist] OT?: Motherboard: Kobian KOB KT266a FDSX In-Reply-To: <3FD7B02A.3005.5A74775@localhost> References: <3FD7B02A.3005.5A74775@localhost> Message-ID: <3FD818F3.8070501@hondaswap.com> > and step the fan into (for instance) one of three variable speeds. > http://www.newegg.com/app/Showimage.asp?image=35-106-017-01.JPG/35-106-017-02.JPG/35-106-017-03.JPG/35-106-017-05.JPG that fan supports speeds via a temp probe that goes between the cpu and the fan base itself. From junkcollect at downlowinc.com Thu Dec 11 01:11:41 2003 From: junkcollect at downlowinc.com (junkcollect at downlowinc.com) Date: Wed, 10 Dec 2003 23:11:41 -0800 Subject: [thelist] Re: GoLive Global Functions? In-Reply-To: References: Message-ID: <200312110711.hBB7Bfhp052942@cedant3.abac.com> Tony, I dont have a very technical answer but yes you need this file if you have used any of goLive's actions. If not you can do away with it but I would check to see if it has any adverse affect on the site. I ran across the same when creating a clients site and i did not upload that file. None of my rollovers worked and had me scratching my head for a min. Anyhow hope this helped ya out. also...I havent looked really close to this file but it seems to me that no matter what small portion of goLive's actions you used it seems to give you the whole lot in that js file. If you are looking to lessen the load time you could prob. pick out the js functions neccessary for your action. good luck. -Dan Tony Grimes writes: > A client of mine was going through a web directory and found a JavaScript > file titled "CSScriptLib.js" and has the following comments at the top of > the page: > > // -- Adobe GoLive JavaScript Library > // -- Global Functions > > The page essentially contains only functions. Does anyone know what GoLive > uses these for? Are they parts of canned scripts to add to web pages or are > they just needed for GoLive to function? > > I've never used the program before, but the site was originally built with > GL. Is it safe to delete this file if my client isn't using GoLive? He > doesn?t want any on-page scripts to break if this page is required (I don't > have access to the site itself, so I can't be sure if the functions are > used). > > TIA > > Tony > > From lauragais at btinternet.com Thu Dec 11 01:59:19 2003 From: lauragais at btinternet.com (Pauline Caldwell) Date: Thu, 11 Dec 2003 07:59:19 +0000 Subject: [thelist] Re: GoLive Global Functions? In-Reply-To: <200312110711.hBB7Bfhp052942@cedant3.abac.com> Message-ID: >> A client of mine was going through a web directory and found a JavaScript >> file titled "CSScriptLib.js" and has the following comments at the top of >> the page: >> >> // -- Adobe GoLive JavaScript Library >> // -- Global Functions >> >> The page essentially contains only functions. Does anyone know what GoLive >> uses these for? Are they parts of canned scripts to add to web pages or are >> they just needed for GoLive to function? >> >> I've never used the program before, but the site was originally built with >> GL. Is it safe to delete this file if my client isn't using GoLive? He >> doesn1t want any on-page scripts to break if this page is required (I don't >> have access to the site itself, so I can't be sure if the functions are >> used). The file needs to be uploaded with the site. It?s GoLive?s complete global javascripts file, and it should have been ?flattened? when the site was uploaded. In GL, flattening that file removes all the scripts that aren?t used in the site - you only upload what?s actually used. It sounds like the original designer didn?t do that - it should have been done. Pauline ______________ Pauline?s Views of France: http://www.pauline-caldwell.com/france/ From jcbullas at nildram.co.uk Thu Dec 11 02:05:11 2003 From: jcbullas at nildram.co.uk (John C Bullas) Date: Thu, 11 Dec 2003 08:05:11 +0000 Subject: [thelist] OT?: Motherboard: Kobian KOB KT266a FDSX In-Reply-To: <3FD7B02A.3005.5A74775@localhost> References: <3FD7B02A.3005.5A74775@localhost> Message-ID: <6.0.1.1.0.20031211080328.0245cd38@pop3.nildram.co.uk> At 07:45 11/12/2003, Ryan Tames wrote >On 22 Nov 2003 at 19:57, John C Bullas wrote: > >I can state, in my mother board, theres this big black >plastic container covering the cpu. The fan is attached to that. AFAIK there is not a plug on the motherboard that will provide a controlled temperature related voltage output to the CPU fan to make it run faster/slower depending on temperature YOUR M/B may have been fitted with a fan that has a temperature sensor under the heatsink sitting on the CPU John >I never attempted to take it apart to look inside, >but it does look like a cooling device. well, more like a vacuum. >but if theres logic built into it, it can easily control the electronic >flow of the fan attached (by monitoring the heat inside the black box). > >and step the fan into (for instance) one of three variable speeds. From mark at mark.ac Thu Dec 11 02:16:44 2003 From: mark at mark.ac (Mark Howells) Date: Thu, 11 Dec 2003 09:16:44 +0100 Subject: [thelist] HMTL Email In-Reply-To: <84AAAA6A-2B5F-11D8-B755-0003938911D8@calteg.org> References: <84AAAA6A-2B5F-11D8-B755-0003938911D8@calteg.org> Message-ID: <5B601E00-2BB2-11D8-AA75-000393143F96@mark.ac> >> Yes, that old arguing point again. It's essential that I apply some >> kind of formatting to an HTML email - text colour and margins, mainly >> - and I can't get it to respond to CSS, whether it's inline (on a >> span) or in the head of the email. Works fine in Apple Mail, but >> Entourage and Outlook Express - both Mac - ignore it. Thanks for the response. I spent the better part of yesterday evening reading and testing; it seems that these mail clients accept CSS formatting defined in the head of a standard HTML template, but it only kicks in with "full HTML" layout when it encounters a non-textual HTML element, such as a table or image tag. If you only work with headings and paragraphs, the mail client decides that it doesn't need to render in full HTML and thus doesn't bother parsing the CSS. Ironically, font tags work just fine either way :-( Regards Mark Howells http://www.mark.ac/ From eugaia at hotmail.com Thu Dec 11 02:32:49 2003 From: eugaia at hotmail.com (Eugaia) Date: Thu, 11 Dec 2003 08:32:49 -0000 Subject: [thelist] Setting up a search engine in Perl, CGI or PHP and MySQL Message-ID: Sorry about the length of this email, but I'm trying to be clear about my needs so that I can get the answer questions on a specific need. I am trying to set up a site that is a different type of search engine. Instead of a top-down approach of redirecting users to other websites based on conventional search criteria, I'm looking at actually cataloguing the pages of different websites, and structuring them in a directory format (a bit like the Open Directory Project, but using computers rather than people for most of the cataloguing process), which is essentially a bottom-up approach. Basically, items will be catalogued by having direct access to data on other people's servers, and by various scripts/algorithms. Initially I will be organising information on commercial sites with affiliate programs, so they should allow direct (albeit restricted) access to their databases. For each site included in our catalogue, I will need to know information about what I'm cataloguing. For example, if I am cataloguing a poster of the Mona Lisa from AllPosers.com, I will need to store information such as the artist, price of the poster, what artistic style it is etc, so that a user on my site could get it it via a section on posters, or on Renaissance art, or on Leonardo Da Vinci etc.. I will also want to make sure that posters from other online stores are correctly placed with the one from AllPoster.com when a request for posters of the Mona Lisa is placed by a user of the site - I don't want the search to do a search of posters with the name Mona Lisa as such, I want it to have already been catalogued. This means that accurate price comparisons on any item could be made. As I see it, there will need to be three scripts/algorithms. The first will extract the relevant information from a site that is to be catalogued, and return various information that will then be put into the database (This will probably be different for different sites, though some sites will have similar scripts, and generic scripts will be written for this process). These will then pass on their results to a second algorithm. The second algorithm will then input the relevant data in the database, including such things as URLs, image locations, various site structure information (such as how the information could be reached through the directory structure). Comparisons will be made with items already catalogued, so that the same item from different stores can be correctly placed together (this may require some human checking as well, though hopefully not much). The third script is the search engine itself. This will not just return a page like a conventional search engine, but might redirect a user to an individual page if there is a very high chance that that is the page a user wanted (e.g. if David Blane was entered, then the user would be redirected to .../david_blane.html). If there are several different possible results, such as a search for pool might yeild results relating to a swimming pool, but also for the game. All results related to the former could be found through links on a page called swimming_pool.html, and the latter on pool.html. These two possibilities would be listed on one page, along with some of their sub-categories underneath the main headings, and any other possible derivations of the word pool. My question is this: Is MySQL suitable for such a task (my gut instinct is yes)? And more importantly, what language should I use for the search engine script? Obviously, being a search engine, it needs to be quick at retreiving results from a database. I am intending on having the rest of the site in PHP (Linux/Apache/MySQL/PHP/Turck MMCache is my current idea for the setup) - Turck MMCache speeds up PHP processing by caching compiled scripts. I'm thinking that Perl might be quicker to have as a search engine script, but I just don't know. What about CGI? Is there anyone with experience of writing search engines that can make some suggestions? Considering that there will potentially be results catalogued for anything you could think of, how should I structure the tablespace of the search engine part of the database? This tablespace could potentially reach terabytes in size. Should I have just one table with all the possible results, or would it be more efficient to somehow split up the results into multiple tables? If so, are there any suggestions for how I should split up the tables? One possibility that I've thought of is to have one table for each search result (so potentially tens of millions of tables), with a list of all the tables being kept in the data-definition of the database? Each table could then contain data about what should be shown for each page, including the links to other pages. If a search did not result in an actual page that had already been structured, then suggested results pages could be made for pages with similar names. Also, would Perl, CGI or PHP (or something else) be better for the other two algorithms/scripts, which will input data into the database? Any responses to these questions will be gratefully received. Thanks in advance. Thanks, Marcus. From gassinaumasis at hotmail.com Thu Dec 11 03:34:13 2003 From: gassinaumasis at hotmail.com (Peter-Paul Koch) Date: Thu, 11 Dec 2003 09:34:13 +0000 Subject: [thelist] help with Opera 7 and attributes... Message-ID: >I have this... > > var el = document.getElementById('myelement'); > el.getAttribute('myattribute'); > >This is always return empty string and prints 'Warning' in the alert box. > >Please, enlighten me. > >How do I retrieve the values of custom FORM Elements in Opera? Odd. This should work. The one thing you cannot do in Opera, though, is using existing attributes on the wrong elements, like