|
Subject:
|
move record to another table in same DB
|
|
Posted By:
|
Dejitan
|
Post Date:
|
1/2/2007 7:22:53 AM
|
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
|
|
Reply By:
|
dparsons
|
Reply Date:
|
1/2/2007 12:14:08 PM
|
Cross post: http://p2p.wrox.com/topic.asp?TOPIC_ID=54163
-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
^^Thats my signature
|
|
Reply By:
|
Dejitan
|
Reply Date:
|
1/3/2007 6:50:14 AM
|
how can I delete this topic?
~~~~~~~~~~~~~~~~~~~~~~
What goes around comes around
|
|
