please imagine the fields in mytable:
each "p" represents a page.
If I want to a have script to delete page 2 I can do something like this:
pageOrder = 2
Set rsc = Server.CreateObject("ADODB.Recordset")
sqlc = "SHOW COLUMNS FROM mytable LIKE 'p%'"
set rsc = cn.execute(sqlc)
On Error Resume Next
Do While Not rsc.EOF
if InStr(rsc("field"),"q"&pageOrder)>0 then
sqla = "ALTER TABLE mytable DROP COLUMN "&rsc("field")
set rsc = nothing
But, I want the script also to change the fields of pages 3,4 to become 2,3 - How can I do it?