date:20070206

On Monday 05 Feb 2007, Rick Faircloth wrote:
With MS SQL Express Edition out, which is free, that may be a good
alternative for me, too...

Reason #234 why MySQL will stay free :-)

--
Tom Chiverton
Helping to enthusiastically differentiate sexy interfaces

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at St
James's Court Brown Street Manchester M2 2JF. A list of members is available
for inspection at the registered office. Any reference to a partner in relation
to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law
Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be
confidential or legally privileged. If you are not the addressee you must not
read it and must not use any information contained in nor copy it nor inform
any person other than Halliwells LLP or the addressee of its existence or
contents. If you have received this email in error please delete it and notify
Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268781
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

On Monday 05 Feb 2007, Doug Brown wrote:
Pretty cool. I would say that the only thing stopping me from hosting
myself would be the costs involved in coldfusion server.

There are free CFML servers, some from Adobe (depending on what you want it
for).
My excuse for not running one is my server isn't up to it (yet !).

--
Tom Chiverton
Helping to heterogeneously integrate high-end portals

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268782
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OT: MySql going public (No more freebies)

2007-02-06 Thread James Holmes

I'm going to try out Oracle Express too ;-)

On 2/6/07, Tom Chiverton [EMAIL PROTECTED] wrote:
 On Monday 05 Feb 2007, Rick Faircloth wrote:
  With MS SQL Express Edition out, which is free, that may be a good
  alternative for me, too...

 Reason #234 why MySQL will stay free :-)


-- 
CFAJAX docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268783
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Claude Schneegans

 People said that about Linux too, but things change.

People said that about Unix too, about 30 years ago, and nothing has 
changed ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268784
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Setting properties in COM objects

2007-02-06 Thread Jerry Kew

Hi, I am integrating ABCpdf into my site, and I can do some stuff quite easily 
e.g this works:


cfobject action=create name=theDoc type = COM class=ABCpdf6.doc
cfset theDoc.FontSize = 96
cfset theDoc.AddText(Hello World)
cfset theDoc.Save(C:\htmlimport.pdf)

Now I am trying to set a deeper property, the help for the product says:

Set theDoc = Server.CreateObject(ABCpdf6.Doc)
theDoc.Rect.Inset 72, 144

So, my challenge is to set 'theDoc.Rect.Inset' but it seems to error however I 
set the cfset, what should the cfset syntaxt be here?

Thank you

Jerry

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268785
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

On Monday 05 Feb 2007, Robertson-Ravo, Neil (RX) wrote:
And more to the point, who cares? Not to be the spoiler of the partay but I
mean in all reality how many people, currently on CF/BD would consider a
move to Smith? just because it is free.

The flip side, is how many people will now look at CF, who didn't before,
because it has a reputation as expensive.

--
Tom Chiverton
Helping to biannually extend unique deliverables

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268786
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Gert Franz

Well all the ones that hear, that there are alternatives with low or no 
costs at all. Like Railo or Smith.

Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch

Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/



Tom Chiverton schrieb:
 On Monday 05 Feb 2007, Robertson-Ravo, Neil (RX) wrote:
   
 And more to the point, who cares? Not to be the spoiler of the partay but I
 mean in all reality how many people, currently on CF/BD would consider a
 move to Smith? just because it is free.
 

 The flip side, is how many people will now look at CF, who didn't before, 
 because it has a reputation as expensive.

   


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268787
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

I think that will depend on how many pure java developers are out there in
coldfusion land that could help out. I for one cannot as I know squat about
Java. If I could help in another way, then I would be very glad to.


Doug B.


- Original Message - 
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 1:53 AM
Subject: Re: Take a minute to Digg this story about the Smith Project


 All I read is words like expect, need, want and free. Those
 words are not the words that will convince the code owners to opensource
 Smith. If nobody is going to write about offer help, invest time,
 employ maintainers or sponsor features I think this thread is pretty
 pointless.

 So who of you that want Smith intend to do something for it?

 Jochem

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268788
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Adrian Lynch

By using it!

Who isn't gonna download it and take a look?

Funny story, I was looking down the list of supported tags and misread it
thinking it said no to cfloop! WHAT!

Adrian

-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: 06 February 2007 12:57
To: CF-Talk
Subject: Re: Take a minute to Digg this story about the Smith Project


I think that will depend on how many pure java developers are out there in
coldfusion land that could help out. I for one cannot as I know squat about
Java. If I could help in another way, then I would be very glad to.


Doug B.


- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 1:53 AM
Subject: Re: Take a minute to Digg this story about the Smith Project


 All I read is words like expect, need, want and free. Those
 words are not the words that will convince the code owners to opensource
 Smith. If nobody is going to write about offer help, invest time,
 employ maintainers or sponsor features I think this thread is pretty
 pointless.

 So who of you that want Smith intend to do something for it?

 Jochem


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268789
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Setting properties in COM objects

