You have a current application written in Classic ASP, and you want to add to it?
Where do you want the search button, and how do you want the results displayed?
If you already have an ASP app set...

You include it exactly the same as you would in an html file. An aspx file is still markup, just like html, and normal markup tags are allowed in addition to special aspx tags.
So,
<script...

The best way, in my opinion, is to use their API that they created just for such a task.
Here is a link to it and their instructions....

Can you clarify?
You can set a form to target google search as easily as any other page using the action. This would be the same as the user going to google and typing in a search term.
If you want...

You take out the relevant javascript portions and save it as a .js file, then include it like any other javascript file in your aspx source.

Lots of ways, depending on what you're doing and what your goal is. It's called "paging".
http://www.google.com/search?sourceid=navclient-ff&ie=UTF-8&rls=GGGL,GGGL:2006-42,GGGL:en&q=asp+paging

If...

Oh, and since it's a query, not a stored procedure, I don't use execute. I use open, which means I can get a record count if I want. You can't do that with execute.

Here's another example from...

Well, when I expect only one match, I test only for EOF, not BOF.

i.e.

Set rs = Server.CreateObject("ADODB.recordset")
rs.Open strSQL, objSpecs, adOpenStatic, adLockReadOnly, 1

if rs.EOF...

You make code to accept page number in the URL then use the links to pass the page number in the URL.

You don't have an On Error Resume Next in that code anywhere, do you?

You can try that, but it's better to troubleshoot the real problem.
We had a problem with some newlines hiding in our text fields; for some reason, when we edited, and hit enter to go to the next...

Is that a text field?
If not, remove the single quotes around the value.
If so, check that there are no "hidden" spaces or tabs in the actual DB values.

I have never managed to find a good way to debug classic ASP, and always end up with either text to a log file, or response.write all over the place for tracing.

What's the error message?

Random:

SQL Server:
SELECT TOP 5 name FROM tblfriends
ORDER BY RAND()

MySQL:
SELECT name FROM tblfriends
ORDER BY RANDOM() LIMIT 5

Here is an example using Northwind.


<%

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "provider=sqloledb;server=xx.xx.xx.xx;initial catalog=northwind;user...

Can you clarify your question please?

This might help.
http://www.brettb.com/ASPMultiSelectInputBoxes.asp