Query to find Primary key?

2004-04-22 Thread Mark W. Breneman
Is it possible to find the column name of the primary key in a table from a
query?

Select getPrimarykey() as Pkey

>From table

FYI I'm running MS SQL2000

Thanks



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: "FREE" BD vs. "$$$$" CF

2004-04-22 Thread Mark W. Breneman
$100+ do exist.  And I am sure that holding one of these makes all problems
solvable with hammering.



$174.99 

15-Ounce Titanium Hammer 

http://www.amazon.com/exec/obidos/tg/detail/-/B6K158/qid=1082644930/sr=1
-2/ref=sr_1_2_etk-tools/102-3185839-9957746?v=glance&s=hi&n=228013



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Paul Kenney [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 21, 2004 9:38 PM
To: CF-Talk
Subject: RE: "FREE" BD vs. "" CF

Expecially if that's a $100 hammer.

Paul Kenney
[EMAIL PROTECTED]
916-212-4359 

> -Original Message-
> From: Nathan C. Smith [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 21, 2004 7:24 PM
> To: CF-Talk
> Subject: RE: "FREE" BD vs. "" CF
> 
> 
> When the only tool you have is a hammer you tend to see the 
> problem as a
> nail.
> 
> -Original Message-
> From: Jim Davis [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, April 21, 2004 7:48 PM
> To: CF-Talk
> Subject: RE: "FREE" BD vs. "" CF
> 
> 
> Actually we use CICS on our mainframe. I've just started a 
> project where I
> need to deal with it for the first time.
> 
> Also, just to round this out, it was IBM Consulting Services that
> "recommended" WebSphere as the obvious solution for the 
> enterprise.  The
> management hired them to examine our then-current 
> applications (written for
> our part in CF) and determine our future course of action.
> 
> How surprised were we when they settled on WebSphere on AIX?  
> Not very.  ;^)
> 
> Jim Davis
> 
>   _  
> 
> From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, April 21, 2004 11:20 AM
> To: CF-Talk
> Subject: Re: "FREE" BD vs. "" CF
> 
> On Apr 21, 2004, at 7:48 AM, Jim Davis wrote:
> 
> > This isn't all that odd. in my case the problem is similar, 
> but comes 
> > from
> >  another end.  My (very large) company won't consider 
> either product 
> > because
> >  their both too cheap - and so (goes the management 
> opinion) are not 
> > fit for
> >  enterprise use.
> >
> >
> 
> I used to work for IBM Data Processing Division and many IBM products 
> were (rumored to be) priced this way (high) because they had a 
> "perceived" greater worth.
> 
> One specific product comes to mind, CICS.
> 
> This was a back-end terminal to MaimFrame CPU (no network) 
> information 
> system.
> 
> It was a good system, but nowhere near the capability, power, 
> ease-of-use, etc. of CFMX.
> 
> Work was essentially completed on the product in the 1980's 
> and it went 
> into maintenance mode (no new development)
> 
> The last I heard the number of users of the CICS (MaimFrame DOS) 
> version was over 30,000 users.
> 
> The average cost to IBM customers was $3,000
> 
> per month
> 
> You do the math!
> 
> Dick
> 
>   _ 
>   _  
> 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: A lesson in security by obscurity...

2004-04-22 Thread Mark W. Breneman
One last note on this topic

It seems that there is a problem with number 8 according to root of the site
http://www.academy.dyndns.org/
"THE TRAFFIC PROBLEM IN LEVEL 8 WILL BE FIXED THURSDAY"

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Marlon Moyer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 22, 2004 9:05 AM
To: CF-Talk
Subject: RE: A lesson in security by obscurity...

Nope, Firefoxbtw, this thread is continuing in CF-community.

-- 
Marlon Moyer, Sr. Internet Developer
American Contractors Insurance Group
phone: 972.687.9445
fax: 972.687.0607
mailto:[EMAIL PROTECTED]
www.acig.com

> -Original Message-
> From: Burns, John D [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 9:02 AM
> To: CF-Talk
> Subject: RE: A lesson in security by obscurity...
> 
> Marlon,
> 
> Are you using IE 6?  I disabled Active Scripting in Security and the
>  tags aren't showing up.  This is driving me nuts.
> 
> John
> 
> -Original Message-
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 9:44 AM
> To: CF-Talk
> Subject: RE: A lesson in security by obscurity...
> 
> answer at bottom.
> 
> --
> Marlon Moyer, Sr. Internet Developer
> American Contractors Insurance Group
> phone: 972.687.9445
> fax: 972.687.0607
> mailto:[EMAIL PROTECTED]
> www.acig.com
> 
> 
> > -Original Message-
> > From: Burns, John D [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, April 22, 2004 8:39 AM
> > To: CF-Talk
> > Subject: RE: A lesson in security by obscurity...
> >
> > Marlon,
> >
> > I'm not sure what you mean.  I tried selecting everything on the
page
> > before the _javascript_ prompt and the _javascript_ prompt page.  I'm
> > confused.  Any more help?  What am I looking for?
> >
> > John
> >
> > -Original Message-
> > From: Marlon Moyer [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, April 21, 2004 10:23 PM
> > To: CF-Talk
> > Subject: RE: A lesson in security by obscurity...
> >
> > -Original Message-
> > From: Tony Weeg [mailto:[EMAIL PROTECTED]
> > Sent: Wed 4/21/2004 8:14 PM
> > To: CF-Talk
> > Cc:
> > Subject: RE: A lesson in security by obscurity...
> > dude its killing me, ive typed everything in I can think of for that
> > page, must you be a mindreader or something here...WTF???
> >
> > and funny how all of us, well most of us tripped up on this one...
> >
> >
> > spoiler space..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> > ..
> >
> > select all of the contents on the page with the mouse.
> >
> >
> 
> I didn't realize it the first time, but you need to disable
_javascript_,
> otherwise, you'll have to view the source and remove all of the font
> tags.  If you disable _javascript_, the  tags will print out
> black characters on a black background.  Select them and you have the
> clue.
> 
> >
> >
> >
> >
> 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: best CF host for 20 dollars a month

2004-04-21 Thread Mark W. Breneman
I don't think they do multi domain hosting but, you can always ask.
$7.95/month
Mysql
CF5

http://www.cheapesthosting.com/

I have few "brochure ware" sites hosted there for my after hours clients.
They seem to be a fair hosting provider. I don't think I would do a large
ecom site with them.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 21, 2004 10:36 AM
To: CF-Talk
Subject: best CF host for 20 dollars a month

who does everyone think is the best CF host for 20 dollars a month. im
hoping to get sql server access as well as host multiple domains (and create
sub domains). thanks.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Windows Server 2003

2004-04-20 Thread Mark W. Breneman
I am *guessing* that CF5 will run on W2k3 server but, I know that it will
not install correctly and register the ISAPIs for .cfm in IIS 6.

I would highly advise upgrading to CFMX 6.1 if CF5 is not officially
supported on W2k3 server, if this is a production server.  

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Adrocknaphobia [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 4:39 PM
To: CF-Talk
Subject: Re: Windows Server 2003

Is CF5 even supported on Win2k3? I would imagine it's not since it didnt
exist when CF5 was out.

-adam

> -Original Message-
> From: David Koehler [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 20, 2004 09:37 PM
> To: 'CF-Talk'
> Subject: Windows Server 2003
> 
> Ok, our old Dell server needs replacing so we bought a new beast with
Windows Server 2003. I installed our CF Server 4.5.1 and then the CF 5
Server update, which had problems finishing. Are there some compatibility
issues? Is CF 6.2 something I can download and use instead. Any help is
appreciated.
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Is it a bug or not a bug?

2004-04-20 Thread Mark W. Breneman
I am curious on how one would go about using this in "real life". If you're
looking for a boolean result then why would you use 5*4 in an _expression_?



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 3:24 PM
To: CF-Talk
Subject: Re: Is it a bug or not a bug?

>>it'll return the last value evaluated in the _expression_.

This IS the bug: it should return the type implied by the operator in the
_expression_.
in true and 4*5, CF has a boolean and a boolean operator, It thus has to
evaluate 4*5, THEN convert it to a boolean in order to complete the boolean
operation.
Finally it has to evaluate (true AND true) and return the result true, not
20.

There is loosely and too loosely, and too loosely is lousy ;-)
___
See some cool custom tags here:
http://www.contentbox.com/claude/customtags/tagstore.cfm
Please send any spam to this address: [EMAIL PROTECTED]
Thanks.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Is it a bug or not a bug?

2004-04-20 Thread Mark W. Breneman
I thought I had seen someone on this list, when MX came out, warning
everyone to not use it due to it broke a convention (or something like that)
and it may not be supported in the future versions due to MM did not
officially acknowledge it as a feature.  So thus I tried to not use it, but
I did find it real handy at times.

I guess I should read MM docs and not believe everything I read on this
list. :-)

Does this method of mathematical calculations have an official name? Other
then "performing mathematical calculations between # signs".

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 3:32 PM
To: CF-Talk
Subject: Re: Is it a bug or not a bug?

Yes I'm sure they do. I don't know about good or bad, I really haven't 
thought about it. It does work.

Mark W. Breneman wrote:

> Does MM officially support performing mathematical calculations between #
> signs? I was sorta under the impression that this was considered not a
good
> practice. Regardless it is handy.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Is it a bug or not a bug?

2004-04-20 Thread Mark W. Breneman
Does MM officially support performing mathematical calculations between #
signs? I was sorta under the impression that this was considered not a good
practice. Regardless it is handy.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Dave Carabetta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 2:03 PM
To: CF-Talk
Subject: RE: Is it a bug or not a bug?

>#(true and 4*5)# returns 20.
>#(false and 4*5)# returns false.
>#(4*5 and false)# returns false.
>#(4*5 and true)# returns true.
>
>Is it a bug or it is using some sort of _expression_ evaluation that I am not

>aware of.
>

CF uses short-circuit boolean evaluation. So it'll either stop the moment it

hits a false condition or it'll go to completion. Further, any non-zero 
value evaluates to true, so 4*5 (20) will always evaluate to true.

Regards,
Dave.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: [OT] Dreamweaver nightmare

2004-04-19 Thread Mark W. Breneman
Right you are!

But, I don't want to use the templates as a dream weaver template (that is
what CFincludes do for me).  I just want to control what contribute users
can edit.   As far as I know using the templates is the only way I can do
that.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Marlon Moyer [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 19, 2004 1:18 PM
To: CF-Talk
Subject: RE: [OT] Dreamweaver nightmare

I thought the whole point of templates was that it is a "template" that
will be replicated on each of the pages that uses that template.  So, if
you need to add something to a non-editable region, you would edit the
template file and then have the changes cascade to the pages.

-- 
Marlon Moyer, Sr. Internet Developer
American Contractors Insurance Group
phone: 972.687.9445
fax: 972.687.0607
mailto:[EMAIL PROTECTED]
www.acig.com

> -Original Message-----
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 1:09 PM
> To: CF-Talk
> Subject: RE: [OT] Dreamweaver nightmare
> 
> On the same note. Is there a way to over ride the non editable
regions?
> We
> are building contribute templates with DW and the frustrating this is
that
> I
> need to open them in a text editor to make changes to them after
adding
> non
> editable regions.
> 
> 
> 
> Maybe some thing like a command line switch when DW loads?
> Dreamweaver.exe
> /ignorenonedit
> 
> 
> 
> I assume that answer is to use homesite that comes with DW. Although,
I am
> a
> big homesite / CFS fan, but I have made the switch to DW. (To be
> consistent
> with what the rest of the office is using) I don't like switching IDEs
mid
> stream. Both apps complain that the file has been edited and want to
> reload
> it.
> 
> 
> 
> Mark W. Breneman
> -Cold Fusion Developer
> -Network Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
> 
>   _
> 
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 1:01 PM
> To: CF-Talk
> Subject: RE: [OT] Dreamweaver nightmare
> 
> 
> 
> > We do the combo of the three (CF, DW Templates, and
> > Contribute). But, we've found that we must include the html,
> > head, and body tags in all our templates, only using
> > cfinclude for things like navigation and design elements.
> > It's definitely more of a PITA. But, it's the only we've been
> > able to make it work.
> 
> I've occasionally been able to get DWMX templates to work without
basic
> HTML
> tags within the page, but typically to do this I have to directly edit
the
> HTML comments that Dreamweaver uses to define template regions, which
is
> suboptimal to say the least.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
> 
>   _
> 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: [OT] Dreamweaver nightmare

2004-04-19 Thread Mark W. Breneman
On the same note. Is there a way to over ride the non editable regions?  We
are building contribute templates with DW and the frustrating this is that I
need to open them in a text editor to make changes to them after adding non
editable regions.

Maybe some thing like a command line switch when DW loads?  Dreamweaver.exe
/ignorenonedit

I assume that answer is to use homesite that comes with DW. Although, I am a
big homesite / CFS fan, but I have made the switch to DW. (To be consistent
with what the rest of the office is using) I don't like switching IDEs mid
stream. Both apps complain that the file has been edited and want to reload
it.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 19, 2004 1:01 PM
To: CF-Talk
Subject: RE: [OT] Dreamweaver nightmare

> We do the combo of the three (CF, DW Templates, and 
> Contribute). But, we've found that we must include the html, 
> head, and body tags in all our templates, only using 
> cfinclude for things like navigation and design elements. 
> It's definitely more of a PITA. But, it's the only we've been 
> able to make it work.

I've occasionally been able to get DWMX templates to work without basic HTML
tags within the page, but typically to do this I have to directly edit the
HTML comments that Dreamweaver uses to define template regions, which is
suboptimal to say the least.

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

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfloop

2004-04-16 Thread Mark W. Breneman
I guess the question I was asking is, is there a difference in execution
time between tag and script based loops in CF.  Would I be better off
(shorter execution time) writing a cfscript for a chunk of code that will
loop say 1000 times? Or is the difference too small to worry about.



It is good to know that they work differently under the hood.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 1:21 PM
To: CF-Talk
Subject: RE: cfloop

Actually, it's both a very useful technique, and only a problem if you're
using CFLOOP.  Say you want to remove duplicate elements from a list.  If
you remove anything, you'll just get an "invalid list index" error, but if
you use CFSCRIPT you'll be just fine.

Here's code for the two different methods.  The script call returns
"1,2,3,4,5", just as it's supposed to, but the tag call throws an "Invalid
list index 6." error.


function dedupeListScript(list) {
var map = structNew();
var i = "";
for (i = 1; i LT listLen(list); i = i + 1) {
if (structKeyExists(map, listGetAt(list, i))) {
list = listDeleteAt(list, i);
i = i - 1;
} else {
map[listGetAt(list, i)] = "";
}
}
return list;
}


















#dedupeListScript(myList)#
#dedupeListTag(myList)#

> -Original Message-
> From: Philip Arnold [mailto:[EMAIL PROTECTED] 
> Sent: Friday, April 16, 2004 11:05 AM
> To: CF-Talk
> Subject: RE: cfloop
> 
> > From: Barney Boisvert
> > 
> > 
> > 
> > 
> > 
> > 
> > #i#-#arrayLen(a)#
> 
> But why would you do this in the first place?
> 
> Looping over an array that you're changing the size of within the loop
> is just asking for trouble
> 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfloop

2004-04-16 Thread Mark W. Breneman
On the same note.

Is a loop using cfscript or  faster, slower or the same on a CFMX
server?

My guess is that they both compile to the same java byte code.  It that
correct?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 16, 2004 12:26 PM
To: CF-Talk
Subject: RE: cfloop

Nope, the commas were causing it to stop - interestingly enough, it was 
pointed out that int(10,000,000) gave up 36,799.

At 01:19 PM 4/16/2004, Jim Davis wrote:
>Are you sure that you're just not hitting the page timeout?
>
>
>
>Jim Davis
>
>
>
>   _
>
>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>Sent: Friday, April 16, 2004 11:42 AM
>To: CF-Talk
>Subject: Re: cfloop
>
>
>
>Well, I just did a quick one (index loop) that tried to loop 10 million
>times, and it looks like it consistently stops at 36,799 and goes no
>further.  That help?
>
>
>#i#
>
>
>Ray
>
>At 11:34 AM 4/16/2004, Tony Weeg wrote:
> >hey there.
> >
> >whats the max number of iterations I can expect cfloop to handle before
it
> >craps out?
> >
> >1 million, 2 million?
> >any number that anyone knows of?
> >
> >thanks!
> >
> >...tony
> >
> >tony weeg
> >senior web applications architect
> >navtrak, inc.
> >www.navtrak.net
> >[EMAIL PROTECTED]
> >410.548.2337
> >
> >
> >
>
>   _
>
>
>
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JRun eating RAM

2004-04-15 Thread Mark W. Breneman
What is your query cache and template cache set to?  If these values are set
high then jrun taking 200Mb is more or less normal. Try setting these values
lower and see if the server still does that.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 15, 2004 4:25 PM
To: CF-Talk
Subject: JRun eating RAM

Hey All,

We've had an odd issue that up until now I was living with...now it's time
to fight back!! ;-)

We've seen this on CF MX 6.1 on Windows 2000 Advanceed Server

1) A parsing error occurs (i.e. 
">")
2) No error is displayed immeadiately
3) JRun starts eating RAM (I've seen it get up to almost 20K before I
reboot the server)
4) A minute or more later a fairly non-descriptive CF error shows in the
browser
5) JRun never lets go of the memory so I always end up rebooting

Now in Dev this is a PIA, but in Prod it's totally unacceptable (but
unlikely to happen as we have tested before sending to Prod).

I've read up on the few hotfixes and patches for CF MX 6.1, but none seem to
apply to this issue.

Any idea folks???

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

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Bread Crumb Trail with CFMX

2004-04-15 Thread Mark W. Breneman
One thing we have done in the past is to use the file name as a list for the
bread Crumb. 

home_section_subsection_page cfm = Home >> Section >> Subsection >> Page

We have done variations based on aberrations that relate to full bread Crumb
titles in a database.

hm_sec_sub_pg.cfm = Home >> Section >> Subsection >> Page

If your nav is totally database driven then it is real simple to build bread
Crumbs.  All you have to do is to look up the parent of the current page
then check to see if that page has a parent ..



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 15, 2004 2:34 PM
To: CF-Talk
Subject: RE: Bread Crumb Trail with CFMX

What are you trying to accomplish?  Setting up the navigation or storing the
results?

The simple breadcrumb trail is completely determined by the author-defined
hierarchy of pages.  You define "this page is in this sub-section which is
in this section" and create three links to represent that.  Something like:

Home >> Section >> Subsection >> Page

You can drive this solely by directory structure if you're set up that way,
by page-level parameters if your pages are distinct, by template level
parameters if you're content is parametized, etc - it really depends on your
site structure and the detail of your definition.

_javascript_ isn't be as nice an option, I think, since this really is a
server-side decision.  (That being said I just finished a _javascript_
implementation of a breadcrumb trail/navigation scheme for the office.)

Now the other style of breadcrumbs which is rarely seen (but ironically
matches the "breadcrumb" metaphor much better) is the clickstream.  In this
case you display the specific users path the current information, regardless
of how you (the author) have organized things.  This is as simple as
creating a session-scoped array.  You just place each page visiting into the
array and then, on demand, display the links.

I do something like this at www.depressedpress.com
  (visit a few pages and then choose "Your
Clickstream" from the left).  I do this mostly for myself (I store the
clickstream in the database at the end of the session) but also make it
available to the end user.

In the end this really isn't something that can be "tacked on" using a
pre-canned thing but rather something that's pretty much determined by how
you've set up your site.  Give us details on that and we should be able to
point you in the right direction.

Jim Davis

  _  

From: Merritt Chapman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 15, 2004 2:29 PM
To: CF-Talk
Subject: Bread Crumb Trail with CFMX

Does anyone know where I can find a good example of a cf driven bread crumb
trail?  Maybe a _javascript_ version?

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX6.1 updater

2004-04-13 Thread Mark W. Breneman
I thought I heard about a new service pack for CF too, but a few weeks about
Ben had this to say,



"The next planned version of ColdFusion is codenamed "Blackstone", and
version numbers, pricing, etc., have yet to be discussed at all.

But, and this is my own opinion here, I doubt that there will be another
maintenance release for CFMX any time soon. CFMX needed updates, which is
why we released service packs and then v6.1, But 6.1 has proven to be
reliable and solid and arguably one of the best ColdFusion's ever, and so a
maintenance release is unlikely.

Bottom line, use 6.1 now, and stay tuned for announcements from MM." - Ben
Forta February 23

CF-Talk - Subject: Re: Question regarding CFMX 6.2

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 3:37 PM
To: CF-Talk
Subject: Re: CFMX6.1 updater

AIT said:
> Hey does anyone have any idea when an updater for CFMX6.1 might be
> out?

I seem to recall somebody commenting that an updater was 'under
consideration'. Probably your best bet is
http://www.macromedia.com/go/wish/

Jochem

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Null Pointer from CFQUERY

2004-04-13 Thread Mark W. Breneman
Is it the double dots in etrade..Bank that is causing your problem? 

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Alisa Thomson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 12:25 PM
To: CF-Talk
Subject: Null Pointer from CFQUERY

I am testing out an application that we want to migrate to CFMX (currently
CF5).  I am getting a NullPointerException from one of my queries when I use
jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with
CFMX.  We want to use jConnect because all of our Java apps use that and we
ran into other issues with the driver that ships with CFMX.  Here is the
query:

  
 SELECT FirstNme
 FROM etrade..Bank
 WHERE BankId = 'WF'
  

As you can see, there are no variables in the query so the
NullPointerException is not caused by an undefined var.  The FROM clause is
referencing a view that actually references another view in another
database.  We have other queries set up this same way that work fine under
jConnect 5.5. The stacktrace just says:

java.lang.NullPointerException

no other information.  Anyone have any ideas?

Thanks in advance.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Mark W. Breneman
If you find that the page is being run by something other than CFSCHEDULE
try something like this





Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 11:29 AM
To: CF-Talk
Subject: RE: MX: Scheduler firing off too often

At 09:35 AM 4/13/2004, you wrote:
>In that email, that you are sending to your self, you may also want to add
a
>few CGI vars to see where and what is calling that cfm page.  One time
>Google some how found a .cfm page that I had scheduler set to run once a
>week and every time Google spidered the site it would run that page.

That's a damn fine idea. Thanks!

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MX: Scheduler firing off too often

2004-04-13 Thread Mark W. Breneman
In that email, that you are sending to your self, you may also want to add a
few CGI vars to see where and what is calling that cfm page.  One time
Google some how found a .cfm page that I had scheduler set to run once a
week and every time Google spidered the site it would run that page.

HTTP_REFERER: #CGI.HTTP_REFERER#

HTTP_USER_AGENT: #CGI.HTTP_USER_AGENT# 

REMOTE_ADDR: #CGI.REMOTE_ADDR#

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
  608.270.9770

  _  

From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 13, 2004 9:48 AM
To: CF-Talk
Subject: Re: MX: Scheduler firing off too often

Ack, should have said "Linux" instead of "Windows" there.

At 08:45 AM 4/13/2004, you wrote:
>Hey folks -
>
>I've got an MX box (Windows) with a oddly behaving scheduler. I've got a
>single task in the list, that fires off once every three minutes. I've got
>the task aborting early, but not before it sends me a quickie time-stamped
>email. Every once in a while, I'll get two or three emails with the same
>time (sans seconds) on it.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Configuring New CFMX Box

2004-04-12 Thread Mark W. Breneman
That Is a big question...

For starters.

200 - 300 is a lot of sites for one server unless they are low traffic
sites.

How much traffic do you expect?

For this config I might look into clustering two or more CF servers  And,
running a tool like folder mirror to sync the files on the servers.  And,
maybe even an extra server for stand a long SQL server.

All of my servers have an OS partition, a data base file partition, web file
partition and a scratch file partition (raid 0). It may also be a good idea
to make an Apps partition depending on what you will be running on the
server(s). 

If you need to supply stats and or keep IIS log files (Like I do) you may
even need to have a server for just log files or a large partition. One of
my clients have a large conference every three years and during the
conference the standard IIS log files will be about 200MB per day.

As far as securing IIS :

http://www.iisanswers.com/

You will be in fair shape if you use the "Security Operations Guide for
Windows 2000"

http://www.microsoft.com/downloads/details.aspx?FamilyID=f0b7b4ee-201a-4b40-
a0d2-cdd9775aeff8

-a0d2-cdd9775aeff8&displaylang=en> &displaylang=en



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 12, 2004 10:36 AM
To: CF-Talk
Subject: Configuring New CFMX Box

I have and Windows 2000 server that I'm going to configure to host about 200
- 300 CFMX / SQL Server and Access websites.  

Each site will have its own set of templates (View and Controller templates)
but they will all share a set of templates (Model templates).  

I have never had to worry about the server / administrative end of CFMX and
I'm looking for some suggestions on how should I configure the server: 

1). for optimal performance, 
2). to ensure backup, 
3). to secure the application, 
4). to facilitate code maintenance and 
5). to monitor the performance of the individual sites.

I looking for suggestion as it relates to partitioning the drive, patching
OS, removing example files, what should go in wwwroot and maybe what should
not, what supporting software should I look into.  

  

Dwayne Cole, MS in MIS, MBA
Florida A&M University
Certified Advanced ColdFusion Developer
850-591-0212

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Determining if a value exists in a query result

2004-04-09 Thread Mark W. Breneman
That is very similar to the way I do it. 

I think you can skip the query loop by using valuelist():


feature_id)>

Note you can simplify that cfif statement in the checkbox down to:



The above code *should* work the same as your code just a little simpler.



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Austin Govella [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 09, 2004 3:26 PM
To: CF-Talk
Subject: Re: Determining if a value exists in a query result

Austin Govella wrote:

> I have a list of generic features.
> 
> And I have a list of features assigned to a specific item.
> 
> I want to print out the generic features with checkboxes
> next to them.
> 
> If the item in question has been assigned one of the
> features, I would like the checkbox for that feature to be
> checked.
> 
> In the input tag for the checkbox, what function should I be
> using to compare the feature_id to the query results?

This has taken me all day, but I think the break at lunch 
helped clear things up for me.

After querying the selected features, create an empty 
variable (it will eventually hold the list of features):



Using cfoutput, add each of the selected features to the list:



listappend(variables.selected_features,#q_selected_features.feature_id#)>


If you output variables.selected_features, you'll see a 
comma delimited list of feature id's.

While ouputting the complete list of possible features, you 
add a cfif statement to the checkboxes:


name="footnote"
type="checkbox"
value=""

IS NOT "0">
checked="checked"

/>

variables.selected_features is our list of currently 
selected features. feature_id comes from the full list of 
possible features.

This *is* the easy way to solve this, right?

--
Austin

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT Tax on shipping OR billing address

2004-04-08 Thread Mark W. Breneman
That is what I thought.  Or at lease what I hoped. Other wise I would have
to recode several sites.:-(

Thanks! 

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 08, 2004 11:56 AM
To: CF-Talk
Subject: RE: OT Tax on shipping OR billing address

Nope.  Tax is based on destination, and OR doesn't have sales tax, so
whether you have ot or not, there isn't any to charge.  If there were (in
any other state except vermont, I believe), I'm pretty sure you only have to
change it if you (the company) actually have a physical presence in the
state.

Cheers,
barneyb

> -Original Message-----
> From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, April 08, 2004 9:45 AM
> To: CF-Talk
> Subject: OT Tax on shipping OR billing address
> 
> First off sorry for the off topic. But, no one in the office 
> can agree on
> this..
> 
>  
> 
> While building an ecom site, the debate arose if tax gets 
> charged based on
> the shipping address OR the billing address.
> 
>  
> 
> Anyone have an answer to that?   Thanks
> 
>  
> 
> Mark W. Breneman
> -Cold Fusion Developer
> -Network Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
> 
> 
> 
> 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT Tax on shipping OR billing address

2004-04-08 Thread Mark W. Breneman
First off sorry for the off topic. But, no one in the office can agree on
this..

While building an ecom site, the debate arose if tax gets charged based on
the shipping address OR the billing address.

Anyone have an answer to that?   Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JRUN Error: No disk in drive A?

2004-04-07 Thread Mark W. Breneman
I really wish that I could reproduce this problem on one of my dev servers.
Since I see this problem on one of my clients production servers I can't
really play with It and try to resolve it. 

I have a few guesses on what may cause the problem.  

Check your system path, see if a:\  is in the system path (Go to a command
prompt and type "path")

Check your CF logs. CFusionMX\logs.  See if there is some clue in there.

Try disabling RDS if you can  

Any chance you have a database mapped to the A: drive? You may want to take
a peak at the neo-query.xml file.

I know that windows has a registry value for the "install path". I wonder if
CFMX has something similar. Anyone?


Seems like this is something that MAY be able to be tweaked in one of the
XML jrun or neo config files. But, I'm not officially suggesting that you go
out and start editing those files. ;-)

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 07, 2004 10:20 AM
To: CF-Talk
Subject: RE: JRUN Error: No disk in drive A?

Nope, this is just a pure web server.  All we have is IIS and CFMX
installed.  We got the error when restarting the server, not when
RDSing.  Very odd.  If anyone from MM has some insight, please share.

John Burns 

-----Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 07, 2004 10:45 AM
To: CF-Talk
Subject: RE: JRUN Error: No disk in drive A?

I was one of the people looking for a fix for this a few months ago. I
see this error when I try to RDS to a client's server.  Not sure if this
is the same issue.

I can't say for sure but, it looks like the RDS call does not time out.
So, if you have your Max number of connections set to 2 and you attempt
to connect via RDS twice you have no available "connections" and the
server is "dead" until someone dismisses the pop up messages.  I don't
have access to this server so most of this is second hand from the
client and thus can not test this theory.

I am not aware of any current fix for this. I have heard of a rumor that
there is a CFMX 6.1 service pack / hot fix roll up / point upgrade (not
sure what it will be officially be called) in the works and that issues
like this should be address by it.

Just out of curiosity do you have the Novell client installed on the
server?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 9:21 AM
To: CF-Talk
Subject: JRUN Error: No disk in drive A?

Anyone know why a server wouldn't restart while giving a JRUN error
saying there is no disk in Drive A?  I remember this coming up before,
but since the search is disabled on the archives, I can't seem to find
info on it.  Any ideas?

John Burns

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JRUN Error: No disk in drive A?

2004-04-07 Thread Mark W. Breneman
I was one of the people looking for a fix for this a few months ago. I see
this error when I try to RDS to a client's server.  Not sure if this is the
same issue.

I can't say for sure but, it looks like the RDS call does not time out. So,
if you have your Max number of connections set to 2 and you attempt to
connect via RDS twice you have no available "connections" and the server is
"dead" until someone dismisses the pop up messages.  I don't have access to
this server so most of this is second hand from the client and thus can not
test this theory.

I am not aware of any current fix for this. I have heard of a rumor that
there is a CFMX 6.1 service pack / hot fix roll up / point upgrade (not sure
what it will be officially be called) in the works and that issues like this
should be address by it.

Just out of curiosity do you have the Novell client installed on the server?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 07, 2004 9:21 AM
To: CF-Talk
Subject: JRUN Error: No disk in drive A?

Anyone know why a server wouldn't restart while giving a JRUN error
saying there is no disk in Drive A?  I remember this coming up before,
but since the search is disabled on the archives, I can't seem to find
info on it.  Any ideas?

John Burns

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF Quit Working

2004-04-06 Thread Mark W. Breneman
Have any security patches been applied?

I would check to see if the ISAPI for ..cfm is mapped
-Goto your Master website properties.
-Click Home Directory
-Click Configuration - the application mappings will be displayed.

Hope that helps.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Claremont, Timothy [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 3:04 PM
To: CF-Talk
Subject: CF Quit Working

CF 4.5 on XP Pro (IIS), test machine

Came back from vacation and CF pages no longer get served.

HTM pages serve correctly.

Can't open administrator, naturally.

I get the "The Page Cannot Be Displayed" error message.

Removal and reinstallation of CF changes nothing.

Any suggestions?

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFIF within input

2004-04-06 Thread Mark W. Breneman
Ok, sureThe code I posted was one part of my "system" that I use for
building admin pages or order forms. I originally build this to speed up
building admin pages but found that I could use it for any form.

Forgive if I over simplify this. 

Let me start on defining the problem this solves.  I build lots of admin
type pages and one thing that most admin pages do is to read data from a
database and allow you to edit the data. Then you also have the admin pages
that you use to add a new record to the database.  Some times these add or
edit pages need to have required fields.  So I all of my admin pages submit
the form data to themselves and do some processing to make sure that the
required fields are filled and if all required fields are filled it inserts
the data into the database.  If the required fields are not filled in then
the page does not insert the data, and loads the form with a required
message next to the missing fields.  

So what my UDF does is it looks for the value of the input, first in a form
var, then in a query var.  If neither the form OR query contain a value for
the input box then it is just blank.  Also, since the form submits to its
self then it will pull the value from the form and not the query after you
submit the page.

Does that help explain what this does?



Example:


function smartvarText(var1) {

  if (IsDefined("form.#var1#"))

  { return #form[var1]#;

  }

else if(IsDefined(queryname &'.'& var1))

{ return Evaluate(queryname &'.'& var1);

}

return "";

}







 
href="" var



Query:













Form:








action="">
t>" method="post">

First Name:

 


value="#smartvarText(variables.var)#" size="35"
maxlength="255">







Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 1:24 PM
To: CF-Talk
Subject: RE: CFIF within input

mark, im a bit interested however, im not following what ur saying...

can ya explain a bit more..?
thanks
tonyS 

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 1:53 PM
To: CF-Talk
Subject: RE: CFIF within input

I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)

This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank.  This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..




value="#smartvarText(variables.var)#" size="35"
maxlength="255" > 

All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.

UDF:


function smartvarText(var1) {

  if (IsDefined("form.#var1#"))

  { return #form[var1]#;

  }

else if(IsDefined(queryname &'.'& var1))

{ return Evaluate(queryname &'.'& var1);

}

return "";

}





Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input



  _  

From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input

Tony,

When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name 

RO

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input

but at the same time...i would...


  
value="#trim(side_1_comments)#" maxlength="100"> 
  


just to double check, and its more read-able :)

hth
tony

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input

ur missing a ">"


trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">

try that.

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input

I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:


trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">

But I get an error. It seems simple, but I must be missing something I can't
see. 

Any suggestion please? Thanks.

Robert O.
HWW
  _

  _

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFIF within input

2004-04-06 Thread Mark W. Breneman
I spend way too much time building forms, so I devised a better more
flexible way to work with inputs. (IMHO) :-)

This is function will look for a form value named "Yellow", then a query
value named "Yellow" if it does not find either, it will be blank.  This UDF
lends its self very well for adding required fields and "add / edit" admin
pages..




value="#smartvarText(variables.var)#" size="35"
maxlength="255" > 



All of the outputs are and the cfset out side of the input tag to keep Dream
weaver (users) happy.



UDF:


function smartvarText(var1) {

  if (IsDefined("form.#var1#"))

  { return #form[var1]#;

  }

else if(IsDefined(queryname &'.'& var1))

{ return Evaluate(queryname &'.'& var1);

}

return "";

}







Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 10:46 AM
To: CF-Talk
Subject: RE: CFIF within input



  _  

From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 11:34 AM
To: CF-Talk
Subject: RE: CFIF within input

Tony,

When I try this I get this error:
Parameter 1 of function IsDefined which is now "text" must be a
syntactically valid variable name 

RO

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:32 AM
To: CF-Talk
Subject: RE: CFIF within input

but at the same time...i would...


  
value="#trim(side_1_comments)#" maxlength="100">

  


just to double check, and its more read-able :)

hth
tony

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 11:28 AM
To: CF-Talk
Subject: RE: CFIF within input

ur missing a ">"


trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#">

try that.

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:21 AM
To: CF-Talk
Subject: CFIF within input

I want to display text in a input box's value field if there is any info in
the database. The code I'm trying is:


trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#">

But I get an error. It seems simple, but I must be missing something I can't
see. 

Any suggestion please? Thanks.

Robert O.
HWW 
  _

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Managment

2004-04-02 Thread Mark W. Breneman
My $.02.

I would use servers alive, then use CFhttp to get the data from Servers
alive status webpage to build a pretty CF page.

Advice is sometimes worth what you pay for it.. :-)

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tipton, Joshua [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 02, 2004 9:27 AM
To: CF-Talk
Subject: RE: Managment

This is true but I am wanting to do it as a cf page so that the results can
be displayed on a web page in a nice way.

Josh

  _  

From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Friday, April 02, 2004 10:18 AM
To: CF-Talk
Subject: RE: Managment

Well, I am sure there are loads of DLL's which do that (not specific for CF
and probably reside with Windows already)

   _  

From: Joshua Tipton [mailto:[EMAIL PROTECTED] 
Sent: 02 April 2004 15:20
To: CF-Talk
Subject: Managment

Does anyone know of a component or dll built for cf that would allow one to
monitor services on network servers? 
   _

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: I really don't know why I care anymore...

2004-03-16 Thread Mark W. Breneman
After running the updater is the only time I have been able to get the
snippet shortcuts to work in DWMX04.  I too found that all of my keyboard
shortcuts were missing. Then I found that DW had defaulted back to the
standard shortcuts.  I found my set still in DW just not selected.  Now I am
as happy as a clam.  

I still miss several things that CFS did for me.

MB

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 16, 2004 2:13 PM
To: CF-Talk
Subject: I really don't know why I care anymore...

I just ran the glorious updater for DWMX 2K4 and I lost all my precious
snippet shortcuts...arrr!

All I have to say at this point is that the DWMX developers better have some
good solid code lined up in this updater and in the next release or I am
jumping ship and never, ever, ever, ever looking back.
-Testy in Tampa

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Website hijacking

2004-03-09 Thread Mark W. Breneman
You may want to check to see if some how a proxy server is being used on
your PC.  Go to "Internet Properties" in your control Panel and click on the
"Connections" tab then click the "LAN Settings." button.  And make sure
everything is unchecked.  (I am assuming you are using some form of router
to access the internet.)

OR

You can go to "Internet Properties" in your control Panel and click on the
"Connections" tab then click the "Setup." Button and answer the questions
the wizard asks.

Setting up a proxy server is a sneaky trick that some spy ware may try to
track your browsing.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 09, 2004 12:23 PM
To: CF-Talk
Subject: OT: Website hijacking

Got a question. I just noticed that when I bring up a browser and type.
www.houseoffusion.com in the address bar and submit. It first goes to
http://list2004.com/p/www.houseoffusion.com before going to
http://www.houseoffusion.com Does anyone know how to get rid of this? I can
not find it on my PC at all.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SQL custom Order by

2004-03-09 Thread Mark W. Breneman
I doubt this is possible, but is there a way to do a custom order by based
on the order I provide?  I need the SQL results to be in a specific order
based on the "catID", but not in ascending or descending order. The order
that I want them in is 10,3,5,1,7,4,9,2,6,8.

Example

Select *

>From table

Order by catID values(10,3,5,1,7,4,9,2,6,8)

I am using MS SQL 2000.

Thanks for the help.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT:CF 6.1 files and DW MX 2004 - anyone see this before

2004-03-08 Thread Mark W. Breneman
I just saw something that is very scary..

One of my co-workers just installed upgraded from DW MX to DW MX 2004. Then
he opened a file named home.cfm for one client and left the file open most
of the day.  Then later, he opened a file named home.cfm for a different
client.  When he opened the first home.cfm file in a text editor he got the
contents of the second home.cfm file.  The odd thing is that the file had
been "rendered" by CF and saved.  It looked just like someone had opened the
file in a browser and clicked save.  I know no one in the office would have
done that.  There are only three of us in the office today.  All of us know
way better then to do that.  

I rebooted the server after checking it out to make sure it was in good
running order.  So far so good.

Anyone ever see anything like this before?  

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINSERT on CFMX (newbe question)

2004-02-24 Thread Mark W. Breneman
Jochem van Dieten said:

"It should not be that hard to write your own cfinsert and cfupdate if
you ever feel the need to abandon them."

Yes, I have started several times to plan out just what my Cfupdate any
Cfinsert would do based on how we use it, but then I realize that 98% of
that is already done by the current Cfupdate and Cfinsert. 



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 24, 2004 10:26 AM
To: CF-Talk
Subject: RE: CFINSERT on CFMX (newbe question)

Mark W. Breneman said:
> Will that fieldname "date" come back to bite him later?

It will probably continue to cause inconvenience, but nothing major.

It is just not something you would want a prospective employer to see.

> Ha, It must be the masochist in me but I still use Cfupdate and
> insert even after CFMX issues and 5+ years of CF programming. Go
> figure..

It should not be that hard to write your own cfinsert and cfupdate if
you ever feel the need to abandon them.

Jochem

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINSERT on CFMX (newbe question)

2004-02-24 Thread Mark W. Breneman
Will that fieldname "date" come back to bite him later?  Seems like I
changed a database or two due to other issues related to using the field
name "date".  Can't remember right now.. Maybe it was just to not use
the reserved word..

Thoughts???

Yes using a real SQL statement is the better way to go then to use
Cfinsert or Cfupdate. 

Ha, It must be the masochist in me but I still use Cfupdate and insert
even after CFMX issues and 5+ years of CF programming. Go figure..



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 24, 2004 10:05 AM
To: CF-Talk
Subject: RE: CFINSERT on CFMX (newbe question)

> From: Mark W. Breneman
> 
> I believe that "date" is reserved keyword. Try changing that 
> field name.

Or switch to CFQUERY and put square brackets around the field names

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINSERT on CFMX (newbe question)

2004-02-24 Thread Mark W. Breneman
I believe that "date" is reserved keyword. Try changing that field name.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Steven Sharko [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 24, 2004 9:46 AM
To: CF-Talk
Subject: RE: CFINSERT on CFMX (newbe question)

Error Occurred While Processing Request

Error Executing Database Query.

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft 
Access Driver] Syntax error in INSERT INTO statement.

The error occurred in D:\websites\clients.cfm: line 34

32 :
tablename="clients">
33 :
34 :
tablename="clients">
35 :
36 :    

SQL   insert into clients (COMPANY,DATE) values ( (param 1) , (param 2)
)
DATASOURCE   devchat
VENDORERRORCODE   -3502
SQLSTATE   42000
Please try the following:

At 10:36 AM 2/24/2004, you wrote:
>Marlon Moyer said:
> > Has anyone else noticed how handy cfinsert would be if you could get
> > the inserted identity back?
>
>That might be a future possibility once we move to JDBC 3:
>http://www.macromedia.com/go/wish/
>
>Jochem
>
>--
>[

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINSERT on CFMX (newbe question)

2004-02-24 Thread Mark W. Breneman
Can you give us a code example?  I can think of lots of reasons.  

Is one of your field names a reserved keyword?  Like "date"?

Are your field names named like "Address", "Address2", "Address3"?   See
http://www.macromedia.com/support/coldfusion/ts/documents/cfinsert_hotfi
x.htm

.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Steven Sharko [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 24, 2004 9:13 AM
To: CF-Talk
Subject: CFINSERT on CFMX (newbe question)

I took an old application that seemed to work fine in CF5 but now on
CFMX I 
get errors with all my cfinsert, Why?  Is there a quick fix? Do I have
to 
edit all of them one by one?



  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question regarding CFMX 6.2

2004-02-23 Thread Mark W. Breneman
I have been a part of the last two CF server beta programs but, I was
way to busy to do any real testing.  Unfortunately I found several issue
after CFMX 6.0 and 6.1 had been officially released.  One such issue
caused us to have to tweak a line of code or two for almost all of our
clients.

So this time I plan to be very active in the beta.

Has there been an official beta program set up for black stone?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: David Delbridge [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 23, 2004 3:22 PM
To: CF-Talk
Subject: Re: Question regarding CFMX 6.2

> I should maybe get in that program and see if I can get some of these
> issues addressed, if they have not been yet.

An excellent idea, though participation isn't guaranteed.  I had to 
raise a fuss in order to get in on the MX beta, despite being a 
Macromedia Partner and having participated in previous betas.  [?!]

That said, there is NO BETTER way to affect positive change than to 
participate in the beta.  If you really, really want to see a particular

component of CF working perfectly -- as I did with Advanced Security -- 
this is your opportunity to throw everything at it you can and see 
Macromedia trip over themselves to provide prompt fixes.  It's a truly 
wonderful thing to behold.

I hope to see you there!

Dave

-- 

David M. Delbridge
Circa 3000
ColdFusion Hosting
http://www.circa3k.com
866-CIRCA3K (247-2235)
Outside U.S: +1.775-832-2445

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question regarding CFMX 6.2

2004-02-23 Thread Mark W. Breneman
No planned maintenance release anytime soon?

Sigh, that is too bad, I was hoping some of the minor "issues" would be
addressed in CFMX 6.1 soon.  But, more than likely this issues that bug
me and my clients are minor enough and affect only a few people I can
understand how they be temporarily ignored.  

Has black stone entered Beta testing yet?  I should maybe get in that
program and see if I can get some of these issues addressed, if they
have not been yet.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 23, 2004 11:57 AM
To: CF-Talk
Subject: RE: Question regarding CFMX 6.2

Right now we are aggressively working on Blackstone. That is not to say
that
there'll not be a release between now and then, but I am unaware of any
planned maintenance release at this point. If one becomes critical and
necessary, then I am sure that one will be released (if hot fixes are
not an
option).

--- Ben

  _  

From: Kola Oyedeji [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 23, 2004 12:50 PM
To: CF-Talk
Subject: RE: Question regarding CFMX 6.2

Ben

Correct me if I'm wrong but aren't there still bugs and known issues
with 6.1. Are you suggesting that there are no immediate plans to
address these?

Thanks

Kola

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: 23 February 2004 16:29
To: CF-Talk
Subject: RE: Question regarding CFMX 6.2

CFMX 6.2? I don't believe that version numbers and editions have been
discussed at all, actually.

Generally, maintenance releases have been free upgrades (as 6.1 was)
whereas
full product releases have been paid upgrades (and included in
subscriptions, of course).

The next planned version of ColdFusion is codenamed "Blackstone", and
version numbers, pricing, etc., have yet to be discussed at all.

But, and this is my own opinion here, I doubt that there will be another
maintenance release for CFMX any time soon. CFMX needed updates, which
is
why we released service packs and then v6.1, But 6.1 has proven to be
reliable and solid and arguably one of the best ColdFusion's ever, and
so a
maintenance release is unlikely.

Bottom line, use 6.1 now, and stay tuned for announcements from MM.

--- Ben

  _  

From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 23, 2004 11:16 AM
To: CF-Talk
Subject: RE: Question regarding CFMX 6.2

I am wondering, will CF 6.2 be a free upgrade from 6.1 or will MM want
us to
pay for it? And if $$$ is involved, how much?

TK
  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 23, 2004 10:21 AM
  To: CF-Talk
  Subject: Re: Question regarding CFMX 6.2

  On Monday 23 Feb 2004 09:21 am, Jochem van Dieten wrote:
  > Macromedia is thinking about:
  > http://mxeurope.org/go/objectid/CAAA4C2A-50DA-4D01-876C3488A0F5D98A

  "simpler ways to create compelling UIs, "
  Does that sound like shiping some sort of cut-down Flex to anyone else
?
In
  the same way they implemented cfchart by shipping a cut down version
of
their
  own stand alone graphing app ?

  "Increasing productivity"
  Could be anything !

  "new ways for deploying your apps"
  As MX is a J2EE system, I hope that means jar/ear/war type stuff :-)

  "source code protection."
  Intresting. Just a better front end to cfencrypt, or something more
  industrial ?

  When is pricing etc. info for MAXEurpoe going to be announced ? Is
there
an
  annoucements mailing list for it yet ?

  --
  Tom Chiverton
  Advanced ColdFusion Programmer

  Tel: +44(0)1749 834997
  email: [EMAIL PROTECTED]
  BlueFinger Limited
  Underwood Business Park
  Wookey Hole Road, WELLS. BA5 1AF
  Tel: +44 (0)1749 834900
  Fax: +44 (0)1749 834901
  web: www.bluefinger.com
  Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
  Quay, BRISTOL. BS1 6EG.
  *** This E-mail contains confidential information for the addressee
  only. If you are not the intended recipient, please notify us
  immediately. You should not use, disclose, distribute or copy this
  communication if received in error. No binding contract will result
from
  this e-mail until such time as a written document is signed on behalf
of
  the company. BlueFinger Limited cannot accept responsibility for the
  completeness or accuracy of this message as it has been transmitted
over
  public networks.*** 
  _
  _ 
  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: DW2004 Snippet madness

2004-02-18 Thread Mark W. Breneman
Yes, you are correct.  I am simply using the # snippet as an example.  I
have other snippets, more complex, that I need to be able to use. 

But, for now I am doing just what you suggested.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 18, 2004 12:31 PM
To: CF-Talk
Subject: Re: DW2004 Snippet madness

"Let me rephrase my problem, I can assign a keyboard shortcut to a
snippet, via the shortcuts GUI, but I have yet to get one to work.  When
I use the shortcuts GUI I am trying to assign Ctrl+3 to a snippet that
will wrap the selected text in #s."

I'm not sure why you're doing this.

You can just reassign the Ctrl-3 keyboard shortcut to override the
current
Ctrl-3 which is H3. I've been doing this in DWMX and DWMX2004 for ages.

You don't have to remap it to a snippet, you can just change what it's
currently mapped to by creating a duplicate keyboard shortcut set, then
changing it to your heart's content.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: DW2004 Snippet madness

2004-02-18 Thread Mark W. Breneman
I wish it was that easy. :-)  I assume by your responses that this issue
may be related to my PC although my laptop seems to do the same thing.

Let me rephrase my problem, I can assign a keyboard shortcut to a
snippet, via the shortcuts GUI, but I have yet to get one to work.  When
I use the shortcuts GUI I am trying to assign Ctrl+3 to a snippet that
will wrap the selected text in #s. After I assign Ctrl+3 to my snippet,
I can see that Ctrl+3 looks like it has been correctly assigned to the
snippet but, after I close the shortcuts GUI the shortcut does not work
and when I open the shortcuts GUI, Ctrl+3 defaults back to H3.  I have
no problem assigning Ctrl+3 to another command like "select all", the
problem only comes in when I try to assign it to a snippet.  

Is it possible that I had a bad previous install of DW MX (non 2004)?  I
have tried uninstalling all DWs and only reinstalling MX2004 but, I seem
to have the same problem

Thank for the help.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 18, 2004 11:17 AM
To: CF-Talk
Subject: Re: DW2004 Snippet madness

> I have the trial of DW MX 2004 installed and I can not assign any
> snippets to keyboard shortcuts.  I need these short cuts or else DW is
> useless to me. Yes, I have duplicated the "MM Standard set" and I can
> assign other types of commands to keyboard short cuts, just not
> snippets.

Select "Snippets" from the "Commands" drop-down inside the Keyboard
shortcuts GUI.

> Also where does DW store the user snippets?  I would have expected it
to
> store them in the Configuration\Snippets but only the default ones are
> in there.  Is it possible to edit the keyboard short cut config file
> directly?  If so where is that stored?

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


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: DW2004 Snippet madness

2004-02-18 Thread Mark W. Breneman
First off sorry for the off topic, but this is driving me mad and I know
some out there will have the answer.  

I mostly hate dream weaver, but I am trying to give it a fair try. 

I have the trial of DW MX 2004 installed and I can not assign any
snippets to keyboard shortcuts.  I need these short cuts or else DW is
useless to me. Yes, I have duplicated the "MM Standard set" and I can
assign other types of commands to keyboard short cuts, just not
snippets. 

Any ideas?

Also where does DW store the user snippets?  I would have expected it to
store them in the Configuration\Snippets but only the default ones are
in there.  Is it possible to edit the keyboard short cut config file
directly?  If so where is that stored?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX looking for disk in A: Drive when RDSing???

2004-02-06 Thread Mark W. Breneman
CFfile. interesting.  

Is this a problem everyone is having?  This client's server is the only
one that I have seen this problem with.

Can you clarify "next release"?  Are we talking Black stone or something
like CFMX 6.2?

Does anyone know of any un-official work arounds for this?  Is there any
way to direct RDS to not look at the A drive? Or anyway to make the root
of the RDS server the "D:" drive?

Thank you so much for this info, Christine.  



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
  608.270.9770

-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 4:27 PM
To: CF-Talk
Subject: RE: CFMX looking for disk in A: Drive when RDSing???

Hi Mark,

Using ftp has been the workaround, maybe you could use cffile?  It's not
on
our list of known issues as we don't have every bug published there.
I've
added your vote to our bugtracking system for a fix, it is currently
targeted for the next release.

Best Regards,

Christine

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 3:29 PM
To: CF-Talk
Subject: RE: CFMX looking for disk in A: Drive when RDSing???

Thanks for the info

FTP is not an option in this case.  This client will not open up the
firewall for anything other than POP SMTP, HTTP and HTTPS.  Any chance
there is a tweak for this or a hot fix in the works?  The other option
is for me to email the files and wait for the IT person to get around to
putting them on the server.

Is 49148 an official known issue number?  I am not able to find it on
the MM website, Forums or google.

Thanks Christine!

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
  608.270.9770

-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 1:56 PM
To: CF-Talk
Subject: RE: CFMX looking for disk in A: Drive when RDSing???

This is bug 49148, I'd suggest you use ftp instead and disable RDS per
our
documentation:
http://livedocs.macromedia.com/coldfusion/6/Installing_ColdFusion_MX/con

n> 
figu
ring6.htm

nfig
uring6.htm> 

Best Regards,

Lawson

Macromedia Technical Support 

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 1:27 PM
To: CF-Talk
Subject: CFMX looking for disk in A: Drive when RDSing???

Hey All,

We have a client, that just upgraded to CFMX, that claims that every
time we connect to their CFMX 6.1 server with RDS, a message pops with
an error message something like "Jrun.exe Error:  No disk in Drive A:".
Needless to say this makes the client really nervous. (Especially when
they think RDS is some form of magic anyway ;-)

Has anyone seen anything like this?  It seems that I can not make a RDS
connection until the client dismisses the error.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _

  _

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX looking for disk in A: Drive when RDSing???

2004-02-06 Thread Mark W. Breneman
Thanks for the info

FTP is not an option in this case.  This client will not open up the
firewall for anything other than POP SMTP, HTTP and HTTPS.  Any chance
there is a tweak for this or a hot fix in the works?  The other option
is for me to email the files and wait for the IT person to get around to
putting them on the server.

Is 49148 an official known issue number?  I am not able to find it on
the MM website, Forums or google.

Thanks Christine!

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
  608.270.9770

-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 1:56 PM
To: CF-Talk
Subject: RE: CFMX looking for disk in A: Drive when RDSing???

This is bug 49148, I'd suggest you use ftp instead and disable RDS per
our
documentation:
http://livedocs.macromedia.com/coldfusion/6/Installing_ColdFusion_MX/con
figu
ring6.htm

nfig
uring6.htm> 

Best Regards,

 Lawson

Macromedia Technical Support 

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 1:27 PM
To: CF-Talk
Subject: CFMX looking for disk in A: Drive when RDSing???

Hey All,

We have a client, that just upgraded to CFMX, that claims that every
time we connect to their CFMX 6.1 server with RDS, a message pops with
an error message something like "Jrun.exe Error:  No disk in Drive A:".
Needless to say this makes the client really nervous. (Especially when
they think RDS is some form of magic anyway ;-)

Has anyone seen anything like this?  It seems that I can not make a RDS
connection until the client dismisses the error.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX looking for disk in A: Drive when RDSing???

2004-02-06 Thread Mark W. Breneman
Hey All,

We have a client, that just upgraded to CFMX, that claims that every
time we connect to their CFMX 6.1 server with RDS, a message pops with
an error message something like "Jrun.exe Error:  No disk in Drive A:".
Needless to say this makes the client really nervous. (Especially when
they think RDS is some form of magic anyway ;-)

Has anyone seen anything like this?  It seems that I can not make a RDS
connection until the client dismisses the error.

Thanks



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Import snippets into Dreamweaver MX 2004?

2004-02-05 Thread Mark W. Breneman
Ok, I feel dumb. It worked. I could have sworn that I tried the exact
same thing and it failed the first time.

Thanks Massimo!

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 9:44 AM
To: CF-Talk
Subject: Re: Import snippets into Dreamweaver MX 2004?

> when i make a snippet i just make it in homesite and save it and when
i
> open up dwmx there it is. so i'd assume u can do the same

HS 5.5 stores snippets using the same XML based format used by DW.

In order to convert snippets from older versions of Homesite/CF Studio
you
can use:

http://www.dwfaq.com/Snippets/converter.asp


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Import snippets into Dreamweaver MX 2004?

2004-02-05 Thread Mark W. Breneman
Is there any way to import snippets from Coldfusion Studio 5 into of
Dreamweaver MX 2004?  Looks like Massimo Foti awesome snippet converter
only works for MX and not 2004.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RDS looking for disk in A: Drive???

2004-02-04 Thread Mark W. Breneman
Hey All,

I have a client, that just upgraded to CFMX, that claims that every time
we connect to their CFMX 6.1 server with RDS, a message pops with an
error message something like "Jrun.exe Error:  No disk in Drive A:".
Has anyone seen anything like this?  It seems that I can not make a RDS
connection until the client dismisses the error.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: flusing the trusted cache

2003-12-23 Thread Mark W. Breneman
I was going to ask this a MAX but never got to.  Is there anyway to send
a command (java? or other ) to flush the trusted cache?  If not can that
be a new feature of black stone?  I have several times that I would love
to turn on trusted cache but, I can't reset the server to make updates.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 23, 2003 2:51 PM
To: CF-Talk
Subject: RE: flusing the trusted cache

Have to cycle the server.  That's the point of the trusted cache, it
never
has to hit the filesystem except on startup.

barneyb 

> -Original Message-
> From: walker [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, December 23, 2003 12:44 PM
> To: CF-Talk
> Subject: flusing the trusted cache
> 
> We just turned on the "trusted cache" in the cf administrator 
> (CF5.0 on 
> Solaris), and now I can't seem to flush it when small changes 
> are made. The 
> old pages still show.
> 
> Anyone got any tricks for cleaning the trusted cache out?
> 
> thanks in advance.
> 
> 
> 
> 
> _
> walker fenton
> [EMAIL PROTECTED]
> 303.722.5473 
> 
> 
>

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT - Scsi hd

2003-11-12 Thread Mark W. Breneman
Robert,

Do you have the driver disk (probably a floppy) that came with the
Adaptec card?  I am thinking that you will need to specify an additional
driver for the Adaptec card when you do the windows 2000 install.  (Hit
F6 during the install when it tells you to.)

I seem to remember a server of mine momentary, when doing an install,
flashing to a BSOD (Blue Screen Of Death), then rebooting, if I did not
load the driver for my Adaptec card.



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 12, 2003 3:03 PM
To: CF-Talk
Subject: OT - Scsi hd

Sorry this is OT, but it's only one of the few times I've asked.

I need to upgrade my server running CF. I have SCSI HD's and an Adaptec
Array adapter. I installed the new HD and then one of the older larger
HD's which I will put the OS (windows 200) on it. I setup the cd-rom as
the boot and put the 2000 cd in it. However, the system boots,
recognizes the HDs, the light comes on the cd but it then reboots and
does not start the Server 2000 setup.

Did I explain enough or is there more to this than meets the eye?

Thanks as always and excuse the OT on this please.

Robert Orlini
HW Wilson
718-588-8400 x2656
ô¿ô

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Win 2003 SBS

2003-11-04 Thread Mark W. Breneman
Dan what is considered "Loaded with RAM" in the context of a server with
Win, CF and SQL?





Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 04, 2003 10:58 AM
To: CF-Talk
Subject: RE: Win 2003 SBS

We have a few clients running dedicated servers with this setup. No
problems to report so far (that they have made me aware of anyway).
Careful running Win, CF, and SQL on the same box though. Load it up with
RAM and keep an eye on traffic. 

Dan Phillips
www.CFXHosting.com 
1-866-239-4678 x105
[EMAIL PROTECTED]

-Original Message-
From: Jeffrey Pratte [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 04, 2003 10:46 AM
To: CF-Talk
Subject: Win 2003 SBS

I am buying a new box to use as a Cold Fusion server. I was thinking
about buying the Microsoft Windows Small Business Server 2003 premium
edition ($1499), since it comes with Win 2003, and SQL Server. Does
anyone have experience with this? Is it a good choice?

Thanks, jeff

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: REPOST: CFMX and variables available on error

2003-10-31 Thread Mark W. Breneman
On the same note, I am looking to beef up my error handlers.  In an
effort to cut my trouble shooting time, is there anyway to get a list
and SQL code for all queries ran, session vars, form vars, etc from the
page that threw the error?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 31, 2003 11:08 AM
To: CF-Talk
Subject: RE: REPOST: CFMX and varaiables available on error

> Thanks Dave...but what should I dump?? ;-)

Dump the Error or CFCATCH scope.

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

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: How To Force Landscape Oriented Printing

2003-10-28 Thread Mark W. Breneman
Hey, I got a client clamoring for that too.  The client claims that they
have seen it done.  The only way I found to do it was with an active X
control.  Active X would not be a good solution for this client due to
the wide diversity of browsers that visit the site that do not support
active x.



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Kumar, Senthil [CC] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 28, 2003 2:38 PM
To: CF-Talk
Subject: How To Force Landscape Oriented Printing

Not Exactly CF Talk - MayBe HTML Talk or CSS Talk.

How would I force a Report to be printed always in
a landscape format.

The following code, did not work.





 New Document 

<br>
<br>
@media print{<br>
<br>
BODY {<br>
<br>
Size: landscape;<br>
<br>
}<br>
<br>
}<br>
<br>






hi






  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX 6.1 Session problems - help

2003-10-27 Thread Mark W. Breneman
Ok, from what I am hearing, it seems that my code may be the problem,
not the session ID "jumping" problem.  Is that Correct? 

Can anyone confirm that they have no problems with session vars in CFMX?

I will be very happy if it is just my code.  That is something I can
fix.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 27, 2003 12:41 PM
To: CF-Talk
Subject: RE: CFMX 6.1 Session problems - help

> Don't CFLOGIN and CFLOGOUT also rely on session vars to track 
> the user?
> 

Not by default. You can turn it on using loginStorage="session" in the
cfapplication tag, but only using MX 6.1.


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX 6.1 Session problems - help

2003-10-27 Thread Mark W. Breneman
Nope, I am not using URL vars for session storage. 

Don't CFLOGIN and CFLOGOUT also rely on session vars to track the user?

MB

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 27, 2003 10:58 AM
To: CF-Talk
Subject: RE: CFMX 6.1 Session problems - help

I thought CFMX fix the session "jumping" problems that CF 5 had and thus
did away with the need to lock session vars, other then in race
conditions.   Is this true?  Is it possible that locking causes a
problem if CFMX?

[Tom Kitta]

As far as Macromedia is disclosing, there is no need for shared variable
locking if no race conditions are to occur. If you don't lock you shared
variables no memory corruption will occur in CFMX and above. However,
you
still need to lock if race conditions might occur. There is a tech note
about that on MM site which I have read a while ago.

As for users seeing each other's sessions - do you maybe use url
variables
for session storage? It was and is a common problem in session sharing.

Other than that, consider using security based solely on CF model
without
any session.userID stuff. In other words use CFLOGIN and CFLOGOUT.

TK

Thoughts?



  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Query-past protection?

2003-10-27 Thread Mark W. Breneman
I guess I sorta see it as fixing an inconsistency.  

If you run a query like this in CF 5:


Select name

from table

where 0=1



(This query will not return a record set)

And then try outputting the value of name:

#getname.name#

You do not get an error.

But if you tried to output :

#getname.name[1]#

You would get an error in CF 5.

Now in CFMX they both work the same.

But, yes this should be documented.



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 27, 2003 11:40 AM
To: CF-Talk
Subject: Re: Query-past protection?

If its a feature rather than an oversight then it should be clearly
notes. I
expected an error and when I didn't get it, I was concerned. Don't get
me
wrong, it's nice but it worries me when an expected error based on code
logic does not exist.
If it is a feature, I wonder how many other 'anti-error' features have
been
included.

> Michael,
>
>
>
> I think this is an "improvement" in CFMX.  I know in CF 5 if you try
to
> access a query element that does not exist, you would get an error.
> But, in CFMX it seems to gracefully handle this.
>
>
>
> Can anyone confirm this?
>
>
>
> MB
>
>
>
> Mark W. Breneman
> -Cold Fusion Developer
> -Network Administrator
>   Vivid Media
>   [EMAIL PROTECTED]
>   www.vividmedia.com
>   608.270.9770
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 27, 2003 11:13 AM
> To: CF-Talk
> Subject: Query-past protection?
>
>
>
> OK, here's a strange one that I need others to test out. Run a query,
> then
> try to access an element past the amount in the query.
> 
> select top 1 columnname from table
> 
> #queryname.columnname[1000]#
> What should happen is an error message saying your trying to access a
> query
> element outside the range of the query results. What I'm getting is a
> blank
> value. If others get the same thing then it's an interesting 'feature'
> that
> should be noted, despite it being technically wrong.
>
>
>
>   _
>
>
> 

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Query-past protection?

2003-10-27 Thread Mark W. Breneman
Michael,

I think this is an "improvement" in CFMX.  I know in CF 5 if you try to
access a query element that does not exist, you would get an error.
But, in CFMX it seems to gracefully handle this.  

Can anyone confirm this?

MB

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 27, 2003 11:13 AM
To: CF-Talk
Subject: Query-past protection?

OK, here's a strange one that I need others to test out. Run a query,
then
try to access an element past the amount in the query.

select top 1 columnname from table

#queryname.columnname[1000]#
What should happen is an error message saying your trying to access a
query
element outside the range of the query results. What I'm getting is a
blank
value. If others get the same thing then it's an interesting 'feature'
that
should be noted, despite it being technically wrong.

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX 6.1 Session problems - help

2003-10-27 Thread Mark W. Breneman
I have a site that seems to have problems with confusing users with each
other. This only happens to about 1% or less of the users.  A user will
sign in and the person next to them will sign in and they may get each
others data.  The site uses session.userid as the identifier. The only
place session.userid is set is on the login page. After the
session.userid is set the user is then forwarded to the main page.  This
site was written for CF 5 so it does have lock tags around all writes to
session vars.  I don't think all of the reads are locked any more.  I
have made changes to some of the code since upgrading to CFMX

I thought CFMX fix the session "jumping" problems that CF 5 had and thus
did away with the need to lock session vars, other then in race
conditions.   Is this true?  Is it possible that locking causes a
problem if CFMX?

Thoughts?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Credit Card processing- Address Verification (AVS) w/ Verisign

2003-10-23 Thread Mark W. Breneman
Hello Jann,

I am looking to maybe upgrade to cfx_payflowpro from CFX_paymentnet.
What did you have to do to get cfx_payflowpro to work with CFMX? Are you
using MX?  The instructions I read through seemed to indicate that I
needed to replace the version of java that CF runs to use
cfx_payflowpro. Is that correct?  Looking back on when I read the
instructions, that may have been the instructions to installing
cfx_payflowpro for CF 5.

Can you shed some light on this?



Thanks



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: J E VanOver [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 23, 2003 11:27 AM
To: CF-Talk
Subject: Credit Card processing- Address Verification (AVS) w/ Verisign

Repost with subject heading changed -- I'll have to implement something
today whether I get advice or not -- I'll do option 4) unless I get
better
advice.  I have asked VeriSign customer service the same question and if
anyone else is interested will pass on their advice.
---
Here's the original question:
I'm doing my first DEEP foray into Verisign and credit card processing -
maintaining an existing system. Already working well with cfx_payflowpro
(VERY easy to use, btw).

I'm adding AVS (Address Verification) and want to know how others are
handling it.

To use AVS, you must either:

1) request authorization (A), and then, if it's good, Capture (D) the
charge, if it's not good, Void(V) the charge.  But VSign doesn't let you
void an Authorization  so you have to Capture it anyway before voiding.

2) Same as #1, but Credit (C) instead of Void (V).  Apparently, this
releases the funds within 48 hours where a Void may take up to 30 days
to
release the funds.  But a Credit (C) shows up on the customer's credit
card
statement.

3) Request Sale (S), then if it's good, do nothing.  If it's not good,
request Void (V).  ?? Would this Void show up on customer's statement?

4) Same as #3, but Credit (C) instead of Void (V). With a Credit (C)
shows
up on the customer's credit card statement.

PLEASE let me know what YOU are doing in similar situations!

Thanks
Jann

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFX_PAYMENTNET and verisign Problems?

2003-10-21 Thread Mark W. Breneman
Is there anyone out there using CFX_PAYMENTNET and verisign having
problems in the last 12 hours when attempting to charge cards?

All transaction seem to get and result code of
RESULT=-9&RESPMSG=SSL_Read() incorrect length received.  The error
relates to a SSL comm. failure.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Antivirus software on web server

2003-10-16 Thread Mark W. Breneman
Dave, as always, true.

Maybe I should be asking if there is worm scanning software out there
that has auto-up-dating worm defs.  And maybe I should do my homework
and 2x check that Norton Anti Virus does scan and prevent worms from
infecting a computer.

Thanks  

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 11:38 AM
To: CF-Talk
Subject: RE: Antivirus software on web server

> The question was brought up, that how would you ever know 
> if your server was infected without some software scanning.  
> My argument to that was if the server is correctly secured 
> that should never be an issue, but, with new exploits being 
> discovered each month the chances go up that the server 
> could be compromised before the patch is applied. 

If you're concerned about server exploits, a virus scanner probably
isn't
going to help you very much, if at all. You're much better off using a
host-based firewall to limit inbound and outbound traffic appropriately,
and
use something wherever possible to examine that traffic (stateful packet
inspection at your host-based firewall, or a web server input filter,
for
example).

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

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Antivirus software on web server

2003-10-16 Thread Mark W. Breneman
Adam,

If I install NAV, I'll be glad to post back to the list the results.

I am not planning on running scheduled system scans. I am not too
worried about file based viruses (boot sector, Trojan or email/scr),
what I am hoping to prevent is worms that prey on security holes like
slammer, blaster or Code Red.  

I am 99% sure that my servers are secure, my software firewall and
hardware firewall are configed correctly and all relevant patches are
applied, but if I miss one, I could spend my weekend rebuilding a
server. 

It would be nice if there was a web server version of NAV.  Or something
that is ultra light on CPU time and system resources.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 10:50 AM
To: CF-Talk
Subject: RE: Antivirus software on web server

Mark,

Once get your anti-virus software installed and running on you web
server, would you mind sharing with the list what kind of performance
impact it creates. Are you planning to run scheduled system scans?

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 11:45 AM
To: CF-Talk
Subject: RE: Antivirus software on web server

True it probably would show in the task or process lists, but if I were
to write a worm/Trojan, I would make it show up in the task list as
SVCHOST.exe, the generic name of a DLL process.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 9:41 AM
To: CF-Talk
Subject: Re: Antivirus software on web server

Mark W. Breneman wrote:
> 
> As much as I am opposed to the idea, I am leaning towards installing
> Norton Antivirus Corporate on all of my web servers.  
> 
> The question was brought up, that how would you ever know if your
server
> was infected without some software scanning.

You see it in the task list. And if it does anything besides 
being there (like trying to spread), you see that in your network 
traffic.

Jochem

  _  

  _  


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Antivirus software on web server

2003-10-16 Thread Mark W. Breneman
Hey that is kinda handy.  tlist  I learn something each day.  (Now that
I have learned it, too bad I can't go back to bed :-)



Thanks!



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 10:45 AM
To: CF-Talk
Subject: Re: Antivirus software on web server

Mark W. Breneman wrote:
> True it probably would show in the task or process lists, but if I
were
> to write a worm/Trojan, I would make it show up in the task list as
> SVCHOST.exe, the generic name of a DLL process.

1. You know how many of those you have on your server.
2. tlist will show the application names behind svchost.exe

Jochem


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Antivirus software on web server

2003-10-16 Thread Mark W. Breneman
True it probably would show in the task or process lists, but if I were
to write a worm/Trojan, I would make it show up in the task list as
SVCHOST.exe, the generic name of a DLL process.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 16, 2003 9:41 AM
To: CF-Talk
Subject: Re: Antivirus software on web server

Mark W. Breneman wrote:
> 
> As much as I am opposed to the idea, I am leaning towards installing
> Norton Antivirus Corporate on all of my web servers.  
> 
> The question was brought up, that how would you ever know if your
server
> was infected without some software scanning.

You see it in the task list. And if it does anything besides 
being there (like trying to spread), you see that in your network 
traffic.

Jochem


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Antivirus software on web server

2003-10-16 Thread Mark W. Breneman
Thanks everyone….

As much as I am opposed to the idea, I am leaning towards installing
Norton Antivirus Corporate on all of my web servers.  

The question was brought up, that how would you ever know if your server
was infected without some software scanning.  My argument to that was if
the server is correctly secured that should never be an issue, but, with
new exploits being discovered each month the chances go up that the
server could be compromised before the patch is applied. 

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
-Original Message-
From: NATHAN C. SMITH [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 15, 2003 4:44 PM
To: CF-Talk
Subject: RE: Antivirus software on web server

I think it is a necessary evil.

People are finding too many neat ways for things to creep across
networks.

-Nate
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 12:23 PM
To: CF-Talk
Subject: SOT: Antivirus software on web server

I can remember this topic has been hashed over a few different times
here, over the years.  Has the opinions changed over the last year or
so?

Do YOU have antivirus software on your servers?  

Do you recommend it on web servers?  

If so, what software?

I have in the past been on the side of not needing AV software on the
server. Now I am, and have been for a few months, sitting on the fence.
A few years ago, as a computer tech, I said that AV software is very
good to have at home / office but not nessicry. Now, I highly recommend
AV software on any computer that is connected to the net in the home /
office environment.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
[EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CF controlled security for downloading doc xls etc. files.

2003-10-15 Thread Mark W. Breneman
We are about to start working on a feature for a client that would allow
a user that is logged in to down one several different types of files.
The idea is to have CF list the files that the user has access to and be
able to download them by clicking on the link.  The one trick it that
these files should not be accessible to anyone else even if they have
the path to where the file is. 

I just thought I would ask the lists' wisdom on these two ideas:

One idea was to use cffile and cfcontent to force a download.  Has
anyone tried this?  I can see it working for txt files but what about
pdf and zip files?

Idea two was to have CF make a folder name based on a UUID (universal
unique ID) and have CF copy the file from a non shared drive to this
folder. Then delete it a few mins later.

Any thoughts / comments?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: Antivirus software on web server

2003-10-15 Thread Mark W. Breneman
I can remember this topic has been hashed over a few different times
here, over the years.  Has the opinions changed over the last year or
so?

Do YOU have antivirus software on your servers?  

Do you recommend it on web servers?  

If so, what software?

I have in the past been on the side of not needing AV software on the
server. Now I am, and have been for a few months, sitting on the fence.
A few years ago, as a computer tech, I said that AV software is very
good to have at home / office but not nessicry. Now, I highly recommend
AV software on any computer that is connected to the net in the home /
office environment.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
Thank you so much for your help.  I had assumed that there was something
wrong with my UDF coding.  Looks like it may well be a problem with the
values the UDF returns.

Thanks!!!

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 4:47 PM
To: CF-Talk
Subject: RE: Ok, I give up UDF error

Mark,

I can put TID=1 to 10 in there and it works as well (both encode and
decode).

(as query string)

Here's your specified input endocded and decoded

http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm

For me  - this works.  There must be something in that string you are
keeping from me (ha). output each character code
in the qencode function like this:

for(i=1;i lte strlen;i=i+1) {
  tempstr = Asc(Mid(tempurlvars, i, 1));
 newstr = newstr & Chr(tempstr + 3);
//writeoutput("asci code IS : " & tempstr & " and new character
looks like " & chr(tempstr + 3) & "");

   }

Then take a look at the list of characters - see if anything pops out at
you (like invisible characters for example...

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 4:14 PM
To: CF-Talk
Subject: RE: Ok, I give up UDF error

  Good theory, but.

  See my last posting where I have included both the qencode and the
  qdecode function.  The qencode may indeed wrap through the ascii code
  table but, where I am running the left function the values have
already
  been decoded (de-shifted).  All I am trying to do is to get rid of the
  random number on the end.

  The values I am inputting is:
  Input Encoded   Output
  TID=1    WLG%286G45 TID=1
  TID=2    WLG%286G5%3A TID=2
  TID=3    WLG%286G63 TID=3
  TID=4    WLG%286G73  TID=4
  TID=5    WLG%286G84  TID=5
  TID=6    WLG%286G93 TID=6
  TID=7    WLG%286G%3A6 TID=7
  TID=8    WLG%286G%3B9 TID=8
  TID=9    WLG%286G%3C3 TID=9
  TID=10  WLG%286G437 TID=10

  #qencode('TID=1')# should return "WLG%286G45" then
  #qdecode('WLG%286G45')# should return the starting value of "TID=1".

  Mark W. Breneman
  -Cold Fusion Developer
  -Network Administrator
    Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
    608.270.9770

  -Original Message-
  From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, October 08, 2003 3:50 PM
  To: CF-Talk
  Subject: RE: Ok, I give up UDF error

  Actually, I tried this function and it works fine for me.  What are
you
  passing into the function? what's the purpose?
  Here's a test that passes in cgi.query_string

  gives a cryptic strring as a return.
  http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?object=true

  Throws an error:
  http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm

  Throws an error:
  http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?o

  If the string is less than 1 character long it throws an error.

  I can only assume that something is crazy about the value being passed
  IN to the function.

  This function appears to take items and shift the ascii character code
  value 3 to the left.  I'm guessing that the ascii
  character code in some cases is less than 3 causing some sort of end
  marker to be placed and thus befuddling your
  "len( )".
  I would do something like:

  if(tempStr LT 4)
  tempStr = tempStr + 254;

  Then your values would "wrap" through the ascii code table.

  -Mark

    -Original Message-
    From: Calvin Ward [mailto:[EMAIL PROTECTED]
    Sent: Wednesday, October 08, 2003 3:16 PM
    To: CF-Talk
    Subject: Re: Ok, I give up UDF error

    What does this do for you?

    
    function qdecode(urlvars){
    var tempurlvars = URLDecode(urlvars);
    var strlen = len(tempurlvars);
    var tempstr = "";
    var i = 1;
    var newstr = "";
    for(i=1;i lte strlen;i=i+1) {
    tempstr = Asc(Mid(tempurlvars, i, 1));
    newstr = newstr & Chr(tempstr - 3);
    }
   strReturn = 'Too Short:' & newstr & ':end';
   if (len(newstr)+1)
strReturn = left(newstr,len(newstr)-1);
}
    

    - Calvin
  - Original Message -
  From: Mark W. Breneman
  To: CF-Talk
  Sent: Wednesday, October 08, 2003 3:52 PM
  Subject: RE: Ok, I give up UDF error

  Good question, but no, I have ran the output sever

RE: Bots / spiders finding unlinked pages... SOVLED!

2003-10-08 Thread Mark W. Breneman
Thanks for all of your help.  

The mystery has been solved.  

We recently gave the client a copy of the full log files from the past
three years.  It sounds like they loaded the log files into
NetTracker/6.0 Enterprise and hit "GO".  Lucky thing that the admin
pages are coded to require a user to be login via a session var in order
to access the admin pages.  It would not have been fun to restore form
back up all of the data that could be deleted from the admin pages.
(130ish admin pages that control the site content)

We promptly told them to stop.  Any data that they would get form 3
years of log file spidering would be very inaccurate.  So many of the
pages have been renamed , moved .etc.  

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 4:42 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

Also, I'd look in your logs.  I'd find the reference relating to your
search
engine and the hidden page.  It should tell you the name of the program
that
requested it.  Then look for references just before it. One of those
pages
might have told the engine about your hidden page.

DRE

-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 3:22 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

does the program tell you the refering pages?  On google you can find
out
how many sites have links to yours.
Also, you might want to check that none of your hidden files are the
folder
default files as well.

DRE

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 1:55 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

Another way, I've heard of "hidden" files being found is by user's
browsing.
If a user was looking at one of these non-linked files, then moved onto
another page.  The URL of the hidden file is available as
"HTTP-Referrer"
This could then be followed back to the original file.

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

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:06 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

One possible way is if you have a search feature built into your site.
Internal search engines index files not by URL but by directory/file and
would therefore find "hidden" documents.  If the spider can somehow
access a
search results page (submit a blank form maybe?) those files might show
up.

Regardless, never assume that a file is safely hidden on your website
simply
because it is not linked to.  There have been several high profile
"finds"
of "hidden" files ranging from obituaries for people who were not dead
to
sensitive internal documents.  As a rule, don't put anything on a web
server
unless you're willing to let people see it.

--
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: Wednesday, October 08, 2003 12:42 PM
To: CF-Talk
Subject: OT:Bots / spiders finding unlinked pages... How?

One of our clients' IS department just got NetTracker/6.0 Enterprise and
has set it loose on the site.  It has found several pages that are not
linked from any where.  I do not have directory browsing turned on and I
know these pages are not linked from any page..

How is it possible that it found these unlinked pages?

Can other Bots / spiders also find unlinked pages?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

  _  

  _  


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Bots / spiders finding unlinked pages... How?

2003-10-08 Thread Mark W. Breneman
We the developer do not have access as of yet to the NetTracker/6.0
Enterprise results.   I am assuming we will get a copy of it in a report
of stuff we need to fix. BTW it looks like NetTracker/6.0 Enterprise
calls the pages with any url vars.  Can't wait to see the report on
that.

None of the pages that NetTracker/6.0 Enterprise is finding are default
files.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 4:22 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

does the program tell you the refering pages?  On google you can find
out
how many sites have links to yours.
Also, you might want to check that none of your hidden files are the
folder
default files as well.

DRE

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 1:55 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

Another way, I've heard of "hidden" files being found is by user's
browsing.
If a user was looking at one of these non-linked files, then moved onto
another page.  The URL of the hidden file is available as
"HTTP-Referrer"
This could then be followed back to the original file.

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

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:06 PM
To: CF-Talk
Subject: RE: Bots / spiders finding unlinked pages... How?

One possible way is if you have a search feature built into your site.
Internal search engines index files not by URL but by directory/file and
would therefore find "hidden" documents.  If the spider can somehow
access a
search results page (submit a blank form maybe?) those files might show
up.

Regardless, never assume that a file is safely hidden on your website
simply
because it is not linked to.  There have been several high profile
"finds"
of "hidden" files ranging from obituaries for people who were not dead
to
sensitive internal documents.  As a rule, don't put anything on a web
server
unless you're willing to let people see it.

--
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: Wednesday, October 08, 2003 12:42 PM
To: CF-Talk
Subject: OT:Bots / spiders finding unlinked pages... How?

One of our clients' IS department just got NetTracker/6.0 Enterprise and
has set it loose on the site.  It has found several pages that are not
linked from any where.  I do not have directory browsing turned on and I
know these pages are not linked from any page..

How is it possible that it found these unlinked pages?

Can other Bots / spiders also find unlinked pages?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

  _  

  _  


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
Good theory, but.

See my last posting where I have included both the qencode and the
qdecode function.  The qencode may indeed wrap through the ascii code
table but, where I am running the left function the values have already
been decoded (de-shifted).  All I am trying to do is to get rid of the
random number on the end.



The values I am inputting is:
Input Encoded   Output
TID=1    WLG%286G45 TID=1
TID=2    WLG%286G5%3A TID=2
TID=3    WLG%286G63 TID=3
TID=4    WLG%286G73  TID=4
TID=5    WLG%286G84  TID=5
TID=6    WLG%286G93 TID=6
TID=7    WLG%286G%3A6 TID=7
TID=8    WLG%286G%3B9 TID=8
TID=9    WLG%286G%3C3 TID=9
TID=10  WLG%286G437 TID=10

#qencode('TID=1')# should return "WLG%286G45" then
#qdecode('WLG%286G45')# should return the starting value of "TID=1".

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 3:50 PM
To: CF-Talk
Subject: RE: Ok, I give up UDF error

Actually, I tried this function and it works fine for me.  What are you
passing into the function? what's the purpose?
Here's a test that passes in cgi.query_string

gives a cryptic strring as a return.
http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?object=true

Throws an error:
http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm

Throws an error:
http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?o

If the string is less than 1 character long it throws an error.

I can only assume that something is crazy about the value being passed
IN to the function.

This function appears to take items and shift the ascii character code
value 3 to the left.  I'm guessing that the ascii
character code in some cases is less than 3 causing some sort of end
marker to be placed and thus befuddling your
"len( )".
I would do something like:

if(tempStr LT 4)
    tempStr = tempStr + 254;

Then your values would "wrap" through the ascii code table.

-Mark

  -Original Message-
  From: Calvin Ward [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, October 08, 2003 3:16 PM
  To: CF-Talk
  Subject: Re: Ok, I give up UDF error

  What does this do for you?

  
  function qdecode(urlvars){
  var tempurlvars = URLDecode(urlvars);
  var strlen = len(tempurlvars);
  var tempstr = "";
  var i = 1;
  var newstr = "";
  for(i=1;i lte strlen;i=i+1) {
  tempstr = Asc(Mid(tempurlvars, i, 1));
  newstr = newstr & Chr(tempstr - 3);
  }
 strReturn = 'Too Short:' & newstr & ':end';
 if (len(newstr)+1)
  strReturn = left(newstr,len(newstr)-1);
  }
  

  - Calvin
    - Original Message -
    From: Mark W. Breneman
    To: CF-Talk
    Sent: Wednesday, October 08, 2003 3:52 PM
    Subject: RE: Ok, I give up UDF error

    Good question, but no, I have ran the output several times and
checked
    all values none are blank.

    Mark W. Breneman
    -Cold Fusion Developer
    -Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

    -Original Message-
    From: Matthew Walker [mailto:[EMAIL PROTECTED]
    Sent: Wednesday, October 08, 2003 2:44 PM
    To: CF-Talk
    Subject: Re: Ok, I give up UDF error

    Is your input string empty?
  - Original Message -
  From: Mark W. Breneman
  To: CF-Talk
  Sent: Thursday, October 09, 2003 8:37 AM
  Subject: Ok, I give up UDF error

  This seems so simple. All I want to do is to trim the last char
from
    the
  return string.  I keep getting this error "Parameter 2 of function
    Left
  which is now -1 must be a positive integer"

  If I hard code a value in the UDF works with out a problem.  But
when
    I
  put in the len(newstr)-1  into the "left" function it seems to
    evaluate
  to 0.

  Can anyone help me out?

  

  function qdecode(urlvars){

  var tempurlvars = URLDecode(urlvars);

  var strlen = len(tempurlvars);

  var tempstr = "";

  var i = 1;

  var newstr = "";

  for(i=1;i lte strlen;i=i+1) {

  tempstr = Asc(Mid(tempurlvars, i, 1));

      newstr = newstr & Chr(tempstr - 3);

  }

  return left(newstr,len(newstr)-1);

  }

  

  Mark W. Breneman

  -Cold Fusion Developer

RE: Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
The still get the same error "Parameter 2 of function Left which is now
-1 must be a positive integer"

OK here is the pair of UDFs if anyone cares to play with them.  All they
are meant to do is to encode a value to a short non readable string.  I
plan to use to encode url vars when security is not major issue. Simply
this is meant to be generate a short sneaky, not secure encoded string.

As you can see buy the qencode function a random number is added to the
end of the sting just to make it look non-sequestional when a list of
the code are viewed.  All I am trying to do is to trim that last number
off on the qdecode output.

Thanks for your help.



function qencode(urlvars){

var tempurlvars = URLEncodedFormat(urlvars  & RandRange(0,
9));

var strlen = len(tempurlvars);

var newstr = "";

var tempstr = "";

var i = 1;

var key = 65;

for(i=1;i lte strlen;i=i+1) {

tempstr = Asc(Mid(tempurlvars, i, 1));



newstr = newstr & Chr(tempstr + 3);



}

return URLEncodedFormat(newstr);

}

 



function qdecode(urlvars){

var tempurlvars = URLDecode(urlvars);



var strlen = len(tempurlvars);

var newstr = "";

var tempstr = "";

var i = 1;

for(i=1;i lte strlen;i=i+1) {

tempstr = Asc(Mid(tempurlvars, i, 1));



newstr = newstr & Chr(tempstr - 3);

    }

   strReturn = 'Too Short:' & newstr & ':end';

   if (len(newstr)+1)

    strReturn = left(newstr,len(newstr)-1);



return strReturn;

}



Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 3:16 PM
To: CF-Talk
Subject: Re: Ok, I give up UDF error

What does this do for you?


function qdecode(urlvars){
var tempurlvars = URLDecode(urlvars);
var strlen = len(tempurlvars);
var tempstr = "";
var i = 1;
var newstr = "";
for(i=1;i lte strlen;i=i+1) {
tempstr = Asc(Mid(tempurlvars, i, 1)); 
newstr = newstr & Chr(tempstr - 3);
}
   strReturn = 'Too Short:' & newstr & ':end';
   if (len(newstr)+1)
    strReturn = left(newstr,len(newstr)-1);
    }


- Calvin
  - Original Message - 
  From: Mark W. Breneman 
  To: CF-Talk 
  Sent: Wednesday, October 08, 2003 3:52 PM
  Subject: RE: Ok, I give up UDF error

  Good question, but no, I have ran the output several times and checked
  all values none are blank.

  Mark W. Breneman
  -Cold Fusion Developer
  -Network Administrator
    Vivid Media
    [EMAIL PROTECTED]
    www.vividmedia.com
    608.270.9770

  -Original Message-
  From: Matthew Walker [mailto:[EMAIL PROTECTED] 
  Sent: Wednesday, October 08, 2003 2:44 PM
  To: CF-Talk
  Subject: Re: Ok, I give up UDF error

  Is your input string empty? 
    - Original Message - 
    From: Mark W. Breneman 
    To: CF-Talk 
    Sent: Thursday, October 09, 2003 8:37 AM
    Subject: Ok, I give up UDF error

    This seems so simple. All I want to do is to trim the last char from
  the
    return string.  I keep getting this error "Parameter 2 of function
  Left
    which is now -1 must be a positive integer"

    If I hard code a value in the UDF works with out a problem.  But
when
  I
    put in the len(newstr)-1  into the "left" function it seems to
  evaluate
    to 0.

    Can anyone help me out?

    

    function qdecode(urlvars){

    var tempurlvars = URLDecode(urlvars);

    var strlen = len(tempurlvars);

    var tempstr = "";

    var i = 1;

    var newstr = "";

    for(i=1;i lte strlen;i=i+1) {

    tempstr = Asc(Mid(tempurlvars, i, 1));

    newstr = newstr & Chr(tempstr - 3);

    }

    return left(newstr,len(newstr)-1);

    }

    

    Mark W. Breneman

    -Cold Fusion Developer

    -Network Administrator

  Vivid Media

  [EMAIL PROTECTED]

  www.vividmedia.com

  608.270.9770

    _  


  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
Sorry, I should have included that info. I was assuming the problem was
a syntax error on my part.

All values of newstr are at least 9 chars in length.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 2:48 PM
To: CF-Talk
Subject: RE: Ok, I give up UDF error

If the variable newstr is only 1 char (or a zero length string) - this
is the error you will get. Output the value of
"len(newstr) and see what you get.

-Mark

  -Original Message-
  From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, October 08, 2003 2:38 PM
  To: CF-Talk
  Subject: Ok, I give up UDF error

  This seems so simple. All I want to do is to trim the last char from
the
  return string.  I keep getting this error "Parameter 2 of function
Left
  which is now -1 must be a positive integer"

  If I hard code a value in the UDF works with out a problem.  But when
I
  put in the len(newstr)-1  into the "left" function it seems to
evaluate
  to 0.

  Can anyone help me out?

  

  function qdecode(urlvars){

  var tempurlvars = URLDecode(urlvars);

  var strlen = len(tempurlvars);

  var tempstr = "";

  var i = 1;

  var newstr = "";

  for(i=1;i lte strlen;i=i+1) {

  tempstr = Asc(Mid(tempurlvars, i, 1));

  newstr = newstr & Chr(tempstr - 3);

  }

  return left(newstr,len(newstr)-1);

  }

  

  Mark W. Breneman

  -Cold Fusion Developer

  -Network Administrator

    Vivid Media

    [EMAIL PROTECTED]

    www.vividmedia.com

    608.270.9770



  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
Good question, but no, I have ran the output several times and checked
all values none are blank.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 08, 2003 2:44 PM
To: CF-Talk
Subject: Re: Ok, I give up UDF error

Is your input string empty? 
  - Original Message - 
  From: Mark W. Breneman 
  To: CF-Talk 
  Sent: Thursday, October 09, 2003 8:37 AM
  Subject: Ok, I give up UDF error

  This seems so simple. All I want to do is to trim the last char from
the
  return string.  I keep getting this error "Parameter 2 of function
Left
  which is now -1 must be a positive integer"

  If I hard code a value in the UDF works with out a problem.  But when
I
  put in the len(newstr)-1  into the "left" function it seems to
evaluate
  to 0.

  Can anyone help me out?

  

  function qdecode(urlvars){

  var tempurlvars = URLDecode(urlvars);

  var strlen = len(tempurlvars);

  var tempstr = "";

  var i = 1;

  var newstr = "";

  for(i=1;i lte strlen;i=i+1) {

  tempstr = Asc(Mid(tempurlvars, i, 1));

  newstr = newstr & Chr(tempstr - 3);

  }

  return left(newstr,len(newstr)-1);

  }

  

  Mark W. Breneman

  -Cold Fusion Developer

  -Network Administrator

    Vivid Media

    [EMAIL PROTECTED]

    www.vividmedia.com

    608.270.9770



  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Ok, I give up UDF error

2003-10-08 Thread Mark W. Breneman
This seems so simple. All I want to do is to trim the last char from the
return string.  I keep getting this error "Parameter 2 of function Left
which is now -1 must be a positive integer"



If I hard code a value in the UDF works with out a problem.  But when I
put in the len(newstr)-1  into the "left" function it seems to evaluate
to 0.

Can anyone help me out?



function qdecode(urlvars){

var tempurlvars = URLDecode(urlvars);

var strlen = len(tempurlvars);

var tempstr = "";

var i = 1;

var newstr = "";

for(i=1;i lte strlen;i=i+1) {

tempstr = Asc(Mid(tempurlvars, i, 1)); 

newstr = newstr & Chr(tempstr - 3);

}

    return left(newstr,len(newstr)-1);

}





Mark W. Breneman

-Cold Fusion Developer

-Network Administrator

  Vivid Media

  [EMAIL PROTECTED]

  www.vividmedia.com

  608.270.9770




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT:Bots / spiders finding unlinked pages... How?

2003-10-08 Thread Mark W. Breneman
One of our clients' IS department just got NetTracker/6.0 Enterprise and
has set it loose on the site.  It has found several pages that are not
linked from any where.  I do not have directory browsing turned on and I
know these pages are not linked from any page.. 

How is it possible that it found these unlinked pages?

Can other Bots / spiders also find unlinked pages?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Regular Expression find end of line / carriage return and replace

2003-09-26 Thread Mark W. Breneman
That is embarssing!!!Guess I assumed that it could not be that EZ and that you needed to usea Regular _expression_.Oh well, that was my one way too simple question for the year. Too bad Iam way over my limit on those. :-)  Must be late Friday.Thanks!Mark W. Breneman-Cold Fusion Developer-Network Administrator  Vivid Media  [EMAIL PROTECTED]  www.vividmedia.com  608.270.9770-Original Message-From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:52 PMTo: CF-TalkSubject: RE: Regular _expression_ find end of line / carriage return andreplaceHi Mark,No need for a regex unless I completely misread your question.In CFS, go to Search-->Extended Replacein the 'Find What' field, literally hit the enter keypop a comma in the 'replace with' fieldlet 'er rip.umm... make sure "current document" is selected :)-----Original Message-From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:26 PMTo: CF-TalkSubject: Regular _expression_ find end of line / carriage return andreplaceOk, I finally broke down and I have to ask this question.How do you do a simple find end of line / carriage return and replacewith a "," in CF studio?I have tried to look this up several times and found myself using ultraedit just to get it done, a few mins later. Thanks.Mark W. Breneman-Cold Fusion Developer-Network AdministratorVivid Media[EMAIL PROTECTED]www.vividmedia.com608.270.9770  _  
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



RE: CFMX6.1 admin left menu does not load then CF hangs

2003-09-26 Thread Mark W. Breneman
Thank you!   Mark W. Breneman-Cold Fusion Developer-Network Administrator  Vivid Media  [EMAIL PROTECTED]  www.vividmedia.com  608.270.9770-Original Message-From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:05 AMTo: CF-TalkSubject: RE: CFMX6.1 admin left menu does not load then CF hangs If ur accessing under SSL there's a hot fix for CF that addressesthis...there's a static cfhttp call in the menu that uses http.Stace  _____  From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: September 26, 2003 11:58 AMTo: CF-TalkSubject: CFMX6.1 admin left menu does not load then CF hangsJust a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.  When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line.Has anyone seen this?  Or know of a fix?Thanks Mark W. Breneman-Cold Fusion Developer-Network Administrator  Vivid Media  [EMAIL PROTECTED]  www.vividmedia.com  608.270.9770  __  
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



Regular Expression find end of line / carriage return and replace

2003-09-26 Thread Mark W. Breneman
Ok, I finally broke down and I have to ask this question.How do you do a simple find end of line / carriage return and replacewith a "," in CF studio?I have tried to look this up several times and found myself using ultraedit just to get it done, a few mins later. Thanks.Mark W. Breneman-Cold Fusion Developer-Network Administrator  Vivid Media  [EMAIL PROTECTED]  www.vividmedia.com  608.270.9770
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



CFMX6.1 admin left menu does not load then CF hangs

2003-09-26 Thread Mark W. Breneman
 Just a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting.  When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service.  Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line. Has anyone seen this?  Or know of a fix? Thanks  Mark W. Breneman-Cold Fusion Developer-Network Administrator  Vivid Media  [EMAIL PROTECTED]  www.vividmedia.com  608.270.9770
 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]



RE: Auto Pinging Script?

2003-09-24 Thread Mark W. Breneman
WOW!

That is really aggressive, if that is fully automated.  I would hate to
guess how many emails to ISPs and Law Enforcement my server would be
generating, if I used you system.  My software firewall logs all pings,
and there are lots of them, on the 15-20 IPs I have on the server. 

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 24, 2003 1:19 PM
To: CF-Talk
Subject: Re: Auto Pinging Script?

You do this on my domain(s) and on the sixth ping you would be locked
out of
access to the system, and on the 15th ping, you would be reported to
your ISP in
the hopes of getting your service terminated, with additional reports to
your
ISP periodically thereafter, and then followed by a complaint filed with
appropriate Law Enforcement.

You see, there are much better ways of evaluating a service provider
than what
could be considered a DDOS or intrusion attempt.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases.
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy:
http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Nick Baker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 10:10 AM
Subject: Auto Pinging Script?


| We need to evaluate the performance of some CF hosting services. One
angle
| I would like to try is to setup an automatic pinging script and ping
sample
| domains hosted by the hosting services at intervals over a period.
Note: I
| am aware that pinging is often used for denial of service, but that is
not
| what this is about.
|
| Any ideas or suggestions? Maybe a script or a Web site that provides
this
| service?
|
| Thanks,
|
| Nick
|
| 

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138351
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ColdFusion MX 6.1, now 2.5 times faster. 
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803


RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
Yes please, it may be a good short term fix. Or long term... 

You can mail it to:

[EMAIL PROTECTED]



-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:42 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

I had a similar issue, but quite as bad, but an MS access db would grow
to
2GB in about a week or less depending on the activity.  

I solved (if you call it that) the issue by doing an automatice
compression
of the db everynight.

Let me know and I will email you the code off list.

I got the origanal code from Jochem, so he might have a more updated
version
as well.



-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 1:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB


I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 



~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137401
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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


RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
CF5 (as in the subject :-)) I've had a long day too.
MB
-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:18 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Are you are on CF5 or MX?

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 5:18 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB


I am sorry!  The site uses menu monger pro and MM pro does use client
vars.

So yes, it is using client vars.  Now what?  Why did this start to mega
bloat now?  The site has been up and running as is for about a month
with out problems. 

At the rate of an estimated 100MB per hour (I think that is on the low
side) it would only be 20 hours till it built the 2 GB file.

Thanks

MB

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:53 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Hm...did you see anything in the DB when you had it open?

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:49 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB


No, we are only using session vars.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:45 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Are they storing client variables in the DB?

Dan Phillips
www.CFXHosting.com 
1-866-239-4678
[EMAIL PROTECTED]


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB


I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 







~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137397
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
I am sorry!  The site uses menu monger pro and MM pro does use client
vars.

So yes, it is using client vars.  Now what?  Why did this start to mega
bloat now?  The site has been up and running as is for about a month
with out problems. 

At the rate of an estimated 100MB per hour (I think that is on the low
side) it would only be 20 hours till it built the 2 GB file.

Thanks

MB

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:53 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Hm...did you see anything in the DB when you had it open?

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:49 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB


No, we are only using session vars.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:45 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Are they storing client variables in the DB?

Dan Phillips
www.CFXHosting.com 
1-866-239-4678
[EMAIL PROTECTED]


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB


I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 





~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137393
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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


RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
Dan,

Nothing out of the ordinary.

I have RDS access the client's server.  I am downloading a back up of
the file I made a few min ago. I'll take a 2nd look.

Thanks.

MB


-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:53 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Hm...did you see anything in the DB when you had it open?

-Original Message-----
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:49 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB


No, we are only using session vars.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:45 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Are they storing client variables in the DB?

Dan Phillips
www.CFXHosting.com 
1-866-239-4678
[EMAIL PROTECTED]


-Original Message-----
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB


I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 





~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137389
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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


RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
No, we are only using session vars.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 3:45 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB

Are they storing client variables in the DB?

Dan Phillips
www.CFXHosting.com 
1-866-239-4678
[EMAIL PROTECTED]


-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 4:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB


I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 



~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137381
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
I just got back from a client site and they are running CF5 and MS
access.  
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk.  I was able to do a simple compact with access
and the file shrunk from 2 GB to 5 MB, but soon after started to grow
again.

Has anyone seen this before?

I assume that since I can shrink the database to 5 MB then it is not
real data that is taking up the 2gb of space.

Anyone have any ideas?

I found that if reset CF it took about 15mins for the growing to start.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770 

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137376
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: [OT] xxxxxxCode.Com (Launched new site last night, feedback please!)

2003-09-11 Thread Mark W. Breneman
We do something sorta like that,

I have a chunk of code that looks for a "debug cookie".  If you have the
cookie and the value is set to debug =on via a URL var, you can see all
of the diagnostic code, all of the server debug code and allows us to
see any errors rather then the "An error has occurred, the webadmin has
been notified" message. 

Kinda handy,

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Darron J. Schall [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 11, 2003 3:10 PM
To: CF-Talk
Subject: Re: [OT] .Com (Launched new site last night, feedback please!)


Same deal here:

We have xxx1.my.com for development, xxx2.my.com for staging, and
www.my.com for production.  We wrote a UDF that returns the sub domain
based on the ip address.


debugging output here!


It's also useful in changing from http to https and ensure that the
domain is right.. https://#getSubDomain()#.my.com

Nothing is worse than having the live site link to stuff on your
development server..

-d

- Original Message - 
From: "Deanna Schneider" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 3:18 PM
Subject: Re: [OT] .Com (Launched new site last night, feedback
please!)


> Pablo,
> We avoid the issue of "uncommenting" our error tags for production by 
> wrapping them in an if statement that looks at the cgi.server_name 
> var.
I'm
> sure there's multiple ways to handle this, but we've found it's way 
> easier to do if you're not relying on remembering to change that one 
> little thing before going live. -d
>


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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: Change NT password

2003-09-10 Thread Mark W. Breneman
Does anyone know if it is possible to change passwords via LDAP?

I thought I had seen somewhere that this could be done.


You could use CFEXECUTE and "net user user_name  new_password"  The only
trick is that you have to be logged as Admin.  Not a good idea from a
security stand point to run CF as admin.

http://support.microsoft.com/?kbid=149427

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 10, 2003 1:07 PM
To: CF-Talk
Subject: Change NT password


Does anyone have a means of allowing an NT4 (or Win2k AD) domain user to
change his password from a ColdFusion (CF5 on IIS5) app?  The following
explains how to do it using ASP, but we don't want to run ASP on the
server:

http://support.microsoft.com/?id=331834

Thanks,
Jim


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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: DWMX 2004 - Whats new for us?

2003-08-27 Thread Mark W. Breneman
I was wondering when you (Ben) would get involved in this thread.  Good
to hear from you and good to hear your points.


I think (I can only speak for myself) people want to "vote with their
money" to send a message to MM that they would be willing to buy
HomeSite+ alone to reinforce that there is a community of CF developers
that want a tool like homesite+.  Maybe it is based on a fear that MM
will drop HomeSite+ since it is kinda a "freebie" and freebies don't
make company money. (I know it is not really a freebie)

Now don't get me wrong! I like that DWMX is only $199 and HomeSite+ is
included in the deal. I use both DWMX and HS+. I personally would like
to see this synergy of the two products continue Or for DWMX to be made
into the UBER tool that I have been dreaming of.

Just my $0.02

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770




-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 27, 2003 2:27 PM
To: CF-Talk
Subject: RE: DWMX 2004 - Whats new for us?



I've been watching this thread with interest, and have also been
forwarding the juicy bits to all sorts of folks within Macromedia. I've
stayed out of the discussion thus far, but ...

I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I
migrated to after Sage which I migrated to after Brief). I'd love one
editor that did it all, it does not exist yet, so I use multiple. It
seems that many of you do the same.

And no, I do not have to use Dreamweaver, I don't even have to like
Dreamweaver, no one (not even my employer) gets to tell me what editor I
should use or like. (Anyone who thinks otherwise does not know me). I
have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal
critic of Dreamweaver prior to that), I have been on the backs of the
Dreamweaver team to improve CF support for a long time and continue to
do so, I publicly acknowledge what I like about Dreamweaver, and have no
qualms about stating what it is that I don't like. I have been very
honest in discussing Dreamweaver, and have never positioned it as a CF
Studio replacement, and always positioned it as "another tool in the
tool box" while stating that the Dreamweaver team had expressed a
commitment to continue to improve ColdFusion integration.

It's that last point that seems to be the crux of this all. And for
those of you who have complained that Dreamweaver MX 2004 does not do
enough for ColdFusion developers, well, I agree. It has improved, and
some of the biggest complaints from ColdFusion users (including the
speed and needing to always define sites) have been addressed. I would
really have liked to have seen more, and as much as I don't like the
fact that the Dreamweaver team dedicated resources to improving support
for ASP.NET and PHP I also understand the economics. This is a business,
Macromedia needs to continue to sell lots of Dreamweaver. The product
has 2,000,000+ users (or something like that) most of whom do not use
ColdFusion, the static page market is saturated and they need to go
after where the big bucks are, targeting PHP and ASP.NET users make
sense. (Whether or not those users will buy the story remains to be
seen, but the Dreamweaver team had to make that effort). It is less "we
don't care about CF" and more "we care lots about those massive user
bases". Context.

I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or
any editor). Many of the items are my own wants, others are user
suggestions, all are shared by the wider community. I want data
awareness in the IDE, I want right click introspection everywhere and
anywhere, I want IntelliJ type intelligence so that when I change a CFC
method I can keep all invocations in synch, I want speed, I want decent
DB integration tools, I want a real debugger, I could go on and on and
on ... I'll keep pushing and nagging.

So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it
a useful tool? Yes. It is an improvement over Dreamweaver MX, even for
us CFers? Yes. Is it good enough to be the exclusive editor for
ColdFusion developers? I'd say that depends on the developer, for
experienced developers I'd say no. Is it compelling enough for Studio
and HomeSite users to abandon those tools entirely for it? No. Does it
have any value at all for ColdFusion developers? Absolutely.

I am at least thankful that HomeSite has been given a new lease on life.
HomeSite 5.5 is not a major upgrade, but it does add some important
enhancements some of which I may want to use. Some of you complained
about having to buy Dreamweaver to get HomeSite+, and that one irked me
a bit. We seem to have forgotten that CF Studio used to sell for, what
was it? $300? $400? I forget. Paying $199 for Dreamweaver + HomeSite+ is
less than you paid

MX timeout regardless of how long I set request time out.

2003-08-27 Thread Mark W. Breneman
I have an extremely long running not publicly accessible CF page.
  
The problem I run into from time to time is that CFMX seems to time out
OR is it Jrun that times out?

CFMX seems to reset itself and for a few seconds I get "Server Error
The server encountered an internal error and was unable to complete your
request. Could not connect to JRun Server." when ever I run this page.

I have tried . And I still get the
same error.  Is there a .xlm file I need to tweak?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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: DWMX 2004 - Whats new for us?

2003-08-25 Thread Mark W. Breneman
I hate to do a "me too" but I keep Ultraedit 32 on my computer just for
that Vertical select feature.  I use it at least 2-5  a week.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Jerry Barnes [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 25, 2003 2:27 PM
To: CF-Talk
Subject: RE: DWMX 2004 - Whats new for us?

Vertical select would be a nice feature.  Also allowing the user to
insert spaces for tabs and indicating the cursor column position in code
view would make good additions.  

J

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 25, 2003 2:32 PM
To: CF-Talk
Subject: Re: DWMX 2004 - Whats new for us?


What I'd like to know is if they've finally added the ability to mark a
column of text in "code view" mode just like UltraEdit32 can.  Until I
see that feature added, UltraEdit will probably remain my editor of
choice.

That's not to say that I don't used DWMX at all.  I just find myself
using UltraEdit more than DWMX.



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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 Subquery as text string? MSSQL

2003-08-22 Thread Mark W. Breneman
>From the little research I have done, I have not been able to confirm
that MSSQL has UDF for aggregates.

Can anyone confirm this?

Seems that is a some what common task, to generate a list of items for a
report.  Maybe not.

Thanks
MB

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2003 4:12 PM
To: CF-Talk
Subject: Re: Return Subquery as text string? MSSQL

Mark W. Breneman wrote:

> Is there any way to do this in MSSQL?  Normally you can not return
more
> then one value with type of subquery.
> 
> Here is what I would like to do:
> Select UserID, Name, (select orderNo from orders where OrderID=UserID)
> as Orders
> From Users
> 
> Result:
> 
> "1", "BOB", "12,63,192"
> "2", "Ed",  "34,45,233" 

We should put this in a FAQ, it pops up every other week :-)

You can do this in every DBMS that allows you to create your own 
functions for aggregates. For a PostgreSQL based example, see 
http://www.zope.org/Members/pupq/pg_in_aggregates

Jochem




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Return Subquery as text string? MSSQL

2003-08-22 Thread Mark W. Breneman
Is there any way to do this in MSSQL?  Normally you can not return more
then one value with type of subquery.

Here is what I would like to do:
Select UserID, Name, (select orderNo from orders where OrderID=UserID)
as Orders
>From Users

Result:

"1", "BOB", "12,63,192"
"2", "Ed",  "34,45,233" 

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: null null errors

2003-08-20 Thread Mark W. Breneman
Null null ... joy.  

I too have tried to fight the null null problem.  We found that updater
3 reduces the problems, but does not eliminate it.  We still get about
5-12 users a month that get the null null error.

There has been postings on this list the null null problem is related to
client vars.  It seems that the error will "happen" one user and all
pages that user tries to view with throw the null null error. I have
only been able to see it once myself.

Does anyone know if this issue is being addressed by MM. Does 6.1 have
the null null issue?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 19, 2003 4:55 PM
To: CF-Talk
Subject: null null errors

Anyone have any ideas as to what a "null null" error is?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Redsky-Still issues with CFINSERT and CFUPDATE.

2003-08-14 Thread Mark W. Breneman
Hey IF a patch is written for 6.1 to fix this "password / Access" issue
on cfupdate and cfinsert could the "Primary Key / cfupdate" issue also
be address?

 

Error message:

The field "ID," was not found in the Form input. This field is required
in order to do an UPDATE because it is part of the primary key for the
"tablename" table.

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3
<http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3&thre
adid=380672> &threadid=380672

 

When using the formfields attribute in the cfupdate tag the primary key
must also be listed in the formfields attribute or else error will be
generated. This issue was introduced in CF MX.  CF 5 and earlier had no
problems.  I think it is a poor practice to update the primary key even,
if it is with the same value.

 

Code Example:




 



 

Result error: 
Primary key field "RECORDID," not found.

The field "RECORDID," was not found in the Form input. This field is
required in order to do an UPDATE because it is part of the primary key
for the "MailListLog" table.

 

Work around code:





 



 

 

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com <http://www.vividmedia.com/> 
  608.270.9770

 

 

-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 11, 2003 9:59 AM
To: CF-Talk
Subject: RE: Redsky-Still issues with CFINSERT and CFUPDATE.

 

I was reading through this thread but I don't see the error message. Can
someone post sample code (against cfsnippets) that produces the error
and the actual error text?

 

Thanks!

Christine

 

-Original Message-

From: Angel Stewart [mailto:[EMAIL PROTECTED] 

Sent: Monday, August 11, 2003 10:21 AM

To: CF-Talk

Subject: RE: Redsky-Still issues with CFINSERT and CFUPDATE.

 

 

Yes I do.

 

With Ablecommerce as well.

I think there is a workaround for Able, but I'm having trouble accessing
their support site. I don't know if the workaround would help with my
CFINSERT and CFUPDATE issues.

 

I am going through one particular application and manually changing the
insert/update statements now though. 

 

-Angel

 

 

-Original Message-

From: David Schmidt [mailto:[EMAIL PROTECTED] 

 

Are you still have the same issues, Angel?

 

 

 

 


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

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



RE: Redsky-Still issues with CFINSERT and CFUPDATE.

2003-08-11 Thread Mark W. Breneman
Is it a BUG??? Bug: A defect or difficulty, as in a system or design. A
defect in the code or routine of a program.

Well, it is an inconsistency at very least between cf5 and MX that cost
us about 16 hours of development time to fix the problem on 50 - 70
sites when we moved to MX. This issue is not address in the MX docs
other then a live doc rant about the issue 'er ah "bug".

I guess I will call it a BUG until it is fixed or someone bigger then me
tells me other wise. :-)

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 11, 2003 1:14 PM
To: CF-Talk
Subject: Redsky-Still issues with CFINSERT and CFUPDATE.

Mark W. Breneman wrote:

>Hey IF a patch is written for 6.1 to fix this "password / Access" issue
>on cfupdate and cfinsert could the "Primary Key / cfupdate" issue also
>be address?
I can't speak for Macromedia -- I'm doing my best to document and
explain the issue to them. I doubt that the primary key issue is
considered a "bug" per se...

...D

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

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

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



RE: Redsky-Still issues with CFINSERT and CFUPDATE.

2003-08-11 Thread Mark W. Breneman
Can anyone shed some light on what the 'problems' are with cfinsert and
cfupdate not working with 6.1? I must be missing an email or two. 

Is anyone having problems with MS SQL 2000 and 6.1 cfupdate and
cfinsert? Other then the problem that CF 6.0 introduced with cfupdate,
requiring the key field to be required in the list of fields to up date.
(Dumb problem) I knew I should have tested the beta of red sky. I had it
sitting on my desk but, no time to test the cfupdate and inserts.  Drat.

Recoding 70-90 sites that we have written over the past 5 years using
cfupdate and cfinsert, is not an option at this time. 

Mark W. Breneman
-Cold Fusion Developer
-Network 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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



Concatenate results of subquery in select

2003-07-18 Thread Mark W. Breneman
Yes, I know this is not standard practice but, I am working on a report and
I would like all of the buildings this teacher teaches at to be in a single
CF query column.

I hope to get query results like:
TeacherName Buildings
Bob High School, Middle School, EMC
Sue ELC, Middle School

Here is basically what I am trying to do:

SELECT TeacherName, (select buildingname from location where teacherID  = 1)
as Buildings
FROM Teachers

But you can not run a subquery that returns more then one value.

Any Ideas on how to work around this?

Tables look like
Teachers table:
teacherID   TeacherName
1   Bob
2   Sue


Location table:
buildingnameteacherID
High School 1
Middle School   1
EMC 1
ELC 2
Middle School   2

I am running:
MS SQL server 2000
CFMX

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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

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



RE: db records with cftags in them do not render -help

2003-07-16 Thread Mark W. Breneman
That makes me laugh or cry not sure what I will do. I have been working with
CF for 5 years and I was aware that you could not put tags and functions
into a var, or in this case a database, but, I assumed that there was a work
around for that.

I have a cf driven photo gallery module that I would like to include into a
database record using a cfinclude. guess I will go back to the drawing
board.

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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

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



RE: db records with cftags in them do not render -help

2003-07-16 Thread Mark W. Breneman
There has got to be a better way of doing this.  Isn't there?

Jochem - Maybe I don't understand what you are saying. The problem I am
having is that I can not "run" a cfinclude that is in a database record. Are
you suggesting that I write 1000s of database records to files? Seems to
kinda defeat the reason we made it a contentment management system in the
first place. Or am I not understanding you correctly. :-)



I think this is the equivalent of what I am trying to do:
I have a var that holds text and 1 cf include.



#foo#


Mark W. Breneman


>Mark W. Breneman wrote:

>> I have a database table that holds the "body" contents of a page. (simple
>> contentment management system) I just tried to put a cfinclude in a db
>> record and found that CFMX does not evaluate the code. CFMX will just
send
>> the cfinclude tag to the browser, as unrendered source code, just like
any
>> other normal html tag. Is there a way I can make CFMX render CFtags that
>> are stored in a db record?

>Write them to a file and cfinclude the file.


>> Seems like there should be an EZ way to do this.

>http://www.macromedia.com/support/email/wishform/?6213=3

>Jochem

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

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



<    1   2   3   4   >