Re: Editing PERL in HomeSite+ or DWMX

[Stephen Hait]

Programmers File Editor is a long-time fave. If you can find it you 
might like it for Perl.

I also find I'm using EditPad Pro a lot these days. It has a variety 
of modules for color coding and formatting in different "languages" 
- Perl, ASP, CFML, SQL, etc.

Stephen

> Does anyone know if HomeSite+ or DWMX make good PERL editors?  If
> not, what is the best application development environment out there
> for PERL?
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

cfdump - server variables

[Stephen Hait]

I have seen references to being able to use cfdump to see the 
contents of the server variables structure but when I try using it 
(CF5) I get an error. Is there an easy way to get a listing of all the 
server scope variables and their values?

TIA,
Stephen

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

RE: cfdump - server variables

[Stephen Hait]

> You can only cfdump the Server scope in CFMX.

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

RE: Update Problem in CF

[Stephen Hait]

This should work with SQL Server

update table1
set price = b.price
from table1 a join table2 b on a.productid = b.productid
and a.modelno = b.modelno

> > I have two tables in a DB containing information about the same
> > products. Table 1 is comprehensive and has complete details about
> > the products. Table 2 has fewer no of fields. The fields common in
> > both Table 1 and Table 2 are productid, modelno, price, details .
> >
> > Table1.price contains the old price.
> > Table2. price is the latest price.
> >
> > I want to update Table1.price with the values in Table2.price and
> > use modelno as the unique value for this update.
> >
> > Can someone please help.
> > My SQL knowlede is very basic.
> > Also what if  Table two consists of new products not included in
> > Table 1.? What syntax Should  I use?
> >
> >
> > Thanks
> > JB
> >
> >
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: MM Pricing Problem on CFMX for J2EE

[Stephen Hait]

> Unfortunately, tech support has gone downhill quite a bit from its
> glory days - I remember getting phone resolution for a WordPerfect
> issue where the guy spent hours on the phone with me, debugging some
> silly problem that easily cost them more than they ever made off of
> me. There's probably a lesson to be drawn from that.

Those were the days. Orem, Utah ruled back then. It's been 
downhill ever since.

S
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Form.Fieldnames and MX

[Stephen Hait]

Could this have something to do with MX treating this somewhat 
differently in terms of case than earlier versions?

This is from a run down I saw recently about issues involved with 
upgrading to MX at:
http://www.cfconf.org/cfun-02/talks/cfun02_migrating_from_cf5.ppt

Form.FiledNames
- returns Form.FieldNames in the order in which they were 
created and not in All Uppercase.

Stephen

> Also - I'd avoid using this variable for the sake of future
> compatibility. It has the feel of something that might to be
> depricated.  Now that the FORM scope is a structure, the fieldnames
> variable is redundant. Use StructKeyList( ).
> 
> -Mark
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 9:42 AM
> To: CF-Talk
> Subject: RE: Form.Fieldnames and MX
> 
> 
> > Ok, what happened? I used to be able to loop through
> > form.fieldnames to create a list of all of the fields
> > and then I could write my processor script. CFMX, on
> > the other hand, gives me the following:
> >
> > Element FIELDNAMES is undefined in FORM.
> 
> This variable still exists in CFMX, whenever the page has received
> an HTTP POST with data. So, you probably don't have a POST from your
> HTML form.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Can SQL do that?

[Stephen Hait]

> I'm doing a report page, with all the sales grouped by month. 
> 
> Select SUM(OrderTotal) as Total, MONTH(OrderDate) as M 
> from orders
> GROUP BY Month(OrderDate)
> 
> That returns the month and the total as follow:
> 
> 01(january) 15
> 02(feb) 40
> 03(mar) 50
> 05(may) 20
> and so. 
> 
> Suppose in april, i didnt had sales, i would like the query list it
> too, but with 0 as total. Since i got no April in the
> MONTH(OrderDate), cos i have no sales in april, this month is not
> listed. 

Try GROUP BY ALL Month(OrderDate)
The ALL argument causes all months to be returned even when 
SUM(OrderTotal) IS NULL.

HTH,
Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT SQL Question

[Stephen Hait]

> Can someone assist me with a quick SQL statement.
> 
> I have a table with 3 columns:  A, B, C (A would be the primary key)
> I need to swap the values in column B with the values in column C
> and vice versa.

This should work with MS SQL assuming columns b and c are 
the same data type:
UPDATE t1
SET b=c, c=b

Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re:

[Stephen Hait]

> HI,
> 
> I have the following radio buttons:
> 
>  Yes
>  No
> 
> Currently I can click on both the "yes" and "no" and they both get
> selected. I don't want that to happen. The user should only be able
> to select one. How can I do this?

Use the same name for all radio buttons in a group and provide a 
different value for each one:
 Yes
 No

When the form is submitted, if one of the buttons is selected, the 
form element named radio1 will contain the value Yes or No.

By their nature, radio buttons in a group sharing the same name 
only allow the selection of one element.

Regards,
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Attaching Files to CFMail

[Stephen Hait]

Try this - works w/CF3.1 (the mimeattach is what attaches the 
file):

Current Update as of #DateFormat(Now(),"m-d-")# 
#TimeFormat(Now())#:

Attached you will find the current update.  Updates will continue 
while the situation is being tracked.

Thanks...Admin. Support


> Hi All,
> 
> Does anyone have an example of how to attach files to cfmail? For
> now I just need to attach one file.
> 
> Duane Boudreau
> CFExperts.Com
> 
> 
> 
> -- Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
> Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


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

Re: I GIVE UP!

[Stephen Hait]

try <> 6


> I want to select all records from a table that  "do not" contain the
> number 6. Sheesh!  Why is it so difficult to select records this
> way...
> 
> the query was
> 
> Select *
> From CaseDetail, CaseInfo
> Where CaseDetail.CaseID=CaseInfo.CaseID
> And CaseDetail.StatusID ?   6
> 
> I've tried NEQ, Does Not Contain,  I'm lost!
> 
> 
> -- Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
> Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


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

latest version of studio?

[Stephen Hait]

Anyone know what the latest release version of CF Studio for 
Windows is?

TIA, Stephen

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

RE: latest version of studio?

[Stephen Hait]

Thanks.
Is there any good reason to upgrade from Studio 4.0 at this point?

Is 4.5a an alpha version or an earlier version than 4.5.1?

TIA, Stephen

> 4.5.1, for production releases. The 4.5.1 SP1 upgrades only apply to
> CF Server.
> 
> Steve
> 
> -Original Message-----
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 13, 2000 6:13 PM
> To: [EMAIL PROTECTED]
> Subject: latest version of studio?
> 
> 
> Anyone know what the latest release version of CF Studio for
> Windows is?
> 
> TIA, Stephen
> 
> 
> -- Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
> Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


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

Re: Advanced SQL Query Question

[Stephen Hait]

> Hello,
> 
> I'm working on a project where records will be added to a single
> table, and each record will be assigned to one of six categories
> (using a category column). Is there a way I can do a single query to
> pull the most recent record from each of the six categories? Or is
> my only option to do queries of queries on my CF template?

Not sure of your actual table structure or database but you could 
possibly use the UNION operator for this. Assuming your 
database is MS SQL Server and there is some column in your 
table that you can use to determine the "most recent" (such as 
an ID or timestamp column):
SELECT TOP 1 *
FROM tbl
WHERE category = 'A'
ORDER BY ID DESC
UNION
SELECT TOP 1 *
FROM tbl
WHERE category = 'B'
ORDER BY ID DESC
... and so on for all the categories.

If you had six categories, this would return six rows, one per 
category, with the "most recent" entry for each category.

HTH,
Stephen


> Thanks,
> Jonathan
> 
> Jonathan Mauney
> Manager, Digital Media Properties / Web Application Developer
> 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio
> Network Jefferson-Pilot Communications Co. One Julian Price Place
> Charlotte, North Carolina 28208 704.374.3862 [voice] 704.374.3884
> [fax] [EMAIL PROTECTED]   [email]
> 
> 
> 
> ~| Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription:
> http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&for
> umid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> 
> Host with the leader in ColdFusion hosting. 
> Voted #1 ColdFusion host by CF Developers. 
> Offering shared and dedicated hosting options. 
> www.cfxhosting.com/default.cfm?redirect=10481
> 
> Unsubscribe:
> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=2137.
> 2057.4
> 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Spamcop probs w/list - anyone else?

[Stephen Hait]

Does anyone else on the [EMAIL PROTECTED] list use 
spamcop.net to filter their mail? I'm finding that quite a number of 
messages from this list get blocked but messages from other 
lists do not.

Any ideas?

Regards,
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQL Question

[Stephen Hait]

See comment below; hope it helps:

> I am not being able to make this (left) or the previous suggestion
> of LIKE work.  Stripped down SQL code below ...
> 
> Table IssueUpdates.Owner (3 records) =
>  'Doe, Jones'
>  'James'
>  'Doe, James'
> 
> The data I need is (3 records) - Doe, James, Doe
> 
> Neither of the below queries return this - they both return empty.
> 
> SELECT Owner
> FROM IssueUpdates
> WHERE Owner LIKE 'Doe' + ',%'

Try:
SELECT LEFT(owner, CHARINDEX(',', owner)-1) as owner
FROM issueupdates
WHERE owner like '%,%'
UNION ALL
SELECT RTRIM(owner) as owner
FROM issueupdates
WHERE owner not like '%,%'

