OWS Query Template Results > DotNetNuke Forum, DNN Creative Magazine, Video Tutorials, Skins, Module Reviews

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

Unanswered Active Topics

Forums Search

Forums > DotNetNuke® > Modules

Subject: OWS Query Template Results

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

Vicky Swift
DNN Creative Magazine Subscriber
Nuker

Nuker
Posts:15

05 Mar 2010 6:24 AM

Hi I'm a real newbie at OWS and have been working through the tutorials - I felt confident to have a go myself but have got really stuck on something that I am sure is trivial / obvious. I have a Query template with the following SQL statement on it SELECT FieldTitle,FieldValue,UserDefinedRowID FROM UserDefinedData JOIN UserDefinedFields ON UserDefinedData.UserDefinedFieldID = UserDefinedFields.UserDefinedFieldID WHERE UserDefinedRowID IN (SELECT UserDefinedRowID FROM UserDefinedData JOIN UserDefinedFields ON UserDefinedData.UserDefinedFieldID = UserDefinedFields.UserDefinedFieldID WHERE UserDefinedRowID IN (SELECT UserDefinedRowID FROM UserDefinedData JOIN UserDefinedFields ON UserDefinedData.UserDefinedFieldID = UserDefinedFields.UserDefinedFieldID WHERE FieldTitle = 'Non' AND cast(FieldValue as nvarchar(max)) = 'True' ) AND (FieldTitle = 'MI' AND cast(FieldValue as nvarchar(max)) = 'True') ) AND (FieldTitle = 'Name' OR FieldTitle = 'Link' OR FieldTitle = 'Notes') ORDER BY UserDefinedRowID I then display the results from this using a detail template

[FieldValue]

This works fine. Now I would like to manipulate the way the data is displayed. So for example take the [FieldValue] from several rows of data and display these in one row in the detail template. I have spent a lot of time trying to do this and am going around in circles - can anyone help Thank you

KA-NA
DNN Creative Magazine Subscriber

Nuke Active Member
Posts:29

11 Mar 2010 2:07 AM
I don't know, that is possible, but I would try to use javascript in dteial template to build string and then use it in footer template.

Vicky Swift
DNN Creative Magazine Subscriber
Nuker

Nuker
Posts:15

11 Mar 2010 3:07 AM
Hi, In the end I achieved what I needed with IIF statments and ALTERNATE Pretty sure its not the neatest solution - but it does what I need.

You are not authorized to post a reply.

Forums > DotNetNuke® > Modules > OWS Query Template Results

ActiveForums 3.7

Subscribe to the website - Sign up now for just $79.97 USD per year!

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...

RE: Customising Registration form by jncraig

You might also look at these:How to Create a Portal Signup Module with OWSHow to Create a Custom...

Forum

Latest Forum Posts

Friends

Menu