Re: History list

2000-08-11 Thread Jonathan Karlen

What about setting cookies?  Use five cookies named LocationX and on each
page loop through them all and append the current page and remove the
oldest.  Then loop through the cookies and print the links.

Jon

- Original Message -
From: Parker, Kevin [EMAIL PROTECTED]
To: CF Talk (E-mail) [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 12:45 AM
Subject: History list


 This may actually be best achieved with a JavaScript solution so I
apologise
 if some regard it as OT.

 We're deploying one of our large manuals to the web (which is currently
 distributed as a Win 3.1 help file - those were the days) as HTML. One of
 its features (the win help version) is that it has a history function and
 users can back track. I want to try an emulate this for the last 5 or so
 pages the user was on.

 I know you can do this by using a href and using history - 1, history -2
etc
 but rather than have a simple image or bit of static text with a link I
want
 to actually try to produce a small list with the name of the page they
were
 on, linked to that page (the link can use history -1 etc but I want to
 actually get the name of the page if I can). After all users won't
remember
 what the page was 5 clicks ago but it will help them if they can see the
 name of the page. The history function in JavaScript doesn't appear to
 provide this info.

 Any clue please.


 
 Kevin Parker
 Service and Communication
 WorkCover Corporation

 [EMAIL PROTECTED]

 ph:  +61 8 82332548
 fax: +61 8 82332000
 






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


 --

 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: Latest WDDX_COM.DLL

2000-08-11 Thread Terry Riley

In-Reply-To: 001401c00317$c18f77b0$[EMAIL PROTECTED]
Thanks, Dave

Terry Riley
Riley Varea Associates, London, UK 
--Original Message--

  Can anyone enlighten me as to the latest version of the WDDX 
  COM object?
  
  I can't find anything on the Allaire site that shows that 
  anything has been 'issued' since the 4.0.1 upgrade.
  
  The one on my machine is version 1,0,0,1 dated 9 April 99.
 
 Have you checked http://www.wddx.org/?
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444



--
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: History list

2000-08-11 Thread Parker, Kevin

Thanks Jon - didn't consider cookies and haven't used them before. This also
assumes that the end user has cookies enabled.



Kevin Parker
Service and Communication
WorkCover Corporation

[EMAIL PROTECTED]

ph:  +61 8 82332548
fax: +61 8 82332000



-Original Message-
From: Jonathan Karlen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 August 2000 4:43:PM
To: [EMAIL PROTECTED]
Subject: Re: History list


What about setting cookies?  Use five cookies named LocationX and on each
page loop through them all and append the current page and remove the
oldest.  Then loop through the cookies and print the links.

Jon

- Original Message -
From: Parker, Kevin [EMAIL PROTECTED]
To: CF Talk (E-mail) [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 12:45 AM
Subject: History list


 This may actually be best achieved with a JavaScript solution so I
apologise
 if some regard it as OT.

 We're deploying one of our large manuals to the web (which is currently
 distributed as a Win 3.1 help file - those were the days) as HTML. One of
 its features (the win help version) is that it has a history function and
 users can back track. I want to try an emulate this for the last 5 or so
 pages the user was on.

 I know you can do this by using a href and using history - 1, history -2
etc
 but rather than have a simple image or bit of static text with a link I
want
 to actually try to produce a small list with the name of the page they
were
 on, linked to that page (the link can use history -1 etc but I want to
 actually get the name of the page if I can). After all users won't
remember
 what the page was 5 clicks ago but it will help them if they can see the
 name of the page. The history function in JavaScript doesn't appear to
 provide this info.

 Any clue please.


 
 Kevin Parker
 Service and Communication
 WorkCover Corporation

 [EMAIL PROTECTED]

 ph:  +61 8 82332548
 fax: +61 8 82332000
 






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


 --

 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.




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

--
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: Structs contained within the application scope?

2000-08-11 Thread Dan Haley

Umm, what am I missing here?  As I was about to type in the duplicate
function, I thought "wait, we use structcopy with structures more than one
level deep", so I did some testing and I can't recreate this problem (or
expected behavior) in either 4.0.1 or 4.5.  I was able to structcopy a
structure multiple levels deep, and assign the application structure to a
variable.  The only problem I ran into is that doing a structcopy on the
application variable was the same as a simple assignment - it was still just
a pointer.

Here is one of the tests I ran - (cf_objectdump is from the developer's
exchange):
cfset application.one = structnew()
cfset application.one.two = structnew()
cfset application.one.two.three = structnew()
cfset application.one.four = "four"
cfset application.one.two.five = "five"
cfset application.one.two.three.six = "six"
cf_objectdump object="#application.one#"

cfset test = application.one
cf_objectdump object="#test#"

cfset application.one.four = "fourteen"
cf_objectdump object="#test#"

cfset test2 = structcopy(application.one)
cf_objectdump object="#test2#"

cfset application.one.four = "twentyfour"
cf_objectdump object="#test2#"

Am I missing something that will bite me in the rear in the future?  Or just
totally misunderstanding this e-mail.

Thanks,
Dan


snip

 I can get around this problem by manually copying the struct
 like so (but it's a pain in the rear):

 CFSET App.test = StructCopy(Application.test)

 So my question is...  Shouldn't the StructCopy() function copy the
 entire struct, and any other structs stored inside it? Has anyone
 else run into this experience, or is it considered expected behavior
 when copying structs which contain other structs?

This is expected behavior with StructCopy; it only copies "one level
deep".
If you want to make a complete duplicate, no matter how many nested data
containers you have, use the Duplicate function introduced in CF 4.5.1,
which makes a "deep copy".

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

--
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: (IIS) Customer file uploads - restrictions of file types

2000-08-11 Thread Rich Wild

One security aspect you need to evaluate is discussed on Bugtraq @:
http://www.ntbugtraq.com/default.asp?pid=36sid=1A2=ind9809L=NTBUGTRAQP=R
2454

It deals with the default upload directory being c:\winnt 

--
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---
 

-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 18:43
To: '[EMAIL PROTECTED]'
Subject: (IIS) Customer file uploads - restrictions of file types


We are getting requests from our customers to upload files to a password
secured area of our site so they can share them with other users from their
company, as well as with our internal people.  The intent is for files like
Excel, Word, and Powerpoint documents.  Some of the restrictions we need to
do are pretty straightforward, like who can upload, who can delete, total
file size, etc., but what pitfalls do I need to watch out for from a server
security standpoint?  We are on IIS 4.0, Windows NT 4.0 SP5, CF4.5 ENT, with
plans to go to Win2000.  Is it as simple as restricting certain executable
file types?

All advice is truly appreciated . . . unless Dave Watts sends me more code
from our site . . . whoops . . . :)

Thanks,
Dan

--
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] REQ testimonials from SAG Electronics customers.

2000-08-11 Thread Mooner Ent

Hello,

We're thinking about spending $$ with http://www.sagelectronics.com/. 2U
rack servers.
Testimonials are encouraged, off list if you prefer.

Thanks,

Rick
[EMAIL PROTECTED]


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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: server printing

2000-08-11 Thread Rif Kiamil

No, not unless you want to write a COM or you can us can COM from MS Access
and you can tell that to print any thing from Access. But it you can only
use the default printer setup on that system

I am writing a Com object in Delphi that will let me print any Access Report
from the ColdFusion to any printer on the network. 

It will also let me send information to Access to fill the report with the
data. E.g. You could design a Report in Access with no data in it and then
the ColdFusion would send the info to the COM which get the report from
access fill the data in the right places in the forum and send it to any
print on that computer you want.

From Rif

-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: 10 August 2000 18:23
To: Cf-Talk
Subject: server printing


Is there a way with cf (or maybe js) to print from a web app to a printer
attached to the cf server or the network it is on?

Say, I want to print a document from out of town to the printer on the
network for someone to look at or whatever...

thanks,
je

--
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: Is there a variable for a query's name?

2000-08-11 Thread Sean Renet

umm that was part of the joke.  I wish I could take credit for it, but I
believe is Daniel Maguire's
- Original Message -
From: "David Shadovitz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 10, 2000 6:37 PM
Subject: Re: Is there a variable for a query's name?


  I must be the most unarticulate person on these lists.

 Yes.  It's "inarticulate."
 -David-who-did-better-on-the-English-part-of-the-SAT-than-on-the-math-par
 t-but-who-works-as-a-programmer-anyway
 
 YOU'RE PAYING TOO MUCH FOR THE INTERNET!
 Juno now offers FREE Internet Access!
 Try it today - there's no risk!  For your FREE software, visit:
 http://dl.www.juno.com/get/tagj.
 --

 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:

2000-08-11 Thread Reynolds, Adam

Sorry
Adam Reynolds

 --
 From: Chapman, Katrina[SMTP:[EMAIL PROTECTED]]
 Sent: 10 August 2000 18:00
 To:   [EMAIL PROTECTED]
 Subject:  RE: 
 
 Let's not get pissy Adam.
 
 Sree,
 
 It should work.
 
 IT should be exaclty like this
 
 CFHTTP URL="http://www.amazon.com"
   METHOD="GET"
   RESOLVEURL=YES
 /CFHTTP
 CFOUTPUT
   PYour file was of type: #CFHTTP.MimeType#
   P#HTMLCodeFormat(CFHTTP.FileContent)#
 /CFOUTPUT
 
 
 I ran it and it returned everything just fine.
 
 What is happening on your end.
 
 --K
 
 -Original Message-
 From: Reynolds, Adam [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 10, 2000 6:19 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: 
 
 
 Love the lack of subject line...makes it so easy to see what your
 problem is.
 Adam Reynolds
 
  --
  From:   Sree@bigbuzz[SMTP:[EMAIL PROTECTED]]
  Sent:   10 August 2000 15:22
  To: [EMAIL PROTECTED]
  
  This is a multi-part message in MIME format.
  
  --=_NextPart_000_0020_01C002AC.712ABA70
  Content-Type: text/plain;
  charset="iso-8859-1"
  Content-Transfer-Encoding: quoted-printable
  
  Any wrong with this?
  
  cfhttp url=3D"http://www.amazon.com" method=3D"get"
  
  Thanks=20
  Sree
  
  --=_NextPart_000_0020_01C002AC.712ABA70
  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.2314.1000" name=3DGENERATOR
  STYLE/STYLE
  /HEAD
  BODY bgColor=3D#ff
  DIVFONT face=3DArial size=3D2Any wrong with this?/FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArial size=3D2lt;cfhttp =
  url=3D"http://www.amazon.com"=20
  method=3D"get"gt;/FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArial size=3D2Thanks /FONT/DIV
  DIVFONT face=3DArial size=3D2Sree/FONT/DIV/BODY/HTML
  
  --=_NextPart_000_0020_01C002AC.712ABA70--
  
 
 --
  
  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.
  
 **
  This email and any attachments are confidential and solely
  for the use of the intended recipient.  They may contain
  material protected by legal professional or other privilege.
  If you are not the intended recipient or the person responsible
  for delivering to the intended recipient, you are not authorised
  to and must not disclose, copy, distribute or retain this email
  or its attachments.  Although this email and its attachments
  are believed to be free of any virus or other defect, it is the
  responsibility of the recipient to ensure that they are virus free
  and no responsibility is accepted by the company for any
  loss or damage arising from receipt or use thereof.
 
 **
 --
 --
 --
 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.
 
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

**
--
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: IE Browser Cache-Help

2000-08-11 Thread Philip Arnold - ASP

  I have a page in my application which I do not wish to cache. I
 have put the
 META tag to prevent caching as follows:
 META HTTP-EQUIV="Expires" CONTENT="Fri, Jun 12 1981 08:20:00 GMT"
 META HTTP-EQUIV="Pragma" CONTENT="no-cache"
 META HTTP-EQUIV="Pragma:no-cache"
 META HTTP-EQUIV="Cache-Control" CONTENT="no-cache"

 Also i tried CFHTTP header:
 CFHEADER NAME="Expires" VALUE="#Now()#"

 but IE still is able to cache pages. Netscape responds well.
 Any clues. I wish to programatically control this. I have no
 control over the Server Configurations.

AFAIK, IE4/5 have this lovely ability to over-ride the page settings for
expiry.

With IE5, when the setting is "Automatic" it takes note of the setting, but
that's the only one that seems to - if the user sets it's on "Never" then
you won't be able to touch it.

It's a real PITA, but that's Micro$oft for you...

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: Array Confusion

2000-08-11 Thread Philip Arnold - ASP

 How do I populate a one dimensional array from a query?? I'm
 having trouble
 figuring out how I make the 'Array number' dynamic:

   cfquery datasource="Tester" name="GetNumbers"
   SELECT Quantity, ID FROM TestTable
   /cfquery

   cfoutput query="GetNumbers"

   cfset QuantityTotal = ArrayNew(1)

   cfset QuantityTotal[??]] = #Quantity#

   /cfoutput

Or as an alternative approach to Derek's (which will put the top value into
all entries of the array)

cfset QuantityTotal=ArrayNew(1)
cfloop query="GetNumbers"
cfset QuantityTotal[CurrentRow]=Quantity
/cfloop

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: Can CF be run on a machine which is also running Service Pack 6 Alpha?

2000-08-11 Thread Philip Arnold - ASP

 The problem is that there is a tag or two that don't work on SP 6. I can't
 remember which one(s), but you may be able to find it on the Allaire site.
 That's where I first read about the problem.

CFContent apparently has problems, and Allaire recommend going back to SP5
if you use it - I use SP6a quite happily as I (currently) don't use
CFContent at all

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 carrying over form values.

2000-08-11 Thread Philip Arnold - ASP

 You can try replacing the " with some string you know the person will not
 enter, like §, or some other character entity. Then you can get that data
 from the hidden form field and convert it back before entering it into the
 database.

There's a neater solution that this one - rather than having to re-convert
it back later...

input type="hidden" name="comments"
value="#Replace(form.Comments,,"quot;","All")#"

You can use this for all form types, and the HTML is converted when the form
passes it along

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: Need your help desperately...

2000-08-11 Thread Philip Arnold - ASP

 I would agree with this, for the simple fact I hold no degrees in
 anything.
 But I am a very quick learner, and work hard to achieve what I set out to
 do. I have 20 years programming experience, and have dabbled in a lot of
 languages. I have a very impressive resume, and the ability to sell my
 skills.

 I did think the CF certificate would make it easier to say you
 know CF, but
 what about programming logic this is a lot harder to learn and comes from
 experience. I see the Allaire Certificate for CF a waste of my time, only
 because I believe in my ability to do the work and think that my
 work in the
 industry will be enough to keep working in it.

I have to totally agree with this assessment - I never went to Uni, hold no
degrees or real qualifications in programming, but I've been a
programmer/developer for the last 10-12 years (in a variety of languages)

I cheated on finding a job though, I own a third of my company g

I'm actually taking the CF Certification in November (at the Conference)
just so that clients are more at ease with the development work - I prove
that I can do the work by the sites I've developed, not by a piece of paper

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: in one query refers to 2 different odbc sources