> SELECT Owner
> FROM IssueUpdates
> WHERE left(IssueUpdates.Owner, instr(IssueUpdates.Owner, ',')) =
> 'Doe'
> 
> This is going in the right direction, but does not appear to be
> there quite yet.
> 
> Thanks
> -- Jeff
> 
> 
> 
> -Original Message-
> From: Matthew Small [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, January 16, 2003 2:22 PM
> To: CF-Talk
> Subject: RE: SQL Question
> 
> 
> where table1.username = left(table2.names,instr(table2.names,','))
> 
> see if that works
> 
> Matthew Small
> IT Supervisor
> Showstopper National Dance Competitions
> 3660 Old Kings Hwy 
> Murrells Inlet, SC 29576
> 843-357-1847
> http://www.showstopperonline.com
> 
> -Original Message-
> From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, January 16, 2003 3:07 PM
> To: CF-Talk
> Subject: WOT: SQL Question
> 
> This is way off topic, but I need some quick help here.
> 
> I have two tables - one with a users name and email address -
> another that has a field that is a comma separated list of user's
> names.
> 
> I need to do a join on the two tables where the users name in table
> one matches the FIRST users name in the second table.
> 
> This is a hand-me down Access db that is not being used in the way
> it was intended, but I have to work with it anyways.  Is there any
> way to do something like listFirst in SQL?
> 
> Thanks
> -- Jeff
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Studio 5 development mappings problem

[Stephen Hait]

Has anyone encountered this problem and, if so, did you find a 
resolution?

I have W2K Pro running IIS 5 with virtual directories as follows:
mydir mapped to c:\inetpub\wwwroot\mydir
mydir2 mapped to c:\inetpub\wwwroot\mydir2

I can browse the contents of both these directories with the URLs:
http://127.0.0.1/mydir/
http://127.0.0.1/mydir2/

I've set up two development mappings in Studio 5:
Studio and server path: c:\intepub\wwwroot\dir
Browser path: http://127.0.0.1/mydir/

Studio and server path: c:\inetpub\wwwroot\dir2
Browser path: http://127.0.0.1/mydir2/

Within Studio, I can "browse" mydir no problem but when I try to 
browse files in mydir2 the URL that is trying to be resolved ends 
up as http://127.0.0.1/mydir/2/

The same thing will occur with virtual and physical directories 
named mydir and mydirold; mydirold resolves to 
http://127.0.0.1/mydir/old/

Any light appreciated.

Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Studio 5 development mappings problem

[Stephen Hait]

Thanks. That sounds logical and I'll try it.

Stephen

> Stephen,
> 
> It is a matter of consistency among each of the three values needed
> for a mapping.  The URL used for "Browser Path" ends in a  slash,
> yet the other two values, "Studio Path" and "Server Path", do not. 
> Either add a slash to the end of these two values or remove the
> slash from the end of the "Browser Path" value.
> 
> Paul Kenney
> [EMAIL PROTECTED]
> 
> 
> > -Original Message-
> > From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 23, 2003 11:17 AM
> > To: CF-Talk
> > Subject: Studio 5 development mappings problem
> >
> >
> > Has anyone encountered this problem and, if so, did you find a
> > resolution?
> >
> > I have W2K Pro running IIS 5 with virtual directories as follows:
> > mydir mapped to c:\inetpub\wwwroot\mydir mydir2 mapped to
> > c:\inetpub\wwwroot\mydir2
> >
> > I can browse the contents of both these directories with the URLs:
> > http://127.0.0.1/mydir/ http://127.0.0.1/mydir2/
> >
> > I've set up two development mappings in Studio 5:
> > Studio and server path: c:\intepub\wwwroot\dir
> > Browser path: http://127.0.0.1/mydir/
> >
> > Studio and server path: c:\inetpub\wwwroot\dir2
> > Browser path: http://127.0.0.1/mydir2/
> >
> > Within Studio, I can "browse" mydir no problem but when I try to
> > browse files in mydir2 the URL that is trying to be resolved ends
> > up as http://127.0.0.1/mydir/2/
> >
> > The same thing will occur with virtual and physical directories
> > named mydir and mydirold; mydirold resolves to
> > http://127.0.0.1/mydir/old/
> >
> > Any light appreciated.
> >
> > Stephen
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Studio 5 development mappings problem-Followup

[Stephen Hait]

It turns out that putting slashes at the end of all three values 
worked. Having no slashes at the end of the values results in the 
problem described below.

Thanks again for the suggestion.

Stephen

> Thanks. That sounds logical and I'll try it.
> 
> Stephen
> 
> > Stephen,
> > 
> > It is a matter of consistency among each of the three values
> > needed for a mapping.  The URL used for "Browser Path" ends in a 
> > slash, yet the other two values, "Studio Path" and "Server Path",
> > do not. Either add a slash to the end of these two values or
> > remove the slash from the end of the "Browser Path" value.
> > 
> > Paul Kenney
> > [EMAIL PROTECTED]
> > 
> > 
> > > -Original Message-
> > > From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, January 23, 2003 11:17 AM
> > > To: CF-Talk
> > > Subject: Studio 5 development mappings problem
> > >
> > >
> > > Has anyone encountered this problem and, if so, did you find a
> > > resolution?
> > >
> > > I have W2K Pro running IIS 5 with virtual directories as
> > > follows: mydir mapped to c:\inetpub\wwwroot\mydir mydir2 mapped
> > > to c:\inetpub\wwwroot\mydir2
> > >
> > > I can browse the contents of both these directories with the
> > > URLs: http://127.0.0.1/mydir/ http://127.0.0.1/mydir2/
> > >
> > > I've set up two development mappings in Studio 5:
> > > Studio and server path: c:\intepub\wwwroot\dir
> > > Browser path: http://127.0.0.1/mydir/
> > >
> > > Studio and server path: c:\inetpub\wwwroot\dir2
> > > Browser path: http://127.0.0.1/mydir2/
> > >
> > > Within Studio, I can "browse" mydir no problem but when I try to
> > > browse files in mydir2 the URL that is trying to be resolved
> > > ends up as http://127.0.0.1/mydir/2/
> > >
> > > The same thing will occur with virtual and physical directories
> > > named mydir and mydirold; mydirold resolves to
> > > http://127.0.0.1/mydir/old/
> > >
> > > Any light appreciated.
> > >
> > > Stephen
> > > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Studio 5 development mappings problem

[Stephen Hait]

> > I have W2K Pro running IIS 5 with virtual directories 
> > as follows:
> > mydir mapped to c:\inetpub\wwwroot\mydir
> > mydir2 mapped to c:\inetpub\wwwroot\mydir2
> > 
> > I can browse the contents of both these directories with 
> > the URLs:
> > http://127.0.0.1/mydir/
> > http://127.0.0.1/mydir2/
> > 
> > I've set up two development mappings in Studio 5:
> > Studio and server path: c:\intepub\wwwroot\dir
> > Browser path: http://127.0.0.1/mydir/
> > 
> > Studio and server path: c:\inetpub\wwwroot\dir2
> > Browser path: http://127.0.0.1/mydir2/
> 
> While you've already found a solution to your problem, I thought it
> might be worth noting that you can simply create one mapping to your
> web server's root directory, rather than creating mappings to each
> subdirectory.
> 
> Dave Watts, CTO, Fig Leaf Software

Actually I've got a number of virtual directories corresponding to 
different clients. c:\inetpub\wwwroot\ contains a site for one, 
d:\website\htdocs\clienttwo\ and d:\website\htdocs\clientthree\ 
correspond to other clients' websites (originally I was running 
O'Reilly WebSite).

With the limited version of IIS I'm running which only allows one 
website root, I haven't found a better way of segregating these 
sites for development. If you have any suggestions, I would 
certainly like to hear them.

Regards,
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Studio 5 development mappings problem

[Stephen Hait]

> If you need to run each project within a separate virtual server,
> you can always use Apache instead of the limited IIS in Win2K Pro.
> 
> Dave Watts, CTO, Fig Leaf Software 

Good suggestion. Thanks.
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Recommended Apache version for W2K, CF5?

[Stephen Hait]

Which version of Apache for W2K is best to use with CF5? 

Thanks,
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Apache for W2K, CF5 - probably dumb question, but..

[Stephen Hait]

I need to develop with both CF and ASP - is there a way to do 
this on W2K with Apache? If I run Apache with CF5, do I then 
also need to somehow run IIS for ASP?

Sorry if that sounds stupid :-)
Stephen

> Which version of Apache for W2K is best to use with CF5? 
> 
> Thanks,
> Stephen
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: query help...

[Stephen Hait]

> I have a table with columns named q1,q2,q3, through q19. Each
> question can have a value of 1, 2, or 3. How can I generate a
> query/cfcode that will tell me how many people answered 1, 2, and 3
> for question 1 through question 19 without having a ton of queries?
> I know it needs to loop somehow, but it just hasn't worked out
> correctly so far. 

Another approach you might consider would be to normalize your 
data so instead of having 19 columns representing answers to 
specific questions for each respondant, you would have a table 
with up to 19 rows for each respondant, each with a question ID 
(1-19) and the answer (1-3) such as:

userID, qID, qAnswer

For example, assume the following data in such a table:
userID  qID qAnswer
1   1   1
1   2   2
1   3   3
1   4   3
2   1   3
2   2   3
3   1   1
3   2   1

Than a query like:
select qID, qAnswer, count(userID) as QACnt
from myTable
group by qID, qAnswer

would result in:
qID qAnswer QACnt
1   1   2
1   3   1
2   2   2
2   3   1
3   3   1
4   3   1

This would show you how may (QACnt) had answered each 
question with which response (Question 1 had 2 responses for 
answer 1 and 1 response for answer 3).

Regards,
Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Development Mapping problem - Studio 5

[Stephen Hait]

I have a virtual directory named lama located in 
c:\inetpub\wwwroot\lama
I have another one named lama2 located in 
c:\inetpub\wwwroot\lama2

I have created development mappings for both of these in Studio. 
When I try to "browse" templates in lama2, Studio is attempting 
to connect to http://127.0.0.1/lama/2/index.cfm instead of 
http://127.0.0.1/lama2/index.cfm.

Does anyone know what might be causing this?

__
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: Development Mapping problem - Studio 5

[Stephen Hait]

Thanks - I was trying to make it more complicated than 
necessary.

Regards,
Stephen

> Why not just set your development mapping to c:\inetpub\wwwroot? 
> You don't need separate mappings for Studio.  You also don't need
> virtual directories in IIS for this setup, since your applications
> are right there under wwwroot without any name changes (ie, mapping
> a browser directory name to the 'real' directory name).
> 
> Chuck McElwee
> etech solutions inc
> www.etechsolutions.com
> 
> 
> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 16, 2002 5:25 PM
> To: CF-Talk
> Subject: Development Mapping problem - Studio 5
> 
> 
> I have a virtual directory named lama located in
> c:\inetpub\wwwroot\lama
> I have another one named lama2 located in
> c:\inetpub\wwwroot\lama2
> 
> I have created development mappings for both of these in Studio.
> When I try to "browse" templates in lama2, Studio is attempting to
> connect to http://127.0.0.1/lama/2/index.cfm instead of
> http://127.0.0.1/lama2/index.cfm.
> 
> Does anyone know what might be causing this?
> 
> 
> 
> __ 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


