RE: CFMAIL problems on 4.51 SP 2

[Trey Rouse]

Actually there was a bug with the mail spooler in 4.5, that I am told was 
fixed in SP2, that caused this behavior.

It would only happen when you had a single template that executed more than 
one cfmail in the same template, via a loop or just more than one instance 
of the tag.  Our experience with this bug was we could easily recreate it 
but it wasn't as consistent as you have described. It seemed to very on 
several factors... All based around the filesystem on the drive and the 
relative access times to the spool directory.

 From our own diagnosis, we found that the spooler appeared to be single 
threaded in its filesystem writes to the spool directory. CF would begin to 
write one file, then try to write another before it closed the first. We 
would usually see 0k spool files in the spooler.  Before SP1 the spooler 
would then lock when it encountered the 0k file thus requiring a restart of 
the service to resume mail operations.

Allaire never responded to us what the cause was, but 3 months into the 
call tag, they did admit they could finally recreate the problem and that 
it would be addressed in SP2.  I have no idea if it was, as we long since 
moved away from our CF spooler problems and use a different product to 
spool all of our webserver generated mail.

It was our opinion that Allaire had little intention of correcting the 
problem or packaging a robust enough spooler to meet our needs.  We did 
suggest that there wasn't enough disparity between Pro and ENT, and perhaps 
the ENT package should include a fully functional multi-threaded smtp 
relay.  I suggest checking out aspmail or moving back to 4.1 :(


Don't know if it helps, but thought I would share.

PS. We were able to send out hundreds of thousands of emails a day using 
single instances of cfmail tags, this bug only happens with more than one 
tag, and it seemed the length of the email, or the inclusion of an 
attachment greatly increased the likelihood of it happening.


At 08:21 PM 3/7/2001 -0800, you wrote:

> >i send out over 48,000 at a time in lots of 8,000. it takes less than 4
> >minutes to spool each (24 minutes for all of them) lot of 8000 out. in
>fact,
> >i *just* sent out 48,000 last night and another 48,000 this morning.
>
>Do you loop through them or use a query parameter?
>
>---> I use CFLOOP.
>
> >i don't have a clear answer to your problem, but i'm running CF4.5.1SP2 on
> >NT4.0SP5 and don't have any problems with it, so i don't think it's CF.
>
>I ran a couple small tests on NT and didn't have the problem.
>
>---> So maybe it's something about running on 98?
>
> >1) does CF on your 98 machine talk to the mail server OK in the
> >administrator?
>
>Sure. In fact, the first 2 mails go fine, then it hangs on the 3rd
>one. I never had any problems with 4.1. I'm stuck using my ISP's mail
>server so I can't test using a different one from home.
>
>--->What is their mail server?
>
> >2) just for kicks, put the content of the mail ("test") on its own line
> >(line break after the opening CFMAIL tag). don't know if it will work, but
> >that's just what i would try first.
>
>Same result.
>
>--->Sometimes wierd things work. Worth ruling them out. :)
>
>--
>
>Bud Schneehagen - Tropical Web Creations
>
>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>ColdFusion Solutions / eCommerce Development
>[EMAIL PROTECTED]
>http://www.twcreations.com/
>954.721.3452
>
~~
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: Help on CF bad_alloc error

[Stephen Kellogg]

Arden,
try increasing the Page Timeout in the ODBC connection in CF Admin from 600
(the default) to 1200.

HTH

Stephen

-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 12:07 AM
To: CF-Talk
Subject: Help on CF bad_alloc error


Helpful hints of the significance of the error message listed below ? ? ?
It's a CFQuery against an Access Table gone bad, but in what sense ? ? ?
Any addee insight would be helpful...

Error Diagnostic Information
bad_alloc: bad allocation
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487
~~
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: Simple Way To Output Month/Year as Header, and corresponding info below, Grouped.

[Michael Dinowitz]

Look at the docs on Group By in CFOUTPUTs. Your grouping by the dates.


> Hi there!
>
> I am trying to do this:
>
> March 2001
>
> 07-Mar-2001
> (console)10:41 AM   Former Sega Employees Form Online Gaming
Network -Kayode
>
> (console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose
US$2Billion-Gel
>
> (Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing
> Countries.-Gel
>
> 05-Mar-2001
> (Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel
> (Tech) 02:44 AM Intel Cuts Prices Again -Gel
> 
> 
> February 2001
>
> etc. etc.
> Currently,I've managed to group the Month and the Genre by using nested
> CFOUTPUTs..
>
> 
> #Dateformat(Date,"ddd,,")#
> 
>
> But of course this displays the Month over and over and over.
>
> I know one of you really smart people here can probably give a rough draft
> of a CFOUTPUT nest off the top of their heads to do this..it seems like
> something very common that a user would want to do with a report,so if you
> can..will you? :)
>
> http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm
>
> I don't want to embark on a series of CFLOOPS and  OldDate> and all that stuff..I feel there must be an SQL based solution to
> this..is there?
>
> -Gel
>
>
>
>
>
>
>
~~
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

Help on CF bad_alloc error

[Arden Weiss]

Helpful hints of the significance of the error message listed below ? ? ?
It's a CFQuery against an Access Table gone bad, but in what sense ? ? ?
Any addee insight would be helpful...

Error Diagnostic Information
bad_alloc: bad allocation 
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487


~~
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: Protecting an admin page

[Phoeun Pha]

This is how it is supposed to work.  In your login page, not only should u
check to see if the login/pasword is right, but also set a session variable
to true.  Then on the top of every admin page, do a test to see if that
session variable is true or not.  if not, forward them to the login page.
there are some other small things to consider but that's the basics of it if
u need more help lemme know!


- Original Message -
From: Hubert Earl <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 9:47 PM
Subject: Protecting an admin page


> Hi,
>
> I have an admin page which can be accessed thru a login page.  However, as
> it now stands, if someone were to learn bookmark that page, he or she
could
> return to it via the bookmark, rather than via the login page.  How can I
> ensure that someone could only access the admin page via the login page?
>
> Sincerely,
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> See pictures of items in my Jamaican Art, Craft & More Store Online Sale
on
> my "Me" page on eBay (this tells you a little about myself, including a
> photo), and there's a link to the auctions themselves:
> http://members.ebay.com/aboutme/hearl1/
>
> See pictures of all items I have:
> http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFMAIL problems on 4.51 SP 2

[Stephen Kellogg]

Bud,
I am currently using smtp.dll date time stamp is 5/12/00 7:13 size is 65,536
file version 4,5,1,1.
I think it is the one that came in the zip file.

I also have my delay time set to 230.
By the way, I have only done small amounts of e-mails (500 to 800 using NT
and win98) and have successfully done this with the query parameter in
cfmail (not looping) ;-)
Based on some of the stuff I have read on different lists, I suppose I'll
need to change this to a loop as the number of e-mails gets larger.

HTH

Stephen

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 11:08 PM
To: CF-Talk
Subject: RE: CFMAIL problems on 4.51 SP 2


On 3/7/01, Stephen Kellogg penned:
>Bud,
>see if any of this applies to you:
>http://www.allaire.com/Handlers/index.cfm?ID=15821&Method=Full

Yes, actually it did. I didn't replace the dll because the one
installed was newer. I had to bump up the registry Delay value to
150, but so far so good.

Do you think I should install the dll from the download?

Thanks a bunch.
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: SQL Server 7 on NT4 and WK2

[Arden Weiss]

Article in InfoWorld didn't say, but I imagine Server in both cases.


-Original Message-
From:   Paige Chandler [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, March 07, 2001 11:10 PM
To: CF-Talk
Subject:Re: SQL Server 7  on NT4 and WK2

Hi Guy,

What version of Win 2000? Professional? Server?

Have a nice evening.

Regards,

Paige
- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 9:39 PM
Subject: SQL Server 7 on NT4 and WK2


> A bit off topic, but very interesting...
>
> Cringely's column in this week's InfoWorld indicated that tests done by an
> independent lab for Network World showed that SQL Server 7 runs almost
> twice as fast on Windows NT4 as it does on Win 2000.
>
> Very interesting if true.
>
> Can any of you confirm similar differences in this regard -- or have
> different results ??
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
>
>
>
>
>
~~
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

browser close on submit

[Joshua Tipton]

How can I make a window close when it has been submited?

~~
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: CFMAIL problems on 4.51 SP 2

[Dylan Bromby]

>i send out over 48,000 at a time in lots of 8,000. it takes less than 4
>minutes to spool each (24 minutes for all of them) lot of 8000 out. in
fact,
>i *just* sent out 48,000 last night and another 48,000 this morning.

Do you loop through them or use a query parameter?

---> I use CFLOOP.

>i don't have a clear answer to your problem, but i'm running CF4.5.1SP2 on
>NT4.0SP5 and don't have any problems with it, so i don't think it's CF.

I ran a couple small tests on NT and didn't have the problem.

---> So maybe it's something about running on 98?

>1) does CF on your 98 machine talk to the mail server OK in the
>administrator?

Sure. In fact, the first 2 mails go fine, then it hangs on the 3rd
one. I never had any problems with 4.1. I'm stuck using my ISP's mail
server so I can't test using a different one from home.

--->What is their mail server?

>2) just for kicks, put the content of the mail ("test") on its own line
>(line break after the opening CFMAIL tag). don't know if it will work, but
>that's just what i would try first.

Same result.

--->Sometimes wierd things work. Worth ruling them out. :)

--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
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: CFMAIL problems on 4.51 SP 2

[Bud]

On 3/7/01, Stephen Kellogg penned:
>Bud,
>see if any of this applies to you:
>http://www.allaire.com/Handlers/index.cfm?ID=15821&Method=Full

Yes, actually it did. I didn't replace the dll because the one 
installed was newer. I had to bump up the registry Delay value to 
150, but so far so good.

Do you think I should install the dll from the download?

Thanks a bunch.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
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: SQL Server 7 on NT4 and WK2

[Paige Chandler]

Hi Guy,

What version of Win 2000? Professional? Server?

Have a nice evening.

Regards,

Paige
- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 9:39 PM
Subject: SQL Server 7 on NT4 and WK2


> A bit off topic, but very interesting...
>
> Cringely's column in this week's InfoWorld indicated that tests done by an
> independent lab for Network World showed that SQL Server 7 runs almost
> twice as fast on Windows NT4 as it does on Win 2000.
>
> Very interesting if true.
>
> Can any of you confirm similar differences in this regard -- or have
> different results ??
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
>
>
>
>
>
~~
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: IIS Permissions/Rights Problem Accessing cfm templates on one site

[Stephen Kellogg]

Paul,
kinda off the wall but... is there an application.cfm file in the directory
(or up the directory tree)? If so what's it doing?
Did you set scripting for that directory in IIS?

Just some quick thoughts

Stephen

-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 10:07 PM
To: CF-Talk
Subject: RE: IIS Permissions/Rights Problem Accessing cfm templates on
one site


Scott,

Thanks for the note.

> solution would be to manually reset the permissions on the
> dir/files to what
> they should be for the IIS server

Right. That's what I am trying to figure out - what permissions on which
files? I've looked at the home directory for the web site itself and all
permissions seem to be correct. I've looked at the CFusion directory and
that looks correct too.

What is stumping me is why one site would have this problem while other
sites with cfm templates don't have any permission troubles (apparently). It
seems like it must be a problem with permissions or rights to something in
the cfusion directory since I can access htm files just fine in the affected
site. But other sites are accessing cf files as well and they don't have the
problem.

Any ideas why there would be this different behavior on different sites?

Thanks for any follow up thoughts. I really appreciate any help.

Paul Sinclair


