Re: URL parameter in a Frame

[Brett Payne-Rhodes]

Ummm, why can't you pass a URL parameter to a frame? I do it all the
time and it seems to work for me... Is it that you are passing it to the
frameset but not then passing it to the relevant frame?

For example, if I have a frameset called diary.cfm which has two frames
diaryCalendar.cfm and diaryPage.cfm I might pass in the date that I want
to use to initialise each frame. To do this I might use a link on a page
like Diary

diary.cfm would then look like:














HTH

Brett Payne-Rhodes
B)


Tim Bahlke wrote:
> 
> I ask for some advice on if this is the best way to pass a URL parameter to
> a nested frame.
> 
> In application.cfm I have
> 
> 
> 
> 
> 
> The frame cannot access the URL parameter directly so I though of this work
> around.  Am I going to run into problems down the road if I do this?
> 
> Thanks.
> 
> 
> Tim Bahlke, CIFO
> thinkcreate.com
> p. 336.230.0575
> f. 336.230.0083
> 
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Stored Procedure

[Sean Renet]

So Dave, how would you rewrite this SP using DECODE to dynamically set the
ORDER BY?

CREATE PROCEDURE webclientacctholddaily @caccountid int, @OrderBy
varchar(50)
AS
DECLARE @mySQL nvarchar(500)
SET @mySQL = N'SELECT holdings.*,securities.* FROM holdings, securities
WHERE holdings.secid = securities.secid AND holdings.accountID=@xparam ORDER
BY '+ @OrderBy
EXEC sp_executeSQL @mySQL , N'@xparam int', @caccountid

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 7:19 AM
Subject: RE: Stored Procedure


> > Does SQL have an equivalent to DECODE?
>
> Yes - CASE. Here's a comparison from SQL Server Books Online:
>
> Oracle:
> DECODE (test_value,
> expression1, value1
> [[,expression2, value2] [...]]
> [,default_value]
> )
>
> SQL Server:
> CASE test_value
> WHEN expression1 THEN value1
> [[WHEN expression2 THEN value2] [...]]
> [ELSE default_value]
> END
>
> In addition, T-SQL provides several functions which provide similar
if-then
> functionality, such as NULLIF and COALESCE.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Form to CFMAIL Sending Attachment Problem

[KJis18]

Ok what i am trying to do is send a "resume" document from a file field in a 
form, to the next page which will process it as a MIMEATTACH in the CFMAIL 
Tag.  For some reason, it does it correctly, but it does not show the right 
file attached, all it shows is a .tmp file.

Can someone help me?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Credit Card Number Parameters

[Seth Petry-Johnson]

> Has anyone got a list of the values for credit card numbers like if the
number begins with
> "6" it's a Discover Card, etc, etc.

