Thank you for your assistance because I do appreciate the help Virgil Bierschwale http://www.bierschwale.com http://www.bierschwalesolutions.com
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eyvind Axelsen Sent: Wednesday, May 30, 2007 9:56 AM To: ProFox Email List Subject: RE: VFP to XML Virgil, The problem lies in the following line: response.write("<marker>") The "marker" tag should not be closed (with a ">") before you write the attributes. Try something like this instead: while (not oRS.EOF) response.write("<marker ") write attributes here... response.write(" />") oRS.MoveNext() wend Still not nearly fool proof, but better. The attribute values (i.e. the data coming from oRS("svclatitude")) should also be enclosed in quotation marks ("). The result on your webpage is not XML the way most people do it, and while it might work, I wouldn't count on it continuing to do so. The XML DOM object that was mentioned earlier might be a bit harder to understand at first, but it will make your (XML related) life a lot easier when you do. Eyvind. -----Opprinnelig melding----- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne av Virgil Bierschwale Sendt: 30. mai 2007 16:37 Til: 'ProFox Email List' Emne: RE: VFP to XML Agreed.. Problem was the example I sent was just that as I was in the process of making it work. The actual code is listed here. You can see it in action by clicking here --> http://www.virgilslist.com/get1059.asp qry = "SELECT svclatitude, svclongitude, svcrate + ' ' + svcfirstname + ' ' + svclastname AS htmldesc, svcrate + ' ' + svclastname AS labeldesc, 'enlisted' as titledesc from Roster WHERE svcBranch = 'NAVY' " Set oRS = oConn.Execute(qry) oRS.MoveFirst() response.write("<?xml version='1.0' encoding='ISO-8859-1'?>") response.write("<markers>") while (not oRS.EOF) response.write("<marker>") response.write("lat=" & oRS("svclatitude") & " ") response.write("lng=" & oRS("svclongitude") & " ") response.write("html=" & oRS("htmldesc") & " ") response.write("label=" & oRS("labeldesc") & " ") response.write("title=" & oRS("titledesc") & " ") response.write("</marker>") oRS.MoveNext() wend oRS.close() oConn.close() response.write("</markers>") Virgil Bierschwale http://www.bierschwale.com http://www.bierschwalesolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eyvind Axelsen Sent: Wednesday, May 30, 2007 9:34 AM To: ProFox Email List Subject: RE: VFP to XML Virgil, PMFJI, but it seems to me that you should indeed change the code you use to produce your XML. I looked at an example from the site you mentioned, and the xml looks like this: <markers> <marker lat="43.65654" lng="-79.90138" html="Some stuff to display in the<br>First Info Window" label="Marker One" /> <marker lat="43.91892" lng="-78.89231" html="Some stuff to display in the<br>Second Info Window" label="Marker Two" /> <marker lat="43.82589" lng="-79.10040" html="Some stuff to display in the<br>Third Info Window" label="Marker Three" /> </markers> Your code, however, would as far as I can tell produce something like this: <markers> <marker> lat="43.65654" lng="-79.90138" html="Some stuff to display in the<br>First Info Window" label="Marker One" </marker> <marker> lat="43.91892" lng="-78.89231" html="Some stuff to display in the<br>Second Info Window" label="Marker Two" </marker> <marker> lat="43.82589" lng="-79.10040" html="Some stuff to display in the<br>Third Info Window" label="Marker Three" </marker> </markers> The difference is, as you no doubt can tell, that in the first example the lat, lng etc are attributes of the marker tag, while in your code they would be just text enclosed by the tag. Also, the problem with quotes inside the attribute values is a valid concern. Regards, Eyvind. -----Opprinnelig melding----- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne av Virgil Bierschwale Sendt: 30. mai 2007 13:37 Til: 'ProFox Email List' Emne: RE: VFP to XML Yep, I've tried it and I use it. Yep, the place that I found all info at is located at http://www.econym.demon.co.uk/googlemaps/index.htm I'm not going to go tit for tat with you, but I've been in this business quite a long time and one thing that I've learned is that there are a lot of different ways to accomplish the same thing. In other words, there is no right nor wrong way to develop software and to insinuate that only your way is "the way" is beyond belief <grin> As for my financial situation, I currently work at 3 jobs, some paid and some unpaid. I too used to be an arrogant sob making 67.50 per hour as an contractor working 60 plus hour weeks until the work went overseas and I couldn't find anymore. It has humbled me a bit. Lets hope that it doesn't happen to you. Virgil Bierschwale http://www.bierschwale.com http://www.bierschwalesolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derek Kalweit Sent: Tuesday, May 29, 2007 9:38 AM To: ProFox Email List Subject: Re: VFP to XML > As for this not working, have you tried it ? > I'm sure that you will find that it creates the xml file that google map > needs exactly and with minor modification, it will create other xml files. Have **you** tried it? The code you posted creates <marker></marker> elements with text inside it, instead of the xml attributes that Google Maps(and generally XML-enabled applications) utilize. No, I haven't loaded this into Google Maps itself(I don't have your data source to test if I chose to waste my time doing so), but if it works, it's a bug/undocumented 'feature' in Google Maps and you can't expect it to keep working. > I just believe in learning from others mistakes instead of trying to > reinvent the wheel every time. Writing a text file like this is not the generally-accepted best way to write XML files, generally. The more accepted way is a DOM-based XML parser, such as MSXML. Occasionally writing to the text file directly such as you do is useful if you have very large files, but IMO, those aren't a good candidate for xml in the first place. Not all XML files are as primitive as the one you have-- many are multiple levels deep. I'm sorry to hear about your financial woes. Possibly it would be smarter for your financial situation to find a job(any job) to pay some bills instead of doing websites for non-profits, etc.? -- Derek [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.