order.
-- Josh
- Original Message -
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, February 14, 2007 7:47 PM
Subject: RE: How to re-order items?
That sounds like the approach I'm currently using in principle,
I'm just doing the insert
Subject: Re: How to re-order items?
Hi Rick,
You don't want to add 10, you want to multiply by 10. So you are looping
the data:
cfoutput query=getAgents
Your cfquery would look like
UPDATE AgentsTable
SET displayorder = #currentRow# * 10
WHERE AgentID = #AgentID#
/cfoutput
This will insert 10
On 2/13/07, Bobby Hartsfield [EMAIL PROTECTED] wrote:
When a new record is added, I usually default the sort order to the number
of records + 1 so it is at the end. Then in a list view of all the records
there is an up and down arrow next to each entry that moves it either up
or
down by sort
How is the up and down arrow implemented? Is this a
Javascript function?
-Original Message-
From: mac jordan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 14, 2007 3:19 AM
To: CF-Talk
Subject: Re: How to re-order items?
On 2/13/07, Bobby Hartsfield [EMAIL PROTECTED] wrote:
When
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 14, 2007 10:09 AM
To: CF-Talk
Subject: RE: How to re-order items?
How is the up and down arrow implemented? Is this a
Javascript function?
-Original Message-
From: mac jordan [mailto
would I use the Round function (or something else?)
to change the numbers up to the next number evenly
divisible by 10?
Rick
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 14, 2007 10:32 AM
To: CF-Talk
Subject: RE: How to re-order items?
Hey
How would I use the Round function (or something else?)
to change the numbers up to the next number evenly
divisible by 10?
Hey Rick,
What I do is, submit the 14 into the db...re-query, ordering by display
order...loop over the query, updating each entry setting displayorder =
#currentRow#
to CurrentRow * 10
Does this follow your line of thinking?
Rick
-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 14, 2007 12:28 PM
To: CF-Talk
Subject: Re: How to re-order items?
How would I use the Round function (or something else
-
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, February 14, 2007 12:19 PM
Subject: RE: How to re-order items?
Interesting approach, Josh... so you're using the current
row (which would be auto-incremented by one) become
the succeeding display
that agents aren't added
or deleted that often, so it won't be a daily routine where
ease of use would be significant.
Thanks for the help.
Rick
-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 14, 2007 3:47 PM
To: CF-Talk
Subject: Re: How to re-order
the best approach to ordering the display of Real Estate agents
In just about all the applications we develop where sort order is required I
supply a sort field which is a numeric (int) field in the table. I create
a page that retrieves the records to be sorted and displays the relevant
part of
, February 14, 2007 6:00 PM
To: CF-Talk
Subject: RE: How to re-order items?
the best approach to ordering the display of Real Estate agents
In just about all the applications we develop where sort order is required I
supply a sort field which is a numeric (int) field in the table. I create
a page
: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 13, 2007 11:41 AM
Subject: How to re-order items?
Hi, all.
I'm trying to figure out the best approach to
ordering the display of Real Estate agents on
a website.
I have it by last name currently
That's order not oder
Doug B.
- Original Message -
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 13, 2007 11:47 AM
Subject: Re: How to re-order items?
Why not just use a date instead. This date could be from their longevity
PROTECTED]
Sent: Tuesday, February 13, 2007 1:42 PM
To: CF-Talk
Subject: How to re-order items?
Hi, all.
I'm trying to figure out the best approach to
ordering the display of Real Estate agents on
a website.
I have it by last name currently, but my client
wants to re-order by Seniority.
So, I
That is exactly what I do in a similar situation, and it works fine.
-- Josh
- Original Message -
From: Rick Faircloth [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 13, 2007 10:41 AM
Subject: How to re-order items?
Hi, all.
I'm trying to figure
and weight fields or more simply just assign
each jobtitle a number.
Regards
Michael
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 13 February 2007 18:42
To: CF-Talk
Subject: How to re-order items?
Hi, all.
I'm trying to figure out the best approach to
ordering
[EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 13, 2007 11:56 AM
Subject: RE: How to re-order items?
Rick
I'm not sure how you your client defines seniority but a couple of ideas
of
the top off my head.
If it's based on length of service add a database field
.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 2:11 PM
To: CF-Talk
Subject: Re: How to re-order items?
Another thing is that if you do it based upon a number and let the client
order by the number, he will be re-ordering all the time when new
It sure beats giving them a field to put a number in
The up/down arrow method is great if there aren't a lot of records, but if
you want to move the 50th record up to #1 for example, it becomes rather
tiresome, clicking the up arrow 50 times. In this case having fields
w/numbers is better.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 10:42 AM
To: CF-Talk
Subject: How to re-order items?
Hi, all.
I'm trying to figure out the best approach to
ordering the display of Real Estate agents on
a website.
I have it by last
PROTECTED]
Sent: Tuesday, February 13, 2007 1:47 PM
To: CF-Talk
Subject: Re: How to re-order items?
Why not just use a date instead. This date could be from their longevity
with the current agency, or their time as an agent overall or even both. you
could have drop down in the admin section to allow them
Nope... I quit... I'm not re-ordering anyone by oder! :o)
Rick
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 1:49 PM
To: CF-Talk
Subject: Re: How to re-order items?
That's order not oder
Doug B
: RE: How to re-order items?
When a new record is added, I usually default the sort order to the number
of records + 1 so it is at the end. Then in a list view of all the records
there is an up and down arrow next to each entry that moves it either up or
down by sort order.
Say you click the third
Glad to know the idea works in practice!
Thanks, Josh
Rick
-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 1:55 PM
To: CF-Talk
Subject: Re: How to re-order items?
That is exactly what I do in a similar situation, and it works fine
13, 2007 1:56 PM
To: CF-Talk
Subject: RE: How to re-order items?
Rick
I'm not sure how you your client defines seniority but a couple of ideas of
the top off my head.
If it's based on length of service add a database field called joindate and
sort on that.
Or if it's on say job title/rank add
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 2:11 PM
To: CF-Talk
Subject: Re: How to re-order items?
Another thing is that if you do it based upon a number and let the client
order by the number, he will be re-ordering all the time when new agents are
hired. I would not do it that way
I'm considering trying a jQuery implementation for this one, too.
I'll check out your suggestion!
Thanks!
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 2:27 PM
To: CF-Talk
Subject: RE: How to re-order items?
Hi there Rick
Is seniority based on hire date?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 2:39 PM
To: CF-Talk
Subject: RE: How to re-order items?
Glad to know the idea works in practice!
Thanks, Josh
Rick
-Original Message-
From: Josh
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 11:51 AM
To: CF-Talk
Subject: RE: How to re-order items?
I'm considering trying a jQuery implementation for this one, too.
I'll check out your suggestion!
Thanks!
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL
No I'm not talking about JS... I'm talking about CF :-)
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 2:39 PM
To: CF-Talk
Subject: RE: How to re-order items?
You must be talking about a Javascript solution.
I'd be glad to see
To: CF-Talk
Subject: RE: How to re-order items?
Is seniority based on hire date?
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk
',
helperclass : 'sorthelper',
opacity:0.5,
fit : false
})
-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 3:12 PM
To: CF-Talk
Subject: RE: How to re-order items?
I used to use http://tool
.
Michael
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 12:47 PM
To: CF-Talk
Subject: RE: How to re-order items?
I see the sample js code, but no HTML application examples...how would
the following be implemented
Well... sure, I'd like to see that code, if you don't mind.
Rick
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 3:25 PM
To: CF-Talk
Subject: RE: How to re-order items?
No I'm not talking about JS... I'm talking about CF
To: CF-Talk
Subject: RE: How to re-order items?
Hi Rick,
Based on the js below, you can simple create a ul like
ul
cfloop query=get_realtor_by_seniority
li class=sortableitem
id=sortrealtor#realtor_id##realtor_name#/li
/cfloop
/ul
I did not test the above
, but with an added Sort functionality.
Hope that makes sense, Rick. CF+jQuery Rules!!
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 1:56 PM
To: CF-Talk
Subject: RE: How to re-order items?
Interesting...I'll have to figure
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 5:29 PM
To: CF-Talk
Subject: RE: How to re-order items?
What I have similarly done in the past is to create a button/link titled
aSort Realtors/a on top of the table.
The sort button will open a div element div id
PROTECTED]
Sent: Tuesday, February 13, 2007 3:40 PM
To: CF-Talk
Subject: RE: How to re-order items?
I'm understanding this a little...I think...
But if data is rearranged in the sortform, then
how will the table data also be rearranged once
the Sort Realtors link is clicked again and the
table
at the bottom of my forms, I list all the records with [edit] and [delete]
links for each. If there is a sortorder on the records then I just put an up
and down arrow at the beginning of each record
with irl variables for the recordid, the direction (up/down) and somehting
else just to look for to
Thanks for the explanation and the code, Bobby!
Much appreciated!
Rick
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 8:35 PM
To: CF-Talk
Subject: RE: How to re-order items?
at the bottom of my forms, I list all the records
Thanks for the explanation!
Rick
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 13, 2007 8:02 PM
To: CF-Talk
Subject: RE: How to re-order items?
At this point, sortform is just a regular form with a hidden field and a
submit button. You can
42 matches
Mail list logo