> -Original Message-
> From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 8:02 PM
> To: CF-Talk
> Subject: RE: IIS Permissions/Rights Problem Accessing cfm templates on
> one site
>
>
> I have seen this many times with newer versions of the mdac, the only
> solution would be to manually reset the permissions on the
> dir/files to what
> they should be for the IIS server M$ tends to do this every
> now and then
> with the mdac release, and I wish they would get this right one day!
>
>
>
> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: 08 March 2001 11:55
> To: CF-Talk
> Subject: IIS Permissions/Rights Problem Accessing cfm templates on one
> site
>
>
> I've got a strange problem that cropped up recently - I believe
> it has to do
> with applying MDAC 2.6. I haven't been able to fix the trouble
> and am hoping
> someone on this list may have some help.
>
> I have numerous websites on a single WinNT 4.0/SP6a, CFEnt 4.5.1/SP2
> machine. Many of the sites have cfm templates but all of these are working
> except for one. On the one site where things are not working
> correctly (and
> this site has not had problems before), all of a sudden it seems to have
> lost its NT rights or permissions to run properly.
>
> After stopping/restarting IIS, the first browse to any *.cfm
> template in the
> site elicits a login box. If I try to login using an ordinary user on the
> domain (i.e., a user in the Users group), the login fails. I have to login
> as a user with at least the rights/permissions of someone in the
> PowerUsers
> group. Obviously, a user in the Administrators group can log in
> successfully.
>
> What is especially strange is that once a user with the proper rights has
> logged in after IIS has been restarted, the site runs just fine. Anyone
> anywhere else can browse to it and no login prompt pops up. But if IIS is
> stopped/restarted, a login prompt pops up for the first browse to
> a cfm page
> in the site.
>
> The login prompt problem doesn't arise if trying to browse to any
> file other
> than *.cfm templates.
>
> To deal with this temporarily I have set the anonymous IIS user
> for this web
> site to a user in the PowerUsers group and this works fine. But I
> don't want
> to leave it this way for too long.
>
> Things I have looked at and done to try and diagnose/fix the problem:
>
> 1. The permissions on all the files in the site's home directory look like
> they are correct (Everyone Full Control).
> 2. IIS Directory Security for the site is set to Anonymous Access.
> 3. When I browse to *.htm or *.asp files in this problem site, no login is
> required.
> 4. When I browse to a *.cfm template for any other site on the machine, no
> login is required.
> 5. I've created a simple file with nothing in it but Hello
> world and named it hello.cfm. Even browsing to this simple cfm
> template pops up the login prompt.
> 6. Reapplied NT SP6a.
> 7. Reapplied CF Ent 4.5.1 SP2.
> 8. Reapplied MDAC 2.6.
> 9. Applied Jet 4.0 SP3 (required after installing MDAC 2.6 apparently).
>
> I've looked at just about everything I can think of to fix this but am out
> of ideas. Anyone out there have some suggestions?
>
> Thanks,
> Paul Sinclair
>
~~
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

Please ignore this test email

[Hubert Earl]

---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

See pictures of items in my Jamaican Art, Craft & More Store Online Sale on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




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

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

RE: Anyone know of a CFX to administer SQL Server 7?

[Clint Tredway]

Thank you very much. It took alot of work to get it where it is now, and it will take 
more to get it where I want it.



I have nothing to add, but I just wanted to say, very cool app dude. 
Excellent work 

J. 


John Wilker 
Web Applications Consultant 
Allaire Certified ColdFusion Developer 

Office: 909-943-8428 
www.billtracker.org  


-Original Message- 
From: Clint Tredway [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 07, 2001 5:38 PM 
To: CF-Talk 
Subject: Re: Anyone know of a CFX to administer SQL Server 7? 


I have an app that is not completely finished but it is an SQL Server 7 web 
based admin. To view my work in progress go to 
http://www.factorxsoftware.com/sqlmanager/ 

Thanks 

-- 
Clint Tredway 
www.factorxsoftware.com 
-- 


--
Clint Tredway
www.factorxsoftware.com
--

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

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

RE: Protecting an admin page

[Patricia Lee]

Check the http referer.  If it is the same as the script name, don't allow
them in... kick them out.

Might not be 100% foolproof.. I believe I've heard it said that some web
serers and/or browsers don't always shell out the http_referer
information... but it's at least good for a 97% solution.

|-Original Message-
|From: Hubert Earl [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, March 08, 2001 10:48 PM
|To: CF-Talk
|Subject: Protecting an admin page
|
|
|Hi,
|
|I have an admin page which can be accessed thru a login page.  
|However, as
|it now stands, if someone were to learn bookmark that page, he 
|or she could
|return to it via the bookmark, rather than via the login page. 
| How can I
|ensure that someone could only access the admin page via the 
|login page?
|
|Sincerely,
|---
|Hubert Earl
|
|ICQ#: 16199853
|AIM: hubertfme
|
|See pictures of items in my Jamaican Art, Craft & More Store 
|Online Sale on
|my "Me" page on eBay (this tells you a little about myself, including a
|photo), and there's a link to the auctions themselves:
|http://members.ebay.com/aboutme/hearl1/
|
|See pictures of all items I have:
|http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
|
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFMAIL problems on 4.51 SP 2

[Bud]

On 3/7/01, Dylan Bromby penned:
>i send out over 48,000 at a time in lots of 8,000. it takes less than 4
>minutes to spool each (24 minutes for all of them) lot of 8000 out. in fact,
>i *just* sent out 48,000 last night and another 48,000 this morning.

Do you loop through them or use a query parameter?

>i don't have a clear answer to your problem, but i'm running CF4.5.1SP2 on
>NT4.0SP5 and don't have any problems with it, so i don't think it's CF.

I ran a couple small tests on NT and didn't have the problem.

>1) does CF on your 98 machine talk to the mail server OK in the
>administrator?

Sure. In fact, the first 2 mails go fine, then it hangs on the 3rd 
one. I never had any problems with 4.1. I'm stuck using my ISP's mail 
server so I can't test using a different one from home.

>2) just for kicks, put the content of the mail ("test") on its own line
>(line break after the opening CFMAIL tag). don't know if it will work, but
>that's just what i would try first.


Same result.


-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
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: Javascript - Reloading window

[Patricia Lee]

Can you check the http referer, if it is the same as the script name, set a
variable.. if this variable is set then don't run the timeout/reload?

I know cf can check the http referer and script name, of course.  I believe
javascript can also check the http referer (at least in ie, not sure about
cross browser), and you can get the window's current href

It might be feasable ...

|-Original Message-
|From: Sam Komolafe [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, March 07, 2001 6:12 PM
|To: CF-Talk
|Subject: Javascript - Reloading window
|
|
|Hi guys,
|
|I need to reload a window just ONCE.  I used javascript
|window.setTimeout(location.reload(),1000) function but it reloads
|continuously.  How can I reload the window just ONCE
|
|Thanks
|
|sam
|
|
|
~~
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

Protecting an admin page

[Hubert Earl]

Hi,

I have an admin page which can be accessed thru a login page.  However, as
it now stands, if someone were to learn bookmark that page, he or she could
return to it via the bookmark, rather than via the login page.  How can I
ensure that someone could only access the admin page via the login page?

Sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

See pictures of items in my Jamaican Art, Craft & More Store Online Sale on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




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

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

RE: CF Pro okay for shopping carts?

[Darryl Lyons]

Cold Fusion express can handle a small shopping cart app :)

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 08, 2001 1:26 PM
To: CF-Talk
Subject: Re: CF Pro okay for shopping carts?


On 3/7/01, Sean Faulkner penned:
>This may be today's dumbest question, but is CF Pro robust enough to handle
>a small shopping cart app?

Yes it is. Robust enough that is, not today's dumbest question. :)
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF Pro okay for shopping carts?

[Bud]

On 3/7/01, Sean Faulkner penned:
>This may be today's dumbest question, but is CF Pro robust enough to handle
>a small shopping cart app?

Yes it is. Robust enough that is, not today's dumbest question. :)
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

[David Shadovitz]

I've written a simple CFML Custom Tag which provides any or all of this 
information about two lists:
  * Union
  * Intersection
  * Differerences

It's called CF_Venn, for those Venn diagrams we learned in school.

I'll submit it to Allaire if and when those guys fix the darn Dev Exchange. 
 Meanwhile, just email me if you'd like it.

A live demo page for my tags is now available at 
http://members.evolt.org/dshadovi/index.cfm

(Posted to CF-Talk and CFDJList)

-David

~~
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: Windows2000 migration - Datasource Problem

[Toby Tremayne]

I know it sounds overly simplistic but the only time I've ever received that
error is when I've spelt the datasource name wrong in the actual cfquery tag
itself.


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Mary Fowler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 1:57 PM
To: CF-Talk
Subject: Windows2000 migration - Datasource Problem


Good evening, me fellow CF'rs.

I have been working all day trying to troubleshoot this and hope that I am
coherent enough to y'all to state the problem I am having correctly.

I am in the process of finishing up a migration to a new machine with
Windows2000 on it.  I have datasource connections for Oracle, SQL Server and
DB2.  They are in the Windows admin for ODBC under systems DSN, they show up
in Cold Fusion Admin for ODBC and verify, I can call up data from them in CF
Studio and I can access them with MSQuery. The problem is when I try to call
up a couple of the apps I get an error message that says:

Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)


[Microsoft][ODBC Driver Manager] Data source 'FRSDEVNATIVE73_NATIVE' not
found and no default driver specified

Hint: In order to use ODBC data sources with Cold Fusion you must create the
data source using the Data Sources page of the Cold Fusion Administrator. In
addition, if you are running under Windows NT you must make sure that the
Data Source is created as a System DSN in order for it to be available to
ColdFusion.


Data Source = "FRSDEVNATIVE73_NATIVE"

I have checked to make sure the spelling is correct on the DSN. Everything
work fine on the old machine (WINNT 4) Is this a bug with Win2000 and CF
4.5.1?  Any suggestions, clues or answers would be greatfully welcomed.

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

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

RE: IIS Permissions/Rights Problem Accessing cfm templates on one site

[Paul Sinclair]

Scott,

Thanks for the note.

> solution would be to manually reset the permissions on the
> dir/files to what
> they should be for the IIS server

Right. That's what I am trying to figure out - what permissions on which
files? I've looked at the home directory for the web site itself and all
permissions seem to be correct. I've looked at the CFusion directory and
that looks correct too.

What is stumping me is why one site would have this problem while other
sites with cfm templates don't have any permission troubles (apparently). It
seems like it must be a problem with permissions or rights to something in
the cfusion directory since I can access htm files just fine in the affected
site. But other sites are accessing cf files as well and they don't have the
problem.

Any ideas why there would be this different behavior on different sites?

Thanks for any follow up thoughts. I really appreciate any help.

Paul Sinclair


> -Original Message-
> From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 8:02 PM
> To: CF-Talk
> Subject: RE: IIS Permissions/Rights Problem Accessing cfm templates on
> one site
>
>
> I have seen this many times with newer versions of the mdac, the only
> solution would be to manually reset the permissions on the
> dir/files to what
> they should be for the IIS server M$ tends to do this every
> now and then
> with the mdac release, and I wish they would get this right one day!
>
>
>
> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: 08 March 2001 11:55
> To: CF-Talk
> Subject: IIS Permissions/Rights Problem Accessing cfm templates on one
> site
>
>
> I've got a strange problem that cropped up recently - I believe
> it has to do
> with applying MDAC 2.6. I haven't been able to fix the trouble
> and am hoping
> someone on this list may have some help.
>
> I have numerous websites on a single WinNT 4.0/SP6a, CFEnt 4.5.1/SP2
> machine. Many of the sites have cfm templates but all of these are working
> except for one. On the one site where things are not working
> correctly (and
> this site has not had problems before), all of a sudden it seems to have
> lost its NT rights or permissions to run properly.
>
> After stopping/restarting IIS, the first browse to any *.cfm
> template in the
> site elicits a login box. If I try to login using an ordinary user on the
> domain (i.e., a user in the Users group), the login fails. I have to login
> as a user with at least the rights/permissions of someone in the
> PowerUsers
> group. Obviously, a user in the Administrators group can log in
> successfully.
>
> What is especially strange is that once a user with the proper rights has
> logged in after IIS has been restarted, the site runs just fine. Anyone
> anywhere else can browse to it and no login prompt pops up. But if IIS is
> stopped/restarted, a login prompt pops up for the first browse to
> a cfm page
> in the site.
>
> The login prompt problem doesn't arise if trying to browse to any
> file other
> than *.cfm templates.
>
> To deal with this temporarily I have set the anonymous IIS user
> for this web
> site to a user in the PowerUsers group and this works fine. But I
> don't want
> to leave it this way for too long.
>
> Things I have looked at and done to try and diagnose/fix the problem:
>
> 1. The permissions on all the files in the site's home directory look like
> they are correct (Everyone Full Control).
> 2. IIS Directory Security for the site is set to Anonymous Access.
> 3. When I browse to *.htm or *.asp files in this problem site, no login is
> required.
> 4. When I browse to a *.cfm template for any other site on the machine, no
> login is required.
> 5. I've created a simple file with nothing in it but Hello
> world and named it hello.cfm. Even browsing to this simple cfm
> template pops up the login prompt.
> 6. Reapplied NT SP6a.
> 7. Reapplied CF Ent 4.5.1 SP2.
> 8. Reapplied MDAC 2.6.
> 9. Applied Jet 4.0 SP3 (required after installing MDAC 2.6 apparently).
>
> I've looked at just about everything I can think of to fix this but am out
> of ideas. Anyone out there have some suggestions?
>
> Thanks,
> Paul Sinclair
>
~~
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

Windows2000 migration - Datasource Problem

[Mary Fowler]

Good evening, me fellow CF'rs.

I have been working all day trying to troubleshoot this and hope that I am
coherent enough to y'all to state the problem I am having correctly.

I am in the process of finishing up a migration to a new machine with
Windows2000 on it.  I have datasource connections for Oracle, SQL Server and
DB2.  They are in the Windows admin for ODBC under systems DSN, they show up
in Cold Fusion Admin for ODBC and verify, I can call up data from them in CF
Studio and I can access them with MSQuery. The problem is when I try to call
up a couple of the apps I get an error message that says:

Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)


[Microsoft][ODBC Driver Manager] Data source 'FRSDEVNATIVE73_NATIVE' not
found and no default driver specified

Hint: In order to use ODBC data sources with Cold Fusion you must create the
data source using the Data Sources page of the Cold Fusion Administrator. In
addition, if you are running under Windows NT you must make sure that the
Data Source is created as a System DSN in order for it to be available to
ColdFusion.


Data Source = "FRSDEVNATIVE73_NATIVE"

I have checked to make sure the spelling is correct on the DSN. Everything
work fine on the old machine (WINNT 4) Is this a bug with Win2000 and CF
4.5.1?  Any suggestions, clues or answers would be greatfully welcomed.

TIA,
:)mary


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

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

RE: CFMAIL problems on 4.51 SP 2

[Stephen Kellogg]

Bud,
see if any of this applies to you:
http://www.allaire.com/Handlers/index.cfm?ID=15821&Method=Full

HTH

Stephen

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 6:08 PM
To: CF-Talk
Subject: CFMAIL problems on 4.51 SP 2


How can this possibly return an unknown exception condition?

unknown exception condition

TagCFMail::sendMessage


#loop#

test




It never makes it past the 2nd loop. I've restarted cfserver. I've
rebooted the server. How can anyone possibly use 4.51 if it can't
even handle sending out more than 2 e-mails at a clip? This is on my
Win98 test machine. I still can't get the nerve to install it on the
production server when I'm running into crap like this.
--

Bud Schneehagen - Tropical Web Creations

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

SQL Server 7 on NT4 and WK2

[Arden Weiss]

A bit off topic, but very interesting...

Cringely's column in this week's InfoWorld indicated that tests done by an 
independent lab for Network World showed that SQL Server 7 runs almost 
twice as fast on Windows NT4 as it does on Win 2000.

Very interesting if true.

Can any of you confirm similar differences in this regard -- or have 
different results ??

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487




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

Different Verity results for Netscape?

[C. Hatton Humphrey]

I'm running into something rather odd.  I've got a Verity search that works
like a charm in IE.  I'm taking a form field and manipulating it so I can do
AND and OR searches (if the AND returns no results, I perform an OR search).
Something odd is happening though.

If I search for something in IE, then all the "expected" results show up...
however, if I fire up Netscape and perform a search then only one of the
entries from the IE search is returned... nothing else.

Anyone have any clue why this might be happening?  Does Netscape post form
fields in such a way as to add extra unseen characters?

TIA!
Hatton Humphrey


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

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

Re: SMTP email question

[Tony Schreiber]

> hey all, is it possible to host my own site at home, but pay some hosting
> company a fee for using their SMPT so i can send/receive email?  is that
> possible?  cuz...
> 1.  My host sucks, they are hosting 200 other peeps, and the site is slow
> 2.  I got a killer server in my garage, and a decent DSL static line
> 3.  email server software cost a TON that's why i am asking the question

Use the SMTP server of your DSL Provider. That covers sending mail...


Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone!
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion


~~
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: Anyone know of a CFX to administer SQL Server 7?

[net_man]

I hear it will be complete and for sale very soon!!!  I can't wait to get
it

Robert

- Original Message -
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 8:55 PM
Subject: RE: Anyone know of a CFX to administer SQL Server 7?


> I have nothing to add, but I just wanted to say, very cool app dude.
> Excellent work
>
> J.
>
>
> John Wilker
> Web Applications Consultant
> Allaire Certified ColdFusion Developer
>
> Office: 909-943-8428
> www.billtracker.org 
>
>
> -Original Message-
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 5:38 PM
> To: CF-Talk
> Subject: Re: Anyone know of a CFX to administer SQL Server 7?
>
>
> I have an app that is not completely finished but it is an SQL Server 7
web
> based admin. To view my work in progress go to
> http://www.factorxsoftware.com/sqlmanager/
>
> Thanks
>
> --
> Clint Tredway
> www.factorxsoftware.com
> --
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: week ending

[John Wilker]

I wrote a custom tag for myself a while back to give me the date of each day
of a given week based on only having one day. Here's part of the code to
determine Friday (the upper bound of the week for my purpose)











#DateToAdd#

J.



John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 5:49 PM
To: CF-Talk
Subject: week ending


I want to setup a page that displays the week ending date based on the
current week.  So that if today was 3/07/2001 it would display 3/10/2001 or
if it was the 6th it would still say the 10th but then next week it will
start with the next week ending date.  Can someone help.

Joshua Tipton
~~
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: week ending

[tmwall]

Joshua,

How about:











#DateFormat(EndOfWeek,"mm/dd/")#


Todd Wall



-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 6:49 PM
To: CF-Talk
Subject: week ending


I want to setup a page that displays the week ending date based on the
current week.  So that if today was 3/07/2001 it would display 3/10/2001 or
if it was the 6th it would still say the 10th but then next week it will
start with the next week ending date.  Can someone help.

Joshua Tipton
~~
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: Anyone know of a CFX to administer SQL Server 7?

[John Wilker]

I have nothing to add, but I just wanted to say, very cool app dude.
Excellent work

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 5:38 PM
To: CF-Talk
Subject: Re: Anyone know of a CFX to administer SQL Server 7?


I have an app that is not completely finished but it is an SQL Server 7 web
based admin. To view my work in progress go to
http://www.factorxsoftware.com/sqlmanager/

Thanks

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

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

RE: curly queries

[Toby Tremayne]

thanks for all the help guys - Nick your outputting cf code gave me an idea.
I was working on stored procs and outer joins and grouping and all kinds of
stuff.. in the end this is how I did it:



select  p.poem_title,
p.poem_id,
p.date_written,
p.submission_type,
p.poem_blurb,
p.poem_content,
p.author_id,
pod.option_name,
po.setting
frommember m, poem p, poem_option po, poem_option_def pod
where m.member_id = p.author_id
and m.member_id = #attributes.member_id#
and po.poem_id = p.poem_id
and pod.option_id = po.option_id
and p.poem_id in (select p.poem_id
from poem p, poem_option po, poem_option_def 
pod
where p.poem_id = po.poem_id
and po.option_id = pod.option_id
and po.setting = 'off'
and pod.option_name = 'hidden')

order by p.date_submitted













  
 



#poem_title#



  

  
 

   

#poem_title#

   

  








ridiculously simple for something that's been driving me crazy.  It just
goes to prove once again that when you have a complex problem, break it down
into simple elements - determine exactly what you want to do in the simplest
terms possible, and work from there.  I got stuck on the idea that I needed
to do some exotic query or stored procedure and near drove myself crazy(er).
The above code works perfectly, and allows me to code conditionally for any
option I end up having.  Plus from a database of around 900 poems and
outputting a list of 70 odd (for the author_id I was testing it on) the
whole pae load took just under 250 milliseconds, which I think i can live
with.

Thanks again for the help guys

Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 March 2001 8:47 PM
To: CF-Talk
Subject: RE: curly queries


Toby

Something like this will get you n rows per poem where n
is the number of options, filtering out the hidden ones.
Assuming each poem must have options - otherwise you need
an outer join.

select p.poem_id, p.poem_title, d.option_name, o.setting
from poem p, poem_option o, poem_option_def d
where p.poem_id = o.poem_id
and d.option_id = o.option_id
and poem_id in
(select p.poem_id from poem p, poem_option o, poem_option_def d
where p.poem_id = o.poem_id
and d.option_id = o.option_id
and d.option_name = 'hidden'
and d.setting = 'off')

You could use  in CF
to "group" the output, but actually you want everything
on one line, so I think you'll have to do something
along the lines of



  


#poem_id# #poem_title#
  

#option_name#=#setting#
  

I can't think of a way of doing headers like your example,
if you dont want to hardcode the options.

None of this tested I'm afraid ;-)

Nick

-Original Message-
From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 3:47 AM
To: CF-Talk
Subject: curly queries


I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each poem
has several "options" such as hidden, hilite etc.  As I output the titles in
a list, I need to be able to run conditional checks against each option (IE
if hilite is "on" then display markers next to the title.)  The tables are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I need
to select all this information for only the poems whose "hidden" option has
a setting of "off", then I need to output the title only once obviously, at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one record:
-
poem_id  |   poem_title   |   hidden   |   hilite  |   spellcheck   |

week ending

[Joshua Tipton]

I want to setup a page that displays the week ending date based on the
current week.  So that if today was 3/07/2001 it would display 3/10/2001 or
if it was the 6th it would still say the 10th but then next week it will
start with the next week ending date.  Can someone help.

Joshua Tipton


~~
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 Pro okay for shopping carts?

[Sean Faulkner]

This may be today's dumbest question, but is CF Pro robust enough to handle
a small shopping cart app?

Thanks in adv.
Sean



~~
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: Anyone know of a CFX to administer SQL Server 7?

[Clint Tredway]

I have an app that is not completely finished but it is an SQL Server 7 web based 
admin. To view my work in progress go to http://www.factorxsoftware.com/sqlmanager/

Thanks

--
Clint Tredway
www.factorxsoftware.com
--

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

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

RE: CFMAIL problems on 4.51 SP 2

[Dylan Bromby]

i send out over 48,000 at a time in lots of 8,000. it takes less than 4
minutes to spool each (24 minutes for all of them) lot of 8000 out. in fact,
i *just* sent out 48,000 last night and another 48,000 this morning.

i don't have a clear answer to your problem, but i'm running CF4.5.1SP2 on
NT4.0SP5 and don't have any problems with it, so i don't think it's CF.

1) does CF on your 98 machine talk to the mail server OK in the
administrator?
2) just for kicks, put the content of the mail ("test") on its own line
(line break after the opening CFMAIL tag). don't know if it will work, but
that's just what i would try first.

keep us posted, i'd be curious to see what happens. and if you want to email
me off-list i'd be happy to help. i do a lot with CFMAIL and CFPOP (and
non-CFPOP POP3 tools).

