On 2/17/01, Dick Applebaum penned:
>Have you considered making a separate ProductArea table which is a
>child of the Product table:
>
> ProductID Int,
> AreaID Int,
>
> PRIMARY KEY (ProductID, AreaID)
>
>Both as the PK
>
>You could just do the insert bookended with CFTry...
>
>If no error, it was the first of that ProductArea Combo... otherwise
>notify the user that it's already taken.
Sounds like a plan Dick. Although I'd probably query against the
table rather than generating all those errors in my log file.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
