anti-cfflush

[Hugo Ahlenius]

Hi,

Am I missing something... ? If I may, please direct me to where I can do
my homework...

I thought it would be natural to have a tag that just deletes the current
rendered page from memory, and starts off again. Kind of like cfflush,
which flushes the page to the client, but instead flushes it from memory.

Does it make sense?





~|
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: [OT] CSS Question

[Jochem van Dieten]

Taco Fleur wrote:
> Anyone know how to get rid of that inner border line that appears on a submit button 
> when it is active?? Or even change the color?

onClick="blur()"

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: unexpeted result with cfqueryparam

[Jochem van Dieten]

Dina Hess wrote:
>>But not when using cfqueryparam. Using cfqueryparam is meant to call the
>>functionality of the database driver to do the escaping. Any escaping done
>>by CF
>>before that will only result in doubling the quotes twice, and therefore
>>CF
>>should do no escaping whatsoever of any value passed through cfqueryparam.
> 
> 
> Yes, I do remember seeing your previous comments about using CFQUERYPARAM to
> preserve single quotes...but I could never get that to test out. Do you have
> a resource to share?



INSERT INTO table (field)
VALUES (>


Make the value anything you want, quotes, backslashes etc., it will work.


> Maybe this is just another Access anomaly...

No, it is a CF MX anomaly.


> 
> 
>   UPDATE foo
>   SET showLabel =  value="#trim(PreserveSingleQuotes(showLabel))#" />
>   where foo_id = 1
> 
> 
> ...foo is now abc's in the database, which is what we want.
> 
> But when I change the CFQUERYPARAM tag to  cfsqltype="cf_sql_varchar" value="#trim(HTMLEditFormat(showLabel))#" />
> 
> ...foo becomes abc''s in the database

And that is the bug.


> If I change the CFQUERYPARAM tag again to  cfsqltype="cf_sql_varchar" value="#trim(showLabel)#" />
> foo is still abc''s

And if you leave the trim() out it will be abc's again. trim() should 
not influence the number of quotes, only the numer of spaces at the 
beginning and end of the string.

For a peak at the java behind the scenes, take a look at
http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=23

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
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: cfscript object array reference

[Joe Eugene]

> can't cfdump COM objects ;((

Are you using CFMX or CF5? You dont need any COM objects
for xml parsing in CFMX. Use cfInvoke and xmlParse..

If you are using CF5 .. objURL[i].text
Are you sure.. you can't dump a "RESULT" from a COM Objects?

> > > objURL = objXMLDOM.getElementsByTagName("url");

I dont think objURL is an array..
sounds like
 xarr=arrayNew(1);
 xarr[1]=structNew();
 xarr[1].FirstName="Taco";
 xarr[1].LastName="Fleur";

Then you can call something like you did xarr[1].FirstName (== "Taco")

Joe Eugene

> -Original Message-
> From: Taco Fleur [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 12:33 AM
> To: CF-Talk
> Subject: Re: cfscript object array reference
>
>
> can't cfdump COM objects ;((
>
> - Original Message -
> From: "Joe Eugene" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 25, 2003 3:21 PM
> Subject: RE: cfscript object array reference
>
>
> > > objURL = objXMLDOM.getElementsByTagName("url");
> >
> > What is objURL in CF.. i mean type of variable?
> > You might want to dump it.. 
> >
> > if its just an array.. all you need objURL[i] ..
> >
> > Am not sure what your code objURL[i].text is for?
> > Are u trying to parse an xmlDoc.. then its different
> > objURL[i].xmlText;
> >
> >
> > Joe Eugene
> >
> > > -Original Message-
> > > From: Taco Fleur [mailto:[EMAIL PROTECTED]
> > > Sent: Sunday, February 23, 2003 11:08 PM
> > > To: CF-Talk
> > > Subject: cfscript object array reference
> > >
> > >
> > > objXMLHTTP = createObject("COM", "Microsoft.XMLHTTP");
> > >
> > > The code below creates an array and assigns it to the variable
> > > "objURL" if I am correct
> > > objURL = objXMLDOM.getElementsByTagName("url");
> > >
> > > However I can't seem to refence to it, neither with
> > > objURL(i).text); nor with
> > > objURL[i].text);
> > >
> > > Any ideas?
> > >
> > >
> > >
> > >
> >
> 
~|
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: cfscript object array reference

[Taco Fleur]

Hi Joe,

> Are you using CFMX or CF5? You dont need any COM objects
> for xml parsing in CFMX. Use cfInvoke and xmlParse..

Using CF5

> If you are using CF5 .. objURL[i].text
> Are you sure.. you can't dump a "RESULT" from a COM Objects?

Nope, can't dump COM objects with CFDUMP in CF 5 anyway.

I tried [] instead of ()
I used the code in VB in which it is objURL(i).text but when moving it over
to CF with cfscript it just won't work with either () or []...
kinda drives me nuts..

> > > > objURL = objXMLDOM.getElementsByTagName("url");
>
> I dont think objURL is an array..
> sounds like
>  xarr=arrayNew(1);
>  xarr[1]=structNew();
>  xarr[1].FirstName="Taco";
>  xarr[1].LastName="Fleur";
>
> Then you can call something like you did xarr[1].FirstName (== "Taco")
>
> Joe Eugene




~|
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: CF-Talk: Digest every 6 hours

[Robby L.]

Sorry about the late reply, thanks Stephen, worked like a charm.
Peter, you requested the correct code when it was found . it's below :o).

One more question regarding xml /cfmx, is I may..

I have the following loop..



for (i=1; i lte arraylen(count_dropdowns_t); i=i+1) {
//count_dropdowns_t is the parent's xmlchildren array
thisElement2 = StructNew();
thisElement2 = count_dropdowns_t[i];
//
if (thisElement2.xmlattributes["name"] is "#ivan#"){
//

 trythis = XmlElemNew(mydrop,"drop_item");
 structinsert(trythis,"xmltext","new model");
 arrayappend(thiselement2,trythis);
 }

}


I'm trying to add an element where the attributes.name is #ivan#
Following the references I've seen, (docs, nate's xml/xslt pdf, this looks 
right.. But it keeps comming back as "trythis" is undefined.. is there a 
syntax error I'm missing or something? (the error line is on the 
structinsert()line, ) My looking at the example in the pdf, mine is 
essentially the same abiet it's not in cfset tags

Shed any light?
Robby


 trythis= XmlElemNew(mydrop,"drop_item");
 structinsert(trythis,"xmltext","new model");
 arrayappend(thiselement2,trythis);*/
 }

}

Subject: xml woes
From: "Stephen Moretti" Date: Mon, 17 Feb 2003 11:55:10 -
Robby,

I suspect this is probably a typo, but the closing tag of your xml packet
isn't a closing tag.

>Both of which bail.. the first one bails without an actual error,
>. just the araydeleteat() being the line it error'd at.
>But when I looked in to the logs,
>It says java.lang.IndexOutOfBoundsException and searching google only gave
>two results,
>. both of which have no bearing on the situation at hand.
>

Basically, this means that CF is trying to access a element in an array,
past the end of the array.  eg.  there are 2 elements in the array and you
are trying to access the third element.
Looking at your code.  The reason for this is that you are using the "yes"
variable to store an array in both your outer "i" loop and your inner "j"
loop.  You need to use different variables for each loop, otherwise you'll
be overwriting your outer array everytime you go around your inner array.

Also, I suspect that you are trying to delete the wrong bit of your array.
You need to be

Try this : (I warn you there maybe errors.  I typed this from your code and
off the top of my head without testing it)


// Loop over the children of c_dropx eg.  and 
for (i=1; i lte arraylen(c_dropx); i=i+1) {
// bung the structure for the current element into a new variable for ease
thisElement = StructNew();
thisElement = c_dropx[i];
// Check the attributes of thisElement to see it is abba.
if (thisElement.xmlattributes["name"] is "abba")
//  Loop over the children for thisElement, which would be the same as
looping over the  elements
 for (j=1;j lte arraylen(thisElement.xmlChildren); j=j+1) {
// Store the current child structure in a variable thisChild for
ease
thisChild = StructNew();
thisChild = thisElement.xmlchildren[j];
if (thisChild.xmltext is "a") {
   WriteOutput(j&" - "&thisChild.xmltext&"");
arraydeleteat(thisElement.xmlchildren, j);
   }
  }
}



>The element at position 5 of dimension 1, of array variable "TT," cannot
be
>found is the one on the second try,  and with it, the array itself is
cfdumped, and
>there is 5 elements in the array, I've read the docs
>I've double checked what I know how. What the hell am I doing wrong?

To be honest, I'm not sure what's up with your second bit of code.   I
really need to play with xml in CFMX some more, but here's the cfscript
version of your code.  I suspect, that you have the same problem here as you
do above, where you are trying to delete the array from the wrong place in
the data structure.


for (i=1;i lte arraylen(tt); i=i+1) {
   if (tt[i].xmltext is "a") {
  arraydeleteat(tt, i);
   }
}


Hope some of this helps some how.

Regards

Stephen




~|
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: anti-cfflush

[mark brinkworth]

In CFMX you could do this



Cheers,
Mark



 --- Hugo Ahlenius <[EMAIL PROTECTED]> wrote: >
Hi,
> 
> Am I missing something... ? If I may, please direct
> me to where I can do
> my homework...
> 
> I thought it would be natural to have a tag that
> just deletes the current
> rendered page from memory, and starts off again.
> Kind of like cfflush,
> which flushes the page to the client, but instead
> flushes it from memory.
> 
> Does it make sense?
> 
> 
> 
> 
> 
>

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

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

Re: anti-cfflush

[Jochem van Dieten]

Hugo Ahlenius wrote:
> 
> I thought it would be natural to have a tag that just deletes the current
> rendered page from memory, and starts off again. Kind of like cfflush,
> which flushes the page to the client, but instead flushes it from memory.



Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

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

RE: anti-cfflush

[Hugo Ahlenius]

Thanks,

I knew it wouldn't be too hard! This way I can ensure that the XML
declaration (for XHTML pages) gets on top, without having to worry about
white-spaces before!





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

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

Re: anti-cfflush

[mark brinkworth]

Dang, forgot about that way
> 
> 
> 
> Jochem


__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
~|
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

Generate Error Log

[Scott Wilhelm]

Is there a log generated for errors within a site?  If not, how can I go
about creating one myself?
 
Thanks,
 
Scott
 
Scott Wilhelm
Computer Technician/Web Developer
St. Lawrence-Lewis BOCES
PO Box 231, Outer State Street
Canton, NY 13617

P. 315-386-4504 x 164
F. 315-386-3395
W.   http://www.sllboces.org
E.[EMAIL PROTECTED] 

 

~|
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: Generate Error Log

[Bruce Sorge]

If you are referring to CFMX Logs, they are typically stored in
C:\CFusionMX\logs.
- Original Message -
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 7:46 AM
Subject: Generate Error Log


> Is there a log generated for errors within a site?  If not, how can I go
> about creating one myself?
>
> Thanks,
>
> Scott
>
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
>
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[EMAIL PROTECTED]
>
>
>
> 
~|
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: Generate Error Log

[Clint]

ColdFusion has an error log file that you can view through CF Admin.

Clint

- Original Message -
From: "Scott Wilhelm" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 7:46 AM
Subject: Generate Error Log


> Is there a log generated for errors within a site?  If not, how can I go
> about creating one myself?
>
> Thanks,
>
> Scott
>
> Scott Wilhelm
> Computer Technician/Web Developer
> St. Lawrence-Lewis BOCES
> PO Box 231, Outer State Street
> Canton, NY 13617
>
> P. 315-386-4504 x 164
> F. 315-386-3395
> W.   http://www.sllboces.org
> E.[EMAIL PROTECTED]
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Automatic File Download

[Mark Leder]

