Recordset problem... ouch !!

# Thread: Recordset problem... ouch !!

1. Member
Join Date
Dec 1969
Posts
76

## Recordset problem... ouch !!

Hi ya...... hope you can help me ! The problem is this : I have a database with deatils of a point system, which has an increment of 100.....100, 200 up to 1700 points. How would i pull out a record in this table where for example the point value used to retrive the record was 110... i wnat to be able to <BR>sort through the recordset and only display the filed for 100.

2. Medieval Dude Guest

## RE: Recordset problem... ouch !!

I don&#039;t know about everyone else, but I&#039;m not following you. What do you want to SELECT from yer database? And what do you want to do with yer recordset once you have it? I need a better example.

3. Senior Member
Join Date
Dec 1969
Location
Los Angeles, CA
Posts
21,192

## RE: Recordset problem... ouch !!

well i cant hink of a way to only do it in the backend <BR><BR>how about this<BR><BR>a = 110 &#060;- whatever the user enters<BR>b = a Mod 100<BR>a = a - b<BR><BR>...where PointColumnName = a &#060;- a will now have 100<BR><BR>this will work in this way <BR><BR>210 = 200 <BR>290 = 200<BR><BR>so it will basically "round" to the lowest 100<BR>

4. Richard A. Lowe Guest

## Good way... also alternative..

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=87

5. Senior Member
Join Date
Dec 1969
Location
Los Angeles, CA
Posts
21,192

## Problem with that...

...based on the post the id or whatever is stored in multiples of 100 so not if i enter 130 will it not round to 150 which is wrong<BR><BR>and 175 to 100 which again MIGHT be wrong for his needs but since he did not give more examples

6. Richard A. Lowe Guest

## RE: Problem with that...

If I understand your concern, I should point out the FAQ can round to the nearest integer interval, which you specify:<BR><BR>Response.Write RoundTo(110, 100) &#039; will give 100<BR><BR>But if you mean he has to do a Floor on the number, like 175 turns into 100, the FAQ would have to be re-written, yes.<BR><BR>Richard

#### Posting Permissions

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