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

Matthias Kühnle

Matthias Kühnleanswered the question How to handle comma separated field vals via @vars ?

I am sorry for the typo: ...IN @ProjectMembers should be ... IN (@ProjectMembers): CommandText="SELECT [UserID], [Email], [DisplayName] FROM Users WHERE CAST([UserID] AS VARCHAR(MAX)) IN @(ProjectMembers)"

4 days ago

Matthias Kühnle

Matthias Kühnleasked the question: How to handle comma separated field vals via @vars ?

The follwing SELECT gives results when using: CommandText="SELECT [UserID], [Email], [DisplayName] FROM Users WHERE CAST([UserID] AS VARCHAR(MAX)) IN (2,3,5)" but nothing is returned (even no error) when using same SELECT with @var : CommandText="SELECT …

4 days ago

 Mar

Marearned the privilege Create unmoderated replies

Earned the Create unmoderated replies privilege!
Matthias KühnleAnonymousAnonymousand 33 others also earned the privilege Matthias Kühnleand 35 others also earned the privilege

1 week ago

 Mar

Marcreated the topic: Limit Custom Command Button to Administrators

I currently am using the template builder to build a view for a client and trying to limit a xmod:CommandButton to only be visible by DNN users with the role 'Administrators'. The view is visible by all users so we do not want all users to able to …

1 week ago

Matthias Kühnle

Matthias Kühnlecreated the topic: How can I use TOKENs in CommandText?

I created a template from table "ProjectData" and I want to show only the results that match for the current logged in user id -> Example: <ListDataSource CommandText="SELECT [id], [UserID], [field1], [field2] FROM ProjectData WHERE [UserID] = …

3 weeks ago

  • NewestOldestView All Comments4 comment(s)
  • Matthias KühnleHi Kelly, thanks for reply - but your example does not show up above.
    I figured it out. In the params somewhere in the docu says use "'[[token:ID]]'", but the " were "too much" :-).
    Best,
    MAZE3 weeks ago
  • Patrick Ryan[ListDataSource CommandText="... WHERE UserID = @UserID]
    [Parameter Name="UserID" Value='[[User:ID]]' /]
    [/ListDataSource]

    replace square brackets with angle brackets...trying to ensure response isn't stripped.3 weeks ago
  • Kelly FordSorry about the blank example. Patrick has the right of it :)3 weeks ago
Alon Hirsch

Alon Hirschanswered the question Replace DNN login form with XMP custom login form

Thanx Patrick, Much appreciated
Patrick Ryan also answered the question Patrick Ryan also answered the question

1 month ago

Steve Krantzman

Steve Krantzmancreated the topic: Kelly, please gaze into your crystal ball and tell us what you see.

In 2017 I asked the question DNN 9 and the future of XMP . It is now four years later, and I am once again curious about the future of XMP. I am still a strong proponent of XMP, but to be honest, except for a couple of XMP updates to make it compatible …

1 month ago

Alon Hirsch

Alon Hirschearned the privilege Edit own questions, answers, & comments

Earned the Edit own questions, answers, & comments privilege!
Michael VernonAlejandro Quiroga AlsinaCharlie Ioannouand 122 others also earned the privilege Michael Vernonand 124 others also earned the privilege

1 month ago

Alon Hirsch

Alon Hirschasked the question: Is it possible to have a dynamic database connection string?

I need to be able to link logins to different databases (my customer wants each customer to have their own database), but I want to control everything through a central DNN installation. Ideally, I'd like to be able to use some identifier associated …

1 month ago

Alon Hirsch

Alon Hirschasked the question: Replace DNN login form with XMP custom login form

How do I get DNN to use my XMP custom login form instead of the default login form? Under Site Settings, Site Behaviour, I can only specify a Login page that has the normal DNN User Login module on it, not my page that has the XMP login form I created

1 month ago