Re: CFLOOP question

[Heidi Belal]

How about if you put # sign's around insert_counter in
the first cfswitch expression?
Heidi

--- JB Mentzer <[EMAIL PROTECTED]> wrote:
> Hi all
> 
> I'm attempting to overwrite the index value of a
> CFLOOP from within the
> loop:
> 
>  STEP="1">
> 
> 
> 
> 
>  
>   
>  
> 
>  
>   
>  
> 
> 
> 
> 
> order_ID = "0">  cust_ID = "0">   img_sm =
> "images/gallery/Img0001s.jpg">  "images/gallery/Img0001.jpg">  "07/01/1999">
> 
> order_ID = "0">  cust_ID = "0">   img_sm =
> "images/gallery/altar_s.jpg">  "images/gallery/altar.jpg">  "01/09/2000">
> 
> 
> and so on
> 
> 
> 
> 
> 
> So far, the CFSWITCH's Expression never seems to be
> true. Anyone have
> any ideas on how to make this work?
> 
> Thanks!
> 
> * john *
> 
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Replace #'s Function!!

[bfalloon]

This doesn't work...
Nothing happens... it doesn't throw an error, but the pound symbols remain
in the HTML.



> 
>
> -Original Message-
> From: bfalloon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 11:07 PM
> To: CF-Talk
> Subject: Replace #'s Function!!
>
>
> Hello all,
>
> I've encounter a stumbling block...
>
> I'm performing a CFFILE action to read a text document that contains HTML,
> but I need to remove any # symbols before I can used the code from the
file.
>
> I've included my code below, but the # symbol always throws an error.
> I've also tried double pound signed, but that just seems to completely
> escape the symbol to replace.
>
>  file="d:\code.txt"
> variable="code">
>
> 
> 
>
> In the Replace function I am tried to replace all #'s with nothing...
> It's not working though.
>
> Your help is greatly appreciated!!
>
> Benjamin
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Replace #'s Function!!

[sabrina Lotun]

 #Replace(code, "#chr(35)#", "", "ALL")#

sabrina

  - Original Message - 
  From: bfalloon 
  To: CF-Talk 
  Sent: Thursday, May 10, 2001 10:06 AM
  Subject: Replace #'s Function!!


  Hello all,

  I've encounter a stumbling block...

  I'm performing a CFFILE action to read a text document that contains HTML,
  but I need to remove any # symbols before I can used the code from the file.

  I've included my code below, but the # symbol always throws an error.
  I've also tried double pound signed, but that just seems to completely
  escape the symbol to replace.

  

  
  

  In the Replace function I am tried to replace all #'s with nothing...
  It's not working though.

  Your help is greatly appreciated!!

  Benjamin
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: MS Access JOIN Error

[Heidi Belal]

I don't know if this will help any but you have
missing and mis matched quotes.

"52 log.Supervisor" AS Supervisor, i suppose
Supervisor should have double quotes around it as you
have with the previous variables!

FROM "MPA log" LEFT JOIN "52 log" ON 'MPA log.MPA #' =
'52 log.MPA #'"   what's this last double quote for?!

Heidi



--- [EMAIL PROTECTED] wrote:
> I'm getting the following error when trying to do a
> left join from an Access
> database from CF. I really don't know what I'm
> doing. Any clues would be
> appreciated 
> 
> 
>   Error Diagnostic Information ODBC Error Code =
> S1000 (General error)
> 
> 
>   [Microsoft][ODBC Microsoft Access Driver] Join
> expression not
> supported.  
> 
>   SQL = 
>   "SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA
> Log.MPA #" AS
> MPAnumb, "MPA Log.Position Title" AS PositionTitle,
> "MPA Log.Series", "MPA
> Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA
> Log.Closing Date" AS Close,
> "MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert
> Issued" AS Cert, "MPA
> Log.Status/Comment" AS Comment, "52 log.Supervisor"
> AS Supervisor 
> 
>   FROM "MPA log" LEFT JOIN "52 log" 
>   ON 'MPA log.MPA #' = '52 log.MPA #'"  
> 
>   Data Source = "HRTRACKER"  The error occurred while
> processing an
> element with a general identifier of (CFQUERY),
> occupying document position
> (3:1) to (4:32). Date/Time: 05/09/01 10:06:18
> Browser: Mozilla/4.0
> (compatible; MSIE 5.01; Windows NT 5.0) Remote
> Address: 10.3.193.44
> 
> Thanks in Advance
> 
> > Doug Kronenberger
> > OI National Training and Education Office
> > Depatment of Veterans Affairs
> > 
> > 440-526-3030 x7776
> [EMAIL PROTECTED]
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Clarification

[Peter Tilbrook]

I believe you can. Hopefully supported under the new version of Verity under
CF 5.0. Check out www.verity.com for more info on the Verity SDK.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Parker,
Kevin
Sent: Thursday, 10 May, 2001 1:50 PM
To: CF-Talk
Subject: Clarification


Can someone clarify this for me please. Can I use CF and Verity located at
one URL to index material at another (completely different) URL.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Replace #'s Function!!

[Dylan Bromby]

-Original Message-
From: bfalloon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 11:07 PM
To: CF-Talk
Subject: Replace #'s Function!!


Hello all,

I've encounter a stumbling block...

I'm performing a CFFILE action to read a text document that contains HTML,
but I need to remove any # symbols before I can used the code from the file.

I've included my code below, but the # symbol always throws an error.
I've also tried double pound signed, but that just seems to completely
escape the symbol to replace.






In the Replace function I am tried to replace all #'s with nothing...
It's not working though.

Your help is greatly appreciated!!

Benjamin
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Replace #'s Function!!

[bfalloon]

Hello all,

I've encounter a stumbling block...

I'm performing a CFFILE action to read a text document that contains HTML,
but I need to remove any # symbols before I can used the code from the file.

I've included my code below, but the # symbol always throws an error.
I've also tried double pound signed, but that just seems to completely
escape the symbol to replace.






In the Replace function I am tried to replace all #'s with nothing...
It's not working though.

Your help is greatly appreciated!!

Benjamin



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

structure in request scope

[Mark Ireland]

Could someone tell me how to load a structure into the request scope in the 
application.cfm

once only when a user first visits a page. That is, check that the 
structure is there and dont rerun the query code if it is

unless a change has been made to the database.

Its for the colour scheme of a site.

Thanks


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFLOOP question

[David Shadovitz]

Don't try to change a loop index.

Use a CASE tag to take care of the cases for which an action is required, as 
you do for VALUE="1".  Don't provide a CASE tag for the values for which no 
action is required.

And don't forget the pound signs around the expression: 
EXPRESSION="#insert_counter#"

-David

On Wednesday, May 09, 2001 9:57 AM, JB Mentzer [SMTP:[EMAIL PROTECTED]] 
wrote:
> Hi all
>
> I'm attempting to overwrite the index value of a CFLOOP from within the
> loop:
>
> 
>
> 
> 
>
>  
>   
>  
>
>  
>   
>  
>
> 
>
> 
>  cust_ID = "0">   "images/gallery/Img0001s.jpg">  "images/gallery/Img0001.jpg"> 
> 
>  cust_ID = "0">   "images/gallery/altar_s.jpg">  "images/gallery/altar.jpg"> 
> 
>
> and so on
>
> 
>
> 
>
> So far, the CFSWITCH's Expression never seems to be true. Anyone have
> any ideas on how to make this work?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL help, pretty please...SOLVED

[Erika L Walker]

This approach worked marvelously!!! Thank you very much John and Jim!!!

Erika
(with a *K*)

-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 11:59 PM
To: CF-Talk
Subject: RE: SQL help, pretty please...


Here is a different approach that would find the next conference even if it
was in the same month.

select top 1 CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and conferences.CODATE > (Database function to return todays date i.e.,
getdate(), now())
order by conferences.codate desc

John
with a "h" ;)


-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 10:46 PM
To: CF-Talk
Subject: SQL help, pretty please...


Some pointing in the right direction please

I generate an email based upon a user's attendance of a conference on a
particular day. The email is going to tell the user when the next conference
is.

I pull a list of all conferences.




Here is my SQL statement:

select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) = #nextMonth#
Works great if there is a conference in June (for next month).
But not if the next conference is in say, August.

So,.. I can't see the light hereit's on the tip of my brain, but I'm
having trouble figuring it out. I need to loop through an index of nextMonth
until it matches a month in the conference list, right?

Am I thinking in the right direction?

Signed,
Going Loopy. (yeah, yeah, yeah, I already am!)

Erika
(with a *K*)
-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help, pretty please...

[sabrina Lotun]

hi,

hmm i guess it should be 

select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) >= #nextMonth#


- Sabrina -

  - Original Message - 
  From: Erika L Walker 
  To: CF-Talk 
  Sent: Thursday, May 10, 2001 7:45 AM
  Subject: SQL help, pretty please...


  Some pointing in the right direction please

  I generate an email based upon a user's attendance of a conference on a
  particular day. The email is going to tell the user when the next conference
  is.

  I pull a list of all conferences.

  
  

  Here is my SQL statement:

  select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
  from CONFERENCES, SPEAKERS
  where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
  and COSPEAKER = SPRFNBR
  and month(conferences.CODATE) = #nextMonth#

  Works great if there is a conference in June (for next month).
  But not if the next conference is in say, August.

  So,.. I can't see the light hereit's on the tip of my brain, but I'm
  having trouble figuring it out. I need to loop through an index of nextMonth
  until it matches a month in the conference list, right?

  Am I thinking in the right direction?

  Signed,
  Going Loopy. (yeah, yeah, yeah, I already am!)

  Erika
  (with a *K*)
  -
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL help, pretty please...

[Jim McAtee]

How about:

select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
  and COSPEAKER = SPRFNBR
  and month(conferences.CODATE) > #Month(Now())#

Jim


- Original Message -
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 9:45 PM
Subject: SQL help, pretty please...


> Some pointing in the right direction please
>
> I generate an email based upon a user's attendance of a conference on a
> particular day. The email is going to tell the user when the next
conference
> is.
>
> I pull a list of all conferences.
>
> 
> 
>
> Here is my SQL statement:
>
> select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
> from CONFERENCES, SPEAKERS
> where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
> and COSPEAKER = SPRFNBR
> and month(conferences.CODATE) = #nextMonth#
>
> Works great if there is a conference in June (for next month).
> But not if the next conference is in say, August.
>
> So,.. I can't see the light hereit's on the tip of my brain, but I'm
> having trouble figuring it out. I need to loop through an index of
nextMonth
> until it matches a month in the conference list, right?
>
> Am I thinking in the right direction?
>
> Signed,
> Going Loopy. (yeah, yeah, yeah, I already am!)
>
> Erika
> (with a *K*)


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL help, pretty please...

[John]

Here is a different approach that would find the next conference even if it
was in the same month.

select top 1 CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and conferences.CODATE > (Database function to return todays date i.e.,
getdate(), now())
order by conferences.codate desc

John
with a "h" ;)


-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 10:46 PM
To: CF-Talk
Subject: SQL help, pretty please...


Some pointing in the right direction please

I generate an email based upon a user's attendance of a conference on a
particular day. The email is going to tell the user when the next conference
is.

I pull a list of all conferences.




Here is my SQL statement:

select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) = #nextMonth#
Works great if there is a conference in June (for next month).
But not if the next conference is in say, August.

So,.. I can't see the light hereit's on the tip of my brain, but I'm
having trouble figuring it out. I need to loop through an index of nextMonth
until it matches a month in the conference list, right?

Am I thinking in the right direction?

