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;
%>