RE: Server Restarts

2002-05-25 Thread Ian Lurie

Check for unlocked session and application vars. That'll do it every time.

Ian

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 25, 2002 3:03 PM
To: CF-Talk
Subject: Server Restarts


Over the last several days I notice that the Server is taking longer and
longer to post the pages I am developing.

After a ReStart everything is snappy again!!

For example... Multiple ReLoad's of the page shows 4000 +/- 200
milliseconds. After ReStart it now is showing 1500 +/- 200 milliseconds.

I am looking for advice on how to chase down this problem.

Thanks to the Gurus,

Brian


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Server Restarts

2002-05-25 Thread Webapper

Brian, I would first go to the ColdFusion logs, primarily Application and
Server.  See if you have any unresponsive/thread messages. The fact that you
are "developing" could indicate that some of your newer code is causing some
issues.  The reason I suspect possible threading issues is that restarts
clears things up.  If you do have these sorts of messages in the error logs
chase down the issues with CF's excellent template-line-position info.
Also, if you are using either application or session (also server) scoped
variables, you need to CFLOCK writes and reads.

Hope this helps.

Mike Brunt, CTO Webapper
http://www.webapper.com
Tel: 562.243.6255
Instant Messaging
AIM: webappermb
Webapper, Downey CA Office

"Webapper - Making the NET Work"


-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 25, 2002 3:03 PM
To: CF-Talk
Subject: Server Restarts


Over the last several days I notice that the Server is taking longer and
longer to post the pages I am developing.

After a ReStart everything is snappy again!!

For example... Multiple ReLoad's of the page shows 4000 +/- 200
milliseconds. After ReStart it now is showing 1500 +/- 200 milliseconds.

I am looking for advice on how to chase down this problem.

Thanks to the Gurus,

Brian


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Server Restarts

2002-05-25 Thread Brian Scandale

Over the last several days I notice that the Server is taking longer and longer to 
post the pages I am developing.

After a ReStart everything is snappy again!!

For example... Multiple ReLoad's of the page shows 4000 +/- 200 milliseconds. 
After ReStart it now is showing 1500 +/- 200 milliseconds.

I am looking for advice on how to chase down this problem.

Thanks to the Gurus,

Brian

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Emergency: Authorize. net woos

2002-05-25 Thread Bud

On 5/25/02, Jim McAtee penned:
>Yes, but if you have any kind of customer support dept doing
>credits/refunds, you either have to give everyone the password so that
>they can enter it manually, have only "trusted" personnel do all the
>credits, or else store that password in the system anyway.  If you're
>manually entering the password, that means you need to change it every
>time someone who knows the password leaves the company.  Storing it in the
>system is probably the safest.
>
>I recall several years ago when first implementing a system using
>Authorize.net, I was passing the username/password for every transaction.
>While talking with someone in their support dept about some implementation
>issue, I mentioned this and was told that for _security_ reasons, I should
>only pass the password when doing a credit.  Go figure.

Exactly. The majority of online transactions are sales, not credits 
or refunds. For instance, my shopping cart is not designed to do 
credits. There are dozens of people using it, and now every one of 
them will have to store their password in the database or hard code 
it into the authnet template for now. If you need to do credits 
online, that's one thing, but if you're doing sales only, you should 
not be required to use a password. It accomplishes nothing as far as 
I can tell.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cf_HTML2Excel Question

2002-05-25 Thread C. Hatton Humphrey

Thanks for the reply Joe, I found a solution within the tag itself.
Unfortuately I couldn't use CFContent to generate the spreadsheet.

Hatton

