Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Another recordset question

Reply
Thread Tools

Another recordset question

 
 
Rob Meade
Guest
Posts: n/a
 
      03-01-2004
Lo all,

I have a local recordset which is not linked to a database.

Some of the fields in this recordset contain html tags.

I have a function which is called when I'm calculating my relevance for
search results which gets the row from the recordset, strips out the html
tags, then does its magic to produce the 'relevance' for that row.

My problem is that when the search is carried out initially, it obviously
matches against the html aswell, after my relevance is calculated a row
could exist in my recordset with a 0 for relevance but its still in the
recordset because it was found initially.

I figure I have two options - before I dump the results to the page I could
either iterate through the recordset again, if there are any results with a
0 relevance then delete them from the recordset, or, have an if..then to see
if the relevance for that row is 0 and then NOT display it to the page.

Question :

Is it better to remove the row from the recordset then just display all -
rather than using the if...then or is it better to use the if...then and not
have to iterate through the recordset to remove all the 0 relevance rows..

Also - if I am to delete the rows from the recordset - anyone got a small
snippet of code to do that?

I'm using stuff like :

RS.AddNew
RS.Update

for this local recordset - not sure how to drop a row like this?

Any help is appreciated,

Regards

Rob


 
Reply With Quote
 
 
 
 
Bob Barrows
Guest
Posts: n/a
 
      03-01-2004
Rob Meade wrote:
> Lo all,
>
> I have a local recordset which is not linked to a database.
>
> Some of the fields in this recordset contain html tags.
>
> I have a function which is called when I'm calculating my relevance
> for search results which gets the row from the recordset, strips out
> the html tags, then does its magic to produce the 'relevance' for
> that row.
>
> My problem is that when the search is carried out initially, it
> obviously matches against the html aswell, after my relevance is
> calculated a row could exist in my recordset with a 0 for relevance
> but its still in the recordset because it was found initially.
>
> I figure I have two options - before I dump the results to the page I
> could either iterate through the recordset again, if there are any
> results with a 0 relevance then delete them from the recordset, or,
> have an if..then to see if the relevance for that row is 0 and then
> NOT display it to the page.
>
> Question :
>
> Is it better to remove the row from the recordset then just display
> all - rather than using the if...then or is it better to use the
> if...then and not have to iterate through the recordset to remove all
> the 0 relevance rows..



Can't answer this without testing ...

>
> Also - if I am to delete the rows from the recordset - anyone got a
> small snippet of code to do that?
>
> I'm using stuff like :
>
> RS.AddNew
> RS.Update
>
> for this local recordset - not sure how to drop a row like this?


RS.Delete


Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


 
Reply With Quote
 
 
 
 
Rob Meade
Guest
Posts: n/a
 
      03-01-2004
"Bob Barrows" wrote ...

> Can't answer this without testing ...


Hi Bob

No worries, I *personally* think that the If..then would be better,
otherwise I have to iterate through the entire recordset again - admittedly
only the once - but it could be huge, the If...Then is already in the main
iteration - so would make more sense....will probably go with this method
for now...

> RS.Delete


doh! "Does exactly what it says on the tin" ... )

Cheers

Rob


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing Recordset from an ASP page to another HTML page ? Oscar ASP General 27 06-01-2005 04:24 PM
Asp to Aspx, Response.Write Recordset.fields(1).value question Gian Paolo Clarici ASP .Net 0 07-21-2004 12:14 PM
ASP Recordset Question Simon NZ Computing 2 02-25-2004 08:22 AM
Recordset Display Question Maria Kovacs ASP General 8 01-29-2004 07:15 AM
RecordSet.Move or RecordSet.AbsolutePosition?? Hung Huynh ASP General 8 09-24-2003 11:07 AM



Advertisments