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]
