RE: I lost my brain - checkboxes

2002-10-07 Thread Margaret Fisk

You could do a second update as follows:

Update survey Set hot = 0 Where SID not in (10,17)

A warning though: A not in query only runs well on
well-indexed or small tables. If your table doesn't meet
those standards then you'd be better off getting the whole
list of SIDs as a list and removing the ones that were checked
then running the in statement with the remainder.

Margaret

-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:39 AM
To: CF-Talk
Subject: I lost my brain - checkboxes


Hi all,

Sorry for the stupid post today but I cannot think.

I have an input field on a form:
input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput
(SID is the primary key in the SQL 2K DB).

then on the page:
cfloop query=GetInfo
tr
tdinput type=checkbox name=hotlead
value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td
/tr
/cfloop

So here is my problem. When a checkbox (or more) is checked, I do this SQL
statement:
UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great.
However, if I deselect the checkbox I no longer have the SID:
UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID).

So how do I do this?
I want to set the Hot field to 1 on only the SID when checked and if i
deselect it, then i want the field to be set to 0 on the SID i deselect. The
default value in the Hot (bit) field is 0.

Thanks,
Tony


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



RE: cfinclude, how granular can you make it?

2002-09-19 Thread Margaret Fisk

You could use the include to create a variable and then use evaluate to
act on it I believe.  Yes, I've run into this limitation myself.

Margaret

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 8:17 AM
To: CF-Talk
Subject: RE: cfinclude, how granular can you make it?


You can't break out cfif's into different pages and then include them, you
have to have the cfif then else all in the same page.

Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:15 AM
To: CF-Talk
Subject: cfinclude, how granular can you make it?


How granular can you make your includes? I ask because I'm unable to breakup
an if-else clause. If I pull out the cfif ... and put it into an include I
get a Just in time compilation error. If I put the entire
cfifcfelse/cfif into the include everything works fine.

I'm not finding information on just in time complitation error in either
google, or forta's book or the macromedia site.


WHAT EXISTS :  // if today is a holiday do this else do that


cfif
... snip ...
#year# EQ 2002 AND #month# EQ 9 AND #ThisDay# EQ 2 OR
... snip ...


td class=holiday#ThisDay#/td

cfelse

tda href=#ThisDay#/td

cfif




WHAT I WOULD LIKE TO BE ABLE TO DO:


cfinclude template=holiday.cfm

td class=holiday#ThisDay#/td

cfelse

tda href=#ThisDay#/td

cfif



thx

// gilbert midonnet





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



RE: Going crazy! Dates acting insane..AIIIEEE!

2002-09-12 Thread Margaret Fisk

I'd check to see if StartDate is a system variable.  Sometimes you
get issues if you choose variable names that are already captured
by the server.

Try renaming StartDate to Starting_Date and see if that helps.

-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 10:14 AM
To: CF-Talk
Subject: Re: Going crazy! Dates acting insane..AIIIEEE!


Same here. It's exactly the same as the full version except that it's got a
2G size limit per database.

- Original Message -
From: Angel Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 10:36 AM
Subject: RE: Going crazy! Dates acting insane..AIIIEEE!


 Ok...maybe I didn't explain this properly.

 Basically, I have set a variable to a date:

 !--- DEBUG CODE ---
 CFSET STARTDATE = #CreateODBCDate('9/01/2002')#
 CFSET ENDDATE = #CreateODBCDate('9/30/2002')#
 CFSET client.empid = 1
 !--- DEBUG CODE ---

 I output the variable startdate and I get : {d '2002-09-01'}

 Then I set another variable, to the startdate.

 CFSET TheDate = StartDate

 Now..when I output this date, in the line directly BENEATH this
 statement above, I get 2002-09-08 00:00:00

 How did it suddenly jump forward by 7 days???

 I have NO other manipulations of the startdate variable in between these
 statements.
 What am I doing wrong???

 -Gel


 -Original Message-
 From: Angel Stewart [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 12, 2002 9:58 AM
 To: CF-Talk
 Subject: Going crazy! Dates acting insane..AIIIEEE!


 !--- DEBUG CODE ---
 CFSET STARTDATE = #CreateODBCDate('9/01/2002')#
 CFSET ENDDATE = #CreateODBCDate('9/30/2002')#
 CFSET client.empid = 1
 !--- DEBUG CODE ---

 tdCFOUTPUT#startdate#/CFOUTPUT/td [This CFOUTPUT shows : {d
 '2002-09-01'} ]
 /tr
 CFSET TheDate = StartDate!--- Set variable to the startdate
 ---strong/strong
 CFLOOP query=GetClients
 CFSET TheDate = StartDate
 trtdCFOUTPUT#TheDate#/CFOUTPUT/td/tr [BUT
 THIS CFOUTPUT shows: 2002-09-08 00:00:00]
 td CFOUTPUT#GetClients.offtime#/CFOUTPUT/td
 cfloop Condition = #TheDate# LESS THAN OR EQUAL TO
 #EndDate#!--- Create a loop to loop over the days from the startdate
 to the enddate which should cover an entire month ---

 CFQUERY name=GetHours
 datasource=#DSN#

 SELECT * FROM
 tblMaster,tblDetails
 WHERE tblMaster.ClientID =
 '#GetClients.ClientID#'
 AND tblDetails.RecordDate =
 #CreateODBCDate(TheDate)#
 AND tblMaster.empid =
 #client.empid#
 AND tblMaster.MasterID =
 tblDetails.MasterID

 /CFQUERY

 td class=SnowDataTDCFIF
 #GetHours.RecordHours# GT 0 cfoutput#GETHOURS.RECORDHOURS#/cfoutput
 CFELSE nbsp /CFIF /td
 CFSET TheDate =
 DateAdd(d,TheDate,1)!--- Increment date value by one ---


 /CFLOOP!--- Date Loop ---
 td
 class=SnowFieldCaptionTDCFOUTPUT#GetClients.clientid#/CFOUTPUT/t
 d
   td
 class=SnowFieldCaptionTDCFOUTPUT#GetClients.hoursworked#/CFOUTPUT
 /td
   td
 class=SnowFieldCaptionTDCFOUTPUT#GetClients.hoursbilled#/CFOUTPUT
 /td
   td
 class=SnowFieldCaptionTDCFOUTPUT#GetClients.jobno#/CFOUTPUT/td
   !--- td class=SnowFieldCaptionTDbAcct Group/b/td
 ---

   /tr
 !---CFSET TheDate = #CreateODBCDate('9/01/2002')# Set
 variable to the startdate ---

 strong/strong
 /CFLOOP!--- Clients Query ---



 How the HELLS did it jump forward 7 days!!??
 I am not changing the date ANYWHERE...

 And I just don't understand what is happening...I'm tearing my hair out
 and its already short and Im really starting to mess up my scalp.

 Any ideas??

 Yes yes yes I know I can use an Index loop instead of the
 conditional..I'll fix all those little things I suppose..but before I do
 that I need to figure out why my dates are suddenly gaining days!! :-\

 ARRRGGHH! What stupid thing am I doing now? :-(

 -Gel







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



RE: Search string pasing?

2002-09-11 Thread Margaret Fisk

This doesn't parse by token, but you could replace the search for % with
a space.  I use this to allow for dynamic emails, i.e. user types in the
email message with actual db fields designated by %.

CFSET found=#find(%,tmp)#
cfloop condition=found gt 0
CFIF #left(tmp,1)# is %
CFELSE
CFSET contents=#contents##left(tmp,(find(%,tmp) 
-1))#
/CFIF
CFSET tmp=#mid(tmp,(find(%,tmp)+1),len(tmp))#
CFSET foundvariable=Sql.  #left(tmp,(find(%,tmp) -1))#
CFSET contents=#contents##evaluate(foundvariable)#
CFSET tmp=#mid(tmp,find(%,tmp)+1,len(tmp))#
CFSET found=#find(%,tmp)#
/cfloop
CFSET contents=#contents##tmp#

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 7:37 AM
To: CF-Talk
Subject: Search string pasing?


Does anyone have an example sof parsing strings with CF?

I need to enhanceour search engine so that we can control the search
cresults and in order to do this, I need to break the search string down
into words so I can search for keyword matches by the entire string then
by each word...


Any ideas..

Thanks KP

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How to add BR to CRLF?

2002-09-11 Thread Margaret Fisk

You may want to verify that the database or text file actually contains
line feeds.  It could just be using a wrap function.

If so, you probably would half to set a line length then find the nearest
space to the line length and add the br there.

Margaret

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 4:04 AM
To: CF-Talk
Subject: Re: How to add BR to CRLF?


