move record to another table in same DB
Help me solve this pls
on the update page(the update-page is a pop-up) I have two radiobuttons with the values 'yes' and 'no'. If you select 'yes' than the record should move to the history table. I have the following code that doesn't work and the worse and don't get any errors:
if akkoord=request.form("akkoord")="ja" then
sqlString = "INSERT INTO geschiedenisAanpassingen" &_
"(prioriteit, stat, aanpassing, commentaar, opleverdatum, toevoeger, " &_
"ap_toegevoegdOp, opleverdatumDD, opleverdatumMM, opleverdatumJJJJ ) VALUES ( " &_
ToSql(prioriteit) & "," &_
ToSql(stat) & "," &_
ToSql(aanpassing) & "," &_
ToSql(commentaar) & "," &_
ToSql(opleverdatum) & "," &_
ToSql(toevoeger) & "," &_
ap_toegevoegdOp & "," &_
ToSql(opleverdatumDD) & "," &_
ToSql(opleverdatumMM) & "," &_
ToSql(opleverdatumJJJJ) & ")"
Conn.Execute (sqlString)
end if
response.end
the radiobutton code looks like this:
<input type="radio" checked="checked" value="nee" title="Nee" id="nee" name="akkoord">Nee</input>
<input type="radio" value="ja" title="Ja" id="ja" name="akkoord">Ja</input>
~~~~~~~~~~~~~~~~~~~~~~
What goes around comes around
__________________
~~~~~~~~~~~~~~~~~~~~~~
What goes around comes around
|