Yes ! I just solve it, the top ten is working beside the list of all authors liked to their articles.
Thanks a lot, you've done grate help and you deserve the star [thumbsup2]
I'll start new threat for formating my list in more than one column.
Adel
...the code I'm trying in to display a full list of author names in more than one column.
<!--#include file=conn.inc -->
<%
selectnewsSQL="select * from authors"
set rsnews=ADO.execute(selectnewsSQL)
%>
<%
count = 0
mymod = 0
do while not rsnews.eof
mymod = count mod 2
%>
<DIV...
1. Still shows the result in one column
2. Example of No.2:
The latest articles:
1. Article 1 title
2. Article 2 title
3.
.
.
10
List Of authors:
1. Author 1 name
2. Author 2 name
.
Adel
Ok .. for No. 2 I mean I want to disply on upper pert the last ten articles has been added on, and then under this on the same page, a full list of all authors.
Adel
Sorry for being too long, but I really learned a lot from this.
1. This code display the same result as before, means one column, although I tried to change the count and mod values.
2. Yes it shows the latest 10 had been added, but without full authors list?
Adel
...page authors.asp (the code is down).
2. Where to put SQL statement .. This is the code:
<!--#include file=conn.inc -->
<%
selectnewsSQL="select * from authors"
set rsnews=ADO.execute(selectnewsSQL)
%>
<%
do while not rsnews.eof
%>
<table>
<tr>
<td><%=rs("authorId")%></td>
<td><a...
More questions .. ok I have 2:
1. For authors or articles pages the result is displayed in one column on the table I've created. Can I display it in 2 or more columns?
2. Above the authors list I want to show only the last ten aricles had been added recently (I think SQL statement).
Thanks in...
Yes DotNetGnat you are right, Thanks. Suppose an author has no article and is listed on the database can you wright IF statement to display a friendly message.
Adel
...the problem is when I click on any author the same list is displayed.
authors.asp code is:
<!--#include file=conn.inc -->
<%
selectnewsSQL="select * from authors"
set rsnews=ADO.execute(selectnewsSQL)
%>
<%
do while not rsnews.eof
%>
<a...
Well done, you’ve done it! It’s a big help I appreciate your time and effort. Then the error was with the quotation mark because the authored type was string.
Thanks a lot.
[thumbsup2]
Adel
Good try DotNetGnat. At least we moved a step forward. Because I stored authorID as string, when I used:
selectnewsSQL="select * from articles, authors where authors.authorID=articles.authorID AND authors.authorID='1' "
I can disply authorID=1 details. But when I tried to use:
where...
...file=conn.asp -->
<%
SET rsnews= Server.CreateObject("ADODB.RECORDSET")
Authorid=request.querystring("Authorid")
selectnewsSQL="select * from authors"
set rsnews=ADO.execute(selectnewsSQL)
%>
<%=rsnews("name")%>
<%
ADO.close
Set ADO=Nothing
%>
That's working fine. But when I add second...
Do you mean the connection file? Yes off course
It's as foloows:
<%
Dim ConnectionString
Dim ADO
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("../db/mydb.mdb")
Set ADO=Server.CreateObject("ADODB.Connection")
ADO.ConnectionString =ConnectionString...
This's my full code:
<%
Authorid=request.querystring("Authorid")
selectnewsSQL="select * from authors, articles where authors.authorid=articles.authorid AND authors.authorid=" & authorid
set rsnews=ADO.execute(selectnewsSQL)
%>
<%=rsnews("title")%>
<%=rsnews("Name")%>
<%=rsnews("body")%>
<%...
I've copyed and paste it on my page with a correction. DotNetGnat typed authorid: authored. So my code as follows:
selectnewsSQL="select * from authors, articles where authors.authorID=articles.authorID AND authors.authorID=" & authorID
But even though I received this error message on that...
...any other you can see a list of all articles belong to him/her (articles.asp).
authors.asp is working and this the code:
<%
selectnewsSQL="select * from authors"
set rsnews=ADO.execute(selectnewsSQL)
%>
<%
do while not rsnews.eof
%>
<a...
Bill Gates isn't Arab ! so, the Arabic language's still not strong enough. In your case I'm not sure this time, but I think as the data you've entered earlier was unrecognized by the code page (courrepted), I'm afraid to say that you need to re-enter your data again. You can use copy+paste to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.