This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C050E0.AB9A38A2
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
I am trying to insert a 2 dimensional array into a table. However, the
array does not have any fieldnames
This is what it looks like
session.array[1][1]: "record1text1"
session.array[1][2]: "record1text2"
session.array[1][3]: "record1text3"
session.array[1][4]: "record1text4"
session.array[1][5]: "record1text5"
session.array[1][6]: "record1text6"
session.array[2][1]: "record2text1"
session.array[2][2]: "record2text2"
session.array[2][3]: "record2text3"
session.array[2][4]: "record2text4"
session.array[2][5]: "record2text5"
session.array[2][6]: "record2text6"
This should be inserted into datasource="p2plan" tablename "materials"
and the fields should correspond as follows:
field1 = session.array[i][1]
field2 = session.array[i][2]
field3 = session.array[i][3]
field4 = session.array[i][4]
field5 = session.array[i][5]
field6 = session.array[i][6]
I thought about doing a <cfloop> with a <cfinsert> based on the index=i but
how do I match each field with its respective text?
Thanks for your help,
Fernando Parra
------_=_NextPart_001_01C050E0.AB9A38A2
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=003585121-17112000>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=003585121-17112000></SPAN></FONT> </DIV>
<DIV><SPAN class=003585121-17112000><FONT face=Arial><FONT size=2>I am trying to
insert a 2 dimensional array into a table. <SPAN
class=025340022-17112000>However, the <FONT face=Arial size=2><SPAN
class=003585121-17112000>array does not have any
fieldnames</SPAN></FONT></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=003585121-17112000></SPAN><SPAN
class=003585121-17112000></SPAN><FONT face=Arial size=2><SPAN
class=003585121-17112000><SPAN class=025340022-17112000>This is what it looks
like</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=003585121-17112000>session.array[1][1]: "<SPAN
class=025340022-17112000>record1</SPAN>text<SPAN
class=025340022-17112000>1</SPAN>"</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=003585121-17112000>session.array[1][2]: "<SPAN
class=025340022-17112000>record1</SPAN>text2"</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=003585121-17112000>session.array[1][3]: "<SPAN
class=025340022-17112000>record1</SPAN>text3"</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=003585121-17112000>session.array[1][4]: "<SPAN
class=025340022-17112000>record1</SPAN>text4"</SPAN></SPAN></FONT></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[1][5]: <SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record1</SPAN>text5"</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[1][6]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record1</SPAN>text6"
</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=003585121-17112000></SPAN></FONT> </DIV>
<DIV><SPAN class=003585121-17112000>
<DIV><SPAN class=003585121-17112000><FONT face=Arial><FONT
size=2>session.array[2][1]:<SPAN class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text1"</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[2][2]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text2"</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[2][3]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text3"
</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[2][4]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text4"</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[2][5]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text5"</SPAN></FONT></FONT></SPAN></SPAN></DIV>
<DIV><SPAN class=003585121-17112000><SPAN class=003585121-17112000><FONT
face=Arial><FONT size=2>session.array[2][6]:<SPAN
class=025340022-17112000> "<SPAN
class=025340022-17112000>record2</SPAN>text6"
</SPAN></FONT></FONT></SPAN></SPAN></DIV></SPAN></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=003585121-17112000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>This should be inserted into datasource="p2plan"
tablename "materials"</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>and the fields should correspond as
follows:</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>field1 =
session.array[i][1]</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>field2 =
session.array[i][2]</SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=003585121-17112000><SPAN class=025340022-17112000>field3 =
session.array[i][3]</SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=003585121-17112000><SPAN class=025340022-17112000>field4 =
session.array[i][4]</SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>field5 =
session.array[i][5]</SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>field6 =
session.array[i][6]</SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000><SPAN class=003585121-17112000><SPAN
class=025340022-17112000></SPAN></SPAN></SPAN></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>I thought about doing a <cfloop> with a
<cfinsert> based on the index=i but how do I match each field with its
respective text?</SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003585121-17112000><SPAN
class=025340022-17112000><SPAN class=003585121-17112000><SPAN
class=025340022-17112000>Thanks for your
help,</SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<P><FONT face=Arial size=2>Fernando Parra</FONT> <BR></P></BODY></HTML>
------_=_NextPart_001_01C050E0.AB9A38A2--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
