The fp_rs is likely created by one of the includes files that FrontPage uses (or that's my assumption - but we know about 'assuming.') I'm afraid that I'm out of my league here - I don't know asp well and I certainly don't know javascript, but I'm trying to make them work together.
I'd originally thought to have one map per entry, but asp generates its code serverside and by the time it gets to javascript it only has the detail for the last entry in it. (Well, the way I wrote it, that's what happened.) This is such an odd 'creature' I've been at a loss as to where to turn. I was hoping that someone here might have worked with it before. Any ideas would be most welcome. Thank you so much for your time. Cheers! On Jan 30, 8:41 am, "[email protected]" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
