This content has been marked as final. Show 4 replies
Set rsSearchResult = Server.CreateObject("ADODB.Recordset")
rsSearchResult.ActiveConnection = MM_conn_STRING
rsSearchResult.Source = "SELECT SupplierName, ContactName, FamilyName FROM tblone WHERE Timber LIKE '%" + Replace(rsSearchResult__MMColParam, "'", "''") + "%' AND Category LIKE '%" + Replace(rsSearchResult__MMColParam2, "'", "''") + "%' AND Location LIKE '%" + Replace(rsSearchResult__MMColParam3, "'", "''") + "%' AND Customer = 'Trade/Retail' ORDER BY Category, Timber ASC"
rsSearchResult.CursorType = 0
rsSearchResult.CursorLocation = 2
rsSearchResult.LockType = 1
rsSearchResult_numRows = 0
Ampersands need to be escaped. You can use the built-in Server.URLEncode to
escape all characters that might cause problems parsing the resulting URL
when you're building your link.
"Mal9" <email@example.com> wrote in message
> Hi there, I have been trying to figure out why this message has been
> coming up
> for days.
> ADODB.Field error '800a0bcd'
> Either BOF or EOF is True, or the current record has been deleted.
> operation requires a current record.
> /html/product.asp, line 276
> Which reads
> Code: <%=(rsSupplier.Fields.Item("Supplier").Value)%>
> I have just discovered that all the entries with a "&" in it come up with
> The data is in the database for sure.
> Is it something to do with the database or is it my poor coding.