Hi All,
I have a script (listed below) that when run allows a file to be downloaded
to a client machine.  In IE 5+ it works great.  However, in NS 6-7 the file
extension .cfm wants to append itself to the end of the file (in this case a
.pdf).  Any way to stop this appending?
===





























==
Thanks, Mark 

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

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

Inserting into MySQL database

[FlashGuy]

Hi,

I have nine variables that I want inserted into my database.


Insert into myresults
(strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize, strDirectory, 
strDateCommand, strUsername)
VALUES
('#Filename#', )
('#FileCommand#', )

...and so on...



Is this the correct syntax? Is there an easier way?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---



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

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

OT: possible to open new window on CF_MsMenu?

[Janine Jakim]

Is anyone using MsMenu?
Is there a way to get the link to open a new window?  I haven't had any luck
doing it this way. I'm assuming that it can't be done since the tag is using
js.
Thanks,
J
~|
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: possible to open new window on CF_MsMenu?

[Robertson-Ravo, Neil (RX)]

Haven't used it,  but I would assume there is a 'target' option and you
simply tell it to open _blank

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: 24 February 2003 14:31
To: CF-Talk
Subject: OT: possible to open new window on CF_MsMenu?


Is anyone using MsMenu?
Is there a way to get the link to open a new window?  I haven't had any luck
doing it this way. I'm assuming that it can't be done since the tag is using
js.
Thanks,
J

~|
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: Inserting into MySQL database

[Jochem van Dieten]

FlashGuy wrote:
> 
> 
> Insert into myresults
> (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize, 
> strDirectory, strDateCommand, strUsername)
> VALUES
> ('#Filename#', )
> ('#FileCommand#', )
> 
> ...and so on...
> 
> 

> Is this the correct syntax?

No: http://www.mysql.com/doc/en/INSERT.html


INSERT INTO myresults (
   strFileName,
   strCommand,
   strCreatedOn,
   strLastAcc,
   strLastMod,
   strSize,
   strDirectory,
   strDateCommand,
   strUsername
   )
VALUES (
   ,
   ,
   ...,
   ...,
   ...,
   ...,
   ...,
   ...,
   ...
   )



> Is there an easier way?

No.

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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

OT - JS Question

[Tangorre, Michael]

Hey everyone, sorry for the OT post, but I figure someone might have a solution to my 
problem.
 
I need a way to alert the user that they have made changes to one or more form fields 
if they attempt to exit the page before saving.
 
does anyone know of a quick solution to this?
 
Thanks,
 
Mke

~|
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: OT - JS Question

[Scott Wilhelm]

Maybe set a hidden field up in the form, and have an onChange refer to a
function that will update that hidden field so that if it changes it
would change it from change=no to change=yes.  Then, put an onExit (or
onUnload...can't remember which off the top of my head), to refer to
another function that will check this field.  If it's change=no, then it
closes.  If it's change=yes, then it will alert the user with a yes/no
box.  Then go from there.

HTH.

Scott

> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 10:11 AM
> To: CF-Talk
> Subject: OT - JS Question
> 
> 
> Hey everyone, sorry for the OT post, but I figure someone 
> might have a solution to my problem.
>  
> I need a way to alert the user that they have made changes to 
> one or more form fields if they attempt to exit the page 
> before saving.
>  
> does anyone know of a quick solution to this?
>  
> Thanks,
>  
> Mke
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT - JS Question

[David Collie (itndac)]

var bChangeFlag = False;

function udfFlagChange() {
bChangeFlag = True;
}

function udfCheckChange() {
if (bChangeFlag == True) {
alert('You changed somethings');
return false;
} else {
return true;
}
}




Every input element would have onChange="udfFlagChange()" attribute added to it

Above is very hacked and don't know if the returning false from the onUnload will work 
in not letting them move on the page... also in my experience, onChange doesn't work 
too well either

onUnload doesn't work very well anyways

dc

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 24 February 2003 15:11
To: CF-Talk
Subject: OT - JS Question


Hey everyone, sorry for the OT post, but I figure someone might have a solution to my 
problem.
 
I need a way to alert the user that they have made changes to one or more form fields 
if they attempt to exit the page before saving.
 
does anyone know of a quick solution to this?
 
Thanks,
 
Mke


~|
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: anti-cfflush

[Paul Hastings]

> 

i suppose i should know this but what else is hungoff of getPageContext()?
its kind of lacking in terms of docs.

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

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

OT: js popup widow width

[Ewok]

hi, this is sorta OT i guess but I saw something the other day about
dynamically resizing popup widows with window.resizeTo

~|
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

Server.log file

[David Brown]

We are getting time outs on our server.  They are getting worse as time goes by. One 
user while using Windows 2k IE 5.00.3502 can not even load the page.  But other users 
have no problem at all.  Could this be a browser issue or the server.

Below is a snip of our server log.

"Fatal","2216","02/24/03","10:17:13",,"Unresponsive thread threshold reached. 
Restarting service."
"Information","2304","02/24/03","10:17:17",,"The ColdFusion Application Server 
started."
"Warning","2288","02/24/03","10:23:18",,"A request exceeded the timeout. The 
unresponsive thread count is up to 1. "Error","2288","02/24/03","10:23:18",," !!  
CFTrace::logThread(1560) has no entry for thread 1560"
"Information","1560","02/24/03","10:23:18",,"A long-running request returned. The 
unresponsive thread count is down to 0. "Warning","2288","02/24/03","10:23:48",,"A 
request exceeded the timeout. The unresponsive thread count is up to 1. 
"Error","2288","02/24/03","10:23:48",," !!  CFTrace::logThread(1560) has no entry for 
thread 1560"
"Information","1560","02/24/03","10:23:49",,"A long-running request returned. The 
unresponsive thread count is down to 0. 

Where do I start to fix this?  


~|
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: anti-cfflush

[Andre Mohamed]

You probably want to refer to the JSP specs here:
http://java.sun.com/products/jsp/download.html#specs

to get the best understanding of full capabilities of the Page Context
object.

Thanks,

André

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 24 February 2003 15:26
To: CF-Talk
Subject: Re: anti-cfflush

> 

i suppose i should know this but what else is hungoff of
getPageContext()?
its kind of lacking in terms of docs.


~|
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: anti-cfflush

[Andre Mohamed]

More specifically, see here:

http://java.sun.com/j2ee/sdk_1.3/techdocs/api/javax/servlet/jsp/PageCont
ext.html

Thanks,

André

-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED] 
Sent: 24 February 2003 15:26
To: CF-Talk
Subject: Re: anti-cfflush

> 

i suppose i should know this but what else is hungoff of
getPageContext()?
its kind of lacking in terms of docs.


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

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

OT: js popup window width ...trying this again

[Ewok]

cntrl enter gets me everytime, im used to typing in access columns : )
anyway, hers the finsihed message...

i saw the other day how you could resize popup windows with window.resieTo
I need to just resize the width so there is no scrolling
im using the following fucntion to call my pop ups



i used the resizeto on the popupos bony
onload="window.resizeTo(document.body.scrollWidth);" but it doesnt seem to
be working without the scrollHeight (which i dont want to change) any
ideas?

~|
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

Request for Comment

[LI, Chunshen .Don.]

Greetings to all,

First of all, I have to say, there are times that I
may seem to be "a bull in chinashop", so, for that I
want to hit myself in the head a couple of times :)

Here's an ad hoc query tool designed and developed in
Cold Fusion for MS SQL Server (7,2000), Oracle(8x and
9x) and IBM DB2 UDB (7x and 8x). 

Please take a look at URL,
http://www.hegelsoftware.com/regURL.htm, 
and kindly let me know your thoughts and/or comments.

If interested in advanced features such as
multi-DBMSs, multi-dbs, semantic translation, XML,
reporting, data dice/slice etc. drop me a line.


Cheers,

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

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

Re: FREE BlueDragon Server Released!

[Thomas Chiverton]

On Saturday 22 Feb 2003 17:10 pm, Vince Bonfanti wrote:

> The only conflict to watch out for is when you go to install a web server
> adapter to IIS or Apache--in that case you can only have one of
> BlueDragon/CFMX/CF5 attached to the web server.

But you can just use ProxyPass or mod_rewrite to map the server on port 8500 
into the URI space of your port 80 Apache server, so it's not much of an 
issue.

-- 
Tom C

Unanswered Questions #6:
 Who created the Universe ?

~|
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: RE: OT - JS Question

[ksuh]

The onUnload event doesn't bubble, which means that you can't abort the operation of 
the page using onUnload.

IE has an event called onBeforeUnload that does what you need, but it always displays 
a confirmation box, and you can only add text to the box - there's fixed text on it 
that's always displayed.

- Original Message -
From: "David Collie (itndac)" <[EMAIL PROTECTED]>
Date: Monday, February 24, 2003 8:23 am
Subject: RE: OT - JS Question

> 
> var bChangeFlag = False;
> 
> function udfFlagChange() {
>   bChangeFlag = True;
> }
> 
> function udfCheckChange() {
>   if (bChangeFlag == True) {
>   alert('You changed somethings');
>   return false;
>   } else {
>   return true;
>   }
> }
> 
> 
> 
> 
> Every input element would have onChange="udfFlagChange()" 
> attribute added to it
> 
> Above is very hacked and don't know if the returning false from 
> the onUnload will work in not letting them move on the page... 
> also in my experience, onChange doesn't work too well either
> 
> onUnload doesn't work very well anyways
> 
> dc
> 
> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: 24 February 2003 15:11
> To: CF-Talk
> Subject: OT - JS Question
> 
> 
> Hey everyone, sorry for the OT post, but I figure someone might 
> have a solution to my problem.
> 
> I need a way to alert the user that they have made changes to one 
> or more form fields if they attempt to exit the page before saving.
> 
> does anyone know of a quick solution to this?
> 
> Thanks,
> 
> Mke
> 
> 
> 
~|
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: FBX3 AND CFMX

[John Paul Ashenfelter]

Granted, if a developer were to
> totally rework the core files, some issues might arise; however, just
> deviating from the methodology in some ways doesn't make it more
> difficult to follow. Besides, most developers don't fiddle around with
> the core files.

This is the actual issue I *was* talking about. All the really good FB
developer I've worked with *have* modded the core file. And it's
encouraged -- look at Hal's whitepaper on adding fbx_permissions for his
CF_Secure tag. Or John and Hal building FuseQ. Or Nat and Erik adding
error-trapping to FEX. Or the new work for "FBMX".

Core file mods often make sense. Some of the error trapping in the core is
misleading. Some basic things are just left out (on purpose) like security,
error handling, organizing custom functions/objects by directory, etc. And
some folks tweak it to squeeze out more performance. There are a lot of
reasons to mod the core files -- but no good battery of tests to ensure
compatibility. I moved several apps from Fusebox.org FB3 to FuseQ and there
were surprises -- errors that weren't there before. Easy ones to fix, but
errors none the less. And there were also cases were code errors resulted in
completely different error messages on the two different versions.

Bastardized fusebox is simply that -- bastardized fusebox. It's sort of
saying the application is "sort of MVC" or that the database is "sort of
backed up" -- it is or it isn't. But the bigger issue remains -- there's not
an organized development effort of Fusebox like many other open source
projects and thus there's no way to maintain and extend a single core.
Instead, each developer does their own thing.

That said, I'll reemphasize that it's easier to big a decent methodology of
the shelf and get the project done instead of trying to build your own. FB3
is a great contribution to CF for that reason alone.

John Paul Ashenfelter


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

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

Re: Old Version of CF $erver

[John Paul Ashenfelter]

Macromedia will still sell CF5 -- you can get it from their online store. Of
course is $1299 (same as CFMX)...
Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Michael Pool" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, February 22, 2003 10:07 AM
Subject: Old Version of CF $erver