2007-02-06 Thread Mike Tangorre

 From: Jerry Kew [mailto:[EMAIL PROTECTED]
 Set theDoc = Server.CreateObject(ABCpdf6.Doc)
 theDoc.Rect.Inset 72, 144


Just a shot in the dark as I am not familiar with the COM object you're
using.

theDoc.Rect.Inset(72,144)








~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

Another thing I would like to point out is this. How many times do we speak
and nobody listens in regards to new features? How long has some of the same
bugs been around? IE: (CFMAIL) As an open source project, you could have
these things addressed in the community and not have to beg a corporation
for the changes. You would also not have to buy the new version with the bug
fixes and new features everytime a new version came out. The one downfall in
all of this, is that some clients will not want to host their own
applications and therefore smith must adhere to the tags and functions that
are available to use in the adobe product. Railo has features that Adobe's
product does not, and if you use any of those features, your app is going to
break if you have it hosted on an Adobe Coldfusion server. It will be a long
time before hosting companies take hold and use Smith.



Doug


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Browser taking too much time in rendering the table data on screen

2007-02-06 Thread hussain shaikh

I am working on a coldfusion page in which I am displaying the Query result on 
the screen in a table.But before displaying the data in the cells I am 
performing some checks on it.So by the time the browser displays the 100 
records on the screen it eats up lot of time.
I tried creating table for each row so that the data is displayed as it fetches 
it but here the problem is aligning successive tables.So the screen is 
cluttered as there is no alignment of the tables.
Following is the sample code which I tried:-
cfoutput query=Counter startrow=1 maxrows=100
table
tr
td./td
td./td
/tr
tr
td./td
td./td
/tr
/table
/cfoutput

Is there any other alternative to this?

Thanks in advance,
Hussain.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Browser taking too much time in rendering the table data on screen

2007-02-06 Thread Claude Schneegans

 I tried creating table for each row so that the data is displayed as 
it fetches it but here the problem is aligning successive tables.

You could declare fixed width for each cell.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268793
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF and Legacy Systems... Need Some Advice/Help

Good morning all. I have a client that has a CF based website (built by
myself around 5 years ago) and a SCO Unix Open Server backend. It's a legacy
system with software that's been heavily modified over the last 20-25 years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and to
get with 21st century. They wish to add a live inventory and live credit
card processing feature to their website.

Though I have done this type of work in the past, I have never worked with a
legacy system to complete this. And, to complicate matters, the software
technicians that administer the SCO Unix Open Server DO NOT wish to use a
HTTP protocol to communicate between the two servers. They tell me that they
wish to communicate to my CF server via the FTP protocol.

A basic interaction would go something like this. A customer would attempt
to place an item in their shopping cart. Before the item is added to the
cart an inventory check is made. A CF process would write an XML file and
FTP it to the remote SCO Unix Open Server. The remote server would then
respond and push a response file back to the CF server. The CF server would
process the file and determine a Yes/No answer and either add the item to
the cart or display a message that the item is out of stock to the customer.

I was wondering, can this even be done with CF and the FTP protocol instead
of using HTTP? With HTTP, this would be relatively easy with the cfhttp
tag. With FTP, I am not sure how the communication would work. :(

In my mind, even if I used the CF Event Gateway to monitor a predefined
directory for FTP traffic... I cannot figure out how to parse the FTP file
and send the response back to the right shopping cart.

Does that make sense? Any help anyone could provide me would be much
appreciated.

Regards, Che

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

On Tuesday 06 Feb 2007, Adrian Lynch wrote:
Funny story, I was looking down the list of supported tags and misread it
thinking it said no to cfloop! WHAT!

The lack of cflog is a slight pain.

--
Tom Chiverton
Helping to enormously customize dot-com functionalities

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268795
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Ebay-like auction written in CFM?

2007-02-06 Thread Ali Majdzadeh

Hi everybody:
I am searching for an open source or commercial ebay-like auction application 
written in CFM/MSSQL or ACCESS. Do you know one?
Thanks
Ali

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Ebay-like auction written in CFM?

I believe you can still buy the developer edition of AuctionBuilder. It is
no longer a supported product though.
http://www.ablecommerce.com/AuctionBuilder-C30.aspx

Doug B.



- Original Message - 
From: Ali Majdzadeh [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 5:32 AM
Subject: Ebay-like auction written in CFM?


 Hi everybody:
 I am searching for an open source or commercial ebay-like auction
application written in CFM/MSSQL or ACCESS. Do you know one?
 Thanks
 Ali

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268797
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Postal Code database and proximity

Russ - can you help me out here a little bit?

I'd like to be able to run a query like this:

select *
from prospects
where prospects.zipcode in
 (select zipcode from zipcodes
  where getDistance(prospect.zipcode, zipcode.zipcode) = 25)

How would I do that?


On 2/5/07, Russ [EMAIL PROTECTED] wrote:

 Christopher, I highly recommend you put in some kind of function to
 calculate the distance into SQL serer.

 CREATE FUNCTION [dbo].[getDistance]
 (
@lat1 numeric(9,6),
@lon1 numeric(9,6),
@lat2 numeric(9,6),
@lon2 numeric(9,6)
 )
 RETURNS NUMERIC( 10, 5 )
 AS
 BEGIN
DECLARE @x decimal(20,10)
DECLARE @pi decimal(21,20)
SET @pi = 3.14159265358979323846
SET @x = sin( @lat1 * @pi/180 ) * sin( @lat2 * @pi/180  ) + cos(
 @lat1 [EMAIL PROTECTED]/180 ) * cos( @lat2 * @pi/180 ) * cos( abs( (@lon2 * 
 @pi/180) -
 (@lon1 [EMAIL PROTECTED]/180) ) )
SET @x = atan( ( sqrt( 1- power( @x, 2 ) ) ) / @x )
RETURN ( 1.852 * 60.0 * ((@x/@pi)*180) ) / 1.609344
 END



 Then your can fairly easily write a query that brings zip codes within a
 certain distance.

 Russ

  -Original Message-
  From: Christopher Jordan [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 05, 2007 4:08 PM
  To: CF-Talk
  Subject: Re: Postal Code database and proximity
 
  Rick,
 
  I bought a zip code table from some company for $39 bucks or there
  abouts. The following queries then get run against the table:
  cfquery name=zipcode datasource=MyDSN
  SELECT DISTINCT latitude,longitude
  FROM AmericanZipCodes
  WHERE zip = '#form.zipcode#'
  /cfquery
 
 
  cfquery name=ZipCode datasource=MyDSN
   SELECT zip,ROUND((ACOS((SIN(#latitude#/57.2958) *
  SIN(latitude/57.2958)) + (COS(#latitude#/57.2958) *
  COS(latitude/57.2958) * COS(longitude/57.2958 - #longitude#/57.2958
  * 3963, 0) AS distance
 
   FROM AmericanZipCodes
 
  WHERE (latitude = #latitude# - (#form.radius#*.009009)) AND (latitude
  = #latitude# + (#form.radius#*.009009)) AND (longitude = #longitude# -
  (#form.radius#*.009009)) AND (longitude = #longitude# +
  (#form.radius#*.009009))
 
   ORDER BY distance
  /cfquery
 
  I did not do the math on this. Thankfully that was done by the folks who
  previously did work for my client... otherwise I'd have been in the same
  boat as you looking for how the hell to do this sort of thing. :o)
 
  I hope this helps. If you need to know where I got the database from.
  Just give a holler and I'll try to dig it up. :o)
 
  Cheers,
  Chris
 
 
  Jordan Michaels wrote:
   We're currently putting something together like this that checks to
 see
   if two addresses are within a certain mile radius using the Google
 Maps
  API.
  
   Not a simple process, but we think we can make it do what we want it
 to.
  
   HTH!
  
   Warm regards,
   Jordan Michaels
   Vivio Technologies
   http://www.viviotech.net/
   Blue Dragon Alliance Member
   [EMAIL PROTECTED]
  
  
   Rick Root wrote:
  
   Is anyone out there using within 25 miles of zipcode for
 searching
   address database?
  
   I've gotten a request where someone is visiting a certain zip code
 and
  they
   want to know all the prospects within a 25 mile radius of the zip
 code
   they're visiting.
  
   I know there are ways to do this.. just wondered what people out
 there
  are
   using.
  
   Thanks!
  
   Rick
  
  
  
  
 
 

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268798
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: moving from CF 4.5 to 7.0

2007-02-06 Thread Pete Ruckelshaus

The biggest difference for our code was that we could no longer
shorthand scopes.  I.e., in 5 and below, cfset tmp.varname =
value would create a scope called tmp and a variable named
varname within the tmp scope.  In MX, you need to cfset tmp =
structnew() and then you can cfset tmp.varname = value

You might also want to look into how the application.cfc differs
from/is superior to the application.cfm file, and also look at UDF's
and CFC's and how they can improve your current codebase.

At my last full-time gig (I now primarily do contract work, which
suits me fine), our team manager decided to make the switch from CF5
to CF6.1 less than a week before a major release; it was a nightmare
in that it did not allow us sufficient time to fully test the
application.  CFMX app server tuning is also a bit more of a black art
than it was with 5 and below.

Pete

On 2/5/07, So Kenfused [EMAIL PROTECTED] wrote:
 Just started a new job and they are looking at moving from CF 4.5 to CF7.  We 
 do have a Dev box, so we can play a little before doing it on the production 
 boxes.

 I'm finding several posts about going from 4.5 to 5, or MX and the issues 
 people ran into however, I am wondering if anyone who has made the jump from 
 4.5 to 7 can provide details to any issues they might have experienced.




 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268799
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Dan G. Switzer, II

Che,

While it could be done, using FTP is going to be extremely sluggish--unless
you can manage to keep the FTP session open all day. 

If you have to log in for each request, you're going to end up adding a good
second or two to the entire process just for the FTP authentication
operations. That's going to seem like forever to a customer on their
website.

If the client insists on FTP, I'd probably look into writing/finding an
application that would monitor a specific folder and push any new files to
the FTP server--something that would run as a service and would maintain the
FTP session.

That way you'd simply write a file to one folder, it would be pushed to the
SCO server and then when it's done it would push a result back to another
folder on your server.

It still might be too sluggish, but it would seem like the best method for
managing this problem.

-Dan


-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 8:32 AM
To: CF-Talk
Subject: CF and Legacy Systems... Need Some Advice/Help

Good morning all. I have a client that has a CF based website (built by
myself around 5 years ago) and a SCO Unix Open Server backend. It's a
legacy
system with software that's been heavily modified over the last 20-25
years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and to
get with 21st century. They wish to add a live inventory and live credit
card processing feature to their website.

Though I have done this type of work in the past, I have never worked with
a
legacy system to complete this. And, to complicate matters, the software
technicians that administer the SCO Unix Open Server DO NOT wish to use a
HTTP protocol to communicate between the two servers. They tell me that
they
wish to communicate to my CF server via the FTP protocol.

A basic interaction would go something like this. A customer would attempt
to place an item in their shopping cart. Before the item is added to the
cart an inventory check is made. A CF process would write an XML file and
FTP it to the remote SCO Unix Open Server. The remote server would then
respond and push a response file back to the CF server. The CF server would
process the file and determine a Yes/No answer and either add the item to
the cart or display a message that the item is out of stock to the
customer.

I was wondering, can this even be done with CF and the FTP protocol instead
of using HTTP? With HTTP, this would be relatively easy with the cfhttp
tag. With FTP, I am not sure how the communication would work. :(

In my mind, even if I used the CF Event Gateway to monitor a predefined
directory for FTP traffic... I cannot figure out how to parse the FTP file
and send the response back to the right shopping cart.

Does that make sense? Any help anyone could provide me would be much
appreciated.

Regards, Che




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF and Legacy Systems... Need Some Advice/Help

On Tuesday 06 Feb 2007, Che Vilnonis wrote:
I was wondering, can this even be done with CF and the FTP protocol instead
of using HTTP? With HTTP, this would be relatively easy with the cfhttp
tag. With FTP, I am not sure how the communication would work. :(

Yeah, you can do it.
If you have a version of CF that can use the event gateway / directory watcher
it may even not be utterly horrible.

directory for FTP traffic... I cannot figure out how to parse the FTP file
and send the response back to the right shopping cart.

You'd have to have the response XML include some sort of user or session
token.

The end result will be a unresponsive GUI that hangs around a lot
saying 'please wait... adding item to cart' and similar. Eww. But you know
that :-)

--
Tom Chiverton
Helping to authoritatively scale six-generation infrastructures

This email is sent for and on behalf of Halliwells LLP.

CONFIDENTIALITY

For more information about Halliwells LLP visit www.halliwells.com.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268801
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Postal Code database and proximity

by the way I know the below wouldn't work...

What I need is a function or stored proc that returns a list of zip codes
within a given distance from a specified zip code.

Ie,

select * from zipcodes where getDistanceFrom('27502')  10



On 2/6/07, Rick Root [EMAIL PROTECTED] wrote:

 Russ - can you help me out here a little bit?

 I'd like to be able to run a query like this:

 select *
 from prospects
 where prospects.zipcode in
  (select zipcode from zipcodes
   where getDistance(prospect.zipcode, zipcode.zipcode) = 25)

 How would I do that?


  On 2/5/07, Russ [EMAIL PROTECTED] wrote:
 
  Christopher, I highly recommend you put in some kind of function to
  calculate the distance into SQL serer.
 
  CREATE FUNCTION [dbo].[getDistance]
  (
 @lat1 numeric(9,6),
 @lon1 numeric(9,6),
 @lat2 numeric(9,6),
 @lon2 numeric(9,6)
  )
  RETURNS NUMERIC( 10, 5 )
  AS
  BEGIN
 DECLARE @x decimal(20,10)
 DECLARE @pi decimal(21,20)
 SET @pi = 3.14159265358979323846
 SET @x = sin( @lat1 * @pi/180 ) * sin( @lat2 * @pi/180  ) + cos(
  @lat1 [EMAIL PROTECTED]/180 ) * cos( @lat2 * @pi/180 ) * cos( abs( (@lon2 * 
  @pi/180)
  -
  (@lon1 [EMAIL PROTECTED]/180) ) )
 SET @x = atan( ( sqrt( 1- power( @x, 2 ) ) ) / @x )
 RETURN ( 1.852 * 60.0 * ((@x/@pi)*180) ) / 1.609344
  END
 
 
 
  Then your can fairly easily write a query that brings zip codes within a
 
  certain distance.
 
  Russ
 
   -Original Message-
   From: Christopher Jordan [mailto:[EMAIL PROTECTED]
   Sent: Monday, February 05, 2007 4:08 PM
   To: CF-Talk
   Subject: Re: Postal Code database and proximity
  
   Rick,
  
   I bought a zip code table from some company for $39 bucks or there
   abouts. The following queries then get run against the table:
   cfquery name=zipcode datasource=MyDSN
   SELECT DISTINCT latitude,longitude
   FROM AmericanZipCodes
   WHERE zip = '#form.zipcode#'
   /cfquery
  
  
   cfquery name=ZipCode datasource=MyDSN
SELECT zip,ROUND((ACOS((SIN(#latitude#/57.2958) *
   SIN(latitude/57.2958)) + (COS(#latitude#/57.2958) *
   COS(latitude/57.2958) * COS(longitude/57.2958 -
  #longitude#/57.2958
   * 3963, 0) AS distance
  
FROM AmericanZipCodes
  
   WHERE (latitude = #latitude# - (#form.radius#*.009009)) AND (latitude
   = #latitude# + (#form.radius#*.009009)) AND (longitude = #longitude#
  -
   (#form.radius#*.009009)) AND (longitude = #longitude# +
   (#form.radius#*.009009))
  
ORDER BY distance
   /cfquery
  
   I did not do the math on this. Thankfully that was done by the folks
  who
   previously did work for my client... otherwise I'd have been in the
  same
   boat as you looking for how the hell to do this sort of thing. :o)
  
   I hope this helps. If you need to know where I got the database from.
   Just give a holler and I'll try to dig it up. :o)
  
   Cheers,
   Chris
  
  
   Jordan Michaels wrote:
We're currently putting something together like this that checks to
  see
if two addresses are within a certain mile radius using the Google
  Maps
   API.
   
Not a simple process, but we think we can make it do what we want it
  to.
   
HTH!
   
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon Alliance Member
[EMAIL PROTECTED]
   
   
Rick Root wrote:
   
Is anyone out there using within 25 miles of zipcode for
  searching
address database?
   
I've gotten a request where someone is visiting a certain zip code
  and
   they
want to know all the prospects within a 25 mile radius of the zip
  code
they're visiting.
   
I know there are ways to do this.. just wondered what people out
  there
   are
using.
   
Thanks!
   
Rick
   
   
   
   
  
  
 
  

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268802
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF and Legacy Systems... Need Some Advice/Help

Thanks Dan. My thoughts exactly. In my mind, the SCO software technicians
simply don't want to add a webserver because of the increased security
issues that would arise. And yes, it *would* be terribly slow.

Che

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 9:09 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help

Che,

While it could be done, using FTP is going to be extremely sluggish--unless
you can manage to keep the FTP session open all day. 

If you have to log in for each request, you're going to end up adding a good
second or two to the entire process just for the FTP authentication
operations. That's going to seem like forever to a customer on their
website.

If the client insists on FTP, I'd probably look into writing/finding an
application that would monitor a specific folder and push any new files to
the FTP server--something that would run as a service and would maintain the
FTP session.

That way you'd simply write a file to one folder, it would be pushed to the
SCO server and then when it's done it would push a result back to another
folder on your server.

It still might be too sluggish, but it would seem like the best method for
managing this problem.

-Dan

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 8:32 AM
To: CF-Talk
Subject: CF and Legacy Systems... Need Some Advice/Help

Good morning all. I have a client that has a CF based website (built by 
myself around 5 years ago) and a SCO Unix Open Server backend. It's a 
legacy system with software that's been heavily modified over the last 
20-25 years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and 
to get with 21st century. They wish to add a live inventory and live 
credit card processing feature to their website.

Though I have done this type of work in the past, I have never worked 
with a legacy system to complete this. And, to complicate matters, the 
software technicians that administer the SCO Unix Open Server DO NOT 
wish to use a HTTP protocol to communicate between the two servers. 
They tell me that they
wish to communicate to my CF server via the FTP protocol.

A basic interaction would go something like this. A customer would 
attempt to place an item in their shopping cart. Before the item is 
added to the cart an inventory check is made. A CF process would 
write an XML file and FTP it to the remote SCO Unix Open Server. The 
remote server would then respond and push a response file back to the 
CF server. The CF server would process the file and determine a Yes/No 
answer and either add the item to the cart or display a message that 
the item is out of stock to the customer.

I was wondering, can this even be done with CF and the FTP protocol 
instead of using HTTP? With HTTP, this would be relatively easy with 
the cfhttp tag. With FTP, I am not sure how the communication would 
work. :(

In my mind, even if I used the CF Event Gateway to monitor a predefined 
directory for FTP traffic... I cannot figure out how to parse the FTP 
file and send the response back to the right shopping cart.

Does that make sense? Any help anyone could provide me would be much 
appreciated.

Regards, Che

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Jochem van Dieten

Che Vilnonis wrote:
Good morning all. I have a client that has a CF based website (built by
myself around 5 years ago) and a SCO Unix Open Server backend. It's a legacy
system with software that's been heavily modified over the last 20-25 years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and to
get with 21st century. They wish to add a live inventory and live credit
card processing feature to their website.

That would not be my preferred option.

I was wondering, can this even be done with CF and the FTP protocol instead
of using HTTP?

Yes. But the question is, what response time can the software
technicians guarantee from the moment you start your FTP transaction to
the moment they complete theirs? Will they guarantee a sub-second
response time (which an interactive website needs).

It is probably easier not to use an event gateway at all and just FTP to
them, sleep for a second and parse the result (because they are
guaranteeing sub-second response times, right?).

Jochem

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268804
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF and Legacy Systems... Need Some Advice/Help

Yeah... what Tom said... Eww. Now, I have to go do some convincing.

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 9:10 AM
To: CF-Talk
Subject: Re: CF and Legacy Systems... Need Some Advice/Help

On Tuesday 06 Feb 2007, Che Vilnonis wrote:
 I was wondering, can this even be done with CF and the FTP protocol 
 instead of using HTTP? With HTTP, this would be relatively easy with 
 the cfhttp tag. With FTP, I am not sure how the communication would 
 work. :(

Yeah, you can do it.
If you have a version of CF that can use the event gateway / directory
watcher 
it may even not be utterly horrible.

 directory for FTP traffic... I cannot figure out how to parse the FTP 
 file and send the response back to the right shopping cart.

You'd have to have the response XML include some sort of user or session 
token.

The end result will be a unresponsive GUI that hangs around a lot 
saying 'please wait... adding item to cart' and similar. Eww. But you know 
that :-)

-- 
Tom Chiverton
Helping to authoritatively scale six-generation infrastructures

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
St James's Court Brown Street Manchester M2 2JF.  A list of members is
available for inspection at the registered office. Any reference to a
partner in relation to Halliwells LLP means a member of Halliwells LLP.
Regulated by the Law Society.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 8008.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268805
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Peterson, Chris

Why not just look into an ODBC connection to the database on the legacy
system?  It may not be the best thing in the world, but if you setup
permissions properly for the connecting user you shouldn't be exposed to
anything bad.  Maybe the inventory check can go over ODBC and the actual
order can be an FTP'd XML file?

Chris 

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 9:16 AM
To: CF-Talk
Subject: Re: CF and Legacy Systems... Need Some Advice/Help

Che Vilnonis wrote:
 Good morning all. I have a client that has a CF based website (built
by
 myself around 5 years ago) and a SCO Unix Open Server backend. It's a
legacy
 system with software that's been heavily modified over the last 20-25
years.
 Neither system communicates with the other.
 
 The client is looking to streamline the order fulfillment process and
to
 get with 21st century. They wish to add a live inventory and live
credit
 card processing feature to their website.
 
 Though I have done this type of work in the past, I have never worked
with a
 legacy system to complete this. And, to complicate matters, the
software
 technicians that administer the SCO Unix Open Server DO NOT wish to
use a
 HTTP protocol to communicate between the two servers. They tell me
that they
 wish to communicate to my CF server via the FTP protocol.

That would not be my preferred option.


 A basic interaction would go something like this. A customer would
attempt
 to place an item in their shopping cart. Before the item is added to
the
 cart an inventory check is made. A CF process would write an XML
file and
 FTP it to the remote SCO Unix Open Server. The remote server would
then
 respond and push a response file back to the CF server. The CF server
would
 process the file and determine a Yes/No answer and either add the item
to
 the cart or display a message that the item is out of stock to the
customer.
 
 I was wondering, can this even be done with CF and the FTP protocol
instead
 of using HTTP?

Yes. But the question is, what response time can the software 
technicians guarantee from the moment you start your FTP transaction to 
the moment they complete theirs? Will they guarantee a sub-second 
response time (which an interactive website needs).


 In my mind, even if I used the CF Event Gateway to monitor a
predefined
 directory for FTP traffic... I cannot figure out how to parse the FTP
file
 and send the response back to the right shopping cart.

It is probably easier not to use an event gateway at all and just FTP to

them, sleep for a second and parse the result (because they are 
guaranteeing sub-second response times, right?).

Jochem



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268806
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Turetsky, Seth

It will be a long time before hosting companies take hold and use Smith.
Correct me if I'm wrong, but since it's just a jar file and not an install, why 
would a hosting company be involved with any decision over using Smith or not?  
You would just need to know what JDK they support

I agree though about our code slowly becoming less portable.  Ie, BD has 
features as well that Coldfusion doesn't support and vice versa, so I think 
using new tag/functions(just for the f$^) of it may not be such a great idea.

-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 8:18 AM
To: CF-Talk
Subject: Re: Take a minute to Digg this story about the Smith Project

Another thing I would like to point out is this. How many times do we speak and 
nobody listens in regards to new features? How long has some of the same bugs 
been around? IE: (CFMAIL) As an open source project, you could have these 
things addressed in the community and not have to beg a corporation for the 
changes. You would also not have to buy the new version with the bug fixes and 
new features everytime a new version came out. The one downfall in all of this, 
is that some clients will not want to host their own applications and therefore 
smith must adhere to the tags and functions that are available to use in the 
adobe product. Railo has features that Adobe's product does not, and if you use 
any of those features, your app is going to break if you have it hosted on an 
Adobe Coldfusion server. It will be a long time before hosting companies take 
hold and use Smith.



Doug




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268807
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Cutter (CFRelated)

Well, I am not versed enough in Java to assist in development. However,
some of us know how to write documentation. I am sure someone out there
can assist with maintenance of the Smith website. Someone probably knows
something or other about moderating mailing lists and forums. There are
probably some people who don't know much about programming in Java, but
know enough to provide research into libraries that could assist in
providing information/direction in implementing currently unsupported
features (i.e.: mapping out the functions of the iText library to
implement cfreport features). If it were open sourced, someone could
provide hosting for the project, maintain the subversion repository,
setup and maintain a trac system, or even assist from a project
management standpoint. Plus, if someone offered, or if the project
accepted it, their are probably ways to donate to the project
monetarily, which helps the core development team maintain a living
while working on a project that benefits the community as a whole by
providing each of us with options.

Cutter

http://blog.cutterscrossing.com

Doug Brown wrote:
I think that will depend on how many pure java developers are out there in
coldfusion land that could help out. I for one cannot as I know squat about
Java. If I could help in another way, then I would be very glad to.

Doug B.

- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 1:53 AM
Subject: Re: Take a minute to Digg this story about the Smith Project

All I read is words like expect, need, want and free. Those
words are not the words that will convince the code owners to opensource
Smith. If nobody is going to write about offer help, invest time,
employ maintainers or sponsor features I think this thread is pretty
pointless.

So who of you that want Smith intend to do something for it?

Jochem

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268808
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Ebay-like auction written in CFM?

2007-02-06 Thread Peterson, Chris

You can check out Beyond Solutions www.beyondsolutions.com

Chris
 

-Original Message-
From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 7:32 AM
To: CF-Talk
Subject: Ebay-like auction written in CFM?

Hi everybody:
I am searching for an open source or commercial ebay-like auction
application written in CFM/MSSQL or ACCESS. Do you know one?
Thanks
Ali



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268809
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Cutter (CFRelated)

Che,

That is unfortunate, and terribly short sighted on their part. It is 
actually fairly easy to limit port 80 traffic to specific IP addresses, 
thereby limiting communication to their server only from the webserver 
itself. They could even set it up so that the web traffic used a 
non-standard port, to which your server requests would specify in the 
http requests. The security issue is valid, but they aren't thinking 
outside of the box, which will potentially cost them a worthwhile 
application.

Cutter
_
http://blog.cutterscrossing.com

Che Vilnonis wrote:
 Thanks Dan. My thoughts exactly. In my mind, the SCO software technicians
 simply don't want to add a webserver because of the increased security
 issues that would arise. And yes, it *would* be terribly slow.
 
 Che
 
 -Original Message-
 From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, February 06, 2007 9:09 AM
 To: CF-Talk
 Subject: RE: CF and Legacy Systems... Need Some Advice/Help
 
 
 Che,
 
 While it could be done, using FTP is going to be extremely sluggish--unless
 you can manage to keep the FTP session open all day. 
 
 If you have to log in for each request, you're going to end up adding a good
 second or two to the entire process just for the FTP authentication
 operations. That's going to seem like forever to a customer on their
 website.
 
 If the client insists on FTP, I'd probably look into writing/finding an
 application that would monitor a specific folder and push any new files to
 the FTP server--something that would run as a service and would maintain the
 FTP session.
 
 That way you'd simply write a file to one folder, it would be pushed to the
 SCO server and then when it's done it would push a result back to another
 folder on your server.
 
 It still might be too sluggish, but it would seem like the best method for
 managing this problem.
 
 -Dan
 
 
 
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 8:32 AM
To: CF-Talk
Subject: CF and Legacy Systems... Need Some Advice/Help

Good morning all. I have a client that has a CF based website (built by 
myself around 5 years ago) and a SCO Unix Open Server backend. It's a 
legacy system with software that's been heavily modified over the last 
20-25 years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and 
to get with 21st century. They wish to add a live inventory and live 
credit card processing feature to their website.

Though I have done this type of work in the past, I have never worked 
with a legacy system to complete this. And, to complicate matters, the 
software technicians that administer the SCO Unix Open Server DO NOT 
wish to use a HTTP protocol to communicate between the two servers. 
They tell me that they
wish to communicate to my CF server via the FTP protocol.

A basic interaction would go something like this. A customer would 
attempt to place an item in their shopping cart. Before the item is 
added to the cart an inventory check is made. A CF process would 
write an XML file and FTP it to the remote SCO Unix Open Server. The 
remote server would then respond and push a response file back to the 
CF server. The CF server would process the file and determine a Yes/No 
answer and either add the item to the cart or display a message that 
the item is out of stock to the customer.

I was wondering, can this even be done with CF and the FTP protocol 
instead of using HTTP? With HTTP, this would be relatively easy with 
the cfhttp tag. With FTP, I am not sure how the communication would 
work. :(

In my mind, even if I used the CF Event Gateway to monitor a predefined 
directory for FTP traffic... I cannot figure out how to parse the FTP 
file and send the response back to the right shopping cart.

Does that make sense? Any help anyone could provide me would be much 
appreciated.

Regards, Che



 
 
 
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268810
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Postal Code database and proximity

This seems to do the trick:


CREATE FUNCTION [dbo].[getDistanceBetween]
(
   @zip1 char(5),
   @zip2 char(5)
)
RETURNS NUMERIC( 10, 5 )
AS
BEGIN
   DECLARE @x decimal(20,10)
   DECLARE @pi decimal(21,20)
   DECLARE @lat1 decimal(5,2)
   DECLARE @long1 decimal(5,2)
   DECLARE @lat2 decimal(5,2)
   DECLARE @long2 decimal(5,2)

   SET @long1 = (select LONGITUDE FROM dbo.ZIPCODES where ZIPCODE =
@zip1)
   SET @lat1 = (select LATITUDE FROM dbo.ZIPCODES where ZIPCODE = @zip1)
   SET @long2 = (select LONGITUDE FROM dbo.ZIPCODES where ZIPCODE =
@zip2)
   SET @lat2 = (select LATITUDE FROM dbo.ZIPCODES where ZIPCODE = @zip2)
   SET @pi = 3.14159265358979323846
   SET @x = sin( @lat1 * @pi/180 ) * sin( @lat2 * @pi/180  ) + cos(
@lat1 [EMAIL PROTECTED]/180 ) * cos( @lat2 * @pi/180 ) * cos( abs( (@long2 * 
@pi/180) -
(@long1 [EMAIL PROTECTED]/180) ) )
   SET @x = atan( ( sqrt( 1- power( @x, 2 ) ) ) / @x )
   RETURN abs(( 1.852 * 60.0 * ((@x/@pi)*180) ) / 1.609344)
END

select A.*, dbo.getDistanceBetween('27502',A.zipcode) AS DIST
from dbo.ZIPCODES A
where
 a.zipcode = '27552' and A.zipcode = '27452' and
 dbo.getDistanceBetween('27502',A.zipcode)  25

That lists all of the zip codes within 25 miles of 27502.

Rick


-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268811
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Dan G. Switzer, II

Che,

Thanks Dan. My thoughts exactly. In my mind, the SCO software technicians
simply don't want to add a webserver because of the increased security
issues that would arise. And yes, it *would* be terribly slow.

If you can keep the FTP session active all the time, it will help w/the
performance, but I still think it's going to be tediously sluggish. 

Are you planning on having the CF server on Windows or *nix? 

-Dan


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268812
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Christopher Jordan

I'd like to see them have a mailing list or forum (which I don't think
they presently have... I could be wrong), but I like seeing discussions
like this, and I'll bet they would too. I'd definitely join such a
mailing list/forum.

Cutter (CFRelated) wrote:
Well, I am not versed enough in Java to assist in development. However,
some of us know how to write documentation. I am sure someone out there
can assist with maintenance of the Smith website. Someone probably knows
something or other about moderating mailing lists and forums. There are
probably some people who don't know much about programming in Java, but
know enough to provide research into libraries that could assist in
providing information/direction in implementing currently unsupported
features (i.e.: mapping out the functions of the iText library to
implement cfreport features). If it were open sourced, someone could
provide hosting for the project, maintain the subversion repository,
setup and maintain a trac system, or even assist from a project
management standpoint. Plus, if someone offered, or if the project
accepted it, their are probably ways to donate to the project
monetarily, which helps the core development team maintain a living
while working on a project that benefits the community as a whole by
providing each of us with options.

Cutter

http://blog.cutterscrossing.com

Doug Brown wrote:

I think that will depend on how many pure java developers are out there in
coldfusion land that could help out. I for one cannot as I know squat about
Java. If I could help in another way, then I would be very glad to.

Doug B.

So who of you that want Smith intend to do something for it?

Jochem

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268813
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CF and Legacy Systems... Need Some Advice/Help

Pardon my off topic reply, but I think I might have nightmares about this
scenario when I go to bed tonight!!!

On 2/6/07, Che Vilnonis [EMAIL PROTECTED] wrote:

Good morning all. I have a client that has a CF based website (built by
myself around 5 years ago) and a SCO Unix Open Server backend. It's a
legacy
system with software that's been heavily modified over the last 20-25
years.
Neither system communicates with the other.

The client is looking to streamline the order fulfillment process and to
get with 21st century. They wish to add a live inventory and live credit
card processing feature to their website.

Though I have done this type of work in the past, I have never worked with
a
legacy system to complete this. And, to complicate matters, the software
technicians that administer the SCO Unix Open Server DO NOT wish to use a
HTTP protocol to communicate between the two servers. They tell me that
they
wish to communicate to my CF server via the FTP protocol.

A basic interaction would go something like this. A customer would attempt
to place an item in their shopping cart. Before the item is added to the
cart an inventory check is made. A CF process would write an XML file
and
FTP it to the remote SCO Unix Open Server. The remote server would then
respond and push a response file back to the CF server. The CF server
would
process the file and determine a Yes/No answer and either add the item to
the cart or display a message that the item is out of stock to the
customer.

I was wondering, can this even be done with CF and the FTP protocol
instead
of using HTTP? With HTTP, this would be relatively easy with the cfhttp
tag. With FTP, I am not sure how the communication would work. :(

Does that make sense? Any help anyone could provide me would be much
appreciated.

Regards, Che

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268814
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF and Legacy Systems... Need Some Advice/Help

Dan, the server will be on Windows. I'm basically using everyone's replies
as a vote for how this should be handled. I don't want to re-invent the
wheel and that is why I have my doubts with doing this via FTP.

~Ché

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 10:15 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help

Che,

Thanks Dan. My thoughts exactly. In my mind, the SCO software 
technicians simply don't want to add a webserver because of the 
increased security issues that would arise. And yes, it *would* be 
terribly slow.

If you can keep the FTP session active all the time, it will help w/the
performance, but I still think it's going to be tediously sluggish. 

Are you planning on having the CF server on Windows or *nix? 

-Dan

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268815
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Peterson, Chris

Even using cffile would be faster than FTP.  You would have to have the user 
that Coldfusion is running as (the service) setup with permissions to your 
legacy system, maybe a specific samba share (if possible?)

Chris 

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 10:20 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help

Dan, the server will be on Windows. I'm basically using everyone's replies
as a vote for how this should be handled. I don't want to re-invent the
wheel and that is why I have my doubts with doing this via FTP.

~Ché

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 10:15 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help

Che,

Thanks Dan. My thoughts exactly. In my mind, the SCO software 
technicians simply don't want to add a webserver because of the 
increased security issues that would arise. And yes, it *would* be 
terribly slow.

If you can keep the FTP session active all the time, it will help w/the
performance, but I still think it's going to be tediously sluggish. 

Are you planning on having the CF server on Windows or *nix? 

-Dan

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268816
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

2007-02-06 Thread Dan G. Switzer, II

Che,

Dan, the server will be on Windows. I'm basically using everyone's replies
as a vote for how this should be handled. I don't want to re-invent the
wheel and that is why I have my doubts with doing this via FTP.

Unix definitely handles FTP operations much more efficiently than Windows.
On a project that I once worked on, we need to FTP new images to a server
every second (this was for a traffic camera application.) 

We could never find a Windows FTP server that could keep up w/the FTP
operations, on the other hand our Unix server had no issues keeping up w/the
stream of images.

-Dan


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268817
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Postal Code database and proximity

I have a zip table from zipCodeDownload.com, and this is the query you can
use with their table:

select z2.* 
from zip z 
cross join zip z2 
where  z.zipCode=27502 and dbo.getDistance(z.Latitude, z.longitude,
z2.latitude, z2.longitude) 10

Takes about 3 seconds on my machine.  If you want faster results, you would
want to precompute the tables, but it would require a lot of storage... 

Russ
 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 9:13 AM
 To: CF-Talk
 Subject: Re: Postal Code database and proximity
 
 by the way I know the below wouldn't work...
 
 What I need is a function or stored proc that returns a list of zip codes
 within a given distance from a specified zip code.
 
 Ie,
 
 select * from zipcodes where getDistanceFrom('27502')  10
 
 
 
 On 2/6/07, Rick Root [EMAIL PROTECTED] wrote:
 
  Russ - can you help me out here a little bit?
 
  I'd like to be able to run a query like this:
 
  select *
  from prospects
  where prospects.zipcode in
   (select zipcode from zipcodes
where getDistance(prospect.zipcode, zipcode.zipcode) = 25)
 
  How would I do that?
 
 
   On 2/5/07, Russ [EMAIL PROTECTED] wrote:
  
   Christopher, I highly recommend you put in some kind of function to
   calculate the distance into SQL serer.
  
   CREATE FUNCTION [dbo].[getDistance]
   (
  @lat1 numeric(9,6),
  @lon1 numeric(9,6),
  @lat2 numeric(9,6),
  @lon2 numeric(9,6)
   )
   RETURNS NUMERIC( 10, 5 )
   AS
   BEGIN
  DECLARE @x decimal(20,10)
  DECLARE @pi decimal(21,20)
  SET @pi = 3.14159265358979323846
  SET @x = sin( @lat1 * @pi/180 ) * sin( @lat2 * @pi/180  ) +
 cos(
   @lat1 [EMAIL PROTECTED]/180 ) * cos( @lat2 * @pi/180 ) * cos( abs( (@lon2 
   *
 @pi/180)
   -
   (@lon1 [EMAIL PROTECTED]/180) ) )
  SET @x = atan( ( sqrt( 1- power( @x, 2 ) ) ) / @x )
  RETURN ( 1.852 * 60.0 * ((@x/@pi)*180) ) / 1.609344
   END
  
  
  
   Then your can fairly easily write a query that brings zip codes within
 a
  
   certain distance.
  
   Russ
  
-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 05, 2007 4:08 PM
To: CF-Talk
Subject: Re: Postal Code database and proximity
   
Rick,
   
I bought a zip code table from some company for $39 bucks or there
abouts. The following queries then get run against the table:
cfquery name=zipcode datasource=MyDSN
SELECT DISTINCT latitude,longitude
FROM AmericanZipCodes
WHERE zip = '#form.zipcode#'
/cfquery
   
   
cfquery name=ZipCode datasource=MyDSN
 SELECT zip,ROUND((ACOS((SIN(#latitude#/57.2958) *
SIN(latitude/57.2958)) + (COS(#latitude#/57.2958) *
COS(latitude/57.2958) * COS(longitude/57.2958 -
   #longitude#/57.2958
* 3963, 0) AS distance
   
 FROM AmericanZipCodes
   
WHERE (latitude = #latitude# - (#form.radius#*.009009)) AND
 (latitude
= #latitude# + (#form.radius#*.009009)) AND (longitude =
 #longitude#
   -
(#form.radius#*.009009)) AND (longitude = #longitude# +
(#form.radius#*.009009))
   
 ORDER BY distance
/cfquery
   
I did not do the math on this. Thankfully that was done by the folks
   who
previously did work for my client... otherwise I'd have been in the
   same
boat as you looking for how the hell to do this sort of thing. :o)
   
I hope this helps. If you need to know where I got the database
 from.
Just give a holler and I'll try to dig it up. :o)
   
Cheers,
Chris
   
   
Jordan Michaels wrote:
 We're currently putting something together like this that checks
 to
   see
 if two addresses are within a certain mile radius using the Google
   Maps
API.

 Not a simple process, but we think we can make it do what we want
 it
   to.

 HTH!

 Warm regards,
 Jordan Michaels
 Vivio Technologies
 http://www.viviotech.net/
 Blue Dragon Alliance Member
 [EMAIL PROTECTED]


 Rick Root wrote:

 Is anyone out there using within 25 miles of zipcode for
   searching
 address database?

 I've gotten a request where someone is visiting a certain zip
 code
   and
they
 want to know all the prospects within a 25 mile radius of the zip
   code
 they're visiting.

 I know there are ways to do this.. just wondered what people out
   there
are
 using.

 Thanks!

 Rick




   
   
  
  
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268818
Subscription:

RE: Postal Code database and proximity

I'm just guessing, but I would bet that my solution is a lot faster... 

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 9:42 AM
 To: CF-Talk
 Subject: Re: Postal Code database and proximity
 
 This seems to do the trick:
 
 
 CREATE FUNCTION [dbo].[getDistanceBetween]
 (
@zip1 char(5),
@zip2 char(5)
 )
 RETURNS NUMERIC( 10, 5 )
 AS
 BEGIN
DECLARE @x decimal(20,10)
DECLARE @pi decimal(21,20)
DECLARE @lat1 decimal(5,2)
DECLARE @long1 decimal(5,2)
DECLARE @lat2 decimal(5,2)
DECLARE @long2 decimal(5,2)
 
SET @long1 = (select LONGITUDE FROM dbo.ZIPCODES where ZIPCODE =
 @zip1)
SET @lat1 = (select LATITUDE FROM dbo.ZIPCODES where ZIPCODE =
 @zip1)
SET @long2 = (select LONGITUDE FROM dbo.ZIPCODES where ZIPCODE =
 @zip2)
SET @lat2 = (select LATITUDE FROM dbo.ZIPCODES where ZIPCODE =
 @zip2)
SET @pi = 3.14159265358979323846
SET @x = sin( @lat1 * @pi/180 ) * sin( @lat2 * @pi/180  ) + cos(
 @lat1 [EMAIL PROTECTED]/180 ) * cos( @lat2 * @pi/180 ) * cos( abs( (@long2 * 
 @pi/180) -
 (@long1 [EMAIL PROTECTED]/180) ) )
SET @x = atan( ( sqrt( 1- power( @x, 2 ) ) ) / @x )
RETURN abs(( 1.852 * 60.0 * ((@x/@pi)*180) ) / 1.609344)
 END
 
 select A.*, dbo.getDistanceBetween('27502',A.zipcode) AS DIST
 from dbo.ZIPCODES A
 where
  a.zipcode = '27552' and A.zipcode = '27452' and
  dbo.getDistanceBetween('27502',A.zipcode)  25
 
 That lists all of the zip codes within 25 miles of 27502.
 
 Rick
 
 
 --
 I'm not certified, but I have been told that I'm certifiable...
 Visit http://www.opensourcecf.com today!
 
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268819
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Browser taking too much time in rendering the table data on screen

2007-02-06 Thread Mik Muller

Hussain,

The problem is IE won't display a table until all content is in. FF will load
the table as the data arrives.

To get past this problem try putting this at the top of the page in question:

cfflush interval=1000 !--- number of bytes ---

Michael

From the docs:

Usage

The first occurrence of this tag on a page sends back the HTML headers and any
other available HTML. Subsequent cfflush tags on the page send only the output
that was generated after the previous flush.

When you flush data, ensure that enough information is available, as some
browsers might not respond if you flush only a small amount. Similarly, set the
interval attribute for a few hundred bytes or more, but not thousands of bytes.

Use the interval attribute only when a large amount of output will be sent to
the client, such as in a cfloop or a cfoutput of a large query. Using this form
globally (such as in the Application.cfm file) might cause unexpected errors
when CFML tags that modify HTML headers are executed.

Caution: Because the cfflush tag sends data to the browser when it executes,
it has several limitations, including the following: Using any of the following
tags or functions on a page anywhere after the cfflush tag can cause errors or
unexpected results: cfcontent, cfcookie, cfform, cfheader, cfhtmlhead,
cflocation, and SetLocale. (These tags and functions normally modify the HTML
header, but cannot do so after a cfflush tag, because the cfflush sends the
header.) Using the cfset tag to set a cookie anywhere on a page that has a
cfflush tag does not set the cookie in the browser. Using the cfflush tag
within the body of several tags, including cfsavecontent, cfquery, and custom
tags, cause errors. If you save Client variables as cookies, any client
variables that you set after a cfflush tag are not saved in the browser.

Note: Normally, the cferror tag discards the current output buffer and
replaces it with the contents of the error page. The cfflush tag discards the
current buffer. As a result, the Error.GeneratedContent variable resulting from
a cferror tag after a cfflush contains any contents of the output buffer that
has not been flushed. This content is not sent to the client. The content of
the error page displays to the client after the bytes that have been sent.

At 07:10 AM 2/6/2007, you wrote:
I am working on a coldfusion page in which I am displaying the Query result on
the screen in a table.But before displaying the data in the cells I am
performing some checks on it.So by the time the browser displays the 100
records on the screen it eats up lot of time.
I tried creating table for each row so that the data is displayed as it
fetches it but here the problem is aligning successive tables.So the screen is
cluttered as there is no alignment of the tables.
Following is the sample code which I tried:-
cfoutput query=Counter startrow=1 maxrows=100
table
tr
td./td
td./td
/tr
tr
td./td
td./td
/tr
/table
/cfoutput

Is there any other alternative to this?

Thanks in advance,
Hussain.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268820
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF and Legacy Systems... Need Some Advice/Help

Dan, this is great to know. And since we have no plans to move to a *nix
environment, that's all the more reason to not use FTP.

Thanks, Ché

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 10:27 AM
To: CF-Talk
Subject: RE: CF and Legacy Systems... Need Some Advice/Help

Che,

Dan, the server will be on Windows. I'm basically using everyone's 
replies as a vote for how this should be handled. I don't want to 
re-invent the wheel and that is why I have my doubts with doing this 
via FTP.

Unix definitely handles FTP operations much more efficiently than Windows.
On a project that I once worked on, we need to FTP new images to a server
every second (this was for a traffic camera application.) 

We could never find a Windows FTP server that could keep up w/the FTP
operations, on the other hand our Unix server had no issues keeping up w/the
stream of images.

-Dan

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268821
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

Christopher Jordan wrote:
 I'd like to see them have a mailing list or forum (which I don't think 
 they presently have... I could be wrong), but I like seeing discussions 
 like this, and I'll bet they would too. I'd definitely join such a 
 mailing list/forum.
 
There is actually a forum
http://www.smithproject.org/forum/forums/list.page
not many posts, though.

But also, I'd like to know where the Digg poster got their 
information...there doesn't seem to be any indication on the Smith site 
of an announced change to open source...right now it just says...

Smith is freeware software, which means that it comes with permission 
for anyone to use, copy, and distribute it. It is also being seriously 
considered to open-source it.

No indication of a timeline for open sourcing it, nor what license they 
might do it under, or if the entire product or some subset would be open 
sourced, or if they are going to want community developers helping out 
with the project.  Move along...nothing to see here.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268822
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Deanna Schneider

On 2/6/07, Christopher Jordan [EMAIL PROTECTED] wrote:
 I'd like to see them have a mailing list or forum (which I don't think
 they presently have... I could be wrong), but I like seeing discussions
 like this, and I'll bet they would too. I'd definitely join such a
 mailing list/forum.

http://www.smithproject.org/forum/forums/list.page

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268823
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Doug Bezona

 But also, I'd like to know where the Digg poster got their
 information...there doesn't seem to be any indication on the Smith
site
 of an announced change to open source...right now it just says...
 
 Smith is freeware software, which means that it comes with permission
 for anyone to use, copy, and distribute it. It is also being seriously
 considered to open-source it.

Probably got it from the second post here:
http://www.smithproject.org/forum/posts/list/6.page

No details (timeline, license, etc.) though.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268824
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Christopher Jordan

See? I said I could be wrong! :o)

Deanna Schneider wrote:
 On 2/6/07, Christopher Jordan [EMAIL PROTECTED] wrote:
   
 I'd like to see them have a mailing list or forum (which I don't think
 they presently have... I could be wrong), but I like seeing discussions
 like this, and I'll bet they would too. I'd definitely join such a
 mailing list/forum.
 

 http://www.smithproject.org/forum/forums/list.page

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268825
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Browser taking too much time in rendering the table data on screen

2007-02-06 Thread Dave Ferguson

Using cfflush still does not solve the issue.  IE will not render the table 
till it has the whole table.  I have gotten around this problem before by 
breaking up a large table into multiple smaller tables.  You will have to set 
the width of all columns so everything lines up but it should work.

--Dave
www.dkferguson.com/BlogCFC

 Hussain,
 
 The problem is IE won't display a table until all content is in. FF 
 will load the table as the data arrives.
 
 To get past this problem try putting this at the top of the page in 
 question:
 
 cfflush interval=1000  !--- number of bytes ---
 
 Michael
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Damien McKenna

On 2/6/07 10:40 AM, Doug Bezona wrote:
 Probably got it from the second post here:
 http://www.smithproject.org/forum/posts/list/6.page
 No details (timeline, license, etc.) though.

http://www.smithproject.org/forum/posts/list/15.page
A month or so.

-- 
Damien McKenna - Web Developer [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268827
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Andy Matthews

I'd easily be willing to sacrifice *SOME* functionality for the sake of
cost. The jury's still out on exactly what I'd be willing to give up.


andy 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, February 05, 2007 5:09 PM
To: CF-Talk
Subject: Re: Take a minute to Digg this story about the Smith Project

But the fact is, if you wanted free ColdFusion, you would expect same
functionality and performance as ColdFusion proper, which Smith cannot
offer?




This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions. 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Christopher Jordan
To: CF-Talk
Sent: Mon Feb 05 23:03:57 2007
Subject: Re: Take a minute to Digg this story about the Smith Project

I'd move to it for all my smaller clients who cannot afford a copy of CF or
BD (and that's quite a few). I'd want to download and play with it first
though. I wrote and told them along time ago that it wasn't worth my time if
it didn't support CFCs. They wrote back recently to tell me that the new
version *does* support them. I still haven't tried the switch, but probably
will fairly soon.

Brad Wood wrote:
 The same argument could have been made for BD when it first came out. 
 A similar argument could have probably been made for CF when it's 
 first clunky version hit shelves.

 I've never tried Smith, but I still think it is cool.

 ~Brad

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 05, 2007 4:52 PM
 To: CF-Talk
 Subject: Re: Take a minute to Digg this story about the Smith Project

 And more to the point, who cares? Not to be the spoiler of the partay 
 but I mean in all reality how many people, currently on CF/BD would 
 consider a move to Smith? just because it is free.

 I would wager not that many, if any.


 





~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Porter, Benjamin L.

Why could smith not offer the same performance and functionality? If it
is open source potentially it will end up offering better performance
and more functionality. The only thing I see going are those items that
deal with flash.

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 9:53 AM
To: CF-Talk
Subject: RE: Take a minute to Digg this story about the Smith Project

I'd easily be willing to sacrifice *SOME* functionality for the sake of
cost. The jury's still out on exactly what I'd be willing to give up.

andy 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, February 05, 2007 5:09 PM
To: CF-Talk
Subject: Re: Take a minute to Digg this story about the Smith Project

But the fact is, if you wanted free ColdFusion, you would expect same
functionality and performance as ColdFusion proper, which Smith cannot
offer?

This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of
the
intended recipient(s).  If you are not the intended recipient(s) please
note
that any form of distribution, copying or use of this communication or
the
information in it is strictly prohibited and may be unlawful.  If you
have
received this communication in error please return it to the sender or
call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within
this
communication are not necessarily those expressed by Reed Exhibitions. 
Visit our website at http://www.reedexpo.com

-Original Message-
From: Christopher Jordan
To: CF-Talk
Sent: Mon Feb 05 23:03:57 2007
Subject: Re: Take a minute to Digg this story about the Smith Project

I'd move to it for all my smaller clients who cannot afford a copy of CF
or
BD (and that's quite a few). I'd want to download and play with it first
though. I wrote and told them along time ago that it wasn't worth my
time if
it didn't support CFCs. They wrote back recently to tell me that the new
version *does* support them. I still haven't tried the switch, but
probably
will fairly soon.

Brad Wood wrote:
 The same argument could have been made for BD when it first came out. 
 A similar argument could have probably been made for CF when it's 
 first clunky version hit shelves.

 I've never tried Smith, but I still think it is cool.

 ~Brad

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 05, 2007 4:52 PM
 To: CF-Talk
 Subject: Re: Take a minute to Digg this story about the Smith Project

 And more to the point, who cares? Not to be the spoiler of the partay 
 but I mean in all reality how many people, currently on CF/BD would 
 consider a move to Smith? just because it is free.

 I would wager not that many, if any.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268829
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

I would not see the flash integration going anywhere. I am sure all that has
to be done is creating something in JAVA to be able to talk back and forth
with flash. Might be alot harder than just words, but should be possible.

Doug B.



- Original Message - 
From: Porter, Benjamin L. [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 8:59 AM
Subject: RE: Take a minute to Digg this story about the Smith Project


 Why could smith not offer the same performance and functionality? If it
 is open source potentially it will end up offering better performance
 and more functionality. The only thing I see going are those items that
 deal with flash.

 -Original Message-
 From: Andy Matthews [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 9:53 AM
 To: CF-Talk
 Subject: RE: Take a minute to Digg this story about the Smith Project

 I'd easily be willing to sacrifice *SOME* functionality for the sake of
 cost. The jury's still out on exactly what I'd be willing to give up.


 andy

 -Original Message-
 From: Robertson-Ravo, Neil (RX)
 [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 05, 2007 5:09 PM
 To: CF-Talk
 Subject: Re: Take a minute to Digg this story about the Smith Project

 But the fact is, if you wanted free ColdFusion, you would expect same
 functionality and performance as ColdFusion proper, which Smith cannot
 offer?




 This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
 Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
 Registered in England, Number 678540.  It contains information which is
 confidential and may also be privileged.  It is for the exclusive use of
 the
 intended recipient(s).  If you are not the intended recipient(s) please
 note
 that any form of distribution, copying or use of this communication or
 the
 information in it is strictly prohibited and may be unlawful.  If you
 have
 received this communication in error please return it to the sender or
 call
 our switchboard on +44 (0) 20 89107910.  The opinions expressed within
 this
 communication are not necessarily those expressed by Reed Exhibitions.
 Visit our website at http://www.reedexpo.com

 -Original Message-
 From: Christopher Jordan
 To: CF-Talk
 Sent: Mon Feb 05 23:03:57 2007
 Subject: Re: Take a minute to Digg this story about the Smith Project

 I'd move to it for all my smaller clients who cannot afford a copy of CF
 or
 BD (and that's quite a few). I'd want to download and play with it first
 though. I wrote and told them along time ago that it wasn't worth my
 time if
 it didn't support CFCs. They wrote back recently to tell me that the new
 version *does* support them. I still haven't tried the switch, but
 probably
 will fairly soon.

 Brad Wood wrote:
  The same argument could have been made for BD when it first came out.
  A similar argument could have probably been made for CF when it's
  first clunky version hit shelves.
 
  I've never tried Smith, but I still think it is cool.
 
  ~Brad
 
  -Original Message-
  From: Robertson-Ravo, Neil (RX)
  [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 05, 2007 4:52 PM
  To: CF-Talk
  Subject: Re: Take a minute to Digg this story about the Smith Project
 
  And more to the point, who cares? Not to be the spoiler of the partay
  but I mean in all reality how many people, currently on CF/BD would
  consider a move to Smith? just because it is free.
 
  I would wager not that many, if any.
 
 
 







 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268830
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Andy Matthews

By the way...

The post that we've been discussing made it to the Front page of Digg! Good
job everyone. Even though there was lots of arguments, and lots of negative
former CF develooper or php rules over CF comments, the important thing
is that some of you made reasoned, intelligent posts about Coldfusion and
people had to be listening.

For every person that makes a comment, there's probably at least 5 or 10
people who read and never say a word. Those are the people that need to hear
the message of Coldfusion.


andy

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 9:53 AM
To: CF-Talk
Subject: RE: Take a minute to Digg this story about the Smith Project

I'd easily be willing to sacrifice *SOME* functionality for the sake of
cost. The jury's still out on exactly what I'd be willing to give up.


andy


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268831
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Doug Bezona

http://sourceforge.net/projects/openamf/

 -Original Message-
 From: Doug Brown [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 11:04 AM
 To: CF-Talk
 Subject: Re: Take a minute to Digg this story about the Smith Project
 
 I would not see the flash integration going anywhere. I am sure all
that
 has
 to be done is creating something in JAVA to be able to talk back and
forth
 with flash. Might be alot harder than just words, but should be
possible.
 
 Doug B.
 


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268833
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Take a minute to Digg this story about the Smith Project

Words from smith regarding opensource

Doug,

yes, Vladimir Nikic has anounced the opening of Smith. Our management is
been working with lawyers about all the possible legal issues about that. We
are waiting for their answer yet

Best,
Boris


Doug


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268832
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: programmatically create an Access Datasource

2007-02-06 Thread Jonathon S

Huh -- never knew about that functionality!  Taking a
stab here -- if I wanted my own CFC's to do this same
thing I'd be filling out those hint and
description attributes that I've been skipping over?

Jonathon



--- Ken Wexel [EMAIL PROTECTED] wrote:

 ColdFusion Components (CFCs) are
 self-describing...that is, you can
 view the methods they expose, parameters they
 require, etc. via a web
 browser interface, using functionality built into
 CF.  For example, to
 view the CF Admin API CFC, browse to:
 
 http://YOURSERVER/cfide/adminapi/administrator.cfc
 
 You'll be prompted to authenticate - enter your CF
 Admin or RDS
 password, and you'll see what is available via that
 particular CFC.
 
 The same steps will work for the other Admin API
 CFCs, specifically:
 
 base.cfc
 datasource.cfc (the one you'll need for your
 programmatic manipulation
 of datasources)
 debugging.cfc
 eventgateway.cfc
 extensions.cfc
 mail.cfc
 runtime.cfc
 security.cfc
 
 Essentially, each group of functions available
 through the ColdFusion
 administrator is also available via the API, using
 the above CFCs
 (well, nearly all of them).
 
 For more info on the admin API and an example of
 programmatically
 manipulating a datasource (SQL Server in this case)
 via the API, check
 out:
 

http://livedocs.macromedia.com/coldfusion/7/htmldocs/1734.htm
 
 Same concepts work for Access, except you'll be
 using the setMSAccess
 (or setMSAccessUnicode) method instead of the
 setMSSQL method used in
 the example.
 
 Hope this helps, but if I can be of assistance, feel
 free to drop me a
 line off-list
 
 -Ken
 
 On 2/5/07, Jonathon S [EMAIL PROTECTED] wrote:
  I'm not familiar with that -- CFC Browser?
 
  Jonathon
 
 
  --- Ken Wexel [EMAIL PROTECTED] wrote:
 
   You can still browse them to see their methods,
   properties, etc. using
   the CFC browser.  I've used the admin api set
 pretty
   heavily - they
   are very very handy!
  
 
 
 
 


  Now that's room service!  Choose from over 150,000
 hotels
  in 45,000 destinations on Yahoo! Travel to find
 your fit.
  http://farechase.yahoo.com/promo-generic-14795097
 
  
 



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Take a minute to Digg this story about the Smith Project

2007-02-06 Thread Christopher Jordan

Sweet!

Andy Matthews wrote:
 By the way...

 The post that we've been discussing made it to the Front page of Digg! Good
 job everyone. Even though there was lots of arguments, and lots of negative
 former CF develooper or php rules over CF comments, the important thing
 is that some of you made reasoned, intelligent posts about Coldfusion and
 people had to be listening.

 For every person that makes a comment, there's probably at least 5 or 10
 people who read and never say a word. Those are the people that need to hear
 the message of Coldfusion.


 andy

 -Original Message-
 From: Andy Matthews [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, February 06, 2007 9:53 AM
 To: CF-Talk
 Subject: RE: Take a minute to Digg this story about the Smith Project

 I'd easily be willing to sacrifice *SOME* functionality for the sake of
 cost. The jury's still out on exactly what I'd be willing to give up.


 andy


 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268835
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Andy Matthews

Paul... 

My company currently has multiple load balanced web servers. Each time we
deploy code, we have to manually FTP it to each server. We'd love to be able
to upload (or SVN) code to one location and have an automated process to
replicate the code to the other servers.

You mentioned a program called Robocopy in this post. Can you provide some
additional information?


Andy matthews

-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 4:13 AM
To: CF-Talk
Subject: RE: Client variables? reliable enough?

We solved the bandwidth issue by moving the source code onto the web servers
instead of them using the filestore server and used robocopy to keep them in
sync... Nowadays I'd use SVN to deploy :)


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268836
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

Andy,

We use SVN to deploy to code to a single server, and then we use DFS to
automatically propagate the changes. Once you set it up, it doesn't require
any intervention, unless it breaks, which happened to me a few times to
date. It is, however, very useful in that once you push the code to one of
the servers through svn, unless you are changing a bunch of files, the files
are replicated almost instantly to the other server.

Russ

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 11:11 AM
To: CF-Talk
Subject: Uploading files to one server, propgating them to many. Was:
Client variables? reliable enough?

Paul...

My company currently has multiple load balanced web servers. Each time we
deploy code, we have to manually FTP it to each server. We'd love to be
able
to upload (or SVN) code to one location and have an automated process to
replicate the code to the other servers.

You mentioned a program called Robocopy in this post. Can you provide some
additional information?

Andy matthews

-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 4:13 AM
To: CF-Talk
Subject: RE: Client variables? reliable enough?

We solved the bandwidth issue by moving the source code onto the web
servers
instead of them using the filestore server and used robocopy to keep them
in
sync... Nowadays I'd use SVN to deploy :)

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268837
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: moving from CF 4.5 to 7.0

2007-02-06 Thread So Kenfused

If you could send that I would appreciate it. It would save me from having to 
search the adobe cite for it. 

There's an Adobe document called cfmx7_migrating.pdf.  We basically just
worked through it.

Let me know if you want me to email you a copy of the document.

Jaime


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268838
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Webcharts

2007-02-06 Thread James Smith

I have a graph on our intranet that displays 4 series as stacked bars.  I
would like to have webcharts display the collumn total at the top of each
collumn.

If I add...

dataLabels style=Pattern placement=Outside isAntialiased=true
font=Verdana-12
![CDATA[$(colTotal)]]
/dataLabels

To the XML file it adds a total but I can't figure out where it gets its
number from 'cause it seems completely wrong.  It also adds 4 numbers, one
for each series.

Is there any way I can just get one number at the top of each collumn which
is the sum of all 4 series so if todays sales from each series were 2,3,4 
5 it would display 14 at the top of the column?

--
James Smith - IT Director
uWish Ltd - http://www.uWish.co.uk



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268839
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Richard Kroll

 My company currently has multiple load balanced web servers. Each time
we
 deploy code, we have to manually FTP it to each server. We'd love to
be
 able
 to upload (or SVN) code to one location and have an automated process
to
 replicate the code to the other servers.

We currently have a similar setup and are looking to use SVN to automate
this portion of our process.  We're currently looking to use a bat file
to SVN Update / Checkout the code on the remote servers.  

We have an integration server where we currently checkout our repository
to then copy the code to the remote servers.  We are trying to do away
with this method as we are using a large amount of bandwidth that is not
really necessary.  Using the SVN update / Checkout method, only the
files that are needed will be transmitted to the production servers, or
at least that is our thought.

Is there something we're missing with this method?

Rich Kroll

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268840
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: Transact-SQL help

I've got my zip code database proximity thing all figured out.  I have a
nice getdistance function that calcs the distance between two zip codes.

syntax of my function:  getDistance(zip1,long1,lat1,zip2,long2,lat2)
taking either the zip code or the lat/long for each...

I can now do:

SELECT *
FROM prospects A
WHERE
 zipcode in
 (
  SELECT B.zipcode
  FROM zipcodes B
  WHERE
   getDistance('27502',0.0,0.0,'',B.latitude,B.longitude)
 )

However, that is very slow.  It's very fast if I pass in the lat and long.

So I've written a stored procedure that when executed looks like this:

sp_zipcodes '27502' 25

It returns a result set containing all the zip codes within 25 miles of
27502.

But I can't use that in an IN clause... so what do I do?

Rick

-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: programmatically create an Access Datasource

2007-02-06 Thread Ken Wexel

You got it!

On 2/6/07, Jonathon S [EMAIL PROTECTED] wrote:
 Huh -- never knew about that functionality!  Taking a
 stab here -- if I wanted my own CFC's to do this same
 thing I'd be filling out those hint and
 description attributes that I've been skipping over?

 Jonathon



 --- Ken Wexel [EMAIL PROTECTED] wrote:

  ColdFusion Components (CFCs) are
  self-describing...that is, you can
  view the methods they expose, parameters they
  require, etc. via a web
  browser interface, using functionality built into
  CF.  For example, to
  view the CF Admin API CFC, browse to:
 
  http://YOURSERVER/cfide/adminapi/administrator.cfc
 
  You'll be prompted to authenticate - enter your CF
  Admin or RDS
  password, and you'll see what is available via that
  particular CFC.
 
  The same steps will work for the other Admin API
  CFCs, specifically:
 
  base.cfc
  datasource.cfc (the one you'll need for your
  programmatic manipulation
  of datasources)
  debugging.cfc
  eventgateway.cfc
  extensions.cfc
  mail.cfc
  runtime.cfc
  security.cfc
 
  Essentially, each group of functions available
  through the ColdFusion
  administrator is also available via the API, using
  the above CFCs
  (well, nearly all of them).
 
  For more info on the admin API and an example of
  programmatically
  manipulating a datasource (SQL Server in this case)
  via the API, check
  out:
 
 
 http://livedocs.macromedia.com/coldfusion/7/htmldocs/1734.htm
 
  Same concepts work for Access, except you'll be
  using the setMSAccess
  (or setMSAccessUnicode) method instead of the
  setMSSQL method used in
  the example.
 
  Hope this helps, but if I can be of assistance, feel
  free to drop me a
  line off-list
 
  -Ken
 
  On 2/5/07, Jonathon S [EMAIL PROTECTED] wrote:
   I'm not familiar with that -- CFC Browser?
  
   Jonathon
  
  
   --- Ken Wexel [EMAIL PROTECTED] wrote:
  
You can still browse them to see their methods,
properties, etc. using
the CFC browser.  I've used the admin api set
  pretty
heavily - they
are very very handy!
   
  
  
  
  
 
 
   Now that's room service!  Choose from over 150,000
  hotels
   in 45,000 destinations on Yahoo! Travel to find
  your fit.
   http://farechase.yahoo.com/promo-generic-14795097
  
  
 
 


 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

If you use SVN + DFS, you will only pull the files you need from a remote
server (SVN) once, and then DFS will propagate only the changes between
your local servers. Doing svn update on every server will load the changes
once for every server from the remote location (unless your svn server is on
site there as well).

Either way, the beauty of DFS is that it auto replicates things without your
intervention, unless it breaks.

Russ

-Original Message-
From: Richard Kroll [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 06, 2007 11:23 AM
To: CF-Talk
Subject: RE: Uploading files to one server, propgating them to many. Was:
Client variables? reliable enough?

My company currently has multiple load balanced web servers. Each time
we
deploy code, we have to manually FTP it to each server. We'd love to
be
able
to upload (or SVN) code to one location and have an automated process
to
replicate the code to the other servers.

We currently have a similar setup and are looking to use SVN to automate
this portion of our process. We're currently looking to use a bat file
to SVN Update / Checkout the code on the remote servers.

We have an integration server where we currently checkout our repository
to then copy the code to the remote servers. We are trying to do away
with this method as we are using a large amount of bandwidth that is not
really necessary. Using the SVN update / Checkout method, only the
files that are needed will be transmitted to the production servers, or
at least that is our thought.

Is there something we're missing with this method?

Rich Kroll

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268843
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Transact-SQL help

Rick, 

Did you take a look at the query that I sent earlier?  It takes only 3
seconds to run on my machine.  

Russ

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 11:49 AM
 To: CF-Talk
 Subject: OT: Transact-SQL help
 
 I've got my zip code database proximity thing all figured out.  I have a
 nice getdistance function that calcs the distance between two zip codes.
 
 syntax of my function:  getDistance(zip1,long1,lat1,zip2,long2,lat2)
 taking either the zip code or the lat/long for each...
 
 I can now do:
 
 SELECT *
 FROM prospects A
 WHERE
  zipcode in
  (
   SELECT B.zipcode
   FROM zipcodes B
   WHERE
getDistance('27502',0.0,0.0,'',B.latitude,B.longitude)
  )
 
 However, that is very slow.  It's very fast if I pass in the lat and long.
 
 So I've written a stored procedure that when executed looks like this:
 
 sp_zipcodes '27502' 25
 
 It returns a result set containing all the zip codes within 25 miles of
 27502.
 
 But I can't use that in an IN clause... so what do I do?
 
 Rick
 
 --
 I'm not certified, but I have been told that I'm certifiable...
 Visit http://www.opensourcecf.com today!
 
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268844
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: moving from CF 4.5 to 7.0

2007-02-06 Thread Tero Pikala

I upgraded couple of sites from CF5.0 - CF7.0 few months ago, here's some
things that required fixing:

- cfsetting / catchexceptionsbypattern is no longer supported. I just
removed it, can't remember what it is for.
- cferror type=monitor was changed to type=exception. Again, can't
remember what 'monitor' did but it worked ok after change.
- QueryOfQueries has some additional reserved words but it doesn't apply to
4.5 upgrade since QoQ came with CF5. I had to fix at least 'position' and
'date' as column names.
- There was variable 'file' somewhere which no longer works.

For me most difficult thing was converting database; there is Chinese and
some other difficult languages there and they work completely differently in
J2EE based CF. I wrote code that exported all relevant data to XML files
which is run with CF5 and another code that updates selected database fields
in CF7 using those XML files.

If you are stuck with that send me email and I'll send you the export/import
files I used (but do try to do that first yourself, it's nice exercise about
database dictionary and XML :)

Tero Pikala

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268845
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Survey Application, not polling

2007-02-06 Thread coldfusion . developer

Thanks Ray,

I read the docs and Let me see if I'm getting this.  I should switch from 
session managment to client managment using cookies.  Then I should take 
that cookie variable and value and use wddx to serialize and then deserialize 
and then assign the value in the client.cookie value to the session.survey 
variable. Correct?  Do I have to use WDDX or can I use multiple cfset(s) 
to do all the reassigning of values?

Thanks

Well for WDDX I'd just suggest reading the docs. It really is pretty
trivial. You use the WDDX tag to serialize a CF variable into an XML
string. THen you use the WDDX tag to deserialize it.

So your application.cfm (or Soundings I should say), would look for
client.surveypacket variable, as an example, and deserialize it into
session.survey.

On 2/5/07, coldfusion. developer @ att. net coldfusion. developer @
att. net [EMAIL PROTECTED] wrote:


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

DevNet meta tag.

What is the current state of old dev-net licensed servers and the meta ... 
tag that is pre-pended to the output; and how this affects doc-types, web 
services and remote access development.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268847
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: Transact-SQL help

2007-02-06 Thread Jochem van Dieten

Rick Root wrote:
 
 syntax of my function:  getDistance(zip1,long1,lat1,zip2,long2,lat2)
 taking either the zip code or the lat/long for each...

 SELECT *
 FROM prospects A
 WHERE
  zipcode in
  (
   SELECT B.zipcode
   FROM zipcodes B
   WHERE
getDistance('27502',0.0,0.0,'',B.latitude,B.longitude)
  )

This query is not indexable so it needs to do the math on each and every 
row. Prequalify the rows by drawing an imaginary box on the map from 
b.lat + X to b.lat -X and b.lon + X to b.lon -X and finding only the 
points in that box (the database can do that using an index). Then 
perform your distance function only on the points in the box.

Jochem

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268848
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

MS Access ODBC driver could not be found

2007-02-06 Thread Natasha Zhalkovsky

I have ColdFusion Administrator installed on my computer and MS Access database 
also on my computer. I have added this database as a datasource through 
Administrator, and it all worked fine for couple months. Last week when 
verifying datasources I received an error - Connection verification failed for 
data source: ... java.sql.SQLException: [Macromedia][SequeLink JDBC 
Driver][ODBC Socket]internal error: Data source name not found and no default 
driver specified
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC 
Driver][ODBC Socket]internal error: Data source name not found and no default 
driver specified
I tried to add datasource again and received an error - Connection verification 
failed for data source:  I looked at Data Sources in Control Panel - I see 
MS Access database as datasource, but when trying configure it receievd 
message: The setup routines for MS Access driver ODBC driver could not be 
found. Reinstall driver. Component not found in the registry.
I am not able to add MS Access as datasource. I have few databases I used for 
development, and it all worked fine, I think before I ran critical updates for 
the MS Office. Any ideas?

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268849
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: DevNet meta tag.

2007-02-06 Thread Big Mad Kev

I'm sure now that Devnet Has gone as has the right to use the server
software, but ok to use the developer tools?

May Be wrong

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: 06 February 2007 17:13
To: CF-Talk
Subject: DevNet meta tag.

What is the current state of old dev-net licensed servers and the meta ...
tag that is pre-pended to the output; and how this affects doc-types, web
services and remote access development.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268850
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Survey Application, not polling

2007-02-06 Thread Raymond Camden

It's up to you. If you use wddx you can just serialize/deserialize one
packet. If you want to use multiple cookies, you can just put one
value in each cookie. You would need to carefully examine exactly what
I put in the session scope though.

On 2/6/07, coldfusion. developer @ att. net coldfusion. developer @
att. net [EMAIL PROTECTED] wrote:
Thanks Ray,

I read the docs and Let me see if I'm getting this. I should switch from
session managment to client managment using cookies. Then I should take
that cookie variable and value and use wddx to serialize and then deserialize
and then assign the value in the client.cookie value to the session.survey
variable. Correct? Do I have to use WDDX or can I use multiple cfset(s)
to do all the reassigning of values?

Thanks

Well for WDDX I'd just suggest reading the docs. It really is pretty
trivial. You use the WDDX tag to serialize a CF variable into an XML
string. THen you use the WDDX tag to deserialize it.

So your application.cfm (or Soundings I should say), would look for
client.surveypacket variable, as an example, and deserialize it into
session.survey.

On 2/5/07, coldfusion. developer @ att. net coldfusion. developer @
att. net [EMAIL PROTECTED] wrote:

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268851
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: moving from CF 4.5 to 7.0

2007-02-06 Thread WebSite CFtalk

http://www.google.com/search?q=cfmx7_migrating.pdf

(-;

-Original Message-
From: So Kenfused [mailto:[EMAIL PROTECTED] 
Sent: 6. februar 2007 16:25
To: CF-Talk
Subject: Re: moving from CF 4.5 to 7.0

If you could send that I would appreciate it. It would save me from
having to search the adobe cite for it. 

There's an Adobe document called cfmx7_migrating.pdf.  We basically
just
worked through it.

Let me know if you want me to email you a copy of the document.

Jaime




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268852
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help

Russ, if you're referring to this one:

*
http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268742
*http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268742

works fine if you want to pass in the lat/long directly, but I'm trying to
come up with a way to do it off zip code.  your function got really slow
when I added functionality inside to do lat/long lookups, because the
function executes for each zip code you're comparing - up to 42000.

However, in attemping to explain all this, I've actually worked out a
solution:

The following query worked pretty well, given that TB907 (the address
table) contains nearly 900,000 records. (Don't blame me for the table name,
blame BSR, it's their product)


DECLARE @long1 decimal(5,2)
DECLARE @lat1 decimal(5,2);
SELECT @long1 = dbo.getlongitude('27502');
SELECT @lat1 = dbo.getLatitude('27502');

SELECT A.*
FROM WEBREPORTS.dbo.TB907 A
WHERE
 zipcode in
 (
  SELECT B.zipcode
  FROM zipcodes B
  WHERE
   dbo.getDistanceBetween('',@lat1,@long1,'',B.latitude,B.longitude)  25
 )

-- 
I'm not certified, but I have been told that I'm certifiable...
Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268853
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: Transact-SQL help

On 2/6/07, Jochem van Dieten [EMAIL PROTECTED] wrote:


 This query is not indexable so it needs to do the math on each and every
 row. Prequalify the rows by drawing an imaginary box on the map from
 b.lat + X to b.lat -X and b.lon + X to b.lon -X and finding only the
 points in that box (the database can do that using an index). Then
 perform your distance function only on the points in the box.


I did this to speed it up originally:

SELECT B.zipcode
FROM zipcodes B
WHERE
B.zipcode between '27002' and '28002'
getDistance('27502',0.0,0.0,'',B.latitude,B.longitude)

That caused it to only look at 1000 zip codes instead of 42000 zip codes.

the lat/long adjustment would probably be more effective.. or perhaps at
least, more accurate.

Rick

-- 
 I'm not certified, but I have been told that I'm certifiable...
 Visit http://www.opensourcecf.com today!


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268854
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Transact-SQL help

No, I'm referring to:

http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818

Russ

 -Original Message-
 From: Rick Root [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, February 06, 2007 12:42 PM
 To: CF-Talk
 Subject: Re: Transact-SQL help
 
 Russ, if you're referring to this one:
 
 *
 http://www.houseoffusion.com/groups/CF-
 Talk/thread.cfm/threadid:50203#268742
 *http://www.houseoffusion.com/groups/CF-
 Talk/thread.cfm/threadid:50203#268742
 
 works fine if you want to pass in the lat/long directly, but I'm trying to
 come up with a way to do it off zip code.  your function got really slow
 when I added functionality inside to do lat/long lookups, because the
 function executes for each zip code you're comparing - up to 42000.
 
 However, in attemping to explain all this, I've actually worked out a
 solution:
 
 The following query worked pretty well, given that TB907 (the address
 table) contains nearly 900,000 records. (Don't blame me for the table
 name,
 blame BSR, it's their product)
 
 
 DECLARE @long1 decimal(5,2)
 DECLARE @lat1 decimal(5,2);
 SELECT @long1 = dbo.getlongitude('27502');
 SELECT @lat1 = dbo.getLatitude('27502');
 
 SELECT A.*
 FROM WEBREPORTS.dbo.TB907 A
 WHERE
  zipcode in
  (
   SELECT B.zipcode
   FROM zipcodes B
   WHERE
dbo.getDistanceBetween('',@lat1,@long1,'',B.latitude,B.longitude)  25
  )
 
 --
 I'm not certified, but I have been told that I'm certifiable...
 Visit http://www.opensourcecf.com today!
 
 
 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

single session variable disappearing.

Can anybody think of unusual reasons for a specific session variable to 
randomly disappear?  The session.cfid and session.cftoken values are working 
just fine, but a session variable I am setting is not consistently persisting 
from request to request.

I am not having any luck finding out a rhyme or reason that this is happening.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268856
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: single session variable disappearing.

2007-02-06 Thread Charlie Griefer

not a lot to go on there.

you sure it's being set properly (the setting isn't taking place
inside of a conditional block whose condition might not be met)? you
sure you're not deleting it somewhere else in the code?

it's just one specific session variable? or it's all session
variables other than CFID and CFTOKEN?

On 2/6/07, Ian Skinner [EMAIL PROTECTED] wrote:
Can anybody think of unusual reasons for a specific session variable to
randomly disappear? The session.cfid and session.cftoken values are working
just fine, but a session variable I am setting is not consistently persisting
from request to request.

I am not having any luck finding out a rhyme or reason that this is happening.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 | |
- Binary Soduko
| | |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268857
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: single session variable disappearing.

not a lot to go on there.

Yeah, unfortunately yes, not much for me to go on either.

you sure it's being set properly (the setting isn't taking place inside of
a conditional block whose condition might not be met)? you sure you're
not deleting it somewhere else in the code?

As best as I can tell, I can dump the session variable and it does sometimes
exist, when it is supposed to exist. But then the next request it is gone and
it is not supposed to be gone.

it's just one specific session variable? or it's all session variables
other than CFID and CFTOKEN?

Well there is only one session involved in the particular piece of code. I'll
experiment with another one. I also want to make it clear that the cfid and
cftoken variables are properly persisting and not changing values. I do not
believe this could be the common cookie issue.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 | |
- Binary Soduko
| | |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: single session variable disappearing.

2007-02-06 Thread Huff, Jerome P.

Do you have an underline in your site name?  That can cause session
variable problems. 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 06, 2007 1:01 PM
To: CF-Talk
Subject: single session variable disappearing.

Can anybody think of unusual reasons for a specific session variable to
randomly disappear?  The session.cfid and session.cftoken values are
working just fine, but a session variable I am setting is not
consistently persisting from request to request.

I am not having any luck finding out a rhyme or reason that this is
happening.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any attachments is for
the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender and
delete any copies of this message. 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268859
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: MS Access ODBC driver could not be found

2007-02-06 Thread Cutter (CFRelated)

Has the Access DB been replaced with a more current version? I doubt you
would be able to open an Access 2007 db with the currently available
drivers, for instance.

Cutter
___
http://blog.cutterscrossing.com

Natasha Zhalkovsky wrote:
I have ColdFusion Administrator installed on my computer and MS Access
database also on my computer. I have added this database as a datasource
through Administrator, and it all worked fine for couple months. Last week
when verifying datasources I received an error - Connection verification
failed for data source: ... java.sql.SQLException: [Macromedia][SequeLink
JDBC Driver][ODBC Socket]internal error: Data source name not found and no
default driver specified
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC
Driver][ODBC Socket]internal error: Data source name not found and no default
driver specified
I tried to add datasource again and received an error - Connection
verification failed for data source: I looked at Data Sources in Control
Panel - I see MS Access database as datasource, but when trying configure it
receievd message: The setup routines for MS Access driver ODBC driver could
not be found. Reinstall driver. Component not found in the registry.
I am not able to add MS Access as datasource. I have few databases I used for
development, and it all worked fine, I think before I ran critical updates
for the MS Office. Any ideas?

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268860
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: single session variable disappearing.

Do you have an underline in your site name?  That can cause session variable 
problems. 


Nope, somehow, somewhere the session timeout got set to one second!  

So, when a session times out, the cfid and cftoken values do not change?  That 
seems a bit unintuitive.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268861
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: single session variable disappearing.

2007-02-06 Thread Les Mizzell

Ian Skinner wrote:
 Do you have an underline in your site name?  That can cause session variable 
 problems. 

Really? I have never seen this before myself. Is it underlines in the 
site name, or URLs?

I'm having a session variable timeout problem myself on a multi-page 
form. All files are named like:

enroll_app1.cfm
enroll_app2.cfm
enroll_app3.cfm

I've tested on three different computers, and I'm having no problems. 
The client, on the other hand, can't get past enroll_app1.cfm before 
seeing Element USERID is undefined in SESSION. It's vanishing for some 
reason, and I haven't found the problem yet. I'm on an unfamiliar host 
for this site, so I'm suspecting a CFAdmin setting myself.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268862
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help

Russ wrote:
 No, I'm referring to:
 
 http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818
 

That one is pretty quick here...
SELECT b.* FROM tblzipcodes a CROSS JOIN tmpzipcodes b
WHERE dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude)  
10 AND a.zip = '27614'

Took 1412 ms.

I limited the latitude side of things with...

SELECT b.* FROM tmpzipcodes a CROSS JOIN tmpzipcodes b
WHERE a.zip = '27614'
AND b.latitude  a.latitude + (10*.014457)
AND b.latitude  a.latitude - (10*.014457)
AND dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude)  10

which only took 170ms

I think that .014457 is right...basically 1 degree/69.172 miles.


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268863
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Footer not displayed at the bottom of the page

2007-02-06 Thread Frank Greene

Hello:

In December I launched a 30 Gig SQL Server database with 140 ColdFusion 
templates.

I use the OnRequestEnd.cfm template to call the Footer.cfm template.

For 139 of the templates the footer is displayed at the bottom of the page.

In just one template the footer is displayed, not at the bottom of the page, 
but to the right of the first table row.

You can check it out at:

http://www.musicsack.com/BibSections.cfm?ItemPK=9270

Can anyone explain why?

Thank you
 Frank Greene

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268864
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Changes to Daylight Savings Time in 2007 may affect your data bases (DB2, Oracle and others)

2007-02-06 Thread sam komo

Folloed the recommendation from Adobe, tried applying the Java 1.4.2_11 patch 
from Sun.  Now unable to restart my CF Administrator.  How do I safe apply this 
update?

Thanks
Sam

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Footer not displayed at the bottom of the page

2007-02-06 Thread Big Mad Kev

I would suggest you check the HTML of that page with a W3C Checker as it
looks like you have missed a table element somewhere /td, /tr or
/table

-Original Message-
From: Frank Greene [mailto:[EMAIL PROTECTED] 
Sent: 06 February 2007 18:13
To: CF-Talk
Subject: Footer not displayed at the bottom of the page

Hello:

In December I launched a 30 Gig SQL Server database with 140 ColdFusion
templates.

I use the OnRequestEnd.cfm template to call the Footer.cfm template.

For 139 of the templates the footer is displayed at the bottom of the page.

In just one template the footer is displayed, not at the bottom of the page,
but to the right of the first table row.

You can check it out at:

http://www.musicsack.com/BibSections.cfm?ItemPK=9270

Can anyone explain why?

Thank you
 Frank Greene

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268866
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Footer not displayed at the bottom of the page

Frank Greene wrote:
 Hello:
 
 In December I launched a 30 Gig SQL Server database with 140 ColdFusion 
 templates.
 
 I use the OnRequestEnd.cfm template to call the Footer.cfm template.
 
 For 139 of the templates the footer is displayed at the bottom of the page.
 
 In just one template the footer is displayed, not at the bottom of the page, 
 but to the right of the first table row.
 
 You can check it out at:
 
 http://www.musicsack.com/BibSections.cfm?ItemPK=9270
 
 Can anyone explain why?
 

If you take the align=left out of the table above it (in the code that 
is, not in the current layout), it will pop to the bottom.  I would also 
recommend some validation on your pages.

http://validator.w3.org/check?uri=http%3A%2F%2Fwww.musicsack.com%2FBibSections.cfm%3FItemPK%3D9270

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268867
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Paul Vernon

 
 You mentioned a program called Robocopy in this post. Can you 
 provide some additional information?
 

Robocopy is in the Windows Resource Kit AFAIK, it's a pretty powerful
command line tool that you can script to keep folders in sync. 

As an example, 

robocopy C:\source \\server\C$\source *.cf* /E /XD .svn

This would copy *everything* from C:\source to the destination that matched
the *.cf* file pattern and would eXclude Directories that have .svn in
their names. 

You could use the /MIR command to mirror a directory structure too...

If you are deploying to multiple servers, you'd still have to FTP (but only
to one) then script a batch file using robocopy to mirror the latest code to
all the other servers Eg to mirror to 3 servers your batch file would
look something like this...

robocopy C:\source \\server1\C$\source *.* /MIR
robocopy C:\source \\server2\C$\source *.* /MIR
robocopy C:\source \\server3\C$\source *.* /MIR

Of course robocopy is a very powerful tool and I haven't even scratched the
surface of what it can do here... It also requires that you have full
control over your servers so you can run scripts on them and that they can
all see each other in a Windows Network and can access shares (hidden or
not).

If it were possible though, I really would recommend using SVN or similar...
So many less headaches so much more spare time!

Paul



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268868
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Paul Vernon

 We use SVN to deploy to code to a single server, and then we 
 use DFS to automatically propagate the changes. 

That of course is the better option if your environment supports it :)

Paul




~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268869
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help

On 2/6/07, Russ [EMAIL PROTECTED] wrote:

 No, I'm referring to:


 http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818


 Ah, no I hadn't seen that one.  I've never used CROSS JOIN before..
interesting.

However, my final solution actually does the same thing in about 100ms for a
10 mile radius of 27502.

It actually does it in about 1500ms, but I added some code to only look at
zip codes whose lat/long were within a certain range, at jochem's
suggestion.  If I look at latitudes and longitutdes of 2.0 +/-, it improved
the query performance from 1542ms to 109ms.

Here's my solution - using your original getDistance function.

DECLARE @lat1 decimal(5,2);
DECLARE @long1 decimal(5,2);
DECLARE @zip1 char(5);
SET @zip1 = '27502'
SELECT @lat1 = LATITUDE from ADSPRD.dbo.zipcodes where zipcode = @zip1;
SELECT @long1 = LONGITUDE from ADSPRD.dbo.zipcodes where zipcode = @zip1;

SELECT B.CITY, B.STATE, B.zipcode
FROM ADSPRD.dbo.zipcodes B
WHERE
 B.LATITUDE BETWEEN @lat1-2.0 and @lat1+2.0
 AND B.LONGITUDE BETWEEN @long1-2.0 and @long1+2.0 AND
 ADSPRD.dbo.getDistance(@lat1,@long1,B.latitude,B.longitude)  10
It's definately not as simple as your cross join solution, but it's the
equivalent of lightning fast by comparison.

Thanks for everyone's help on this!

Rick


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268870
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help

so many solutions, so little time!

I like how you're limiting by latitude only and using the radius as well.

Doing that actually lowered my execution time to 94ms ...

 =)

On 2/6/07, Jim Wright [EMAIL PROTECTED] wrote:

 Russ wrote:
  No, I'm referring to:
 
 
 http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818
 

 That one is pretty quick here...
 SELECT b.* FROM tblzipcodes a CROSS JOIN tmpzipcodes b
 WHERE dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude) 
 10 AND a.zip = '27614'

 Took 1412 ms.

 I limited the latitude side of things with...

 SELECT b.* FROM tmpzipcodes a CROSS JOIN tmpzipcodes b
 WHERE a.zip = '27614'
 AND b.latitude  a.latitude + (10*.014457)
 AND b.latitude  a.latitude - (10*.014457)
 AND dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude)  10

 which only took 170ms

 I think that .014457 is right...basically 1 degree/69.172 miles.


 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268871
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Query error

I get the following during a radius check on zipcodes when I choose say 500 
miles from point x

Internal Query Processor Error: The query processor ran out of stack space 
during query optimization

Any Ideas?

Doug B.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268872
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Uploading files to one server, propgating them to many. Was: Client variables? reliable enough?

2007-02-06 Thread Eric Haskins

We use UNC shares in our current enviroment but now we are integrating Linux
Apache boxes on the front end so in the interim we have a 1TB File (750Mb
Raid 5) Server that does NFS and CIFS shares. We are moving to a Netapps
Filer in a bit so we just picked up a SNAP Server to hold us over

Eric


On 2/6/07, Paul Vernon [EMAIL PROTECTED] wrote:

  We use SVN to deploy to code to a single server, and then we
  use DFS to automatically propagate the changes.

 That of course is the better option if your environment supports it :)

 Paul




 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268873
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Query error

I found it. I guess I have to many records to perform an IN search against
the table and will need to use a temp table to do it. According to MS and
using SQL2000

Doug B.
- Original Message - 
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 06, 2007 12:44 PM
Subject: Query error


 I get the following during a radius check on zipcodes when I choose say
500 miles from point x

 Internal Query Processor Error: The query processor ran out of stack space
during query optimization

 Any Ideas?

 Doug B.

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268874
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help

Rick Root wrote:
 
 I like how you're limiting by latitude only and using the radius as well.
 

Thinking about limiting it by longitude made my head hurt...I thought 
about using some larger constant (like the 2 degrees that you used), but 
in Alaska, 2 degrees longitude only equates to about 44 miles in some 
places.  Limiting by latitude at least gets the bulk of the comparisons 
out of the way.

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268875
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: single session variable disappearing.

2007-02-06 Thread Claude Schneegans

 Can anybody think of unusual reasons for a specific session variable 
to randomly disappear?

Yeah, when CFHTTPing from a template, the called template is not aware 
of the current session and will open a new one.
This one kept me busy for quite a while some times ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268876
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

data source metadata

2007-02-06 Thread Brad Wood

If I have a ColdFusion data source name, can I programmatically access
information such as the database it is pointed to and/or the jdbc url?

 

~Brad



~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Transact-SQL help