Mailto INSERT INTO duo

[NevG]

Hi gang

Can someone please help me with this.

I have a database that users enter questions about our sie into through a web page (obviously). I then bring back these questions in a web page report that changes the E-mail address into a mailto hyperlink. This bit is fine, but I want to compliment the mailto with a peice of script that fires a yes into completed / Answered field in the database. I could do this several ways by using checkboxes or a submit button, but I would like this to be done automatically when the support team reply to the E-mail

Thanks for any help

Nev

 

[shaddow]

Please Be more specific... ________

George

 

[NevG]

I would like to have my team replying to questions via email through the report on the web showing all questions posted.

Sequence of events would be

Click the question to bring up mail window
Send mail to person who sent question
Automatically return the id of that question to the database to set a True in the Answered field.

Can you help

 

[shaddow]

If i'm not wrong...
U need to use in the central page...
Click the question to bring up mail window
a script function
function setId(id)
{
//set the id where u need in the central page
};
window.open "mail.asp" to bring up the mail


and then in the "mail.asp"

u need to sent the mail an then update the database... and get the id
and then in script call
window.opener.setId(id) to call from the mail window the central window function that modifi the id...


hope this was helpful. if not please tell more detailes ________

George