Try using a structure, using the line number as the key, instead of an
array. A bit more flexible IMHO.
--Scott
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 4:09 PM
Subject: Array help?
> New to the list, new to the language, quite possibly in WAY over my
head...and
> posting this to the list at the advice of our webmaster.
>
> I'm using Cold Fusion to compare two files by loading them into arrays,
and I'd
> like to know if anyone can help me out with some array problems. (The
short
> explanation: I'm comparing source code from another programming language
> (Mumps), and using CF to do it because the code files are on different
servers,
> and it's actually easier to get to from outside than inside...if anyone
wants
> the long explanation, I'll be glad to give it...if you have an
afternoon...or
> maybe a weekend.) This is as much a systems tool for our department as it
is
> "proof to my boss I can do it"...it's also my own private "learn CF the
HARD
> way!" project, I think...anyway...
>
> I'm using a CFQuery to get the TEXT and the NUMBER of each line of code
and load
> it into two arrays, and then using CompareNoCase in a loop to check for
> differences. It's got some bells and whistles, too; if it finds a
difference,
> it will actually check a few lines forward to see if that line is inserted
and
> the rest of the program is the same. Or at least, it's supposed to.
>
> My problem is in the indexing of the array. If I bring the query over
with
> "ORDER BY LINE NUMBER" it times out--too much going on, I guess, and it
loses
> the connection to the other server. So, instead, I'm bringing it over in
> whatever order it comes across. I'm loading it into an array, using the
LINE
> NUMBER as the index, and I'm hitting a glitch that has me stumped.
>
> It brings over lines 1-50, then lines 52-100, and then line 51. It loads
all of
> these lines into the array. Then, when I go to do my compare, it can't
find
> line 51, and dies at that point. I know line 51 is there, because I told
it to
> CFOUTPUT each line as it went into the array; it just wasn't the 51st item
to go
> into the array...I would think it wouldn't matter what ORDER they go in,
as long
> as the line number controls where in the array it gets stored...?
>
> Here's a code snippet:
>
> <CFSET qArray1 = ArrayNew(1)>
> <CFSET temp = ArrayResize(qArray1, GetQuery1.RecordCount)>
> <CFLOOP query="GetQuery1">
> <CFSET temp= ArrayInsertAt(qArray1,#SEQUENCE_NUMBER#, "#TEXT#")>
> <CFOUTPUT> For testing purposes - Q1,
> *#SEQUENCE_NUMBER#*,#TEXT#</cfoutput><BR>
> </cfloop>
>
> Any advice on this would really be appreciated...and if I seriously
mangled my
> description here, I'll be glad to re-explain in further email. Thanks in
> advance...
>
> Allan Davis
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
