OK, here is more, i don't understand "you want to go
through the parent object and update it through there", could you in
turn send me a little code example please?:
<!--- if the current file extension is in the imageextensionlist,
write the file to dmimage and set to emailberichten_aemailafbeeldingen
array --->
<cfif listcontains(imageextensionslist,"#listlast
(accountemails.attachments,".")#",".")>
<!--- write the file to dmimage --->
<cfset obj = createObject
('component',application.stcoapi.dmimage.typePath) />
<cfset stprops = {} />
<cfset stprops.objectid = emailberichten_aemailbestanden_bindinguuid /
>
<cfset stprops.emailantwoordobjectid =
emailantwoordobjectid_bindinguuid />
<cfset stprops.alt = accountemails.attachments />
<cfset stprops.label = accountemails.attachments />
<cfset stprops.sourceimage = "/images/dmimage/sourceimage/
#accountemails.attachments#" />
<cfset stprops.label = accountemails.attachments />
<cfset stprops.status = "approved" />
<cfset stprops.title = accountemails.attachments />
<cfset obj.createData(stProperties=stprops) />
<!--- set file and email objectid to emailberichten_aemailafbeeldingen
array --->
<cfset obj = createObject
('component',application.stcoapi.emailberichten_aemailafbeeldingen.typePath) /
>
<cfset stprops = {} />
<cfset stprops.data = emailantwoordobjectid_bindinguuid />
<cfset stprops.parentid = emailberichten_aemailbestanden_bindinguuid /
>
<cfset stprops.seq = "1" />
<cfset stprops.typename = "dmImage" />
<cfset obj.createData(stProperties=stprops) />
<!--- if the current file extension is not in the imageextensionlist,
write the file to dmfile and set to emailberichten_aemailbestanden
array --->
<cfelse>
<!--- write the file to dmfile --->
<cfset obj = createObject
('component',application.stcoapi.dmfile.typePath) />
<cfset stprops = {} />
<cfset stprops.objectid = emailberichten_aemailbestanden_bindinguuid /
>
<cfset stprops.emailantwoordobjectid =
emailantwoordobjectid_bindinguuid />
<cfset stprops.bLibrary = "1" />
<cfset stprops.filename = "/dmfile/#accountemails.attachments#" />
<cfset stprops.label = accountemails.attachments />
<cfset stprops.status = "approved" />
<cfset stprops.title = accountemails.attachments />
<cfset obj.createData(stProperties=stprops) />
<!--- set file and email objectid to emailberichten_aemailbestanden
array --->
<cfset obj = createObject
('component',application.stcoapi.emailberichten_aemailafbeeldingen.typePath) /
>
<cfset stprops = {} />
<cfset stprops.data = emailantwoordobjectid_bindinguuid />
<cfset stprops.parentid = emailberichten_aemailbestanden_bindinguuid /
>
<cfset stprops.typename = "dmFile" />
<cfset obj.createData(stProperties=stprops) />
</cfif>
<!--- write email to db --->
<cfset obj = createObject
('component',application.stcoapi.emailberichten.typePath) />
<cfset stprops = {} />
<cfset stprops.objectid = emailantwoordobjectid_bindinguuid />
<cfset stprops.emailadresontvanger = accountemails.to />
<!--- strip emailaddress sender mail from any name convention --->
<cfif not listcontains(accountemails.from,"<")>
<cfset stprops.emailadresverzender = accountemails.from />
<cfelse>
<cfset emailadresverzender = listlast(accountemails.from,"<")>
<cfset emailadresverzender = replace(emailadresverzender,">","")>
<cfset stprops.emailadresverzender = emailadresverzender />
</cfif>
<cfset stprops.emailonderwerp = accountemails.subject />
<cfset stprops.emailtekst = accountemails.body />
<cfset stprops.label = accountemails.subject />
<cfset stprops.emailbestanden = accountemails.attachments />
<cfset stprops.substatus = "ongelezen" />
<cfset obj.createData(stProperties=stprops) />
<!--- after succesfull inserting to db delete email from mail server
--->
<cfpop action="delete"
server="#emailaccounts.emailserver#"
port="25"
timeout="60"
username="#emailaccounts.emailgebruikersnaam#"
password="#emailaccounts.emailwachtwoord#"
uid="#accountemails.UID#">
<cfcatch type="any">
<h1>Error while inserting email to db, the operation is aborted</h1>
</cfcatch>
</cftry>
On Nov 3, 3:05 pm, Tomek Kott <[email protected]> wrote:
> Marco, i'm confused about your type structure. Is it the following:
>
> Email (parentid)
> Array of dmImage and dmFile (attachmentid)
>
> And maybe attaching (rather than inline) the enitre code you're processing
> would help. The point remains that FarCry doesn't handle array tables
> directly through CreateData / SetData / GetData. Instead, you want to go
> through the parent object and update it through there.
>
> Tomek
>
> On Tue, Nov 3, 2009 at 8:57 AM, Marco van den Oever <
>
> [email protected]> wrote:
>
> > What is happening in the code is that i receive an email which i set
> > to a custom type, the email attachments are filtered and put into
> > dmfile or dmimage, then i want to bind the email and the email
> > attachments by array.
>
> > (The array is also used when people send an email and are selecting
> > email attachments through dmfile and dmimage.)
>
> > I set an objectid bij createuuid and use that to set the email
> > objectid and the data value for the array table, an earlier set
> > objectid by createuuid is used to set the dmfile or dmimage objectid
> > and the parent value for the array table.
>
> > So then do i need a structure like you state above? A appendArray
> > structure instead of createData?
>
> > On Nov 3, 2:18 pm, Tomek Kott <[email protected]> wrote:
> > > Marco, I believe you don't want to set the array property directly.
> > Instead,
> > > you want to do something like the following:
>
> > > getData( objectid of the parent )
> > > appendArray( dataID )
> > > setData.
>
> > > Basically, you need to go through the parent type to set the array using
> > > setData or createData. Otherwise you need to create your own query, as
> > > FarCry doesn't (I believe) work with array tables except through the
> > > original type.
>
> > > Tomek
>
> > > On Mon, Nov 2, 2009 at 6:50 PM, Marco van den Oever <
>
> > > [email protected]> wrote:
>
> > > > I don't get an error, it's a webtop list with code that executes on
> > > > load.
> > > > Am debugging with cfdump, this code seems to be the problem as when i
> > > > cfdump an existing variable under it, it isn't dumped but the list
> > > > loads.
>
> > > > How can i debug better?
>
> > > > On Nov 3, 12:22 am, modius <[email protected]> wrote:
> > > > > What is the error?
>
> > > > > -- gb
>
> > > > > On Nov 3, 9:14 am, Marco van den Oever <[email protected]>
> > > > > wrote:
>
> > > > > > Hi all,
>
> > > > > > I am trying to create a array record to bind 2 items by array:
>
> > > > > > <!--- set file and email objectid to
> > emailberichten_aemailafbeeldingen
> > > > > > array --->
> > > > > > <cfset obj = createObject
>
> > ('component',application.stcoapi.emailberichten_aemailafbeeldingen.typePath
> > > > ) /
>
> > > > > > <cfset stprops = {} />
> > > > > > <cfset stprops.data = emailantwoordobjectid_bindinguuid />
> > > > > > <cfset stprops.parentid =
> > emailberichten_aemailbestanden_bindinguuid /
>
> > > > > > <cfset stprops.seq = "1" />
> > > > > > <cfset stprops.typename = "dmImage" />
> > > > > > <cfset obj.createData(stProperties=stprops) />
>
> > > > > > All variables and table exists, any tips???
--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---
