I probably didn't do a very good job of explaining the problem I was having.
In any case, I was able to resolve it by doing two things:
1. I reviewed all of my data connections in InfoPath until I found the one that was returning two fields with the same name of 'siteid.' I had included a table's primary key, siteid, in my SQL ...