dylan

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 3:08 PM
To: CF-Talk
Subject: CFMAIL problems on 4.51 SP 2


How can this possibly return an unknown exception condition?

unknown exception condition

TagCFMail::sendMessage


#loop#

test




It never makes it past the 2nd loop. I've restarted cfserver. I've
rebooted the server. How can anyone possibly use 4.51 if it can't
even handle sending out more than 2 e-mails at a clip? This is on my
Win98 test machine. I still can't get the nerve to install it on the
production server when I'm running into crap like this.
--

Bud Schneehagen - Tropical Web Creations

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

Anyone know of a CFX to administer SQL Server 7?

[Cameron]

Hi all,

I don't know if this has been asked before or not, but I am wondering if
anyone knows whether there is a CFX to administer SQL Server 7.

Basically, I want something that provides similar functionality as
Enterprise Manager. Add, alter, delete tables, SP, etc.

I know I could probably use plain SQL to do it, but a CFX would be easier,
more secure & hopefully bug free.

Can anyone help me?

Cameron


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

Re: CF's lack of support for milliseconds in datetime fields

[Steve Aylor]

Hmmm.

I encountered this issue - but thought the blame belonged on Access and
ODBC.  Interesting twist here.  Seems what I gathered from the thread that
CF only alters it when you apply certain CF built in functions on it?

Anyways - I'll dig up that stored proc I used to get around the millisecond
snippage barrier, if you think it might be useful.

Steve

- Original Message -
From: "Lomvardias, Christopher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 4:17 PM
Subject: CF's lack of support for milliseconds in datetime fields


> There is an ongoing thread on Allaire's beta forum about CF's lack of
> support for milliseconds in datetime fields in ColdFusion query result
sets.
> I see this issue as fairly important issue (and shortcoming) and am
> wondering if anyone else has any thoughts on this.
>
> The thread is at
> http://beta.allaire.com/betaconf/Index.cfm?Message_ID=675174
>
> I'm interested in hearing what other folks think.
>
> Chris
> --
> Chris Lomvardias
> [EMAIL PROTECTED]
> Syscom, Inc.
> 400 E. Pratt Street, Suite 300
> Baltimore, MD 21202
> (410)539-3737 x1722 voice
> (410)539-7302 fax
> [EMAIL PROTECTED] (pager via email)
> http://www.syscom.com/
> --
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: IIS Permissions/Rights Problem Accessing cfm templates on one site

[Scott, Andrew]

I have seen this many times with newer versions of the mdac, the only
solution would be to manually reset the permissions on the dir/files to what
they should be for the IIS server M$ tends to do this every now and then
with the mdac release, and I wish they would get this right one day!



-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 11:55
To: CF-Talk
Subject: IIS Permissions/Rights Problem Accessing cfm templates on one
site


I've got a strange problem that cropped up recently - I believe it has to do
with applying MDAC 2.6. I haven't been able to fix the trouble and am hoping
someone on this list may have some help.

I have numerous websites on a single WinNT 4.0/SP6a, CFEnt 4.5.1/SP2
machine. Many of the sites have cfm templates but all of these are working
except for one. On the one site where things are not working correctly (and
this site has not had problems before), all of a sudden it seems to have
lost its NT rights or permissions to run properly.

After stopping/restarting IIS, the first browse to any *.cfm template in the
site elicits a login box. If I try to login using an ordinary user on the
domain (i.e., a user in the Users group), the login fails. I have to login
as a user with at least the rights/permissions of someone in the PowerUsers
group. Obviously, a user in the Administrators group can log in
successfully.

What is especially strange is that once a user with the proper rights has
logged in after IIS has been restarted, the site runs just fine. Anyone
anywhere else can browse to it and no login prompt pops up. But if IIS is
stopped/restarted, a login prompt pops up for the first browse to a cfm page
in the site.

The login prompt problem doesn't arise if trying to browse to any file other
than *.cfm templates.

To deal with this temporarily I have set the anonymous IIS user for this web
site to a user in the PowerUsers group and this works fine. But I don't want
to leave it this way for too long.

Things I have looked at and done to try and diagnose/fix the problem:

1. The permissions on all the files in the site's home directory look like
they are correct (Everyone Full Control).
2. IIS Directory Security for the site is set to Anonymous Access.
3. When I browse to *.htm or *.asp files in this problem site, no login is
required.
4. When I browse to a *.cfm template for any other site on the machine, no
login is required.
5. I've created a simple file with nothing in it but Hello
world and named it hello.cfm. Even browsing to this simple cfm
template pops up the login prompt.
6. Reapplied NT SP6a.
7. Reapplied CF Ent 4.5.1 SP2.
8. Reapplied MDAC 2.6.
9. Applied Jet 4.0 SP3 (required after installing MDAC 2.6 apparently).

I've looked at just about everything I can think of to fix this but am out
of ideas. Anyone out there have some suggestions?

Thanks,
Paul Sinclair
~~
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

IIS Permissions/Rights Problem Accessing cfm templates on one site

[Paul Sinclair]

I've got a strange problem that cropped up recently - I believe it has to do
with applying MDAC 2.6. I haven't been able to fix the trouble and am hoping
someone on this list may have some help.

I have numerous websites on a single WinNT 4.0/SP6a, CFEnt 4.5.1/SP2
machine. Many of the sites have cfm templates but all of these are working
except for one. On the one site where things are not working correctly (and
this site has not had problems before), all of a sudden it seems to have
lost its NT rights or permissions to run properly.

After stopping/restarting IIS, the first browse to any *.cfm template in the
site elicits a login box. If I try to login using an ordinary user on the
domain (i.e., a user in the Users group), the login fails. I have to login
as a user with at least the rights/permissions of someone in the PowerUsers
group. Obviously, a user in the Administrators group can log in
successfully.

What is especially strange is that once a user with the proper rights has
logged in after IIS has been restarted, the site runs just fine. Anyone
anywhere else can browse to it and no login prompt pops up. But if IIS is
stopped/restarted, a login prompt pops up for the first browse to a cfm page
in the site.

The login prompt problem doesn't arise if trying to browse to any file other
than *.cfm templates.

To deal with this temporarily I have set the anonymous IIS user for this web
site to a user in the PowerUsers group and this works fine. But I don't want
to leave it this way for too long.

Things I have looked at and done to try and diagnose/fix the problem:

1. The permissions on all the files in the site's home directory look like
they are correct (Everyone Full Control).
2. IIS Directory Security for the site is set to Anonymous Access.
3. When I browse to *.htm or *.asp files in this problem site, no login is
required.
4. When I browse to a *.cfm template for any other site on the machine, no
login is required.
5. I've created a simple file with nothing in it but Hello
world and named it hello.cfm. Even browsing to this simple cfm
template pops up the login prompt.
6. Reapplied NT SP6a.
7. Reapplied CF Ent 4.5.1 SP2.
8. Reapplied MDAC 2.6.
9. Applied Jet 4.0 SP3 (required after installing MDAC 2.6 apparently).

I've looked at just about everything I can think of to fix this but am out
of ideas. Anyone out there have some suggestions?

Thanks,
Paul Sinclair





~~
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: curly queries

[Toby Tremayne]

Eric,

thanks for that - the query part of it was the simplest part.  The problem
is that while I can output everything the way you've described below - I
still have no simple way to relate the "settings" values to the
"option_names" values.  Without hardcoding in the query etc, I need to be
able to run a conditional check saying "if the option named 'hilite' is set
to 'on' then do this"

do you see my problem?

Toby


Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913

-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 7 March 2001 11:50 PM
To: CF-Talk
Subject: RE: curly queries


Toby,

Their are two ways that you could do this.  First way it to return your
data in a column based manor (the "way you want it") then just print it
out, the second is to return it in a row based manor ( the "way it is
now").  Each way has issues.

Column Based :  What it seems like you would like to be able to pivot
your data so that the X direction is Y and vice versa.  In Access you
can use the SQL TRANSFORM function to take data and pivot it across an
axis.  However in SQL server (and I believe Oracle) you don't get such a
function (I've been trying to figure out how that is for quite a while).
If a TRANSFORM or similar function is not available to you, then you can
use SQL CASE statements to artificially create this pivot in the data.
The problem with this approach is that its not very flexible.  If your
options are changing frequently or vary greatly this method is probably
going to cause you more headache than its worth.

Row Based : The way you got the data back looks great to me.  Sure you
are getting back a bit of redundant data, but you are going to put much
less of a load on the DB than approaching this in a column based manor.
Have you ever used the GROUP attribute of CF Output?  This is exactly
the situation its for.  To pull this off (easily) I recommend you do two
things  1) Return the data using some *outer* joins so that their is
a row for every option for every poem (see SQL below) 2) Use CFOUTPUT
with the GROUP tag.  I could see it working something like this, keep in
mind the code below is a skeleton I'm sure you'll need some other logic.

DISCLAIMER : I didn't test any of this code ...so be prepared to fiddle
with it (sorry if eMail messes up the formatting)


SELECT  p.poem_id, p.poem_title,
po.setting,
pod.option_id, pod.option_name

FROMpoem p

LEFT OUTER JOIN
poem_option po  ON p.poem_id = po.poem_id
LEFT OUTER JOIN
poem_option_def pod ON  po.option_id pod.option_name
ORDER BYp.poem_id, option_name






#getPoems.poem_id#

#getPoems.option_name#







I hope this helps.

-eric


Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390
(f)   212.580.7181


-Original Message-
From: Toby Tremayne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 10:47 PM
To: CF-Talk
Subject: curly queries


I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each
poem
has several "options" such as hidden, hilite etc.  As I output the
titles in
a list, I need to be able to run conditional checks against each option
(IE
if hilite is "on" then display markers next to the title.)  The tables
are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I
need
to select all this information for only the poems whose "hidden" option
has
a setting of "off", then I need to output the title only once obviously,
at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one record:
-
poem_id  |   poem_title   |   hidden   |   hilite  |   spellcheck   |
-
   01"my poem"  "off""on" "on"


instead, I have this:

one record:
--

interacting with domain registrars

[Jon Tillman]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Does anyone know of a domain registrar that is easy to interface with? I have 
a look-up on a site I am building, and would like to transfer the user to 
register the domain if it comes back as available.

- -- 
Jon Tillman
http://www.eruditum.org
finger [EMAIL PROTECTED] to annoy the MPAA

If an infinite number of computer programmers programmed for an infinite 
number of years, they would eventually come up with a working operating 
system. Bill Gates, being impatient, gave them two days and took the first 
one that was finished.

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.1i

iQA/AwUBOqbU4dga7tZtnIOtEQL86ACcC8Jf2kA5bin0aV2OJ+0pL8DVjN0Aniel
ScFxBESFMjVe0MQI7uARriKE
=0oEb
-END PGP SIGNATURE-

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

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

RE: cfmail

[Robert Everland III]

Could you give an example of using this type of mime. I would like to see
how it is done.


Bob Everland

-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:53 PM
To: CF-Talk
Subject: Re: cfmail


MIME attachments are basically different formats of file to be attached in a
message. For instance at Double Click we use MIME attachment to a HTML
message in the case the reader doesn't support HTML then the MIME decencies
kick in and display the txt. You can find all about MIME and it's history at
http://bondiboard.macpublishing.net/1998/06/secrets/4337.html

--Yes it's a Mac Site--

As to the other issue I would determine if they are using new mail clients
that can read HTML and the send it that way.

-Brian
- Original Message -
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 3:23 PM
Subject: cfmail


> is there a way to attach a cf template to an email with the cfmail tag?
> and what exactly is a MIME attachment?
> i have a form that a user fills out...and i want the info in that form to
go
> to an email address but i want the layout of the form to go also.
> thanks,
> 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
> use or distribution of this e-mail is strictly prohibited.
>
>
>
>
~~
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's lack of support for milliseconds in datetime fields

[Lomvardias, Christopher]

