Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [Michael_Bray] Help Desk Integration [Food for thought]: Edit Log

Here is the list of edits for this post
Re: [Michael_Bray] Help Desk Integration [Food for thought]
If it is set up as CHAR, VARCHAR, or TEXT column, then it wouldn't matter in terms of the index searching. But still, very bad idea to store multiple values in columns...best to use JOINS between tables in terms of efficient database structure.

(wigetz/jerry su, old user of GT products, did the same thing with My Links by storing all the LinkIDs in the User table...very bad structure...he ended up changing the design of his database to reflect suggestions I provided him...discussion took place back in the summer of 2000 in the Links 2.0 Customization forum...)

Yea, the point is that, yes, you can "do it" via the above code that Paul posted, but not the best idea in terms of long-term database maintenance, functionality, etc.
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Heckler: Jan 7, 2002, 8:29 AM

Edit Log: