Code

Re: Track Hyper Link Clicks

Hilary Stoupa — Tue, 19 Mar 2013 21:22:38 GMT

Fantastic - sorry I'd not had a chance to get back to your last post yet.

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 21:19:20 GMT

I got this working finally. Again thanks for all the help that you have been.

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 19:06:08 GMT

so both the QFR_Number and the hyperlink are in the same group. The number is what I am trying to get when the hyperlink is clicked. So if i use the relative path will I be able to get the number that goes with hyperlink that got clicked?

Re: Track Hyper Link Clicks

Hilary Stoupa — Tue, 19 Mar 2013 18:23:50 GMT

Well - you are using an absolute XPath which will get the first one, sure. Is the ID for the hyperlink a field inside the group? Use a relative XPath to get what you need - ../ will take you from the ID to the group (if it is a first level child inside the group - sorry, I've got no idea what your data structure looks like) - so you should be able to do something like e.Context.SelectSingleNode("../my:othernodeinthesamegroup", NamespaceManager)

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 18:17:03 GMT

Ok so that would work but the node that I need isn't actually the same one that gets clicked. It is in the same group but it is the ID of the hyperlink. Is there a way to get that name without doing SelectSingleNode because that just gets the first instance.

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 15:31:59 GMT

Alright I will try to get some time to mess around with it a bit today and report back with my findings. Thanks again for all of your help.

Re: Track Hyper Link Clicks

Hilary Stoupa — Tue, 19 Mar 2013 15:23:57 GMT

Oh - I wasn't suggesting alternate approaches - I think the only way you are going to be able to track clicks on a hyperlink control is via the context changed event. I just haven't run into this particular requirement before. There are other cases for using the context changed event - but again, it just isn't something I've had to deal with very often.

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 14:53:28 GMT

What do you use for a situation like this?

Re: Track Hyper Link Clicks

Hilary Stoupa — Tue, 19 Mar 2013 14:45:59 GMT

Sorry - didn't see your reply yesterday - I don't use the context changed event much - but you should be able to get the name of the node that has changed - looks like e.Context.Name should get you that. You could run your code based on whether the correct node had changed. e.Context is an XPathNavigator - you should be able to get the value you need from there.

Re: Track Hyper Link Clicks

markwitte — Tue, 19 Mar 2013 14:29:35 GMT

Do you have any thoughts on how to cycle through the nodes when I am using the on_ContextChanged?

Re: Track Hyper Link Clicks

markwitte — Mon, 18 Mar 2013 14:49:42 GMT

Yes I am handling this in the on contextchanged event.

Re: Track Hyper Link Clicks

Hilary Stoupa — Fri, 15 Mar 2013 21:06:24 GMT

Yup - I noticed that in your code, figured one thing at a time. Where is your code executing - in the context changed event?

Re: Track Hyper Link Clicks

markwitte — Fri, 15 Mar 2013 20:21:21 GMT

Ok so I got it to insert into the database. YEAH!!!!!! Thank you so much for all of your help with this. One more thing if that is alright. The code that I am using only brings back the first instance of QFR_Number field on the form even when i click the second instance in a repeating section. Is there a way to figure out what "node", or how ever you reference it, is actually clicked? Again thank you so much for your help

Re: Track Hyper Link Clicks

markwitte — Fri, 15 Mar 2013 20:04:22 GMT

Ok so i do have the auto generated ID column set as my PK because the QFR_Number is going to be repeated. From what I read in your post is the only thing that I need to do in my stored proc is to set implicit_transactions off?

Re: Track Hyper Link Clicks

Hilary Stoupa — Fri, 15 Mar 2013 19:56:34 GMT

Here's a blog post of mine from ages ago, and at the bottom you'll see I mention an issue with my stored proc & that Jimmy had made a suggestion that worked for me. Try setting implicit_transactions to off in your stored proc.