4 = Visa
5 = Mastercard
6 = Discover (at least according to you, I don't know for sure )

> I'd like to write some javascript validation using the information hidden
within the numbers.

If you want to do validation then there are a number of pre-written
validation scripts already written that not only validate that the given
number is valid (based upon a series of math tests against the number) but
also that the supplied expiration date has not already passed.

You may want to head over to Javascripts.com or SiteExperts.com and see if
you can find one... no sense in re-inventing the wheel, as they say.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: using at rather than cfschedule

[Jim McAtee]

Create a batch file and schedule the batch file using AT.  In the batch
file you need to set an environment variable indicating the location of
the cf template.  Optionally, you can set whatever values you'd want in
your CGI query string (url parameters).

Example:

@echo off
set "QUERY_STRING=RequestTimeout=1800"
set CF_TEMPLATE_PATH=d:\web\somedirectory\gen.cfm
c:\cfusion\bin\cfml.exe


Jim



-Original Message-
From: Jason Egan <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Date: Friday, June 23, 2000 7:18 PM
Subject: using at rather than cfschedule


>WAAAY back there was a post on using the NT AT command rather than
>cfschedule -- is cfschedule better in 4.5? -- if not, does anyone know
the
>correct way to use AT to run a CFM script?
>
>Thanks
>je

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Shopping Mall Application

[Sim Graves]

Dear Shane,

Thanks for the AbleCommerce source.  It looks real promising for my project and 
certainly inexpensive enough.

You're a pal for taking your time to help me.

Sim

Shane Witbeck wrote:

> AbleCommerce.
>
> Sincerely,
>
> Shane Witbeck
> Webmaster
> [EMAIL PROTECTED]
> www.digitalsanctum.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Shopping Mall Application

[Steve Pierce]

Just FYI CartEase is $249 for 5 stores with 1yr support and upgrades.

 - Steve


-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 10:18 PM
To: [EMAIL PROTECTED]
Subject: RE: Shopping Mall Application


Sim,

In addition to AbleCommerce, take a look at Cartease,
http://www.cartease.com.  I'm in the process of evaluating it against a
couple other low-cost shopping carts, but it might be what you need.  It
(version 2) has the capability to let affiliates create and generate
stores.  Download the demo and play with it some.

Chris Montgomery   [EMAIL PROTECTED]
:: Web development/Consulting  http://www.astutia.com ::
:: Allaire Consulting Partner/ NetObjects Reseller::
:: 210-490-3249/888-745-7603   Fax 210-490-4692   ::
:: Find a Job in San Antonio   http://www.sajobnet.com::


>-Original Message-
>From: Sim Graves [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 8:22 PM
>To: [EMAIL PROTECTED]
>Subject: Shopping Mall Application
>
>
>
>I've created a few individual stores in CF/FuseBox  but my
>client wants to create a mall where members can build their
>own stores through an HTLM interface. Have any of you created
>such a critter that I could purchase.  I think it would be
>more cost effective for my client  to purchase this
>application rather than having me reinvent the wheel.
>
>TIA
>
>Sim Graves


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Shopping Mall Application

[Chris Montgomery]

Sim,

In addition to AbleCommerce, take a look at Cartease,
http://www.cartease.com.  I'm in the process of evaluating it against a
couple other low-cost shopping carts, but it might be what you need.  It
(version 2) has the capability to let affiliates create and generate
stores.  Download the demo and play with it some.

Chris Montgomery   [EMAIL PROTECTED]
:: Web development/Consulting  http://www.astutia.com ::
:: Allaire Consulting Partner/ NetObjects Reseller::
:: 210-490-3249/888-745-7603   Fax 210-490-4692   ::
:: Find a Job in San Antonio   http://www.sajobnet.com::


>-Original Message-
>From: Sim Graves [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 8:22 PM
>To: [EMAIL PROTECTED]
>Subject: Shopping Mall Application
>
>
>
>I've created a few individual stores in CF/FuseBox  but my
>client wants to create a mall where members can build their
>own stores through an HTLM interface. Have any of you created
>such a critter that I could purchase.  I think it would be
>more cost effective for my client  to purchase this
>application rather than having me reinvent the wheel.
>
>TIA
>
>Sim Graves

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Shopping Mall Application

[Shane Witbeck]

AbleCommerce.

Sincerely,

Shane Witbeck
Webmaster
[EMAIL PROTECTED]
www.digitalsanctum.com




-Original Message-
From: Sim Graves [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 9:22 PM
To: [EMAIL PROTECTED]
Subject: Shopping Mall Application



I've created a few individual stores in CF/FuseBox  but my client wants to
create a mall where members can build their own stores through an HTLM
interface. Have any of you created
such a critter that I could purchase.  I think it would be more cost
effective for my client  to purchase this application rather than having me
reinvent the wheel.

TIA

Sim Graves


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Shopping Mall Application

[Sim Graves]

I've created a few individual stores in CF/FuseBox  but my client wants to create a 
mall where members can build their own stores through an HTLM interface. Have any of 
you created
such a critter that I could purchase.  I think it would be more cost effective for my 
client  to purchase this application rather than having me reinvent the wheel.

TIA

Sim Graves

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

using at rather than cfschedule

[Jason Egan]

WAAAY back there was a post on using the NT AT command rather than
cfschedule -- is cfschedule better in 4.5? -- if not, does anyone know the
correct way to use AT to run a CFM script?

Thanks
je

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: not cfinclude, but...

[C]

At 04:50 PM 6/23/00 -0400, you wrote:
>I'll try and make this as clear as possible...
>
>What I am attempting to do is include header and footer pages on any given
>document.  These are .htm pages, and are not on a cold fusion server so I
>can't use .  Is there a way, and where do I find the resources to
>do this?
>
>Please email me off the list.


Well, you can use CFINCLUDE without using .cfm files.. I do it all the 
time; using



...

I've got  statements that determine which static HTML template to 
load, and I've never had a problem using CFINCLUDE to handle this; I've 
seen CFINCLUDE to also include plain .TXT files, I'm unsure of why the 
assumption is you can't use a




Or am I missing something here... ?

CW

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Credit Card Number Parameters

[Sim Graves]

Has anyone got a list of the values for credit card numbers like if the number begins 
with "6" it's a Discover Card, etc, etc.

I'd like to write some javascript validation using the information hidden within the 
numbers.

TIA

Sim Graves

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: not cfinclude, but...

[Dana Larose]

If think there is a way if your are using server side includes, the #include
directive or something like that.  (All you have to do is tell your
webserver to accept .shtml pages).  This may not work, as it has been a LONG
time since I've done anything with SSI.

If you are stuck with just .htm pages, you can use frames, but they look
ugly.  One last recommendation is to use software like Dreamweaver, which
makes it easy to create template pages and use those templates for an entire
site.  If you update the templates, then all the pages are updated.

Dana

-Original Message-
From: Steve Dworman <[EMAIL PROTECTED]>
To: Cold Fusion <[EMAIL PROTECTED]>
Date: Friday, June 23, 2000 7:01 PM
Subject: not cfinclude, but...


>I'll try and make this as clear as possible...
>
>What I am attempting to do is include header and footer pages on any given
>document.  These are .htm pages, and are not on a cold fusion server so I
>can't use .  Is there a way, and where do I find the resources
to
>do this?
>
>Please email me off the list.
>
>Thanks in advance,
>
>Steven D. Dworman
>--
>Cold Fusion Developer
>Stoneage.com - HUNT, GATHER, DRIVE
>http://www.stoneage.com
>Phone:  877-846-7560 (direct)
>Cell:   517-281-8121
>--
>
>-
>STONEAGE.COM is nationally ranked as one of the Top 10 Online Auto Sites,
>and was recently awarded an overall rating of EXCELLENT from PC Magazine.
>-
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: not cfinclude, but...

[ron]

> What I am attempting to do is include header and
> footer pages on any given
> document.  These are .htm pages, and are not on a
> cold fusion server so I
> can't use .  Is there a way, and where do
> I find the resources to
> do this?

Steve,

Check out the  tag. With it, you can grab another site's
content, and display it like any other variable. You'll probably
want to grab it on schedule, however, so that your template
isn't going out across the internet twice on every page load to
get the content.

hth,
ron

http://humankindsystems.com



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

random record query retrieval

[Richard Mazur]

Hi.

I have a database of 4,000 or so records. I would like to do a query based
on some conditions (i.e. where active =1 AND group_id = 45). I can do this.
The problem I have having is that out of the conditional query I would like
to pull a random 3 records out and have use and be able to output the data
in those random 3 rows. So, to recap...4,000 records in a database. I
might have a query where 500 out of the 4,000 match my conditional criteria.
Out of that 500 that gets returned in the query I would like to select a
random 3 out of only that 500 returned and have use of the data.. Can anyone
help?

Richard Mazur

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[Anthony Israel-Davis]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFDD6E.32B327EA
Content-Type: text/plain;
charset="iso-8859-1"

Don't know what's up without seeing the code.  Off the top of my head, I
would say loop through the list and check against each item.  There's also
the "contains" key word which might be useful...Again have to see the
query/CFML to answer adequately.  

Email me offlist if you need a quick answer, cuz I'm almost outta here.  Of
course, there are plenty of far more able and knowledgable folks than me on
this list who could give you an answer as well...

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Inserting Multiple Values into One Database Field


hey there, thanks for the Tip Anthony, but when I search  like two words, it

won't pick it up, it only picks up the first word i put in my search
box. 
 

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--_=_NextPart_001_01BFDD6E.32B327EA
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Inserting Multiple Values into One Database Field



Don't know what's up without seeing the code.  =
Off the top of my head, I would say loop through the list and check =
against each item.  There's also the "contains" key word =
which might be useful...Again have to see the query/CFML to answer =
adequately.  

Email me offlist if you need a quick answer, cuz I'm =
almost outta here.  Of course, there are plenty of far more able =
and knowledgable folks than me on this list who could give you an =
answer as well...

ant


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 4:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Inserting Multiple Values into One =
Database Field



hey there, thanks for the Tip Anthony, but when I =
search  like two words, it 
won't pick it up, it only picks up the first word i =
put in my search box. 
 
---=
---
Archives: http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.



--_=_NextPart_001_01BFDD6E.32B327EA--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

not cfinclude, but...

[Steve Dworman]

I'll try and make this as clear as possible...

What I am attempting to do is include header and footer pages on any given
document.  These are .htm pages, and are not on a cold fusion server so I
can't use .  Is there a way, and where do I find the resources to
do this?

Please email me off the list.

Thanks in advance,

Steven D. Dworman
--
Cold Fusion Developer
Stoneage.com - HUNT, GATHER, DRIVE
http://www.stoneage.com
Phone:  877-846-7560 (direct)
Cell:   517-281-8121
--

-
STONEAGE.COM is nationally ranked as one of the Top 10 Online Auto Sites,
and was recently awarded an overall rating of EXCELLENT from PC Magazine.
-

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Inserting Multiple Values into One Database Field

[KJis18]

hey there, thanks for the Tip Anthony, but when I search  like two words, it 
won't pick it up, it only picks up the first word i put in my search box. 
 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL Server 6.5 Problem

[Mark Rogers]

SQL Server Problem

We have been running Sequel Server 6.5 (SQL 6.5, NT 4.0 SP5) uneventfully
for some time now.

While rebooting the server today received the following error message
"unable to start SQLSERVER SERVICES due to internal NT error". No changes or
upgrades have been made to the server other than upload of latest McCaffee
Anti-virus super dat files.

Not much to go on... any thoughts would be appreciated... would also
appreciate hearing if anyone has experienced problems with NT4.0 SP.

Thanks!

Mark


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[Anthony Israel-Davis]

Doh! - sorry about the last post hit send when going for 'file'. Anyhoo - 

Worked fine for me - I'm using SQL Server7, BTW...maybe I misunderstood the
question but '#var1# #var2 #var3...#' works fine with MSSS7.

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 3:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Inserting Multiple Values into One Database Field



That should throw a SQL error.  What you need to do is create the list
outside of your query statement.




INSERT INTO search(keywords)
VALUES('#keywords#')


--K


Katrina Chapman
Consultant
Ameriquest Mortgage


 

Anthony

Israel-Davis To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>

Subject: RE: Inserting Multiple
Values into One Database Field 
 

06/23/00

03:06 PM

Please

respond to

cf-talk

 

 




Try this:


INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')


remove the "AND"s and wrap the whole thing in single quotes.  Hope that
helps

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field


Ok, what i am trying to do is add a column in my database that would
contain

"Keywords" for a search.

What i am trying to do is add values from the data entered in the form from

the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???


INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')


Help?

-kev


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Parsing Data to the same page

[Jon Boehnker]

the name of the form needs to be different from the name of the select box..
right now you have them both set to 'area'.

HTH

Jon




- Original Message -
From: WL <[EMAIL PROTECTED]>
To: "Dana Larose" <[EMAIL PROTECTED]>
Cc: Cold Fusion Talk <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 6:24 PM
Subject: Re: Parsing Data to the same page


>
>
> > If I understand you correctly, you want the second version of your SQL
> > statement to happen only if the user selects a category, otherwise use
the
> > first.
>
> OK well I've uses your idea but have come across a really irritating
> problem.  Obviously this select is only on the 2nd page, but the error is
> "the specified form object cannot be found" - why?  It's there, it's
> specified, why can't it see it?!
>
> I'm sorry I'm being so dumb..here's my code:
>
> 
> SELECT county FROM locations
> 
> 
>   
> 
>   
value="#County.county#">#County.county# tput>
>   
>   
>   
> 
>
> 
> SELECT * FROM categories WHERE id = 1
> 
> AND county is '#form.area#'
> 
>
>
> Seems fine to my eyes :(
>
> TIA
>
> Will
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[Anthony Israel-Davis]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFDD65.9C442DD4
Content-Type: text/plain;
charset="iso-8859-1"



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 3:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Inserting Multiple Values into One Database Field



That should throw a SQL error.  What you need to do is create the list
outside of your query statement.




INSERT INTO search(keywords)
VALUES('#keywords#')


--K


Katrina Chapman
Consultant
Ameriquest Mortgage


 

Anthony

Israel-Davis To:
"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>

Subject: RE: Inserting Multiple
Values into One Database Field 
 

06/23/00

03:06 PM

Please

respond to

cf-talk

 

 




Try this:


INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')


remove the "AND"s and wrap the whole thing in single quotes.  Hope that
helps

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field


Ok, what i am trying to do is add a column in my database that would
contain

"Keywords" for a search.

What i am trying to do is add values from the data entered in the form from

the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???


INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')


Help?

-kev


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--_=_NextPart_001_01BFDD65.9C442DD4
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Inserting Multiple Values into One Database Field





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 3:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Inserting Multiple Values into One =
Database Field




That should throw a SQL error.  What you need to =
do is create the list
outside of your query statement.






INSERT INTO search(keywords)
VALUES('#keywords#')



--K


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Katrina Chapman
Consultant
Ameriquest Mortgage



  &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp; 

  &nb=
sp; =
Anthony   =
;=
;=
;=
;=
;=
;=
;=
;  

  &nb=
sp; =
Israel-Davis =
To: "'[EMAIL PROTECTED]'" =
<[EMAIL PROTECTED]>  &nb=
sp;   &nb=
sp;   

  &nb=
sp; =
  =
  Subject: RE: Inserting Multiple Values =
into One Database =
Field   &=
nbsp; 

  &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp;   &nb=
sp; 

  &nb=
sp; =
06/23/00  &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p; 

  &nb=
sp; 03:06 =
PM   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;   &nbs=
p;    

  &nb=
sp; 

Re: Parsing Data to the same page

[Brian Peddle]

What you are attempting to do will not work this way.  Cold Fusion processes the page 
on the server and returns HTML to the client.  If someone choices something in select 
box 1, you cant run a query to get select box two unless you submit the page again.

There are 3 options I know of.

1. After select box 1 is picked use Javascript to do an onchange to reload the page 
and pass the form field in and reload the page with select box 2 data.

2. Depending on the # of possible result sets hard code the values in javascript based 
on the 1st select box only certain things in select box are shown.

3. Use urlPipe from kisai.com which is a free java applet that allows you to make a 
call to a page to get information live and populate the select box.  I havent has much 
exeperience with this but if you do some research on this way would be the best and 
coolest way to do it.
If anyone has any good example is this please post.

-- Original Message --
From: "WL" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 23 Jun 2000 23:24:59 +0100

>

> If I understand you correctly, you want the second version of your SQL
> statement to happen only if the user selects a category, otherwise use the
> first.

OK well I've uses your idea but have come across a really irritating
problem.  Obviously this select is only on the 2nd page, but the error is
"the specified form object cannot be found" - why?  It's there, it's
specified, why can't it see it?!

I'm sorry I'm being so dumb..here's my code:


SELECT county FROM locations


  

  #County.county#
  
  
  



SELECT * FROM categories WHERE id = 1

AND county is '#form.area#'



Seems fine to my eyes :(

TIA

Will

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[KChapman]

That should throw a SQL error.  What you need to do is create the list
outside of your query statement.




INSERT INTO search(keywords)
VALUES('#keywords#')


--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
 
Anthony
 
Israel-Davis To: "'[EMAIL PROTECTED]'" 
<[EMAIL PROTECTED]>  
Subject: RE: Inserting Multiple Values 
into One Database Field 
   
 
06/23/00   
 
03:06 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 



Try this:


INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')


remove the "AND"s and wrap the whole thing in single quotes.  Hope that
helps

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field


Ok, what i am trying to do is add a column in my database that would
contain

"Keywords" for a search.

What i am trying to do is add values from the data entered in the form from

the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???


INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')


Help?

-kev


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Parsing Data to the same page

[WL]

> If I understand you correctly, you want the second version of your SQL
> statement to happen only if the user selects a category, otherwise use the
> first.

OK well I've uses your idea but have come across a really irritating
problem.  Obviously this select is only on the 2nd page, but the error is
"the specified form object cannot be found" - why?  It's there, it's
specified, why can't it see it?!

I'm sorry I'm being so dumb..here's my code:


SELECT county FROM locations


  

  #County.county#
  
  
  



SELECT * FROM categories WHERE id = 1

AND county is '#form.area#'



Seems fine to my eyes :(

TIA

Will

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Serving Dynamic RA and WMP

[Dirk De Bock]

You can do this with CF :

rstp://www.yourserver.com#rasrc#

in a file by itself

So you give the correct path in the parameter 'rasrc'

I never tried this with Windows Media but there's no reason it won't work
the same way

- Original Message -
From: "Duane Boudreau" <[EMAIL PROTECTED]>

> The problem I need to fix is how do I write one file that is able to serve
> the content for all asx and smil dynamically


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Inserting Multiple Values into One Database Field

[Anthony Israel-Davis]

Try this:


INSERT INTO search(keywords)
VALUES('#name#,#address#,#phone#')


remove the "AND"s and wrap the whole thing in single quotes.  Hope that
helps

ant

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:56 PM
To: [EMAIL PROTECTED]
Subject: Inserting Multiple Values into One Database Field


Ok, what i am trying to do is add a column in my database that would contain

"Keywords" for a search.  

What i am trying to do is add values from the data entered in the form from 
the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???


INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')


Help?

-kev

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Verity Search rules

[Richard Colman]

Check out:

http://www.faculty.uci.edu/index.htm

look towards the bottom of the page and you will see another attempt to
provide concise user instructions for a rather complex set of rules.

Good luck.

Richard Colman


-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 2:43 PM
To: [EMAIL PROTECTED]
Subject: Re: Verity Search rules


I put as much as I thot users could put up with
at http://www.cbee.org/search.html

best,  paul

At 05:04 PM 6/23/00 -0400, you wrote:
>I am using verity to search my web site, and I need to have an explanation
>describing the rules and syntax of a verity search for my users.  Does
>anyone have these instructions on a page that they would be willing to
>share?
>
>___
>Robert M. Saxon, Jr. (Rob), Senior Web Developer
>Mercer University
>Department of Web Management
>TSS // 1400 Coleman Avenue // Macon, GA 31207
>912-301-5550 voice // 912-301-5314 fax
>[EMAIL PROTECTED]
>Philippians 4:13
>
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Verity Search rules

[paul smith]

I put as much as I thot users could put up with
at http://www.cbee.org/search.html

best,  paul

At 05:04 PM 6/23/00 -0400, you wrote:
>I am using verity to search my web site, and I need to have an explanation
>describing the rules and syntax of a verity search for my users.  Does
>anyone have these instructions on a page that they would be willing to
>share?
>
>___
>Robert M. Saxon, Jr. (Rob), Senior Web Developer
>Mercer University
>Department of Web Management
>TSS // 1400 Coleman Avenue // Macon, GA 31207
>912-301-5550 voice // 912-301-5314 fax
>[EMAIL PROTECTED]
>Philippians 4:13
>
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Parsing Data to the same page

[Dana Larose]

If I understand you correctly, you want the second version of your SQL
statement to happen only if the user selects a category, otherwise use the
first.

Presumably, your select box will look like:


All Categories
1
...


All you need is to have your query look like:

SELECT *
FROM advert_details
WHERE county = '#Form.county#'

AND category = #Form.category#


Hope that helps,

Dana

-Original Message-
From: WL <[EMAIL PROTECTED]>
To: Cold Fusion Talk <[EMAIL PROTECTED]>
Date: Friday, June 23, 2000 4:22 PM
Subject: Parsing Data to the same page


>Hi,
>
>This is going to seem trivial for all of you, but I hope you can spare me a
>min.
>
>I have a page, in which I want it to modify a SQL query depending on a
>users' selection.  For exampls, the following SQL:
>
>SELECT * FROM advert_details WHERE county = 'berks'
>
>What I need to do is have a Select drop down box, which I have dynamically
>populated, as a second option - "To filter data, please choose a
category" -
>then that would modify the SQL,hopefully, to read:
>
>SELECT * FROM advert_details WHERE county = 'berks' and category = 143
>
>How can I do this?
>
>Thanks,
>
>Will
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Parsing Data to the same page

[WL]

Hi,

This is going to seem trivial for all of you, but I hope you can spare me a
min.

I have a page, in which I want it to modify a SQL query depending on a
users' selection.  For exampls, the following SQL:

SELECT * FROM advert_details WHERE county = 'berks'

What I need to do is have a Select drop down box, which I have dynamically
populated, as a second option - "To filter data, please choose a category" -
then that would modify the SQL,hopefully, to read:

SELECT * FROM advert_details WHERE county = 'berks' and category = 143

How can I do this?

Thanks,

Will

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Verity Search rules

[Robert M. Saxon, Jr.]

I am using verity to search my web site, and I need to have an explanation
describing the rules and syntax of a verity search for my users.  Does
anyone have these instructions on a page that they would be willing to
share?

___
Robert M. Saxon, Jr. (Rob), Senior Web Developer
Mercer University
Department of Web Management
TSS // 1400 Coleman Avenue // Macon, GA 31207
912-301-5550 voice // 912-301-5314 fax
[EMAIL PROTECTED]
Philippians 4:13


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Inserting Multiple Values into One Database Field

[KJis18]

Ok, what i am trying to do is add a column in my database that would contain 
"Keywords" for a search.  

What i am trying to do is add values from the data entered in the form from 
the previous page to one field in the database

I only get a value of "-1"  ?  is there something i am doing wrong???


INSERT INTO search(keywords)
VALUES('#name#' AND '#address#' AND '#phone#')


Help?

-kev
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Java and CF

[Larry Meadors]

I've used createobject() successfully. Didn't look to closely at the mem use. Is it 
possible that the mem use you're seeing is the jvm?

We just had a thread about cfx tags in java. Read it before going that route unles you 
*like* to restart services...

   ;-)

Larry

>>> [EMAIL PROTECTED] 06/23/00 11:08AM >>>
Using CFOBJECT is not the best way eh?

So 4.5 now allows CFX's to be written in Java I always thought it was just
C?  If I recompile the Java Code will I have to register the  CFX's again

-Original Message-
From: Conrad, Christopher [mailto:[EMAIL PROTECTED]] 

CFX_J or CFX's on 4.5x

> -Original Message-
> From: Trahan, Shane [SMTP:[EMAIL PROTECTED]] 
> 
> What is the best way to use Java and CF? I have tried using CFOBJECT but
> have had alot of problems with it not releasing memory etc..  How can I
> best leverage Java and CF?
> 
> If anyone has any insight into Java and CFOBJECT please let me know!! I have
> been trying to figure out why CFOBJECT doesn't release the memory after
> the class has been called from the CFOBJECT


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Running Stored Procedures on AS/400 or DB2???

[Robert Everland]

I don't think AS/400 can do stored procedures. I know DB2 can but not the
flavor of DB2 that the AS/400 runs. YOu can get an add on SQL tool for
AS/400 to run stored procedures though. We are using AS/400 with JDEdwards
to do a ton of stuff and are getting the SQL add on. I do find that the
client access isn't the best way to communicate with the database.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 3:08 PM
To: [EMAIL PROTECTED]
Subject: Running Stored Procedures on AS/400 or DB2???



Hello all,
  I am trying to run a Stored Procedure on an AS/400
using DB2 Connect and Client Express ODBC Connectors.
Neither of them work. Have you guys been able to run stored procedures
on AS/400 or Db2 successfully? Appretiate any help.

Thanks
Joe


-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Serving Dynamic RA and WMP

[Duane Boudreau]

Hi All,

I've been trying to wrap my head around this one all day and either going to
have to give up and hit the margaritas or ask the experts. I have a client
(whom shall remain unnamed) that is having problems serving RA and WMP files
in Netscape. The problem is that the content is being served from a second
server as mms:// for WMP and rstp:// for RA. This causes netscape to try and
put www in front. The fix for this is top create an ASX and SMIL file that
contains the location information. My new problems is that there are over
400 interviews and growing rapidly.

The problem I need to fix is how do I write one file that is able to serve
the content for all asx and smil dynamically. I have the mime types setup in
IIS for ASX and SMIL. I tried registering the ASX and SMIL extensions as CF
templates but that seems to change the mime type as the generated files do
not cause a media player to be called.

Is there another possibility that I am missing? Could this be done with
CFCONTENT?

Help.

Duane

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Running Stored Procedures on AS/400 or DB2???

[joeug]

Hello all,
  I am trying to run a Stored Procedure on an AS/400
using DB2 Connect and Client Express ODBC Connectors.
Neither of them work. Have you guys been able to run stored procedures
on AS/400 or Db2 successfully? Appretiate any help.

Thanks
Joe


-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

OT: ASP Mailing Lists (asp-talk?)

[Billy Cravens]

I've recently begun a contract where the skillset requires both ASP and
CF.  In addition to brushing up on my ASP skills (been over a year since
I did serious development), I'd like to find a list of the same quality
as this one for ASP.  There's so many of them out there, I thought I'd
ask for suggestions before I start wasting space on the mail server.
Thanks.

--
Billy Cravens
[EMAIL PROTECTED]


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: check-box editing

[Christine Kelley]

Thanks Mike!!
You gave me the clue I needed. - I set some of the info equal to
variables and then put it all together.
Thanks again,
Christine


- Original Message -
From: "Mike Hughes" <[EMAIL PROTECTED]>
To: "Christine Kelley" <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 2:43 PM
Subject: Re: check-box editing


> Hello Christine,
>
> You may tried something like this
>
> 
>
> 
>
> I don't know what type of data the "groups" column is. When I use a
> check box I setup the data type as a number, 0 not checked  - 1
> checked. And I also name the checkbox a difference name then the
> others boxes.
>
> 
> 
> Hope this helps
>


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Win2k or NT?

[Dave Watts]

> I'm going to be getting a dedicated server for my personal
> website from Digital Nation very soon (being with Interland
> is really starting to suck). I'll be buying CF 4.5 and SQL
> Server 7 and I'm trying to decided if I should go with NT
> or 2000. I've heard a lot of good things (as well as a lot of
> bad) about 2k, so I'm curious to hear which people recommend.
> Thanks.

I'd have no reservations about recommending Win2K Server as a standalone,
dedicated web/CF server. There are lots of improvements to IIS and TCP/IP in
Win2K, and from a general system stability perspective, I've had less
trouble with my own personal development machine using Win2K. Admittedly I
haven't used it on a production web server yet. I'd be a bit less
enthusiastic about using it as a major part of an existing domain
infrastructure, though, if for no other reason but that I haven't seen how
it works there.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SourceSafe integration

[Ken Goldstraw]

Hello fine CFers

What's the general consensus of CF's SourceSafe integration feature?  My
boss is considering using it.

TIA

Ken Goldstraw
Web Developer
Bigdough.com
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Win2k or NT?

[Kevin Langevin]

I run CF Server (Enterprise usually, but Pro right now) and SQL Server 7 on
my Laptop (PIII-500/288MB) which is running Win2K Advanced Server.  It
flies.  Stable...Knock on wood, my laptop has not crashed once since I
installed the software.  I have left it up and running for up to two weeks
at a time on my little LAN at home, but now I use it as my private dev
server at work, so I don't usually leave it running for long periods of
time.  I'd suggest Win2K to anyone, though.


-Kev


> -Original Message-
> From: Nick McClure [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 23, 2000 1:36 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Win2k or NT?
>
>
>  From what I have done windows 2000 is better.
>
> IIS 5 seems to be much more stable than 4
>
> At 10:52 AM 6/23/2000 -0600, you wrote:
> >I'm going to be getting a dedicated server for my personal website from
> >Digital
> >Nation very soon (being with Interland is really starting to
> suck).  I'll be
> >buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go
> >with NT
> >or 2000. I've heard a lot of good things (as well as a lot of bad) about
> >2k, so
> >I'm curious to hear which people recommend.  Thanks.
> >
> >---
> >Aaron Powell
> >Healthwell.com Web Developer
> >http://www.healthwell.com
> >
> >
> >
> >-
> -
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/c
> f_talk or
> >send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> >the body.
>
> --
> Nick McClure  [EMAIL PROTECTED]
> Technical Director606.245.9656
> squareFish Media  www.squareFish.com
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: access across LAN

[Jacob]

Create a NT user account for the cold fusion service.
Take care of all the necessary permissions (just like if it was a actually 
person accessing information across the network.
Go to Control Panel - Services.
Log on as This account.
Choose the user account you created for cold fusion.
Re start the cold fusion service.

Jacob


At 01:00 PM 6/23/00 -0400, you wrote:
>Can someone point me to a resource or examples that explains how to
>configure a cold fusion server and another NT server to enable it to access
>files on the other NT server on the same LAN... specifically, to perform
>cffile operations, writing files, reading, deleting files on the other a NT
>server.
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Win2k or NT?

[Jeremy Allen]

The real problem, most places are quietly not selling NT 4.0 anymore. You
can
 still buy it in *plenty* of places, but ive noticed more than one place
wihch has
just removed NT from its product list.


That said, I would wait for a year at least for Win2K before I trusted it
with anything even close to mission critical. Yeah im sure its nice and fine
but... If
you read about NT and how reliable it was it never become remotely stable
until ServicePack 3. Now its at Service Pack 6 and they are *still* fixing
bugs
in it? Hmmn. And W2K Is just absolutely HUGE. I really would hold off. This
is just my opinon tho. This would be one thing id just rather not learn the
hardway. Most esp since If you are looking just for SQL + ColdFusion
platform What is W2K going to offer you that NT cant? I have been running
server at home for a good 3 months now. I can leave it on to do my normal
desktop computing along with some light to moderate CF / SQL work and it
stays running for at least a week before the UI flips out from some little
memory leaks. So really.. if you do not need anything in Win2K or dont even
know what it offers then there is not a whole lot of a point. NT is tha way
to
go still :-)



Jeremy Allen
[EMAIL PROTECTED]


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: access across LAN

[mherbene]

This article
(http://www.allaire.com/Handlers/index.cfm?ID=13519&Method=Full) describes
the basic issues, even though it's about Netware servers.  You can run CF
under a domain account that has rights to both its own server and the other
one(s), or you can create a matchine account on the other machine(s).

-Original Message-
From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 1:00 PM
To: [EMAIL PROTECTED]
Subject: access across LAN


Can someone point me to a resource or examples that explains how to
configure a cold fusion server and another NT server to enable it to access
files on the other NT server on the same LAN... specifically, to perform
cffile operations, writing files, reading, deleting files on the other a NT
server.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFContent not working in IE 5

[Michael P.]

The following code works just fine in Netscape 4.x and almost works in IE 5.
In IE 5, the file is downloaded but the cursor remains as an hourglass and
the icon in the upper-right hand corner keeps spinning as if it is still
trying to get a response from the server.  

If I hit refresh all is good again. Nothing gets run after the cfcontent
tag.  I have put html, cf code, and text directly after it but to no avail.

I have tested this in the following environments...

CF Server 4.5.1 is common to all...
1. NT Workstation 4, IE 5, Netscape Web Server 2.x
2. Win98, IE 5, Personal Web Server
3. WinNT & Win98 as clients hitting a Sun Solaris box

On a page I have a listing of all files available, a user clicks on a file
with a link to another page with this code...








 

 

SOME ERROR MESSAGE


Thanks,



Michael Paulsmeyer
Infovision, Inc.
http://www.infovisioninc.com
http://www.pcs-link.com
877-727-8824 - Toll Free
[EMAIL PROTECTED]


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Win2k or NT?

[Nick McClure]

 From what I have done windows 2000 is better.

IIS 5 seems to be much more stable than 4

At 10:52 AM 6/23/2000 -0600, you wrote:
>I'm going to be getting a dedicated server for my personal website from 
>Digital
>Nation very soon (being with Interland is really starting to suck).  I'll be
>buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go 
>with NT
>or 2000. I've heard a lot of good things (as well as a lot of bad) about 
>2k, so
>I'm curious to hear which people recommend.  Thanks.
>
>---
>Aaron Powell
>Healthwell.com Web Developer
>http://www.healthwell.com
>
>
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  606.245.9656
squareFish Mediawww.squareFish.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Win2k or NT?

[Rif Kiamil]

I would wait till SP2 or 3 on Win2K.

-Original Message-
From: Aaron Powell [mailto:[EMAIL PROTECTED]]
Sent: 23 June 2000 17:52
To: [EMAIL PROTECTED]
Subject: Win2k or NT?


I'm going to be getting a dedicated server for my personal website from
Digital
Nation very soon (being with Interland is really starting to suck).  I'll be
buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go with
NT
or 2000. I've heard a lot of good things (as well as a lot of bad) about 2k,
so
I'm curious to hear which people recommend.  Thanks.

---
Aaron Powell
Healthwell.com Web Developer
http://www.healthwell.com




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Java and CF

[Trahan, Shane]

Using CFOBJECT is not the best way eh?

So 4.5 now allows CFX's to be written in Java I always thought it was just
C?  If I recompile the Java Code will I have to register the  CFX's again

-Original Message-
From: Conrad, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 12:34 PM
To: [EMAIL PROTECTED]
Subject: RE: Java and CF


CFX_J or CFX's on 4.5x

Chris

Christopher Conrad
Victoria's Secret Catalogue
http://www.VictoriasSecret.com
Senior.Programmer.Analyst
614.337.5653
[EMAIL PROTECTED]


> -Original Message-
> From: Trahan, Shane [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 23, 2000 12:08 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Java and CF
> 
> What is the best way to use Java and CF? I have tried using CFOBJECT but
> have had alot of problems with it not releasing memory etc..  How can I
> best
> leverage Java and CF?
> 
> 
> If anyone has any insight into Java and CFOBJECT please let me know!! I
> have
> been trying to figure out why CFOBJECT doesn't release the memory after
> the
> class has been called from the CFOBJECT
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

access across LAN

[Jay Wigginton]

Can someone point me to a resource or examples that explains how to
configure a cold fusion server and another NT server to enable it to access
files on the other NT server on the same LAN... specifically, to perform
cffile operations, writing files, reading, deleting files on the other a NT
server.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Win2k or NT?

[Aaron Powell]

I'm going to be getting a dedicated server for my personal website from Digital
Nation very soon (being with Interland is really starting to suck).  I'll be
buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go with NT
or 2000. I've heard a lot of good things (as well as a lot of bad) about 2k, so
I'm curious to hear which people recommend.  Thanks.

---
Aaron Powell
Healthwell.com Web Developer
http://www.healthwell.com



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CreateODBCTime question

[Gary McNeel, Jr.]

I have a tiny little schedule program that runs from MS SQL Server. This is
very simple.

In it the user enters an EventDetail, EventDate, EventStartTime and
EventEndTime. The date and time fields in SQL are DateTime datatype.

As I insert or update the records I use a CreateODBCDate for the EventDate
and CreateODBCTime for times. I use CFFORM to validate the date and time
formats.

INSERT QUERY

UPDATE tblGradOrientation
SET
EventDate = #CreateODBCDate(EventDate)#,
EventStartTime = #CreateODBCTime(EventStartTime)#,
EventEndTime = #CreateODBCTime(EventEndTime)#,
EventType = #EventType#,
EventDetail = '#EventDetail#'
WHERE GradOrientationID = #GradOrientationID#


The resulting data looks like this:
GID  EventDate   EventStartTime   EventEndTime EventDetail
EventType
12   08/23/006/20/00 9:00:00 AM   6/20/00 9:50:00 AM
Opening Remarks 1



***
In the output I sort it on first the EventDate, then the start times.

OUTPUT QUERY

SELECT tblGradOrientation.*, EventDate, EventStartTime,
EventType
FROM tblGradOrientation
ORDER BY EventDate, EventStartTime



***
Problem:
Example: When you insert (or update) a record to the system, it shows the
the EventDate in the database as 08/25/00. The times, however, show as
6/20/00 9:00:00 AM and 6/20/00 10:00:00 AM, showing the date the data was
entered. Output is fine at this point if all the data for that EventDate are
entered on the same day (06/20/00).

If someone updates the record on another day, say 06/21/00, the sorting gets
screwy. It now puts all times with the new, updated date in the EventStart
and StopTime fields at the end.

Question:
Is there a simple way to store JUST the time in a DateTime datatype field. I
would have thought that is what CreateODBCTime was for, but apparently not.
Or should I just use a char field for this.

Sorry if this is too much detail or messy. Please feel free to contact me
off-list.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Logical Limit of NT User Accounts

[Justin v0.9 MacCarthy]

FROM

http://sam.cs.unc.edu/ntfaq.html

Q. How many user accounts can I have in one Domain?

A. The real problem is that each user account and machine account takes up
space in the SAM file, and the SAM file has to be memory resident. A user
account takes up 1024 bytes of memory (a machine account half as much), so
for each person (assuming they each had one machine) would be 1.5 KB. This
would mean for a 10,000 user domain each PDC/BDC would need 15MB of memory
just to store the SAM! Imagine a network with 100,000 people. This is one of
the reasons you have multiple domains and then setup trust relationships.

FROM

http://sam.cs.unc.edu/ntfaq.html



~Justin MacCarthy


- Original Message -
From: David B. Brooks <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 5:17 PM
Subject: Logical Limit of NT User Accounts


> Greetings All,
>
> I'm going to utilize Cold Fusion's Advanced Security using my local NT
> Domain for authentication.  Does anyone know the logical limit to the
number
> of users NT can handle in its database?
>
> Thanks for all the info!
>
> David Brooks
> PC Pros, Inc.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

URL parameter in a Frame

[Tim Bahlke]

I ask for some advice on if this is the best way to pass a URL parameter to
a nested frame.

In application.cfm I have





The frame cannot access the URL parameter directly so I though of this work
around.  Am I going to run into problems down the road if I do this?

Thanks.


Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Java and CF

[Conrad, Christopher]

CFX_J or CFX's on 4.5x

Chris

Christopher Conrad
Victoria's Secret Catalogue
http://www.VictoriasSecret.com
Senior.Programmer.Analyst
614.337.5653
[EMAIL PROTECTED]


> -Original Message-
> From: Trahan, Shane [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 23, 2000 12:08 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Java and CF
> 
> What is the best way to use Java and CF? I have tried using CFOBJECT but
> have had alot of problems with it not releasing memory etc..  How can I
> best
> leverage Java and CF?
> 
> 
> If anyone has any insight into Java and CFOBJECT please let me know!! I
> have
> been trying to figure out why CFOBJECT doesn't release the memory after
> the
> class has been called from the CFOBJECT
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Logical Limit of NT User Accounts

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Under NT 4, it was 20,000 accounts per domain.  Under Win2k, there's
no pratical limit.

Regards,
Zac Bedell


Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.

Please include original message in any replies -- I get a 
lot of email every day, and I have a REALLY bad memory... 
So I don't always remember everything that was said.  
Thanks!





> -Original Message-
> From: David B. Brooks [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 23, 2000 12:18 PM
> To: [EMAIL PROTECTED]
> Subject: Logical Limit of NT User Accounts
> 
> 
> Greetings All,
> 
> I'm going to utilize Cold Fusion's Advanced Security using my local
> NT Domain for authentication.  Does anyone know the logical 
> limit to the number
> of users NT can handle in its database?
> 
> Thanks for all the info!
> 
> David Brooks
> PC Pros, Inc.
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.2 for non-commercial use 
Comment: Please use PGP!!!

iQA/AwUBOVORHAraVoMWBwRBEQJcOwCg5ow37h+39zpz1kH5x7Px1HTRVqkAn27h
dWp6m2u53L6NXgJhpAabUZ1R
=kAbR
-END PGP SIGNATURE-
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Changing file permissions in Unix

[Mark Warrick]

There are instructions in the CF Documentation titled "Setting File and Directory 
Attributes".

Check the docs.

Or just set the permissions with the unix CHMOD command.



--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Carol Chandler [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 23, 2000 8:51 AM
> To: [EMAIL PROTECTED]
> Subject: Changing file permissions in Unix
> 
> 
> We have our CF user (www) file permissions set to owner 
> read-write only (no group or world read or write), and like it 
> that way for most instances.  However, in one case, we need to 
> change a file generated by CF to group read-write.  Is there a 
> chmod command available in CF, or is there some command that 
> allows you to plug in a Unix command?
> 
> Thanks.
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_tal
> k or send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Changing file permissions in Unix

[Frédéric LeMieux]

If you are using CFFILE, you can always put the MODE="" attribute.

-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 12:12 PM
To: [EMAIL PROTECTED]
Subject: RE: Changing file permissions in Unix


CFEXECUTE?

Steve

-Original Message-
From: Carol Chandler [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 11:51 AM
To: [EMAIL PROTECTED]
Subject: Changing file permissions in Unix


We have our CF user (www) file permissions set to owner read-write only (no
group or world read or write), and like it that way for most instances.
However, in one case, we need to change a file generated by CF to group
read-write.  Is there a chmod command available in CF, or is there some
command that allows you to plug in a Unix command?

Thanks.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: [Another Way...]Checking for a record, and then deleting it

[Philip Arnold - ASP]

> The correct way in ANSI SQL
> would be something Like
>
> DELETE FROM SystemQuote WHERE CFID Exists IN
> (
> Select CFID
> FROM SystemQuote
> WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> )
>
> Check the syntax but something like that .

Isn't that exactly the same as;
DELETE FROM SystemQuote WHERE CFID=#CFID# AND CFTOKEN=#CFTOKEN#

Seems to be to me... since the CFIDs returned from the sub-query are the
same as the ones in the Where, you might as well not run the sub-query

Also, this query (and the sub-query version) won't crash if you have no
entries in the database to delete.

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Authenticating a user using NT Authentication

[jeff tapper]

It may be as simple as a variable scoping problem.  a CFPARAM tag is being 
used to set a default value of Categories (no scope) to a blank 
string.  The cfa_contentObjectProperty tag is also referencing the the 
variable without a scope.  Its possible the two unscoped variables are 
actually referring to a variables.categories, and not the form.categories 
which they really mean.  I would try changing  to  and see if that helps.

At 12:04 PM 6/22/00 -0400, you wrote:


>Hi Again,
>
>Is there anyway to automatically authenticate a user (giving them access to
>a CF application without having to login) using NT Authentication?
>
>TIA,
>
>Debbie
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

==
Jeff Tapper
[EMAIL PROTECTED]
Senior Allaire Platform Technologist
http://www.gtriad.com
G. Triad
==

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Changing file permissions in Unix

[Justin v0.9 MacCarthy]

Using the mode attribute in File = upload ???

MODE=777 etc

just your standard chmod numbers

Or you chould try cfexecute chmod etc...

BTW the is a linux cf list @ [EMAIL PROTECTED] 

~Justin

> We have our CF user (www) file permissions set to owner read-write only
(no group or world read or write), and like it that way for most instances.
However, in one case, we need to change a file generated by CF to group
read-write.  Is there a chmod command available in CF, or is there some
command that allows you to plug in a Unix command?
>
> Thanks.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Logical Limit of NT User Accounts

[David B. Brooks]

Greetings All,

I'm going to utilize Cold Fusion's Advanced Security using my local NT
Domain for authentication.  Does anyone know the logical limit to the number
of users NT can handle in its database?

Thanks for all the info!

David Brooks
PC Pros, Inc.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Changing file permissions in Unix

[Steve Bernard]

CFEXECUTE?

Steve

-Original Message-
From: Carol Chandler [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 11:51 AM
To: [EMAIL PROTECTED]
Subject: Changing file permissions in Unix


We have our CF user (www) file permissions set to owner read-write only (no
group or world read or write), and like it that way for most instances.
However, in one case, we need to change a file generated by CF to group
read-write.  Is there a chmod command available in CF, or is there some
command that allows you to plug in a Unix command?

Thanks.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Java and CF

[Trahan, Shane]

What is the best way to use Java and CF? I have tried using CFOBJECT but
have had alot of problems with it not releasing memory etc..  How can I best
leverage Java and CF?


If anyone has any insight into Java and CFOBJECT please let me know!! I have
been trying to figure out why CFOBJECT doesn't release the memory after the
class has been called from the CFOBJECT
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Support for NCLOB Datatype in Oracle

[Dave Watts]

> I ran into this problem a while back.  Apparently Cold Fusion has
> difficulties putting more than 4000 characters at a time into
> a CLOB in Oracle. I ended up writing a little PL/SQL script that
> would break down a character string passed to it into chunks and
> insert them one by one. I'm not sure if it will work on an NCLOB
> datatype, but it sounds very similar and I was getting the same
> error. I have the CF Code and the accompanying PL Code. Will post
> it tomorrow morning when I get to work.

If you're using CF 4.5.x, you shouldn't need to break data into chunks
anymore. You can use CFQUERYPARAM to put a large string into a bind
parameter.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Changing file permissions in Unix

[Carol Chandler]

We have our CF user (www) file permissions set to owner read-write only (no group or 
world read or write), and like it that way for most instances.  However, in one case, 
we need to change a file generated by CF to group read-write.  Is there a chmod 
command available in CF, or is there some command that allows you to plug in a Unix 
command?

Thanks.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Support for NCLOB Datatype in Oracle

[James Berry]

Sorry it took so long.. It seems that there is always a major crisis in the
morning.

---
 PL/SQL Code

This takes the 4000 characters and appends them to the correct field
---

CREATE OR REPLACE  PROCEDURE "WEB"."UPDATE_EXPLANATION" (pkey in number,
longparam in VARCHAR2, APPENDLOB IN INTEGER) IS
  dblob CLOB;
  amt BINARY_INTEGER;
BEGIN
amt :=  LENGTH(longparam);

SELECT BODY_CONTENT INTO dblob FROM CONTENT WHERE CONTENT_ID = pkey
FOR UPDATE;

IF dblob IS NULL THEN
  UPDATE CONTENT SET BODY_CONTENT = ' ' WHERE CONTENT_ID = pkey;
  SELECT BODY_CONTENT INTO dblob FROM CONTENT WHERE CONTENT_ID =
pkey FOR UPDATE;
END IF;

IF APPENDLOB = 0 THEN
DBMS_LOB.TRIM ( dblob, 0 );
END IF;

DBMS_LOB.WRITEAPPEND (dblob, amt, longparam);

COMMIT;
END;
---
End PL/SQL Code
---

---
 CF Code

Description:
This loops over the form field text and puts 4000 character chunks in to
the CLOB

Vars:
N_BODY_AREA = Form field that contains the text to put in the CLOB
---












---
End CF Code
---

Of Course you'll need to make some changes to get it updating the correct
cols in your DB..
If you need any help figuring out what any of it does, let me know
-jb


-Original Message-
From: Jonathan Fisher [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 5:33 AM
To: [EMAIL PROTECTED]
Subject: Re: Support for NCLOB Datatype in Oracle


Thanks a lot, I'd really appreciate it!

J
- Original Message -
From: "James Berry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 12:06 PM
Subject: RE: Support for NCLOB Datatype in Oracle


> I ran into this problem a while back.  Apparently Cold Fusion has
> difficulties putting more than 4000 characters at a time into a CLOB in
> Oracle.  I ended up writing a little PL/SQL script that would break down a
> character string passed to it into chunks and insert them one by one.  I'm
> not sure if it will work on an NCLOB datatype, but it sounds very similar
> and I was getting the same error.   I have the CF Code and the
accompanying
> PL Code.  Will post it tomorrow morning when I get to work.
>
> -jb
>
>
> -Original Message-
> From: Jonathan Fisher [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 22, 2000 11:14 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Support for NCLOB Datatype in Oracle
>
>
> ok...here's where I am now - I switched to the CLOB datatype and still got
> the error. Then I upgraded the Cold Fusion from 4.5.0 to 4.5.1 and was
able
> to get a step furtherthe message I get now is :
>
> Error Diagnostic Information
> Oracle Error Code = 1704
> ORA-01704: string literal too long
> 
>
>
> So of course the question is - how can that be? Any suggestions?
>
> Thanks much,
>
> J
>
> - Original Message -
> From: "Jonathan Fisher" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 21, 2000 4:24 PM
> Subject: Re: Support for NCLOB Datatype in Oracle
>
>
> > ok, thanksIs there another type that could be used for storing large
> > amounts of text? The problem is with storing magazine article amounts of
> > text in a database, which we expect may be more than the 4000 character
> > limit allowed by the VARCHAR2 type.
> >
> > J
> >
> > - Original Message -
> > From: "Dave Watts" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 21, 2000 4:01 PM
> > Subject: RE: Support for NCLOB Datatype in Oracle
> >
> >
> > > > Can anyone tell me whether the native driver for Oracle that
> > > > comes with Cold Fusion Enterprise 4.5 supports Oracle's NCLOB
> > > > data type?
> > >
> > > I'm not 100% certain, but I don't think so - N' data types aren't
ASCII,
> > but
> > > Unicode, which CF doesn't understand.
> > >
> > > Dave Watts, CTO, Fig Leaf Software
> > > http://www.figleaf.com/
> > > voice: (202) 797-5496
> > > fax: (202) 797-5444
> > >
> >
>
> --
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> >
> >
> > __
> > Do You Yahoo!?
> > Talk to your friends online with Yahoo! Messenger.
> > 

RE: Client variables to an url and form

[Frédéric LeMieux]

Never had that specific problem, but I always have CLIENTMANAGEMENT="Yes"
CLIENTSTORGAE="[validStoragePlace]" in my 

IF you don't have it, maybe this is your problem.

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 11:07 AM
To: '[EMAIL PROTECTED]'
Subject: Client variables to an url and form


Ok I appended client.urltoken to 2 urls on 2 different pages and it
passes me 2 different cfids and cftokens. Why is it doing this. Do I have to
put something special in my cfapplication. Anyone have any experieince with
this. I am using 4.5.1, nt 4.


Robert Everland III
Web Developer
Dixon Ticonderoga

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: [Another Way...]Checking for a record, and then deleting it

[Justin v0.9 MacCarthy]

The correct way in ANSI SQL
would be something Like

DELETE FROM SystemQuote WHERE CFID Exists IN
(
Select CFID
FROM SystemQuote
WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
)

Check the syntax but something like that .

Justin

- Original Message -
From: Chris Terrebonne <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 4:09 PM
Subject: RE: [Another Way...]Checking for a record, and then deleting it


> Never tried it on Oracle.  It works great on MS SQL 7.
> Check the Oracle docs for the correct SQL format of the statement and it
> should work
>
> Chris
> --
> Original Message
> From: "Frédéric LeMieux"<[EMAIL PROTECTED]>
> Subject: RE: [Another Way...]Checking for a record, and then deleting it
> Date: Fri, 23 Jun 2000 09:52:08 -0400
>
> >hmmm I never saw that kind of SQL statement. So I tried, and it is
not
> >working !
> >The Oracle Database returns "Invalid SQL statement".
> >
> >Where did you see that king of statement ? Can you give me more
information
> >on how to make this king of SQL working ?
> >
> >
> >-Original Message-
> >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, June 23, 2000 9:48 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re:[Another Way...]Checking for a record, and then deleting it
> >
> >
> >Or you could do it all via SQL:
> >
> >
> >IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
> >CFTOKEN=#CFTOKEN#)) > 0)
> > DELETE FROM SystemQuote WHERE CFID = #CFID#
> >
> >
> >Chris
> >--
> >Original Message
> >From: "Chris Terrebonne"<[EMAIL PROTECTED]>
> >Subject: Re:Checking for a record, and then deleting it
> >Date: Fri, 23 Jun 2000 08:43:08 -0500
> >
> >>Just test for the RecordCount...
> >>
> >>
> >>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> >>
> >>
> >>
> >> 
> >> DELETE FROM SystemQuote WHERE CFID = #CFID#
> >> 
> >>
> >>
> >>--
> >>Original Message
> >>From: "Chris Farrugia"<[EMAIL PROTECTED]>
> >>Subject: Checking for a record, and then deleting it
> >>Date: Thu, 22 Jun 2000 21:24:46 -0400
> >>
> >>>I have a table in a database that contains the fields CFID, CFTOKEN,
WDDX
> >>>(which is an array that I used CFWDDX on), and the date.  It is for a
> >>system
> >>>configurator for new computer systems.  When someone fills in the forms
> >for
> >>>what they want on their system, it puts it in a database, then they can
> >>>click a reconfigure button...  that takes them back to the form they
just
> >>>filled out so they can reconfigure their system.  THen they hit the
> submit
> >>>button again and here I need to check if a record in the quotes table
> >>>already exists (meaning this is at least the second time they've
> >configured
> >>>a system), and if it exists, then that record needs to be deleted.
Here
> >is
> >>>the code I've tried but it doesn't work:
> >>>
> >>>
> >>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> >>>
> >>>
> >>>
> >>>
> >>> 
> >>> DELETE FROM SystemQuote WHERE CFID = #CFID#
> >>> 
> >>>
> >>>
> >>>
> >>>
> >>>Does anybody know of a way of doing this?  Thanks in advance.
> >>>
>
>>>-
> -
> >-
> >>---
> >>>Archives: http://www.eGroups.com/list/cf-talk
> >>>To Unsubscribe visit
> >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> >>the body.
> >>>
> >>
> >>_
> >>Free email with personality! Over 200 domains!
> >>http://www.MyOwnEmail.com
> >>
>
>>--
> -
> >---
> >>Archives: http://www.eGroups.com/list/cf-talk
> >>To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
> >>
> >
> >_
> >Free email with personality! Over 200 domains!
> >http://www.MyOwnEmail.com
> >
>
>---
> -
> >--
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
> >
>
>---
> ---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
> ---

RE: [Another Way...]Checking for a record, and then deleting it

[Chris Terrebonne]

Another thing that might be causing you  a problem is the CRLF after the
AND in the if statement. Make sure the initial if statement is all one one
line.

IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
CFTOKEN=#CFTOKEN#)) > 0)
 DELETE FROM SystemQuote WHERE CFID = #CFID#

--
Original Message
From: "Frédéric LeMieux"<[EMAIL PROTECTED]>
Subject: RE: [Another Way...]Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 09:52:08 -0400

>hmmm I never saw that kind of SQL statement. So I tried, and it is not
>working !
>The Oracle Database returns "Invalid SQL statement".
>
>Where did you see that king of statement ? Can you give me more information
>on how to make this king of SQL working ?
>
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 9:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re:[Another Way...]Checking for a record, and then deleting it
>
>
>Or you could do it all via SQL:
>
>
>IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
>CFTOKEN=#CFTOKEN#)) > 0)
> DELETE FROM SystemQuote WHERE CFID = #CFID#
>
>
>Chris
>--
>Original Message
>From: "Chris Terrebonne"<[EMAIL PROTECTED]>
>Subject: Re:Checking for a record, and then deleting it
>Date: Fri, 23 Jun 2000 08:43:08 -0500
>
>>Just test for the RecordCount...
>>
>>
>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>
>>
>>
>>  
>>  DELETE FROM SystemQuote WHERE CFID = #CFID#
>>  
>>
>>
>>--
>>Original Message
>>From: "Chris Farrugia"<[EMAIL PROTECTED]>
>>Subject: Checking for a record, and then deleting it
>>Date: Thu, 22 Jun 2000 21:24:46 -0400
>>
>>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>>>(which is an array that I used CFWDDX on), and the date.  It is for a
>>system
>>>configurator for new computer systems.  When someone fills in the forms
>for
>>>what they want on their system, it puts it in a database, then they can
>>>click a reconfigure button...  that takes them back to the form they just
>>>filled out so they can reconfigure their system.  THen they hit the
submit
>>>button again and here I need to check if a record in the quotes table
>>>already exists (meaning this is at least the second time they've
>configured
>>>a system), and if it exists, then that record needs to be deleted.  Here
>is
>>>the code I've tried but it doesn't work:
>>>
>>>
>>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>>
>>>
>>>
>>>
>>> 
>>> DELETE FROM SystemQuote WHERE CFID = #CFID#
>>> 
>>>
>>>
>>>
>>>
>>>Does anybody know of a way of doing this?  Thanks in advance.
>>>
>>>-
-
>-
>>---
>>>Archives: http://www.eGroups.com/list/cf-talk
>>>To Unsubscribe visit
>>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>>the body.
>>>
>>
>>_
>>Free email with personality! Over 200 domains!
>>http://www.MyOwnEmail.com
>>
>>--
-
>---
>>Archives: http://www.eGroups.com/list/cf-talk
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>---
-
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Solaris vs Linux

[Jeff Honken]

We have the Solaris, Linux and N.T. servers all running Cold Fusion.  I've
found both the Solaris and Linux versions very stable and great to work
with.  Of course NT is NT.  We utilize both MySQL and Oracle for our
databases.  The Oracle version for Solaris seems to more stable.  The linux
version has the ODBC drivers included with the install for MySQL.  I don't
think you can go wrong with either version.

-Original Message-
From: Stas Maximov [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 4:43 AM
To: [EMAIL PROTECTED]
Subject: Solaris vs Linux


Dear Fusioners,

I'm on the stage of choosing platform for application server. Candidates are
Sparc Solaris and PIII-750 Linux. As I understand there is no difference
what hardware is: Sparc Server of Intel P3 if the latter has enough RAM and
faster Intel processor. But what about ColdFusion for these platforms? Isn't
Linux version of CF4.5 too raw? Or this is just a gossip? I wish to use
Linux/PC version, but I'm afraid that it will be less stable, has some bugs,
etc.

Any help will be highly appreciated.

stas@


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Bad cfml.exe ???

[Jacob]

I agree.  But since this site was set up about 4-5 years ago, this is the 
way it has been.

This is not a big concern now since I can still use the cfml.exe 
from  4.0.0.  Since 4.0.1 is a small upgrade to 4.0.0, I am not going to 
lose very many feature with the new cfml.exe.  We are talking about 
changing this problem, but it may be a while until it is finished.  We have 
about 200,000 html pages to go through.

The new stuff we implement does not use the cgi directory.

Jacob

At 10:12 AM 6/23/00 -0400, you wrote:
> > I can't help with the problem you mentioned, but I WOULD
> > point out that - at least when I was working with Perl -
> > putting executables into a public-accessable CGI directory
> > was regarded a really, really good way to let people execute
> > arbitrary code on your system.
> >
> > In other words, a big fat security hole.
> >
> > I don't know if this is a no-no with CF, given that I have no
> > experience with CF on a non-NT environment; but I'd keep it in mind,
> > unless you're absolutely sure that's the right thing to do.
>
>This is how CF used to work, prior to version 2.0. It conceivably might have
>been a security hole, but that's the way Allaire instructed setting it up.
>There's not a lot that the CFML.EXE application does in any case; it's a
>stub that sends the HTTP request to the CF Application Server, which
>actually does all the work.
>
>Nowadays, practically no one uses the CGI stub anymore, and rather than
>worrying too much about security, I'd worry about the awful performance that
>you'd get from using the CGI stub. Website, like IIS, Netscape and Apache,
>supports the use of in-process modules.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Client variables to an url and form

[Robert Everland]

Ok I appended client.urltoken to 2 urls on 2 different pages and it
passes me 2 different cfids and cftokens. Why is it doing this. Do I have to
put something special in my cfapplication. Anyone have any experieince with
this. I am using 4.5.1, nt 4.


Robert Everland III
Web Developer
Dixon Ticonderoga
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: [Another Way...]Checking for a record, and then deleting it

[Chris Terrebonne]

Never tried it on Oracle.  It works great on MS SQL 7.
Check the Oracle docs for the correct SQL format of the statement and it
should work

Chris
--
Original Message
From: "Frédéric LeMieux"<[EMAIL PROTECTED]>
Subject: RE: [Another Way...]Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 09:52:08 -0400

>hmmm I never saw that kind of SQL statement. So I tried, and it is not
>working !
>The Oracle Database returns "Invalid SQL statement".
>
>Where did you see that king of statement ? Can you give me more information
>on how to make this king of SQL working ?
>
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 9:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re:[Another Way...]Checking for a record, and then deleting it
>
>
>Or you could do it all via SQL:
>
>
>IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
>CFTOKEN=#CFTOKEN#)) > 0)
> DELETE FROM SystemQuote WHERE CFID = #CFID#
>
>
>Chris
>--
>Original Message
>From: "Chris Terrebonne"<[EMAIL PROTECTED]>
>Subject: Re:Checking for a record, and then deleting it
>Date: Fri, 23 Jun 2000 08:43:08 -0500
>
>>Just test for the RecordCount...
>>
>>
>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>
>>
>>
>>  
>>  DELETE FROM SystemQuote WHERE CFID = #CFID#
>>  
>>
>>
>>--
>>Original Message
>>From: "Chris Farrugia"<[EMAIL PROTECTED]>
>>Subject: Checking for a record, and then deleting it
>>Date: Thu, 22 Jun 2000 21:24:46 -0400
>>
>>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>>>(which is an array that I used CFWDDX on), and the date.  It is for a
>>system
>>>configurator for new computer systems.  When someone fills in the forms
>for
>>>what they want on their system, it puts it in a database, then they can
>>>click a reconfigure button...  that takes them back to the form they just
>>>filled out so they can reconfigure their system.  THen they hit the
submit
>>>button again and here I need to check if a record in the quotes table
>>>already exists (meaning this is at least the second time they've
>configured
>>>a system), and if it exists, then that record needs to be deleted.  Here
>is
>>>the code I've tried but it doesn't work:
>>>
>>>
>>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>>
>>>
>>>
>>>
>>> 
>>> DELETE FROM SystemQuote WHERE CFID = #CFID#
>>> 
>>>
>>>
>>>
>>>
>>>Does anybody know of a way of doing this?  Thanks in advance.
>>>
>>>-
-
>-
>>---
>>>Archives: http://www.eGroups.com/list/cf-talk
>>>To Unsubscribe visit
>>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>>the body.
>>>
>>
>>_
>>Free email with personality! Over 200 domains!
>>http://www.MyOwnEmail.com
>>
>>--
-
>---
>>Archives: http://www.eGroups.com/list/cf-talk
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>---
-
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFERROR

[Guy Walker]

Tom

Where is it located?

Guy

- Original Message -
From: "Tom Harwood" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 7:44 AM
Subject: Re: CFERROR


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> --_=_NextPart_000_01BFDD21.83AAFD46
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Hello Michael,
>
> Have you seen our whitepaper on error handling?  If there are any specific
> questions I can answer, let me know.  Feedback on the paper would also be
> very helpful to us.  Thanks!
>
> --
> Tom Harwood
> ColdFusion Language Development
> Allaire Corporation
>
>
> --_=_NextPart_000_01BFDD21.83AAFD46
> Content-Type: application/msword;
> name="ColdFusion Exception Handling Whitepaper.doc"
> Content-Transfer-Encoding: base64
> Content-Disposition: attachment;
> filename="ColdFusion Exception Handling Whitepaper.doc"
>
>
0M8R4KGxGuEAPgADAP7/CQAGAAABTwAA
>
EAAAUQEAAAD+AE4AAAD/
>

>

>

>

>

>

>
///s
>
pcEAcQAJBAAACBK/EAAABAAAsC0AAA4AYmpianQrdCsA
>
AAAJBBYAHlAAABZBAQAWQQEAsCkAAAD//w8A
>
AAD//w8AAAD//w8AAF0AAL4CvgIAAL4C
>
vgIAAAC+AgAAAL4CvgIAABQAANIC0gIA
>
AADSAgAAANIC0gIAABQAAADmAgAAPNICvBQAAGoBAAA+AwAA
>
FgAAAFQDVAMAAABUAwAAAFQDVAMAAABUAwAAAFQD
>
gRQAAAIAAACDFIMUgxQAAACDFIMUgxQAACQA
>
AAAmFgAA9AEAABoYAACQpxQAABUAvgIAAABUAwAA
>
AABUAwAAAFQDVAMAAABUAwAAAKcU
>
jAwAAAC+AgAAAL4CVAMAAFQDPgMAAACM
>
DIwMjAwAAABUAwAAXgYAAL4CVAMAAAC+AgAAAFQD
>
gRQA0gIAAADSAgAAAL4CvgIA
>
AAC+AgAAAL4CVAMAAACBFIwMAAAYBwAAjAwAAACkEwAA
>
OgAAAEsUAAAsvgIAAAC+AgAA
>
gRQAAABUAwAAACIDAAAcoGbq/AJi
>
vwHSAgAAANICsgkAANoCAAB3FAAACgAA
>

>
Q29s
>
ZEZ1c2lvbiAgNC41C0V4Y2VwdGlvbiBIYW5kbGluZyBTdHJhdGVnaWVzDQ1TdW1tYXJ5DVVzZSB0
>
aGUgc2l0ZS13aWRlIGV4Y2VwdGlvbiBoYW5kbGVycyBmb3IgYWR2YW5jZWQgZXJyb3IgcHJlc2Vu
>
dGF0aW9uOiBjb250ZXh0LXNlbnNpdGl2ZSBlcnJvciBtZXNzYWdlcywgbG9nZ2luZywgYWRtaW5p
>
c3RyYXRvciBub3RpZmljYXRpb24uDVVzZSBDRlRSWS9DRkNBVENIIGZvciBleGNlcHRpb24gcmVj
>
b3Zlcnk6IHNvbWUgZXJyb3JzIGNhbiBiZSBmaXhlZC4NVXNlIENGRVJST1IgVFlQRT2UUkVRVUVT
>
VJQgZm9yIGJhY2t1cCBlcnJvciBwcmVzZW50YXRpb24gaW4gY2FzZSB0aGUgZXhjZXB0aW9uIGhh
>
bmRsZXJzIHN1ZmZlciBhZGRpdGlvbmFsIGVycm9ycy4gDVVzZSBDRkVSUk9SIFRZUEU9lEVYQ0VQ
>
VElPTpQgdG8gb3ZlcnJpZGUgdGhlIHNpdGUtd2lkZSBleGNlcHRpb24gaGFuZGxlcnMuDVVzZSBD
>
RkVSUk9SIFRZUEU9lE1PTklUT1KUIHRvIGRlYnVnIHVuZXhwZWN0ZWQgZXhjZXB0aW9ucyB3aXRo
>
aW4gYSBjb21wbGV4IGFwcGxpY2F0aW9uLg1Ib3cgdGhlIENvbGRGdXNpb24gQXBwbGljYXRpb24g
>
U2VydmVyIE1hbmFnZXMgRXhjZXB0aW9ucw1FeGNlcHRpb25zIGFyZSBldmVudHMgdGhhdCBkaXNy
>
dXB0IGFuIGFwcGxpY2F0aW9uknMgbm9ybWFsIGZsb3cgb2YgaW5zdHJ1Y3Rpb25zLiAgTm9ybWFs
>
bHksIHRoZXNlIGV2ZW50cyBhcmUgZ2VuZXJhdGVkIGJ5IGFuIGVycm9yIGNvbmRpdGlvbiB0aGF0
>
IHByZXZlbnRlZCBhbiBvcGVyYXRpb24gZnJvbSBjb21wbGV0aW5nIG5vcm1hbGx5Lg1FeGNlcHRp
>
b25zIGFyZSBnZW5lcmF0ZWQgd2l0aGluIENGQVMgZm9yIHRocmVlIGdlbmVyYWwgcmVhc29uczoN
>
QXMgYW4gZXJyb3IgcmVzcG9uc2UgZnJvbSBhbiBleHRlcm5hbCBzZXJ2aWNlLCBzdWNoIGFzIGFu
>
IE9CREMgZHJpdmVyIG9yIGEgQ09SQkEgc2VydmVyLg1CeSBhIENGTUwgdGFnIGltcGxlbWVudGF0
>
aW9uLCBlaXRoZXIgYmVjYXVzZSBvZiBhIENGTUwgZXJyb3Igb3IgaW4gcmVzcG9uc2UgdG8gYSA8
>
Q0ZUSFJPVz4gb3IgPENGQUJPUlQ+IHRhZy4NQmVjYXVzZSBvZiBpbnRlcm5hbCBlcnJvcnMgd2l0
>
aCBDRkFTIGl0c2VsZi4NVGhlIENGTUwgbGFuZ3VhZ2UgcHJvY2Vzc29yIGd1YXJkcyBpdHNlbGYg
>
YWdhaW5zdCBleGNlcHRpb25zIGVhY2ggdGltZSBpdCBleGVjdXRlcyBhIENGTUwgdGFnLCB1c2lu
>
ZyBDKysgY29uc3RydWN0cyB0aGF0IGFyZSB2ZXJ5IHNpbWlsYXIgdG8gQ0ZUUlkgYW5kIENGQ0FU
>
Q0guICBFeGNlcHRpb25zIGFyZSBpbW1lZGlhdGVseSBjYXRlZ29yaXplZCBhcyByZWNvdmVyYWJs
>
ZSBvciB1bnJlY292ZXJhYmxlLiAgVW5yZWNvdmVyYWJsZSBleGNlcHRpb25zIGFyZSBjYXVzZWQg
>

RE: Allaire Cold Fusion Template Header Size: 54 .... What's this?

[Steve Bernard]

Isn't that the same text that appears in the header of an encrypted
template? Just a thought, might be way off, and even if this is the case I
don't know why it would start to show up in the logs.

Steve


-Original Message-
From: KungFusion [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 10:45 AM
To: [EMAIL PROTECTED]
Subject: Allaire Cold Fusion Template Header Size: 54  What's this?


anybody seen this before? I had to redo my development box at home and after
installing CF4.5 I get this message on all my DirectoryIndex pages...
Machine specs:
W2K Server (scary!!, we'll see if it makes a week before completly crashing)
CF4.5  (I haven't installed the upgrade 4.5.1 yet)
SQL 7
yadayadayada

thanks for the info..
Brian

"throw me a frickin bone here... I'm the boss. need the info." -Dr.
Evil

Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Allaire Cold Fusion Template Header Size: 54 .... What's this?

[Dave Watts]

> anybody seen this before?
...
> Allaire Cold Fusion Template Header Size: 54 Allaire Cold
> Fusion Template Header Size: 54 ...

The message "Allaire Cold Fusion Template Header Size: ..." appears at the
top of an encrypted file. It looks to me like you encrypted the same file
many, many times. I suspect that if you encrypt the same file more than
once, CF won't be able to deal with it.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Allaire Cold Fusion Template Header Size: 54 .... What's this?

[KungFusion]

anybody seen this before? I had to redo my development box at home and after
installing CF4.5 I get this message on all my DirectoryIndex pages...
Machine specs:
W2K Server (scary!!, we'll see if it makes a week before completly crashing)
CF4.5  (I haven't installed the upgrade 4.5.1 yet)
SQL 7
yadayadayada

thanks for the info..
Brian

"throw me a frickin bone here... I'm the boss. need the info." -Dr.
Evil

Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54 Allaire Cold Fusion Template
Header Size: 54 Allaire Cold Fusion Template Header Size: 54 Allaire Cold
Fusion Template Header Size: 54 Allaire Cold Fusion Template Header Size: 54
Allaire Cold Fusion Template Header Size: 54

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFERROR

[Tom Harwood]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_000_01BFDD21.83AAFD46
Content-Type: text/plain;
charset="iso-8859-1"

Hello Michael,

Have you seen our whitepaper on error handling?  If there are any specific
questions I can answer, let me know.  Feedback on the paper would also be
very helpful to us.  Thanks!

--
Tom Harwood
ColdFusion Language Development
Allaire Corporation


--_=_NextPart_000_01BFDD21.83AAFD46
Content-Type: application/msword;
name="ColdFusion Exception Handling Whitepaper.doc"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="ColdFusion Exception Handling Whitepaper.doc"

0M8R4KGxGuEAPgADAP7/CQAGAAABTwAA
EAAAUQEAAAD+AE4AAAD/






///s
pcEAcQAJBAAACBK/EAAABAAAsC0AAA4AYmpianQrdCsA
AAAJBBYAHlAAABZBAQAWQQEAsCkAAAD//w8A
AAD//w8AAAD//w8AAF0AAL4CvgIAAL4C
vgIAAAC+AgAAAL4CvgIAABQAANIC0gIA
AADSAgAAANIC0gIAABQAAADmAgAAPNICvBQAAGoBAAA+AwAA
FgAAAFQDVAMAAABUAwAAAFQDVAMAAABUAwAAAFQD
gRQAAAIAAACDFIMUgxQAAACDFIMUgxQAACQA
AAAmFgAA9AEAABoYAACQpxQAABUAvgIAAABUAwAA
AABUAwAAAFQDVAMAAABUAwAAAKcU
jAwAAAC+AgAAAL4CVAMAAFQDPgMAAACM
DIwMjAwAAABUAwAAXgYAAL4CVAMAAAC+AgAAAFQD
gRQA0gIAAADSAgAAAL4CvgIA
AAC+AgAAAL4CVAMAAACBFIwMAAAYBwAAjAwAAACkEwAA
OgAAAEsUAAAsvgIAAAC+AgAA
gRQAAABUAwAAACIDAAAcoGbq/AJi
vwHSAgAAANICsgkAANoCAAB3FAAACgAA

Q29s
ZEZ1c2lvbiAgNC41C0V4Y2VwdGlvbiBIYW5kbGluZyBTdHJhdGVnaWVzDQ1TdW1tYXJ5DVVzZSB0
aGUgc2l0ZS13aWRlIGV4Y2VwdGlvbiBoYW5kbGVycyBmb3IgYWR2YW5jZWQgZXJyb3IgcHJlc2Vu
dGF0aW9uOiBjb250ZXh0LXNlbnNpdGl2ZSBlcnJvciBtZXNzYWdlcywgbG9nZ2luZywgYWRtaW5p
c3RyYXRvciBub3RpZmljYXRpb24uDVVzZSBDRlRSWS9DRkNBVENIIGZvciBleGNlcHRpb24gcmVj
b3Zlcnk6IHNvbWUgZXJyb3JzIGNhbiBiZSBmaXhlZC4NVXNlIENGRVJST1IgVFlQRT2UUkVRVUVT
VJQgZm9yIGJhY2t1cCBlcnJvciBwcmVzZW50YXRpb24gaW4gY2FzZSB0aGUgZXhjZXB0aW9uIGhh
bmRsZXJzIHN1ZmZlciBhZGRpdGlvbmFsIGVycm9ycy4gDVVzZSBDRkVSUk9SIFRZUEU9lEVYQ0VQ
VElPTpQgdG8gb3ZlcnJpZGUgdGhlIHNpdGUtd2lkZSBleGNlcHRpb24gaGFuZGxlcnMuDVVzZSBD
RkVSUk9SIFRZUEU9lE1PTklUT1KUIHRvIGRlYnVnIHVuZXhwZWN0ZWQgZXhjZXB0aW9ucyB3aXRo
aW4gYSBjb21wbGV4IGFwcGxpY2F0aW9uLg1Ib3cgdGhlIENvbGRGdXNpb24gQXBwbGljYXRpb24g
U2VydmVyIE1hbmFnZXMgRXhjZXB0aW9ucw1FeGNlcHRpb25zIGFyZSBldmVudHMgdGhhdCBkaXNy
dXB0IGFuIGFwcGxpY2F0aW9uknMgbm9ybWFsIGZsb3cgb2YgaW5zdHJ1Y3Rpb25zLiAgTm9ybWFs
bHksIHRoZXNlIGV2ZW50cyBhcmUgZ2VuZXJhdGVkIGJ5IGFuIGVycm9yIGNvbmRpdGlvbiB0aGF0
IHByZXZlbnRlZCBhbiBvcGVyYXRpb24gZnJvbSBjb21wbGV0aW5nIG5vcm1hbGx5Lg1FeGNlcHRp
b25zIGFyZSBnZW5lcmF0ZWQgd2l0aGluIENGQVMgZm9yIHRocmVlIGdlbmVyYWwgcmVhc29uczoN
QXMgYW4gZXJyb3IgcmVzcG9uc2UgZnJvbSBhbiBleHRlcm5hbCBzZXJ2aWNlLCBzdWNoIGFzIGFu
IE9CREMgZHJpdmVyIG9yIGEgQ09SQkEgc2VydmVyLg1CeSBhIENGTUwgdGFnIGltcGxlbWVudGF0
aW9uLCBlaXRoZXIgYmVjYXVzZSBvZiBhIENGTUwgZXJyb3Igb3IgaW4gcmVzcG9uc2UgdG8gYSA8
Q0ZUSFJPVz4gb3IgPENGQUJPUlQ+IHRhZy4NQmVjYXVzZSBvZiBpbnRlcm5hbCBlcnJvcnMgd2l0
aCBDRkFTIGl0c2VsZi4NVGhlIENGTUwgbGFuZ3VhZ2UgcHJvY2Vzc29yIGd1YXJkcyBpdHNlbGYg
YWdhaW5zdCBleGNlcHRpb25zIGVhY2ggdGltZSBpdCBleGVjdXRlcyBhIENGTUwgdGFnLCB1c2lu
ZyBDKysgY29uc3RydWN0cyB0aGF0IGFyZSB2ZXJ5IHNpbWlsYXIgdG8gQ0ZUUlkgYW5kIENGQ0FU
Q0guICBFeGNlcHRpb25zIGFyZSBpbW1lZGlhdGVseSBjYXRlZ29yaXplZCBhcyByZWNvdmVyYWJs
ZSBvciB1bnJlY292ZXJhYmxlLiAgVW5yZWNvdmVyYWJsZSBleGNlcHRpb25zIGFyZSBjYXVzZWQg
YnkgaW50ZXJuYWwgZXJyb3JzLiAgV2hlbiB0aGUgQ0ZNTCBsYW5ndWFnZSBwcm9jZXNzb3IgcmVj
b2duaXplcyBhIHJlY292ZXJhYmxlIGV4Y2VwdGlvbiwgYmVnaW5zIGNoZWNraW5nIHRoZSB0b3Ag
dGFnIG9uIGl0cyBzdGFjayBvZiBjdXJyZW50bHkgZXhlY3V0aW5nIHRhZ3MgZm9yIGEgQ0ZUUlkg
dGFnIHRoYXQgY2FuIGNhdGNoIHRoZSBleGNlcHRpb24uICBJZiB0aGUgdG9wIHRhZyBpcyBub3Qg

RE: Stored Procedure

[Dave Watts]

> Does SQL have an equivalent to DECODE?

Yes - CASE. Here's a comparison from SQL Server Books Online:

Oracle:
DECODE (test_value,
expression1, value1
[[,expression2, value2] [...]]
[,default_value]
)

SQL Server:
CASE test_value
WHEN expression1 THEN value1
[[WHEN expression2 THEN value2] [...]]
[ELSE default_value]
END

In addition, T-SQL provides several functions which provide similar if-then
functionality, such as NULLIF and COALESCE.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Regular Expression Help

[Steve Bernard]

What you describe is one of the tenants of Fusebox, www.fusebox.org. In that
case the global app code is included in the local app code for each of the
sub folders. What you describe achieves much the same effect by a different
name.

Steve

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 10:11 PM
To: [EMAIL PROTECTED]
Subject: Re: Regular Expression Help


Application.cfm files are great for saving on coding and site management and
stuff, but when you have sub folders that need their own Application.cfm
files, they become less convenient as you have to make sure to include any
needed code from the Application.cfms above them.  Today, I had a (probably
unoriginal) idea.  Is it possible to  the 'root' Application.cfm
into the sub Application.cfms?  This would save me from having to edit all
of the sub ones every time I made a change to the root one.  If this is
technicly possible, is there any reason this shouldn't be done?

Thanks,

Todd

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: scheduled tasks - problems....

[Randy Adkins]

Make sure the scheduled task is running on a normal
port 80 and not something else. This was one problem
an Allaire Representative noted when we contracted
him to visit to resolve the problem.

Other than that, just make sure your settings are correct
for the time to start and end the task.


- Original Message -
From: "steven broadbent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 9:48 AM
Subject: scheduled tasks - problems


>Hi All
>
>I'm using CF 4 on NT.  I'd heard of reported problems using scheduled
> tasks in CF Administrator so I set up a simple
>template to add the date/time to a table every hour.  It worked fine.
>
> Now when I come to run a real scheduled task,  it is totally ignored.
> Nothing shows in the schedue log.  The template itself is
fine,
> but just won't run as a scheduled task.   I'm confident I've set up the
> template name etc correctly in CF
> administrator.  Can anyone shed some light on this - any help would be
most
> appreciated.
>
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Bad cfml.exe ???

[Dave Watts]

> I can't help with the problem you mentioned, but I WOULD
> point out that - at least when I was working with Perl -
> putting executables into a public-accessable CGI directory
> was regarded a really, really good way to let people execute
> arbitrary code on your system.
>
> In other words, a big fat security hole.
>
> I don't know if this is a no-no with CF, given that I have no
> experience with CF on a non-NT environment; but I'd keep it in mind,
> unless you're absolutely sure that's the right thing to do.

This is how CF used to work, prior to version 2.0. It conceivably might have
been a security hole, but that's the way Allaire instructed setting it up.
There's not a lot that the CFML.EXE application does in any case; it's a
stub that sends the HTTP request to the CF Application Server, which
actually does all the work.

Nowadays, practically no one uses the CGI stub anymore, and rather than
worrying too much about security, I'd worry about the awful performance that
you'd get from using the CGI stub. Website, like IIS, Netscape and Apache,
supports the use of in-process modules.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Bad cfml.exe ???

[Jacob]

points to the template directory. d:\html\template\

Everything works fine with the cfml.exe from 4.0.0.  I have no 
problems.  When I copy the cfml.exe from 4.0.1 to replace the old one, that 
is when I get the error.

When I restore the cfml.exe from 4.0.0, it works again.

At 08:17 PM 6/22/00 -0400, you wrote:
>What about CF internal mappings?  These are in the CF adminsitrator.
>
>Regards,
>
>Howie Hamlin
>--
>inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
>www.CoolFusion.com
>
>Please vote for iMS in the Most Innovative category here:
>*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
>
>Check out inFusion Mail Server - the world's most configurable email server
>
>- Original Message -
>From: Jacob <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, June 22, 2000 6:10 PM
>Subject: Re: Bad cfml.exe ???
>
>
> > Quite a few pages on the site are coded like that (CF as a CGI).
> >
> >
> > At 03:45 PM 6/22/00 -0400, you wrote:
> > >Is there a reason why you are running CF as a CGI?  If not, then I would
> > >suggest mapping .cfm to iscf.dll (wwwserver/isapi) in WebSite.
> > >
> > >Regards,
> > >
> > >Howie Hamlin
> > >--
> > >inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
> > >www.CoolFusion.com
> > >
> > >Please vote for iMS in the Most Innovative category here:
> > >*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
> > >
> > >Check out inFusion Mail Server - the world's most configurable email
>server
> > >
> > >- Original Message -
> > >From: Jacob <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >Sent: Thursday, June 22, 2000 2:26 PM
> > >Subject: Bad cfml.exe ???
> > >
> > >
> > > > I upgraded from Cold Fusion studio 4.0 to 4.0.1.
> > > >
> > > > After the upgrade I copied the cfml.exe to C:\website\cgi-shl\ .  When
>I
> > > > run a template I get an error:
> > > >
> > > > Error Occurred While Processing Request
> > > >
> > > > Error Diagnostic Information
> > > > An error has occurred.
> > > > HTTP/1.0 404 Object Not Found
> > > >
> > > > Please inform the site administrator that this error has occurred (be
>sure
> > > > to include the contents of this page in your message to the
> > >administrator).
> > > >
> > > >
> >
> >http://38.144.90.136/cgi-bin/cfml.exe?Template=/shopping/additem.htm&stock=
>5
> > >5264V1
> > > >
> > > > When I replace it the cfml.exe from version 4.0, it works fine.
> > > >
> > > > 4.0 cfml.exe 104KB 10/6/98
> > > > 4.0.1 cfml.exe 121KB 4/8/99
> > > >
> > > > I made no changes to the webserver (Website Professional).
> > > >
> > > > Any suggestions?
> > > >
> > > > Jacob
> > > >
> > >
> > --
> > >
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
>or
> > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > >the body.
> > >
> >
> >---
>---
> > >Archives: http://www.eGroups.com/list/cf-talk
> > >To Unsubscribe visit
> > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
>or
> > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > >the body.
> >
> >
> > --
>
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Variables to append to url

[Frédéric LeMieux]

CLIENT.urlToken will append your tokens in the URL

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 9:55 AM
To: '[EMAIL PROTECTED]'
Subject: Variables to append to url


I lost the darn email with the variable to append to the url. Also
do I have to put a cfid and cftoken when I submit a form? And if so is there
anything special besides doing a cfid=#cfid# cftoken=#cftoken#?


Robert Everland III
Web Developer
Dixon Ticonderoga

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: [Another Way...]Checking for a record, and then deleting it

[Frédéric LeMieux]

hmmm I never saw that kind of SQL statement. So I tried, and it is not
working !
The Oracle Database returns "Invalid SQL statement".

Where did you see that king of statement ? Can you give me more information
on how to make this king of SQL working ?


-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 23, 2000 9:48 AM
To: [EMAIL PROTECTED]
Subject: Re:[Another Way...]Checking for a record, and then deleting it


Or you could do it all via SQL:


IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
CFTOKEN=#CFTOKEN#)) > 0)
 DELETE FROM SystemQuote WHERE CFID = #CFID#


Chris
--
Original Message
From: "Chris Terrebonne"<[EMAIL PROTECTED]>
Subject: Re:Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 08:43:08 -0500

>Just test for the RecordCount...
>
>
>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>
>
>
>   
>   DELETE FROM SystemQuote WHERE CFID = #CFID#
>   
>
>
>--
>Original Message
>From: "Chris Farrugia"<[EMAIL PROTECTED]>
>Subject: Checking for a record, and then deleting it
>Date: Thu, 22 Jun 2000 21:24:46 -0400
>
>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>>(which is an array that I used CFWDDX on), and the date.  It is for a
>system
>>configurator for new computer systems.  When someone fills in the forms
for
>>what they want on their system, it puts it in a database, then they can
>>click a reconfigure button...  that takes them back to the form they just
>>filled out so they can reconfigure their system.  THen they hit the submit
>>button again and here I need to check if a record in the quotes table
>>already exists (meaning this is at least the second time they've
configured
>>a system), and if it exists, then that record needs to be deleted.  Here
is
>>the code I've tried but it doesn't work:
>>
>>
>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>
>>
>>
>>
>>  
>>  DELETE FROM SystemQuote WHERE CFID = #CFID#
>>  
>>
>>
>>
>>
>>Does anybody know of a way of doing this?  Thanks in advance.
>>
>>--
-
>---
>>Archives: http://www.eGroups.com/list/cf-talk
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Variables to append to url

[Robert Everland]

I lost the darn email with the variable to append to the url. Also
do I have to put a cfid and cftoken when I submit a form? And if so is there
anything special besides doing a cfid=#cfid# cftoken=#cftoken#?


Robert Everland III
Web Developer
Dixon Ticonderoga
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re:[Another Way...]Checking for a record, and then deleting it

[Chris Terrebonne]

Or you could do it all via SQL:


IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
CFTOKEN=#CFTOKEN#)) > 0)
 DELETE FROM SystemQuote WHERE CFID = #CFID#


Chris
--
Original Message
From: "Chris Terrebonne"<[EMAIL PROTECTED]>
Subject: Re:Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 08:43:08 -0500

>Just test for the RecordCount...
>
>
>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>
>
>
>   
>   DELETE FROM SystemQuote WHERE CFID = #CFID#
>   
>
>
>--
>Original Message
>From: "Chris Farrugia"<[EMAIL PROTECTED]>
>Subject: Checking for a record, and then deleting it
>Date: Thu, 22 Jun 2000 21:24:46 -0400
>
>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>>(which is an array that I used CFWDDX on), and the date.  It is for a
>system
>>configurator for new computer systems.  When someone fills in the forms
for
>>what they want on their system, it puts it in a database, then they can
>>click a reconfigure button...  that takes them back to the form they just
>>filled out so they can reconfigure their system.  THen they hit the submit
>>button again and here I need to check if a record in the quotes table
>>already exists (meaning this is at least the second time they've
configured
>>a system), and if it exists, then that record needs to be deleted.  Here
is
>>the code I've tried but it doesn't work:
>>
>>
>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>>
>>
>>
>>
>>  
>>  DELETE FROM SystemQuote WHERE CFID = #CFID#
>>  
>>
>>
>>
>>
>>Does anybody know of a way of doing this?  Thanks in advance.
>>
>>--
-
>---
>>Archives: http://www.eGroups.com/list/cf-talk
>>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>>
>
>_
>Free email with personality! Over 200 domains!
>http://www.MyOwnEmail.com
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: -- help.

[Randy Adkins]

The name is the name of the query that all the directory results are dumped
into.

So you can use the contents of the query to search as you would a query.


- Original Message -
From: "miles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 2:21 PM
Subject:  -- help.


> hi.
>
> Im new to this list...ive been looking for a list like this for
> ages...obviously I haven't looked too hard otherwise I would've
> found this a while ago!
>
> Anywho...my issue is this:
>
>  name="??" sort="name">
>
> what should go in the name value ?  especially if I want to list the
entire
> contents of the directory.
>
> Miles.
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re:Checking for a record, and then deleting it

[Chris Terrebonne]

Just test for the RecordCount...


Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)




DELETE FROM SystemQuote WHERE CFID = #CFID#



--
Original Message
From: "Chris Farrugia"<[EMAIL PROTECTED]>
Subject: Checking for a record, and then deleting it
Date: Thu, 22 Jun 2000 21:24:46 -0400

>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
>(which is an array that I used CFWDDX on), and the date.  It is for a
system
>configurator for new computer systems.  When someone fills in the forms for
>what they want on their system, it puts it in a database, then they can
>click a reconfigure button...  that takes them back to the form they just
>filled out so they can reconfigure their system.  THen they hit the submit
>button again and here I need to check if a record in the quotes table
>already exists (meaning this is at least the second time they've configured
>a system), and if it exists, then that record needs to be deleted.  Here is
>the code I've tried but it doesn't work:
>
>
>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
>
>
>
>
>   
>   DELETE FROM SystemQuote WHERE CFID = #CFID#
>   
>
>
>
>
>Does anybody know of a way of doing this?  Thanks in advance.
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFSTOREDPROC and Access97

[Aidan Whitehall]

Thanks for all the replies... very helpful




-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFOBJECT

[Trahan, Shane]

I am using CFOBJECT with some Java Classes and am having a problem..

I have seen many posts in regards to this but have yet to see anything from
allaire on this issue. I am using Java Classes with CFOBJECT and I really
like this feature. HOWEVER, the CFOBJECT never seems to release the action
from memory. The Class is never destroyed. I have upgraded to 4.5.1 to see
if this will help but it does not. The only way that I can release the Class
is to start and stop the CF server!! I do not want to have to do this
everytime..Can someone give me some insight as to how to get CFOBJECT to
release the Object after it has been used? Any help on this would be greatly
appreciated.. 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Regular Expression Help

[Aidan Whitehall]

> Application.cfm files are great for saving on coding and site 
> management and
> stuff, but when you have sub folders that need their own 
> Application.cfm
> files, they become less convenient as you have to make sure 
> to include any
> needed code from the Application.cfms above them.  Today, I 
> had a (probably
> unoriginal) idea.  Is it possible to  the 'root' 
> Application.cfm
> into the sub Application.cfms?  This would save me from 
> having to edit all
> of the sub ones every time I made a change to the root one.  
> If this is
> technicly possible, is there any reason this shouldn't be done?


If you have a ColdFusion mapping set up for the website, you could just





-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

No Subject

[Cristi]

usubscribe
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Scheduler and SQLBase.. help needed urgently

[steven broadbent]

 I am trying to use CF administrator to write updates and inserts to
tables on Centura SQLBase (formerly Gupta)
 We are using CF 4.5

 The template runs fine from the browser, but won't run as a scheduled
task.  If I add code to send an e mail in the template, either above or
below the database code , this dosen't happen either.  We have scheduled
tasks which write to access tables and send e-mail and they run fine.


Has anyone found their RBDMS won't accept scheduled tasks, and what are the
alternatives.  I think you can run scheduled tasks under NT but I don't know
anything about it.  Any help would be an absolute godsend.


Steven

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Server Date comparison

[Smith, Melanie]

Oops - Correction - Sorry Phillip!  Don't be !  Thanks a lot

> -Original Message-
> From: Smith, Melanie 
> Sent: Thursday, June 22, 2000 5:27 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: SQL Server Date comparison
> 
> Message-ID: <[EMAIL PROTECTED]>
> 
> Thanks Phillip and Robert.  The CreateODBCDateTime didn't work - in
> debugger that turned the date into 6-22-00 00:00:00 so any documents I
> added today wouldn't be found.  I used Robert's syntax below and it worked
> like a charm!  Thanks MUCH!!!
> 
> WHERE tblDocumentMstr.effectivedate Between
>   #CreateODBCDate(form.begindate)# And
> DateAdd(d,1,#CreateODBCDate(form.enddate)#) 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Checking for a record, and then deleting it

[Beth Strichartz]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFDD0A.E847BC10
Content-Type: text/plain;
charset="iso-8859-1"

Hi,
Test for results after the 

 


NOBLE(STAR
Beth Strichartz
Consultant
617.252.3322 voice
[EMAIL PROTECTED]
http://noblestar.com


-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 9:25 PM
To: [EMAIL PROTECTED]
Subject: Checking for a record, and then deleting it


I have a table in a database that contains the fields CFID, CFTOKEN, WDDX
(which is an array that I used CFWDDX on), and the date.  It is for a system
configurator for new computer systems.  When someone fills in the forms for
what they want on their system, it puts it in a database, then they can
click a reconfigure button...  that takes them back to the form they just
filled out so they can reconfigure their system.  THen they hit the submit
button again and here I need to check if a record in the quotes table
already exists (meaning this is at least the second time they've configured
a system), and if it exists, then that record needs to be deleted.  Here is
the code I've tried but it doesn't work:


Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)





DELETE FROM SystemQuote WHERE CFID = #CFID#





Does anybody know of a way of doing this?  Thanks in advance.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--_=_NextPart_001_01BFDD0A.E847BC10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: Checking for a record, and then deleting it



Hi,
Test for results after the 


 



NOBLE(STAR
Beth Strichartz
Consultant
617.252.3322 voice
[EMAIL PROTECTED]
http://noblestar.com" =
TARGET=3D"_blank">http://noblestar.com



-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]">mailto:coldfusion@bluewaterpc=
.com]
Sent: Thursday, June 22, 2000 9:25 PM
To: [EMAIL PROTECTED]
Subject: Checking for a record, and then deleting =
it



I have a table in a database that contains the fields =
CFID, CFTOKEN, WDDX
(which is an array that I used CFWDDX on), and the =
date.  It is for a system
configurator for new computer systems.  When =
someone fills in the forms for
what they want on their system, it puts it in a =
database, then they can
click a reconfigure button...  that takes them =
back to the form they just
filled out so they can reconfigure their =
system.  THen they hit the submit
button again and here I need to check if a record in =
the quotes table
already exists (meaning this is at least the second =
time they've configured
a system), and if it exists, then that record needs =
to be deleted.  Here is
the code I've tried but it doesn't work:



Select * FROM SystemQuote WHERE (CFID=3D#CFID# AND =
CFTOKEN=3D#CFTOKEN#)





    
    DELETE =
FROM SystemQuote WHERE CFID =3D #CFID#
    





Does anybody know of a way of doing this?  =
Thanks in advance.


---=
---
Archives: http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.



--_=_NextPart_001_01BFDD0A.E847BC10--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Tracking users through a site

[Zachary Bedell]

:~~
: From: Zachary Bedell <[EMAIL PROTECTED]>
: Another possibility, if cookies are an option, would be to
: continuely pass a "Click Stream" cookie back & forth to the
: user.  At each page request, just take the current cookie
:~~
> this would only work up to 4k.  that's the limit set 
> on cookie size.  it wouldn't take much surfing and 
> page tracking to reach that limit.

I figured there had to be a limit.  Just wasn't sure what it was

The sites I've seen that pull this off use a very terse tokenized form of
this -- just a char or two for each page.  That works for them, but I guess
for the original poster's needs, 4k would probably fall a bit short of the
mark...

Thanks for the info!
Zac Bedell
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Solaris vs Linux

[Stas Maximov]

Dear Fusioners,

I'm on the stage of choosing platform for application server. Candidates are
Sparc Solaris and PIII-750 Linux. As I understand there is no difference
what hardware is: Sparc Server of Intel P3 if the latter has enough RAM and
faster Intel processor. But what about ColdFusion for these platforms? Isn't
Linux version of CF4.5 too raw? Or this is just a gossip? I wish to use
Linux/PC version, but I'm afraid that it will be less stable, has some bugs,
etc.

Any help will be highly appreciated.

stas@

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.