-
Hi, Welcome to the Forum!
If you can give the sample XML of you Sharepoint list, and what filter you have on the dropdown, we can give more specific answer.
As per my understanding, you need to add a second condition to your filter with an ''and'' to your first condition.
-
You can send email from code.
Search InfoPath dev forums with ''send email'' as the keyword. There are lot of posts on how to send email from code.
-
Hi,
I think there might be a mistake where you have actually cloned the node, you might be assigning the cloned node instead of cloned node to ''NodeToAppend'' variable. Just look at the code that you have written to clone the node.
-
When the form is still in the OnLoad event, view object is still not created so ''XDocument.View.Window'' will give null reference exception.
Where as ''On context change'' event fires after the View object is created and context is on some node.
-
Hi,
When you submit a form to sharepoint, sharepoint creates an ID for your form, this is a sequesnce number. What we normally in our projects is,
1. Submit the form to sharepoint
2. Get the ID created by sharepoint and set this value in the form. This is done using sharepoint ''_vti_bin/lists.asmx'' webservice.
3. Submit the form to sharepoint ...
-
Hi Brian,
Welcome to the Forum!
You need add second repeating node as a child to the first one.
If you have already done that then Drop you first repeating section into the UI first and then add your second repeating section directly into the first one.
Please post back if this does not solve your problem.
Agni
INFOPATHdev India
-
Hi,
Try this XPath you should be able to get all the child nodes with it.
node.selectNodes(''descendant::*'');
then loop through these nodes and output those values where ever you want.
Agni
INFOPATHdev India
-
Hi,
You are using single quote in the query string, database thinks single quote as a starting of the string.
You need to escape single quote with one extra single quote then it should work.
So your query should be
SELECT distinct FullName
FROM bi_employee
AS FullName
WHERE LogonName=N''blah''
ORDER BY ''FullName''
Agni
INFOPATHdev India
-
Hi,
Try the following queries they might help you out
Dataconnection query
SELECT DISTINCT
CASE isActive
when 1 then 'yes'
when 0 then 'no'
else 'unknown'
end AS isActive
FROM [dbo].[Members] as Members
and your code query should look like
''SELECT DISTINCT '' +
'' CASE '' + column +
'' WHEN 0 THEN ''' + c0 + ''''' +
'' WHEN 1 ...
-
Hi Cory,
I don't expect InfoPath to do any kind of randomness to dropdown values.
One thing that you can try and look is, how does your values from database look in the XML? To look at the data, just place the data from DB in the UI as repeating nodes and check out the order of the data in the UI. Now compare these values and the values in the ...