asp ,ado

Results 1 to 2 of 2

Thread: asp ,ado

  1. #1
    Join Date
    Dec 1969

    Default asp ,ado

    even though i have used the cursor type as Dynamic.<BR> I does not get the total no of records.<BR> Also "/" include file missing is the error ,I am facing.<BR><BR><BR> MY CODE<BR> ----------<BR> mySQL ="select * from CLASSIFIEDDATA where citynm=&#039"&y&"&#039 and trans=&#039"&x&"&#039<BR> and protp=&#039"&z&"&#039 "<BR> Set Con = Server.CreateObject("ADODB.Connection")<BR> Con.Open<BR> "PROVIDER=SQLOLEDB;DATASOURCE=indiafile;UID=sa;DAT ABASE=indiafile"<BR> Set RS=Server.CreateObject ("ADODB.Recordset")<BR> RS.MaxRecords = 6<BR> RS.CursorType =adOpenDynamic<BR> RS.Open mySQL,Con<BR><BR> kumaran

  2. #2
    Join Date
    Dec 1969

    Default RE: asp ,ado is the file that translates vb code words for you for example adOpenDynamic = 2 If you don&#039t have adovbs then substitute 2 for AdOpen Dynamic and it should work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts