InfoPath Dev

Hello Hilary!  It would appear as if you have your signature on every new skill that I try to learn here!  You are very busy! At any rate, is it possible to manipulate just the 'from' on an email?  I have a rule to submit to database/sharepoint/email and it works swimmingly, but I would like to hard code the 'from' ...

I am having the same problem.  How did you solve it?

Sorry to hijack the thread, but I am having a similar issue.  IP 2007 form built on a SQL DB as the main data source and published to a SP forms library.  There are several other secondary data sources connected to the form.  When I run the form from my local machine, no problems.  When I go to the SP forms library and ...

I think that I will be hanging around the forums for a long time to come, and, who knows, I may be able to answer someone else's question someday ;P I think that I am starting to get what you are talking about.  I have a SQL book and a C# book now and by studying a bit, I am getting the hang of it.  Thanks again for all your help, ...

I think that I know the answer to this, but I would like someone to prove me wrong.  I have a form with many repeating tables that have fields that I am promoting to a SP view.  Since the fields are in repeating tables, I have to use 'merge' during promotion in order to get all instances of that filed to display.  The ...

Hilary, you are the Grand Poo Bah Master!  Everything works perfectly!  Thank you so much.  This is going to be a big help.  I hope that there is some way that I can return all of your help.

The code that you are giving me isn't sql is it?  We are using C# to create a dynamic sql query, right?  And that is what I am looking at when I am debugging and do the hover thing - the sql that is.  So if I am guessing correctly, the dynamic query that is created appends the 'where' clause at the end and that is what ...

WOW - I am still marveling at the jargon... OK.  I assume that the first string statement that you included is the one that is already in the original code so I just copied the last 3 lines and pasted them in after that line.  Is that correct?  At any rate, I am still getting the same error.

I set the breakpoint and started to debug.  When it hit the breakpoint, nothing happened.  Do I 'step into'? Here is the sql statement from the data connection: shape  {select ...

Hello again Hilary!  Sorry to resurrect a blast from the past, but I am stuck again.  I have used this bit a couple of times and it has worked like a charm until now.  I created another form and inserted the code with the necessary modifications to point it to the right place and now I am getting a strange error: The query cannot ...