Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Problem getting info out of database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem getting info out of database

 Post Reply Post Reply
Author
mtarby View Drop Down
Newbie
Newbie


Joined: 20 February 2003
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote mtarby Quote  Post ReplyReply Direct Link To This Post Topic: Problem getting info out of database
    Posted: 20 February 2003 at 8:26am
I'm trying to pull records from a database in order to generate a graph of the results. I can connect to the database just fine and write a table of the columns I've selected

<%
Dim oConn, oRs, filePath, Index, i, j
Dim iRecFirst, iRecLast, iFieldFirst, iFieldLast, arrData

filePath = Server.MapPath("/database/database.mdb")
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
Set oRs = oConn.Execute("SELECT Reunion_Class, Goal_Donors, Paid_Donors From Reunion_Giving")
arrData =oRs.GetRows()
iRecFirst = LBound(arrData, 2)
iRecLast = UBound(arrData, 2)
iFieldFirst = LBound(arrData, 1)
iFieldLast = UBound(arrData, 1)
%>


Here's my problem - I thought this loop would write the data in the column in the spot in the applet where I need it for the graph, but it isn't working. 

<param name=dataset0yURL value="<%Do while NOT oRs.EOF
Response.Write oRs("Goal_Donors")
oRs.MoveNext
Loop
%>">


What am I missing? I know it has to be something basic.

Thanks in advance!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.