23. februar 2000 - 11:24
Der er
3 kommentarer og 3 løsninger
Tælle records....?
Hej, Jeg har følgende script: ------------------------ <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> <link rel="stylesheet" type="text/css" href="../style.css"> </head> <body> <% set conn = Server.CreateObject ("ADODB.connection") conn.Open "DBQ=" & Server.MapPath("../db/download.mdb") &";Driver={Microsoft Access Driver (*.mdb)};" SQL = "Select * FROM download" Set RS = conn.execute(SQL) 'rs.Open SQL, conn, adOpenKeyset, adLockReadonly strAntal = RS.Recordcount %> <p class="textstor" align="center">ICQ Downloads</p> <p class="text" align="left">Programmer (<%= StrAntal %>)</p> <% SQL2 = "SELECT * FROM skins" %> <p class="text" align="left">Skins (<%= StrAntal %>)</p> </body> </html> ------------------------------- Og får følgende output: ------------------------ Programmer (-1) Skins (-1) ------------------------ Help ? Anyone ? <//morpheus\\>
Annonceindlæg fra Kingston Technology
23. februar 2000 - 12:02
#2
Reason ---> han skal da lave et Server.Createobject("ADODB.recordset"), ellers kan man da ikke bruge RS.recordcount - er det ikke rigtigt
23. februar 2000 - 12:06
#4
stoffer han skal bare bruge den her rs.Open SQL, conn, 3, 3 istedet sjense ja det kan man da også men så mangler der lige rs("") uden om Antal eks rs ("Antal")
23. februar 2000 - 12:16
#6
Scriptet ser nu ud som følger: ------------------------------ <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> <link rel="stylesheet" type="text/css" href="../style.css"> </head> <body> <% set conn = Server.CreateObject ("ADODB.connection") conn.Open "DBQ=" & Server.MapPath("../db/download.mdb") &";Driver={Microsoft Access Driver (*.mdb)};" SQL = "Select count(*) as Antal FROM download" Set RS = conn.execute(SQL) 'strAntal = RS.Recordcount %> <p class="textstor" align="center">ICQ Downloads</p> <p class="text" align="left">Programmer (<%= rs("Antal") %>)</p> <% Set conn = Nothing %> <% set conn = Server.CreateObject ("ADODB.connection") conn.Open "DBQ=" & Server.MapPath("../db/download.mdb") &";Driver={Microsoft Access Driver (*.mdb)};" SQL = "Select count(*) as Antal FROM skins" Set RS = conn.execute(SQL) %> <p class="text" align="left">Skins (<%= rs("Antal") %>)</p> <% Set conn = Nothing %> </body> </html> --------------------------------- <//morpheus\\>