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?
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?
Please post a link to the page that is not working so we can examine the code.
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.
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;
%>
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.
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!!!
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.
so how do you get it to display the out bounds when the map is pulling up multiple records? Thanks
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.
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.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.