I'm using this code to display results from a database:

<%
companyname = Request.QueryString( "companyname")





Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=C:mypath\mydatabase.mdb"

quote = "SELECT * FROM Results WHERE company LIKE '%"&
companyname &"%'"

Set quote = Conn.Execute( quote)

if quote.eof then
Response.write("No records found.")
Response.End
end if


%>

The problem I'm having is I'm searching for a company name
and there are more than one record with the same company
name but my results page will only display one record.
Also I'm displaying more fields than just the company
name, but company name is what field is used in the
query. All the fields together are formatted to make up a
quote form. I need this code to display all the records
not just the first one it comes to...and all the other
fields with it. The frontpage database results wizard
does this when you select how many records you want
displayed at one time. If you select 1 then a nav bar is
created at the bottom of the results page to take you to
the next record...this is what I'm trying to
accomplish...but without using the wizard...please help

Hi Stu,

You need to loop through the results, eg

<%
sql="select * from table where company like '%" & companyname & "%'"
set quote = conn.execute(sql)
if not quote.eof then
do until quote.eof
response.write quote(0) & "<BR>"
quote.movenext
loop
else
response.write "no results"
end if
%>

Hopefully that will get you started

--
Cheers,
Jon
Microsoft MVP - FP

"Stu" <(E-Mail Removed)> wrote in message
news:1bed001c45227$bd94e330$(E-Mail Removed)...
> I'm using this code to display results from a database:
>
> <%
> companyname = Request.QueryString( "companyname")
>
>
>
>
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.open "DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=C:mypath\mydatabase.mdb"
>
> quote = "SELECT * FROM Results WHERE company LIKE '%"&
> companyname &"%'"
>
> Set quote = Conn.Execute( quote)
>
> if quote.eof then
> Response.write("No records found.")
> Response.End
> end if
>
>
> %>
>
> The problem I'm having is I'm searching for a company name
> and there are more than one record with the same company
> name but my results page will only display one record.
> Also I'm displaying more fields than just the company
> name, but company name is what field is used in the
> query. All the fields together are formatted to make up a
> quote form. I need this code to display all the records
> not just the first one it comes to...and all the other
> fields with it. The frontpage database results wizard
> does this when you select how many records you want
> displayed at one time. If you select 1 then a nav bar is
> created at the bottom of the results page to take you to
> the next record...this is what I'm trying to
> accomplish...but without using the wizard...please help