Andrew
Dont say i never do anything for you:P
<cfscript>
function queryDeleteRow(query, row) {
var cols = structNew();
var i = 0;
var numberOfColumns = listLen(query.columnList);
var returnQry = queryNew("");
for (i = 1; i LTE numberOfColumns; i = i + 1) {
valueListStr =
evaluate("valueList(query.#listGetAt(query.columnList,
i)#)");
valueListStr = IIF(left(valueListStr, 1) EQ "," , DE("
"), DE("")) &
valueListStr & IIF(right(valueListStr, 1) EQ "," , DE(" "), DE(""));
"#listGetAt(query.columnList, i)#" =
listToArray("#replace(valueListStr,
',,', ', ,', 'ALL')#");
arrayDeleteAt(evaluate(listGetAt(query.columnList, i)),
row);
queryAddColumn(returnQry, listGetAt(query.columnList,
i),
evaluate(listGetAt(query.columnList, i)));
}
return returnQry;
}
</cfscript>
see how you go with that
Regards
Steve Onnis
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf
Of Andrew Mercer
Sent: Friday, April 07, 2006 5:54 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query function to delete a row from a query
doesnt look like you can do a delete in QoQ
On 4/7/06, Andrew Mercer <[EMAIL PROTECTED]> wrote:
Does anyone know if there is something like queryDeleteRow() {the opersite
of queryAddRow()} in CF?
google found this in a blueDragon file
otherwise I guess i will have to do a QoQ to do it
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
