Questions

Passing string parameter to SELECT statement using WHERE IN

I need to pass a string value into a template that uses a SELECT statement and needs multiple values. So, I'm using WHERE column_name IN ('xxxxx','xxxxx') ... that's all fine when it is hard coded in. But the parameter needs to be that string inside those parentheses. This seems to be a matter of using quotes, double quotes, two single quotes to escape a single quote, etc. But I cannot get the par

parameter WHERE IN

0 votes

3 responses

2296 views

Jen Sharp asked Dec 20, 2019 active Dec 20, 2019

How to reference parameter sent by add link

What is the proper syntax to reference a parameter (which is a foreign key id) in the add form which was sent by the add link?

AddForm AddLink parameter

0 votes

4 responses

2642 views

Dana Armstrong asked Apr 4, 2019 active Apr 9, 2019

ListBox pass parameter to form submit command as stored procedure

http://dnndev.com/fiddle/fid/737 All, I get an error however way I try and pass the listbox strings to the stored procedure. Can some one give the correct format to do this? -Error MESSAGE: Incorrect syntax near ')'.; ADDITIONAL INFO....List2:; List1:; FK_ID:5462; BYID:1; STACK TRACE: at KnowBetter.XModPro.FormFunctions.AddButtonClicked(XItem& xi) at KnowBetter.XModPro.XModPro.frmAddRecord_Add

databound ListBox parameter stored procedure

0 votes

1 responses

2522 views

Paul.Buckley asked Dec 20, 2018 active Dec 20, 2018

Procedure or function expects parameter, which was not supplied.

Getting this error: "Procedure or function expects parameter '@disasterID', which was not supplied." See below for the fiddle of code, etc. Have profiler running which shows what XMP is sending to SQL; neither of these work and I get the same error. If I manually execute the stored procedure, enter the variables, everything works fine. Any ideas? http://dnndev.com/fiddle/fid/708

missing parameter stored procedure

0 votes

3 responses

4449 views

Jeff M. asked Jun 7, 2018 active Jun 13, 2018

GET or POST parameters - any flaws in this method?

Simple thing, and I think I have it solved. Posting here in case (1) there are any gaps that I haven't thought of or (2) it might help someone else. I have an existing page that is the catch-all manager screen for an issue-tracking system. So anywhere an issue can appear on any other page, it contains a <xmod:redirect method="Post" ... > link so the user can jump to this page. Except then I was as

parameter redirect

0 votes

1 responses

2739 views

Myron Weber asked Mar 28, 2018 active Mar 29, 2018

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