close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Problem with recordset in Google Maps

Thread began 2/09/2011 12:02 am by bill181745 | Last modified 2/14/2011 9:50 am by Jason Byrnes | 2048 views | 9 replies |

bill181745

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

bill181745

reply

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

Attached Files
webassistFiles.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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
Sign in to reply to this post

bill181745

error

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

Sign in to reply to this post

Jason ByrnesWebAssist

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


rsloc_cmd.CursorLocation = 3
Set rsloc = rsloc_cmd.Execute

Sign in to reply to this post

bill181745

another error

Microsoft VBScript runtime error '800a01b6'

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

/sdthunt/MapGoogle.asp, line 23

Sign in to reply to this post

Jason ByrnesWebAssist

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
%>
Sign in to reply to this post

bill181745

Yahoo!!!

BI JOVE I think you got it.
Hurray!!

Sign in to reply to this post

Jason ByrnesWebAssist

Glad to hear it is working.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...