There is an ongoing thread on Allaire's beta forum about CF's lack of
support for milliseconds in datetime fields in ColdFusion query result sets.
I see this issue as fairly important issue (and shortcoming) and am
wondering if anyone else has any thoughts on this.

The thread is at
http://beta.allaire.com/betaconf/Index.cfm?Message_ID=675174

I'm interested in hearing what other folks think.

Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--


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

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

Re: OT: Javascript: I can't reference

[andrew kopelman]

yes, i could.  only, could I then change the src of that img thru a 
javascript function?

Thanks,
Andrew

>From: "Fred T. Sanders" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: OT: Javascript: I can't reference Date: Wed, 07 Mar 2001 18:25:03 -0500
>
>you can use the onClick= event of an  to submit a form.
>whateverform.submit()
>
>or you could even enclose the image within  and have that run a
>whateverform.submit()
>
>Fred
>
>- Original Message -
>From: "David Cummins" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, March 07, 2001 6:20 PM
>Subject: Re: OT: Javascript: I can't reference 
>
> > Someone told me that it's impossible... therefore now I'm using an input
>tag if
> > there's no script, or an image link which submits when they click if 
>there
>is
> > javascript.
> >
> > David
> >
> > andrew kopelman wrote:
> > >
> > > Hi,
> > >
> > > I know this is off topic, but maybe someone has seen this problem
>before?
> > >
> > > I want to reference in javascript my:  > > name="myInputImage" src="../../images/cancel.gif">.  I want to do this
>in
> > > order that I can switch its image (and make it essentially 
>dissappear).
>Its
> > > not even showing up in my debug loop of all form elements!  And throws
>an
> > > error if I try to display it in alert box (so is commented out). A
>regular
> > >  does work, but i can't use it to submit the form.  Any 
>ideas?
> > >
> > > Thanks in advance,
> > > Andrew
> > >
> > > 
> > > 
> > > Untitled
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > >  > > enablecab="Yes">
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > > 
> >
> >
>
~~
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: SMTP email question

[Dave Watts]

> hey all, is it possible to host my own site at home, but pay 
> some hosting company a fee for using their SMPT so i can 
> send/receive email? is that possible? cuz...
> 1.  My host sucks, they are hosting 200 other peeps, and the 
> site is slow
> 2.  I got a killer server in my garage, and a decent DSL static 
> line
> 3.  email server software cost a TON that's why i am asking 
> the question

There are a couple of things worth pointing out here.

1. Your home DSL subscription probably excludes any real hosting. If your
DSL provider notices the increase in upstream bandwidth, they'll either
cancel you or increase your rates.

2. Your home DSL subscription probably provides different speeds for
upstream and downstream traffic. You'll probably be limited to the slower of
the two, although I'm not sure about that.

3. Email server software doesn't have to cost a ton. Many SMTP servers are
free - IIS comes with one, for example. If you want to host POP or IMAP
mailboxes, you typically pay on a per-mailbox basis, more or less, but if
you just want to send mail, this doesn't make any difference.

> I got two puters. Puter A has the coldfusion server and has 
> internet connection. Puter B is networked to Puter A and has 
> the SQL database, but no internet connection. Its IP address 
> is like 192.168.0.2. is there a way for me to export or import 
> data to the host computer (in Virginia)?? or does Puter B have 
> to have an internet connection?  thanx!

If you want to use your database admin interface (like SQL Enterprise
Manager) to transfer data directly, the machines would need some sort of
network connection. You could conceivably have a connection through the web
server ("Puter A") using routing and tunneling and that sort of stuff, but
most likely you don't. You could, however, simply backup your database to a
file, move the file to the web server, then move it from the web server to
the database server. You could even automate this process, with enough work.

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

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

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

RE: URL Problem Continues

[ibtoad]

Thanks for all of the input.  I have solved the problem.
Rich

-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 6:09 PM
To: CF-Talk
Subject: Re: URL Problem Continues



You can cheat a little..
   create a table that holds the cfid and cftoken. Add a field that is a
unique ID.  Fill it with createuuid()..
Pass that unique ID to the payment processor, then when it returns, look up
the cfid and cftoken.. then cflocate to whereever you want.
Al


>I am trying to interact with a payment processor.  Here is the problem.  I
>need to pass the urltoken in the return url. However the site I am
>interacting with changes the
>CFID=15&CFTOKEN=77027316 to
>CFID=15&CFTOKEN=77027316
>which is invalid to cold fusion.
>
>I tried UrlEncodedFormat and I got CFID%3D15%26CFTOKEN%3D77027316 which is
>also useless.  Is there anyway to recall the session variables with just
one
>varaiable being passed?  Or is there another way to do this?
>
>Thanks,
>Rich
>
>
>
>
~~
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: Javascript: I can't reference

[Fred T. Sanders]

you can use the onClick= event of an  to submit a form.
whateverform.submit()

or you could even enclose the image within  and have that run a
whateverform.submit()

Fred

- Original Message -
From: "David Cummins" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 6:20 PM
Subject: Re: OT: Javascript: I can't reference  Someone told me that it's impossible... therefore now I'm using an input
tag if
> there's no script, or an image link which submits when they click if there
is
> javascript.
>
> David
>
> andrew kopelman wrote:
> >
> > Hi,
> >
> > I know this is off topic, but maybe someone has seen this problem
before?
> >
> > I want to reference in javascript my:  > name="myInputImage" src="../../images/cancel.gif">.  I want to do this
in
> > order that I can switch its image (and make it essentially dissappear).
Its
> > not even showing up in my debug loop of all form elements!  And throws
an
> > error if I try to display it in alert box (so is commented out). A
regular
> >  does work, but i can't use it to submit the form.  Any ideas?
> >
> > Thanks in advance,
> > Andrew
> >
> > 
> > 
> > Untitled
> > 
> > 
> > 
> > 
> >
> > 
> >  > enablecab="Yes">
> >
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
>
>
~~
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: Javascript: I can't reference

[Craig Bowes]

Actually a regular image should be able to submit your form:








and you should be able to swap the images by referencing
document.whateverForm.src

Hope that helps.

-Craig
[EMAIL PROTECTED]


-Original Message-
From: andrew kopelman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 10:59 PM
To: CF-Talk
Subject: OT: Javascript: I can't reference .  I want to do this in
order that I can switch its image (and make it essentially dissappear).  Its
not even showing up in my debug loop of all form elements!  And throws an
error if I try to display it in alert box (so is commented out). A regular
 does work, but i can't use it to submit the form.  Any ideas?

Thanks in advance,
Andrew



Untitled
















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

Javascript - Reloading window

[Sam Komolafe]

Hi guys,

I need to reload a window just ONCE.  I used javascript
window.setTimeout(location.reload(),1000) function but it reloads
continuously.  How can I reload the window just ONCE

Thanks

sam


~~
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: URL Problem Continues

[Al Musella, DPM]

You can cheat a little..
   create a table that holds the cfid and cftoken. Add a field that is a 
unique ID.  Fill it with createuuid()..
Pass that unique ID to the payment processor, then when it returns, look up 
the cfid and cftoken.. then cflocate to whereever you want.
Al


>I am trying to interact with a payment processor.  Here is the problem.  I
>need to pass the urltoken in the return url. However the site I am
>interacting with changes the
>CFID=15&CFTOKEN=77027316 to
>CFID=15&CFTOKEN=77027316
>which is invalid to cold fusion.
>
>I tried UrlEncodedFormat and I got CFID%3D15%26CFTOKEN%3D77027316 which is
>also useless.  Is there anyway to recall the session variables with just one
>varaiable being passed?  Or is there another way to do this?
>
>Thanks,
>Rich
>
>
>
>
~~
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: Javascript: I can't reference

[David Cummins]

Someone told me that it's impossible... therefore now I'm using an input tag if
there's no script, or an image link which submits when they click if there is
javascript.

David

andrew kopelman wrote:
> 
> Hi,
> 
> I know this is off topic, but maybe someone has seen this problem before?
> 
> I want to reference in javascript my:  name="myInputImage" src="../../images/cancel.gif">.  I want to do this in
> order that I can switch its image (and make it essentially dissappear).  Its
> not even showing up in my debug loop of all form elements!  And throws an
> error if I try to display it in alert box (so is commented out). A regular
>  does work, but i can't use it to submit the form.  Any ideas?
> 
> Thanks in advance,
> Andrew
> 
> 
> 
> Untitled
> 
> 
> 
> 
> 
> 
>  enablecab="Yes">
> 
> 
> 
> 
> 
> 
> 
> 
> 

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

CFMAIL problems on 4.51 SP 2

[Bud]

How can this possibly return an unknown exception condition?

unknown exception condition

TagCFMail::sendMessage


#loop#

test




It never makes it past the 2nd loop. I've restarted cfserver. I've 
rebooted the server. How can anyone possibly use 4.51 if it can't 
even handle sending out more than 2 e-mails at a clip? This is on my 
Win98 test machine. I still can't get the nerve to install it on the 
production server when I'm running into crap like this.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

OT: Javascript: I can't reference

[andrew kopelman]

Hi,

I know this is off topic, but maybe someone has seen this problem before?

I want to reference in javascript my: .  I want to do this in 
order that I can switch its image (and make it essentially dissappear).  Its 
not even showing up in my debug loop of all form elements!  And throws an 
error if I try to display it in alert box (so is commented out). A regular 
 does work, but i can't use it to submit the form.  Any ideas?

Thanks in advance,
Andrew



Untitled
















~~
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: Validating user input.

[Tristram Charnley]

Despite your reluctance to use custom tags I would
recommend you look at  in the gallery,
this blocks malicious form submissions by filtering out
a list of characters you specify. (requires CF4.5)

Also keep your db outside your root directory!

HTH

Tristram Charnley
-
[EMAIL PROTECTED]

"If something is hard to do, its not worth doing!"
Homer Simpson. 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 07 March 2001 22:15
> To: CF-Talk
> Subject: Validating user input.
> 
> 
> Hello Everyone,
> 
> I'm pretty new to Coldfusion, and I need some guidance.
> I am developing a site where users will be able to submit
> information a database (their tips and tricks, nothing special).
> I want to make my app secure as possible. What kind
> of steps should I follow to make sure any malicious code
> gets passed? Which kind of symbols should I filter out, and
> which cf function would work best for this purpose. I do not 
> want to use
> custom tags. Does anybody have a security checklist before
> deploying a site? Maybe someone can guide me to a good security
> related website.
> 
> Thanks,
> 
> Robert
> 
> [EMAIL PROTECTED]
> http://www.httpworkshop.com 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Slight OT : Javascript works in IE, but ignored in Netscape

[Dan G. Switzer, II]

Mark,

Take a look at qForms:
http://www.pengoworks.com/qForms/

You're going to run into some problems using your current method if your
form contains any non-text fields. qForms provides a common API for setting
and retrieving form fields. Plus, it's cross-browser compatible, so it'll
take the guesswork out of things.

-Dan

