Problem with recordset in Google Maps

I am trying to get multiple markers from a recordset using google maps. They show up perfectly when I take out the Request.QueryString and put in a static number for the ID. But when using dreamweaver with asp and setting up the recordset with the Request.QueryString ID with more than one record the map will not show up.
In testing out the map I can get all of the markers for the whole database to render on the map, but as soon as I put in a query I get a blank map. I have updated each instance of wagmp_map_?.asp each time a change is made.
Have any solution for this challenge?

Thanks

Bill

Please send a copy of your page and the google_javascrpt folder in a zip archive as well as a link where i can see the problem to investigate the cause.

Jason, thanks for the reply.
Here is the link singleResults.asp?huntID=58
Click on the word map in the lower right section of the page, that is the link that is suppose to produce all of the markers on the map, in this case 9.

Thanks Bill

change the following line of code:

Set rsloc_cmd = Server.CreateObject ("ADODB.Command")

to:

Set rsloc_cmd = Server.CreateObject ("ADODB.Command")
rsloc_cmd.CursorLocation = 3

Jason, this is the error that appears when executing the procedure.

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'CursorLocation'

/sdthunt/MapGoogle.asp, line 16

try moving that line down, so it just before the Execute statement instead;


rsloc_cmd.CursorLocation = 3
Set rsloc = rsloc_cmd.Execute

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'CursorLocation'

/sdthunt/MapGoogle.asp, line 23

strange, ok, lets try another tack.

instead of adding the rsloc_cmd.CursorLocation = 3 line, change this code in the wagmp_map_11.asp file:

<% rsloc.MoveFirst() %>

to:

<%
rsloc.Close()
Set rsloc = rsloc_cmd.Execute
%>

BI JOVE I think you got it.
Hurray!!

Glad to hear it is working.