> unnecessary and unreliable. He said that databases have built-in ways
> of returning the value.
i think that might be qualified as "non-desktop" (ie "real") databases.
> this information with CF? Can MSAccess (I know it sucks) return such a
> value?
you could use
- plain UUID,
- modified UUID: UUID in conjunction with autonumber (use the
autonumber column for JOINs much faster than the UUID varchar).
basically createUUID, insert it & that row's data into table, select for
that UUID to return autonumber, insert that into child tables.
- key tables: basically maintain the key in a separate table. does
increase db transactions but these will all be short & sweet.
or switch to a real database. if your load isn't too bad (no more than
5 simultaneous users) and db size isn't too large (less than 2gb) i think
access users might consider sql server's idiot brother MSDE. it also
makes a nifty development target.....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
