RE: regex help

2003-06-16 Thread Greg McDaniel
Too bad it does not install on W2K.
:`(

-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 12:55 PM
To: CF-Talk
Subject: RE: regex help


Michael,

I also use this program to help test regex's.  It's quicker than using cf
most of the time.

http://laurent.riesterer.free.fr/regexp/

Marlon

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 12:47 PM
To: CF-Talk
Subject: Re: regex help


in1 should be testNum, I typed it in wrong...


- Original Message -
From: "Michael T. Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 1:44 PM
Subject: regex help


> I am trying to determine if an integer begins with 332.
>
> The number varies in length from 4 to 9 digits in length. If 332 begins
the number I would like to return the number minus the 332.
>
> I am still trying to learn regex so an explanation with any ideas would be
very helpful. Here is what I am starting with:
>
> 
> 
>
> Thanks,
>
> MT
>
>
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How to call CFSTOREDPROC without parms

2003-06-13 Thread Greg McDaniel
I have a simple stored procedure in Oracle that takes no parms and
returns no data.

I can run this proc in sqlplus, works great.

Run this from Coldfusion
 
returns:
ORA-06550: line 1, column 18: PLS-00222: no function with name 'CLEANUP'
exists in this scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored.

  Oracle 7 drivers.
  Only two tables exist in this database.
  Procedure compiles successfully and runs.


Here is the procedure:

CREATE OR REPLACE
PROCEDURE   "CLEANUP"
AS
BEGIN
delete from bdcd
where cfid in (
select b.cfid
from bdgd b
where b.create_date <= trunc(sysdate)
);
insert into bdgd
select b.cfid, trunc(sysdate + 2)
from bdcd b
where b.cfid not in (
select a.cfid from bdgd a
where a.cfid = b.cfid
);
delete from bdgd
where create_date <= trunc(sysdate);
commit;
END;
/


Any help?

Thanks,

Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cf studio users

2003-06-09 Thread Greg McDaniel
I'm interested.

Greg M

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 2:44 PM
To: CF-Talk
Subject: RE: cf studio users


ColdFusionProNews is?


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 09, 2003 1:39 PM
> To: CF-Talk
> Subject: cf studio users
>
>
> I got an interesting article in my email today written by Ben
> Forta called "extending coldfusion studio" from
> ColdFusionProNews. If anyone is interested in it, let me know
> and I will forward it to you.
>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfapplication and cookies

2003-03-20 Thread Greg McDaniel
Would this "trick" also work with ClientManagement instead of
SessionManagement?

Greg

-Original Message-
From: Darren Houle [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 9:59 AM
To: CF-Talk
Subject: RE: cfapplication and cookies


I may be misunderstanding your exact wants but just in case it helps here's
a quick  primer on cookies and CF applications...

First, cookies...

Cookies are basically stored in web browers two different ways, either in
memory or written to a file on the local drive.  If code instructs the
browser to create a cookie then it is always created first in the browser's
memory.  If you give that cookie an expiration value then the browser,
usually on close, will write that cookie to a hard file and add the
expiration date/time to the record.  If you don't set any expiration dateb
then the cookie never makes it to a hard file, it disappears when the
browser unloads from memory.  Because of this behavior you can work with
cookies that live *only* in memory if you wish, but in CF you have to do
some tricks to get that to happen.  In a nutshell that's pretty much how
cookies work.  You can do some fancy pants stuff and I can also imagine some
situations where this default behavior could be changed but for all intents
and purposes this is correct.

Now, for ...

When you add  to a page what it basically does is provide
that browser session with a server side memory area (this is changable but
it's the default) to store user variables and it links that memory area to
that specific web browser by way of cookies.  CF instructs your browser to
create two cookies, one called CFID and one called CFTOKEN.  Each one stores
only a number, pointer information that the server side uses to connect your
browser requests to your session data on the server.  When CF creates these
cookies it sets, by default, an expiration value for the cookies equal to
either the default timout value in CF Admin or else the timeout value set
manually using the applicationtimeout and sessiontimeout attributes of the
cfapplication tag.  Since an expiration value is defined, the cookies are
written to hard file and persist even after the browser is closed and then
re-opened later.

This is bad, at least for me, because I want the user's session to end when
they click logout, after a certain amount of innactivity, or when the
browser is closed.

To get CF to use session management and these cookies, yet only use them in
memory, you can use a little CF trick that's been around for a while.  Add
the following code to your page wherever you define your cfapplication tag
(usually in an application.cfm file at the root of your application
directory)...





What this does is re-write the session cookies created by the cfapplication
tag immediately after the cfapplication tag creates them, except the
cfcookie tag doesn't set any expiration value so they will only be memory
cookies.

In other words, on the server side... the cfapplication tag instructs the
cfserver to create session memory space for session variables, provide CFID
and CFTOKEN values that link to that memory space, create cookie headers
with expiration values, and get ready to send the cookies to the browser in
the cfserver response.  But then the very next tags, the cfcookie tags,
recreate those new CFID and CFTOKEN cookies before they are sent the
browser.  The new cookies will contain the same memory pointer values that
the first cookies did, but these new cookies have no expiration value.  If
there are no further changes later in your page code to these cookies, their
contents, or their expiration values, then they are sent to the browser
during the cfserver's response and subsequently get set with the proper
session pointers but only in browser memory.

Problem solved.  You get session management (server side session variables),
you get a timeout on the server side (the cfserver will kill the CFID and
CFTOKEN memory ocations after the CF Admin defined innactivity period, and
you get session termination when the browser is cosed because the cookies
are constantly re-written as memory cookies each page load.  The only
drawback is if the users don't ccept cookies, then you have to mess with
CFID and CFTOKEN as URL params.  I just warn everyone that cookies must be
turned on and it avoids all that, but it totally depends on your situation.
You might now be in a position to do that.

Hope this helps, and please forgive if I've missed anything important or
mis-stated something...I did this kind of on the fly :-)

Thanks,
Darren Houle
Sr. Web Developer
Health First, Inc.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and relat

RE: cfapplication and cookies

2003-03-19 Thread Greg McDaniel
I do want to use cookies, but I don't want them written
to the hard drive, it should be in memory only.

I had found a snippet somewhere that said if you did not set
the cookie with an expiration time the cookie would disappear
when the browser was closed.

Something like this: 

Does it really work or is this one of those Urban Web Myths?

Greg M


-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 9:50 AM
To: CF-Talk
Subject: Re: cfapplication and cookies


>This is probably a complex simple question, but here goes.
>
>What settings do I need to put into cfapplication to accomplish the
>following?
>
>   No Cookie written to the Browswer
>   Client Variables Stored in a Database


1. SETCLIENTCOOKIES="No"
2. CLIENTSTORAGE="myDatasource" (make sure you set the tables up via CF
Admin)

I'm also assuming you know that since you won't be setting cookies, you will
have to manually pass the CFID/CFTOKEN value in the URL string to maintain
state.

Regards,
Dave.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cfapplication and cookies

2003-03-19 Thread Greg McDaniel
This is probably a complex simple question, but here goes.

What settings do I need to put into cfapplication to accomplish the
following?

No Cookie written to the Browswer
Client Variables Stored in a Database

Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Looping Client Vars

2003-03-14 Thread Greg McDaniel
You can use


   




Greg

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 1:47 PM
To: CF-Talk
Subject: Looping Client Vars


Anyone have any ideas for looping through and deleting all client variables?
Client isn't a structure, is it?

TIA,

Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Clusters Coldfusion form submissions

2003-03-13 Thread Greg McDaniel
I have two websites running identical code.
One is a standalone.
The other is a cluster. (Not Cluster Cats)

I have a form that submits a page.
  http://www.verifyx.com/safe.cfm";
method="post">...
  ...

I set the hidden form fields using JavaScript like so:
  document.formname.fieldname1.value = "x";
  document.formname.fieldname2.value = "y";
  document.formname.submit();

I cfdump the variables and cfabort at the top of the page before the
action page is fully processed.

On the Standalone version I see that cgi.request_method is set as "POST"
On the Cluster the cgi.request_method variable is set to "GET"

I am not programmatically changing the method on the form submission.

1st Question: Has anyone ever seen this kind of behavior?
2nd Question: I lose my Form variables on the Cluster because of the GET,
right?
3rd Question: What can cause my form submission to change to a GET?


Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Losing Variable Scopes

2003-03-06 Thread Greg McDaniel
I'm running two identical web sites on different platforms.

I'm running a Solaris/Weblogic/BlueDragon/Fusebox application on a Solaris
machine
and I'm having issues with losing the attributes and form scopes between
submit and the server side validation.  In addition, iPlanet is the web
server and Siteminder protects the Web Site.

The W2K/Weblogic/BlueDragon/Fusebox application doesn't have the same issue.
This seems to point to UNIX case issues, which I have quadruple checked, but
I'll do that again just to make sure.  The W2K box also uses Siteminder to
provide Authentication and
IIS 5 is the web server.

If issues with losing entire variable scopes rings a bell with anyone I'd
like to see your thoughts on it.


Many Thanks,
Greg Mc


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: [OT] CFID and CFTOKEN on POPUP Windows

2003-02-28 Thread Greg McDaniel
Thanks to you both for the clarification.

Greg McDaniel



-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 11:22 AM
To: CF-Talk
Subject: Re: [OT] CFID and CFTOKEN on POPUP Windows


oi Greg!!

well if you want them associated with the same session. why not just leave
it.


Critz





Friday, February 28, 2003, 12:09:41 PM, you wrote:

GM> I have a CF App with pop-up windows. The pop-up
GM> windows call server side tags and SQL.

GM> Is it better to have the pop-up windows generate
GM> their own CFID/CFTOKEN pairs, or do they need
GM> to use the same pair as the parent window?


GM> Greg McDaniel

GM>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



[OT] CFID and CFTOKEN on POPUP Windows

2003-02-28 Thread Greg McDaniel
I have a CF App with pop-up windows. The pop-up 
windows call server side tags and SQL.

Is it better to have the pop-up windows generate 
their own CFID/CFTOKEN pairs, or do they need 
to use the same pair as the parent window?


Greg McDaniel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFX_JSpellCheck

2003-02-28 Thread Greg McDaniel
Does anyone have any experience with the CFX_JSpellCheck
tag from CFDEV and Fusebox?

Greg McDaniel


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



OT: Javascript List?

2003-02-21 Thread Greg McDaniel
Could someone please recommend a Javascript List that is
at least as good as CF-Talk?

Greg M.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




CF and Char(1) in Oracle

2003-02-17 Thread Greg McDaniel
In my code I select fields that are defined as char(1) in Oracle and I get
back the expected value plus a bunch of garbage padded to the right.
Trimming the field doesn't get rid of it, so I usually end  up using
substr(x,1,1).

Has anyone else seen this kind of behavior?  Do you know why it is
happening?  How did you address it?

Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Xml, and attributes..

2003-02-10 Thread Greg McDaniel
Is CF-TALK down?
I haven't received any messages since Sunday and 10:00am.

Greg M.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




List Down?

2003-02-10 Thread Greg McDaniel
Is the CF-TALK list down?
I stopped receiving messages Sunday and 10:00am.

Greg M.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Jeremy Allaire leaving MM

2003-02-06 Thread Greg McDaniel
Hmmm, didn't M$ hire away from Borland the primary
Delphi developer several years ago?  I wonder if
Jeremy has been tempted by the Dark Side.

Greg

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 10:01 AM
To: CF-Talk
Subject: RE: Jeremy Allaire leaving MM


exactly.

*blows dust of C# books*


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




Studio 5 development mappings problem (RDS)

2003-01-24 Thread Greg McDaniel
Does anyone have any tips about what might be happening
when an RDS connection repeatedly fails when
debugging a website?

Greg M


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: proper cfparam usage

2003-01-10 Thread Greg McDaniel
Thanks Michael.

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 7:44 AM
To: CF-Talk
Subject: Re: proper cfparam usage


It's legal. The default is only used when the variable does not exist and
dateformatted data is still a date. Just be sure that request.current_date
exists and it a date as well or it'll blow up.

> Can anyone tell me if this is a proper/valid usage for cfparam?
> I'm debugging someone else's application and I've never seen it used this
> way before.
>
>  default=#DateTimeFormat(request.current_date)# type="date">
>
> Thanks,
>
> Greg M
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




proper cfparam usage

2003-01-10 Thread Greg McDaniel
Can anyone tell me if this is a proper/valid usage for cfparam?
I'm debugging someone else's application and I've never seen it used this
way before.



Thanks,

Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: cftry cftransaction across multiple includes

2003-01-03 Thread Greg McDaniel
Thank you Paul that did the trick.

Greg M.

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 10:10 AM
To: CF-Talk
Subject: Re: cftry cftransaction across multiple includes


I would put the CFTRANSACTION before the first CFINCLUDE and /CFTRANSACTION
after the last CFINCLUDE (in other words, at the level of the CASE
statement)

You can also do it with the database instead of ColdFusion, for example in
M$ SQL:


SET NOCOUNT ON
BEGIN TRANSACTION
UPDATE AWads SET AdImpressions=AdImpressions + 1,
AdRan=GetDate(),
AdCTR=convert(money,AdClickThrus)/convert(money,AdImpressions)
WHERE AdID=#AdID#
UPDATE AWmonthCharge SET CurrentCharge=convert(money,CurrentCharge) +
convert(money,#cost#) WHERE CampaignID=#CampaignID# AND YearID=#Year1# AND
MonthID=#Month1#
UPDATE MAX_ID SET tbl_AWimpressions = tbl_AWimpressions + 1
DECLARE @MAX INT
SELECT @MAX = tbl_AWimpressions FROM MAX_ID
INSERT INTO AWimpressions(AdID,ImpPos,ImpCost,ImpID)
VALUES(#AdID#,#Row#,#cost#,@MAX)
COMMIT TRANSACTION
SET NOCOUNT OFF


best,  paul


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



cftry cftransaction across multiple includes

2003-01-03 Thread Greg McDaniel
I have several insert query statements that are CFIncluded as separate files
inside a single CFCase statement.
cfcase.
cfinclude = "qry_insert1.cfm".
cfinclude = "qry_insert2.cfm".
cfinclude = "qry_insert3.cfm".
cfinclude = "qry_insert4.cfm".
/cfcase.

Can I put "cftry" and "cftransaction begin" in the first include
and put the end tags /cftry /cftransaction in the last include?

Would anyone have a way to manage multiple inserts such that they all
rollback if anyone of them fails?  Is the above the wrong approach?

Greg M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RDS Timing Out.

2002-12-02 Thread Greg McDaniel
When I start CFStudio, I get a non-descript popup box
that says "Operation timed out."
When I try to debug a page it eventually says "Operation timed out."
The entire CFStudio crashes even if there is no activity going on within
CFStudio or CF5 Server.

I searched through the Archives and through Google and found
few hits and even fewer related articles.

I'm running CF5 Studio and CF5 Server on the same W2K Pro machine.
I'm using simple mappings:
"c:\inetpub\wwwroot\"
"c:\inetpub\wwroot\"
"http^://localhost/"

I've also tried Homesite+ 5.1 with the same result.
I've also re-installed Server and Studio more times than I care to say.
I've applied all the patches that were recommended.
I have all the recent Virus patches installed and the machine scans clean.
I have a voodoo doll with Bill Gates' picture on it strapped to my monitor.
I can't go to CFMX yet due to project constraints.


Can DreamWeaverMX debug CF5 code?

Is CF5 just a buggy IDE and I should look for something else, or
can someone offer any advice to help fix this problem?


Greg M



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



cfx_jspellcheck as fuse?

2002-11-22 Thread Greg McDaniel
Has anyone implemented the CFX_JSpellCheck from CFDev.com as a fuse? or even
used it?

Greg McDaniel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



RE: [OT][OT] Zip Code Lookup

2002-11-19 Thread Greg McDaniel
Is there a Zip Code lookup that includes the Zip Code + 4?

It would be a huge database.

--Greg

-Original Message-
From: jon roig [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 1:53 PM
To: CF-Talk
Subject: RE: [OT] Zip Code Lookup


If you're using the JCSM database, here's a simple query to pull out all the
zips within #radius# number of miles.




SELECT  lat, lon, Zip, LastLineCity, State
FROM jcszip
WHERE Zip = '#zip#'





SELECT jcszip.Zip,
jcszip.LastLineCity,
jcszip.State,
jcszip.Lat,
jcszip.Lon
FROM jcszip
WHERE (((jcszip.lat)>= (#geoCode.Lat# - (#Radius# * 0.0005))
 And (jcszip.lat)<= (#geoCode.Lat# + (#Radius# * 0.0005))
) AND ((jcszip.lon)>= (#geoCode.Lon# - (#Radius# * 0.0005))
 And (jcszip.lon)<= (#geoCode.Lon# + (#Radius# * 0.0005))
))
ORDER BY jcszip.Zip


We purchased this fairly recently and we love it.

-- jon

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 15, 2002 5:04 PM
To: CF-Talk
Subject: Re: [OT] Zip Code Lookup


charlie griefer wrote:

> I'm building an application where i need to do the 'search within x
> miles of zip code 12345'
>
> Can anybody make a recommendation?  The client would like something
> that offers updates fairly regularly.  Maybe even some sort of XML
> feed direct from the (a) source?
>
> Any leads would be greatly appreciated.
>
> Oh, and would be nice if it integrated easily with CF (to kinda bring
> this question a little bit on topic) :)

Strategy and options depends quite a bit on the usage pattern and the
financial room. I will just presume it is for nearest outlet matching
for now.

If it is for the occasional lookup, I am sure there are webservices
where you can pay per hit. Easy and all the database maintenance is done
for you by the remote partner. But it might be a bit clumsy if you get
back a long list of ZIP codes that you then have to match against your
own database of outlets. And if you get a lot of hits, paying per hit
might not be the best model.

Another option would be to buy a ZIP database with subscriptions for
updates and a bunch of tags for running queries on them. But again, it
might be a bit clumsy if you want to match those results with another
database of outlets.

The last option is to buy the ZIP database and built your own search
system for it. It really isn't that hard to make the database do
distance calculations based on lat/lon pairs, and unless you have a very
special set of datapoints using a smart algorithm and some indexing will
make it very fast, especially since you can do the outlet matching in
the database as well.

I would probably go for option 3, unless there is a business reason for
doing number 1. Let me know if you want some code for option 3.

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



RE: Compare code on two pages...

2002-11-12 Thread Greg McDaniel
I use Beyond Compare and it allows you easily
see the differences and to move code
between the two files.

Excellent tool.

Greg

-Original Message-
From: Sandy Clark [mailto:slLists@;shayna.com]
Sent: Tuesday, November 12, 2002 11:23 AM
To: CF-Talk
Subject: RE: Compare code on two pages...


Beyond Compare
Http://www.scootersoftware.com

-Original Message-
From: Chris White [mailto:whitec@;earthlink.net]
Sent: Tuesday, November 12, 2002 8:10 AM
To: CF-Talk
Subject: Compare code on two pages...


I have the need to take the same page but there different versions and
see what has changed.  Is it possible to see the differences in two
different files using DreamweaverMX?  What are others using if they need
to compare code to see what has changed?

Thanks,

Chris


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



XML Conversations from CF 5

2002-10-18 Thread Greg McDaniel
Has anyone done anything like this?  The code below works with MSXML, but I
want to dump that
in favor of a J2EE compatible call.

I want to send an XML stream to a service and read the response from that
service without using
Microsoft's MSXML service.

-- I set a variable equal to list of commands in XML format.
-- I Open a thread to the proxy service.
-- I Send the message to the service.
-- I Receive a response from the service and load it into a variable.

Can CF use something else besides MS to duplicate the code below or is there
some
kind of dependency that only allows MS to talk to MS?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



How is CFMX J2EE implemented?

2002-10-11 Thread Greg McDaniel

Can anyone answer or point me to a resource about the questions below?

How does the CFMX for J2EE run on a J2EE platform?
Is there a CF stub that has to be installed in a
J2EE Server that allows it to interpret CFMX or
does CFMX produce compiled byte code that
can run on the targeted hosting environment?

If CFMX J2EE is a plugin of some kind on a J2EE server, How do they slice up
the licensing:  Is it per CPU? Per server?  What about clustering?

Developer Licenses I guess are tied to the CFMX Studio, but what if you want
to develop off of a central server and you've purchased "Production"
licenses, do they allow you to develop off of the same license on a
different machine?

I haven't found any white papers detailing how the CFMX J2EE product is
implemented on the host.  My customer is in the middle of Architecting their
new environment and the purists don't want to put CF products in their J2EE
environment.

My client is trying to lower their total cost of ownership by dumping CF and
going to a pure J2EE environment.



Greg McDaniel

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



RE: RegEx

2002-10-10 Thread Greg McDaniel

Sorry, getContainer is not a tag, it is a UDF that you can find on
cflib.org.

Greg
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 10:55 AM
To: CF-Talk
Subject: SOT: RegEx


Ok, I have a string that looks like this:

/web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01

It's an imagemagic identification of a file that my user is uploading.
myfile.jpg is CFFILE.clientfile.

I need to go through this thing and get the 1280x1024 out.  I could come up
with a way to do this w/o regular expressions, but it wouldn't be as
flexible as I'd like it to be.

I've tried this:




And this:



Doesn't seem to work.  Any ideas?





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: SOT: RegEx

2002-10-10 Thread Greg McDaniel

If it always bounded by JPEG and DirectClass, you could use the getContainer
tag.

Greg

-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 11:15 AM
To: CF-Talk
Subject: RE: SOT: RegEx


I thought of that too, but what if there's a space in the file path?

> -Original Message-
> From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 10, 2002 12:04 PM
> To: CF-Talk
> Subject: Re: SOT: RegEx
>
>
> Hi Willy,
>
> if it's always the same structure you could get use
> ListGet(myString, 3, ' ') With space as delimiter.
>
> Just a thought...
>
> Patric
>
>
> WR> Ok, I have a string that looks like this:
>
> WR> /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit
> 95kb 0.3u 0:01
>
> WR> It's an imagemagic identification of a file that my user
> is uploading.  myfile.jpg is CFFILE.clientfile.
>
> WR> I need to go through this thing and get the 1280x1024
> out.  I could come up with a way to do this w/o regular
> expressions, but it wouldn't be as flexible as I'd like it to be.
>
> WR> I've tried this:
>
>
> WR> 
>
> WR> And this:
>
> WR> 
>
> WR> Doesn't seem to work.  Any ideas?
>
>
>
>
>
> WR> -
> WR> Willy Ray
> WR> Web Applications Developer
> WR> Certified Advanced ColdFusion Developer
> WR> Westminster College
>
> WR>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



RE: Any Fusebox and CFMX issues?

2002-08-26 Thread Greg McDaniel

Hal,

  Does your statement about CFMX and Fusebox mean
  that we should throw out FB as a methodology until
  FB4 comes along if we are developing with CFMX?



On the point that it doesn't leverage CFMX - I agree, but then how could
it? It was designed a year prior to CFMX. Maybe it would be more prudent
(though arguably less fun) to be more charitable and see what the FB
community comes up with?



Gm
__
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: DateTime problem?

2002-08-14 Thread Greg McDaniel

A little more background may be helpful.

I'm getting dates from a real-time system in the form
of ddmmm/hhmm but no year, so I have to figure out the
year based on what month it is as compared to the current
local date.  (e.g. If my server date is Jan 1, 2002 03:00:00 and
my real-time system date is 31DEC/0830 which converts to
Dec 31, 2001 08:30:00 etc.)

So I parsed out the dd, mmm, hh, mm, ss and added  for the year.
I tried using the below mentioned CreateDateTime command so that
I can compare my server.datetime.apples to my realtime.datetime.apples.

Please send comments, suggestions and hysterical-rejoinders
to me,

  Greg
-Original Message-

It looks like these commands all return time in GMT.



lsNow  = Now();
lsParseNow = ParseDateTime(Now());
lsDateValue1 = ParseDateTime('07/31/2002 8:18:00','STANDARD');
lsDateValue2 = LSParseDateTime('07/31/2002 8:18:00');
lsDateValue3 = CreateDateTime(2002,7,31,8,18,0);


What If I don't want to convert my time to GMT?

Produces:
lsNow:current local time.
lsParseNow:   +5 hours from current local time.
lsDateValue1: 07/31/2002 3:18:00
lsDateValue2: 07/31/2002 3:18:00
lsDateValue3: 07/31/2002 3:18:00



Why are the commands converting to GMT?  If so, based on what? Can I stop
it?

CF 5.0,
OS W2K,
Time Zone US Central: gmt -6
  Daylight Savings:   gmt -5


__
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



DateTime problem?

2002-08-14 Thread Greg McDaniel

It looks like these commands all return time in GMT.



lsNow  = Now();
lsParseNow = ParseDateTime(Now());
lsDateValue1 = ParseDateTime('07/31/2002 8:18:00','STANDARD');
lsDateValue2 = LSParseDateTime('07/31/2002 8:18:00');
lsDateValue3 = CreateDateTime(2002,7,31,8,18,0);


What If I don't want to convert my time to GMT?

Produces:
lsNow:current local time.
lsParseNow:   +5 hours from current local time.
lsDateValue1: 07/31/2002 3:18:00
lsDateValue2: 07/31/2002 3:18:00
lsDateValue3: 07/31/2002 3:18:00



Why are the commands converting to GMT?  If so, based on what? Can I stop
it?

CF 5.0,
OS W2K,
Time Zone US Central: gmt -6
  Daylight Savings:   gmt -5


Greg

__
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: CFMX and XML

2002-08-12 Thread Greg McDaniel

Mathew, Jon and Brook, 

Thank you for all of your input.

I've looked into CFX xml tags, but not CFX http tags. 
JSP looks like an answer that will work.  

Who would have thought that sending and receiving 
an XML string would be such an effort.

Greg


__
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



CFMX and XML

2002-08-09 Thread Greg McDaniel

Does CFMX have a better way of sending and receiving
XML data?  The following way seems to be constrained to just
working with WinTel machines.  What If I wanted to use Lintel?









  http://wpcftst1/ProxyService.asp";>


  














    

Greg McDaniel

__
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: Oracle Error

2002-02-07 Thread Greg McDaniel

Just some places to look,
-Are the threads to the database set up to be kept alive in the CF Admin?
-Is TNS configured to disconnect inactive DB threads?
-There may be problems with the DNS server.
-Also, if 8i works like an Application Server, you may need to check the
port
 range for which it communicates to make sure it has an adequate range to
speak
 through.

Greg McDaniel

-Original Message-
> From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 10:58 AM
> To: CF-Talk
> Subject: Oracle Error
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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