Having a major braincramp right now.
Working on a "quick order entry form" that integrates with our ERP system via XML. Scenario is that a customer searches for a product or group of products. Results are parsed XML from the ERP system. Each row of the result has an item#, qty, uom, and price. The qty is a textfield, uom is a select, price and item# are hidden fields.
Anyway, when I type qty's in a handful of items and submit my form, it contains all items from the results page (which is fine for now). Some have qty's defined, others are null.
I'm looping params.item to get each individual row:
<cfloop collection="#params.item#" item="objProduct">
Now is where my brain cramp kicks in.
I need to check each item to make sure qty is not null (and eventually that it is numeric once I get the syntax right). BUT, I'm having a heck of time referencing the correct variable. This is what I have now:
<cfif isDefined('params.item[objProduct].qty') and #params.item[objProduct].qty# neq ''>
..And it's giving me
Parameter 1 of function IsDefined, which is now params.item[objProduct].qty, must be a syntactically valid variable name.
So, points for:
1. Helping me loop each row and check to make sure qty is defined and is numeric;
2. If qty passes the checks, inserting qty, item, price, and uom to orderlines table (MySQL)
Thanks in advance!