package name=general
object name=applications table=applications
decorator=models.applications sequence=seq_applications
id name=application_id type=numeric /
property name=formal_title
This is the function that I used to retrieve the records via TQL =
http://pastebin.ca/1639591.
I forgot to include it in the 2nd message.
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
here's the relevent transfer.xml: http://www.pastebin.ca/1623157
I want to delete multiple record in fcrec_researchers using
application_id. Is this possible using transfer?
I had a look at the wiki but nothing useful came up. Searching the
discussion brought me to a 2007 discussion but a lot
/wiki/Managing_the_Cache.cfm#Transfer.dis...)
Hope that helps.
Mark
On Fri, Oct 16, 2009 at 12:45 PM, jarthel jart...@gmail.com wrote:
here's the relevent transfer.xml:http://www.pastebin.ca/1623157
I want to delete multiple record in fcrec_researchers using
application_id
Here's a sample code that is from the wiki (many-to-many):
cfscript
post = transfer.new(post.Post);
post.setTitle(My Title);
post.setBody(The body of my post);
post.setDateTime(Now());
category = transfer.get(system.Category,1);
Thanks for the reply.
Don't you mean onetomany? applications onetomany with
applications_users and then users onetomany with applications_users?
Thanks again
On Oct 1, 3:09 pm, Matt Quackenbush quackfu...@gmail.com wrote:
You cannot have the m2m as well as an o2m with the same table.
just to clarify
applications m2o with applications_users
users m2o with applications_users
could you explain the decorator methods?
thanks again :)
Jayel
On Oct 2, 8:21 am, Matt Quackenbush quackfu...@gmail.com wrote:
Nope. I mean m2o. With an o2m, Transfer places methods on both objects.
I have 3 tables. applications, users and applications_users.
applications and users have a many-to-many relationship and I'm using
applications_users to relate the 2 together. Also a user can different
roles per application so I have added a role field in
applications_users. e.g. user1 can be
I have the following code:
---
cffunction name=saveApplications access=public output=false
returntype=array
cfset var tempArray = ArrayNew(1) /
cfset var tempObj = /
cfset tempObj = createApplications(argumentCollection =
sorry about that :)
Here's the error message:
--
11:40:52.052 - Database Exception - in C:\web\apache\htdocs\flinders
\webapps\edss\transfer\com\sql\QueryExecution.cfc : line 82
Error Executing Database Query.
/
property name=access_type type=string
column=access_type
nullable=true /
/object
-
On Sep 30, 12:15 pm, Mark Mandel mark.man...@gmail.com wrote:
You don't have robust exception handling turned on?
Mark
On Wed, Sep 30, 2009 at 1:12 PM, jarthel jart
found my problem after awhile (debugging queryexecution.cfc mostly).
it's a misconfigured transfer.xml :(
thanks Mark for reading :)
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
I currently have a mach-ii/coldspring project working nicely.
retrieving a record and displaying it in a form is a breeze.
when I introduce transfer to do the same, it is very slow. no special
tricks were used. just a transfer get function to retrieve the
object.
When I said 'very slow, I meant
thank you very much!
it's very very quick now
On Sep 29, 9:52 am, Mark Mandel mark.man...@gmail.com wrote:
Report Execution times will drastically slow down any CFC heavy application.
Turn it off, and watch things return to normal.
Mark
On Tue, Sep 29, 2009 at 10:49 AM, jarthel jart
like I am inserting inter-related records into 6 tables. and the
something happened when it was inserting the record on the 3rd table.
Is there some sort of alert? I looked at the page (http://
docs.transfer-orm.com/wiki/Transactions_and_Transfer.cfm) on
transaction and nothing was mentioned.
It seems TQL can only accomodate basic (at least to me) SQL which
makes it feels like I'm going backwards.
You can't use built-in DB functions (at least that's how I understand
it reading the TQL doc page). We use oracle here and there are many
useful functions built-in the DB.
1. why would you
I forgot to say that my framework is something like
service (includes crud) - gateway - TQL.
I'm not sure if this is relevant to my original message but I'll
include it anyway.
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
I work for a university (so we get special pricing on Oracle) and I
highly highly doubt we would be moving to another DB vendor in the
near/distant feature.
from what I can see the only benefit to me is on security
(injections). though I have to weigh that up VS the usefulness of
Oracle's
Is it possible to use transfer.get to retrieve fields from multiple
table?
something along the lines of:
select a.project_id, b.client_id, b.client_name, a.project_manager
from projects a, clients b where a.client_id = b.client_id and
a.project_id = xxx
I see happening in almost every program
With readByQuery, I suppose I need to create new entries in transfer
to correspond to my new dataset? (new because the fields are
combination of fields from multiple tables)
something like: http://www.pastebin.ca/1456294 (Please look at the
last object which is applications_users)
Thanks again
I have 3 tables
1. applications (application_id is the primary key)
2. users (user_id is the primary key)
3. applications_users (applications and users have a many-to-many
relationship and this is the middle table) (application_id and
user_id make up the primary key)
I've looked at the wiki and
outside of Transfer you either need to let it know
that it should clear its cache and retrieve the objects again, or you need
to disable the cache (either for all objects, or just for the object in
question that gets trigger-inserted).
Chris Peterson
On 5/11/09 7:11 AM, jarthel jart...@gmail.com
Well my thread below got me thinking about cache. So I looked up the
wiki entry and the various discussion in this group.
But 1 thing isn't very clear: is it a multi-user (browser?) cache?
like my workmate 2 doors away updated a record. my cache would pick
up the changes?
I guess the analogy
Thanks everyone for the help :)
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google
27, 2009 at 4:19 PM, jarthel jart...@gmail.com wrote:
I have disabled caching on my development PC. I have also cleared the
template cache.
Maximum number of cached templates = 0
Maximum number of cached queries = 0
all tick boxes are unticked
+
I made some
25 matches
Mail list logo