Signed,
Going Loopy. (yeah, yeah, yeah, I already am!)

Erika
(with a *K*)
-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL 7 Question

[Paul Hastings]

* Team Allaire *
> Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT
> TRANSACTION in another version, but I guess it fell down the proverbial
> crack in this developing application.  (Probably a bad copy/paste ;-)

if you shove a bunch of TSQL statements into one cfquery you have to
enclose them all in SET NOCOUNT ON/OFF block to prevent cf from
thinking its getting valid resultsets everytime sql server sends back "x
rows
selected" messages. in fact, for most sp its a good idea to shave a few ms
here & there...


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Clarification

[Parker, Kevin]

Can someone clarify this for me please. Can I use CF and Verity located at
one URL to index material at another (completely different) URL.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL help, pretty please...

[Erika L Walker]

Some pointing in the right direction please

I generate an email based upon a user's attendance of a conference on a
particular day. The email is going to tell the user when the next conference
is.

I pull a list of all conferences.




Here is my SQL statement:

select CORFNBR, CODATE, COTIME, CONAME, CODESCR, COSPEAKER, COSPECIAL
from CONFERENCES, SPEAKERS
where CORFNBR IN (#ValueList(getconfnumbers.RCCORFNBR)#)
and COSPEAKER = SPRFNBR
and month(conferences.CODATE) = #nextMonth#

Works great if there is a conference in June (for next month).
But not if the next conference is in say, August.

So,.. I can't see the light hereit's on the tip of my brain, but I'm
having trouble figuring it out. I need to loop through an index of nextMonth
until it matches a month in the conference list, right?

Am I thinking in the right direction?

Signed,
Going Loopy. (yeah, yeah, yeah, I already am!)

Erika
(with a *K*)
-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL 7 Question

[Paul Smith]

Thanks! Now that you mention it I did had BEGIN TRANSACTION/COMMIT 
TRANSACTION in another version, but I guess it fell down the proverbial 
crack in this developing application.  (Probably a bad copy/paste ;-)

I happen to have the SQL below within a CFTRANSACTION of 3 CFQUERIES.  They 
take zip time so I guess I should move all SQL inside one CFQUERY and use 
the DB BEGIN/COMMIT TRANSACTION instead.

best, paul

At 10:36 PM 5/9/01 -0400, you wrote:
>The dbms needs to support it, but yeah it's known. I guess the only limit
>would be the amount of time you want that connection open to the database
>server.
>It is not the equivalent to a transaction. I thought so also until Dave
>Watts corrected me a little while ago ;-)
>Each different command between the  tags is it's own seperate
>transaction. Same as in a stored procedure.
>You have (I'm almost sure) three transactions in the below statement. In
>order to make all of the below statements a single transaction, put BEGIN
>TRANSACTION at the beginning, and COMMIT TRANSACTION at the end.
>
>As you have it now, two concurrent users could execute the cfquery at the
>same time, and potentially get unpredictable results. What happens if they
>both hit it at the same time and the two updates run before either of the
>selects? @max is probabaly going to be off...
>
>jon
>- Original Message -
>From: "Paul Smith" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, May 09, 2001 9:36 PM
>Subject: SQL 7 Question
>
>
> > I've been putting one SQL statement after another like the following
>inside
> > a CFQUERY for a while.  Seems to work fine.
> >
> > UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1
> > DECLARE @MAX INT
> > SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients
> > INSERT INTO ClientData(CFID,CFTOKEN)
> > VALUES(@MAX,#CFT#)
> >
> > Is this a known feature?
> >
> > Is there a limit to how many SQL statements can be combined this way?
> >
> > I assume the above is equivalent to a CFTRANSACTION.  Is this so?
> >
> > best,  paul
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL 7 Question

[Jon Hall]

The dbms needs to support it, but yeah it's known. I guess the only limit
would be the amount of time you want that connection open to the database
server.
It is not the equivalent to a transaction. I thought so also until Dave
Watts corrected me a little while ago ;-)
Each different command between the  tags is it's own seperate
transaction. Same as in a stored procedure.
You have (I'm almost sure) three transactions in the below statement. In
order to make all of the below statements a single transaction, put BEGIN
TRANSACTION at the beginning, and COMMIT TRANSACTION at the end.

As you have it now, two concurrent users could execute the cfquery at the
same time, and potentially get unpredictable results. What happens if they
both hit it at the same time and the two updates run before either of the
selects? @max is probabaly going to be off...

jon
- Original Message -
From: "Paul Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 9:36 PM
Subject: SQL 7 Question


> I've been putting one SQL statement after another like the following
inside
> a CFQUERY for a while.  Seems to work fine.
>
> UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1
> DECLARE @MAX INT
> SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients
> INSERT INTO ClientData(CFID,CFTOKEN)
> VALUES(@MAX,#CFT#)
>
> Is this a known feature?
>
> Is there a limit to how many SQL statements can be combined this way?
>
> I assume the above is equivalent to a CFTRANSACTION.  Is this so?
>
> best,  paul
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop question (I think)

[Seamus Campbell]

Many thanks - I was focusing on tblGroups and didn't even think going the 
other way as you have suggested
your first code worked beautifully
thanks again
Seamus


At 11:59 am 10/05/01 , you wrote:
>You could probably do this with  cfloop but why.  Let the database do the
>work for you.  I am a little confused to when you say zero product
>descriptions.  Does this mean an entry in tblproduct  where there is a
>groupcode but no productdescription, meaning its null.  Another option,
>which what I think you mean, is that there is an entry in tblgroup but no
>entries in tblproduct with that groupcode.
>
>I can see a couple of ways to get what you want through sql.
>
>Select groupcode from tblGroup where groupcode in (Select distinct groupcode
>from tblproduct)
>
>or
>
>Select distinct tblGroup.GroupCode from tblGroup left outer join tblProduct
>on tblGroup.GroupCode = tblProduct.GroupCode
>
>Hope this helps.
>
>John Hancock
>
>-Original Message-
>From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 09, 2001 8:29 PM
>To: CF-Talk
>Subject: cfloop question (I think)
>
>
>I have a database with (amongst other things) a table:
>
>tblProduct
>ProductDescription and GroupCode
>
>another table:
>
>tblGroup
>GroupCode and GroupDescription
>
>The database is updated regularly
>there are 31 GroupCodes but sometimes (and this varies) one or more
>GroupCodes have zero ProductDescriptions in them
>
>I want to be able to have a list of GroupCodes
>but only show the GroupCodes which actually have records
>
>I'm sure there must be a way to do this with cfloop but
>I can't see how to do it
>
>Can anyone help please
>Seamus
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFX_IMAGE original?

[Bill Poff]

Has anyone tried using the Jasc Image Robot for this type of application?

We've been using 2GIF and 2JPEG from fCoder (fcoder.com) and are quite
pleased with both output and speed when used with Cold Fusion.

We need to have the ability to convert from AI and EPS files as well and the
fCoder apps don't support either of these formats.

--Bill

-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 9:57 AM
To: CF-Talk
Subject: RE: CFX_IMAGE original?


I've use Jukka's tag quite a bit and it is good, but I work for a company
involved with graphics.  Jukka's tag just didn't cut it with us.  But don't
get me wrong.  It is quite sufficient for what we needed.  It resizes and
composites acceptably.  The antialiasing is fair.  It could be better.

If you don't need anything extremely involved, Jukka's tag is great.  He
could do a better job of documenting. It took us about 2 weeks to figure out
everything we needed.

Just to let you know, we are using Jukka's tag, but get complaints daily
about the quality of the thumbnails it generates.  I'm still waiting on
Louis Sellar's CFX for resizing and compositing.

As for the other tag, we looked at it and rejected it quickly.  Jukka's tag
was better by several orders of magnitude.

Russel


  Russel Madere, Jr. Senior Web Developer
  ICQ: 5446158   http://www.TurboSquid.com

Some days you eat the bear; some days the bear eats you.



> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 07:02
> To: CF-Talk
> Subject: CFX_IMAGE original?
>
>
> I just downloaded 2 cfx tags named: cfx_image.
> the first one was downloaded from allaire dev exchange - by "gafware".
> the second one was downloaded from intrafoundation - by "jukka".
>
> which one is better? I need to put this cfx into extensive use.
> any help would be appriciated.
>
> Michael.
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop question (I think)

[John]

You could probably do this with  cfloop but why.  Let the database do the
work for you.  I am a little confused to when you say zero product
descriptions.  Does this mean an entry in tblproduct  where there is a
groupcode but no productdescription, meaning its null.  Another option,
which what I think you mean, is that there is an entry in tblgroup but no
entries in tblproduct with that groupcode.

I can see a couple of ways to get what you want through sql.

Select groupcode from tblGroup where groupcode in (Select distinct groupcode
from tblproduct)

or

Select distinct tblGroup.GroupCode from tblGroup left outer join tblProduct
on tblGroup.GroupCode = tblProduct.GroupCode

Hope this helps.

John Hancock

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 8:29 PM
To: CF-Talk
Subject: cfloop question (I think)


I have a database with (amongst other things) a table:

tblProduct
ProductDescription and GroupCode

another table:

tblGroup
GroupCode and GroupDescription

The database is updated regularly
there are 31 GroupCodes but sometimes (and this varies) one or more
GroupCodes have zero ProductDescriptions in them

I want to be able to have a list of GroupCodes
but only show the GroupCodes which actually have records

I'm sure there must be a way to do this with cfloop but
I can't see how to do it

Can anyone help please
Seamus
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL 7 Question

[Paul Smith]

I've been putting one SQL statement after another like the following inside 
a CFQUERY for a while.  Seems to work fine.

UPDATE MAX_ID_Clients SET MAX_ID_Client = MAX_ID_Client + 1
DECLARE @MAX INT
SELECT @MAX = MAX_ID_Client FROM MAX_ID_Clients
INSERT INTO ClientData(CFID,CFTOKEN)
VALUES(@MAX,#CFT#)

Is this a known feature?

Is there a limit to how many SQL statements can be combined this way?

I assume the above is equivalent to a CFTRANSACTION.  Is this so?

best,  paul


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfloop question (I think)

[Seamus Campbell]

I have a database with (amongst other things) a table:

tblProduct
ProductDescription and GroupCode

another table:

tblGroup
GroupCode and GroupDescription

The database is updated regularly
there are 31 GroupCodes but sometimes (and this varies) one or more 
GroupCodes have zero ProductDescriptions in them

I want to be able to have a list of GroupCodes
but only show the GroupCodes which actually have records

I'm sure there must be a way to do this with cfloop but
I can't see how to do it

Can anyone help please
Seamus


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Wrong permissions on a Sun Server

[Mak Wing Lok]

did you used FTP or RDS on your CF Studio to save .cfm files into the
server? try checking on the user account that you log into the server from
CF Studio


- Original Message -
From: "Stevens, Jason" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 5:20 AM
Subject: Wrong permissions on a Sun Server


>
> I have recently started a position in a rather chaotic CF environment and
> wonder if someone could help me with, what I hope, is a simple question.
>
> We run ColdFusion Server 4.5 on a Sun platform. Whenever we create a .cfm
in
> Studio and put it on the server the permissions are incorrect. They are
> owned by "nobody" rather than the group and id that we need them to be
owned
> by. Is there a setting I would change to rectify this problem?
>
> Jason E Stevens
> AT&T Wireless
> EA Enhancement Team
> (425) 829-2293
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Wrong permissions on a Sun Server]

[Alex]

if you FTP them to the solaris box then they are owned by the FTP acct used.
You can change the permissions of the nobody acct (not recommended) or change
the acct used to FTP over the files...ie. cfuser with correct permissions.

useradd...

"Stevens, Jason" <[EMAIL PROTECTED]> wrote:

I have recently started a position in a rather chaotic CF environment and
wonder if someone could help me with, what I hope, is a simple question.

We run ColdFusion Server 4.5 on a Sun platform. Whenever we create a .cfm in
Studio and put it on the server the permissions are incorrect. They are
owned by "nobody" rather than the group and id that we need them to be owned
by. Is there a setting I would change to rectify this problem?

Jason E Stevens
AT&T Wireless
EA Enhancement Team
(425) 829-2293
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: RE: Highlighting Text

[Christine Kelley]

Awesome :)
   Thanks,  Christine

> Save the following as a tag and place all of your content 
between the open and end tags.
> 
> For example, if your tag was called CF_Highlight:
> 
> 
> 
>   This is a test of the sales system.
>   #variables.foo#
>   End of sales information
> 
> 
> Tag Code:
> 
> 
>   
>   
>   
>   
>   
>   
>   #variables.markedUpBody#
>   
> 
> 
> Craig
> 
> > -Original Message-
> > From:   Christine Kelley 
[SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, May 09, 2001 4:12 PM
> > To: CF-Talk
> > Subject:Highlighting Text
> > 
> > Hi!
> > 
> > How do I go about...
> > Having the Keyword highlighted throughout page.  For 
> > example the keyword 'sales' would be shadowed in yellow.
> > 
> > I've looked into the  custom tag, but it's 
not 
> > quite what I need.  It would be nice to highlight all 
the 
> > keywords at once.  How about looping through each line 
and 
> > then each word..., but how do I tell it to loop through 
the 
> > entire page (including dynamically filled areas)?
> >This is a tough one :)
> >Thanks,  Christine
> > 
> > 
> > 
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF-Studio registration number

[Tom Davison]

You started with 4.52 eval which will not work if you put the serial number
in, now that you have that installed download the upgrade which is 4.52 also
but now you can put the serial number in... hope this clears up any
confusion.

Tom
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 3:58 PM
Subject: AW: CF-Studio registration number


> As I said, I started with 4.5.2 right from the beginning.
> So your suggestion doesn't make sense.
> But thank you anyway.
>
> Uwe
>
> -Ursprüngliche Nachricht-
> Von: Tom Davison [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 9. Mai 2001 01:06
> An: CF-Talk
> Betreff: Re: CF-Studio registration number
>
>
> You should now download the upgrade to 4.5 and install that and put in the
> reg key.
>
> Tom
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, May 08, 2001 4:58 PM
> Subject: AW: CF-Studio registration number
>
>
> > No, that hasn't been the case.
> > I tried that already earlier too.
> > With no success.
> >
> > Uwe
> >
> >
> > -Ursprüngliche Nachricht-
> > Von: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> > Gesendet: Dienstag, 8. Mai 2001 15:32
> > An: CF-Talk
> > Betreff: RE: CF-Studio registration number
> >
> >
> > just enter the serial number when you install it.
> >
> > you can uninstall and reinstall with the number.
> >
> > -Original Message-
> > From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 08, 2001 5:13 AM
> > To: CF-Talk
> > Subject: CF-Studio registration number
> >
> >
> > Hi, is there a way to fill in the registration number
> > of a CF 4.5.2 Studio EVAL-Version later after installation ?
> > I downloaded it because I couldn't find my original CF-Studio-CD.
> > I looked in the registry but I couldn't find anything concerning a
> > registration number. Thanks for ideas.
> >
> > Uwe
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Firewall Proxy Server Suggestions

[Steve Bernard]

Do you require an application that supports network-based virus protection?

Regards,

Steve

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 5:44 PM
To: CF-Talk
Subject: OT:Firewall Proxy Server Suggestions


We are currently using WinProxy for our firewall and proxy server, however
they feel compelled to charge $2000.00 per year for their virus protection
now.  Any suggestions
on NT or LINUX based server software out there?

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: disabling RDS

[Dylan Bromby]

woops. i guess i should've read all of the message huh? :)

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:10 PM
To: CF-Talk
Subject: RE: disabling RDS


on NT? if so, set the service to "Disabled".

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:42 PM
To: CF-Talk
Subject: disabling RDS


I have disabled the RDS service on our NT server but get the following
error in the executive log:

"Error","TID=104","05/09/01","00:41:34","Unexpected Windows NT error number
1058 occurred while attempting to start the RDS service."

Is it possible to completely disable the RDS service?

Thanks,

Brook Davies
Maracasmedia Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFREGISTRY (the inner workings of CF Admin)

[Dave Watts]

> I am thinking I'm going to disable CFREGISTRY on one of my 
> servers for security reasons. Then it occurred to me, how 
> does the CF Administrator check passwords, retrieve datasources, 
> etc... if it's disabled. Does disabling it exclude pages 
> within the CF Administrator...?

By default, the CF Administrator directory isn't affected when you disable
CFREGISTRY. You can actually specify the directory path which will still
allow CFREGISTRY in the same "Basic Security" page with which you disable
CFREGISTRY.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Bruce Heerssen]

I know how most folks around here feel about HTML email (evil), but it should be noted 
that images can be used to track emails. You
can either look in your server logs for hits to the image, or serve up the image using 
CF or PHP, which would let you do things like
add records to the database, etc..

options, options...

There are a lot of options and none of them are fool-proof, but maybe by using several 
techniques in conjuction with each other you
can cover most of the holes.

-Bruce

>
> > If the email is accepted it's likely valid.
>
> We are using iMail on our server and you can set up an alias named 'nothing'
> that will accept all email to the domain that doesn't point to an existing
> account. With this in mind, our mail server would never return mail as
> undeliverable. So I just thought I would point out that that is a "hit &
> miss" solution. Seems like there used to be a CFX tag that would do it
> somehow...?
>
> Steve
>


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: How to set up PWS to process CGI scripts?

[Billy Cravens]

When you say CGI, do you mean Perl?  (common mistake; they're not
interchangeable terms)

If so, look at ActiveState Perl

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Robert Obreczarek wrote:

> Hi Everybody,
>
> Sorry for the OT post, but I need to find out
> some info on this topic quick. I need to know
> if it's possible to set up PWS to process cgi
> scripts. I'm on a Win 98 SE box. If yes can
> someone point me to any resources or downloads?
> I really apreciate any help. Thanks a lot.
>
> Robert Obreczarek
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Keith C. Ivey]

On 9 May 2001, at 16:46, Steve Bernard wrote:

> Yes, most mail servers support address verification, if it's
> enabled. You can use a Telnet client, or CFX_TCPClient, ...

But since verification is disabled on most mail servers (mainly 
because of spammers), it's not likely to be worth the trouble 
to try.

Keith C. Ivey <[EMAIL PROTECTED]>
Webmaster, EEI Communications
66 Canal Center Plaza, Suite 200
Alexandria, VA  22314
Telephone:  703-683-0683
Fax:  703-683-4915
Web Site:  http://www.eeicommunications.com

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Pinging an email address

[Steve Reich]

> If the email is accepted it's likely valid.

We are using iMail on our server and you can set up an alias named 'nothing'
that will accept all email to the domain that doesn't point to an existing
account. With this in mind, our mail server would never return mail as
undeliverable. So I just thought I would point out that that is a "hit &
miss" solution. Seems like there used to be a CFX tag that would do it
somehow...?

Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT:Firewall Proxy Server Suggestions

[Larry Juncker]

We are currently using WinProxy for our firewall and proxy server, however
they feel compelled to charge $2000.00 per year for their virus protection
now.  Any suggestions
on NT or LINUX based server software out there?

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[PEREZ, RICHARD RINGO (SBCSI)]

What is an MX record how do you do that?

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:19 PM
To: CF-Talk
Subject: RE: Pinging an email address


you can telnet to a mail server (they usually have exposure to the
internet).

1) lookup the MX record for a domain
2) telnet to that mail server (usually on port 25)
3) do VRFY (username) or EXPN (username)

