RE: reading a text file into a query??

[Steve Martin]

Check out the query functions: QueryNew(), QueryAddRow(), QuerySetCell()
along with CFFILE and a bit of looping and a liberal sprinkling of list
functions should do the trick.

Steve

> -Original Message-
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: 21 December 2001 15:08
> To: CF-Talk
> Subject: reading a text file into a query??
> 
> 
> Sinze I'm having so much trouble using cfhttp to read a txt 
> file in then
> output it as a query is there any other way that I can do 
> this with CF???
> 
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: "Form Processing" Page

[Steve Martin]

function startWaiting()
{
page.style.display='none';
waiting.style.display='block';
}












  


Insert normal page content here



Steve

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 20 December 2001 08:16
> To: CF-Talk
> Subject: Re: "Form Processing" Page
> 
> 
> I'm pretty new to CF, but can't you use cfflush to output bits of html
> before and during the processing?
> 
> chris
> 
> on 12/20/01 7:54 AM, Alex at [EMAIL PROTECTED] wrote:
> 
> > put it in a frame. have the top say waiting or background 
> color change or
> > image ; have the bottom process your form. In your bottomm 
> have onload
> > kill the top.
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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 Attacks (was Forms and CF Code)

[Steve Martin]

One should use parameterised SQL to get around that

For example:


Select *
>From MyTable
Where SomeField = 



> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 16:38
> To: CF-Talk
> Subject: Re: SQL Attacks (was Forms and CF Code)
> 
> 
> I have a page up which discusses this 
> http://www.vawter.com/urlhack.cfm
> 
> - Original Message -
> From: "Shawn Grover" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 19, 2001 9:32 AM
> Subject: RE: SQL Attacks (was Forms and CF Code)
> 
> 
> > Don't forget the SQL attacks - similar to the type of 
> attack we've been
> > discussing, but not addressed thus far.
> > Something like this:
> >
> > 
> > Select *
> > From MyTable
> > Where SomeField = #Form.SomeField#
> > 
> >
> > now if Form.SomeField were "b'; use dbname; drop table 
> tablename; --'"
> >
> > then The original query would get executed with 'b' as the 
> filter, but
> then
> > standard SQL commands are issued.  The "--'" ensures that anything
> following
> > this point is treated as a comment.  try it out on one of 
> YOUR sites -
> > except maybe replace the drop table statement with a select or
> something...
> >
> > Protect against this by using stored procedures where 
> possible and/or
> doing
> > some sort of filter.  The preservesinglequotes might help 
> with this too,
> not
> > sure.
> >
> > No, I'm not revealing anything new here - I learned the 
> details of this at
> > the MS PDC conference in LA, and know I've seen reference 
> to the issue on
> > the list a few times.
> >
> > Here's hoping that mentioning it here helps improve some sites.
> >
> > Shawn Grover
> >
> > -Original Message-
> >
> > This is bad for multiple reasons. I don't deny that many 
> people do it,
> > but as a reminder, it's much easier, and quicker, to do:
> >
> > 
> >
> > Furthermore, this is only an issue if you pass a _function_ as you
> > describe below.
> >
> >
> > > In testing somebodies site I have used this to slow his site
> > > to a crawl
> > > by making a custom form with code like:
> > > 
> > > 
> > > 
> >
> > Interesting. Good point. This is one more reason why we 
> need to preach
> > to people to NOT use evaluate to get form fields. I need to go on a
> > crusade or something. ;)
> >
> > 
> ===> 
> > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
> >
> > Email: [EMAIL PROTECTED]
> > Yahoo IM : morpheus
> >
> > "My ally is the Force, and a powerful ally it is." - Yoda
> >
> > 
> 
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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: Forms and CF Code

[Steve Martin]

Just spotted this thread. Surely, unless the scenario referred to by Ray
is encountered you should simply HTMLEditFormat() any user submitted
output in order to escape any special characters.

> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 15:44
> To: CF-Talk
> Subject: RE: Forms and CF Code
> 
> 
> Why would anyone need to clean cfcode? Unless you save user input to a
> file and cfinclude it, it will not get executed.
> 
> FYI, to clean HTML and stuff, look for StripHTML on cflib.org.
> 
> ===> 
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -Original Message-
> > From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] 
> > Sent: Tuesday, December 18, 2001 7:14 PM
> > To: CF-Talk
> > Subject: RE: Forms and CF Code
> > 
> > 
> > In addition to CF code, you may need to strip out other 
> > characters to avoid 
> > SQL hacks and such. If I can, I strip all < > ; # % * ' ( ) 
> > and , with 
> > REReplace or use REFind to detect the nasty ones and throw an error 
> > message, including sending an email message to me. < and > 
> > eliminate the 
> > functionality of . # can be icky if it comes up in a 
> > bad place. ( and 
> > ) missing will eliminate the functionality of a CF function. 
> > ; can be used 
> > in a query to do nasty things like execute a second SQL 
> > command in your 
> > CFQuery and drop your tables. % is a sql wildcard so a user 
> > could get more 
> > returns than you want them to. , has caused me a lot of 
> > problems when I try 
> > to dump the data to a text file. * just makes me nervous. *twitch*
> > 
> > At 04:02 PM 12/18/01 -0700, you wrote:
> > >I wrote a simple routine that would loop through all the 
> > form elements,
> > >strip out HTML, and change single quotes to chr(97).  It'd 
> > be easy enough to
> > >do something similar for cfcode - just check for the  > specific CF
> > >functions.  A simple search/replace, or regular expression 
> > can handle this.
> > >
> > >If you need it, I can dig out my routine, but it's simple 
> > enough that it can
> > >be recreated from scratch in about 30 minutes.
> > >
> 
__
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: Stripping last 4 characters from string

[Steve Martin]

ListFirst(GetFontFamily, ".")

> -Original Message-
> From: phumes1 [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2001 14:46
> To: CF-Talk
> Subject: Re: Stripping last 4 characters from string
> 
> 
> Hi,
> 
> I have a variable #GetFontFamily# which displays the results 
> "Garamond.fnt"
> 
> How can I strip off the ".fnt" and only display "Garamond" on my page?
> 
> 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: Bug I think

[Steve Martin]

True, but it isn't anything that you would normally do so there isn't
really anything to worry about there.

> -Original Message-
> From: David Brown [mailto:[EMAIL PROTECTED]]
> Sent: 17 December 2001 16:12
> To: CF-Talk
> Subject: Bug I think
> 
> 
>   Server Product ColdFusion Server
>  Version 4, 5, 1, SP2
>  Edition Professional
> 
> 
> Has anyone see this?
> 
> I am trying to find the firstdayofmonth(date) and then find what
> dayofweek(FirstDayofMonth(date)) is.
> 
> For example:
> 
> 
> 
> 
> #firstday# #Weekday# 
> 
> This will give you:
> 335 for firstday (12/1/01)
> 6 for Weekday(11/30/1900)
> 
> If you try to do a dateformat(firstday,"mm/dd/") you get 
> 11/30/1900 .
> You don't get an error reporting that you can't do that.  You 
> just get the
> wrong answer.
> 
> So I think that is a bug with CF 4.5.
> 
> 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

RE: BrainFART: CFQuery conditional excecution

[Steve Martin]

You mean like this:


   SELECT  ItemName, BrandName, RetailEach, RetailUnit, UnitSize, 
   DetailedDescription, ItemNumber, MainCategory, 
SubCategory1, SubCategory2
FROM MasterItemTable
WHERE 0=0
   
AND (SubCategory1 = '#SubCategory1#')
   
 OR (SubCategory2 = '#SubCategory2#')
   



Steve

> -Original Message-
> From: Richard L Smith [mailto:[EMAIL PROTECTED]]
> Sent: 17 December 2001 15:19
> To: CF-Talk
> Subject: BrainFART: CFQuery conditional excecution
> 
> 
> Hello,
> 
> I trying to get this cfquery to run based on what link the user
> clicks, i.e. if the user clicks 
> "somepage.cfm?SubCategory1=#SubCategory1#" then the first part of 
the 
> WHERE should execute else the the OR should execute.
> I have tried CFQueryParam to no avail, here is the code
> I am using so far. 
> 
> Rick
> 
>   datasource="dsMain"
>  dbtype="ODBC">
>SELECT  ItemName, BrandName, RetailEach, RetailUnit, UnitSize, 
>DetailedDescription, ItemNumber, MainCategory, 
> SubCategory1, SubCategory2
> FROM MasterItemTable
>
> WHERE (SubCategory1 = '#SubCategory1#')
>
>  OR (SubCategory2 = '#SubCategory2#')
>
> 
>  
> 
> 
~~
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: String ends

[Steve Martin]

ListLast(string, "*") eq "END"

> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: 17 December 2001 01:10
> To: CF-Talk
> Subject: Re: String ends
> 
> 
> len(st) GE 4 and right(st,4) EQ "*END"
> 
> (you need to check length because right(st,4) with give an 
> error if length
> is less than 4
> 
> - Original Message -
> From: "Parker, Kevin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, December 16, 2001 6:00 PM
> Subject: String ends
> 
> 
> > Can someone help a little here please (I left my copy of 
> Forta at home
> :-( I
> > am checking a string returned from a third party payment 
> gateway to see
> how
> > the gateway processed the payment request. There are a 
> number of possible
> > outcomes I check for (see one example in the code snippet 
> below) but I
> also
> > need to check that I received the entire string. In all 
> cases the gateway
> > returns strings which end with END and the delimiter in the 
> list is * so
> if
> > I get the complete string back I should see the string ending *END
> >
> > I am checking what the string contains to see how to 
> process it my end but
> > what is the best way to check that each string returned 
> finishes *END
> >
> >  CONTAINS "true")>
> >
> >
> >
> >
> > **
> >
> > Kevin Parker
> > Web Services Manager
> > WorkCover Corporation
> >
> > [EMAIL PROTECTED]
> > www.workcover.com
> >
> > p: 08 82332548
> > f: 08 82332000
> > m: 0418 806 166
> >
> > **
> >
> >
> >
> > 
> **
> **
> > This e-mail is intended for the use of the addressee only. It may
> > contain information that is protected by legislated confidentiality
> > and/or is legally privileged. If you are not the intended 
> recipient you
> > are prohibited from disseminating, distributing or copying 
> this e-mail.
> >
> > Any opinion expressed in this e-mail may not necessarily be 
> that of the
> > WorkCover Corporation of South Australia. Although precautions have
> > been taken, the sender cannot warrant that this e-mail or any files
> > transmitted with it are free of viruses or any other defect.
> >
> > If you have received this e-mail in error, please notify the sender
> > immediately by return e-mail and destroy the original e-mail and any
> > copies.
> > 
> 
~~
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: search a form

[Steve Martin]

1) See bottom of message

2) 

#form[field]#


Steve

> -Original Message-
> From: laurent hsld [mailto:[EMAIL PROTECTED]]
> Sent: 14 December 2001 13:46
> To: CF-Talk
> Subject: search a form
> 
> 
> Hello !
> 
> First of all, could one of you remind me the url where all the past 
> messages can be found ?
> 
> I would like to know if there is a way to loop through all the form 
> elements a bit in the same way that it could be done with 
> javascript with 
> document.form.elements[index] ...
> 
> Thanks for your help !
> 
> Laurent
> 
>  
> __
> 
> ifrance.com, l'email gratuit le plus complet de l'Internet !
> vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
> http://www.ifrance.com/_reloc/email.emailif
> 
> 
~~
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: CreateODBCDate

[Steve Martin]

CC,
Can I assume that you're having problems with dates being treated as
though they were being represented as MM/DD/YY? This is a common
stumbling block and sadly doesn't affect anyone in the US. I have
attached one of my many FAQs on this subject for your information.
Hope this is of use.

Steve

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 13 December 2001 02:14
> To: CF-Talk
> Subject: RE: CreateODBCDate
> 
> 
> Bruce -
> 
> Now when you say cf server clock, are you talking about the operating
> system clock the coldfusion server is running on, or is there 
> a separate
> setting which the coldfusion server keeps track of, and if it 
> keeps track
> of it is this a setting set when coldfusion is installed? Where in the
> administrator can I check this date/time setting? I havent 
> found one yet.
> 
> Thanks for your reply!
> CC
> 
> 
>   
>  
> "Dunwiddie,   
>  
> Bruce"   To: CF-Talk 
> <[EMAIL PROTECTED]>   
>   
> @henrywurst.cSubject: RE: 
> CreateODBCDate   
> om>   
>  
>   
>  
> 12/12/01  
>  
> 04:08 PM  
>  
> Please
>  
> respond to
>  
> cf-talk   
>  
>   
>  
>   
>  
> 
> 
> 
> 
> createodbcdate is a function all on it's own. it doesn't get 
> a date. you
> would have to use something like createodbcdate(now()) to get 
> a date, and
> now() would use the time according to the cf server clock.
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 12, 2001 3:06 PM
> To: CF-Talk
> Subject: CreateODBCDate
> 
> 
> Hello -
> 
> Can anyone tell me exactly where the createODBCdate function 
> in coldfusion
> gets its date from?  The problem we are running into is 
> dateadd function
> not working in the UK.  We think we've tracked the problem to the web
> server and not necessarily the coldfusion server itself 
> because we have the
> same version running in the same enviroment in the US.
> 
> Your insight is appreciated!
> CC
> 
> 
> 
~~
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: Releasing Access locks with Coldfusion?

[Steve Martin]

Are they still around? 
Ignoring the mem leak issues (or "the escapes of memory"  ;-) ) I recall
that Allaire recommended that connections should not be maintained to
Access dbs with CF3.x but changed the database pooling methods with 4.x+
and hence recommended that connections should be maintained. Obviously
they should have considered the mem leaks before giving this advice. Ho
hum.

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2001 17:44
> To: CF-Talk
> Subject: RE: Releasing Access locks with Coldfusion?
> 
> 
> > > You should never Maintain Database Connections on an Access 
> > > DB anyway.
> > 
> > Pourquoi?
> 
> En raison des fuites de mémoire ODBC!
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
~~
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: Releasing Access locks with Coldfusion?

