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

Forum

Forums > DotNetNuke® > Modules
Subject: OWS How to access multiple Datatable results ?
Prev Next
You are not authorized to post a reply.

Author Messages
Bizcom.it
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:8
28 Feb 2010 6:29 PM  
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 Deschenes
DNN Creative Staff
Nuke Active Member
Nuke Active Member
Posts:25
02 Mar 2010 12: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.it
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:8
03 Mar 2010 7:16 PM  
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.
Forums > DotNetNuke® > Modules > OWS How to access multiple Datatable results ?



ActiveForums 3.7

Latest Forum Posts

Request tutorial on accessing websites by darcy
Hello Lee: I am new to DotNetNuke and downloaded the Community Edition yesterday and I am using Vis...
Request Tutorial For Forms and List by Allen6195
If you have already produced a tutorial for Forms and List, would you please let me know where it is...
RE: Skin Header by mcmanta
ok I edited the home.ascx and inner.ascx and uploaded the skin again. thanks for the help.
RE: "Good" hosting providers by jtgreg77
Hello AJ, I can't say anything about the other two hosting providers, but we at PowerDNN have ha...
Where is the tutorial for the Reports Module? by Allen6195
I'm sorry but I can't find a tutorial on the Reports module.  When I do a search for 'Reports module...
RE: calender and events registration module by jncraig
I'm not aware of any.
RE: Missing blog entries by jncraig
I have not seen or heard of that particular problem before.
RE: Module Installation Error by jncraig
In email I suggested that you manually install one of the modules that failed.  See if errors are re...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jncraig
In the file manager, set the permissions so that logged in users (registered users) have write permi...
RE: Module Installation Error by ollep
Thanks for your prompt reply Joe.I tried the logfile yesterday but had problem saving current (today...
RE: Skin Header by WinXnet
You need to add the link to the button. Right now it is just an image - no link at all! open it with...
RE: Skin Header by mcmanta
sure my web site is twinsprucepa.com if you look I have the header in place but when you click the c...
RE: NAV Menu not showing up correctly... by WinXnet
Try putting something in the separator html, like a div with a class you can work with. Also, y...
RE: Missing blog entries by WinXnet
I never use the dnn blog - it always seems to have issues. If possible, you might want to move to a ...
RE: CSS Skin Height Problem by WinXnet
100% height divs are a bit more complicated than it seems it should be. First - what browsers are...
RE: Skin Header by WinXnet
Not sure what you are asking - you should be able to just create an image button link... Then you...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jerimiahpettigrew
How do you make the "my folder" option the only visible option for the profile image upload....inste...
RE: Tab startdate/enddate by brian_strickland
Thanks tons Joseph... I was actually trying to simplify my explanation so I wouldn't over complicat...
Skin Header by mcmanta
Hello All, I have a DNN5 site and my customer has asked me to create a Contact us button and Dire...
RE: Slow login by jncraig
Make sure that you have uninstalled modules that you aren't actually using.  That will reduce the me...
DNM Rapid Application Developer Trial Version
RSS Feeds