Skip to main content
A
Anonymous
June 9, 2008
Answered

csv array with gaps

  • June 9, 2008
  • 2 replies
  • 724 views
I am inserting a csv into a table, but some of the csv "fields" are empty and need to be NULL so that it can move on to the next field. I've tried creating a cfparam with a default of "" but that doesnt work. not sure where to head now... the code works perfectly fine until there is an empty field.

any help here?
thanks.
    This topic has been closed for replies.
    Correct answer elDonrico
    Actually, now that i have tweaked it alittle, it is still just skipping over the blank areas. since i am using cf7, i cannot use the includeEmptyFields parameter. does anyone know how to do this without the parameter.

    Thanks.
    Try just using this.

    2 replies

    D
    Dan_Bracuk
    Inspiring
    June 13, 2008
    I approach these matters a bit more methodically. First, for every field that is allowed to be null, I'll do something like this:

    if (something)
    FieldxNull = true;
    else
    FieldxNull = false;

    Then when I get to the query, I do this
    <cfqueryparm null="#FieldxNull#">
    K
    Kronin555
    Participating Frequently
    June 9, 2008
    Replace this:
    <cfloop index="csvCell" list="#csvRecord#" delimiters=",">
    <cfset csvArray[variables.csvCellCount] = csvCell>
    <cfset csvCellCount = csvCellCount + 1>
    </cfloop>

    with this:
    <cfset csvArray = ListToArray(csvCell,",",true)>
    <cfset csvCellCount = ArrayLen(csvArray)>

    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_l_21.html#131626
    A
    Anonymous
    June 10, 2008
    I'm sorry i should have described my situation more clearly. I am using CF7 which ListToArray only takes 1 or 2 parameters. I tried doing ListToArray(csvCell,",")> But, i get the following error in the log...

    quote:
    Complex object types cannot be converted to simple values.The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. <p> The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a &lt;CFIF&gt; tag. This was possible in ColdFusion 2.0 but creates an error in later versions.
    A
    Anonymous
    June 10, 2008
    Actually, now that i have tweaked it alittle, it is still just skipping over the blank areas. since i am using cf7, i cannot use the includeEmptyFields parameter. does anyone know how to do this without the parameter.

    Thanks.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices