Voyager

Ok, Saw the final episode last night. Errrr how crap was that. Nice new technology and all that, but that really was a poor ending. Best Regards, Adam Reynolds ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I have a general "how do you do that" SQL question. I have a table with links in it.  One link per row, with URL link name, etc. The client wants to be able to specify the order in which the links appear. In other words, they want to set any link to show up first, another other link to show up second, etc, etc. I did a rough think like this a while back, by allowing then to set a "precedent" field, than the sorted on that field.  The trick is, of course, if they ad a link and want it to show up in the second slot, then the "precedence" filed for records higher then 2 need to be incremented by one, so the sequence will still be in tack. I'm thinking there must be a better way to do this, but I don't know what it is. Thanks in advance, Peter Janett New Media One Web Services ================================ WEB HOSTING FOR WEB DEVELOPERS ================================ Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net webmaster@newmediaone.net (303)828-9882 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

What I do is allow the client to specify the sequence number. I inform them that if they use the same sequence number twice then the URLs will appear together, but the order in which they are displayed is not guaranteed. What I would say is that you could always provide a multi-select field which you manipulate using javascript that enables the user to move entries up and down in the list. -----Original Message----- From:  Peter Janett [SMTP:cf@tourmerchandise.com] Sent:  07 August 2001 09:36 To:  CF-Community Subject:  SQL question I have a general "how do you do that" SQL question. I have a table with links in it.  One link per row, with URL link name, etc. The client wants to be able to specify the order in which the links appear. In other words, they want to set any link to show up first, another other link to show up second, etc, etc. I did a rough think like this a while back, by allowing then to set a "precedent" field, than the sorted on that field.  The trick is, of course, if they ad a link and want it to show up in the second slot, then the "precedence" filed for records higher then 2 need to be incremented by one, so the sequence will still be in tack. I'm thinking there must be a better way to do this, but I don't know what it is. Thanks in advance, Peter Janett New Media One Web Services ================================ WEB HOSTING FOR WEB DEVELOPERS ================================ Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net webmaster@newmediaone.net (303)828-9882 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

----- Excess quoted text cut - see Original Post for more ----- In this sort of situation I have a Sort field, containing a four or five digit textual number (padded with zeroes), so you'd get 0001, 0002, 0003 etc. That way you can order them however you want Now, to add in the "slot" functionality, make it 2 sets of numbers, so it'll be 0001-0001, 0002-0001, 0002-0002, 0002-0003, 0003-0001 The first 4 digits is the "slot" and the second 4 are the "sort" - that way you ORDER BY one field and still can read how it's meant to be displayed HTH Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** 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. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

> Saw the final episode last night. Errrr how crap was that. Nice new > technology and all that, but that really was a poor ending. Why do they always have to play about with time to end the series? In TNG they had the 3 time periods, can't remember DS9 (how much of an impression did it make?) and this one had Future Janeway coming back to help Present Janeway beat the Borg... Nice trick to play on the Borg Queen, but it was still a "So, that was it?" ending... 8 years for that... Want to see "Enterprise" to see what they've done with that though... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** 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. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I thought DS9 was the better of them all - a bit more of a serious series, without the 'filler' episodes of TNG and Voyager.  Sisko was the best captain of them all. As for Enterprise, I am sure it will still have the class of a ST series, but its Scott Bakula for gods sake!!!!, at every point I will expect Dean Stockwell to walk out an white light door whacking a tri-corder which is making crappy bleeps and blurps only to tell our new captain that "Ziggy" thinks they have a 23% chance of survival (oh and the new captain is actually dressed as a women.... :-) Or maybe I have just given the plot away.... N ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

> I thought DS9 was the better of them all - a bit more of a serious series, > without the 'filler' episodes of TNG and Voyager.  Sisko was the best > captain of them all. DS9 was the most substantial of all of the ST series' - but I still don't remember the ending... maybe it just didn't make an impression, or I only remember the crap ones <g> > As for Enterprise, I am sure it will still have the class of a ST series, > but its Scott Bakula for gods sake!!!!, at every point I will expect Dean > Stockwell to walk out an white light door whacking a tri-corder which is > making crappy bleeps and blurps only to tell our new captain that "Ziggy" > thinks they have a 23% chance of survival (oh and the new captain is > actually dressed as a women.... :-) I didn't realise he was the captain... I'll have to go a-hunting for information > Or maybe I have just given the plot away.... Damn, there goes most of the first series - they'll have to re-write it now Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** 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. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

http://www.startrek.com/production/seriesv/multimedia.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I think Scott Bakula was a great choice.  This captain needs to be far more carnal than Pickard, more carnal even than Kirk. Course and crude, reflecting his times (which are maybe even a little less evolved than our own after all Earth has been through -- but not a eugenics war in 1996). H. I thought DS9 was the better of them all - a bit more of a serious series, without the 'filler' episodes of TNG and Voyager.  Sisko was the best captain of them all. As for Enterprise, I am sure it will still have the class of a ST series, but its Scott Bakula for gods sake!!!!, at every point I will expect Dean Stockwell to walk out an white light door whacking a tri-corder which is making crappy bleeps and blurps only to tell our new captain that "Ziggy" thinks they have a 23% chance of survival (oh and the new captain is actually dressed as a women.... :-) Or maybe I have just given the plot away.... N ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I have to be honest and say I stopped watching Voyager about 3 series back. I just couldn't get on with the crew....Janeway lacked the charisma to be a captain. Was kinda hoping that Chakotay would lead a mutiny, drop her off on the nearest inhabitable planet, and damn the prime directive and all that to hell. Still :) > Saw the final episode last night. Errrr how crap was that. Nice new > technology and all that, but that really was a poor ending. Why do they always have to play about with time to end the series? In TNG they had the 3 time periods, can't remember DS9 (how much of an impression did it make?) and this one had Future Janeway coming back to help Present Janeway beat the Borg... Nice trick to play on the Borg Queen, but it was still a "So, that was it?" ending... 8 years for that... Want to see "Enterprise" to see what they've done with that though... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** 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. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I liked it. H. Ok, Saw the final episode last night. Errrr how crap was that. Nice new technology and all that, but that really was a poor ending. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Check this out.... http://www.startrek.com/news/news.asp?ID=120418 best wishes,                   -= Ed If you want others to be happy, practice compassion. If you want to be happy, practice compassion." ~The 14th Dalai Lama ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm