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
-~----------~----~----~----~------~----~------~--~---
