[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
them
insert into foo
(colA, colD, colB, colE)
values
('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
values
('Avalue', 'Bvalue', 'Cvalue', 'Dvalue', 'Evalue')
rudy
r937.com
More information about the thelist
mailing list