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]
