Questions

Questions Filter:
All Unanswered Answered My Questions My Answers
Tag Filter:

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
parameterWHERE IN
0 votes
3 responses
2005 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?
AddFormAddLinkparameter
0 votes
1 responses
2339 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
databoundListBoxparameterstored procedure
0 votes
1 responses
2288 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
missingparameterstored procedure
0 votes
2 responses
4213 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
parameterredirect
0 votes
1 responses
2440 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:

  1. Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  2. 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.
  3. 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. 
  4. 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).