Results 1 to 3 of 3

Thread: Count

  1. #1
    Gabriele Guest

    Default Count

    Hi, i have a litle problem...<BR>I use MySQL with ASP and i want create a Select with &#039count()&#039in my ASP page, but dont work.<BR>Help Me<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Count

    here&#039s how i do it:<BR><BR>&#060;%<BR>set dbcn=server.createobject("adodb.connection")<BR>db "dsn=mydsn"<BR>set dbrs=server.createobject("adodb.recordset")<BR>dbr s.activeconnection=dbcn<BR> "select count(myfield) as acount from mytable"<BR>acount=dbrs.fields("acount")<BR>respon se.write acount<BR>dbrs.close<BR>dbcn.close<BR>set dbrs=nothing<BR>set dbcn=nothing<BR>%&#062;

  3. #3
    Join Date
    Dec 1969

    Default Does MySQL Support the COUNT Function?

    Does MySQL Support the COUNT Function?

Posting Permissions

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