Cheers,
barneyb
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 2:37 PM
> To: CF-Talk
> Subject: Re: CFC 2 XML - ERROR: Whitespace required before attributes
>
> I've tried all these suggestions and here's what the code
> look like now.
>
> NEW ERROR:
> Illegal character or entity reference syntax.
> Illegal character or entity reference syntax.
>
> The error occurred in
> D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23
>
> 21 :
> <MotorSportsFlag>#MotorSportsFlag#</MotorSportsFlag>
> 22 : </partno>
> 23 : </cfoutput>
> 24 : </dbtable>
> 25 : </cfxml>
>
> CODE:
> <cfquery name="getinfo" datasource="datasource">
> Select partno, shortdesc, longdesc, pic, manf, promos,
> dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag
> from inventory
> </cfquery>
>
> <cfxml variable="inventoryXML">
> <dbtable name="Inventory">
> <cfoutput query="getinfo">
> <partno id="#partno#">
> <shortdesc>#shortdesc#</shortdesc>
> <longdesc>#longdesc#</longdesc>
> <pic>#pic#</pic>
> <manf>#manf#</manf>
> <promos>#promos#</promos>
> <dateAdded>#dateAdded#</dateAdded>
> <ManHand>#ManHand#</ManHand>
> <OverSized>#OverSized#</OverSized>
>
> <FreightItem>#FreightItem#</FreightItem>
>
> <MotorSportsFlag>#MotorSportsFlag#</MotorSportsFlag>
> </partno>
> </cfoutput>
> </dbtable>
> </cfxml>
>
> <cfdump var=#inventoryXML#>
>
> <cffile action="" output="#tostring(inventoryXML)#"
> file="C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml">
>
>
>
> >If you are going to have attributes in your XML they have to be like:
> >
> > <part_no id="#partno#">
> >
> > <shortdesc>#shortdesc#</shortdesc>
> >
> > </part_no>
> >
> >
> >
> >Ben
> >
> >
> >
> >-----Original Message-----
> >From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> >
> >Sent: Monday, May 10, 2004 4:39 PM
> >To: CF-Talk
> >Subject: CFC 2 XML - ERROR: Whitespace required before attributes
> >
> >
> >
> >I Does anyone know anything about this error. I can't figure it out.
> >Here's my
> >code.
> >
> ><CFQUERY name="get_info" datasource="#datasource#" maxrows="10">
> >Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded,
> >ManHand, OverSized, FreightItem, MotorSportsFlag
> >from inventory
> ></CFQUERY>
> ><CFXML variable="inventoryXML">
> ><dbtable name="Inventory">
> ><CFOUTPUT query="get_info">
> ><partno_id="#partno#">
> ><shortdesc>#shortdesc#</shortdesc>
> ><longdesc>#longdesc#</longdesc>
> ><pic>#pic#</pic>
> ><manf>#manf#</manf>
> ><promos>#promos#</promos>
> ><dateadded>#dateadded#</dateadded>
> ><Manhand>#Manhand#</Manhand>
> ><OverSized>#OverSized#</OverSized>
> ><FreightItem>#FreightItem#</FreightItem>
> ><MotorSportsFlag>#MotorSportsFlag#</MotorSportsFlag>
> ></partno_id>
> ></CFOUTPUT>
> ></dbtable>
> ></CFXML>
> ><CFDUMP var=#inventoryXML#>
> ><CFFILE action="" output="#tostring(inventoryXML)#"
> >file="C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml">
> >
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
