Questions

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

Form SelectCommand Stored Procedure Parameters not working

In an AddForm I am unable to call a stored procedure in a Select Command as commandtype="storedprocedure" as follows: <SelectCommand CommandText="GetAddCodeChangeDefaults" CommandType="StoredProcedure" ConnectionString="*" > <Parameter Name="LoggedOnUserID" Value='[[User:ID]]' DataType="Int32" Size="100"/> </SelectCommand> The above throws an error stating that the Parameter was not supplied. I ha
parameterSelectCommandstoredprocedure
0 votes
3 responses
2819 views
Phillip Austin asked Jul 10, 2014 active Dec 22, 2016

(NoItemsTemplate) or (xmod:Select) for (AddForm)?

I’ve got a scenario where an (AddForm) is used with a (SelectCommand) returning a single (1) row to populate some “defaults”. It’s possible that the SelectCommand could return zero (0) rows. In that case I’d like XMP to render different HTML in a similar manor as (NoItemsTemplate) or (xmod:Select) in a template. The (Panel) tag would work if it had say a “ShowIf” attribute like it has a “ShowRoles
AddFormnoitemstemplatePanelSelectCommandxmod:select
0 votes
2 responses
2551 views
James Allen Hall asked Nov 8, 2015 active Nov 9, 2015

Using [[Field]] Tokens in Your Form does not appear to work as documented.

"Beginning in version 1.3, XMod Pro now supports the ability to use data from your <|SelectCommand|> in the attributes of your form controls.This allows you to retrieve values from your database or from passed-in parameters or hard-coded values in your forms to further enhance their dynamic nature. For instance, if a customer is ordering a product, your <|SelectCommand|> can look that product up i
field tokensSelectCommand
0 votes
2 responses
1732 views
James Allen Hall asked Nov 20, 2014 active Nov 20, 2014

Two select commands in one form?

<SelectCommand CommandText="Select @portalid as PortalID"> <parameter name="portalid" value='[[Portal:ID]]' /> <parameter name="portalname" value='[[Portal:ID]]' /> </SelectCommand> <SelectCommand CommandText="Select [PortalName] FROM PortalLocalization"> <Parameter name="PortalName" Value='[[PortalName]]' </SelectCommand> <strong>Portal Id:</strong> [[PortalId]] <br/> <strong>Portal Name:</strong
SelectCommand
0 votes
2 responses
1703 views
Bob Veale asked Aug 4, 2014 active Aug 4, 2014

SelectCommand DataField not available in Email?

Answer Accepted
It seems DataFields which are in the SelectCommand on an AddForm are not available in the Email template. Is this correct? Is it only DataFields which are in the SubmitCommand? Is it possible to use data from a Variable in the email? Basically I need some data which is not in the submit command in my email! Thanks
AddFormemailSelectCommand
0 votes
2 responses
1746 views
Jax UK asked Feb 6, 2014 active Mar 13, 2014

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