> Anybody out there know a place I can get ahold of an old copy of CF Server
5 or less? I have a new boss that won't spring for CFMX and he want's me to
build a huge Intranet document/information management system.
>
> All in all I am looking for ANY cheap routes to getting CF on this server
(what a tight ass this guy is!this is a Billion dollar contract and he
is worried about $700!!).
>
> ANY help you can give me would be greatly appreciated.
>
> Believe me, I have tried to convince him to buy me the new version of the
server, to no avail. There has got to be a way I can get this thing running
inexpensively. I'm only going to have about 75 users on this Intranet (if
that) but, this app could carry over to many other installations around the
world if I can make it fly. (this means lots of CFMX sales...and I mean
LOTS! Plus, lots of CF Programmer jobs for all of us!!!)
>
> I know about the single user version, but that is not going to work...I
need a cheap, legal, workable solution to this.
>
> Thank's CF Peeps.
>
> Tryin' to keep the faith
> M.Pool
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: FREE BlueDragon Server Released!

[Dave Watts]

> > The only conflict to watch out for is when you go to 
> > install a web server adapter to IIS or Apache--in that 
> > case you can only have one of BlueDragon/CFMX/CF5 
> > attached to the web server.
> 
> But you can just use ProxyPass or mod_rewrite to map the 
> server on port 8500 into the URI space of your port 80 
> Apache server, so it's not much of an issue.

You don't even have to do that. You can just enable BlueDragon or CFMX or
CF5 within specific virtual servers or directories, on Apache or IIS.

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

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

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

Re: FBX3 AND CFMX

[ksuh]

Keep in mind that frameworks in any platform/language often get customized by end 
developers.  Gawd knows how many bastardized versions of Struts are out there...

Expect a "shrink-wrapped" framework to be customized.

- Original Message -
From: John Paul Ashenfelter <[EMAIL PROTECTED]>
Date: Monday, February 24, 2003 9:20 am
Subject: Re: FBX3 AND CFMX

> Granted, if a developer were to
> > totally rework the core files, some issues might arise; however, 
> just> deviating from the methodology in some ways doesn't make it more
> > difficult to follow. Besides, most developers don't fiddle 
> around with
> > the core files.
> 
> This is the actual issue I *was* talking about. All the really 
> good FB
> developer I've worked with *have* modded the core file. And it's
> encouraged -- look at Hal's whitepaper on adding fbx_permissions 
> for his
> CF_Secure tag. Or John and Hal building FuseQ. Or Nat and Erik adding
> error-trapping to FEX. Or the new work for "FBMX".
> 
> Core file mods often make sense. Some of the error trapping in the 
> core is
> misleading. Some basic things are just left out (on purpose) like 
> security,error handling, organizing custom functions/objects by 
> directory, etc. And
> some folks tweak it to squeeze out more performance. There are a 
> lot of
> reasons to mod the core files -- but no good battery of tests to 
> ensurecompatibility. I moved several apps from Fusebox.org FB3 to 
> FuseQ and there
> were surprises -- errors that weren't there before. Easy ones to 
> fix, but
> errors none the less. And there were also cases were code errors 
> resulted in
> completely different error messages on the two different versions.
> 
> Bastardized fusebox is simply that -- bastardized fusebox. It's 
> sort of
> saying the application is "sort of MVC" or that the database is 
> "sort of
> backed up" -- it is or it isn't. But the bigger issue remains -- 
> there's not
> an organized development effort of Fusebox like many other open source
> projects and thus there's no way to maintain and extend a single core.
> Instead, each developer does their own thing.
> 
> That said, I'll reemphasize that it's easier to big a decent 
> methodology of
> the shelf and get the project done instead of trying to build your 
> own. FB3
> is a great contribution to CF for that reason alone.
> 
> John Paul Ashenfelter
> 
> 
> 
~|
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: FREE BlueDragon Server Released!

[samcfug]

| 
| You don't even have to do that. You can just enable BlueDragon or CFMX or
| CF5 within specific virtual servers or directories, on Apache or IIS.
| 
| Dave Watts, CTO, Fig Leaf Software
| http://www.figleaf.com/
| voice: (202) 797-5496
| fax: (202) 797-5444
| 


I would be interested in seeing more details on this "feature"
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

Re: unexpeted result with cfqueryparam

[Dina Hess]

> 
> 
> INSERT INTO table (field)
> VALUES (>
> 
>
> Make the value anything you want, quotes, backslashes etc., it will work.

I did...and it doesn't. But I think I know why now.

The inserted data has to be passed directly from an HTML form to
CFQUERYPARAM.  In other words, you can't set the value directly using CFSET
and get the results you expect. But if you enter the value in an INPUT box
and send it directly to CFQUERYPARAM, it works great.

I've been using CFQUERYPARAM successfully for some time now. When I looked
at my code, I noticed that when I'm inserting form values into the DB, I
don't use any functions at all to wrap the form variables in the VALUE
attribute. But when I output, I wrap the DB values with both
HTMLEditFormat() and Trim(). There are all kinds of special characters in
the values I'm displaying, including single quotes. But this method of
handling the data seems to work very well.

> And if you leave the trim() out it will be abc's again. trim() should
> not influence the number of quotes, only the numer of spaces at the
> beginning and end of the string.

I agree that Trim() should not influence a single quote. Nor should
HTMLEditFormat(). But both do, even without CFQUERYPARAM.

Why?

> For a peak at the java behind the scenes, take a look at
> http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=23

Thanks for the link, Jochem...very helpful. I now have a much better
understanding of how Java uses JDBC to interact with a database
behind-the-scenes.

~Dina




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

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

RE: FREE BlueDragon Server Released!

[Dave Watts]

> > You don't even have to do that. You can just enable 
> > BlueDragon or CFMX or CF5 within specific virtual 
> > servers or directories, on Apache or IIS.
> 
> I would be interested in seeing more details on this 
> "feature"

I've described this more than once on this list, I'm sure, so it's probably
in the archives. Nevertheless, it's not too difficult to do. With IIS, you
can use wsconfig to configure CFMX to work with an individual virtual
server; what this does is configure either an ISAPI filter or extension to
work with that virtual server, and create a virtual directory called
"JrunScripts", which maps to the same folder that contains the ISAPI DLL.
You can set up CF 5 manually, for a specific virtual server or application,
by mapping the .cfm extension to \CFusion\BIN\ISCF.DLL.

With Apache, you simply put the appropriate directives within a VirtualHost
directive. Here's an example, from my laptop:


ServerAdmin [EMAIL PROTECTED]
DocumentRoot "C:/htdocs/mycf5/"
LoadModule coldfusion_module modules/mod_coldfusion.so 
AddHandler type-coldfusion cfm dbm



ServerAdmin [EMAIL PROTECTED]
DocumentRoot "C:/htdocs/mycfmx/"
# JRun Settings
LoadModule jrun_module "C:/CFusionMX/runtime/lib/wsconfig/2/mod_jrun20.so"

JRunConfig Verbose false
JRunConfig Apialloc false
JRunConfig Ssl false
JRunConfig Ignoresuffixmap false
JRunConfig Serverstore
"C:/CFusionMX/runtime/lib/wsconfig/2/jrunserver.store"
JRunConfig Bootstrap 127.0.0.1:51010
   #JRunConfig Errorurl 
AddHandler jrun-handler .jsp .jws



To make this work on my laptop, with both hosts using the same IP socket, I
added the appropriate entries to my hosts file.

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

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

[Vince Bonfanti]

Yes, this works. I've asked one of our engineers to forward full details to
you to make sure you have BlueDragon set up properly.

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com

> -Original Message-
> From: samcfug [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, February 22, 2003 7:22 PM
> To: CF-Talk
> Subject: Re: hey bluedragoneers :)
> 
> 
> a server running IIS 5.0 with several virtual web sites.
> 
> =
> Douglas White
> group Manager
> mailto:[EMAIL PROTECTED]
> http://www.samcfug.org
> =

~|
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: HTTPS

[Cary Gordon]

The encryption is performed on submission, so the form does not have to be 
an https.  That said, while all of us so called experts might know this, 
the general public does not, and they will be looking for that lock symbol 
on the form page, so you might as well make it a mandatory ssl page anyway.

Cary Gordon
The Cherry Hill Company

At 07:36 AM 2/22/2003 -0600, you wrote:
>For proper security, should your login screen be called using HTTPS as well as
>the action screen or just the login action screen?
>
>http://www.domain.com/login.cfm
>
>Or
>
>https://www.domain.com/login.cfm
>
>Andy


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

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

CFHTTP timeout

[Nick de Voil]

We're using CFHTTP (CFMX) to get PDF documents translated to HTML by Adobe's
online service at http://access.adobe.com/perl/convertPDF.pl .

CFHTTP appears to be finishing reading the output before it's finished
coming back. I don't think it's timing out because we have the timeout set
to 600, both in the CFHTTP tag and in the CF administrator, and it's
generally taking under a minute to process the page.

If I do the HTTP request in my browser, it takes something like 15 seconds
to start showing some output from the Perl script at the other end, then the
rest gets gradually displayed over the next 15 seconds or so.

Is CFHTTP thinking that because it's got *some* output it must have got
*all* of it? Or what?

Thanks

Nick



~|
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: FREE BlueDragon Server Released!

[Christian Cantrell]

On Saturday, February 22, 2003, at 10:24 AM, Vince Bonfanti wrote:

> Note that the BlueDragon implementation is via the new PAGE attribute 
> of the
> CFINCLUDE tag (and not via the GetPageContext function), which allows 
> you to
> include the output of JSP pages or servlets in a CFML page:
>
> BlueDragon also implement a new CFFORWARD tag to do a "server-side 
> redirect"
> equivalent to CFMX's GetPageContext().forward():
>
> BTW, we plan to add support for GetPageContext() in BlueDragon 3.1 in 
> order
> to provide compatibility with CFMX, but we still like our 
> implementation
> better. :-)

ColdFusion now has all three:

-- start includeanything.cfm --


 
 
 getPageContext().include(attributes.page);
 

-- end includeanything.cfm --

-- start forward.cfm --


 
 
 getPageContext().forward(attributes.page);
 

-- end forward.cfm --

Christian

~|
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

URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

I'm evaluating cfmx on j2ee. I use mysql as database and all my date are stored in 
mysql default format, witch is "-mm-dd hh:mm:ss". I'm using the 
Portugues(Brazilian) locale. 

As you know, MYSQL stores DateTime objects in the format "-MM-DD HH:MM:SS". 

When i try to run the code:


Select DateField from  


 (suppose DateVar has the value "2003-02-23 18:34:59 ")
#LsDateFormat("DateVar", 'dd/mm/')# 

it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

the same error is returned if i use the CREATEODBCDateTime function, as follow
#LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns this error:

"{ts '2003-01-07 16:23:09'} " is an invalid date format. 


ALSO, 


#LsDateFormat(temp, 'dd/mm/')#

outputs this:
{ts '2003-02-24 12:52:28'} 02/11/2004 

when the correct date is
24/02/2003 (dd/mm/ format). 


I cant understand why the mysql default date format is not valid anymore. I realy dont 
want to change all my date fields in my database, or change all my code that use dates 
(witch are quite alot). Does anyone knows why CFMX does that and does anyone knows a 
solution? 

Tks alot 

Leonardo
~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Mike Townend]

Drop the quotes...

#LsDateFormat(DateVar, 'dd/mm/')#

Instead of

#LsDateFormat("DateVar", 'dd/mm/')#

HTH




Mikey

=
http://www.phonebin.com
"From Phone to Web in minutes" 


-Original Message-
From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 24, 2003 18:05
To: CF-Talk
Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!


I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
the Portugues(Brazilian) locale. 

As you know, MYSQL stores DateTime objects in the format "-MM-DD
HH:MM:SS". 

When i try to run the code:


