I would normally use columns in a database and not worry about structures
but, from the looks of the spec that I have got there is more of a
complicated structure.
basically it is a company information section for our intranet.
Within the Slow_stream table there will be coluimns for
Company info, financial info and sales office info
The later column has to contain;
Direct Sales:
location, size
VARs
location, Size, other products
International Presense
Key Markets
Market Share
I was thinking about using a structure for the direct sales and VAR sections
so I can store the extra details.
Is it as simple creating a structure then inserting it into a DB field.
When I want to display the data for a user can I query the database then
access the structure as I normal ?
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 25 April 2001 09:54
To: CF-Talk
Subject: RE: Storing structures in a DB
Darren
The question isn't as simple as all that -
the subject line says DB but the body says array.
In both cases the answer is yes, but the details
depend on what exactly you're trying to do.
One way of storing a structure in a DB is to put
it in a WDDX packet & put that in a large text
field. Otherwise of course you can have a table
with one column for each field in the struct.
Nick
-----Original Message-----
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 9:39 AM
To: CF-Talk
Subject: Storing structures in a DB
Hello,
Just a simple question that probably has a simple answer.
Can a structure be stored in an array so that it can be referrence at a
later date ?
Darren Adams
Web Developer
Marketing Department
Systems Union
Office: 01252 55 6220
Mobile: 07714 817 038
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
