Re: [itsdifferent] AML-XSL problem urgent

Hi norica,

 

I guess you have not analyzed your possible Database structure,as there is one to many relationship between the applicant and reasons,there bound to be redundant data.

 

Samir,

norica gohil <noricagohil@yahoo.co.in> wrote:

Hi thanks for your concern,

The scenario is that an appliaction can be rejected for either one of the reason specified in the reasons table.

A table stores the reason(0 to n) for each appliaction rejected,

THe appliacnts details(ie name appno,adress etc is stored in a diiferebnt table)

Now what i have is the format for the rejection letter to be sent to each applicant , the format for letter is an XSL file stored in another table -(ther are various reports and letters all are stored as XSL)

 

wel from htis i guess u infer my problem,

 

I fetch all appliacnts rejected( a dataset)

Get all reasons for each appliacnt from different table)

 

If i populate both together i will have redundant data in each row and my XSL will fail, its for an indivisual appliacant with multiple reason

 

thanks

Norica

Samir Prabhu <samirsprabhu@yahoo.co.in> wrote:

Hi,

 

In .NET you can create a join based query,populate a dataset and either through default dataset.writeXML() method or by using methods in System.xml namespace format your customized xml comprising the data.

Hope this will help you.

 

Regards,

Samir

norica gohil <noricagohil@yahoo.co.in> wrote:

Hi

Can anyone help me out with this?

 

I have two sets of data (like master Detail) i want to generate both into one as XMl so i can transform with XSl

 

Eg

data1

Appno

Address

Rollno

 

Data2

Appno1,Reason

Appno1,Reason

Appno 1,REason

Appno2,Reason

Appno2,Reason

Appno2,Reason

 

How do i fetch them and merrge to get on XMl as

<candidate>

<Appno1>  </Appno1>

<Address> </Address>

<Rollno></Rollno>

<reasons>

<Reason></Reason>

<Reason></Reason>

<Reason></Reason>

</reasons>

 

</candidate>

 

Thanks,

 

---

Yahoo! India Answers: Share what you know. Learn something new. Click here

---

Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.

---

Yahoo! India Answers: Share what you know. Learn something new. Click here
Send instant messages to your online friends - NOW

---

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators

SPONSORED LINKS

Computer software spy	Automotive computer software	Medical computer software
Computer telephony software	Computer software online training	Computer monitoring software

---

YAHOO! GROUPS LINKS

•  Visit your group "itsdifferent" on the web.
   
•  To unsubscribe from this group, send an email to:
   itsdifferent-unsubscribe@yahoogroups.com
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---