I have a couple of ASP problems,

1. I have a DB, can display records, which is great, BUT at the start of each record I have a approved Yes/no field, and want to display only the records the have yes, so I triedsomething along the line of:

if x_aprvd = false then rs.movenext else (rest of record)

<table........

I know the above is not code correct (no delimiters and all, it's just off the top of my head), I have an existing end if, rs.movenext, loop command later on to loop through and display the records.

2. I've managed to add comments to another record (1 to many routeen)and what I would like to do is, on clicking to add a comment to a record, to add the record id to to a field on the comments table so I can then display the comments related to that record, I've managed to list the record ID's in a list, but have gone brain dead and can't think past this one...

Thanx in advance

umm didnt quite understand the no. 2 question

and for number 1, i aint sure cose ya said ya did it off the top of ya head, but is it cose it doesnt have quotes round the "false" ... like that?

the code line above isn't the exact script, it's just an example for quickness, but goes along those sort of lines, but it maybe completely different...it's just the way I was attempting to do it.... I can get the exact code 2night at home, I don't have it with me at work :(

I don't think that the testing value would have to be in "" as it's either Ture or false and not Text, as the text would be represented as "yes" or "no"

For question one why dont you just use select * from table where x_aprvd = True. This would be faster as it would return less results from the origional query, also you wouldnt have to use the if statement.

I used the string

Select * FROM [tblinks] WHERE [link_aprvd] = true

So thanks Ultramods for that,

now all I need to do is, I have a links table and a comments table, and want people to post comments about the links, I have a duplicate field on both tables called [Link_id], how do I set the [Link_id] on the comments table to the value of the record they want to comment on?? (abit like posting a comment on the forum)

Thanx again for any help given

For each link you could have a button called "comment". When they click on the button it go's to a page where they can comment on the link. The url for this page would have a queryString for the linkID.

For example. http://www.youdomain.co.uk/commentonLink.asp?linkID=2 - www.youdomain.co.uk/commentOnLink.asp?linkID=2

Let the users add there posts then enter all the details into your comments table including the linkID. ie rs("linkID") = linkID

http://www.youdomain.co.uk/commentonLink.asp?linkID -