RE: client variables and no cookies

2000-08-22 Thread Francisco Montes; Spain on Line

Thanks Justin,

However what i want to do is to hide completely this variables. I read,
literally from the CF Studio help pages: "[...] you must maintain client
state in URLs. by passing the client ID (CFID)and the client security token
(CFTOKEN) between pages, either in hidden form fields or appended to URLs.
"...

So it seems possible to pass these parameters through form fields but ...
even if i pass them on, the CF server doesn´t seem to care about them!

Francisco

-Mensaje original-
De: JustinMacCarthy [EMAIL PROTECTED]
Para: [EMAIL PROTECTED] [EMAIL PROTECTED]
Fecha: lunes 21 de agosto de 2000 20:49
Asunto: Re: client variables and no cookies


you can do

form action=index.cfm?#Urltoken# method=post

etc..


~justin



- Original Message -
From: "Francisco Montes; Spain on Line" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 21, 2000 6:12 PM
Subject: client variables and no cookies


 This is a multi-part message in MIME format.

 --=_NextPart_000_0150_01C00BA3.B2ED8820
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 Hi all,

 I=B4m trying to keep client data but without using cookies. I know that,
=
 in that case, CFID and CFTOKEN have to be passed around  all the time to
=
 accomplish it.

 Now, i tried to pass the URLTOKEN variable through the URL and it went =
 just fine. However i read that these parameters can also be passed =
 through hidden form fields how do i do it? I tried to pass CFID and =
 CFTOKEN but everytime i ask CFserver for a new page it creates a new =
 pair CFID/CFTOKEN without even considering the ones i sent it before =
 through hidden form fields!!!

 What am i doing wrong?

 Francisco Montes

 --=_NextPart_000_0150_01C00BA3.B2ED8820
 Content-Type: text/html;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"
 HTML
 HEAD

 META content=3Dtext/html;charset=3Diso-8859-1 =
 http-equiv=3DContent-Type
 META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT color=3D#00 size=3D2Hi all,/FONT/DIV
 DIVFONT color=3D#00 size=3D2/FONTnbsp;/DIV
 DIVFONT color=3D#00 size=3D2Iacute;m trying to keep client data
=
 but without=20
 using cookies. I know that, in that case, CFID and CFTOKEN have to be =
 passed=20
 aroundnbsp; all the time to accomplish it./FONT/DIV
 DIVFONT color=3D#00 size=3D2/FONTnbsp;/DIV
 DIVFONT color=3D#00 size=3D2Now, i tried to pass the URLTOKEN =
 variable=20
 through the URL and it went just fine. However i read that these =
 parameters can=20
 also be passed through hidden form fields how do i do it? I tried to
=
 pass=20
 CFID and CFTOKEN but everytime i ask CFserver for a new page it creates =
 a new=20
 pair CFID/CFTOKEN without even considering the ones i sent it before =
 through=20
 hidden form fields!!!/FONT/DIV
 DIVFONT color=3D#00 size=3D2/FONTnbsp;/DIV
 DIVFONT color=3D#00 size=3D2What am i doing wrong?/FONT/DIV
 DIVFONT color=3D#00 size=3D2/FONTnbsp;/DIV
 DIVFONT color=3D#00 size=3D2Francisco =
 Montes/FONT/DIV/BODY/HTML

 --=_NextPart_000_0150_01C00BA3.B2ED8820--

 -
-

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



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

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



RE: LDAP searching - [need a server]

2000-08-22 Thread Michael O Reilly

Stephen,

You may want to try the Netscape LDAP server which comes as a 3rd party
product on the CF 4.5 Pro installation CD.
I installed it to see what it was like. Personally I hated the interface
which I thought was a bit clunky (HTML based requiring Navigator).  I much
prefer MS Exchange's implementation which is X400 based ( I believe that
strictly speaking LDAP is a cut down version of X500). This means that the
attibute names differ slightly from the standard attribute names. Exchange
can be setup to create a user whenever a new NT account is set up, which
means your user directory is kept in synch. Finally Novell had a free
download on their site which exposed the NDS tree as an LDAP directory. I
installed it on a Novell 4.11 box when I knew little about LDAP and couldn't
get it to work. 
You'll find that whatever server you use, getting queries to work at first
can be a real pain in the butt. It's more a question of trial and error than
an exact science.

Regards
Michael O'Reilly
TransAer


-Original Message-
From: Gerry Pauline [mailto:[EMAIL PROTECTED]]
Sent: 18 August 2000 16:38
To: [EMAIL PROTECTED]
Subject: Re: LDAP searching - [need a server]


Stephen:

We use Netscape's LDAP, which is anything but free (license fees are
based on the number of entries) ! Try this one at the Open LDAP project:

http://www.openldap.org

-Gerry

Gerard T. Pauline
Computer Systems, DoIT
Pace University



"Stephen M. Aylor" wrote:
 
 Anyone got a FREE, Easy, Simple, Good LDAP server they could turn me onto?
 Preferrably one that might have some doc's Im a total rookie (on many
 tech levels) WIN OS BTW.
 
 TIA,
 
 Steve
 
 - Original Message -
 From: "John Anderson" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, August 17, 2000 2:57 PM
 Subject: Re: LDAP searching
 
  Lucas,
 
  A production LDAP query which sorts (CF 4.0):
  cfldap action="QUERY"
  name="personquery"
  attributes="cn,telephonenumber,mail,title,salutation,o,location"
  start="ou=Users, o=jcu.edu.au"
  scope="ONELEVEL"
  maxrows="3"
  filter="((cn=*#data_entered#*)(accountenabled=true))"
  sort="cn"
  server="ldap"
  port="389"
  timeout="240"
 
   I know that this will sound like a very simple question but I hope
that
   someone can help...
  
   I know that the server is working and can get results back but I am
 unable
   to sort them.
  
   Here is an example of the code that I am running...
   It works, and returns a query with all the locations in it but they
are
   un-sorted.
  
   cfldap action="QUERY"
   name="Results"
   attributes="l"
   start="ou=staff,o=company.com.au"
   sortcontrol="l"
   server="ldap"
   port="389"
  
   any ideas?
   Thanks,
   Lucas.
 


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

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



Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Michael O Reilly

Hi all,
I have been given a problem which I'm not sure is solvable.
We are to publish staff rosters on the Web and want to know if staff have
been notified of/looked at their roster.
I have said that although we can detect that the user has requested a page,
it's impossible to know if the whole page arrived at the browser (people are
connecting in from all over the world on some very dodgy telco systems so
connection speeds can be assumed to be poor). Am I correct here.

I know I could put a JS onload event into the body tag which submits some
info back to the server. But can I put anything at the end of the page which
would do the same.

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



Blob in oracle

2000-08-22 Thread Franz Rustler

Hello 

i have some problem with the Blob in Oracle.
I search a custom Tag that can view me the Blob.
the Blob is a Jpg/gif or Htm but i can not view it.
thanks for evrey help.

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



Re: Blob in oracle

2000-08-22 Thread Gena

I guess the problem is not in Oracle.

See http://www.experts-exchange.com/bin/Q.10578041

Cheers

 Hello

 i have some problem with the Blob in Oracle.
 I search a custom Tag that can view me the Blob.
 the Blob is a Jpg/gif or Htm but i can not view it.
 thanks for evrey help.

 Franz
 --

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


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



AW: Blob in oracle

2000-08-22 Thread Franz Rustler

But for SQL Server exist the getimage take.
This take  i  need for Oracle.
 thanks franz
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Dick Applebaum

Why not use an "I have read this" button that the user must click?

An alternative is an onUnload routine in the BODY tag... but, yhis 
just means it was received, and that the user has moved on.

Dick

At 9:41 AM +0100 8/22/00, Michael O Reilly wrote:
Hi all,
I have been given a problem which I'm not sure is solvable.
We are to publish staff rosters on the Web and want to know if staff have
been notified of/looked at their roster.
I have said that although we can detect that the user has requested a page,
it's impossible to know if the whole page arrived at the browser (people are
connecting in from all over the world on some very dodgy telco systems so
connection speeds can be assumed to be poor). Am I correct here.

I know I could put a JS onload event into the body tag which submits some
info back to the server. But can I put anything at the end of the page which
would do the same.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Blob in oracle

2000-08-22 Thread Gena

 But for SQL Server exist the getimage take.

BTW I could find only the way I show earlier. The problem is - how to get
image into CF variable and store into HD. And it is CF problem - not RDBMS

Cheers

 This take  i  need for Oracle.
  thanks franz
 --

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


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



Re: Caching pages

2000-08-22 Thread Gena

 Is there a way to keep browsers from caching a page?

Yes

 I have a CF page that does a calculation, and if the person hits the back
 button and goes back to the page the data is not updated.

Like this:

cfset a= random()

MyFile.cfm?refresh=#a#


Cheers


 Thanks
 Chad
 --

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


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



Upgrade 4.01 to 4.5.1 ?

2000-08-22 Thread cf-talk


Hi, now it is about time to upgrade my CF-Server since on
one of my projects I have to use a special 4.5-Tag.

Any pitfalls with the upgrade-process/server-running other than the service-pack 6 
issue under NT people mentioned on this list ?
Order of installation: 4.0 / 4.01 / 4.5 / 4.5.1
Am I correct ?

Thanks 
Uwe




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



AW: Blob in oracle

2000-08-22 Thread Franz Rustler

Yes, i now it´s a cf problem but i think oracle handle Blob fields other
then SQL Server.
The scecond problem is getimage is for Win NT server i use a Solaris server.

thanks Franz

P.s.

Sorry for my english

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Blob in oracle

2000-08-22 Thread Gena

Yes, i now it´s a cf problem but i think oracle handle Blob fields other
then SQL Server.

Yes, you right. They handle BLOB in different ways, but solution for CF is
in the link I sent you. Outstanding - just write SQL requests to store
binary file into BLOB and to get it from the table :))

The scecond problem is getimage is for Win NT server i use a Solaris server.

It shouldn't be big problem. Try to find answer on www.deja.com

P.s.

Sorry for my english

No problem

I'm not englishman too :)


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.


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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Michael O Reilly

The point of getting notification that a user has seen his/her roster page
is in case they decide to go AWOL after seeing they are rostered for a job
they may not wish to do. We can therefore say that we know you seen you were
rostered for job x and should have reported for duty. In this case, a button
the user voluntarily clicks, won't work.

Also a BODY onUnload="" solution isn't really confirming that the whole
page loaded. I need to post some info back to the server near the end of the
page without the user knowing. If I set up a form with an action property
targetting a hidden frame, some hidden form fields and put some Javascript
into the end of the page which submits the form data , the data should go
back to the server? I'm wondering if anyone has done this sort of thing.

Regards
Michael O'Reilly
TransAer


-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 10:15
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT - Detecting that a page has completed.


Why not use an "I have read this" button that the user must click?

An alternative is an onUnload routine in the BODY tag... but, yhis 
just means it was received, and that the user has moved on.

Dick

At 9:41 AM +0100 8/22/00, Michael O Reilly wrote:
Hi all,
I have been given a problem which I'm not sure is solvable.
We are to publish staff rosters on the Web and want to know if staff have
been notified of/looked at their roster.
I have said that although we can detect that the user has requested a page,
it's impossible to know if the whole page arrived at the browser (people
are
connecting in from all over the world on some very dodgy telco systems so
connection speeds can be assumed to be poor). Am I correct here.

I know I could put a JS onload event into the body tag which submits some
info back to the server. But can I put anything at the end of the page
which
would do the same.

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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Stewart McGowan

Michael,

Maybe delaying an action of some sort by a set time at the bottom of the
page (which should be requested last, and therefore executed last) however,
doesn't really solve the problem because the page may not have fully
rendered.plausible deniability.


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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Anthony Geoghegan

Hi Michael,

You said:
|I need to post some info back to the server near 
|the end of the
|page without the user knowing. If I set up a form with an 
|action property
|targetting a hidden frame, some hidden form fields and put 
|some Javascript
|into the end of the page which submits the form data , the 
|data should go
|back to the server? I'm wondering if anyone has done this sort 
|of thing.


Check out the vote button on our home page( www.wow.ie ), it does just this.
email me off list for the details.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

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



Re: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Wjreichard

Could you use remote scripting ... which will execute server script to do 
whatever when the forms OnLoad fires. Remote scripting uses two java applets 
that allow a server round trip without ever leaving/updating the original 
client page. Other uses fro remote scripting to populate large combpo boxes 
when actually accessed vice waiting for big initial page download time.

If you can't find or want some detail on remote scripting, give a yell:

[EMAIL PROTECTED]

Bill
Willow Gold
http://www.willowgold.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Caching pages

2000-08-22 Thread Anthony Geoghegan

Hi All,

You wrote:
| Is there a way to keep browsers from caching a page?
|
|Yes

I have found this to be very effective:

CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must-revalidate"

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

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



Problem with CFFTP

2000-08-22 Thread Andy Ewings

I have a problem with CFFTP.  I am trying to use CFFTP to download a file
onto a user hard drive.  When the user clicks a button the web site creates
a file using CFFILE and then tries to download it to C:\temp using CFFTP.
However all it is doing is saving it to C:\Temp on the web server!  Here is
my code

cfftp action="open" username="username" password="password"
server="servername" connection="temp" stoponerror="no"
cfoutput
Open Error Code: #cfftp.errorcode#
Open Error Text: #cfftp.errortext#
/cfoutput

cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
failifexists="No" stoponerror="No"
Download Error Code: #cfftp.errorcode#br
Download Error Text: #cfftp.errortext#br  
/cfoutput
cfftp action="CLOSE" connection="cv"

Both FTP operations succeed.  Anyone have any ideas?


--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--

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



RE: Linked Tables in SQL Server?

2000-08-22 Thread Philip Arnold - ASP

 Is there a way to "link" tables in SQL Server the way they can be
 in ACCESS?
 I mean in separate databases of course,

If you mean to a SQL database, you don't need to.

SQL Server will allow you to talk to other databases (even those without
ODBC DSNs);

select t1.*, t2.*
from table1 as t1, serverName.databaseName.dbo.tableName as t2

You can cut off the "serverName" part, it talks quite happily to other
databases as long as they are SQL Server

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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Linked Tables in SQL Server?

2000-08-22 Thread Andy Ewings

Do you mean is there an equivalent in SQL Server to the 'relationship'
window you find in Access?  If so then have a look at the 'diagram' option
for each database

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 11:45
To: [EMAIL PROTECTED]
Subject: RE: Linked Tables in SQL Server?


 Is there a way to "link" tables in SQL Server the way they can be
 in ACCESS?
 I mean in separate databases of course,

If you mean to a SQL database, you don't need to.

SQL Server will allow you to talk to other databases (even those without
ODBC DSNs);

