Re: GeoIP for Coldfusion?
On 12/26/2011 2:44 AM, Phillip Vector wrote: > > Hrm.. The CSV's look feasible to use. Thanks. :) if you plan on using your db for this, might think again--performance won't be all that good. the binary version performs better. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
Hrm.. The CSV's look feasible to use. Thanks. :) On Sun, Dec 25, 2011 at 10:54 AM, Donnie Bachan (Gmail) wrote: > > FYI, http://www.maxmind.com/app/geolitecity, best to check with them > about your particular use case to ensure you are good to use the free > version. > > Best Regards, > Donnie Bachan > "Nitendo Vinces - By Striving You Shall Conquer" > == > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > On Sun, Dec 25, 2011 at 4:18 PM, Phillip Vector > wrote: >> >> *nods* I was looking for city and state actually. >> >> and it would need to be free. I can't drop $370 on this. >> >> On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) >> wrote: >>> >>> Although this isn't a completely free solution we've used it with very >>> good success without any updates for a while now. >>> http://www.maxmind.com/app/geoip_features. If you are using it for >>> just country level access for $50 it's not a bad investment. >>> >>> I've included some code for accessing checking the IP, once you have >>> the database loaded. Please note that the java database is much, much >>> faster than using the data in a database table. >>> >>> >> output="false"> >>> >> type="string" /> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> (CGI.REMOTE_ADDR)> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> isNumeric(aIPParts[1]) and >>> isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and >>> isNumeric(aIPParts[4])> >>> >> (aIPParts[2] * (256^2)) >>> + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> >>> >> datasource="#getDatasource()#"> >>> SELECT TOP 1 country FROM GeoIP >>> WHERE >>> CAST(#iIPNum# AS bigint) between >>> CAST(begin_num AS bigint) and >>> CAST(end_num AS bigint) >>> >>> >>> >>> >> datasource="#getDatasource()#"> >>> SELECT * FROM >>> countryBlacklist >>> WHERE country = >>> >> value="#getIP.country#" /> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> Hope this helps. >>> >>> Best Regards, >>> Donnie Bachan >>> "Nitendo Vinces - By Striving You Shall Conquer" >>> == >>> The information transmitted is intended only for the person or entity to >>> which it is addressed and may contain confidential and/or privileged >>> material. Any review, retransmission, dissemination or other use of, or >>> taking of any action in reliance upon, this information by persons or >>> entities other than the intended recipient is prohibited. If you received >>> this in error, please contact the sender and delete the material from any >>> computer. >>> >>> >>> >>> On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector >>> wrote: Is there a server side solution for GeoIP that I can use? I'd like to make ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
FYI, http://www.maxmind.com/app/geolitecity, best to check with them about your particular use case to ensure you are good to use the free version. Best Regards, Donnie Bachan "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Sun, Dec 25, 2011 at 4:18 PM, Phillip Vector wrote: > > *nods* I was looking for city and state actually. > > and it would need to be free. I can't drop $370 on this. > > On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) > wrote: >> >> Although this isn't a completely free solution we've used it with very >> good success without any updates for a while now. >> http://www.maxmind.com/app/geoip_features. If you are using it for >> just country level access for $50 it's not a bad investment. >> >> I've included some code for accessing checking the IP, once you have >> the database loaded. Please note that the java database is much, much >> faster than using the data in a database table. >> >> > output="false"> >> > type="string" /> >> >> >> >> >> >> >> >> >> >> >> > (CGI.REMOTE_ADDR)> >> >> >> >> >> >> >> >> >> >> > isNumeric(aIPParts[1]) and >> isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and >> isNumeric(aIPParts[4])> >> > (aIPParts[2] * (256^2)) >> + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> >> > datasource="#getDatasource()#"> >> SELECT TOP 1 country FROM GeoIP >> WHERE >> CAST(#iIPNum# AS bigint) between >> CAST(begin_num AS bigint) and >> CAST(end_num AS bigint) >> >> >> >> > datasource="#getDatasource()#"> >> SELECT * FROM countryBlacklist >> WHERE country = > cfsqltype="cf_sql_varchar" >> value="#getIP.country#" /> >> >> >> >> >> >> >> >> >> >> >> >> >> >> Hope this helps. >> >> Best Regards, >> Donnie Bachan >> "Nitendo Vinces - By Striving You Shall Conquer" >> == >> The information transmitted is intended only for the person or entity to >> which it is addressed and may contain confidential and/or privileged >> material. Any review, retransmission, dissemination or other use of, or >> taking of any action in reliance upon, this information by persons or >> entities other than the intended recipient is prohibited. If you received >> this in error, please contact the sender and delete the material from any >> computer. >> >> >> >> On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector >> wrote: >>> >>> Is there a server side solution for GeoIP that I can use? I'd like to >>> make up some CF code that can detect when sites are connecting in >>> area ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349242 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFimage to draw a triangle
t = ImageNew('', 300,300,'argb'); ImageSetAntialiasing(t); ImageSetDrawingColor(t,'00'); ImageDrawLines(t,[0,300,0],[0,150,300],'yes','yes'); ImageWrite(t,'/Users/andy/Sites/triangle.png'); -Original Message- From: Terry Troxel [mailto:terry.tro...@gmail.com] Sent: Sunday, December 25, 2011 9:34 AM To: cf-talk Subject: CFimage to draw a triangle Could someone show me the proper way to draw a filled triangle using CFimage? Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Status of Visual SQL builders for ColdFusion
Hi, At least 12 years ago I developped my own visual database management system, mainly because no one able to fulfill my needs was available on the market. This manager includes a powerful visual query builder which generated not only SQL code, but SQL integrated within CF code. Now that many new products are on the market, I wonder if one is able to do what I need or if I sould still use and support my own. For instance, my system is able to generate the followind code with only 10 clicks, no text to enter. Is this possible with any other SQL builder ? UPDATE docs SET public = , docTitle = , docNote = , fileName = , localName= , fileSize = , docDate = , docType = , timeDownloaded = , linkPage = , category = , membersOnly = WHERE docId = ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
*nods* I was looking for city and state actually. and it would need to be free. I can't drop $370 on this. On Sun, Dec 25, 2011 at 3:48 AM, Donnie Bachan (Gmail) wrote: > > Although this isn't a completely free solution we've used it with very > good success without any updates for a while now. > http://www.maxmind.com/app/geoip_features. If you are using it for > just country level access for $50 it's not a bad investment. > > I've included some code for accessing checking the IP, once you have > the database loaded. Please note that the java database is much, much > faster than using the data in a database table. > > output="false"> > type="string" /> > > > > > > > > > > > (CGI.REMOTE_ADDR)> > > > > > > > > > > isNumeric(aIPParts[1]) and > isNumeric(aIPParts[2]) and isNumeric(aIPParts[3]) and > isNumeric(aIPParts[4])> > (aIPParts[2] * (256^2)) > + (aIPParts[3] * (256^1)) + (aIPParts[4]) /> > datasource="#getDatasource()#"> > SELECT TOP 1 country FROM GeoIP > WHERE > CAST(#iIPNum# AS bigint) between > CAST(begin_num AS bigint) and > CAST(end_num AS bigint) > > > > datasource="#getDatasource()#"> > SELECT * FROM countryBlacklist > WHERE country = cfsqltype="cf_sql_varchar" > value="#getIP.country#" /> > > > > > > > > > > > > > > Hope this helps. > > Best Regards, > Donnie Bachan > "Nitendo Vinces - By Striving You Shall Conquer" > == > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector > wrote: >> >> Is there a server side solution for GeoIP that I can use? I'd like to >> make up some CF code that can detect when sites are connecting in >> areas we don't serve and direct them to a different page. Is there any >> (f ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFimage to draw a triangle
Could someone show me the proper way to draw a filled triangle using CFimage? Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: GeoIP for Coldfusion?
Although this isn't a completely free solution we've used it with very good success without any updates for a while now. http://www.maxmind.com/app/geoip_features. If you are using it for just country level access for $50 it's not a bad investment. I've included some code for accessing checking the IP, once you have the database loaded. Please note that the java database is much, much faster than using the data in a database table. SELECT TOP 1 country FROM GeoIP WHERE CAST(#iIPNum# AS bigint) between CAST(begin_num AS bigint) and CAST(end_num AS bigint) SELECT * FROM countryBlacklist WHERE country = Hope this helps. Best Regards, Donnie Bachan "Nitendo Vinces - By Striving You Shall Conquer" == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Sun, Dec 25, 2011 at 5:56 AM, Phillip Vector wrote: > > Is there a server side solution for GeoIP that I can use? I'd like to > make up some CF code that can detect when sites are connecting in > areas we don't serve and direct them to a different page. Is there any > (free) solutions for ColdFusion to detect where an IP is located? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm