you mean like this?
<cfset userid= attributes.City&"_"&attributes.State>
I find it easier to use associated tables for this. once you put a user into
your database if you have an autonumber or identity field or use the MAXID
tag you will then have a unique id for every user which will be a number. A
database searches numbers faster than a string. Then you just use an
associated table to join it to another. So if you have a table of computer
specs, that table would contain an autonumber or identity field called say
compspecs_id. The user table would have a column that was an autonumber or
identity field called say user_id. The table that associates them would be
called something like user_compspecs. This table would have three columns.
user_compspecs_id, user_id, and compspecs_id. In this way you could have one
user have multiple specs for muliple dates all you would have to do is add a
date column to the user_compspecs table.
Is that what you were asking?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