-Original Message-
From: Picker, Mark P [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 5:02 PM
To: CF-Talk
Subject: Slight OT : Javascript works in IE, but ignored in Netscape

Hi All,

I am having a problem with a javascript function in ColdFusion.  Works fine
under IE, but not Netscape.

You enter a record ID in a form field and click the lookup button, which
loads a page which amongst other things, contains the below code.  Once the
query finds the correct details the code inserts the found records onto the
parent form.  FIne in IE, Netscape just ignores it.

As follows :




function updateinfo()
{
window.focus;
var name = "Mr" + " " + "Mark" + " " + "Picker";

  window.opener.StudentResults.Name1.value = name;
  window.opener.StudentResults.AddressOne1.value = "'TestSite'";

.. etc ..

  window.close()
}


Details are filled in with ColdFusion scripts.

It appears that netscape isn't even looking at the function.

Hope you can help.

Cheers
Mark

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


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

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

RE: Can you clear cached queries?

[Peter Stolz]

will clear all the cached queries on the server.
Undocumented and unsupported

P.

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:20 PM
To: CF-Talk
Subject: Can you clear cached queries?


After looking through the archives and my CF 4.5 book, the only way I see
to clear a cached query is to set the cachedwithin timespan to 0 (or maybe
1 second). Am I right? There is no clear_cached_queries function in 4.5?
(why the heck not?).

So what do you guys do? I am thinking of having another page in an
administration area that has all the cached queries in it, except the
cachedwithin timespan is set to zero on these. Ad administrator would
execute this page, clearing all the cached queries (As long as they all
made their way in to this list).

How does this sound?

Does anyone know of any cached query guidelines they can point me to? I
tried the allaire site, didn't see anything.

Thanks,
Ryan
~~
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

OT: O'Reilly Drops Software Development Division

[Benjamin S. Rogers]

Thought I would post a link to this news as many ColdFusion developers are
devoted WebSite customers.

http://software.oreilly.com/news.cfm?ID_News=200

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


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

Validating user input.

[robertathome123]

Hello Everyone,

I'm pretty new to Coldfusion, and I need some guidance.
I am developing a site where users will be able to submit
information a database (their tips and tricks, nothing special).
I want to make my app secure as possible. What kind
of steps should I follow to make sure any malicious code
gets passed? Which kind of symbols should I filter out, and
which cf function would work best for this purpose. I do not want to use
custom tags. Does anybody have a security checklist before
deploying a site? Maybe someone can guide me to a good security
related website.

Thanks,

Robert

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

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

RE: Text box not wrapping

[Paul Ihrig]

Have you tried ParagraphFormat?


# ParagraphFormat(editClass.ClassDescription) #



-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

> icq:  47658358


-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:47 PM
To: CF-Talk
Subject: Text box not wrapping


I have a text field value, that on the form, it wraps around and
everything looks fine, although on the action page, (so people see what they
submitted,) it just goes straight off to the right side of the page,  what
am I missing or forgeting to put in.

TIA

Michael
~~
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: Text box not wrapping

[Howarth, Craig (IBK-NY)]

If you specify wrap="hard" in the textarea tag, you must either convert the CR/LF 
using replace or ParagraphFormat() or use  to preserve the CR/LF as they are.  If 
you are using  already, then perhaps you have not specified wrap="hard" on 
textarea.

Craig

> -Original Message-
> From: Michael [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 4:47 PM
> To:   CF-Talk
> Subject:  Text box not wrapping
> 
> I have a text field value, that on the form, it wraps around and
> everything looks fine, although on the action page, (so people see what they
> submitted,) it just goes straight off to the right side of the page,  what
> am I missing or forgeting to put in.
> 
> TIA
> 
> Michael
> 
> 
> 
>
~~
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: LEVEL 8 Systems Corporate Website

[Roque,Carlos]

Fireworks or Photoshop should work fine for this. DreamWeaver is an editor
not a graphic drawing tool.

Carlos Roque
I.S., Applications
Web Development
Sage Software, Inc.
x2154

 -Original Message-
From:   Jones, Becky [mailto:[EMAIL PROTECTED]] 
Sent:   Wednesday, March 07, 2001 7:20 AM
To: CF-Talk
Subject:LEVEL 8 Systems Corporate Website

would anyone know what type of package this company used to make this image?
something like photoshop or dreamweaver?  
 
 http://www.level8.com/


*
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 
use or distribution of this e-mail is strictly prohibited. 


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

Slight OT : Javascript works in IE, but ignored in Netscape

[Picker, Mark P]

Hi All,

I am having a problem with a javascript function in ColdFusion.  Works fine
under IE, but not Netscape.

You enter a record ID in a form field and click the lookup button, which
loads a page which amongst other things, contains the below code.  Once the
query finds the correct details the code inserts the found records onto the
parent form.  FIne in IE, Netscape just ignores it.

As follows :




function updateinfo()
{
window.focus;
var name = "Mr" + " " + "Mark" + " " + "Picker";
  
  window.opener.StudentResults.Name1.value = name;
  window.opener.StudentResults.AddressOne1.value = "'TestSite'";

.. etc ..  

  window.close()
}


Details are filled in with ColdFusion scripts.

It appears that netscape isn't even looking at the function.

Hope you can help.

Cheers
Mark

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

RE: CF Virtual memory usage

[Jeff Beer]

BTW - when I said "timed out queries" I meant to say timed out sessions..
hehe - that's a big difference :)

Jeff Beer
Senior Programmer Architect
Hydrogen Media, Inc
(727) 530-5500 x303
[EMAIL PROTECTED]


> -Original Message-
> From: Jeff Beer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 4:23 PM
> To: CF-Talk
> Subject: CF Virtual memory usage
>
>
> Hello all,
>
> One of our cf servers is experiencing the "server unable to
> handle request"
> error.
>
> I can't find anything obviously wrong.  No errors in the
> logs, other than a
> few timed out queries.
>
> It's CF 4.5.2 using OLE DB and ODBC to a SQL Server db.  We
> have MDAC 2.5
> SP1 in place.  Task manager shows that the CF Server memory
> is growing, and
> it seems to stabilize around 70 megs.  It's a fairly high
> traffic site, with
> around 40 anonymous users on at any one time.
>
> One question is that the virtual memory amount (shown in task
> manager) for
> the CF service is slightly higher that the mem usage column.
> Should CF be
> consuming virtual memory as well as physical memory?  That
> doesn't make much
> sense to me, unless I am using the wrong definition of
> "virtual memory" in
> this context.
>
> Any ideas?
>
> Thanks,
>
> Jeff
>
>
> Senior Programmer Architect
> Hydrogen Media, Inc
> (727) 530-5500 x303
> [EMAIL PROTECTED]
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Text box not wrapping

[Michael]

I have a text field value, that on the form, it wraps around and
everything looks fine, although on the action page, (so people see what they
submitted,) it just goes straight off to the right side of the page,  what
am I missing or forgeting to put in.

TIA

Michael



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

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

Re: Multiple Websites on one server

[Jon Hall]

Why not just set up multiple web sites on the server using host headers and
use internal dns names to differentiate them?
We have an internal tld .oz ;-) So you could have a dev.gainsco,
proposal.gainsco, qa.gainsco...
If you want to show the proposal to a client, just enter a subdomain link
client.gainsco.com and just add that as a host header to the proposal site.
Just a thought...

Otherwise, I believe you could just set up multiple web sites on different
ports, to do it the way you want. Just point the site to different folders.
Just make sure that your customs tags are in the folder of the template that
calls them, or call them with cfmodule.

jon
- Original Message -
From: "Nathan Stanford" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 4:29 PM
Subject: Multiple Websites on one server


> We want to create
>
> A Development server  ex: http://test:999  c:\inetpub\wwwroot
>
> A QA server  ex: http://test:777  c:\inetpub\wwwqa
>
> A Proposal server  ex: http://test:555  c:\inetpub\wwwprop
>
>
> 1. In ColdFusion Administrator the mapping points to c:\inetpub\wwwroot
>
>How do I make sure that QA and Proposal does not LOOK at Development
> Files?
>
> 2. Custom Tags
>How do I make sure that QA and Proposal does not LOOK at Development
> Custom Tags?
>
> Thanks,
> Nathan
>
>
~~
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: ISP's with CF in Germany or Austria?

[Paul Ihrig]

yes it matters.
if i have to develop a site for German & Austrian architects who have
limited bandwidth, would i want them to trace route to Columbus Ohio?

i would be shot.

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

> icq:  47658358


-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:35 PM
To: CF-Talk
Subject: RE: ISP's with CF in Germany or Austria?


Does it really matter where your ISP is located?
I would check out the FAQs for recommended CF hosting.

HTH

Tristram Charnley
-
[EMAIL PROTECTED]

"If something is hard to do, its not worth doing!"
Homer Simpson. 

> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: 07 March 2001 21:13
> To: CF-Talk
> Subject: RE: ISP's with CF in Germany or Austria?
> 
> 
> any one know of CF, isp'd in Germany or Austria?
> or where to look?
> i have had 1 response to previous post.
> 
> thank you
> 
> -paul
> 
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> fax:  614 485-5534
> 
> Home: [EMAIL PROTECTED]
>   614 449-1681
> 
> icq:  47658358
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Multiple Websites on one server

[David Schmidt]

I would not put the files under the c:\inetpub\wwwroot folder.  It is best
to create three new folders, independent of each other.  Then you can map
both CF and the webserver to those folders.  Make sure you lock things down
security-wise, especially if these have outside IP addresses.

David



-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:29 PM
To: CF-Talk
Subject: Multiple Websites on one server


We want to create 

A Development server  ex: http://test:999  c:\inetpub\wwwroot

A QA server  ex: http://test:777  c:\inetpub\wwwqa

A Proposal server  ex: http://test:555  c:\inetpub\wwwprop


1. In ColdFusion Administrator the mapping points to c:\inetpub\wwwroot
 
   How do I make sure that QA and Proposal does not LOOK at Development
Files?
   
2. Custom Tags
   How do I make sure that QA and Proposal does not LOOK at Development
Custom Tags?

Thanks,
Nathan
~~
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: ISP's with CF in Germany or Austria?

[Tristram Charnley]

Does it really matter where your ISP is located?
I would check out the FAQs for recommended CF hosting.

HTH

Tristram Charnley
-
[EMAIL PROTECTED]

"If something is hard to do, its not worth doing!"
Homer Simpson. 

> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: 07 March 2001 21:13
> To: CF-Talk
> Subject: RE: ISP's with CF in Germany or Austria?
> 
> 
> any one know of CF, isp'd in Germany or Austria?
> or where to look?
> i have had 1 response to previous post.
> 
> thank you
> 
> -paul
> 
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> fax:  614 485-5534
> 
> Home: [EMAIL PROTECTED]
>   614 449-1681
> 
> icq:  47658358
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Multiple Websites on one server

[Nathan Stanford]

We want to create 

A Development server  ex: http://test:999  c:\inetpub\wwwroot

A QA server  ex: http://test:777  c:\inetpub\wwwqa

A Proposal server  ex: http://test:555  c:\inetpub\wwwprop


1. In ColdFusion Administrator the mapping points to c:\inetpub\wwwroot
 
   How do I make sure that QA and Proposal does not LOOK at Development
Files?
   
2. Custom Tags
   How do I make sure that QA and Proposal does not LOOK at Development
Custom Tags?

Thanks,
Nathan

~~
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: Broken image links

[Chris Martin]

Thanks to everyone who responded.  This looks like its going to solve the
problem.


~~
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 Virtual memory usage

[Jeff Beer]

Hello all,

One of our cf servers is experiencing the "server unable to handle request"
error.

I can't find anything obviously wrong.  No errors in the logs, other than a
few timed out queries.

It's CF 4.5.2 using OLE DB and ODBC to a SQL Server db.  We have MDAC 2.5
SP1 in place.  Task manager shows that the CF Server memory is growing, and
it seems to stabilize around 70 megs.  It's a fairly high traffic site, with
around 40 anonymous users on at any one time.

One question is that the virtual memory amount (shown in task manager) for
the CF service is slightly higher that the mem usage column.  Should CF be
consuming virtual memory as well as physical memory?  That doesn't make much
sense to me, unless I am using the wrong definition of "virtual memory" in
this context.

Any ideas?

Thanks,

Jeff


Senior Programmer Architect
Hydrogen Media, Inc
(727) 530-5500 x303
[EMAIL PROTECTED]



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

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

Can you clear cached queries?

[Ryan]

After looking through the archives and my CF 4.5 book, the only way I see 
to clear a cached query is to set the cachedwithin timespan to 0 (or maybe 
1 second). Am I right? There is no clear_cached_queries function in 4.5? 
(why the heck not?).

So what do you guys do? I am thinking of having another page in an 
administration area that has all the cached queries in it, except the 
cachedwithin timespan is set to zero on these. Ad administrator would 
execute this page, clearing all the cached queries (As long as they all 
made their way in to this list).

How does this sound?

Does anyone know of any cached query guidelines they can point me to? I 
tried the allaire site, didn't see anything.

Thanks,
Ryan


~~
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: ISP's with CF in Germany or Austria?

[Ben Forta]

See www.forta.com/cf/isp
29 in Germany, 2 in Austria


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 4:13 PM
To: CF-Talk
Subject: RE: ISP's with CF in Germany or Austria?


any one know of CF, isp'd in Germany or Austria?
or where to look?
i have had 1 response to previous post.

thank you

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

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

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

RE: ISP's with CF in Germany or Austria?

[Paul Ihrig]

any one know of CF, isp'd in Germany or Austria?
or where to look?
i have had 1 response to previous post.

thank you

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

icq:47658358

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

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

Re: Those darn Access .ldb files

[Larry C. Lyons]

Douglas,

A simple way of avoiding Access .ldb files would be to create a blank
database. Then link it to the real database using File -->Get External
Data-->Link Tables. Select the appropriate database and tables. Then
whenever you need to swap out the database its just a matter of copying
the file without having to worry about the Access .ldb files.

hth,
larry

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--

[EMAIL PROTECTED] wrote:
> 
> Ok,
> 
> I've searched through the House of Fusion Mail Archive and Allaire's
> support forums for info regarding how to unlock a M$ Access file through
> CF.   
> 
> Any thoughts?
> 
> -
> Douglas Knudsen
> Leveraged Technologies Group
> 678-351-6063
> Got Linux? http://linuxmall.com
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SMTP email question

[Michael]

Maybe this is NOT what you want to here, but why not switch hosting,
www.crystaltech.com

I dont work for them and am not affiliated with them , all I know is you
cant beat the bang for the buck

Good Luck

Michael
"Phoeun Pha" <[EMAIL PROTECTED]> wrote in message
3FDBC86059BAD4119A1B0090273D1EB60C2AC3@HOUBLUE">news:3FDBC86059BAD4119A1B0090273D1EB60C2AC3@HOUBLUE...
> hey all, is it possible to host my own site at home, but pay some hosting
> company a fee for using their SMPT so i can send/receive email?  is that
> possible?  cuz...
> 1.  My host sucks, they are hosting 200 other peeps, and the site is slow
> 2.  I got a killer server in my garage, and a decent DSL static line
> 3.  email server software cost a TON that's why i am asking the question
>
> Oh, while I'm at it, here's another question!
>
> I got two puters.  Puter A has the coldfusion server and has internet
> connection.  Puter B is networked to Puter A and has the SQL database, but
> no internet connection.  Its IP address is like 192.168.0.2.  is there a
way
> for me to export or import data to the host computer (in Virginia)??  or
> does Puter B have to have an internet connection?  thanx!
>
>
>
>
~~
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: Form submit new window

[Lee Surma]

Forget that last post. I got it working. Thanks Craig and Alex.
~~
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: Migrating from Windows NT to Solaris

[James Taavon]

You are correct. We are using CF on Solaris. Due to the case sensitivity
I just keep everything in lowercase, that way I don't run into any
problems.



David Schmidt wrote:
> 
> Hi all,
> 
> I have a customer that wants to switch from NT to Solaris. They use CF
> 4.5.1, SP2 on each. Their datasource will still run on an NT box using SQL 7
> or 6.5 (not sure which yet). What I need to know is, since Solaris is case
> sensitive, what tags are affected? Are all tags that have href, filename, or
> datasource parameters affected? I am interested in only the coding aspects
> of the migration, not install, admin and such.
> 
> Thank You,
> 
> David Schmidt, ACP
> DevTech,Inc.
> http://www.dev-tech.com/
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: LEVEL 8 Systems Corporate Website

[Christian L. Watt]

They used image ready and photoshop, my opinion is to use Fireworks by
Macromedia.  Adobe didn't have anything to that until Fireworks started
kicking there ass on web production graphics.

cw

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 9:55 AM
To: CF-Talk
Subject: RE: LEVEL 8 Systems Corporate Website


> would anyone know what type of package this company used to make
> this image?
> something like photoshop or dreamweaver?
>
>  http://www.level8.com/

Photoshop is an image editor, DreamWeaver is an HTML editor - so I doubt an
image was created in DreamWeaver...

They could have built it in just about any image editor as it's just a few
ovals and some picutres with drop-shadow and glow...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Form submit new window

[Lee Surma]

>onsubmit="window.open('','newTest','width=200,height=400')">

Thanks. That's kind of working but I'm getting two windows, the first with an error 
saying it can't evaluate one of the form elements and the second being exactly what I 
want.

Exact code
 
~~
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: Those darn Access .ldb files

[Christian L. Watt]

Have similar situation.  What I did was upload that database, then copy all
its contents to the production database.  That way it doesn't matter how
many people are connected, the info gets updated, and you have a backup
should something happen to the production DB either during transfere or
anything else.  Just recopy and off you go.  Hope this helps...

cw

-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 12:20 PM
To: CF-Talk
Subject: Re: Those darn Access .ldb files




ooops!  The intent: I have a page that an end user can use to upload a
M$ db that resides on the web server.  This db is manually updated
everyday. We would automate this by building a form and such, but the
end user(read customer) does not want to pay for it or change their
modus operandi(sp?)   There is a web app that does an ODBC read to
this db that others use daily.  Each time this occurs the .ldb file is
generated, if it doesn't already exist.  So, I want my page to be able
to upload the updated mdb file to the web server and over write the
current one.   So, I need this page to 'unlock' the current mdb file
and upload the newly updated mdb overwriting the current one all
without errors.

I know 3 below works, but what impact would this have on all the other
db based CF apps?

Thanks!

-
Douglas Knudsen
Leveraged Technologies Group
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/07/2001 02:43 PM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  Re: Those darn Access .ldb files


   I'm confused.  Are you trying to unlock the database inside a
'functional' page that users will see?

   I've only had to do this when I am copying over the database.
Using
method two, I would run it without the try/catch tags.  If the page
throws
an error, who cares.  It's a page for my own personal use.  I'm just
running it to unlock the database.

   Why do you need to unlock the database?

At 11:15 AM 03/07/2001 -0500, you wrote:



>Ok,
>
>I've searched through the House of Fusion Mail Archive and Allaire's
>support forums for info regarding how to unlock a M$ Access file
through
>CF.   We are using NT4 SP5(or 6) and CF 4.0.1. I have done/tried the
>following:
>
>1) unchecked the 'maintan connections' checkbox in the ODBC setup for
the
>datasource in the CF Administrator.
>
> This did not work.  When I do an ODBC read/write the lock
file is
>still generated
>
>2) tried performing a 'fake' query to the datasource
>
>
>
> 
> SELECT Rasputin
> FROM Russia
> WHERE Name = Gregori
> 
>
> 
>   worked?
> 
>
>
>
>
>This did not do it either.  If I remove the TRY/CATCH code, the
dtabase is
>unlocked, but then I get a non-functional page.  Is this code
correct?
>
>3) used this  in my page.  This
>works, but I suspect it is not a good idea to use in a production
>environment as it kills ALL dbconnections.  Any thoughts?  (This is
all
>for an Intranet, hence the use of M$ Access)
>
>4) used this throws an error.
>
>Any thoughts?
>
>
>-
>Douglas Knudsen
>Leveraged Technologies Group
>678-351-6063
>Got Linux? http://linuxmall.com
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SMTP email question

