Thank you Michael.
I made it an SOT in case I was flamed by people. It's a sad fact that many
installs of SQL Server, version 7 at least, are not as carefully wrapped up
as they should be. The actual artical came from Australian IT - a well
respected source of many things IT related downunder:
The classic - and class(y/ie)? CFX_DOC2HTML would also be gratefully
purchased!!!
==
Peter Tilbrook
Macromedia ColdFusion Applications Developer
4/73 Tharwa Road
Queanbeyan, NSW, 2620
Phone: (02) 6284 2727
Mobile: 0401 973 415
Email: [EMAIL PROTECTED]
-Original Message-
From: Mallory
Hasn't Ben himself indicated that an MX version of his own classic tome/s is
due?
Personally I am still having a ball with CF5. And the Forrest Gump
soundtrack is recommended for easy listening during database design!
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Morning all,
Has anyone ever come across a problem with running java with cfobject?
At present we run a fair few java CFX tags which are all working perfectly,
however, one of our sites uses a java class to encrypt user details and post
them to a credit card processing company, this is done
If I've got a query and for some odd reason the database
server goes down, of course my query will fail.
How can I catch the error due to the server being down and display a
static/temp page instead?
My code is below and it appears to be correct but it will not
catch the error and redirect.
Does anybody know what causes Error 500 invalid port Command
using CFFTP?
Which web server are you CFFTPing to
Some don't allow FTP access unless it's got the proper header
information
Also, CFFTP requires a certain amount of responses to work, so if it's a
limited FTP server, then it might
Morning all,
Has anyone ever come across a problem with running java with cfobject?
At present we run a fair few java CFX tags which are all working perfectly,
however, one of our sites uses a java class to encrypt user details and post
them to a credit card processing company, this is done
Hello,
I must be missing some kind of syntax. Anyone can help please?
I'm getting the error below when I do this update:
cfquery name=update datasource=purchases
UPDATE purchases SET Costeach = #Dollarformat(Costeach)#
on a field that is dollar formatted as:
input type=text name=costeach
I have never used these functions much.
The syntax looks just like the help files.
cfset TodayPlus1 = DateAdd(d, 1, Today)
Can I use the DateAdd function in a CFSET?
I get this error:
Error Diagnostic Information
An error occurred while evaluating the expression:
TodayPlus1 = DateAdd(d,
I think you don't need DollarFormat when updating only when displaying
ie
cfquery name=update datasource=purchases
UPDATE purchases SET Costeach = #Costeach#
...
Seamus
At 10:09 pm 24/05/2002 , you wrote:
Hello,
I must be missing some kind of syntax. Anyone can help please?
I'm getting
cfset TodayPlus1 = DateAdd(d, 1, Today)
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 7:29 AM
To: CF-Talk
Subject: DateAdd function
I have never used these functions much.
The syntax looks just like the help files.
cfset TodayPlus1 =
Ah man,
The Quotes weren't in the help file I looked at, and my brain didn't click
in to trying them.
Cursed Brain!!
Thanks Kevin!
Yves
- Original Message -
From: Kevin Schmidt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 9:30 AM
Subject: RE:
Good point. I removed the dollarformat and now have: SET Costeach = #form.Costeach#
and I get this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$0.00'
Do I need a Trim function beforhand?
Robert O.
No problem
-Original Message-
From: Yves Arsenault [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 7:38 AM
To: CF-Talk
Subject: Re: DateAdd function
Ah man,
The Quotes weren't in the help file I looked at, and my brain didn't
click
in to trying them.
Cursed Brain!!
Well folks, I'm a bit stuck with retrieving data from a
mySQL-datasource which was exported from ms-access via a little nifty
utility called MyAccess. The problem is that the text in the db has
german special characters. Since I exported the data to mySQL I'm able
to retrieve all the data but the
I have some js that checks the time an automatically logs out if there
hasn't been any activity in the last 15 minutes. This sometimes takes
people by surprise. I'd like to add something that either counts down
There has not been any activity. You will be logged off in 15
do you have the dollar sign in the form?
Try putting just the amount in the form - no dollar signs and see what happens
Seamus
At 10:36 pm 24/05/2002 , you wrote:
Good point. I removed the dollarformat and now have: SET Costeach =
#form.Costeach#
and I get this error:
ODBC Error Code = 37000
I must be missing some kind of syntax. Anyone can help please?
I'm getting the error below when I do this update:
cfquery name=update datasource=purchases
UPDATE purchases SET Costeach = #Dollarformat(Costeach)#
on a field that is dollar formatted as:
input type=text name=costeach
OK, now I understand. Costeach is a number in the Access table.
However, is there any way to make the number, let's say 1300.50 appear as $1,300.50
when displayed, but as 1300.50 (stripped the $, etc) when updating?
Thanks.
Robert O.
-Original Message-
From: Philip Arnold - ASP
With JavaScript this is tricky, but you could use something like this:
SCRIPT LANGUAGE=JavaScript
if (confirm('You have been inactibe for x minutes. Logout?')) {
// logout code here
};
/SCRIPT
This only gives them OK or Cancel as options. I don't think you can
prompt and set your own
Hi,
Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm
using frames and my dropdown navigation menu is in the top frame and when
clicked does *not* overlay the bottom frame.
Is there a version of heirmenu that allows overlaying on frames? If so,
which one?
Er...what I meant was...
..Also, since the message box is modal, I don't think the browser can load
a new page until the prompt is answered so you couldn't automatically send
them to a logout page if they didn't respond...
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Hi phumes1,
I would assume that the dhtml-layer of the menu can't appear anywhere
else than in it's own frame...
Patric
p Hi,
p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm
p using frames and my dropdown navigation menu is in the top frame and when
p clicked
Well, I guess this is off-topic and probably a bit basic, but how do you
write a recursive query? I have a need for it but I don't know how to
do it. My db is access 2000.
Thanks,
Matt Small
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23,
Alright, this is my LAST correction...this is getting ridiculous, but it IS
Friday...
With JavaScript this is tricky, but you could use something like this:
SCRIPT LANGUAGE=JavaScript
if (confirm('You have been inactibe for x minutes. Logout?')) {
// logout code here
}else {
//
In this version, correct.
At 03:34 PM 5/24/2002 +0200, you wrote:
Hi phumes1,
I would assume that the dhtml-layer of the menu can't appear anywhere
else than in it's own frame...
Patric
p Hi,
p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm
p using frames and my
Well, there'll be nothing (at the moment) that can be rendered partly
out of it's own frame. This needs to be implementet in the browsers
rendering-engine
Patric
p In this version, correct.
p At 03:34 PM 5/24/2002 +0200, you wrote:
Hi phumes1,
I would assume that the dhtml-layer of the
I believe you will encounter the same problem in all versions of the menu. I
do not think it is possible to script a layer to cross the frame since it is
essentially another document.
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
Nitendo Vinces - By Striving You Shall Conquer
Yes in the Query you would use:
#Costeach#
When displaying #Dollarformat(Costeach)#
AS LONG AS Costeach in a numeric field in the
database. If it is a MONEY this try using:
#VAL(CostEach)#
Randy Adkins
[EMAIL PROTECTED] 05/24/02 09:16 AM
OK, now I understand. Costeach is a number in the
Check out http://www.burmees.nl/menu/menus.htm. These DHTML menus appear to
work across frames. They are quite ingenious.
-Original Message-
From: Patric Stumpe [SMTP:[EMAIL PROTECTED]]
Sent: 24 May 2002 14:55
To: CF-Talk
Subject: Re: Heirmenu
Well, there'll be nothing
Dooh, Beat me to it! I'll post it anyway.
cfset places=querynew('name')
cfset temp = QueryAddRow(places,4)
cfset temp = QuerySetCell(places, 'name', 'University of Alabama The', 1)
cfset temp = QuerySetCell(places, 'name', 'Florida State University', 2)
cfset temp = QuerySetCell(places, 'name',
OK, now I understand. Costeach is a number in the Access table.
However, is there any way to make the number, let's say
1300.50 appear as $1,300.50 when displayed, but as 1300.50
(stripped the $, etc) when updating?
What you have to do is before you update;
Lowdown:
What is the optimum arrangement of WHERE clauses when querying an Oracle
database?
Details:
I'm trying to optimize my CF queries running against an Oracle 8i database.
I know that conventional wisdom is to put highly selective columns (those
with many unique values) first in the WHERE
All,
I have a page that displays perfectly in IE 5.5, but shows up blank in
Netscape 4.79. Not only does it render blank, but it takes about 30 seconds
to render blank. (no dynamic content). When I do a View Source in
Netscape, the source is there. However, in the browser, I am only seeing
- Original Message -
From: Matthew Walker [EMAIL PROTECTED]
cfset content=REReplaceNoCase(content, a href=([^ ]*)
([^]*), a href=\1%20\2, all)
This will only replace one space per anchor. You need to run it
repeatedly to get them all.
-
I ended up with a
Lowdown:
What is the optimum arrangement of WHERE clauses when
querying an Oracle database?
Details:
I'm trying to optimize my CF queries running against an
Oracle 8i database. I know that conventional wisdom is to
put highly selective columns (those with many unique values)
first
Wow, you do know that cfscript would clean up that code something fierce.
cfscript
places = queryNew(name);
queryAddRow(places, 4);
querySetCell(places, 'name', 'University of Alabama The', 1);
querySetCell(places, 'name', 'Florida State University', 2);
querySetCell(places,
You're right, Oracle reads from the bottom up. It's good practice to place
your most limiting conditions at the end of the where clause, and work your
way up from there.
v/r,
Jeff
-Original Message-
From: Chris Lofback [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 10:34 AM
To:
Sample code?
It could be one tiny little forgotten tag .. Or something not closed
correctly
One of the useful things about DWMX, .. Is when I open code up in it ...
If any of the tags are not nested correctly .. Or not closed properly
.. It highlights it. Found quite a few errors like this
I have a page that displays perfectly in IE 5.5, but shows up blank in
Netscape 4.79. Not only does it render blank, but it takes
about 30 seconds
to render blank. (no dynamic content). When I do a View Source in
Netscape, the source is there. However, in the browser, I am
only seeing
Thanks, but gee doesn't but I guess that defeats the purpose? Works ok as
long as you want the person to respond- but it needs to logout of the
applicaton if the user has walked away from their computer
-Original Message-
From: Chris Lofback [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Thanks much Phillip. One further question though.
In Access I have the costeach field setup as numeric. Each time a figure is entered
with cents after, it rounds it off to the next amount (350.60 becomes 360). How can I
keep it as 350.50 and then at some point have this number calculated via
Can you post a link?
-Original Message-
From: Jeff Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 10:40 AM
To: CF-Talk
Subject: damn Netscape 4.x!
All,
I have a page that displays perfectly in IE 5.5, but shows up blank in
Netscape 4.79. Not only does it
Do any of you fine people know of a free XML European wide weather feed?
TIA
J
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
Janine:
If you're trying to stick with your existing JS functionality and keep it
all JS, then I don't know of any other option for prompting because any JS
prompt will be modal. You could try writing your countdown to the status
bar but it may not be noticed by the user or they may have their
not just table tags that will cause problems. also td's and tr's. I would
take the netscape source and paste into a temp.htm page and start commentin
out lines until you track down the issue.
I feel for ya. I had a very late nite last week with the same issue.
Sean
-Original
Hi all,
I'm currently working on an enterprise level (clusterable and such) security
system and I'm working on the application logging aspect of it now. I've
built several security systems in the past and have done logging before so
it's no big deal. Typically I'll log the remote_address,
If you have more than one URL/IP pointing at the same site, you might want to log the
server_name.
Or even if you want to know if they came in as IP #s or domain name.
Jerry Johnson
[EMAIL PROTECTED] 05/24/02 11:26AM
Hi all,
I'm currently working on an enterprise level (clusterable and
Does anyone know of a list that has to do with search engine
optimization? We are trying to get better rankings and I could use all
the input I can get.
Douglas Brown
Email: [EMAIL PROTECTED]
__
Signup for the Fusion
Try http://www.searchengineworld.com a good amount of information.
Good Luck
Paul Giesenhagen
QuillDesign
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 11:05 AM
Subject: OT: Search Engines
Does anyone know of a
I cant find in any of the books if all the queries in a CFTransaction block
are single threaded.
Like if i have three querys in the CFTransaction:
cftransaction
Query #1: Insert into DB
Query #2: Select from DB to get highest number of Query #1 and increment by 1
Query #3: Insert into DB
This site is pretty nice http://www.searchengineworld.com/ the thing is
though, the biggest place for you to get higher ranking is from reciprical
links. So you would need to do a type of link exchange program between like
sites or customers.
Robert Everland III
Dixon Ticonderoga
Web Developer
Also http://searchenginewatch.com/
Shawn McKee
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 11:00 AM
To: CF-Talk
Subject: Re: Search Engines
Try http://www.searchengineworld.com a good amount of information.
Good Luck
Paul
WordTracker.com is an essential tool.
cf_plug
There are also firms (like ours) that can do this for you. It's not that
expensive...
/cf_plug
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 9:05 AM
To: CF-Talk
Subject: OT: Search Engines
www.searchenginewatch.com
He has a newsletter too. Pretty interesting each month.
Dave
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 12:05 PM
Subject: OT: Search Engines
Does anyone know of a list that has to do
Anyone know of a custom tag or something that offers a true combo box for
HTML?
The tags I have seen in the exchange are typically a text box which will use
JS to select the appropriate item in a select box. However, we need to
allow our users to type a value into a combo box, where the value
I cant find in any of the books if all the queries in a
CFTransaction block are single threaded.
Like if i have three querys in the CFTransaction:
cftransaction
Query #1: Insert into DB
Query #2: Select from DB to get highest number of Query #1
and increment by 1
Query #3: Insert into
check out http://www.rolist.com
rotating search engine.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 12:05 PM
To: CF-Talk
Subject: OT: Search Engines
Does
Does anyone know the contact email to report problems on the MM Developer's
Exchange?
In particular, I found a custom tag (Combo Box by Dave Miller) where if you
click the View Example link, you get nailed with pop-up ads (about 6 of
them), and never do get to view an example of the combo box.
robert,
i guess phillip got busy :)...so i'll pinch hit for him...
in access design view, click on the field name then make sure
field size (general tab) is set to long integer and decimal
places is set to auto. that should eliminate your problem with
rounding.
if you want to multiply the
There is an address you could write for such thing, but I don't have it in front of
me. Send the specifics to me, I'll forward it to the correct folks.
Thanks!
Vernon Viehe
Community Manager
Macromedia, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Shawn Grover
To: CF-Talk
Sent:
depending on your audience... i.e. IE only as i dont think this works on
Netscape..
http://www.devguru.com/Features/tutorials/ComboControl/combocontrol.html
Shawn Grover wrote:
Anyone know of a custom tag or something that offers a true combo box for
HTML?
The tags I have seen in the
i guess phillip got busy :)...so i'll pinch hit for him...
Oops, missed that one... Thanks for catching it for me Dina
Also, my Access skills are a little rusty as I've not really used it for
close on 3 years now g
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia
Hey CF people,
Happy Friday!!
Well I have a question about access. I thought I saw something or read
something about use the access query objects as stored procs. Has anyone
done this and if so can you share?
TIA
Shawn Regan
Uh - it's a domain name for sale . . . .
Daved
- Original Message -
From: Ian Lurie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 12:11 PM
Subject: RE: Search Engines
WordTracker.com is an essential tool.
cf_plug
There are also firms (like ours) that can
Here is one I made that works in IE5+ and Mozilla/NS/AOL/Compuserve...
http://www.oztek.net/jon/combobox.htm
It's not the best code, and I started working on a more OO version, but what
code is there is pretty readable.
jon
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To:
Yes, we have. It works quite well: You write your query in Access, then use
CFSTOREDPROC to access it. Cut the processing time on a few of our pages
from over 4 seconds to just under 400 ms.
You can also access a query as a table, of course, but then PROCPARAM is
right out...
Ian
-Original
Are you sure - I just cut and paste this:
http://www.wordtracker.com/
We use it every day, honest
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 10:07 AM
To: CF-Talk
Subject: Re: Search Engines
Uh - it's a domain name for sale . . . .
Thank you Jon, and Mike. I think the article Mike specified is the best
solution (in our case). Unfortunately, we are mostly through our app, and
need to replace some selects with combo's. On that note, it is not feasible
at this time for us to rewrite the code to populate the combo boxes. So
:) no problem...
- Original Message -
From: Philip Arnold - ASP [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 24, 2002 11:50 AM
Subject: RE: update a dollarformat field
i guess phillip got busy :)...so i'll pinch hit for him...
Oops, missed that one... Thanks
Dear Listmembers,
I truly hate posting this question because I know it has been discussed,
albeit some time ago. However, combing through the archives and saved emails
has not proven fruitful yet.
We are building a file sharing system on our intranet. CFFile uploads from a
Mac go ok, but cannot
Thanks Dina! Have a good weekend all and thanks for the quick and helpful replies as
always.
Robert O.
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 12:36 PM
To: CF-Talk
Subject: Re: update a dollarformat field
robert,
i guess phillip got
Ok thanks
Do you know of any place I can find docs on the syntax?
Shawn Regan
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 10:12 AM
To: CF-Talk
Subject: RE: Access SQL stored procs
Yes, we have. It works quite well: You write your query in
You can set up a paramater query in Access that accepts CFPROCPRAM.
something like:
cfstoredproc datasource=AdvancedAccess procedure=CustomerOrders
cfprocparam
type=in
cfsqltype=cf_sql_integer
dbvarname=get_OrderListForCustomerByID
value=1
cfprocresult
Ben Forta did an article on this some time ago (think it was him). Check
out his site at www.forta.com the article should be there somewhere.
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 11:31 AM
To: CF-Talk
Subject: RE: Access SQL stored
I forgot to change the subject line in my original post
--
Dear Listmembers,
I truly hate posting this question because I know it has been discussed,
albeit some time ago. However, combing through the archives and saved emails
has not proven fruitful yet.
We are building a file sharing
If I define a 2 dimensional array with info in it like this:
Element NameLowMark HighMarkAvgMark
1 Fred22 88 45
2 Bob 55 96 83
Is there a way to easily get the average of the average column
ok thanks
Shawn Regan
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 10:47 AM
To: CF-Talk
Subject: RE: Access SQL stored procs
Ben Forta did an article on this some time ago (think it was him). Check
out his site at www.forta.com the
Looks like a neat problem. Lets see:
CFSCRIPT
!--- initialize the total variable to hold the sum of the array's
value ---
total = 0;
for(i = 1; i lt arrayLen(avgMark); i = i + 1){
total = total + avgMark[i];
}
average = total / arrayLen(avgMark);
/CFSCRIPT
That should do it
At 02:29 PM 5/24/02 -0400, Timothy Heald wrote:
That should do it right?
grin Very slick. That looks like it'll solve it. Thanks.
T
__
Signup for the Fusion Authority news alert and keep up with the latest news in
Hi all friends:
I'm using the cfhttp tag to log into a site remotly and walk around after
being logged , the problem comes out when I meet a link (that I need to call
trough cfhttp too) like this:
a
href=javascript:cf_http_hook_fullpath('http://skillport.nywired.org/_SkillS
Let me expand this a bit more:
CFSCRIPT
!--- initialize the total variable to hold the sum of the array's
value ---
total = 0;
for(i = 1; i lt arrayLen(studentInfo[5]); i = i + 1){
total = total + studentInfo[5][i];
}
average = total / arrayLen(studentInfo[5]);
/CFSCRIPT
Youre probably getting that from a query. Why not have the db calculate it
for you? DRE
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 12:40 PM
To: CF-Talk
Subject: RE: Array questions
Let me expand this a bit more:
CFSCRIPT
!---
No need to reinvent the wheel. How about
average = ArrayAvg(avgMark)
Don't think it will work on a 2D array but I don't see how your data fits a
two dimension array.
/rob
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:29 PM
To: CF-Talk
Hey all, I'm having a bit of a brain fart here. I want to have a particular
site send the details of the error message when a message occurs. The plan
I have is this, but it doesn't seem to be working.
\root\Application.cfm (contains a cferror tag, type=exception
mailto=myemailaddr
My understanding is that you can't use cf code at all in an error template. You have
access to a few vars. You can use mailto in cferror to send an e-mail on error.
You can use CF code in a cfcatch if you trap your error that way.
David Schmidt [EMAIL PROTECTED] 05/23/02 02:52PM
Hey all,
Anyone have a ideas on how to sort a two dimentional array by one of the
elements (numerically)?
Kevin Schmidt
Two Rivers Marketing Group
502 E. Locust, Des Moines, IA 50309
Phone: 515.557.2028
Mobile: 515.865.3526
Fax: 515.557.2001
[EMAIL PROTECTED]
I need to use my spell checker more often! :)
-Original Message-
From: Kevin Schmidt
Sent: Friday, May 24, 2002 1:58 PM
To: CF-Talk
Subject: Sorting a 2 dimensionl array
Anyone have a ideas on how to sort a two dimentional array by one of the
elements (numerically)?
Kevin
check out ArraySort() in the CF Docs...
v/r,
Jeff
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:58 PM
To: CF-Talk
Subject: Sorting a 2 dimensionl array
Anyone have a ideas on how to sort a two dimentional array by one of the
elements
http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=Sort2DArray
On Fri, 24 May 2002, Kevin Schmidt wrote:
Anyone have a ideas on how to sort a two dimentional array by one of the
elements (numerically)?
Kevin Schmidt
Two Rivers Marketing Group
502 E.
ArraySort() only works with 1 dimensional arrays.
On Fri, 24 May 2002, Jeff Brown wrote:
check out ArraySort() in the CF Docs...
v/r,
Jeff
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:58 PM
To: CF-Talk
Subject: Sorting a 2
That only does 1 dimensional arrays :)
-Original Message-
From: Jeff Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:01 PM
To: CF-Talk
Subject: RE: Sorting a 2 dimensionl array
check out ArraySort() in the CF Docs...
v/r,
Jeff
-Original Message-
From: Kevin
Didn't know there was an arrayAvg() function. Should work on a multiple
dimension array like this:
arrayAvg(studentInfo[5])
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: Rob Baxter [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002
arraySort(array[1], numeric[,asc or desc])
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:58 PM
To: CF-Talk
Subject: Sorting a 2 dimensionl array
Anyone have a
That stinks.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 2:59 PM
To: CF-Talk
Subject: RE: Sorting a 2 dimensionl array
ArraySort() only works with 1 dimensional
Your code is most likely throwing an exception error, after which no CFML
can be processed. There are multiple error types which may be thrown
(exception, request, monitor and some other I can't remember).
Though you did not say it, I bet your cfmail tag is getting processed some
times (like
The CFStudio help says only a single dimensional array.
~Todd
On Fri, 24 May 2002, Timothy Heald wrote:
Didn't know there was an arrayAvg() function. Should work on a multiple
dimension array like this:
arrayAvg(studentInfo[5])
Tim Heald
ACP/CCFD :)
Application Development
This WAS true with earlier versions, but the error page is MUCH more robust
now, starting with V 4.5 I think.
Are you trying to make it work with a V 4.0 CF Server?
On 5/24/02 11:55 AM, BEN MORRIS [EMAIL PROTECTED] wrote:
My understanding is that you can't use cf code at all in an error
Kevin,
The one I pointed out at the Macromedia exchange works well. Steer clear
of one called ArrayTableSort however, it has a nice little bug in it (in
fact, it inserted an empty element in the array which screwed up my
app like you wouldn't believe). The Sort2DArray works well and has
Man we have all these great array functions, and they only work on single
dimension arrays. Wish I had known more about that during the CFMX beta.
Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
1 - 100 of 136 matches
Mail list logo