-Original Message-
From: Joe Bastian [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 25, 2002 2:14 PM
To: CF-Talk
Subject: RE: cf_HTML2Excel Question


Hatton,
You can do this straight without using cf_html2Excel
For the specific problem with '00' just use " "
in the table def  Field



Joe



-Original Message-
From: Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:25 AM
To: CF-Talk
Subject: cf_HTML2Excel Question


Does anyone have any expeirence with this tag?  I have it working almost
to where I need it but I'm running into an odd problem.

I have a field that is coming in from a SQL Server VarChar with '00'
as the value in the field.  It is being output to the HTML as 00 in
the table but for some reason the excel file is translating it as a
numeric value and saving a single 0 in the file.  The problem is that
it's *supposed* to be a numeric value, so now I guess the question is
how to I force the tag (or more to the point, Excel) to save the numbers
as characters?

TIA!
Hatton



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: UTF-8 encoding

2002-05-25 Thread Paul Hastings

> I am using CF to generate an xhtml page.
> Does anyone know what I need to do to
> serve the page with UTF-8 encoding?

in cf5:
make it utf-8 format (use notepad to create the template) and pass
in 

in neo:
nothing special.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.365 / Virus Database: 202 - Release Date: 24/5/2545

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cf_HTML2Excel Question

2002-05-25 Thread Joe Bastian

Hatton,
You can do this straight without using cf_html2Excel
For the specific problem with '00' just use " "
in the table def  Field



Joe



-Original Message-
From: Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:25 AM
To: CF-Talk
Subject: cf_HTML2Excel Question


Does anyone have any expeirence with this tag?  I have it working almost 
to where I need it but I'm running into an odd problem.

I have a field that is coming in from a SQL Server VarChar with '00' 
as the value in the field.  It is being output to the HTML as 00 in 
the table but for some reason the excel file is translating it as a 
numeric value and saving a single 0 in the file.  The problem is that 
it's *supposed* to be a numeric value, so now I guess the question is 
how to I force the tag (or more to the point, Excel) to save the numbers 
as characters?

TIA!
Hatton


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



UTF-8 encoding

2002-05-25 Thread Don Vawter

I am using CF to generate an xhtml page.
Does anyone know what I need to do to
serve the page with UTF-8 encoding?



°¿°
 ~
  Don Vawter


FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: QuerySim custom tag and Fusebox 3

2002-05-25 Thread Hal Helms

I use it in child circuits all the time without a problem. On a possibly
related note, I'm wondering why are you using ../ notation to get back
to the home circuit?

-Original Message-
From: heirophant mm [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, May 25, 2002 1:02 PM
To: CF-Talk
Subject: QuerySim custom tag and Fusebox 3


Hi everyone,

I'm using the QuerySim custom tag (find it at www.halhelms.com) to
assist in developing a Fusebox 3 site. When I use it in a template that
I am viewing directly rather than through the Fusebox ( as in
"/index.cfm?fuseaction=circuit.fuse"), it works fine. Also, QuerySim
works fine when calling it through the Fusebox, if it is in the home
circuit.

However, when QuerySim is called in a template used by a child circuit,
something wierd happens. I have found that the value of
thistag.generatedcontent, which would hold the query contents i pass, is
wiped out. Therefore, QuerySim has nothing to make a query out of.

I know that the proper place to be using QuerySim is when you're testing
individual fuses, especially before you have the "real" query fuses
written, so you can say that i'm using QuerySim improperly anyway by
using it within the fusebox itself. (in my defense, i have an acceptable
reason to be doing this in this case and its only temporary, but i wont
try to explain).

Anyway, I thought it was strange that the value thistag.generatedcontent
of a custom tag would be wiped out in that way. I have thoroughly tested
this and found that, indeed, it only happens when calling it within the
Fusebox, and only in a child circuit. I am afraid that this reveals some
sort of subtle problem with Fusebox itself! But I am probably (and
hopefully) wrong...

Mike Mertsock
Alfred University Web Team



Outgrown your current e-mail service?
Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL
PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



QuerySim custom tag and Fusebox 3

2002-05-25 Thread heirophant mm

Hi everyone,

I'm using the QuerySim custom tag (find it at www.halhelms.com) to assist in 
developing a Fusebox 3 site. When I use it in a template that I am viewing directly 
rather than through the Fusebox ( as in "/index.cfm?fuseaction=circuit.fuse"), it 
works fine. Also, QuerySim works fine when calling it through the Fusebox, if it is in 
the home circuit.

However, when QuerySim is called in a template used by a child circuit, something 
wierd happens. I have found that the value of thistag.generatedcontent, which would 
hold the query contents i pass, is wiped out. Therefore, QuerySim has nothing to make 
a query out of.

I know that the proper place to be using QuerySim is when you're testing individual 
fuses, especially before you have the "real" query fuses written, so you can say that 
i'm using QuerySim improperly anyway by using it within the fusebox itself. (in my 
defense, i have an acceptable reason to be doing this in this case and its only 
temporary, but i wont try to explain).

Anyway, I thought it was strange that the value thistag.generatedcontent of a custom 
tag would be wiped out in that way. I have thoroughly tested this and found that, 
indeed, it only happens when calling it within the Fusebox, and only in a child 
circuit. I am afraid that this reveals some sort of subtle problem with Fusebox 
itself! But I am probably (and hopefully) wrong...

Mike Mertsock
Alfred University Web Team



Outgrown your current e-mail service?
Get a 25MB Inbox, POP3 Access, No Ads and No Taglines with LYCOS MAIL PLUS.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: must be a better method

2002-05-25 Thread Dave Watts

> My one thing to add here is that if you can re-work 
> the database to keep date and times separate, it might 
> be beneficial in the long-run. I've had problems in the 
> past creating daily reports because I didn't have
> isolation of the date and time.

I can't imagine why storing the date and time in a single datetime field
would cause a problem. It's easy enough to query the database to find only
the date or the time value, if that's what you want to do.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Emergency: Authorize. net woes

2002-05-25 Thread Dave Watts

> So what's the deal? Is macromedia going to issue a patch 
> to fix the urlencoding problem? 

I have no idea. In my opinion, CFHTTP has been next to useless for quite
some time - it has many, many flaws. Oddly enough, MM solicited the opinions
of a bunch of CF developers (myself included) about what we'd like CFHTTP to
be able to do. Then, apparently, they disregarded all that stuff. Given MM's
track record with CFHTTP, I wouldn't expect anything to change very soon
with it.

Fortunately, it doesn't matter all that much, as there are many alternatives
that you can use to accomplish the same thing. In CF MX, I've been testing
the Jakarta io JSP tag library, which seems to do most of the things I want
to be able to do with an HTTP client:
http://jakarta.apache.org/taglibs/

> It should be automatic. POST doesn't encode, GET does.

Well, it's not that simple. First of all, you should be able to send HTTP
headers whether you're sending a GET or POST request, but CFHTTP doesn't let
you do that - you can only use the CFHTTPPARAM tag when you're POSTing. This
limitation prevents you from using CFHTTP with many cookie-enabled sites, as
they won't necessarily accept anything other than GET requests for many
pages.

Second, headers shouldn't ever be encoded, whether you're doing a POST or a
GET. This is simply a bug.

Finally, you should be able to POST raw data, instead of just name-value
pairs. I think that this has been addressed to some degree in CF MX, but the
other problems would still make the tag unusable for quite a few things.
Since CF MX lets you invoke SOAP services over HTTP directly with the
CFINVOKE tag and CreateObject function, this is less of an issue for me,
now, but it does prevent you from sending raw data to other interfaces, such
as XML-RPC servers.

When I say "finally" above, I don't mean to say that there aren't any other
problems with CFHTTP, just that I'm not going to bother enumerating any
more. Not having full control over headers is kind of a deal-breaker right
there.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: must be a better method

2002-05-25 Thread Andy Ousterhout

you can also use select distinct to be sure you only list each record/total
once.

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 25, 2002 7:34 AM
To: CF-Talk
Subject: Re: must be a better method


  My one thing to add here is that if you can re-work the database to keep
date and times separate, it might be beneficial in the long-run.  I've had
problems in the past creating daily reports because I didn't have isolation
of the date and time.

At 09:49 PM 5/24/2002 -0500, you wrote:
>adrian,
>
>this should work...
>
>SELECT carrier, cast(convert(char(8),mydate,112) as datetime) as
>date_shipped, count(mydate) AS totals
>FROM carrier
>WHERE mydate BETWEEN '05/1/2002 00:00' AND '05/15/1999 23:59'
>GROUP BY carrier,cast(convert(char(8),mydate,112) as datetime)
>ORDER BY carrier,cast(convert(char(8),mydate,112) as datetime)
>
>~ dina
>
>- Original Message -
>From: "Adrian Cesana" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, May 24, 2002 5:49 PM
>Subject: RE: must be a better method
>
>
> > Thanks, this seems to be working well although the output
>format isnt really
> > what I wanted but I can work around that.  The other issue I
>have now using
> > this method is the grouping is also including the times from
>the date field,
> > I only want to group on the mmdd portion.  I know I need to
>use DatePart
> > but cant seem to get it to work with the GROUP BY.  Any
>tips
> >
> > This is basically the query Im using...
> >
> > SELECT carrier,mydate,count(mydate) AS totals FROM mytable
> > WHERE mydate BETWEEN '05/1/2002 00:00' AND '05/15/2002 23:59'
> > GOUP BY carrier,mydate ORDER BY carrier,mydate
> >
> > Thanks,Adrian
> >
> >
> > -Original Message-
> > From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 24, 2002 1:06 PM
> > To: CF-Talk
> > Subject: Re: must be a better method
> >
> >
> > At 12:47 PM 5/24/2002 -0700, you wrote:
> > >Im generating a summary report but the current method Im using
>could result
> > >in up to 100 queries or more...so this is what Im trying to
>achieve.
> > >
> > >Basically dealing with two fields, Carrier and Date.  The user
>selects a
> > >date range, I need a count all the records for each day within
>the range
> > >grouping by the Carrier.
> >
> >   I'm not sure if you want:
> >
> >A single count for the specified date range.  So, if the
>range is June
> > 1st through July 1st, you will get 1 count per carrier.
> >
> >   Or
> >
> >A count for each day in the specified range.  So if the
>range is June
> > 1st through July 1st, you will get 30 counts per character.
> >
> > This might take some experimentation, but.. something along the
>lines of:
> >
> >   SELECT Count(CarrierTable.DateField) as DateCount, Carrier,
>DateField
> >   FROM CarrierTable
> >   WHERE DateField BETWEEN StartDate and EndDate
> >   GROUP BY CarrierTable.Carrier, DateField
> >
> > Something like this (off the top of my head ) should give you
>the output
> > you need:
> >
> > 
> > 
> > #MyQuery.Carrier#
> >
> >
> >   
> > #MyQuery.DateCount#
> >   
> >
> >
> > 
> >
> >
> > 
> > 
> >
> >
> >   But this could potentially cause problems matching up
>carriers with date
> > columns if it is possible that a single carrier will have no
>entries on a
> > date.
> >
> >
>
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Emergency: Authorize. net woos

2002-05-25 Thread Jim McAtee

- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 25, 2002 4:22 AM
Subject: RE: Emergency: Authorize. net woos


> On 5/25/02, Mark A. Kruger - CFG penned:
> >If you are using ADC Direct Response (not relay - direct), the type of
> >implementation where you get a comma delimited list in return for your
post,
> >then you are not "yet" required to use the refer URL. Here's a snippet
from
> >the integration doc that Auth.net published.
>
> I've been trying to get an answer out of them why the
> password-required mode will soon be implemented. All they'll say is
> "Security Reasons". I've told them that my concern is that now,
> everyone's authnet password must be stored on the server or in a
> database for hackers to get to. Once they get that, they can simply
> log in to authnet's console and credit funds to the credit cards of
> their choice. Why on earth should a password be required to submit a
> Sale transaction? I mean, if someone has my username only and would
> like to put money into my bank account, so be it. It doesn't get THEM
> anything.

Yes, but if you have any kind of customer support dept doing
credits/refunds, you either have to give everyone the password so that
they can enter it manually, have only "trusted" personnel do all the
credits, or else store that password in the system anyway.  If you're
manually entering the password, that means you need to change it every
time someone who knows the password leaves the company.  Storing it in the
system is probably the safest.

I recall several years ago when first implementing a system using
Authorize.net, I was passing the username/password for every transaction.
While talking with someone in their support dept about some implementation
issue, I mentioned this and was told that for _security_ reasons, I should
only pass the password when doing a credit.  Go figure.

Jim

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: must be a better method

2002-05-25 Thread Jeffry Houser

  My one thing to add here is that if you can re-work the database to keep 
date and times separate, it might be beneficial in the long-run.  I've had 
problems in the past creating daily reports because I didn't have isolation 
of the date and time.

At 09:49 PM 5/24/2002 -0500, you wrote:
>adrian,
>
>this should work...
>
>SELECT carrier, cast(convert(char(8),mydate,112) as datetime) as
>date_shipped, count(mydate) AS totals
>FROM carrier
>WHERE mydate BETWEEN '05/1/2002 00:00' AND '05/15/1999 23:59'
>GROUP BY carrier,cast(convert(char(8),mydate,112) as datetime)
>ORDER BY carrier,cast(convert(char(8),mydate,112) as datetime)
>
>~ dina
>
>- Original Message -
>From: "Adrian Cesana" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, May 24, 2002 5:49 PM
>Subject: RE: must be a better method
>
>
> > Thanks, this seems to be working well although the output
>format isnt really
> > what I wanted but I can work around that.  The other issue I
>have now using
> > this method is the grouping is also including the times from
>the date field,
> > I only want to group on the mmdd portion.  I know I need to
>use DatePart
> > but cant seem to get it to work with the GROUP BY.  Any
>tips
> >
> > This is basically the query Im using...
> >
> > SELECT carrier,mydate,count(mydate) AS totals FROM mytable
> > WHERE mydate BETWEEN '05/1/2002 00:00' AND '05/15/2002 23:59'
> > GOUP BY carrier,mydate ORDER BY carrier,mydate
> >
> > Thanks,Adrian
> >
> >
> > -Original Message-
> > From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 24, 2002 1:06 PM
> > To: CF-Talk
> > Subject: Re: must be a better method
> >
> >
> > At 12:47 PM 5/24/2002 -0700, you wrote:
> > >Im generating a summary report but the current method Im using
>could result
> > >in up to 100 queries or more...so this is what Im trying to
>achieve.
> > >
> > >Basically dealing with two fields, Carrier and Date.  The user
>selects a
> > >date range, I need a count all the records for each day within
>the range
> > >grouping by the Carrier.
> >
> >   I'm not sure if you want:
> >
> >A single count for the specified date range.  So, if the
>range is June
> > 1st through July 1st, you will get 1 count per carrier.
> >
> >   Or
> >
> >A count for each day in the specified range.  So if the
>range is June
> > 1st through July 1st, you will get 30 counts per character.
> >
> > This might take some experimentation, but.. something along the
>lines of:
> >
> >   SELECT Count(CarrierTable.DateField) as DateCount, Carrier,
>DateField
> >   FROM CarrierTable
> >   WHERE DateField BETWEEN StartDate and EndDate
> >   GROUP BY CarrierTable.Carrier, DateField
> >
> > Something like this (off the top of my head ) should give you
>the output
> > you need:
> >
> > 
> > 
> > #MyQuery.Carrier#
> >
> >
> >   
> > #MyQuery.DateCount#
> >   
> >
> >
> > 
> >
> >
> > 
> > 
> >
> >
> >   But this could potentially cause problems matching up
>carriers with date
> > columns if it is possible that a single carrier will have no
>entries on a
> > date.
> >
> >
>
>
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Emergency: Authorize. net woos

2002-05-25 Thread Bud

On 5/25/02, Mark A. Kruger - CFG penned:
>If you are using ADC Direct Response (not relay - direct), the type of
>implementation where you get a comma delimited list in return for your post,
>then you are not "yet" required to use the refer URL. Here's a snippet from
>the integration doc that Auth.net published.

I've been trying to get an answer out of them why the 
password-required mode will soon be implemented. All they'll say is 
"Security Reasons". I've told them that my concern is that now, 
everyone's authnet password must be stored on the server or in a 
database for hackers to get to. Once they get that, they can simply 
log in to authnet's console and credit funds to the credit cards of 
their choice. Why on earth should a password be required to submit a 
Sale transaction? I mean, if someone has my username only and would 
like to put money into my bank account, so be it. It doesn't get THEM 
anything.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Emergency: Authorize. net woos

2002-05-25 Thread Bud

On 5/24/02, Dave Watts penned:
>Well, that's what you get for listening to me - you can set the Referer
>header, but I can't figure a way to stop CF from encoding it, which kind of
>makes the header option useless. This is just one of the many, many ways
>that CFHTTP stinks - there are so many ways, that I never actually use
>CFHTTP; I just replace it with a third-party component - I typically use
>Lewis Sellers' TCPClient COM object for this
>(http://www.intrafoundation.com/freeware.html), if I'm working on Windows.
>It's pretty easy to use, and best of all, it doesn't do anything you don't
>tell it to do!

So what's the deal? Is macromedia going to issue a patch to fix the 
urlencoding problem? It should be automatic. POST doesn't encode, GET 
does.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: FreeBSD and Java = CFMX???

2002-05-25 Thread Brandon Harper

> From: Alex <[EMAIL PROTECTED]>
> You have to be realistic and have a little business savvy. 

Concur.  I've seen maybe 3-4 people mention they were interested in
seeing it on FreeBSD? 

So I'm curious, has anyone been able to get the Linux version of CFMX
running on FreeBSD 4.5?  Believe it or not, I once had JRun running on a
FreeBSD 3.4 box a couple of years back just to see if I could get it up
and running.  It was slow and it crashed a little too often, but it
worked at least.  I do remember seeing something about CFMX on FreeBSD
in the beta forums, but I don't remember coming across anyone claiming
to have of gotten it working.

Anyhow, one of the projects I'm planning on pursuing over the weekend is
trying to get CFMX working on 4.5 with Linux emulation.  If it runs
reasonably, I could certainly justify purchasing a copy of it to use on
my personal server so long as the final version still work on it.  I'm
in the process of throwing some hardware together to try it out since I
don't have anything newer than a firewall/NAT box running 4.3 around,
and I really don't want to do a buildworld on my personal server to
upgrade it since its pretty customized at this point.

I don't think I could swallow having to move back to Linux or Win2K on
my personal server, unfortunately.  I hope I can get it to work.
Otherwise I'm stuck with PHP for now.

- Brandon

--
http://spooled.net
http://booms.net

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists