Search Engine - write review
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15871
Printed Date: 30 March 2026 at 6:24am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Search Engine - write review
Posted By: urko
Subject: Search Engine - write review
Date Posted: 18 July 2005 at 10:20am
|
Hey all, Has any1 tried to add "Write review" to Search engine?? The reason I'm asking is, that I would like to use search engine db for my products but would also like beside voting to write reviews. Any Idea how should I make this? Thanks, ------------- Urko |
Replies:
Posted By: ub3rl337ch3ch
Date Posted: 18 July 2005 at 7:05pm
|
create a table which includes a long field (100s of characters) and an id field. then whenever someone posts a review, add a record to this table with the id of whatever they're reviewing and the review itself. you could also have a field for poster (username or handle), time of post (=now()) and title of review, if you want something slightly less basic. Then it'd just be a matter of doing a query for whatever fields you want where id = the id of the product being viewed, using that to open a rs, and doing 'do until vrec.eof' and 'vrec.movenext' to fill out subsequent rows of reviews...
|
Posted By: pmormr
Date Posted: 19 July 2005 at 12:57am
|
the best field type to use for reviews and stuff is called a "memo field" in access. check the help files to see how to change it. ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |
Posted By: urko
Date Posted: 19 July 2005 at 12:50pm
|
Not sure i understand exactly what u mean. So I should make new table with cells: ID, TITLE, REVIEW, DATE and then I have to connect it with RS??  I think I would need little more help ------------- Urko |