Re: CF and Linux - anyone? Anyone? Bueller?

[Marc Edwards]

I did a bit of testing about a year ago comparing the two (CF 4.5 on Red Hat
Linux w/ Apache, 4.5 on NT 4.0 w/ IIS), running on similar hardware and the
same application. I was looking at the load handling capabilities, and used
Microsoft's stress test tool to simulate a large no. of users, and also
browsing the site at the same time to see what the experience was like for a
user when there was so much activity. Linux definitely outperformed Windows
on that front, pages were returned quicker, and when the loads got really
high CF Windows started to take really long and timeout before CF Linux did.
Also what was particularly interesting was that at extreme loads that choked
both servers, CF Linux was usually able to resume serving pages when the
load was reduced to normal levels again, while with windows I typically had
to reboot the system.

You know what I'd love to try though ? (if I could find the time) CF on the
Intel compatible version of Solaris - anybody ever experimented with that?

- Original Message -
From: "James Sleeman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, October 06, 2001 11:20 AM
Subject: Re: CF and Linux - anyone? Anyone? Bueller?


> While I havn't used it in a production scenario, I have used it from a
> development standpont, briefly.  What I found was this...
> 1) Case sensitivity - developing CF apps under windows for the last 2
years
> (before that I was at univerisity  using solaris) had made me real sloppy
> when it came to making sure that the cases all matched up :-)  When I
> ported the app I was developing to my linux box I had to write a couple of
> recursive templates to fix up the case of the 500 odd files and references
> to those files.  Did the job ok for the most part but still a pain in the
> proverbial
>
> 2) Databases. I had originally intended to use one of those ODBC bridges
to
> put the access database on  a windows machine (that's the only way of
doing
> it), but in the end I decided it was easier to just write the SQL.  I
> looked at mySQL, but the lack of sub-selects really bites IMHO, in the end
> I went with postgres and it worked well.
>
> 3) CFStudio, until you have to go without (not available under Linux) you
> don't realise how much you use that tag-insight.
>
> 4) Java - fscking Java !  I just could not get Java custom tags to
> work  under Linux.  Tried for hours to get it working to no avail.  I gave
> up in the end.
>
> All in all, it worked well, I "felt" that the CF server ran somewhat
faster
> - but I didn't make any actual tests between the two.  Getting JAVA
working
> - well, that was a big problem, although others don't seem to have had the
> same trouble so it might just be that I'm using Debian instead of the
> typical redhat guff.Not having CFSTUDIO or similar available was a
> downside, but not a show-stopper, it'd probably just make me know more CF
> off the top oif my head.  If our hosting partner used CF & Linux togethor
> and had Postgres available for that then I'd be tempted to use Linux at
> work instead of WindowsNT, I'd have to be able to get Java working first
> though, unfortunatly thoughall thier CF hosting is on Windows machines,
and
> even on thier linux boxen they only have MySQLL available.
>
> At 10:43 PM 10/5/2001, you wrote:
> >We're a CF shop and we're pondering the idea of trying to ditch Windoze
as
> >much as possible, if not entirely, on the development/production server
> >environments. Obviously the choices are CF on Linux, probably running
Oracle
> >and Access DBs (if, indeed, Access DBs still function properly as far as
> >fielding queries, etc. under Linux, when the file is present in the Linux
> >filesystem and a datasource pointed at it).
> >
> >I'd like to hear from some folks out there in CF-Talkland who've bit the
> >bullet and have put CF under Linux into 'real' use - i.e. production
sites,
> >etc. Also would like to hear what you've done as far as the DB goes -
which
> >ones you've used, good/bad things about each, etc.
> >
> >Replies off-list, if you would, please.
> >
> >Thanks!
> >--Scott
> >
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OSX CF Port?

[Dick Applebaum]

Andy

Me too-

I am an acknowledged Mac Bigot, but I love CF (even Access)

I think a BSD 'Nix-based Apache host otta' do jus' fine!

Dick

More's the pity if it don't







At 10:26 PM -0400 10/5/01, Andrew Tyrone wrote:
>I'd be interested to see the performance of a web server running on the
>MAC platform versus Windows 2000 Server or any *nix based server. 
>Unless of course you were only talking about desktop platform stability.
>  You were, right?
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFLOCK timeouts

[James Sleeman]

Well of course it depends on what is going on in the locked code (if you're 
doing a big job then it might take a while longer than 30 seconds).  You 
should check though for deadlocks if it works "sometimes" (i.e trying to 
obtain this lock, which is owned by a process trying to obtain a lock you 
hav), if you are nesting locks, make sure you do it in the same order 
everywhere i.e always lock x then y, never y then x, or you are asking for 
trouble.  Lock as little code as possible, it'll be easier to debug and 
faster to run.

At 02:53 AM 10/6/2001, you wrote:
>What is the average amount of time used for the timeout parameter of the
>cflock tag?
>I use  and have been
>receiving  'Timed out while waiting to obtain exclusive access' errors
>frequently.
>
>Obviously I should increase the timeout but does this indicate problems
>elsewhere in my code or server settings?
>
>Thanks,
>Dave
>
>
>
>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF and Linux - anyone? Anyone? Bueller?

[James Sleeman]

While I havn't used it in a production scenario, I have used it from a 
development standpont, briefly.  What I found was this...
1) Case sensitivity - developing CF apps under windows for the last 2 years 
(before that I was at univerisity  using solaris) had made me real sloppy 
when it came to making sure that the cases all matched up :-)  When I 
ported the app I was developing to my linux box I had to write a couple of 
recursive templates to fix up the case of the 500 odd files and references 
to those files.  Did the job ok for the most part but still a pain in the 
proverbial

2) Databases. I had originally intended to use one of those ODBC bridges to 
put the access database on  a windows machine (that's the only way of doing 
it), but in the end I decided it was easier to just write the SQL.  I 
looked at mySQL, but the lack of sub-selects really bites IMHO, in the end 
I went with postgres and it worked well.

3) CFStudio, until you have to go without (not available under Linux) you 
don't realise how much you use that tag-insight.

4) Java - fscking Java !  I just could not get Java custom tags to 
work  under Linux.  Tried for hours to get it working to no avail.  I gave 
up in the end.

All in all, it worked well, I "felt" that the CF server ran somewhat faster 
- but I didn't make any actual tests between the two.  Getting JAVA working 
- well, that was a big problem, although others don't seem to have had the 
same trouble so it might just be that I'm using Debian instead of the 
typical redhat guff.Not having CFSTUDIO or similar available was a 
downside, but not a show-stopper, it'd probably just make me know more CF 
off the top oif my head.  If our hosting partner used CF & Linux togethor 
and had Postgres available for that then I'd be tempted to use Linux at 
work instead of WindowsNT, I'd have to be able to get Java working first 
though, unfortunatly thoughall thier CF hosting is on Windows machines, and 
even on thier linux boxen they only have MySQLL available.

At 10:43 PM 10/5/2001, you wrote:
>We're a CF shop and we're pondering the idea of trying to ditch Windoze as
>much as possible, if not entirely, on the development/production server
>environments. Obviously the choices are CF on Linux, probably running Oracle
>and Access DBs (if, indeed, Access DBs still function properly as far as
>fielding queries, etc. under Linux, when the file is present in the Linux
>filesystem and a datasource pointed at it).
>
>I'd like to hear from some folks out there in CF-Talkland who've bit the
>bullet and have put CF under Linux into 'real' use - i.e. production sites,
>etc. Also would like to hear what you've done as far as the DB goes - which
>ones you've used, good/bad things about each, etc.
>
>Replies off-list, if you would, please.
>
>Thanks!
>--Scott
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ColdFusion Server Slows down... then stops

[Correa, Orlando (ITSC)]

This has been an interesting one... we've been reading the logs (server,
application, etc., etc.) for two days now and still haven't been able to
pin-point one thing... Initially we had a lot of database connection
timeouts for about a week, but that hadn't brought down the server... Then
we started getting Allaire COM timeout messages for a day a so... Then we
got invalid login for user '\' errors...  We did get one error that said we
were reading a variable in a scope (server scope) that require locking...
this read was within a  tag and we had automatic read locking on
server scope enabled, but it was still throwing that error... I recoded that
one, but then we were getting a bunch of ing timeout errors... and
still haven't been able to isolate it to a page... We also have disabled all
Access databases for now... uninstalled all called .dlls and have cranked up
the settings as suggested by Bud which helps for a while then it dies

The network guys are telling us that nothing has changed... but my guess is
that network latency issues my be forcing requests to queue up and then
eventually hang the server  

We're stilling trying to resolve the issue... and these are great
suggestions coming in... thank you all for the ideas... please keep sending
them if any other arise... 

Orlando

-Original Message-
From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 6:09 PM
To: CF-Talk
Subject: RE: ColdFusion Server Slows down... then stops


Orlando, this looks very much like a memory threading problem, in fact every
time I encountered these symptoms that's exactly what it was. Here is my
suggestion, firstly take a look at your Application and Server logs don't be
put off if they are large.  Look for any error messages with the words
"thread" or "threading" particularly if the word unresponsive is also
around.  The ColdFusion logs are VERY informative and should give the line
and position number on the page(s) that is causing problems.  Go to work on
the offending page(s) and at least on those pages put CFLOCK's around any
Application, Session or Server variable reads and writes.

If this is the problem, it would be prudent to then check all reads and
writes to and from these kinds of variables and seriously look at the
Request scope as an alternative scope to the others.

I hope this helps.

Mike Brunt
Sempra Energy
213.244.5226
"The nice thing about standards is that there are so many to choose from."  



-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 1:43 PM
To: CF-Talk
Subject: ColdFusion Server Slows down... then stops


Does anyone know if a solution/resolution to CF Server hanging as
described/detailing in the following Allaire forum thread has been found?

http://forums.allaire.com/coldfusion/messageview.cfm?catid=3&threadid=184276
&highlight_key=y&keyword1=unresponsive  


We are currently experiencing this problem as well.

Any help is greatly appreciated!

Thanks,
Orlando Correa


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

RE: OSX CF Port?

[Andrew Tyrone]

I'd be interested to see the performance of a web server running on the 
MAC platform versus Windows 2000 Server or any *nix based server.  
Unless of course you were only talking about desktop platform stability. 
 You were, right?

-Andy

> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 04, 2001 9:15 AM
> To: CF-Talk
> Subject: RE: OSX CF Port?
> 
> 
> I'm not really in the mood for an argument about "What's a better x" 
just
> trying to get my opinion out there. Thanks for the offer though. I'm
> speaking purely from a development standpoint. I don't CARE what 
> it's being
> served by -> IIS/Website Pro/Apache ... doesn't really matter, as 
> long as it
> runs. From a day-to-day programmer's standpoint, I'd much rather sit 
in
> front of a MAC all day than in front of my PCs.
> 
> I have 3 PCs and 1 Mac on my desk:
> 
> PC:  Compaq/Win98/AMD-K6 500/6gb/192mb
> PC:  Generic/Win2K/Celeron 633/70gb/384mb
> PC:  Dell/Win2K/PIII 800/60gb/512mb
> MAC: iMac/OS9/G3 400/13gb/384mb
> 
> Mac outruns them all and has yet to crash in the time that it's been 
here.
> The PCs on the other hand - I can count on a crash from at least 
> one of them
> at some point today - proabably the 98 machine.
> 
> That's all I have to say on this topic.
> 
> Joshua Miller
> Web Development::Programming
> Eagle Technologies Group, Inc.
> www.eagletgi.com
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 04, 2001 8:46 AM
> To: CF-Talk
> Subject: RE: OSX CF Port?
> 
> 
> I suppose you believe webstar is the most secure web server too
> 
> 
> 
> **
> **
> *
> Here, Here! Please port CF Studio and Server to the MAC OS ... much 
more
> stable environment.
> **
> 
> 
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird CFMAIL Error

[mailinglist]

Can anyone help me identify this error.  I'm running CF 4.5 on Windows 98 
if it's any help. Tanx!

Gregory Harris
[EMAIL PROTECTED]


unknown exception condition

TagCFMail::sendMessage

The error occurred while processing an element with a general identifier 
of (CFMAIL), occupying document position (103:5) to (103:121) in the 
template file 
C:\WEBSHARE\WWWROOT\ZAPCONNECT\WWW\ADMIN\USER_TO_COMPANY\ACT_PROCESS_UPDAT
ES.CFM.


Date/Time: 10/05/01 19:22:02
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)
Remote Address: 127.0.0.1
HTTP Referer: 
http://127.0.0.1/zapconnect/www/admin/user_to_company/index.cfm?
fuseaction=user_match
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: unknown fields...

[Dennis Powers]

If it is an *.cfm page you could loop through the form fields:









http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How to find out the page to send 'em back to

[Dave Babbitt]