however, those commands are unavailable sometimes for privacy/security
reasons. or...sometimes you can FINGER an address. from a command line, use
FINGER username@domain.

but that's one way to verify it exists.

you could also send an email to it and have a bot watch for undeliverable
returns. no telling how long that would take to receive though. mail servers
are configured differently for that both on the outbound and the inbound.

--dylan

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFREGISTRY (the inner workings of CF Admin)

[Steve Reich]

I am thinking I'm going to disable CFREGISTRY on one of my servers for
security reasons. Then it occurred to me, how does the CF Administrator
check passwords, retrieve datasources, etc... if it's disabled. Does
disabling it exclude pages within the CF Administrator...?

Mostly just curious
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Wrong permissions on a Sun Server

[Stevens, Jason]

I have recently started a position in a rather chaotic CF environment and
wonder if someone could help me with, what I hope, is a simple question.

We run ColdFusion Server 4.5 on a Sun platform. Whenever we create a .cfm in
Studio and put it on the server the permissions are incorrect. They are
owned by "nobody" rather than the group and id that we need them to be owned
by. Is there a setting I would change to rectify this problem?

Jason E Stevens
AT&T Wireless
EA Enhancement Team
(425) 829-2293

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: syntax error when inserting date

[Erik Carroll]

What database are you using? The problem may be that your database is
expecting the date in a specific format. Using Oracle as an example, the
value you are trying to insert into the Date column, '#onedate#', would be
seen as a string and not a date which would generate an error. Oracle has a
TO_DATE function that will convert the string to a date format. Check to
make sure the format is recognizable by the database you are using and also
check if the date string needs to be converted before inserting.

Erik

- Original Message -
From: "megan sherman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 10:01 AM
Subject: syntax error when inserting date


