Sorry, list doesn't allow attachments (hence previous useles post)
<!----creates stProperties and creates the object
---><!----Loop over kiosk data query to create correct objects --->
<cfset numObjs = 0>
<cfloop query="kioskdata">
<!--- Create StProperties --->
<cfscript>
//basically copies certain fields from row into a structure for create
objects
stProperties = StructNew();
stproperties.linkurl = URL;
stProperties.TeaserText = LEGEND;
stProperties.title = TITLE;
stProperties.label = VARIANT&"_"&CHANEL&SUBCHANNEL&"_#pagename#";
</cfscript>
<cfa_contentObjectCreate
dataSource="#request.cfa.objectstore.dsn#"
typeID="000CA16A-722C-1AFA-982380C4360A0000"
stProperties="#stProperties#"
bActivate="Yes"
label="#stProperties.label#"
r_id="r_id">
<cfoutput>
#r_id# #stProperties.label# created<br>
</cfoutput>
<cfset numObjs = numObjs + 1>
</cfloop>
<cfoutput>#numObjs# objects created!<br></cfoutput>
</cfloop>
Russell Brown
Internet Application Developer
Freeserve.com Plc, PO Box 452, Leeds LS2 7EY
Telephone: 0113 207 1203
-----Original Message-----
From: Russell Brown [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2001 14:33
To: Spectra-Talk
Subject: RE: High volume content objects
Heres a snippet from the code I used to create objects from a query.
It worked for me as a one off batch job (can't think of any gotchas)
Russell Brown
Internet Application Developer
Freeserve.com Plc, PO Box 452, Leeds LS2 7EY
Telephone: 0113 207 1203
-----Original Message-----
From: Rion D'Luz [mailto:[EMAIL PROTECTED]]
Sent: 18 July 2001 13:26
To: Spectra-Talk
Subject: High volume content objects
-----BEGIN PGP SIGNED MESSAGE-----
Hello All:
The prototype site i'm developing under 1.5.1 has got
about 2000 catalog items. What I'd like to know is:
a) what are the advantages/disadvantages of making each item a
content object?
b) In creating catalog content items by pulling relevant data from a
DSN and
using cfa_contentobjectcreate is there any 'gotcha's" that I need to
look out
for? Locking issues, etc.. Can anybody offers a 'here's the code'
example of
their own?
TIA
Rion
--
----------------------------------
Level9
5 State Street
Montpelier, VT
1 (802) 229 2005
E-Mail: [EMAIL PROTECTED]
E-Mail2: [EMAIL PROTECTED]
----------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
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.