[Scott Brader]

Software.com has a free version of Post.Office that is limited to ten
mailboxes. Maybe it's not the greatest, but it does a nice job. I've been
using it along with CF for a couple of years now with no problems.

Scott

Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North Prairie, WI 53153-0235

Phone: 262.392.9173
Fax: 262.392.9174

Toll Free: 888.821.3427
Mobile: 262.490.1376



Amateurs practice until they get it right,
Experts practice until they can't get it wrong.

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:14 PM
To: CF-Talk
Subject: SMTP email question


hey all, is it possible to host my own site at home, but pay some hosting
company a fee for using their SMPT so i can send/receive email?  is that
possible?  cuz...
1.  My host sucks, they are hosting 200 other peeps, and the site is slow
2.  I got a killer server in my garage, and a decent DSL static line
3.  email server software cost a TON that's why i am asking the question

Oh, while I'm at it, here's another question!

I got two puters.  Puter A has the coldfusion server and has internet
connection.  Puter B is networked to Puter A and has the SQL database, but
no internet connection.  Its IP address is like 192.168.0.2.  is there a way
for me to export or import data to the host computer (in Virginia)??  or
does Puter B have to have an internet connection?  thanx!
~~
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: Help!!! - Nettscape 6 DOM

[Daniel Lancelot]