> Hi all,
> My action template is supposed to insert classID, location and date into
> a table in my database. When creating new records in the form I provide,
> I want the user to be able to supply a comma delimited list of dates. I
> think the loop in the action template successfully extracts individual
> dates from the date list, but there is a syntax error in the insert
> command. Everything works if I don't try to insert the date, so that
> must be where the syntax error occurs. Can anybody tell me what my date
> syntax error is?
> Thanks in advance!
> Megan
> <<>>
> 
>  
> 
> 
> 
> 
> 
> 
> insert into class_schedule (classID, location, date)
> values(#form.classID#, '#form.location#', '#onedate#')
> 
> 
> 
> 
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: disabling RDS

[Lanny R. Udey]

We found you could not disable it but if you set it to manual it was OK.

Lanny Udey
Hofstra University

>>> [EMAIL PROTECTED] Wednesday, May 09, 2001 >>>
I have disabled the RDS service on our NT server but get the following 
error in the executive log:

"Error","TID=104","05/09/01","00:41:34","Unexpected Windows NT error number 
1058 occurred while attempting to start the RDS service."

Is it possible to completely disable the RDS service?

Thanks,

Brook Davies
Maracasmedia Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How to set up PWS to process CGI scripts?

[Boardwine, David L.]

This link tells how to set up PERL scripts on PWS.

http://support.microsoft.com/support/kb/articles/q231/9/98.asp


David L. Boardwine
Programmer/Analyst
Ohio Department of Development/ITO
Phone (614) 752-4431
[EMAIL PROTECTED]





-Original Message-
From: Robert Obreczarek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 4:16 PM
To: CF-Talk
Subject: OT: How to set up PWS to process CGI scripts?


Hi Everybody,

Sorry for the OT post, but I need to find out
some info on this topic quick. I need to know
if it's possible to set up PWS to process cgi
scripts. I'm on a Win 98 SE box. If yes can 
someone point me to any resources or downloads?
I really apreciate any help. Thanks a lot.

Robert Obreczarek
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: disabling RDS

[Dave Watts]

> I have disabled the RDS service on our NT server but get the 
> following error in the executive log:
> 
> "Error","TID=104","05/09/01","00:41:34","Unexpected Windows 
> NT error number 1058 occurred while attempting to start the 
> RDS service."
> 
> Is it possible to completely disable the RDS service?

Yes. The problem is that the Executive is trying to start the service, even
though it's been disabled. You can instruct the Executive not to do this by
setting the value:

HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\IDE\ServiceRunning

to "0".

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: disabling RDS

[Dylan Bromby]

on NT? if so, set the service to "Disabled".

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:42 PM
To: CF-Talk
Subject: disabling RDS


I have disabled the RDS service on our NT server but get the following
error in the executive log:

"Error","TID=104","05/09/01","00:41:34","Unexpected Windows NT error number
1058 occurred while attempting to start the RDS service."

Is it possible to completely disable the RDS service?

Thanks,

Brook Davies
Maracasmedia Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I run CFML code that I pull form my database?

[Robert J. Bailey]

The information that I get from the form is not ever going back to the
application, only to a VB app that I have created to read the information
from the database. I think I am going to follow your suggestion and grab the
actual data from the database, use CFFILE to write a temp. cfm file and then
include it for the user, this seems to be the best way to go. Thanks


Robert J. Bailey
(646) 526-4536


-Original Message-
From: Chris Maloney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 4:32 PM
To: CF-Talk
Subject: RE: Can I run CFML code that I pull form my database?


Robert,
Considering I've seen other replies to this post that were considerably
inaccurate, I'll give you a proper solution.

The way to solve this problem is to take the data from the database write it
to a file and then use cfinclude to include the file back in and thus have
the code executed.

Now, there is a danger in using this method, because someone could fill out
a form and have code written into your database that may cause damage to
your system.  However you could easily filter the users input and strip out
any tags they may have put into the form.

Using evaluate() will work, provided however, you are only using CF
functions and not using tags.  Since you are using tags this method is not
an option.

Chris

-Original Message-
From: Robert J. Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:28 PM
To: CF-Talk
Subject: Can I run CFML code that I pull form my database?


OK, here is what I am doing. I am executing a stored procedure which grabs
some code from my SQL server and then displays it on the page. Mostly what
this is for is my forms, which I would like to keep in the DB so I can
easily change them. The problem being that the CFFORM tag as well as my
CFINPUT tags do not execute when doing this and it displays the tag 
etc in the browser. I am not good at explaining things so if I did not do a
good enough job trying to ask this question, please let me know. Thanks for
all that will have a solution that I can implement.


Robert J. Bailey
(646) 526-4536
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

AW: CF-Studio registration number

[cf-talk]

As I said, I started with 4.5.2 right from the beginning.
So your suggestion doesn't make sense.
But thank you anyway.

Uwe

-Ursprüngliche Nachricht-
Von: Tom Davison [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 9. Mai 2001 01:06
An: CF-Talk
Betreff: Re: CF-Studio registration number


You should now download the upgrade to 4.5 and install that and put in the
reg key.

Tom
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 4:58 PM
Subject: AW: CF-Studio registration number


> No, that hasn't been the case.
> I tried that already earlier too.
> With no success.
>
> Uwe
>
>
> -Ursprüngliche Nachricht-
> Von: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 8. Mai 2001 15:32
> An: CF-Talk
> Betreff: RE: CF-Studio registration number
>
>
> just enter the serial number when you install it.
>
> you can uninstall and reinstall with the number.
>
> -Original Message-
> From: CF-Talk (SD Solutions) [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 08, 2001 5:13 AM
> To: CF-Talk
> Subject: CF-Studio registration number
>
>
> Hi, is there a way to fill in the registration number
> of a CF 4.5.2 Studio EVAL-Version later after installation ?
> I downloaded it because I couldn't find my original CF-Studio-CD.
> I looked in the registry but I couldn't find anything concerning a
> registration number. Thanks for ideas.
>
> Uwe
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Bit Masks

[Ken Monroe]

Hello!

I believe that someone once gave a presentation at one of the CFUGs about
using bit masks, also know as Right Bit AND, to set up security access
levels.  This wasn't the same as the presentation at the Fig Leaf site
that's slight more oriented towards hierarchy uses.  I've looked at all the
CFUG sites linked to from the Allaire site but I can't find the
presentation.  Does anyone recall where the presentation was made and/or how
to get the presentation file?

Thx


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Highlighting Text

[Howarth, Craig (IBK-NY)]

Save the following as a tag and place all of your content between the open and end 
tags.

For example, if your tag was called CF_Highlight:



This is a test of the sales system.
#variables.foo#
End of sales information


Tag Code:








#variables.markedUpBody#



Craig

> -Original Message-
> From: Christine Kelley [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 4:12 PM
> To:   CF-Talk
> Subject:  Highlighting Text
> 
> Hi!
> 
> How do I go about...
> Having the Keyword highlighted throughout page.  For 
> example the keyword 'sales' would be shadowed in yellow.
> 
> I've looked into the  custom tag, but it's not 
> quite what I need.  It would be nice to highlight all the 
> keywords at once.  How about looping through each line and 
> then each word..., but how do I tell it to loop through the 
> entire page (including dynamically filled areas)?
>This is a tough one :)
>Thanks,  Christine
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Steve Bernard]

Yes, most mail servers support address verification, if it's enabled. You
can use a Telnet client, or CFX_TCPClient, to open a connection to port 25
on the mail host and issue the following command:

VRFY 

Steve

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Email List Servers

[Bill Holloway]

Anyone have a good email list server recommendation.  I've been looking at
iMail but it's more than I need.  (what's this list run on?)

TIA for suggestions,
Bill


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Tony Schreiber]

This wouldn't catch email addresses that are aliases would it? Would it
depend on how the alias was defined?

> you can telnet to a mail server (they usually have exposure to the
> internet).
> 
> 1) lookup the MX record for a domain
> 2) telnet to that mail server (usually on port 25)
> 3) do VRFY (username) or EXPN (username)
> 
> however, those commands are unavailable sometimes for privacy/security
> reasons. or...sometimes you can FINGER an address. from a command line, use
> FINGER username@domain.
> 
> but that's one way to verify it exists.
> 
> you could also send an email to it and have a bot watch for undeliverable
> returns. no telling how long that would take to receive though. mail servers
> are configured differently for that both on the outbound and the inbound.
> 
> --dylan
> 
> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 12:59 PM
> To: CF-Talk
> Subject: Pinging an email address
> 
> 
> Is there a way to "ping" an email address to verify that the mailbox exists?
> It doesn't neccessarily have to be a CF routine either...
> 
> Thanks,
> Steve
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Pinging an email address

[Tony Schreiber]

Send them a message and have the user click a link inside the email (or
cut/paste whatever)... That's how I verify with most of my applications
(SMB included).

You can't really "ping" an actuall address, only the mail server that
serves it...

> Is there a way to "ping" an email address to verify that the mailbox exists?
> It doesn't neccessarily have to be a CF routine either...
> 
> Thanks,
> Steve
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Pinging an email address

[Jim McAtee]

The closest thing would be the smtp VRFY command.  Many (most?) email server
admins have the command disabled in order to prevent the harvesting of email
addresses, so it's all but worthless in verifying the validity of an
address.

JIm


- Original Message -
From: "Steve Reich" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 1:59 PM
Subject: Pinging an email address


> Is there a way to "ping" an email address to verify that the mailbox
exists?
> It doesn't neccessarily have to be a CF routine either...
>
> Thanks,
> Steve


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

disabling RDS

[Brook Davies]

I have disabled the RDS service on our NT server but get the following 
error in the executive log:

"Error","TID=104","05/09/01","00:41:34","Unexpected Windows NT error number 
1058 occurred while attempting to start the RDS service."

Is it possible to completely disable the RDS service?

Thanks,

Brook Davies
Maracasmedia Inc.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Highlighting Text

[Jose Alberto Guerra Ugalde]

There's a Custom Tag that I think does just that in Allaire the name is
CF_Highlight

"CF_Highlight takes a list of substrings, and highlights them in a larger
text string. For example, it can be used to highlight search terms on the
results page from a search engine. It requires CF 3.01 or above to run."

Regards

Jose Alberto Guerra Ugalde
Mail: [EMAIL PROTECTED]
My ICQ page: http://www.mirabilis.com/1607021
My ICQ:1607021

- Original Message -
From: "Christine Kelley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 1:11 PM
Subject: Highlighting Text


> Hi!
>
> How do I go about...
> Having the Keyword highlighted throughout page.  For
> example the keyword 'sales' would be shadowed in yellow.
>
> I've looked into the  custom tag, but it's not
> quite what I need.  It would be nice to highlight all the
> keywords at once.  How about looping through each line and
> then each word..., but how do I tell it to loop through the
> entire page (including dynamically filled areas)?
>This is a tough one :)
>Thanks,  Christine
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: syntax error when inserting date

[Chris Maloney]

Actually the problem is that you have a field in your database named 'Date'
this is a reserved word and cannot be used as a field name in your db.  Try
changing the field name to something like 'mydate' or some other equivalent
and try your code again, you will likely see better results.

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:06 PM
To: CF-Talk
Subject: RE: syntax error when inserting date


Your problem is most likely due to the format of the date.
If the data field in the database is of type 'Date' you would have to use
CreateODBCDate(Form.Date) in order to change the text to an ODBC date
format.

Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

email: [EMAIL PROTECTED]
 phone: 303-885-7044

plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives



-Original Message-
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 8:02 AM
To: CF-Talk
Subject: syntax error when inserting date


Hi all,
My action template is supposed to insert classID, location and date into
a table in my database. When creating new records in the form I provide,
I want the user to be able to supply a comma delimited list of dates. I
think the loop in the action template successfully extracts individual
dates from the date list, but there is a syntax error in the insert
command. Everything works if I don't try to insert the date, so that
must be where the syntax error occurs. Can anybody tell me what my date
syntax error is?
Thanks in advance!
Megan
<<>>

 