[Steve Martin]

Porquoi?

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2001 17:27
> To: CF-Talk
> Subject: Re: Releasing Access locks with Coldfusion?
> 
> 
> On 12/12/01, Jon Hall penned:
> >You can also uncheck Maintain Database Connections in the CF 
> admin and the
> >database will never lock.
> 
> You should never Maintain Database Connections on an Access DB anyway.
> -- 
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 
~~
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: RE help needed: stripping tags from a string

[Steve Martin]

An alternative approach - try using the MS Office 2000 HTML filter:
http://download.microsoft.com/download/office2000prem/msohtmf/2000/WIN98
/EN-US/msohtmf2.exe

Steve

> -Original Message-
> From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2001 14:36
> To: CF-Talk
> Subject: RE help needed: stripping tags from a string
> 
> 
> Hi all,
> 
> I'm trying to get a regular expression working to replace some
> particularly horrible markup (yes it's Microsoft-generated) with
> something manageable. I'm trying to turn this string:
> 
>  
> Blah Blah Blah
> 
> Into this:
> 
>  | | | Blah Blah Blah |
> 
> So far I have this:
> 
> ]"," |
> ","ALL")>
> 
> to try and turn all paragraph tags into pipe characters flanked by
> spaces. But, instead of it matching any printable character from the
> first < to the first >, which is what I thought it should do, it's
> ignoring the first > and the second < and skipping to the second >. So
> the first two paragraph tags, instead of being converted to two pipes,
> are being converted to one. Argh!
> 
> If anyone can point out where I'm going wrong, I'd really 
> appreciate it.
> 
> K.
> 
~~
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: Does anyone see a problem with this query?

[Steve Martin]

Can't see anything to cause a syntax error but you do have a superfluous
WHERE clause as the expression is being handled by the join.

Could you post the CF code that generates the SQL pls.
Steve

> -Original Message-
> From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 16:49
> To: CF-Talk
> Subject: Re: Does anyone see a problem with this query?
> 
> 
> Here is the original post
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: 
> Incorrect syntax near
> '.'.
> 
> 
> 
> SELECT   topc.id,
>topc.topics,
>subt.id,
>subt.topic_id,
>subt.s_topics
> FROM  topics AS topc
> INNER JOIN sub_topics
> AS  subt
> ON  topc.id = subt.id
> WHERE   topc.id = subt.id
> 
> - Original Message -
> From: "Michael Haggerty" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 11, 2001 8:27 AM
> Subject: RE: Does anyone see a problem with this query?
> 
> 
> > What is the error you are getting?
> >
> > -Original Message-
> > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 11, 2001 11:39 AM
> > To: CF-Talk
> > Subject: Re: Does anyone see a problem with this query?
> >
> >
> > Absolutely nothing else.
> >
> >
> >
> > Doug
> >
> >
> >
> > - Original Message -
> > From: "Mike Connolly" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, December 11, 2001 2:12 AM
> > Subject: RE: Does anyone see a problem with this query?
> >
> >
> > > I don't know if I'm alone in this, but at first, second, and third
> glance
> > > your query syntax seems fine.
> > >
> > > Is there anything else to this query?
> > >
> > > -Original Message-
> > > From: Douglas Brown [mailto:[EMAIL PROTECTED]]
> > > Sent: 11 December 2001 00:42
> > > To: CF-Talk
> > > Subject: Does anyone see a problem with this query?
> > >
> > >
> > > I keep getting this error when I run the query. This is a SQL 2K
> > > database
> > >
> > > ODBC Error Code = 37000 (Syntax error or access violation)
> > >
> > >
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: 
> Incorrect syntax
> > > near '.'.
> > >
> > >
> > >
> > > SELECT   topc.id,
> > >topc.topics,
> > >subt.id,
> > >subt.topic_id,
> > >subt.s_topics
> > > FROM  topics AS topc
> > > INNER JOIN sub_topics
> > > AS  subt
> > > ON  topc.id = subt.id
> > > WHERE   topc.id = subt.id
> > >
> > >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Doug
> > >
> > >
> > >
> >
> > 
> 
~~
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: ODBC or OLE DB

[Steve Martin]

All my bit fields come back as 1/0 both in OLEDB and ODBC.
All my date fields are treated the same.
Text (VC, Text, etc.) fields, no probs.
Numerics - all OK

Anyone out there actually KNOW of any fundamental differences on the SQL
interface level?


