VERY Tricky SQL! Can you do it?

[jesus4u]

RSINGH if you look at the QueryAnalyzer's resultset. HOw can I move through this RS and display only the unique Qtext?

[RSINGH]

Could you do a select DISTINCT to get the unique questions? For what purpose do you want the unique questions? Is this a separate requirement from the above SQL? If so its a new query.

The distinct keyword will eliminate the duplicates.

[jesus4u]

The reason is because I am dynamically building an asp page. See the link and how the page loads the repetitive data. I just need to find a way to move through the rs.

http://codeexamples.4t.com/dyn.jpg

[RSINGH]

Unfortunately my ASP is not good enough(I've only just started). Its hometime for me - so I'll give it a thought over the weekend. It may only be pseudocode though!

[jesus4u]

all I need to know is how to move through the rs. The asp is easy for me.

thanks

[RSINGH]

For and AOD recordset is it not rs.movenext ?