__
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: Tricky sorting riddle.

[Stephen Hait]

Have you tried:
...
ORDER BY DateAdd(MONTH,lease_length,Since)
???

Good luck,
Stephen


> 
> Followup to my own message :-)
> 
> >
> > Hi All,
> >
> > I am building a real-estate DB and I have stumbled over an
> > interesting riddle:
> >
> > In this case I use the following fields in Access DB (tenants)
> >
> > Property_ID -integer (related to an ID in Properties table)
> > Name-Text,
> > sq_ft   -integer
> > rate-currency
> > lease_start -date,
> > term-integer (months)
> >
> > At some point I want to output a partial list of tenants:
> >
> > 
> >   SELECT *
> >   FROM tenants
> >   WHERE Property_ID=#Form.ID#
> >  
> > 
> >
> > Based on existing data, I want to sort those tenants so that
> > those with closest expiration dates are listed first.
> >
> > I thought of using a structure (name, CalculatedExpirationDate),
> > but then I will still need to output other fields from the query,
> > like rate and sq_ft.
> >
> > Is there any other way? Can such sorting be done within 
> > tag?
> >
> > Cyrill
> 
> 
> I tried to execute this: (instead of #CreateODBCDate(now())# I also
> used getdate() which should have worked with SQL server, but I am
> working with Access and it says that getdate() is undefined)
> 
> 
>  SELECT ID, Since, Rate, Lease_length, sq_ft_leased, Name,
> Datediff(dd,#CreateODBCDate(now())#,
> DateAdd(MONTH,lease_length,Since)) AS sortable_date
>  FROM tenants
>  where Property_ID=#TheRecord.ID#
>  Order by sortable_date
> ,
> 
> But I get this:
> ---
> ODBC Error Code = 07001 (Wrong number of parameters)
> 
> 
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
> Expected 3.
> 
> Hint: The cause of this error is usually that your query contains a
> reference to a field which does not exist. You should verify that
> the fields included in your query exist and that you have specified
> their names correctly. ---
> 
> All names check out OK.
> 
> Bummer!
> 
> 
> -- Archives: http://www.eGroups.com/list/cf-talk To
> Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


Stephen Hait <[EMAIL PROTECTED]>

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

list manager - old posts showing up?

[Stephen Hait]

Why are posts from several days ago apparently being resent?

Stephen

Stephen Hait <[EMAIL PROTECTED]>

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

CFMAIL --> CDO/CDONTS problems

[Stephen Hait]

I have a CF shared hosting provider who is recommending 
switching to CDO/CDONTS from CFMAIL for sending e-mail. I've 
successfully created modifcations for a few sites there to 
accomplish this. 

Now I'm trying to implement this locally for development purposes 
and I'm realizing I'm totally lost so I'm asking if anyone has any 
suggestions or pointers to tutorials about this that might resolve 
the problems I'm having (basically mail doesn't get sent from my 
development machines, it just ends up and stays in the IIS 
mailroot\queue directory.)

I've got 2 development platforms, both connecting to the Internet 
via ADSL connection and I'm able to send mail via this 
connection with a mail client through my ISP's mail servers no 
problem; in fact I'm doing that right now. I'm also able to set up 
CFMAIL in the CF Administrator to use CFMAIL no problem. My 
2 platforms are as follows and I'd welcome solutions pertaining to 
either of them:

W2K Pro running CF5 and IIS5 single mode (or whatever it's 
referred to).
W2003 Server Webserver Edition running CFMX6.1 and IIS6.

When trying to use CDONTS on either of these machines, mail 
ends up in the QUEUE directory but just stays there and is never 
sent out. With CF5 I can specify my mail server as 
mail.bellsouth.net (SMTP server I use with a regular mail client) 
and with CFMX I can specify this server and, additionally, specify 
the proper user/password credentials required by Bellsouth to 
send mail via its mail servers. I don't see how to accomplish this 
via CDO/CDONTS and the IIS SMTP service and I'm not even 
sure this is looking in the correct direction.

This one's had me scratching my head for a few days now so any 
suggestions would be extemely welcome.

Sorry if this is a newbie question but I've been trying to find a 
solution in many places and so far have struck out.

Regards,
Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: SQL Problem

[Stephen Hait]

> Update IssueRegister
> SET IssueStatus = '#form.IssueStatus#',
>  Response = '#form.Response#',
> ResponseUserId = '#session.activeuser.USER_NAME#',
>  DateofResponse = #CreateODBCdate(now())#
> Where IssueNumber = #form.issuenumber#
> 
> The error that I get from CF is
> 
> The search key was not found in any record.
> 
> But if I look in the error window it show my statment as follows
> 
> 
> Update IssueRegister_qr SET IssueStatus = 'Closed', Response =
>   'completed',
> ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d
> '2003-12-16'}
>   Where
> IssueNumber = 1110 
> 
> This look correct to me.  So I tried running it in access's
> query window
>   and
> I get the same error, yet when I try to search the column for
> issuenumber 1110 Access finds it through its own search utility.

This is most probably a problem with Access and not your SQL 
statement or ColdFusion. Try a search in Google Groups for "The 
search key was not found in any record". There appear to be any 
number of scenarios that can lead to this vague error message - 
replication, memo fields, Jet version, etc.You are definitely not 
the only one who has experienced this.

Here's something else you might try if it's feasible:
Try creating a new (blank) Access database.
Immediately turn off Name AutoCorrect (Tools | Options | 
General).
Then import everything from the old database (File | Get External 
| Import).

Recreating everything like that may solve the issue.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Weird Images issues...

[Stephen Hait]

> them on the server. When I look at them through either the web site
> or directly in the globalimages directory on a web browser I get
> nadda. No broken links just no image.

FWIW, I also don't see images displayed at 
http://www.lcgis.com/STAGE/index.htm.

I do see the directory listing in the GlobalImages directory but 
cannot actually view any of the images. And if I try to download 
an image from the listing by "Save target as..." I get a file 
downloaded with the image name but it ends up being zero bytes 
on my end.

Have you checked to see if you can access an image stored in 
the /STAGE directory from the /STAGE directory? If so, the 
/STAGE and /STAGE/GlobalImages directories may be set up 
somehow differently.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CFMX on Win2K3 Web Edition?

[Stephen Hait]

> Are there any known issues for installing CFMX on Windows 2003 Web
> Edition? Because we're having problems...first the CF service
> started fine, but would not execute CF pages, now the service won't
> even start.  Any help would be greatly, superly, duperly,
> stupendously, immeasurably appreciated->

This won't be much help, I'm afraid, but I've got CFMX 6.1 running 
on Windows 2003 Web Edition without any problems. When you 
look at CF MX Application Server in your services list, does it 
appear as Started? If not, can you start it? Is Startup Type set to 
Automatic? If not, can you set it to Automatic? If you have other 
CF services in the list, how do they appear to be set?

This is a clean install of CFMX - no previous versions had been 
installed.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CF Studio RDS datasource madness

[Stephen Hait]

> >   - Installed MS SQL Server on dev box.
> >   - Created a datasource in CF 5 admin.
> >   - Attempted to browse the datasource tables via the database tab
> >   in CF Studio.
> >
> >   The tables I see via the database tab in CF Studio are NOT the
> >   tables defined in my datasource... they look like system tables
> >   or something, not really 
> > sure.
> >   Here's
> >   a snapshot of what I see.
> >   http://66.51.163.40/cfstudio/
> >
> >   Anyone know what's causing this and how to fix it? TIA.

The tables you're seeing under the datasource you've created, 
CD_webstore, are actually tables in the master database. When 
you set up your datasource in CF Admin you need to specify the 
database in addition to the server. My guess is that the database 
has been left blank in which case the database defaults to 
whatever is set as the default database on SQL Server; probably 
this is the master database. Try entering CD_webstore as the 
database you want to connect to for this datasource name from 
withing CF Admin and you should be good to go.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: OT : Form Posts > Mac

[Stephen Hait]

> Recently, we have been having problems with some forms not posting
> correctly on a Macintosh (G4, IE 5.5), does anyone remember anything
> specific about Macs and form posting which needs to be addressed to
> get it to work correctly?

One diiference in the way form data is posted from a Mac is how 
line endings might be sent. On a PC line endings are usually 
sent as two characters: CR + LF (carriage return + line feed/new 
line), on a *NIX box lines usually end with just a new line 
character and on Macs lines traditionally have ended with just a 
carriage return character. This may be different on newer Macs 
whose operating systems are UNIX based but I'm not sure about 
that. 

This could have an impact if the code in the form's target is 
attempting to parse line endings for some reason.

However, since you don't describe exactly what problem you're 
encountering, this may or may not be relevant.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: OT : Form Posts > Mac

[Stephen Hait]

> Line endings in what? the actual template / code?

In this case, I'm referring to line endings contained in values 
related to submitted form elements. In a textarea form element, 
for instance, I could type the following:

Now is the time
for all good ...

When the form is submitted, the value for this form element 
would contain a line ending character(s) after the word 'time'.

When you say forms are not posting correctly, what exactly is 
the problem you're seeing?

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Flash question - newbie

[Stephen Hait]

I'm interested in learning about developing applications on CFMX 
that utilize Flash but I confess I'm confused as to what I would 
need to do this. There seem to be various products; Flash MX 
2004, Flash MX Pro 2004 and Studio MX 2004 with Flash Pro, 
etc. that might do this.

What's the minimum software requirement for developing Flash 
apps? What would be the benefits of alternatives to the minimum?

I own CF Studio 5 if that's a factor.

Sorry this sounds so lame but I've never created anything with 
Flash and am clueless.

Regards,
Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Flash question - newbie

[Stephen Hait]

How does Flash Remoting fit into the equation? Or does it?
Stephen

> The only 2 tools you need Flash MX 2004 Professional and Sapien's
> PrimalScript www.sapien.com.

> >
> > What's the minimum software requirement for developing Flash
> > apps? What would be the benefits of alternatives to the minimum?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Flash question - newbie

[Stephen Hait]

Thanks to all for your input.
Stephen

