Here is what I want to do, I want to te a zone number to a canadian postal
code.
To do this I have to evaluate the first three chars.
Here is what I've done.
It's working most of the time but not any time.
Here is a working value H3S, and a not working value J7Z
Both should work ...
Someone out there tell me what's wrong please!!
<cfloop index="current"
list="A0AA2V:48,B0AB2T:44,B2VB4G:45,B4HB5A:44,C0AC1N:44,E0AE0L:44,E1AE1H:43,
E1JE2G:44,E2HE2S:43,E2VE2Z:43,E3AE3E:43,E3LE9H:44,G0BG0J:38,G0KG0V:37,G0XG0Z
:37,G1AG3G:39,G3JG4A:37,G4RG4Z:38,G5BG5C:38,G5HG6J:37,G6LG6T:37,G6VG7A:39,G7
BG8P:37,G8TG9X:37,H0AH9X:36,J0AJ0L:37,J0NJ0V:37,JOYJOZ:35,J1AJ3B:37,J3GJ3T:3
7,J3YJ5R:36,J5VJ5X:37,J5YJ6A:36,J6JJ6N:36,J6RJ6T:37,J6VJ7H:36,J7JJ7N:37,J7PJ
7R:36,J7XJ8C:37,J8HJ8V:37,J8XJ9A:25,J9HJ9J:37,J9LJ9Z:35,K0AK0M:32,K1AK4A:25,
K4BK9V:32,L0AL0J:32,L0KL0M:29,L0NL1E:32,L1GL1Z:31,L2AL2J:32,L2ML2W:33,L3BL3M
:32,L3PL3T:31,L3XL3Y:31,L4AL4L:31,L4ML4R:26,LASL7A:31,L7BL7C:32,L7EL7J:32,L7
LL9K:33,LP9L9R:32,L9VL9X:32,M1BM9W:31,N0AN1A:32,N1CN2V:34,N3BN3V:34,N3WN5R:3
2,N5VN6P:30,N7AN8M:32,N8NN9K:28,N9VN9Y:32,P0AP0S:29,P0TP0Y:27,P1AP2N:29,P6AP
6C:26,P7AP6C:26,P7AP9N:27,R0AR1N:22,R2CR4A:21,R4HR9A:22,S0AS4H:18,S4LS4Z:17,
S6HS6X:18,S7HS7V:19,S9AS9X:18,T0AT0G:13,T0JT0M:13,T1AT1W:13,T1XT3N:12,T3ZT4X
:13,T5AT6X:15,T7AT7Z:13,T8AT8C:15,T8ET8G:13,T8HT8J:15,T8ST8X:14,T9AT9G:13,T9
HT9K:14,T9MT9X:13,V0AV0B:07,V0EV0H:07,V0KV0L:07,V0MV0S:05,V0TV0W:11,V1AV1E:0
7,V1NV2E:07,V2KV2N:11,V2PV2R:05,V2SV4S:04,V4TV4V:07,V4WV4X:04,V5AV7Y:04,V8CV
8G:11,V8KV8M:05,V8NV9E:03,V9GV9P:05,V9RV9V:03,X0AX0C:22,X0EX1A:14,Y0AY1A:11"
>
<cfset StartRange = #LEFT("#current#",3)#>
<cfset EndRange = #MID("#current#",4,3)#>
<cfset ZoneRange = #right("#current#",2)#>
<CFIF #LEFT("#ATTRIBUTES.POSTAL_CODE#",1)# EQ #Left(StartRange,1)#>
<CFIF #RIGHT("#LEFT("#ATTRIBUTES.POSTAL_CODE#",2)#",1)# GTE
#Mid(StartRange,2,1)#
AND
#RIGHT("#LEFT("#ATTRIBUTES.POSTAL_CODE#",2)#",1)# LTE #Mid(EndRange,2,1)#>
<CFIF
#RIGHT("#LEFT("#ATTRIBUTES.POSTAL_CODE#",3)#",1)# GTE #Right(StartRange,1)#
AND
#RIGHT("#LEFT("#ATTRIBUTES.POSTAL_CODE#",3)#",1)# LTE #Right(EndRange,1)#>
<CFSET Zone = #ZoneRange#>
</cfif>
</cfif>
</cfif>
</cfloop>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
