On Jan 30, 6:19 am, Penny Magas <[email protected]> wrote: > I have an Access database that is searchable and the results go to a > new page where I'd like to show a map of the results. I started by > trying to put the javascript within the asp that generated the > results, but I only got one entry on the map (and only 1 map - I > originally thought I could get multiple maps per page.)
You should be able to have multiple maps per page. > > I have since learned that I need to generate xml from the database > results and create the map from that. But I'm having trouble with the > 'loop' in asp. That will work too. > I know just enough asp to be dangerous (and I use > FrontPage database results wizard which to date has served me quite > well.) > > The page with the problem is > here:http://marksellsstlouis.net/analysis/search-by-area9.asp > (use the default search and you'll see the error message.) When I view > the page source (using Firefox), I get this error message: > > Microsoft VBScript runtime error '800a01a8' > Object required: '' > /analysis/area-found-map9.asp, line 168 > > The database results and the loop are as follows: > > <!--#include file="_fpclass/fpdblib.inc"--> > <% > fp_sQry="SELECT * FROM MF2analysis WHERE ([Listing Price]>= ::From:: AND > [Listing Price] <= ::To:: AND [Unit 1-# of Bedrooms] > >= ::Bedrooms:: AND ([Type of Units Desc] LIKE '%::Type2::%') AND > > ([Area Desc] LIKE '%::Area2::%')) ORDER BY [Net Income] DESC,[Listing > Price] DESC" > > fp_sNoRecords="Sorry - no properties match your criteria today. > Please try another search or request a Custom Property Search." > fp_sDataConn="mf2an-map" > fp_iMaxRecords=256 > fp_iCommandType=1 > fp_iPageSize=5 > fp_fTableFormat=False > fp_fMenuFormat=False > fp_sMenuChoice="" > fp_sMenuValue="" > fp_iDisplayCols=33 > fp_fCustomQuery=True > BOTID=0 > fp_iRegion=BOTID > %> > > <% > response.ContentType = "text/xml" > fp_rs.MoveFirst > response.write("<?xml version='1.0' encoding='ISO-8859-1'?>") > response.Write objXmlDoc.xml > response.Write("<data>") > while (not fp_rs.EOF) > response.write("<marker>") > response.Write("<lat>" & fp_rs("latitude") & "</lat>") > response.Write("<lng>" & fp_rs("longitude") & "</lng>") > response.write("</marker>") > response.Write("<addr>" & fp_rs("Address") & "</addr>") > response.Write("<price>" & fp_rs("Listing Price") & "</price>") > fp_rs.MoveNext > wend > response.Write("</data>") > %> > > <!--#include file="_fpclass/fpdbrgn1.inc"--> > <h1><%=FP_FieldVal(fp_rs,"Address")%></h1> > ---content excluded for the sake of brevity--- > <p><%=FP_FieldVal(fp_rs,"Marketing Remarks")%></p> > ---content excluded for the sake of brevity--- > <div style="clear:both;"></div> > <!--#include file="_fpclass/fpdbrgn2.inc"--> > > Line 168 is " fp_rs.MoveFirst" but I believe that the loop is > probably my problem. Can anyone lend me a hand? Thanks so much for any > help you might offer! Where do you create fp_rs? -- Larry > > Regards, > Penny --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
