> Some things for each one are: > MS-Access and MS-SQL can have Default Date fields however, > MySQL wont. All 3 of those platforms can have IDENTIFY > (type) > Fields that auto-increment. So if you have basic queries > that > Are not DB dependent, you can do it.
I think you mean IDENTITY ... Although I avoid those myself because they can (ymmv) cause some really challenging problems later (they have for several companies I've worked for -- I've talked to other people who've never had a problem with them). Oracle also although it doesn't support anything like an IDENTITY column, does support sequences and triggers which can be used in combination to create the same effect as an identity column. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