> -Original Message-
> From: Craig Dudley [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 14:51
> To: CF-Talk
> Subject: RE: ODBC or OLE DB
> 
> 
> The last problem I had was runnign query a query on a 
> recordset returned via
> oledb, all the sql BIT fields were coming back as 'Yes' and 
> 'No' as oppossed
> to 0/1.
> 
> -Original Message-
> From: Steve Martin [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 14:28
> To: CF-Talk
> Subject: RE: ODBC or OLE DB
> 
> 
> I'm curious as to what differences you've found as I've used both
> interchangeably without any problems whatsoever. Could you possibly
> enumerate the differences for the benefit of the list.
> Cheers,
> Steve
> 
> > OLEDB handles dates and boolean fields slightly differently at times
> > (perhaps other data types too?), converting sites that use 
> > ODBC can be a
> > pain.
> > 
> > I've used both quite bit, and still don't have a preference. 
> > If I was trying
> > to decide which to use for a new site, then I would probably 
> > go with ODBC as
> 
> 
~~
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: Trimming Files

[Steve Martin]

Or just use Trim() on the variable containing the file content and then
write it out again.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 11 December 2001 14:44
> To: CF-Talk
> Subject: Re: Trimming Files
> 
> 
> Depending on what line separator(s) are used... you can do it 
> a few different ways.
> But ones that come to mind this instant are...
> 
> 1. Use a regular expression, I don't use the builtin regexp 
> coldfusion stuff
> 2. Search and replace on two instance of the separator(s), 
> then clean the last line, if exists
> 3. Loops lines and manually parse, removing 
> startline+whitespace+endline if it appears
> 4. Write or have someone write a simple custom tag that does 
> this if you need efficiency, future use, & ease.
> 
> - Original Message - 
> From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 11, 2001 8:40 AM
> Subject: Trimming Files
> 
> 
> > Does anyone have a quick way to trim extra lines from a text file?
> > 
> > I have an app that uploads a text file and processes it as 
> a TSV file, but
> > some users are exporting from MS Access, which is adding 
> some extra line
> > feeds to the end.  Any suggestions?
> > 
> > C. Hatton Humphrey, Developer
> > Fisher, Towne & Associates
> > 716-839-2141 x336
> > [EMAIL PROTECTED]
> > 
> > 
> 
~~
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: ODBC or OLE DB

[Steve Martin]

I'm curious as to what differences you've found as I've used both
interchangeably without any problems whatsoever. Could you possibly
enumerate the differences for the benefit of the list.
Cheers,
Steve

> OLEDB handles dates and boolean fields slightly differently at times
> (perhaps other data types too?), converting sites that use 
> ODBC can be a
> pain.
> 
> I've used both quite bit, and still don't have a preference. 
> If I was trying
> to decide which to use for a new site, then I would probably 
> go with ODBC as
~~
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: query name vs. query object

[Steve Martin]

> -Original Message-
> From: Alexander "just me" Apartsev [mailto:[EMAIL PROTECTED]]
> Sent: 07 December 2001 08:29
> To: CF-Talk
> Subject: query name vs. query object
> 
> 
> Hello All,
> 
> i have a custom tag making a query. I would like to access 
> its results in
> another custom tag or else in the calling template.
> 
> The custom tag making the query is called from another custom tag.
> 
>  doesn't work cause it 
> needs a literal,
> not a query object.
> 
> Is there a solution?
> 
> Thanks in advance
> 
> Alexander Apartsev
> [EMAIL PROTECTED]
> 
~~
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: Random passwords

[Steve Martin]

There are various ways. One is as simple as:











#pwd#

HTH
Steve

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2001 18:30
> To: CF-Talk
> Subject: Random passwords 
> 
> 
> Does Anybody know how to generate random passwords for new users?
>  
>  
>  
> 
> 
~~
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: query name vs. query object

[Steve Martin]

in that case make sure you pass the literal name of the query into the
CFOUTPUT tag.
If you've called the query REQUEST.TheQuery then:


Steve


> -Original Message-
> From: Alexander "just me" Apartsev [mailto:[EMAIL PROTECTED]]
> Sent: 06 December 2001 18:20
> To: CF-Talk
> Subject: query name vs. query object
> 
> 
> Hello All,
> 
> i have a custom tag making a query. I would like to access 
> its results in
> another custom tag or else in the calling template.
> 
> The custom tag making the query is called from another custom tag.
> 
>  doesn't work cause it 
> needs a literal,
> not a query object.
> 
> Is there a solution?
> 
> Thanks in advance
> 
> Alexander Apartsev
> [EMAIL PROTECTED]
> 
~~
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: Windows NT error #1450 occurred.

[Steve Martin]

For future reference:
C:\>net helpmsg 1450

Insufficient system resources exist to complete the requested service.

Steve

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 16:22
To: CF-Talk
Subject: RE: Windows NT error #1450 occurred.


that or the registry is full, which is the other situation where I have
seen
this error. Are you storing client variables in the registry? If so,
that's
probably what it is.

will

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:27
To: CF-Talk
Subject: RE: Windows NT error #1450 occurred.


If i remember right it is a out of memory error.  I have hit this error
trying to upload large files with CFFILE.



At 10:10 AM 11/28/2001 -0500, you wrote:
>The only reference to that error I found was here.
>http://www.allaire.com/Handlers/index.cfm?ID=1659&Method=Full
>
>-Original Message-
>From: Don Vawter [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, November 28, 2001 10:04 AM
>To: CF-Talk
>Subject: Windows NT error #1450 occurred.
>
>
>Windows NT error #1450 occurred.
>
>Anybody no what causes this error?
>
>TIA
>
>Don
>
>


~~
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: %$#@^&%$& CFSETTING

[Steve Martin]

Do you have "Suppress whitespace by default" checked in the CF admin? If so
then you'll always end up with a leading space as it would appear to
compress runs of zero (yes, zero) or more whitespace characters to a space.
Had me pulling my hair out for a while once.

Steve

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 12:27
To: CF-Talk
Subject: RE: %$#@^&%$& CFSETTING


I put a  directly after it.
It still inserted the space.
I'll play around with it with different amount of code on that line.

Thanks :)

EC

-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 5:02 PM
To: CF-Talk
Subject: Re: %$#@^&%$& CFSETTING


No, just remove the carriage return after cfsetting.



- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 3:50 PM
Subject: %$#@^&%$& CFSETTING


> I'm using a CF script to talk to a Flash SWF.  The flash movie needs an
> output like a query string
>
> ?var1=abc&var2=123&var3=def
>
> The very first in this script is...
> 
> to supress any whitespace that is problematic in Flash.
>
> The problem is that the first carraige return after  causes a
> space to be placed into the output.  This can mess up communication with
the
> Flash movie.
> Do I have to write this entire %$#@^&%$& script on one line?
>
> Eric Carlisle
> Web Site Developer
> Progress Energy IT Systems Delivery
> E-mail: [EMAIL PROTECTED]
> Phone: (919) 546-4739
>


~~
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: Masked Query Strings in URL

[Steve Martin]

You can confirm the server version with the following code:

OS: #Server.OS.Name#
Ver: #Server.OS.Version#
Build: #Server.OS.BuildNumber#
Extra Info: #Server.OS.AdditionalInformation#


Steve

-Original Message-
From: Michiel Boland [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2001 08:05
To: CF-Talk
Subject: Re: Masked Query Strings in URL


On Thu, 8 Nov 2001, Sean Daniels wrote:

> I have been using the fusebox style trick for masking query strings in the
> URL (index.cfm/var1/value/var2/value) for quite some time now.
>
> I recently deployed an app written this way to a new host environment and
> have found that all the URLs using this format are returning 404 errors
> (from IIS, I believe, not CF).
>
> The only thing I know for sure is different about the environment is that
it
> is CF 5, and I run 4.5 (Win2K) on my dev machine. But, since the 404 seems
> like it's from IIS, I don't think that's the issue.
>
> I have limited ability to suss out the host server, does anyone have any
> ideas as to why the masked URLs wouldn't work? The guy at the hosting
place
> claims it's a standard install.

What OS version is he using? There are definite problems if you try this
on WINNT SP6 without the appropriate hotfix.

~~
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: Question about using 2 datasources

[Steve Martin]

> This works to combine two Access datasources into one query.
> http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914

Eh oh, that tells you how to query 2 TABLES not 2 datasources!

You can query 2 datasources in Access using the following technique however:

SELECT tableA.field1, tableA.field2, tableB.field1
FROM someTable tableA, "D:\databases\foo.mdb".someOtherTable tableB
WHERE tableA.field1 = tableB.field1

At least you could last time I tried it which was sometime in 1999, MDAC
updates _may_ have changed matters but try it anyway.

Steve


-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: 01 November 2001 17:07
To: CF-Talk
Subject: Re: Question about using 2 datasources



> Ok heres my problem.
>
> I have a Access database that our users can go into and register new
> studetns with.  However all of our course information resides in another
> datasource.  My problem is that I have to display the course names which
> reside in database 2.  however I have to use the course ID's stored in
> Datasource 1.  How can I dothis?
>
> Thanks for all your help
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [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: ### Output all variables?

[Steve Martin]

dump the contents of the FORM, URL & ATTRIBUTE structs using a handy tag
such as for example CF_ObjectDump.

Steve

-Original Message-
From: Jason Blum [mailto:[EMAIL PROTECTED]]
Sent: 01 November 2001 17:27
To: CF-Talk
Subject: ### Output all variables?


Anyone know of a quick and dirty way to just show all variables that
were passed from a previous page?


~~
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: Naming Conventions

[Steve Martin]

Local variables are scoped as variables.variablename
After running item 1 you can refer to the local variable as variables.Fname

Item 2 won't have a structure associated unless you explicitly created one.
You have simply created a variable called Names.Fname

Steve

> -Original Message-
> From: sam komolafe [mailto:[EMAIL PROTECTED]]
> Sent: 31 October 2001 16:44
> To: CF-Talk
> Subject: Naming Conventions
>
>
> Hi guys,
>
> Which is the better or acceptable way of naming a LOCAL variable:
>
> 1.  
> 2.  
>
> Coldfusion did not create a structure for item #2, and I can
> still reference
> it using #variables.Names.Fname#.  Can you point to a link/site on CF name
> coventions
>
> Thanks
> Sam
>
>
>
> 
~~
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: archiving cftalk mails

[Steve Martin]

[Outlook] File/Import & Export/Export to file

> -Original Message-
> From: John McCosker [mailto:[EMAIL PROTECTED]]
> Sent: 31 October 2001 10:59
> To: CF-Talk
> Subject: archiving cftalk mails
>
>
> Has anyone wrote an app or aware of one that can scan your inbox and write
> your emails to a txt file.
> I gues I could then use CFSchedule to automate this, then build a search
> template to scan my file.
>
> I have 3000 emails from cftalk in my inbox, and I'm starting to get
> complaints.
>
> If anyone has done anything like this or any ideas I'd love to know.
>
> 
~~
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: Words Docs & Coldfusion

[Steve Martin]

Word docs are binary files and CF isn't too hot at handling binary data from
databases. You'll probably have to use some sort of custom tag (Java or C++)
to return the binary data to the browser with the appropriate headers or
write it to a temp file and use CFCONTENT in the manner indicated by Mark
(albeit with the deletefile attribute set to yes) to grab the tmp file and
serve it. Alternatively, you could store the documents as RTF which is
purely textual and then have CF return that in the usual manner, using
CFCONTENT to supply the appropriate mime header to the output stream.

Steve

> -Original Message-
> From: Mark Stewart [mailto:[EMAIL PROTECTED]]
> Sent: 26 October 2001 15:11
> To: CF-Talk
> Subject: RE: Words Docs & Coldfusion
>
>
>  deletefile="No">
>
> Mark
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 26, 2001 6:22 AM
> To: CF-Talk
> Subject: Words Docs & Coldfusion
>
>
> Hi
>
> I currently have MS Word docs stored in an Oracle database. I wish to
> display these in a web browser via Coldfusion.
>
> Is this possible using Coldfusion and what is the best method of
> achieving so ?
>
>
>
>
> 
~~
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: Yet another reason why I hate Netscape

[Steve Martin]

Session vars aren't related to the type of browser you're using. The only
dependency on the browser is that it must perpetuate the cfid and cftoken
values. This is usually done through a cookie. If Nutscrape has cookies
turned off for whatever reason and you are not passing the values from page
to page via the URL then the session vars won't exist on the next page as
the server will have no idea who you are. As a test try outputting
#session.cfid# #session.cftoken# on all your pages. If the numbers change on
each page then the server is issuing new ones as you haven't reminded it
what the first ones were.

HTH
Steve

> -Original Message-
> From: t nelson [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2001 22:08
> To: CF-Talk
> Subject: Yet another reason why I hate Netscape
>
>
> Hi all,
>
> I am working on an application which uses some a session
> variables. It works
> perfectly in IE (of course), however when I try to load the exact same
> page(s) in netscape the variable does not exist. I even went so far as to
> write a couple of simple test pages.
>
> All they do is set a session variable then pass it to another
> page. Again I
> tried it in IE and it works fine but then when I tried it in
> netscape, the
> variable doesn't exist.
>
> Here is my session variable:
>
> 
> 
> 
>
> I know that I can pass variables to subsequent pages in a number of
> different ways. However, my question is: Do session variables simply not
> work in Netscape? If they do work is there some setting/syntax I am
> forgetting or should be examining?
>
>
> If this helps I am using both Netscape Navigator(4.08) and Netscape(6).
>
>
> Thanks in advance,
>
> Nelson
>
>
>
> 
~~
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: CFIF Confusion

[Steve Martin]

eh-oh:

SELECT *
FROM Wherever
WHERE somefield IS NULL

> That's because IS is not a valid SQL keyword...


~~
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: is this list dead?

[Steve Martin]

Shhh!, it's sleeping.

> ... I thought the list was Dead!!
> 
> Jason Lees 
> National Express
> Email : [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Erika L. Walker [mailto:[EMAIL PROTECTED]]
> Sent: 02 July 2001 16:53
> To: CF-Talk
> Subject: RE: is this list dead?
> 
> 
> I'm getting posts, but not as many as we used to get.
> 
> :(
> 
> Erika
> (with a *K*)
> 
> "Those who love deeply never grow old; they may die of old age, 
> but they die
> young." - Sir Arthur Wing Pinero
> -
> Macromedia ColdFusion 5.0 Certified Developer - < Just passed!!
> WooHoo
> -
> 
> -Original Message-
> From: Mike Sullivan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 02, 2001 10:57 AM
> To: CF-Talk
> Subject: is this list dead?
> 
> 
> I haven't seen a post in quite some time now.
> Mike
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Aggregate functions (AVG())

[Steve Martin]

Don't forget the query attribute of your CFOUTPUT tag. That's why you're
only getting the 1st record returning.

Steve

> -Original Message-
> From: Tim [mailto:[EMAIL PROTECTED]]
> Sent: 12 June 2001 16:05
> To: CF-Talk
> Subject: Aggregate functions (AVG())
>
>
> I have a simple query that includes the AVG() function
> to average some fields.  The code is:
>
> 
> SELECT  overall, AVG(overall) AS OAvg, needs,
> AVG(needs) as NAvg, tech, AVG(tech) AS TAvg,
> equipment, AVG(equipment) AS EAvg, software,
> AVG(software) AS SAvg, location
> FROM main
> WHERE   (location = 'Atlanta')
> GROUP BY  location, overall, needs, tech, equipment,
> software
> 
>
> 
> Results for Atlanta; number of responses:
> #qGetAtlanta.RecordCount#
> 
> Overall Rating of IT, #qGetAtlanta.OAvg#
> Overall rating of IT support, #qGetAtlanta.NAvg#
> Technical capability, #qGetAtlanta.tavg#
> Equipment availability, #qGetAlanta.eavg#
> Software availability, #qGetAlanta.savg#
> 
>
> However, it is not outputting the average of each
> field. It returns the correct number od records, 4,
> but appears to just output the value in each field of
> the first record.
>
> The four records have field values of 2, 3, 1, 4, 5;
> 5, 4, 3, 5, 4; 2, 4, 3, 2, 1; and 5, 5, 5, 5, 5.  The
> output is returning values of 2, 3, 1, 4 and 5, the
> values of the first record's fields.  They should be
> 3.5, 4.0, 3.0, 4.0 and 3.75.
>
> Any ideas?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Preserve ampersand tagged data (SGML)

[Steve Martin]

HTMLEditFormat()

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 06 June 2001 12:58
> To: CF-Talk
> Subject: RE: Preserve ampersand tagged data (SGML)
>
>
>
> I'm using  french accented characters.
>
> Is there a CF function to preserve ampersand stuff ?
>
> Here is a little snippet from the datafile that has the SGML entity for a
> accented character "çais"
>
> 
>
> Disponible en français
>
> 
>
>
> When outputted in a  I want the text to appear AS IS. I don't
> want the "cedil" translated into the ASCII character.
>
> 
>
> Disponible en français
>
> 
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: file upload and 'please wait'

[Steve Martin]

In a manner of speaking, yes. And this also applies to any page that you
want a Please Wait for. You can use the OnBeforeUnload event (IE5+ only) to
bring up a Please Wait message before the current page unloads and the
requested page is called. Typically what you would do is have for example a
 -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: 06 June 2001 13:01
> To: CF-Talk
> Subject: file upload and 'please wait'
>
>
>
>
> Has anyone figured out how to show a 'please wait page' when uploading a
> file without using CF 5 progress meter? The file does not transfer when
> using an intermediate page. I ended up using:
>
>  onClick="if(this.value == 'Submit Form') this.form.submit(); this.value =
> 'Please Wait. . .';">
>
> Sebastian
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Is it possible to nest CFQUERY inside CFLOOP?

[Steve Martin]

CFQUERY is allowed in any type of CFLOOP so the addition of CFOUTPUTs into
the loop is irrelevant.
This thread reminded me of a BUG in CF which I can confirm is still in CF5RC
(haven't checked with the final release yet but I doubt it has changed!)
which concerns the nesting of query driven loops that I thought I'd post as
I doubt everyone is aware of it. Let's say we have 2 query loops (named
query1 and query2 for simplicity), in which for each record in query1,
query2 is iterated over fully. Now, if within the query2 loop you refer to
query1.somefieldname you would expect it to contain the value of the record
that query1 is currently on. But no. It always contains the value of the
FIRST record in query1. The workaround is to initialise a local variable
before entering into the inner loop and from within the loop refer to the
local variable.




#query1.somevarname#








#variables.someLocalVarname#



Steve


> -Original Message-
> From: Bill Davidson [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 18:06
> To: CF-Talk
> Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> You should be able to nest cfquery in a cfloop that is not query based...
> Maybe the actual problem is that cfloop doesn't implicitly force
> a cfoutput,
> so chances are your variables are not getting resolved.  Include a
>  inside the loop.
>
> Here's a code snippet where I am nesting a query inside a loop:
> 
>  
>
>   
>
>SELECT  dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
>   FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
> dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
>   where Employee_job_rates_employee_id = #attributes.user_id#
>   and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'
>
>  
> .
> 
> 
>
> The only other thing I could think of is the list attribute for cfloop.
> Maybe cold fusion internally handles lists as a query.  Maybe just do a
> "from to" loop and only do the query and related code when the index is in
> the list.  That's what I am doing in the previous block of code,
> except with
> arrays.
>
> HTH,
> -Bill
> www.brainbox.tv
>
> - Original Message -
> From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 11:38 AM
> Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> > I just noticed the loop index variable is wrong, I changed it
> to from "i"
> to
> > "region" as it should be and still got the same error message...
> >
> > -Original Message-
> > From: Kevin Gilchrist
> > Sent: Thursday, May 31, 2001 11:32 AM
> > To: CF-Talk (E-mail)
> > Subject: Is it possible to nest CFQUERY inside CFLOOP?
> >
> >
> > I get an error when I try to do this:
> >
> > 
> >  > dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> > SELECT
> >   sum(severity_minutes) as sev_sum,
> >   max(total_minutes)
> > FROM
> >   history_view,
> >   site_name
> > WHERE
> >   query_id =259 AND
> >   node='RS_CHARMING1' AND
> >   severity=5 AND
> >   customer_name='CHARMING' AND
> >   application='RS_PING' AND
> >   region=#i#
> > 
> > 
> >
> > The error message is:
> >
> > Just in time compilation error
> > A nested CFQUERY tag has been encountered at document position
> (455:2) to
> > (455:130). CFQuery tags cannot be nested inside one another.
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

[Steve Martin]

Although browsers work fine without hashes (pounds for you yanks ),
technically speaking the 'standard' is for hex numbers to be preceeded with
a #.

Steve

> -Original Message-
> From: Gina K. Anderson [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:12
> To: CF-Talk
> Subject: RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]
>
>
> Thanks to everyone for the fix on my hex numbers! Taking out the
> hash worked, as
> well as doubling up. Now I just have to decide which way to go
> with it and adopt
> it as my form. What's the "standard"?
>
> Thanks again!
> Gina
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Is it possible to nest CFQUERY inside CFLOOP?

[Steve Martin]

You have an unterminated CFQUERY in your page though you have only pasted a
snippet of the code into your email. Take a look above your code and try to
find the offending tag.

> -Original Message-
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:38
> To: CF-Talk
> Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I just noticed the loop index variable is wrong, I changed it to
> from "i" to
> "region" as it should be and still got the same error message...
>
> -Original Message-
> From: Kevin Gilchrist
> Sent: Thursday, May 31, 2001 11:32 AM
> To: CF-Talk (E-mail)
> Subject: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I get an error when I try to do this:
>
> 
>dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
>   SELECT
> sum(severity_minutes) as sev_sum,
> max(total_minutes)
>   FROM
> history_view,
> site_name
>   WHERE
> query_id =259 AND
> node='RS_CHARMING1' AND
> severity=5 AND
> customer_name='CHARMING' AND
> application='RS_PING' AND
> region=#i#
>   
> 
>
> The error message is:
>
> Just in time compilation error
> A nested CFQUERY tag has been encountered at document position (455:2) to
> (455:130). CFQuery tags cannot be nested inside one another.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: how do i send an attachment?

[Steve Martin]

You could potentially create the entire mail body dynamically by encoding
the dynamic data on the fly and using cfmailparam insert the relevant mail
headers along with the encoded data. Your best bet, unless somebody else
provides a step by step set of instructions would be to examine an existing
mail message which is already in your desired final format and attempt to
recreate it.

However, writing to a file and using mimeattach is probably a lot less
hassle  ;-)

HTH
Steve

> -Original Message-
> From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 08:14
> To: CF-Talk
> Subject: RE: how do i send an attachment?
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Suppose I want to attach some HTML code that was obtained either from a
> database or using CFHTTP, how do I attach it to CFMAIL without having to
> save it to a local file first?
>
> Can I pass CFHTTP's CFHTTP.FileContent as the MIMEATTACH parameter value
> for CFMAIL?
>
> TIA.
>
> - 
> Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
> E-Developer | novaSPRINT.com (S) Pte Ltd
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
>
> iQA/AwUBOxV+kxQsl2B8K+e4EQI+dACgqch4ndBLggOrI+teadTl6tIXBnkAn3Gx
> 6Dm7mgJkJ/gCLi0YvEDQSCTH
> =h7Xf
> -END PGP SIGNATURE-
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cfcatch and email

[Steve Martin]

You can put whatever you want inside a CFCATCH block. Check to see whether
the email is being created or not by examining the SPOOL and UNDELIVR
directories under CFUSION. If not then see what happens without the
CFLOCATION though this shouldn't be causing CFMAIL to fail.

Steve

> -Original Message-
> From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
> Sent: 22 May 2001 09:44
> To: CF-Talk
> Subject: Re: cfcatch and email
>
>
> Never tried to do that inside of a cfcatch block before but could you just
> populate a variable with the email message and then outside the try block
> check to see if the message is not empty and then send an email if so?
>
> Bryan
>
> - Original Message -
> From: "sebastian palmigiani" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, May 21, 2001 10:39 PM
> Subject: cfcatch and email
>
>
> >
> > I want to send an email with database error info using
> cftry/cfcatch. But
> it
> > is not working. Am I trying to do something that can't be done within a
> > cfcatch block?
> >
> > Sebastian
> >
> > ---
> >
> >
> > 
> >
> > 
> >
> > Select * from members
> >
> > 
> >
> > 
> >
> > 
> >  > type="HTML"
> > to="[EMAIL PROTECTED]"
> > subject="Database Error">
> >
> > Date: #DateFormat(Now(), "MM D, YYY")# #TimeFormat(Now(), "h:mm
> tt")#
> > Error Type: #CFCATCH.Type#
> > Message: #CFCATCH.Message#
> > Template: #CGI.CF_Template_Path#
> > Referer: #CGI.HTTP_Referer#
> > Details:
> > #CFCATCH.Detail#
> > 
> >
> >  --->
> >
> > 
> >
> > 
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Redirects

[Steve Martin]

FYI, the first line is superfluous as CGI vars are special in that they will
always exist, including made up names like cgi.happy_hovercraft. In fact,
cgi vars afaik are r/o so cfparaming them would be pointless.
Steve

> -Original Message-
> From: another programmer [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 06:46
> To: CF-Talk
> Subject: Re: Redirects
>
>
> in the root index.cfm, not the application.cfm ;-)
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> btw be aware you do need to setup the 3 domain names to point to
> the same IP
> (egads! I'm a bean!)
>
> - Original Message -
> From: "Parker, Kevin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, May 16, 2001 2:28 PM
> Subject: Redirects
>
>
> > I have a situation where I want three domain names to point to
> a given IP
> > address but I want the user to see different parts of the site dependant
> on
> > which name they come in via. Someone gave me this bit of ASP to do the
> > trick. Can it be done with CF.
> >
> > TIA!!!
> >
> >
> >
> > <%response.buffer=true%>
> > 
> > Enter Page
> > 
> > 
> > <%
> >
> > if Request.ServerVariables("HTTP_HOST")="www.domainone.com" then
> > Response.Redirect("http://www.domainone.com/page1";)
> > end if
> > if Request.ServerVariables("HTTP_HOST")="www.domaintwo.com" then
> > Response.Redirect("http://www.domainone.com/page2";)
> > end if
> > if Request.ServerVariables("HTTP_HOST")="www.domainthree.com" then
> > Response.Redirect("http://www.domainone.com/page3";)
> > end if
> > %>
> > 
> >
> >
> >
> >
> > 
> >
> > Kevin Parker
> > Web Services Manager
> > WorkCover Corporation
> >
> > [EMAIL PROTECTED]
> >
> > www.workcover.com
> >
> > p: +61 8 82332548
> > f: +61 8 82332000
> > m: 0418 800 287
> >
> >
> >
> >
> >
> >
> **
> **
> > This e-mail is intended for the use of the addressee only. It
> may contain
> > information that is protected by legislated confidentiality and/or is
> > legally privileged. If you are not the intended recipient you are
> prohibited
> > from disseminating, distributing or copying this e-mail. Any opinion
> > expressed in this e-mail may not necessarily be that of the WorkCover
> > Corporation of South Australia. Although precautions have been
> taken, the
> > sender cannot warrant that this e-mail or any files transmitted with it
> are
> > free of viruses or any other defect.
> > If you have received this e-mail in error, please notify the sender
> > immediately by return e-mail and destroy the original e-mail and any
> copies.
> >
> **
> **
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: open link in new, maximized window?

[Steve Martin]

Click here

> -Original Message-
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: 15 May 2001 18:34
> To: CF-Talk
> Subject: OT: open link in new, maximized window?
>
>
> I need a link to open up in a new maximized browser window.  I
> figure its a
> windows setting issue instead of a code issue, correct?  This is for a
> demonstration later today.  My CF app is launching the GIS application and
> its opening the GIS App in a small window and its having trouble
> re-rendering when we maximize the window manually.
>
> Where do I change that setting so the browser window will open up
> maximized
> all the time?
>
> Thanks,
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: query error

[Steve Martin]

Is your OperaID an autonumber field perchance? Trying to insert a value into
an autonumber field is not going to happen.
Steve

> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2001 12:36
> To: CF-Talk
> Subject: query error
>
>
> Hello,
>
> Must be having a brain spasm todayI am getting this error message:
>
> Message: ODBC Error Code = S1000 (General error)
> Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC
> Microsoft Access
> Driver] Operation must use an updateable query.
>
>
> SQL = "INSERT INTO tbl_threads (operaID, thread_title, thread_body,
> thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01);"
>
> This is the query that seems to be causing the problem:
>
> 
>   INSERT INTO tbl_threads (operaID,
>   thread_title,
>   thread_body,
>   thread_author,
>   thread_time)
> VALUES(#url.operaID#,
>   '#Form.thread_title#',
>   '#Form.thread_body#',
>   #checkauthor.authorID#,
>   #dadate#);
> 
>
> Any ideas anyone?
>
> TIA
>
> Will
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Internal Server Error

[Steve Martin]

fdisk

> -Original Message-
> From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
> Sent: 10 May 2001 15:55
> To: CF-Talk
> Subject: Internal Server Error
> 
> 
> We just set up a Windows 2000 Advanced Server with
> ColdFusion 4.5.1 SP2 and cannot get any cfm files to
> work, it always gives me an Error 500 - Internal
> Server Error.  Does this for asp pages also.  I did
> not set up the machine, so figure the guy that did
> messed with some setting to mess this up, I have set
> up computers with similar configurations and have
> never had this problem before.  Any ideas why this is
> happening?  I cannot find any setting that fixes this problem.
> 
> =
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
> ICQ UIN: 916324
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Spider 404s

[Steve Martin]

Try: CFHTTP.StatusCode
Should contain 404 if the server is contacted and returns a 404.

Steve

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

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

RE: cffile vars

[Steve Martin]

Dave, it would appear that CF is aware of the true file type of an uploaded
file in spite of any file extension renaming. By way of a quick test I took
a JPG and renamed it to .MP3 and uploaded it. file.contenttype and
contentsubtype reflected the fact that the file was indeed an image/pjpeg
and not audio/mpeg. I'm not sure where the examination takes place, though I
would guess that the browser passes the content type as I have had trouble
in the past with files uploaded from Macs not having a content type at all
and therefore causing CFFILE to fail when the 'accept' attribute is used.
Steve

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: 09 May 2001 14:32
> To: CF-Talk
> Subject: RE: cffile vars
>
>
> > CFFile.ContentType and CFFile.ContentSubType - are they
> > reliable enough? I allow people to upload gif/jpg to one of
> > my sites, and ONLY jpg/gif but I bet some of them will try
> > to rename a .mp3 file into .gif or something. Can I use this
> > to filter other formats, rather then images?
>
> CF isn't going to examine the actual file content - it wouldn't know how!
> So, if someone renames an .mp3 file with a .jpg extension, for all intents
> and purposes, it's now a .jpg file, both to the uploading browser and to
> your server.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Arrays and Structures storing query values

[Steve Martin]

*** Team Pixie ***

If you think about it, arrays are suited to storing an arbitrary number of
bits of information from 1 ... n - similar to the way a table stores an
arbitrary number of records. Structures are suited to storing groups of
associated information e.g. employee=StructNew(), employee.name="bob"
employee.deptNo="123", etc. in the same manner that a record uses numerous
fields to group associated information per record. Put the two together and
you get an array (or set of records) of structures (associated information).

Steve

> -Original Message-
> From: Neil Clark [mailto:[EMAIL PROTECTED]]
> Sent: 30 April 2001 16:44
> To: CF-Talk
> Subject: RE: Arrays and Structures storing query values
>
>
> Doh.  Just think the other way around is more suited? maybe not?
> whatdoiknow!!! :-(
>
>  Neil Clark
> Senior Web Applications Engineer
> XML / Cerebro
> MCB Digital
> Macromedia Alliance Member
> Tel: 020 8941 3232
> Fax: 020 8941 4333
> e-mail: [EMAIL PROTECTED]
> >
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Arrays and Structures storing query values

[Steve Martin]

select * from pressreleasetable
ORDER by pressreleasedate DESC














Should do the trick

Steve


> -Original Message-
> From: Darren Adams [mailto:[EMAIL PROTECTED]]
> Sent: 30 April 2001 15:28
> To: CF-Talk
> Subject: Arrays and Structures storing query values
>
>
> Can anyone lend me a hand ?
>
> I am trying to store one database in an array of structures then insert it
> into another database.
>
> I am only using one field at the moment but, there will be 9 that
> I want to
> copy over.
>
> What I am trying to do is to take PressReleaseHeader from the
> pressreleasetable.
>
> But it keep giving me errors.
>
> 
>
> 
> select * from pressreleasetable
> ORDER by pressreleasedate DESC
> 
>
> 
>
> 
> 
> 
>
> 
>   
> 
>
>
>
> Darren Adams
> Web Developer
> Marketing Department
> Systems Union
>
> Office: 01252 55 6220
> Mobile: 07714 817 038
> Email: [EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: data nonsense

[Steve Martin]

Try the following instead:



btw, make sure your locale is set to a non-US locale otherwise your dd/mm/yy
will be interpreted as mm/dd/yy (unless the date is beyond the 12th of the
month).

Steve

> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: 24 April 2001 12:10
> To: CF-Talk
> Subject: data nonsense
>
>
> Hi all,
>
> Having this problem with dates which I mentioned before, but no-one seemed
> to be able to help.
>
> Basically, I have an order form , which has a day, month and year
> drop down
> menus which are combined for the date. These fields are put
> together on the
> next page to make a date, which I then ODBC date format to ensure its ok.
> Here is the code:
>
> The date entered is 28th November 2001
>
> the fields passed over are 28 11 01
>
> 
>
> intdate now equals 28/11/01
>
> 
>
> formatdate now equals 01/11/28
>
> 
>
> deldate now equals {d '2028-01-11'}.
>
> Now I just cannot see why this is happening to the date.However,
> it doesn't
> always happen. Look at this:
>
> The date entered is 7th November 2001
>
> the fields passed over are 7 11 01
>
> intdate now equals 07/11/01
>
> formatdate now equals 11/07/01
>
> deldate now equals {d '2001-11-07'}
>
> I have done this kind of thing loads of times, and never seen this problem
> before. Futhermore, it has just suddenly started happening.
> Anyone have any
> ideas as to what's going on. FYI, the db is Access2000 and the
> field type is
> short date.
>
> TIA
>
> Will Swain
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: again...

[Steve Martin]

Can the server that CFHTTP is being called on actually see the URL that it
is supposed to be accessing?

> -Original Message-
> From: Holger Lockertsen [mailto:[EMAIL PROTECTED]]
> Sent: 19 April 2001 10:28
> To: CF-Talk
> Subject:  again...
>
>
> Running 4.5.1 SP2 on a server we are getting the "connection
> failure"-error
> on this code:
>
> http://www.theserver.com/template.cfm"
> method="GET"
> port="80"
> resolveurl="false"
> timeout="20"
> throwonerror="yes">
>
> On another server running the same configuration, the code runs well.
>
> Any more issues with  I should be aware of?
>
>
> || Holger Lockertsen - [EMAIL PROTECTED]
> || Sentralbord: +47 23 00 53 00
> || Direkte: +47 23 00 53 04
> || Mobil  : +47 91 83 20 51
> || http://www.pixelduck.com/
>
> OBS: Pixelduck AS har ny adresse og nytt telefonnummer!
> -- Gjerdrums vei 16 A, 0484 OSLO.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Calling a custom tag dynamically

[Steve Martin]

nb  is the same as 
attributecollection is what still appears to be an undocumented method of
passing a dynamic list of attributes into a tag. You just create a structure
containing keys pertaining to the attributes you want to pass into the tag
along with the associated values and then pass it to the tag as
attributecollection.

Steve


> -Original Message-
> From: JW [mailto:[EMAIL PROTECTED]]
> Sent: 18 April 2001 08:34
> To: CF-Talk
> Subject: Calling a custom tag dynamically
>
>
> Can anyone help? I'm looking to call any one of 30? or so custom
> tags from a
> database depending on what
> category the visitor selects from the first page.
>
> i.e. The visitor chooses the health care category and on the next
> page, the
> health care custom tag is called:
> . I'd rather leave it as a
> custom tag vs. a cfinclude.
>
> What is the best way to do this?
>
> I thought I would just use a CFCASE/CFSWITCH conditional, but
> this could get
> cumbersome, especially since there
> is additional information to load about each tag. Or would this
> actually be
> the best route to take.
>
> Thanks!
>
> Josh Winter
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: FormatBaseN Blowing up

[Steve Martin]

I recall there being some change in the way ints are handled between the two
versions (4.0 & 4.5). I can't remember the specifics but your symptoms point
to that as being a likely suspect. Anyone who knows the details care to
elaborate?
Steve

> -Original Message-
> From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
> Sent: 12 April 2001 16:54
> To: CF-Talk
> Subject: RE: FormatBaseN Blowing up
>
>
> But why would this work with CF Server 4.0 and not in 4.5?  There is no
> change in the code or OS?
>
> Thanks!
> Hatton
>
> > -Original Message-
> > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 12, 2001 11:36 AM
> > To: CF-Talk
> > Subject: Re: FormatBaseN Blowing up
> >
> >
> > FormatBaseN() will only work on an integer. Look at this
> article for more
> > info on it.
> > http://www.fusionauthority.com/alert/index.cfm?alertid=30#tech1
> > http://www.houseoffusion.com/hof/datatype.cfm
> >
> >
> > > Hi folks,
> > >
> > > Okay, off the thought ramble for a moment and on to something more
> > pressing
> > > and less theoretical.
> > >
> > > Yesterday our network admin updated one of the servers.  The hardware
> > > upgrade was necessary and the server needed cleaning.  The web
> > server was
> > > changed from Netscape Enterprise server to IIS4.0 and the CF
> Server went
> > > from 4.0 to 4.5.1.  We thought we had all the problems ironed out, but
> > > apparently there's some interesting differences.
> > >
> > > The one I'm dealing with right now has to do with the FormatBaseN
> > funciton.
> > > Here's the code in question:
> > >
> > > 
> > >  > > #TimeFormat(now(),"hhmmss")#>
> > > 
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > #systime# Len: #len(systime)#
> > > #int(systime)# - #val(systime)# - #NumberFormat(systime)# -
> > > #IsNumeric(systime)#
> > > #int(systime_orig)# - #val(systime_orig)# -
> > #NumberFormat(systime_orig)# -
> > > #IsNumeric(systime_orig)#
> > > 
> > > 
> > > 
> > > #base16_systime# - #base36_systime#
> > > 
> > >  (This is here to stop further processing while I'm
> fixing it)
> > >
> > > On the Netscape server, the output is:
> > > 20150031924110 Len: 14
> > > 2.01500319241E+013 - 2.01500319241E+013 - 20,150,031,924,110 - YES
> > > 2.00104121051E+013 - 2.00104121051E+013 - 20,010,412,105,139 - YES
> > > 8b7ebb8e - 2my27n
> > >
> > > The IIS Server gets the following:
> > > 11410401429203 Len: 14
> > > 1.14104014292E+013 - 1.14104014292E+013 - 11,410,401,429,203 - YES
> > > 2.00104121049E+013 - 2.00104121049E+013 - 20,010,412,104,932 - YES
> > >
> >
> --
> > --
> > > 
> > > Error Occurred While Processing Request
> > > Error Diagnostic Information
> > >
> > > An error occurred while evaluating the expression:
> > >
> > >  base16_systime=#FormatBaseN(systime,16)#
> > >
> > > Error near line 56, column 7.
> > >
> >
> --
> > --
> > > 
> > > Parameter 1 of function FormatBaseN which is now
> > "11410401429203" must be
> > an
> > > integer
> > >
> > > Any ideas or suggestions?
> > >
> > > TIA
> > > Hatton Humphrey
> > >
> > >
> > >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: date range search

[Steve Martin]

That was because your dates were in the incorrect format.
Try:




SELECT * FROM wwebsales
where orderdate between #startdate# and #enddate#


> Thanks for the suggestion. It didn't work though. I have a form with a
> dropdown menu. Can dates in an Access table between: 01/01/00 and 01/01/01
> be searched ?
> -
> Using my code:
> 
> 
> 
> 
>
> 
> SELECT * FROM wwebsales
> where orderdate between #startdate# and #enddate#
> 
> ---
> I can the following error:
>
> ODBC Error Code = 22012 (Division by zero)
> [Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
> SQL = "SELECT * FROM wwebsales where orderdate between 01/01/00 and
> 01/01/01"
> Data Source = "wwebsales"
> --
>
> Thanks.
>
> Robert O.
>
> >-Original Message-
> >From: Lamon, Alec [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, April 03, 2001 3:04 PM
> >To: CF-Talk
> >Subject: RE: date range search
> >
> >
> >I think you want to use the CreateODBCDate() function to create
> >your start and end dates.
> >
> >
> >
> >Then refer to those in your query *without* 's. (the
> >CreateODBCDate() function puts them in for you):
> >
> >
> >
> >SELECT * FROM wwebsales
> >where orderdate between #startdate# and #enddate#
> >
> >
> >> -Original Message-
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: multiple file upload in the same time..

[Steve Martin]

Have more than 1  in the same form on a page and use
the corresponding number of  on the action page.

Steve

> -Original Message-
> From: paul . [mailto:[EMAIL PROTECTED]]
> Sent: 03 April 2001 13:44
> To: CF-Talk
> Subject: multiple file upload in the same time..
>
>
> well Guys i need to know how to upload two files at the same time..
> have done one file at a time.
> please do help
> -paul
>
>
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: R U aggry with me on session concept?

[Steve Martin]

Why don't you just use the premade session.URLToken?

> Yup sounds ok to me.  The only thing I do extra is to put some code in my
> Application.cmf which creates a string containing the CFID and CFTOKEN if
> the user has session level cookies turned off.  I then append
> this string to
> every hyperlink, form posting, CFLocation in my site to ensure state is
> maintained
>
> --
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> --
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 29 March 2001 12:39
> To: CF-Talk
> Subject: R U aggry with me on session concept?
>
>
>
> Dear Sir  Andy
> i was also suffering from such type of problem.
> When the user logs in by his login name and password.At this time
> we create
> a session variable.
> And when the user will request for  any page, we will check that session
> variable is in existance.?
> we check at the top of every page whether session variable is alive or not
> ...OR simply we write statements in
> Application.cfm file.
> creation variable process:
>session.started="true"
> To check session variable existance.
> 
> 
> 
> Plz give response.
> Best Regards
>
> Muhammad Mumtaz Ahmad
> software Engineer.
> AcroLogix (Pvt) Ltd.
> 106/3, Saint Johns Park
> Lahore, Pakistan.
> Tel: 92-42-6664301~04  Fax: 6664307
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Personal web server install

[Steve Martin]

If it wasn't installed by default then it will be on your
CD.Windows[productVersion]

-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 18:32
To: CF-Talk
Subject: Personal web server install



Hello all,

I am trying to install microsofts personal web server on my NT 5.0 machine
and I cannot find it on the microsoft site.  I can only find PWS for NT
4.

does anyone know where the down load is for this/

Thanks

Julie


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

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

RE: CFID / CFToken

[Steve Martin]

The CFID and CFTOKEN are NOT automatically appended to the URL when a page
is served.
I guess you really want to find out how to stop CFID & CFTOKEN being passed
to the browser as cookies as that is how they are passed by default.
Firstly, make sure SETCLIENTCOOKIES is set to NO in your CFAPPLICATION.
Secondly, if the above attribute was at any point set to on then any cookies
that were set then will still get passed back with browser requests. To stop
this you will have to delete them from ther browser by using  & ditto for cftoken.


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 17:22
To: CF-Talk
Subject: CFID / CFToken


Can anyone point me to a place I can find out how
to STOP the CFID/CFTOKEN from being appended
to the URL when pages are served to the browser?

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

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

RE: Calling Custom Tags in

[Steve Martin]

No.

-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:59
To: CF-Talk
Subject: Calling Custom Tags in 



Hi All,

In CF Version 4.5 is it possible to call a custom Tag from with in a
CFScript block

EG





the x^2 = #y#

How would you convert the CF_Foo into the cfscript block?


Jason Lees
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]

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

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

RE: Survey: Web-based WYSIWIG editing tool

[Steve Martin]

5) Other - IE5 (though IE5.5 has more granular object control)

Hi All,

Just a quick survey to appease my curiosity...

If you use a web-based WYSYWIG editing tool, what do you use?

1) ActiveEdit (www.cdev.com)
2) eWebEditPro (www.ektron.com)
3) ezEdit (www.siteobjects.com)
4) HTMLArea (www.iautomated.com/products)
5) Other

I am currently using ActiveEdit, and am curious as to what others are using.

Thanks, Cameron


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

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

RE: Session variables stored in SQL server

[Steve Martin]

You're talking about client variables, not session variables. However:
They are as safe as they were in the registry as they are keyed on the
CFID/CFTOKEN pair which are generated by CF. Make sure in your
 you have UseDomainCookes set to TRUE so that no matter
which server you happen to being serviced by, the cookies that were set by
one machine will be available to one of the others in the farm.

Performance-wise, your system will thank you for moving to a RDBMS in the
long run as the registry isn't the most efficient of databases and that's
basically what you're using it for by storing client variables in there.
After a while the registry fills up and system performance degrades - a bad
bad thing!

Steve



-Original Message-
From: Andres Leon [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 16:57
To: CF-Talk
Subject: Session variables stored in SQL server


Hello all,

I am wondering if anyone has had any experience with this:

I am running a IIS5.0 and CF cluster of 5 servers and one databaser
server (sql70) will upgrade to sql2k soon.

I was adviced by Allaire to move my session variables to the database,
rather than storing them in each server's registry.

My question is: How safe is this in terms of client variables getting
mixed, or users taking other each other's session variables becuase they
would be extracted from one pool, rather than 5?

Is there a performance change by moving these variables to a remote
database? good?, bad?

Any thoughts or ideas on the subject will be greatly appreciated.

Thank you!

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

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

RE: Hyphen Use in CF 4.52

[Steve Martin]

I can't remember back that far to know whether the variable naming rules
were more lax then but as far as CF4.52 is concerned, variable names must
contain only letters, numbers and underscores, and must start with a letter.
This translates to meaning that your query names should follow the same
convention as the query name forms part of the variable name when you use it
to prefix the column name. The datasource name is fine as that isn't
constrained by CF but the operating system upon which CF is installed. I
haven't experimented with a range of different characters but I know that
spaces work.

Steve

-Original Message-
From: Tom Forbes [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 13:37
To: CF-Talk
Subject: Hyphen Use in CF 4.52



I wrote an application in CF 2.0 several years ago. My provider just moved
it to CF 4.52 and I get DataSource errors.

My question: is it OK to use a hyphen in either/both the datasource name
and/or the query name, or is this now illegal?

Thanks very much,

Tom

***
MedMatrix Used Medical Equipment Web Portal
http://www.medmatrix.com
V:(407) 772-3427   F:(407) 772-3428
Tom Forbes,  Forbes Web Consulting, Inc.
178 S. Monterey Isle Blvd., Longwood, FL - 32779
***
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Can I tell if a browser is 128 bit with CF

[Steve Martin]

cgi.HTTPS_KEYSIZE=  [40/128]

Steve

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 12:50
To: CF-Talk
Subject: Re: Can I tell if a browser is 128 bit with CF


CF is server side.  Browser detection must be done client side with
JavaScript.  I know there are scripts to detect browser screen height,
width, pixels and color depth, but I've never seen one detect encryption.
Not saying it does not exist, just saying if it does, it would not be a CF
issue.

Dave



- Original Message -
From: "James Milks" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 7:30 AM
Subject: Can I tell if a browser is 128 bit with CF


> Hi all,
> Is it possible to determine if a clients browser is 128 or 40 bit with CF?
>
> Thanks
> James Milks
> Noncubicle Corporation
> www.noncubicle.com
> [EMAIL PROTECTED]
> (613) 560-9855
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Finding host from IP

[Steve Martin]

Use CFX_GetIPHostname

-Original Message-
From: Paul Bowley [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 11:14
To: CF-Talk
Subject: Finding host from IP


Hi all

A question for the ASP-literate among you.  We have some ASP code that looks
like this:

Set DNS = CreateObject("TCPIP.DNS")
Host = DNS.gethostbyip(request.servervariables("remote_addr"))

It seems to be doing a DNS lookup.  Our production server does not run ASP.
Is there a way of doing the above but with ColdFusion?

TIA

Paul


---
Any opinions expressed in this message are those of the individual and not
necessarily the company.  This message and any files transmitted with it are
confidential and solely for the use of the intended recipient.  If you are
not the intended recipient or the person responsible for delivering to the
intended recipient, be advised that you have received this message in error
and that any use is strictly prohibited.

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

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

RE: exploiting shopping carts

[Steve Martin]

Worldpay have what is known as a 'data fetch' method whereby when you enter
the payment system you pass in a cart ID. The payment system then does the
equivalent of a CFHTTP to a URL on your site that you predefine in the
payment system administration pages passing the cart ID as a parameter. You
can then use this parameter to identify the appropriate cart, which you
would typically store in an application array of structs keyed on the cart
ID, and pass the info back to the payment system in whatever format it
requires. I dare say this is an approach adopted by other payment systems
too though I haven't really explored many others recently.

Steve

>
> > > Any data from the browser is subject to tampering. You can't
> > > rely on HTTP_REFERER - that's sent by the browser, and thus
> > > subject to the same sort of tampering as the form fields.
> >
> > Then can you suggest the best way of tackling this situation...
> >
> >  - website, basket and pre-checkout on one server
> >  - basket or orders table in database, each basket record tied to a
> > session.userid value
> >  - secure payment area / checkout on another server
> >  - no database access from secure server to database on main
> > website server
> >
> > How can you make the basket / orders data tied to a user,
> > together with the prices for the products, accessible to the
> > checkout section without including them as hidden form fields
> > which, obviously can be tampered with?
> >
> > I've seen one solution where a text file was written on the
> > unsecure server and the filename passed as a form field to the
> > secure area. The checkout just CFHTTPed the text file, parsed
> > out the order / product data and displayed the totals... not
> > an ideal way of doing it but seemed reasonably effective.
>
> As in your example, you'd have to use CFHTTP or some other communication
> mechanism between your CF server (as the client) and the payment server.
> That's really the only way.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFABORT Template Page

[Steve Martin]

You can change the site wide error handler from within the CF admin. Specify
a template and use the #error.X# variables to format the error layout.

Steve

> -Original Message-
> From: Shannon Carr [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2001 14:35
> To: CF-Talk
> Subject: CFABORT Template Page
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0043_01C09669.61C3AC80
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I need help finding and changing the template that displays when using =
> cfabort and showerror.
>
> The tag works fine, I just wanted to make the page that shows the error =
> not look so intimidating to the user.
>
> Thanks,
> Shannon
>
> --=_NextPart_000_0043_01C09669.61C3AC80
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> I need help finding and changing the =
> template that=20
> displays when using cfabort and showerror.
>  
> The tag works fine, I just wanted to =
> make the page=20
> that shows the error not look so intimidating to the user.
>  
> Thanks,
> Shannon
>
> --=_NextPart_000_0043_01C09669.61C3AC80--
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>


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

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

RE: Dateformat behaviour

[Steve Martin]

DateFormat assumes US date formats by default - it is effectivelt a
hardwired US locale specific version of LSDateFormat. I would recommend that
you set your locale using SetLocale("English (UK)") [or whatever] and then
use the locale specific versions of the date and time manipulation
functions.

Steve

> -Original Message-
> From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2001 14:05
> To: CF-Talk
> Subject: Dateformat behaviour
>
>
> Have a strange behaviour of DateFormat() function. Look at the following
> code and the results below. In my opinion CF could give me an
> error message
> on the second line (invalid date) but certainly not invert the
> day and month
> as it does!
>
> Your comments?
>
> Dominique
>
>
> 
> 
>
>   
> Dateformat("01/12/2000","mmdd")
> #Dateformat("01/12/2000","mmdd")#
>   
> Dateformat("13/12/2000","mmdd")
> #Dateformat("13/12/2000","mmdd")# 
>
> 
>
>
> Dateformat("01/12/2000","mmdd")
> 2112
> Dateformat("13/12/2000","mmdd")
> 20001213
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Best Practices

[Steve Martin]

Don't forget the old § gem! That's a browser screwup (IE4) which causes
CF to barf.


> If you're talking about CF errors ZERO!
>
> If you're talking about JavaScript errors, then early version will have
> problems, but try to build in redundancy so that it won't break if they
> don't have the functionality...
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF Server Question

[Steve Martin]

Do a tracert from the box to the alleged local IP and see if it is the case

Steve

> -Original Message-
> From: George Lemos [mailto:[EMAIL PROTECTED]]
> Sent: 13 February 2001 04:51
> To: CF-Talk
> Subject: CF Server Question
>
>
>
>
> I've noticed recently that on one of our cold fusion servers, when we run
> the administrator from start/programs/cold fusion, etc. We get a URL that
> comes up with the localhost IP as the path for example:
> http://127.0.0.1/CFIDE/Administrator/index.cfm
>
> When I click on the  ODBC link I see 2-3 ODBC databases listed.
>
>
> Here's where I am confused.
>
> If I enter the IP Address of this same computer in the URL for example:
> (xxx.xxx.xxx.xxx = OUR IP ADDRESS)
>
> http://XXX.XXX.XXX.XXX/CFIDE/Administrator/index.cfm
>
> When I login to the administrator I get a different set of databases under
> the ODBC link.
>
> This is the same computer! Why am I getting two different ODBC listings
> under the ODBC link in the administrator from the same computer?
>
> Has anyone come across this scenario? We are currently working on taking
> over a network that was put in place by some other admins that
> are no longer
> here. Hence trying to figure out some of what they did.
>
> Thanks for your help!
>
> George
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>


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

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

RE: Nesting CFTRANSACTIONs

[Steve Martin]

Explanation: You have used a CFTRANSACTION tag within the
scope of another CFTRANSACTION tag (nesting of
CFTRANSACTION tags is not permitted).

Sorry to point out the obvious but!


> -Original Message-
> From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 17:21
> To: CF-Talk
> Subject: Nesting CFTRANSACTIONs
>
>
> We have a custom tag that has a CFTRANSACTION in it. That tag is
> called from
> 3 other templates, all of which call it from within a query-driven CFLOOP.
>
> Ideally, I'd like to be able to retain the CFTRANSACTION within the custom
> tag but also wrap a CFTRANSACTION around the query-driven loop, but I'm
> getting this error:
>
> 
> CWebException: Error: Invalid use of CFTRANSACTION tag
>
> Explanation: You have used a CFTRANSACTION tag within the
> scope of another CFTRANSACTION tag (nesting of
> CFTRANSACTION tags is not permitted).
>
> This error very likely results from the unintentional omission
> of the end tag (/CFTRANSACTION) for your first
> CFTRANSACTION.
> 
>
> The closing tag is there, BTW.
>
> Is nesting CFTRANSACTIONS possible at all, perhaps by using certain
> attribute parameters?
>
>
>
> Thanks
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Random letter/number value

[Steve Martin]

The following should do what you want.












Steve

> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 15:56
> To: CF-Talk
> Subject: Random letter/number value
> 
> 
> Hi,
> 
> I'd like to produce a random letter/number value for a password 
> field, could
> be around 8 characters I suppose.  Can I get help with this please?
> 
> Thanks,
> Peter
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: excel - access - sql?

[Steve Martin]

a) Yes
b) Yes

> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 00:08
> To: CF-Talk
> Subject: excel - access - sql?
> 
> 
> if anyone can help me on this i would appreciate it
> i was wondering:
> 
> A. i could convert an excel file to sql
> 
> B. i could convert an excel file to access (if at all) then to sql?
> 
> 
> Thanks much :)
> 
> Jay Patton
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> www.webpro-usa.com
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Statistics on Toy R Us

[Steve Martin]

> > Apparently the removewhitespace setting only applies to
> > whitespace internal to tags
> > e.g.
> > 
> > datasource="dsn"
> > dbtype="odbc">
>
> I know this is a dumb question, but WHAT F***ING USE IS THAT?


The internal CRs do bleed into the generated text so the all new super
snazzy removewhitespace does actually remove _some_ whitespace.


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

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

RE: Statistics on Toy R Us

[Steve Martin]

Apparently the removewhitespace setting only applies to whitespace internal
to tags
e.g.

datasource="dsn"
dbtype="odbc">



> -Original Message-
> From: Jason Lees (National Express)
> [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 10:34
> To: CF-Talk
> Subject: RE: Statistics on Toy R Us
>
>
>
> I've got the remove whitespace setting applied on CF server and it doesn't
> seem to make any difference to the size of the completed template, I still
> get pages that are filled with whitespace.
>
> The only way I found to get rid of some, was to put CF comments in, this
> reduces the Tabed indents to a single CRLF, but theres a trade
> off, parsing
> speed against page size.  In testing I've found that it reduces pages by
> upto 20% (depending on the page layout).
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 10:13
> To: CF-Talk
> Subject: RE: Statistics on Toy R Us
>
>
> > The point about CF is that it uses the approach of "Anything
> written in CF
> > changes to whitespace when processed" as a default, instead of
> treating CF
> > as a programming language and compiling etc (prepare to flame me...).
> > That's what produces the whitespace.  This can of course be
> > turned off, and
> > can mean faster page loading.  The CFML processor is effectively only a
> > parser (a fast one, but still a parser) so any other language
> > that is parsed like this will produce similar output.
>
> Just as a point on this - removing white-space only reduces the
> time that it
> takes to send the template to the user - using CFSETTING a lot
> will actually
> slow the server down (slightly)
>
> It's therefore a payoff as to whether you want the pages to be
> built faster
> or sent to the user faster - remembering that if you can turn more pages
> around on the server, then you can serve more visitors - people
> are willing
> to wait an extra second or so, but if you've got a busy site, then you've
> got to weigh up which one you prefer...
>
> You get what I mean :-/
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Dumb Questions :: About Verity :: Intranets

[Steve Martin]

Paul,
Verity will index database content as well as a variety of documents. Check
out the cfindex type="custom" for the syntax for indexing databases. It
shouldn't be too much trouble to integrate your current text indeces with
the database content into one collection. When creating a collection, not
only do you have a KEY for the index - which in the case of the indexed
documents will be the path/filename of the indexed documents, but there are
2 extra fields - CUSTOM1 and CUSTOM2 which allow you to specify additional
criteria. For example, you could use CUSTOM1 to store a value indicating the
'class' of indexed item, e.g. FILE for indexed file, or the appropriate
tablename in the case of database content. This should allow you to choose
which types of data within the single collection to search on.

HTH
Steve

> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 13:25
> To: CF-Talk
> Subject: Dumb Questions :: About Verity :: Intranets
>
>
> Hello All!
> this is going to sound dumb.
>
> My manager wants only one interface for our search form on our intranet.
> right now i have tons of separate little DB apps that do the usual.
> each one has its own search interface, to search its own DB.
>
> i mentioned verity to him before i knew what it was, now he
> want's it in one
> little tight search form.
>
> correct me if i am wrong, but verity will only search text based doc's
> exct.. not database's?
>
> so how would *You* start to tie in 12-20 DB apps & all the normal
> text doc's
> into one thing.
> the problem i see is to keep the content relative to the pages it was
> created for.
>
> so how>? where to start?
>
> thanks for your time...
>
> -paul
>
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> fax:  614 485-5534
>
> Home: [EMAIL PROTECTED]
>   614 449-1681
>
> > icq:47658358
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Statistics on Toy R Us

[Steve Martin]

> 
>   > Thats very interesting, because doing a view source indicates
>   > that they are
>   > using CF:-)
>   >
>   > I mean how many other scripting languages generate that much 
> whitespace!
>   >
> 
> Erm...
> 
> Loads of languages generate that much whitespace!

Which ones?

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

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

RE: Weird Problem

[Steve Martin]

Mary,
The quote is closing the quote in the form thus rendering it invisible.


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 12:37
> To: CF-Talk
> Subject: Weird Problem
>
>
> I am having the strangest problem...
>
> I have a varchar field in a SQL database.  It contains the following text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
>
> So the field is coming back fine, but when the form is displaying, it cuts
> it off.
>
> I am using .
>
> Does anyone have any ideas?
>
> TIA
> Mary
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Windows NT Error Number 109

[Steve Martin]

The messages are accessible through Windoze:
>From a command prompt type:
net helpmsg 109

"The pipe has been ended"

Steve

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 12:25
> To: CF-Talk
> Subject: Windows NT Error Number 109
>
>
> What exactly does "Windows NT Error Number 109" mean?  I can't find a list
> of error numbers/codes on Microsoft's web site.
>
> I read the KB article on what it means when those errors are in your log,
> but we aren't using MS Access on our server, so I need to find
> out what the
> error means.  They happen when Verity crawls our web site each morning.
> This isn't the CF Verity, but the full product.  We crawl the web
> site with
> "vpsider"
>
> TIA
> Mary
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: How do I put the little image in the address bar in IE?

[Steve Martin]

create an icon called favicon.ico and IE will automatically look for it at
the root of the web site.

Steve

> -Original Message-
> From: Milks, Jim [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2001 18:39
> To: CF-Talk
> Subject: OT:How do I put the little image in the address bar in IE?
>
>
> Hi,
> I have a client who is hell-bent on having his logo appear in the
> IE address
> bar and when people bookmark his site. How is this done? It is IE only,
> right?
>
> Thanks,
>
> James
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFID and CFTOKEN, client variables, hidden form fields

[Steve Martin]

It doesn't work if you use hidden form fields, you need to append the token
to the file portion within the form tag:

 etc.


Steve


-Original Message-
From: Peter Lutwyche [mailto:[EMAIL PROTECTED]]
Sent: 26 January 2001 12:27
To: CF-Talk
Subject: CFID and CFTOKEN, client variables, hidden form fields


Apologies if this one has been asked before, but I couldn't find an answer
in the archives.

I would like to maintain state using Client (or Session) variables but do
not want to use cookies. I know I am therefore reliant on the CFID and
CFTOKEN being passed from page to page. What I would like to do is pass CFID
and CFTOKEN as hidden form fields, rather than as URL variables. So far I
have been able to create my forms containing a hidden CFID and CFTOKEN, but
on submission of the form I'm unable to access any Client (or Session)
variables using the ID and TOKEN. Has anyone managed to achieve this, and if
so, would you be able to post a snippet of code?

Cheers
Pete


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


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

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

RE: Allaire wish list

[Steve Martin]

[EMAIL PROTECTED]
(or possibly even [EMAIL PROTECTED]  )

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2001 16:56
To: CF-Talk
Subject: Allaire wish list


What's the e-mail address to send CFAS enhancement requests to?



Thanks

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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: FileLocking error with CFFile

[Steve Martin]

Oops, no atachments allowed. Here it is in full:

Originally posted by Gregory Narain - ages ago.
===
All of the entries go into the
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters
key

ObjectCacheTTL (DWORD)
--
This thing supposedly tells IIS how long to hold on to the files.  They
have a special value (as opposed to using just 0!) of 0x that
supposedly disables the scavenger.

Defaults to 10 minutes.


ObjectFilesInCache (DWORD)
--
This reduces the total memory allowed to be in cache.  You can simply
set this one to zero.

Defaults to 1000 for every 32MB of memory.


MemoryCacheSize (DWORD)
---
This puppy caches system handles and other things for IIS (directory
listings, etc.)  You can set this to 0 and eliminate the caching
supposedly.

Defaults to 3072000, 3MB.


DisableMemoryCache (DWORD)
--
Well, this one I found from a reference to a knowledge book in the
forums.  Apparently, setting MemoryCache to 0 wasn't intuitive enough so
they made an an extra value.  Set this to 1 and it REALLY will work.  I
tried this one yesterday and it's all good to go now. KB Article Q191742
for reference.

Defaults.. it wasn't ever meant to be used!

=

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

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

RE: Duplicate supported in CF4.0

[Steve Martin]

They do and they don't  ;-)
The Advanced CF course teaches the bits about structures and pointers with
reference to StructCopy(). However Duplicate() is much more generic than
StructCopy() i.e. can copy more than just structs, and (IIRC) performs a
deep copy.

Steve

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: 21 December 2000 11:11
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


But why doesn't allaire use StructCopy ... ;)

-Original Message-----
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 11:43
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Not entirely true. Structcopy does actually duplicate the structure in
question. I think there's some confusion here over  which creates a pointer to the original. Structcopy
however only performs a shallow copy in that any embedded structures within
the structure that you are trying to duplicate aren't copied wholesale but
are referenced through pointers.

Steve

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: 21 December 2000 10:11
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Using StrucyCopy you still reference the original structure. So, when using
structCopy of an application or session variable you still have a pointer to
the shared memory


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:55
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0



StructCopy(structure)


-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889
<http://www.thefactore.com>

Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: [Compress HTML output]

[Steve Martin]

I just stumbled across this thread and I must say that it had never occurred
to me that you could zip html and have it unzipped at the client - should
read a few more RFCs eh!
Anyway, as excited as a small boy in a big room full of sweets I knocked up
a quick tag. Everyone please feel free to use/ignore/modify/etc.





























ATB Steve Martin



-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2000 17:55
To: CF-Talk
Subject: RE: [Compress HTML output]


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Thanks for the reminder on that one!  I was going to do that...  I
even had RFC 2616 on my desk to look up how to do that, and I
completely forgot...

I've actually got some "real work" to do today (darn clients
always interrupting my fun!), but once I get that taken care of, I'll
integrate the various suggestions on this & see if I can turn it into
a real tag

Thanks again to everyone for the tips & pointers!

Best regards,
Zac Bedell


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

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

RE: FileLocking error with CFFile

[Steve Martin]

Attached is a posting from a while back which addresses this issue (IIS4).

Other workarounds include wrapping a bit of exception habdling around the
code so that should the problem occur then you can queue the process i.e.
place the source and destination file refs in a db and reexecute it later.

Steve

-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: 20 December 2000 21:41
To: CF-Talk
Subject: RE: FileLocking error with CFFile


I am getting the same exact error, and I was just looking to
this list for an answer.   I am posting this to keep the thread
alive and see if anyone has a solution.

John McKown, VP Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 Dover, DE 19901
email: [EMAIL PROTECTED]
phone: 302-736-5515
fax: 302-736-5945
icq: 1495432



> -Original Message-
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 08, 2000 10:25 AM
> To: CF-Talk
> Subject: FW: FileLocking error with CFFile
>
>
> Any ideas with this?
>
> This error message is displayed (at random) when attempting to overwrite a
> file using CFFILE action = "Move"
>
> The code works most of the time, but sometimes displays this
> error - if the
> error is displayed, then waiting a couple of mins and hitting
> refresh, will
> normally execute the cffile fine.  It appears as if the file is getting
> locked for some reason.  This is in an admin backend, and is executed just
> after a preview of the existing gif file has been shown (might IIS be
> locking it?)
>
> Can anyone help suggest a reason/solution? otherwise it means a partial
> rewrite of the backend...
>
> -Original Message-
> From: Paul Lowton
> Sent: 08 December 2000 15:17
> To: Daniel Lancelot
> Subject:
>
>
> ==
>
> Error Diagnostic Information
> Error processing CFFILE
>
> Unable to move file
> 'c:\web_sites\brearleyGreens2\public\fileStore\residential\picsoth
> er\temp\pi
> cin1137167269.gif' to path
> 'c:\web_sites\brearleyGreens2\public\fileStore\residential\picsoth
> er\picin11
> 37167269.gif'. Access is denied. (error 5)
>
> The error occurred while processing an element with a general
> identifier of
> (CFFILE), occupying document position (90:3) to (92:108).
>
>
> Date/Time: 12/08/00 15:21:49
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)
> Remote Address: 195.226.55.82
> HTTP Referer:
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Duplicate supported in CF4.0

[Steve Martin]

Not entirely true. Structcopy does actually duplicate the structure in
question. I think there's some confusion here over  which creates a pointer to the original. Structcopy
however only performs a shallow copy in that any embedded structures within
the structure that you are trying to duplicate aren't copied wholesale but
are referenced through pointers.

Steve

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: 21 December 2000 10:11
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


Using StrucyCopy you still reference the original structure. So, when using
structCopy of an application or session variable you still have a pointer to
the shared memory


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:55
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0



StructCopy(structure)


-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:54 AM
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


How do you duplicate a structure in CF4.0?

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: donderdag 21 december 2000 10:40
To: CF-Talk
Subject: RE: Duplicate supported in CF4.0


No it's not!

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Johan Coens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:47 AM
To: CF-Talk
Subject: Duplicate supported in CF4.0


Quick question
is the Duplicate function supported in CF4.0?

Best regards,
Johan Coens

=
Ing. Johan Coens
Certified ColdFusion Developer

Friesestraatweg 215a
P.o. Box 2010 9704 CA Groningen
The Netherlands
Tel: +31 (0)50 57 57 888
Fax: +31 (0)50 57 57 889


Premium Partner for Allaire Cold Fusion
Multimedia development with Macromedia Director, Authorware, Flash.

"Imagination is more important than knowledge. Knowledge is limited.
Imagination encircles the world."
Albert Einstein
=
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Passing XML content back as XML

[Steve Martin]

quite simply text/xml
You need IE5+ to view the XML in the browser.

-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 06 December 2000 11:51
To: CF-Talk
Subject: Passing XML content back as XML


is there anyway in cf to pass am xml packet back, so that the browser knows
it is XML?

I assume its somthing to do with mime types an CFCONTENT?

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

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

RE: passing a negative value

[Steve Martin]

URLEncodedFormat() even.

Steve

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2000 18:12
To: CF-Talk
Subject: RE: passing a negative value


wouldn't urlencrypt() work?  Pass in -5, it gets url coded, and then on the
application page you don't have to do anything, as CF will automatically
decode url encryption for you?

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 02, 2000 10:36 AM
> To: CF-Talk
> Subject: passing a negative value
>
>
> I need to pass a negative value to a url variable, anybody
> know how I should
> go about this?
>
> I know I can probably just represent negative numbers with a static
> character like M5 would be -5, I could just replace the m
> with a - and do my
> calculations.
> There has to be a faster way...
>
> jon
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: How To Determine Logged In Users

[Steve Martin]

When a user logs in, update an application variable keyed on their userid
with a timestamp. To view a list of logged in users simply list all the
userids which have a timestamp of less than your chosen session timeout
period.

Steve

> -Original Message-
> From: AustralianAccommodation.com Pty. Ltd.
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 15, 2000 20:51
> To: CF-Talk
> Subject: How To Determine Logged In Users
>
>
> Just wondering how I can go about coding so I can determine the
> names of those members who are currently logged into my website.
> At the moment I can determine the number of persons logged in and
> their ip addresses however I am wanting  to try and take it to
> the next step so that I can see who exactly is logged in
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Email: [EMAIL PROTECTED]
> Developers Of:
>   Website: www.AustralianAccommodation.com
>   Website: www.AccommodationNewZealand.com
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: date comparisons

[Steve Martin]

SELECT * FROM table
WHERE datefield BETWEEN #LSParseDateTime(date1)# AND
#LSParseDateTime(date2)#

Book: SQL for smarties - Joe Celko

Steve

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 20:41
> To: CF-Talk
> Subject: date comparisons
>
>
>
> One of the fields in my table is a datestamp.  I need to be able
> to pull only those records whose datestamps are between certain
> dates.  I would like to limit my query to only pull the records I
> need based on their dates, but frankly this app will be getting
> low enough usage that if I could pull all records and then
> evaluate whether or not to print them, that would be fine, too.
>
> Second question:  Is there a good simple sql book that I could
> get that would keep me from having to bug the smart people
> everytime I can't figure out some stupid syntax problem?
>
> Willy
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: Is Cold Fusion a Typed Language?

[Steve Martin]

CF is basically untyped. When using variables or constants CF uses 'lazy
evaluation' where the type of a particular var or const is evaluated at
runtime, for example you can stick an integer value into a variable and then
stick that variable into a dateformatting function and you will only get an
error at runtime if the function can't cast the variable into the expected
type.

There are 2 basic type that exist - simple values and complex values.
Complex values are structures, arrays, com objects, query recordsets. Simple
values are string, int, float, datetimes, lists. All the simple datatypes
are represented internally as simple text strings which means that you can
use any of the string functions on say for example, a date object.
Similarly, you can treat a sentence as a space delimited list.

To demonstrate the late or lazy typing of CF try out the following code:






#HTMLEditFormat(outputPacket1)#

#HTMLEditFormat(outputPacket2)#


Notice the difference in the type of data indicated by the wddx packet.
n.b. this is important when using WDDX to pass packets to other application
environments where there is typing.

Steve


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 15:34
> To: CF-Talk
> Subject: RE: Is Cold Fusion a Typed Language?
>
>
> There was a brief reference to constants in that article, but nothing
> describing how constants are created.  Anyone have further information on
> that topic?
>
> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 9:48 AM
> To: CF-Talk
> Subject: Re: Is Cold Fusion a Typed Language?
>
>
> Here is an article that Allaire recently posted on their website
> that should
> answer all your questions.
>
> http://www.allaire.com/handlers/index.cfm?ID=14718&Method=Full&Tit
le=ColdFus
ion%20Expressions%3A%20Operands%2C%20Operators%2C%20and%20Other%20Constructs
&Cache=False

I guess ColdFusion would be called  an optionally typed language. You can
type variables if it becomes necessary.


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


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

RE: Poll two tables...

[Steve Martin]

Make use of the custom fields when you create your indexes. Custom1 could be
used to store a reference to the table and custom2 to the primary key in
said table. Check your docs for details on how to use these fields - it's
pretty straightforward.

Steve

> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 14:46
> To: CF-Talk
> Subject: Poll two tables...
>
>
> Not sure how'd I would go about doing this, so here's my question.
>
> I do a verity search, then query the verity results - match those results
> from a table in my DB, and present the final results.
>
> Problem is every once in a while some of the matched verity
> results may lay
> in another table.
>
> Any suggestions for me?
>
> Thanks,
> Pete
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: Passing PWs via URL bar

[Steve Martin]

This is true, I forgot about those 'useful' aspects of modern browsers.
On that note, I believe there are programatic methods to remove URLs from
the browser's history using javascript.
Steve.

> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 12:53
> To: CF-Talk
> Subject: RE: Passing PWs via URL bar
>
>
> Okay.  I use IE.  It has something called "inline autocomplete" for web
> addresses.
>
> Lets say someone else uses my machine.  They could type in
> "http://www." and
> get all the urls beginning with "www." and then put in "a" then
> "b" then "c"
> etc... and at some point they would be able to see a url with a
> password in
> it!
>
> If the URL did not contain the password, they would not be able to see it.
> They may (and it's only may depending on coding) be able to see the page
> using the posted form contents.
>
> Lets say it was passed in the form variable.  At the very least,
> this would
> stop a casual user being able to accidentally see
> "http://www.somewhere.com/admin/login.cfm?username=myuser&password=mypass"
>
> That is why I used the term "at the very least".
>
> Lets just say that it is the least the programmer should do.
>
> Paul
>
> > -Original Message-
> > From: Steve Martin [mailto:[EMAIL PROTECTED]]
> > Sent: 07 November 2000 12:34
> > To: CF-Talk
> > Subject: RE: Passing PWs via URL bar
> >
> >
> > "Passing it through the HTTP header as a form variable would be
> > more secure
> > at the very least."
> >
> > I wouldn't say so. If the value is passed either via URL or by
> form field
> > the data is still plaintext and can be intercepted either way.
> >
> > >
> > > Jake,
> > >
> > > I would suggest using javascript to encrypt the pw string if
> you HAVE to
> > > pass it through the URL string (I am assuming here that it has
> > > been inputted
> > > in a text field and it can't be passed any other way).  If
> you are only
> > > going to store the variable and don't need to know what the
> > > string is then I
> > > suggest one-way hashing with the MD5 algorithm. If you need
> to know the
> > > password string, then I suggest that you find some way of not
> passing it
> > > into the URL.  Passing it through the HTTP header as a form
> > variable would
> > > be more secure at the very least.
> > >
> > > Moral of story: do your best never to pass passwords through the
> > > URL string.
> > >
> > > Paul
> > >
> > > PS You can ensure that the user is using Javascript by writing a
> > > Javascript
> > > redirect to itself with an added URL string of js=yes and a
> timestamp of
> > > some sort so that CF can stop it if the user tries to hack into
> > > the page at
> > > a later time.  If you want to know what I mean, email me off list.
> > >
> > > > -Original Message-
> > > > From: Jake Hileman - Patmos [mailto:[EMAIL PROTECTED]]
> > > > Sent: 06 November 2000 16:06
> > > > To: CF-Talk
> > > > Subject: Passing PWs via URL bar
> > > >
> > > >
> > > > Any idea how I can encode/encrypt a pw to be passed via the URL bar?
> > > > Encrypt and URLEncode don't play nice together.  :-)
> > > >
> > > >
> > > > Any ideas?
> > > >
> > > > jake
> > > >
> > > > --
> > > > --
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > > or send a message with 'unsubscribe' in the body to
> > > > [EMAIL PROTECTED]
> > > >
> > >
> > >
> > > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > or send a message with 'unsubscribe' in the body to
> > > [EMAIL PROTECTED]
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

RE: Passing PWs via URL bar

[Steve Martin]

"Passing it through the HTTP header as a form variable would be more secure
at the very least."

I wouldn't say so. If the value is passed either via URL or by form field
the data is still plaintext and can be intercepted either way.

>
> Jake,
>
> I would suggest using javascript to encrypt the pw string if you HAVE to
> pass it through the URL string (I am assuming here that it has
> been inputted
> in a text field and it can't be passed any other way).  If you are only
> going to store the variable and don't need to know what the
> string is then I
> suggest one-way hashing with the MD5 algorithm. If you need to know the
> password string, then I suggest that you find some way of not passing it
> into the URL.  Passing it through the HTTP header as a form variable would
> be more secure at the very least.
>
> Moral of story: do your best never to pass passwords through the
> URL string.
>
> Paul
>
> PS You can ensure that the user is using Javascript by writing a
> Javascript
> redirect to itself with an added URL string of js=yes and a timestamp of
> some sort so that CF can stop it if the user tries to hack into
> the page at
> a later time.  If you want to know what I mean, email me off list.
>
> > -Original Message-
> > From: Jake Hileman - Patmos [mailto:[EMAIL PROTECTED]]
> > Sent: 06 November 2000 16:06
> > To: CF-Talk
> > Subject: Passing PWs via URL bar
> >
> >
> > Any idea how I can encode/encrypt a pw to be passed via the URL bar?
> > Encrypt and URLEncode don't play nice together.  :-)
> >
> >
> > Any ideas?
> >
> > jake
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
>
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

RE: Variables within string

[Steve Martin]

#Evaluate(DE(longstring))#


Steve


> -Original Message-
> From: Gordon Burns [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 05, 2000 23:06
> To: CF-Talk
> Subject: Variables within string
> 
> 
> I have a variable #longstring#.  This variable contains a string on
> the lines of:
> 
> "Todays team is #team# currently at #position# in the league"
> 
> This gets passed to another template as #longstring# how do I get
> this template to evaluate and display team and position which are
> values pulled from the database.
> 
> I have tried evaluate but to no avail.
> 
> Any suggestions seized upon with the usual enthusiasm of those
> blind to what must be obvious.
> 
> TIA
> 
> 
> Gordon
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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

RE: CF 4.0.0 and CFHEADER

[Steve Martin]

You would use CFHEADER to return any custom headers you like. This includes
headers to tell proxy servers not to cache. Quite what 'optimum values'
means in terms of http headers I don't know.

Incidentally, are you _really_ going to deploy a site using CF4.0.0 bearing
in mind it officially contains bugs, hence the 4.01 release.

Steve

> -Original Message-
> From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 06, 2000 07:22
> To: CF-Talk
> Subject: CF 4.0.0 and CFHEADER
>
>
> Hi all,
>
> In CFWACK, the only mention of CFHEADER that I can find says "There is
> usually little need to use  because ColdFusion sets the HTTP
> headers automatically to optimum values" (page 818).
>
> I'm close to deploying a fairly large site on a CF 4.0.0 server. Is this
> statement fairly accurate? Is there any point, for example, in
> specifying a
> CFHEADER "expires now" tag in my app cfm so that proxy servers don't cache
> dynamic pages?
>
> Thanks,
> Kay.
> __
> Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
> Internet Solutions for your business!
>
> Level 9/105 St George's Tc - Perth - Western Australia
> Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
> Visit Perth online! : www.perthweb.com.au
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: and the "required" field

[Steve Martin]

This can apply to normal select fields too given that the criteria for
passing the required field stipulation is that the value of the field in
question contains must value that isn't the empty string - in the same
manner as required text fields. For example your first option may be (Please choose an option). In this case setting required will not
let you get away with leaving the above option selected.

Steve

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 05, 2000 01:10
> To: CF-Talk
> Cc: '[EMAIL PROTECTED]'
> Subject: RE:  and the "required" field
>
>
> > The "required" option for CFSELECT is rather silly, when you
> > consider how SELECT boxes work. In a SELECT, something is
> > always selected (the default option, if not changed).
>
> This isn't necessarily true for multi-select boxes. Some browsers will not
> preselect any option within a multi-select box unless the option has the
> SELECTED attribute.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: Getting List of all cookies

[Steve Martin]

Similarly cookies are stored in the cookie structure so you could do a
StructKeyList(cookie)

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 01, 2000 09:05
> To: CF-Talk
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Getting List of all cookies
>
>
> > Since the recent thread on getting a list of all form fields
> > got so many responses, I thought I'd try posting this tougher
> > question again.
> >
> > I have been searching for quite a while for a way to get all
> > available cookies, similar to #form.fieldnames#.
> >
> > I can do it in other languages, so I think there must be a way.
>
> You can retrieve this from the CGI scope, using the variable
> CGI.HTTP_COOKIE. This will contain a list delimited by semicolons.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: Startstop.htm

[Steve Martin]

Absolutely. In fact I don't even let CF anywhere near the executing of the
batch file, I have IIS call it directly - with the relevant security - of
course, that way if it fails to restart first time I can call another batch
file that runs a net start.

> -Original Message-
> From: lsellers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 17:45
> To: CF-Talk
> Subject: RE: Startstop.htm
>
>
> > Alternatively you could rig up a batch file with execute
> permissions which
> > contains a NET STOP/START to the appropriate services which you can call
> > from a browser.
>
> Naw. That's just too obvious. :)
>
> But it is actually the best way, because you can spawn it off so
> it survives
> a cf reboot.
>
> --min
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

RE: CFINCLUDE Problem

[Steve Martin]

Um, can't see anything wrong with that. Once mapped, a directory should be
immediately available - without a restart and without mapping it on the web
server either. /me scratches head. I'm stumped, there has to be something
that has been missed somewhere though I'll be blown if I can think of what
it could be at present.


> My mapping settings are:
>
> Logical Path: /Templates/
> Directory Path: C:\Inetpub\wwwroot\new\Templates\
>
>
> This is my CF Code:
>
> 
>
> >From: "Steve Martin" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: RE: CFINCLUDE Problem
> >Date: Mon, 30 Oct 2000 17:19:39 -
> >
> >Sal, can you detail _exactly_ what you did, i.e. exactly what
> you typed for
> >your mappings and exactly what you typed to include the file.
> >
> >Steve
> >
> > > -Original Message-
> > > From: S R [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 30, 2000 17:13
> > > To: CF-Talk
> > > Subject: Re: CFINCLUDE Problem
> > >
> > >
> > > I did do this and I still get an error saying I must map the
> directory
> >in
> > > the ColdFusion Admin. The setup is exactly as you have it below. The
> >only
> > > thing I could think of is that when I entered the mapping in the
> > > CF Admin I
> > > did not 'restart' the server. Does this need to be done?
> > >
> > > Sal
> > >
> > >
> > > >From: "John Cummings" <[EMAIL PROTECTED]>
> > > >Reply-To: [EMAIL PROTECTED]
> > > >To: CF-Talk <[EMAIL PROTECTED]>
> > > >Subject: Re: CFINCLUDE Problem
> > > >Date: Fri, 27 Oct 2000 21:28:23 -0400
> > > >
> > > >Where is the "Templates" folder in relation to the directory that the
> > > >calling file is in?
> > > >
> > > >For example, if your index.cfm file is the "calling" template,
> > > and it is in
> > > >say, C:\DOCS - and the templates.cfm file is in
> > > C:\DOCS\TEMPLATES then you
> > > >would need to include this path information in the call.
> > > >
> > > >- Original Message -
> > > >From: "S R" <[EMAIL PROTECTED]>
> > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > >Sent: Friday, October 27, 2000 7:44 PM
> > > >Subject: CFINCLUDE Problem
> > > >
> > > >
> > > > > Hi,
> > > > >
> > > > > I have an index.cfm page in my websites root folder and
> I'm trying
> >to
> > > >use
> > > >a
> > > > >  to call a file within a folder called
> > > 'Templates'
> > > >but
> > > > > it is not working. It works if the file I am trying to
> > > reference is in
> > > >the
> > > > > same place as the Index.cfm file but when I put it in this
> >'Templates'
> > > > > folder, my browser just hangs. I mapped the directory in the CF
> >Admin
> > > >and
> > > >it
> > > > > still doesn't work. Does this directory also have to be added
> > > to the Web
> > > > > Server or something?
> > > > >
> > > > > Thanks
> > > > >
> > > > > Sal
> > > > >
> > >
> >
> >_
> > > > > Get Your Private, Free E-mail from MSN Hotmail at
> > > >http://www.hotmail.com.
> > > > >
> > > > > Share information about yourself, create your own public
> profile at
> > > > > http://profiles.msn.com.
> > > > >
> > > > >
> > > >-
> > > -
> > > >--
> > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > > Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or
> > >send
> > >a message with 'unsubscribe' in the body to
> > >[EMAIL PROTECTED]
> > > >
> > >
> > >-
> > ---
> > >Archives: http://www.mail-archive.com/cf-talk@hou

RE: Startstop.htm

[Steve Martin]

Alternatively you could rig up a batch file with execute permissions which
contains a NET STOP/START to the appropriate services which you can call
from a browser.

Steve

> -Original Message-
> From: lsellers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 17:27
> To: CF-Talk
> Subject: RE: Startstop.htm
>
>
>
> > > Can anyone give me the skinny on startstop.html.  It
> > > is a java applet that Allaire provides or used to
> > > provide with ColdFusion to allow you to remotely
> > > start and stop a ColdFusion server.  Apparently it was
> > > somewhat dependant on RDS running.  Does anyone know
> > > what the whereabouts of this utility are?
> >
> > It's no longer provided in CF. It's obviously a potential
> > security problem,
> > and I think enough people left it unsecured that the Allaire
> guys figured
> > they'd better not put it in!
>
> Try looking for CFX_Service (?) or in the gallery. I'm fairly
> certain there
> are a couple free ones floating about with similiar names.
>
> (I've written one myself called CFX_Services, but that's part of ihtk.)
>
> --min
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>


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

RE: CFINCLUDE Problem

[Steve Martin]

Sal, can you detail _exactly_ what you did, i.e. exactly what you typed for
your mappings and exactly what you typed to include the file.

Steve

> -Original Message-
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 17:13
> To: CF-Talk
> Subject: Re: CFINCLUDE Problem
>
>
> I did do this and I still get an error saying I must map the directory in
> the ColdFusion Admin. The setup is exactly as you have it below. The only
> thing I could think of is that when I entered the mapping in the
> CF Admin I
> did not 'restart' the server. Does this need to be done?
>
> Sal
>
>
> >From: "John Cummings" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: Re: CFINCLUDE Problem
> >Date: Fri, 27 Oct 2000 21:28:23 -0400
> >
> >Where is the "Templates" folder in relation to the directory that the
> >calling file is in?
> >
> >For example, if your index.cfm file is the "calling" template,
> and it is in
> >say, C:\DOCS - and the templates.cfm file is in
> C:\DOCS\TEMPLATES then you
> >would need to include this path information in the call.
> >
> >- Original Message -
> >From: "S R" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Friday, October 27, 2000 7:44 PM
> >Subject: CFINCLUDE Problem
> >
> >
> > > Hi,
> > >
> > > I have an index.cfm page in my websites root folder and I'm trying to
> >use
> >a
> > >  to call a file within a folder called
> 'Templates'
> >but
> > > it is not working. It works if the file I am trying to
> reference is in
> >the
> > > same place as the Index.cfm file but when I put it in this 'Templates'
> > > folder, my browser just hangs. I mapped the directory in the CF Admin
> >and
> >it
> > > still doesn't work. Does this directory also have to be added
> to the Web
> > > Server or something?
> > >
> > > Thanks
> > >
> > > Sal
> > >
> >_
> > > Get Your Private, Free E-mail from MSN Hotmail at
> >http://www.hotmail.com.
> > >
> > > Share information about yourself, create your own public profile at
> > > http://profiles.msn.com.
> > >
> > >
> >-
> -
> >--
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send
> >a message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> > >
> >
> >-
> ---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]

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

Share information about yourself, create your own public profile at
http://profiles.msn.com.



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


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