Search Again: Re: XML Query From: William Chase Date: Tuesday, February 3, 2004 Time: 11:26:03 am Strange.. It is null for every record for me but I do know that the invoice id is populated. What about the unique key in line items? -----Original Message----- From: Shawn Hogan [mailto:shawn@digitalpoint.com] Sent: Tuesday, February 03, 2004 3:16 PM To: Optigold ISP List Subject: Re: [Optigold ISP] XML Query William Chase wrote: > I am attempting to pull out invoices and line items via XML. The Invoice ID > field is not populating in the line items query. I am sending the > following: > > http://bdc100145:81/FMPro?-db=lineitems_.fp5&-format=-dso_xml&-lay=&-Max=1&i > dentification=200&password=S1rNYWRtaW4NZWFzdGVybg==&-FindAll > > I have also tried using a layout and it still does not populate that field. > Is there a script or something I have to include? > > Also, where are the sales tax lines stored and what is the unique field in > line items? It works for me when I try it... in fact it's the 2nd field I get back in my test... <Identification> 1 </Identification> <Invoice_ID> 26 </Invoice_ID> <Product_ID> DSL </Product_ID> - Shawn ---------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html --------------------------------------------------- --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: XML Query by William Chase on Feb 3, 2004 at 7:13:47 am Re: XML Query by Shawn Hogan on Feb 3, 2004 at 11:16:58 am Re: XML Query by William Chase on Feb 3, 2004 at 11:26:03 am Re: XML Query by Shawn Hogan on Feb 3, 2004 at 11:29:35 am Re: XML Query by William Chase on Feb 3, 2004 at 11:41:49 am Re: XML Query by Shawn Hogan on Feb 3, 2004 at 11:52:49 am Re: XML Query by William Chase on Feb 3, 2004 at 12:50:59 pm Re: XML Query by Faisal Imtiaz on Feb 3, 2004 at 1:08:32 pm Re: XML Query by William Chase on Feb 3, 2004 at 1:14:19 pm