yep - .top works (although i'm having to usee .replace() to get rid of the
px

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 07 March 2001 19:14
To: CF-Talk
Subject: RE: Help!!! - Nettscape 6 DOM


> Ideally, Can someone point me to an understandable DOM reference for
> Netscape 6
>
> I am trying to position a div dynamically using JS in NS6 -
>  and document.getElementById(tdiv).style.pixelTop and
> document.getElementById(tdiv).style.Top and
> document.getElementById(tdiv).Top dont seem to work -
> has anyone any idea how to do this?

I'm pretty sure that .Top should be .top - not sure about pixelTop though...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Simple Way To Output Month/Year as Header, and corresponding info below, Grouped.

[Olivier Gostan]

change your sql to return MONTH(date) as month and group on this.
O-

- Original Message -
From: "Angél Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 2:15 PM
Subject: Simple Way To Output Month/Year as Header, and corresponding info
below, Grouped.


> Hi there!
>
> I am trying to do this:
>
> March 2001
>
> 07-Mar-2001
> (console)10:41 AM   Former Sega Employees Form Online Gaming
Network -Kayode
>
> (console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose
US$2Billion-Gel
>
> (Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing
> Countries.-Gel
>
> 05-Mar-2001
> (Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel
> (Tech) 02:44 AM Intel Cuts Prices Again -Gel
> 
> 
> February 2001
>
> etc. etc.
> Currently,I've managed to group the Month and the Genre by using nested
> CFOUTPUTs..
>
> 
> #Dateformat(Date,"ddd,,")#
> 
>
> But of course this displays the Month over and over and over.
>
> I know one of you really smart people here can probably give a rough draft
> of a CFOUTPUT nest off the top of their heads to do this..it seems like
> something very common that a user would want to do with a report,so if you
> can..will you? :)
>
> http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm
>
> I don't want to embark on a series of CFLOOPS and  OldDate> and all that stuff..I feel there must be an SQL based solution to
> this..is there?
>
> -Gel
>
>
>
>
>
>
>
~~
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: SMTP email question

[Cruz, Joseph]

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On the second question, you could install the Data Transformation Services(part
of the SQL Client tools) on the Web Server and use it to connect the local SQL
Server with the remote.  You won't be able to store and run the DTS package on
the local SQL server, however...although I imagine you can execute the DTS
package as a file on the I-net connected box, but I think you lose the ability
to automate the dump.

Joe

Joseph Cruz
Wharton Computing and Information Technology
Programmer/Analyst
3620 Locust Walk
Suite 400 SH-DH
Philadelphia, PA  19104-6302
[EMAIL PROTECTED]
215-898-1220(w)  215-573-2798(f)
215-308-0657(p)  215-768-2071(m)
 

> -Original Message-
> From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 2:14 PM
> To: CF-Talk
> Subject: SMTP email question
> 
> 
> hey all, is it possible to host my own site at home, but pay 
> some hosting
> company a fee for using their SMPT so i can send/receive 
> email?  is that
> possible?  cuz...
> 1.  My host sucks, they are hosting 200 other peeps, and the 
> site is slow
> 2.  I got a killer server in my garage, and a decent DSL static line
> 3.  email server software cost a TON that's why i am asking 
> the question
> 
> Oh, while I'm at it, here's another question!
> 
> I got two puters.  Puter A has the coldfusion server and has internet
> connection.  Puter B is networked to Puter A and has the SQL 
> database, but
> no internet connection.  Its IP address is like 192.168.0.2.  
> is there a way
> for me to export or import data to the host computer (in 
> Virginia)??  or
> does Puter B have to have an internet connection?  thanx! 

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBOqaOENCGp5RuWHIBEQIuYACcDgu13JbQsvZvRq8FbXSchy50N2cAoMRr
BGnQkUU+VjpRByqfh3tvKY1m
=2T7y
-END PGP SIGNATURE-

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

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

RE: Simple Way To Output Month/Year as Header, and corresponding info below, Grouped.

[Adkins, Randy]

You can set a temp variable with the date and then test 

if temp_var NEQ date then output date



-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 2:16 PM
To: CF-Talk
Subject: Simple Way To Output Month/Year as Header, and corresponding
info below, Grouped.


Hi there!

I am trying to do this:

March 2001

07-Mar-2001
(console)10:41 AM   Former Sega Employees Form Online Gaming Network -Kayode

(console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose US$2Billion-Gel

(Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing
Countries.-Gel

05-Mar-2001
(Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel
(Tech) 02:44 AM Intel Cuts Prices Again -Gel
.
.
February 2001

etc. etc.
Currently,I've managed to group the Month and the Genre by using nested
CFOUTPUTs..


#Dateformat(Date,"ddd,,")#


But of course this displays the Month over and over and over.

I know one of you really smart people here can probably give a rough draft
of a CFOUTPUT nest off the top of their heads to do this..it seems like
something very common that a user would want to do with a report,so if you
can..will you? :)

http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm

I don't want to embark on a series of CFLOOPS and  and all that stuff..I feel there must be an SQL based solution to
this..is there?

-Gel
~~
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: Simple Way To Output Month/Year as Header, and corresponding info below, Grouped.

[Phoeun Pha]

lemme see your CQUERY code, and an output of your results please

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:16 PM
To: CF-Talk
Subject: Simple Way To Output Month/Year as Header, and corresponding
info below, Grouped.


Hi there!

I am trying to do this:

March 2001

07-Mar-2001
(console)10:41 AM   Former Sega Employees Form Online Gaming Network -Kayode

(console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose US$2Billion-Gel

(Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing
Countries.-Gel

05-Mar-2001
(Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel
(Tech) 02:44 AM Intel Cuts Prices Again -Gel
.
.
February 2001

etc. etc.
Currently,I've managed to group the Month and the Genre by using nested
CFOUTPUTs..


#Dateformat(Date,"ddd,,")#


But of course this displays the Month over and over and over.

I know one of you really smart people here can probably give a rough draft
of a CFOUTPUT nest off the top of their heads to do this..it seems like
something very common that a user would want to do with a report,so if you
can..will you? :)

http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm

I don't want to embark on a series of CFLOOPS and  and all that stuff..I feel there must be an SQL based solution to
this..is there?

-Gel
~~
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: [HELP going from Dynamic CF Queries to Stored Procedures]

[metzy martinez]

my database is sql server 7.0  The problems is that i'm trying to make a
dynamic WHERE statement and i'm trying to find out if you can use them

Where (ID >0)AND((Name LIKE '%#name#%'))AND(list LIKE '%#list#%'))
in this query is trying to figure out if the user entered something into the
name field and if they did they are appending the statement to the where
clause



> -Original Message-
> From: Alex [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 07, 2001 12:23 PM
> To: CF-Talk
> Subject: Re: [HELP going from Dynamic CF Queries to Stored Procedures]
>
>
> you can't use ColdFusion ifs but you can use your DB's ifs.
> what's your DB?
>
> "metzy martinez" <[EMAIL PROTECTED]> wrote:
>
>
> Our company is going from using regular cfquery statements to putting them
> into stored procedures in order to get the load of our cold fusion box and
> letting the sql server box handle the load. where i'm having problems is
> making a query that is dynamic and changing it to a stored procedure. i'm
> wondering things like can i use if statements in my wheres. Attached is an
> example of what is driving me insane.
>
> 
> Select *
> From Listings2
>
> AND
> ((CategoryMain = '#category#') OR
> (CategoryOther = '#category#'))
>  AND
> ((Subs1 = '#subs1#') OR
> (SubsOther = '#subs1#') )
>  AND
> (Street1 LIKE '%#street#%')
>  AND
> (moviecode = '#moviecode#')
> AND
> ((Keywords LIKE '%#keyword#%') OR
> (Name LIKE '%#keyword#%') OR
> (Description LIKE '%#keyword#%') OR
> (CategoryMain LIKE '%#keyword#%') OR
> (CategoryOther LIKE '%#keyword#%') OR
> (Subs1 LIKE '%#keyword#%') OR
> (SubsOther LIKE '%#keyword#%'))
> AND (AreaOfTown = '#area#') 
> AND (NumberOfVotes > 0)
> AND (reviewid <> '') 
> AND (AwardsID <> '')
> ORDER BY #OrderBy#
> 
>
~~
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: Migrating from Windows NT to Solaris

[Jeff Britts]

In our environment we're developing on NT and deploying on Solaris.
(until we can get another Solaris box for development)

The only issues we've found are case sensitivity in filenames and a
different path structure if you're going to be doing things with cffile.

Usually we just copy everything over, maybe fix an image name or include
filename and it runs fine.

-Original Message-
From: David Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 2:10 PM
To: CF-Talk
Subject: Migrating from Windows NT to Solaris


Hi all,

I have a customer that wants to switch from NT to Solaris. They use CF
4.5.1, SP2 on each. Their datasource will still run on an NT box using SQL 7
or 6.5 (not sure which yet). What I need to know is, since Solaris is case
sensitive, what tags are affected? Are all tags that have href, filename, or
datasource parameters affected? I am interested in only the coding aspects
of the migration, not install, admin and such.

Thank You, 

David Schmidt, ACP 
DevTech,Inc. 
http://www.dev-tech.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CSS & Netscape

[Philip Arnold - ASP]

> In netscape, after a nested table, the style sheet stops
> functioning. for the rest of the page.  This happens in NS 4.6,
> 4.7 and 6.0.
>
> Is there a workaround to this problem.

Netscape has always had a problem with nested TABLEs and nested DIVs - make
sure you're not putting 2 DIVs inside each other, that's a big no-no in
NS4.x

NS6 should be happier though

The workaround? Use IE 

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

SMTP email question

[Phoeun Pha]

hey all, is it possible to host my own site at home, but pay some hosting
company a fee for using their SMPT so i can send/receive email?  is that
possible?  cuz...
1.  My host sucks, they are hosting 200 other peeps, and the site is slow
2.  I got a killer server in my garage, and a decent DSL static line
3.  email server software cost a TON that's why i am asking the question

Oh, while I'm at it, here's another question!

I got two puters.  Puter A has the coldfusion server and has internet
connection.  Puter B is networked to Puter A and has the SQL database, but
no internet connection.  Its IP address is like 192.168.0.2.  is there a way
for me to export or import data to the host computer (in Virginia)??  or
does Puter B have to have an internet connection?  thanx!



~~
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: Help!!! - Nettscape 6 DOM

[Philip Arnold - ASP]

> Ideally, Can someone point me to an understandable DOM reference for
> Netscape 6
>
> I am trying to position a div dynamically using JS in NS6 -
>  and document.getElementById(tdiv).style.pixelTop and
> document.getElementById(tdiv).style.Top and
> document.getElementById(tdiv).Top dont seem to work -
> has anyone any idea how to do this?

I'm pretty sure that .Top should be .top - not sure about pixelTop though...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

RE: LEVEL 8 Systems Corporate Website

[Philip Arnold - ASP]

> They used ImageReady which comes with PhotoShop 6.0 -
> ImageReady adds JavaScript code to the resulting HTML
> file to specify rollover states.

Actually, ImageReady comes with 5.5 - we never upgraded to v6 and use it
quite happily

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

Simple Way To Output Month/Year as Header, and corresponding info below, Grouped.

[Angél Stewart]

Hi there!

I am trying to do this:

March 2001

07-Mar-2001
(console)10:41 AM   Former Sega Employees Form Online Gaming Network -Kayode

(console)07:03 AM Analyst's Outlook On MS Xbox: MS Will Lose US$2Billion-Gel

(Tech)03:44 AM Windows XP's Copyprotection May Disadvantage Developing
Countries.-Gel

05-Mar-2001
(Tech) 09:44 PM Warning! New PC Virus:My Naked Wife... -Gel
(Tech) 02:44 AM Intel Cuts Prices Again -Gel


February 2001

etc. etc.
Currently,I've managed to group the Month and the Genre by using nested
CFOUTPUTs..


#Dateformat(Date,"ddd,,")#


But of course this displays the Month over and over and over.

I know one of you really smart people here can probably give a rough draft
of a CFOUTPUT nest off the top of their heads to do this..it seems like
something very common that a user would want to do with a report,so if you
can..will you? :)

http://www.carigamer.com/default.cfm?page=news/newsarchives.cfm

I don't want to embark on a series of CFLOOPS and  and all that stuff..I feel there must be an SQL based solution to
this..is there?

-Gel






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

Migrating from Windows NT to Solaris

[David Schmidt]

Hi all,

I have a customer that wants to switch from NT to Solaris. They use CF
4.5.1, SP2 on each. Their datasource will still run on an NT box using SQL 7
or 6.5 (not sure which yet). What I need to know is, since Solaris is case
sensitive, what tags are affected? Are all tags that have href, filename, or
datasource parameters affected? I am interested in only the coding aspects
of the migration, not install, admin and such.

Thank You, 

David Schmidt, ACP 
DevTech,Inc. 
http://www.dev-tech.com/ 


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

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

RE: URL Problem Continues

[ron]

> I am trying to interact with a payment processor.  Here is the problem.  I
> need to pass the urltoken in the return url. However the site I am
> interacting with changes the
> CFID=15&CFTOKEN=77027316 to
> CFID=15&CFTOKEN=77027316
> which is invalid to cold fusion.
>
> I tried UrlEncodedFormat and I got CFID%3D15%26CFTOKEN%3D77027316 which is
> also useless.  Is there anyway to recall the session variables
> with just one
> varaiable being passed?  Or is there another way to do this?

Pass it to them in one variable, like "s=15.77027316", then when it comes
back to you, split it back into the CFID and CFTOKEN in your Application.cfm
page BEFORE the  tag, like so:




  
  




We use that technique to pass the cfid and cftoken in the URL without giving
away what middleware we're using.

Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]




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

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

Fw: Closing A Browser Window

[ehoma]

Hi,

Thank you to everyone that responded.  I was making a rookie mistake, I was
inside of a frame and was only closing the frame.  I needed to open my
Logout.cfm page using Target='_top'.  It was late!

Thanks,

Eric Homa

- Original Message -
From: ehoma <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 1:50 AM
Subject: Closing A Browser Window


> Hi,
>
> Anyone know how I can make my logout.cfm page actually close the browser
> window?  I've created the browser window by using the following called
from
> another browser window:
>
> 
> window.open('/URL/index.cfm','Admin',
>
'toolbar,location,status,menubar,scrollbars,resizable,width=710,height=370')
> 
>
> When the user selects logout I clear the client and session variables and
> I'd like to close the window.  I've tried to use:
>
> 
> window.close()
> 
>
> It doesn't work.
>
> Any help?
>
> Thanks,
>
> Eric Homa
>
>
>
>
~~
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: [Form submit new window]

[Alex]

onSubmit="javascript:popup=window.open('url.cfm','popup','width=400,height=300,toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=1,resizable=1');"


Lee Surma <[EMAIL PROTECTED]> wrote:
I need to open a new window and control the size etc. when a form is
submitted. I know I can use target="new" in the form action, but I need to
specify the size and suppress the toolbar etc much like a Javascript onclick
window open command.
--
~~
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