RE: get Range Between 2 IP addresses

2007-04-27 Thread Bobby Hartsfield
-Original Message- From: Elena Aminova [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 3:42 PM To: CF-Talk Subject: get Range Between 2 IP addresses What is the correct way to write the following? I need to redirect a user based on his/her IP address range if the CGI.REMOTE_ADDR

Re: get Range Between 2 IP addresses

2007-04-27 Thread Charlie Griefer
i don't believe that'll work as intended. you can always use listLast() using the period as a delimiter to get those last octals and -then- use the BETWEEN operator. also, you could convert the addresses to their integer counterparts. i believe the formula is: (first octet * 16777216) + (second

RE: get Range Between 2 IP addresses

2007-04-27 Thread Brad Wood
If you are only concerned with the last octet, you could treat the IP as a period delimited list like so: cfif listgetat(CGI.REMOTE_ADDR,4) gt 33 and listgetat(CGI.REMOTE_ADDR,4) lt 62 Not sure exactly you are going for though. ~Brad -Original Message- From: Elena Aminova [mailto:[EMAIL