Please help me out, I've been stuck on this prob for awhile.
My site allows you to upload 3 different types of media: photos, videos, and written experiences. I'd like for the users to be able to comment and respond on each other's uploaded media. So, for each specific photo or video there would be a "comment" link and anyone can comment or reply to others comments.
I need to somehow use the ID of the media uploaded, pass that value onto the comments form page and insert the specific comment into the proper place in the dbase.

Anyone have any ideas to do this??? Any help is GREATLY appreciated.

John



Edited by - Trinity420 on 16 Dec 2001 16:58:17

simply make a table that has

1. commentID :autonumber
2. ItemID :number (foreign key)
3. comment : text
4. name : text
5. dateposted : date/time

then make alink on the media display page that passes the itemID to the comment page via the querystring <b>&lt;a href="comment.asp?itemID=&lt;%=recordset1.fields("itemID".value%&gt;"&gt;Comment on this item&lt;/a&gt;</b>

shouldn't be that hard.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Ok, yeah...I've gotten that far. I'm able to pass the itemID value to the comments_form page. But now that I have the value passed to the Comments_Form page, How do I insert the data in the forms into the Access dbase Comments Table (the itemID is binded to the MediaID field in the Access dbase tables).

I'm so close, but I'm just missing something.

Thanks for the help.

make a form with 3 fields...
1. name : textbox
2. comment : textarea (multiline textbox)
3. itemID : hidden field

the itemID hidden field shold have <b>&lt;%=request("itemID"%&gt;</b> as the value.
then simply apply the insert server behavior... for the dateposted, just put <b>date()</b> as the runtime value.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Awesome...that was so simple.

I was using filtered recordsets, query search strings and trying to update and insert but kept getting continual errors.

Thanks a million!