> At a minimum, Flash Pro with or without the studio (not sure if you
> need that extra stuff) and the free developer version of CFMX (which
> comes with Flash Remoting).
> 
> You could get away with the standard version of Flash but the
> additional components and integrated AS editor in Pro make it worth
> it.
> 
> chris
> 
> ____
> From: Stephen Hait [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 05, 2004 11:03 AM
> To: CF-Talk
> Subject: Flash question - newbie
> 
> I'm interested in learning about developing applications on CFMX
> that utilize Flash but I confess I'm confused as to what I would
> need to do this. There seem to be various products; Flash MX 2004,
> Flash MX Pro 2004 and Studio MX 2004 with Flash Pro, etc. that might
> do this.
> 
> What's the minimum software requirement for developing Flash 
> apps? What would be the benefits of alternatives to the minimum?
> 
> I own CF Studio 5 if that's a factor.
> 
> Sorry this sounds so lame but I've never created anything with Flash
> and am clueless.
> 
> Regards,
> Stephen
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Mind Mapping Programs

[Stephen Hait]

> I am looking into mind mapping software once again. A couple years
> ago I used Visual Mind and Ynguis a little bit, but want to find one
> and use it regularly as part of my planning processes. The ones I
> know of are listed below. Anybody have any experience using any of
> these or know of other ones I have not listed here?
> 
> Visual Mind
> MindManager X5 
> FreeMind
> MindGenius
> MindMapper

I've used MindManager from MindJet.com for quite awhile and like 
it pretty well. Has collaboration features, generates various HTML 
based representations that are fairly clean, supports hyperlinks, 
etc.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: SQL Help (updated)

[Stephen Hait]

> Had some incorrect info in there Carry on  :-)
> 
> Given the following journals with related documents.
> 
> Journal A
> 
> document1a - Jan 1, 2004
> document2a - Jan 2, 2003
> document3a - Dec 3, 2002
> 
> Journal B
> 
> document1b - Jan 3, 2001
> document2b - Jan 4, 2000
> document3b - Dec 2, 1999
> 
> Journal C
> 
> document1c - Dec 3, 2002
> document2c - Jan 9, 2003
> document3c - Jan 9, 2004
> 
> I would like to output to be like this
> 
> Journal C - Jan 9, 2004
> Journal A - Jan 1, 2004
> Journal B - Jan 3, 2001
> 
> Anyone want to take a stab at it?
Try this:
SELECT j.title, MAX(d.createdate) AS maxdocdate
FROM journal j JOIN document d ON j.journalid = d.journalid
GROUP BY j.title
ORDER BY maxdocdate DESC

You can format your date output however you'd like.

HTH,
Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Free Mail Clients

[Stephen Hait]

> BS> Anyone know of any good free email clients?

Pegasus Mail is free and works well if you run Windows.
http://www.pmail.com/

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: SQL: is there such a thing as NOT DISTINCT?

[Stephen Hait]

One way to isolate these "not distinct" rows would be something 
like this:
SELECT myColumn, count(myColumn)
FROM myTable
WHERE count(myColumn) > 1

This would give you only return rows where where there was more 
than one instance.

HTH,
Stephen


> I want to output all records in a table where a certain field is
> duplicated at least once. My first instinct is to filter in the SQL
> - but how?! I'm using Access 2000, and the field in question is
> VARCHAR.
> 
> DISTINCT doesn't *seem* to support being negated with NOT, and
> anyway, isn't it only meant for numeric fields?
> 
> Will I have to run some complex CF code to rebuild the query once
> it's returned?
> 
> Confused! Any help welcomed...
> 
> - Gyrus
> 
> 
> - [EMAIL PROTECTED]
> work: http://www.tengai.co.uk
> play: http://www.norlonto.net
> - PGP key available
> 
> 
> 
__
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

Session timeout and inactivity time

[Stephen Hait]

If cfapplication specifies a sessiontimeout of 10 minutes, will any  
session variables be destroyed after 10 minutes or only after 10 
minutes of inactivity?

TIA,
Stephen
__
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: Session timeout and inactivity time

[Stephen Hait]

Thanks for the quick response.

Stephen

> > If cfapplication specifies a sessiontimeout of 10 minutes, 
> > will any session variables be destroyed after 10 minutes 
> > or only after 10 minutes of inactivity?
> 
> After ten minutes of inactivity.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444


__
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

Impending session timeout warning methods?

[Stephen Hait]

Does anyone attempt to warn a user that their session will 
shortly expire? Could javascript with a timer allow popping up a 
window, say, when the session will expire in 2 minutes? Are 
there any better approaches?

TIA,
Stephen

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

RE: OT SQL SERVER Backup

[Stephen Hait]

Dave Watts wrote: 
> There are a couple of options that might work for you. If this is a
> one-time thing, and you can stop the source database server, you can
> simply copy the database and log files to the new server, and use
> sp_attach_db to attach each to the new server. 

Another alternative if you don't need to move the log files is to 
look into the command (see Books Online for syntax):
sp_attach_single_file_db

This allows you to attach just using the .MDF file.

Stephen

__
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: CFTree and IE6 - broken - an update

[Stephen Hait]

I'm not sure if this will help but I've been dealing with a similar 
issue recently relating to CFGRID which also relies on a java 
applet. The problem we were having was not so much browser 
version related as it was JDE version related (java runtime 
environment). The JDE version that seems to work ok with 
CFGRID is 1.3.0* and possibly 1.3.1*. 

Later versions such as 1.4* no longer allow passing certain types 
of data in ways the earlier versions did which "breaks" these 
applets' functionality. Since your application sounds like it's only 
being used by a controlled number of users you might try the 
following (this assumes you are using Windows as your OS):

On each computer that needs to access these apps, 
Rename the folder that contains java version 1.4 if you have it. 
This ought to be in c:\program files\java.
Rename the folders that contain any earlier versions of java. 
These ought to be in c:\program files\javasoft\JRE.

Then point your IE6 to a page with your tree control. It should 
sense that you don't have a JRE installed and also should then 
automatically download and install JRE 1.3.0_01. In our case, 
the CFGRID started working again.

I hope this helps. I think it sucks that MM has not addressed this 
other than to suggest this type of work around.

You can find numerous older versions of the JRE at 
http://java.sun.com/products/archive/

There is also quite a lot of discussion about this issue on the 
online forums for Cold Fusion at 
http://webforums.macromedia.com/coldfusion/

Regards,
Stephen