select t1.*, t2.*
from table1 as t1, serverName.databaseName.dbo.tableName as t2

You can cut off the "serverName" part, it talks quite happily to other
databases as long as they are SQL Server

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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Dick Applebaum

Technically speaking, the onLoad is not supposed to fire until the 
entire page has been loaded...

Some IE browsers (especially on the Mac) violate this, tho.

You could use a script at the end of the page, a meta tag refresh, 
onUnload,, a button...

But, what if they have the browser page hidden or not currently displayed...

...lots of excuses to bail on you:

   the text was too small

   that portion of the pag was off the screen

   I got interrupted and vever got back to it

Sounds like a case of "The dog ate my roster".   You are not going to 
solve this with a program or a script... a company policy and some 
enforced compliance is required.

Dick




At 11:01 AM +0100 8/22/00, Michael O Reilly wrote:
The point of getting notification that a user has seen his/her roster page
is in case they decide to go AWOL after seeing they are rostered for a job
they may not wish to do. We can therefore say that we know you seen you were
rostered for job x and should have reported for duty. In this case, a button
the user voluntarily clicks, won't work.

Also a BODY onUnload="" solution isn't really confirming that the whole
page loaded. I need to post some info back to the server near the end of the
page without the user knowing. If I set up a form with an action property
targetting a hidden frame, some hidden form fields and put some Javascript
into the end of the page which submits the form data , the data should go
back to the server? I'm wondering if anyone has done this sort of thing.

Regards
Michael O'Reilly
TransAer

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



CFTREE's CompletePath Parameter

2000-08-22 Thread Michael O Reilly

I've been trying to figure out exactly what difference this parameter makes
to a CFTREE.

CF's documentation says the following

COMPLETEPATH
Optional. Yes passes the root level of the treename.path form variable when
the CFTREE is submitted. If omitted or No, the root level of this form
variable is not included.

What the f*** does this mean in plain english?

The examples don't show what this does, and with debugging info on, there
doesn't seem to be any difference between specifying Yes or No.

From my previous experience with CFTree, dblclicking on a node does not
cause form vars to be submitted even though CFTree must reside within a
CFForm.

Anyone on the list figured out/used this parameter?

Regards
Michael O'Reilly
TransAer

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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Michael O Reilly

Dick,
If we can be reasonably sure the page was viewed, then thats good enough. If
I can go back to my manager and say that this ain't 100% foolproof but it's
as good as your gonna get, then he has no choice but to fly with it.

Michael

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 12:23 PM
To: [EMAIL PROTECTED]
Subject: RE: Slightly OT - Detecting that a page has completed.


Technically speaking, the onLoad is not supposed to fire until the 
entire page has been loaded...

Some IE browsers (especially on the Mac) violate this, tho.

You could use a script at the end of the page, a meta tag refresh, 
onUnload,, a button...

But, what if they have the browser page hidden or not currently displayed...

...lots of excuses to bail on you:

   the text was too small

   that portion of the pag was off the screen

   I got interrupted and vever got back to it

Sounds like a case of "The dog ate my roster".   You are not going to 
solve this with a program or a script... a company policy and some 
enforced compliance is required.

Dick




At 11:01 AM +0100 8/22/00, Michael O Reilly wrote:
The point of getting notification that a user has seen his/her roster page
is in case they decide to go AWOL after seeing they are rostered for a job
they may not wish to do. We can therefore say that we know you seen you
were
rostered for job x and should have reported for duty. In this case, a
button
the user voluntarily clicks, won't work.

Also a BODY onUnload="" solution isn't really confirming that the whole
page loaded. I need to post some info back to the server near the end of
the
page without the user knowing. If I set up a form with an action property
targetting a hidden frame, some hidden form fields and put some Javascript
into the end of the page which submits the form data , the data should go
back to the server? I'm wondering if anyone has done this sort of thing.

Regards
Michael O'Reilly
TransAer


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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Michael O Reilly

Bill, 
I've seen remote scriptin mentioned on the list before. I downloaded stuff
from MSDN, but the docs weren't great and at the time, I couldn't really
think of a use, worth spending a couple of days mucking around with it.
Now I that have, do you know of any resources, sample code that might be of
help?
It's IE dependent isn't it?

Michael

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 11:29 AM
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT - Detecting that a page has completed.


Could you use remote scripting ... which will execute server script to do 
whatever when the forms OnLoad fires. Remote scripting uses two java applets

that allow a server round trip without ever leaving/updating the original 
client page. Other uses fro remote scripting to populate large combpo boxes 
when actually accessed vice waiting for big initial page download time.

If you can't find or want some detail on remote scripting, give a yell:

[EMAIL PROTECTED]

Bill
Willow Gold
http://www.willowgold.com

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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread DeVoil, Nick

 If we can be reasonably sure the page was viewed, then thats good enough. 

Michael,
The only way I can see this working is

- use a button or checkbox - this is equivalent to them signing it, like the
license agreements you get in software
- instigate a policy *requiring* people to use the button
- put it *after* the roster information
- design the page so that it would be implausible to say "I didn't see that
part", i.e. make the page nice and compact so that no scrolling is required
- maybe you could force the dimensions of the window to a certain size.

Nick


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Problem with CFFTP

2000-08-22 Thread Kevin Schmidt

Yeah,  You can't use CFFTP to move files between the cfserver and browser.
Only between the FTP server and CF server.  You have to use CFFILE and
CFCONTENT to upload and download from the browser to the server and then
from the server to the FTP server and vice versa.

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 5:56 AM
Subject: Problem with CFFTP


 I have a problem with CFFTP.  I am trying to use CFFTP to download a file
 onto a user hard drive.  When the user clicks a button the web site
creates
 a file using CFFILE and then tries to download it to C:\temp using CFFTP.
 However all it is doing is saving it to C:\Temp on the web server!  Here
is
 my code

 cfftp action="open" username="username" password="password"
 server="servername" connection="temp" stoponerror="no"
 cfoutput
 Open Error Code: #cfftp.errorcode#
 Open Error Text: #cfftp.errortext#
 /cfoutput

 cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
 remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
 failifexists="No" stoponerror="No"
 Download Error Code: #cfftp.errorcode#br
 Download Error Text: #cfftp.errortext#br
 /cfoutput
 cfftp action="CLOSE" connection="cv"

 Both FTP operations succeed.  Anyone have any ideas?


 --
 Andrew Ewings
 Project Manager
 Thoughtbubble Ltd
 --

 --

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


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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Wjreichard

Remote scripting will work in any browser that supports java applets, should cover 
99%. Hang on and let me find some resources for you.

Email me and I'll send you what I have. [EMAIL PROTECTED]

Bill
Willow Gold
http://www.willowgold.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



arraysort

2000-08-22 Thread Vincent

This is a multi-part message in MIME format.

--=_NextPart_000_0075_01C00C66.0F476AB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

hi,
  Can any one guide me thru the process of Double dimesion array sorting =
!

thanks
vin

--=_NextPart_000_0075_01C00C66.0F476AB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"
HTML
HEAD

META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type
META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR
/HEAD
BODY bgColor=3D#ff
DIVFONT color=3D#008080 face=3DVerdana size=3D2hi,/FONT/DIV
DIVFONT color=3D#008080 face=3DVerdana size=3D2nbsp; Can any one =
guide me thru=20
the process of Double dimesion array sorting !/FONT/DIV
DIVFONT color=3D#008080 face=3DVerdana size=3D2/FONTnbsp;/DIV
DIVFONT color=3D#008080 face=3DVerdana size=3D2thanks/FONT/DIV
DIVFONT color=3D#008080 face=3DVerdana =
size=3D2vin/FONT/DIV/BODY/HTML

--=_NextPart_000_0075_01C00C66.0F476AB0--

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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

Oh.

How do I do that?  What I am trying to do is let the user download a
specific file from the web server to there Hard drive but I want to let them
choose where to save it.  Have you got any code that will do this?

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:28
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Yeah,  You can't use CFFTP to move files between the cfserver and browser.
Only between the FTP server and CF server.  You have to use CFFILE and
CFCONTENT to upload and download from the browser to the server and then
from the server to the FTP server and vice versa.

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 5:56 AM
Subject: Problem with CFFTP


 I have a problem with CFFTP.  I am trying to use CFFTP to download a file
 onto a user hard drive.  When the user clicks a button the web site
creates
 a file using CFFILE and then tries to download it to C:\temp using CFFTP.
 However all it is doing is saving it to C:\Temp on the web server!  Here
is
 my code

 cfftp action="open" username="username" password="password"
 server="servername" connection="temp" stoponerror="no"
 cfoutput
 Open Error Code: #cfftp.errorcode#
 Open Error Text: #cfftp.errortext#
 /cfoutput

 cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
 remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
 failifexists="No" stoponerror="No"
 Download Error Code: #cfftp.errorcode#br
 Download Error Text: #cfftp.errortext#br
 /cfoutput
 cfftp action="CLOSE" connection="cv"

 Both FTP operations succeed.  Anyone have any ideas?


 --
 Andrew Ewings
 Project Manager
 Thoughtbubble Ltd
 --

 --

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



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



Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

They already have the ability to specify where it is saved.  That is
completely a client function.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP


 Oh.

 How do I do that?  What I am trying to do is let the user download a
 specific file from the web server to there Hard drive but I want to let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 browser.
 Only between the FTP server and CF server.  You have to use CFFILE and
 CFCONTENT to upload and download from the browser to the server and then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to download a
 file
  onto a user hard drive.  When the user clicks a button the web site
 creates
  a file using CFFILE and then tries to download it to C:\temp using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web server!
 Here
 is
  my code
 
  cfftp action="open" username="username" password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: #cfftp.errortext#br
  /cfoutput
  cfftp action="CLOSE" connection="cv"
 
  Both FTP operations succeed.  Anyone have any ideas?
 
 
  --
  Andrew Ewings
  Project Manager
  Thoughtbubble Ltd
  --
 
 
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
 or
 send a message to [EMAIL PROTECTED] with 'unsubscribe'
 in
 the body.
 

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


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



RE: Caching pages

2000-08-22 Thread Gilles Ratte

Can you explain a little further...
I don't see how you do this with a random refresh

thanx

 -Message d'origine-
 De:   Gena [SMTP:[EMAIL PROTECTED]]
 Date: Tuesday, August 22, 2000 5:24 AM
 À:[EMAIL PROTECTED]
 Objet:Re: Caching pages
 
  Is there a way to keep browsers from caching a page?
 
 Yes
 
  I have a CF page that does a calculation, and if the person hits the
 back
  button and goes back to the page the data is not updated.
 
 Like this:
 
 cfset a= random()
 
 MyFile.cfm?refresh=#a#
 
 
 Cheers
 
 
  Thanks
  Chad
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

Oh okbut I still don;t see/understand how you move files from the web
server to the client using cffile/cfcontent.  I would have thought cfftp
would have done this by the nature of it's name!  Anyone show me what to
do?!

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


They already have the ability to specify where it is saved.  That is
completely a client function.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP


 Oh.

 How do I do that?  What I am trying to do is let the user download a
 specific file from the web server to there Hard drive but I want to let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 browser.
 Only between the FTP server and CF server.  You have to use CFFILE and
 CFCONTENT to upload and download from the browser to the server and then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to download a
 file
  onto a user hard drive.  When the user clicks a button the web site
 creates
  a file using CFFILE and then tries to download it to C:\temp using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web server!
 Here
 is
  my code
 
  cfftp action="open" username="username" password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: #cfftp.errortext#br
  /cfoutput
  cfftp action="CLOSE" connection="cv"
 
  Both FTP operations succeed.  Anyone have any ideas?
 
 
  --
  Andrew Ewings
  Project Manager
  Thoughtbubble Ltd
  --
 
 
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
 or
 send a message to [EMAIL PROTECTED] with 'unsubscribe'
 in
 the body.
 

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



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



RE: CFTREE's CompletePath Parameter

2000-08-22 Thread Anthony Geoghegan

Hi Michael,

You wrote:
|What the f*** does this mean in plain english?
|
|The examples don't show what this does, and with debugging 
|info on, there
|doesn't seem to be any difference between specifying Yes or No.

I have recently had the misfortune to work with this applet and found a few
problems with it so I had to dump it and get a third party applet to do the
same thing.
I believe the completepath parameter just specifies the applet to include
the parent folders in the path variable.  I think this path variable is
included as a parameter in the URL when a link is included on the treeitem
and the link is clicked.
I'm not sure as I said I tossed it because of table related issues.

Hope this helps.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

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



Re: Problem with CFFTP

2000-08-22 Thread Kevin Schmidt

Actually I am working on the code right now.  So I don't have anything for
you yet.  I have the upload and directory listing code already but that is
the easy stuff.  Except some pesky bug that I can't figure out with Win2k
the stinking CFFTP tag will only send a 0 byte file when it uploads.
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 7:52 AM
Subject: RE: Problem with CFFTP


 Oh.

 How do I do that?  What I am trying to do is let the user download a
 specific file from the web server to there Hard drive but I want to let
them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and browser.
 Only between the FTP server and CF server.  You have to use CFFILE and
 CFCONTENT to upload and download from the browser to the server and then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to download a
file
  onto a user hard drive.  When the user clicks a button the web site
 creates
  a file using CFFILE and then tries to download it to C:\temp using
CFFTP.
  However all it is doing is saving it to C:\Temp on the web server!  Here
 is
  my code
 
  cfftp action="open" username="username" password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: #cfftp.errortext#br
  /cfoutput
  cfftp action="CLOSE" connection="cv"
 
  Both FTP operations succeed.  Anyone have any ideas?
 
 
  --
  Andrew Ewings
  Project Manager
  Thoughtbubble Ltd
  --
 

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

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

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

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



Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