Try:
CFSET HTMLBody = replace(Body, tmpCRLF,#tmpCRLF#br,ALL)

On Wed, 11 Sep 2002, Erik Britt-Webb wrote:

 I'm trying to take plain text from a database or text file and display it
on
 a web page.  Problem is that the CRLF characters don't work in HTML.  So,
I
 tried converting them using:

 CFSet tmpCRLF = Chr(13)Chr(10)
 CFSet HTMLBody = #Replace(Body,tmpCRLF,tmpCRLFBR)#


 But that doesn't work.  I still get the same run-on paragraph.

 Any suggestions how I do this?  I'm sure it's easy.

 Thanks,

 Erik



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



RE: Programmatically Import XLS into SQL Server 2000

2002-09-10 Thread Margaret Fisk

Look for something like SQLloader for Oracle that can load based on
delimited fields.

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 11:10 AM
To: CF-Talk
Subject: OT: Programmatically Import XLS into SQL Server 2000


Any ideas?

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Has anyone seen this before? Strange garbling of the SQL statement when passed by CFQUERY

2002-09-03 Thread Margaret Fisk

Hi all,

I just moved my box to another domain in another network but the actual box
stayed the same and contains CF 4.5, Oracle 8i and IIS.

I tried to run one of my reports and I get the following error:

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression


SQL = select q.incident,(q.calldate||' '|| q.calltime) as create_time,
min(c.calldate||' '|| c.calltime) as action_time, sysdate from cnotes c,
question q where c.incident=q.incident and =2.12452406865E-314 and
=q.incident and (c.callgroup is not null) group by q.incident,q.calldate||'
'|| q.calltime


The actual query is:

select q.incident as incident, (q.calldate||' '|| q.calltime) as
create_time,
min(to_char((to_date((c.calldate||' '|| c.calltime),'DD-MON-YY
HH24:MI:SS') -
to_date((q.calldate||' '|| q.calltime),'DD-MON-YY
HH24:MI:SS'))*24,'.00'))
AS difference, sysdate from cnotes c,question q where c.incident=q.incident
and
q.calldate = sysdate-#Actionrange# and c.calldate is not null and
(c.callgroup is not null) and q.incident not in (select incident from cnotes
where callnote like '%Case taken from Cus Support+Knowledge Base%') group
by q.incident,q.calldate||' '|| q.calltime

Actionrange is a variable set to 8 by default.  I'm thinking the problem is
related to the greater than sign, but am not sure.  The report worked fine
up until the move and the box itself is the same as it was before, only the
domain is different.

Please help, I am completely stumped. Even if you can just give me some idea
where the 2.12452406865E-314 is coming from I'd appreciate it.  Running the
query in native SQL has no problems even on that box.

Thanks in advance,
Margaret



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFFORM/CFINPUT

2002-08-13 Thread Margaret Fisk

When I tried to use cfinput, it had to download an applet onto the client
machine.  So I decided to stick with self-validation rather than requiring a
user automatic download that they might be concerned about.

-Original Message-
From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 8:56 AM
To: CF-Talk
Subject: Re: CFFORM/CFINPUT


It really depends on how fast you need something done and how detailed you
want error messages.

I use cfform at times and at other times when more complex error checking is
required--I don't use it.

I never use cfinsert and cfupdate though.

J
- Original Message -
From: G L [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 11:53 AM
Subject: CFFORM/CFINPUT


 Can someone explain to me why alot of advanced CF'ers don't like to use
 CFFORM and CFINPUTs in their code? I've even heard them refer to it as
 novice cf-coding. I've always had good luck using them. Are there
 drawbacks to letting CF generate the js to validate your input fields?
There
 must be a good reason.



 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFFORM/CFINPUT

2002-08-13 Thread Margaret Fisk

Wow. Thanks.  I'll admit I'm not going to redo all my forms now, but that's
good to know for the future.

Margaret

-Original Message-
From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 9:07 AM
To: CF-Talk
Subject: Re: CFFORM/CFINPUT


CFFORM NAME=name
ACTION=form_action
ENABLECAB=Yes or No

set enablecab = no and you don't have to download the applet.

j
- Original Message -
From: Margaret Fisk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 13, 2002 11:55 AM
Subject: RE: CFFORM/CFINPUT


 When I tried to use cfinput, it had to download an applet onto the client
 machine.  So I decided to stick with self-validation rather than requiring
a
 user automatic download that they might be concerned about.

 -Original Message-
 From: JLH All Turbo [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 13, 2002 8:56 AM
 To: CF-Talk
 Subject: Re: CFFORM/CFINPUT


 It really depends on how fast you need something done and how detailed you
 want error messages.

 I use cfform at times and at other times when more complex error checking
is
 required--I don't use it.

 I never use cfinsert and cfupdate though.

 J
 - Original Message -
 From: G L [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, August 13, 2002 11:53 AM
 Subject: CFFORM/CFINPUT


  Can someone explain to me why alot of advanced CF'ers don't like to use
  CFFORM and CFINPUTs in their code? I've even heard them refer to it as
  novice cf-coding. I've always had good luck using them. Are there
  drawbacks to letting CF generate the js to validate your input fields?
 There
  must be a good reason.
 
 
 
 

 

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



RE: Single Quote in Multiple Record Update - not yet

2002-08-13 Thread Margaret Fisk

You may have to replace the  in the comments field with the html
equivalent, 
quot; before you insert.

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 10:12 AM
To: CF-Talk
Subject: RE: Single Quote in Multiple Record Update - not yet


Whoops, typo!

It's correct on the actual page.

Actually, it only the comments field that's the problem - everything else is
fine. The update is actually much larger than the example - probably 50
fields.  Query works great until somebody puts something like I can't
figure this into the comments field...

 For my update multiple records problem with single quotes:
 CFOUTPUT
 CFLOOP index=thisID list=#FORM.ProjID#

 CFQUERY NAME=update datasource=creati610.data
UPDATE INT_PROJECT
FORM_NUM= '#evaluate(FORM.NUM_#thisID#)#',
DUE_DATE= '#evaluate(FORM.DUE_DATE_#thisID#)#',
   COMMENTS= '#evaluate(FORM.COMMENTS_#thisID#)#'
  WHERE ID = #thisID#
 /CFQUERY

 /CFLOOP
 /CFOUTPUT


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: How to append a string to a string?

2002-07-29 Thread Margaret Fisk

I may be missing something but this works:
output = table border='#border#' bgcolor='#color#'
output = #output#
tr
td

etc.

-Original Message-
From: Chris Edwards [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 2:17 PM
To: CF-Talk
Subject: How to append a string to a string?


whats an easy way to append a string to a string?

I'm trying to do this:

// php
$output  = table border='$border' bgcolor='$color';
$output .=   tr;
$output .= td;
etc...

  in CF.

I don't want to use cfscript though.

Thanks.



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



RE: record linking prob

2002-07-26 Thread Margaret Fisk

It's a silly detail, but are you sure you're within a functioning loop when
the href url is generated? Sounds like it is just showing the first
searchResults.RecordID from your description.

-Original Message-
From: Doherty,Sean [NCR] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 26, 2002 10:35 AM
To: CF-Talk
Subject: record linking prob


Hey I am a newbie here and am having abit of troubles ... i am trying to
link together a brief results page to a full details page.  i am able to
create the link, but when I click on it, it always brings me to the same
record ... here is my source:

a
href=matdetails.cfm?searchResults.RecordId=#URLEncodedFormat(searchResults.
RecordID)##searchResults.Title#/a

. no matter when I click on it I always get record one ... any suggestions
would be appreciated.

thanks

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Cold Fusion and imap

2002-07-25 Thread Margaret Fisk

Does anyone know if Cold Fusion can support getting mail from an imap
connection instead of POP?

Thanks in advance,
Margaret
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Password protecting browsable web directories

2002-07-23 Thread Margaret Fisk

I actually had a similar problem and solved it in the following way:

I have a form that reads the results of of CFDIRECTORY listing and makes 
URLs out of the files and buttons out of the subdirectories. When you click 
a button, it redoes the CFDIrectory but adds the subdirectory to the path
that 
is listed.

Since security is such a big deal, this download page is only available
within
a password protected site (using a database and an encrypted password) and
then 
additionally I use CFCONTENT to pass the file to them without ever showing
where 
the indicated file structure exists.

Is this what you're looking for?

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 1:19 PM
To: CF-Talk
Subject: Password protecting browsable web directories


I've got a client that wants a simple web-accessible file store where
employees can download files.  The simplest approach is just to enable
directory browsing and to allow administrators to FTP to the web site to
upload the files.  Now they want to password protect the directory.  I don't
want to use NT user accounts.

If I use CF for login management, I must create index files in each
directory, but I lose the simple web server based 'browsability' of the
directory tree.  What are the alternatives?  Do I need to create an
application that mimics the web server behavior?

Jim


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Populating a form with query results

2002-07-22 Thread Margaret Fisk

One other thing is you should do isDefined and provide a blank or default if
it is not.  Otherwise you get errors if the query returns a null for that
field.

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 10:05 AM
To: CF-Talk
Subject: RE: Populating a form with query results


I generally do something like this:

cfquery name=foo
select bar
from table
/cfquery

cfoutput
input name=newfoo type=text value=#foo.bar#
/cfoutput


Hope that helps.  Maybe my brain is in gear on this one.  :-)

  --Ben Doom 
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Yexley Robert D Contr Det 1 AFRL/WSI
: [mailto:[EMAIL PROTECTED]]
: Sent: Monday, July 22, 2002 12:50 PM
: To: CF-Talk
: Subject: Populating a form with query results
: 
: 
: I have a basic HTML form in a CF document, and I need to be able 
: to populate some of the fields on the form with the results of a 
: database query.  I can't seem to find anywhere that explains how 
: to go about doing this.  Could somebody point me in the right 
: direction?  Thanks in advance.
: 
: /*
: || Robert D. Yexley
: || Oracle Programmer/Analyst
: || Easylink Services Corporation
: || Professional Services
: || Contractor - Wright Research Site MIS
: || Det-1 AFRL/WSI Bldg. 45 Rm. 062
: || (937) 255-1984
: || [EMAIL PROTECTED]
: || )))
: */
: 
:  Robert D. Yexley (E-mail).vcf 
: 
: 

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



RE: CFCONTENT and closing the main page

2002-07-17 Thread Margaret Fisk

Hi everyone,

I am using CFCONTENT to force a download dialog box (thanks to some help
from this list :-)) and I have an additional question.

Right now, I pop up a separate window that then pops up the File Download
dialog.  However, the original window stays open even after the download is
complete and displays as a blank page.

I'm going to work on putting a Click Save on the File Download dialog box
message to avoid the blank page, but this is rather obvious.  Is there any
way to close the window after the File Download box has displayed...without
disrupting the download of course.

Thanks in advance,
Margaret Fisk 
Manager of Customer Support
[EMAIL PROTECTED] 
Quiver, Inc. 
2121 El Camino Real
Suite 300
San Mateo, CA 94403 
Quiver...Knowledge is Your Advantage 
Visit our website:  http://www.quiver.com/ 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT and closing the main page

2002-07-17 Thread Margaret Fisk

Nope.  It doesn't close.  I also tried CFLOCATION after the CFCONTENT but it
didn't work either.

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 11:08 AM
To: CF-Talk
Subject: Re: CFCONTENT and closing the main page


You cant just use
script
window.close();
/script after your code?




Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Margaret Fisk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 10:57 AM
Subject: RE: CFCONTENT and closing the main page


 Hi everyone,

 I am using CFCONTENT to force a download dialog box (thanks to some help
 from this list :-)) and I have an additional question.

 Right now, I pop up a separate window that then pops up the File Download
 dialog.  However, the original window stays open even after the download
is
 complete and displays as a blank page.

 I'm going to work on putting a Click Save on the File Download dialog
box
 message to avoid the blank page, but this is rather obvious.  Is there any
 way to close the window after the File Download box has
displayed...without
 disrupting the download of course.

 Thanks in advance,
 Margaret Fisk
 Manager of Customer Support
 [EMAIL PROTECTED]
 Quiver, Inc.
 2121 El Camino Real
 Suite 300
 San Mateo, CA 94403
 Quiver...Knowledge is Your Advantage
 Visit our website:  http://www.quiver.com/
 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFCONTENT and closing the main page

2002-07-17 Thread Margaret Fisk

Thanks Isaac.  I'll give it a try.


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 11:39 AM
To: CF-Talk
Subject: RE: CFCONTENT and closing the main page


Hi Margaret,

I believe you'll get what you want if you simply don't spawn the separate
window... If you just use a link to the cfcontent page, i.e. a
href=cfcontent.cfm?fileid=#fileid#Get the File/a The user will only see
the download dialogue -- the page they're on won't change -- in essence, the
same as if you linked to a zip file like a href=myfile.zipGet the
file/a


Isaac Dealey

www.turnkey.to
954-776-0046

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Recursive queries

2002-07-16 Thread Margaret Fisk

This is a very complex query that I used to use to generate a report from:
ID  Parent  Name
1   0   Dad
2   1   Daughter
3   2   Grandson

To this:

Master_Parent   Parent  Topic   count
Dad Dad Daughter1
Dad DaughterGrandson1

Or something like that...its been a while.

Is this what you're looking for?  It requires a known number of topic
relationships
SELECT  s4.sort_order,' '||substr(rtrim(s3.Name),1,length(s3.name))
Master_Parent,
'   '||substr(rtrim(s2.Name),1,length(s2.name)) Parent,
'   '||substr(rtrim(s.Name),1,length(s.name)) Topic,
'   '||rtrim(c.URL) URL,
'   '||sum(c.Count)  CountOfURL
FROM pbls_$partner s,pbl_count_$partner c,sortorder_$partner s2,
pbls_$partner s3, sortorder_$partner s4
WHERE s.pbl_id=c.pbl_id and s2.pbl_id(+)=s.father_id and
s2.master_father_id=s3.pbl_id(+) and s.pbl_id=s4.pbl_id
and c.hit_date in (select hit_date from temp_pbl2_$partner)
GROUP BY s.path, s2.name, s.father_id, s.name,c.URL,
s3.name, s4.sort_order;

-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 8:57 AM
To: CF-Talk
Subject: RE: Recursive queries


I looped this:

SELECT  *
WHERE   PARENT_ID IN (#keyList#)

appending the keys returned to a list, and kept going till recordcount = 0

That goes from parent to all children, grandchildcren, all the way down.

Going up is the opposite.

I can chunk you the code if you want.

Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education  Training Professional 
Development  Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 


-Original Message-
From: chris.alvarado [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 16, 2002 10:37 AM
To: CF-Talk
Subject: Recursive queries

Still trying to decide how I like to perform some type of recursive
query wth the following Table structure;

ID   NAME   PARENT_ID

If the current record IS the parent then the Parent ID is 0

Otherwise the child has the ID of the parent as it's Parent ID.


Anyone have any good references on recursive queries to handle this? A
way to spider down through the parents and children basically.

Ive done this before using Stored Procs and temp tables, but there has
to be an easier way.

Any suggestions?


-chris.alvarado
[ application developer ]
4 Guys Interactive, Inc.
http://www.4guys.com 

-- I can picture in my mind a world without war, a world without hate.
And I can picture us attacking that world, because they'd never expect
it. -- Jack Handy




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFmail can only deliver to our domain name...

2002-07-12 Thread Margaret Fisk

What does your mail log say? We had the same problem when my
company changed the mail server.  It did not include a rule that 
the CFserver could use it as a forwarding server and so rejected
any mail address that did not exist on the box.

-Original Message-
From: Philippe Varichon [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 7:52 AM
To: CF-Talk
Subject: CFmail can only deliver to our domain name...


I sent 180 different emails generated from our db in that way:

BATCH #1:
to myself with the From being '[EMAIL PROTECTED]' and the To:
'[EMAIL PROTECTED]'
Worked just fine.

BATCH #2:
to myself with the From being '[EMAIL PROTECTED]' and the To:
'[EMAIL PROTECTED]'
Worked just fine.

BATCH #3:
to myself with the From being a list of 180 different emails not related to
our
domain name: 'circumvista.com' such as '[EMAIL PROTECTED]' and 3 emails that were:
'[EMAIL PROTECTED]'
'[EMAIL PROTECTED]'
'[EMAIL PROTECTED]'

and the To: '[EMAIL PROTECTED]'

Results: only the 3 above emails sent to our domain were successfully
received
all other ones were dumped in the undeliverable bin and transferring them in
the
spool would just dump them again.

I did the tests twice each time with the same results.
Our box is scanned daily for virus by Norton with the latest updates.
Does someone can explain this weird behavior of CFmail?
It used to work just fine with hundred's of emails.

Thanks in advance,

Philippe Varichon


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cffile copy problem

2002-07-11 Thread Margaret Fisk

It will only get you the text of the file and probably lose some formatting,
but you could read it and then output a new file using the file contents
couldn't you?

-Original Message-
From: Shawn McKee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 1:08 PM
To: CF-Talk
Subject: RE: cffile copy problem


No joy, still won't copy a file that I don't have write permissions for.

Shawn


-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 8:49 AM
To: Shawn McKee
Subject: RE: cffile copy problem


Yeah, the attributes parameter looks like a Windows-only thing.

-- Original Message --
From: Shawn McKee [EMAIL PROTECTED]
Date: Thu, 11 Jul 2002 08:40:44 -0500

This actually comes from the custom tag local_to_local.  In looking at it I
am wondering if it is the combination of the attributes and the mode in the
same tag.  I am betting I added the mode and left the attributes.

cffile action=COPY source=#Dir#/#Name#
destination=#attributes.DestDir#/#NewFile# attributes=normal
mode=664

Shawn


-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 8:35 AM
To: Shawn McKee
Subject: RE: cffile copy problem


Ah, yes, I agree - your CF is running as userid cfadm.  Sounds like Linux
itself is happy with what you've got.

Do you have a mode parameter in your cffile statement?

Here's one I use:

cffile 
action=append 
file=myfilename  
mode=644 
addnewline=Yes 
output=blah blah blah

-- Original Message --
From: Shawn McKee [EMAIL PROTECTED]
Date: Thu, 11 Jul 2002 08:16:54 -0500

I'll check that but when it does successfully copy the files the end up as
owned by cfadm not by nobody thus my assumption that it was running as
cfadm.

Shawn


-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 11, 2002 7:59 AM
To: CF-Talk; [EMAIL PROTECTED]
Subject: Re: cffile copy problem


CF (on Solaris, anyway) runs as userid nobody.  So the permissions have to
be right for nobody for cffile to work.

Chris Norloff


-- Original Message --
from: Shawn McKee [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 10 Jul 2002 19:00:20 -0500

I am trying to copy a file on a Linux system that has read permissions at
the group level (644 specifically).  I can log into the box and su to
cfadm
and make the copy just fine.  If I try and do it with the cffile tag I
get
a permission denied.  If I change the file permissions to read, write at
the
group level (774) all is OK.  The write permission at group should not
impact my ability to read and copy the file.

Any ideas?

Shawn McKee
Manager, Web Development
NewsStand, Inc.
8620 Burnet Rd., Suite 100
Austin, TX 78757 USA
512-334-5100
Read newspapers and magazines from around the world in a whole new way.
NewsStand delivers them to your PC without paper and without delay!
Try: http://www.newsstand.com?NSEMC=EMNSI01





__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: I don't want refreshing when I am selectiong to download

2002-07-08 Thread Margaret Fisk

I have a similar situation where users choose between 12 different
downloads. How I've resolved the situation is to place a checkmark next
to each download.  The checkmarks are evaluated after the submit and those
downloads are sent to the user in email.

-Original Message-
From: Kodjo Ackah [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 8:08 AM
To: CF-Talk
Subject: I don't want refreshing when I am selectiong to download


Hi,
my application gives the user the choice to select from search
results(images), in order to download.
They will usually select more than one image.
 
PROBLEM: Each click of the select button means my page is refreshed -
that is a new query has to begin in order to select yet another image.
 
The code is attached.
 
I have been advised that javascript will help me stop this happenning.
What kind of javascript are we referring to?
How can I implement this.
I don't know where to start.


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



RE: CFMX CFDUMP / Stylesheets.

2002-07-08 Thread Margaret Fisk

I've not tried it, but you could probably override the default TD class 
by putting TD class=cfdump for all the cfdump information. That way
you'd
only have to change the cfdump entries rather than every TD call.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 08, 2002 8:51 AM
To: CF-Talk
Subject: RE: CFMX CFDUMP / Stylesheets.


Ok, perhaps I'm not seeing the obvious.. if I have my site css... and I 
have something like:

TD{font-family : Verdana, Geneva, Arial, Helvetica;font-size : xx-small;}

Now... just because I want my fonts in a TD to be xx-small doesn't mean 
I want the TD's in the CFDUMP to be xx-small.  I'm guessing that I 
need to remove the above TD in the stylesheet and just make my own 
class, but that would mean me having to go and add class=whatever to all 
my TD's that I want it applied to.

:)

~Todd


On Mon, 8 Jul 2002, Katherine Maltby wrote:

 but you can have more than one class for all tds in a site..or am I
 missing what the problem is here?!
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 08 July 2002 16:34
 To: CF-Talk
 Subject: RE: CFMX CFDUMP / Stylesheets.
 
 
 No, my stylesheet is interferring with cfdumps.  I'd have to go in and 
 remove my own TD class and make a class that doesn't conflict I guess.
 
 ~Todd
 
 On Mon, 8 Jul 2002, Raymond Camden wrote:
 
  Are you saying that cfdump's style sheet inteferes with your pages style
  sheet?
  
  ===
  Raymond Camden, ColdFusion Jedi Master for Macromedia
  
  Email: [EMAIL PROTECTED]
  Yahoo IM : morpheus
  
  My ally is the Force, and a powerful ally it is. - Yoda 
  
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
   Sent: Monday, July 08, 2002 11:27 AM
   To: CF-Talk
   Subject: CFMX CFDUMP / Stylesheets.
   
   
   Anyone know of a way to stop a block of code from using 
   stylesheets?  For 
   example, my css obviously has a TD {blah} in it - and, 
   because of that ... 
   cfdump also uses that stylesheet.  Basic question here, but 
   ... my brain 
   is dead atm.  
   
   Too much Warcraft 3. :)  (Awesome game btw)
   
   TIA,
   ~Todd
   
   -- 
   
   Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
   Team Macromedia Volunteer for ColdFusion   |
   http://www.macromedia.com/support/forums/team_macromedia/  |
   http://www.flashCFM.com/   - webRat (Moderator)|
   http://www.ultrashock.com/ - webRat (Back-end Moderator)   |
   
   
   
  
 
 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: variables not let go

2002-07-02 Thread Margaret Fisk

You can always use an ISNULL in your query...different for each
database...
to make sure it has a value even if the field is blank.

-Original Message-
From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 1:19 PM
To: CF-Talk
Subject: Re: variables not let go


I have noticed this in a nested loop/query situation.  I just had to make a
workaround for it.

~Val

- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 2:28 PM
Subject: variables not let go


 has anyone noticed when they have a query
 that returns lets say for example the variable called
 CompanyName, and on the 3rd loop through the results
 the variable CompanyName is undefined and then
 value of CompanyName from the 2nd row shows
 up as the value of the 3rd row?

 ..tony

 Tony Weeg
 Senior Web Developer
 Information System Design
 Navtrak, Inc.
 Fleet Management Solutions
 www.navtrak.net
 410.548.2337

 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Working with empty lists

2002-07-02 Thread Margaret Fisk

Set your form to supply default values that are overridden or in the case of
a checkbox, have a hidden value with the same name that you strip in your
code. If only the hidden value exists, insert null otherwise, insert the
other list value. Multiple entries will usually be separated by a comma.

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 2:07 PM
To: CF-Talk
Subject: Re: Working with empty lists


Ok...Let me try to be a little more presice in what I am needing, and by the
way Brian your help yesterday was excellent. What I want to do is insert the
value of  or NULL if none of the checkboxes are checked and insert the id,
inventory_id into the table also. Right now if the person does not choose
any
options, then nothing gets inserted into the options table. This causes a
problem if the user later goes back and decides to give the car some options
from the update form since their is no inventory_id in the table to
reference
for the vehicle. Does this make a little more sense?






Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 1:52 PM
Subject: Re: Working with empty lists


 OK...I thought I showed you how to do this yesterday ;-)

 First off I think what you're trying to will loop as many times as there
are
options.  Instead you
 should only need to loop as many times as there are checked checkboxes.
yes
I know it's not a big
 deal, but if you can be more efficient...why not ;-)

 Here's what I'd do:

 DISPLAY AND ASSIGN VALUES TO CHECKBOXES:

 cfloop query=get_otptions
   input type=checkbox name=chkOption value=#ID##Option_Name#br
 /cfloop

 AFTER THE BOXES ARE CHECKED AND THE FORM IS PASSED:

 Now we have to insert all your CHECKED options.  I'll just focus on the
option INSERT query and skip
 your other stuff to grab the right ID and all that (so at this point we
assume we have the vehicle
 ID).

 cfquery datasource=DSN name=InsertOptions
   cfloop list=#FORM.chkOption# index=Option_ID
 INSERT INTO
   Options
 (
 inventory_id,
 option_id
 )
VALUES
(
#Inventory_ID#,
#Option_ID#
) ;
   /cfloop
 /cfquery

 So what happened above is;
 The value for FORM.chkOption will contain a comma delimited list of ALL
the
values (option_IDs) from
 the CHECKED boxes.  You CFLOOP through that list and insert the
Option_IDs.

 Hopefully I understand what you're up to and this has made sense ;-)

 Good luck

 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 t. 250.920.8830
 e. [EMAIL PROTECTED]

 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com

 - Original Message -
 From: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, July 02, 2002 1:08 PM
 Subject: Re: Working with empty lists


  Ok here we go.
 
  I am using the hidden field as someone pointed out
 
  IE:
  input type=hidden name=chkOptionList
value=#valuelist(get_options.id)#
  This gives me a list of 1,2,3,4,5 etc...etc...
 
  then using the cfif listFind(attributes.chkOption,j) to see if the
checkbox
  was indeed checked and if so run the query to insert the value and if
not
to
  insert NULL or 
 
 
 
 
 
  Douglas Brown
  Email: [EMAIL PROTECTED]
  - Original Message -
  From: Bryan Stevenson [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Tuesday, July 02, 2002 1:04 PM
  Subject: Re: Working with empty lists
 
 
   An overview of exactly what you're trying to do might help.  It's hard
to
  tell where everything is
   coming from and what kind of value it's supposed to have ;-)
  
   Bryan Stevenson B.Comm.
   VP  Director of E-Commerce Development
   Electric Edge Systems Group Inc.
   t. 250.920.8830
   e. [EMAIL PROTECTED]
  
   -
   Macromedia Associate Partner
   www.macromedia.com
   -
   Vancouver Island ColdFusion Users Group
   Founder  Director
   www.cfug-vancouverisland.com
  
   - Original Message -
   From: Douglas Brown [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Tuesday, July 02, 2002 12:55 PM
   Subject: Re: Working with empty lists
  
  
I still must be doing something wrong.It inserts all the values
of
the
checkboxes, if they are checked or not.
   
Here is the code I have so far, and thanks for all the help
   
cfif ListLen(attributes.chkOptionList)
cfloop list=#attributes.chkOptionList# index=j
cfparam name=attributes.chkOption 

RE: fusebox 3.0 help needed

2002-06-21 Thread Margaret Fisk

I may be missing something but why don't you use either CFLOCATION to
redirect or CFCONTENT to display the contents of the additional page from
within the called page? CFINCLUDE only works on code not other pages as far
as I know.

Margaret
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 8:40 AM
To: CF-Talk
Subject: RE: fusebox 3.0 help needed


Nope still got a 404,


-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 4:32 PM
To: CF-Talk
Subject: RE: fusebox 3.0 help needed


How do you include a location?  All you are doing with include is throwing
a bunch of code in the middle of the template you initially called.

Try killing the request.virtualhost.  If you are routing this all through
the root level index.cfm it is in the directory you are currently in. just
do

href = index.cfm?fuseaction=GlobalAdmin.admin:;

See if that works.

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 21, 2002 11:13 AM
 To: CF-Talk
 Subject: RE: fusebox 3.0 help needed


 yes using javscript is a good altrenative to redirecting to the approprite
 circuit and FA, BUT THE cfinclude
 should still work all the same.

 but CFINCLUDE SHOULD still work,

 I tried this

 CFOUTPUT
   SCRIPT LANGUAGE=Javascript

 document.location.href=#REQUEST.VIRTUALROOT#index.cfm?fuseaction=
 GlobalAdmi
 n.admin;
   /SCRIPT
   /CFOUTPUT

 I still get the same error,

 I am posting to index.cfm at root level,

 //my FBX_CIRCUITS

 CFSET Fusebox.Circuits = StructNew()
 cfset fusebox.Circuits.utilityEyeAdmin=utilityEyeAdmin
 cfset fusebox.Circuits.GlobalAdmin=utilityEyeAdmin/secure/GlobalAdmin

 SO THEN EFFECTIVELY i should go to my FBX_switch at
 utilityEyeAdmin/secure/GlobalAdmin/

 which is

 CFPARAM NAME=VARIABLES.ERROR DEFAULT=
 CFSWITCH EXPRESSION = #FUSEBOX.FUSEACTION#
   CFCASE VALUE=admin
   test
   /CFCASE
   CFDEFAULTCASE
   CFPARAM NAME=ATTRIBUTES.DISPLAYACTION DEFAULT=NEW
   CFINCLUDE TEMPLATE=TEST.CFM
   /CFDEFAULTCASE
 /CFSWITCH

 inside utilityEyeAdmin/secure/GlobalAdmin/ i have

 fbx_Layouts.cfm
 fbx_Settings.cfm
 fbx_Switch.cfm
 lay_adminLayout.cfm
 test.cfm

 N.B. no index.cfm ...





 -Original Message-
 From: Timothy Heald [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 21, 2002 3:30 PM
 To: CF-Talk
 Subject: RE: fusebox 3.0 help needed


 I am not sure how you are going about relocating to another page by using
 cfinclude.  In Fb3, and cf development in general, I will usually use a
 javascript location.

 Something along the lines of:

 SCRIPT
   document.locaction.href=index.cfm?fuseaction=this.that;
 /SCRIPT

 I am not sure why you are getting a 404 error.  Are you
 continuing to route
 your calls through the root level index.cfm, or are you making a call to a
 circuit directly?

 Tim Heald
 ACP/CCFD :)
 Application Development
 www.schoollink.net

  -Original Message-
  From: John McCosker [mailto:[EMAIL PROTECTED]]
  Sent: Friday, June 21, 2002 10:15 AM
  To: CF-Talk
  Subject: fusebox 3.0 help needed
 
 
  Greetings,
 
  I need some help here guys and gals,
  I am seriously confused with FB 3,
 
  bearing in mind I am migrating from ver 1 to 3 skipping 2,
  the problem is when I post a form validate it and then relocate to
  a different directory using CFINCLUDE (BECAUSE I AM SETTING A COOKIE),
  i get a HTTP/1.0 404 Object Not Found,
 
  the sample app I downloaded (simpsons) is a bad example to
  be honest because it does not cover the problem when posting data only
  circuit nesting, and I don't see the advantages of that anyway to be
  painfully honest.
 
  I don't know if I need an index file in each directory, because
 the sample
  app
  does not,
 
  I understand #fusebox.layout# and its relationship with FBX_switch,
  I don't want to post any code unless someone is prepared to
 identify where
  I am going wrong,
 
  you'll probably spot it quicker than me if you have been
  developing with FB3
  for a while,
 
  any one want to help me out here,
 
  Respectfully,
 
  j
 

 


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



RE: MAX function problem

2002-05-29 Thread Margaret Fisk

The problem is that your As TheID needs to appear immediately after Max(ID)
like so:
SELECT MAX(ID) AS TheID FROM UserInfo 

The way you have it actually is renaming the table not the result.

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 10:28 AM
To: CF-Talk
Subject: MAX function problem


Hello,

Everytime I use this function I have problems. My code is below. I keep 
receiving an error saying:

The column THEID is not present in the query named GETID

CFQUERY datasource=#dsn# name=GetID
SELECT MAX(ID) FROM UserInfo AS TheID
/CFQUERY

CFOUTPUT#GetID.TheID#/CFOUTPUT

thanks for your help,

Sal



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: populate a table

2002-05-28 Thread Margaret Fisk

You need to remove from selectedvendor from your query since you are
performing an insert not a select.

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 8:47 AM
To: CF-Talk
Subject: populate a table


Hello,

If a user selects a vendor from a drop-down list, I want to populate a form
and main table called purchases with the info from the vendor data that I
have in stored in another table called vendor. Here is some of the code
that checks the option field in the drop-down menu. I get a syntax error
with this though.

Any better way?

Robert O.

CFIF selectvendor is not New Vendor
cfquery name=addvendor datasource=purchases
INSERT INTO purchases (
vendor,
Contact,
Address)
VALUES (
'#FORM.vendor#',
'#FORM.contact#',
'#FORM.Address#')
from selectedvendor
/cfquery
/CFIF

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Strange SQL error

2002-05-17 Thread Margaret Fisk

Something that's happened to me before is that, depending on what you 
used to write the code originally, a hidden illegal character may have been
introduced. When you moved it, once again depending on what you were using,
the
cut and paste would eliminate any illegal characters.

I usually pass code through notepad if I've touched anything like Word or
Wordpad 
for example because of the illegal characters.

Margaret

-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:25 AM
To: CF-Talk
Subject: RE: Strange SQL error


What Andy meant was that he moved the @JuryTitle param to the bottom of the
list like so:
-- Any parameters here
@CountryID  int 
,   @JuryName   varchar(100)
,   @JuryCompanyvarchar(50) 
,   @JuryCity   varchar(50) 
,   @JuryTypeID int 
,   @JuryTitle  varchar(50) 

@JuryTitle was originally declared after the second param @JuryName.

For some reason the SP then released perfectly.  Bizarrely I then moved the
@JuryTitle param back to where it was and then the SP relases again.  For
the last 2 hours the SP would not release and we are at a loss as to why it
didn't work.

Any Ideas SQL gurus what may have happened?

-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:10
To: CF-Talk
Subject: RE: Strange SQL error


uh?

 -Original Message-
 From: Andy Ewings [mailto:[EMAIL PROTECTED]]
 Sent: 17 May 2002 17:18
 To: CF-Talk
 Subject: RE: Strange SQL error
 
 
 Right fixed it - all we did was to move the declaration of 
 the JuryTitle
 param to the bottom of the list and itr works! SQL schmeequel
 
 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 17 May 2002 16:50
 To: CF-Talk
 Subject: RE: Strange SQL error
 
 
 I assume in this bit:
 
   VALUES  (
   @CountryID
   ,   @JuryName
   ,   @test
   ,   @JuryCompany
   ,   @JuryCity
   ,   @JuryTypeID
   
 
 you're actually using 
 
   VALUES  (
   @CountryID
   ,   @JuryName
   ,   @JuryTitle
   ,   @JuryCompany
   ,   @JuryCity
   ,   @JuryTypeID
   
 
 ?
 
  -Original Message-
  From: Andy Ewings [mailto:[EMAIL PROTECTED]]
  Sent: 17 May 2002 16:56
  To: CF-Talk
  Subject: Strange SQL error
  
  
  In all my time developing SQL I have never come across sommat 
  like this -
  please someone tell me I'm being stoopid as it's a Fri
  afternoon.
  I have the following SP which refuses to release - it says it 
  cannot find
  parameter @JuryTitle.  If I comment out @JuryTitle and the 
  corresponding
  field insert it works.  If I change the name of the variable it
  doesn'tsomeone slap me with a kipper so I can see 
  where I've
  gone wrong...
  
  CREATE PROCEDURE JuryInsert
  
  -- Any parameters here
  @CountryID  int 
  ,   @JuryName   varchar(100)
  ,   @JuryTitle  varchar(50) 
  ,   @JuryCompanyvarchar(50) 
  ,   @JuryCity   varchar(50) 
  ,   @JuryTypeID int 
  
  AS
  
  BEGIN
  
  INSERT INTO tblJury (
  CountryID
  ,   JuryName
  ,   JuryTitle
  ,   JuryCompany
  ,   JuryCity
  ,   JuryTypeID
  )
  VALUES  (
  @CountryID
  ,   @JuryName
  ,   @test
  ,   @JuryCompany
  ,   @JuryCity
  ,   @JuryTypeID
  )
  
  IF @@error  0
  BEGIN
  GOTO ERROR_EXIT
  END
  
  RETURN @@error
  
  ERROR_EXIT:
  RETURN @@error
  
  
  END
  GO
  -- 
  Andy Ewings
  Director 
  Thoughtbubble Ltd
  http://www.thoughtbubble.net 
  -- 
  United Kingdom 
  http://www.thoughtbubble.net 
  Tel: +44 (0) 20 7387 8890 
  -- 
  New Zealand 
  http://www.thoughtbubble.co.nz/ 
  Tel: +64 (0) 9 419 4235 
  -- 
  The information in this email and in any attachments is 
  confidential and
  intended solely for the attention and use of the named 
  addressee(s). Any
  views or opinions presented are solely those of the author 
 and do not
  necessarily represent those of Thoughtbubble. This 
 information may be
  subject to legal, professional or other privilege and further 
  distribution
  of it is strictly prohibited without our authority. If you 
 are not the
  intended recipient, you are not authorised to disclose, copy, 
  

RE: Is there any way to touch a file and update its dateLastMod ified?

2002-05-17 Thread Margaret Fisk

Thanks Dave, your script is probably exactly what I need.
And yes, I know it is common on Unix, but I'm working on 
Windows. Every once in a while I get frustrated by the differences :-)

Margaret

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:37 PM
To: CF-Talk
Subject: RE: Is there any way to touch a file and update its
dateLastMod ified?


 Is there any way to touch a file and update its 
 dateLastModified?

There's a utility called touch, which will do this. It's common on
Unix/Linux systems, and it's part of the Cygwin distribution that you can
use on Windows. I wouldn't be surprised if there were versions of touch
available for Windows outside of Cygwin, either.

 I'm trying to archive files after 5 days that are moved 
 over to the CF server for download but they are retaining 
 their dateLastModified from their original location. I've 
 checked the file properties in the OS and the date created 
 is the value I want because it shows when they were copied 
 into the folder. How do I access date created as opposed 
 to dateLastModified?

Unfortunately, I don't think you can get that from CFDIRECTORY. If you're on
Windows, you can access the COM interface to the filesystem:

cfscript
strFile = d:\sample_file.txt;
fso = CreateObject(COM, Scripting.FileSystemObject);
f = fso.GetFile(strFile);
WriteOutput(DateFormat(f.DateCreated));
/cfscript

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

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



RE: Subquery from the same table: Is it possible??

2002-05-16 Thread Margaret Fisk

You have to join the two tables even if it is the same one. However, this
particular query makes no sense. This type of technique is best with the key
manager where they have a connected key so you do something like this:

Select * from tbl_users where role = (select role from tbl_users a,tbl_users
b
where a.role_owner=b.role and a.username =
'#session.username#')

this would be a case where role_owner is the manager and the role_owner key
is matched to the role key for the subordinates.

Margaret

cfquery name=GetKeyUser datasource=lsar_beta
select  fullname, role
fromtbl_users a
where   fullname IN (select fullname
from tbl_users a,tbl_users b
where a.username=b.username and username =
'#session.username#')
/cfquery

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 8:07 AM
To: CF-Talk
Subject: RE: Subquery from the same table: Is it possible??


almost like the same output I got with this, but it produces the same name
in both fields. My code prodcues two instances of USER and your code
produces two instances of the KEY USER. Getting closer though...



cfquery name=GetKeyUser datasource=lsar_beta
select  fullname, role
fromtbl_users
where   fullname IN (select fullname
from tbl_users
where username = '#session.username#')
/cfquery



-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 11:06 AM
To: CF-Talk
Subject: RE: Subquery from the same table: Is it possible??


cfquery name=GetKeyUser datasource=lsar_beta
select fullname, role
from tbl_users
whererole = (   select 'key_'  role as keyrole
from tbl_users
where username = '#session.username#')
/cfquery


See if that works for you.  It's an educated guess.

- Matt Small


-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 10:47 AM
To: CF-Talk
Subject: RE: Subquery from the same table: Is it possible??

ok. Interesting. Here is my situation. I will try to explain it has best
I
can.

I have a response form that inserts the user into one field via session
variable. The other field needs another name based on the role of the
first.
ROLE is a field in my database. Here is an example:

USERNAMEFULLNAMEROLE
djohnsonDenise Johnson  key_user_miller
twendel Tom Wendel  user_miller

If Tom Wendel opens a response form, his name is inserted into a field
called 'sender'. I want the 'receiver' to be Denise Johnson. This is but
one
possible scenario as I have one key user for a manager and several users
that fall under the same manager. Total of about 6 managers each with
one
key user to manage the users. Is this possible to use a subquery based
on
the way the data is structued now or do I need to make a change?


I tried something like this, but got an error which did not surprise me.

cfquery name=GetKeyUser datasource=lsar_beta
select fullname, role
from tbl_users
whereIN (select fullname
from tbl_users
where username = '#session.username#') AND
 role LIKE 'key_user%'
/cfquery






-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 10:18 AM
To: CF-Talk
Subject: RE: Subquery from the same table: Is it possible??


 Is it possible to have a subquery from the same table to
 output data based on a certain condition?

Yes. It's called a correlated subquery. It's described very well in the
SQL
Server Books Online:

Many queries can be evaluated by executing the subquery once and
substituting the resulting value or values into the WHERE clause of the
outer query. In queries that include a correlated subquery (also known
as a
repeating subquery), the subquery depends on the outer query for its
values.
This means that the subquery is executed repeatedly, once for each row
that
might be selected by the outer query.

This query finds the names of all authors who earn 100 percent of the
shared
royalty (royaltyper) on a book.

USE pubs
SELECT au_lname, au_fname
FROM authors
WHERE 100 IN
   (SELECT royaltyper
   FROM titleauthor
   WHERE titleauthor.au_ID = authors.au_id)

Here is the result set:

au_lname au_fname
 
WhiteJohnson
GreenMarjorie
Carson   Cheryl
Straight Dean
Locksley Charlene
Blotchet-Halls   Reginald
del Castillo   

RE: How to detect timeout session??

2002-05-16 Thread Margaret Fisk

I do a similar check but at the top of the page so it also catches people
who haven't logged in at all. If the session variables are not defined or
don't have the correct values (clicking logout changes to invalid value)
then it redirects to the login page. This is both security for direct calls
to the individual page and manages session timeouts in one.

Margaret

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 9:21 AM
To: CF-Talk
Subject: RE: How to detect timeout session??


put this in application.cfm

cfif (logic to check timeout)
cfset fuseAction = login // fusebox style
OR
cflocation url=login.cfm // be careful here that you don't end
up in an endless loop since application.cfm will be called again when the
location happens
/cfif

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Mario Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 8:50 AM
To: CF-Talk
Subject: How to detect timeout session??


Hi friends:
I need to find an easy way to detect timeout session to redirect the user to
a login page in case he  has spent too much time without actvity.
Any easy way to detect that at the beginning of one template???

regards and thanks in advance
Mario



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Is there any way to touch a file and update its dateLastModifie d?

2002-05-16 Thread Margaret Fisk

Is there any way to touch a file and update its dateLastModified?

I'm trying to archive files after 5 days that are moved over to the CF
server for download but they are retaining their dateLastModified from their
original location. I've checked the file properties in the OS and the date
created is the value I want because it shows when they were copied into the
folder. How do I access date created as opposed to dateLastModified?

Thanks in advance,
Margaret

-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 9:43 AM
To: CF-Talk
Subject: OT : js submit into new window...


Is there a way to submit a form into a new window, on somebody else's
server, and control it's properties (size, status bars, etc)?  Right now,
I'm using the target attribute in the form tag, but I'd like to have more
control over the the window...TIA-

Tyler Silcox
email | [EMAIL PROTECTED]



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Can this be done?

2002-05-15 Thread Margaret Fisk

One way you can do this is to keep a count of the items in the list and when
the count is equal to X, create a new cell. Have the count restart every
time you create a new cell (td) and don't forget to close your previous
one. You can even have the X variable be something a user can set.

Margaret

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 9:57 AM
To: CF-Talk
Subject: Re: Can this be done?


Hi,

This might be a crazy question but here it goes.

I'm using cfdirectory to list files on our server. Some directories can 
have a 100+ files in them. Presently I'm displaying the list down the left 
side of my webpage under each other.

file1.txt
file2.txt
file3.txt
file4.txt
file5.txt
etc...

I was wondering if there is a way automatically using a table to do the 
following and if so, how?


file1.txt   file5.txt   file9.txt file13.txt   file17.txt
file2.txt   file6.txt   file10.txt   file14.txt   file18.txt
file3.txt   file7.txt   file11.txt   file15.txt   file19.txt
file4.txt   file8.txt   file12.txt   file16.txt   file20.txt



+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



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



RE: [admin] List status

2002-05-14 Thread Margaret Fisk

Actually, we just priced this:

It is about $5000 per cpu if you get SQL Server Standard edition and about
20,000 (not sure about this one) per cpu if you want Enterprise edition. The
difference between the editions is failover and uptime tools.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 3:07 PM
To: CF-Talk
Subject: RE: [admin] List status


At 04:42 PM 5/14/02, you wrote:
I would chip in.  Have a fund raiser Mike. I am not too familiar with
SQL Server costs, what would it cost?
No clue. I've already started the ball rolling for it and whatever it costs
will be taken care of. Donations from people on the list, from pocket,
whatever. It's needed and it's going in.




-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, May 14, 2002 3:39 PM
To: CF-Talk
Subject: RE: [admin] List status

Being able to search the archives might even be worth a donation to many
of us.  I know it would help me out on occasion.  It would greatly
reduce the number of emails I save in my CF Archive folder.

Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525

 [EMAIL PROTECTED] 05/14/02 03:42PM 
Wow, searching the archives would be 'the heat'! how can we help to get
the
sql box online?

Tony Gruen







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



RE: what is causing this mail server error???

2002-05-14 Thread Margaret Fisk

Hi all, 

I periodically get the No connection to mail server error in my mail log and
my mail is moved to undeliverable. It seems to be a timing issue or load
issue because the server is always available.

I have two questions:
1) Is there some bug that I can add a patch for that is responsible?
2) Can I configure my system to try again when this happens?

I realize I could create a cf page that just moves the files back into spool
based on the error message, but I was wondering if there was a better
solution.

Thanks,
Margaret


Failed to send the spooled mail file, 41B.cfmail. SMTP server replied No
connection to mail server.
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Problem with comparenocase vs is in CFIF

2002-05-09 Thread Margaret Fisk

Hi everyone,

I'm experiencing a strange error that I can't figure out and was hoping for
some help. I've included the problem code below.

Here is what I'm doing:
I have a form that includes a report table. Each of the headers is a submit
button with the name sort_order and the value of the text that displays
(taken from the columnlist variable below). I also pass the previous
sort_order button in a hidden field called sort_order_hidden so if the user
choses the next 10 records, they will still be sorted by the selected value.

I started with using is to compare the list value for the display names
with the button value (which is the display name). However, on one of my
pages, only when passing the sort order through the hidden field (the
CFELSEIF), it does not find any matching value when running the statement
CFIF a[i] is Form.sort_order_hidden (I displayed the results and the value
is there, but it is not considered a match. I changed to the code to CFIF
comparenocase(sort_order_display,a[i]) and now it matches the first value
(or when I remove the CFBREAK, the last value) in the loop even if for
example, the list item is Company Name and the Form.sort_order_hidden is
Phone.

As you can tell, I'm stumped and would appreciate any advice, assistance
etc.

Thanks in advance,
Margaret

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Problem with comparenocase vs is in CFIF

2002-05-09 Thread Margaret Fisk

Thanks for all the help I know I would have gotten, but I figured it out.

Human error of course :-)
In my columnlist, I am doing a comma delimited list but to make it more
readable, I have a space in front of the values. In my default, I didn't
include the space. It only affected this page because the other pages have
the first value as the default sort.

Sorry,
Margaret

-Original Message-
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:19 PM
To: CF-Talk
Subject: RE: Problem with comparenocase vs is in CFIF 


Hi everyone,

I'm experiencing a strange error that I can't figure out and was hoping for
some help. I've included the problem code below.

Here is what I'm doing:
I have a form that includes a report table. Each of the headers is a submit
button with the name sort_order and the value of the text that displays
(taken from the columnlist variable below). I also pass the previous
sort_order button in a hidden field called sort_order_hidden so if the user
choses the next 10 records, they will still be sorted by the selected value.

I started with using is to compare the list value for the display names
with the button value (which is the display name). However, on one of my
pages, only when passing the sort order through the hidden field (the
CFELSEIF), it does not find any matching value when running the statement
CFIF a[i] is Form.sort_order_hidden (I displayed the results and the value
is there, but it is not considered a match. I changed to the code to CFIF
comparenocase(sort_order_display,a[i]) and now it matches the first value
(or when I remove the CFBREAK, the last value) in the loop even if for
example, the list item is Company Name and the Form.sort_order_hidden is
Phone.

As you can tell, I'm stumped and would appreciate any advice, assistance
etc.

Thanks in advance,
Margaret


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Determine if file is there

2002-05-06 Thread Margaret Fisk

You could use CFdirectory. That only gets the directory listing which you
can loop through to find the file or files.

-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 7:59 AM
To: CF-Talk
Subject: Determine if file is there


Is there an easy way, without reading the entire file to determine if a 
file exsists on the server?


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



RE: Do I need to lock around queries?

2002-05-06 Thread Margaret Fisk

Sorry I don't have an answer for you, but I do have another question on the 
locking issue

When you put a variable in your application.cfm (for example, your DSN
name), 
is it automatically an application scope variable requiring application
locking
whether or not you use application.DSN rather than just DSN?

And if it is not an application scope variable, what is its scope? 

Thanks in advance,
Margaret

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 8:44 AM
To: CF-Talk
Subject: RE: Do I need to lock around queries?


 Would locking include such things as checking if statements, ie:

   CFIF NOT IsDefined (SESSION.var)
   Run some code
   /CFIF

You only need to lock to update, reading does not need a Lock, unless
you're REALLY paranoid about it changing information while your code is
running

Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911

www.aspmedia.co.uk
www.aspevents.net

An ISO9001 registered company.

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



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Do I need to lock around queries?

2002-05-06 Thread Margaret Fisk

Thanks. I'll look up type variables to figure out how to treat them.

-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 9:01 AM
To: CF-Talk
Subject: RE: Do I need to lock around queries?


No.  Default unless fully qualified is type variables, not application

Andy

-Original Message-
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 10:55 AM
To: CF-Talk
Subject: RE: Do I need to lock around queries?


Sorry I don't have an answer for you, but I do have another question on the
locking issue

When you put a variable in your application.cfm (for example, your DSN
name),
is it automatically an application scope variable requiring application
locking
whether or not you use application.DSN rather than just DSN?

And if it is not an application scope variable, what is its scope?

Thanks in advance,
Margaret

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 8:44 AM
To: CF-Talk
Subject: RE: Do I need to lock around queries?


 Would locking include such things as checking if statements, ie:

   CFIF NOT IsDefined (SESSION.var)
   Run some code
   /CFIF

You only need to lock to update, reading does not need a Lock, unless
you're REALLY paranoid about it changing information while your code is
running

Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911

www.aspmedia.co.uk
www.aspevents.net

An ISO9001 registered company.

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





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



RE: Left Outer Join - Lotsa Pain!

2002-05-06 Thread Margaret Fisk

The easiest way to get the Access SQL is to construct the statement in 
the Access GUI. Then you can test out your query as well. 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 9:47 AM
To: CF-Talk
Subject: RE: Left Outer Join - Lotsa Pain!


So how would I write it for Access? Would I still use the WHERE
statement?
It's the syntax for Access that really throws me for a loop!

FROM pl_companies LEFT OUTER JOIN (pl_category, pl_join,
pl_joincatbrand, pl_brands)

Thanks,
Mark


-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]] 
Sent: Monday, May 06, 2002 12:13 PM
To: CF-Talk
Subject: Re: Left Outer Join - Lotsa Pain!


mark,

try using left outer join to join *all* of your tables, starting with
pl_companies and ending with pl_brands.

~ dina


 WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND 
 pl_category.prl_cat_ID =  pl_joincatbrand.prl_cat_ID AND 
 pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID  = 
 pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID

 ORDER BY pl_companies.co_name ASC


- Original Message -
From: Mark Leder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 06, 2002 10:10 AM
Subject: Left Outer Join - Lotsa Pain!


 This query is being run on MSAccess 2002.

 I want to do a LEFT OUTER JOIN so that all company names are
returned
 based on a product CATEGORY, even though they may not have a
product
 BRAND associated with them. (I used a joining table, pl_join,
because
 one company may have many brands; the pl_joincatbrand table is
used as a
 joining table because one brand may belong to many categories).

 The query statement below works properly, but will not bring
back
 company names that do not have a brand.  I've tried a number of
ways to
 do a LOJ in the FROM statement, but I can't get it to work
where there
 are more than two tables involved. (ie, FROM pl_companies LEFT
OUTER
 JOIN pl_join ON pl_companies.pl_ID = pl_join.pl_ID)

 Your help is greatly appreciated, as my head is getting really
sore
 banging it on the desk for the past 7 hours trying to get this
to work
 right.

 Mark
 

 SELECT *
 FROM pl_category, pl_join, pl_companies, pl_joincatbrand,
pl_brands

 WHERE pl_category.prl_cat_ID = #FORM.prl_cat_ID# AND 
 pl_category.prl_cat_ID =  pl_joincatbrand.prl_cat_ID AND 
 pl_Brands.pl_BID = pl_joincatbrand.pl_BID AND pl_Brands.pl_BID  = 
 pl_join.pl_BID AND pl_join.pl_ID = pl_companies.pl_ID

 ORDER BY pl_companies.co_name ASC

 Thanks,
 Mark





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



RE: transact-sql datediff function

2002-05-06 Thread Margaret Fisk

Just a guess, but in the datediff you are just extracting the year. If you
want to include the 
month in the calculation, you should probably get the month part too.

Margaret

-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 11:20 AM
To: CF-Talk
Subject: OT: transact-sql datediff function


hi all,

i posted this on the sql list but got no response.

i have a test table named employees with the following fields:

fname varchar
lname varchar
hire_date datetime

the record i'm querying contains 2001-05-11 00:00:00.000 in the
hire_date field. but this query returns 1 rather than the
expected 0:

select datediff(yy, hire_date, getdate()) as yearsdiff from
employees where fname = 'ann'

this should give me the number of years between 5/11/2001 and
today's date of 5/6/2002, which should be 0 since it's not 5/11
yet. so why am i getting 1???

~ dina


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL and singlequotes

2002-05-06 Thread Margaret Fisk

Are you doubling all your single quotes in the phrases where you are
preserving single quotes?

I've had this problem in the past where Oracle reads the sql as:

Insert into tablea
(lastname)
values
('o'dell')
as 'o' and dies or ignores dell.

Need to write:
Insert into tablea
(lastname)
values
('o''dell')
And then it usually works.

Margaret

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 12:26 PM
To: CF-Talk
Subject: SQL and singlequotes


Preservesinglequote() not working or are we missing something?  Here is
our code, and the resulting error from a user:

cfquery name=putitin datasource=mrskellystea username=#tea.user#
password=#tea.pass#
Insert Into Feedback (comment, sitecomment, tearequest, okforemail,
response, firstname, lastname, email, timedate)
VALUES('#preservesinglequotes(form.comments)#',
'#preservesinglequotes(form.sitesuggestions)#',
'#preservesinglequotes(form.tearequests)#', '#form.teamail#',
'#form.pleaserespond#', '#form.fname#', '#form.lname#',
'#form.email_address#', #setdate#)
/cfquery


[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near 't'.


SQL = Insert Into Feedback (comment, sitecomment, tearequest,
okforemail, response, firstname, lastname, email, timedate) VALUES('I
don't know if you got my message. Am looking for Mrs. Kelly's Special
Jasmine tea. Is that the same as your Jasmine Special Grade? Is that the
only Jasmine tea you carry? Do you have any hibiscus teas? ', '', '',
'n', 'n', 'Barb', 'Chapman', '[EMAIL PROTECTED]', {d
'2002-05-06'})
Regards,

Eric J. Hoffman
Director of Internet Development
DataStream Connexion, LLC
(formerly Small Dog Design)




__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Problem with CFHeader and CFCONTENT

2002-05-03 Thread Margaret Fisk

Hi all,

I'm having a problem with the CFHeader tag and the CFContent tag combination
and hoped someone had a way around it.

I am trying to force browsers to download a file rather than launching it in
their plugins while also masking the actual location of the file.

Thanks to Shawn, I've gotten far enough that the functionality is correct,
but I'm running into an annoying display issue.

My code is below. This is what happens:

To force the browser to save rather than opening the file in the browsers,
you have to use the attachment value in the CFHeader (as far as I can tell.)

When you use the attachment value, two things go wrong:

1) The filename displayed in the File Download dialog is actually the full
URL with query string that you call to launch files this way, (i.e.
getfile.cfm?file=george.txttype=petercomment=what is the meaning of 42),
of course only actually the last 20-40 characters display.

2) If you select Open file from this location, on one of my test systems, it
actually opens the File Download dialog again. (This may be a fluke since
its not on the other system.

CFSET actualname=#URLDecode(URL.file)#
CFHEADER NAME=Content-Disposition VALUE=attachment;
filename=#actualname#
cfcontent type=nothing/unknown
file=#filepath# deletefile=No

I'd appreciate any suggestions or even just the answer that I have to live
with it. I've tried a bunch of stuff, but the only way to get the filename
back into the display is to take out attachment from the CFHEADER value and
that will not work.

Thanks in advance,
Margaret
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Email Time Off Unix

2002-05-02 Thread Margaret Fisk

Have you checked the message in another viewer other than MS Outlook?
Outlook puts its own interpretation on the date and may think it is in a
different time zone. We had that problem for messages between two Exchange
servers.

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 2:27 PM
To: CF-Talk
Subject: Email Time Off Unix


I am running CF4.5 on solaris.
When I send an email with cfmail the resulting email's sent time (in MS
Outlook) is 1 hour ahead. The date and time on the unix server is
correct. When I send an email from the shell the resulting email's sent
time is correct.When I cfoutput now() to a browser window I get the 
correct time.

Anyone come across this? 


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



RE: output cf to html

2002-05-01 Thread Margaret Fisk

Just schedule it on your CF server in Administration Tools.

Delete the original file
Create a new file
Write the report + html coding to the file.

Or am I missing the point?

Margaret

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 2:35 PM
To: CF-Talk
Subject: output cf to html


I have this Huge Honking report
written in cf

it shows exactly what i want.

but i don't want a user to run this report every time they hit the page.

i would like to know how to
have cf-server
run the page...
but just save it to html
every night.

so that it gets updated basically once a day.
instead of hitting the db every time some one views the cfm page..

any ideas?

-paul

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: masking URLs and cflocation

2002-05-01 Thread Margaret Fisk

Hi everyone,

I know there is a way to do this (at least the URL masking), but I can't
find any answers. I may be asking the wrong questions but...


Currently:
I have a page that displays the files available for download with hrefs to
download them.
The user clicks the href and the files either launches in another browser or
downloads.
The URL is listed both on the href and in the browser address.


Here is what I want to do:
I want the page to list the files available for download (preferably not as
buttons but that's livable)
User clicks the link to download (this is not an href so the URL is not
displayed)
The document/file download launches (cflocation?) in another browser window
but the address line displays a default address rather than the true URL.

I'd prefer to do this with Cold Fusion rather than JavaScript because not
everyone can run JavaScript, but I am willing to be flexible on that if it
will work.

Thanks in advance,
Margaret
 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: masking URLs and cflocation

2002-05-01 Thread Margaret Fisk

Thanks for the correction. It looks like it might be exactly what I need.
I'll need to play with it first of course :-)

-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 4:11 PM
To: CF-Talk
Subject: RE: masking URLs and cflocation


oops

http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=cf_
download


-- Sam


-Original Message-
From: Sam Roach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 4:07 PM
To: CF-Talk
Subject: RE: masking URLs and cflocation


Try cf_download

http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347854-2830-11D4
-AA9700508B94F380method=Full


-- Sam


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 4:00 PM
To: CF-Talk
Subject: RE: masking URLs and cflocation


I've hidden the URL to a specific file through the use of a special page
and the CFContent tag.

For instance, if I asked for a file that was named MyFile.gif, the URL of
the link to the file would be something like getfile.cfm?FileID=44.  The
end result is that the user would download MyFile.gif (with the same
filename in the save as window), without ever knowing where MyFile.gif
actually resided.

Tying this in with the use of the status bar (onmouseover, blank the status
bar value), then you would effectively hide the URL to the specific file.

Not sure if that's quite what you want, but hope it helps.

Shawn Gover

-Original Message-
From: Margaret Fisk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 4:46 PM
To: CF-Talk
Subject: RE: masking URLs and cflocation


Hi everyone,

I know there is a way to do this (at least the URL masking), but I can't
find any answers. I may be asking the wrong questions but...


Currently:
I have a page that displays the files available for download with hrefs to
download them.
The user clicks the href and the files either launches in another browser or
downloads.
The URL is listed both on the href and in the browser address.


Here is what I want to do:
I want the page to list the files available for download (preferably not as
buttons but that's livable)
User clicks the link to download (this is not an href so the URL is not
displayed)
The document/file download launches (cflocation?) in another browser window
but the address line displays a default address rather than the true URL.

I'd prefer to do this with Cold Fusion rather than JavaScript because not
everyone can run JavaScript, but I am willing to be flexible on that if it
will work.

Thanks in advance,
Margaret





__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists