You cannot post messages because only members can post, and you are not currently a member.
Description:
Group for the discussion and support of Transfer ORM ColdFusion library.
|
|
|
Stuck on an error using TQL
|
| |
Hi, I'm using the following TQL Statement: FROM Items.Item AS Item JOIN Groups.Group AS Group JOIN Users.User AS User WHERE User.ID = :userid AND Group.ID = :groupid ORDER BY Label ASC I'm getting this error when I try to execute it: The 2 parameter of the Left function, which is now -1, must be a positive integer... more »
|
|
|
Problem with jTDS driver and CF8
|
| |
Hi all,
I am having problems using Transfer with the jTDS JDBC Driver (1.2.2)
and CF8 (update 8.0.1) and MS SQL Server 2005.
It is not possible to insert a new record into the database via the
framework. The error I get is the following:
You have attempted to dereference a scalar variable of type class... more »
|
|
|
support for schema name in datasource.xml
|
| |
We need to prefix the calls to our tables with the schema name so all of our generated queries look like: select name from schemaName.tableName where id = 1 Having looked at the datasource.xsd, there is nowhere to declared that information, so it looks like this is not supported. Does anyone else need... more »
|
|
|
TQL Custom Tags in SVN
|
| |
Elliot Sprehn has been kind enough to donate his TQL custom tags for the Transfer project. Big thanks to Elliot! This should ease some of the verbosity that is required when working with TQL. Elliot provided be with several examples of their usage: --- <!--- This would be /transfer/tags ---> <cfimport taglib="tags" prefix="t">... more »
|
|
|
compositeID's and manytomany
|
| |
Is it possible to use manytomany with compositeID's, kind of like
this:
<compositeid>
<manytomany name="EMPLOYEE_ID" />
<manytomany name="USER_ID" />
</compositeid>
<manytomany name="EMPLOYEES">
<link to="EMPLOYEES.EMPLOYEES" column="EMPLOYEE_ID"/>... more »
|
|
|
Multiple Deletes
|
| |
Is it possible to execute a multi-row delete in transfer, something
like;
DELETE from PEOPLE.PEOPLE as PEOPLE where
PEOPLE.PEOPELID IN ( :peopleIDList)
And if I can do this, what do i call after i've created the query to
execute it:
<cfset qBulkDelete = transfer.listByQuery(query) />
Its probably not listbyquery, but is there a generic runSQL() function... more »
|
|
|
Bulk database updates
|
| |
I have to do some bulk updates with transfer, and my only idea so far
seems highly inefficient.
Basically, lets say a user (Userid =123) has a multi-select box and
they need to choose, "sports they like". Previously, the user had
picked "Soccer" (im american), "Football", "Lacrosse", "Golf", with... more »
|
|
|
Slow Init
|
| |
I have put together a small test script to try out Transfer. I has 2
objects each with just a few fields.
This code;
<cfset application.transferFactory =
CreateObject("component","tran sfer.TransferFactory").init(ar gumentCollection=transferConfi g)>
is taking about 40 seconds to complete when CFs cache expires or we go... more »
|
|
|
