A
adna
I have an MS access query that I export to an xml file for use in posting
info on our website. It is a hearing schedule for a court, the database has
these 3 fields:
ContactFirstName - First Name of petitioner
ContactLastName - Last Name of petitioner
PartyName -(this is used if there is more than one Contact or it is a
company or business name, in this case ContactFirstName and ContactLastName
is left null)
On the website we list the "Petitioner name", which would contain a
last,first name if there is a single name, or the party name.
I built the PetitonerName field in the query (I cant edit the tables) using
the following if statement:
PetitionerName: IIf([ContactLastName] Is Not Null,[ContactLastName] & ", " &
[ContactFirstName],IIf([ContactLastName]<>"",[ContactLastName] & ", " &
[ContactFirstName],[PartyName]))
Basically, this reads, if contact last name is not empty, use Last Name +
First Name, If it is empty use party Name
That part works fine, and the query results work as inteneded... the problem
is that when I export to the xml, on some of the ones with party name insted
of last,first name, it's like it isn't reading the "PartyName" and I don't
get the data, I get this:
- <PetitionerName>
- <![CDATA[ ,
]]>
</PetitionerName>
On some the ParyName comes through just fine.. and I don't see a difference
in the records...
Any ideas?
info on our website. It is a hearing schedule for a court, the database has
these 3 fields:
ContactFirstName - First Name of petitioner
ContactLastName - Last Name of petitioner
PartyName -(this is used if there is more than one Contact or it is a
company or business name, in this case ContactFirstName and ContactLastName
is left null)
On the website we list the "Petitioner name", which would contain a
last,first name if there is a single name, or the party name.
I built the PetitonerName field in the query (I cant edit the tables) using
the following if statement:
PetitionerName: IIf([ContactLastName] Is Not Null,[ContactLastName] & ", " &
[ContactFirstName],IIf([ContactLastName]<>"",[ContactLastName] & ", " &
[ContactFirstName],[PartyName]))
Basically, this reads, if contact last name is not empty, use Last Name +
First Name, If it is empty use party Name
That part works fine, and the query results work as inteneded... the problem
is that when I export to the xml, on some of the ones with party name insted
of last,first name, it's like it isn't reading the "PartyName" and I don't
get the data, I get this:
- <PetitionerName>
- <![CDATA[ ,
]]>
</PetitionerName>
On some the ParyName comes through just fine.. and I don't see a difference
in the records...
Any ideas?