close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

map not showing

Thread began 12/22/2009 2:41 pm by jkulnis244092 | Last modified 12/31/2009 6:09 pm by Eric Mittman | 2017 views | 10 replies |

jkulnis244092

map not showing

giving up. map shows, then if you make a change like the zoom, then it doesnt show. uplaoded the associated files. still nothing. plus, how do you make a one line texxtbox then asubmit button to pan to a location?

Sign in to reply to this post

Jason ByrnesWebAssist

Please post a link to the page that is not working so we can examine the code.

Sign in to reply to this post

jkulnis244092

Map not showing when using Request Querystring

if i use a store procedure or recordset with no frills, pulls all the records, the map will show. But it i try to send a Request.QueryString, a white page is displayed.

Sign in to reply to this post

jkul

stored proc or querystring not working on map

here is the dreamweaver SQL. This one will not work. But if i remove the parameter and let the DB pull all the records, Then it will work. You CAN NOT use a querystring to get the records.
<%
var rsRSet__vState = "Virginia";
if (String(varState) != "undefined" &&
String(varState) != "") {
rsBillBoards__vState = String(varState);
}
%>
<%
var rsRSet_cmd = Server.CreateObject ("ADODB.Command");
rsRSet_cmd.ActiveConnection = MM_HPSQLMAIN_STRING;
rsRSet_cmd.CommandText = "SELECT Lat, Lng, CustBB_ID, Photo1, RSet.Address, Sale, Rent, RSet.States, RSet.Zipcode, Type, Market FROM CustomerInfo, RSet WHERE CustomerID = Cust_ID and RSet.States = ?";
rsRSet_cmd.Prepared = true;
rsRSet_cmd.Parameters.Append(RSet_cmd.CreateParameter("param1", 200, 1, 255, rsRSet__vState)); // adVarChar

var rsRSet = rsRSet_cmd.Execute();
var rsRSet_numRows = 0;
%>

Sign in to reply to this post

jkul

line 265 in wagmp_map11.asp

When using request.querysting or anything but a straight recordset, an error shows for line 265 (the last line of the code) that says, Microsoft OLE DB Provider for SQL Server error '80040e18', Rowset position cannot be restarted. And the actual code for that line is <% rsRecSet.MoveFirst(); %>

Any hints on what to do. thanks.

Sign in to reply to this post

jkul

possible fix

i commented out the last line tha tsaid <% rsRecSet.MoveFirst(); %>
The **** thing works now!!!
So do i get a prize???
PS. I am unempoyed, so i have nothing better to do over these past 3 days than to sit here and figure this out!!!

Sign in to reply to this post

Eric Mittman

The line of code you commented out is there to return the recordset to the first row. This command is not compatible with some types of recordsets. From what I have read it is the ADO Command Objects that use Execute method that create forward only recordsets.

One way to fix this may be to adjust the cursor type for the connection or the recordset. Here is what that code might look like:

Recordset1_cmd.CursorLocation = 3 'ie. client side

You would add this to the rs before the query is executed.

The code that you commented out is only for re-using the rs on the same page, if you do not intent to do this then you can just leave that code commented out without any issues.

Sign in to reply to this post

jkul

bounds of multiple recordset

so how do you get it to display the out bounds when the map is pulling up multiple records? Thanks

Sign in to reply to this post

Eric Mittman

I'm not sure that I understand the question, are you getting all of the locations mapped correctly? The recordset should only need to be gone through once. Each record should return a single location.

Please post back with some more info about the result you are currently getting and how it should be displaying. Also if you have a link to the page with the map on it this may help us understand more about the problem.

Sign in to reply to this post

jkul

outer limits of markers

My typo mistake on the last post, sorry. when you pull up multiple markers from a recordset on the map, it jumps to a specific zoom level based on one marker and you only see that one Default Destination. This happens whether you check the Default Dest check box or not. So is there a way for the map to autozoom to show all the markers that are pulled up? Hope that explains it more.

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...