Select DateField from  


 (suppose DateVar has the value "2003-02-23
18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')# 

it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

the same error is returned if i use the CREATEODBCDateTime function, as
follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns
this error:

"{ts '2003-01-07 16:23:09'} " is an invalid date format. 


ALSO, 


#LsDateFormat(temp, 'dd/mm/')#

outputs this:
{ts '2003-02-24 12:52:28'} 02/11/2004 

when the correct date is
24/02/2003 (dd/mm/ format). 


I cant understand why the mysql default date format is not valid anymore. I
realy dont want to change all my date fields in my database, or change all
my code that use dates (witch are quite alot). Does anyone knows why CFMX
does that and does anyone knows a solution? 

Tks alot 

Leonardo

~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

opz, it's type error, the code does not have the quotes, sorry =)
  - Original Message - 
  From: Mike Townend 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 3:15 PM
  Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  Drop the quotes...

  #LsDateFormat(DateVar, 'dd/mm/')#

  Instead of

  #LsDateFormat("DateVar", 'dd/mm/')#

  HTH




  Mikey

  =
  http://www.phonebin.com
  "From Phone to Web in minutes" 


  -Original Message-
  From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] 
  Sent: Monday, February 24, 2003 18:05
  To: CF-Talk
  Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  INVALID!


  I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
  stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
  the Portugues(Brazilian) locale. 

  As you know, MYSQL stores DateTime objects in the format "-MM-DD
  HH:MM:SS". 

  When i try to run the code:

  
  Select DateField from  
  

   (suppose DateVar has the value "2003-02-23
  18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')# 

  it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

  the same error is returned if i use the CREATEODBCDateTime function, as
  follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns
  this error:

  "{ts '2003-01-07 16:23:09'} " is an invalid date format. 


  ALSO, 

  
  #LsDateFormat(temp, 'dd/mm/')#

  outputs this:
  {ts '2003-02-24 12:52:28'} 02/11/2004 

  when the correct date is
  24/02/2003 (dd/mm/ format). 


  I cant understand why the mysql default date format is not valid anymore. I
  realy dont want to change all my date fields in my database, or change all
  my code that use dates (witch are quite alot). Does anyone knows why CFMX
  does that and does anyone knows a solution? 

  Tks alot 

  Leonardo

  
~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

Here is the real code:

it reads a TXT file that has {ts '2003-01-07 16:23:09'} as content:



#LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#

Then i got the error: 

"{ts '2003-01-07 16:23:09'} " is an invalid date format. 

That's very wierd, that error was not ocurring in cf5 =/
  - Original Message - 
  From: Mike Townend 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 3:15 PM
  Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  Drop the quotes...

  #LsDateFormat(DateVar, 'dd/mm/')#

  Instead of

  #LsDateFormat("DateVar", 'dd/mm/')#

  HTH




  Mikey

  =
  http://www.phonebin.com
  "From Phone to Web in minutes" 


  -Original Message-
  From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] 
  Sent: Monday, February 24, 2003 18:05
  To: CF-Talk
  Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  INVALID!


  I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
  stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
  the Portugues(Brazilian) locale. 

  As you know, MYSQL stores DateTime objects in the format "-MM-DD
  HH:MM:SS". 

  When i try to run the code:

  
  Select DateField from  
  

   (suppose DateVar has the value "2003-02-23
  18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')# 

  it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

  the same error is returned if i use the CREATEODBCDateTime function, as
  follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns
  this error:

  "{ts '2003-01-07 16:23:09'} " is an invalid date format. 


  ALSO, 

  
  #LsDateFormat(temp, 'dd/mm/')#

  outputs this:
  {ts '2003-02-24 12:52:28'} 02/11/2004 

  when the correct date is
  24/02/2003 (dd/mm/ format). 


  I cant understand why the mysql default date format is not valid anymore. I
  realy dont want to change all my date fields in my database, or change all
  my code that use dates (witch are quite alot). Does anyone knows why CFMX
  does that and does anyone knows a solution? 

  Tks alot 

  Leonardo

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

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

Re: CFHTTP timeout

[Bud]

On 2/24/03, Nick de Voil penned:
>We're using CFHTTP (CFMX) to get PDF documents translated to HTML by Adobe's
>online service at http://access.adobe.com/perl/convertPDF.pl .
>
>CFHTTP appears to be finishing reading the output before it's finished
>coming back. I don't think it's timing out because we have the timeout set
>to 600, both in the CFHTTP tag and in the CF administrator, and it's
>generally taking under a minute to process the page.
>
>If I do the HTTP request in my browser, it takes something like 15 seconds
>to start showing some output from the Perl script at the other end, then the
>rest gets gradually displayed over the next 15 seconds or so.

CFHTTP has a problem with pages that are delivered in steps, such as 
a page that come back with "Please wait while your request is 
processed". It will get that first message and think the page is 
done. Not sure what you can do about it if anything.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

I got it working by this code:





#LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#


Note the cfset tag. Looks like CFMX treats the first dtUltimaAtualizacao as a string 
instead of a DateTime object as CF5 does. 

That's not nice =/. Does anyone have another solution or another tip for that or 
should i really have to put the cfset tag in all my templates that handle dates? 

Thank you. 
(ps, i also have posted this on mm foruns, if i got the solution i will let you guys 
know)
  - Original Message - 
  From: Mike Townend 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 3:15 PM
  Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  Drop the quotes...

  #LsDateFormat(DateVar, 'dd/mm/')#

  Instead of

  #LsDateFormat("DateVar", 'dd/mm/')#

  HTH




  Mikey

  =
  http://www.phonebin.com
  "From Phone to Web in minutes" 


  -Original Message-
  From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] 
  Sent: Monday, February 24, 2003 18:05
  To: CF-Talk
  Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  INVALID!


  I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
  stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
  the Portugues(Brazilian) locale. 

  As you know, MYSQL stores DateTime objects in the format "-MM-DD
  HH:MM:SS". 

  When i try to run the code:

  
  Select DateField from  
  

   (suppose DateVar has the value "2003-02-23
  18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')# 

  it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

  the same error is returned if i use the CREATEODBCDateTime function, as
  follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns
  this error:

  "{ts '2003-01-07 16:23:09'} " is an invalid date format. 


  ALSO, 

  
  #LsDateFormat(temp, 'dd/mm/')#

  outputs this:
  {ts '2003-02-24 12:52:28'} 02/11/2004 

  when the correct date is
  24/02/2003 (dd/mm/ format). 


  I cant understand why the mysql default date format is not valid anymore. I
  realy dont want to change all my date fields in my database, or change all
  my code that use dates (witch are quite alot). Does anyone knows why CFMX
  does that and does anyone knows a solution? 

  Tks alot 

  Leonardo

  
~|
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: FREE BlueDragon Server Released!

[Sean A Corfield]

On Saturday, Feb 22, 2003, at 07:24 US/Pacific, Vince Bonfanti wrote:
> My apologies--CFMX does indeed offer similar capabilities as 
> BlueDragon in
> this regard. It was an oversight on my part, and not a deliberate 
> attempt to
> mislead.

No problem. I expected it was just an oversight. I've been reading 
through the compatibility guide (thank you) to see what other 
enhancements New Atlanta has added.

> Note that the BlueDragon implementation is via the new PAGE attribute 
> of the
> CFINCLUDE tag (and not via the GetPageContext function), which allows 
> you to
> include the output of JSP pages or servlets in a CFML page:
>
> 
> 
>
> BlueDragon also implement a new CFFORWARD tag to do a "server-side 
> redirect"
> equivalent to CFMX's GetPageContext().forward():

Can you obtain the page context object in any way in BlueDragon? I was 
just wondering if there was a way that people could write their JSP 
include/forward so that it was compatible between both products.

> Details of CFINCLUDE, CFFORWARD, and other CFML enhancements 
> introduced by
> BlueDragon (such as the CFIMAP tag) are in the BlueDragon CFML 
> Compatibility
> Guide:

This is a good piece of documentation - I learned some interesting 
things about CF5 from it! It's also good that you point out these 
enhancements and incompatibilities so that developers who are keen to 
write portable code can continue to do so.

> Anyone's who's interested in learning more about the CFML/Java/JSP
> integration features offered by BlueDragon will be interested in 
> attending
> my talk at the upcoming MXNorth conference:

I assume this will cover more ground than your (enjoyable and 
informative) BACFUG talk from a few months back?

> BTW, we plan to add support for GetPageContext() in BlueDragon 3.1 in 
> order
> to provide compatibility with CFMX, but we still like our 
> implementation
> better. :-)

Ah, that answers my question above then. Roll on version 3.1 then!

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Ewok]

>(suppose DateVar has the value "2003-02-23 18:34:59 ")
   it probably does.but your not calling the variable your trying to
change the text value "DateVar" into a date
> #LsDateFormat("DateVar", 'dd/mm/')#

try them without quotes

#LsDateFormat(DateVar, 'dd/mm/')#

#LsDateFormat(CREATEODBCDateTime(Now()), 'dd/mm/')#

good luck

- Original Message -
From: "Leonardo Crespo - Cftop.COM" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1:04 PM
Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!


