| Author |
 Topic  |
|
|
PuppyF500
New Member
Netherlands
68 Posts |
 Posted - 10 January 2005 : 14:10:34
|
I'm trying to create a Tutorial Page. I coded all the stuff except for one page. The page is supposed to change the order of the steps in Tut_ID x (where x is being fetched using Request.QueryString). Because the database doesn't allow duplicate entries I tried to first update the database with a value +10 and then revert that but then put the correct value in the database field. (still following me?  ) I managed to make a system for the value +10 action. and it also reverts it after doing the first update, but whatever I try it won't update the number I want it to update 
The database looks like this:
The things in bold are Primary Keys
And of course here the code from the step_order.asp page.
step_order.asp
If you are going to test the page, you'd probably need the Database itself too.
Tutorials.mdb |
Edited by - PuppyF500 on 10 January 2005 14:12:25 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
PuppyF500
New Member
Netherlands
68 Posts |
Posted - 10 January 2005 : 14:24:07
|
Step_nr and Tut_ID are the Primary Key , otherwise i can't create 2 steps 1 (needed if i want more than one Tutorial) |
 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
PuppyF500
New Member
Netherlands
68 Posts |
Posted - 10 January 2005 : 14:37:39
|
| its not auto-generated, and it can be changed, i can let it change to value + 10 without problems, but inserting the correct nr after that fails. it just insert the old number again... it's probably a stupid mistake i'm making, but if someone could find out what it was i would be very happy with it |
Edited by - PuppyF500 on 11 January 2005 01:52:36 |
|
|
|
PuppyF500
New Member
Netherlands
68 Posts |
Posted - 12 January 2005 : 18:58:19
|
| anyone who can help me out? |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 12 January 2005 : 22:39:04
|
Do you get errors?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
PuppyF500
New Member
Netherlands
68 Posts |
Posted - 13 January 2005 : 04:26:13
|
I don't get any errors, but first it updates values of +10 (which is correct) but then it has to insert values from the form into the database, but it just inserts the old values back in. But i can't find the problem  |
|
|
|
PuppyF500
New Member
Netherlands
68 Posts |
Posted - 13 January 2005 : 12:22:46
|
i did it it works now i made a small mistake, i forgot to let the page remember the new step_nr correctly so it went wrong while updating the 2nd time tnx for trying to help anywayz |
|
|
| |
Topic |
|
Topic Locked
