PDA

View Full Version : help on script



ghostme
04-26-2007, 05:19 PM
Hello good pple of the forum i need to modify a particular script on DD which is pause up -down scrolling script. What i want to do is to integrate it with my access database. displaying the records as the database is inserted or updated. The problem i am having is displaying all the database in the scroller at once. What i am doing now is displaying the records using an array,however the way i am doing this limits the number of records to be displayed. Also, sometimes the content in the database comes in single and double how can escape both at once. Cheers


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>

<%
Dim conn,rs,sql_select,data_source
set conn=server.CreateObject("ADODB.CONNECTION")
set rs=server.CreateObject("adodb.recordset")
data_source="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("db\test.mdb")
conn.open data_source
sql_select="SELECT * FROM coursequestion_getconnected"
rs.open sql_select,conn,3,1

dim v(1)
dim i
do until rs.eof
v(i)=rs("coursequest")
i=i+1
rs.movenext:loop
%>
<script>
var pausecontent2=new Array()
pausecontent2[0]="<%=v(0)%>"
pausecontent2[1]="<%=v(1)%>"
</script>
</head>
<body>
<script type="text/javascript">
//new pausescroller(name_of_message_array, CSS_ID, CSS_classname, pause_in_miliseconds)
new pausescroller(pausecontent2, "pscroller1", "someclass", 2000)
</script>
</body>
</html>