I could never use this technique. Why is my CGI.Authorization always an
empty string? Anybody know? I use , though, to
great effect.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 1:34 PM
To: CF-Talk
Subject: Re: How to find out the page to send 'em back to


> If you want I can send a code example tonight.


Code is below (does this list accept attachments?). This code still is
based on session variables, but that should be easy to solve.
If the user needs to log in an HTTP statuscode 401 is send. This results
in a browser popup. When the user submits username&password these are
send as the HTTP header "authorization" with the form
ToBase64(username:password).

I would recommend reading the first 2 chapters of RFC 2617 for
background info (5 pages).


Have fun.

Jochem


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

RE: Database Design Question

[Kwang Suh]

If you have 3 tables, then there is no performance impact.  I'd keep it
normalized.

-Original Message-
From: Koo Pai Lao [mailto:[EMAIL PROTECTED]]
Sent: October 5, 2001 4:54 PM
To: CF-Talk
Subject: Database Design Question


ok, this is just a small example of what I am working with.

I have 3 tables, and their relationship is hierarchical.

TableA - id, name, year

TableB - id, description, TableA_id

TableC - id, time, location, TableB_id


ok, here is my question.  First off, i can relate information from TableA
with TableC through TableB, using outer joins or what not.  My question is,
would it save CPU time if I set up TableC like this...

TableC - id, time, location, TableB_id, TableA_id

so that I dont have to go through TableB to relate information between
TableA and TableC in my SQL statements??  Also, right now my head is telling
me that that might be a bad idea, since now if I edit the TableA_id in
TableB, i have the burden of editing it in TableC too.  But what are your
thoughts?

I'm just worried that too many wierd SQL statements will take more
processing time.
Ex..
Select this from there where b.id  is c.id AND c = d AND c.id  = b.id  and
c.id =  (u get the idea!!)
VS.
Select a from x where y = z (very simple!)



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

Re: HumanClick alternative

[John Lucas]

I just came across this one.  Haven't looked at it.  On the surface it seems
to be lacking some of the livehelper and humanclick features.

http://www.getmelive.com/default.asp


- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 4:58 PM
Subject: OT: HumanClick alternative


> Hi,
>
> HumanClick.com have stopped their free "live person" product (small bit of
> javascript on each page - neat way of keeping track of who's at your site,
> and simple & quick way of providing support).  I had it running on one of
my
> personal sites - just wondering if anyone knew of an alternative?
>
> Cheers
>
> Will
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ColdFusion Server Slows down... then stops

[Brunt, Michael]

Orlando, this looks very much like a memory threading problem, in fact every
time I encountered these symptoms that's exactly what it was. Here is my
suggestion, firstly take a look at your Application and Server logs don't be
put off if they are large.  Look for any error messages with the words
"thread" or "threading" particularly if the word unresponsive is also
around.  The ColdFusion logs are VERY informative and should give the line
and position number on the page(s) that is causing problems.  Go to work on
the offending page(s) and at least on those pages put CFLOCK's around any
Application, Session or Server variable reads and writes.

If this is the problem, it would be prudent to then check all reads and
writes to and from these kinds of variables and seriously look at the
Request scope as an alternative scope to the others.

I hope this helps.

Mike Brunt
Sempra Energy
213.244.5226
"The nice thing about standards is that there are so many to choose from."  



-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 1:43 PM
To: CF-Talk
Subject: ColdFusion Server Slows down... then stops


Does anyone know if a solution/resolution to CF Server hanging as
described/detailing in the following Allaire forum thread has been found?

http://forums.allaire.com/coldfusion/messageview.cfm?catid=3&threadid=184276
&highlight_key=y&keyword1=unresponsive  


We are currently experiencing this problem as well.

Any help is greatly appreciated!

Thanks,
Orlando Correa

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

Re: Is CF-Talk running slow

[Jim McAtee]

The same message took 75 minutes to get to me.   A 4:01 am (Eastern) post
was delivered in just 3 minutes, while another at 3:45 pm took 90.

Jim


- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 3:44 PM
Subject: Re: Is CF-Talk running slow


> 306 post and 310 receive. its you.
>
> Michael Dinowitz
> Publisher: Fusion Authority weekly news alert
> (www.fusionauthority.com/alert)
> Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
> (www.houseoffusion.com)
>
> - Original Message -
> From: "Bruce, Rodney" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 05, 2001 3:06 PM
> Subject: Is CF-Talk running slow
>
>
> > Is it just my connection here?  Or is it taking awhile for the posts to
go
> > through?
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: variable in custom tag name?

[Matt Robertson]

Thx everybody!  I think my brain has already taken the weekend off.  CFMODULE works 
great.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: Dave Babbitt <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 05 Oct 2001 18:14:59 -0400



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:59 PM
To: CF-Talk
Subject: variable in custom tag name?


Is it possible to have a variable in a custom tag *name* when calling it? I
have an app that has 50 different tag modules whose only difference is 2
letters in their name.  I'd like to be able to do a single generic call to
them if possible.  The example below blows up, and other attempts to dummy
something up with Evaluate() and DE() went nowhere for me.




#tagresult#



---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---



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

Re: OT: HumanClick alternative

[Paris Lundis]

Of course I am interested as well... :)  we got smacked by that phasing 
out...

-paris

