><cfif Len(instructorid) AND Len(lastname) AND Len(firstname) AND en(URL.EID)>
>Add data to the db
><cfelse>
>Build a query in cf memory of bad data
></cfif>
>The problem is, empty strings are slippin thru and I end up with rows
>of empty trings. Then my process bombs out because it tries looping over
>these empty string columns and can't find an index.
Will,
I'm starting to wonder if we're misinterpreting the problem. Is the problem
the db insert or the second step: "Build a query in cf memory of bad data"?
If you want to eliminate empty rows from the second step, test the length of
the values again before adding them to the query. If _at_least_one_ of the
values is not an empty string, add it to the "bad data" query. Is that what
you mean?
<cfif len(trim(instructorid)) gt 0 OR
len(trim(lastname)) gt 0 OR
len(trim(firstname)) gt 0 >
At least one field is non-empty! Add row to "bad data" query
</cfif>
Janet
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284286
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
