Data set example:
Table name: Orders
*******************************************
BatchNumber, CheckNumber, Name
1111a, 1234, Joe Johnson
1111a, 1235, Mary Madison
12-32-1, 3434, Jon Johnson
12-32-1, 3453, Victoria V
********************************************
<cfquery name="getOrders" dataousre="#DSN#">
Select * from Orders
</cfquery>
<cfloop query="GetOrders">
<cfset thisBatch = GetOrders.BatchNumber>
<cfquery name="getBatchOrders" dbtype="query">
select *
from getOrders
where BatchNumber = '#thisBatch#'
</cfqery>
<cfloop query...>
....
</cfloop>
</cfloop>
The loop works until I reach the batch with two hyphens in it. It
handles numeric values, alphanumeric valuse, lenghts that are short and
long, and one hypen in the string... but once there are two hyphens in the
batch number it fails.
It is NOT a possiblity to restrict two hyphens on the input as this is
a potentially valid batch number. The SQL statement works as straight
SQL against the DB, but fails when queried against a query.
IS THIS A CF BUG?!!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the mailserver that powers this list at
http://www.houseoffusion.com/banners/view.cfm?bannerid=17
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182228
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