2000-08-11 Thread Philip Arnold - ASP

 I have 2 databases located on the 2 different NT servers, Is
 there any way i
 can write one query that refers to different odbc sources, if
 yes, how and the syntax,

If they are the same database type, then there is usually a way...

in SQL Server it's quite easy;
cfquery name="myQuery" datasource="myDSN"
select t1.column1, t2.column2
from table1 as t1, serverName.databaseName.dbo.table2 as t2
...
/cfquery

using Access you can refer to the database by a it's exact location, but I
can't remember the code as I haven't worked in Access for over a year now

If they are differing database types, as in Access and SQL Server, then no,
you can't

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: Optimization tips collection

2000-08-11 Thread Philip Arnold - ASP

 There is a lot of conflicting information on how to properly set up an
 Access datasource. For me anyway, I've found that Access sites
 are much more
 stable when the database connection is NOT persistent, and the
 max number of connections is set to around 5.

I found sites much more stable by not using Access g

Remember that Access has the horrid maximum 50 concurrent connections - that
counts for multiple uses on the same template, and over any databases as
it's the MSJet driver that has the limit, not the database

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: Need your help desperately...

2000-08-11 Thread Andrew Scott

The latter sounds good, but no it was a typo and hase been rectified I don't
look good in a dress anyway:-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 11 August 2000 11:35 AM
To: [EMAIL PROTECTED]
Subject: RE: "Need your help desperately..."




"Scott, Andrew" [EMAIL PROTECTED]wrote:

Andrea Scott
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]

So which is it? Andrew or Andrea? Or are there multiple personalities all
fighting each other? :-)


Rob Keniger



--
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: History list

2000-08-11 Thread Philip Arnold - ASP

 This may actually be best achieved with a JavaScript solution so
 I apologise
 if some regard it as OT.

 We're deploying one of our large manuals to the web (which is currently
 distributed as a Win 3.1 help file - those were the days) as HTML. One of
 its features (the win help version) is that it has a history function and
 users can back track. I want to try an emulate this for the last 5 or so
 pages the user was on.

 I know you can do this by using a href and using history - 1,
 history -2 etc
 but rather than have a simple image or bit of static text with a
 link I want
 to actually try to produce a small list with the name of the page
 they were
 on, linked to that page (the link can use history -1 etc but I want to
 actually get the name of the page if I can). After all users
 won't remember
 what the page was 5 clicks ago but it will help them if they can see the
 name of the page. The history function in JavaScript doesn't appear to
 provide this info.

Seeing as the history object in JavaScript is an array, you can refer to any
of the entries in it - BUT, it calls them all by URL, it's only the browser
that calls them by title

The only way I can think of getting the titles is to run an (ugly) loop that
briefly opens another window for that URL, grabs the title, then closes that
window - this would mean loads of windows flicking into existance, then
closing immediately.

This would work, but it wouldn't be quick if the server connection was slow,
oh, and did I mention it would be ugly?

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: History list

2000-08-11 Thread JustinMacCarthy

I would suggest using an array and the

ArrayDeleteAt(array, position)
ArrayAppend(array, value)


so if you have a var session.history

as you add a values use ArrayAppend(session.history, value) and
if the array is over 5 entries use ArrayDeleteAt(session.history,1)

Justin MacCarthy

- Original Message -
From: "Parker, Kevin" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 7:30 AM
Subject: RE: History list


 Thanks Jon - didn't consider cookies and haven't used them before. This
