Questions

Json feed returns null instead of empty array []

I am using this feed to return events to an instance of Fullcalendar.io . The code below works perfect as long as even one event is found by the select. But when the select does not find any items/events, the feed returns absolutely nothing. Fullcalender expects an empty array [] in this condition, not null, and so the failure callback shown in the fiddle is returned. I'm attempting to research th

Array feed SQL

0 votes

1 responses

5151 views

Mike O asked Nov 5, 2021 active Nov 5, 2021

Import Excel worksheet through XMod Pro

Hello.. We've had a request to be able to import from an excel worksheet into a DB table. Can this be accomplshed through XMP? Thanks..

excel import SQL

0 votes

4 responses

2883 views

Jeff M. asked Nov 21, 2017 active Nov 1, 2018

Odd errors when attemping to use a Stored Procedure

Hi again, I'm trying to modify a form to trigger a stored procedure upon submit. I have written up a stored procedure and tested it by running the EXEC command from within SQL Management Studio. So it appears to be working. However, after I modified the form to use the stored procedure, I keep getting this error: Procedure or function SP_Contact_Create has too many arguments specified." I've been

SQL stored procedures

0 votes

4 responses

2557 views

David Puffenberger asked Sep 20, 2018 active Sep 21, 2018

External Database Connection String

Hello I am trying to use an external SQL Server Database Table to create a Form and a Template using said external DB table. I have tried several different connection string combos without any luck. I have also tried to find how to do this within the dnndev.com site and through google without any luck finding an answer. Can you all help with this issue.

connectionstring SQL

0 votes

2 responses

2488 views

asked Aug 14, 2018 active Aug 14, 2018

2 SQL Servers connection string

Hi, I had the situation where I had to access 2 separate SQL data sources at once: one of the local DNN and another one form a remote location. How I would connect in that situation? This does not work <SelectCommand ConnectionString="Data Source=externalIP;Initial Catalog=splendid;Persist Security Info=True;User ID=is;Password=pass" "Data Source=.\SQLExpress;Initial Catalog=mindmaster;User ID=is2

connectionstring SQL

0 votes

1 responses

2938 views

Cata asked Feb 6, 2017 active Feb 6, 2017

Getting Good Answers

How do you get good answers to your questions? Ask good questions. That means:

Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples.
Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).