Results 1 to 4 of 4

Thread: Number of record

  1. #1

    Thread Starter
    Member betto's Avatar
    Join Date
    Mar 2000
    Location
    Perú
    Posts
    38

    Smile

    Hi...
    how can I get number of record from a query, I'm using "recordcount" but it seems it doesnt work..

    <%strQuery = "select * from Images"
    set rsResult=connDB.Execute(strQuery)%>
    <% dim NumberRow, rest
    NumberRow= int(rsResult.recordcount/3)
    rest= rsResult.recordcount mod 3%>

    ..I'm making a table with only 3 columns
    ...and I'd like to know if I can use "int" and "mod" like we use in Visual basic

    betto
    bettoterra.com.pe

  2. #2
    Lively Member
    Join Date
    Sep 2000
    Posts
    126
    ive never seen mod used

  3. #3
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    select count(*) from Images
    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    [email protected]
    [email protected]


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..

  4. #4

    Thread Starter
    Member betto's Avatar
    Join Date
    Mar 2000
    Location
    Perú
    Posts
    38
    thanks monte 96.... it worked

    ahhhh then i realized that "mod" works like in VB..

    bye.. thank you.. all

Posting Permissions

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



Click Here to Expand Forum to Full Width