insert into class_schedule (classID, location, date)
values(#form.classID#, '#form.location#', '#onedate#')






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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I run CFML code that I pull form my database?

[Chris Maloney]

Robert,
Considering I've seen other replies to this post that were considerably
inaccurate, I'll give you a proper solution.

The way to solve this problem is to take the data from the database write it
to a file and then use cfinclude to include the file back in and thus have
the code executed.

Now, there is a danger in using this method, because someone could fill out
a form and have code written into your database that may cause damage to
your system.  However you could easily filter the users input and strip out
any tags they may have put into the form.

Using evaluate() will work, provided however, you are only using CF
functions and not using tags.  Since you are using tags this method is not
an option.

Chris

-Original Message-
From: Robert J. Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 1:28 PM
To: CF-Talk
Subject: Can I run CFML code that I pull form my database?


OK, here is what I am doing. I am executing a stored procedure which grabs
some code from my SQL server and then displays it on the page. Mostly what
this is for is my forms, which I would like to keep in the DB so I can
easily change them. The problem being that the CFFORM tag as well as my
CFINPUT tags do not execute when doing this and it displays the tag 
etc in the browser. I am not good at explaining things so if I did not do a
good enough job trying to ask this question, please let me know. Thanks for
all that will have a solution that I can implement.


Robert J. Bailey
(646) 526-4536
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I run CFML code that I pull form my database?

[Robert J. Bailey]

Yes, I am aware of this, also I am the only one with access to my SQL
server.


Robert J. Bailey
(646) 526-4536


-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 4:04 PM
To: CF-Talk
Subject: RE: Can I run CFML code that I pull form my database?


And PLEASE be aware that this is potentially very dangerous.  Do YOU have
full control over what goes in and out of the database?  Be aware of your
risks before you take this action.

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:46 PM
To: CF-Talk
Subject: Re: Can I run CFML code that I pull form my database?


Wrap the string from SQL Server in an #Eval()# statement.  It'll take a bit
of escaping a whatnot, but it should
work.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

"Robert J. Bailey" wrote:

> OK, here is what I am doing. I am executing a stored procedure which grabs
> some code from my SQL server and then displays it on the page. Mostly what
> this is for is my forms, which I would like to keep in the DB so I can
> easily change them. The problem being that the CFFORM tag as well as my
> CFINPUT tags do not execute when doing this and it displays the tag

> etc in the browser. I am not good at explaining things so if I did not do
a
> good enough job trying to ask this question, please let me know. Thanks
for
> all that will have a solution that I can implement.
>
> Robert J. Bailey
> (646) 526-4536
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: syntax error when inserting date

[Bryan LaPlante]

Remember that date is a key word in sql and will produce undesired results
if a field in a table is named date as in your code snippet.
insert into class_schedule (classID, location, date)

Try changing the field name to aDate or lastupdated or something.

Bryan

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 3:06 PM
Subject: RE: syntax error when inserting date


> Your problem is most likely due to the format of the date.
> If the data field in the database is of type 'Date' you would have to use
> CreateODBCDate(Form.Date) in order to change the text to an ODBC date
> format.
>
> Regards,
>
> Rob Rusher
>
> Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
> Java Programmer
>
> email: [EMAIL PROTECTED]
>  phone: 303-885-7044
>
> plan, build and integrate interactive applications and e-business services
> to enhance knowledge sharing, e-commerce and business communications
> initiatives
>
>
>
> -Original Message-
> From: megan sherman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 8:02 AM
> To: CF-Talk
> Subject: syntax error when inserting date
>
>
> Hi all,
> My action template is supposed to insert classID, location and date into
> a table in my database. When creating new records in the form I provide,
> I want the user to be able to supply a comma delimited list of dates. I
> think the loop in the action template successfully extracts individual
> dates from the date list, but there is a syntax error in the insert
> command. Everything works if I don't try to insert the date, so that
> must be where the syntax error occurs. Can anybody tell me what my date
> syntax error is?
> Thanks in advance!
> Megan
> <<>>
> 
>  
> 
> 
> 
> 
> 
> 
> insert into class_schedule (classID, location, date)
> values(#form.classID#, '#form.location#', '#onedate#')
> 
> 
> 
> 
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Robert J. Bailey]

you can not "ping" an email, but there are some ways to determine if the
email exists. Will take some extra work on your end and more then likely you
are not going to know right away. Try connecting to the SMTP server that you
want to check mail against. When you connect to the SMTP, which is usually
port 25, you want to try to send a mail to the user to see if the box
exists. I had to do this on a job a few years ago so I am not remembering
the syntax but I can look it up for you if you would like. If there is no
mailbox by that name on the server, it should return an error of 550 and
state it is not a valid mailbox on the system. Let me know if this helps.
Thanks


Robert J. Bailey
(646) 526-4536


-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Chris Maloney]

There is no explicit way to 'ping' an email address the best and only way to
do it is send an email to that address.  If the host rejects the email the
address is invalid.  If the email is accepted it's likely valid.  Typically
the best way to verify an email address is to have the user click on a link
inside the email that directs to a page you have and then flags the entry in
the database as a valid email address.

Chris

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 2:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Pinging an email address

[Dylan Bromby]

you can telnet to a mail server (they usually have exposure to the
internet).

1) lookup the MX record for a domain
2) telnet to that mail server (usually on port 25)
3) do VRFY (username) or EXPN (username)

however, those commands are unavailable sometimes for privacy/security
reasons. or...sometimes you can FINGER an address. from a command line, use
FINGER username@domain.

but that's one way to verify it exists.

you could also send an email to it and have a bot watch for undeliverable
returns. no telling how long that would take to receive though. mail servers
are configured differently for that both on the outbound and the inbound.

--dylan

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:59 PM
To: CF-Talk
Subject: Pinging an email address


Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: How to set up PWS to process CGI scripts?

[Robert Obreczarek]

Hi Everybody,

Sorry for the OT post, but I need to find out
some info on this topic quick. I need to know
if it's possible to set up PWS to process cgi
scripts. I'm on a Win 98 SE box. If yes can 
someone point me to any resources or downloads?
I really apreciate any help. Thanks a lot.

Robert Obreczarek

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Highlighting Text

[Christine Kelley]

Hi!

How do I go about...
Having the Keyword highlighted throughout page.  For 
example the keyword 'sales' would be shadowed in yellow.

I've looked into the  custom tag, but it's not 
quite what I need.  It would be nice to highlight all the 
keywords at once.  How about looping through each line and 
then each word..., but how do I tell it to loop through the 
entire page (including dynamically filled areas)?
   This is a tough one :)
   Thanks,  Christine



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Spider 404s

[Keith C. Ivey]

On 9 May 2001, at 11:15, Nick McClure wrote:

> You should be able to check CFHTTP.StatusCode
> 
> this will be equal to 404 or 500.
> 
> 200 is a successful request.

Yes, that's the way it's supposed to work.  Unfortunately, a 
bunch of people out there have configured their servers to 
return status 200 even for requests for nonexistent pages.  It 
makes things hard for spider writers, and results in clutter 
for search-engine databases.

