Priot to making suggestions I urge you to read http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23833298.html
which was part one of my problem.
The Issue now is that I am receiving the above error when I add on to the code below. Microsoft notes only that it has to do with Parameter Mapping if this helps.
rsListings__varPCity = "*"
If (Request("ResiCity") <> "") Then
rsListings__varPCity = Request("ResiCity")
Set rsListings_cmd = Server.CreateObject ("ADODB.Command")
ction = MM_HomeownerServices_STRIN
= "SELECT * FROM TListings WHERE PropertyCity = IIF(? = '*', PropertyCity, ?)"
rsListings_cmd.Prepared = true
m1", 200, 1, 255, rsListings__varPCity) ' adVarChar
m2", 200, 1, 255, rsListings__varPCity) ' adVarChar
Set rsListings = rsListings_cmd.Execute
rsListings_numRows = 0
This works well, but I need to add to this a parameter for counties, like the cities. As well as one for price and for levels. Please see the link and you will have a greater understanding.
When I do this in Dreamweaver, it overwrites the code for parameter 2 in the selct statement. When I put it back manual and change the parameter of the new line to 3, I get this error.
All help appreciated