• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

WDDX packet parse error at line 1, column 1. Content is not allowed in prolog..

New Here ,
Nov 26, 2012 Nov 26, 2012

Copy link to clipboard

Copied

We have a CFC page that was working fine before moving to CF9 from CF8.  Any ideas on why it is no longer working?  It is not processing at all now - just giving us this error.

<cfcomponent displayname="Checks For Email Address" output="true" hint="Checks for an Existing Email">

               <cffunction access="remote" name="CheckInData" returntype="boolean" description="Checks Email and Returns True if Email Address Exists" hint="Checks Email and Returns True if Email Address Exists">

               <cfargument name="Email_Check" type="string" required="true"/>

               <cfquery name="data" datasource="datasource" dbtype="OLEDB">

            SELECT                 

                              Email

            FROM                    

                              EmailTable

            WHERE

                              Email=<cfqueryparam value="#Trim(arguments.Email_Check)#" cfsqltype="cf_sql_varchar" />

            AND

                              Company_ID='#company_ID#'

        </cfquery>

        <cfif data.RecordCount EQ 0>

               <cfreturn false>

        <cfelse>

               <cfreturn true>

        </cfif>

    </cffunction>

Views

1.7K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guide ,
Nov 26, 2012 Nov 26, 2012

Copy link to clipboard

Copied

@cover,

I see two things you might change, but I don't know if they will solve the problem.  First, you don't need the "dbtype" attribute anymore with CFQuery, unless it's dbtype="query".  Second, it's possible you have a race condition on your query results variable ("data").  You might add a line right below the CFArgument tag:

<cfset var data = "">

This will make the "data" variable local to the function.

Other than that, I can't see anything obvious.  I'm not at all versed in WDDX, so maybe someone else will have some better ideas.

-Carl V.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 26, 2012 Nov 26, 2012

Copy link to clipboard

Copied

Tried that.  Did not work.  Yep, it is not even running the CFC after the upgrade.  Anyone else with ideas on how to fix and get working again?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Nov 26, 2012 Nov 26, 2012

Copy link to clipboard

Copied

LATEST

Is that cfc attempting to do anything with WDDX?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation