GetRows Help

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

GetRows Help

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> GetRows Help

Page: [1]

washurjosh

Posts: 66
Joined: 1/18/2006
Status: offline

GetRows Help - 5/15/2006 18:52:53

So i am trying to use GetRows to stick my ID's into an array that i can then use. But it keeps coming up with errors.

this is what i have so far.

<%

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open ~MYDATABASE~
set rs=Server.CreateObject("ADODB.recordset")
SQL = "Select ID From Results WHERE Cdate(T1)>Date()" 
rs.Open SQL, conn

Dim MyArray
MyArray = rs.GetRows()
Response.Write(MyArray)



rs.close
conn.close

%>


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: GetRows Help - 5/15/2006 21:05:52 quote: SQL = "Select ID From Results WHERE Cdate(T1)>Date()" Access DB should be something like this: SQL = "Select ID From Results WHERE Cdate(T1)>#" & Date() & "#" That help any? EDIT: If that doesn't get it, can you post the exact error? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to washurjosh)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: GetRows Help - 5/15/2006 23:51:30 Thats your actual code? "~MYDATABASE~" ? Hope not :) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to rdouglass)