> I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
the Portugues(Brazilian) locale.
>
> As you know, MYSQL stores DateTime objects in the format "-MM-DD
HH:MM:SS".
>
> When i try to run the code:
>
> 
> Select DateField from 
> 
>
>  (suppose DateVar has the value "2003-02-23
18:34:59 ")
> #LsDateFormat("DateVar", 'dd/mm/')#
>
> it throws an error saying 2003-02-23 18:34:59 is an INVALID date format.
>
> the same error is returned if i use the CREATEODBCDateTime function, as
follow
> #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns this
error:
>
> "{ts '2003-01-07 16:23:09'} " is an invalid date format.
>
>
> ALSO,
>
> 
> #LsDateFormat(temp, 'dd/mm/')#
>
> outputs this:
> {ts '2003-02-24 12:52:28'} 02/11/2004
>
> when the correct date is
> 24/02/2003 (dd/mm/ format).
>
>
> I cant understand why the mysql default date format is not valid anymore.
I realy dont want to change all my date fields in my database, or change all
my code that use dates (witch are quite alot). Does anyone knows why CFMX
does that and does anyone knows a solution?
>
> Tks alot
>
> Leonardo
> 
~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

The mega wierd part is that if i run the code:




 yes

 no


#LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#

It returns TRUE (yes) for the cfif condition (it is a DateTime object) but the 
LSDateFormat does not work (error "{ts '2003-01-07 16:23:09'} " is an 
invalid date format. )

i realy need to add the line: 


befor the #LsDate function... That's wierd and definitly not nice =/. Maybe i should 
post a bug @ MM page.


  - Original Message - 
  From: Leonardo Crespo - Cftop.COM 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 3:31 PM
  Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  I got it working by this code:

  

  

  #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#


  Note the cfset tag. Looks like CFMX treats the first dtUltimaAtualizacao as a string 
instead of a DateTime object as CF5 does. 

  That's not nice =/. Does anyone have another solution or another tip for that or 
should i really have to put the cfset tag in all my templates that handle dates? 

  Thank you. 
  (ps, i also have posted this on mm foruns, if i got the solution i will let you guys 
know)
- Original Message - 
From: Mike Townend 
To: CF-Talk 
Sent: Monday, February 24, 2003 3:15 PM
Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


Drop the quotes...

#LsDateFormat(DateVar, 'dd/mm/')#

Instead of

#LsDateFormat("DateVar", 'dd/mm/')#

HTH




Mikey

=
http://www.phonebin.com
"From Phone to Web in minutes" 


-Original Message-
From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 24, 2003 18:05
To: CF-Talk
Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!


I'm evaluating cfmx on j2ee. I use mysql as database and all my date are
stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm using
the Portugues(Brazilian) locale. 

As you know, MYSQL stores DateTime objects in the format "-MM-DD
HH:MM:SS". 

When i try to run the code:


Select DateField from  


 (suppose DateVar has the value "2003-02-23
18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')# 

it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. 

the same error is returned if i use the CREATEODBCDateTime function, as
follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')# throwns
this error:

"{ts '2003-01-07 16:23:09'} " is an invalid date format. 


ALSO, 


#LsDateFormat(temp, 'dd/mm/')#

outputs this:
{ts '2003-02-24 12:52:28'} 02/11/2004 

when the correct date is
24/02/2003 (dd/mm/ format). 


I cant understand why the mysql default date format is not valid anymore. I
realy dont want to change all my date fields in my database, or change all
my code that use dates (witch are quite alot). Does anyone knows why CFMX
does that and does anyone knows a solution? 

Tks alot 

Leonardo


  
~|
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

SQL SP3 and CF5 Crashtacular!!!!!

[Buddy]

Hi everyone.
I have been away from the group for a while. I hope all has been going well.
I have a problem and I am hoping that y'all can help me sort it out. We had
an application server and a sql server server running very nicely until the
sql slammer virus hit a few weeks ago, during the chaos of that day the
application server died, of unrelated causes. We moved the application to a
new box (still talking to the same, but newly patched sql server), but it
was unreliable. It kept going down and we were unable to figure out why. So
we moved the code to another box. It did okay there for a while, but as the
load increases a snowball effect starts where there are some unresponsive
threads and then there are more and more and more, and then the cf server
restarts itself and tries again, and it all happens over again. Thinking
that it could be problems on the db box we just replaced that, and we are
still having the same problem. Have any of you guys encountered a similar
problem?

Thanks in advance for your help.
Buddy

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

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

Re: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Ewok]

that is weird
is that actually how it is entered in the text file?

ts '2003-01-07 16:23:09'

including the  [']...

and is this space at the end in there too?
"2003-02-23 18:34:59 ")


- Original Message -
From: "Leonardo Crespo - Cftop.COM" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1:41 PM
Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!


> The mega wierd part is that if i run the code:
>
> 
>
> 
>  yes
> 
>  no
> 
>
> #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#
>
> It returns TRUE (yes) for the cfif condition (it is a DateTime object) but
the LSDateFormat does not work (error "{ts '2003-01-07 16:23:09'}
" is an invalid date format. )
>
> i realy need to add the line:
> 
>
> befor the #LsDate function... That's wierd and definitly not nice =/.
Maybe i should post a bug @ MM page.
>
>
>   - Original Message -
>   From: Leonardo Crespo - Cftop.COM
>   To: CF-Talk
>   Sent: Monday, February 24, 2003 3:31 PM
>   Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
INVALID!
>
>
>   I got it working by this code:
>
>   
>
>   
>
>   #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#
>
>
>   Note the cfset tag. Looks like CFMX treats the first dtUltimaAtualizacao
as a string instead of a DateTime object as CF5 does.
>
>   That's not nice =/. Does anyone have another solution or another tip for
that or should i really have to put the cfset tag in all my templates that
handle dates?
>
>   Thank you.
>   (ps, i also have posted this on mm foruns, if i got the solution i will
let you guys know)
> - Original Message -
> From: Mike Townend
> To: CF-Talk
> Sent: Monday, February 24, 2003 3:15 PM
> Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss)
as INVALID!
>
>
> Drop the quotes...
>
> #LsDateFormat(DateVar, 'dd/mm/')#
>
> Instead of
>
> #LsDateFormat("DateVar", 'dd/mm/')#
>
> HTH
>
>
>
>
> Mikey
>
> =
> http://www.phonebin.com
> "From Phone to Web in minutes"
>
>
> -Original Message-
> From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 18:05
> To: CF-Talk
> Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
> INVALID!
>
>
> I'm evaluating cfmx on j2ee. I use mysql as database and all my date
are
> stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm
using
> the Portugues(Brazilian) locale.
>
> As you know, MYSQL stores DateTime objects in the format "-MM-DD
> HH:MM:SS".
>
> When i try to run the code:
>
> 
> Select DateField from 
> 
>
>  (suppose DateVar has the value
"2003-02-23
> 18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')#
>
> it throws an error saying 2003-02-23 18:34:59 is an INVALID date
format.
>
> the same error is returned if i use the CREATEODBCDateTime function,
as
> follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')#
throwns
> this error:
>
> "{ts '2003-01-07 16:23:09'} " is an invalid date format.
>
>
> ALSO,
>
> 
> #LsDateFormat(temp, 'dd/mm/')#
>
> outputs this:
> {ts '2003-02-24 12:52:28'} 02/11/2004
>
> when the correct date is
> 24/02/2003 (dd/mm/ format).
>
>
> I cant understand why the mysql default date format is not valid
anymore. I
> realy dont want to change all my date fields in my database, or change
all
> my code that use dates (witch are quite alot). Does anyone knows why
CFMX
> does that and does anyone knows a solution?
>
> Tks alot
>
> Leonardo
>
>
>
> 
~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

Yes, the content of the file is: 

{ts '2003-01-07 16:23:09'}

without beginning and ending spaces, and no extra lines, lf or cr. I try to add a trim 
function to strip possible spaces, no sucess :'-(


  - Original Message - 
  From: Ewok 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 3:52 PM
  Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  that is weird
  is that actually how it is entered in the text file?

  ts '2003-01-07 16:23:09'

  including the  [']...

  and is this space at the end in there too?
  "2003-02-23 18:34:59 ")


  - Original Message -
  From: "Leonardo Crespo - Cftop.COM" <[EMAIL PROTECTED]>
  To: "CF-Talk" <[EMAIL PROTECTED]>
  Sent: Monday, February 24, 2003 1:41 PM
  Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  INVALID!


  > The mega wierd part is that if i run the code:
  >
  > 
  >
  > 
  >  yes
  > 
  >  no
  > 
  >
  > #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#
  >
  > It returns TRUE (yes) for the cfif condition (it is a DateTime object) but
  the LSDateFormat does not work (error "{ts '2003-01-07 16:23:09'}
  " is an invalid date format. )
  >
  > i realy need to add the line:
  > 
  >
  > befor the #LsDate function... That's wierd and definitly not nice =/.
  Maybe i should post a bug @ MM page.
  >
  >
  >   - Original Message -
  >   From: Leonardo Crespo - Cftop.COM
  >   To: CF-Talk
  >   Sent: Monday, February 24, 2003 3:31 PM
  >   Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  INVALID!
  >
  >
  >   I got it working by this code:
  >
  >   
  >
  >   
  >
  >   #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/')#
  >
  >
  >   Note the cfset tag. Looks like CFMX treats the first dtUltimaAtualizacao
  as a string instead of a DateTime object as CF5 does.
  >
  >   That's not nice =/. Does anyone have another solution or another tip for
  that or should i really have to put the cfset tag in all my templates that
  handle dates?
  >
  >   Thank you.
  >   (ps, i also have posted this on mm foruns, if i got the solution i will
  let you guys know)
  > - Original Message -
  > From: Mike Townend
  > To: CF-Talk
  > Sent: Monday, February 24, 2003 3:15 PM
  > Subject: RE: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss)
  as INVALID!
  >
  >
  > Drop the quotes...
  >
  > #LsDateFormat(DateVar, 'dd/mm/')#
  >
  > Instead of
  >
  > #LsDateFormat("DateVar", 'dd/mm/')#
  >
  > HTH
  >
  >
  >
  >
  > Mikey
  >
  > =
  > http://www.phonebin.com
  > "From Phone to Web in minutes"
  >
  >
  > -Original Message-
  > From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED]
  > Sent: Monday, February 24, 2003 18:05
  > To: CF-Talk
  > Subject: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as
  > INVALID!
  >
  >
  > I'm evaluating cfmx on j2ee. I use mysql as database and all my date
  are
  > stored in mysql default format, witch is "-mm-dd hh:mm:ss". I'm
  using
  > the Portugues(Brazilian) locale.
  >
  > As you know, MYSQL stores DateTime objects in the format "-MM-DD
  > HH:MM:SS".
  >
  > When i try to run the code:
  >
  > 
  > Select DateField from 
  > 
  >
  >  (suppose DateVar has the value
  "2003-02-23
  > 18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/')#
  >
  > it throws an error saying 2003-02-23 18:34:59 is an INVALID date
  format.
  >
  > the same error is returned if i use the CREATEODBCDateTime function,
  as
  > follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/')#
  throwns
  > this error:
  >
  > "{ts '2003-01-07 16:23:09'} " is an invalid date format.
  >
  >
  > ALSO,
  >
  > 
  > #LsDateFormat(temp, 'dd/mm/')#
  >
  > outputs this:
  > {ts '2003-02-24 12:52:28'} 02/11/2004
  >
  > when the correct date is
  > 24/02/2003 (dd/mm/ format).
  >
  >
  > I cant understand why the mysql default date format is not valid
  anymore. I
  > realy dont want to change all my date fields in my database, or change
  all
  > my code that use dates (witch are quite alot). Does anyone knows why
  CFMX
  > does that and does anyone knows a solution?
  >
  > Tks alot
  >
  > Leonardo
  >
  >
  >
  > 
  
~|
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.7

RE: FREE BlueDragon Server Released!

[Vince Bonfanti]

I'm giving two talks at MXNorth. The first, "Intro to JSP for CFML
Developers" is a slightly updated version of the presentation I gave at
BACFUG in December (I also gave this presentation to the Atlanta CFUG, and
somewhere else I don't remember offhand). This one is on Friday at 2:15 pm.

The second talk is "Integrating CFML and J2EE Web Applications" on Sunday at
1:00 pm. I think I gave a presentation with the same title at CFNorth last
year, but this one is completely different. Last year was all slides and
theory, this one will be mostly practical code examples.

Finally, for anyone who's interested, we'll be demonstrating BlueDragon for
.NET in our booth at MXNorth (the first ever public demonstration).

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com

> -Original Message-
> From: Sean A Corfield [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 11:59 AM
> To: CF-Talk
> Subject: Re: FREE BlueDragon Server Released!
> 
> 
...
> 
> > Anyone's who's interested in learning more about the CFML/Java/JSP 
> > integration features offered by BlueDragon will be interested in 
> > attending my talk at the upcoming MXNorth conference:
> 
> I assume this will cover more ground than your (enjoyable and 
> informative) BACFUG talk from a few months back?
> 
...

~|
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

CF Administrator Settings

[Scott Wilhelm]

I'm looking through some of the settings, and I was wondering what a
good CF5 server setup is.
 
I see that there's single-threaded setting to reduce the need for CFLOCK
(is that good?), etc.  
 
Hints, tips, tricks, etc. would be greatly appreciated!

Scott

Scott Wilhelm
Computer Technician/Web Developer
http://www.sllboces.org  
[EMAIL PROTECTED]

Canton (Mon/Tue)
St. Lawrence-Lewis BOCES
PO Box 231, 139 State Street Road
Canton, NY 13617
P.   315-386-4504 x 164
F.   315-386-3395

Heuvelton (Wed/Thu/Fri)
Heuvelton Central School
PO Box 375, 87 Washington Street
Heuvelton, NY 13654
P.   315-344-2414 x 3651

 
 

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

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

Re: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Jochem van Dieten]

Leonardo Crespo - Cftop.COM wrote:
> 
> That's wierd and definitly not nice =/. Maybe i should post a bug @ MM page.

I think you should. I have always found it weird that "-mm-dd 
hh:mm:ss" (which is one of the 2 formats from ISO-8601) is not an 
officially supported format, but that it behaves differently between 
IsDate() and LSDateFormat() is a bug.

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: unexpeted result with cfqueryparam

[Andrew Tyrone]

> -Original Message-
> From: Dina Hess [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 12:06 PM
> To: CF-Talk
> Subject: Re: unexpeted result with cfqueryparam

> I agree that Trim() should not influence a single quote. Nor should
> HTMLEditFormat(). But both do, even without CFQUERYPARAM.
>
> Why?

I encountered this some years ago for the first time when I was using
Evaluate() on a form field in my cfquery statement; I think this was on CF
4.0.  I can't be sure about this because I haven't performed any tests with
and without cfqueryparam, but I think CF doesn't automatically escape single
quotes if you are performing ANY functions on the variable inline of the
query.  You have to perform all operations on the variable before you use it
in the SQL statement.  The reason for this, I surmise, is that if you are
performing any operations on the variable, CF leaves it alone as it (maybe)
assumes you want to handle all processing of that variable.

--Andy


~|
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

Allowing specific HTML tags to be displayed

[Russ]

All--

I've still not had any luck trying to get Replace or ReReplace to allow
a set of specific codes when displaying information from a database.

I'm hoping to allow for only specific sets:  Italics, Bold, A HREF and
IMG SRC and I'm baffled as to how to get this to work.  It's a bit of a
repost, but I'm really striking out.

Thanks,

Russ

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

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

Re: Allowing specific HTML tags to be displayed

[Matthew Walker]

Are you running CF5 or CFMX?

- Original Message -
From: "Russ" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 8:16 AM
Subject: Allowing specific HTML tags to be displayed


> All--
>
> I've still not had any luck trying to get Replace or ReReplace to allow
> a set of specific codes when displaying information from a database.
>
> I'm hoping to allow for only specific sets:  Italics, Bold, A HREF and
> IMG SRC and I'm baffled as to how to get this to work.  It's a bit of a
> repost, but I'm really striking out.
>
> Thanks,
>
> Russ
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

odbc error 01000 (General Warning)

[Michael Ross]

We have a box win2000 with cf 5 that points to a sql2000 box.  We started noticing a 
lot of these errors that occured randomly

ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP 
Sockets]ConnectionWrite

We tried rebooting, we tried re starting the cf service but it still doesn't go away.  
It started happeneing Saturday then that night the sql team installed sp3 (no relation 
to errors).  After that it got much worse.  I have looked a lot of places but I can't 
seem to figure out what the error means.  Anyone have an idea? 
 

~|
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: Allowing specific HTML tags to be displayed

[Russ]

CFMX

> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 1:20 PM
> To: CF-Talk
> Subject: Re: Allowing specific HTML tags to be displayed
> 
> 
> Are you running CF5 or CFMX?
> 
> - Original Message -
> From: "Russ" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 25, 2003 8:16 AM
> Subject: Allowing specific HTML tags to be displayed
> 
> 
> > All--
> >
> > I've still not had any luck trying to get Replace or 
> ReReplace to allow
> > a set of specific codes when displaying information from a database.
> >
> > I'm hoping to allow for only specific sets:  Italics, Bold, 
> A HREF and
> > IMG SRC and I'm baffled as to how to get this to work.  
> It's a bit of a
> > repost, but I'm really striking out.
> >
> > Thanks,
> >
> > Russ
> >
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

Re: Allowing specific HTML tags to be displayed

[Jerry Johnson]

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

This should get you there.

Jerry Johnson

>>> [EMAIL PROTECTED] 02/24/03 02:16PM >>>
All--

I've still not had any luck trying to get Replace or ReReplace to allow
a set of specific codes when displaying information from a database.

I'm hoping to allow for only specific sets:  Italics, Bold, A HREF and
IMG SRC and I'm baffled as to how to get this to work.  It's a bit of a
repost, but I'm really striking out.

Thanks,

Russ


~|
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

CF Code (Business Rules) in the Presentation Layer (OT?)

[Reilly, James]

We have a repeating patter where we'll need business rules applied in the
presentation layer (mostly via JavaScript for a smart client and some post
form validation on an action page, maybe a call to EBJ), as well as these
same rules applied to flat files that are coming in.  Both need the same
rules applied.  

Anyone have experience at Rules Engines (writing, saving in a common non
language specific format, and applying to CF or JS and also flat files
and/or Java/EBJ)?  Flat files may be read and parsed by Java (or ??), and
apply the rules to right out human readable specific error messages.   

Some rules engines seem more A.I. like, not really what I'm looking for.


Also, anyone know of Tools to buy that will parse and validate large flat
files and apply rules.. (maybe integrate the rules and publish to CF?).


Current Arch Flow Thoughts:
===
HTML/JS ->   CFM->   CFC   -> EJB   ->   Oracle
(JS rules) (cf rules) (cf rules)(java rules)   (db rules)


Want to capture all rules and store in one place, and validate where needed,
but
also use there same rules for flat files  (not shown above, see below)

Thoughts?:
==
Flat File  ->  (converter/map)  ->  Flat File   ->(pgm) ->Oracle
(some rules)(XML???)   (XML Schema) (db
rules)



Currently Have:
===
(XML)->   CFC   ->CF->
HTML/JS HTML/JS
(has some rules)(load xml)(make js/html rules from XML)(js/html
rules)


Need to refine the XML w/ rules and apply w/ Java/EJB  and  a flat file
converter/validator.


Anyone do anything like this?









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

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

BlueDragon Config

[[EMAIL PROTECTED]]

I ahev installed Blue Dragon Server on my WinXP machine at the house with
excellent results, but I have tried to run it at work on our Win2K server
with IIS 5.0 and I have some issues... Maybe one of you know why...

When I hit http://localhost with my machine I get the Blue Dragon Default
page... index.cfm. It works fine, but when I try to hit any other page in
my web, my browser tries to open them as an application... You know..the
Windows Modal opens up asking whether to Save this or open it from it's
locationwhen I select open(like I shouldn't even see this anyhow)
it just closes and nothing happens.

HELP!

M.Pool



~|
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: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

[Leonardo Crespo - Cftop.COM]

Yeah, you're right =/

  - Original Message - 
  From: Jochem van Dieten 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 4:14 PM
  Subject: Re: URGENT, cfmx interprets MYSQL date (-mm-dd hh:mm:ss) as INVALID!


  Leonardo Crespo - Cftop.COM wrote:
  > 
  > That's wierd and definitly not nice =/. Maybe i should post a bug @ MM page.

  I think you should. I have always found it weird that "-mm-dd 
  hh:mm:ss" (which is one of the 2 formats from ISO-8601) is not an 
  officially supported format, but that it behaves differently between 
  IsDate() and LSDateFormat() is a bug.

  Jochem

  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

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

SQL: How do I a get list of everybody that doesn't meet a certain criteria

[Kronenberger, Douglas]

I'm stumped. 

I have a table that has multiple courses taken (CourseName) entries  for
each employee (EmpID)

This gets me everybody that took the coures.
SELECT EmpID, CourseName
FROM Course
WHERE CourseName = "Preventing Sexual Harassment"

But how do I get everybody that didn't?

Thanks in advance

Doug Kronenberger

~|
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: How do I a get list of everybody that doesn't meet a certain criteria

[Bryan F. Hogan]

SELECT EmpID, CourseName
FROM Course
WHERE CourseName <> "Preventing Sexual Harassment"


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 2:58 PM
To: CF-Talk
Subject: SQL: How do I a get list of everybody that doesn't meet a
certain criteria


I'm stumped.

I have a table that has multiple courses taken (CourseName) entries  for
each employee (EmpID)

This gets me everybody that took the coures.
SELECT EmpID, CourseName
FROM Course
WHERE CourseName = "Preventing Sexual Harassment"

But how do I get everybody that didn't?

Thanks in advance

Doug Kronenberger


~|
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: How do I a get list of everybody that doesn't meet a certain criteria

[Tony Weeg]

Select EmpID
from course where empId not in

(   SELECT EmpID, CourseName
FROM Course
WHERE CourseName = "Preventing Sexual Harassment"
)

hth

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 24, 2003 2:58 PM
To: CF-Talk
Subject: SQL: How do I a get list of everybody that doesn't meet a
certain criteria


I'm stumped. 

I have a table that has multiple courses taken (CourseName) entries  for
each employee (EmpID)

This gets me everybody that took the coures.
SELECT EmpID, CourseName
FROM Course
WHERE CourseName = "Preventing Sexual Harassment"

But how do I get everybody that didn't?

Thanks in advance

Doug Kronenberger


~|
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: How do I a get list of everybody that doesn't meet a certain criteria

[Mosh Teitelbaum]

Something like:

SELECT EmpID
FROM Course
WHERE EmpID NOT IN (
SELECT EmpID, CourseName
FROM Course
WHERE CourseName = "Preventing Sexual Harassment"
)

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


> -Original Message-
> From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 2:58 PM
> To: CF-Talk
> Subject: SQL: How do I a get list of everybody that doesn't meet a
> certain criteria
>
>
> I'm stumped.
>
> I have a table that has multiple courses taken (CourseName) entries  for
> each employee (EmpID)
>
> This gets me everybody that took the coures.
>   SELECT EmpID, CourseName
>   FROM Course
>   WHERE CourseName = "Preventing Sexual Harassment"
>
> But how do I get everybody that didn't?
>
> Thanks in advance
>
> Doug Kronenberger
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

What is the JDBC type of MYSQL driver included in CFMX to j2ee?

[Leonardo Crespo - Cftop.COM]

That's a quick question, What is the JDBC type of MYSQL driver included in CFMX to 
j2ee?

I'm asking that because i'm wondering if i should use the MYSQL Connector/J witch is a 
TYPE 4 JDBC driver instead if the one included with CFMX to J2EE. 

MYSQL says that it is 50-100% faster than "previous version"... maybe the included 
with CFMX is similar to that "previous version" they're talking about =)

THANK YOU!

Ps: greetings from Brazil =)


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

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

Re: SQL: How do I a get list of everybody that doesn't meet a certain criteria

[Jacob]

WHERE CourseName not like '%Preventing Sexual Harassment%'


At 01:57 PM 2/24/2003 -0600, you wrote:
>I'm stumped.
>
>I have a table that has multiple courses taken (CourseName) entries  for
>each employee (EmpID)
>
>This gets me everybody that took the coures.
> SELECT EmpID, CourseName
> FROM Course
> WHERE CourseName = "Preventing Sexual Harassment"
>
>But how do I get everybody that didn't?
>
>Thanks in advance
>
>Doug Kronenberger
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: How do I a get list of everybody that doesn't meet a certain criteria

[Russ]

That sounds like you're getting everyone who signed up for the course.

If you wanted to get everyone who didn't take the course, you might want
to add another field for 'CourseTaken' or something, but that's just me.

Have you tried simply replace the = with <>  ?

Russ

> -Original Message-
> From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 1:58 PM
> To: CF-Talk
> Subject: SQL: How do I a get list of everybody that doesn't 
> meet a certain criteria
> 
> 
> I'm stumped. 
> 
> I have a table that has multiple courses taken (CourseName) 
> entries  for
> each employee (EmpID)
> 
> This gets me everybody that took the coures.
>   SELECT EmpID, CourseName
>   FROM Course
>   WHERE CourseName = "Preventing Sexual Harassment"
> 
> But how do I get everybody that didn't?
> 
> Thanks in advance
> 
> Doug Kronenberger
> 
> 
~|
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: How do I a get list of everybody that doesn't meet a certain criteria

[Leonardo Crespo - Cftop.COM]

If you have NULL or "" values for CourseName in your DB for your Employees that hasnt 
build the course you can use that in your where clause (where CourseName IS NULL OR 
CourseName = "". 

But i think you have a Employees table, with all the Employees. You can make a query 
to select all employees form Employees table witch does not have a match in the Course 
table. 

Let me know if i am not making myself clear =) 

Leonardo Crespo
ICQ: 198810
[EMAIL PROTECTED]
  - Original Message - 
  From: Kronenberger, Douglas 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 4:57 PM
  Subject: SQL: How do I a get list of everybody that doesn't meet a certain criteria


  I'm stumped. 

  I have a table that has multiple courses taken (CourseName) entries  for
  each employee (EmpID)

  This gets me everybody that took the coures.
  SELECT EmpID, CourseName
  FROM Course
  WHERE CourseName = "Preventing Sexual Harassment"

  But how do I get everybody that didn't?

  Thanks in advance

  Doug Kronenberger

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

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

Re: How do I a get list of everybody that doesn't meet a certain criteria

[Clint]

Try this:

SELECT EmpID, CourseName
 FROM Course
 WHERE CourseName != "Preventing Sexual Harassment"

- Original Message -
From: "Kronenberger, Douglas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1:57 PM
Subject: SQL: How do I a get list of everybody that doesn't meet a certain
criteria


> I'm stumped.
>
> I have a table that has multiple courses taken (CourseName) entries  for
> each employee (EmpID)
>
> This gets me everybody that took the coures.
> SELECT EmpID, CourseName
> FROM Course
> WHERE CourseName = "Preventing Sexual Harassment"
>
> But how do I get everybody that didn't?
>
> Thanks in advance
>
> Doug Kronenberger
>
> 
~|
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: How do I a get list of everybody that doesn't meet a certain criteria

[Mosh Teitelbaum]

Just mind the ", CourseName" in the inner query.

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


> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 2:53 PM
> To: CF-Talk
> Subject: RE: How do I a get list of everybody that doesn't meet a
> certain criteria
>
>
> Select EmpID
> from course where empId not in
>
> ( SELECT EmpID, CourseName
>   FROM Course
>   WHERE CourseName = "Preventing Sexual Harassment"
> )
>
> hth
>
> ...tony
>
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337
>
> -Original Message-
> From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 2:58 PM
> To: CF-Talk
> Subject: SQL: How do I a get list of everybody that doesn't meet a
> certain criteria
>
>
> I'm stumped.
>
> I have a table that has multiple courses taken (CourseName) entries  for
> each employee (EmpID)
>
> This gets me everybody that took the coures.
>   SELECT EmpID, CourseName
>   FROM Course
>   WHERE CourseName = "Preventing Sexual Harassment"
>
> But how do I get everybody that didn't?
>
> Thanks in advance
>
> Doug Kronenberger
>
>
> 
~|
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: What is the JDBC type of MYSQL driver included in CFMX to j2ee?

[Barney Boisvert]

I believe that CFMX includes a type 4 driver for MySQL, but I'm not 100%
sure.  It would surprise me if they didn't, with CF supposedly positioned
for large-scale  applications.  That being said, it might not be the _best_
MySQL driver available, although I've not had any problems with it
speedwise.

barneyb

> -Original Message-
> From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 11:55 AM
> To: CF-Talk
> Subject: What is the JDBC type of MYSQL driver included in CFMX to j2ee?
>
>
> That's a quick question, What is the JDBC type of MYSQL driver
> included in CFMX to j2ee?
>
> I'm asking that because i'm wondering if i should use the MYSQL
> Connector/J witch is a TYPE 4 JDBC driver instead if the one
> included with CFMX to J2EE.
>
> MYSQL says that it is 50-100% faster than "previous version"...
> maybe the included with CFMX is similar to that "previous
> version" they're talking about =)
>
> THANK YOU!
>
> Ps: greetings from Brazil =)
>
>
> 
~|
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: SQL: How do I a get list of everybody that doesn't meet a certain criteria

[Jochem van Dieten]

Kronenberger, Douglas wrote:
> 
> I have a table that has multiple courses taken (CourseName) entries  for
> each employee (EmpID)
> 
> This gets me everybody that took the coures.
>   SELECT EmpID, CourseName
>   FROM Course
>   WHERE CourseName = "Preventing Sexual Harassment"
> 
> But how do I get everybody that didn't?

I presume you have a table "employees" that has EmpID as the primary 
key. In that case:

SELECT
EmpID
FROM
Employees
WHERE NOT EXISTS (
SELECT
1
FROM
Course
WHERE
CourseName = "Preventing Sexual Harassment"
AND
Course.EmpID = Employees.EmpID
)

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

[Everett, Al]

Shouldn't those be single quotes around the course name?

> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 3:02 PM
> To: CF-Talk
> Subject: Re: SQL: How do I a get list of everybody that doesn't meet a
> certain criteria
> 
> 
> Kronenberger, Douglas wrote:
> > 
> > I have a table that has multiple courses taken (CourseName) 
> entries  for
> > each employee (EmpID)
> > 
> > This gets me everybody that took the coures.
> > SELECT EmpID, CourseName
> > FROM Course
> > WHERE CourseName = "Preventing Sexual Harassment"
> > 
> > But how do I get everybody that didn't?
> 
> I presume you have a table "employees" that has EmpID as the primary 
> key. In that case:
> 
> SELECT
>   EmpID
> FROM
>   Employees
> WHERE NOT EXISTS (
>   SELECT
>   1
>   FROM
>   Course
>   WHERE
>   CourseName = "Preventing Sexual Harassment"
>   AND
>   Course.EmpID = Employees.EmpID
>   )
> 
> 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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

context-sensetive help

[Robert Bailey]

I remember a few years ago using finding and using a great little plug in
for larger applications that allowed for context-sensitive help. It had a
windows type interface to it, looked almost exactly like windows help. I can
not remember where we purchased this, and it has been a few years. Anyone
work with something like this or may be able to help me recall the product?

Thanks!
Robert Bailey
Famous for nothing


~|
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: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

[Leonardo Crespo - Cftop.COM]

Makes no diference for me , using mysql and cfmx on win2k. 
  - Original Message - 
  From: Everett, Al 
  To: CF-Talk 
  Sent: Monday, February 24, 2003 5:12 PM
  Subject: RE: SQL: How do I a get list of everybody that doesn't meet a cer tain 
criteria


  Shouldn't those be single quotes around the course name?

  > -Original Message-
  > From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
  > Sent: Monday, February 24, 2003 3:02 PM
  > To: CF-Talk
  > Subject: Re: SQL: How do I a get list of everybody that doesn't meet a
  > certain criteria
  > 
  > 
  > Kronenberger, Douglas wrote:
  > > 
  > > I have a table that has multiple courses taken (CourseName) 
  > entries  for
  > > each employee (EmpID)
  > > 
  > > This gets me everybody that took the coures.
  > > SELECT EmpID, CourseName
  > > FROM Course
  > > WHERE CourseName = "Preventing Sexual Harassment"
  > > 
  > > But how do I get everybody that didn't?
  > 
  > I presume you have a table "employees" that has EmpID as the primary 
  > key. In that case:
  > 
  > SELECT
  > EmpID
  > FROM
  > Employees
  > WHERE NOT EXISTS (
  > SELECT
  > 1
  > FROM
  > Course
  > WHERE
  > CourseName = "Preventing Sexual Harassment"
  > AND
  > Course.EmpID = Employees.EmpID
  > )
  > 
  > Jochem
  > 
  > 
  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

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

RE: context-sensetive help

[Bryan F. Hogan]

cf_activehelp from Activefeedback.com?


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:04 PM
To: CF-Talk
Subject: context-sensetive help


I remember a few years ago using finding and using a great little plug in
for larger applications that allowed for context-sensitive help. It had a
windows type interface to it, looked almost exactly like windows help. I can
not remember where we purchased this, and it has been a few years. Anyone
work with something like this or may be able to help me recall the product?

Thanks!
Robert Bailey
Famous for nothing



~|
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: odbc error 01000 (General Warning)

[Ben Koshy]

I typically see this when Box A is having trouble or intermittent TCP/IP
trouble communicating with Box B.  Check for:

A) Bad Cables
B) Router/Switch misconfiguration
C) Mismatched Duplexes on the Network Cards (to the Switch)
D) Make sure one of the boxes isn't rebooting randomly & often