CFCONTENT causes CF to read a file from the web server and "push" it to
the client via the browser.  CFFILE lets you move files around on the web
server, including creating, renaming, copying and deleting.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:02
Subject: RE: Problem with CFFTP


 Oh okbut I still don;t see/understand how you move files from the
 web
 server to the client using cffile/cfcontent.  I would have thought cfftp
 would have done this by the nature of it's name!  Anyone show me what to
 do?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 13:56
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 They already have the ability to specify where it is saved.  That is
 completely a client function.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 12:52
 Subject: RE: Problem with CFFTP


  Oh.
 
  How do I do that?  What I am trying to do is let the user download a
  specific file from the web server to there Hard drive but I want to
 let
  them
  choose where to save it.  Have you got any code that will do this?
 
  -Original Message-
  From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:28
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  Yeah,  You can't use CFFTP to move files between the cfserver and
  browser.
  Only between the FTP server and CF server.  You have to use CFFILE and
  CFCONTENT to upload and download from the browser to the server and
 then
  from the server to the FTP server and vice versa.
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: "CFTalk (E-mail)" [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 5:56 AM
  Subject: Problem with CFFTP
 
 
   I have a problem with CFFTP.  I am trying to use CFFTP to download a
  file
   onto a user hard drive.  When the user clicks a button the web site
  creates
   a file using CFFILE and then tries to download it to C:\temp using
  CFFTP.
   However all it is doing is saving it to C:\Temp on the web server!
  Here
  is
   my code
  
   cfftp action="open" username="username" password="password"
   server="servername" connection="temp" stoponerror="no"
   cfoutput
   Open Error Code: #cfftp.errorcode#
   Open Error Text: #cfftp.errortext#
   /cfoutput
  
   cfftp connection="temp" action="GETFILE"
 localfile="c:\temp\test.doc"
   remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
   failifexists="No" stoponerror="No"
   Download Error Code: #cfftp.errorcode#br
   Download Error Text: #cfftp.errortext#br
   /cfoutput
   cfftp action="CLOSE" connection="cv"
  
   Both FTP operations succeed.  Anyone have any ideas?
  
  
   --
   Andrew Ewings
   Project Manager
   Thoughtbubble Ltd
   --
  
  
 
 
  --
  
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or
  send a message to [EMAIL PROTECTED] with 'unsubscribe'
  in
  the body.
  
 
 
 
  
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or
  send a message to [EMAIL PROTECTED] with 'unsubscribe'
  in
  the body.
 
 
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or send a message to [EMAIL PROTECTED] with
  'unsubscribe' in the body.
 

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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in 

RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

well rest assured I am trying here too!if I get anywhere I'll send you
the code.  

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 15:09
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Actually I am working on the code right now.  So I don't have anything for
you yet.  I have the upload and directory listing code already but that is
the easy stuff.  Except some pesky bug that I can't figure out with Win2k
the stinking CFFTP tag will only send a 0 byte file when it uploads.
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 7:52 AM
Subject: RE: Problem with CFFTP


 Oh.

 How do I do that?  What I am trying to do is let the user download a
 specific file from the web server to there Hard drive but I want to let
them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and browser.
 Only between the FTP server and CF server.  You have to use CFFILE and
 CFCONTENT to upload and download from the browser to the server and then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to download a
file
  onto a user hard drive.  When the user clicks a button the web site
 creates
  a file using CFFILE and then tries to download it to C:\temp using
CFFTP.
  However all it is doing is saving it to C:\Temp on the web server!  Here
 is
  my code
 
  cfftp action="open" username="username" password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE" localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: #cfftp.errortext#br
  /cfoutput
  cfftp action="CLOSE" connection="cv"
 
  Both FTP operations succeed.  Anyone have any ideas?
 
 
  --
  Andrew Ewings
  Project Manager
  Thoughtbubble Ltd
  --
 

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

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

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


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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

I thought CFContent basically allows the user to read non HTML files in
their browser window (after all the browser is just a container).  I don't
want to open the file in their browser, just let them save it to their hard
drive and open it up in word (it's a word doc)

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:05
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


CFCONTENT causes CF to read a file from the web server and "push" it to
the client via the browser.  CFFILE lets you move files around on the web
server, including creating, renaming, copying and deleting.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:02
Subject: RE: Problem with CFFTP


 Oh okbut I still don;t see/understand how you move files from the
 web
 server to the client using cffile/cfcontent.  I would have thought cfftp
 would have done this by the nature of it's name!  Anyone show me what to
 do?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 13:56
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 They already have the ability to specify where it is saved.  That is
 completely a client function.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 12:52
 Subject: RE: Problem with CFFTP


  Oh.
 
  How do I do that?  What I am trying to do is let the user download a
  specific file from the web server to there Hard drive but I want to
 let
  them
  choose where to save it.  Have you got any code that will do this?
 
  -Original Message-
  From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:28
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  Yeah,  You can't use CFFTP to move files between the cfserver and
  browser.
  Only between the FTP server and CF server.  You have to use CFFILE and
  CFCONTENT to upload and download from the browser to the server and
 then
  from the server to the FTP server and vice versa.
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: "CFTalk (E-mail)" [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 5:56 AM
  Subject: Problem with CFFTP
 
 
   I have a problem with CFFTP.  I am trying to use CFFTP to download a
  file
   onto a user hard drive.  When the user clicks a button the web site
  creates
   a file using CFFILE and then tries to download it to C:\temp using
  CFFTP.
   However all it is doing is saving it to C:\Temp on the web server!
  Here
  is
   my code
  
   cfftp action="open" username="username" password="password"
   server="servername" connection="temp" stoponerror="no"
   cfoutput
   Open Error Code: #cfftp.errorcode#
   Open Error Text: #cfftp.errortext#
   /cfoutput
  
   cfftp connection="temp" action="GETFILE"
 localfile="c:\temp\test.doc"
   remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
   failifexists="No" stoponerror="No"
   Download Error Code: #cfftp.errorcode#br
   Download Error Text: #cfftp.errortext#br
   /cfoutput
   cfftp action="CLOSE" connection="cv"
  
   Both FTP operations succeed.  Anyone have any ideas?
  
  
   --
   Andrew Ewings
   Project Manager
   Thoughtbubble Ltd
   --
  
  
 
 
  --
  
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or
  send a message to [EMAIL PROTECTED] with 'unsubscribe'
  in
  the body.
  
 
 
 
  
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or
  send a message to [EMAIL PROTECTED] with 'unsubscribe'
  in
  the body.
 
 
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or send a message to [EMAIL PROTECTED] with
  'unsubscribe' in the body.
 

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

Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

To a certain extent that is true.  However, by setting the appropriate MIME
type for the document you can force the browser to "save" it rather than
rendering it.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:12
Subject: RE: Problem with CFFTP


 I thought CFContent basically allows the user to read non HTML files
 in
 their browser window (after all the browser is just a container).  I
 don't
 want to open the file in their browser, just let them save it to their
 hard
 drive and open it up in word (it's a word doc)

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:05
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 CFCONTENT causes CF to read a file from the web server and "push" it
 to
 the client via the browser.  CFFILE lets you move files around on the
 web
 server, including creating, renaming, copying and deleting.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:02
 Subject: RE: Problem with CFFTP


  Oh okbut I still don;t see/understand how you move files from the
  web
  server to the client using cffile/cfcontent.  I would have thought
 cfftp
  would have done this by the nature of it's name!  Anyone show me what
 to
  do?!
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 13:56
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  They already have the ability to specify where it is saved.  That is
  completely a client function.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 12:52
  Subject: RE: Problem with CFFTP
 
 
   Oh.
  
   How do I do that?  What I am trying to do is let the user download a
   specific file from the web server to there Hard drive but I want to
  let
   them
   choose where to save it.  Have you got any code that will do this?
  
   -Original Message-
   From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:28
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   Yeah,  You can't use CFFTP to move files between the cfserver and
   browser.
   Only between the FTP server and CF server.  You have to use CFFILE
 and
   CFCONTENT to upload and download from the browser to the server and
  then
   from the server to the FTP server and vice versa.
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: "CFTalk (E-mail)" [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 5:56 AM
   Subject: Problem with CFFTP
  
  
I have a problem with CFFTP.  I am trying to use CFFTP to download
 a
   file
onto a user hard drive.  When the user clicks a button the web
 site
   creates
a file using CFFILE and then tries to download it to C:\temp using
   CFFTP.
However all it is doing is saving it to C:\Temp on the web server!
   Here
   is
my code
   
cfftp action="open" username="username" password="password"
server="servername" connection="temp" stoponerror="no"
cfoutput
Open Error Code: #cfftp.errorcode#
Open Error Text: #cfftp.errortext#
/cfoutput
   
cfftp connection="temp" action="GETFILE"
  localfile="c:\temp\test.doc"
remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
failifexists="No" stoponerror="No"
Download Error Code: #cfftp.errorcode#br
Download Error Text: #cfftp.errortext#br
/cfoutput
cfftp action="CLOSE" connection="cv"
   
Both FTP operations succeed.  Anyone have any ideas?
   
   
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
   
   
  
 
 
   --
   
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
  
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
   or
   send a message to [EMAIL PROTECTED] with
 'unsubscribe'
   in
   the body.
   
  
  
 
 
   
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
  
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
   or
   send a message to [EMAIL PROTECTED] with
 'unsubscribe'
   in
   the body.
  
 
 
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
  
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
   or send a message to [EMAIL PROTECTED] with
   'unsubscribe' in the body.
  
 
 
 

Upgrading

2000-08-22 Thread Kevin Schmidt

This is a multi-part message in MIME format.

--=_NextPart_000_0038_01C00C18.A9C5B9F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Are there any known issues when ugrading to 4.5.1 and all the service =
packs on win 2000.

Thanks,

Kevin Schmidt
Internet Services Manager
Peterson, WIlliams  Bizer
Office: 734.995.5000
Mobile: 734.649.4843


--=_NextPart_000_0038_01C00C18.A9C5B9F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Are there any known issues when =
ugrading to 4.5.1=20
and all the service packs on win 2000./FONT/DIV
DIVBRFONT face=3DArial size=3D2Thanks,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20
ManagerBRPeterson, WIlliams amp; BizerBROffice: =
734.995.5000BRMobile:=20
734.649.4843BR/FONT/DIV/BODY/HTML

--=_NextPart_000_0038_01C00C18.A9C5B9F0--

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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

great...thanksI'll give it a go

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:14
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


To a certain extent that is true.  However, by setting the appropriate MIME
type for the document you can force the browser to "save" it rather than
rendering it.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:12
Subject: RE: Problem with CFFTP


 I thought CFContent basically allows the user to read non HTML files
 in
 their browser window (after all the browser is just a container).  I
 don't
 want to open the file in their browser, just let them save it to their
 hard
 drive and open it up in word (it's a word doc)

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:05
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 CFCONTENT causes CF to read a file from the web server and "push" it
 to
 the client via the browser.  CFFILE lets you move files around on the
 web
 server, including creating, renaming, copying and deleting.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:02
 Subject: RE: Problem with CFFTP


  Oh okbut I still don;t see/understand how you move files from the
  web
  server to the client using cffile/cfcontent.  I would have thought
 cfftp
  would have done this by the nature of it's name!  Anyone show me what
 to
  do?!
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 13:56
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  They already have the ability to specify where it is saved.  That is
  completely a client function.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 12:52
  Subject: RE: Problem with CFFTP
 
 
   Oh.
  
   How do I do that?  What I am trying to do is let the user download a
   specific file from the web server to there Hard drive but I want to
  let
   them
   choose where to save it.  Have you got any code that will do this?
  
   -Original Message-
   From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:28
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   Yeah,  You can't use CFFTP to move files between the cfserver and
   browser.
   Only between the FTP server and CF server.  You have to use CFFILE
 and
   CFCONTENT to upload and download from the browser to the server and
  then
   from the server to the FTP server and vice versa.
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: "CFTalk (E-mail)" [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 5:56 AM
   Subject: Problem with CFFTP
  
  
I have a problem with CFFTP.  I am trying to use CFFTP to download
 a
   file
onto a user hard drive.  When the user clicks a button the web
 site
   creates
a file using CFFILE and then tries to download it to C:\temp using
   CFFTP.
However all it is doing is saving it to C:\Temp on the web server!
   Here
   is
my code
   
cfftp action="open" username="username" password="password"
server="servername" connection="temp" stoponerror="no"
cfoutput
Open Error Code: #cfftp.errorcode#
Open Error Text: #cfftp.errortext#
/cfoutput
   
cfftp connection="temp" action="GETFILE"
  localfile="c:\temp\test.doc"
remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
failifexists="No" stoponerror="No"
Download Error Code: #cfftp.errorcode#br
Download Error Text: #cfftp.errortext#br
/cfoutput
cfftp action="CLOSE" connection="cv"
   
Both FTP operations succeed.  Anyone have any ideas?
   
   
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--
   
   
  
 
 
   --
   
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
  
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
   or
   send a message to [EMAIL PROTECTED] with
 'unsubscribe'
   in
   the body.
   
  
  
 
 
   
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
  
 
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
   or
   send a message to [EMAIL PROTECTED] with
 'unsubscribe'
   in
   the body.
  
 
 
   --
   Archives: 

Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes takes
heroic efforts to overcome the M$ natural tendency to display the document
in the browser, as opposed to force a download.

DC

- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:14
Subject: Re: Problem with CFFTP


 To a certain extent that is true.  However, by setting the appropriate
 MIME
 type for the document you can force the browser to "save" it rather than
 rendering it.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:12
 Subject: RE: Problem with CFFTP


  I thought CFContent basically allows the user to read non HTML files
  in
  their browser window (after all the browser is just a container).  I
  don't
  want to open the file in their browser, just let them save it to their
  hard
  drive and open it up in word (it's a word doc)
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:05
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  CFCONTENT causes CF to read a file from the web server and "push" it
  to
  the client via the browser.  CFFILE lets you move files around on
 the
  web
  server, including creating, renaming, copying and deleting.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:02
  Subject: RE: Problem with CFFTP
 
 
   Oh okbut I still don;t see/understand how you move files from
 the
   web
   server to the client using cffile/cfcontent.  I would have thought
  cfftp
   would have done this by the nature of it's name!  Anyone show me
 what
  to
   do?!
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 13:56
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   They already have the ability to specify where it is saved.  That is
   completely a client function.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 12:52
   Subject: RE: Problem with CFFTP
  
  
Oh.
   
How do I do that?  What I am trying to do is let the user download
 a
specific file from the web server to there Hard drive but I want
 to
   let
them
choose where to save it.  Have you got any code that will do this?
   
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:28
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
Yeah,  You can't use CFFTP to move files between the cfserver and
browser.
Only between the FTP server and CF server.  You have to use CFFILE
  and
CFCONTENT to upload and download from the browser to the server
 and
   then
from the server to the FTP server and vice versa.
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 5:56 AM
Subject: Problem with CFFTP
   
   
 I have a problem with CFFTP.  I am trying to use CFFTP to
 download
  a
file
 onto a user hard drive.  When the user clicks a button the web
  site
creates
 a file using CFFILE and then tries to download it to C:\temp
 using
CFFTP.
 However all it is doing is saving it to C:\Temp on the web
 server!
Here
is
 my code

 cfftp action="open" username="username" password="password"
 server="servername" connection="temp" stoponerror="no"
 cfoutput
 Open Error Code: #cfftp.errorcode#
 Open Error Text: #cfftp.errortext#
 /cfoutput

 cfftp connection="temp" action="GETFILE"
   localfile="c:\temp\test.doc"
 remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
 failifexists="No" stoponerror="No"
 Download Error Code: #cfftp.errorcode#br
 Download Error Text: #cfftp.errortext#br
 /cfoutput
 cfftp action="CLOSE" connection="cv"

 Both FTP operations succeed.  Anyone have any ideas?



 --
 Andrew Ewings
 Project Manager
 Thoughtbubble Ltd

 --


   
  
 
 
--

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

   
   
  
 
 

--
Archives: 

RE: CFTREE's CompletePath Parameter

2000-08-22 Thread Michael O Reilly

Anthony,
I tried to contact you off list re: CFTree and the Vote button you
mentioned, but posts to [EMAIL PROTECTED] are being bounced.
Check out the vote button on our home page( www.wow.ie ), it does just this.
email me off list for the details.

Are you talking about the link to the Golden Spider awards or a different
vote button?

I have recently had the misfortune to work with this applet and found a few
problems with it so I had to dump it and get a third party applet to do the
same thing.
I believe the completepath parameter just specifies the applet to include
the parent folders in the path variable.  I think this path variable is
included as a parameter in the URL when a link is included on the treeitem
and the link is clicked.
I'm not sure as I said I tossed it because of table related issues.

I have also been looking around for a replacment Java TreeView applet, but
nove seem to do exactly what I want.
Most don't seem to accept all the data as Params, instead they open a text
file which isn't very elegent and a long way from being dynamic. What Applet
do you use now?


Excellent site BTW.
How many Graphic Designers/Programmers are involved in your site if you
don't mind me asking?

Regards
Michael O'Reilly
TransAer


-Original Message-
From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 2:03 PM
To: '[EMAIL PROTECTED]'
Subject: RE: CFTREE's CompletePath Parameter


Hi Michael,

You wrote:
|What the f*** does this mean in plain english?
|
|The examples don't show what this does, and with debugging 
|info on, there
|doesn't seem to be any difference between specifying Yes or No.

I have recently had the misfortune to work with this applet and found a few
problems with it so I had to dump it and get a third party applet to do the
same thing.
I believe the completepath parameter just specifies the applet to include
the parent folders in the path variable.  I think this path variable is
included as a parameter in the URL when a link is included on the treeitem
and the link is clicked.
I'm not sure as I said I tossed it because of table related issues.

Hope this helps.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.


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



Re: Caching pages

2000-08-22 Thread Gena

If browser "see" different url - it download this page from server, not from
cash

Regards,
Gennadi

- Original Message -
From: Gilles Ratte [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 10:46 PM
Subject: RE: Caching pages


Can you explain a little further...
I don't see how you do this with a random refresh

thanx

 -Message d'origine-
 De: Gena [SMTP:[EMAIL PROTECTED]]
 Date: Tuesday, August 22, 2000 5:24 AM
 À: [EMAIL PROTECTED]
 Objet: Re: Caching pages

  Is there a way to keep browsers from caching a page?

 Yes

  I have a CF page that does a calculation, and if the person hits the
 back
  button and goes back to the page the data is not updated.

 Like this:

 cfset a= random()

 MyFile.cfm?refresh=#a#


 Cheers

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

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.


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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

Ok, I tried it and unfortunately it loaded it into the browser as a word
document.  Any ideas as to the direction I need to point my heroic efforts
in order to prompt the user to download the file?!

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:18
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes takes
heroic efforts to overcome the M$ natural tendency to display the document
in the browser, as opposed to force a download.

DC

- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:14
Subject: Re: Problem with CFFTP


 To a certain extent that is true.  However, by setting the appropriate
 MIME
 type for the document you can force the browser to "save" it rather than
 rendering it.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:12
 Subject: RE: Problem with CFFTP


  I thought CFContent basically allows the user to read non HTML files
  in
  their browser window (after all the browser is just a container).  I
  don't
  want to open the file in their browser, just let them save it to their
  hard
  drive and open it up in word (it's a word doc)
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:05
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  CFCONTENT causes CF to read a file from the web server and "push" it
  to
  the client via the browser.  CFFILE lets you move files around on
 the
  web
  server, including creating, renaming, copying and deleting.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:02
  Subject: RE: Problem with CFFTP
 
 
   Oh okbut I still don;t see/understand how you move files from
 the
   web
   server to the client using cffile/cfcontent.  I would have thought
  cfftp
   would have done this by the nature of it's name!  Anyone show me
 what
  to
   do?!
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 13:56
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   They already have the ability to specify where it is saved.  That is
   completely a client function.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 12:52
   Subject: RE: Problem with CFFTP
  
  
Oh.
   
How do I do that?  What I am trying to do is let the user download
 a
specific file from the web server to there Hard drive but I want
 to
   let
them
choose where to save it.  Have you got any code that will do this?
   
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:28
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
Yeah,  You can't use CFFTP to move files between the cfserver and
browser.
Only between the FTP server and CF server.  You have to use CFFILE
  and
CFCONTENT to upload and download from the browser to the server
 and
   then
from the server to the FTP server and vice versa.
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 5:56 AM
Subject: Problem with CFFTP
   
   
 I have a problem with CFFTP.  I am trying to use CFFTP to
 download
  a
file
 onto a user hard drive.  When the user clicks a button the web
  site
creates
 a file using CFFILE and then tries to download it to C:\temp
 using
CFFTP.
 However all it is doing is saving it to C:\Temp on the web
 server!
Here
is
 my code

 cfftp action="open" username="username" password="password"
 server="servername" connection="temp" stoponerror="no"
 cfoutput
 Open Error Code: #cfftp.errorcode#
 Open Error Text: #cfftp.errortext#
 /cfoutput

 cfftp connection="temp" action="GETFILE"
   localfile="c:\temp\test.doc"
 remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
 failifexists="No" stoponerror="No"
 Download Error Code: #cfftp.errorcode#br
 Download Error Text: #cfftp.errortext#br
 /cfoutput
 cfftp action="CLOSE" connection="cv"

 Both FTP operations succeed.  Anyone have any ideas?



 --
 Andrew Ewings
 Project Manager
 Thoughtbubble Ltd

 --


   
  
 
 
--

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 

Hidden Variables

2000-08-22 Thread paul smith

Good Morning List!

Is it expected behavior for Hidden Vars
to be truncated at the first space?

best,  paul

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



(OT)SQL Operator

2000-08-22 Thread Tim Bahlke

Hey all ...

I have been going through the SQL 7 CBT and just finished operators.  With
regards to comparison operators ... != 'is not equal to', and  'is not
equal too'.

I do not understand  'not equal too'.

Can someone please explain this to me in more detail and possible provide an
example?

Thanks


Tim Bahlke, CIFO
Graphica
p. 230-0570
f. 230-0083



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



Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

Try MIMETYPE="unknown" and see if that works.  Unfortunately IE has a
tendency to read the file extension and use the MIMETYP associated with the
file extension instead of the MIMETYPE in the HTTP header.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:30
Subject: RE: Problem with CFFTP


 Ok, I tried it and unfortunately it loaded it into the browser as a word
 document.  Any ideas as to the direction I need to point my heroic
 efforts
 in order to prompt the user to download the file?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:18
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes
 takes
 heroic efforts to overcome the M$ natural tendency to display the
 document
 in the browser, as opposed to force a download.

 DC

 - Original Message -
 From: "David E. Crawford" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:14
 Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather
 than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML
 files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to
 their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push"
 it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That
 is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user
 download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do
 this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver
 and
 browser.
 Only between the FTP server and CF server.  You have to use
 CFFILE
   and
 CFCONTENT to upload and download from the browser to the server
  and
then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to
  download
   a
 file
  onto a user hard drive.  When the user clicks a button the web
   site
 creates
  a file using CFFILE and then tries to download it to C:\temp
  using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web
  server!
 Here
 is
  my code
 
  cfftp action="open" username="username"
 password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE"
localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: 

Re: Hidden Variables

2000-08-22 Thread David E. Crawford

Yes, if they are not surrounded by quotes.

Ie.

cfset myvar="This is a test"

input type="hidden" value=#myvar#  will be truncated

while

input type="hidden" value="#myvar#" will not be truncated.



DC

- Original Message - 
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:31
Subject: Hidden Variables


 Good Morning List!
 
 Is it expected behavior for Hidden Vars
 to be truncated at the first space?
 
 best,  paul
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
 or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.
 

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



RE: (OT)SQL Operator

2000-08-22 Thread Andy Ewings

They are essentially the same.  The only difference is that  is SQL-92
standard wheras != is not.

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:41
To: [EMAIL PROTECTED]
Subject: (OT)SQL Operator 


Hey all ...

I have been going through the SQL 7 CBT and just finished operators.  With
regards to comparison operators ... != 'is not equal to', and  'is not
equal too'.

I do not understand  'not equal too'.

Can someone please explain this to me in more detail and possible provide an
example?

Thanks


Tim Bahlke, CIFO
Graphica
p. 230-0570
f. 230-0083




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



RE: Problem with CFFTP

2000-08-22 Thread Jay Wigginton

I would try using cfcontent type="application/unknown" file="filename"

 -Original Message-
 From: Andy Ewings [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:30 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Problem with CFFTP


 Ok, I tried it and unfortunately it loaded it into the browser as a word
 document.  Any ideas as to the direction I need to point my heroic efforts
 in order to prompt the user to download the file?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:18
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Keep in mind that with IE and MS-Word, Powerpoint, Excel, it
 sometimes takes
 heroic efforts to overcome the M$ natural tendency to display the document
 in the browser, as opposed to force a download.

 DC

 - Original Message -
 From: "David E. Crawford" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:14
 Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push" it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 browser.
 Only between the FTP server and CF server.  You have to use CFFILE
   and
 CFCONTENT to upload and download from the browser to the server
  and
then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to
  download
   a
 file
  onto a user hard drive.  When the user clicks a button the web
   site
 creates
  a file using CFFILE and then tries to download it to C:\temp
  using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web
  server!
 Here
 is
  my code
 
  cfftp action="open" username="username" password="password"
  server="servername" connection="temp" stoponerror="no"
  cfoutput
  Open Error Code: #cfftp.errorcode#
  Open Error Text: #cfftp.errortext#
  /cfoutput
 
  cfftp connection="temp" action="GETFILE"
localfile="c:\temp\test.doc"
  remotefile="#thisdirectory#TestFile.htm" transfermode="BINARY"
  failifexists="No" stoponerror="No"
  Download Error Code: #cfftp.errorcode#br
  Download Error Text: #cfftp.errortext#br
  /cfoutput
  cfftp action="CLOSE" connection="cv"
 
  Both FTP operations succeed.  Anyone have any 

RE: Hidden Variables

2000-08-22 Thread Jay Wigginton

use the CF function URLEncodedFormat(string) in the value of the hidden tag

 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:32 AM
 To: [EMAIL PROTECTED]
 Subject: Hidden Variables


 Good Morning List!

 Is it expected behavior for Hidden Vars
 to be truncated at the first space?

 best,  paul

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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



CFHTTP Question

2000-08-22 Thread Frank Mamone

I need to login to a supplier page to retrieve parts information using
CFHHTP. The problem is it uses Cookies for login.

Has anyone come across this and found a way to do it?

Frank Mamone

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



RE: Fuzzy Logic Searches in SQL

2000-08-22 Thread Jeremy Allen

There is something called SOUNDEX searches in SQL also which
in theory return phonetical spellings of words.

Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 21, 2000 5:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Fuzzy Logic Searches in SQL


CONTAINS Predicate is exactly what you are looking for.

However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature
full-text searching/indexing was added. In which I think CONTAIN relies on?

Any hope of upgrading to 7.0? Or possibly using Verity search capability?

Bill
Willow Gold
http://www.willowgold.com

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

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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

ok.getting there.   It prompts the user whether to open or save file but
when you click on save file it gives you the name of the cfm file that is
being executed altough the content is correct.  Is there anyway of putting a
default name or file type in the 'save as' box.  The least I want them to do
is to be prompted to save the file as a .doc.  I'm not bothered about the
name of the file.

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:40
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Try MIMETYPE="unknown" and see if that works.  Unfortunately IE has a
tendency to read the file extension and use the MIMETYP associated with the
file extension instead of the MIMETYPE in the HTTP header.

DC

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:30
Subject: RE: Problem with CFFTP


 Ok, I tried it and unfortunately it loaded it into the browser as a word
 document.  Any ideas as to the direction I need to point my heroic
 efforts
 in order to prompt the user to download the file?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:18
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes
 takes
 heroic efforts to overcome the M$ natural tendency to display the
 document
 in the browser, as opposed to force a download.

 DC

 - Original Message -
 From: "David E. Crawford" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:14
 Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather
 than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML
 files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to
 their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push"
 it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That
 is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user
 download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do
 this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver
 and
 browser.
 Only between the FTP server and CF server.  You have to use
 CFFILE
   and
 CFCONTENT to upload and download from the browser to the server
  and
then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to
  download
   a
 file
  onto a user hard drive.  When the user clicks a button the web
   site
 creates
  a file using CFFILE and then tries to download it to C:\temp
  using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web
  server!
 

RE: (OT)SQL Operator

2000-08-22 Thread Jeremy Allen

They are the same thing, both opeartors test for inequality. :)

SELECT *
FROM Somplace
WHERE ThisField  10

SELECT *
FROM Somplace
WHERE ThisField != 10


Are the same thing.. :)
Just use the '' opeartor to be on the safe side.


Jeremy Allen
[EMAIL PROTECTED]

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 9:41 AM
To: [EMAIL PROTECTED]
Subject: (OT)SQL Operator 


Hey all ...

I have been going through the SQL 7 CBT and just finished operators.  With
regards to comparison operators ... != 'is not equal to', and  'is not
equal too'.

I do not understand  'not equal too'.

Can someone please explain this to me in more detail and possible provide an
example?

Thanks


Tim Bahlke, CIFO
Graphica
p. 230-0570
f. 230-0083




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

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



Re: AuthentiX CF cookies

2000-08-22 Thread Kevin Schmidt

NOt to knock CF but why not use ASP all around??
- Original Message -
From: "Robin Boudwin" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 8:41 AM
Subject: AuthentiX CF cookies


 I am developing a ColdFusion registration form that should insert the
 registration info into a database and create username and password cookies
 that get passed onto an asp page used with AuthentiX.  AuthentiX grants
 access to specific protected directories.

 If I use the asp page as my action in the CF registration form, it all
works
 fine, however, I still need to insert the data into the database.
 Currently, I have the action of the form posting to a cfm page with the
 insert action, that then attempts to route to the asp page.

 Since cflocation does not work with cookies and cfinclude requires a cfm
 page rather than an asp, I am at a loss.  I have also attempted to use a
 cfhttp page.

 Any ideas?  Thank you.



 --

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


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



RE: Fuzzy Logic Searches in SQL

2000-08-22 Thread Benjamin S. Rogers

We've sort of been looking for a reason to upgrade to SQL Server 7.0.

I've used Verity before. I did not know, however, that Verity took care of
stemming and sound matching. Good to know.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 21, 2000 5:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Fuzzy Logic Searches in SQL


CONTAINS Predicate is exactly what you are looking for.

However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature
full-text searching/indexing was added. In which I think CONTAIN relies on?

Any hope of upgrading to 7.0? Or possibly using Verity search capability?

Bill
Willow Gold
http://www.willowgold.com

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

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



RE: Help with custom tag

2000-08-22 Thread Carol Chandler

You're the only person who has taken a stab at this, so thank you very much!  

It is my understanding that caller.message and attributes.message point to the same 
thing, but that any modifications that refer to it as "attributes.message" will be 
strictly local to that invocation of the tag.  Is anyone willing to help with my 
understanding of caller vs. attribute, without necessarily getting too involved in the 
headache-y recursion? *grin*

Thanks,
Carol

 [EMAIL PROTECTED] 08/21/00 04:53PM 
Hi, Carol.

Perhaps your recursive invocation of cf_output_unknown needs to pass
caller.message as the message= argument rather than the attributes.message.
I may be getting wrapped around the recursion here, but it seems to me that
within a given invocation of cf_output_unknown you modify caller.message
with by appending the value of the argument test_object (or an element of
it) to the value of the message argument. But then you pass the unmodified
attributes.message to the next level of recursion. (Of course, if in the
final analysis the caller and attributes scopes actually point to the same
value because of the recursion then this advice doesn't mean much.)

HTH,
  -- Tim Dempsey


-Original Message-
From: Carol Chandler [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 21, 2000 4:48 PM
To: [EMAIL PROTECTED] 
Subject: Help with custom tag


Hi list,  

I'm working on my very first custom tag.  I was writing a specific routine
to collect the contents of the CFCATCH structure when it occurred to me that
a more general solution might be useful.  So, what this tag is intended to
do is to take a variable - simple, array, or structure, or any combination
(array of structures of arrays, etc.) - and append all of the component
names and values into one string.  What I have here does correctly traverse
and output a nest of structures/arrays, but I can't seem to collect it all
into one variable.  There must be more to "caller.variable" than meets the
eye.  What happens in the calling page is that "message" has the name of the
last component of the outer structure.

Can anyone tell me what I am missing?  Thanks very much.  (And I hope the
recursion doesn't give anyone a headache!)

!--- CF_output_unknown [input] test_object [output] message  -

cfif IsDefined("attributes.test_object") IS "No"
cfset #caller.message# = ""
cfelseif #IsSimpleValue(attributes.test_object)#
cfoutput#attributes.test_object#/cfoutput 
cfset #caller.message# = #attributes.message# 
#attributes.test_object#
cfelseif #IsStruct(attributes.test_object)#
CFLOOP COLLECTION=#attributes.test_object# item="struct"
cfset #caller.message# = #attributes.message#  #struct# 
" = "
cfoutputBR#struct# = /cfoutput 
CF_output_unknown
test_object=#attributes.test_object[struct]# message=#attributes.message#
/CFLOOP
cfelseif #IsArray(attributes.test_object)#
CFLOOP index=i from=1 to= #arrayLen(attributes.test_object)#
CF_output_unknown test_object=#attributes.test_object[i]#
message= #attributes.message#
/cfloop
cfelse
Cfset #caller.message# = #attributes.message#  "Unable to proceed
with CF_output_unknown."
/cfif



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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: arraysort

2000-08-22 Thread Philip Arnold - ASP

   Can any one guide me thru the process of Double dimesion array sorting

2 methods that I can think of;
Write your own sort routine for multi-dimentional arrays (I use a bubble
sort, but there are better ways)
Convert the array into a Query (using Nate's ArrayToQuery command), and then
using the QuerySort custom tag and treat it as a Query from then on (or
convert it back to an array)

The standard array function don't do much, as a 2 dimensional array is just
a list of one dimensional array in every entry of the main array

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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem with CFFTP

2000-08-22 Thread Moneymaker, Jon S.

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_01C00C44.1E5D7688
Content-Type: text/plain;
charset="iso-8859-1"

Users can simply right click on the "link" and select the option: "save
target as..." and it will bring up the save dialog box and give them the
option to save it on their systemI use this on our intranet and it works
just fine.

It requires some user education (always a perilous and onerous
undertaking)but that, coupled with a rather large font size: Right Click
to Download

seems to work for us!!

Jon
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 9:30 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Problem with CFFTP


Ok, I tried it and unfortunately it loaded it into the browser as a word
document.  Any ideas as to the direction I need to point my heroic efforts
in order to prompt the user to download the file?!

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:18
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes takes
heroic efforts to overcome the M$ natural tendency to display the document
in the browser, as opposed to force a download.

DC

- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:14
Subject: Re: Problem with CFFTP


 To a certain extent that is true.  However, by setting the appropriate
 MIME
 type for the document you can force the browser to "save" it rather than
 rendering it.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:12
 Subject: RE: Problem with CFFTP


  I thought CFContent basically allows the user to read non HTML files
  in
  their browser window (after all the browser is just a container).  I
  don't
  want to open the file in their browser, just let them save it to their
  hard
  drive and open it up in word (it's a word doc)
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:05
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  CFCONTENT causes CF to read a file from the web server and "push" it
  to
  the client via the browser.  CFFILE lets you move files around on
 the
  web
  server, including creating, renaming, copying and deleting.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:02
  Subject: RE: Problem with CFFTP
 
 
   Oh okbut I still don;t see/understand how you move files from
 the
   web
   server to the client using cffile/cfcontent.  I would have thought
  cfftp
   would have done this by the nature of it's name!  Anyone show me
 what
  to
   do?!
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 13:56
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   They already have the ability to specify where it is saved.  That is
   completely a client function.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 12:52
   Subject: RE: Problem with CFFTP
  
  
Oh.
   
How do I do that?  What I am trying to do is let the user download
 a
specific file from the web server to there Hard drive but I want
 to
   let
them
choose where to save it.  Have you got any code that will do this?
   
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:28
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
Yeah,  You can't use CFFTP to move files between the cfserver and
browser.
Only between the FTP server and CF server.  You have to use CFFILE
  and
CFCONTENT to upload and download from the browser to the server
 and
   then
from the server to the FTP server and vice versa.
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CFTalk (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 5:56 AM
Subject: Problem with CFFTP
   
   
 I have a problem with CFFTP.  I am trying to use CFFTP to
 download
  a
file
 onto a user hard drive.  When the user clicks a button the web
  site
creates
 a file using CFFILE and then tries to download it to C:\temp
 using
CFFTP.
 However all it is doing is saving it to C:\Temp on the web
 server!
Here
is
 my code

 cfftp action="open" username="username" password="password"
 server="servername" connection="temp" stoponerror="no"
 cfoutput
 Open Error Code: #cfftp.errorcode#
 Open Error Text: #cfftp.errortext#

CFQUERY, using two different DBs question - Newbie ;)

2000-08-22 Thread Mike Deane

cfquery name="Insert" DATASOURCE="AClient" username="sa" password=""
INSERT Customer_Kit
SELECT *
FROM dbo.ProdCenter.Task
WHERE 1 = 1
AND Task.Task_ID IN (#PreserveSingleQuotes(Form.Task_Selected)#);
/cfquery


I am trying to move some data from one DB,table (ProdCenter,Task)
FROM dbo.ProdCenter.Task into another DB,table (AClient,
Customer_Kit).

How do I accomplish this feat?  For instance, how do I provide a second
DATASOURE to access the second DB?



Thank you.
/mdeane
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem with CFFTP

2000-08-22 Thread Joel Richards

You can also use the cfheader tag:

CFHEADER NAME="Content-Disposition" value="attachment; 
filename=#form.FileName#"

At 08:20 AM 8/22/00, you wrote:
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_01C00C44.1E5D7688
Content-Type: text/plain;
 charset="iso-8859-1"

Users can simply right click on the "link" and select the option: "save
target as..." and it will bring up the save dialog box and give them the
option to save it on their systemI use this on our intranet and it works
just fine.

It requires some user education (always a perilous and onerous
undertaking)but that, coupled with a rather large font size: Right Click
to Download

seems to work for us!!

Jon
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 9:30 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Problem with CFFTP


Ok, I tried it and unfortunately it loaded it into the browser as a word
document.  Any ideas as to the direction I need to point my heroic efforts
in order to prompt the user to download the file?!

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:18
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes takes
heroic efforts to overcome the M$ natural tendency to display the document
in the browser, as opposed to force a download.

DC

- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:14
Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push" it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 browser.
 Only between the FTP server and CF server.  You have to use CFFILE
   and
 CFCONTENT to upload and download from the browser to the server
  and
then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to
  download
   a
 file
  onto a user hard drive.  When the user clicks a button the web
   site
 creates
  a file using CFFILE and then tries to download it to C:\temp
  using
 CFFTP.
  However all it is doing is saving it to C:\Temp on the web

RE: Problem with CFFTP

2000-08-22 Thread Adam Cantrell


So how do you maintain directory security?  I know you could only display
the files you want that particular user to beable to download, but what's
stopping them from guessing other filenames in their browser to see if they
can get anybody elses files?  I have resorted to pulling the files out from
behind the wwwroot using cffile and putting them into a temp directory for
the user to download - and then when they log out, I delete them from the
temp directory(pretty lame, I know).  I wish the cfcontent tag worked
correctly, I could pull files from behind the wwwroot and maintain security
by never making the files publicly accessable.  Anyways, do you have any
directory security in place?

 -Original Message-
 From: Moneymaker, Jon S. [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:20 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Problem with CFFTP


 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_01C00C44.1E5D7688
 Content-Type: text/plain;
   charset="iso-8859-1"

 Users can simply right click on the "link" and select the option: "save
 target as..." and it will bring up the save dialog box and give them the
 option to save it on their systemI use this on our intranet
 and it works
 just fine.

 It requires some user education (always a perilous and onerous
 undertaking)but that, coupled with a rather large font size:
 Right Click
 to Download

 seems to work for us!!

 Jon
 -Original Message-
 From: Andy Ewings [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:30 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Problem with CFFTP


 Ok, I tried it and unfortunately it loaded it into the browser as a word
 document.  Any ideas as to the direction I need to point my heroic efforts
 in order to prompt the user to download the file?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:18
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Keep in mind that with IE and MS-Word, Powerpoint, Excel, it
 sometimes takes
 heroic efforts to overcome the M$ natural tendency to display the document
 in the browser, as opposed to force a download.

 DC

 - Original Message -
 From: "David E. Crawford" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:14
 Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push" it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 

Advanced Security set-up

2000-08-22 Thread Ashley Hart

Does anyone know where I have to go to install the Advanced Security in
the Administrator?  Do I have to re-install Cold Fusion Studio or the
Server?  I went into the Server to re-install, but it only gives me an
option for selecting on the server Microsoft IIS, Peer Web Server, or
Personal Web Server?  I thought this is where I was to go to select
Advanced Security? Thanks.

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



RE: Fuzzy Logic Searches in SQL

2000-08-22 Thread Dick Applebaum

The SOUNDEX function returns a 4-character Phonetic code.  It is 
primarily used to compensate for spelling differences in last names:

   Smith
   Schmidt
   Smythe

all generate the same code, S630, as I recall.

It will not resolve differences in the first character:

Ffiefer
Pfiefer

This is a very old technology (predates computers) that was developed 
for the government.  I temember an old IBM SOUNDEX manual that was a 
reprint of a government manual.  It was available in the '60s for 
development oh Police Information systems and the like.

I did a sherlock search and found:

   http://www.cimorelli.com/pie/faq/pfaq_a15.htm

HYH

Dick

At 9:48 AM -0400 8/22/00, Jeremy Allen wrote:
There is something called SOUNDEX searches in SQL also which
in theory return phonetical spellings of words.

Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 21, 2000 5:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Fuzzy Logic Searches in SQL


CONTAINS Predicate is exactly what you are looking for.

However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new feature
full-text searching/indexing was added. In which I think CONTAIN relies on?

Any hope of upgrading to 7.0? Or possibly using Verity search capability?

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



RE: CFQUERY, using two different DBs question - Newbie ;)

2000-08-22 Thread Andy Ewings

Is this SQL?  If so the datasource is not database dependent (although you
should specify a default database when setting up the odbc datasource).  It
is only server dependent.

Therefore, assuming that AClient is the default database for the ODBC DSN
then I think you need the following:

INSERT INTO Customer_Kit
SELECT * 
FROM ProdCenter.dbo.Task
WHERE 1=1
AND Task.Task_ID IN (#PreserveSingleQuotes(Form.Task_Selected)#)

where ProdCenter is the other database and task is the table within this
database



-Original Message-
From: Mike Deane [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 15:20
To: '[EMAIL PROTECTED]'
Subject: CFQUERY, using two different DBs question - Newbie ;)


cfquery name="Insert" DATASOURCE="AClient" username="sa" password=""
INSERT Customer_Kit
SELECT *
FROM dbo.ProdCenter.Task
WHERE 1 = 1
AND Task.Task_ID IN (#PreserveSingleQuotes(Form.Task_Selected)#);
/cfquery


I am trying to move some data from one DB,table (ProdCenter,Task)
FROM dbo.ProdCenter.Task into another DB,table (AClient,
Customer_Kit).

How do I accomplish this feat?  For instance, how do I provide a second
DATASOURE to access the second DB?



Thank you.
/mdeane

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



Re: Hidden Variables

2000-08-22 Thread paul smith

Of course!  Thanks!!!

best,  paul

At 01:40 PM 8/22/00 +, you wrote:
Yes, if they are not surrounded by quotes.

Ie.

cfset myvar="This is a test"

input type="hidden" value=#myvar#  will be truncated

while

input type="hidden" value="#myvar#" will not be truncated.



DC

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:31
Subject: Hidden Variables


  Good Morning List!
 
  Is it expected behavior for Hidden Vars
  to be truncated at the first space?
 
  best,  paul
 
  
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
  or send a message to [EMAIL PROTECTED] with
  'unsubscribe' in the body.
 

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

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



Re: Problem with CFFTP

2000-08-22 Thread David E. Crawford

What do you mean by "cfcontent worked correctly"?  CFCONTENT allows you to
serve files from anywhere on the server that CF has access to.  The files do
not have to be in the web root.

DC

- Original Message -
From: "Adam Cantrell" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 14:37
Subject: RE: Problem with CFFTP



 So how do you maintain directory security?  I know you could only
 display
 the files you want that particular user to beable to download, but
 what's
 stopping them from guessing other filenames in their browser to see if
 they
 can get anybody elses files?  I have resorted to pulling the files out
 from
 behind the wwwroot using cffile and putting them into a temp directory
 for
 the user to download - and then when they log out, I delete them from
 the
 temp directory(pretty lame, I know).  I wish the cfcontent tag worked
 correctly, I could pull files from behind the wwwroot and maintain
 security
 by never making the files publicly accessable.  Anyways, do you have any
 directory security in place?

  -Original Message-
  From: Moneymaker, Jon S. [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, August 22, 2000 9:20 AM
  To: '[EMAIL PROTECTED]'
  Subject: RE: Problem with CFFTP
 
 
  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_01C00C44.1E5D7688
  Content-Type: text/plain;
  charset="iso-8859-1"
 
  Users can simply right click on the "link" and select the option:
 "save
  target as..." and it will bring up the save dialog box and give them
 the
  option to save it on their systemI use this on our intranet
  and it works
  just fine.
 
  It requires some user education (always a perilous and onerous
  undertaking)but that, coupled with a rather large font size:
  Right Click
  to Download
 
  seems to work for us!!
 
  Jon
  -Original Message-
  From: Andy Ewings [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, August 22, 2000 9:30 AM
  To: '[EMAIL PROTECTED]'
  Subject: RE: Problem with CFFTP
 
 
  Ok, I tried it and unfortunately it loaded it into the browser as a
 word
  document.  Any ideas as to the direction I need to point my heroic
 efforts
  in order to prompt the user to download the file?!
 
  -Original Message-
  From: David E. Crawford [mailto:[EMAIL PROTECTED]]
  Sent: 22 August 2000 14:18
  To: [EMAIL PROTECTED]
  Subject: Re: Problem with CFFTP
 
 
  Keep in mind that with IE and MS-Word, Powerpoint, Excel, it
  sometimes takes
  heroic efforts to overcome the M$ natural tendency to display the
 document
  in the browser, as opposed to force a download.
 
  DC
 
  - Original Message -
  From: "David E. Crawford" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:14
  Subject: Re: Problem with CFFTP
 
 
   To a certain extent that is true.  However, by setting the
 appropriate
   MIME
   type for the document you can force the browser to "save" it rather
 than
   rendering it.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:12
   Subject: RE: Problem with CFFTP
  
  
I thought CFContent basically allows the user to read non HTML
 files
in
their browser window (after all the browser is just a container).
 I
don't
want to open the file in their browser, just let them save it to
 their
hard
drive and open it up in word (it's a word doc)
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:05
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
CFCONTENT causes CF to read a file from the web server and
 "push" it
to
the client via the browser.  CFFILE lets you move files around
 on
   the
web
server, including creating, renaming, copying and deleting.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:02
Subject: RE: Problem with CFFTP
   
   
 Oh okbut I still don;t see/understand how you move files
 from
   the
 web
 server to the client using cffile/cfcontent.  I would have
 thought
cfftp
 would have done this by the nature of it's name!  Anyone show me
   what
to
 do?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 13:56
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 They already have the ability to specify where it is saved.
 That is
 completely a client function.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 12:52
 Subject: RE: Problem with CFFTP


  Oh.
 
  

RE: Fuzzy Logic Searches in SQL

2000-08-22 Thread Jeremy Allen

Ya, I read about it in a SQL book I have, the author provided a
SOUNDEX which would detect for the

"Ffiefer
 Pfiefer"

Cases, But it can still be useful for certain types of searches
so I figured I would toss it out there.

I actually read in a book Programming Pearls (really great)
About how the algorithms to generate unique signatures for
words (Like say in a dictionary).. Interesting stuff...

Does it suprise you taht the MS Implementation is more
or less not that great? :-P

Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]


-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:32 AM
To: [EMAIL PROTECTED]
Subject: RE: Fuzzy Logic Searches in SQL


The SOUNDEX function returns a 4-character Phonetic code.  It is
primarily used to compensate for spelling differences in last names:

   Smith
   Schmidt
   Smythe

all generate the same code, S630, as I recall.

It will not resolve differences in the first character:

Ffiefer
Pfiefer

This is a very old technology (predates computers) that was developed
for the government.  I temember an old IBM SOUNDEX manual that was a
reprint of a government manual.  It was available in the '60s for
development oh Police Information systems and the like.

I did a sherlock search and found:

   http://www.cimorelli.com/pie/faq/pfaq_a15.htm

HYH

Dick

At 9:48 AM -0400 8/22/00, Jeremy Allen wrote:
There is something called SOUNDEX searches in SQL also which
in theory return phonetical spellings of words.

Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 21, 2000 5:39 PM
To: [EMAIL PROTECTED]
Subject: Re: Fuzzy Logic Searches in SQL


CONTAINS Predicate is exactly what you are looking for.

However, I do not believe it is part of SQL 6.5. In MS-SQL 7.0 a new
feature
full-text searching/indexing was added. In which I think CONTAIN relies on?

Any hope of upgrading to 7.0? Or possibly using Verity search capability?


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

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



OT: Access 97 and 2000

2000-08-22 Thread Gene Kraybill

What does it take to run both Access 97 and Access 2000 on the same machine?

We have some small CF db's in Access 97. We have a development machine with 
Office 2000 and tried to install only the Access portion of Office 97 on the same 
machine.

When we try to start either version of Access, we now get this message:

"Microsoft Access can't start because there is no license for it on this machine."

Gene Kraybill


-
Gene Kraybill
LPW  Associates LLC
www.lpw.net
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem with CFFTP

2000-08-22 Thread Adam Cantrell

I'm sorry, I meant "worked correctly in my application", which it doesn't.
I didn't mean to be one of those "allaire sucks because I can't get this to
work" people.  I don't doubt it working in most peoples' cases.  It freezes
the browser and never times out (and this is on a 2k file).  I've put a lot
of time into getting this tag to work, and it never worked correctly for me.
w2k advanced server/IIS5/CF4.5-ENT/NTFS.  Browsers range from IE 5.0 - 5.5.

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:37 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 What do you mean by "cfcontent worked correctly"?  CFCONTENT allows you to
 serve files from anywhere on the server that CF has access to.
 The files do
 not have to be in the web root.

 DC

 - Original Message -
 From: "Adam Cantrell" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 14:37
 Subject: RE: Problem with CFFTP


 
  So how do you maintain directory security?  I know you could only
  display
  the files you want that particular user to beable to download, but
  what's
  stopping them from guessing other filenames in their browser to see if
  they
  can get anybody elses files?  I have resorted to pulling the files out
  from
  behind the wwwroot using cffile and putting them into a temp directory
  for
  the user to download - and then when they log out, I delete them from
  the
  temp directory(pretty lame, I know).  I wish the cfcontent tag worked
  correctly, I could pull files from behind the wwwroot and maintain
  security
  by never making the files publicly accessable.  Anyways, do you have any
  directory security in place?
 
   -Original Message-
   From: Moneymaker, Jon S. [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, August 22, 2000 9:20 AM
   To: '[EMAIL PROTECTED]'
   Subject: RE: Problem with CFFTP
  
  
   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_01C00C44.1E5D7688
   Content-Type: text/plain;
   charset="iso-8859-1"
  
   Users can simply right click on the "link" and select the option:
  "save
   target as..." and it will bring up the save dialog box and give them
  the
   option to save it on their systemI use this on our intranet
   and it works
   just fine.
  
   It requires some user education (always a perilous and onerous
   undertaking)but that, coupled with a rather large font size:
   Right Click
   to Download
  
   seems to work for us!!
  
   Jon
   -Original Message-
   From: Andy Ewings [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, August 22, 2000 9:30 AM
   To: '[EMAIL PROTECTED]'
   Subject: RE: Problem with CFFTP
  
  
   Ok, I tried it and unfortunately it loaded it into the browser as a
  word
   document.  Any ideas as to the direction I need to point my heroic
  efforts
   in order to prompt the user to download the file?!
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:18
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   Keep in mind that with IE and MS-Word, Powerpoint, Excel, it
   sometimes takes
   heroic efforts to overcome the M$ natural tendency to display the
  document
   in the browser, as opposed to force a download.
  
   DC
  
   - Original Message -
   From: "David E. Crawford" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:14
   Subject: Re: Problem with CFFTP
  
  
To a certain extent that is true.  However, by setting the
  appropriate
MIME
type for the document you can force the browser to "save" it rather
  than
rendering it.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:12
Subject: RE: Problem with CFFTP
   
   
 I thought CFContent basically allows the user to read non HTML
  files
 in
 their browser window (after all the browser is just a container).
  I
 don't
 want to open the file in their browser, just let them save it to
  their
 hard
 drive and open it up in word (it's a word doc)

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:05
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 CFCONTENT causes CF to read a file from the web server and
  "push" it
 to
 the client via the browser.  CFFILE lets you move files around
  on
the
 web
 server, including creating, renaming, copying and deleting.

 DC

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:02
 Subject: RE: Problem with CFFTP


  Oh okbut I still 

RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

The name of the file that that they are downloading from the server is
hardcoded in the cfm page (filename is dynamically built depending on a
client variable).  All I want them to be able to do is specify the location
to save it to on their hard drive, which should be taken care of
automaticaly by their browser, if I could just get the browser to save it
instead of displaying it!


-Original Message-
From: Adam Cantrell [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 15:38
To: [EMAIL PROTECTED]
Subject: RE: Problem with CFFTP



So how do you maintain directory security?  I know you could only display
the files you want that particular user to beable to download, but what's
stopping them from guessing other filenames in their browser to see if they
can get anybody elses files?  I have resorted to pulling the files out from
behind the wwwroot using cffile and putting them into a temp directory for
the user to download - and then when they log out, I delete them from the
temp directory(pretty lame, I know).  I wish the cfcontent tag worked
correctly, I could pull files from behind the wwwroot and maintain security
by never making the files publicly accessable.  Anyways, do you have any
directory security in place?

 -Original Message-
 From: Moneymaker, Jon S. [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:20 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Problem with CFFTP


 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_01C00C44.1E5D7688
 Content-Type: text/plain;
   charset="iso-8859-1"

 Users can simply right click on the "link" and select the option: "save
 target as..." and it will bring up the save dialog box and give them the
 option to save it on their systemI use this on our intranet
 and it works
 just fine.

 It requires some user education (always a perilous and onerous
 undertaking)but that, coupled with a rather large font size:
 Right Click
 to Download

 seems to work for us!!

 Jon
 -Original Message-
 From: Andy Ewings [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 9:30 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: Problem with CFFTP


 Ok, I tried it and unfortunately it loaded it into the browser as a word
 document.  Any ideas as to the direction I need to point my heroic efforts
 in order to prompt the user to download the file?!

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:18
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Keep in mind that with IE and MS-Word, Powerpoint, Excel, it
 sometimes takes
 heroic efforts to overcome the M$ natural tendency to display the document
 in the browser, as opposed to force a download.

 DC

 - Original Message -
 From: "David E. Crawford" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 13:14
 Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push" it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   

RE: Access 97 and 2000

2000-08-22 Thread Andy Ewings

A miracle

No really - I think you need to have them installed on a seperate drive, or
partition - but I'm not 100% sure

-Original Message-
From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 18:55
To: [EMAIL PROTECTED]
Subject: OT: Access 97 and 2000


What does it take to run both Access 97 and Access 2000 on the same machine?

We have some small CF db's in Access 97. We have a development machine with 
Office 2000 and tried to install only the Access portion of Office 97 on the
same 
machine.

When we try to start either version of Access, we now get this message:

"Microsoft Access can't start because there is no license for it on this
machine."

Gene Kraybill


-
Gene Kraybill
LPW  Associates LLC
www.lpw.net

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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Paul Johnston

Why not use the OnRequestEnd.cfm page (like application.cfm but at end of
request not start!) and test that this has run.

You can do this by putting an if statement to check which page has been
requested by the user, and assuming you have ID's and stuff of various
users, you can put in a database that they have received the page when this
page is hit.

You can not however without some kind of "I have read this" button, test
whether they have read it and there is no way you can check if they've
understood it ;)

Paul

 -Original Message-
 From: Michael O Reilly [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 09:42
 To: [EMAIL PROTECTED]
 Subject: Slightly OT - Detecting that a page has completed.


 Hi all,
 I have been given a problem which I'm not sure is solvable.
 We are to publish staff rosters on the Web and want to know if staff have
 been notified of/looked at their roster.
 I have said that although we can detect that the user has
 requested a page,
 it's impossible to know if the whole page arrived at the browser
 (people are
 connecting in from all over the world on some very dodgy telco systems so
 connection speeds can be assumed to be poor). Am I correct here.

 I know I could put a JS onload event into the body tag which
 submits some
 info back to the server. But can I put anything at the end of the
 page which
 would do the same.

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.



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



Re: Minimum Search Criteria

2000-08-22 Thread Mary_Baotic



I have never made it work with CFSELECT.  I always use a separate validation
routine that allows me to validate it the way its supposed to.
It would be nice if CFSELECT had a real validation routine that worked.
Mary


|+---
||  Eva Holtsmark|
||  evah@hskids-|
||  tmsc.org|
||   |
||  08/21/2000   |
||  01:26 PM |
||  Please   |
||  respond to   |
||  cf-talk  |
||   |
|+---
  |
  ||
  |   To: [EMAIL PROTECTED]|
  |   cc: (bcc: Mary Baotic)   |
  |   Subject: Re: Minimum Search Criteria |
  |





[EMAIL PROTECTED] wrote:

 Using CFFORM and its tags, you can make certain fields in the form "required".
 The "required" option works best for CFINPUT, it doesn't work well for
 CFSELECT

Tell me about it.  I'm trying, has anyone made it work?  want to know how...
Here is my *nonworking* code for a State/Province CFSELECT

TD
FONT FACE="arial,helvetica" COLOR="#A0"State / Province:/FONT
BRcfselect name="State" message="Please choose your State or Province."
required="Yes"
option/option
option  value="AL"AL/option
option  value="AK"AK/option
option  value="AZ"AZ/option
option  value="AR"AR/option
option  value="CA"CA/option
option  value="CO"CO/option
option  value="CT"CT/option
option  value="DC"DC/option
option  value="DE"DE/option
option  value="FL"FL/option
option  value="GA"GA/option
option  value="HI"HI/option
option  value="ID"ID/option
option  value="IL"IL/option
option  value="IN"IN/option
option  value="IA"IA/option
option  value="KS"KS/option
option  value="KY"KY/option
option  value="LA"LA/option
option  value="ME"ME/option
option  value="MD"MD/option
option  value="MA"MA/option
option  value="MI"MI/option
option  value="MN"MN/option
option  value="MS"MS/option
option  value="MO"MO/option
option  value="MT"MT/option
option  value="NE"NE/option
option  value="NV"NV/option
option  value="NH"NH/option
option  value="NJ"NJ/option
option  value="NM"NM/option
option  value="NY"NY/option
option  value="NC"NC/option
option  value="ND"ND/option
option  value="OH"OH/option
option  value="OK"OK/option
option  value="OR"OR/option
option  value="PA"PA/option
option  value="RI"RI/option
option  value="SC"SC/option
option  value="SD"SD/option
option  value="TN"TN/option
option  value="TX"TX/option
option  value="UT"UT/option
option  value="VT"VT/option
option  value="VA"VA/option
option  value="WA"WA/option
option  value="WV"WV/option
option  value="WI"WI/option
option  value="WY"WY/option
 option  value="--"--
option  value="AB"AB/option
option  value="BC"BC/option
option  value="MB"MB/option
option  value="NB"NB/option
option  value="NF"NF/option
option  value="NS"NS/option
option  value="NT"NT/option
option  value="ON"ON/option
option  value="PE"PE/option
option  value="PQ"PQ/option
option  value="SK"SK/option
option  value="YT"YT/option
/cfselect
INPUT TYPE="HIDDEN" NAME="State_required" VALUE="Please choose your State or
Province."
/TD
__

Do you know the answer?
___

Eva


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



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 

RE: CFTRANSACTION

2000-08-22 Thread Andy Ewings

UhI haven't seen this before?  What does the 3D do before the Name and
Datasource Value?
Also when you do the insert why have you got INSERT INTO tablename = 20.
As far as I'm aware this isn't any kind of SQL syntax although I could be
wrong!  personally I would have done:

CFTRANSACTION

CFQUERY NAME="insert new employee" datasource="Wherewolf"
INSERT INTO empolyee_data
Values (#form.user_id#, #form.given_name#, #form.family_name#,
#form.position#, #form.supervisor#, #form.ext_number#, #form.ah_contact#,
#form.memo#, #form.status#, #form.return#, #form.comment#)
/cfquery

CFQUERY NAME=3D"insert in_out" datasource=3D"wherewolf"
Insert Into in_out
Values (#form.user_id#, #form.given_name#, #form.family_name#,
#form.status#, #form.return#, #form.comment#)
/cfquery

/cftransaction

You must insure that you are inserting into ALL of the fields in the tables
if you are not specifying a field list before the values


-Original Message-
From: Luke Kearney [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 15:49
To: [EMAIL PROTECTED]
Subject: CFTRANSACTION


This is a multi-part message in MIME format.

--=_NextPart_000_0009_01C00C93.8BCD5770
Content-Type: text/plain;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

Hello CF'ers

Can anyone see any problems with the syntax below. The form fields match =
as do the names of fields (including spelling errors ) in the DB but I =
get an error complaining of missing parameters. The goal is really to =
get data from one form on to two tables as part of a timecard app for an =
intranet project. DB is MS Access. Perhaps someone with fresher eyes wil =
spot my mistake immediately





CFTRANSACTION

CFQUERY NAME=3D"insert new employee" datasource=3D"Wherewolf"
INSERT INTO empolyee_data=20
Values (#form.user_id#, #form.given_name#, #form.family_name#, =
#form.position#, #form.supervisor#, #form.ext_number#, =
#form.ah_contact#, #form.memo#, #form.status#, #form.return#, =
#form.comment# )
/cfquery

CFQUERY NAME=3D"insert in_out" datasource=3D"wherewolf"
Insert Into in_out=20
Values (#form.user_id#, #form.given_name#, #form.family_name#, =
#form.status#, #form.return#, #form.comment# )
/cfquery

/cftransaction
***

ODBC Error Code =3D 07001 (Wrong number of parameters)=20


[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected =
8.

***

Luke Kearney


--=_NextPart_000_0009_01C00C93.8BCD5770
Content-Type: text/html;
charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-2022-jp" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3D"MS PMincho" size=3D2Hello CF'ers/FONT/DIV
DIVFONT face=3D"MS PMincho" size=3D2/FONTnbsp;/DIV
DIVFONT face=3D"MS PMincho" size=3D2Can anyone see any problems with =
the syntax=20
below. The form fields match as do the names of fields (including =
spelling=20
errors ) in the DB but I get an error complaining of missing parameters. =
The=20
goal is really to get data from one form on to two tables as part of a =
timecard=20
app for an intranet project. DB is MS Access. Perhaps someone with =
fresher eyes=20
wil spot my mistake immediately/FONT/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV
DIVFONT face=3D"MS PMincho" size=3D2/FONTnbsp;/DIV
DIVFONT face=3D"MS PMincho" =
size=3D2lt;CFTRANSACTIONgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3D"MS PMincho" size=3D2lt;CFQUERY NAME=3D"insert new =
employee"=20
datasource=3D"Wherewolf"gt;BRINSERT INTO empolyee_data BRValues=20
(#form.user_id#, #form.given_name#, #form.family_name#, #form.position#, =

#form.supervisor#, #form.ext_number#, #form.ah_contact#, #form.memo#,=20
#form.status#, #form.return#, #form.comment# =
)BRlt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3D"MS PMincho" size=3D2lt;CFQUERY NAME=3D"insert =
in_out"=20
datasource=3D"wherewolf"gt;BRInsert Into in_out BRValues =
(#form.user_id#,=20
#form.given_name#, #form.family_name#, #form.status#, #form.return#,=20
#form.comment# )BRlt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3D"MS PMincho" =
size=3D2lt;/cftransactiongt;/FONT/DIV
DIVFONT face=3D"MS PMincho" size=3D2
P***
PODBC Error Code =3D 07001 (Wrong number of parameters)=20
P
P[Microsoft][ODBC Microsoft Access Driver] Too few parameters. =
Expected=20
8./P/FONT/DIV
DIVFONT face=3D"MS PMincho"=20
size=3D2=
***/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3D"MS PMincho" size=3D2Luke =
KearneyBR/FONT/DIV/BODY/HTML

--=_NextPart_000_0009_01C00C93.8BCD5770--


--
Archives: 

RE: CFTRANSACTION

2000-08-22 Thread DeVoil, Nick

Andy it was the HTML mail putting that garbage in.
Luke you need apostrophes round the character variables.
Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem with CFFTP

2000-08-22 Thread Moneymaker, Jon S.

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_01C00C4A.E954A248
Content-Type: text/plain;
charset="iso-8859-1"



These are internal public files, available to all users in the system
(hundreds of files). They are only .doc, .pdf, and .ppt's., consisting of
handouts, and presentations we do for our client population.  No real need
for directory security internally.


--_=_NextPart_001_01C00C4A.E954A248
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
TITLERE: Problem with CFFTP/TITLE

META content="MSHTML 5.00.2919.6307" name=GENERATOR/HEAD
BODY
BLOCKQUOTE style="MARGIN-RIGHT: 0px"
  DIV class=OutlookMessageHeaderFONT face="Times New Roman" 
  size=2/DIV/FONT
  PFONT size=2These are internal public files, available to all users in the 
  system (hundreds of files). They are only .doc, .pdf, and .ppt's., consisting 
  of handouts, and presentations we do for our client population.nbsp; No real 
  need for directory security internally./FONT/P/BLOCKQUOTE/BODY/HTML

--_=_NextPart_001_01C00C4A.E954A248--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFTRANSACTION

2000-08-22 Thread Andy Ewings

oh ok...thanks *blush*knew I must be doing something silly!

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 16:09
To: '[EMAIL PROTECTED]'
Subject: RE: CFTRANSACTION


Andy it was the HTML mail putting that garbage in.
Luke you need apostrophes round the character variables.
Nick


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

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



RE: Hidden Variables

2000-08-22 Thread Philip Arnold - ASP

 Is it expected behavior for Hidden Vars
 to be truncated at the first space?

Are you putting quotes around the value?

If not, then HTML will think that it's another parameter

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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: (OT)SQL Operator

2000-08-22 Thread Philip Arnold - ASP

 I have been going through the SQL 7 CBT and just finished operators.  With
 regards to comparison operators ... != 'is not equal to', and  'is not
 equal too'.
 
 I do not understand  'not equal too'.
 
 Can someone please explain this to me in more detail and possible 
 provide an example?

In real terms, the "" means "Not less than and not greater than".

I actually prefer writing it 
 where not myField='myValue'

I know it sounds odd, but it's easier for me to read...

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.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Access 97 and 2000

2000-08-22 Thread Mark Armendariz

Taken from the MS Knowledge Base (I had this same issue) at:
http://support.microsoft.com/support/kb/articles/Q241/1/41.ASP?LN=EN-USSD=g
nFR=0


---
One error message you may receive is:
Microsoft Access can't start because there is no license for it on this
machine.
To resolve this behavior, follow these steps:
Click Start, point to Find, and then click Files or Folders.


In the Named box, type Hatten.ttf.


In the Look In box, type C:\Windows\Fonts or the path to the Fonts folder on
your computer. If you are not sure of the font folder's location, open
Windows explorer and verify the directory where Windows is installed. Note:
If you are on Windows NT 4.0, the path may be C:\WINNT\Fonts


Click Find Now to start the search.


Under Name, right-click the Hatten.ttf file, and on the menu that appears,
click Rename.


Change the name of the file to Hatten.sav.

NOTE: You can find the Hatten.ttf file in the Fonts folder under the name,
Haettenschweiler


Insert your Access 97 or Office 97 CD into the CD-ROM or DVD-ROM drive.


Click Start, and then click Run.


Type the command to run the Microsoft Access Setup program and use the /y
switch to reregister Access 97. For example, type:


D:\Setup.exe /y
In the Installation Maintenance Program dialog box, click Reinstall. The
Setup program updates the system registry for Access. When Setup is
finished, start Access.




-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Access 97 and 2000


A miracle

No really - I think you need to have them installed on a seperate drive, or
partition - but I'm not 100% sure

-Original Message-
From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 18:55
To: [EMAIL PROTECTED]
Subject: OT: Access 97 and 2000


What does it take to run both Access 97 and Access 2000 on the same machine?

We have some small CF db's in Access 97. We have a development machine with
Office 2000 and tried to install only the Access portion of Office 97 on the
same
machine.

When we try to start either version of Access, we now get this message:

"Microsoft Access can't start because there is no license for it on this
machine."

Gene Kraybill


-
Gene Kraybill
LPW  Associates LLC
www.lpw.net

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

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

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



Re: Access 97 and 2000

2000-08-22 Thread Deanna L. Schneider

H, I have both installed without a problem. I had 97 installed first,
then installed 2000 from the disc and select the "install when first run"
option. I can switch back and forth and even have both running at once.

I have a Windows 98 OS, if that makes any difference.

-Deanna




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



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



RE: Documentation system a la Perldoc

2000-08-22 Thread Paul Johnston

As requested a few days ago...

I have created a simple CF file browser and simple cfdoc documentation
system.  This is similar to perldoc and POD and so uses similar syntax.

Please download it and tell me what you think.  To run the program, download
http://www.perlfreak.uklinux.net/cfdoc/cfdoc.zip and place the 3 files
(cfdoc.cfm, cfdoc_browser.cfm, README.txt) somewhere cold fusion can see
them (ie on a test website) and load cfdoc_browser.cfm into your browser,
and view cfdoc.cfm. The README.txt file gives you the syntax for cfdoc so
that you can make your own files if you want.

I hope it's useful. I only wrote it in an hour or so, so it may not be
perfect.

Thanks

Paul


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



Re: CFTRANSACTION

2000-08-22 Thread Deanna L. Schneider

You're not indicating any of your fields as text fields (you need to wrap a
field in 's, like so: 'form.givenname') That would definitely throw an
error.

-Deanna




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



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



RE: Access 97 and 2000

2000-08-22 Thread Gene Kraybill

I see Access 2000 has an option to save in Access 97 format. Can anyone vouch for 
this as a reliable way of maintaining Access-97 dbs on a development machine when 
upgrading to 2000 isn't an option on the live server?

Gene Kraybill


Andy Ewings [EMAIL PROTECTED]

 I think you need to have them installed on a seperate drive, or
 partition - but I'm not 100% sure
 
 -Original Message-
 From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 18:55
 To: [EMAIL PROTECTED]
 Subject: OT: Access 97 and 2000
 
 
 What does it take to run both Access 97 and Access 2000 on the same machine?
 
 We have some small CF db's in Access 97. We have a development machine with 
 Office 2000 and tried to install only the Access portion of Office 97 on the
 same 
 machine.
 
 When we try to start either version of Access, we now get this message:
 
 "Microsoft Access can't start because there is no license for it on this
 machine."
 
 Gene Kraybill
 
 
 -
 Gene Kraybill
 LPW  Associates LLC
 www.lpw.net
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or s
end a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
 


-
Gene Kraybill
LPW  Associates LLC
www.lpw.net
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Access 97 and 2000

2000-08-22 Thread James Smith

oops, Microsoft strike again :-)

As far as I know there is NO way to get both versions running on the same
machine (thanks Microsoft).

The error you are getting is a cracker, and you will have fun getting rid of
it!  The problem is caused by the fact that Office 2000 does not completely
remove it's self when you uninstall it and your machine is now convinced you
are trying to run the wrong version of the software with the wrong licence.

The only way to solve it is to uninstall both versions of office, then run a
utility provided by Microsoft (see the URL's at the end of the email) to
finish the uninstall for you, then reinstall the version of office you want
to run.

The best way to avoid this problem is not to have ANY version of office on
the server, just install the latest copy of the MDAC (2.5 I think) which
will provide read/write access to all versions of Access databases (but ONLY
if they are not replicable) and do all your modifications on other machines.

Knowledge base articles
---
Q219423 - OFF2000: How to Completely Remove Microsoft Office CD1
http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP?LN=EN-USSD=g
nFR=0

Q247684 - OFF2000: How to Completely Remove Microsoft Office CD2
http://support.microsoft.com/support/kb/articles/Q247/6/84.ASP?LN=EN-USSD=g
nFR=0

Q239938 - OFF2000: Utility to Completely Remove Remaining Office CD1 Files
and Registry Entries
http://support.microsoft.com/support/kb/articles/q239/9/38.asp?LN=EN-USSD=g
nFR=0

Q247674 - OFF2000: Utility to Completely Remove Remaining Office CD2 Files
http://support.microsoft.com/support/kb/articles/q247/6/74.asp?LN=EN-USSD=g
nFR=0

Hope this little lot helps :)

--
James Smith
[EMAIL PROTECTED]

When God created France he found it so perfect that to comfort those who
couldn't live there, he created the French.

- Original Message -
From: "Gene Kraybill" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 6:54 PM
Subject: OT: Access 97 and 2000


 What does it take to run both Access 97 and Access 2000 on the same
machine?

 We have some small CF db's in Access 97. We have a development machine
with
 Office 2000 and tried to install only the Access portion of Office 97 on
the same
 machine.

 When we try to start either version of Access, we now get this message:

 "Microsoft Access can't start because there is no license for it on this
machine."

 Gene Kraybill


 -
 Gene Kraybill
 LPW  Associates LLC
 www.lpw.net
 --

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

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



RE: Access 97 and 2000

2000-08-22 Thread Robert Everland

No do a search at the kb on www.microsoft.com/technet . There they
will give you a program that will fix the registry. Went through it like 80
times now. Pain in my butt, you would think since they made these products
the least they could do is make sure they could work together.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Access 97 and 2000


A miracle

No really - I think you need to have them installed on a seperate drive, or
partition - but I'm not 100% sure

-Original Message-
From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 18:55
To: [EMAIL PROTECTED]
Subject: OT: Access 97 and 2000


What does it take to run both Access 97 and Access 2000 on the same machine?

We have some small CF db's in Access 97. We have a development machine with 
Office 2000 and tried to install only the Access portion of Office 97 on the
same 
machine.

When we try to start either version of Access, we now get this message:

"Microsoft Access can't start because there is no license for it on this
machine."

Gene Kraybill


-
Gene Kraybill
LPW  Associates LLC
www.lpw.net

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

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



RE: Problem with CFFTP

2000-08-22 Thread Andy Ewings

nopethis does the same thing (tries to save the cfm page)

-Original Message-
From: Joel Richards [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 15:28
To: [EMAIL PROTECTED]
Subject: RE: Problem with CFFTP


You can also use the cfheader tag:

CFHEADER NAME="Content-Disposition" value="attachment; 
filename=#form.FileName#"

At 08:20 AM 8/22/00, you wrote:
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_01C00C44.1E5D7688
Content-Type: text/plain;
 charset="iso-8859-1"

Users can simply right click on the "link" and select the option: "save
target as..." and it will bring up the save dialog box and give them the
option to save it on their systemI use this on our intranet and it
works
just fine.

It requires some user education (always a perilous and onerous
undertaking)but that, coupled with a rather large font size: Right
Click
to Download

seems to work for us!!

Jon
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 9:30 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Problem with CFFTP


Ok, I tried it and unfortunately it loaded it into the browser as a word
document.  Any ideas as to the direction I need to point my heroic efforts
in order to prompt the user to download the file?!

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 14:18
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP


Keep in mind that with IE and MS-Word, Powerpoint, Excel, it sometimes
takes
heroic efforts to overcome the M$ natural tendency to display the document
in the browser, as opposed to force a download.

DC

- Original Message -
From: "David E. Crawford" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 13:14
Subject: Re: Problem with CFFTP


  To a certain extent that is true.  However, by setting the appropriate
  MIME
  type for the document you can force the browser to "save" it rather than
  rendering it.
 
  DC
 
  - Original Message -
  From: "Andy Ewings" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, August 22, 2000 13:12
  Subject: RE: Problem with CFFTP
 
 
   I thought CFContent basically allows the user to read non HTML files
   in
   their browser window (after all the browser is just a container).  I
   don't
   want to open the file in their browser, just let them save it to their
   hard
   drive and open it up in word (it's a word doc)
  
   -Original Message-
   From: David E. Crawford [mailto:[EMAIL PROTECTED]]
   Sent: 22 August 2000 14:05
   To: [EMAIL PROTECTED]
   Subject: Re: Problem with CFFTP
  
  
   CFCONTENT causes CF to read a file from the web server and "push" it
   to
   the client via the browser.  CFFILE lets you move files around on
  the
   web
   server, including creating, renaming, copying and deleting.
  
   DC
  
   - Original Message -
   From: "Andy Ewings" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, August 22, 2000 13:02
   Subject: RE: Problem with CFFTP
  
  
Oh okbut I still don;t see/understand how you move files from
  the
web
server to the client using cffile/cfcontent.  I would have thought
   cfftp
would have done this by the nature of it's name!  Anyone show me
  what
   to
do?!
   
-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: Problem with CFFTP
   
   
They already have the ability to specify where it is saved.  That is
completely a client function.
   
DC
   
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 12:52
Subject: RE: Problem with CFFTP
   
   
 Oh.

 How do I do that?  What I am trying to do is let the user download
  a
 specific file from the web server to there Hard drive but I want
  to
let
 them
 choose where to save it.  Have you got any code that will do this?

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 14:28
 To: [EMAIL PROTECTED]
 Subject: Re: Problem with CFFTP


 Yeah,  You can't use CFFTP to move files between the cfserver and
 browser.
 Only between the FTP server and CF server.  You have to use CFFILE
   and
 CFCONTENT to upload and download from the browser to the server
  and
then
 from the server to the FTP server and vice versa.

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CFTalk (E-mail)" [EMAIL PROTECTED]
 Sent: Tuesday, August 22, 2000 5:56 AM
 Subject: Problem with CFFTP


  I have a problem with CFFTP.  I am trying to use CFFTP to
  download
   a
 file
  onto a user 

RE: Advanced Security set-up

2000-08-22 Thread Olive, Christopher M Mr NMR

you do, but Advanced Security only comes with  Enterprise (AFAIK.)  do you
have Professional?

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Ashley Hart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:35 AM
To: [EMAIL PROTECTED]
Subject: Advanced Security set-up


Does anyone know where I have to go to install the Advanced Security in
the Administrator?  Do I have to re-install Cold Fusion Studio or the
Server?  I went into the Server to re-install, but it only gives me an
option for selecting on the server Microsoft IIS, Peer Web Server, or
Personal Web Server?  I thought this is where I was to go to select
Advanced Security? Thanks.

-ashley

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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Michael O Reilly

Paul,

Thanks for the suggestion, I don't really care if they don't read the page,
so long as I know that they requested the page and it all arrived at their
browser.
If the user stops a slow page download, will OnRequestEnd be triggered. I
need to verify that everything arrived at the browser, which is why I'm
concentrating on a Client side solution.

Michael

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:56 AM
To: [EMAIL PROTECTED]
Subject: RE: Slightly OT - Detecting that a page has completed.


Why not use the OnRequestEnd.cfm page (like application.cfm but at end of
request not start!) and test that this has run.

You can do this by putting an if statement to check which page has been
requested by the user, and assuming you have ID's and stuff of various
users, you can put in a database that they have received the page when this
page is hit.

You can not however without some kind of "I have read this" button, test
whether they have read it and there is no way you can check if they've
understood it ;)

Paul

 -Original Message-
 From: Michael O Reilly [mailto:[EMAIL PROTECTED]]
 Sent: 22 August 2000 09:42
 To: [EMAIL PROTECTED]
 Subject: Slightly OT - Detecting that a page has completed.


 Hi all,
 I have been given a problem which I'm not sure is solvable.
 We are to publish staff rosters on the Web and want to know if staff have
 been notified of/looked at their roster.
 I have said that although we can detect that the user has
 requested a page,
 it's impossible to know if the whole page arrived at the browser
 (people are
 connecting in from all over the world on some very dodgy telco systems so
 connection speeds can be assumed to be poor). Am I correct here.

 I know I could put a JS onload event into the body tag which
 submits some
 info back to the server. But can I put anything at the end of the
 page which
 would do the same.

 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
 'unsubscribe' in the body.




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



RE: Fuzzy Logic Searches in SQL

2000-08-22 Thread Wjreichard

MS implemention may not be that good (which I'm not going to argue), but it is free 
and thrown into MS-SQL 7.0. 

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



RE: Access 97 and 2000

2000-08-22 Thread Olive, Christopher M Mr NMR

that's actually incorrect.  i am currently running both office versions.
(at one point, i had 4.3 on there, too!)

the key with microsoft is to install their products in DATE ORDER, oldest
first.  if you install 97, then 2000, selecting "do not remove old
applications" in the 2000 install, they'll play together nicely.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 11:30 AM
To: [EMAIL PROTECTED]
Subject: Re: Access 97 and 2000


oops, Microsoft strike again :-)

As far as I know there is NO way to get both versions running on the same
machine (thanks Microsoft).

The error you are getting is a cracker, and you will have fun getting rid of
it!  The problem is caused by the fact that Office 2000 does not completely
remove it's self when you uninstall it and your machine is now convinced you
are trying to run the wrong version of the software with the wrong licence.

The only way to solve it is to uninstall both versions of office, then run a
utility provided by Microsoft (see the URL's at the end of the email) to
finish the uninstall for you, then reinstall the version of office you want
to run.

The best way to avoid this problem is not to have ANY version of office on
the server, just install the latest copy of the MDAC (2.5 I think) which
will provide read/write access to all versions of Access databases (but ONLY
if they are not replicable) and do all your modifications on other machines.

Knowledge base articles
---
Q219423 - OFF2000: How to Completely Remove Microsoft Office CD1
http://support.microsoft.com/support/kb/articles/Q219/4/23.ASP?LN=EN-USSD=g
nFR=0

Q247684 - OFF2000: How to Completely Remove Microsoft Office CD2
http://support.microsoft.com/support/kb/articles/Q247/6/84.ASP?LN=EN-USSD=g
nFR=0

Q239938 - OFF2000: Utility to Completely Remove Remaining Office CD1 Files
and Registry Entries
http://support.microsoft.com/support/kb/articles/q239/9/38.asp?LN=EN-USSD=g
nFR=0

Q247674 - OFF2000: Utility to Completely Remove Remaining Office CD2 Files
http://support.microsoft.com/support/kb/articles/q247/6/74.asp?LN=EN-USSD=g
nFR=0

Hope this little lot helps :)

--
James Smith
[EMAIL PROTECTED]

When God created France he found it so perfect that to comfort those who
couldn't live there, he created the French.

- Original Message -
From: "Gene Kraybill" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 22, 2000 6:54 PM
Subject: OT: Access 97 and 2000


 What does it take to run both Access 97 and Access 2000 on the same
machine?

 We have some small CF db's in Access 97. We have a development machine
with
 Office 2000 and tried to install only the Access portion of Office 97 on
the same
 machine.

 When we try to start either version of Access, we now get this message:

 "Microsoft Access can't start because there is no license for it on this
machine."

 Gene Kraybill


 -
 Gene Kraybill
 LPW  Associates LLC
 www.lpw.net
 --

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


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



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Paul Wakefield

Two possibilities:

1. Doesn't CF throw a timeout/abort error if the page is cancelled before
it's finished?
2. (Sneaky one this) use the 'web bug' idea - add an IMG tag at the end of
the source, after the roster info with the SRC pointing to a CF script that
logs the request and returns an invisible 1x1 gif. No client side scripting
or frames to worry about, your only problem would be people turning off
images in the browser.

-- 
Paul Wakefield

Hofstadter's Law - It always takes longer than you think, even if you take
into account Hofstadter's Law.


 -Original Message-
 From: Michael O Reilly [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 22, 2000 10:42 AM
 To: [EMAIL PROTECTED]
 Subject: Slightly OT - Detecting that a page has completed.
 
 
 Hi all,
 I have been given a problem which I'm not sure is solvable.
 We are to publish staff rosters on the Web and want to know 
 if staff have
 been notified of/looked at their roster.
 I have said that although we can detect that the user has 
 requested a page,
 it's impossible to know if the whole page arrived at the 
 browser (people are
 connecting in from all over the world on some very dodgy 
 telco systems so
 connection speeds can be assumed to be poor). Am I correct here.
 
 I know I could put a JS onload event into the body tag 
 which submits some
 info back to the server. But can I put anything at the end of 
 the page which
 would do the same.
 
 --
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OnRequestEnd.cfm

2000-08-22 Thread Ken Goldstraw

Hello folks,

Someone once told me that OnRequestEnd.cfm should exist in every directory,
whether you're using it or not.  The reason he gave was that CF would
traverse the directory tree until either an OnRequestEnd.cfm was found, or
the top level was reached.  Is this true?  Does anyone do this?

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



Re: CFTRANSACTION

2000-08-22 Thread Wjreichard

If any of your values evaluate to NULL you will not form a valid insert string. You'll 
end up with:

INSERT tblA (A,B) VALUES (1,)

Ypu'll need to check for NULL and make appropriate substitions:

INSERT tblA (A,B) VALUES (1,NULL)


Also I see your not using a field list? So all table fields must be account for, in 
one way or another.

Also, it doesn't appear that ypur adding quoute to your insert statement? If data is 
character type will might have to?

Bill
Willow Gold
http://www.willowgold.com

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



RE: AuthentiX CF cookies

2000-08-22 Thread Bill Killillay

Because this is a COLD FUSION list, we talk about ways to do things with
ColdFusion here.

 NOt to knock CF but why not use ASP all around??


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



RE: OnRequestEnd.cfm

2000-08-22 Thread Brad Roberts

It only searches the directory where the application.cfm was found.
Wouldn't hurt to have one in that directory though.

-Original Message-
From: Ken Goldstraw [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: OnRequestEnd.cfm


Hello folks,

Someone once told me that OnRequestEnd.cfm should exist in every directory,
whether you're using it or not.  The reason he gave was that CF would
traverse the directory tree until either an OnRequestEnd.cfm was found, or
the top level was reached.  Is this true?  Does anyone do this?

TIA
-Ken

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

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



CFQUERY, using two different DBs question - Newbie ;)

2000-08-22 Thread Mike Deane

cfquery name="Insert" DATASOURCE="AClient" username="sa" password=""
INSERT Customer_Kit
SELECT *
FROM dbo.ProdCenter.Task
WHERE 1 = 1
AND Task.Task_ID IN (#PreserveSingleQuotes(Form.Task_Selected)#);
/cfquery


I am trying to move some data from one DB,table (ProdCenter,Task)
FROM dbo.ProdCenter.Task into another DB,table (AClient,
Customer_Kit).

How do I accomplish this feat?  For instance, how do I provide a second
DATASOURE to access the second DB?



Thank you.
/mdeane
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: OnRequestEnd.cfm

2000-08-22 Thread Dan Haley

I don't think the same holds true for onrequestend.cfm that does for
application.cfm.  CF will only look for onrequestend.cfm in the directory
that it found application.cfm.

Dan

-Original Message-
From: Ken Goldstraw [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 8:56 AM
To: '[EMAIL PROTECTED]'
Subject: OnRequestEnd.cfm


Hello folks,

Someone once told me that OnRequestEnd.cfm should exist in every directory,
whether you're using it or not.  The reason he gave was that CF would
traverse the directory tree until either an OnRequestEnd.cfm was found, or
the top level was reached.  Is this true?  Does anyone do this?

TIA
-Ken

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



  1   2   3   >