-----BEGIN PGP SIGNED MESSAGE-----
Hi Russell:
Thank you, I'll give it a spin around the DSN block
Rion
On Wed, 18 Jul 2001, you wrote:
> 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.
