Nope, that works kind of opposite. If there are fields that are in the database that you don't include in your INSERT statement, then the DB will automatically populate the field with whatever the default value is set to in the DB itself.
Torrent Girl wrote: > Great. > On the flip side, do i need to add ALL of them in the insert query? > > > > >> No, an update only updates the fields that you ask it to. It leaves the >> others as-is. So, just include the fields that are on the second page >> of your form in the update statement on the final page. >> >> Torrent Girl wrote: > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1658 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
