|
-
Apr 23rd, 2001, 02:48 PM
#1
Thread Starter
Member
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
betto terra.com.pe
-
Apr 23rd, 2001, 09:27 PM
#2
Lively Member
-
Apr 23rd, 2001, 09:37 PM
#3
Frenzied Member
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..
-
Apr 24th, 2001, 12:20 AM
#4
Thread Starter
Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|