RE: evaluate hell Pt2

2006-02-03 Thread Michael T. Tangorre
 From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
 cfif isdefined(GetInventory.#GetListingFields.DBColName#) and
 evaluate(GetInventory.#GetListingFields.DBColName#[#GetInvent
 ory.currentrow#])
 NEQ 0 AND
 Trim(evaluate(GetInventory.#GetListingFields.DBColName#[#GetI
 nventory.currentrow#]))
 NEQ 

Is GetListingFields a query also?

Just off the top of my head

isdefined(GetInventory[GetListingFields[DBColName]])
and
val(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow]) neq
0 
and
len(trim(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow])
) neq 0

Tango



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231319
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: evaluate hell Pt2

2006-02-03 Thread Adrian Lynch
cfif
IsDefined(GetInventory.#GetListingFields.DBColName#) AND
GetInventory[GetListingFields.DBColName][GetInventory.currentrow] NEQ 0 
AND
Trim(GetInventory[GetListingFields.DBColName][GetInventory.currentrow]) 
NEQ



-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: 03 February 2006 22:58
To: CF-Talk
Subject: evaluate hell Pt2


Need serious help rewriting this statement without using evaluate:

cfif isdefined(GetInventory.#GetListingFields.DBColName#) and
evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.currentrow
#])
NEQ 0 AND
Trim(evaluate(GetInventory.#GetListingFields.DBColName#[#GetInventory.curre
ntrow#]))
NEQ 

(I'm confused???)

Cutter



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54