how to use GetRows() with VBscrip (ASP)?

From: Mich (mich_at_nomail)
Date: 10/30/04 

Date: Sat, 30 Oct 2004 17:55:46 +0200

Hi,

I want to use GetRows() instead of RecordCount, but i have some problem with
array in VBscript (ASP).

This is what i want to change with GetRows():
<%
set objdc = Server.CreateObject("ADODB.Connection")
objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source =c:\mydb")
sql="select field1 from mytable;"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open sql, OBJDC, 3, 3
rec=rs.RecordCount
%>

Thanks
Mich

Relevant Pages

  • how to use GetRows() with VBscrip (ASP)?
    ... array in VBscript (ASP). ... This is what i want to change with GetRows(): ... set objdc = Server.CreateObject ...
    (microsoft.public.vb.database.ado)
  • Re: ASP ecommerce help
    ... > I seem to be getting to grips with the whole ASP DB ecommerce thing, ... > 1) I use the getrows feature all the time now for recordsets rather ... I don't recall buffering having anything to do with checking cookies. ... I don't do ecommerce, but I don't remember ever deliberately turning ...
    (microsoft.public.inetserver.asp.db)
  • Re: ASP ecommerce help
    ... > I seem to be getting to grips with the whole ASP DB ecommerce thing, ... > 1) I use the getrows feature all the time now for recordsets rather ... I don't recall buffering having anything to do with checking cookies. ... I don't do ecommerce, but I don't remember ever deliberately turning ...
    (microsoft.public.inetserver.asp.general)