[thelist] ASP Database Problem. Any Ideas?

Rudy_Limeback at maritimelife.ca Rudy_Limeback at maritimelife.ca
Mon Sep 25 12:15:05 CDT 2000

 >  do they have to be in the order they're in in the database?

hi dan

no, any sequence of columns is fine, assuming you are explicitly listing 

  insert into foo
     (colA, colD, colB, colE)
     ('Avalue', 'Dvalue', 'Bvalue', 'Evalue')

columns that are not listed must have a default value, so make sure the 
column you are omitting actually is an autonumber like you said

if you do not list the columns then you must supply a value for all of 
them, in table column sequence

insert into foo
     ('Avalue', 'Bvalue', 'Cvalue', 'Dvalue', 'Evalue')


More information about the thelist mailing list