Some of these server admins do it to avoid having their custom 
404 pages hidden by IE's damned "friendly" error messages.  
Regardless of the reason, it's a bad idea and yet another bit 
of Microsoftian damage to the idea of standards.  A better way 
to do avoid IE's interference is to make sure the custom page 
contents are longer than 512 (or maybe it's 1024) bytes.

I think that requests for nonexistent .cfm files result in 
status 200 for the usual configuration of IIS as well, so that 
could be another contribution to the problem.

Keith C. Ivey <[EMAIL PROTECTED]>
Webmaster, EEI Communications
66 Canal Center Plaza, Suite 200
Alexandria, VA  22314
Telephone:  703-683-0683
Fax:  703-683-4915
Web Site:  http://www.eeicommunications.com

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: syntax error when inserting date

[robrusher]

Your problem is most likely due to the format of the date.
If the data field in the database is of type 'Date' you would have to use
CreateODBCDate(Form.Date) in order to change the text to an ODBC date
format.

Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

email: [EMAIL PROTECTED]
 phone: 303-885-7044

plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives



-Original Message-
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 8:02 AM
To: CF-Talk
Subject: syntax error when inserting date


Hi all,
My action template is supposed to insert classID, location and date into
a table in my database. When creating new records in the form I provide,
I want the user to be able to supply a comma delimited list of dates. I
think the loop in the action template successfully extracts individual
dates from the date list, but there is a syntax error in the insert
command. Everything works if I don't try to insert the date, so that
must be where the syntax error occurs. Can anybody tell me what my date
syntax error is?
Thanks in advance!
Megan
<<>>

 






insert into class_schedule (classID, location, date)
values(#form.classID#, '#form.location#', '#onedate#')






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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I run CFML code that I pull form my database?

[Jann VanOver]

And PLEASE be aware that this is potentially very dangerous.  Do YOU have
full control over what goes in and out of the database?  Be aware of your
risks before you take this action.

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:46 PM
To: CF-Talk
Subject: Re: Can I run CFML code that I pull form my database?


Wrap the string from SQL Server in an #Eval()# statement.  It'll take a bit
of escaping a whatnot, but it should
work.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

"Robert J. Bailey" wrote:

> OK, here is what I am doing. I am executing a stored procedure which grabs
> some code from my SQL server and then displays it on the page. Mostly what
> this is for is my forms, which I would like to keep in the DB so I can
> easily change them. The problem being that the CFFORM tag as well as my
> CFINPUT tags do not execute when doing this and it displays the tag

> etc in the browser. I am not good at explaining things so if I did not do
a
> good enough job trying to ask this question, please let me know. Thanks
for
> all that will have a solution that I can implement.
>
> Robert J. Bailey
> (646) 526-4536
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Pinging an email address

[Steve Reich]

Is there a way to "ping" an email address to verify that the mailbox exists?
It doesn't neccessarily have to be a CF routine either...

Thanks,
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I run CFML code that I pull form my database?

[Robert J. Bailey]

yes, I understand that, but is there anyway I can use any CFML within this
that you can think of at all?

Thanks!


Robert J. Bailey
(646) 526-4536


-Original Message-
From: Dave f [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:36 PM
To: CF-Talk
Subject: Re: Can I run CFML code that I pull form my database?


It will work if you change to regular HTML FORM tags  
etc.


- Original Message -
From: "Robert J. Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:27 PM
Subject: Can I run CFML code that I pull form my database?


> OK, here is what I am doing. I am executing a stored procedure which grabs
> some code from my SQL server and then displays it on the page. Mostly what
> this is for is my forms, which I would like to keep in the DB so I can
> easily change them. The problem being that the CFFORM tag as well as my
> CFINPUT tags do not execute when doing this and it displays the tag

> etc in the browser. I am not good at explaining things so if I did not do
a
> good enough job trying to ask this question, please let me know. Thanks
for
> all that will have a solution that I can implement.
>
>
> Robert J. Bailey
> (646) 526-4536
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can I run CFML code that I pull form my database?

[Billy Cravens]

Wrap the string from SQL Server in an #Eval()# statement.  It'll take a bit of 
escaping a whatnot, but it should
work.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

"Robert J. Bailey" wrote:

> OK, here is what I am doing. I am executing a stored procedure which grabs
> some code from my SQL server and then displays it on the page. Mostly what
> this is for is my forms, which I would like to keep in the DB so I can
> easily change them. The problem being that the CFFORM tag as well as my
> CFINPUT tags do not execute when doing this and it displays the tag 
> etc in the browser. I am not good at explaining things so if I did not do a
> good enough job trying to ask this question, please let me know. Thanks for
> all that will have a solution that I can implement.
>
> Robert J. Bailey
> (646) 526-4536
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: PageMaker/Quark document generated from Database?

[Paul Sizemore]

You defiantly want Quark, and to add to the confusion, you might look at
Meadows Information's offerings (www.meadowsinfo.com). I reviewed the three
and decided on Meadows because they seemed like they would be more
responsive to tech questions (and price was less). When I used it, they were
planning on an ODBC link (they could only use text data files output from
DBs). There are also a few other higher end tools. If I remember, LinkUP is
AppleScript compatible, a strong plus.

Can you export the data into a flat file and import it into Quark (like a
one time import), or do you want to establish a "data flow?" 

Most printers cringe at the thought of Pagemaker. If you have generated PDF
from CF, you might send a sample to your print shop and see if they can use
the PDF generated from CF. 

Let me know if you need any other advice.

Paul Sizemore

Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516


-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:57 PM
To: CF-Talk
Subject: PageMaker/Quark document generated from Database?

I've got an Access database full of information to list in in a
directory which is to be printed at a print shop. So I need the
database to populate my directory pages. I'll probably need to use
Quark or PageMaker. Is one or the other better suited for this
endeavor?

I'm also a ColdFusion programmer, so I could conceivably script them
myself, though that seems difficult, and I don't know anything about
Quark or PageMaker markup.

I've heard of McResearch.com's "LinkUP" and EMSoftware.com's
"Xcatalog", for Quark but I haven't heard any reviews or comparisons.
Could anyone give me any advice or pointers?

Any tips/pointers are appreciated.

Thanks, Jamie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can I run CFML code that I pull form my database?

[Dave f]

It will work if you change to regular HTML FORM tags  
etc.


- Original Message -
From: "Robert J. Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:27 PM
Subject: Can I run CFML code that I pull form my database?


> OK, here is what I am doing. I am executing a stored procedure which grabs
> some code from my SQL server and then displays it on the page. Mostly what
> this is for is my forms, which I would like to keep in the DB so I can
> easily change them. The problem being that the CFFORM tag as well as my
> CFINPUT tags do not execute when doing this and it displays the tag

> etc in the browser. I am not good at explaining things so if I did not do
a
> good enough job trying to ask this question, please let me know. Thanks
for
> all that will have a solution that I can implement.
>
>
> Robert J. Bailey
> (646) 526-4536
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[Jon Hall]

I think that has made it into Hals Helms worst practices list. Learn to use
SQL joins and this is never necessary.

jon
- Original Message -
From: "Adkins, Randy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 1:08 PM
Subject: RE: cfloop vs cfoutput


> You can have a  tag between
>   Tags
>
> I have done that many times
>
> Example:
>
> 
> 
> This that and the other thing
> 
> Back to Square One
> 
>
>
> -Original Message-
> From: Gregory Harris [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 12:33 PM
> To: CF-Talk
> Subject: Re: cfloop vs cfoutput
>
>
> No question on that one, CFOUTPUT beats CFLOOP by a long shot, however
> sometimes you have to use CFLOOP for things, like if you wish to have a
>  tag in your  statement which wouldn't be possible,
you'd
> have to use CFLOOP
>
>
> Gregory Harris
> Web Developer
> 
> The Stirling Bridge Group, LLC
> *We Engineer Internet Business Solutions*
> TEL: (949) 707-1534  FAX: (949) 707-1535
>
>
> - Original Message -
> From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 09, 2001 8:50 AM
> Subject: cfloop vs cfoutput
>
>
> >
> > Sorry for the crosspost (had conflicting answers from other lists)
> >
> > but is there a consensus on which method of looping over a query is
> fastest?
> >
> > cfloop or cfoutput..
> >
> > Cheers
> >
> > KOLa
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[Jon Hall]

And now to inject a little more uncertainty...
Just a couple of months ago an Allaire consultant told me that cfloop was
the second slowest tag after cfmail. Always use cfoutput to output queries.
I imagine he was speaking relatively though. I can think of some really slow
tags.

jon
- Original Message -
From: "Critter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 1:37 PM
Subject: Re: cfloop vs cfoutput


> Hello Kola,
>
> This is from the Certified ColdFusion Developer Study Guide:
>
> pg 37 Tip #1
>
> 
>
> The function of the query loop is the same as using  with a
query attribute. For
> performance  reasons,  use a Query loop rather than a  loop. Before
> ColdFusion 4.x, the  query loop performed better.
>
> Generally  speaking  you  should  use a  with a query attribute
when doing all, or
> mostly,  processing  in  the  loop.  If  there  is  nothing  in  the loop
but display, use
> 
>
>
> 
>
>   So what's right?
>
> --
> Best regards,
>  Critter
> ---
> Wednesday, May 09, 2001, 11:50:56 S2k, you wrote:
>
>
> KO> Sorry for the crosspost (had conflicting answers from other lists)
>
> KO> but is there a consensus on which method of looping over a query is
fastest?
>
> KO> cfloop or cfoutput..
>
> KO> Cheers
>
> KO> KOLa
>
>
> KO>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[Gregory Harris]

Ok, bad example (I recall in an earlier version that this was impossible
though, to embed CFQUERY in CFOUTPUT), but some tags still, such as the
before mentioned CFMAIL tag.

Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535


- Original Message -
From: "Adkins, Randy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 10:08 AM
Subject: RE: cfloop vs cfoutput


> You can have a  tag between
>   Tags
>
> I have done that many times
>
> Example:
>
> 
> 
> This that and the other thing
> 
> Back to Square One
> 
>
>
> -Original Message-
> From: Gregory Harris [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 12:33 PM
> To: CF-Talk
> Subject: Re: cfloop vs cfoutput
>
>
> No question on that one, CFOUTPUT beats CFLOOP by a long shot, however
> sometimes you have to use CFLOOP for things, like if you wish to have a
>  tag in your  statement which wouldn't be possible,
you'd
> have to use CFLOOP
>
>
> Gregory Harris
> Web Developer
> 
> The Stirling Bridge Group, LLC
> *We Engineer Internet Business Solutions*
> TEL: (949) 707-1534  FAX: (949) 707-1535
>
>
> - Original Message -
> From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 09, 2001 8:50 AM
> Subject: cfloop vs cfoutput
>
>
> >
> > Sorry for the crosspost (had conflicting answers from other lists)
> >
> > but is there a consensus on which method of looping over a query is
> fastest?
> >
> > cfloop or cfoutput..
> >
> > Cheers
> >
> > KOLa
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

default spool file

[sebastian palmigiani]

I had a problem with cfmail where it kept sending the same email over and
over again. I had to stop the CF service. I checked the spool directory and
found the following spool file:

c:\CFusion\Mail\Spool\2A.CFMAIL=1

That was the name of the email that was beeing sent over and over. What is
the default value for this file?

Thanks,
Sebastian



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ColdFusion Query Windows NT Error 1450

[Jack Tumlin]

I'm having a problem with a query that displays the results in a CFGRID. 
The query works on two different servers with no problems.

Now, I'm trying the query on NT 4.0 machine and getting a blank page. A 
"Error number 1450 occurred while attempting to write the reply to the web 
server." entry is recorded in the server log. I found some information 
about the error on the Allaire Support forums. The fix was to store client 
variables in a data source. I'm doing this already. Any ideas?  The 
ColdFusion Server version is 4.5.1 SP2.
Jack Tumlin
Vice President Business Development
Millennium Software, Inc.
The Software Solutions Company
[EMAIL PROTECTED]
www.millsoftinc.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can I run CFML code that I pull form my database?

[Robert J. Bailey]

OK, here is what I am doing. I am executing a stored procedure which grabs
some code from my SQL server and then displays it on the page. Mostly what
this is for is my forms, which I would like to keep in the DB so I can
easily change them. The problem being that the CFFORM tag as well as my
CFINPUT tags do not execute when doing this and it displays the tag 
etc in the browser. I am not good at explaining things so if I did not do a
good enough job trying to ask this question, please let me know. Thanks for
all that will have a solution that I can implement.


Robert J. Bailey
(646) 526-4536



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

PageMaker/Quark document generated from Database?

[Jamie Jackson]

I've got an Access database full of information to list in in a
directory which is to be printed at a print shop. So I need the
database to populate my directory pages. I'll probably need to use
Quark or PageMaker. Is one or the other better suited for this
endeavor? 

I'm also a ColdFusion programmer, so I could conceivably script them
myself, though that seems difficult, and I don't know anything about
Quark or PageMaker markup. 

I've heard of McResearch.com's "LinkUP" and EMSoftware.com's
"Xcatalog", for Quark but I haven't heard any reviews or comparisons.
Could anyone give me any advice or pointers? 

Any tips/pointers are appreciated. 

Thanks, Jamie


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Object Oriented CFML]

[Garza, Jeff]

CF5 is, I believe, the last of the CF engines based on the C++ codebase.
There are parts of CF5 (like parts of the Administrator) that are java
servlet based.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 09, 2001 9:58 AM
To: CF-Talk
Subject: RE: [Object Oriented CFML]


Yeh I spoke to some guy from Allaire about it a while back and he sounded
pretty upbeat about the whole thing.  I agree it sounds superb that you can
combine pure Java and CF in one page.  I guess having the ability to combine
both in a page gives you the opportunity to enjoy increased development time
and performance.  If CF5 is written in Java (which I think it is isn't it?)
then I guess there's no reason why NEO can't convert it back with no probs.
Obviously it will be restirctive but the fact you can combine pure Java with
CF in the page overcomes this...I wait with baited breath

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 16:45
To: CF-Talk
Subject: RE: [Object Oriented CFML]


If I remember correctly, Neo will actually be a full set of JSP Custom tags
to convert the CFML to appropriate Java syntax (which will be compiled to a
servlet class file).  It's pretty much the same as using the Jrun custom
tags  like <%jrun:sql%>.  This will be some really cool technology as you
should also be able to intermix pure Java with CF in the same template.
Heard this from a Jrun seminar a few months ago...

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 09, 2001 2:44 AM
To: CF-Talk
Subject: RE: [Object Oriented CFML]


Nick

Yeh I thought that sounded pretty interesting too!  I'm the first person to
admint that serverlets are pretty coollightning quick if I remember
correctly.  What bothers/worries me is how you can convert your cfml code
into a serverlet without losing anything in the translation..we'll just
have to wait and see I guess.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 10:01
To: CF-Talk
Subject: RE: [Object Oriented CFML]


>Can you call a JSP page as an object, pass parameters to it,
have its variables and such encapsulated, etc? 

You can't do this with a JSP per se, but you can call Java
classes from within a JSP.

You can do it with a servlet. A servlet is a Java class.

A JSP interpreter such as JRun turns JSP's into servlets.
You can write servlets directly without the JSP stage.

JRun also provides the servlet engine, i.e. the other Java
classes you need to actually run the servlet.

Neo, 

Re: cfloop vs cfoutput

[Critter]

Hello Kola,

This is from the Certified ColdFusion Developer Study Guide:

pg 37 Tip #1



The function of the query loop is the same as using  with a query attribute. 
For
performance  reasons,  use a Query loop rather than a  loop. 
Before
ColdFusion 4.x, the  query loop performed better.

Generally  speaking  you  should  use a  with a query attribute when doing 
all, or
mostly,  processing  in  the  loop.  If  there  is  nothing  in  the loop but display, 
use





  So what's right?

-- 
Best regards,
 Critter
---
Wednesday, May 09, 2001, 11:50:56 S2k, you wrote:


KO> Sorry for the crosspost (had conflicting answers from other lists)

KO> but is there a consensus on which method of looping over a query is fastest?

KO> cfloop or cfoutput..

KO> Cheers

KO> KOLa


KO>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[G]

Well thats a bit misleadingthe more processing you do within a loop,
the slower its going to be, no matter the looping method.  For pure looping,
I remember hearing from somewhere that CFLOOP was actually faster, all other
things being equal.  I remember being somewhat surprised by this.

- Original Message -
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 12:22 PM
Subject: Re: cfloop vs cfoutput


> ofcourse cfoutput,
> that's why it doesn't allow alot of tags to be typed into it.
> it's much more faster then CFLOOP, which lets you specify every cf tag you
> want (CFMAIL, for example)
>
>
> Thanks,
>
> Michael Lugassy
> IT/WEB Specialist
> Interactive Music Ltd.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop vs cfoutput

[Kola Oyedeji]

sure?

>I just remembered where I read that cfloops are more efficient than
>cfoutput with queries, in ben forta's coldfusion developers study guide, if
>that helps clarify anything

>mark

If there is no notable difference then i suppose it doesnt matter!

Kola
-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 17:33
To: CF-Talk
Subject: Re: cfloop vs cfoutput


No question on that one, CFOUTPUT beats CFLOOP by a long shot, however
sometimes you have to use CFLOOP for things, like if you wish to have a
 tag in your  statement which wouldn't be possible, you'd
have to use CFLOOP


Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535


- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 8:50 AM
Subject: cfloop vs cfoutput


>
> Sorry for the crosspost (had conflicting answers from other lists)
>
> but is there a consensus on which method of looping over a query is
fastest?
>
> cfloop or cfoutput..
>
> Cheers
>
> KOLa
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop vs cfoutput

[Adkins, Randy]

You can have a  tag between 
  Tags

I have done that many times

Example:



This that and the other thing

Back to Square One



-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:33 PM
To: CF-Talk
Subject: Re: cfloop vs cfoutput


No question on that one, CFOUTPUT beats CFLOOP by a long shot, however
sometimes you have to use CFLOOP for things, like if you wish to have a
 tag in your  statement which wouldn't be possible, you'd
have to use CFLOOP


Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535


- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 8:50 AM
Subject: cfloop vs cfoutput


>
> Sorry for the crosspost (had conflicting answers from other lists)
>
> but is there a consensus on which method of looping over a query is
fastest?
>
> cfloop or cfoutput..
>
> Cheers
>
> KOLa
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Object Oriented CFML]

[Andy Ewings]

Yeh I spoke to some guy from Allaire about it a while back and he sounded
pretty upbeat about the whole thing.  I agree it sounds superb that you can
combine pure Java and CF in one page.  I guess having the ability to combine
both in a page gives you the opportunity to enjoy increased development time
and performance.  If CF5 is written in Java (which I think it is isn't it?)
then I guess there's no reason why NEO can't convert it back with no probs.
Obviously it will be restirctive but the fact you can combine pure Java with
CF in the page overcomes this...I wait with baited breath

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 16:45
To: CF-Talk
Subject: RE: [Object Oriented CFML]


If I remember correctly, Neo will actually be a full set of JSP Custom tags
to convert the CFML to appropriate Java syntax (which will be compiled to a
servlet class file).  It's pretty much the same as using the Jrun custom
tags  like <%jrun:sql%>.  This will be some really cool technology as you
should also be able to intermix pure Java with CF in the same template.
Heard this from a Jrun seminar a few months ago...

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 09, 2001 2:44 AM
To: CF-Talk
Subject: RE: [Object Oriented CFML]


Nick

Yeh I thought that sounded pretty interesting too!  I'm the first person to
admint that serverlets are pretty coollightning quick if I remember
correctly.  What bothers/worries me is how you can convert your cfml code
into a serverlet without losing anything in the translation..we'll just
have to wait and see I guess.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 10:01
To: CF-Talk
Subject: RE: [Object Oriented CFML]


>Can you call a JSP page as an object, pass parameters to it,
have its variables and such encapsulated, etc? 

You can't do this with a JSP per se, but you can call Java
classes from within a JSP.

You can do it with a servlet. A servlet is a Java class.

A JSP interpreter such as JRun turns JSP's into servlets.
You can write servlets directly without the JSP stage.

JRun also provides the servlet engine, i.e. the other Java
classes you need to actually run the servlet.

Neo, on the other hand, also turns CFML templates into
Java servlets... which I think is pretty interesting.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it o

CFLOOP question

[JB Mentzer]

Hi all

I'm attempting to overwrite the index value of a CFLOOP from within the
loop:






 
  
 

 
  
 









and so on





So far, the CFSWITCH's Expression never seems to be true. Anyone have
any ideas on how to make this work?

Thanks!

* john *




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Log files of a web attack.

[Dave Watts]

> What was the situation under which Apache failed? 

Load testing of a simple CF application on non-clustered servers. The
servers became unresponsive at high load, and started generating lots of
Winsock errors at the console.

> What version of 1.3?

I don't recall exactly. I believe it was 1.3.9 or higher.

> My last application used a large number of clustered servers, 
> so it may be a while before that installation experiences any 
> problems. Load testing proved very successful however...

Mileage does vary, I'm sure. I've heard that Apache 2 should run
significantly better on Windows. I don't think that there's a CF module for
the 2 beta yet, though.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[Gregory Harris]

No question on that one, CFOUTPUT beats CFLOOP by a long shot, however
sometimes you have to use CFLOOP for things, like if you wish to have a
 tag in your  statement which wouldn't be possible, you'd
have to use CFLOOP


Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535


- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 8:50 AM
Subject: cfloop vs cfoutput


>
> Sorry for the crosspost (had conflicting answers from other lists)
>
> but is there a consensus on which method of looping over a query is
fastest?
>
> cfloop or cfoutput..
>
> Cheers
>
> KOLa
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop vs cfoutput

[Michael Lugassy]

ofcourse cfoutput,
that's why it doesn't allow alot of tags to be typed into it.
it's much more faster then CFLOOP, which lets you specify every cf tag you
want (CFMAIL, for example)


Thanks,

Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Log files of a web attack.

[Tony Schreiber]

What was the situation under which Apache failed? What version of 1.3? My
last application used a large number of clustered servers, so it may be a
while before that installation experiences any problems. Load testing
proved very successful however...

I put Apaches Mod_rewrite to great use.

> > I used Netscape FastTrack and/or Enterprise for the longest 
> > time on Win32. Finally, when it too bloated and I got frustrated 
> > at its error-handling, I switched to Apache which come around 
> > to great Win32 version...
> > 
> > IIS - Never used it, never will.
> 
> I've encountered serious performance issues with Apache 1.3.x on Win32 under
> heavy load - it's been basically unusable with CF.
> 
> On the other hand, on Windows, IIS is a relatively good web server platform.
> As long as you follow a few simple steps (removing unused ISAPI extensions,
> application of buffer overflow patches, application of ACLs, etc), it's
> relatively secure and stable. The only real security flaw with IIS is that
> it has to run as Local System, due to the way it integrates with NT
> authentication, so buffer overflow exploits run as root, essentially.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MS Access JOIN Error

[douglas . kronenberger]

Rats, that did not do it

Thanks all the same.

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 7:32 AM
To: CF-Talk
Subject: RE: MS Access JOIN Error


Not sure about Access but in SQL you have to specify the fact that it's an
outer join so instead of LEFT JOIN use LEFT OUTER JOIN.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 15:37
To: CF-Talk
Subject: MS Access JOIN Error


I'm getting the following error when trying to do a left join from an Access
database from CF. I really don't know what I'm doing. Any clues would be
appreciated 


Error Diagnostic Information ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Join expression not
supported.  

SQL = 
"SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS
MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA
Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close,
"MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA
Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor 

FROM "MPA log" LEFT JOIN "52 log" 
ON 'MPA log.MPA #' = '52 log.MPA #'"  

Data Source = "HRTRACKER"  The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44

Thanks in Advance

> Doug Kronenberger
> OI National Training and Education Office
> Depatment of Veterans Affairs
> 
> 440-526-3030 x7776
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: concurrency problem..

[Tony Schreiber]

Well, that's a problem. Let's assume that we can mark a quantity of an
item as "taken" when they place it in their shopping cart. What percentage
of shopping carts are abandonned? Plenty. So that inventory is locked up
until this cleanup runs - which may be before the user has finished
shopping!

> A suggestion is to when the user selects the 
> room/item is to mark the record as being taken,
> and with a date/time.
> 
> Thus not available for someone else.
> 
> Then I would run a clean up file to unmark those 
> checked after say 20 minutes or so.
> 
> Maybe a scheduled task every hour
> 
> 
> 
> 
> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 09, 2001 7:06 AM
> To: CF-Talk
> Subject: Re: concurrency problem..
> 
> 
> I have somewhat of the same issue... In my shopping cart which show live
> inventory available, stock is check before you put the item in the cart.
> And then again during a transaction which puts the item in your order. But
> there is the possibility that someone will have ordered the last widget
> AFTER the inventory check, but BEFORE the actual decrement of inventory.
> 
> How does everyone handle this?
> 
> > hi ppl... i have a hotel booking system that lets the users to reserve
> room thru the web.
> > I retrieve the hotel room capacity to show the current room available...
> if the capacity is zero.. the page will indicate fully booked.
> >  In order to have the most updated info..
> > i actually retrieve the room capacity again from the database juz before
> updating...
> > but seems still have slight chance to have multiple submission at microsec
> difference...
> > 
> > i thinking of using CFLOCK to contain the read,update queries..
> > however.. at the admin module... i have a function that enable the
> administrator to update the total room capacity...
> > so.. which means i cant use CFLOCK (..from my understanding.. CFLOCK only
> locks requests from same page...)
> > 
> > Any advice??
> > 
> > heard that i can use stored procedure from the DB to "lock" the table...??
> > i never use stored procedure b4... so any kind soul can kindly guide me to
> some examples or website where i can learn??
> > 
> > 
> > thanx in advance...
> > 
> > han
> > 
> > 
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Spider 404s

[Dain Anderson]

Gene,

In addition to the comments you've received, you could also take the route
of using a try/catch statement with the TYPE= to one of the HTTP exception
types (see below):

Examples:


cfhttp statement here...



 ...code...




 ...code...




Exception types:

COM.Allaire.ColdFusion.CFEXECUTE.OutputError
COM.Allaire.ColdFusion.CFEXECUTE.Timeout
COM.Allaire.ColdFusion.HTTPAccepted
COM.Allaire.ColdFusion.HTTPAuthFailure
COM.Allaire.ColdFusion.HTTPBadGateway
COM.Allaire.ColdFusion.HTTPBadRequest
COM.Allaire.ColdFusion.HTTPCFHTTPRequestEntityTooLarge
COM.Allaire.ColdFusion.HTTPCFMLRequestFailure
COM.Allaire.ColdFusion.HTTPCGIValueNotPassed
COM.Allaire.ColdFusion.HTTPConflict
COM.Allaire.ColdFusion.HTTPConnectionTimeout
COM.Allaire.ColdFusion.HTTPContentLengthRequired
COM.Allaire.ColdFusion.HTTPContinue
COM.Allaire.ColdFusion.HTTPCookieValueNotPassed
COM.Allaire.ColdFusion.HTTPCreated
COM.Allaire.ColdFusion.HTTPFailure
COM.Allaire.ColdFusion.HTTPFileInvalidPath
COM.Allaire.ColdFusion.HTTPFileNotFound
COM.Allaire.ColdFusion.HTTPFileNotPassed
COM.Allaire.ColdFusion.HTTPFileNotRenderable
COM.Allaire.ColdFusion.HTTPForbidden
COM.Allaire.ColdFusion.HTTPGatewayTimeout
COM.Allaire.ColdFusion.HTTPGone
COM.Allaire.ColdFusion.HTTPMethodNotAllowed
COM.Allaire.ColdFusion.HTTPMovedPermanently
COM.Allaire.ColdFusion.HTTPMovedTemporarily
COM.Allaire.ColdFusion.HTTPMultipleChoices
COM.Allaire.ColdFusion.HTTPNoContent
COM.Allaire.ColdFusion.HTTPNonAuthoritativeInfo
COM.Allaire.ColdFusion.HTTPNotAcceptable
COM.Allaire.ColdFusion.HTTPNotFound
COM.Allaire.ColdFusion.HTTPNotImplemented
COM.Allaire.ColdFusion.HTTPNotModified
COM.Allaire.ColdFusion.HTTPPartialContent
COM.Allaire.ColdFusion.HTTPPaymentRequired
COM.Allaire.ColdFusion.HTTPPreconditionFailed
COM.Allaire.ColdFusion.HTTPProxyAuthenticationRequired
COM.Allaire.ColdFusion.HTTPRequestURITooLarge
COM.Allaire.ColdFusion.HTTPResetContent
COM.Allaire.ColdFusion.HTTPSeeOther
COM.Allaire.ColdFusion.HTTPServerError
COM.Allaire.ColdFusion.HTTPServiceUnavailable
COM.Allaire.ColdFusion.HTTPSwitchingProtocols
COM.Allaire.ColdFusion.HTTPUnsupportedMediaType
COM.Allaire.ColdFusion.HTTPUrlValueNotPassed
COM.Allaire.ColdFusion.HTTPUseProxy
COM.Allaire.ColdFusion.HTTPVersionNotSupported
COM.Allaire.ColdFusion.POPAuthFailure
COM.Allaire.ColdFusion.POPConnectionFailure
COM.Allaire.ColdFusion.POPDeleteError
COM.Allaire.ColdFusion.Request.Timeout
COM.Allaire.ColdFusion.SERVLETJRunError

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/


- Original Message -
From: "Gene Kraybill" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 2:04 PM
Subject: OT: Spider 404s


> I'm building a little spider in CF and want to check each page as it's
retrieved to
> determine whether it contains the expected contents.
>
> Seems like looking for " 404 " in CFHTTP.FileContent won't cover
everything. Does
> anyone have a good working list of words/phrases that can be used to
verify links and
> ensure they're still active?
>
> Gene Kraybill
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Spider 404s

[Caulfield, Michael]

Funny you should mention this -- we go this hit from Google the other day:

http://www.as.columbia.edu/test404response2057687042.html


Now since we have no page of that name, I'm guessing that google is dealing
with exactly the same problem that you are, and their process goes something
like this:

Fire off a bad request (complete with random number)
Store the response as your prototypical 404 page
When making other requests, compare the response to the prototypical 404
page. If it more or less matches it, don't add it to the database.

I thought it seemed a rather neat system (if in fact that was what they were
doing)

Michael Caulfield


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 10:30 AM
To: CF-Talk
Subject: RE: Spider 404s


> I'm building a little spider in CF and want to check each 
> page as it's retrieved to determine whether it contains the 
> expected contents.
> 
> Seems like looking for " 404 " in CFHTTP.FileContent won't 
> cover everything. Does anyone have a good working list of 
> words/phrases that can be used to verify links and ensure 
> they're still active?

Looking for "404" in CFHTTP.FileContent won't help you if the web server
returns an HTTP status code of 404. Instead, you might look at the variable
CFHTTP.StatusCode if you're running CF 4.5.x. Actually, this variable might
be present in earlier versions, but I don't know for sure.

Incidentally, if you request a non-existent CF page, you won't get back a
404 status code, even though the page itself will say "HTTP/1.0 404 Object
Not Found". The server will actually return a 200 status code, which
typically means "everything's OK". So, your spider may need to take this
into account.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Array String Concatenation

[Bill King]

Just for clarification:  what are your intended results?

Are you making a list of clickable teams from a database?

Could you, instead of using a two dimensional array use an array with a
structure in it like this:


Standings[1][TeamName] = "Barracudas";
Standings[1][TeamID] = "17";


Then you can spit out your clickable link as follows:

http://www.hostworks.com





-Original Message-
From: Jeffrey R. Thomas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 8:03 PM
To: CF-Talk
Subject: Array String Concatenation


I am trying to concatenate an array string.

This is what I presently have:


I would like to add alink with url.TeamID to the team name so that when I
output the array using a loop the TeamName will show up as a link.

I would like to have something like this (below) to be added to the array
entry above.
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MS Access JOIN Error

[DeVoil, Nick]

Does this work?

FROM [MPA log] LEFT JOIN [52 log]
ON [MPA log].[MPA #] = [52 log].[MPA #]

Those table names and field names are pretty confusing.
Is it an option for you to change the names so that they
do not contain spaces, pound signs etc?

Nick

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:37 PM
To: CF-Talk
Subject: MS Access JOIN Error


I'm getting the following error when trying to do a left join from an Access
database from CF. I really don't know what I'm doing. Any clues would be
appreciated 


Error Diagnostic Information ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Join expression not
supported.  

SQL = 
"SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS
MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA
Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close,
"MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA
Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor 

FROM "MPA log" LEFT JOIN "52 log" 
ON 'MPA log.MPA #' = '52 log.MPA #'"  

Data Source = "HRTRACKER"  The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44

Thanks in Advance

> Doug Kronenberger
> OI National Training and Education Office
> Depatment of Veterans Affairs
> 
> 440-526-3030 x7776
[EMAIL PROTECTED]



**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfloop vs cfoutput

[Kola Oyedeji]

Sorry for the crosspost (had conflicting answers from other lists)

but is there a consensus on which method of looping over a query is fastest?

cfloop or cfoutput..

Cheers

KOLa


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MS Access JOIN Error

[Garza, Jeff]

No, Access only allows a LEFT JOIN.

Try Creating the query in the Access Query builder and paste to your CMFL
template.  This is by far the easiest way I found to deal with Access's
squirly SQL syntax...

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 09, 2001 7:32 AM
To: CF-Talk
Subject: RE: MS Access JOIN Error


Not sure about Access but in SQL you have to specify the fact that it's an
outer join so instead of LEFT JOIN use LEFT OUTER JOIN.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 15:37
To: CF-Talk
Subject: MS Access JOIN Error


I'm getting the following error when trying to do a left join from an Access
database from CF. I really don't know what I'm doing. Any clues would be
appreciated 


Error Diagnostic Information ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Join expression not
supported.  

SQL = 
"SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS
MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA
Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close,
"MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA
Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor 

FROM "MPA log" LEFT JOIN "52 log" 
ON 'MPA log.MPA #' = '52 log.MPA #'"  

Data Source = "HRTRACKER"  The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44

Thanks in Advance

> Doug Kronenberger
> OI National Training and Education Office
> Depatment of Veterans Affairs
> 
> 440-526-3030 x7776
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [Object Oriented CFML]

[Garza, Jeff]

If I remember correctly, Neo will actually be a full set of JSP Custom tags
to convert the CFML to appropriate Java syntax (which will be compiled to a
servlet class file).  It's pretty much the same as using the Jrun custom
tags  like <%jrun:sql%>.  This will be some really cool technology as you
should also be able to intermix pure Java with CF in the same template.
Heard this from a Jrun seminar a few months ago...

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 09, 2001 2:44 AM
To: CF-Talk
Subject: RE: [Object Oriented CFML]


Nick

Yeh I thought that sounded pretty interesting too!  I'm the first person to
admint that serverlets are pretty coollightning quick if I remember
correctly.  What bothers/worries me is how you can convert your cfml code
into a serverlet without losing anything in the translation..we'll just
have to wait and see I guess.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 10:01
To: CF-Talk
Subject: RE: [Object Oriented CFML]


>Can you call a JSP page as an object, pass parameters to it,
have its variables and such encapsulated, etc? 

You can't do this with a JSP per se, but you can call Java
classes from within a JSP.

You can do it with a servlet. A servlet is a Java class.

A JSP interpreter such as JRun turns JSP's into servlets.
You can write servlets directly without the JSP stage.

JRun also provides the servlet engine, i.e. the other Java
classes you need to actually run the servlet.

Neo, on the other hand, also turns CFML templates into
Java servlets... which I think is pretty interesting.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Uploading a file

[Craig Dudley]

you are missing the accept paramater, 




This could very well be your problem, I think the mime type for Word docs is
"application/ms-word"

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 17:41
To: CF-Talk
Subject: Uploading a file


Hi,
I am trying to upload a file on a server using CFFILE.  All is well in
development, however on live server I get the following error:

Error Occurred While Processing Request
Error Diagnostic Information
Request canceled or ignored by serverServer busy or unable to fulfill
request. The server is unable to fulfill your request due to extremely high
traffic or an unexpected internal error. Please attempt your request again
(if you are repeatedly unsuccessful you should notify the site
administrator). (Location Code: 26)

The code I use to upload file is:



Is this error simply a server problem or is it to do with CFFILE.

Cheers,
Nick.
 


-Original Message-
From: Foggy, Doreen [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 17:16
To: CF-Talk
Subject: RE: CFFILE


I don't think it is a permission problem.  I set the permission on the
folder to everyone and still received the same error. It may be a network
problem.  When I upload the file to my hard drive destination path="c:\"  It
works.  Any other path on my server returns the same error.  Please
advise...


Error Diagnostic Information
Error processing CFFILE

The directory specified in the DESTINATION attribute of the CFFILE tag (g:\)
is not valid. The directory either does not exist or is not accessible by
the ColdFusion service.

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (21:1) to (24:33).


-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 11:48 AM
To: CF-Talk
Subject: Re: CFFILE


If you are using UNC paths then you need to run CF under a user account with
rights to the folder on the other server.  By default,
CF runs under the system account.  You can change this in the NT Services
applet.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server


- Original Message -
From: "Foggy, Doreen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 11:43 AM
Subject: CFFILE


> Error Diagnostic Information
> Error processing CFFILE
> The directory specified in the DESTINATION attribute of the CFFILE tag
> chh-test\www\lmts_int\cic is not valid. The directory either does not
exist
> or is not accessible by the ColdFusion service.
> The error occurred while processing an element with a general identifier
of
> (CFFILE), occupying document position
>
>
> I am using the CFFILE tag for the first time and I am running into some
> problems.  Please Help!  The directory does exist and I am not sure what
> accessible by the ColdFuison service means.  The directory is located on
the
> web server.
> * I have two forms
> * upload.cfm (html form)
> * uploadfile.cfm (action page)
>
> The syntax for both is located below:
>
> Upload.cfm
> WebStar: Contracts Online
> 
>  vlink="Yellow" alink="White">
> 
> 
> 
>  border="0">
> 
>   File to upload:
>   
> 
>   
> 
> 
>   File Destination:
>   
>value="\\chh-test\www\lmts_int\cic" size="50">
>
>   
> 
>   
>    
> 
> 
> 
>
> Upload.cfm
> WebStar: Contracts Online
> 
>  vlink="Yellow" alink="White">
> 
> 
>  filefield="FileName"
> destination="#form.FileDestination#"
> nameconflict="OVERWRITE">
> 
> 
> CF 3.1 CFFILE Tag File Upload Demonstration Results - Example 1
> File Upload was Successful! Information about the file is detailed below.
> 
> 
> 
> File Information
> 
> File
> Name:#File.ServerDirectory#\#FILE.ServerFile#
> Content Type:#File.ContentType#
> 
> 
> Content SubType:
> #File.ContentSubType#
> Client Path:
#File.ClientDirectory#
> 
> 
> Client File:#File.ClientFile#
> Client
> FileName:#File.ClientFileName#
> 
> 
> Client
FileExt:#File.ClientFileExt#
> Server Path:#File.ServerDirectory#
> 
> 
> Server File:#File.ServerFile#
> Server
> FileName:#File.ServerFileName#
> 
> 
> Server
FileExt:#File.ServerFileExt#
> Attempted
> ServerFile:#File.AttemptedServerFile#
> 
> 
> File Existed?#File.FileExisted#
> File Was Saved?#File.FileWasSaved#
> 
> 
> File Was
> Overwritten?#File.FileWasOverWritten#
> File Was
> Appended?#File.FileWasAppended#
> 
> 
> File Was
> Renamed?#File.FileWasRenamed#
> File Size:#File.Filesize#
> 
> 
> Old File Size:#File.OldFileSize#
> Date Last
> Accessed:#DateFormat(File.DateLastAccessed,'DD MMM YY')#
> 
> 
> Date/Time
> Created:#DateFormat(File.TimeCreated,'DD MMM YY')#
> #Timeformat(File.TimeCreated,'HH:MM:SS')#
> Date/Time
> Modified:#DateFo

RE: test

[Thomas Chiverton]

Sorted now.

Thanks to those who replied.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists