here is my next problem...
has anyone got any places i could research this as i am very interested in using this technique more...
<cfloop index ="x" from="1" to="#arraycount#">
��������<cfset data_element_array = ListToArray(Data_Line_Array[x])>
��������<cfset elementarraycount = #ArrayLen(Data_Element_Array)#>
��������
��������<!--- Set the fielddata(column) to an element in the array --->
����������������<cfset tmp_element_1 = '#data_element_array[1]#'>
����������������<!--- all the element in this demo are text string and will
����������������need single quotes around them in order to insert into the database --->
������������������������<cfset element_1 = '#PreserveSingleQuotes(tmp_element_1)#'>
������������������������������������������������
����������������<cfset tmp_element_2 = '#data_element_array[2]#'>
������������������������<cfset element_2 = '#PreserveSingleQuotes(tmp_element_2)#'>
����������������������������������������
����������������<cfset tmp_element_3 = '#data_element_array[3]#'>
������������������������<cfset element_3 = '#PreserveSingleQuotes(tmp_element_3)#'>
<cfset tmp_element_4 = '#data_element_array[4]#'>
������������������������<cfset element_4 = '#PreserveSingleQuotes(tmp_element_4)#'>�����������
������������������������
��������<cfset tmp_element_5 = '#data_element_array[5]#'>
��������<!--- An unprintable character is appearing on the end of these strings.
��Use RemoveChars to remove it --->
��������<cfset new_element_5 = RemoveChars(tmp_element_5, len(tmp_element_5), 1)>
����������������<cfset element_5 = '#PreserveSingleQuotes(new_element_5)#'>
the error that is coming back is this
<x-tad-bigger> The element at position 2 of dimension 1, of array variable "DATA_ELEMENT_ARRAY," cannot be found.
</x-tad-bigger>Which suggests to me that its not picking up the tab as it is looking for a comma, how could i define to look for a tab???
thanks people
Robert Shaw
Online Learning
[EMAIL PROTECTED]
MLC School
Rowley Street
Burwood 2134
Phone: 97471266
Mobile: 0422222515
Fax: 97453254
