Why don't you store them in separate rows?
Drew Falkman
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 04, 2001 2:40 PM
Subject: Best way to store a certain set of data
> This is a pretty general question so i didn't have a specific list to send
it to, but here goes.
>
> I have a web-based mail program that retrieves mail from pop3 servers and
sends mail through smtp. Now the question is, what is the best way to store
the email addresses?
>
> Right now, I have them in a varchar field which is fine, but I've had to
grow this field several times and now it has gotten to 5000 chars. This is
because some people might want to send a mail merge out to their entire
contact list, etc... I can't keep growing this field because I assume that
the database would become less and less efficient.
>
> So the options I can think of are:
> - Make the field insanely large.
> - Use a text/memo field - this would be fine, but makes it hard to search,
etc
> - Use another table to store addresses and map them to the e-mail - What
would be the pros and cons of this? The pros I can see are that you could
have unlimited number of addresses for each e-mail.
>
> Please give your opinion on this. Thanks!
>
> Travis Reeder
> Chief Software Architect
> www.ThinkVirtual.com
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
