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:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED]
(303)828-9882
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
