In addition to Ray's comments (who took the words right out of my e-mail):
There is an example of creating a structure and then creating and populating
an object in the Spectra e-Business CK book on pg 124.
The only piece the example is missing is the query, which Ray covered very
well.
Regards,
Rusher
Broadiant Corporation
999 18th Street Office (303) 308-2963
Suite 1955 Cellular (720) 939-6661
Denver, CO 80202 Fax (303) 298-7540
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Success usually comes to those who are too busy to be looking for it.
-----Original Message-----
From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 8:14 AM
To: [EMAIL PROTECTED]
Subject: RE: External Content to ContentObject?
First off, please bare in mind that if you use Spectra 1.01, you will NOT be
able to use Access as your COAPI.
Anyway, with that in mind, yes, what you want to do is very possible.
Simply use a QUERY to get your old data, then a loop to create new objects.
Here is an example:
<CFQUERY NAME="GetOldCrap" DATASOURCE="OldCrap">
SELECT * FROM tblOldCrap
</CFQUERY>
<CFLOOP QUERY="GetOldCrap">
<CFSET Ob = StructNew()>
<CFSET Ob.Name = Name>
<CFSET Ob.Title = Title>
<CFA_COntentObjectCreate ...>
</CFLOOP>
In the above code, Name and Title are columns from the GetOldCrap query.
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: Neil Clark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 03, 2000 9:51 AM
> To: [EMAIL PROTECTED]
> Subject: External Content to ContentObject?
>
>
> Okay, heres one and hopefully someone can give me a good insight into what
> can be done!
>
> I have a database [sadly in Access] with over 10,000 records. We
> are about
> to start a new Spectra site and I wanted to build the DB as the standard
> ContentObject store. I do not want to input the data manually
> into Objects
> within Spectra.
>
> Is there a way I can get the info [looping over the records] from the DB
> into a Spectra store using a script or something like that?
>
> N
>
> <! -----------------------------------
> Neil Clark
> Senior Web Applications Engineer
> mcb digital
> Tel. +44 (0)20 8941 3232
> Tel. +44 (0)20 8408 8131 [Direct]
> http://www.mcbdigital.com
> ----------------------------------->
>
>
>
> ------------------------------------------------------------------
> ------------
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
