Renumbering Table
webdesign | Posted 11:39am 16. January 2008 Server Time |
random number (code)
...
select * from table where number_id="' & random_number
...
rs.delete
rs.move next
for ix=1 to table_row_size
rs("number_id")= ix
rs.update
next
Why is this not working?
Thanks in advance |
WizzKidd | Posted 2:58am 17. January 2008 Server Time |
Umm, if your random_number is of type 'Number' then you do not need quotes around it in your select statement, so your query should be:
sql = "select * from table where number_id=" & random_number
otherwise post your error, so we can have a look at.
- WizzKidd aka Neil-One
webdesign | Posted 9:49am 17. January 2008 Server Time |
I am using quotes.... just thought i'd give a quick code.
I am not at my computer right now...but will later on.
error was something like "... is marked for deletion."
will give exact error later tonight.
Thanks
webdesign | Posted 7:12pm 18. January 2008 Server Time |
well ... I went around renumbering table and used some other code to get the results I wanted. Thanks
Reply to Post Renumbering Table
|
|
|
