Access
i can send you my code:
<%@ LANGUAGE="VBSCRIPT" %>
<%
Dim magazineDB
Dim magazineDBPath
strmagazineDBPath= Server.MapPath("magazine.mdb")
%>
<%
set magazineDB = Server.CreateObject("ADODB.Connection")
magazineDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strmagazineDBPath & ";"
%>
<%
set magazineSet = magazineDB.Execute("select * from storie order by
id desc")
Do While Not magazineSet.EOF
%>
<style>
.titolo{font: 10pt/16pt "arial";
color: #ffffff;
text-align: left;
}
.testo{font: 8pt/10pt "tahoma";
color: #000000;
text-align: justify;
}
</style>
<div id= caso1 style=" position: absolute; top: 10px; left: 20px;
width: 200px">
<table width="180" height="250" bgcolor="#ccc99c">
<tr>
<td width="20"></td>
<td class="titolo"><a href="storie.asp?p_storie_id=<% Response.Write
magazineSet("id") %>&p_storie_tit=<%Response.Write
Server.URLencode(magazineSet("societa"))%>"><b><%= magazineSet
("societa") %></b><br></a></td>
<td width="20"></td>
</tr>
</table>
</div>
<%
magazineSet.MoveNext
Loop
%>
<%
magazineSet.Close
set magazineSet = Nothing
%>
<%
set storiaSet= magazineDB.Execute("select * from storie order by id
asc")
Do While Not storiaSet.EOF
%>
<div id= caso2 style=" position: absolute; top: 10px; left: 205px;
width: 150px">
<table width="150" height="250" bgcolor="#d55500">
<tr>
<td width="20"></td>
<td width="110" align="center"><img src="/image/<%= storiaSet
("photo") %>"</td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td width="110" class="titolo"><b><%= storiaSet("titolare") %
></b></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td width="110" class="testo"><b><%= storiaSet("societa") %></b></td>
<td width="20"></td>
</tr>
<tr>
<td width="20"></td>
<td width="110" class="testo"><%= storiaSet("testo") %></td>
<td width="20"></td>
</tr>
</table>
</div>
<%
storiaSet.MoveNext
Loop
%>
<%
storiaSet.Close
set storiaSet = Nothing
magazineDB.Close
set magazineDB = Nothing
%>
Thank you very very much
Valter
--- In [email protected], "Mischa Kroon"
<[EMAIL PROTECTED]> wrote:
> What is the source that you use without it I can't help you.
>
> ----- Original Message -----
> From: "Valter" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Friday, March 04, 2005 5:11 PM
> Subject: [AspClassicAnyQuestionIsOk] Re: Problem with db
>
>
> >
> >
> > Thank you for your help,
> > actually i am also experiencing another problem, when i run the
> > script it only display the first record.
> > Sorry if I bother you but I really need some help
> > Ty
> > Valter
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.308 / Virus Database: 266.5.7 - Release Date:
3/1/2005
> >
> >
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
