OPENXML question

Last Post 03 Dec 2009 10:20 AM by prospec. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
prospec
New Member
New Member

--
03 Dec 2009 10:20 AM
All,
I'm new to the xml world and i'm a bit confused with some openxml syntax. Here's part of the syntax below

from openxml (@idoc,'/cXML/Request/OrderRequest',1)
with (
payload_id varchar(50) '../../@payloadID'
,order_timestamp varchar(50) '../../@timestamp'
,order_date varchar(50) 'OrderRequestHeader/@orderDate'
,po_no varchar(25) 'OrderRequestHeader/@orderID'
,order_type varchar(25) 'OrderRequestHeader/@orderType'
,type varchar(25) 'OrderRequestHeader/@type'
,order_total money 'OrderRequestHeader/Total/Money'
,comment varchar(255) 'OrderRequestHeader/Comments'
,contact varchar(50) 'OrderRequestHeader/Contact/Name'
,email varchar(100) 'OrderRequestHeader/Contact/Email'
)
can anyone tell me what the difference is between an @orderType and Comments? why is one prefixed with the "@" symbol and the other is not?

Thanks
You are not authorized to post a reply.

Acceptable Use Policy