Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Specific XML results per text box

Status
Not open for further replies.

bronxjester

Technical User
Jan 10, 2006
4
US
Hi everyone,

I have started working on a project to import data into quark (version 6.1 Windows) via XML.

The XML data is generated from an Access 2003 database (see sample below)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dataroot SYSTEM "prices III rev6.dtd">
<dataroot>
<prices>
<number>AL2910 </number>
<unit_price>1.21</unit_price>
</prices>
<prices>
<number>AL2911 </number>
<unit_price>2.41</unit_price>
</prices>

In addition I created a DTD that appears to work (see below)

<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT dataroot (prices+)>
<!ELEMENT prices (number,unit_price)>
<!ELEMENT number (#PCDATA)>
<!ELEMENT unit_price (#PCDATA)>

My goal is to update sku prices in my catalog. The layout basically follows this format:

One picture per sku
Under each picture is a text box (or two)that shows sku
number and cost.

When I use the placeholders to populate the text boxes, I get a list of every sku and unit price. I need to have each box return one specific sku and its corresponding unit price for each picture.

Can anyone point me in the right direction?? Thank you in advace for your time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top