date:20031118

Re: Inserting rows into a 2d array

2003-11-18 Thread Ian Skinner

Looks like this may already be answered, but I just got around to playing with this.My solution is very similar, but maybe a bit more streamlined, if you are still just trying to add blank rows for output purposes.

cfset Test = ArrayNew(2)
cfset Test[1][1] = 'Sacramento'
cfset Test[1][2] = 'C001'
cfset Test[2][1] = 'Los Angles'
cfset Test[2][2] = 'C002'
cfset Test[3][1] = 'New York'
cfset Test[3][2] = 'C003'
cfset Test[4][1] = 'Seattle'
cfset Test[4][2] = 'C004'

h3Dump Test Array/h3
cfdump var=#Test#

h3Output Row 4/h3
cfoutput#Test[4][1]# #Test[4][2]#/cfoutput

cfset ArrayInsertAt(Test,3,ArrayNew(1))

h3Dump Test Array After new row added/h3
cfdump var=#test#

h3Output Row 4/h3
cfoutput#Test[4][1]# #Test[4][2]#/cfoutput

The only real difference then the other example, is I don't bother creating a blank placeholder array.Just put the ArraNew(1) function as the third parameter of the ArrayInsertAt function.This creates a blank new array at the new position.Then, if you later decide you need to put data here, you can just use simple assignment.

cfset Test[3][1] = first value
cfset Test[3][2] = second value
ect.

What took me a little to get my head around, when I first learned Cold Fusion Arrays, is that, when you have a two dimension Array, it does not have to be a grid or table.It is more proper to visualize it as a one diminsion array, that each element contains individual one diminsion arrays.Thus you can have different size arrays at each element.Something like this.

1 : Apples Oranges Peaches
2 : Joe Sally Jim Paul Mary Ringo George
3 : 1 2 3 4 5 6 7 8 9 10
4 : Cool
5 : A B C D E F G H I J K L M N O P Q 

Thus you have a 3 element sub-array in position 1, a 7 element sub-array in position 2, a 10 element sub-array in position 3, a 1 element sub-array in position 4 and finally 17 element sub-array in position 5.

This is powerfull stuff, because each sub-element can contain another level of array, thus you can create truely mind boggeling array demeinsions, only limited by memory, performance and sanity.
If you wanted an 11 dimension array {StringTheoryArray[2][3][1][5][7][8][1][9][17][22][4]}, this is perfectly leagle and allowed.May not be advisable, but you can do it. 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Inserting rows into a 2d array

2003-11-18 Thread Ian Skinner

Glad you got this to work for you, but just as a last thought.Your method requries the code to loop through all the data three times. Once to transfer the data from the query to the array, once to process blank rows into the array, and a third time to display it.I would be a bit leary for something like this on a high trafic page with a large data set.If neither of these apply to this application then you shouldn't have a problem.But it's a trade off to be aware of if used on such a page.

