Re: Lat/Long and Like
Two unrelated questions both pertaining to an XML report I have been working on.
The first relates to latitude and longitude. The main query in my report extracts both sample lat and sample long (as well as a lot of other fields) and the columns section includes statements to output these along with everythinge else. However the final output doesn't include these two fields (everything else is there and the syntax is identical).
Is there something special about these two fields? I want to use them to send the report output to the Recorder mapping tool (among other things).
The second question is about the use of the LIKE operator in a WHERE clause in my XML report.
If I use the standard SQL wildcard character % to denote a string of any characters in a LIKE statement, the XML report falls over reporting something like "No parameter for the object '%'". Presumably the % has some reserved functionality in XML.
I have created my own workaround, by creating a user function to do the LIKE outside the XML report XML, but am I missing something, is there a way to do LIKE with a wildcard in XML?
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre