What db are you using?
For mssql you usually use
Insert into table
(field1, field2, field3)
VALUES
('xxx','xxx','xxx')
For mysql you can do it a bit differently but I usually try to do it the
same way to be consistant
Mike
-----Original Message-----
From: Torrent Girl [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 1:23 PM
To: CF-Newbie
Subject: Order of fields in insert and update statements
Hello all
Does the order of the fields in insert/update statements matter or do they
have to be in the same order as in the table?
Thanks
tGirl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1773
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
