From joe at artlung.com Mon Dec 18 02:56:34 2000 From: joe at artlung.com (Joe Crawford) Date: Mon Dec 18 02:56:34 2000 Subject: [thelist] Style Sheets, Hacks, Browsers References: Message-ID: <3A3DD18F.2ED66A99@artlung.com> Kyle Smeby wrote: > > Did you try: ? That seems to > > me a longer term, less hackish, less potentially troublesome solution than > > fake script tags. I mean, IE5.5 could ignore the It doesn't even come close to working...and I'm getting upset! Now, even the variable creation doesn't work! I'm gettign an error on that line that says 'movie' is null or not an object. I'd really appreciate some help with this. The SetVariable method I'm trying to use comes from the MM reference at http://macromedia.com/support/flash/publishexport/scriptingwithflash_03.html thanks, john From Rudy_Limeback at maritimelife.ca Tue Dec 19 15:47:50 2000 From: Rudy_Limeback at maritimelife.ca (rudy) Date: Tue Dec 19 15:47:50 2000 Subject: [thelist] Hello Message-ID: >>>Watch out for the sharks, they might be helpful dolphins >>I am not! >That's just what a shark would say! folks, don't forget a (tm) with your, um, low signal-to-noise posts... in sql/server you can copy a table with select * into newTable from oldTable you don't have to pre-define newTable, but i think you have to enable the bulkcopy option (sgd, please confirm, you know i aint a dba) you can also always do it the straight-forward way by first issuing the CREATE TABLE statement for newTable, and then using insert into newTable select * from oldTable but this will involve row-by-row logging > (Don't Bother Nothing There) hi jonathan that's a hoot, can i steal that? i have a site just like that ;o) rudy.ca (don't bother nothing there) From jsp at designframe.com Tue Dec 19 15:51:09 2000 From: jsp at designframe.com (James Spahr) Date: Tue Dec 19 15:51:09 2000 Subject: [thelist] SQL question In-Reply-To: <006401c069ef$ea4ba4a0$8ce41d18@ce.mediaone.net> Message-ID: How can I (safely) set a table column to be a unique id number? I'd just like to set all the columns that satisfy this WHERE clause to be one more than the MAX value of the column. Like so: UPDATE sample SET status='CONFIRMING', orderid=MAX(orderid)+1 WHERE customerid='2' AND orderid='-1'; MySQL gives me 'ERROR 1111: Invalid use of group function'. I assume I can't use MAX(orderid)+1 in this context, but I don't want to do this in 2 sql statements, because I just might (however small the chance) get same same orderid on 2+ orders ... (pending orders always have a orderid of '-1') make sense? James. From atdtxav at yahoo.com Tue Dec 19 16:06:15 2000 From: atdtxav at yahoo.com (AtdtXav) Date: Tue Dec 19 16:06:15 2000 Subject: [thelist] IE "friendly" errors (Evolt problem) Message-ID: <20001219204006.9908.qmail@web6403.mail.yahoo.com> Not a clue, honestly. By all rights IE should only show an error message when you'd -normally- have an error message anyway. As far as how many others leave the default settings.... the vast majority of IE users will leave the default setting. In fact, the only people who would change that particular setting are webfolk like us who want to see the exact error message without MS's sugar-coating. Scott --- Michele Foster wrote: > I just discovered this. What a very odd message though. Any > idea why a > default setting like this would create such a problem? All is > fine on my > end now, but I wonder how many others leave the default > settings? > > Michele > > ----- Original Message ----- > From: "AtdtXav" > To: > Sent: Friday, December 15, 2000 7:13 PM > Subject: Re: [thelist] IE "friendly" errors (Evolt problem) > > > > Go to advanced under Internet Options, UNCHECK "show > friendly > > HTTP error messages" that'll do ya. > > > > Scott > > ===== Xavier - Scott -- http://spork.ofdoom.com ------------------------------- __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ From sgd at ti3.com Tue Dec 19 16:08:46 2000 From: sgd at ti3.com (Scott Dexter) Date: Tue Dec 19 16:08:46 2000 Subject: sql tip (was: RE: [thelist] Hello) Message-ID: <8C8B8745C0FE7A43BFA6CABAB321117223F938@gate.ti3.com> > in sql/server you can copy a table with > select * > into newTable > from oldTable > you don't have to pre-define newTable, but i think you have > to enable the > bulkcopy option (sgd, please confirm, you know i aint a dba) yes, you have to enable the bulk copy option (in MS SQL Server, the option is labelled "Select Into/Bulk Copy" to help you remember) because the Select Into statement is not logged.... sgd From amanda at gawow.com Tue Dec 19 16:18:19 2000 From: amanda at gawow.com (A. Erickson) Date: Tue Dec 19 16:18:19 2000 Subject: [thelist] Hello In-Reply-To: Message-ID: Damn! You guys caught me. Sorry to raise your ire. I recently got a book entitled How to Design Logos, Symbols and Icons by Gregory Thomas. It came out this year and has about 30 current logos designed by some top firms. There is a few pages on each one about their process and strategy for coming up with what they did. They even show some preliminary sketches that didn't make the final cut. I'm really enjoying it. So much better than a design annual which gives you no context. - amanda > -----Original Message----- > From: thelist-admin at lists.evolt.org > [mailto:thelist-admin at lists.evolt.org]On Behalf Of rudy > Sent: Tuesday, December 19, 2000 11:41 AM > To: thelist at lists.evolt.org > Subject: Re: [thelist] Hello > > > >>>Watch out for the sharks, they might be helpful dolphins > >>I am not! > >That's just what a shark would say! > > folks, don't forget a (tm) with your, um, low signal-to-noise > posts... > > > in sql/server you can copy a table with > select * > into newTable > from oldTable > you don't have to pre-define newTable, but i think you have to enable the > bulkcopy option (sgd, please confirm, you know i aint a dba) > you can also always do it the straight-forward way by first issuing the > CREATE TABLE statement for newTable, and then using > insert into newTable > select * from oldTable > but this will involve row-by-row logging > > > > > (Don't Bother Nothing There) > > hi jonathan > > that's a hoot, can i steal that? i have a site just like that ;o) > > > rudy.ca (don't bother nothing there) > > --------------------------------------- > For unsubscribe and other options, including > the Tip Harvester and archive of TheList go to: > http://lists.evolt.org Workers of the Web, evolt ! > From bread_man at hotmail.com Tue Dec 19 16:57:51 2000 From: bread_man at hotmail.com (Adam Slesinger) Date: Tue Dec 19 16:57:51 2000 Subject: [thelist] javascript with Flash Message-ID: John, I can't help you with your poblem - but the users at flashkit.com should be able to. Just sign up for their forums, post in the appropriate forum, and you'll get your answer soon, i'm sure. They've helped me with many flash questions, complicated and simple. adam >From: "John Corry" >Reply-To: thelist at lists.evolt.org >To: >Subject: [thelist] javascript with Flash >Date: Tue, 19 Dec 2000 10:12:32 -1000 > >At wits end...I have to ask again... > >I'm trying to use javascript to set a variable that flash can use... > >here's what I've got: > > > > >It doesn't even come close to working...and I'm getting upset! Now, even >the >variable creation doesn't work! I'm gettign an error on that line that says >'movie' is null or not an object. > >I'd really appreciate some help with this. The SetVariable method I'm >trying >to use comes from the MM reference at >http://macromedia.com/support/flash/publishexport/scriptingwithflash_03.html > >thanks, >john > > >--------------------------------------- >For unsubscribe and other options, including >the Tip Harvester and archive of TheList go to: >http://lists.evolt.org Workers of the Web, evolt ! _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com From jaylard at equilon.com Tue Dec 19 17:05:16 2000 From: jaylard at equilon.com (Aylard JA (James)) Date: Tue Dec 19 17:05:16 2000 Subject: [thelist] NS 6 Event list? Message-ID: <8B8252E8924BD31193D800805FE63E6D0104CD6F@mzrmsx02.newcos.com> Seth, > Can anyone point me in the direction of where to get a listing or overview > of some sort for the NS 6 event handling stuff? Unfortunately, AFAIK Netscape has yet to put out any first-hand documentation for Netscape 6, apparently freed from such a chore by the notion that the browser is standards-compliant so all you need to do is read the standards. While this is mostly true for some standards (e.g., HTML 4, CSS 1), it is only partly true for others (e.g., CSS 2), meaning that it is essentially the job of the developer -- with some help from third-party author-developers when you can find it -- to figure out exactly what Netscape 6 can and cannot do. Netscape's developer site (http://developer.netscape.com/) offers links to various forums that may or may not provide helpful information -- most of it simply links to third-party articles and white papers. Unfortunately, developer.netscape.com itself is layered :) in the increasingly thick dust of neglect. For example, one page touts the release of Netscape 6 PR 2 -- and another the release of Gecko M8(!!!). (These are top-level headlines, not archived links, btw.) Your best bet might be to start at http://developer.netscape.com/tech/index.html?cp=dev01ttec and just feel your way around. I suppose an enterprising individual could sift through Mozilla's Bugzilla site (http://bugzilla.mozilla.org/) to find postings on what has and has not been implemented, but this would be quite a task. Personally, I am amazed that the development community tolerates this so quiescently -- where's that WaSP bunch when you need 'em?? :) James Aylard From seth at subimage.com Tue Dec 19 17:16:32 2000 From: seth at subimage.com (Seth Banks) Date: Tue Dec 19 17:16:32 2000 Subject: [thelist] NS 6 Event list? In-Reply-To: <8B8252E8924BD31193D800805FE63E6D0104CD6F@mzrmsx02.newcos.com> Message-ID: Yeah, after searching most of the afternoon I came up with pointers to the w3c, then an excellent link @ http://www.scottandrew.com/index.php?dom/events.html Anyone ever try to read the w3c documentation? Ugh. Very bland and non-descriptive. At least I found what I was looking for! - seth :) -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Aylard JA (James) Sent: Tuesday, December 19, 2000 1:41 PM To: 'thelist at lists.evolt.org' Subject: RE: [thelist] NS 6 Event list? Seth, > Can anyone point me in the direction of where to get a listing or overview > of some sort for the NS 6 event handling stuff? Unfortunately, AFAIK Netscape has yet to put out any first-hand documentation for Netscape 6, apparently freed from such a chore by the notion that the browser is standards-compliant so all you need to do is read the standards. While this is mostly true for some standards (e.g., HTML 4, CSS 1), it is only partly true for others (e.g., CSS 2), meaning that it is essentially the job of the developer -- with some help from third-party author-developers when you can find it -- to figure out exactly what Netscape 6 can and cannot do. Netscape's developer site (http://developer.netscape.com/) offers links to various forums that may or may not provide helpful information -- most of it simply links to third-party articles and white papers. Unfortunately, developer.netscape.com itself is layered :) in the increasingly thick dust of neglect. For example, one page touts the release of Netscape 6 PR 2 -- and another the release of Gecko M8(!!!). (These are top-level headlines, not archived links, btw.) Your best bet might be to start at http://developer.netscape.com/tech/index.html?cp=dev01ttec and just feel your way around. I suppose an enterprising individual could sift through Mozilla's Bugzilla site (http://bugzilla.mozilla.org/) to find postings on what has and has not been implemented, but this would be quite a task. Personally, I am amazed that the development community tolerates this so quiescently -- where's that WaSP bunch when you need 'em?? :) James Aylard --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt ! From monique_gros at hotmail.com Tue Dec 19 17:22:54 2000 From: monique_gros at hotmail.com (Monique Gros) Date: Tue Dec 19 17:22:54 2000 Subject: [thelist] JavaScript with Apache Server Message-ID: A friend of mine is having a problem and I thought someone might be able to help. Here's the problem: Do you by any chance know anything about JavaScript and the Apache Web Server. I am trying to create a shared code file in JS on the server There are several funcitons I have written that I would like to use in several web pages. ie: is_num, is_empty... These functions will determine if a string is either empty or if it contains only numbers. I am using these to help in form validations. Rather than have copies in each html file I would like to have one 'utils.js' file on the server. This file would be included by the following: But I keep gettingthe following error: [Tue Dec 19 13:15:16 2000] [error] (8)Exec format error: exec of /var/apache/cgi-bin/utils.js failed [Tue Dec 19 13:15:16 2000] [error] [client 10.50.1.34] Premature end of script headers:/var/apache/cgi-bin/utils.js Any ideas? ~monique _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com From Rudy_Limeback at maritimelife.ca Tue Dec 19 17:30:24 2000 From: Rudy_Limeback at maritimelife.ca (rudy) Date: Tue Dec 19 17:30:24 2000 Subject: [thelist] SQL question Message-ID: > UPDATE sample > SET status='CONFIRMING' > , orderid=MAX(orderid)+1 > WHERE customerid='2' > AND orderid='-1'; > > MySQL gives me 'ERROR 1111: Invalid use of group function'. > I assume I can't use MAX(orderid)+1 in this context, hi james yes, that's right, you can't actually it would ordinarily be possible, but it requires a subquery, which mysql cannot handle, so i'm told (other databases are fine) but you don't want to do it that way anyway ;o) > but I don't want to do this in 2 sql statements, > because I just might (however small the chance) > get same same orderid on 2+ orders ... good call -- you don't want to update more than one row with what's supposed to be a unique number however, regarding taking more than one step, if you're trying to fix your database, like a one-time fix, then efficiency doesn't matter, so the easiest way to do it would be in a script like this -- begin loop find a row with the problem fix the problem on that row end loop the first step is easy, you apparently have a bunch of rows with orderid=-1, however, whether *the rows* are all unique is the question also, i am a bit confused by your statement "pending orders always have a orderid of '-1'" -- is that the way it has to stay or would you like to assign all these a new unique id? i'm going to assume you will assign unique numbers from now on... anyhow, the tricky part is finding "a" row, because the second step, to fix each row, requires that you can identify that row by some combination of values of columns for example, suppose you had the following table id name 12 mary 13 beth 14 sue -1 fred -1 bob -1 billy joe the only thing to watch for is duplicate names -- like i said, you have to be able to identify each row uniquely in order to fix it, and if you don't have enough columns, you are s.o.l. and you have to dump the table and fix it manually in the above example, assuming the names are unique, your loop would look something like this -- select max(orderid) as highest from yourtable begin loop highest = highest + 1 select min(name) as thisname from yourtable where orderid=-1 update yourtable set orderid = highest where name = thisname end loop (not shown is "no results" testing inside the loop to know when you're done) does this help? rudy From seth at subimage.com Tue Dec 19 17:35:04 2000 From: seth at subimage.com (Seth Banks) Date: Tue Dec 19 17:35:04 2000 Subject: [thelist] JavaScript with Apache Server In-Reply-To: Message-ID: the best way to share javascript across multiple html pages is like this... in the tag of your documents in which you want to use the js file, include a line that says But I keep gettingthe following error: [Tue Dec 19 13:15:16 2000] [error] (8)Exec format error: exec of /var/apache/cgi-bin/utils.js failed [Tue Dec 19 13:15:16 2000] [error] [client 10.50.1.34] Premature end of script headers:/var/apache/cgi-bin/utils.js Any ideas? ~monique _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt ! From framar at interlog.com Tue Dec 19 17:39:40 2000 From: framar at interlog.com (Frank) Date: Tue Dec 19 17:39:40 2000 Subject: [thelist] Hello + Penance...er.. tip. In-Reply-To: References: Message-ID: > folks, don't forget a (tm) with your, um, low > signal-to-noise posts... Yes daddy... So you can search your database, and you've created a simple search engine that hits on keywords using SQL. You CAN search your database using the Verity engine. Verity itself will not search a database, but it will search an SQL query. Neat idea, huh? Which do I use? Verity, or SQL? Verity is best at handling large chunks of unstructured text (like a news article). It automatically handles stemming (love, loved, loves, loving, lover) and is best at handling 'natural language' ('Who loves me?') type queries. SQL is best of finding precise matches in very structured information (like prices). Verity can, however give you somewhat mushy results. Why not search the return of your verity query with SQL? The Pro side: Very accurate results with good control over your data. The Con side: You lose relevance ranking, and must resort to using ORDER BY. So you're using the Verity engine to search your big note fields. What happens if the collection isn't there, or gets destroyed? Why not back it up with an SQL search? By using and you can make it so that if there verity search chokes, that there's a redundant search mechnism that takes only minutes to implement. If you're using , make it so that your app mails you about the error. In the mean time, your client and the user were served, and you don't have to get up at 4 am to deal with it. Redundancy often pays off, and is cheap to implement. -- Frank Marion Loofah Communications frank at loofahcom.com http://www.loofahcom.com From sebastien at oven.com Tue Dec 19 17:40:04 2000 From: sebastien at oven.com (Seb Barre) Date: Tue Dec 19 17:40:04 2000 Subject: [thelist] JavaScript with Apache Server In-Reply-To: Message-ID: <5.0.2.1.0.20001219170748.026098e0@pop.oven.com> At 03:43 PM 12/19/2000 -0600, you wrote: >A friend of mine is having a problem and I thought someone might be able >to help. > >Here's the problem: > >Do you by any chance know anything about JavaScript >and the Apache Web Server. I am trying to create a >shared code file in JS on the server > >There are several funcitons I have written that I would like to >use in several web pages. ie: is_num, is_empty... >These functions will determine if a string is either >empty or if it contains only numbers. I am using >these to help in form validations. Rather than have >copies in each html file I would like to have one >'utils.js' file on the server. >This file would be included by the following: > > Javascript is client-side scripting, not server-side, so the file can't be located in your CGI-BIN directory. Put it somewhere in your regular static document path and reference that URL instead. If you load a file from the cgi directory, the webserver will try to execute it server side and return the output to the browser (which will fail in this case). HTH --- -- - Seb Barre - seb at oven.com OVEN Digital Toronto Work: 416-595-9750 x 222 Mobile: 416-254-5078 http://www.oven.com/ From Ron.Luther at COMPAQ.com Tue Dec 19 17:55:04 2000 From: Ron.Luther at COMPAQ.com (Luther, Ron) Date: Tue Dec 19 17:55:04 2000 Subject: [thelist] SQL - Correlated Subquery?? Message-ID: <8958135993102D479F1CA2351F370A060C169A@cceexc17.americas.cpqcorp.net> Hi Gang, I have a table with (at least) three columns; Region - North America, Europe, Asia Process completion date - (completed program #6 at) 12/17/00 3:45:00am Data "as of" date - (data for) 12/16/00 12:00:00am (The table has - oh - let's say 300,000 records in it. It is a "processing history" table.) What I'd really really like is to return 3 records - one showing me the maximum "as of' date for each region. This should be easy, I'm hanging my head, I'm just not getting it! TIA, Ron L. From phil at presence-multimedia.co.uk Tue Dec 19 17:56:41 2000 From: phil at presence-multimedia.co.uk (Philip Lindsay) Date: Tue Dec 19 17:56:41 2000 Subject: [thelist] how the mighty have fallen In-Reply-To: <5.0.2.1.0.20001219085622.00a0d4d0@email.up.edu> Message-ID: on 19/12/00 5:12 pm, Erika Meyer at meyer at up.edu wrote: > EToys: ding dong the witch is dead. > > boo.com: > For all the money they blasted through, > they couldn't build a web site that worked. > UK ISP breathe.com looks in a bad way also, seeking a buyer with debts of ?50m odd. http://www.mediaguardian.co.uk/newmedia/story/0,7496,412828,00.html The debts racked up from a v.expensive advertising campaign, which although very impressive, left many viewers wondering what breathe actually did.... Also backed out of a deal offering unlimited web access to customers paying a ?50 one-off fee, who have since lost their money... oh dear... ---- Phil From joshua at alphashop.net Tue Dec 19 18:13:31 2000 From: joshua at alphashop.net (Joshua OIson) Date: Tue Dec 19 18:13:31 2000 Subject: [thelist] SQL - Correlated Subquery?? References: <8958135993102D479F1CA2351F370A060C169A@cceexc17.americas.cpqcorp.net> Message-ID: <02b001c06a27$6cfaabd0$0200a8c0@agusta1.ga.home> something like this might work: SELECT DISTINCT b.region, (SELECT Max(as_of_date) FROM mytable a WHERE a.region = b.region) as max_as_of_date FROM mytable b Basically, the "distinct" keyword ensures that you get one row per region, and the subselect calculates the maximum date, given a constraint that your only looking within a particular region. -joshua ----- Original Message ----- From: "Luther, Ron" To: Sent: Tuesday, December 19, 2000 2:29 PM Subject: [thelist] SQL - Correlated Subquery?? > Hi Gang, > > > I have a table with (at least) three columns; > > Region - North America, Europe, Asia > > Process completion date - (completed program #6 at) 12/17/00 3:45:00am > > Data "as of" date - (data for) 12/16/00 12:00:00am > > (The table has - oh - let's say 300,000 records in it. It is a "processing > history" table.) > > > > What I'd really really like is to return 3 records - one showing me the > maximum "as of' date for each region. > > This should be easy, I'm hanging my head, I'm just not getting it! > > > > TIA, > > Ron L. > > > --------------------------------------- > For unsubscribe and other options, including > the Tip Harvester and archive of TheList go to: > http://lists.evolt.org Workers of the Web, evolt ! From Ron.Luther at COMPAQ.com Tue Dec 19 18:19:50 2000 From: Ron.Luther at COMPAQ.com (Luther, Ron) Date: Tue Dec 19 18:19:50 2000 Subject: [thelist] SQL - Correlated Subquery?? Message-ID: <8958135993102D479F1CA2351F370A060C169B@cceexc17.americas.cpqcorp.net> Thanks Joshua, I will give it a whirl ... but I'm not sure the tool I'm using (Brio) will allow me to use the 'distict' keyword in the select list ... so I'll try to make some changes as appropriate! Thanks! Ron L. -----Original Message----- From: Joshua OIson [mailto:joshua at alphashop.net] Sent: Tuesday, December 19, 2000 7:52 PM To: thelist at lists.evolt.org Subject: Re: [thelist] SQL - Correlated Subquery?? something like this might work: SELECT DISTINCT b.region, (SELECT Max(as_of_date) FROM mytable a WHERE a.region = b.region) as max_as_of_date FROM mytable b Basically, the "distinct" keyword ensures that you get one row per region, and the subselect calculates the maximum date, given a constraint that your only looking within a particular region. -joshua ----- Original Message ----- From: "Luther, Ron" To: Sent: Tuesday, December 19, 2000 2:29 PM Subject: [thelist] SQL - Correlated Subquery?? > Hi Gang, > > > I have a table with (at least) three columns; > > Region - North America, Europe, Asia > > Process completion date - (completed program #6 at) 12/17/00 3:45:00am > > Data "as of" date - (data for) 12/16/00 12:00:00am > > (The table has - oh - let's say 300,000 records in it. It is a "processing > history" table.) > > > > What I'd really really like is to return 3 records - one showing me the > maximum "as of' date for each region. > > This should be easy, I'm hanging my head, I'm just not getting it! > > > > TIA, > > Ron L. > > > --------------------------------------- > For unsubscribe and other options, including > the Tip Harvester and archive of TheList go to: > http://lists.evolt.org Workers of the Web, evolt ! --------------------------------------- For unsubscribe and other options, including the Tip Harvester and archive of TheList go to: http://lists.evolt.org Workers of the Web, evolt ! From jayfitz at bayou.com Tue Dec 19 18:23:49 2000 From: jayfitz at bayou.com (Jay Fitzgerald) Date: Tue Dec 19 18:23:49 2000 Subject: [thelist] mySQL Sequencing Message-ID: <3A3FE79C.F9C418AC@bayou.com> Does anyone know of a way to "sequence" items listed in a mySQL db? Specifically to where when a client makes an addition to their db, the form will also allow them to set the order/position that the item would appear online....or is there a way to code this type of feature into our PHP document? Couldn't we do something of this sort using the id? -- Jay Fitzgerald - Web Development/Sales ============================================= Bayou Internet http://www.bayou.com Mississippi Internet http://www.mississippi.net Vicksburg Online http://www.vicksburg.com Bama Online http://www.bamaonline.net ============================================= ICQ: 38823829 Phone: 888-302-2968 Fax: 877-329-2296 From jdowdell at macromedia.com Tue Dec 19 18:30:17 2000 From: jdowdell at macromedia.com (John Dowdell) Date: Tue Dec 19 18:30:17 2000 Subject: [thelist] javascript with Flash Message-ID: If you're trying to have JavaScript tell an object in the page a user-determined value, then you've got a series of browser differences to overcome: -- Not all browsers let scripts talk to objects -- Different browsers have different ways of finding objects in the page -- You need to send the object a message it can understand, at a time it can understand it In your example, triggering the communication in the body.onLoad will almost always fail, because the page loads before the objects on the page get a chance to load. If you know the value when the page is written, then there are easier and more universal ways to talk with at least some objects in the page... here's an overview: "Different approaches to setting variables in a Flash movie" http://www.macromedia.com/go/14253 In other situations, where you don't know the values when the page is created but are relying on user choices when the page is displayed, then it's easier to put all the interactivity in the SWF file itself. This lets you avoid all the browser differences. jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ From oliver at lineham.co.nz Tue Dec 19 18:35:30 2000 From: oliver at lineham.co.nz (Oliver Lineham) Date: Tue Dec 19 18:35:30 2000 Subject: [thelist] SQL - Correlated Subquery?? In-Reply-To: <8958135993102D479F1CA2351F370A060C169A@cceexc17.americas.c pqcorp.net> Message-ID: <4.2.0.58.20001220120133.01c489c0@mail.paradise.net.nz> At 16:29 19/12/2000 -0600, you wrote: >I have a table with (at least) three columns; > >Region - North America, Europe, Asia > >Process completion date - (completed program #6 at) 12/17/00 3:45:00am > >Data "as of" date - (data for) 12/16/00 12:00:00am > >What I'd really really like is to return 3 records - one showing me the >maximum "as of' date for each region. > >This should be easy, I'm hanging my head, I'm just not getting it! i might be misunderstanding your problem, but surely this would work: SELECT thetable.region MAX(thetable.asofdate) AS maxasof FROM thetable GROUP BY thetable.region the group by clause should mean you get one row per region and, should make the MAX() find the maximum asofdate from that region. let me know if this works :) i haven't seen the post you were replying to (it hasn't come in yet for me), but i assume they were suggested a nested SELECT statement. these are usually less efficient, so if you can find another way - use it. ____________________________________________________ v i b e m e d i a http://www.vibe.co.nz/ po box 10-492 wellington, new zealand phone +64 21 210-7845 oliver at lineham.co.nz From webshot at neoncowboy.com Tue Dec 19 19:38:27 2000 From: webshot at neoncowboy.com (John Corry) Date: Tue Dec 19 19:38:27 2000 Subject: [thelist] javascript with Flash In-Reply-To: Message-ID: >-- Not all browsers let scripts talk to objects > in this case, as highly inflammatory as I know it is...as long as nav/IE 4+ browsers on windows supports it, I'm golden. >-- Different browsers have different ways of finding objects in the page > So...some logic to rewrite the variabel set function based on browser appname/appversion might be necessary? >-- You need to send the object a message it can understand, at a time it >can understand it > >In your example, triggering the communication in the body.onLoad will >almost always fail, because the page loads before the objects on the page >get a chance to load. Got it...a better idea would be to send the function call via FScommand from the first frame of the movie...right? I know the value of the variable when the page is rendered. I have this script on my page: and this AS On the first frame of the movie.. fscommand ("set"); I'm desperately trying to 'get it' and it still sin't working...and I don't have anyone else I can ask. thanks, John Corry PS - JD, are you interested in a teaching gig? If so, email me offlist From miinx at miinx.com.au Tue Dec 19 19:55:44 2000 From: miinx at miinx.com.au (miinx) Date: Tue Dec 19 19:55:44 2000 Subject: [thelist] how the mighty have fallen References: Message-ID: <3A3FFC69.5277C873@miinx.com.au> Philip Lindsay wrote: > UK ISP breathe.com looks in a bad way also, seeking a buyer with debts of > ?50m odd. but surely that will only make the situation worse... ;-) Karen -- http://www.miinx.com.au/ http://www.monkey.com.au/ From webguru at vsnl.net Wed Dec 20 00:22:39 2000 From: webguru at vsnl.net (Madhu Menon) Date: Wed Dec 20 00:22:39 2000 Subject: [thelist] OT: Programmer's night before Christmas In-Reply-To: <20001219222856.B0F7E3F367@relay.evolt.org> Message-ID: <5.0.2.1.2.20001220101801.00b06a08@mail.vsnl.net> This is a programmer's version of the Christmas story: PROGRAMMER"S NIGHT BEFORE CHRISTMAS 'Twas the night before implementation and all through the house, not a program was working not even a browse. The programmers hung by their tubes in despair, with hopes that a miracle would soon be there. The users were nestled all snug in their beds, while visions of inquiries danced in their heads. When out in the machine room there arose such a clatter, I sprang from my desk to see what was the matter. And what to my wondering eyes should appear, but a super programmer (with a six-pack of beer). His resume glowed with experience so rare, he turned out great code with a bit-pusher's flair. More rapid than eagles, his programs they came, On update! on add! on inquiry! on delete! on batch jobs! on closing! on functions complete! His eyes were glazed-over, fingers nimble and lean, from weekends and nights in front of a screen. A wink of his eye, and a twitch of his head, soon gave me to know I had nothing to dread. He spoke not a word, but went straight to his work, turning specs into code; then turned with a jerk; And laying his finger upon the "ENTER" key, the systems came up and worked perfectly. The updates updated; the deletes, they deleted; the inquiries inquired, and closings completed. He tested each whistle, and tested each bell, with nary an abend, and all had gone well. The system was finished, the tests were concluded. The users' last changes were even included. And the user exclaimed with a snarl and a taunt, "It's just what I asked for, but not what I want!" And for that hopelessly off-topic post, I definitely owe a tip... (unlike some of the other OT posts ;) Users hate to fill out long forms that require them to divulge everything from their annual income to their dog's name. If a person feels, "Damn! It's going to take me 15 minutes to fill all this crap up", they're not going to bother. Keep registration forms short, especially for things like subscriptions to email newsletters (you really only need the email address here). But the sales guy yells, "we need our demographic data!" :) He has a point. But if you really need to get all that info, make it optional *after* registering and offer a carrot of a lucky t-shirt, mug, whatever. Make it worth the user's while to fill up all the fields. But don't make it compulsory. Lastly, don't ever expect people to fill in their salary honestly. It just isn't going to happen. Try to provide salary ranges instead. That has a better chance of being more accurate Cheers, Madhu <<< * >>> Madhu Menon Manager - User Experience Trisoft Systems Pvt. Ltd. Work: http://www.trisoft.net Personal: http://madman.weblogs.com From phil at presence-multimedia.co.uk Wed Dec 20 04:58:55 2000 From: phil at presence-multimedia.co.uk (Philip Lindsay) Date: Wed Dec 20 04:58:55 2000 Subject: [thelist] Flash 4 Tutorials (PC) In-Reply-To: <20001218190105.MLSQ9078.mta07.onebox.com@onebox.com> Message-ID: to get going a good place to start might be the Flash tutorials on Webmonkey - http://hotwired.lycos.com/webmonkey/multimedia/shockwave_flash/index.html -, but you may also find the need to get a good book for reference and more detailed information. I got the Flash 4 Bible which has served me well and would recommend to anyone. Remember though Flash 5 is out and is a wee bit different, so it may be worth getting a Flash 5 book (if there are any..). HTH, Phil > hi, i'm having difficulty learning Flash 4, particularlly the timeline > and how to manipulate. are there any suggestions for lessons other than > those included with the program, such as web-based, or a good cheap book? > your input is appreciated From martin.p.burns at uk.pwcglobal.com Wed Dec 20 05:23:11 2000 From: martin.p.burns at uk.pwcglobal.com (martin.p.burns at uk.pwcglobal.com) Date: Wed Dec 20 05:23:11 2000 Subject: [thelist] Common Fonts Message-ID: <802569BB.003634E8.00@uk-emamta003.ema.pwcinternal.com> Memo from Martin P Burns of PricewaterhouseCoopers -------------------- Start of message text -------------------- Actually Jacob, there is a serious point here - Arial and Geneva are both variations on Helvetica, but are tweaked for improved on-screen legibility. Helvetica is designed for print use, and isn't very good on-screen. Times isn't that good onscreen either, but I don't have an alternative seriffed font to suggest. Reading material: Stop Stealing Sheep & Find Out How Type Works http://www.amazon.co.uk/exec/obidos/ASIN/0201703394/martin043 (probably the best typography book for non-typographers) This is now on my Library article: http://evolt.org/article/Building_a_library/25/2448/evolt.org htttp://www.easyweb.co.uk/articles/library.html Cheers Martin Please respond to thelist at lists.evolt.org To: thelist at lists.evolt.org cc: Subject: RE: [thelist] Common Fonts Eric, Be sure to read the suggestions others have made regarding this. A good alternative if you really want Arial as your Windows font is to use a Mac-only font first in your choices - for example, font-family: Geneva, Arial, Helvetica; Geneva is a pretty good looking Mac font and will do just fine for an Arial replacement on the Mac, Arial will show up on Windows, and for those hapless (I'm JOKING :) :) :) ) UNIX users, Helvetica should take up the cause. --------------------- End of message text -------------------- The principal place of business of PricewaterhouseCoopers and its associate partnerships is 1 Embankment Place, London WC2N 6NN where lists of the partners' names are available for inspection. All partners in the associate partnerships are authorised to conduct business as agents of, and all contracts for services to clients are with, PricewaterhouseCoopers. The UK firm of PricewaterhouseCoopers is authorised by the Institute of Chartered Accountants in England and Wales to carry on investment business. PricewaterhouseCoopers is a member of the world-wide PricewaterhouseCoopers organisation. ---------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. From sck at biljettpoolen.se Wed Dec 20 05:28:43 2000 From: sck at biljettpoolen.se (Steve Cook) Date: Wed Dec 20 05:28:43 2000 Subject: [thelist] JavaScript - closing parent window Message-ID: <3B55A5A1F233D41183A800D0B74D4D5205E6BD@SBS> Hi folks, hopefully a quickie JavaScript question! If I open a pop-up window, how do I both close that window and update the parent window at the same time. I'm trying variation on this: Close (inside is the name of the frame I want to update in the parent). Any ideas? .steve ---------------------------------- WapWarp - http://wapwarp.com Wap-Dev - http://www.wap-dev.net Cookstour - http://cookstour.org ---------------------------------- From lizlawson at charitycards.co.uk Wed Dec 20 05:40:42 2000 From: lizlawson at charitycards.co.uk (Liz Lawson) Date: Wed Dec 20 05:40:42 2000 Subject: [thelist] mySQL Sequencing Message-ID: <009d01c06a6d$92fe6920$03c812ac@liz> I wouldn't use the id unless you know that firstly you don't want the order to change (you won't want to change your ids!) and secondly you want to order the items in the same order as the ids, most likely the order they were added. To control the display order of records, I include a column called 'priority' and order my results by that. You could enter a priority value as part of a new record, but this means that either you will have two products with the same priority (not a problem for the order by clause, but does mean that you won't have control over the order of records with the same priority), or your add script will also have to update all existing records with priority values higher than that of the new product by adding 1 to the priority. In my system all new records go in with priority 0, which puts them either at the beginning or the end. I then have a separate page with a javascript order sorter (based on an example posted to this list, thanks!) where the user can select an item in a form menu and move it up or down the list. When this page is generated (PHP), the results are pulled from the db in priority order, and an html menu list is created in the form