Leaderboard

Rank Member Pts

Welcome to DNNDev University

DNNDev University LogoJust like a university without the grades and student loan. Think of it more as a merging of the student union and open classrooms. Ask questions, get answers, learn, teach, make friends and contacts.

Find Out More

 

Here's What's Happening on Campus

Kelly Ford

Kelly Fordvoted on Need to join 3 tables in Database

SELECT a.[PatientId], a.[CreatedDate], a.[Gender] b.[LastName], b.[FirstName], b.[DateofBirth], c.Something, d.SomethingElse, e.AnotherSomething
FROM dnn_PreEmploymentScreenPatientPart a
INNER JOIN dnn_AddPatient b ON a.PatientID = b.PatientID
INNER JOIN SomeOtherTable c ON a.PatientID = c.PatientID
INNER JOIN AnotherOne d ON a.PatientID = d.PatientID
INNER JOIN YetAnotherOne e ON a.PatientID = e.PatientID


WHERE a.PatientID = @PatientID

1 day ago

Patrick Ryan

Patrick Ryananswered the question Need to join 3 tables in Database

SELECT a.[PatientId], a.[CreatedDate], a.[Gender] b.[LastName], b.[FirstName], b.[DateofBirth], c.Something, d.SomethingElse, e.AnotherSomething FROM dnn_PreEmploymentScreenPatientPart a INNER JOIN dnn_AddPatient b ON a.PatientID = b.PatientID INNER JOIN …

4 days ago

Special Project

Special Projectearned the privilege Edit any question or answer or comment

Earned the Edit any question or answer or comment privilege!
 SpecialProject VuongLisaand 87 others also earned the privilege  SpecialProjectand 89 others also earned the privilege

5 days ago

Special Project

Special Projectasked the question: Need to join 3 tables in Database

Hi, I need to pull data from 3 different tables in my database. I've written the join to pull data from 2 and that works fine. Here is the fiddle for it. http://dnndev.com/fiddle/fid/740 Can anyone explain to me how to pull data from a 3rd table and how …

5 days ago

Patrick Ryan

Patrick Ryananswered the question Test for Mobile Users

There are for sure ways to do this with Javascript, and probably helpful libraries to make it even easier. My immediate thoughts is to expose both methods and hide/show based on mobile or not, but this would all be client-side logic. This answer is based …

5 days ago

Steve Krantzman

Steve Krantzman added the idea Multiple Tokens for Form Controls with Text-Value Pairs

I would love to see multiple tokens for text-value pair controls such as DropDownList, CheckBoxList, RadioButtonList, DualList... etc. They would look like the following: 1) [[MyControl]] The current default token which returns the control's Value value …

5 days ago

Jeff M.

Jeff M.asked the question: Test for Mobile Users

Hello.. Is there a way for XMP to see if someone is on a mobile device? We're serving up PDF files and 9 out of 10 times, mobile users can't see these files. My thinking is to export these PDF's as JPG files and then in the logic of the XMP template, …

5 days ago

Roy Barrow

Roy Barrowcreated the topic: AddUser function having issues

I have a basic registration form using the usual country/region dropdown lists. The feeds and values are working properly (eg pick US and NC and you get 221 and 279 - or whatever DNN entryID is for those 2) Everything is working fine EXCEPT for the …

1 week ago

  • NewestOldest
  • Patrick RyanFor the hidden textbox, don't use visible="false" because then it's never rendered to the client. Instead use style="display: none". The reason it won't work with feeds with the DDL is security related. If the options in the DDL are not generated from the server then it can only accept on the server values that were there, not dynamically added on the client. 1 week ago
  • Roy BarrowThanks Patrick....as always!!!!1 week ago
  • Patrick Ryan@Roy Barrow Welcome. Remember to validate on the server whatever input is entered... because they could technically unhide that textbox and put anything they want in it.1 week ago
Jen Sharp

Jen Sharpanswered the question Is it possible to add the Moore Creative signature template to an edit form?

Somewhat related question... I'm using this in an AddForm, and using the example, I see how it saves the JSON to a database. However, I need to grab the resulting JSON and add it to a different input field on my page, submitting to a different form. How …

1 week ago

Kelly Ford

Kelly Fordanswered the question Key Field Not Displaying When I Click Dropdown

When working with a DNN DB Table as your data source, the Form Builder uses the "databaseOwner" setting (i.e. schema) that is set for DNN. In this case it looks like that is "dbo". However, your table has a schema of "snathub" so the form builder won't …

1 week ago