___
Ian Skinner
Web Developer
Sierra Outdoor Recreation
(http://www.SierraOutdoorRecreation.com)
- Original Message - 
From: DougF 
To: CF-Talk 
Sent: Monday, November 17, 2003 9:22 PM
Subject: Re: Inserting rows into a 2d array

Thanks Dave.
Just what I was fishing for... As a visual learner I need an example to help
understand the concept.

Here is what I have come up with. Tested, works, and solved my problem.
-
cfset My2DArray = ArrayNew(2)
cfloop index=row from=1 to=#query.RecordCount#
CFSET My2DArray[row][1] = #query.var_name[row]#
CFSET My2DArray[row][2] = #query.var_id[row]#
CFSET My2DArray[row][3] = #query.var_count[row]#
/cfloop
cfset firstLetter = A
cfset count=1
cfif My2DArray[count][1] NEQ 
cfloop condition=count LTE ArrayLen(My2DArray)
cfif Left(My2DArray[count][1],1) NEQ firstLetter
 cfset firstLetter = left(My2DArray[count][1],1)
 cfset NewElement = ArrayNew(1)
 cfset NewElement[1] = 
 cfset NewElement[2] = 
 cfset NewElement[3] = 
 cfset InsertSuccess = ArrayInsertAt(My2DArray, #count#, NewElement)
/cfif
cfset count = count + 1
/cfloop
/cfif
--
- Original Message - 
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, November 17, 2003 4:46 PM
Subject: RE: Inserting rows into a 2d array

 Something like this might work:

 cfset My2DArray = ArrayNew(2)
 cfset My2DArray[1][1] = outer 1 inner 1
 cfset My2DArray[1][2] = outer 1 inner 2
 cfset My2DArray[2][1] = outer 2 inner 1
 cfset My2DArray[2][2] = outer 2 inner 2

 cfset NewElement = ArrayNew(1)
 cfset NewElement[1] = foo
 cfset NewElement[2] = bar

 cfset rs = ArrayInsertAt(My2DArray, 2, NewElement)

 Note that I haven't tested this, exactly, but something close to this
should
 work. You could also create the element in place, then populate it, I
 suspect.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CF Studio 5 resource windows

2003-11-18 Thread Pascal Peters

NO
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED] 
Sent: maandag 17 november 2003 22:03
To: CF-Talk
Subject: OT: CF Studio 5 resource windows

Studio has two file windows (file 1, primary and file 2, secondary).Is
there any way to add more? 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CF and strange HTTP 500 error

2003-11-18 Thread Dwayne Cole

Is the city the only difference between users.Do they have different passwords or different access variables.Are you using cfc's or udf's? Are you using cflogin?I've encounterd the frustrating http 500 when there were errors in my cfc or udf.I've noticed that when when the error in my code, usely cfquery,is burried behind cfc's or under udf's I might run into this problem.

Dwayne Cole, MS in MIS, MBA
Florida AM University
Certified Advanced ColdFusion Developer
850-591-0212

 
It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge

-- Original Message --
From: Mosh Teitelbaum [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 17 Nov 2003 17:55:30 -0500

Uwe:

A status code of 500 indicates that there was an internal server error...
i.e., something funky happened, probably somewhere in your code.What is
the code for login.cfm trying to do?Check the code for any conditional
logic that may be affected by external things (such as cookies, IP Address,
etc).

Or you could post the code here (login.cfm, application.cfm,
onRequestEnd.cfm and any other applicable code) and let us have a look see.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 5:38 PM
To: CF-Talk
Subject: CF and strange HTTP 500 error


Hi list,
I have a strange problem
with a CF-server in an Intranet
of a customer:

User A from city X clicks the following
URL: www.foo.com/login.cfm with
no problem at all.

User B clicks the same URL
from city Y and will
get the following error:
HTTP 500 error (in detailled: -2146893054 (0x80090302))

Any clues how this is going
to get happen ?

On a sitenote: User B can access normal html-pages
from the same web-server without a problem.

Uwe




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:HTML e-Newsletter

2003-11-18 Thread Dwayne Cole

Thanks for the pointers.I kinda knew what to do from a technical perspective but I wanted to hear from someone about the issues and challenges faced when using cfmail to send html email to opt-in list that is expected to grow to about 8000.I've heard of .aol as well.

Dwayne,

Let me point out a few gotchas that hopefully the tutorial will cover.

1) Outlook XP and the latesxt versions of Outlook Express block by default any _javascript_ or Active X Controls. That means if you send out any videos, Flash or a snippy _javascript_ most folks can't see it.

2) The latest beta of Outlook blocks HTML email having formating or images from an external source. HTML email requires external images for displaying the images properly as the email is forwared from one person to the next. Marketers use this feature to embed web bugs allowing one to track the number of people who have opened the email message.

3) You must use an opt-in list to send out the email. In some US States and contries, you can be legally liable for emails not sent to an opt in list. Even worse, you can also be placed on a Black Hole list if you're using an external server acting as a relay.

4) You need to configrue your mail server to ensure outsiders can not relay off of the server you're using to send CFMAIL. CFMAIL does require an open relay to send out email-- on the other hand if you use NAT to make sure only non-routeable IP addresses are relayed by CFMAIL and specifically specify the non-routeable IP address of the Cold Fusion in the mail server, then you can protect yourself from spammers and not get yourself on a black hole list for having an open relay.

From a business point of view this has the following reprocussions.

A) Your subject line must clear, consise and meaningful to the opener
B) You should use plain text without forwarding unless the email generated is from an Intranet (where one can control the user experiance while using the firewall and black hole lists to control spam)
C) If your trying this for an external audiance, you need to purcahse or generate an opt in list, have a privacy policy in place and have a real secure set-up from a hosting point of view.

On the other hand why send out a message people can not read because they are protecting themselves from spam, viruses-- and protect yourself from potential legal and network configuration issues. IMHO, HTML email should only be used in an Intranet setting where one can control the message and the client.

I know that this is a hot button issue among the CF talkers out there -- this has been discussed at length on this forum. However, I have seen the reprocussions of a poor network configuration and HTML email.

1 2 >

1 - 100 of 115 matches

Mail list logo