Some ideas...

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 24, 2003 11:23 AM
To: CF-Talk
Subject: odbc error 01000 (General Warning)


We have a box win2000 with cf 5 that points to a sql2000 box.  We
started noticing a lot of these errors that occured randomly

ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]ConnectionWrite

We tried rebooting, we tried re starting the cf service but it still
doesn't go away.  It started happeneing Saturday then that night the sql
team installed sp3 (no relation to errors).  After that it got much
worse.  I have looked a lot of places but I can't seem to figure out
what the error means.  Anyone have an idea? 


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

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

political leanings test

[Michael Dinowitz]

http://www.politicalcompass.org/
One of those political spectrum detection tests. Good for a nice heated debate
on the list. :)

My ratings:
Economic Left/Right: -3.25
Authoritarian/Libertarian: -2.56


~|
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: political leanings test

[Michael Dinowitz]

Please disregard. This was supposed to go to CF-Community. Please do not reply
to this on this list. Thank you.


> http://www.politicalcompass.org/
> One of those political spectrum detection tests. Good for a nice heated debate
> on the list. :)
>
> My ratings:
> Economic Left/Right: -3.25
> Authoritarian/Libertarian: -2.56
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Creating Functions

[Scott Wilhelm]

How would I create a function that would let me to create, let's say, a
date drop down...