[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: "W Luke" <[EMAIL PROTECTED]>
Date: Fri, 5 Oct 2001 22:58:10 +0100
Subject: OT: HumanClick alternative

> Hi,
> 
> HumanClick.com have stopped their free "live person" product (small
> bit of
> javascript on each page - neat way of keeping track of who's at your
> site,
> and simple & quick way of providing support).  I had it running on
> one of my
> personal sites - just wondering if anyone knew of an alternative?
> 
> Cheers
> 
> Will
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Database Design Question

[Koo Pai Lao]

ok, this is just a small example of what I am working with.

I have 3 tables, and their relationship is hierarchical.

TableA - id, name, year

TableB - id, description, TableA_id

TableC - id, time, location, TableB_id


ok, here is my question.  First off, i can relate information from TableA 
with TableC through TableB, using outer joins or what not.  My question is, 
would it save CPU time if I set up TableC like this...

TableC - id, time, location, TableB_id, TableA_id

so that I dont have to go through TableB to relate information between 
TableA and TableC in my SQL statements??  Also, right now my head is telling 
me that that might be a bad idea, since now if I edit the TableA_id in 
TableB, i have the burden of editing it in TableC too.  But what are your 
thoughts?

I'm just worried that too many wierd SQL statements will take more 
processing time.
Ex..
Select this from there where b.id  is c.id AND c = d AND c.id  = b.id  and 
c.id =  (u get the idea!!)
VS.
Select a from x where y = z (very simple!)


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

Re: ColdFusion Server Slows down... then stops

[Bud]

On 10/5/01, Correa, Orlando (ITSC) penned:
>Does anyone know if a solution/resolution to CF Server hanging as
>described/detailing in the following Allaire forum thread has been found?
>
>http://forums.allaire.com/coldfusion/messageview.cfm?catid=3&threadid=184276
>&highlight_key=y&keyword1=unresponsive
>
>We are currently experiencing this problem as well.
>
>Any help is greatly appreciated!

I was having similar problems with 4.01 several months ago. I bumped 
Simultaneous Requests up to 50. Way more than recommended, but I 
haven't had a problem since and through my upgrade to 4.51 sp2. I 
started out at 20 and watched for several days, that helped. I went 
to 30, that helped more. 40 was better. 50 did the trick.

I also set the Page Timeout value to 600 and Buffer Size to 0 for all 
Access DBs.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Getting Information from a RecordSet

[Nate Smith]

Close but the index goes after the column name like this:
QueryName.ColumnName[QueryName.RecordCount]

-
Nate Smith

> -Original Message-
> From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 6:00 PM
> To: CF-Talk
> Subject: Getting Information from a RecordSet
> 
> 
> All, 
> 
> I'm trying to find a way to get certain information from a 
> recordset. I need
> to get a certain field from the last row of the result of a 
> query. I know I
> can use #RecordCount# to get the number of rows, and I know 
> the field name.
> So now I need a way to get to that information. I assume if would be
> something like:
> 
> Recordset[#recordset.RecordCount#].fieldname but this does not work. 
> 
> Leon
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Scheduled Tasks in CF Admin

[Bruce, Rodney]

Dave 
Seen your comments on the web page.

There are only comments in the application.cfm page that explain
what the scheduled tasks do.  the application.cfm itself does nothing.

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

RE: Quotes questions

[Dave Babbitt]

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 3:03 PM
To: CF-Talk
Subject: Quotes questions


I'm using CFFILE and im trying to insert a list similar to the following in
the output part of the tag:

"#form.username#", "#form.firstname#", "#form.lastname#",
"#form.email#", "#password#"

making my entire cffile cammand look like:

"
addnewline="yes">

my problem is that I do not know/rememebr how to make those quotesa that
ahve to be around each entry appear in the file but not close the output.


thanks for oyur help

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

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

RE: Is CF-Talk running slow

[Bruce, Rodney]

This was not a put down to CF-Talk.
I think the list is great and Mike does a very hard job well, keeping it up.

Normally I get my posts back in approx 20 mins from the list.  Today it has
been taking about 50, more than twice as long.  
This could have been a lot of things.  but the only way to find out is to
ask. 
I have seen Mike's posts on the web page, so I know his answer.  So now the
options have been narrowed.  When I get the answers back to the other emails
and questions I sent I will hopefully get if figured out.

Granted I should have worded the question better.

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 2:37 PM
To: CF-Talk
Subject: RE: Is CF-Talk running slow


How many lists are they running? And how many thousands of users are they
sending each message to for each list?




-Original Message-
From: Bruce H. Sorge [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:02 PM
To: CF-Talk
Subject: Re: Is CF-Talk running slow


This list has almost always been slow for posts. There is that rare occasion
where when I submit a post that it goes through almost as fast as the
Dallas/Fort Worth ColdFusion Users Group (www.dfwcfug.org). Of course, the
DFWCFUG is running on Infranets IIFramework application framework,  which is
pretty slick (and no, I do not work for Infrastructure, nor do I get any
kickbacks, I just call em like I see em).
- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 2:06 PM
Subject: Is CF-Talk running slow


> Is it just my connection here?  Or is it taking awhile for the posts to go
> through?
>


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

RE: Scheduled Tasks in CF Admin

[Dave Babbitt]

Tell us what application.cfm pages also run along with this task template
and what they have in them.

-Original Message-
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:25 AM
To: CF-Talk
Subject: Scheduled Tasks in CF Admin


Hello all

I have created 3 tasks that I want to run on the 1st of each month.
When I run the pages manually they run fine.  When in CF Admin and I
run the task, no errors pop up and I get the message the task ran ok, but
nothing happens.
I set the first run of the task for testing to be this morning, but
nothing happened.
All the tasks do is check for accounts that have not been used in
over 60/90 days and sends an email to me and other site managers.   I have
set accounts so that they are over 60/90 days.

What am I missing?

Using CF 5, IIS4, NT 4.0 SP6, Access 2000

Thanks for any suggestions

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

RE: variable in custom tag name?

[Dave Babbitt]

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:59 PM
To: CF-Talk
Subject: variable in custom tag name?


Is it possible to have a variable in a custom tag *name* when calling it? I
have an app that has 50 different tag modules whose only difference is 2
letters in their name.  I'd like to be able to do a single generic call to
them if possible.  The example below blows up, and other attempts to dummy
something up with Evaluate() and DE() went nowhere for me.




#tagresult#



---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


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

RE: variable in custom tag name?

[Matthew W Jones]

call the custom tag with a cfmodule, and this should work

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 3:59 PM
To: CF-Talk
Subject: variable in custom tag name?


Is it possible to have a variable in a custom tag *name* when calling it? I
have an app that has 50 different tag modules whose only difference is 2
letters in their name.  I'd like to be able to do a single generic call to
them if possible.  The example below blows up, and other attempts to dummy
something up with Evaluate() and DE() went nowhere for me.




#tagresult#



---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---
 

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

Getting Information from a RecordSet

[Leon Oosterwijk]

All, 

I'm trying to find a way to get certain information from a recordset. I need
to get a certain field from the last row of the result of a query. I know I
can use #RecordCount# to get the number of rows, and I know the field name.
So now I need a way to get to that information. I assume if would be
something like:

Recordset[#recordset.RecordCount#].fieldname but this does not work. 

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

OT: HumanClick alternative

[W Luke]

Hi,

HumanClick.com have stopped their free "live person" product (small bit of
javascript on each page - neat way of keeping track of who's at your site,
and simple & quick way of providing support).  I had it running on one of my
personal sites - just wondering if anyone knew of an alternative?

Cheers

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

RE: variable in custom tag name?

[Billy Cravens]

You probably can't do it that way - you could do it by calling the
custom tag via the cfmodule tag:



---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, October 05, 2001 3:59 PM
To: CF-Talk
Subject: variable in custom tag name?


Is it possible to have a variable in a custom tag *name* when calling
it? I have an app that has 50 different tag modules whose only
difference is 2 letters in their name.  I'd like to be able to do a
single generic call to them if possible.  The example below blows up,
and other attempts to dummy something up with Evaluate() and DE() went
nowhere for me.




#tagresult#



---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---
 

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

RE: SQL Book

[Andrew Tyrone]

William,

Try:

Joe Celko's SQL for Smarties: Advanced SQL Programming
Transact-SQL Programming (O'Reilly)
The Guru's Guide to Transact-SQL

-Andy

> -Original Message-
> From: William H. Bowen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 3:13 PM
> To: CF-Talk
> Subject: OT: SQL Book
> 
> 
> I need a reference manual that contains basic to advanced SQL or T-SQL
> syntax. Stored procedure how to's would be nice as well. Any thoughts?
> 
> will
> 
> 
> William H. Bowen
> Webmaster
> ALSTOM's Energy Management and Markets Business
> 
> [EMAIL PROTECTED]
> http://www.esca.com/
> 
> 425.739.3629 Voice
> 425.466.7016 Cell
> 425.739.3690 FAX
> 
> 
> CONFIDENTIALITY: This e-mail and any attachments are confidential
> and may  be privileged. If  you are not a named recipient, please 
notify
> the sender immediately and  do not disclose the contents to another
> person, use it for any purpose or store or copy the information in any
> medium.
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How Can i pre select an update form using cf_threeselectsrelated

[Dave Babbitt]

Make a tag with similar attributes as the three select tags which will
insert javascript like this:


/* Make sure the #Attributes.Display1# is preselected */
var preselected = false;
var selectionObject = document.#Attributes.FormName#.#Attributes.Name1#;
var tot = selectionObject.length;
for(i = 0; i#Chr(60)#tot; i++) {
var optionObject = selectionObject.options[i];
var optionValue = optionObject.value;
if(optionValue==#Attributes.Default1#) {
optionObject.selected = true;
#Attributes.FormName#ChangeMenu(i);
preselected = true;
/* break so we don't get stuck at the bottom */
break;
}
else {optionObject.selected = false;}
}
if(preselected == false) {selectionObject.options[0].selected = true;}
/* Make sure the #Attributes.Display2# is preselected */
preselected = false;
selectionObject = document.#Attributes.FormName#.#Attributes.Name2#;
tot = selectionObject.length;
for(i = 0; i#Chr(60)#tot; i++) {
optionObject = selectionObject.options[i];
optionValue = optionObject.value;
if(optionValue==#Attributes.Default2#) {
optionObject.selected = true;
#Attributes.FormName#ChangeMenu2(i);
preselected = true;
/* break so we don't get stuck at the bottom */
break;
}
else {optionObject.selected = false;}
}
if(preselected == false) {selectionObject.options[0].selected = true;}
/* Make sure the #Attributes.Display3# is preselected */
preselected = false;
selectionObject = document.#Attributes.FormName#.#Attributes.Name3#;
tot = selectionObject.length;
for(i = 0; i#Chr(60)#tot; i++) {
optionObject = selectionObject.options[i];
optionValue = optionObject.value;
if(optionValue==#Attributes.Default3#) {
optionObject.selected = true;
preselected = true;
/* break so we don't get stuck at the bottom */
break;
}
else {optionObject.selected = false;}
}
if(preselected == false) {selectionObject.options[0].selected = true;}


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 9:04 AM
To: CF-Talk
Subject: How Can i pre select an update form using
cf_threeselectsrelated


How Can i pre select an update form using cf_threeselectsrelated
by using something like
SELECTED
SELECTED
SELECTED

thank you

-paul



also is there a way to use both 2selects related & 2selects related on the

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

Re: Is CF-Talk running slow

[Michael Dinowitz]

306 post and 310 receive. its you.

Michael Dinowitz
Publisher: Fusion Authority weekly news alert
(www.fusionauthority.com/alert)
Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
(www.houseoffusion.com)

- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 3:06 PM
Subject: Is CF-Talk running slow


> Is it just my connection here?  Or is it taking awhile for the posts to go
> through?
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Is CF-Talk running slow

[Michael Dinowitz]

You post was in at 401 and got to me at 404. Yep, that's slow.

Michael Dinowitz
Publisher: Fusion Authority weekly news alert
(www.fusionauthority.com/alert)
Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
(www.houseoffusion.com)

- Original Message -
From: "Bruce H. Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 4:01 PM
Subject: Re: Is CF-Talk running slow


> This list has almost always been slow for posts. There is that rare
occasion
> where when I submit a post that it goes through almost as fast as the
> Dallas/Fort Worth ColdFusion Users Group (www.dfwcfug.org). Of course, the
> DFWCFUG is running on Infranets IIFramework application framework,  which
is
> pretty slick (and no, I do not work for Infrastructure, nor do I get any
> kickbacks, I just call em like I see em).
> - Original Message -
> From: "Bruce, Rodney" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 05, 2001 2:06 PM
> Subject: Is CF-Talk running slow
>
>
> > Is it just my connection here?  Or is it taking awhile for the posts to
go
> > through?
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Is CF-Talk running slow

[Ken Wilson]

How many lists are they running? And how many thousands of users are they
sending each message to for each list?




-Original Message-
From: Bruce H. Sorge [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:02 PM
To: CF-Talk
Subject: Re: Is CF-Talk running slow


This list has almost always been slow for posts. There is that rare occasion
where when I submit a post that it goes through almost as fast as the
Dallas/Fort Worth ColdFusion Users Group (www.dfwcfug.org). Of course, the
DFWCFUG is running on Infranets IIFramework application framework,  which is
pretty slick (and no, I do not work for Infrastructure, nor do I get any
kickbacks, I just call em like I see em).
- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 2:06 PM
Subject: Is CF-Talk running slow


> Is it just my connection here?  Or is it taking awhile for the posts to go
> through?
>

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

Re: ColdFusion Server Slows down... then stops

[Bruce H. Sorge]

The only time that we have had this issue is when there was an issue with
the SQL Server. If the SQL Server is out of locks then the requests start to
stack up, then CF stops and starts again. When we added more locks to the
SQL server this issue pretty much went away. Not sure if this is your
situation, but may be a place to start.
- Original Message -
From: "Correa, Orlando (ITSC)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 3:43 PM
Subject: ColdFusion Server Slows down... then stops


> Does anyone know if a solution/resolution to CF Server hanging as
> described/detailing in the following Allaire forum thread has been found?
>
>
http://forums.allaire.com/coldfusion/messageview.cfm?catid=3&threadid=184276
> &highlight_key=y&keyword1=unresponsive
>
>
> We are currently experiencing this problem as well.
>
> Any help is greatly appreciated!
>
> Thanks,
> Orlando Correa
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Book

[Greg Jordan]

for t-sql i recommend "The Guru's Guide to Transact-SQL"

ISBN 0-201-61576-2



Greg Jordan
Macromedia Certified ColdFusion Developer
Web Project Manager
[EMAIL PROTECTED]

Unified Health Services
51 Germantown Court
Cordova, TN 38018
PH - (901) 843-2667 x261
FAX - (901) 843-2672




-Original Message-
From: Bruce H. Sorge [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 3:10 PM
To: CF-Talk
Subject: Re: SQL Book


Ben Forta has a really great handbook out called Tech Yourself SQL in 10
minutes. He avoids the typical diatribe about the creation of the earth,
discovery of fire, and the complete War and Peace edition of SQL, and gets
right to the nuts and bolts of SQL. Another book that I find useful is SQL
Queries for Mere Mortals by Hernandez/Viescas (Addison Wesley Publishers)
- Original Message -
From: "William H. Bowen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 2:13 PM
Subject: OT: SQL Book


> I need a reference manual that contains basic to advanced SQL or T-SQL
> syntax. Stored procedure how to's would be nice as well. Any thoughts?
>
> will
> 
>
> William H. Bowen
> Webmaster
> ALSTOM's Energy Management and Markets Business
>
> [EMAIL PROTECTED]
> http://www.esca.com/
>
> 425.739.3629 Voice
> 425.466.7016 Cell
> 425.739.3690 FAX
>
> 
> CONFIDENTIALITY: This e-mail and any attachments are confidential
> and may  be privileged. If  you are not a named recipient, please notify
> the sender immediately and  do not disclose the contents to another
> person, use it for any purpose or store or copy the information in any
> medium.
>

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

RE: Quotes questions

[Owens, Howard]

Try #chr(34)# for quote marks within CFFILE.

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Kris Pilles [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 12:03 PM
> To:   CF-Talk
> Subject:  Quotes questions
> 
> I'm using CFFILE and im trying to insert a list similar to the following
> in
> the output part of the tag:
> 
> "#form.username#", "#form.firstname#", "#form.lastname#",
> "#form.email#", "#password#"
> 
> making my entire cffile cammand look like:
> 
>  FILE="D:\INETPUB\WWWROOT\CLADMIN\ADMIN""
> output=""#form.username#", "#form.firstname#",
> "#form.lastname#",
> "#form.email#", "#password#""
> addnewline="yes">
> 
> my problem is that I do not know/rememebr how to make those quotesa that
> ahve to be around each entry appear in the file but not close the output.
> 
> 
> thanks for oyur help
> 
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: unknown fields...

[Owens, Howard]

I haven't followed this thread closely ... will a variation of the following
work:














Where I'm dropping the info into hidden form fields, you could first
determine what the fields are and later write query using that information.



H.





Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Paris Lundis [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 12:10 PM
> To:   CF-Talk
> Subject:  Re: unknown fields...
> 
> 
> 
> 
> 
> Jeff,
> 
> There is no form. It is posting information from desktop based software 
> to a page... the page doesn't exist right now... We catch it with a 404 
> error page.. the software I suspect thinks everythign is swell so the 
> submissions keep coming...
> 
> As far as manipulating the structure I haven't a clue. Anyone have any 
> code or simple aid to get the ball rolling...?
> 
> Thanks, as usual!
> 
> -paris
> 
> 
> Paris Lundis
> [finding the future in the past, passing the future in the present]
> [connecting people, places and things]
> 
> 
> -Original Message-
> From: Jeffry Houser <[EMAIL PROTECTED]>
> Date: Fri, 05 Oct 2001 13:30:35 -0700
> Subject: Re: unknown fields...
> 
> >   I'm a bit confused.
> >   Do you have access to the page that people are submitting the form
> > to?
> >   The form scope in a ColdFusion page is stored as a structure, so
> > you 
> > could just loop over the structure to find out all the form fields.
> > 
> >   Do you know where people are submitting the form from?  Can't you
> > just do 
> > a view source to see it?  If 20,000+ people are submitting info, the
> > form 
> > has gotta be somewhere obvious.
> > 
> > At 12:01 PM 10/05/2001 -0400, you wrote:
> > >Here's an odd scenario we have... haven't ever seen a need to do
> > >this... wondering what everyone recommends...
> > >
> > >We have a site that is defunct but still gets a massive number of
> > >submissions per day directly to the website... To the tune of
> > 20,000+
> > >per day...
> > >
> > >Lots of people have automated leads submission software that beams
> > >information off to a page that use to have a form there.. Funny
> > thing
> > >is we have no idea of what people are sending over and no idea of
> > the
> > >form fields...
> > >
> > >so the question is how would you go about 1. determining the fields,
> > 2.
> > >Writing a database to store the fields and any information that
> > isn't
> > >provided.
> > >
> > >Unusual I say :)
> > >
> > >-paris
> > >
> > >Paris Lundis
> > >[finding the future in the past, passing the future in the present]
> > >[connecting people, places and things]
> > >
> > >
> > 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: how to get the name and value of a field

[Douglas Jordon]

Did the trick, thanks.

Koo Pai Lao wrote:

> I do this every day :)
>
> 
> )>
>
> 
> 
> 
>
> you see... evaluate('form.'& index) will tell coldfusion to read it as
> Form.Bahehehe  (if index = bahehehe during that loop)
>
> but a question since your logic is wierd.  your conditions are doing the
> same thing.  WHY?
>
> >From: Douglas Jordon <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: how to get the name and value of a field
> >Date: Fri, 05 Oct 2001 14:19:59 -0400
> >
> >I created a little utility for myself that spits out inserts, updates,
> >forms, a set of cfparams etc. when passed a dsn and a table name. I
> >thought I'd try to go one better by enclosing the values in the insert
> >and update statements in single quotes when necessary. But in order to
> >do that, I need to access both the column name and the value of a field.
> >Something like:
> >
> >
> >
> >   SET index = form.index
> >
> >SET index =  'form.index'
> >
> >
> >It breaks because I don't know how to access the value of foo.index.
> >
> >Does anyone know how to do this? I hope I'm making sense.
> >
> >TIA,
> >
> >Doug Jordon
> >
> >
> >
> >
> >
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Book

[Bruce H. Sorge]

Now if only I could find a book that would teach me how to spell.

(Huked on foniks werked four mi!)

- Original Message -
From: "Bruce H. Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 3:10 PM
Subject: Re: SQL Book


> Ben Forta has a really great handbook out called Tech Yourself SQL in 10
> minutes. He avoids the typical diatribe about the creation of the earth,
> discovery of fire, and the complete War and Peace edition of SQL, and gets
> right to the nuts and bolts of SQL. Another book that I find useful is SQL
> Queries for Mere Mortals by Hernandez/Viescas (Addison Wesley Publishers)
> - Original Message -
> From: "William H. Bowen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 05, 2001 2:13 PM
> Subject: OT: SQL Book
>
>
> > I need a reference manual that contains basic to advanced SQL or T-SQL
> > syntax. Stored procedure how to's would be nice as well. Any thoughts?
> >
> > will
> > 
> >
> > William H. Bowen
> > Webmaster
> > ALSTOM's Energy Management and Markets Business
> >
> > [EMAIL PROTECTED]
> > http://www.esca.com/
> >
> > 425.739.3629 Voice
> > 425.466.7016 Cell
> > 425.739.3690 FAX
> >
> > 
> > CONFIDENTIALITY: This e-mail and any attachments are confidential
> > and may  be privileged. If  you are not a named recipient, please notify
> > the sender immediately and  do not disclose the contents to another
> > person, use it for any purpose or store or copy the information in any
> > medium.
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Book

[Dave Watts]

> I need a reference manual that contains basic to advanced SQL or T-SQL
> syntax. Stored procedure how to's would be nice as well. Any thoughts?

I like the O'Reilly "Transact-SQL Programming" book.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Ohio Area CFUG - Oct 9

[Angelo McComis]

Folks,

Time once again for the Ohio Area Cold Fusion User Group meeting.

This month:
- Updates on CF DevCon
- Administrative Stuff - Discuss needs / topics for upcoming meetings
- Giveaways
- November announcements
- Open Floor Q & A

When:
Tues 09-Oct
6:30 pm

Where:
OAR Net
1480 W. Lane Ave
Columbus, OH

Details:
www.oacfug.org




FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

variable in custom tag name?

[Matt Robertson]

Is it possible to have a variable in a custom tag *name* when calling it? I have an 
app that has 50 different tag modules whose only difference is 2 letters in their 
name.  I'd like to be able to do a single generic call to them if possible.  The 
example below blows up, and other attempts to dummy something up with Evaluate() and 
DE() went nowhere for me.




#tagresult#



---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---
 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Somewhat OT: Data Conversion

[Scott Brader]

Thanks for the suggestions. Unfortunately, I do not have DataEase locally
and was wondering if there was a way to get it out. I did find a product
called ConnectEase that provides an ODBC driver for DataEase, but the demo
version only errored out when I tried it.

Thanks,
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: Alex [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 13:27
To: CF-Talk
Subject: Re: Somewhat OT: Data Conversion


can you get it out as a deleimted file?
If yes, do it and insert it in Access

On Fri, 5 Oct 2001, Scott Brader wrote:

> One of my clients currently has all of their invoicing and inventory in an
> old Data Ease database. I am doing some new development for them and will
> need to convert the data from the Data Ease formats to Access. I don't
need
> to convert the forms, reports, etc. just the data. Does anyone have any
> input on converting the Data Ease data?
>
> Thanks,
> 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.
>

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

ColdFusion Server Slows down... then stops

[Correa, Orlando (ITSC)]

Does anyone know if a solution/resolution to CF Server hanging as
described/detailing in the following Allaire forum thread has been found?

http://forums.allaire.com/coldfusion/messageview.cfm?catid=3&threadid=184276
&highlight_key=y&keyword1=unresponsive  


We are currently experiencing this problem as well.

Any help is greatly appreciated!

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

Re: OT: SQL Book

[Chuck Rodgers]

You might want to take a look at Joe Celko's "SQL for Smarties"

Chuck Rodgers

At 12:13 PM 10/5/01 -0700, you wrote:
>I need a reference manual that contains basic to advanced SQL or T-SQL
>syntax. Stored procedure how to's would be nice as well. Any thoughts?
>
>will
>
>
>William H. Bowen
>Webmaster
>ALSTOM's Energy Management and Markets Business
>
>[EMAIL PROTECTED]
>http://www.esca.com/
>
>425.739.3629 Voice
>425.466.7016 Cell
>425.739.3690 FAX
>
>
>CONFIDENTIALITY: This e-mail and any attachments are confidential
>and may  be privileged. If  you are not a named recipient, please notify
>the sender immediately and  do not disclose the contents to another
>person, use it for any purpose or store or copy the information in any
>medium.
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Book

[Bruce H. Sorge]

Ben Forta has a really great handbook out called Tech Yourself SQL in 10
minutes. He avoids the typical diatribe about the creation of the earth,
discovery of fire, and the complete War and Peace edition of SQL, and gets
right to the nuts and bolts of SQL. Another book that I find useful is SQL
Queries for Mere Mortals by Hernandez/Viescas (Addison Wesley Publishers)
- Original Message -
From: "William H. Bowen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 2:13 PM
Subject: OT: SQL Book


> I need a reference manual that contains basic to advanced SQL or T-SQL
> syntax. Stored procedure how to's would be nice as well. Any thoughts?
>
> will
> 
>
> William H. Bowen
> Webmaster
> ALSTOM's Energy Management and Markets Business
>
> [EMAIL PROTECTED]
> http://www.esca.com/
>
> 425.739.3629 Voice
> 425.466.7016 Cell
> 425.739.3690 FAX
>
> 
> CONFIDENTIALITY: This e-mail and any attachments are confidential
> and may  be privileged. If  you are not a named recipient, please notify
> the sender immediately and  do not disclose the contents to another
> person, use it for any purpose or store or copy the information in any
> medium.
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Is CF-Talk running slow

[Bruce H. Sorge]

This list has almost always been slow for posts. There is that rare occasion
where when I submit a post that it goes through almost as fast as the
Dallas/Fort Worth ColdFusion Users Group (www.dfwcfug.org). Of course, the
DFWCFUG is running on Infranets IIFramework application framework,  which is
pretty slick (and no, I do not work for Infrastructure, nor do I get any
kickbacks, I just call em like I see em).
- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 2:06 PM
Subject: Is CF-Talk running slow


> Is it just my connection here?  Or is it taking awhile for the posts to go
> through?
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF and Linux - anyone? Anyone? Bueller?

[Pete Freitag]

There is another list [EMAIL PROTECTED] that has lots of people
using linux for production on it.

+++
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 6:44 AM
To: CF-Talk
Subject: CF and Linux - anyone? Anyone? Bueller?


We're a CF shop and we're pondering the idea of trying to ditch Windoze as
much as possible, if not entirely, on the development/production server
environments. Obviously the choices are CF on Linux, probably running Oracle
and Access DBs (if, indeed, Access DBs still function properly as far as
fielding queries, etc. under Linux, when the file is present in the Linux
filesystem and a datasource pointed at it).

I'd like to hear from some folks out there in CF-Talkland who've bit the
bullet and have put CF under Linux into 'real' use - i.e. production sites,
etc. Also would like to hear what you've done as far as the DB goes - which
ones you've used, good/bad things about each, etc.

Replies off-list, if you would, please.

Thanks!
--Scott

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

Re: CF and Linux - anyone? Anyone? Bueller?

[BEN MORRIS]

You might try and contact www.cfm-resources.com, they have a hosting plan 
using CF on Linux.

>>> "Scott Weikert" <[EMAIL PROTECTED]> 10/05/01 06:43AM >>>
We're a CF shop and we're pondering the idea of trying to ditch Windoze as
much as possible, if not entirely, on the development/production server
environments. Obviously the choices are CF on Linux, probably running 
Oracle
and Access DBs (if, indeed, Access DBs still function properly as far as
fielding queries, etc. under Linux, when the file is present in the Linux
filesystem and a datasource pointed at it).

I'd like to hear from some folks out there in CF-Talkland who've bit the
bullet and have put CF under Linux into 'real' use - i.e. production 
sites,
etc. Also would like to hear what you've done as far as the DB goes - 
which
ones you've used, good/bad things about each, etc.

Replies off-list, if you would, please.

Thanks!
--Scott

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

RE: CF and Linux - anyone? Anyone? Bueller?

[C. Hatton Humphrey]

There's a whole 'nother list for CF and Linux... CF-Linux... good place to
ask this question.

I've had some experience with it... drop Access databases, go with MySQL or
PostGreSQL... Access does not work "out of the box".

C. Hatton Humphrey, Developer
Fisher, Towne & Associates
716-839-2141 x336
[EMAIL PROTECTED]


> -Original Message-
> From: Scott Weikert [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 6:44 AM
> To: CF-Talk
> Subject: CF and Linux - anyone? Anyone? Bueller?
>
>
> We're a CF shop and we're pondering the idea of trying to ditch Windoze as
> much as possible, if not entirely, on the development/production server
> environments. Obviously the choices are CF on Linux, probably
> running Oracle
> and Access DBs (if, indeed, Access DBs still function properly as far as
> fielding queries, etc. under Linux, when the file is present in the Linux
> filesystem and a datasource pointed at it).
>
> I'd like to hear from some folks out there in CF-Talkland who've bit the
> bullet and have put CF under Linux into 'real' use - i.e.
> production sites,
> etc. Also would like to hear what you've done as far as the DB
> goes - which
> ones you've used, good/bad things about each, etc.
>
> Replies off-list, if you would, please.
>
> Thanks!
> --Scott
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: how to get the name and value of a field

[John Anderson]

Try this:



  SET index = form.index

SET index =  'form.index'


John Anderson
http://www.aloha-webdesign.com


-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:20 AM
To: CF-Talk
Subject: how to get the name and value of a field


I created a little utility for myself that spits out inserts, updates,
forms, a set of cfparams etc. when passed a dsn and a table name. I
thought I'd try to go one better by enclosing the values in the insert
and update statements in single quotes when necessary. But in order to
do that, I need to access both the column name and the value of a field.
Something like:



  SET index = form.index

SET index =  'form.index'


It breaks because I don't know how to access the value of foo.index.

Does anyone know how to do this? I hope I'm making sense.

TIA,

Doug Jordon






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

RE: CF and Linux - anyone? Anyone? Bueller?

[Jesse Noller]

By the way, there is a CF-Linux list, I'm forwarding your message to there,
hopefully, you'll get some good responses.

-jesse


> -Original Message-
> From: Scott Weikert [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 6:44 AM
> To: CF-Talk
> Subject: CF and Linux - anyone? Anyone? Bueller?
> 
> 
> We're a CF shop and we're pondering the idea of trying to 
> ditch Windoze as
> much as possible, if not entirely, on the 
> development/production server
> environments. Obviously the choices are CF on Linux, probably 
> running Oracle
> and Access DBs (if, indeed, Access DBs still function 
> properly as far as
> fielding queries, etc. under Linux, when the file is present 
> in the Linux
> filesystem and a datasource pointed at it).
> 
> I'd like to hear from some folks out there in CF-Talkland 
> who've bit the
> bullet and have put CF under Linux into 'real' use - i.e. 
> production sites,
> etc. Also would like to hear what you've done as far as the 
> DB goes - which
> ones you've used, good/bad things about each, etc.
> 
> Replies off-list, if you would, please.
> 
> Thanks!
> --Scott
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf-talk@houseoffusion.com

[Bruce, Rodney]

hello all

Below is my code for calling a custom error page if the file upload
errors out.
Is there a way to "CATCH" the different file errors.  i.e.  File
already exists or file is zero length.  What the different error types are.

 

 

 




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

Re: Problem with Stored Procedure

[Jared Stark]

I appreciate everyone's help.  It makes me feel better knowing I'm not
crazy... at least not yet anyway!
I'll add the extra parameters and just deal with I guess.

Jared
- Original Message -
From: "Matthew W Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 12:02 PM
Subject: RE: Problem with Stored Procedure


> The @ is correct, but as you are using sql server, it doesn't matter.
> You need to specify all of the parameters for your stored procedure, in
the
> correct order.
>
> With sql server, they (cfprocparam) MUST be in the correct order,
dbvarname
> doesn't even matter at all
> With Oracle, dbvarname does matter, and the (cfprocparam) order doesn't
>
> you will need to send the ones you are missing with the parameter of
> null="yes" (this means that regardless of what you have in the value, you
> will still be sending in null)
>
>
> -Original Message-
> From: Jared Stark [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 11:36 AM
> To: CF-Talk
> Subject: Re: Problem with Stored Procedure
>
>
> That is how I had it originally, but in the ColdFusion documentation it
> shows it with the @.
>
> Jared
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 05, 2001 6:13 AM
> Subject: RE: Problem with Stored Procedure
>
>
> > I think you need
> > DBVARNAME="Orderby"
> > instead of
> > DBVARNAME="@Orderby"
> >
> > This might be helpful:
> > http://www.defusion.com/articles/index.cfm?ArticleID=56
> >
> > > -Original Message-
> > > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 04, 2001 5:54 PM
> > > To: CF-Talk
> > > Subject: Problem with Stored Procedure
> > >
> > >
> > > -- Here is code snippet for my stored procedure:
> > >
> > > CREATE PROCEDURE spGetManagers
> > >  @OrderBy nvarchar(20)   = 'LAST',
> > >  @OrderType nvarchar(10)  = 'ASC',
> > >  @Id  int   = -1,
> > >  @ErrorStatus int  OUTPUT,
> > >  @ErrorMsg nvarchar(255) OUTPUT
> > > AS
> > > ...
> > >
> > > -- Here is CF Code calling the stored procedure:
> > >
> > >  > > password="#request.pass#" procedure="spGetManagers">
> > >
> > >   > > cfsqltype="CF_SQL_VARCHAR">
> > >   > > variable="ErrorStatus"
> > > cfsqltype="CF_SQL_INTEGER">
> > >   > > cfsqltype="CF_SQL_VARCHAR">
> > >  
> > >
> > > 
> > >
> > > You'll notice that I'm not providing parameters for
> > > @OrderType, nor @Id as
> > > they have default values defined in the sp.
> > >
> > > -- Here is the error message I am getting:
> > >
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > > parameter '@OrderType'
> > > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> > >
> > > It would appear that it is trying to map my second
> > >  to the
> > > @OrderType parameter, rather than using Named Notation and
> > > mapping it to
> > > @ErrorStatus.  My understanding is that by using the
> > > dbvarname attribute it
> > > would pass to the correct parameter and I wouldn't need to provide a
> > >  tag for ALL parameters.
> > >
> > > 1. Is there something stupid here that I'm missing?
> > > 2. Has anyone else had this problem?
> > > 3. Should I call it a day, and go home? (yes)
> > >
> > > Thanks for any help...
> > > Jared
> > >
> >
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL Question: results of a delete

[Brook Davies]

How to you return a result from an SQL delete command? I just need to know 
if anything was deleted.

Thanks!


At 01:28 PM 05/10/01 -0500, you wrote:
>Another option would be to add the procparams, in the correct order and set
>null="yes" in the procparam
>
>Another option would be to change the stored procedure itself to have the
>ones you don't want to pass as the last declarations, and just don't include
>the procparams for those
>
>-Original Message-
>From: Andy Ewings [mailto:[EMAIL PROTECTED]]
>Sent: Friday, October 05, 2001 12:12 PM
>To: CF-Talk
>Subject: RE: Problem with Stored Procedure
>
>
>No you need the @.
>
>Th problem is with ColdFusion.  IT is a nightmare when passing in proc
>params.  you unfortunately nedd to specify them all, and in the correct
>order.  I don't know why it asks for the dbvarname fattribute as it doen't
>appear to use it.  You have 2 options - either pass in the other params
>using the default as the value or uses cfquery and execute the sp using
>TRANSACT SQL i.e:
>
>EXEC spGetManagers @Orderby="Last", @ErrorStatus OUT etc...
>
>--
>Andrew Ewings
>Project Manager
>Thoughtbubble Ltd
>http://www.thoughtbubble.net
>--
>United Kingdom
>http://www.thoughtbubble.co.uk/
>Tel: +44 (0) 20 7387 8890
>--
>New Zealand
>http://www.thoughtbubble.co.nz/
>Tel: +64 (0) 9 488 9131
>--
>The information in this email and in any attachments is confidential and
>intended solely for the attention and use of the named addressee(s). Any
>views or opinions presented are solely those of the author and do not
>necessarily represent those of Thoughtbubble. This information may be
>subject to legal, professional or other privilege and further distribution
>of it is strictly prohibited without our authority. If you are not the
>intended recipient, you are not authorised to disclose, copy, distribute, or
>retain this message. Please notify us on +44 (0)207 387 8890.
>
>
>
>-Original Message-
>From: Jared Stark [mailto:[EMAIL PROTECTED]]
>Sent: 05 October 2001 17:36
>To: CF-Talk
>Subject: Re: Problem with Stored Procedure
>
>
>That is how I had it originally, but in the ColdFusion documentation it
>shows it with the @.
>
>Jared
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, October 05, 2001 6:13 AM
>Subject: RE: Problem with Stored Procedure
>
>
> > I think you need
> > DBVARNAME="Orderby"
> > instead of
> > DBVARNAME="@Orderby"
> >
> > This might be helpful:
> > http://www.defusion.com/articles/index.cfm?ArticleID=56
> >
> > > -Original Message-
> > > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 04, 2001 5:54 PM
> > > To: CF-Talk
> > > Subject: Problem with Stored Procedure
> > >
> > >
> > > -- Here is code snippet for my stored procedure:
> > >
> > > CREATE PROCEDURE spGetManagers
> > >  @OrderBy nvarchar(20)   = 'LAST',
> > >  @OrderType nvarchar(10)  = 'ASC',
> > >  @Id  int   = -1,
> > >  @ErrorStatus int  OUTPUT,
> > >  @ErrorMsg nvarchar(255) OUTPUT
> > > AS
> > > ...
> > >
> > > -- Here is CF Code calling the stored procedure:
> > >
> > >  > > password="#request.pass#" procedure="spGetManagers">
> > >
> > >   > > cfsqltype="CF_SQL_VARCHAR">
> > >   > > variable="ErrorStatus"
> > > cfsqltype="CF_SQL_INTEGER">
> > >   > > cfsqltype="CF_SQL_VARCHAR">
> > >  
> > >
> > > 
> > >
> > > You'll notice that I'm not providing parameters for
> > > @OrderType, nor @Id as
> > > they have default values defined in the sp.
> > >
> > > -- Here is the error message I am getting:
> > >
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > > parameter '@OrderType'
> > > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> > >
> > > It would appear that it is trying to map my second
> > >  to the
> > > @OrderType parameter, rather than using Named Notation and
> > > mapping it to
> > > @ErrorStatus.  My understanding is that by using the
> > > dbvarname attribute it
> > > would pass to the correct parameter and I wouldn't need to provide a
> > >  tag for ALL parameters.
> > >
> > > 1. Is there something stupid here that I'm missing?
> > > 2. Has anyone else had this problem?
> > > 3. Should I call it a day, and go home? (yes)
> > >
> > > Thanks for any help...
> > > Jared
> > >
> >
>
>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Can I use my Outlook address book as a data source?

[BT]

I did this through exchange with a LDAP component.
- Original Message - 
From: "Larry Juncker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 1:01 PM
Subject: Can I use my Outlook address book as a data source?


> Can I use my outlook Address Book as a data source for a cfmail
> template?
> 
> If so, can someone give me a little direction in how to accomplish this.
> 
> Thanks
> 
> Larry Juncker
> Senior Cold Fusion Developer
> Heartland Communications Group, Inc.
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: oracle brings the server down

[Matthew W Jones]

had something like this happen a long time ago.  Don't remember the
specifics, but we had transactions opening that weren't getting closed.

-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:57 PM
To: CF-Talk
Subject: oracle brings the server down


I am having a serious problem with oracle.

It looks like everytime the CF query make a connection to the tables 
in the oracle database the connection is not closed.  The numbers of
connection keep growing till the server is brought down. 

Does anyone have any idea how to fix this problem ? please give a 
hand.

thanks a lot.



--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com

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

OT: SQL Book

[William H. Bowen]

I need a reference manual that contains basic to advanced SQL or T-SQL
syntax. Stored procedure how to's would be nice as well. Any thoughts?

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

[EMAIL PROTECTED]
http://www.esca.com/

425.739.3629 Voice
425.466.7016 Cell
425.739.3690 FAX


CONFIDENTIALITY: This e-mail and any attachments are confidential
and may  be privileged. If  you are not a named recipient, please notify
the sender immediately and  do not disclose the contents to another
person, use it for any purpose or store or copy the information in any
medium.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: unknown fields...

[Paris Lundis]

Jeff,

There is no form. It is posting information from desktop based software 
to a page... the page doesn't exist right now... We catch it with a 404 
error page.. the software I suspect thinks everythign is swell so the 
submissions keep coming...

As far as manipulating the structure I haven't a clue. Anyone have any 
code or simple aid to get the ball rolling...?

Thanks, as usual!

-paris


Paris Lundis
[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: Jeffry Houser <[EMAIL PROTECTED]>
Date: Fri, 05 Oct 2001 13:30:35 -0700
Subject: Re: unknown fields...

>   I'm a bit confused.
>   Do you have access to the page that people are submitting the form
> to?
>   The form scope in a ColdFusion page is stored as a structure, so
> you 
> could just loop over the structure to find out all the form fields.
> 
>   Do you know where people are submitting the form from?  Can't you
> just do 
> a view source to see it?  If 20,000+ people are submitting info, the
> form 
> has gotta be somewhere obvious.
> 
> At 12:01 PM 10/05/2001 -0400, you wrote:
> >Here's an odd scenario we have... haven't ever seen a need to do
> >this... wondering what everyone recommends...
> >
> >We have a site that is defunct but still gets a massive number of
> >submissions per day directly to the website... To the tune of
> 20,000+
> >per day...
> >
> >Lots of people have automated leads submission software that beams
> >information off to a page that use to have a form there.. Funny
> thing
> >is we have no idea of what people are sending over and no idea of
> the
> >form fields...
> >
> >so the question is how would you go about 1. determining the fields,
> 2.
> >Writing a database to store the fields and any information that
> isn't
> >provided.
> >
> >Unusual I say :)
> >
> >-paris
> >
> >Paris Lundis
> >[finding the future in the past, passing the future in the present]
> >[connecting people, places and things]
> >
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: how to get the name and value of a field

[Koo Pai Lao]

I do this every day :)


)>
   





you see... evaluate('form.'& index) will tell coldfusion to read it as 
Form.Bahehehe  (if index = bahehehe during that loop)

but a question since your logic is wierd.  your conditions are doing the 
same thing.  WHY?


>From: Douglas Jordon <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: how to get the name and value of a field
>Date: Fri, 05 Oct 2001 14:19:59 -0400
>
>I created a little utility for myself that spits out inserts, updates,
>forms, a set of cfparams etc. when passed a dsn and a table name. I
>thought I'd try to go one better by enclosing the values in the insert
>and update statements in single quotes when necessary. But in order to
>do that, I need to access both the column name and the value of a field.
>Something like:
>
>
>
>   SET index = form.index
>
>SET index =  'form.index'
>
>
>It breaks because I don't know how to access the value of foo.index.
>
>Does anyone know how to do this? I hope I'm making sense.
>
>TIA,
>
>Doug Jordon
>
>
>
>
>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How to check directory permissions?

[saro cf]

Is there any function similar to "directoryexists" to check whether
the directory is writable. 
-- 
saro cf
[EMAIL PROTECTED] - email
(818) 630-2340 x6093 - voicemail/fax




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

Is CF-Talk running slow

[Bruce, Rodney]

Is it just my connection here?  Or is it taking awhile for the posts to go
through?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Scheduled Tasks in CF Admin

[Bruce, Rodney]

Query only takes approx  25ms,  then a few emails are sent.  Total time is
30-50ms.  

What service?  I looked at the services and all CF** services are running.



-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:06 AM
To: CF-Talk
Subject: Re: Scheduled Tasks in CF Admin


How long done is take to run... CF5 requires an additional service be
running for this to happen automatically.
- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 11:24 AM
Subject: Scheduled Tasks in CF Admin


> Hello all
>
> I have created 3 tasks that I want to run on the 1st of each month.
> When I run the pages manually they run fine.  When in CF Admin and I
> run the task, no errors pop up and I get the message the task ran ok, but
> nothing happens.
> I set the first run of the task for testing to be this morning, but
> nothing happened.
> All the tasks do is check for accounts that have not been used in
> over 60/90 days and sends an email to me and other site managers.   I have
> set accounts so that they are over 60/90 days.
>
> What am I missing?
>
> Using CF 5, IIS4, NT 4.0 SP6, Access 2000
>
> Thanks for any suggestions
> 

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

Quotes questions

[Kris Pilles]

I'm using CFFILE and im trying to insert a list similar to the following in
the output part of the tag:

"#form.username#", "#form.firstname#", "#form.lastname#",
"#form.email#", "#password#"

making my entire cffile cammand look like:

"
addnewline="yes">

my problem is that I do not know/rememebr how to make those quotesa that
ahve to be around each entry appear in the file but not close the output.


thanks for oyur help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: SQL 2000 can't log in other then trusted connection

[Mark W. Breneman]

Sorry for the OT.  I am at my wits end with this issue.  I know there are a
few expert SQL admins out there.

Just upgraded form SQL 7 to SQL 2000.  Restored the database into SQL 2000.
CF on the same box can talk to the SQL server happily using a trusted
connection. (but not a username/pass)  IF I use Enterprise manager from the
server using a trusted connection, I can admin it. I have added several
admin accounts in both windows and SQL, but I can not login with a username
and password.  I keep getting a message "Connection failed:SQLState:'28000'
SQL Server Error 18452 Login failed for usernamehere.  Reason: Not
associated with a trusted SQL Server connection."

I have tried (and failed):
Switching the authentication to windows and SQL.
Adding admin account in windows.
Adding admin accounts in SQL
Using the sa account to log in.



Any idea what the problem might be?  Some New security is SQL 2000?  Issue
with the upgrade?

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Somewhat OT: Data Conversion

[Alex]

can you get it out as a deleimted file? 
If yes, do it and insert it in Access

On Fri, 5 Oct 2001, Scott Brader wrote:

> One of my clients currently has all of their invoicing and inventory in an
> old Data Ease database. I am doing some new development for them and will
> need to convert the data from the Data Ease formats to Access. I don't need
> to convert the forms, reports, etc. just the data. Does anyone have any
> input on converting the Data Ease data?
> 
> Thanks,
> 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.
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: oracle brings the server down

[Alex]

use maintain connections timeout
also what ODBC driver are you using

On Fri, 5 Oct 2001, FARRAH NG wrote:

> I am having a serious problem with oracle.
> 
> It looks like everytime the CF query make a connection to the tables 
> in the oracle database the connection is not closed.  The numbers of
> connection keep growing till the server is brought down. 
> 
> Does anyone have any idea how to fix this problem ? please give a 
> hand.
> 
> thanks a lot.
> 
> 
> 
> --
> Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
> Sign-up today at http://www.hotvoice.com
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Problem with Stored Procedure

[Matthew W Jones]

Another option would be to add the procparams, in the correct order and set
null="yes" in the procparam

Another option would be to change the stored procedure itself to have the
ones you don't want to pass as the last declarations, and just don't include
the procparams for those

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:12 PM
To: CF-Talk
Subject: RE: Problem with Stored Procedure


No you need the @.

Th problem is with ColdFusion.  IT is a nightmare when passing in proc
params.  you unfortunately nedd to specify them all, and in the correct
order.  I don't know why it asks for the dbvarname fattribute as it doen't
appear to use it.  You have 2 options - either pass in the other params
using the default as the value or uses cfquery and execute the sp using
TRANSACT SQL i.e:

EXEC spGetManagers @Orderby="Last", @ErrorStatus OUT etc...

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: 05 October 2001 17:36
To: CF-Talk
Subject: Re: Problem with Stored Procedure


That is how I had it originally, but in the ColdFusion documentation it
shows it with the @.

Jared
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 6:13 AM
Subject: RE: Problem with Stored Procedure


> I think you need
> DBVARNAME="Orderby"
> instead of
> DBVARNAME="@Orderby"
>
> This might be helpful:
> http://www.defusion.com/articles/index.cfm?ArticleID=56
>
> > -Original Message-
> > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 04, 2001 5:54 PM
> > To: CF-Talk
> > Subject: Problem with Stored Procedure
> >
> >
> > -- Here is code snippet for my stored procedure:
> >
> > CREATE PROCEDURE spGetManagers
> >  @OrderBy nvarchar(20)   = 'LAST',
> >  @OrderType nvarchar(10)  = 'ASC',
> >  @Id  int   = -1,
> >  @ErrorStatus int  OUTPUT,
> >  @ErrorMsg nvarchar(255) OUTPUT
> > AS
> > ...
> >
> > -- Here is CF Code calling the stored procedure:
> >
> >  > password="#request.pass#" procedure="spGetManagers">
> >
> >   > cfsqltype="CF_SQL_VARCHAR">
> >   > variable="ErrorStatus"
> > cfsqltype="CF_SQL_INTEGER">
> >   > cfsqltype="CF_SQL_VARCHAR">
> >  
> >
> > 
> >
> > You'll notice that I'm not providing parameters for
> > @OrderType, nor @Id as
> > they have default values defined in the sp.
> >
> > -- Here is the error message I am getting:
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > parameter '@OrderType'
> > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> >
> > It would appear that it is trying to map my second
> >  to the
> > @OrderType parameter, rather than using Named Notation and
> > mapping it to
> > @ErrorStatus.  My understanding is that by using the
> > dbvarname attribute it
> > would pass to the correct parameter and I wouldn't need to provide a
> >  tag for ALL parameters.
> >
> > 1. Is there something stupid here that I'm missing?
> > 2. Has anyone else had this problem?
> > 3. Should I call it a day, and go home? (yes)
> >
> > Thanks for any help...
> > Jared
> >
> 


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

Multiple Sessions Login issue-- Session takeover

[Stephen Wach]

Hi All

I'm having a problem with multiple sessions getting mixed up, and I'm
wondering if anyone can help, here's what's happening:

One of our clients has a system that is used within a proxy server.  In
their computer lab several users at the time with unique userID's but the
similar functionality use the system.  From time to time the session  get
mixed (i.e taken over).  Here's an example:


user A logs in and views project list
user B logs in and view project list
user A clicks on project list and views page "all projects for user A"
user B clicks on project list and sees page "all projects for user A"  ---it
should be B


So user B has now taken over the session of user A. We now have 2 user A's
accessing the system.


What causes this?  Is it perhaps the proxy server caching at fault?


I've include the session code below and help as to what I'm doing wrong
would be much appreciated.



-A user enter their user name and password
-If the user is valid the session is created as such:








-Now on each page a user accesses after that the following code is included







..code to prompt reentering password






Thanks

Steve


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

how to get the name and value of a field

[Douglas Jordon]

I created a little utility for myself that spits out inserts, updates,
forms, a set of cfparams etc. when passed a dsn and a table name. I
thought I'd try to go one better by enclosing the values in the insert
and update statements in single quotes when necessary. But in order to
do that, I need to access both the column name and the value of a field.
Something like:



  SET index = form.index

SET index =  'form.index'


It breaks because I don't know how to access the value of foo.index.

Does anyone know how to do this? I hope I'm making sense.

TIA,

Doug Jordon





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

Re: Scheduled Tasks in CF Admin

[BT]

How long done is take to run... CF5 requires an additional service be
running for this to happen automatically.
- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 11:24 AM
Subject: Scheduled Tasks in CF Admin


> Hello all
>
> I have created 3 tasks that I want to run on the 1st of each month.
> When I run the pages manually they run fine.  When in CF Admin and I
> run the task, no errors pop up and I get the message the task ran ok, but
> nothing happens.
> I set the first run of the task for testing to be this morning, but
> nothing happened.
> All the tasks do is check for accounts that have not been used in
> over 60/90 days and sends an email to me and other site managers.   I have
> set accounts so that they are over 60/90 days.
>
> What am I missing?
>
> Using CF 5, IIS4, NT 4.0 SP6, Access 2000
>
> Thanks for any suggestions
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF and Linux - anyone? Anyone? Bueller?

[Scott Weikert]

We're a CF shop and we're pondering the idea of trying to ditch Windoze as
much as possible, if not entirely, on the development/production server
environments. Obviously the choices are CF on Linux, probably running Oracle
and Access DBs (if, indeed, Access DBs still function properly as far as
fielding queries, etc. under Linux, when the file is present in the Linux
filesystem and a datasource pointed at it).

I'd like to hear from some folks out there in CF-Talkland who've bit the
bullet and have put CF under Linux into 'real' use - i.e. production sites,
etc. Also would like to hear what you've done as far as the DB goes - which
ones you've used, good/bad things about each, etc.

Replies off-list, if you would, please.

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

CF Grid and CF 5

[John Anderson]

We have an app that uses cfgrid on Solaris,  installed patches from
allaire

Some people are having trouble getting the grid to initialize.  Each person
is running ie 5.  We had them upgrade their java vm and nothing seems to
work.

All was well with cf 4.5 ?

Has anyone seen this before?

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

RE: Problem with Stored Procedure

[Matthew W Jones]

The @ is correct, but as you are using sql server, it doesn't matter.
You need to specify all of the parameters for your stored procedure, in the
correct order.

With sql server, they (cfprocparam) MUST be in the correct order, dbvarname
doesn't even matter at all
With Oracle, dbvarname does matter, and the (cfprocparam) order doesn't

you will need to send the ones you are missing with the parameter of
null="yes" (this means that regardless of what you have in the value, you
will still be sending in null)


-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:36 AM
To: CF-Talk
Subject: Re: Problem with Stored Procedure


That is how I had it originally, but in the ColdFusion documentation it
shows it with the @.

Jared
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 6:13 AM
Subject: RE: Problem with Stored Procedure


> I think you need
> DBVARNAME="Orderby"
> instead of
> DBVARNAME="@Orderby"
>
> This might be helpful:
> http://www.defusion.com/articles/index.cfm?ArticleID=56
>
> > -Original Message-
> > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 04, 2001 5:54 PM
> > To: CF-Talk
> > Subject: Problem with Stored Procedure
> >
> >
> > -- Here is code snippet for my stored procedure:
> >
> > CREATE PROCEDURE spGetManagers
> >  @OrderBy nvarchar(20)   = 'LAST',
> >  @OrderType nvarchar(10)  = 'ASC',
> >  @Id  int   = -1,
> >  @ErrorStatus int  OUTPUT,
> >  @ErrorMsg nvarchar(255) OUTPUT
> > AS
> > ...
> >
> > -- Here is CF Code calling the stored procedure:
> >
> >  > password="#request.pass#" procedure="spGetManagers">
> >
> >   > cfsqltype="CF_SQL_VARCHAR">
> >   > variable="ErrorStatus"
> > cfsqltype="CF_SQL_INTEGER">
> >   > cfsqltype="CF_SQL_VARCHAR">
> >  
> >
> > 
> >
> > You'll notice that I'm not providing parameters for
> > @OrderType, nor @Id as
> > they have default values defined in the sp.
> >
> > -- Here is the error message I am getting:
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > parameter '@OrderType'
> > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> >
> > It would appear that it is trying to map my second
> >  to the
> > @OrderType parameter, rather than using Named Notation and
> > mapping it to
> > @ErrorStatus.  My understanding is that by using the
> > dbvarname attribute it
> > would pass to the correct parameter and I wouldn't need to provide a
> >  tag for ALL parameters.
> >
> > 1. Is there something stupid here that I'm missing?
> > 2. Has anyone else had this problem?
> > 3. Should I call it a day, and go home? (yes)
> >
> > Thanks for any help...
> > Jared
> >
> 

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

oracle brings the server down

[FARRAH NG]

I am having a serious problem with oracle.

It looks like everytime the CF query make a connection to the tables 
in the oracle database the connection is not closed.  The numbers of
connection keep growing till the server is brought down. 

Does anyone have any idea how to fix this problem ? please give a 
hand.

thanks a lot.



--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Template encryption

[Larzz]

try cfencrypter at www.iz-net.com

Jason Larson

-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:33 AM
To: CF-Talk
Subject: Template encryption


I'm looking for a more secure method of encoding
templates than cfencode currently provides.

Does anyone on the list have any recommendations?
Are there alternatives?

TIA

Tristram Charnley


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

Re: unknown fields...

[Jeffry Houser]

  I'm a bit confused.
  Do you have access to the page that people are submitting the form to?
  The form scope in a ColdFusion page is stored as a structure, so you 
could just loop over the structure to find out all the form fields.

  Do you know where people are submitting the form from?  Can't you just do 
a view source to see it?  If 20,000+ people are submitting info, the form 
has gotta be somewhere obvious.

At 12:01 PM 10/05/2001 -0400, you wrote:
>Here's an odd scenario we have... haven't ever seen a need to do
>this... wondering what everyone recommends...
>
>We have a site that is defunct but still gets a massive number of
>submissions per day directly to the website... To the tune of 20,000+
>per day...
>
>Lots of people have automated leads submission software that beams
>information off to a page that use to have a form there.. Funny thing
>is we have no idea of what people are sending over and no idea of the
>form fields...
>
>so the question is how would you go about 1. determining the fields, 2.
>Writing a database to store the fields and any information that isn't
>provided.
>
>Unusual I say :)
>
>-paris
>
>Paris Lundis
>[finding the future in the past, passing the future in the present]
>[connecting people, places and things]
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Can I use my Outlook address book as a data source?

[Larzz]

Check out CFComet (http://www.cfcomet.com/cfcomet/outlook/), This might get
you started.

Jason Larson


-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:01 AM
To: CF-Talk
Subject: Can I use my Outlook address book as a data source?


Can I use my outlook Address Book as a data source for a cfmail
template?

If so, can someone give me a little direction in how to accomplish this.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.

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

Re: How to find out the page to send 'em back to

[Jochem van Dieten]

> If you want I can send a code example tonight.


Code is below (does this list accept attachments?). This code still is 
based on session variables, but that should be easy to solve.
If the user needs to log in an HTTP statuscode 401 is send. This results 
in a browser popup. When the user submits username&password these are 
send as the HTTP header "authorization" with the form 
ToBase64(username:password).

I would recommend reading the first 2 chapters of RFC 2617 for 
background info (5 pages).


Have fun.

Jochem














variables.dsn = "login";
variables.dsn_username = "";
variables.dsn_password = "";
variables.dsn_usertable = "users";
variables.realmname = "Login application";








if (IsDefined("session.user")) {
request.user = Duplicate(session.user);
variables.showloginform = FALSE;
}




























SELECT  *
FROM#variables.dsn_usertable#
WHERE   #variables.dsn_usertable#.UserName = 
AND #variables.dsn_usertable#.Password = 





variables.user = StructNew();
for (i = 1 ; i LTE ListLen(qUser.ColumnList) ; i = i + 
1)

"variables.user.#ListGetAt(qUser.ColumnList,i)#" = Evaluate("qUser." & 
ListGetAt(qUser.ColumnList,i));



session.user = Duplicate(variables.user);



























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

Re: Url as Data Source

[Wjreichard]

In a message dated 10/5/01 1:02:36 PM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:


> 

As a datasource?

A URL can point to a program on a server and that program 
(cfm/asp/cgi/perl/etc) can create data in many formats and return it to the 
browser.

I don't know what you want to do ... but with MS-SQL 2K you can set up a 
virtual root to be accessed via a URL. The SQL 2K server will send back XML 
data or information translated into some other form like HTML by using XSL.

Or if you are refferring to a DSN ...  you could send datasource connection 
information in a URL and dynamically connect to a database on the serverside
 
Create a DSN-less connection.

Access = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\db.mdb"
MSSQL = "Driver={SQL Server};Server=(local);UID=sa;PWD="

Cheers,
Bill


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

Re: Can anyone "Translate" this?

[Julia Green]

You're creating a table called content.  The Primary Key is called
catid which can be an integer of up to 10 characters.  There is no 0
for the primary ID.  That's about where I get offI've never seen
so many KEYs in a MYSQL statement...

Please refer to www.mysql.com

Their documentation is pretty good...

Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box 279
Watertown MA  02471-0279
Email:  [EMAIL PROTECTED]
http://www.juliagreen.com
Phone:  617-926-3413
Fax:  617-812-5935


- Original Message -
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 1:55 PM
Subject: Can anyone "Translate" this?


> I have a mySQL CREATE script that I want to run on MS-SQL 2000.
> Can anyone let me know how to "translate" this?
>
> CREATE TABLE content (
>   catid mediumint(10) unsigned NOT NULL default '0',
>   link text,
>   link1 text,
>   link_count smallint(5) unsigned default NULL,
>   link_total int(6) unsigned default NULL,
>   symlinkfarm enum('Y','N') NOT NULL default 'N',
>   PRIMARY KEY  (catid),
>   KEY link_total (link_total),
>   KEY symlinkfarm (symlinkfarm),
>   KEY link_count (link_count)
> ) TYPE=MyISAM;
>
> Michael.
>
>
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: E-commerce

[Owens, Howard]

The following article was very helpful to me:

http://www.allaire.com/Handlers/index.cfm?ID=18894&Method=Full&Cache=Off

I just completed a shopping cart based in part on this.

I used session variables to allow the adding and removal of items from the
cart (this article doesn't cover session variables).  

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Mike Tangorre [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 04, 2001 8:01 PM
> To:   CF-Talk
> Subject:  E-commerce
> 
> Hi everyone.
> I am trying to elarn how to create a simple E-commerce site (for 
> practice purposes).
> I have no experience with this yet and could use some pointers.
> 
> What is the est way to store information when the user wants to add 
> something to their basket?
> I was thinking about using a structure of arrays, or a structure of 
> lists... or just arrays.. im not really sure what is easiest to work 
> with for a novice?
> 
> Does anyone know some online examples with code that I could study from?
> Should the cart be stored as a session var?
> 
> Any help would be appreciated.
> 
> Thanks 
> 
> Mike
> 
> ===
> Michael T. Tangorre
> Web Applications Developer
> 
> Alfred University Webteam Slave  :-)
> [EMAIL PROTECTED]
> AIM: CrazyFlash4===
> "Friends don't let friends code before
> coffee!"===
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL and Inline images

[Jochem van Dieten]

Leon Oosterwijk wrote:

> All, 
> 
> I want to send an Email using Cfmail that has images inline. That means, I
> want someone to get an Email with an HTML format that has images in it that
> will be view-able in this E-mail even if the user if offline. I used to have
> this solution working in PERL. In which case I merely send a flat-text file
> that had the MIME-encoded graphics in the bottom of the E-mail. I'm
> wondering if it is possible to do the same on Cold Fusion. 


Try http://jochem.vandieten.net/coldfusion/customtags/

The solution provided is buggy, but if your Perl code is robust I am 
sure you can patch this. Alternatively, send me your Perl solution 
offlist. (Only if it is documented/commented and I can rip from it (next 
version will be BSD license) so I can fix the transfer-encoding problems 
I keep running into.)

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

RE: Url as Data Source

[Mark Warrick]

If you're talking about setting up a remote ODBC connection to something
like SQL server, then yes, so long as that domain name maps to a specific IP
address, you can use it in your connection string.

Is that what you meant?

---mark

=
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160
AIM: markwarric
Yahoo: Serengeti
=


-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 9:26 AM
To: CF-Talk
Subject: Url as Data Source


Is it possible to use a url as a datasource (newbie question)




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

Re: unknown fields...

[Jochem van Dieten]

Paris Lundis wrote:

> 
> so the question is how would you go about 1. determining the fields, 2. 
> Writing a database to store the fields and any information that isn't 
> provided.


Forms are a structure. Can't you WDDX the structure and dump it into one 
database field (if that is what you mean)?

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

RE: Problem with Stored Procedure

[Andy Ewings]

No you need the @.

Th problem is with ColdFusion.  IT is a nightmare when passing in proc
params.  you unfortunately nedd to specify them all, and in the correct
order.  I don't know why it asks for the dbvarname fattribute as it doen't
appear to use it.  You have 2 options - either pass in the other params
using the default as the value or uses cfquery and execute the sp using
TRANSACT SQL i.e:

EXEC spGetManagers @Orderby="Last", @ErrorStatus OUT etc...

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: 05 October 2001 17:36
To: CF-Talk
Subject: Re: Problem with Stored Procedure


That is how I had it originally, but in the ColdFusion documentation it
shows it with the @.

Jared
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 6:13 AM
Subject: RE: Problem with Stored Procedure


> I think you need
> DBVARNAME="Orderby"
> instead of
> DBVARNAME="@Orderby"
>
> This might be helpful:
> http://www.defusion.com/articles/index.cfm?ArticleID=56
>
> > -Original Message-
> > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 04, 2001 5:54 PM
> > To: CF-Talk
> > Subject: Problem with Stored Procedure
> >
> >
> > -- Here is code snippet for my stored procedure:
> >
> > CREATE PROCEDURE spGetManagers
> >  @OrderBy nvarchar(20)   = 'LAST',
> >  @OrderType nvarchar(10)  = 'ASC',
> >  @Id  int   = -1,
> >  @ErrorStatus int  OUTPUT,
> >  @ErrorMsg nvarchar(255) OUTPUT
> > AS
> > ...
> >
> > -- Here is CF Code calling the stored procedure:
> >
> >  > password="#request.pass#" procedure="spGetManagers">
> >
> >   > cfsqltype="CF_SQL_VARCHAR">
> >   > variable="ErrorStatus"
> > cfsqltype="CF_SQL_INTEGER">
> >   > cfsqltype="CF_SQL_VARCHAR">
> >  
> >
> > 
> >
> > You'll notice that I'm not providing parameters for
> > @OrderType, nor @Id as
> > they have default values defined in the sp.
> >
> > -- Here is the error message I am getting:
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > parameter '@OrderType'
> > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> >
> > It would appear that it is trying to map my second
> >  to the
> > @OrderType parameter, rather than using Named Notation and
> > mapping it to
> > @ErrorStatus.  My understanding is that by using the
> > dbvarname attribute it
> > would pass to the correct parameter and I wouldn't need to provide a
> >  tag for ALL parameters.
> >
> > 1. Is there something stupid here that I'm missing?
> > 2. Has anyone else had this problem?
> > 3. Should I call it a day, and go home? (yes)
> >
> > Thanks for any help...
> > Jared
> >
> 

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

RE: Url as Data Source

[Janine Jakim]

The url of the database should go under cfadmin when you name your database.
in your apps pg make it generic 
Then in your pages when you make your queries your datasource will always be
#Request.DSN#
Later on if you change to a different database you will only have to make
the change in the apps page

-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:26 PM
To: CF-Talk
Subject: Url as Data Source


Is it possible to use a url as a datasource (newbie question)

 


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

RE: CFMAIL and Inline images

[Philip Arnold - ASP]

> I want to send an Email using Cfmail that has images inline. That means, I
> want someone to get an Email with an HTML format that has images
> in it that
> will be view-able in this E-mail even if the user if offline. I
> used to have
> this solution working in PERL. In which case I merely send a
> flat-text file
> that had the MIME-encoded graphics in the bottom of the E-mail. I'm
> wondering if it is possible to do the same on Cold Fusion.

Instead of bloating the email with images, why not send it in HTML format
and http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can I use my Outlook address book as a data source?

[Larry Juncker]

Can I use my outlook Address Book as a data source for a cfmail
template?

If so, can someone give me a little direction in how to accomplish this.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF Two Selected TAG

[Dennis Powers]

Aaron,

Which version of the tag are you using?  The version I have doesn't support
the Default1 & 2 attributes.  Can you point me to a link where I can
download the tag you are using?


Best regards,

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

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 8:06 AM
To: CF-Talk
Subject: Re: CF Two Selected TAG

With the Default1 and Default2 attributes.  I used to use the following
for it and never ran into a problem.











I set the variables at the top of my page in a switch/case, the default
values for when the form is in "input" mode are the following:

CauseType1  =   "";
SubCause1   =   "";
CauseType2  =   "";
SubCause2   =   "";

Then if it is in "error" or "edit" modes, I set them to equal whichever
ID's I need them to be.

Snipe - 

On Thu, 4 Oct 2001, David Boyd wrote:

> Hi,
>
> Does anyone know how to preselect values using the CF two selected tag?
>
>
> Cheers.
>
>
>

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

Re: Problem with Stored Procedure

[Jared Stark]

That is how I had it originally, but in the ColdFusion documentation it
shows it with the @.

Jared
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 6:13 AM
Subject: RE: Problem with Stored Procedure


> I think you need
> DBVARNAME="Orderby"
> instead of
> DBVARNAME="@Orderby"
>
> This might be helpful:
> http://www.defusion.com/articles/index.cfm?ArticleID=56
>
> > -Original Message-
> > From: Jared Stark [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 04, 2001 5:54 PM
> > To: CF-Talk
> > Subject: Problem with Stored Procedure
> >
> >
> > -- Here is code snippet for my stored procedure:
> >
> > CREATE PROCEDURE spGetManagers
> >  @OrderBy nvarchar(20)   = 'LAST',
> >  @OrderType nvarchar(10)  = 'ASC',
> >  @Id  int   = -1,
> >  @ErrorStatus int  OUTPUT,
> >  @ErrorMsg nvarchar(255) OUTPUT
> > AS
> > ...
> >
> > -- Here is CF Code calling the stored procedure:
> >
> >  > password="#request.pass#" procedure="spGetManagers">
> >
> >   > cfsqltype="CF_SQL_VARCHAR">
> >   > variable="ErrorStatus"
> > cfsqltype="CF_SQL_INTEGER">
> >   > cfsqltype="CF_SQL_VARCHAR">
> >  
> >
> > 
> >
> > You'll notice that I'm not providing parameters for
> > @OrderType, nor @Id as
> > they have default values defined in the sp.
> >
> > -- Here is the error message I am getting:
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Formal
> > parameter '@OrderType'
> > was defined as OUTPUT but the actual parameter not declared OUTPUT.
> >
> > It would appear that it is trying to map my second
> >  to the
> > @OrderType parameter, rather than using Named Notation and
> > mapping it to
> > @ErrorStatus.  My understanding is that by using the
> > dbvarname attribute it
> > would pass to the correct parameter and I wouldn't need to provide a
> >  tag for ALL parameters.
> >
> > 1. Is there something stupid here that I'm missing?
> > 2. Has anyone else had this problem?
> > 3. Should I call it a day, and go home? (yes)
> >
> > Thanks for any help...
> > Jared
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Possible bug with IIS and CFHTTP (CF4.5) ?

[Alex Santantonio]

Have you installed CF 4.5.1 SP2 yet?  I know we had a good deal of problems
with CF 4.5 until we installed SP 2.  Just a quick idea.

Alex Santantonio

-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 12:12 AM
To: CF-Talk
Subject: Possible bug with IIS and CFHTTP (CF4.5) ?

Hi all,
 sometime after IIS was patched recently on our host's server
something went awry with CFHTTP... it's hard to explain... basically, when
a CFHTTPPARAM  value contains an ampersand ('&'), and the CFHTTP is POSTed
to the CF server, the receiving CF template (fusebox, but this applies to
standard templates too) gets very confused abut field names, and values,
specifically, it takes the text in the _VALUE_ after the ampersand and
thinks that is a field name.  Obviously this is bad.  I have tested this
with our systems... here are the results...

 Apache & CF5 = normal
 IIS 4 (latest patch level) & CF4.5 = broken
 IIS 5 (latest patch level) & CF5= normal

Now I initially thought this would be an IIS problem, because I'm not fond
of IIS really.  But I setup a standard form which did the same thing as
CFHTTP, that is posted the data to the receiving template, and it worked OK
where CFHTTP didn't.

I'm sure that the problem hasn't ALWAYS existed with IIS and 4.5 because I
have only been made aware of it now as there have been 3 failures of this
particular bit of code in the last 2 weeks and  no similar failures in the
8 months since it was brought online.  Anybody got any idea what could be
the problem, or more importantly how I can work around it ??  Here is my
test code (two files, testPOST.cfm and testPOST2.cfm, change the
LocationOfTestPost2 in testPOST.cfm as appropriate)...

== testPOST.cfm







 Untitled



 http://put.your.server.here/testPOST2.cfm";>

 
 
 AccountDetails.PrimaryDomain = "mrd.co.nz";
 AccountDetails.Q_Hosting = QueryNew("blah,foo");
 AccountDetails.DoHoDiskSpaceUnits = 0;
 AccountDetails.Q_Options = QueryNew("blah,foo");
 // These are incase the user ordered the secure system option
 AccountDetails.SSAOptions = StructNew();

 AccountDetails.SSAOptions.SSAContactName = "Blog Bar &  Foo Bar";
 AccountDetails.SSAOptions.SSAContactPhone = "123 4567";
 AccountDetails.SSAOptions.SSAContactEmail =
"[EMAIL PROTECTED]";
 AccountDetails.SSAOptions.SSAUsername = "xxyyzz";
 AccountDetails.SSAOptions.SSAPassword = "xxzzyy";
 AccountDetails.SSAOptions.SSACustomerNumber = "DW-00631-C";
 




 
 http://www.yahoo.com";>
 
 
 
 
 
 

#CFHTTP.FileContent#


 
 
 http://www.yahoo.com";>
 
 
 
 
 
 

 
 





== testPOST2.cfm







 Untitled





#FORM.FieldNames#


#FORM.AccountDetails#







--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential
and may be legally privileged. If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited. If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


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

Url as Data Source

[ronmyers]

Is it possible to use a url as a datasource (newbie question)

 

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

unknown fields...

[Paris Lundis]

Here's an odd scenario we have... haven't ever seen a need to do 
this... wondering what everyone recommends...

We have a site that is defunct but still gets a massive number of 
submissions per day directly to the website... To the tune of 20,000+ 
per day...

Lots of people have automated leads submission software that beams 
information off to a page that use to have a form there.. Funny thing 
is we have no idea of what people are sending over and no idea of the 
form fields...

so the question is how would you go about 1. determining the fields, 2. 
Writing a database to store the fields and any information that isn't 
provided.

Unusual I say :)

-paris

Paris Lundis
[finding the future in the past, passing the future in the present]
[connecting people, places and things]

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

RE: E-commerce

[Rich Tretola]

I used the webmonkey tutorial to create a storefront business as well.  It
is very basic, but lets you see where you need to add the things you want.

Rich
http://www.shoppalstores.com


-Original Message-
From: Development Team [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 11:22 AM
To: CF-Talk
Subject: Re: E-commerce


I'll second the motion on the web monkey tutorial.

http://hotwired.lycos.com/webmonkey/99/49/index4a.html

A couple of years ago, for our e-commerce site we had no choice but to build
one.  A standard out of the box shopping cart was nowhere near equipped for
the extras that we were going to need.. That tutorial help us lay the ground
work and learn the in's and outs of what we needed to do...

Jeff




> "Mike Tangorre" <[EMAIL PROTECTED]> wrote in message
> 023f01c14d4a$02873aa0$72a35495@tangormt">news:023f01c14d4a$02873aa0$72a35495@tangormt...
> > Hi everyone.
> > I am trying to elarn how to create a simple E-commerce site (for
> > practice purposes).
> > I have no experience with this yet and could use some pointers.
> >
> > What is the est way to store information when the user wants to add
> > something to their basket?
> > I was thinking about using a structure of arrays, or a structure of
> > lists... or just arrays.. im not really sure what is easiest to work
> > with for a novice?
> >
> > Does anyone know some online examples with code that I could study from?
> > Should the cart be stored as a session var?
> >
> > Any help would be appreciated.
> >
> > Thanks
> >
> > Mike
> >
> > ===
> > Michael T. Tangorre
> > Web Applications Developer
> >
> > Alfred University Webteam Slave  :-)
> > [EMAIL PROTECTED]
> > AIM: CrazyFlash4===
> > "Friends don't let friends code before
> coffee!"===
> >
> >
>
>

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

RE: columnlist

[Nate Smith]

The original poster wanted the columns in the order specified in the
database.

So your post of:

>> Or 
>>
>>  Queryname.Columnlist 
>>
>> Jerry Staple 

would not work. The only way to do that, to the best of my current
knowledge, is to query the system tables.

-
Nate Smith, 
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED] 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMAIL and Inline images

[Leon Oosterwijk]

All, 

I want to send an Email using Cfmail that has images inline. That means, I
want someone to get an Email with an HTML format that has images in it that
will be view-able in this E-mail even if the user if offline. I used to have
this solution working in PERL. In which case I merely send a flat-text file
that had the MIME-encoded graphics in the bottom of the E-mail. I'm
wondering if it is possible to do the same on Cold Fusion. 

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

RE: How to find out the page to send 'em back to

[Kola Oyedeji]

I would love to have a look at that as well.


Cheers

Kola

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:11 PM
To: CF-Talk
Subject: RE: How to find out the page to send 'em back to


Yes please!  This seems such a simple answer.  I had never thought of that
approach.I would be very grateful if you would send me that code
example.

Thanks!

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


When you want a user to log in don't send him to a form or something.
Just use cfheader to send a HTTP 401 (or was it 403?) to the user.
Include some realm info as per RFC 2617 and make the authentication type
basic. User gets a popup window which asks for authentication info. Upon
completion of username and password the browser simply repeats the
original HTTP reqeust, but adds a header with the authentication info.
On the server, catch the header, extract the username and password and
set a client variable (your specs above leave the possibility of using
client variables and storing them in your own database).

If you want I can send a code example tonight.


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

RE: Storing Credit Cards

[Jeff Stone]

Sorry, fellas.  I am a moron listening to a Tech Support rep at
Authorize.net.  Of course, you need the credit card number again.  As I
scrolled down further into the development guide, it shows that this number
is required on every transaction.  It would be pretty awesome if it didn't
have to be there, but I guess if that were the case everyone would be using
it. :-)

It appears that Authorize.net does store the credit card number for you to
retrieve, but I was told it is just a manual process as of now.  From what I
read, you can login to your Authorize.net account and pass the last
transaction id of the customer.  Supposedly, by looking at the last
transaction id, you can get the credit card number.  I dunno if this is
true, because I don't have an account with them yet.  Maybe I can CFHTTP to
them and pull the information back, although I'm sure that would really bog
down a server.  I am going to see if I can automate it though, what the
heck.

Sorry again for the quick (and false) statements earlier.
-- Jeff

-Original Message-
From: Jeff Stone [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 10:17 AM
To: CF-Talk
Subject: RE: Storing Credit Cards


All,

I just wanted to thank all of you for giving this thread some attention.
After a little more research and phone calls today to payment gateways, I
believe I have found the answer to my original question.  It appears that
Authorize.Net allows for recurring payments "without" the credit card number
having to be passed every time to the gateway.  Therefore, I should be able
to completely bypass the storing of credit card numbers, which is a huge
relief.  I am sure all of the other payment gateways do this, too, but
Authorize.net is the one I am going to use.

Here is the information from their Developer's Guide that sums up the
solution


--- From Dev Guide ---

Batch processing
Aside from the automated ways of integrating with the system, batches of
transactions can be uploaded to the system for processing. All transactions
contained in the uploaded file are processed in the currently open batch and
are settled with any other transactions pending in that same batch.

One way this capability can be useful is for merchants who collect their
transaction information over the course of the day, and want to upload their
transactions for processing all at one time.

This capability can also be useful for merchants who have recurring
transactions, such as monthly subscription fees. Each month a merchant could
upload a file containing all of their customers' transaction information to
bill their customers for another month.

In addition to being able to upload batches of transactions, the system
allows a merchant to download settlement batches as a file to their own
computer.

--- End Dev Guide ---


The encryption information you all provided was both informative and useful
for another piece of this project.


Thanks again for the help,

Jeff Stone
Stone Grove Design
[EMAIL PROTECTED]


-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 8:36 AM
To: CF-Talk
Subject: Re: Storing Credit Cards


What are the other solutions then?  I agree PGP isn't the only solution.

- Original Message -
From: "Dave Hannum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 5:48 AM
Subject: Re: Storing Credit Cards


> I'm not trying to say that there is anything wrong with PGP (other than
the
> exhorbatant commmercial price) - all I was saying was that if done
properly
> (which all of your arguements against what I have proposed have assumed
that
> sloppy handling of the process is taking place) - there are other
solutions
> that will be reasonably secure.  Face it - any credit cards stored on a
> server are NEVER SAFE!  That's been talked about here time and time again.
>
> Dave
>
> - Original Message -
> From: "Kwang Suh" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 04, 2001 11:36 PM
> Subject: Re: Storing Credit Cards
>
>
> > Oh yes.  I need to add one more thing.  No matter how smart you think
you
> > are, any form of encryption you come up with will suck.  It doesn't
matter
> > how many steps of obfuscation or whatever you put in.  It will still
suck.
> > I used to work with a guy who was a decent cryptography programmer.  He
> says
> > that there are very, very, very few people in the world who can write
> decent
> > encryption schemes.  No offense, but no one on this list is qualified to
> > write encryption schemes.  No one on this list should even have the
> smallest
> > spark of thinking of thinking of writing an encryption scheme.  Use
> someone
> > else's.
> >
> > - Original Message -
> > From: "Kwang Suh" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, October 04, 2001 9:23 PM
> > Subject: Re: Storing Credit Cards
> >
> >
> > > Because, in order to do a valid CC transaction

Scheduled Tasks in CF Admin

[Bruce, Rodney]

Hello all

I have created 3 tasks that I want to run on the 1st of each month.
When I run the pages manually they run fine.  When in CF Admin and I
run the task, no errors pop up and I get the message the task ran ok, but
nothing happens.   
I set the first run of the task for testing to be this morning, but
nothing happened.
All the tasks do is check for accounts that have not been used in
over 60/90 days and sends an email to me and other site managers.   I have
set accounts so that they are over 60/90 days.

What am I missing?

Using CF 5, IIS4, NT 4.0 SP6, Access 2000

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

Re: Somewhat OT: Data Conversion

[John Paitel]

Go to the knowledge base at microsoft.com, and do a search for the specific 
article Q94194. It talks about exporting from DataEase to a format that 
Access can import.

John


At 09:52 AM 10/5/01 -0500, Scott Brader wrote:
>One of my clients currently has all of their invoicing and inventory in an
>old Data Ease database. I am doing some new development for them and will
>need to convert the data from the Data Ease formats to Access. I don't need
>to convert the forms, reports, etc. just the data. Does anyone have any
>input on converting the Data Ease data?
>
>Thanks,
>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.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists