No one's ever come across this before? I'm a pioneer!!!
On Jan 15, 11:09 am, tilespace <[EMAIL PROTECTED]> wrote:
> Howdy :)
> So I'm building an import script that takes all of the data from the
> existing database and imports it into the FC database. I've got it
> importing all of the content properly (the biggest challenge with this
> was taking data from 4 seperate tables and importing them into a
> single table) as well as importing all of the relevant images/graphics/
> photos/logos of the existing site into the dmImage table (I was
> extremely surprised by my being able to do this lol).
>
> Here's my issue tho. I have 7 FC tables (custom types) that have
> either both a logo and photo field or just a photo field. The images
> are in the dmImage table. But I can't for the life of me figure out
> how to get the objectid for the newly created image and pass it back
> to the addRecord() function so that it is inserted into the correct
> record.
>
> Here's my process:
>
> addRecord() is called and takes 3 parameters - typeName, origTblName,
> and arrFlds. The array has 2 values - the new field name and the
> original field name that it is associated to (ie: name:casino,
> addr1:address, website:url, logo:logoimagepath, etc).
>
> It then runs a select query on the origTblName which is then looped
> through. I use cfscript to then assign the appropriate values before
> calling newRec.createData(). If there is a logo or photo field, and
> it's not empty, I call the function FCifyImg() which takes 2
> parameters - origImg and origImgName. It pretty much does the exact
> same thing as addRecord() but for dmImage. But here I need to be able
> to return the new objectid to addRecord() and am just drawing a blank
> cuz if I run a scope_identity() query, it runs first before
> FCifyImg()... I've tried other methods that are erroring out so I'm at
> a loss...
>
> Here's an example of calling the image function:
>
> stRecords.photo = FCifyImg(oldRec.image,oldRec.name);
>
> I hope that makes sense...
>
> Thanks...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