I'd want to create something where I could specify it something like
this:



In my head,this would generate a select drop down (1-31) with today (24)
selected.

Is this possible?  If so, how would I do it?

Scott

> -Original Message-
> From: Ben Koshy [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 3:24 PM
> To: CF-Talk
> Subject: RE: odbc error 01000 (General Warning)
> 
> 
> I typically see this when Box A is having trouble or 
> intermittent TCP/IP
> trouble communicating with Box B.  Check for:
> 
> A) Bad Cables
> B) Router/Switch misconfiguration
> C) Mismatched Duplexes on the Network Cards (to the Switch)
> D) Make sure one of the boxes isn't rebooting randomly & often
> 
> Some ideas...
> 
> -Original Message-
> From: Michael Ross [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 11:23 AM
> To: CF-Talk
> Subject: odbc error 01000 (General Warning)
> 
> 
> We have a box win2000 with cf 5 that points to a sql2000 box.  We
> started noticing a lot of these errors that occured randomly
> 
> ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]ConnectionWrite
> 
> We tried rebooting, we tried re starting the cf service but it still
> doesn't go away.  It started happeneing Saturday then that 
> night the sql
> team installed sp3 (no relation to errors).  After that it got much
> worse.  I have looked a lot of places but I can't seem to figure out
> what the error means.  Anyone have an idea?   
> 
> 
> 
~|
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: Allowing specific HTML tags to be displayed

[S . Isaac Dealey]

Hey Russ -- I already know what Matt's going to recommend ant that's using
 with an empty prefix value which will allow you to specify a
directory of CF modules to replace the html tags. It's not a bad solution,
however, the problem you're going to have is that you need 1 tag for each
html element someone might type into the form, so ... to avoid that kind of
work-creep, you might want to check out the StripTags() function that can be
found both in the open-source API in my sig and on www.cflib.org.



This syntax will remove any xml-style tag that's not a link (or anchor),
bold, italic or html image tag from the string. Note that it doesn't
currently remove anything but the tags themselves, so given the string
"hello world" it would return "hello world", not "hello ".

You'll probably want to do this _before_ the data goes into the db if
possible because it's a reasonably large function with a lot of string
manipulation.

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

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

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


> Are you running CF5 or CFMX?

> - Original Message -
> From: "Russ" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 25, 2003 8:16 AM
> Subject: Allowing specific HTML tags to be displayed


>> All--
>>
>> I've still not had any luck trying to get Replace or
>> ReReplace to allow
>> a set of specific codes when displaying information from
>> a database.
>>
>> I'm hoping to allow for only specific sets:  Italics,
>> Bold, A HREF and
>> IMG SRC and I'm baffled as to how to get this to work.
>> It's a bit of a
>> repost, but I'm really striking out.
>>
>> Thanks,
>>
>> Russ
>>
>>
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.

>   Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
>   ubscribe.cfm?user=633.558.4


~|
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: political leanings test

[Dave Watts]

> Good for a nice heated debate on the list. :)

This list?

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

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

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

RE: context-sensetive help

[Robert Bailey]

Not what I was thinking, but going to check this one out, thanks!

Thanks!
Robert Bailey
Famous for nothing