also
 assumes that the end user has cookies enabled.


 
 Kevin Parker
 Service and Communication
 WorkCover Corporation

 [EMAIL PROTECTED]

 ph:  +61 8 82332548
 fax: +61 8 82332000
 


 -Original Message-
 From: Jonathan Karlen [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 10 August 2000 4:43:PM
 To: [EMAIL PROTECTED]
 Subject: Re: History list


 What about setting cookies?  Use five cookies named LocationX and on each
 page loop through them all and append the current page and remove the
 oldest.  Then loop through the cookies and print the links.

 Jon

 - Original Message -
 From: Parker, Kevin [EMAIL PROTECTED]
 To: CF Talk (E-mail) [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 12:45 AM
 Subject: History list


  This may actually be best achieved with a JavaScript solution so I
 apologise
  if some regard it as OT.
 
  We're deploying one of our large manuals to the web (which is currently
  distributed as a Win 3.1 help file - those were the days) as HTML. One
of
  its features (the win help version) is that it has a history function
and
  users can back track. I want to try an emulate this for the last 5 or so
  pages the user was on.
 
  I know you can do this by using a href and using history - 1, history -2
 etc
  but rather than have a simple image or bit of static text with a link I
 want
  to actually try to produce a small list with the name of the page they
 were
  on, linked to that page (the link can use history -1 etc but I want to
  actually get the name of the page if I can). After all users won't
 remember
  what the page was 5 clicks ago but it will help them if they can see the
  name of the page. The history function in JavaScript doesn't appear to
  provide this info.
 
  Any clue please.
 
 
  
  Kevin Parker
  Service and Communication
  WorkCover Corporation
 
  [EMAIL PROTECTED]
 
  ph:  +61 8 82332548
  fax: +61 8 82332000
  
 
 
 
 
 


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



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





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


 

OT: file upload problems with IIS

2000-08-11 Thread Paul Johnston

I am having trouble trying to do HTTP file uploads with IIS 4. I have heard
there is some sort of update to put on to make it RFC 1867 (or whatever it
is) compatible but cannot find it.

Any help appreciated.

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: CF-Talk V1 #134 (Out of office)

2000-08-11 Thread Julie Hopple

I am currently out of the office and will return on Monday, August 21.  Any urgent 
concerns should be forwarded to David McCormick or Mary Prosceno.

 CF-Talk 08/11/00 06:37 

CF-TalkFri, 11 Aug 2000  Volume 1 : Number 134

In this issue:

Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
Preventing Browsers Cacheing a .cfm file
Re: Preventing Browsers Cacheing a .cfm file
RE: Problem carrying over form values.
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
RE: Preventing Browsers Cacheing a .cfm file
Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
RE: OT eWebeditPro  CFML
RE: VERY SAD (was CFGRID onvalidate="???")
RE: CF, ODBC and 64k data
RE: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
Re: Certified?
History list
Re: History list
RE: Latest WDDX_COM.DLL
RE: History list
RE: Structs contained within the application scope?
RE: (IIS) Customer file uploads - restrictions of file types
RE: VERY SAD (was CFGRID onvalidate="???")
[OT] REQ testimonials from SAG Electronics customers.
RE: server printing
Re: Is there a variable for a query's name?
RE: 
RE: Array Confusion
RE: IE Browser Cache-Help
RE: Can CF be run on a machine which is also running Service Pack 6 Alpha?
RE: Problem carrying over form values.
RE: "Need your help desperately..."
RE: Optimization tips collection
RE: in one query refers to 2 different odbc sources
RE: "Need your help desperately..."
RE: History list
Re: History list
OT: file upload problems with IIS


--

Date: Fri, 11 Aug 2000 15:03:07 +1200
From: David Cummins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: CustomTag /DIRECTORYat a SHARED HOSTING ISP ??? HELP!!!
Message-ID: [EMAIL PROTECTED]

I would actually disagree with that.

Someone in our office tried calling a custom tag that alters the generated
content with cfmodule, and it did not work correctly, even though it worked when
called the standard way. He used /cfmodule at the end too.

David

Matthew Walker wrote:
 
   I just signed up with an ISP that does shared web hosting.
   i use to a stand alone machine and inserting my custom tags
   in the /customtags directory under my CF install.  How would/should
   an ISP implement this kind of capability on a shared service where
   multiple sites are using one install of CF?
 
  The ISP will probably have you copy your custom tags directory under your
  root. You can either copy the custom tag to which ever directory
  you wish to
  call the tag from or you can put the tags in one central directory and use
  cfmodule to call your tags.
 
 I'm in the same situation. I place a customtags folder under the root of the
 site. Annoyingly, I can't use absolute paths (beginning with a /) to point
 to it (has to be set up on the server) so every time I want to call a custom
 tags I have to use a relative link with cfmodule. One thing to note is
 that custom tags that have a closing tag (e.g. cf_bodycontent/) will still
 work -- you just use /cfmodule instead.
 
 I'd really like to see notes in the Fusebox spec about using it in a shared
 environment like this. The number of CF Web hosting services is only going
 to grow
 
 Regards,
 Matthew Walker
 Electric Sheep Web Co.
 http://www.electricsheep.co.nz/
 
 --
 Tel +64-3-374 2137
 Fax +64-3-377 7930
 Mobile +64-25-605 5747
 P O Box 13-907, Armagh
 Christchurch 8031
 New Zealand
 
 --
 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.

--

Date: Fri, 11 Aug 2000 13:44:48 +1000
From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Preventing Browsers Cacheing a .cfm file
Message-ID: 00c701c00346$805015a0$71cbfea9@claudeslaptop

This is a multi-part message in MIME format.

--=_NextPart_000_00C4_01C0039A.5121F240
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is the a code that will successfully prevent a  .cfm page from being =
cached on a users browser that will work effectively across browsers


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

--=_NextPart_000_00C4_01C0039A.5121F240
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

RE: dynamically updating one select list [code example]

2000-08-11 Thread Daniel Kemp

This is a multi-part message in MIME format.

--=_NextPart_000_00FB_01C00386.96C88AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Terri,

 I'm assuming I will have to (ugh) use a javascript for
 this?  Admittedly, I am neither a javascript guru nor
 a coldfusion guru. Can anyone provide me with some
 direction on this?

I've attached two files which I hope will start you going in the right
direction.  The first one doesn't specifically answer your question,
but does deal with dynamically repopulating a form
based on a selection.  In the hope that other people will also find it
useful.

In the first example I'm populating a second drop down select box,
based on the selection made in the first drop down box.

The second file should give you a better solution to your problem.
You'll need to tweek it slightly to suit your needs, but it's all
there.  I'm sure there are simpler ways to do this, but using the code
in the second file may allow you to move forwards to more elaborate
code/needs.  You'll notice I also have more than one person in a
department, where as you'll only be having one person per department,
this'll be reflected I assume in your database.

Good luck anyway.

Oh yeah, the code won't "run straight out of the box" as it depends on
two queries in a database, these are easy to build I've commented them
in the code.  Of course you'll also need to change the datasource.

I've put working examples up at...
http://www.phink.net/dynamicSelect.cfm
http://www.phink.net/dynamicSelect2.cfm

 Thanks in advance!
 Terri

Hope this helps someone.

Dan.



This message is intended only for the use of the person(s) ("the intended 
recipient(s)") to whom it is addressed.

It may contain information which is privileged and confidential within the meaning of 
the applicable law. If you are not the intended recipient, please contact the sender 
as soon as possible.The views expressed in this communication may not necessarily be 
the views held by Live Information Systems Limited.

--=_NextPart_000_00FB_01C00386.96C88AC0
Content-Type: application/octet-stream;
name="dynamicSelect.cfm"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="dynamicSelect.cfm"

!---=0A=
//  Title:Dynamic Select Example=0A=
//  Created:  11th August 2000=0A=
//  By:   Daniel Kemp=0A=
---=0A=
=0A=
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"=0A=
=0A=
html=0A=
head=0A=
titleUntitled/title=0A=
=0A=
!--=0A=
//  Here we get all the info we need from the databases=0A=
---=0A=
=0A=
!--- These are my two tables, the first one; departments has the =
following fields...=0A=
//  id  (int)   The unique id of each 
department.=0A=
//  title   (varchar)   The title of each department.=0A=
//=0A=
//  The contents look somewhat like=0A=
//=0A=
//  id  |   title=0A=
//  --|-=0A=
//   1  |   Development=0A=
//   2  |   Resources=0A=
//   3  |   Sales=0A=
---=0A=
=0A=
cfquery name=3D"departments" datasource=3D"yme" dbtype=3D"ODBC"=0A=
  SELECT *=0A=
FROM departments=0A=
ORDER BY title=0A=
/cfquery=0A=
=0A=
!--- The second; staff has the following fields...=0A=
//  id  (int)  
 The unique id of each member of staff=0A=
//  departmentID(int)   The department they 
are in=0A=
//  title   (varchar)   The 
staff members name=0A=
//=0A=
//  The contents look somewhat like=0A=
//=0A=
//  id  | departmentID | title=0A=
//--|--=0A=
//   1  |  1   | Bill=0A=
//   2  |  1   | Colin=0A=
//   3  |  2   | Dave=0A=
//   4  |  3   | Eve=0A=
//   5  |  2   | Fiona=0A=
//   6  |  3   | George=0A=
//   7  |  1   | Helen=0A=
//   8  |  3   | Ian=0A=
//=0A=
//  Notice in this case I have more then one member of staff in each =
department, this is=0A=
//  to open up the uses of this JavaScript to more people, in Terri's =
case there's only=0A=
//  one default person in each department.=0A=
---=0A=
=0A=
cfquery name=3D"staff" datasource=3D"yme" dbtype=3D"ODBC"=0A=
SELECT *=0A=
FROM staff=0A=
ORDER BY title=0A=
/cfquery=0A=
=0A=
!---=0A=
//  Now onto the funky JavaScript=0A=
---=0A=
script language=3D"JavaScript"=0A=
=0A=
!---=0A=
//  This function is kinda like creating our own object like thing, =
anyway it's an object=0A=
//  called anyStaff, which has three properties.  I can use it as such...=0A=
//  anyStaff.ID =3D 1=0A=
//  anyStaff.title =3D 'Tony'=0A=
//  

Double Dimesion ArraySorting

2000-08-11 Thread Vincent

 hi,
I was wondering  how do I go about sorting a double dimension array
?

Consider the second dimension to be ranging from 1-10.

myarray[x][1] -- myarray[x][10]


Now if I want to sort all the arrays in ascending order by the array[x][5]
So that the order of the data myarray[x][1] -- myarray[x][10] would
remain
intact...

...how do I go about doing something like that  ?


Thanks
vin

--
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: dynamically updating one select list [code example]

2000-08-11 Thread Daniel Kemp

Guess the attachments didn't work too well,

Here's the first file dynamicSelect.cfm.
Sorry 'bout the wrap.


-8-8-8-8-8-8-

!---
//  Title:Dynamic Select Example
//  Created:  11th August 2000
//  By:   Daniel Kemp
---

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

html
head
titleUntitled/title

!--
//  Here we get all the info we need from the databases
---

!--- These are my two tables, the first one; departments has the
following fields...
//  id  (int)  The unique id of each department.
//  title   (varchar)  The title of each department.
//
//  The contents look somewhat like
//
//id  | title
//  --|-
// 1  | Development
// 2  | Resources
//   3  | Sales
---

cfquery name="departments" datasource="yme" dbtype="ODBC"
  SELECT *
  FROM departments
  ORDER BY title
/cfquery

!--- The second; staff has the following fields...
//  id(int)  The unique id of each member of staff
//  departmentID  (int)  The department they are in
//  title (varchar)  The staff members name
//
//  The contents look somewhat like
//
//  id  | departmentID | title
//--|--
//   1  |  1   | Bill
//   2  |  1   | Colin
//   3  |  2   | Dave
//   4  |  3   | Eve
//   5  |  2   | Fiona
//   6  |  3   | George
//   7  |  1   | Helen
//   8  |  3   | Ian
//
//  Notice in this case I have more then one member of staff in each
department, this is
//  to open up the uses of this JavaScript to more people, in Terri's
case there's only
//  one default person in each department.
---

cfquery name="staff" datasource="yme" dbtype="ODBC"
SELECT *
FROM staff
ORDER BY title
/cfquery

!---
//  Now onto the funky JavaScript
---
script language="JavaScript"

!---
//  This function is kinda like creating our own object like thing,
anyway it's an object
//  called anyStaff, which has three properties.  I can use it as
such...
//  anyStaff.ID = 1
//  anyStaff.title = 'Tony'
//  anyStaff.departmentID = 6
---

function anyStaff(ID,title,departmentID) {
this.ID = ID;
this.title = title;
this.departmentID = departmentID;
}

cfoutput
!---
//  We are now setting myStaff to be an array of the anyStaff object we
defined above,
//  therefore we can now go...
//  myStaff[0].ID = 1
//  myStaff[0].title = 'bengy'
//  etc. etc. for each member of staff we have
---
var maxStaff = #staff.RecordCount#;
myStaff = new Array(maxStaff);
/cfoutput

!---
//  And this is the bit that loads up the array,
---
cfset counter = 0
cfoutput query="staff"
myStaff[#counter#] = new
anyStaff('#ID#','#title#','#departmentID#');
 cfset counter = counter + 1
/cfoutput
!---
//  The best way to see what happened is to view the source code
created, which should look something like...
//  myStaff[0] = new anyStaff('1','Bill','1');
//  myStaff[1] = new anyStaff('2','Colin','1');
//  myStaff[2] = new anyStaff('3','Dave','2');
//  myStaff[3] = new anyStaff('4','Eve','3');
//  myStaff[4] = new anyStaff('5','Fiona','2');
//  myStaff[5] = new anyStaff('6','George','3');
//  myStaff[6] = new anyStaff('7','Helen','1');
//  myStaff[7] = new anyStaff('8','Ian','3');
---


!---
//  This function does all the hard work, when someone changes the
selection
//  in the department box this function is called.  To start with it
empties
//  out the staff select box, then it attempts to re-populate it.  It
starts
//  with adding two default lines, and then loops though all the
myStaff
//  objects we created above, checking to see if their departmentID
matches
//  the ID given to use from the department select box.
---
function changeStaff() {
  //Empty out the staff list box.
  document.formName.dropdown2.length = 0;
  //Get the current department ID value.
  var departmentID =
document.formName.dropdown1.options[document.formName.dropdown1.select
edIndex].value;
  //Add the 2 default lines.
  document.formName.dropdown2.options[0] = new Option('Select a staff
member',-99);
  document.formName.dropdown2.options[1] = new
Option('--',-99);
  //Set the counter up to add the rest of the recrods.
  var counter = 2;
  //Now loop through the staff to find the people who belong in this
department.
  for (var i = 0; i  maxStaff;i++) {
  //If this member of staffs departmentID matches the currently
selected department ID
  //then we add them
  if (myStaff[i].departmentID == 

RE: dynamically updating one select list [code example]

2000-08-11 Thread Daniel Kemp

Here's the second file dynamicSelect.cfm.
Sorry 'bout the wrap.


-8-8-8-8-8-8-

!---
//  Title:Dynamic Select Example
//  Created:  11th August 2000
//  By:   Daniel Kemp
---

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

html
head
titleUntitled/title

!--
//  Here we get all the info we need from the databases
---

!--- These are my two tables, the first one; departments has the
following fields...
//  id  (int)  The unique id of each department.
//  title   (varchar)  The title of each department.
//
//  The contents look somewhat like
//
//id  | title
//  --|-
// 1  | Development
// 2  | Resources
//   3  | Sales
---

cfquery name="departments" datasource="yme" dbtype="ODBC"
  SELECT *
  FROM departments
  ORDER BY title
/cfquery

!--- The second; staff has the following fields...
//  id(int)  The unique id of each member of staff
//  departmentID  (int)  The department they are in
//  title (varchar)  The staff members name
//
//  The contents look somewhat like
//
//  id  | departmentID | title
//--|--
//   1  |  1   | Bill
//   2  |  1   | Colin
//   3  |  2   | Dave
//   4  |  3   | Eve
//   5  |  2   | Fiona
//   6  |  3   | George
//   7  |  1   | Helen
//   8  |  3   | Ian
//
//  Notice in this case I have more then one member of staff in each
department, this is
//  to open up the uses of this JavaScript to more people, in Terri's
case there's only
//  one default person in each department.
---
cfquery name="staff" datasource="remix" dbtype="ODBC"
SELECT *
FROM staff
ORDER BY title
/cfquery

!---
//  Now onto the funky JavaScript
---
script language="JavaScript"

!---
//  This function is kinda like creating our own object like thing,
anyway it's an object
//  called anyStaff, which has three properties.  I can use it as
such...
//  anyStaff.ID = 1
//  anyStaff.title = 'Tony'
//  anyStaff.departmentID = 6
---

function anyStaff(ID,title,departmentID) {
this.ID = ID;
this.title = title;
this.departmentID = departmentID;
}

cfoutput
!---
//  We are now setting myStaff to be an array of the anyStaff object we
defined above,
//  therefore we can now go...
//  myStaff[0].ID = 1
//  myStaff[0].title = 'bengy'
//  etc. etc. for each member of staff we have
---
var maxStaff = #staff.RecordCount#;
myStaff = new Array(maxStaff);
/cfoutput

!---
//  And this is the bit that loads up the array,
---
cfset counter = 0
cfoutput query="staff"
myStaff[#counter#] = new
anyStaff('#ID#','#title#','#departmentID#');
 cfset counter = counter + 1
/cfoutput
!---
//  The best way to see what happened is to view the source code
created, which should look something like...
//  myStaff[0] = new anyStaff('1','Bill','1');
//  myStaff[1] = new anyStaff('2','Colin','1');
//  myStaff[2] = new anyStaff('3','Dave','2');
//  myStaff[3] = new anyStaff('4','Eve','3');
//  myStaff[4] = new anyStaff('5','Fiona','2');
//  myStaff[5] = new anyStaff('6','George','3');
//  myStaff[6] = new anyStaff('7','Helen','1');
//  myStaff[7] = new anyStaff('8','Ian','3');
---


!---
//  This function does all the hard work, when someone changes the
selection in the department box
//  this function is called.  To start with it deselects all the items
in the dropdown2 box, then it
//  Then it loops though all the list of staff members, finding out if
they belong to that department.
//  Using the myStaff objects we created above, checking to see if
their departmentID matches the ID
//  given to use from the department select box, if so make that item
number selected.  We use a counter
//  to keep track of how far we are through the list.
---
function changeStaff() {
//  Deselects all the items
for (var i = 0; i  maxStaff;i++) {
document.formName.dropdown2.options[i].selected = 
false;
}
//  Get the current department ID value.
var departmentID =
document.formName.dropdown1.options[document.formName.dropdown1.select
edIndex].value;
var counter = 0;
//  Now loop through the staff to find the people who 
belong in this
department.
for (var i = 0; i  maxStaff;i++) {
//  If this member of staffs 

Framesets and URL variables

2000-08-11 Thread sebastian palmigiani


I want to pass a URL variable from a non-frame page to a frameset.

Can all the different pages or frames in the frameset have access to that
URL variable?

Sebastian

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



randrange() function

2000-08-11 Thread Bud

Hi. This one is weird, unless there's something I've missed somewhere.

I have this code:
cfset pass = randrange(1736483927,9039930393)

It returned this number:
1430463369

Shouldn't the number returned always be in the range specified? Is 
there a limit as to the size of the number this works on or something?

Thanks,
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
--
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: Framesets and URL variables

2000-08-11 Thread DeVoil, Nick


 I want to pass a URL variable from a non-frame page to a frameset.
 
 Can all the different pages or frames in the frameset have access to that
 URL variable?

Not by default, but you can pass them straight through the frameset into the
individual pages/frames via the FRAME SRC= attribute.

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.



[ot]Ouch at allaire.com

2000-08-11 Thread JustinMacCarthy

All of www.allaire.com down 


C:\ping www.allaire.com

Pinging allaire.com [205.181.25.11] with 32 bytes of data:

Reply from 4.0.5.74: TTL expired in transit.
Request timed out.
Request timed out.
Request timed out.


~J

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



Database problems

2000-08-11 Thread John Allred

I have a strange problem with inserts in an Access table. I can't seem
to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION.
Either method, without a CFTRANSACTION, will successfully insert a
record in my table. But as soon as I try to use CFTRANSACTION, so I can
get the ID of the record just inserted and CFLOCATION to the entry form,
all I do is increment the database ID, but don't insert any data.

Can anyone hazard a guess what's causing this? I've read everything I
can get my hands on, and I can't seem to figure it out.

Thanks,
--John
--
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.



Oracle Date Time

2000-08-11 Thread Scott Mulholland

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

I found this query to return the date W/ a time value in Oracle in the
forums.  This seems to be the only way to get it to retrieve a time value
for me:
 
cfquery name="Get_DT" datasource="My_DS"
select to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE
from DUAL
/cfquery
 
This works as i needed it to, but my problem is now updating that value in
another table
 
cfquery name="Get_DT" datasource="My_DS"
UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#'

/cfquery
 
This gives me an error stating it is an invalid date.  Any ideas on how to
accomplish this??
 
Thanks,
Scott 

--_=_NextPart_001_01C0038B.D2275F00
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"


META content="MSHTML 5.50.4134.600" name=GENERATOR/HEAD
BODY
DIVFONT face=Arial size=2SPAN class=700385911-11082000I found this query 
to return the date W/ a time value in Oracle in the forums.nbsp; This seems to 
be the only way to get it to retrieve a time value for me:/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;cfquery 
name="Get_DT" datasource="My_DS"gt;/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000select 
to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000from 
DUAL/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000lt;/cfquerygt;/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000This works as i 
needed it to, but my problem is nownbsp;updating that value in another 
table/SPAN/FONT/DIV
DIVFONT face=Arial size=2/FONTnbsp;/DIV
DIVFONT face=Arial size=2
DIVFONT face=Arial size=2SPAN class=700385911-11082000lt;cfquery 
name="Get_DT" datasource="My_DS"gt;/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000UPDATE MyTable set 
LAST_UPDATE = '#Get_DT.LAST_UPDATE#'/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000lt;/cfquerygt;/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=700385911-11082000This gives me an 
error stating it is an invalid date.nbsp; Any ideas on how to accomplish 
this??/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN 
class=700385911-11082000Thanks,/SPAN/FONT/DIV/FONT/DIV
DIVFONT face=Arial size=2Scott /FONT/DIV/BODY/HTML

--_=_NextPart_001_01C0038B.D2275F00--
--
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:

2000-08-11 Thread Angél Stewart

hee hee hee hee
I love this list.
=))

-Gel

- Original Message - 
From: Reynolds, Adam [EMAIL PROTECTED]


 Sorry
 Adam Reynolds
 
  --
  From: Chapman, Katrina[SMTP:[EMAIL PROTECTED]]

  Let's not get pissy Adam.


--
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]Ouch at allaire.com

2000-08-11 Thread Ken Wilson

Hmmm, wonder if the renewal process went crazy?


Registrant:
Allaire Corporation (ALLAIRE-DOM)
One Alewife Center
Cambridge, MA 02140
US

Domain Name: ALLAIRE.COM

Administrative Contact, Technical Contact, Zone Contact, Billing Contact:
Master, Web (MW523-ORG) [EMAIL PROTECTED]
Allaire Corporation
One Alewife Center
Cambridge , MA 02140
US
617-761-2000
Fax- 617-761-2001

Record last updated on 31-Jan-2000.
Record expires on 12-Aug-2000.   --
Record created on 11-Aug-1994.
Database last updated on 10-Aug-2000 23:09:12 EDT.

Domain servers in listed order:

DNSAUTH1.SYS.GTEI.NET 4.2.49.2
DNSAUTH2.SYS.GTEI.NET 4.2.49.3
DNSAUTH3.SYS.GTEI.NET 4.2.49.4


 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 7:45 AM
 To: [cftalk]
 Subject: [ot]Ouch at allaire.com


 All of www.allaire.com down 


 C:\ping www.allaire.com

 Pinging allaire.com [205.181.25.11] with 32 bytes of data:

 Reply from 4.0.5.74: TTL expired in transit.
 Request timed out.
 Request timed out.
 Request timed out.


 ~J

 --
 
 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: Oracle Date Time

2000-08-11 Thread DeVoil, Nick


 I found this query to return the date W/ a time value in Oracle in the
 forums.  This seems to be the only way to get it to retrieve a time value
 for me:
  
 cfquery name="Get_DT" datasource="My_DS"
 select to_char(SYSDATE, 'DD-MM- HH24:MI:SS') LAST_UPDATE
 from DUAL
 /cfquery
  
 This works as i needed it to, but my problem is now updating that value in
 another table
  
 cfquery name="Get_DT" datasource="My_DS"
 UPDATE MyTable set LAST_UPDATE = '#Get_DT.LAST_UPDATE#'
 
 /cfquery
  
 This gives me an error stating it is an invalid date.  Any ideas on how to
 accomplish this??


Your CF variable #Get_DT.LAST_UPDATE# is a string. You need to convert it
back into a date for Oracle using TO_DATE() in your UPDATE statement.

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: [ot]Ouch at allaire.com

2000-08-11 Thread Gregory Gooden (Annex)


OY! That's aweful!

I've taken the liberty to post a credit card payment to their domain
renewal.. :)

Gregory

--- 
annex.com, Inc. - http://www.annex.com/ 
--- 
- If you EcoBuild it, they will come. - 
- http://www.ecobuilder.com/ - 
--- 


 -Original Message-
 From: Ken Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 5:15 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [ot]Ouch at allaire.com
 
 
 Hmmm, wonder if the renewal process went crazy?
 
 
 Registrant:
 Allaire Corporation (ALLAIRE-DOM)
 One Alewife Center
 Cambridge, MA 02140
 US
 
 Domain Name: ALLAIRE.COM
 
 Administrative Contact, Technical Contact, Zone Contact, 
 Billing Contact:
 Master, Web (MW523-ORG) [EMAIL PROTECTED]
 Allaire Corporation
 One Alewife Center
 Cambridge , MA 02140
 US
 617-761-2000
 Fax- 617-761-2001
 
 Record last updated on 31-Jan-2000.
 Record expires on 12-Aug-2000.   --
 Record created on 11-Aug-1994.
 Database last updated on 10-Aug-2000 23:09:12 EDT.
 
 Domain servers in listed order:
 
 DNSAUTH1.SYS.GTEI.NET 4.2.49.2
 DNSAUTH2.SYS.GTEI.NET 4.2.49.3
 DNSAUTH3.SYS.GTEI.NET 4.2.49.4
 
 
  -Original Message-
  From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
  Sent: Friday, August 11, 2000 7:45 AM
  To: [cftalk]
  Subject: [ot]Ouch at allaire.com
 
 
  All of www.allaire.com down 
 
 
  C:\ping www.allaire.com
 
  Pinging allaire.com [205.181.25.11] with 32 bytes of data:
 
  Reply from 4.0.5.74: TTL expired in transit.
  Request timed out.
  Request timed out.
  Request timed out.
 
 
  ~J
 
  --
  
  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=list
s/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.



HELP: SQL Server Problems!

2000-08-11 Thread Paul Johnston

I am trying to find out where the Enterprise Manager and Query Analyzer is
for SQL Server.  The company at the moment uses PC Anywhere to log in to the
machine and then work from there, but I want to be able to write SP's from
here.

We have the SQL Servr 7 disks, but I can't find where on those it is.

HELP

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: Double Dimesion ArraySorting

2000-08-11 Thread JustinMacCarthy

Build a structure (associative array) where you have
 the value you are trying to sort (array[x][5]) as the keyname
and the array[x]  as the keyvalue

* untested code ahead ***

cfset myStruct = StructNew()
cfloop from=1 to=ArrayLen(myarray) index=idx
cfset result = StructInsert(myStruct, array[idx][5], array[idx])
/cfloop

!--- Sort the array keynames 
cfset KeyNames = StructKeyArray(myStruct)
cfset SortedKeys =  ArraySort(KeyNames, "textnocase", "desc") !--- or
what ever sort you want ---

cfset MySortedArray = ArrayNew(1)
cfloop from=1 to=arraylen(SortedKeys) index=idx
cfset MySortedArray[idx] = StructFind(myStruct,SortedKeys[idx])
/cfloop


or something like that , let me know how you get on 

~Justin

- Original Message -
From: "Vincent" [EMAIL PROTECTED]
To: "cftalk" [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 11:58 AM
Subject: Double Dimesion ArraySorting


 hi,
 I was wondering  how do I go about sorting a double dimension
array
 ?

 Consider the second dimension to be ranging from 1-10.

 -- myarray[x][10]


 Now if I want to sort all the arrays in ascending order by the array[x][5]
 So that the order of the data myarray[x][1] -- myarray[x][10] would
 remain
 intact...

 ...how do I go about doing something like that  ?


 Thanks
 vin

 --

 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: Framesets and URL variables

2000-08-11 Thread James Taavon

Sebastian,

I am doing what you want.

FRAME.CFM (FILE CONTAINING FRAMESETS)

cfoutput query="User" 
frame name="menu" src="menu.cfm?user=#Trim(user.username)#"
frameborder="0" scrolling="no"
frame name="contents"
src="contents.cfm?user=#Trim(user.username)#" frameborder="0"
scrolling="auto"
/cfoutput


CONTENTS.CFM (ONE OF THE FILES CONTAINING THE PASSED URL VARIABLE)

cfquery name="User" datasource="lsars"
select * from taavon.users
where username= '#url.user#'
/cfquery


James


sebastian palmigiani wrote:
 
 I want to pass a URL variable from a non-frame page to a frameset.
 
 Can all the different pages or frames in the frameset have access to that
 URL variable?
 
 Sebastian
 
 --
 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: dynamically updating one select list based upon the selection in another

2000-08-11 Thread Terri Stocke

Thanks, Truman!  I'll check those out and give them a try...


Original Message Follows
From: "Truman Esmond III" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: dynamically updating one select list based upon the selection 
in another
Date: Thu, 10 Aug 2000 13:49:16 -0600

I would recommend Nate Weiss' CF_TwoSelectsRelated or CF_ThreeSelectsRelated
tags which perform the functions you request; your preselections will be
based on their order in the query rather than an absolute selection, but I
think they'll do what your looking for.
Truman

-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:27 PM
To: [EMAIL PROTECTED]
Subject: dynamically updating one select list based upon the selection
in another


I have an update form in which the the user can choose an option from a
select list.  When this form is initially displayed, the current info from
the database is automatically selected.  This field happens to contain the
names of various departments in our division.
Each department has a default individual assigned to it (meaning that when a
department is selected from the list, the information submitted will
automatically be routed to the default person for that group).

The field below that is a dynamically populated select list of all of the
people in our division. If a user so chooses, they can override the default
person assigned to a group, and specify someone else from this list.

Now, here's what I want to do. When the form is first displayed, I want both
the department select list AND the people list to have the current value in
the db displayed (i.e. the department it will be routed to and the default
contact person's name in that department).
If, however, the user changes the name of the department to route to, I
would like the list below it to automatically then select the default
contact person's name for that department.

In a nutshell, the first list will drive what is selected in the second
list, but I want the second list to be independent (the first list will not
change what is selected if I make a different selection in the second list).

I'm assuming I will have to (ugh) use a javascript for this?  Admittedly, I
am neither a javascript guru nor a coldfusion guru. Can anyone provide me
with some direction on this?

Thanks in advance!
Terri

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Can CF be run on a machine which is also running Service Pack 6 Alpha?

2000-08-11 Thread Robert Everland

I havem't had any problems with CFCONtent and Sp6a. Maybe it was fixed in
4.5.1.

Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 4:33 AM
To: [EMAIL PROTECTED]
Subject: RE: Can CF be run on a machine which is also running Service
Pack 6 Alpha?


 The problem is that there is a tag or two that don't work on SP 6. I can't
 remember which one(s), but you may be able to find it on the Allaire site.
 That's where I first read about the problem.

CFContent apparently has problems, and Allaire recommend going back to SP5
if you use it - I use SP6a quite happily as I (currently) don't use
CFContent at all

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: Is there a variable for a query's name?

2000-08-11 Thread David Shadovitz

Sean,
I see so much bad grammar (e.g. confusion over its/it's, your/you're)
that I assumed this was more of the same.  Oops.
-David-who-failed-to-see-the-joke

On Fri, 11 Aug 2000 01:35:22 -0700 "Sean Renet"
[EMAIL PROTECTED] writes:
 umm that was part of the joke.  I wish I could take credit for it, 
 but I
 believe is Daniel Maguire's
 - Original Message -
 From: "David Shadovitz" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, August 10, 2000 6:37 PM
 Subject: Re: Is there a variable for a query's name?
 
 
   I must be the most unarticulate person on these lists.
 
  Yes.  It's "inarticulate."
  

-David-who-did-better-on-the-English-part-of-the-SAT-than-on-the-math-par
  t-but-who-works-as-a-programmer-anyway

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
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.



CFX_ONCR_CYBERCASH

2000-08-11 Thread Frédéric LeMieux

This is a multi-part message in MIME format.

--=_NextPart_000_0004_01C00374.05646890
Content-Type: multipart/alternative;
boundary="=_NextPart_001_0005_01C00374.056775D0"


--=_NextPart_001_0005_01C00374.056775D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Everybody,

I downloaded the new version of CFX_ONCR_CYBERCASH (4.0) yesterday, to
evaluate it on Solaris 2.7, CF Server 4.5.1
But after I install it, and try to access the tag by calling it, each time I
get the following error:

"Unable to load the library associated with the custom tag
CFX_ONCR_CYBERCASH (/opt/coldfusion/CustomTags/cfx_oncr_cybercash.so)
Error: ld.so.1: /opt/coldfusion/bin/cfserver: fatal: relocation error: file
/opt/coldfusion/CustomTags/cfx_oncr_cybercash.so: symbol _pure_error_:
referenced symbol not found

Please check the LibraryPath entry for this tag in the custom tag database
to verify that the library file exists and is accessible by the ColdFusion
service."

Everything is fine in the CF Service. Exccept maybe for the fact that I
specified C++ as the type of CFX. Could it be Java ?

Anyone had this problem, or still has it ?

Please reply all.


Frédéric LeMieux, Chaos Programmer ([EMAIL PROTECTED])
K-OS
5505 blvd. St-Laurent
Montréal, Qc.

http://www.k-os.com

Once the music leaves yr head, it's already compromised.
  - Jack Brewer


--=_NextPart_001_0005_01C00374.056775D0
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.3105.105" name=3DGENERATOR/HEAD
BODY
DIVFONT size=3D2SPAN =
class=3D964511512-11082000Everybody,/SPAN/FONT/DIV
DIVFONT size=3D2SPAN =
class=3D964511512-11082000/SPAN/FONTnbsp;/DIV
DIVFONT size=3D2SPAN class=3D964511512-11082000nbsp;nbsp;nbsp; =
I downloaded=20
the new version of CFX_ONCR_CYBERCASH (4.0) yesterday, to evaluate it on =
Solaris=20
2.7, CF Server 4.5.1/SPAN/FONT/DIV
DIVFONT size=3D2SPAN class=3D964511512-11082000But after I install =
it, and try=20
to access the tag by calling it, e/SPAN/FONTFONT size=3D2SPAN=20
class=3D964511512-11082000ach time I get the following =
error:/SPAN/FONT/DIV
DIVFONT size=3D2SPAN =
class=3D964511512-11082000/SPAN/FONTnbsp;/DIV
DIVSPAN class=3D964511512-11082000FONT size=3D2"Unable to load the =
library=20
associated with the custom tag CFX_ONCR_CYBERCASH=20
(/opt/coldfusion/CustomTags/cfx_oncr_cybercash.so) /FONT
PFONT size=3D2Error: ld.so.1: /opt/coldfusion/bin/cfserver: fatal: =
relocation=20
error: file /opt/coldfusion/CustomTags/cfx_oncr_cybercash.so: symbol=20
_pure_error_: referenced symbol not found /FONT
PFONT size=3D2Please check the LibraryPath entry for this tag in the =
custom=20
tag database to verify that the library file exists and is accessible by =
the=20
ColdFusion service."/FONT/P
P/SPANFONT size=3D2SPAN class=3D964511512-11082000Everything is =
fine in the=20
CF Service. Exccept maybe for the fact that I specified C++ as the type =
of CFX.=20
Could it be Java ?/SPAN/FONT/P
PFONT size=3D2SPAN class=3D964511512-11082000Anyone had this =
problem, or still=20
has it ?/SPAN/FONT/P
PFONT size=3D2SPAN class=3D964511512-11082000Please reply=20
all./SPAN/FONT/P/DIV
DIVFONT size=3D2SPAN class=3D964511512-11082000nbsp;nbsp;nbsp;=20
/SPAN/FONT/DIV
DIVFONT size=3D2Fr=E9d=E9ric LeMieux, Chaos Programmer (A=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A)/FONT/DIV
DIVFONT size=3D2K-OS/FONT/DIV
DIVFONT size=3D25505 blvd. St-Laurent/FONT/DIV
DIVFONT size=3D2Montr=E9al, Qc./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2A=20
href=3D"http://www.k-os.com/"http://www.k-os.com/A/FONT/DIV
DIVFONT size=3D2/FONT/DIV
DIVFONT size=3D2Once the music leaves yr head, it's already=20
compromised./FONT/DIV
DIVFONT=20
size=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs=
p;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
- Jack Brewer/FONT/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_001_0005_01C00374.056775D0--

--=_NextPart_000_0004_01C00374.05646890
Content-Type: text/x-vcard;
name="=?iso-8859-1?B?RnLpZOlyaWMgTGVNaWV1eC52Y2Y=?="
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="=?iso-8859-1?B?RnLpZOlyaWMgTGVNaWV1eC52Y2Y=?="

BEGIN:VCARD
VERSION:2.1
N:LeMieux;Fr=E9d=E9ric
FN:Fr=E9d=E9ric LeMieux
ORG:K-OS;Web development
TITLE:Programmer
TEL;WORK;VOICE:(514) 495-1122
TEL;HOME;VOICE:(514) 893-7155
TEL;CELL;VOICE:(514) 893-7155
TEL;WORK;FAX:(514) 495-1342
ADR;WORK:;;5505 St-Laurent, #4210;Montr=E9al;Qu=E9bec;H2T 1S6;Canada
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:5505 St-Laurent, =
#4210=3D0D=3D0AMontr=3DE9al, Qu=3DE9bec H2T 1S6=3D0D=3D0ACanada
URL:
URL:http://www.k-os.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:2622T125350Z

RE: Error Handling

2000-08-11 Thread Miriam Hirschman

I looked a bit into that , but  I waant a message only for that error, and
it doesn't seem like I can tell CFTRY to only catch the cfsearch error.
Please tell me if I am wrong.

-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Error Handling


Hello Miriam.  While I'm not too familiar with the CFSearch tag, I would
imagine that the CFTRY/CFCATCH could pick up any such error and then you
have control over how you'd handle it.  Look up the CFTRY/CFCATCH
statements, use those and tell me how it works out.

Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 08/09 8:42 AM 
I am using CFSearch.  If the user enters "and","or", "'" then I get a CF
error.  I would like to catch only this error and display a message to the
user telling them that they entered invalid search criteria.

Thanks,

 ---miriam



--
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: VERY SAD (was CFGRID onvalidate=???)

2000-08-11 Thread Duane Boudreau

 As Dave said, in a controlled environment they work fine, with
 our B2B apps
 the major concern is ease of use and the grids add some good functionality
 with very little overheadif you know who's gonna use em then use em :)


The key there is controlled environments. If I have conrtol over the
environment, the user has to be using IE 4+ and then I, personally, prefer
to use IFRAME's. More flexibility and control over the data presentation
and input. Using style sheets and IFRAME you can put together a pretty
nice display.

Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258




 Stew


 It got to the point that our clients "requested" (AKA ordered)
 us to remove
 them from their sites. There customers were complaining quite a bit. We
 removed them and never looked back. In any instance now where we would
 consider using a CFGRID - usually in an admin section, we use
 IFRAME and
 warn users that IE is required.

 I am in the process of investigating ways of using flash instead of
 IFRAME.

--
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: new worried (subquery)

2000-08-11 Thread megan sherman

Thanks for your help so far. Anthony Geoghegan was very helpful steering
me in the right direction. I am trying to use a subquery in combination
with a session variable to keep track of a customer's choices of malas
(worry beads) on a web site that I would someday like to put on line. I
guess it is a crude shopping cart. Anyway, I'll deal with the session
variable stuff later. Right now I'm having trouble with the subquery. I
am using two simple tables filled with a bunch of dummy values (maybe
that's part of my problem). A file called mqapp_our_select.cfm located
at http://www.digitalnature.net/hameed/mqapp_our_select.cfm is supposed
to display a selection of wonderful malas. Right now the gifs are
colored squares. When you click on one of them, you invoke the next
template called mqapp_our_list.cfm. The query looks like this:
CFQUERY DATASOURCE="data" NAME="mq_our"
SELECT prod_num,bead
FROM mq_our
WHERE malaID IN (SELECT malaID FROM sessions
  WHERE session=#session_name#)
ORDER BY prod_num
/CFQUERY
Instead of a session variable for now (to keep things simple) I'm just
using a string: abc. In the second table called sessions I have some
instances where abc appears in the session column. I want the query to
pull the corresponding "malaID's" from the sessions table and use them
in the mq_our table. But I get an error:
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
1.
HELP! What am I doing wrong?
For completeness the full error code can be viewed at
http://www.digitalnature.net/hameed/error.txt. The application file can
be viewed at http://www.digitalnature.net/hameed/application.txt. The
code for mqapp_our_select.cfm can be viewed at
http://www.digitalnature.net/hameed/mqapp_our_select.txt. The code for
mqapp_our_list.cfm can be viewed at
http://www.digitalnature.net/hameed/mqapp_our_list.txt. The mq_our table
can be viewed at http://www.digitalnature.net/hameed/mq_our_1.html. And
the sessions table can be viewed at
http://www.digitalnature.net/hameed/sessions_1.html.
If you see anything else in all that code that needs fixing please let
me know!
Thank you, kind people of cf-talk for any help you can offer!
Megan

--
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]Ouch at allaire.com

2000-08-11 Thread Ann Harrell

Provider problems

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 6:45 AM
To: [cftalk]
Subject: [ot]Ouch at allaire.com


All of www.allaire.com down 


C:\ping www.allaire.com

Pinging allaire.com [205.181.25.11] with 32 bytes of data:

Reply from 4.0.5.74: TTL expired in transit.
Request timed out.
Request timed out.
Request timed out.


~J


--
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]Ouch at allaire.com

2000-08-11 Thread Ann Harrell

back up now

-Original Message-
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 8:43 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [ot]Ouch at allaire.com


Provider problems

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 6:45 AM
To: [cftalk]
Subject: [ot]Ouch at allaire.com


All of www.allaire.com down 


C:\ping www.allaire.com

Pinging allaire.com [205.181.25.11] with 32 bytes of data:

Reply from 4.0.5.74: TTL expired in transit.
Request timed out.
Request timed out.
Request timed out.


~J


--
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: [OT] REQ testimonials from SAG Electronics customers.

2000-08-11 Thread paul smith

We've had very good experience with SAG.
The dual Pentium 90(!) we got from SAG
in 1995 is still plugging along.

best,  paul

At 01:13 AM 8/11/00 -0700, you wrote:
Hello,

We're thinking about spending $$ with http://www.sagelectronics.com/. 2U
rack servers.
Testimonials are encouraged, off list if you prefer.

Thanks,

Rick
[EMAIL PROTECTED]


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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: new worried (subquery)

2000-08-11 Thread DeVoil, Nick


 CFQUERY DATASOURCE="data" NAME="mq_our"
 SELECT prod_num,bead
 FROM mq_our
 WHERE malaID IN (SELECT malaID FROM sessions
   WHERE session=#session_name#)
 ORDER BY prod_num
 /CFQUERY

Megan,

You need apostrophes around #session_name#.
I don't know if that will solve the problem though!

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.



From .exe to .dll

2000-08-11 Thread Mark Armendariz

I am looking for resources regarding converting a dos based program into a
dll that will run well from cold fusion. can anyone point me in the right
direction?

Thanks


Mark Armendariz
Righteous Desgin
www.sorighteous.com
[EMAIL PROTECTED]



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

2000-08-11 Thread dscheide

Hey,
I've got several scripts that grab content from other sites using CFHTTP. 
I've heard that i should be using CFLOCK around my calls to CFHTTP. What 
options should i specify? just:

cflock timeOut=120
cfhttp ...
/cflock

Or do i need to specify the scope or something?

btw, Using CF4.5.1 NT4 IIS

Thanks
Dave
--
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: JavaScript CSS Detector

2000-08-11 Thread Robert Forsyth

Sorry for the off topic...

I use cf_browser to select browser and load different Style Sheets based on browser 
(thanks Netscape).

I now have to do a co-branded "outside our server farm" web page that I still need to 
detect and load the different CSS's.  I searched javascipts.com (which sadly is no 
longer CF) and found nothing.  Does anyone have a snippets or other placers to check?

Robert Forsyth
Director of Web Operations
Irides, LLC
Phone: 202-364-7831
  Fax: 202-364-2481

--
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: From .exe to .dll

2000-08-11 Thread JustinMacCarthy

Have you got the source code ??? What language was it written in? What does
it do?

~Justin

- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: "Cf-Talk" [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 2:55 PM
Subject: From .exe to .dll


 I am looking for resources regarding converting a dos based program into a
 dll that will run well from cold fusion. can anyone point me in the right
 direction?

 Thanks


 Mark Armendariz
 Righteous Desgin
 www.sorighteous.com
 [EMAIL PROTECTED]



 --

 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: VERY SAD (was CFGRID onvalidate=???)

2000-08-11 Thread Jeremy Allen

How about..

http://www.dansteinman.com/dynduo/

For one such API :)


-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:03 AM
To: [EMAIL PROTECTED]
Subject: RE: VERY SAD (was CFGRID onvalidate="???")


It got to the point that our clients "requested" (AKA ordered) us to remove
them from their sites. There customers were complaining quite a bit. We
removed them and never looked back. In any instance now where we would
consider using a CFGRID - usually in an admin section, we use IFRAME and
warn users that IE is required.

Heh, heh, heh. Instead of restricting the browsers that were having problems
you restrict everyone not using Internet Explorer. Don't get me wrong, in
controlled situations, we only design for Internet Explorer 4 and up, but it
seems like you're arguing 6 in one, half a dozen in the other.

I still maintain that we've had no problems with the "stability" of the
Allaire Java applets. We've used them in quite a few apps, though only in
Intranet/Extranet/Administration apps, however, because we didn't feel the
common user was comfortable with (or capable of) installing Java classes on
their machine.

I am in the process of investigating ways of using flash instead of
IFRAME.

iframe and ilayer are remarkably similar in terms of functionality,
although they require completely different attributes and are referenced
differently by JavaScript. However, if you developed a relatively simple
JavaScript API, you can make alter the control the iframe/ilayer
transparently. Take a look at O'Reilly's _DHTML: The Definitive Guide_ for a
better explanation and an API from which to get started.

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


--
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: SQL Server Problems!

2000-08-11 Thread Benjamin S. Rogers

If I remember correctly, you'll want to call up the SQL Server 7 CD. If it
doesn't autorun, then you'll have to find the executable that the autorun is
trying to launch. Run the installation (choose a "Custom" install if that is
an option) and you'll receive a few options with check boxes. Uncheck the
SQL Server option and leave the SQL Server client tools option checked.
There's a couple other options there as well, but I can't remember what they
are and whether or not you'll need them to run the tools.

Hope this helps. I'm sorry I can't be more specific, but I don't have the CD
in front of me right now.

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

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 8:21 AM
To: Cf-Talk
Subject: HELP: SQL Server Problems!


I am trying to find out where the Enterprise Manager and Query Analyzer is
for SQL Server.  The company at the moment uses PC Anywhere to log in to the
machine and then work from there, but I want to be able to write SP's from
here.

We have the SQL Servr 7 disks, but I can't find where on those it is.

HELP

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: randrange() function

2000-08-11 Thread Seth Petry-Johnson

 I have this code:
 cfset pass = randrange(1736483927,9039930393)

 It returned this number:
 1430463369

 Shouldn't the number returned always be in the range specified? Is
 there a limit as to the size of the number this works on or something?

Integers in CF are limited to 32 bit numbers (thanks to M. Dinowitz for his
FA article on this), which means that the largest integer value that CF
understands is 2,147,483,647.  This is a bit smaller than 9,039,930,393.  My
guess is that the large number you're passing to randRange() is causing a
bit of internal confusion.

I wrote a little test.  I ran a loop 1000 times, each iteration generating a
random number using the randRange() parameters you mentioned above.  On 5
separate page loads, ALL 1000 numbers were less than 1,736,483,927. If I
dropped the second parameter to a value within the allowed range, then
randRange() performed as expected.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates

2,147,483,648 and 2,147,483,647
1,736,483,927
9,039,930,393
I remember reading somewhere that CF had

--
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: Error Handling

2000-08-11 Thread David Shadovitz

Miriam,

If you put only the CFSEARCH code in the CFTRY block, only errors from
that code will activate the error handler.  If you need even finer
resolution than that, you could check the actual error message
(CFCATCH.Details, I think).

-David

On Fri, 11 Aug 2000 09:20:59 -0400 "Miriam Hirschman"
[EMAIL PROTECTED] writes:
 I looked a bit into that , but  I waant a message only for that 
 error, and
 it doesn't seem like I can tell CFTRY to only catch the cfsearch 
 error.
 Please tell me if I am wrong.
 
 -Original Message-
 From: Gregory Harris [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 09, 2000 12:59 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Error Handling
 
 
 Hello Miriam.  While I'm not too familiar with the CFSearch tag, I 
 would
 imagine that the CFTRY/CFCATCH could pick up any such error and then 
 you
 have control over how you'd handle it.  Look up the CFTRY/CFCATCH
 statements, use those and tell me how it works out.
 
 Gregory Harris

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
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: JavaScript CSS Detector

2000-08-11 Thread JustinMacCarthy

Use the Browers Sniffer at

http://developer.iplanet.com/docs/examples/javascript/browser_type.html

And dynamically write the css sheet

document.write("style ")

~JustinMacCarthy

- Original Message -
From: "Robert Forsyth" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 3:01 PM
Subject: OT: JavaScript CSS Detector


 Sorry for the off topic...

 I use cf_browser to select browser and load different Style Sheets based
on browser (thanks Netscape).

 I now have to do a co-branded "outside our server farm" web page that I
still need to detect and load the different CSS's.  I searched
javascipts.com (which sadly is no longer CF) and found nothing.  Does anyone
have a snippets or other placers to check?

 Robert Forsyth
 Director of Web Operations
 Irides, LLC
 Phone: 202-364-7831
   Fax: 202-364-2481

 --

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



--
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: From .exe to .dll

2000-08-11 Thread Mark Armendariz

YEs, we have the source code.  It's actually a proprietary application made
by our own programmers to generate a password for our software.  I believe
it's written in C.  The functions of the program are fairly basic.  It asks
about 10 questions (INPUT), and gives one answer depending on the input
(OUTPUT).

Our programmers are very capable.  I just need to know where to look so i
can ask them for this knowledgeably and answer any questions they may have
from the get go.  Or at least know ehre to send them for the answers they
need.  I would imagine we just need a means of giving the dll input and then
getting the output via a variable.

Thanks..

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:01 AM
To: [EMAIL PROTECTED]
Subject: Re: From .exe to .dll


Have you got the source code ??? What language was it written in? What does
it do?

~Justin

- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: "Cf-Talk" [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 2:55 PM
Subject: From .exe to .dll


 I am looking for resources regarding converting a dos based program into a
 dll that will run well from cold fusion. can anyone point me in the right
 direction?

 Thanks


 Mark Armendariz
 Righteous Desgin
 www.sorighteous.com
 [EMAIL PROTECTED]



 --

 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: VERY SAD (was CFGRID onvalidate=???)

2000-08-11 Thread Benjamin S. Rogers

How about..

http://www.dansteinman.com/dynduo/

For one such API :)

And another:

http://www.siteexperts.com/dhtmllib/page1.asp

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
--
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: From .exe to .dll

2000-08-11 Thread JustinMacCarthy

If you have the source code I would recommend wrapping the code in a
cfx_tag. It's very simple.

For example of cfx source code in C/C++
Have a look at the excellent www.intrafoundation.com . There is also some
info in Ben's advanced book and plenty of help(!?!!?) on this list :-)

If all that fails you chould use cfexecute ( or CFX_consoleCommand @
intrafoundation.com ) to capture the input from the dos program..


~Justin MacCarthy




- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 3:23 PM
Subject: RE: From .exe to .dll


 YEs, we have the source code.  It's actually a proprietary application
made
 by our own programmers to generate a password for our software.  I believe
 it's written in C.  The functions of the program are fairly basic.  It
asks
 about 10 questions (INPUT), and gives one answer depending on the input
 (OUTPUT).

 Our programmers are very capable.  I just need to know where to look so i
 can ask them for this knowledgeably and answer any questions they may have
 from the get go.  Or at least know ehre to send them for the answers they
 need.  I would imagine we just need a means of giving the dll input and
then
 getting the output via a variable.

 Thanks..

 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 10:01 AM
 To: [EMAIL PROTECTED]
 Subject: Re: From .exe to .dll


 Have you got the source code ??? What language was it written in? What
does
 it do?

 ~Justin

 - Original Message -
 From: "Mark Armendariz" [EMAIL PROTECTED]
 To: "Cf-Talk" [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 2:55 PM
 Subject: From .exe to .dll


  I am looking for resources regarding converting a dos based program into
a
  dll that will run well from cold fusion. can anyone point me in the
right
  direction?
 
  Thanks
 
 
  Mark Armendariz
  Righteous Desgin
  www.sorighteous.com
  [EMAIL PROTECTED]
 
 
 

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



Newbie: JavaScript var and CF

2000-08-11 Thread Mike Deane

Throws "Cannot evaluate" CF error.  How do I pass a JavaScript created
variable (in alert) back to CF on the same page.

script language="JavaScript"
!--
function Overwrite()
{
var x=window.confirm("Skill levels have been
already assigned for this user. By clicking OK, you will *overwrite* all
existing skill assignments. Click CANCEL to use an existing profile of
this user.");
if (x)
return 1;
else
return 0;
}
// --
/script


cfoutput#Overwrite()#/cfoutput  !--- Throws an error ---
--
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] REQ testimonials from SAG Electronics customers.

2000-08-11 Thread Chuck Hergenroeder

Have spent many $$ with SAG and have not had any real problems.

Their systems are well built with quality components and their support is top notch.  
The only complaint I do have is that they do not have 24hour support (at least I don't 
think they do?). I only had to call support one time, 30 second hold time and I had 
the new hard drive in my hands by 9AM the next day.



 -- Original Message --
From: "Mooner Ent" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Fri, 11 Aug 2000 01:13:05 -0700

Hello,

We're thinking about spending $$ with http://www.sagelectronics.com/. 2U
rack servers.
Testimonials are encouraged, off list if you prefer.

Thanks,

Rick
[EMAIL PROTECTED]



__

Do You Yahoo!?

Talk to your friends online with Yahoo! Messenger.

http://im.yahoo.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.



Custom CF_ Tags

2000-08-11 Thread Chad

Im just starting to read the books about Custom tags, and im wondering if 
the file in the C:\CFUSION\CustomTags folder has to contain the actual code 
of the tag?

Or is the file there just to name the tag??

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.



Re: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Gene Kraybill

Hi John,

You could write a few lines of CF to convert the CSV file into a query (using 
CFHTTP), then cfoutput the query and insert each record into a db table. If there's a 
way to use a CSV file as a datasource, I'm not aware of it. Even if there is a way, 
you'd 
be better off transferring the data to a proper db, with the speed advantages of 
indexes 
and other db features. 

Gene Kraybill
LPW  Associates

John McGown wrote:

 I have a customer that is a car dealership.  They want to put their car
 inventory online.
 The company that makes their inventory database tells me that the data store
 is not ODBC compliant, but that they could output a CSV text file that they
 will auto-FTP to our servers in the middle of the night.  Not exactly the
 most elegant solution, but it beats entering car data manually.  :)
 
 Can I create an ODBC connection in the CF Administrator to use a CSV text
 file as a data source? 
--
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: Newbie: Sessions

2000-08-11 Thread Art Broussard

Thanks all for the help!

Now if you can help me with this. I turn on session manegment in my 
application.cfm file and set the ime out for 10 min. I have a person enter 
username and password. If correct I set the session.login to yes. Now if 
they don't use the site for longer then 10 min., what happenes. Do I need to 
do some kind of a check on the session.login and then send them to the login 
page or what? If so, would I do it in the application.cfm page

I just quit drinking caffeine so my brain is a little fuzzy, large, swollen 


Thanks,

Art


Hello,

Argument for using session variables:

We have a company directory with free listings for members of the natural
food products industry (very recently released). We will give out login and
passwords to companies (upon approval of their company as verifiable) so
that they can either change information (address, phone numbers etc) and
also so that they may "Upgrade" their listing to incorporate a lot of tools
(very similar to the Thomas Register). When a user logs in we cannot be 
sure
they are doing so from their personal home/office computer and since we do
not want to leave a variety of differently named cookies that would contain
information about the company on machines in public kiosks we decided to
manipulate this information using session variables that store database
values and some temporary values that a user may change when logged in via 
a
form.. We use the session variables because they maintain state throughout
the 15 odd screens that a user may  go through (depending on how much they
upgrade) in order to pull info user specific data from a database and from
forms which then allows the user to update their information.

This system has worked well for us. If I had to maintain any other type of
variables from page to page in my application I think this project would be
a lot less portable (right now adding a component is really easy since it 
is
very fuse box like and the session variables get set in one file which get
included in all the pages of the application.'


If you had asked me 6 months ago if I would ever use session variables I
probably would have said "NO" but this was one place I have found them very
useful.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: From .exe to .dll

2000-08-11 Thread Mark Armendariz

I appreciate the quick reply... As for the cfx.h library.  Would we just
have to compile the code with an inclusion of cfx.h or is there any changes
that would actually have to be made to the code itself?

I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on
Monday.


THANKS!!

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:39 AM
To: [EMAIL PROTECTED]
Subject: Re: From .exe to .dll


If you have the source code I would recommend wrapping the code in a
cfx_tag. It's very simple.

For example of cfx source code in C/C++
Have a look at the excellent www.intrafoundation.com . There is also some
info in Ben's advanced book and plenty of help(!?!!?) on this list :-)

If all that fails you chould use cfexecute ( or CFX_consoleCommand @
intrafoundation.com ) to capture the input from the dos program..


~Justin MacCarthy




- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 3:23 PM
Subject: RE: From .exe to .dll


 YEs, we have the source code.  It's actually a proprietary application
made
 by our own programmers to generate a password for our software.  I believe
 it's written in C.  The functions of the program are fairly basic.  It
asks
 about 10 questions (INPUT), and gives one answer depending on the input
 (OUTPUT).

 Our programmers are very capable.  I just need to know where to look so i
 can ask them for this knowledgeably and answer any questions they may have
 from the get go.  Or at least know ehre to send them for the answers they
 need.  I would imagine we just need a means of giving the dll input and
then
 getting the output via a variable.

 Thanks..

 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 10:01 AM
 To: [EMAIL PROTECTED]
 Subject: Re: From .exe to .dll


 Have you got the source code ??? What language was it written in? What
does
 it do?

 ~Justin

 - Original Message -
 From: "Mark Armendariz" [EMAIL PROTECTED]
 To: "Cf-Talk" [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 2:55 PM
 Subject: From .exe to .dll


  I am looking for resources regarding converting a dos based program into
a
  dll that will run well from cold fusion. can anyone point me in the
right
  direction?
 
  Thanks
 
 
  Mark Armendariz
  Righteous Desgin
  www.sorighteous.com
  [EMAIL PROTECTED]
 
 
 

 --
 
  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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Ryan

I think you can treat a csv file as an ODBC datasource, you
just need to have the driver for it.

RPS

--
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: Newbie: Sessions

2000-08-11 Thread Jamie Keane

The way I've done it is to include a template that on all protected pages
that checks for one of the session variables that I know should be set, and
if the check returns false, redirect the user to a re-login page.  There are
probably more efficient ways though...

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Art Broussard [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 11, 2000 11:02 AM
Subject: Re: Newbie: Sessions


Thanks all for the help!

Now if you can help me with this. I turn on session manegment in my
application.cfm file and set the ime out for 10 min. I have a person enter
username and password. If correct I set the session.login to yes. Now if
they don't use the site for longer then 10 min., what happenes. Do I need
to
do some kind of a check on the session.login and then send them to the
login
page or what? If so, would I do it in the application.cfm page

I just quit drinking caffeine so my brain is a little fuzzy, large, swollen


Thanks,

Art


Hello,

Argument for using session variables:

We have a company directory with free listings for members of the natural
food products industry (very recently released). We will give out login
and
passwords to companies (upon approval of their company as verifiable) so
that they can either change information (address, phone numbers etc) and
also so that they may "Upgrade" their listing to incorporate a lot of
tools
(very similar to the Thomas Register). When a user logs in we cannot be
sure
they are doing so from their personal home/office computer and since we do
not want to leave a variety of differently named cookies that would
contain
information about the company on machines in public kiosks we decided to
manipulate this information using session variables that store database
values and some temporary values that a user may change when logged in via
a
form.. We use the session variables because they maintain state throughout
the 15 odd screens that a user may  go through (depending on how much they
upgrade) in order to pull info user specific data from a database and from
forms which then allows the user to update their information.

This system has worked well for us. If I had to maintain any other type of
variables from page to page in my application I think this project would
be
a lot less portable (right now adding a component is really easy since it
is
very fuse box like and the session variables get set in one file which get
included in all the pages of the application.'


If you had asked me 6 months ago if I would ever use session variables I
probably would have said "NO" but this was one place I have found them
very
useful.


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Custom CF_ Tags

2000-08-11 Thread Duane Boudreau

 Im just starting to read the books about Custom tags, and im wondering if
 the file in the C:\CFUSION\CustomTags folder has to contain the
 actual code
 of the tag?

 Or is the file there just to name the tag??

The file has to contain the code. You pass data into the tag using the
Attribute scope and you return data using the caller scope.

Example:

sample.cfm
--
html
headtitle/title/head
body
cf_mytag attrib1="hello" attrib2="world"
br
cfoutput#mytag.success#/cfoutput
/body
/html


mytag.cfm
--
cfoutput#Attributes.attrib1# #Attributes.attrib2#/cfoutput
caller.mytag.success=true


Output:
--
hello world
true


HTH,
Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258

--
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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Philip Arnold - ASP

 I have a customer that is a car dealership.  They want to put their car
 inventory online.
 The company that makes their inventory database tells me that the
 data store
 is not ODBC compliant, but that they could output a CSV text file
 that they
 will auto-FTP to our servers in the middle of the night.  Not exactly the
 most elegant solution, but it beats entering car data manually.  :)

 Can I create an ODBC connection in the CF Administrator to use a CSV text
 file as a data source?   I tried but I could not get it to verify the data
 source.

You can use CSV files for ODBC datasource, but don't! The main reason is
that ODBC holds onto sources like that once it's got them

2 Solutions;
Open the CSV using CFFile - it's just a comma separated list per line
Make a link table in Access which talks to the CSV - this is the much
preferred solution as you can actually run SQL queries on the data

This all assumes that the column list and names stay the same, and only the
data itself changes

Remember also that quotes screw up CSV files royally - so if they have any
in their descriptions (as in 14" wheels)

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: From .exe to .dll

2000-08-11 Thread JustinMacCarthy

Its a little more complicated then that :-) You need to know how to handle
input and ouput params etc...

If you are using VisualC++ there is a template to get u started.
(I think there is a KB article on how to install it if you haven't got it)

Have your programmer look at the source code of some of the freeware cfx on
 intrafoundations site and you'll see the structure.

~J


- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 4:07 PM
Subject: RE: From .exe to .dll


 I appreciate the quick reply... As for the cfx.h library.  Would we just
 have to compile the code with an inclusion of cfx.h or is there any
changes
 that would actually have to be made to the code itself?

 I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on
 Monday.


 THANKS!!

 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 10:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: From .exe to .dll


 If you have the source code I would recommend wrapping the code in a
 cfx_tag. It's very simple.

 For example of cfx source code in C/C++
 Have a look at the excellent www.intrafoundation.com . There is also some
 info in Ben's advanced book and plenty of help(!?!!?) on this list :-)

 If all that fails you chould use cfexecute ( or CFX_consoleCommand @
 intrafoundation.com ) to capture the input from the dos program..


 ~Justin MacCarthy




 - Original Message -
 From: "Mark Armendariz" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 3:23 PM
 Subject: RE: From .exe to .dll


  YEs, we have the source code.  It's actually a proprietary application
 made
  by our own programmers to generate a password for our software.  I
believe
  it's written in C.  The functions of the program are fairly basic.  It
 asks
  about 10 questions (INPUT), and gives one answer depending on the input
  (OUTPUT).
 
  Our programmers are very capable.  I just need to know where to look so
i
  can ask them for this knowledgeably and answer any questions they may
have
  from the get go.  Or at least know ehre to send them for the answers
they
  need.  I would imagine we just need a means of giving the dll input and
 then
  getting the output via a variable.
 
  Thanks..
 
  -Original Message-
  From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
  Sent: Friday, August 11, 2000 10:01 AM
  To: [EMAIL PROTECTED]
  Subject: Re: From .exe to .dll
 
 
  Have you got the source code ??? What language was it written in? What
 does
  it do?
 
  ~Justin
 
  - Original Message -
  From: "Mark Armendariz" [EMAIL PROTECTED]
  To: "Cf-Talk" [EMAIL PROTECTED]
  Sent: Friday, August 11, 2000 2:55 PM
  Subject: From .exe to .dll
 
 
   I am looking for resources regarding converting a dos based program
into
 a
   dll that will run well from cold fusion. can anyone point me in the
 right
   direction?
  
   Thanks
  
  
   Mark Armendariz
   Righteous Desgin
   www.sorighteous.com
   [EMAIL PROTECTED]
  
  
  
 

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

RE: CF Query Problem with Session Variables

2000-08-11 Thread Dana Larose

 CFQUERY NAME="GetUsers" DATASOURCE="DSN"
 SELECT User_ID, FullName, Login
 FROM Users
 WHERE session.user_ID = #CurrentUser.User_ID#
 ORDER BY Login
 /CFQUERY

But...is session.user_ID a table in your database.  What you probably want
is

WHERE User_ID = #session.user_ID#

Dana Larose
Database Monkey
Canadian Web Design  Consulting Inc.

A: 701-281 McDermot Avenue (McDermot  King)
P: 204-946-5155
C: 204-228-0477
F: 204-946-5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.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: CF Query Problem with Session Variables

2000-08-11 Thread Steve Martin

And you could remove the excessive # signs too:

cfset session.user_ID = CurrentUser.User_ID


 Try:

 cfset session.user_ID = #CurrentUser.User_ID#

 CFQUERY NAME="GetUsers" DATASOURCE="DSN"
 SELECT User_ID, FullName, Login
 FROM Users
 WHERE User_ID = #session.user_ID#
 ORDER BY Login
 /CFQUERY

 And you'll probably need single quotes around #session.User_ID# if it's a
 non-numeric field.

 
 Ricq Pattay [EMAIL PROTECTED]
 Univ of MN College of Veterinary Medicine



 - Original Message -
 From: Jeremy Toevs [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 10:08 AM
 Subject: CF Query Problem with Session Variables


 Hey CF People,

 I am storing the current users id in a session variable using the
 following:

 cfset session.user_ID = #CurrentUser.User_ID#

 Now I am trying to write a query that uses that.

 CFQUERY NAME="GetUsers" DATASOURCE="DSN"
 SELECT User_ID, FullName, Login
 FROM Users
 WHERE session.user_ID = #CurrentUser.User_ID#
 ORDER BY Login
 /CFQUERY

 Is it possible to use it, or am I just writing it wrong?

 Thanks in advance!

 Jeremy

 --
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_tal
 k 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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Larry Juncker

John;

Just let your client download the info as requested and then import the csv
file into a table after you get it.  Then you can read it very easily.

H   Larry Juncker
 L  Senior Cold Fusion Programmer
  I Heartland Communications Group
  Internet Division

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Newbie Question - Creating Data Source for CSV text file


I think you can treat a csv file as an ODBC datasource, you
just need to have the driver for it.

RPS


--
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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread paul smith

For SQL7, this works fine inside CF:

BULK INSERT Victor
FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='
'
)

best,  paul

At 10:28 AM 8/11/00 -0400, you wrote:
CF Gurus,

I have a customer that is a car dealership.  They want to put their car
inventory online.
The company that makes their inventory database tells me that the data store
is not ODBC compliant, but that they could output a CSV text file that they
will auto-FTP to our servers in the middle of the night.  Not exactly the
most elegant solution, but it beats entering car data manually.  :)

Can I create an ODBC connection in the CF Administrator to use a CSV text
file as a data source?   I tried but I could not get it to verify the data
source.

Any Tips or place I could go to for more info?


John McKown, VP of Business Services
Delaware.Net, Inc.

--
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: Query Delete?

2000-08-11 Thread Planet CF

The permissions are in the database and trying to do
it at display time (I understand this as doing it
while displaying it on the browser) may not be the
best way to do it.

 Kedar Desai
 Differential Technologies
 Fairfax, VA

--- "Olive, Christopher M Mr NMR"
[EMAIL PROTECTED] wrote:
 why can't you handle that logic at display time? 
 check to see to what the
 user has permissions, and display accordingly?
 
 Chris Olive,
 DOEHRS Website Administrator 
 
 -Original Message-
 From: Planet CF [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 09, 2000 4:46 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Query Delete?
 
 
 The need for a QueryDeleteColumn or QueryDeleteRow
 arises in situations
 where one wants to manipulate the query due to
 various reasons.
 
 One of them could something like applying security
 on the query. This means
 that the user does not priviledges to view all the
 rows/columns of the query
 (which is a join). In such a case you would want to
 delete data which is
 secure. One can say that incorporate that in the
 'select' itself. However
 this cannot be done bcoz some users have override
 security priviledges,
 meaning that security does not apply for such users.
 
 The bottomline is that, if there is a QueryAddColumn
 then why not a
 QueryDeleteColumn and also QueryDeleteRow.
 
 Kedar Desai
 Differential Technologies
 Fairfax, VA
 
 
 -Original Message-
 From: David E. Crawford
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 08, 2000 10:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Query Delete?
 
 
 This is a multi-part message in MIME format.
 
 --=_NextPart_000_0175_01C00146.6E5DE680
 Content-Type: text/plain;
   charset="Windows-1252"
 Content-Transfer-Encoding: quoted-printable
 
 Query Delete?You could relatively easily do it using
 the QueryNew() =
 function and looping over. But what would be the
 point?  Just don't =
 selec the column in the first place.
 
 DC
 
   - Original Message -=20
   From: Planet CF=20
   To: [EMAIL PROTECTED]=20
   Sent: Tuesday, August 08, 2000 14:34
   Subject: Query Delete?
 
 
   Hi,=20
 
   Is there a custom tag somewhere out there, that=20
   deletes a column from  a query?=20
 
   Thanks=20
   Kedar Desai=20
   Differential Technologies=20
   Fairfax, VA=20
 
 
 
  

__=20
   Do You Yahoo!?=20
   Kick off your party with Yahoo! Invites.=20
   http://invites.yahoo.com/=20
   =

-=
 -=20
   Archives:

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

http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_ta=
 lk or send a message to
 [EMAIL PROTECTED] with =
 'unsubscribe' in the body.
 
 
 --=_NextPart_000_0175_01C00146.6E5DE680
 Content-Type: text/html;
   charset="Windows-1252"
 Content-Transfer-Encoding: quoted-printable
 
 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
 Transitional//EN"
 HTMLHEADTITLEQuery Delete?/TITLE
 META content=3D"text/html; charset=3Dwindows-1252"
 =
 http-equiv=3DContent-Type
 META content=3D"MSHTML 5.00.3018.900"
 name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2You could
 relatively easily do it using =
 the=20
 QueryNew() function and looping over. But what would
 be the point?nbsp; =
 Just=20
 don't selec the column in the first
 place./FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2DC/FONT/DIV
 DIVnbsp;/DIV
 BLOCKQUOTE=20
 style=3D"BORDER-LEFT: #00 2px solid;
 MARGIN-LEFT: 5px; MARGIN-RIGHT: =
 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"
   DIV style=3D"FONT: 10pt arial"- Original
 Message - /DIV
   DIV=20
   style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial;
 font-color: =
 black"BFrom:/B=20
   A href=3D"mailto:[EMAIL PROTECTED]" =
 [EMAIL PROTECTED]Planet CF/A=20
   /DIV
   DIV style=3D"FONT: 10pt arial"BTo:/B A=20
   href=3D"mailto:[EMAIL PROTECTED]"=20
  

[EMAIL PROTECTED][EMAIL PROTECTED]/A
 /DIV
   DIV style=3D"FONT: 10pt arial"BSent:/B
 Tuesday, August 08, 2000=20
 14:34/DIV
   DIV style=3D"FONT: 10pt arial"BSubject:/B
 Query Delete?/DIV
   DIVBR/DIV
   PFONT size=3D2Hi,/FONT /P
   PFONT size=3D2Is there a custom tag somewhere
 out there, =
 that/FONT=20
   BRFONT size=3D2deletes a column fromnbsp; a
 query?/FONT /P
   PFONT size=3D2Thanks/FONT BRFONT
 size=3D2Kedar Desai/FONT =
 BRFONT=20
   size=3D2Differential Technologies/FONT
 BRFONT size=3D2Fairfax, =
 VA/FONT=20
   /PBR
   PFONT =

size=3D2__/FONT=20
   BRFONT size=3D2Do You Yahoo!?/FONT BRFONT
 size=3D2Kick off =
 your party=20
   with Yahoo! Invites./FONT BRFONT
 size=3D2A=20
   href=3D"http://invites.yahoo.com/"=20
  
 target=3D_blankhttp://invites.yahoo.com//A/FONT
 BRFONT=20
   =

size=3D2=
 --/FONT=20
   BRFONT size=3D2Archives: A=20
  


Re: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Mike Kear


I've done it.  It's tricky, but I had to go into the NTServer control panel
and define a DSN there.  Once that was done, the CF Administrator could see
it and configure it for ColdFusion.   (We have  a partner site FTP 6 csv
files into our server every night so we always have up todate information
on our own site.)

After that it worked just like any other ODBC database.

Not sure about it's speed though, compared to SQLServer7 because it wasn't
an application that was subject to high traffic.

Perhaps someone else can advise whether it would be faster or slower than
the grown-up database?


Mike Kear
[EMAIL PROTECTED]
www.afp.zip.com.au
Windsor, NSW, Australia

AFP Web Development
AFP Electronic Forms
AFP Models



At 10:28 AM 11-08-00 -0400, you wrote:
CF Gurus,

I have a customer that is a car dealership.  They want to put their car
inventory online.
The company that makes their inventory database tells me that the data store
is not ODBC compliant, but that they could output a CSV text file that they
will auto-FTP to our servers in the middle of the night.  Not exactly the
most elegant solution, but it beats entering car data manually.  :)

Can I create an ODBC connection in the CF Administrator to use a CSV text
file as a data source?   I tried but I could not get it to verify the data
source.

Any Tips or place I could go to for more info?


John McKown, VP of Business Services
Delaware.Net, Inc.

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



More elegant way of passing URL variables?

2000-08-11 Thread Milks, Jim

Hi,
I am dynamically generating a list of customers, on which a user can click
to go to a detailed page. To do this, I am putting the customerID into a URL
variable in the A HREF path. But the client doesn't want to see the value in
the address bar, as they consider it a security risk. 

What would be a better solution? A hidden FORM field for each item, and have
the HREF call Javascript which posts the form? The problem with that us I
will get all of the form fields in the detail page, unless the JS passes a
value to indicate the field I want, but hen I essentially have the same
problem

Any input appreciated.

James
--
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] REQ testimonials from SAG Electronics customers.

2000-08-11 Thread paul smith

Yes, I forgot this in my earlier post.  Same here.  And they sent
a tech to install the new HD (many of their systems come with
on-site service).

best,  paul

At 10:45 AM 8/11/00 -0400, you wrote:
support (at least I don't think they do?). I only had to call support one 
time, 30 second hold time and I had the new hard drive in my hands by 9AM 
the next day.

--
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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Gieseman, Athelene

If your server is NT you can create an ODBC connection using the Microsoft
Text Driver (txt and csv).  I've experimented with it just a bit and it
seems to work on very simple things.  I would think that you'd want to weigh
how many steps you want to take manipulating and moving data.  If the csv
driver works consistently, it might make things simpler.  On the other hand,
if the data is in a database, you have a lot more flexibility.  If you don't
need that flexibility, having fewer places where a breakdown could occur
might be preferable.  I know that we have a few processes where we extract
information from an Informix database on Unix, have that data FTP'd to an NT
Server, then another process runs on the NT server to import the data.
Should be fine in a perfect world.  But I don't live there!  So occasionally
some part of that process doesn't automatically run and the update doesn't
happen.  We're working on getting to the point where the NT application can
be updated directly from the Informix database.  Less places to break.
Another consideration might be the long term plan for the current system.
If it's not ODBC, will it be down the road?  I would think that the vendor
of the product would be moving in that direction.  If so, a simple solution
might be fine.  In that case I'd give the ODBC data source a try.  

By the way, I usually just create my ODBC data sources right from the
control panel.  So I'm not sure if you get all of those same options using
the CF Administrator.  But if you don't, you should be able to just create
it from ODBC32 under the Control Panel. 

Athelene


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:23 AM
To: [EMAIL PROTECTED]
Subject: RE: Newbie Question - Creating Data Source for CSV text file


 I have a customer that is a car dealership.  They want to put their car
 inventory online.
 The company that makes their inventory database tells me that the
 data store
 is not ODBC compliant, but that they could output a CSV text file
 that they
 will auto-FTP to our servers in the middle of the night.  Not exactly the
 most elegant solution, but it beats entering car data manually.  :)

 Can I create an ODBC connection in the CF Administrator to use a CSV text
 file as a data source?   I tried but I could not get it to verify the data
 source.

You can use CSV files for ODBC datasource, but don't! The main reason is
that ODBC holds onto sources like that once it's got them

2 Solutions;
Open the CSV using CFFile - it's just a comma separated list per line
Make a link table in Access which talks to the CSV - this is the much
preferred solution as you can actually run SQL queries on the data

This all assumes that the column list and names stay the same, and only the
data itself changes

Remember also that quotes screw up CSV files royally - so if they have any
in their descriptions (as in 14" wheels)

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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Gene Kraybill

 From:  "Philip Arnold - ASP" [EMAIL PROTECTED]

 You can use CSV files for ODBC datasource, but don't! The main reason is
 that ODBC holds onto sources like that once it's got them
 
 Make a link table in Access which talks to the CSV - this is the much
 preferred solution as you can actually run SQL queries on the data

I'd be interested in hearing a few more details on this... and info about the 
advantages 
of this over using CFHTTP to create a query object and then looping over the 
query to insert each record into a db...

Gene Kraybill


--
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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread John McKown

Thanks for all of the feedback.
Keep it coming...

Right now I am learning to use CFHTTP...
Couldn't I just use that to take their CSV and insert it into a table?
Or am I going to have issues when they have strings that contain quotes?


Thanks in advance...

John McKown, VP of Business Services
Delaware.Net, Inc.

 -Original Message-
 From: paul smith [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 11:47 AM
 To: [EMAIL PROTECTED]
 Cc: John McKown
 Subject: Re: Newbie Question - Creating Data Source for CSV text file


 For SQL7, this works fine inside CF:

 BULK INSERT Victor
 FROM 'D:\FR\FileResource\VictorJPGs\CSVs\July212000\101-200.csv'
 WITH
 (
 FIELDTERMINATOR=',',
 ROWTERMINATOR='
 '
 )

 best,  paul

 At 10:28 AM 8/11/00 -0400, you wrote:
 CF Gurus,
 
 I have a customer that is a car dealership.  They want to put their car
 inventory online.
 The company that makes their inventory database tells me that
 the data store
 is not ODBC compliant, but that they could output a CSV text
 file that they
 will auto-FTP to our servers in the middle of the night.  Not exactly the
 most elegant solution, but it beats entering car data manually.  :)
 
 Can I create an ODBC connection in the CF Administrator to use a CSV text
 file as a data source?   I tried but I could not get it to
 verify the data
 source.
 
 Any Tips or place I could go to for more info?
 
 
 John McKown, VP of Business Services
 Delaware.Net, Inc.
 
 -
 -
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/c
f_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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread paul smith

In my app at http://bradford.support.net/ I had my client
export their jobs database to CSV using a pipe (|) as a field
delimiter to get around the quotes problem.  They also
upload their CSV using HTTP.

best, paul

At 04:22 PM 8/11/00 +0100, you wrote:
Remember also that quotes screw up CSV files royally - so if they have any
in their descriptions (as in 14" wheels)

--
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: Newbie Question - Creating Data Source for CSV text file

2000-08-11 Thread Eric Dawson

parse into a database once received?


From: "John McKown" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: "CF_Talk" [EMAIL PROTECTED]
Subject: Newbie Question - Creating Data Source for CSV text file
Date: Fri, 11 Aug 2000 10:28:04 -0400

CF Gurus,

I have a customer that is a car dealership.  They want to put their car
inventory online.
The company that makes their inventory database tells me that the data store
is not ODBC compliant, but that they could output a CSV text file that they
will auto-FTP to our servers in the middle of the night.  Not exactly the
most elegant solution, but it beats entering car data manually.  :)

Can I create an ODBC connection in the CF Administrator to use a CSV text
file as a data source?   I tried but I could not get it to verify the data
source.

Any Tips or place I could go to for more info?


John McKown, VP of Business Services
Delaware.Net, Inc.

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


Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.



Error Diagnostic Information

2000-08-11 Thread Claude Desrochers

This is a multi-part message in MIME format.

--=_NextPart_000_0046_01C0038B.89E6DDC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Can somebody help me?

This problem occures sporadically.  It seem to happens when there's a few
user using the system.  Sometime, a refesh will execute the template
successfully.  When a single user use it, it works just find.

We use Cold Fusion Server 4 Pro on NT 4 with SP5.  The web server is IIS.
Openlink v3.0 is also being used as an ODBC driver to our Informix SE 7
Database.

Here's the error :

Error Diagnostic Information
unknown exception condition

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:53).


Date/Time: 08/11/00 09:53:14
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
Remote Address: 172.16.220.101
HTTP Referer: http://devserver.wbn.ca/transac/SearchEmp.cfm
Template: G:\cfpages\transac\ExecuteSearchEmp.cfm

Claude

--=_NextPart_000_0046_01C0038B.89E6DDC0
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.2314.1000" name=3DGENERATOR/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Can somebody help me?nbsp; =
/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2This problem occures =
sporadically.nbsp; It seem to=20
happens when there's a few user using the system.nbsp; Sometime, a =
refesh will=20
execute the template successfully.nbsp; When a single user use it, it =
works=20
just find./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2We use Cold Fusion Server 4 Pro on NT 4 =
with=20
SP5.nbsp; The web server is IIS./FONT/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D91125015-11082000Openlink v3.0 is also=20
being used as an ODBC driver to our Informix SE 7 =
Database./SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D91125015-11082000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Here's the error :/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Error Diagnostic InformationBRunknown =
exception=20
condition/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial=20
size=3D2PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag/FONT/DIV=

DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2The error occurred while processing an =
element with=20
a general identifier of (CFQUERY), occupying document position (3:1) to=20
(3:53)./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2BRDate/Time: 08/11/00 =
09:53:14BRBrowser:=20
Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)BRRemote =
Address:=20
172.16.220.101BRHTTP Referer: A=20
href=3D"http://devserver.wbn.ca/transac/SearchEmp.cfm"http://devserver.w=
bn.ca/transac/SearchEmp.cfm/ABRTemplate:=20
G:\cfpages\transac\ExecuteSearchEmp.cfm/FONT/DIV
DIVnbsp;/DIV
DIVFONT color=3D#00 face=3DArial size=3D2Claude =
/FONT/DIV/BODY/HTML

--=_NextPart_000_0046_01C0038B.89E6DDC0--

--
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: Newbie: Sessions

2000-08-11 Thread Todd Ashworth

What I do is put all pages that need to be password protected into their own
folder.  Then I toss an application.cfm into that folder that looks
something like this:

!--- ---
cfinclude template="../application.cfm"

cfif not isdefined('Session.login') or Session.login is not "yes"
cflocation url="../login.cfm"
/cfif
!--- ---

This application.cfm includes all of the attributes of the root
application.cfm, but also checks for your session variable and redirects if
it is expired, not created, etc.

Todd Ashworth

- Original Message -
From: "Art Broussard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 11:02 AM
Subject: Re: Newbie: Sessions


| Thanks all for the help!
|
| Now if you can help me with this. I turn on session manegment in my
| application.cfm file and set the ime out for 10 min. I have a person enter
| username and password. If correct I set the session.login to yes. Now if
| they don't use the site for longer then 10 min., what happenes. Do I need
to
| do some kind of a check on the session.login and then send them to the
login
| page or what? If so, would I do it in the application.cfm page
|
| I just quit drinking caffeine so my brain is a little fuzzy, large,
swollen


--
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: Error Handling

2000-08-11 Thread Gene Kraybill

[EMAIL PROTECTED] wrote:

 I looked a bit into that , but  I waant a message only for that error, and
 it doesn't seem like I can tell CFTRY to only catch the cfsearch error.
 Please tell me if I am wrong.

I've just started using CFTRY myself, but check out CFTHROW. It's my 
understanding you can use it along with some conditional code to "throw" any 
customized 
error message for any error condition at all...Your customized error will then be 
"caught" by CFCATCH at the bottom of the CFTRY block.

Gene Kraybill
--
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.



Flushing cached queries

2000-08-11 Thread Dana Larose

Hey everyone,

If you are caching queries, is there a way to force CF to flush them?

When an administrator updates a table, I would like CF to dump any cached
queries using that table, so that users aren't viewing old data.

Dana Larose
Web Developer
Canadian Web Design  Consulting Inc.

A: 701-281 McDermot Avenue (McDermot  King)
P: 204-946-5155
C: 204-228-0477
F: 204-946-5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.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: CF Query Problem with Session Variables

2000-08-11 Thread Todd Ashworth

P.S. Jeremy, don't forget to cflock those session variables ;)

Todd Ashworth

- Original Message -
From: "Ricq Pattay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 11:24 AM
Subject: Re: CF Query Problem with Session Variables


| Try:
|
| cfset session.user_ID = #CurrentUser.User_ID#
|
| CFQUERY NAME="GetUsers" DATASOURCE="DSN"
| SELECT User_ID, FullName, Login
| FROM Users
| WHERE User_ID = #session.user_ID#
| ORDER BY Login
| /CFQUERY
|
| And you'll probably need single quotes around #session.User_ID# if it's a
| non-numeric field.
|
| 
| Ricq Pattay [EMAIL PROTECTED]
| Univ of MN College of Veterinary Medicine
|
|
|
| - Original Message -
| From: Jeremy Toevs [EMAIL PROTECTED]
| To: [EMAIL PROTECTED]
| Sent: Friday, August 11, 2000 10:08 AM
| Subject: CF Query Problem with Session Variables
|
|
| Hey CF People,
|
| I am storing the current users id in a session variable using the
following:
|
| cfset session.user_ID = #CurrentUser.User_ID#
|
| Now I am trying to write a query that uses that.
|
| CFQUERY NAME="GetUsers" DATASOURCE="DSN"
| SELECT User_ID, FullName, Login
| FROM Users
| WHERE session.user_ID = #CurrentUser.User_ID#
| ORDER BY Login
| /CFQUERY
|
| Is it possible to use it, or am I just writing it wrong?
|
| Thanks in advance!
|
| Jeremy


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



CSv

2000-08-11 Thread Jim Taylor

what is a csv file?

--
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: Error Handling

2000-08-11 Thread Gregory Harris

David's right, just use CFCATCH.Detail in a CFIF statement and you can catch the 
detail down to the very fine point.  Lemme know if ya need anything else.

Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 08/11 7:21 AM 
Miriam,

If you put only the CFSEARCH code in the CFTRY block, only errors from
that code will activate the error handler.  If you need even finer
resolution than that, you could check the actual error message
(CFCATCH.Details, I think).

-David

On Fri, 11 Aug 2000 09:20:59 -0400 "Miriam Hirschman"
[EMAIL PROTECTED] writes:
 I looked a bit into that , but  I waant a message only for that 
 error, and
 it doesn't seem like I can tell CFTRY to only catch the cfsearch 
 error.
 Please tell me if I am wrong.
 
 -Original Message-
 From: Gregory Harris [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 09, 2000 12:59 PM
 To: [EMAIL PROTECTED] 
 Subject: Re: Error Handling
 
 
 Hello Miriam.  While I'm not too familiar with the CFSearch tag, I 
 would
 imagine that the CFTRY/CFCATCH could pick up any such error and then 
 you
 have control over how you'd handle it.  Look up the CFTRY/CFCATCH
 statements, use those and tell me how it works out.
 
 Gregory Harris

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
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: More elegant way of passing URL variables?

2000-08-11 Thread JustinMacCarthy

Encrypt  the url 
I wrote a couple of tags that encrypt/ decrypt query_strings

so instead of index.cfm?value=6name=jim

You get

page2.cfm?94946560A4946560B495214551E01031C1D1A.
and on page2 you include cf_DeCryptURL

and you can still use url.value and url.name etc

I don't have it handy at the moment though and it chould do with
more testing but I'll end it to you over the weekend if you want ...

~ Justin

- Original Message -
From: "Milks, Jim" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 4:49 PM
Subject: More elegant way of passing URL variables?


 Hi,
 I am dynamically generating a list of customers, on which a user can click
 to go to a detailed page. To do this, I am putting the customerID into a
URL
 variable in the A HREF path. But the client doesn't want to see the value
in
 the address bar, as they consider it a security risk.

 What would be a better solution? A hidden FORM field for each item, and
have
 the HREF call Javascript which posts the form? The problem with that us I
 will get all of the form fields in the detail page, unless the JS passes a
 value to indicate the field I want, but hen I essentially have the same
 problem

 Any input appreciated.

 James
 --

 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: More elegant way of passing URL variables?

2000-08-11 Thread Jason Egan

I'm assuming that you're having some type of summary list to select from
that takes you to the details page (or something like that)...
I've had the same issue, I have done some weird things to keep this all in a
single form and evaluate the numerous form fields passed to come up with the
one id that actually was selected.  Another way that is a little simpler, is
to create a form for each of the rows in your summary list... you would just
have the complete form information with the hidden form field assigned the
userid in each form.

that would make for a lot of forms potentially (I've limited my display to
10 records with a next/previous setup) - a heavier document, but it works.

just an idea...
later - je

-Original Message-
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 9:50 AM
To: '[EMAIL PROTECTED]'
Subject: More elegant way of passing URL variables?


Hi,
I am dynamically generating a list of customers, on which a user can click
to go to a detailed page. To do this, I am putting the customerID into a URL
variable in the A HREF path. But the client doesn't want to see the value in
the address bar, as they consider it a security risk.

What would be a better solution? A hidden FORM field for each item, and have
the HREF call Javascript which posts the form? The problem with that us I
will get all of the form fields in the detail page, unless the JS passes a
value to indicate the field I want, but hen I essentially have the same
problem

Any input appreciated.

James

--
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 carrying over form values.

2000-08-11 Thread ColdFusionKid

Thanks! That works perfectly!

Cody
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 4:02 AM
Subject: RE: Problem carrying over form values.


  You can try replacing the " with some string you know the person will
not
  enter, like §, or some other character entity. Then you can get that
data
  from the hidden form field and convert it back before entering it into
the
  database.

 There's a neater solution that this one - rather than having to re-convert
 it back later...

 input type="hidden" name="comments"
 value="#Replace(form.Comments,,"quot;","All")#"

 You can use this for all form types, and the HTML is converted when the
form
 passes it along

 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: Newbie Question - CSV text file + IE4/5 fun

2000-08-11 Thread JustinMacCarthy

If you use the pips , ensure that you change your ODBC driver settings, a
comma is default.

BTW if you looking to play around, check out the IE Databinding stuff with
CSV file.

6 Lines of code and you can output the file sort it by columns and allsorts
of cool stuff. Handy for a quick csv viewing and backend stuff .IE only
though...


~Justin

- Original Message -
From: "paul smith" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 4:55 PM
Subject: RE: Newbie Question - Creating Data Source for CSV text file


 In my app at http://bradford.support.net/ I had my client
 export their jobs database to CSV using a pipe (|) as a field
 delimiter to get around the quotes problem.  They also
 upload their CSV using HTTP.

 best, paul

 At 04:22 PM 8/11/00 +0100, you wrote:
 Remember also that quotes screw up CSV files royally - so if they have
any
 in their descriptions (as in 14" wheels)

 --

 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: Newbie: Sessions

2000-08-11 Thread Dennis Powers

Art,

Keep in mind how session variables work.  The variables are stored in
the web server's memory and the timeout period tells the server to
clear them if there is no activity for THAT session for the specified
time.

The obvious question here is: "If the web is stateless how can the
server know which session is which?"

Like anything on the web that needs to maintain state, you need to
tell the server which session you are.  That is done with either a
cookie, set by the cold fusion server, or a URL token sent with each
URL request.

The CF server sends two ID numbers, CFID and CFTOKEN, as a cookie to
your browser when Session or Client management is enabled.  Then on
each subsequent request, CF reads those variables (CFID and CFTOKEN)
and knows which session and which memory (session) variables they are
associated with.  Keep in mind that if you have cookies turned off in
your browser, the server will not know which session you are and will
re-assign a new session on each request. You will then lose your
session variables between requests.

To overcome that situation you can TELL CF which session you are by
including the CFID  CFTOKEN variables on the URL line. Like so:
http://www.domain.com?CFID=#CFIDCFTOKEN=#CFTOKEN#. CF also supports a
shortcut variable for those commands: "Session.URLToken"  You can
append it to each URL like so:
http://www.domain.com?#session.URLToken# and CF will expand the
variable for you and know which session your are.

If you can dictate that your users MUST have cookies enabled then
there is no need to pass the URLToken on each URL request, but if you
are designing for the public at large, I would recommend passing the
URLTOKEN on each URL to be safe.



Best Regards,

Dennis Powers
UXB Internet
(203)879-2844
http://www.uxbinfo.com

-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 11:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Newbie: Sessions

Thanks all for the help!

Now if you can help me with this. I turn on session manegment in my
application.cfm file and set the ime out for 10 min. I have a person
enter
username and password. If correct I set the session.login to yes. Now
if
they don't use the site for longer then 10 min., what happenes. Do I
need to
do some kind of a check on the session.login and then send them to the
login
page or what? If so, would I do it in the application.cfm page

I just quit drinking caffeine so my brain is a little fuzzy, large,
swollen


Thanks,

Art


Hello,

Argument for using session variables:

We have a company directory with free listings for members of the
natural
food products industry (very recently released). We will give out
login and
passwords to companies (upon approval of their company as verifiable)
so
that they can either change information (address, phone numbers etc)
and
also so that they may "Upgrade" their listing to incorporate a lot of
tools
(very similar to the Thomas Register). When a user logs in we cannot
be
sure
they are doing so from their personal home/office computer and since
we do
not want to leave a variety of differently named cookies that would
contain
information about the company on machines in public kiosks we decided
to
manipulate this information using session variables that store
database
values and some temporary values that a user may change when logged
in via
a
form.. We use the session variables because they maintain state
throughout
the 15 odd screens that a user may  go through (depending on how much
they
upgrade) in order to pull info user specific data from a database and
from
forms which then allows the user to update their information.

This system has worked well for us. If I had to maintain any other
type of
variables from page to page in my application I think this project
would be
a lot less portable (right now adding a component is really easy
since it
is
very fuse box like and the session variables get set in one file
which get
included in all the pages of the application.'


If you had asked me 6 months ago if I would ever use session
variables I
probably would have said "NO" but this was one place I have found
them very
useful.

__
__
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com

--

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal
k 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: From .exe to .dll

2000-08-11 Thread Hoffman, Joe (CIT)

The wizard and header file can be found here with directions of where to
place them
on your hard drive with VC++ 6.  It requires that CF server is installed on
the same 
box but might be hackable if you manually add the reg keys noted in the
instructions.

http://members.home.com/hoffmanj/cf/cfx_files.zip

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 11:22 AM
To: [EMAIL PROTECTED]
Subject: Re: From .exe to .dll


Its a little more complicated then that :-) You need to know how to handle
input and ouput params etc...

If you are using VisualC++ there is a template to get u started.
(I think there is a KB article on how to install it if you haven't got it)

Have your programmer look at the source code of some of the freeware cfx on
 intrafoundations site and you'll see the structure.

~J


- Original Message -
From: "Mark Armendariz" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 11, 2000 4:07 PM
Subject: RE: From .exe to .dll


 I appreciate the quick reply... As for the cfx.h library.  Would we just
 have to compile the code with an inclusion of cfx.h or is there any
changes
 that would actually have to be made to the code itself?

 I'm waiting for Ben's advanced book in the mail.. hopefull to arrive on
 Monday.


 THANKS!!

 -Original Message-
 From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Friday, August 11, 2000 10:39 AM
 To: [EMAIL PROTECTED]
 Subject: Re: From .exe to .dll


 If you have the source code I would recommend wrapping the code in a
 cfx_tag. It's very simple.

 For example of cfx source code in C/C++
 Have a look at the excellent www.intrafoundation.com . There is also some
 info in Ben's advanced book and plenty of help(!?!!?) on this list :-)

 If all that fails you chould use cfexecute ( or CFX_consoleCommand @
 intrafoundation.com ) to capture the input from the dos program..


 ~Justin MacCarthy




 - Original Message -
 From: "Mark Armendariz" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, August 11, 2000 3:23 PM
 Subject: RE: From .exe to .dll


  YEs, we have the source code.  It's actually a proprietary application
 made
  by our own programmers to generate a password for our software.  I
believe
  it's written in C.  The functions of the program are fairly basic.  It
 asks
  about 10 questions (INPUT), and gives one answer depending on the input
  (OUTPUT).
 
  Our programmers are very capable.  I just need to know where to look so
i
  can ask them for this knowledgeably and answer any questions they may
have
  from the get go.  Or at least know ehre to send them for the answers
they
  need.  I would imagine we just need a means of giving the dll input and
 then
  getting the output via a variable.
 
  Thanks..
 
  -Original Message-
  From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
  Sent: Friday, August 11, 2000 10:01 AM
  To: [EMAIL PROTECTED]
  Subject: Re: From .exe to .dll
 
 
  Have you got the source code ??? What language was it written in? What
 does
  it do?
 
  ~Justin
 
  - Original Message -
  From: "Mark Armendariz" [EMAIL PROTECTED]
  To: "Cf-Talk" [EMAIL PROTECTED]
  Sent: Friday, August 11, 2000 2:55 PM
  Subject: From .exe to .dll
 
 
   I am looking for resources regarding converting a dos based program
into
 a
   dll that will run well from cold fusion. can anyone point me in the
 right
   direction?
  
   Thanks
  
  
   Mark Armendariz
   Righteous Desgin
   www.sorighteous.com
   [EMAIL PROTECTED]
  
  
  
 

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

CFTHROW

2000-08-11 Thread Miriam Hirschman

How Do I define my own error in a cfthrow?  I would like to say if the error
is an invalid search criteria then

Thanks,
 
 ---miriam

--
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: Database problems

2000-08-11 Thread Katrina Chapman

Can we see some code?  You may be nesting your tags incorrectly.

--K

-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 5:00 AM
To: CF-Talk
Subject: Database problems


I have a strange problem with inserts in an Access table. I can't seem
to wrap either a CFINSERT or an SQL insert within a CFTRANSACTION.
Either method, without a CFTRANSACTION, will successfully insert a
record in my table. But as soon as I try to use CFTRANSACTION, so I can
get the ID of the record just inserted and CFLOCATION to the entry form,
all I do is increment the database ID, but don't insert any data.

Can anyone hazard a guess what's causing this? I've read everything I
can get my hands on, and I can't seem to figure it out.

Thanks,
--John

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