This is a "success" ... here is a sample ASP file i used to extract datas from my access database The only pbl i've is that i've 8000 news in the database ... and only 300 news appears ... but it's still good The script works I hope this will help some
IZ.
allnews.asp
<%
Server.ScriptTimeout = 360
xml = "<?xml version=""1.0"" encoding=""utf-8"" ?><content type=""Blog"" version=""03.01.20""><blogs><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[1]]></blogID><childBlogCount><![CDATA[5]]></childBlogCount><created><![CDATA[11/24/2005 10:55:22 AM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[r]]></dateFormat><description><![CDATA[Actualites]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[11/24/2005 5:30:54 PM]]></lastEntry><parentBlogID><![CDATA[-1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[False]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[Actualites]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName></blog><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[2]]></blogID><childBlogCount><![CDATA[0]]></childBlogCount><created><![CDATA[11/24/2005 10:55:22 AM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[g]]></dateFormat><description><![CDATA[Generales]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[11/24/2005 5:28:46 PM]]></lastEntry><parentBlogID><![CDATA[1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[True]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[Generales]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName></blog><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[3]]></blogID><childBlogCount><![CDATA[0]]></childBlogCount><created><![CDATA[11/24/2005 10:55:22 AM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[g]]></dateFormat><description><![CDATA[Logiciels]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[1/1/0001 12:00:00 AM]]></lastEntry><parentBlogID><![CDATA[1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[True]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[Logiciels]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName></blog><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[4]]></blogID><childBlogCount><![CDATA[0]]></childBlogCount><created><![CDATA[11/24/2005 10:55:22 AM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[g]]></dateFormat><description><![CDATA[Administration]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[11/24/2005 10:55:22 AM]]></lastEntry><parentBlogID><![CDATA[1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[True]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[Administration]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName></blog><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[5]]></blogID><childBlogCount><![CDATA[0]]></childBlogCount><created><![CDATA[11/24/2005 10:55:22 AM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[g]]></dateFormat><description><![CDATA[WoW]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[11/24/2005 10:55:22 AM]]></lastEntry><parentBlogID><![CDATA[1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[True]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[WoW]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName></blog><blog><allowAnonymous><![CDATA[True]]></allowAnonymous><allowComments><![CDATA[True]]></allowComments><blogID><![CDATA[6]]></blogID><childBlogCount><![CDATA[0]]></childBlogCount><created><![CDATA[11/24/2005 4:53:33 PM]]></created><culture><![CDATA[en-US]]></culture><dateFormat><![CDATA[r]]></dateFormat><description><![CDATA[News Ancien site]]></description><emailNotification><![CDATA[False]]></emailNotification><lastEntry><![CDATA[11/28/2005 3:54:34 PM]]></lastEntry><parentBlogID><![CDATA[1]]></parentBlogID><portalID><![CDATA[0]]></portalID><public><![CDATA[True]]></public><showFullName><![CDATA[False]]></showFullName><syndicated><![CDATA[True]]></syndicated><syndicateIndependant><![CDATA[True]]></syndicateIndependant><syndicationEmail><![CDATA[]]></syndicationEmail><syndicationURL><![CDATA[]]></syndicationURL><timeZone><![CDATA[2]]></timeZone><title><![CDATA[_News Ancien site]]></title><userFullName><![CDATA[SuperUser Account]]></userFullName><userID><![CDATA[1]]></userID><userName><![CDATA[iznogoud]]></userName><entries>"
Set objconn= server.CreateObject("ADODB.connection")
Set objrec=Server.CreateObject("ADODB.recordset")
objconn.open "izsurfing"
SQL = "SELECT * FROM news ORDER BY id_news DESC"
objrec.ActiveConnection = objconn
objrec.Source = SQL
objrec.CursorType = 0
objrec.CursorLocation = 2
objrec.LockType = 3
objrec.Open()
i = 10
if Not Objrec.eof Then
While not Objrec.eof
i = i + 1
id = objrec("id_news")
source = Server.HTMLEncode(objrec("urlsource1_news"))
source2 = Server.HTMLEncode(objrec("urlsource2_news"))
source3 = Server.HTMLEncode(objrec("urlsource3_news"))
titre = Server.HTMLEncode(ucase(objrec("Titre_News")))
news = Server.HTMLEncode(objrec("libelle_news"))
xml = xml &"<blogEntry>"
xml = xml &"<addedDate><![CDATA[11/28/2005 01:00:00 PM]]></addedDate>"
xml = xml &"<allowComments><![CDATA[True]]></allowComments>"
xml = xml &"<blogID><![CDATA[6]]></blogID>"
xml = xml &"<commentCount><![CDATA[0]]></commentCount>"
xml = xml &"<copyright><![CDATA[]]></copyright>"
xml = xml &"<description><![CDATA[]]></description>"
xml = xml &"<displayCopyright><![CDATA[False]]></displayCopyright>"
xml = xml &"<entry><![CDATA["& news &" <A href=""& source &"">"& source &"</A> <A href=""& source2 &"">"& source2 &"</A> <A href=""& source3 &"">"& source3 &"</A>]]></entry>"
xml = xml &"<entryID><![CDATA["& i &"]]></entryID>"
xml = xml &"<permaLink><![CDATA[http://wwwizsurfingcom.dyndns.org/Default.aspx?tabid=52&EntryID="& i &"]]></permaLink>"
xml = xml &"<published><![CDATA[True]]></published>"
xml = xml &"<title><![CDATA["& titre &"]]></title>"
xml = xml &"<userFullName><![CDATA[SuperUser Account]]></userFullName>"
xml = xml &"<userID><![CDATA[1]]></userID>"
xml = xml &"<userName><![CDATA[iznogoud]]></userName>"
xml = xml &"</blogEntry>"
objrec.movenext
Wend
End If
objrec.close()
xml = xml &"</entries></blog></blogs></content>"
Response.Write xml
%>