Nathan Mische wrote:
Hello,
I'm having some issues with the new fourq setData.cfm
(fourq/_fourq/setData.cfm) posted to the list by Brendan last week. The
following issues have cropped up while trying to add a rule to a
container.
There have been a couple of revisions since then...I have just been
testing them before making it an official fix. Please test out the
attached version...it should fix your problems.
-Brendan
http://farcry.daemon.com.au
// get table name for db schema
tablename = this.getTablename();
// get extended properties for this instance
aProps = this.getProperties();
UPDATE #arguments.dbowner##tablename#
SET objectID =
, #propertyName# =
, #propertyName# = ''
>
arr_sql = "DELETE FROM #arguments.dbowner##tablename#_#propertyname# WHERE objectid = '#objectid#'";
arrayAppend(stQueries,arr_sql);
arr_sql = "
INSERT INTO #arguments.dbowner##tablename#_#propertyname#
(objectid,seq,data)
Values
('#objectid#',#j#,#preservesinglequotes(thisvalue)#)
";
arrayAppend(stQueries,arr_sql);
, #propertyName# =
, #propertyName# =
, #propertyName# =
, #propertyName# =
WHERE objectID =
#preservesinglequotes(thisSQL)#
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
