You need to Register for free and Login to post a message in the forum.

Forum

OWS How to access multiple Datatable results ?
Last Post 2010-03-04 01:16 AM by Bizcom.it. 2 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Bizcom.itUser is Offline
Nuke Newbie
Nuke Newbie
Posts:8

--
2010-03-01 12:29 AM  
Hello , in a custom XML query (but it come true also in a standard SQL multiple select statements) the results are mapped to multiple datatables : the statistics debug view can be confirm it. How can I map the 2° , 3° etc table values in the detail template or in any other templating in OWS ? If I write [fieldname] or [fieldname,queryname] I can access only to the first datatable of that query : there is a sintax that permit to access the others? Thanks in advance Roberto
Paul DeschenesUser is Offline
Nuke Active Member
Nuke Active Member
Posts:25

--
2010-03-02 06:00 PM  
Each dataset in a query template is ordered by index number so that if your query template was

Select username from users
Select rolename from roles

you could access the results of both in your detail templates by referencing the first query as 0 and the second as 1

[username,0]


[rolename,1]

Paul Deschenes
DNN Creative OWS Tutor
Subscribe to the website
Bizcom.itUser is Offline
Nuke Newbie
Nuke Newbie
Posts:8

--
2010-03-04 01:16 AM  
Thank you !

This can run only in a Query Template ?

And what about Query[queryname] action ?

in this case the common sintax is

[fieldname,queryname]

How can I access to n-result in a multi result Query action ?

Roberto
You are not authorized to post a reply.

Active Forums 4.3

Latest Forum Posts

Problem After Attaching/Detaching Database.mdf by Prakasam Srinivasan
I successfully installed DNN 6 on my local machine using IIS 7.5. Its working good. When I attach to
RE: Module Security permissions by Bhushan Gholap
Thanks for the reply!!! I would definitely contact sales engineer team of DNN.
RE: There's a tutorial for this somewhere by Eric W
The error I got was the Connection Error(s): Index #: 0 Source: .Net SqlClient Data Provider
RE: DNN 6 Modules Not Showing by Joseph Craig
Where can I see this? If you'd like to send me some login credentials so that I can look, use the c
RE: DNN 6 Modules Not Showing by Mike DeBaise
No, modules are set to all viewers/users. Just cant figure this out, it really doesnt make any sense
RE: Searching in DNN by Alex Ritter
Will do Joseph. I'll let you know my findings.
RE: DNN Blog module syndication by Aggiedan97
The reason I bring it up - Lee had originally provided a tutorial regarding podcast submission to iT
RE: installing DNN locally - problems with relative path by Joseph Craig
Recently I discovered this very useful blog post: http://www.dotnetnuke.com/Resources/Blogs/EntryId
installing DNN locally - problems with relative path by Prakasam Srinivasan
Instead of making tests on my live site, I recently seen various tutorials concerning installing DNN
RE: Moved site to subdomain, now no links work by Joseph Craig
PortalAlias is a table in the DotNetNuke database. Normally you would adjust this on the Site Set
RE: DNN 6 Modules Not Showing by Joseph Craig
Did you also check the module permissions? Are the modules permissions such that only logged in use
RE: Add to the menu with a custom module by Joseph Craig
I can't tell you how to do this, but ... I'd think you could start with a version of the Mega menu i
RE: Where is the Manage Profile default Properties required error message found? by Joseph Craig
You'll find it in one of those resource files you can get at with the Language Editor. I'm not sure
RE: Facebook Like Button by Joseph Craig
You can get the code you need from Facebook and then you can paste it into an HTML module in HTML mo
RE: Module Security permissions by Joseph Craig
Just a thought -- as you are evaluating the Professional version of DotNetNuke, you might want to as
RE: Module Security permissions by Joseph Craig
The module permissions that you mention are for the module: Edit the module's settings, Delete the
RE: Module permission does not work! by Joseph Craig
When you login are you a member of the Administrators security role? I don't believe that you can d
DNN 6 Modules Not Showing by Mike DeBaise
Hello all. I created a skin for DNN 6 and noticed that only while I am logged in can I see the modul
RE: URL login bypass by Joseph Craig
If you want the private page to be protected, you are going to have to have some way of "logging in.
RE: DNN Blog module syndication by Joseph Craig
Sorry. I'm not really familiar with feedburner and I haven't had a chance to research this. While
You are not logged in.
You must log in to access all 
650+ videos, tutorials, podcasts, and more.
RSS Feeds