> The problem is that CFTREE (and I assume CFGRID) don't work with IE6
> or NN6.2 browsers.  They'll display the tree but not pass the node
> values to the form.  So CFTREE applications appear to work at first
> sight, but when you click "submit" on the form they're passing
> values to, you get an error. This is apparently related to the
> versions of the java plugins and the version used by CF5.  (I have
> no idea if the problem is also in CFMX.  I don't use it yet.)

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

Re: CFGrid issue

[Stephen Hait]

This might help:
For those suffering problems with IE6 (and other browsers)
especially using CFTREE, there is a new tech note just published
describing the problem and available workarounds / fixes.

ColdFusion Server 5 : Hot Fix for Applets When Using Java Plug-
in Versions Greater Than 1.3.1_01a

http://www.macromedia.com/v1/Handlers/index.cfm?ID=23150&Method=Full

Stephen
> I have a cfgrid with SelectMode="Edit" and when I submit it the
> action page does not seem have the 3 arrays that its supposed to
> have.
> 
> One of the arrays are "form.gridname.rowstatus" I test for it and it
> is not defined.
> 
> I recently upgraded to CF5, this code used to work in CF4.5.
> 
> Anyone know why im not getting the arrays like im supposed to?
> 
> A bit of test code is below
> 
> Thanks,
> Jeff
> 
>  code
> -
> 
> 
>  
>   Form.Products.RowStatus.Action is defined
>  
>   Form.Products.RowStatus.Action is NOT defined
>  
> 
> 
> 
>   width="620" height="226" colheaderfontsize="15"
> rowheaderfontsize="15" >
>width="120">
>   
>headeralign="CENTER" dataalign="CENTER" width="50">
>dataalign="CENTER" width="60">
>headeralign="CENTER" dataalign="CENTER" width="55">
>   
>   
> 
>
>   
> 
>  
>  
>  
> 
> 
>  code
> -
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Flowchart program

[Stephen Hait]

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 28 June 2002 9:13 AM
> To: CF-Talk
> Subject: OT: Flowchart program
> 
> 
> Recently I have found myself wanting to use some kind of flowchart
> program to visualize my application logic, but I haven't been able
> to find any decent lightweight flowchart software anywhere. I know I
> could use Visio, but I'd like stay away from it if there is an
> alternative.

I enjoy using Paraben's Flow Charter - http://www.paraben.com

Stephen
__
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: Raiser's Edge

[Stephen Hait]

I've got a client using RaisersEdge. I believe you can use 
BlackBaud's RE:Open product to access the data via ODBC but 
that it cost $5K.There is also a newer product called RE:API 
which only works with version 7 of Raisers Edge (not v.6 or 
earlier) which is priced based on a percentage of your purchase 
price of the other software but the minimum cost is $10K. 

This pricing seems a bit absurd since these products really do 
nothing more than give you access to your own data that you've 
entered and should own anyway but if you really need to connect 
to your data outside RaisersEdge, those seem to be the options.

HTH,
Stephen

> Has anyone ever connected CF to or even heard of Raiser's Edge, a
> database application geared toward non-profit fundraising? It is
> made by Blackbaud (http://www.blackbaud.com). The white paper on the
> application states that it is ODBC compliant and can come with SQL
> Anywhere, Oracle, or SQL Server.
> 
> If anyone has any experience, please contact me off-list. Thanks.
> 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Simon ParkComputer Systems Management, Inc.
> [EMAIL PROTECTED]205 South Whiting Street
> Ph: 703-823-4300 x119 Suite 201
> fax: 703-823-4301 Alexandria, VA  22304
>  http://www.csmi.com  
> 
> -- Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
> Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


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

Re: Managing Extremely Large Text files

[Stephen Hait]

Programmer's File Editor - PFE - can do this, I think.

http://www.lancs.ac.uk/people/cpaap/pfe/

Stephen


> I need help.
> 
> We are trying to view a 2+Gig text file to work through some of the
> text structure.  Any recommendations for a good editor that will
> handle files of this size?  We don't necessarily need to open the
> file all at once, even if we could scroll and view only certain
> sections of the file.  We are working on parsing routines, and need
> to verify the file structure throughout.
> 
> Thanks, Kelly Britt
> 
> 
> 
> 
> 
> 
>  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]

Conference materials available?

[Stephen Hait]

I had heard that materials presented at the DC conference such 
as code examples, slides, etc. would be made available in some 
form after the conference concluded. Does anyone know anything 
about this or where these materials might be obtained?

TIA,
Stephen


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: Anyone know Perl AND CF?

[Stephen Hait]

I might be able to help. If you provide the perl code (it might be 
helpful to include more than the single line in order to better 
understand the context) and, if you can, your understanding of 
what you are trying to do I would be glad to see if I can help.

Regards,
Stephen


> I need to find someone who knows perl and CF who would be willing to
> tell me how to write one line of Perl code to Cold Fusion.. It uses
> the "sed" statement..
> 
> Can anyone help.. please?
> 
> Thanks,
> Tony Hicks
> --
> Search the Holy Bible: http://www.bibleclicks.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: Internet Faxing Service

[Stephen Hait]

I've used eFax since Feb, 1999. It has worked well for me.

Stephen

> Hey Gang,
> 
> Is anyone here using an internet faxing service? I've looked at eFax
> and EasyLink, but I would like to get some recommendations if there
> are any.
> 
> Thanks,
> Duane
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL quicky

[Stephen Hait]

This is not exactly within a cf sql statement, but...

If you can be sure that your phone numbers are 10 digit strings 
you can format your output like this:



tel=(#left(tel,3)#) #mid(tel,4,3)#-#right(tel,4)#

The output would look like this:
tel=(800) 555-1212 

> How do I format a phone number (###) ###- within my cf sql
> statement? My backend is sql 2000. Thanks in advance.

~~
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: SQL quicky

[Stephen Hait]

Sorry, I don't understand what you're trying to accomplish here. 
Are you trying to output a value obtained from a query to a web 
page or add formatted data to a database table or something 
else?

> That's what I had originally. It works fine for my forms that pull
> up individual records. However, upon doing the bulk records I needed
> to change how my queries sat. All the related queries are a  QUERY> within a query.(  QUERY2> ) And for some reason the
> formatting of telephone now will not  I'm not sure why,
> so I thought I'd try to format it within the sql statement instead.
> 
> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 2:14 PM
> To: CF-Talk
> Subject: RE: SQL quicky
> 
> 
> This is not exactly within a cf sql statement, but...
> 
> If you can be sure that your phone numbers are 10 digit strings you
> can format your output like this:
> 
> 
> 
> tel=(#left(tel,3)#)
> #mid(tel,4,3)#-#right(tel,4)#
> 
> The output would look like this:
> tel=(800) 555-1212 
> 
> > How do I format a phone number (###) ###- within my cf sql
> > statement? My backend is sql 2000. Thanks in advance.
> 
> 
> 
~~
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: SQL quicky

[Stephen Hait]

The following gives the desired output for me when TELEPHONE 
is defined as char(10) in the database. Are you sure you're 
retrieving TELEPHONE as character data and not numeric? Are 
you able to output TELEPHONE without any formatting? Are you 
able to add 1 to TELEPHONE? If yes, you have a numeric value 
and would want to convert to string before formatting. HTH.


select * from schools



select * from schoolinfo




Untitled



school=#schname#

  (#left(getschoolinfo.telephone,3)#) 
#mid(getschoolinfo.telephone,4,3)#-
#right(getschoolinfo.telephone,4)#





> Yes I am trying to format a phone number (it's kept in the database
> as 1234567890) for an output form. The problem is that the usual
> formatting ()wo
> n't work for this output so I'm trying to move the formatting to
> inside the sql query. 
> 
> This formats fine: Gives the result: (123)456-7890
> 
> #TELEPHONE#
> 
> 
> BUT I need it to loop through a 2ndary query and this does not work:
> Gives result 1234567890.0   QUERY="2ndary"> #TELEPHONE#  
> 

~~
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: Macromedia/Allaire Knowledge Base

[Stephen Hait]

You might want to subscribe to the relatively new usenet 
newsgroup: alt.comp.lang.coldfusion
This is also searchable from Google Groups and may become 
more valuable as content accrues.

Stephen


>  I'm am very frustrated with the "Knowledge Base" at
>  Macromedia/Allaire. If it wasn't for posting a problem here or
>  doing a search through the CF
> Talk archives, I would have

~~
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: Why can't I buy JUST CFStudio 5?

[Stephen Hait]

According to Macromedia's website they are offering an 
UPGRADE to CF Studio 5 for $169 if you currently own 4.X. Only 
a downloadable version is currently available.

Stephen

> Why is it that Macromedia insists on bundling CFStudio5 and UltraDev
> 4 together? Why can't I buy just CFStudio5? I can get JRun Studio, I

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

Studio 5 Upgrade Promotion Code?

[Stephen Hait]

Was there any Promotion Code provided at the conference that 
would be applicable for a discount on a ColdFusion 5 Ultradev 4 
Studio Upgrade? I seem to remember seeing a reference to this 
but don't have that info now.

Stephen

~~
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: cf excel formatting problem

[Stephen Hait]

FWIW, we create Excel spreadsheets by sending table data and 
it works fine in NS4.7, too. The main difference is that in IE, 
Excel opens in the browser whereas in NS the user is prompted 
to either save or view it. If they choose to view it, a new instance 
of Excel is opened and the spreadsheet is displayed there.

Regards,
Stephen


> Are you on an IE-only platform?
> 
> If yes, you can try try sending an HTML table to Excel
> instead of a .csv. Excel will read in an HTML table
> and preserve formatting information so you can get
> really fancy if you want.
> 

~~
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: Entire Dynamic sites in Flash

[Stephen Hait]

Gee, all these years - shoulda guessed :-)

> > Well, my nickname isn't "minimalist" for no reason at all. :)
> 

~~
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: JavaScript book recommendation

[Stephen Hait]

O'Reilly's site says 4th edition will be published 11/2001. 
Amazon lists 12/15/2001.

Stephen

> > The JavaScript book I recommend most often is the O'Reilly 
> > one, "JavaScript:
> > The Definitive Guide". It really explains JavaScript in a 
> > coherent, organic
> > way - as a language, not just a bunch of tricks you can do.
> > 
> 
> You know offhand if it's being updated soon? I believe the last
> version was the 3rd edition, and that came out in 98, right? (Sure,
> I know most if it still applies, but it's almost 2002. ;)
> 
> 
> === 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 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: SQL Query Problem

[Stephen Hait]

Try adding:
WHERE BrandID IS NOT NULL

This will eliminate any rows where the value is null. It will have 
impact on the calculation of AVG, of course.

If you have multiple BrandID columns, just add "AND BrandID2 IS 
NOT NULL", etc.

Stephen


> I am having a problem trying to think of the correct SQL statement I
> need. It's late in the day and my brain is completely fried.
> 
> What I am tring to do is get the average price of one column based a
> an ID that is passed to the SQL query. For example if a BrandID of 1
> is passed into the query it should output an average price of $4.00
> 
> The problem arises when one of the BrandID(BNID) columns doesn't
> contain any of the #ID# numbers in it. The value that it returns is
> NULL which causes the rest of the SQL statement to return NULL as a
> result even if the other columns contain at least one #ID# in the
> BNID column. For example passing a BrandID of 24 will return a
> resultset of NULL because it is not in the second or third BRANDID
> column. 
> 
> Hopefully I made some sense. Below is the partial table design and
> SQL statements I am using in my script. Any help would be great.
> 
> 
> TABLE DESIGN
> BNID1_3 Price1_3 BNID2_3 Price2_3 BNID3_3 Price3_3
> 1   $2.0010  $0.001   $5.00
> 24  $0.001   $5.0023  $0.00
> 
> SQL STATEMENT
> select
> (select avg(Price1_3) from temp1 where BNID1_3=#ID#)+
> (select avg(Price2_3) from temp1 where BNID2_3=#ID#)+
> (select avg(Price3_3) from temp1 where BNID3_3=#ID#) AS AVGPRICE
> 
> 
> 
> 
~~
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: CF Studio memory leaks.

[Stephen Hait]

Crashes on me (5.0) almost as bad as with 4.5. The only 
program I run that causes a need to reboot my system at least a 
couple of times a day. Win98 so maybe that's the problem but 
then why do other resource intensive progs (photoshop6, 
sqlserver7, etc.) not have these problems? When it's convenient 
I've taken to using EditPad for most editing - it has color coding 
capabilities for CF files but not all the good stuff that Studio offers.

Stephen 

> I'm with you William.
> Aside from the part of CF5S not ever crashing.
> 
> I have crashed CF5S ten or so times since I bought it.
> 
> 
> Joseph DeVore
> VeloxWeb Technologies
> 
> 
> -Original Message-
> From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 4:32 PM
> To: CF-Talk
> Subject: Re: CF Studio memory leaks.
> 
> 
> Then you're just lucky ;)
> 
> Its died on me STUDIO 3, 4, 4.5 .1 2. 3. 4.4 .4.5 all the way upto 5
> :) still leaks
> 
> leaked on 98
> on 98SE
> on ME
> on 2000
> on NT
> on XP :)
> 
> It never crashes on me anymore with studio 5 but it F's up at
> the worst times :) when it wants to be restarted lol
> 
> but never dies on me anymore
> 
> 
> Bill Wheatley
> Director of Development
> Certified Advanced ColdFusion 5 Developer
> AEPS INC
> Allaire ColdFusion Consulting Partner
> www.aeps.com
> www.aeps2000.com
> 954-472-6684 X303
> ICQ: 417645
> - Original Message -
> From: "Kevin Langevin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 21, 2001 6:37 PM
> Subject: RE: CF Studio memory leaks.
> 
> 
> > Strange...I use Studio via RDS with a server I have colocated all
> > the
> time,
> > and Studio 5 hasn't ever crashed on me.  Not once since I started
> > using
> it.
> >
> > I'm running Win2K Server on my dev machine and Advanced server on
> > the
> remote
> > machine.
> >
> >
> > Kevin Langevin
> > Web Guy In Charge
> > UsWebGuys
> > 954-327-5780
> >
> >
> > -Original Message-
> > From: Maureen [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 21, 2001 6:33 PM
> > To: CF-Talk
> > Subject: RE: CF Studio memory leaks.
> >
> >
> > At 09:26 AM 9/28/01 Michael Brunt wrote:
> > >CF Studio 4.5 runs very well on Win 2k and I've used it on 98,
> > >NT, ME.  I certainly don't see it as any more "buggy-ass" than
> > >any other
> html-CF-style
> > >sheet editor out there.  In fact Homesite-CFStudio are without
> > >doubt the best IDE tools around, they at least do not insert
> > >extraneous html tags
> all
> > >over the place and once you get into VTML the options are
> > >amazing. As I
> > said
> > >CF 4.5-Win 2k is very stable in my experience.
> >
> > I think if you just use Studio, it's ok.  But if you use the RDS
> > feature
> of
> > Studio, or the debugger, or the validator, it leaks like a sieve,
> > on all versions of the OS.
> >
> > I've been begging Allaire for a fix for this since 4.5 first hit,
> > without luck.  So I reverted to Studio 4.0.  It still crashes, but
> > not as often, and usually only if I have a Microsoft application
> > open as well.
> >
> > This is my absolute biggest gripe with any Allaire product.
> >
> >
> >
> 
> 
~~
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: CF Studio memory leaks.

[Stephen Hait]

Dave,
You're probably right that there's some other problem with my 
system that's causing me these problems. As soon as it's 
practical I will go to a clean install of Win2K and I imagine these 
problems will be a thing of the past. The fact is, though, that as 
screwed up as my system probably is at this point (I've been 
adding, updating and removing software for over a year now) 
Studio4, 4.5, 5.0 is the only program that gives me this much 
grief. May just be bad karma :-). I sure do miss Nick Bradbury 
(sigh).

Stephen


> I have to believe that there is some other problem with your system.
>  I've run Studio 3.1, 4.0, 4.5 and now 5 and the only one I ever had
> any trouble with was 4.0 (threw error on closing).  I ran 4.5 on Win
> 98 forever a year and never had a problem with it.
> 
> Dave
> 
> - Original Message -
> From: "Stephen Hait" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 21, 2001 9:00 PM
> Subject: RE: CF Studio memory leaks.
> 
> 
> > Crashes on me (5.0) almost as bad as with 4.5. The only
> > program I run that causes a need to reboot my system at least a
> > couple of times a day. Win98 so maybe that's the problem but then
> > why do other resource intensive progs (photoshop6, sqlserver7,
> > etc.) not have these problems? When it's convenient I've taken to
> > using EditPad for most editing - it has color coding capabilities
> > for CF files but not all the good stuff that Studio offers.
> >
> > Stephen
> >
> > > I'm with you William.
> > > Aside from the part of CF5S not ever crashing.
> > >
> > > I have crashed CF5S ten or so times since I bought it.
> > >
> > >
> > > Joseph DeVore
> > > VeloxWeb Technologies
> > >
> > >
> > > -Original Message-
> > > From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, November 21, 2001 4:32 PM
> > > To: CF-Talk
> > > Subject: Re: CF Studio memory leaks.
> > >
> > >
> > > Then you're just lucky ;)
> > >
> > > Its died on me STUDIO 3, 4, 4.5 .1 2. 3. 4.4 .4.5 all the way
> > > upto 5 :) still leaks
> > >
> > > leaked on 98
> > > on 98SE
> > > on ME
> > > on 2000
> > > on NT
> > > on XP :)
> > >
> > > It never crashes on me anymore with studio 5 but it F's up
> > > at the worst times :) when it wants to be restarted lol
> > >
> > > but never dies on me anymore
> > >
> > >
> > > Bill Wheatley
> > > Director of Development
> > > Certified Advanced ColdFusion 5 Developer
> > > AEPS INC
> > > Allaire ColdFusion Consulting Partner
> > > www.aeps.com
> > > www.aeps2000.com
> > > 954-472-6684 X303
> > > ICQ: 417645
> > > - Original Message -
> > > From: "Kevin Langevin" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, November 21, 2001 6:37 PM
> > > Subject: RE: CF Studio memory leaks.
> > >
> > >
> > > > Strange...I use Studio via RDS with a server I have colocated
> > > > all the
> > > time,
> > > > and Studio 5 hasn't ever crashed on me.  Not once since I
> > > > started using
> > > it.
> > > >
> > > > I'm running Win2K Server on my dev machine and Advanced server
> > > > on the
> > > remote
> > > > machine.
> > > >
> > > >
> > > > Kevin Langevin
> > > > Web Guy In Charge
> > > > UsWebGuys
> > > > 954-327-5780
> > > >
> > > >
> > > > -Original Message-
> > > > From: Maureen [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, November 21, 2001 6:33 PM
> > > > To: CF-Talk
> > > > Subject: RE: CF Studio memory leaks.
> > > >
> > > >
> > > > At 09:26 AM 9/28/01 Michael Brunt wrote:
> > > > >CF Studio 4.5 runs very well on Win 2k and I've used it on
> > > > >98, NT, ME.  I certainly don't see it as any more "buggy-ass"
> > > > >than any other
> > > html-CF-style
> > > > >sheet editor out there.  In fact Homesite-CFStudio are
> > > > >without doubt the best IDE tools around, they at least do not
> > > > >insert extraneous html tags
> > > all
> > > > >over the place and once you get into VTML the options are
> > > > >amazing. As I
> > > > said
> > > > >CF 4.5-Win 2k is very stable in my experience.
> > > >
> > > > I think if you just use Studio, it's ok.  But if you use the
> > > > RDS feature
> > > of
> > > > Studio, or the debugger, or the validator, it leaks like a
> > > > sieve, on all versions of the OS.
> > > >
> > > > I've been begging Allaire for a fix for this since 4.5 first
> > > > hit, without luck.  So I reverted to Studio 4.0.  It still
> > > > crashes, but not as often, and usually only if I have a
> > > > Microsoft application open as well.
> > > >
> > > > This is my absolute biggest gripe with any Allaire product.
> > > >
> > > >
> > > >
> > >
> > >
> > 
> 
~~
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: What the best database structure to do this?

[Stephen Hait]

One way to approach this is to use intermediate tables that 
contain groups of valid values. 

As a simple example, let's take sizes and assume that one 
product comes in S,M,L and another product comes in S,M,L,XL. 

You could create a size table containing a row for each possible 
size: S,M,L,XL, etc. with a sizeID for each row (sizeID for S=1, 
sizeID for M=2, etc.) and a groups table with a groupsID 
containing a row for each possible sizegroup (groupID for 
"SmlMedLg" = 1, groupID for "SmlMedLgXL" = 2, etc.). You 
would then also create an intermediate sizegroups table 
containing a row for a sizegroupID and a sizeID to link various 
sizes to different groups. In this simple case you'd have:
Groups table:
GroupsID=1, GroupDescription="SmlMedLg"
GroupsID=2, GroupsDescription="SmlMedLgXL"

Size table:
SizeID=1, SizeDescription="SM"
SizeID=2, SizeDescription="Med"
SizeID=3, SizeDescription="Lg"
SizeID=4, SizeDescription="XL"

SizeGroups table:
GroupsID=1, SizeID=1
GroupsID=1, SizeID=2
GroupsID=1, SizeID=3

GroupsID=2, SizeID=1
GroousID=2, SizeID=2
GroupsID=2, SizeID=3
GroupsID=2, SizeID=4

In your products table, you'd have a column for each product 
referencing which Group to use for valid sizes. When displaying 
available sizes for a product, you'd get the GroupsID for the 
product and link to the Sizes table through the SizeGroups table 
to get the variable number of valid sizes for any product.

Obviously, this example is very basic but the concept provides 
one way of approaching parts of your problem. It's also easy to 
add new sizes and size groups (or color or whatever).

HTH,
Stephen



> I've been wrestling with this for the last half hour and I can not
> decide the best way to structure the database for a function I a
> programming related to a shopping cart. It get's kind of crazy...
> 
> Each item can have a variable number of sizes.
> Each size can have a variable upcharge attached to it.
> Each item can have a variables number of price levels for different
> types of customers with variable quantity breaks per price level.
> All of the above is done. I am now trying to add in the sizes so
> that I can set variable size/quantity discounts at different price
> levels.
> 
> If I totally normalize the new size table, given 500 products, 4
> quantity breaks, 4 sizes and 2 pricing levels, I end up with 16000
> rows, albeit in a very nicely indexable table. That's an extreme
> example for the probable use of the software, but I want to make
> sure it doesn't break under load either. I know 16000 rows is not a
> big deal for SQL Server, but since the data in the table will be
> used for displaying the item, I can see it getting hit pretty hard.
> 
> Should I be worried about this table, or does anyone have any tips?
> 
> RDBMS == SQL Server
> 
> jon
> 
~~
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: Anti Virus Recommendations

[Stephen Hait]

My favorite is the "original" AVP now available from Kaspersky 
Labs:
http://www.kaspersky.com/



> Hi All -
> 
> I have heard horror stories about certain anti virus
> programs not playing will with ColdFusion. I am asking for
> recommendations for an anti virus program to use my
> computer.
> 
> I have Win 98 SE, PWS, Studio 4.5 and CF Server 4.5.
> --
> David Andrew
> [EMAIL PROTECTED]
> 
> 
> 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


~~
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: can't download 4.5.2 eval either

[Stephen Hait]

This may not be a bad thing. I installed Studio 4.5.2 and besides 
the already mentioned blank help files problem, I now can't 
access databases or browse locally from Studio without errors. 
Hopefully they will get this together before they put the 4.5.2 
upgrade back up.

Regards,
Stephen


> even if you try and download 4.5.2 to eval at:
> 
> http://allaire11.allaire.com/download/showfamily.cfm?DownloadType=Up
> date&FamilyID=1953B558-7AC0-11D4-849E0010B547F60A
> 
> it's blank. 
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: Platform/server info

[Stephen Hait]

If you're running a version of Windows, you can also use the free 
What's Running program at:
 http://www.woodstone.nu/whats

Stephen


> > I lost the link; perhaps someone can remind me:
> > Where can I enter a domain name and see what platform it uses and
> > what web server it is running?


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

Re: anyone see what is causing a Syntax Error is this update statement??

[Stephen Hait]

This might be because desc is a reserved word in MS SQL. 
Check the docs for the platform you're on and see if this might be 
the problem.

Regards,
Stephen


HTH,
Stephen

> Hello cf-talk,
> 
> This simple update is generating a syntax error i can't seem to
> resolve. What am I missing??
> 
> 
> 
> 
> UPDATE #form.table#
> SET name='#name#',
> desc='#desc#',
> price='#price#'
> WHERE id=#form.id#  
> 
> 
> 
> 
> 
> Best regards,
>  Jeff Fongemie  mailto:[EMAIL PROTECTED]
>  Internet Guns For Hire (603) 356-0768
> 
> 
> 
>
~~
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 problem

[Stephen Hait]

Try outputing the number already formatted:
#NumberFormat(YourNumberVariable,'_99,999,999')#

HTH,
Stephen


> I have a page where I allow users to download an excel file of the
> query they have done.  I use the  TYPE="application/vnd.ms-excel"> and it works nicely except for one
> field.  It's a 12 digit number that shows in the excel file in
> exponential notation (i.e 446547798380 is 4.46548E+11).  It doesn't
> matter if it's text instead of a number.  Any suggestions on how to
> fix this?
> 
> ---
> Sandi Benditt
> Sr. Programmer Analyst - Advanced Technologies
> DecisionOne
> 
> 
>
~~
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: Broswer Back clears Form

[Stephen Hait]

Just a guess but are you using secure pages for these forms? If 
so, IE by design sometimes does not cache the form contents 
when the user clicks the back button. Supposedly this is for 
security purposes.

HTH,
Stephen


> In a form I am using some client side validation as well as server
> side, when the user submits a populated form and the server side
> validation finds an error (in this case using the CF
> formname_required method), then user then clicks the back button the
> form is cleared of the user input.  Its only happening in a specific
> template.  Any ideas why this occurs or what to look for?
> 
> Thanks,Adrian
> 
> 
>
~~
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

dupes

[Stephen Hait]

Why does this list constantly have duplicates posted to its 
members? Any thoughts?

Regards,
Stephen


~~
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: Displaying the IP of a server

[Stephen Hait]

CGI.HTTP_HOST

HTH,
Stephen


~~
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: Displaying the IP of a server

[Stephen Hait]

How reliable would this scenario be, then:

One application with one application.cfm. Three locations for the 
application: local development machine, public production server, 
private production server. Only some resources are available on 
each platform, need a way to determine which platform app is 
running on to disable attempting to access unavailable resources.

For example: 
Production machine - all resources available - NT authentication, 
access to resources off the box.
Private machine - NT authentication available, no access to 
resources off the box.
Local machine - W98, PWS - no NT authentication available

How to identify which location the app is running on within the 
same application.cfm and conditionally process accordingly?

Currently using check on CGI.HTTP_HOST for either 
localhost/127.0.0.1 or www.publicserver.com or IP address of 
private server. Is this unreliable for this? Is there a better way? 
This appears to be working but this thread has made me wonder.

Stephen


To this:
> > what about CGI.HTTP_HOST or CGI.SERVER_NAME?
Dave Watts replied:
> These are only as reliable as the information they're fed by the
> browser. For example, if I wanted, from my browser, to put a
> specific value in those variables, I can do that. I need only edit
> my hosts file to give whatever name I want to the appropriate IP
> address. The only way to know that the name used by the browser is
> the appropriate name is if you're using name-based virtual servers,
> which will only accept requests that provide the appropriate name.
> 
> Also, in a clustered environment, these variables may provide the
> external name used to reach the cluster, rather than a name
> corresponding to a specific server.
> 
> Dave Watts, CTO, Fig Leaf Software


~~
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: Displaying the IP of a server

[Stephen Hait]

> As an alternative, what I generally recommend for machine-specific
> application settings is that you store them on the machine itself,
> and have your application read those values from wherever you've
> stored them. You could store them in a text file, or within the
> registry, for example. If you store them in a file, make sure that
> file doesn't get overwritten when you move a new build of your
> application from development to production.
> 
> Dave Watts, CTO, Fig Leaf Software

Thanks. That's a good suggestion. It still requires maintaining 3 
separate instances of the same info in different locations but it 
would be less volatile data and would be easier to maintain than 
trying to juggle separate application.cfm files.

Stephen


~~
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: Mouse wheel in CF 4.52

[Stephen Hait]

FWIW - I had the same problem (among others) w/4.52. Never 
could get any of them resolved. Have gone back to an earlier 
version.

Stephen

> I recently formatted my computer and reinstalled CF 4.52.  I have
> now lost the functionality of the mouse wheel while in CF Studio,
> which was previously working.  I am pretty sure that it is not a
> problem with my mouse because the wheel is functioning in every
> other application.  Just wondering if anyone knows if this is a
> setting in CF Studio that can be turned on/off, or if there is
> something i can do to get my mouse wheel back into action?
> 
> Thanks,
> 
> Scott
> 
>
~~
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: Disappearing Variables on Mac IE?

[Stephen Hait]

I've just been wrestling with an issue involving problems with 
IE4.5 on Macs myself. In my case I was using javascript in 
combination with forms for minor error checking. It worked fine on 
every other platform/browser combo which presumably supported 
javascript we tried, including earlier NS versions on Mac but 
bombed with IE4.5/Mac. We eventually moved all the validation to 
a perl script on the server and that solved it but I never really 
determined the exact cause. If your problem is at all related it 
may have to do more with forms handling on IE4.5/Mac than on 
the javascript which is what I thought our  problem was. I will say, 
however, that the form elements all seem to get posted properly 
to the perl script.

FWIW, the javascript was looping through a few mandatory form 
elements to ensure they'd been entered but in IE4.5/Mac the 
form elements I was checking had been entered but were 
determined to be missing. It was like the browser lost track of the 
form elements. Also, if this helps, there were about 70+ form 
elements in total on the page but I was only checking the first 3 
or 4. Also, this was not CFM at all - simply HTML form submit to 
a perl cgi.

HTH,
Stephen


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

CF 5 Cfgraph question

[Stephen Hait]

Does CFGraph provide the ability to create drill-down Flash 
graphs similar to how PopChart does?

Regards,
Stephen



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

testing - is list working?

[Stephen Hait]

no mail from list in over a week - is it alive?




~~
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: Dead ?

[Stephen Hait]

Same duplicate problem here. Multiple copies of exactly the 
same message, headers and all. So far the largest number of 
dupes was 5 for one of Mike Dinowitz's posts.

Still much better than not getting messages .

Stephen


> some messages come as they should - some come with 3-5 copies
> (easily deleted) - and somewhere around noon most days, messages
> stop coming at all - only to dump into my email as a group several
> hours later hm



~~
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: last modified

[Stephen Hait]

Look into CFFILE. It returns the modified date among other 
things.

Stephen


> 
> >Is there any way to access the attributes of a file, such as when
> >it was last modified?
> 
> 
>
~~
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

Any CFGRAPH examples out there?

[Stephen Hait]

Particularly, examples employing drill-down capabilities 
and dynamic sizing of graphs similar to what Corda offers.

TIA,
Stephen



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

Debugging Fusebox apps

[Stephen Hait]

What are some of the tools or methods to use when trying to 
debug Fusebox apps?

Stephen



~~
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: OT: SQL Server 7, Windows 95 and Service Manager

[Stephen Hait]

On Win98, I have a shortcut in the startup folder:
:\MSSQL7\Binn\scm.exe -Action 1 -Silent 1

Stephen

> In Windows 95, how do you change the account the Service Manager
> uses to try and start SQL Server on boot up, bearing in mind there
> is no Services option (as is the case with NT)?
> 
> 
> 
> Thanks
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Macromedia ColdFusion Developer
> Fairbanks Environmental +44 (0)1695 51775
>
~~
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: Vote on ColdFusion Enhancements!

[Stephen Hait]

Have a look at CRiSP - www.crisp.com

A bit pricey, though (minimum $150 after 21 day free trial)

Stephen

> oh yeah brings back memories of "brief"
> 
> - Original Message -
> From: "Duane Boudreau" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, July 29, 2001 10:00 AM
> Subject: RE: Vote on ColdFusion Enhancements!
> 
> 
> > One of the things I'd love to see in Studio is ability to
> > select/highlight text both at the Row and the Column level. I use
> > Studio for everything, imcluding editing text files. When working
> > with character delimted text files is would be really nice to be
> > able to select enitre columns of text.
> >
> >
> >
> > > -Original Message-
> > > From: Terry Ford [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, July 27, 2001 2:13 PM
> > > To: CF-Talk
> > > Subject: Vote on ColdFusion Enhancements!
> > >
> > >
> > > Hi cf-talk,
> > >
> > > We're deep in the middle of the design and development for the
> > > next major release of ColdFusion and are looking for some good
> > > input on ColdFusion enhancements.  Below is a link to an
> > > enhancement-tracking application that we've put online
> > > temporarily. Inside you will find over 200 CF enhancement
> > > requests that we have received and logged over the past year
> > > that you may vote on or add to.
> > >
> > > You will need to create a simple account to vote. Note that this
> > > system will only be available publicly for two days as we need
> > > to put this application on a solid server before opening up
> > > permanently -- we'd just like some quick feedback now.
> > >
> > > http://syndication.allaire.com/vote/
> > >
> > > Your detailed input is important.  Please post comments in the
> > > app beside any features or enhancements that interest you.  Not
> > > only is your vote important, but also descriptions about how
> > > you'd use such a feature or a story about how you needed such a
> > > feature in the past.  Please be as verbose as possible when
> > > posting -- more info, the better!  Feel free to not only vote on
> > > items but to also add your own items.
> > >
> > > Standard disclaimer:
> > >
> > > Other variables go into the blender of feature definition.
> > > 100 votes for "I'd like CF to emulate the Vic-20" does not
> > > necessarily mean that this feature will make the cut.  This is
> > > simply one of a number of methods that we're using to help guide
> > > product development.
> > >
> > > Thanks,
> > > Terry
> > > ColdFusion Product Management
> > >
> > >
> > >
> >
>
~~
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: CFIF Confusion

[Stephen Hait]

You could check the value of the variable to see if it's really 'Yes' 
or not:

FIELD1='#FIELD1#'


Note single quotes surrounding variable output. Check to see if 
there might be trailing spaces - this might be the problem.

HTH, Stephen


> Hello!
> 
> I'm working with SQL Server 2000 and I have a query I'm confused
> about. There's a field (FIELD1) that's defined as a VARCHAR.  The
> field contains either "Yes" or "No".  I SELECT all records and then
> want to display somthing different if FIELD1 is a "Yes" or "No".
> 
>   The following structure works:
> 
> Bunch of code
> 
> 
> This structure does not work:
> 
> Bunch of code
> 
> 
> I've also notice that in SQL, if I do a:
> SELECT *
> FROM TableName
> WHERE (FIELD1 LIKE 'yes')
> it works, but
> SELECT *
> FROM TableName
> WHERE (Field1 IS 'yes')
> does not work...
> 
> ???
> Thx
> 
> 
>
~~
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: CF Studio Trick

[Stephen Hait]

Check out Code Templates - Options, Settings. Under Editor, 
click on Code Templates to see a list of default templates. On 
my systems, the following code is associated with "scriptj" and 
typing scriptj followed by alt+j pops this text into a document at 
the cursor. 





HTH, Stephen


> I was at the 2001 cf odyssey event this past weekend. When one
> speaker was showing us some javascript I thought he typed 'scriptj'
> in studio, and bang the entire script header/footer tag and more
> appeared. I just tried this at work and it didn't work. Am I doing
> something wrong?
> 
> Thanks
> Jan
> 
> 
> 
>
~~
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: OT: SirCam virus???

[Stephen Hait]

Actually, the SirCam virus sports its own SMTP application to 
send mail, target e-mail addresses may come from a variety of 
sources including browser cache. You don't have to be an 
Outlook user to spread this. To get infected you must "run" the 
attached file.

Stephen


> yeah the virus is spread by MS Outlook users... 
> 
> someone sends you mail... you click.. Outlook gets corrupted and
> starts emailing people in your contacts your random personal
> documents... Word files, excel, etc...
> 
> I have received about 100 messages in one email box alone :)
> 
> McAffee and everyone else has issued patches and virus updates for
> it... get some virus software running...
> 
> -paris
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> Date: Mon, 30 Jul 2001 13:12:24 EDT
> Subject: OT: SirCam virus???
> 
> > I've been getting multiple emails for the last couple of days from
> > gr and nl domains. All have a file attached with the same email
> > body. I also read about a new virus making it's rounds ... the
> > Sircam virus. Does anyone have any info on these emails or the
> > SirCam virus?
> > 
> > Email body:
> > <<
> > Hi! How are you?
> > 
> > I send you this file in order to have your advice
> > 
> > See you later. Thanks
> > >>
> > 
> > Thanks,
> > Bill
> > 
> > 
> >
>
~~
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

CodeCharge editor - anybody have experience with this?

[Stephen Hait]

Just wondering if anyone on this list has tried this editor and, if 
so, what your experiences have been with it.

http://www.codecharge.com/index2.html

Regards,
Stephen



~~
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: Nt authenicate with a twist

[Stephen Hait]

One way would be to rely on group memberships for these users 
if that's possible. You could then keep a database of what things 
members of various groups have access to and base it on their 
NT group memberships.

See www.intranetfoundation.com for tags that allow you to 
access this NT info based on authenticated_user.

Regards,
Stephen


> We want users to be able to authenicate through their current nt
> login.  But we also need to hook these users to a specific list. I
> currently have it in a sql database table- name/password/ids used to
> get specific list.  What is the best way to use this with nt?  I
> can't add the needed fields to nt and we don't want to have to keep
> another list of usersany ideas?
> 
>
~~
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

Stored procedures for queries

[Stephen Hait]

I've been wondering about using stored 
procedures in templates instead of 
embedding queries. Is there a good reason 
for this if the queries are only select 
statements?

Stephen
__
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: Stored procedures for queries

[Stephen Hait]

Jon, thanks for your response.
Stephen

> If you are concerned about performance, converting cfquery's to
> stored procedures is the best way to optimize an application. Even
> for selects.
> 
> jon
> 
> Stephen Hait wrote:
> 
> >I've been wondering about using stored 
> >procedures in templates instead of 
> >embedding queries. Is there a good reason 
> >for this if the queries are only select 
> >statements?
> >
> >Stephen
> >
> 
> 
> __ 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


__
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: CF / SQL 2K / CONNX

[Stephen Hait]

> Does anyone have any experience using SQL 2K and CONNX together and
> then using CF to output the data?

We are using CONNX to access DataFlex data with SQL7. We 
can also set up an ODBC connection to the CONNX-connected 
DataFlex data and access this via CF if needed. I don't know how 
this would differ with VMS data and I'm not sure I am answering 
your specific question.

Stephen

__
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: Weight Loss

[Stephen Hait]

Yes. It costs over $2,000. But if you need more graphing 
capability than comes currently with ColdFusion, it could be 
worth it.

Stephen


> Does this app cost money. I don't see on the website where you can
> buy it, just a free download. It looks nice, and would be cool to
> use, but I'll stick with cfgraph for now if it costs anything.
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 1:35 PM
> To: CF-Talk
> Subject: Re: Weight Loss 
> 
> 
> Although CFGRAPH is pretty cool and a welcome addition to
> ColdFusion, there
>  are still quite a few limitations to that tag. This is one of them.
> 
> What you are wanting to do is to have two valuecolumns on the same
> chart, a nd this is something that CFGRAPH does not do. What you can
> do is to create
>  two graphs, one showing weight loss and the other weight goal. You
>  would h
> ave all the people in the database lumped into one chart for each
> category.
>  The code example below gives you two charts, one on top of the
>  other. If y
> ou want to do some really cool things with charts and graphs, for
> now you w ill need to get a third party charting application. The
> one we use here at Baylor is PopChart by Corda Technologies
> (www.corda.com). It is really good
>  It is a JAVA application that runs on the web server (or any server
>  for t
> hat matter, you just have to point to it in your code). It works
> well with CFM, ASP, JSP and HTML.  It also comes with a cool builder
> tool that is als o a JAVA application. You feed in the necessary
> parameters and it creates t he necessary JavaScript for you.
> 
> Code example:
> 
> 
> 
>  Select *
> > WeightLoss
>  order By F_Name
>  
> 
> 
>  valuecolumn="Weight
> _Lost" itemcolumn="F_Name" showvaluelabel="Yes"
> valuelabelfont="Arial " valuelocation="ONBAR" scaleto="300"
> itemlabelfont="Arial" itemlabel orientation="HORIZONTAL"
> title="Weight Loss Progress Chart" titlefont ="Arial"
> fileformat="Flash" depth="5" colorlist="red,green,blue,yel
> low,orange">
>  
> 
>  
>valuecolumn="Weight_
> Goal" itemcolumn="F_Name" showvaluelabel="Yes"
> valuelabelfont="Arial"
>  valuelocation="ONBAR" scaleto="300" itemlabelfont="Arial"
>  itemlabelo
> rientation="HORIZONTAL" title="Weight Goal Progress Chart" titlefont
> ="Arial" fileformat="Flash" depth="5" colorlist="red,green,blue,
yel
> low,orange">
>  
> 
> Another thing that you can do is to output the information into a
> table abo ve the charts, and you can also make it a drill down
> chart, then you could pass in the User_ID parameter in the URL and
> create another chart for just the individual or a table with the
> necessary information.
> 
> 
> --- Original Message --
> From: "Ann Harrell" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date:  Thu, 7 Feb 2002 11:24:52 -0500
> 
> I'm in the thinking stage of a small project for a group of friends.
> I want
> 
> to keep it fairly simple. It would be in Access
> 
> Person1
> WeightLost (bar graph)
> WeightGoal
> 
> Person2
> WeightLost
> WeightGoal
> 
> and I would like to display this in cfgraph. Is this possible?
> 
> Ann Harrell, USA
> Phone: 219.342.0618
> 
> A society that will trade a little liberty for a little order will
> lose both, and deserve neither. --- Thomas Jefferson, in a letter to
> Madison
> 
> 
> 
> __ 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=coldfusiona
> 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

__
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: auth_user

[Stephen Hait]

Check out Intrafoundation's Intranet Hosting Toolkit (IHTK) at
http://www.intrafoundation.com/

This let's you see groups and group memberships for NT 
authenticated users. It might be helpful.

Regards,
Stephen

> i want only users that are apart of an Admin group that i created to
> be a ble to access a template i built.  i know that i can use
> AUTH_USER and sa y if u are this list of people...you can access the
> template.  but is there a way to say if you are apart of this GROUP
> u can access thi s template?  i hope i am being clear.  right not i
> declare a variable and set it to AU TH_USER.  but can i set this
> variable equal to the Admin group somehow? thanks for your help,
> bec.
> 
> 
> * 
> This e-mail, including any attachments, is intended for the 
> receipt and use by the intended addressee(s), and may contain 
> confidential and privileged information. If you are not an intended
> recipient of this e-mail, you are hereby notified that any
> unauthorized
> 
> __ 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

__
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: ColdFusion IDEs

[Stephen Hait]

EditPad Pro

> All,
> 
> I'm curious to know what IDEs other than Dreamweaver and
> HomeSite/ColdFusion Studio are people using, and what the stand out
> features of their favored IDE is.
> 
> Note: I'm really not interested in HomeSite(+ or not) or Dreamweaver
> info.
> 
> Thanks,
> Calvin Ward
> Jacksonville, FL ColdFusion User Group Manager
> http://www.jaxfusion.org/ 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: ColdFusion Graphing Capabilities

[Stephen Hait]

Corda PopChart
Stephen

> Does coldfusion allow you to do really indepth graphs that I would
> be able to do on MS Excel? If so, does any one know a good site that
> gives good examples of how to generate complicated graphs. If not,
> does anyone know of a good charting tool that integrates easily?
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CFID/CFTOKEN newbie question

[Stephen Hait]

> Bah - that's what I thought.  So, how do you determine if the user
> has cookies or not before you go through the trouble of adding them
> to the url?



	cookies not enabled code here


HTH,
Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]