-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:26 PM
To: CF-Talk
Subject: RE: context-sensetive help


cf_activehelp from Activefeedback.com?


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:04 PM
To: CF-Talk
Subject: context-sensetive help


I remember a few years ago using finding and using a great little plug in
for larger applications that allowed for context-sensitive help. It had a
windows type interface to it, looked almost exactly like windows help. I can
not remember where we purchased this, and it has been a few years. Anyone
work with something like this or may be able to help me recall the product?

Thanks!
Robert Bailey
Famous for nothing




~|
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: Creating Functions

[Raymond Camden]

It sounds like you want to build a custom tag. For something as broad as
this - the best bet is to read the documentation in the /cfdocs folder.

===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia

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

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

> -Original Message-
> From: Scott Wilhelm [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 2:33 PM
> To: CF-Talk
> Subject: Creating Functions
> 
> 
> How would I create a function that would let me to create, 
> let's say, a date drop down...
> 
> I'd want to create something where I could specify it something like
> this:
> 
> 
> 
> In my head,this would generate a select drop down (1-31) with 
> today (24) selected.
> 
> Is this possible?  If so, how would I do it?
> 
> Scott
> 
> > -Original Message-
> > From: Ben Koshy [mailto:[EMAIL PROTECTED]
> > Sent: Monday, February 24, 2003 3:24 PM
> > To: CF-Talk
> > Subject: RE: odbc error 01000 (General Warning)
> > 
> > 
> > I typically see this when Box A is having trouble or
> > intermittent TCP/IP
> > trouble communicating with Box B.  Check for:
> > 
> > A) Bad Cables
> > B) Router/Switch misconfiguration
> > C) Mismatched Duplexes on the Network Cards (to the Switch)
> > D) Make sure one of the boxes isn't rebooting randomly & often
> > 
> > Some ideas...
> > 
> > -Original Message-
> > From: Michael Ross [mailto:[EMAIL PROTECTED]
> > Sent: Monday, February 24, 2003 11:23 AM
> > To: CF-Talk
> > Subject: odbc error 01000 (General Warning)
> > 
> > 
> > We have a box win2000 with cf 5 that points to a sql2000 box.  We 
> > started noticing a lot of these errors that occured randomly
> > 
> > ODBC Error Code = 01000 (General warning) [Microsoft][ODBC 
> SQL Server 
> > Driver][TCP/IP Sockets]ConnectionWrite
> > 
> > We tried rebooting, we tried re starting the cf service but 
> it still 
> > doesn't go away.  It started happeneing Saturday then that 
> night the 
> > sql team installed sp3 (no relation to errors).  After that it got 
> > much worse.  I have looked a lot of places but I can't seem 
> to figure 
> > out
> > what the error means.  Anyone have an idea? 
> > 
> > 
> > 
> 
~|
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: Creating Functions

[Barney Boisvert]

>From within your custom tag, you can output HTML just like normal.  The code
would look something like this, minus validation and such:


~|
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: political leanings test

[John Stanley]

mine 
Economic Left/Right: -3.75
Authoritarian/Libertarian: -1.54

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:31 PM
To: CF-Talk
Subject: political leanings test


http://www.politicalcompass.org/
One of those political spectrum detection tests. Good for a nice heated
debate
on the list. :)

My ratings:
Economic Left/Right: -3.25
Authoritarian/Libertarian: -2.56



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

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

RE: Creating Functions

[Barney Boisvert]

Whoa, what happened there?  There some sort of filter that'll kill anything
below a long line of dashes on the list server?  Here's the code again,
minus the dashes:



   
  
 
selected="selected">#i#
  
   

   
  
 
selected="selected">#monthAsString(i)#
  
   
 



> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 12:45 PM
> To: CF-Talk
> Subject: RE: Creating Functions
>
>
> From within your custom tag, you can output HTML just like
> normal.  The code
> would look something like this, minus validation and such:
>
>
> 
~|
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: political leanings test

[Scott Wilhelm]

My ratings:
Economic Left/Right: -4.38
Authoritarian/Libertarian: -1.69

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 3:31 PM
> To: CF-Talk
> Subject: political leanings test
> 
> 
> http://www.politicalcompass.org/
> One of those political spectrum detection tests. Good for a 
> nice heated debate
> on the list. :)
> 
> My ratings:
> Economic Left/Right: -3.25
> Authoritarian/Libertarian: -2.56
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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

RE: political leanings test

[John Stanley]

sorry, i saw the repost by Michael after I sent this

-Original Message-
From: John Stanley 
Sent: Monday, February 24, 2003 3:47 PM
To: CF-Talk
Subject: RE: political leanings test


mine 
Economic Left/Right: -3.75
Authoritarian/Libertarian: -1.54

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:31 PM
To: CF-Talk
Subject: political leanings test


http://www.politicalcompass.org/
One of those political spectrum detection tests. Good for a nice heated
debate
on the list. :)

My ratings:
Economic Left/Right: -3.25
Authoritarian/Libertarian: -2.56




~|
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: political leanings test

[Michael Dinowitz]

Not this list. I meant to send this to CF-Community. Please respond to this
thread there. Sorry for the very OT post.


> > Good for a nice heated debate on the list. :)
>
> This list?
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=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: Allowing specific HTML tags to be displayed

[Russ]

I'm looking in to this and realize that I've mis-described what I'm
trying to do.

I don't want the tags to be displayed, instead, I want them to be
actually WORK.

So, if someone does http://www.blinktag.org>blinktag.org
then it shows up in the output the link blinktag.org that will work.
>From the look of the examples in that tag, it doesn't seem that it'll do
that, but I'll continue plugging at it.

Thanks for the suggestion.

Russ

> -Original Message-
> From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 1:24 PM
> To: CF-Talk
> Subject: Re: Allowing specific HTML tags to be displayed
> 
> 
> http://www.cflib.org/udf.cfm?ID=774 
> 
> This should get you there.
> 
> Jerry Johnson
> 
> >>> [EMAIL PROTECTED] 02/24/03 02:16PM >>>
> All--
> 
> I've still not had any luck trying to get Replace or 
> ReReplace to allow
> a set of specific codes when displaying information from a database.
> 
> I'm hoping to allow for only specific sets:  Italics, Bold, A HREF and
> IMG SRC and I'm baffled as to how to get this to work.  It's 
> a bit of a
> repost, but I'm really striking out.
> 
> Thanks,
> 
> Russ
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFHTTP timeout

[Nick de Voil]

Thanks Bud.

Any advance on that, anyone?

> CFHTTP has a problem with pages that are delivered in steps, such as 
> a page that come back with "Please wait while your request is 
> processed". It will get that first message and think the page is 
> done. Not sure what you can do about it if anything.



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

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

RE: Allowing specific HTML tags to be displayed

[Matthew Walker]

Was not! OK, maybe. Actually what I was going to suggest was replacing
the <> on the html tags you want with a control character like chr(27)
then stripping all the tags, then swapping the escaped tags back in.
This was pre-first cup of morning coffee however. Isaac's udf looks
nice. 

> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 25 February 2003 9:43 a.m.
> To: CF-Talk
> Subject: Re: Allowing specific HTML tags to be displayed
> 
> 
> Hey Russ -- I already know what Matt's going to recommend ant 
> that's using
>  with an empty prefix value which will allow you to 
> specify a
> directory of CF modules to replace the html tags. It's not a 
> bad solution,
> however, the problem you're going to have is that you need 1 
> tag for each
> html element someone might type into the form, so ... to 
> avoid that kind of
> work-creep, you might want to check out the StripTags() 
> function that can be
> found both in the open-source API in my sig and on www.cflib.org.
> 
> 
> 
> This syntax will remove any xml-style tag that's not a link 
> (or anchor),
> bold, italic or html image tag from the string. Note that it doesn't
> currently remove anything but the tags themselves, so given the string
> "hello world" it would return "hello world", 
> not "hello ".
> 
> You'll probably want to do this _before_ the data goes into the db if
> possible because it's a reasonably large function with a lot of string
> manipulation.
> 
> hth
> 
> s. isaac dealey954-776-0046
> 
> new epoch  http://www.turnkey.to
> 
> lead architect, tapestry cms   http://products.turnkey.to
> 
> tapestry api is opensource http://www.turnkey.to/tapi
> 
> certified advanced coldfusion 5 developer
> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
> 
> 
> > Are you running CF5 or CFMX?
> 
> > - Original Message -
> > From: "Russ" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 25, 2003 8:16 AM
> > Subject: Allowing specific HTML tags to be displayed
> 
> 
> >> All--
> >>
> >> I've still not had any luck trying to get Replace or
> >> ReReplace to allow
> >> a set of specific codes when displaying information from
> >> a database.
> >>
> >> I'm hoping to allow for only specific sets:  Italics,
> >> Bold, A HREF and
> >> IMG SRC and I'm baffled as to how to get this to work.
> >> It's a bit of a
> >> repost, but I'm really striking out.
> >>
> >> Thanks,
> >>
> >> Russ
> >>
> >>
> > ~~
> > ~~~|
> > Archives:
> > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> > Subscription: http://www.houseoffusion.com/cf_lists/index.
> > cfm?method=subscribe&forumid=4
> > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > This list and all House of Fusion resources hosted by
> > CFHosting.com. The place for dependable ColdFusion
> > Hosting.
> 
> > Unsubscribe: 
> http://www.houseoffusion.com/cf_lists/uns
> > ubscribe.cfm?user=633.558.4
> 
> 
> 
~|
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: Allowing specific HTML tags to be displayed

[Jerry Johnson]

Is it a fairly low volume site?

I have often written the code out to a temp file, and then used cfinclude to pull it 
in. This is mainly used for cf code stored in a db that I want to have executed.

But I still don't quite get what you are trying to do.

It sounds like you have HTML code in a db field.

You want to output that HTML to the screen, and have it work like HTML.

As far as I know (meaning I do it all the time in cf5), you just need to  
the HTML code to the screen, and it will render.

#HTMLCode#

What part are you getting stuck on?

Jerry Johnson

>>> [EMAIL PROTECTED] 02/24/03 03:54PM >>>
I'm looking in to this and realize that I've mis-described what I'm
trying to do.

I don't want the tags to be displayed, instead, I want them to be
actually WORK.

So, if someone does http://www.blinktag.org>blinktag.org
then it shows up in the output the link blinktag.org that will work.
>From the look of the examples in that tag, it doesn't seem that it'll do
that, but I'll continue plugging at it.

Thanks for the suggestion.

Russ

> -Original Message-
> From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
> Sent: Monday, February 24, 2003 1:24 PM
> To: CF-Talk
> Subject: Re: Allowing specific HTML tags to be displayed
> 
> 
> http://www.cflib.org/udf.cfm?ID=774 
> 
> This should get you there.
> 
> Jerry Johnson
> 
> >>> [EMAIL PROTECTED] 02/24/03 02:16PM >>>
> All--
> 
> I've still not had any luck trying to get Replace or 
> ReReplace to allow
> a set of specific codes when displaying information from a database.
> 
> I'm hoping to allow for only specific sets:  Italics, Bold, A HREF and
> IMG SRC and I'm baffled as to how to get this to work.  It's 
> a bit of a
> repost, but I'm really striking out.
> 
> Thanks,
> 
> Russ
> 
> 
> 

~|
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: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

[Jochem van Dieten]

Everett, Al wrote:
>From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
>>
>>SELECT
>>  EmpID
>>FROM
>>  Employees
>>WHERE NOT EXISTS (
>>  SELECT
>>  1
>>  FROM
>>  Course
>>  WHERE
>>  CourseName = "Preventing Sexual Harassment"
>>  AND
>>  Course.EmpID = Employees.EmpID
>>  )
> 
> Shouldn't those be single quotes around the course name?

Not necessarily. Double quotes identify a field, single quotes a value. 
But the example code was with double quotes so I presume he wanted the 
field.

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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

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