RE: 2007 Web Design Survey
From the point of view of the small business sector and for-hire consulting and design groups, I could see how someone might see cold fusion and web design work as code monkey tasks. But, in your larger, more established IT departments, there are jobs you can only hold with a dozen years of design experience and the ability to work in/with large teams. For that matter, there are analyst and architect level positions which allow companies to recognize the the value of an experienced eye on a problem. Management is an entirely different job requiring minimal technical expertise if you have the intelligence to hire and trust in the strengths of the team you build. Unfortuantely, former techies tend to become poor managers for the very reason that they know too much about the task at hand and often step in to micromanage a solution. I don't think it should come as a surprize that a good number of technical people lack the interpersonal skills and patience for politics it takes to succeed in management. Moreover, many of these same people know this about themselves and choose not to have direct reports. In the end, what we all really do is provide solutions to problems. Young developers tend to live on the bleeding edge of technology solving every problem with an untested, new approach. That's what I'd call a code monkey. Good fortune, Richard Walters -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 10:55 AM To: CF-Talk Subject: Re: 2007 Web Design Survey I happen to know some damn good programmers in their 40's and 50's who are VERY content just being a code monkey. These guys have degrees/experience and could get management positions, but they don't want to. There is nothing wrong with being a worker bee all your life. Bruce Crow T. Robot wrote: I don't see it so much a goal as a natural progression in one's career. Who wants to be a 50-60 year old code monkey? ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Graphing Solutions Beyond CFGraph
Hi list, I am searching for a graphing engine that will allow me to display 2 Y axis, one on the right and one on the left. Ordinarily I am not interested in people trying to peddle non-CF solutions, but I don't think CFGraph is going to help me with this problem. So, if you know a good package, please post a reply. Thanks. Good Fortune, Richard Walters, Internet Application Designer, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137554 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Graphing Solutions Beyond CFGraph
Thanks Bruce, Corda looks like a pretty cool package. Looking through the archives I saw references to ActivePDF, ReportLab, BigFaceLess, and CFXGraphicsServer. Keep the suggestions coming, if for no other reason that people who research this topic later will have a good list to start their decision making process. Thanks all. Good Fortune, Richard Walters [EMAIL PROTECTED] 09/18/03 02:27PM We have been using Corda's PopCharts here at Baylor Health Care System for quite some time, and it has proven to work out great over the enterprise. It has a very robust engine and a fairly intuitive chart builder application. It works with .NET, CF, Java, ASP very well. You can check it out at www.corda.com. HTH Bruce -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 1:20 PM To: CF-Talk Subject: Graphing Solutions Beyond CFGraph Hi list, I am searching for a graphing engine that will allow me to display 2 Y axis, one on the right and one on the left. Ordinarily I am not interested in people trying to peddle non-CF solutions, but I don't think CFGraph is going to help me with this problem. So, if you know a good package, please post a reply. Thanks. Good Fortune, Richard Walters, Internet Application Designer, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137565 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Graphing Solutions Beyond CFGraph
To ammend my own post, The ActivePDF, ReportLab, BigFaceLess.. etc, are all PDF/Print conversion utilities. They really don't address creating a graph. [EMAIL PROTECTED] 09/18/03 02:57PM Thanks Bruce, Corda looks like a pretty cool package. Looking through the archives I saw references to ActivePDF, ReportLab, BigFaceLess, and CFXGraphicsServer. Keep the suggestions coming, if for no other reason that people who research this topic later will have a good list to start their decision making process. Thanks all. Good Fortune, Richard Walters [EMAIL PROTECTED] 09/18/03 02:27PM We have been using Corda's PopCharts here at Baylor Health Care System for quite some time, and it has proven to work out great over the enterprise. It has a very robust engine and a fairly intuitive chart builder application. It works with .NET, CF, Java, ASP very well. You can check it out at www.corda.com. HTH Bruce -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 1:20 PM To: CF-Talk Subject: Graphing Solutions Beyond CFGraph Hi list, I am searching for a graphing engine that will allow me to display 2 Y axis, one on the right and one on the left. Ordinarily I am not interested in people trying to peddle non-CF solutions, but I don't think CFGraph is going to help me with this problem. So, if you know a good package, please post a reply. Thanks. Good Fortune, Richard Walters, Internet Application Designer, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137571 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Re[2]: Preventing user from going back
If the question has turned into: can you secure an application on the client side? the answer is no. If a user has access to the security source code then a way can always be devised to crack it. In my own investigation of this same topic I have concluded that the javascript cache clearing is an iffy solution at best. The problem my own group has involves multiple people with different access permissions using the same public workstation to access patient records. If a medical director logs into our reporting site and views a patient and then logs off, what is to prevent an intern from using the back button to view the samed cached report? Javascript can clear the cache, remove the back button, or force a reload of the page to check permissions. But if javascript is off in the browser, then there is nothing to prevent this. A half-way solution we have yet to implement would be to check and see if javascipt is enabled to complete the login process and then have javascript close the browser window on logout. Placing an icon to the site on the desktop would allow one click access to return to login. But, again, this can be sidestepped. So ultimately the real security will take place in training. In training the doctors, we stress the importance of closing the window after they access patient records. And as backup to this, we keep a server side timestamp of their login purposefully very short to ensure with reasonable accuracy that even if they walk away from the workstation logged in, that trying to continue will re-require login to continue. But if they leave the browser open and javascript is not enabled, then the history is open for back browsing. Unfortunately, in the end we must conclude the obvious: an internet browser in a multi user environment is not an ideal security arangement. Lucky for us, we also have in house applications that access patient records locally and which are far more secure. Further, the pc's themselves are in a secure environment or in clear view of staff. Good Fortune, Richard Walters, Internet Application Designer, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x [EMAIL PROTECTED] 05/30/02 04:01PM and then all someone has to do is use a program to spoof the referrer information and their in. The only thing that you as a web programmer can do without beating your head against the wall is to make sure you qualify all variables passed to the page, check them to make sure they are of the length and type you want and then have error checking to test the values. If you do that, then it doesn't matter where the information is coming. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:54 PM To: CF-Talk Subject: RE: Re[2]: Preventing user from going back The only way I have seen to do this, and it was mentioned by someone earlier, is to only allow for a specific referer. You would use the url to the page that the user 'should' be coming from like this: cfif cgi.HTTP_REFERER is 'my url' Allow the template to process cfelse move them somewhere else either with cflocation or a script /cfif Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:18 PM To: CF-Talk Subject: Re: Re[2]: Preventing user from going back Interesting point. I took it upon myself to test out your question and found that you CAN go back. On Thu, 30 May 2002, Mario Martinez wrote: What if I view the file source, erase all the java script code that is bothering me .Save the file into my local harddisk and run the browser over it and try to going back??? . regards Mario - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 2:18 PM Subject: Re[2]: Preventing user from going back oi Alex!! then you could always do this noscriptmeta refresh../noscript seeing as how most of us develop web applications and not websitesif javascript is disabled, then they don't need to be there.. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 2:07:05 PM, you wrote: A What happens if I disable javascript? A On Thu, 30 May 2002, Critz wrote: oi Mark!! SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- window.history.forward(); file://-- /SCRIPT on the preceding page -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 1:19:09 PM, you wrote:
RE: Back button-refresh
I have never been able to get the Meta Expire to work correctly. Is there a cross browser solution to successfully expire the page cache so you can't hit the back button and return to already rendered pages? I especially wanted to use this to clear the cache after people logout of the application. I'm sure someone has spent the time needed to figure this out. Good Fortune, Richard Walters, Internet Application Designer, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x [EMAIL PROTECTED] 05/23/02 08:38AM You could try this: cfheader name=EXPIRES value=#NOW()# Thank you. Steve Burcham Webmaster - Field Support Team RDO Equipment Co. Phone (701) 239-8755 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 7:17 AM To: CF-Talk Subject: Back button-refresh Can I force a page to refresh when a user hits the back button? If so How?? Thanks __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Macromedia Forums (aka FuseTalk)
Dear MM, Your forums blow. I have tried to log in many times and it seems almost random if I get in. Anyway, I figured I would post something here so you know why I am not going to waste my time trying to tell you about your preview product. If others are having close to the same level of frustration with the forums, you're losing a lot of potentially valuable input. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita 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
Apology
I'd like to apologize for insulting the MM Forums. I'm quite sure I'm mad at something else and was just frustrated by the boards when I really need the time right now. Sorry to vent on the list. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x DaVita Inc. __ 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: cfreport
Don't know if this will help.
http://www.macromedia.com/v1/Handlers/index.cfm?ID=16757Method=Full
There are undocumented properties of the CFReport Tag.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 10:02AM
Hello all,
I am having trouble with the cfreport tag. I'm trying to connect to
an
oracle db, and I have created a dsn using the crystal reports oracle 8
driver, which is verified as working in the cf administrator.
this is what the CF5 docs say:
cfreport report = '/reports/monthlysales.rpt'
{Departments.Department} = 'International'
/cfreport
and then on the same page but different they say:
cfreport report = report_path
orderBy = result_order
username = username
password = password
formula = formula
/cfreport
when i try this:
cfreport report=dailytimesheets.rpt username=cf
password=fusion/cfreport
it can't find the report, even though the cfm and the rpt files are in
the
same directory.
when i do this:
cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt
username=cf password=fusion/cfreport
I get the error:
Error occurred while processing CFREPORT
An unexpected error occurred while using the Crystal Engine.
Error number 692 ocurred (Error in File
D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or
export format.).
My thinking is that the cfdocs are just plain wrong and my syntax is
right..
but I must be missing something.
All help is appreciated.
Ken Beard
__
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: cfreport
More specifically, Crystal now has it's own webserver. So, the best
option seems to be to set up the crystal webserver and then run it in a
frame. I'm not fond of it because it sidesteps site security. Unless
someone out there has a way to integrate it with existing security, I
don't think it's a good way to offer your intellectual property over the
web. Crystal has it's own security framework that might be sufficient,
but I haven't seen a combined framework that passes parameters in a
secure manner between CF applications and CR8.
Oh, if anyone is successfully doing this, please tell me. I am aware
that the class can be accessed using ASP, I'm looking for a Cold Fusion
solution. Maybe someone has a COM object for it, or maybe someone has
figured out some LDAP tricks to keep within the security framework. And
if so, the next step is to move the crystal server to it's own machine
and preserve the security. Crystal's web server is a resource hog.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 10:25AM
nevermind... found this on the crystal reports website
Unfortunately there is currently no integration with Crystal Reports 8
and
the CF report tag. ColdFusion ships with version 5.0 of Crystal Reports
and
Macromedia has released patches to allow version 6 and version 7 to
work
with the CF report tag. As this time there is no fix for Crystal
Reports 8
to work with ColdFusion.
that sucks.
Ken
-Original Message-
From: Ken Beard [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:03 AM
To: CF-Talk
Subject: cfreport
Hello all,
I am having trouble with the cfreport tag. I'm trying to connect to
an
oracle db, and I have created a dsn using the crystal reports oracle 8
driver, which is verified as working in the cf administrator.
this is what the CF5 docs say:
cfreport report = '/reports/monthlysales.rpt'
{Departments.Department} = 'International'
/cfreport
and then on the same page but different they say:
cfreport report = report_path
orderBy = result_order
username = username
password = password
formula = formula
/cfreport
when i try this:
cfreport report=dailytimesheets.rpt username=cf
password=fusion/cfreport
it can't find the report, even though the cfm and the rpt files are in
the
same directory.
when i do this:
cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt
username=cf password=fusion/cfreport
I get the error:
Error occurred while processing CFREPORT
An unexpected error occurred while using the Crystal Engine.
Error number 692 ocurred (Error in File
D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL or
export format.).
My thinking is that the cfdocs are just plain wrong and my syntax is
right..
but I must be missing something.
All help is appreciated.
Ken Beard
__
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: cfreport
CFContent.. hey.. that is a good idea. I thought of calling an asp page
with CFHTTP the same way but it's mildly detestable to NEED to use ASP.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 10:54AM
Rick, I've done exactly this. I created a VB com wrapper to access
the
Crystal Object. Right now, I use the wrapper to pass username,
password,
dbname, servername, and selection formula and then export the report to
a
PDF (other formats are available, but mostly prove unusable :) ).
After the
PDF is generated, I serve it to the user via CFContent. It's kind of
a
convoluted way of doing things, but I didn't care for the crystal
reports
server either.
Marlon
- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 9:38 AM
Subject: RE: cfreport
More specifically, Crystal now has it's own webserver. So, the best
option seems to be to set up the crystal webserver and then run it in
a
frame. I'm not fond of it because it sidesteps site security.
Unless
someone out there has a way to integrate it with existing security,
I
don't think it's a good way to offer your intellectual property over
the
web. Crystal has it's own security framework that might be
sufficient,
but I haven't seen a combined framework that passes parameters in a
secure manner between CF applications and CR8.
Oh, if anyone is successfully doing this, please tell me. I am
aware
that the class can be accessed using ASP, I'm looking for a Cold
Fusion
solution. Maybe someone has a COM object for it, or maybe someone
has
figured out some LDAP tricks to keep within the security framework.
And
if so, the next step is to move the crystal server to it's own
machine
and preserve the security. Crystal's web server is a resource hog.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 10:25AM
nevermind... found this on the crystal reports website
Unfortunately there is currently no integration with Crystal Reports
8
and
the CF report tag. ColdFusion ships with version 5.0 of Crystal
Reports
and
Macromedia has released patches to allow version 6 and version 7 to
work
with the CF report tag. As this time there is no fix for Crystal
Reports 8
to work with ColdFusion.
that sucks.
Ken
-Original Message-
From: Ken Beard [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:03 AM
To: CF-Talk
Subject: cfreport
Hello all,
I am having trouble with the cfreport tag. I'm trying to connect to
an
oracle db, and I have created a dsn using the crystal reports oracle
8
driver, which is verified as working in the cf administrator.
this is what the CF5 docs say:
cfreport report = '/reports/monthlysales.rpt'
{Departments.Department} = 'International'
/cfreport
and then on the same page but different they say:
cfreport report = report_path
orderBy = result_order
username = username
password = password
formula = formula
/cfreport
when i try this:
cfreport report=dailytimesheets.rpt username=cf
password=fusion/cfreport
it can't find the report, even though the cfm and the rpt files are
in
the
same directory.
when i do this:
cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt
username=cf password=fusion/cfreport
I get the error:
Error occurred while processing CFREPORT
An unexpected error occurred while using the Crystal Engine.
Error number 692 ocurred (Error in File
D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL
or
export format.).
My thinking is that the cfdocs are just plain wrong and my syntax is
right..
but I must be missing something.
All help is appreciated.
Ken Beard
__
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: cfreport
I'm skeptical that list supports attachements, but if you're willing,
I'd love a copy. Copy me. :)
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 11:11AM
Sure, but I'm off work today so I can't get to the source right now,
and
since there's no documentation, you'd probably want that too :-)
Does this list support attachments?
Ken Beard wrote:
Marlon,
Any chance you'd share that?
Ken
-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:55 AM
To: CF-Talk
Subject: Re: cfreport
Rick, I've done exactly this. I created a VB com wrapper to access
the
Crystal Object. Right now, I use the wrapper to pass username,
password,
dbname, servername, and selection formula and then export the report
to a
PDF (other formats are available, but mostly prove unusable :) ).
After the
PDF is generated, I serve it to the user via CFContent. It's kind of
a
convoluted way of doing things, but I didn't care for the crystal
reports
server either.
Marlon
- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 9:38 AM
Subject: RE: cfreport
More specifically, Crystal now has it's own webserver. So, the best
option seems to be to set up the crystal webserver and then run it in
a
frame. I'm not fond of it because it sidesteps site security.
Unless
someone out there has a way to integrate it with existing security,
I
don't think it's a good way to offer your intellectual property over
the
web. Crystal has it's own security framework that might be
sufficient,
but I haven't seen a combined framework that passes parameters in a
secure manner between CF applications and CR8.
Oh, if anyone is successfully doing this, please tell me. I am
aware
that the class can be accessed using ASP, I'm looking for a Cold
Fusion
solution. Maybe someone has a COM object for it, or maybe someone
has
figured out some LDAP tricks to keep within the security framework.
And
if so, the next step is to move the crystal server to it's own
machine
and preserve the security. Crystal's web server is a resource hog.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 05/17/02 10:25AM
nevermind... found this on the crystal reports website
Unfortunately there is currently no integration with Crystal Reports
8
and
the CF report tag. ColdFusion ships with version 5.0 of Crystal
Reports
and
Macromedia has released patches to allow version 6 and version 7 to
work
with the CF report tag. As this time there is no fix for Crystal
Reports 8
to work with ColdFusion.
that sucks.
Ken
-Original Message-
From: Ken Beard [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 10:03 AM
To: CF-Talk
Subject: cfreport
Hello all,
I am having trouble with the cfreport tag. I'm trying to connect to
an
oracle db, and I have created a dsn using the crystal reports oracle
8
driver, which is verified as working in the cf administrator.
this is what the CF5 docs say:
cfreport report = '/reports/monthlysales.rpt'
{Departments.Department} = 'International'
/cfreport
and then on the same page but different they say:
cfreport report = report_path
orderBy = result_order
username = username
password = password
formula = formula
/cfreport
when i try this:
cfreport report=dailytimesheets.rpt username=cf
password=fusion/cfreport
it can't find the report, even though the cfm and the rpt files are
in
the
same directory.
when i do this:
cfreport report=D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt
username=cf password=fusion/cfreport
I get the error:
Error occurred while processing CFREPORT
An unexpected error occurred while using the Crystal Engine.
Error number 692 ocurred (Error in File
D:\Inetpub\wwwroot\kenbeard\dailytimesheets.rpt: Invalid export DLL
or
export format.).
My thinking is that the cfdocs are just plain wrong and my syntax is
right..
but I must be missing something.
All help is appreciated.
Ken Beard
__
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: [admin] List status - A CHALLENGE
Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: [admin] List status - A CHALLENGE
What are you afraid of: terrorists, hurricaines, train derailments, voting scandals, tourist taxes, water shortages, impossible traffic, lightning, speaking spanish, Jimmy Buffet, or sunburn? Certainly there's nothing wrong with Florida that Jeb Bush or Janet Reno can't fix. It helps if you say that over and over. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 02:07PM No way, everything happens in Florida, time to share the wealth. What about Buffalo, NY? -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:47 PM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Perhaps we should start planning the CF-Talk Expo here in Florida? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/15/02 01:36PM We get a free gift with our donation, but we have already been consuming that gift. Kevin [EMAIL PROTECTED] 05/14/02 10:13AM Does this mean, that for a donation, we can get a t-shirt, coffee mug, or license plate with a 'Swirly Thing' on it? -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:08 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE Yeah - I usually pledge along about Wednesday, just so they will get back to the news ha. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 11:43 AM To: CF-Talk Subject: RE: [admin] List status - A CHALLENGE I was just going to say that this strategy works great for NPR: Our goal is $5000 this hour, and we've got $3000. C'mon, call us! -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:38 AM To: CF-Talk Subject: Re: [admin] List status - A CHALLENGE I think you misread my intentions. I figured that if someone could see that the goal was not yet reached then they would be more inclined to donate. People are sometimes apathetic and need to see that a goal was not reached. If, say, someone waits a few weeks before donating they may throw in 10 bucks because they may figure that there were enough donations. If, however, they could see that the donations were a few thousand short then they may be inclined to donate $100. Regards, Howie - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 12:30 PM Subject: RE: [admin] List status - A CHALLENGE Don't agree.. (a first for me and you Howie! grin) Michael will put to good use whatever is there, and I'm sure will report on what's left after his decisions are made about how to handle things, and what he's put in place. Knowing him, he'll probabaly ask the group. But I trust Michael and his decisions. Don't get me wrong.. I don't think the numbers should be hidden.. And I have NO doubt that Michael is above that. However, ANYTHING he receives from us will be well worth it, for the priceless information we gain from this list, and ultimately his support. Let him handle it, and let him report to us what's there afterwards, if anything. If anything's left, we can all discuss/vote on what to do with it.. I'm sure. Just my .02 __ 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: [admin] List status
Being able to search the archives might even be worth a donation to many of us. I know it would help me out on occasion. It would greatly reduce the number of emails I save in my CF Archive folder. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/14/02 03:42PM Wow, searching the archives would be 'the heat'! how can we help to get the sql box online? Tony Gruen __ 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: Geographical redundancy?
BoardWatch Magazine publishes a summary of country-wide backbone providers once or twice a year. If you look specifically for this publication you can get a good overview of which networks connect to which cities and NAPs (MAE-East is a NAP). Personally, I don't think you're really looking for a solution like this in the end. You might want to consider pooling data locally at your collection centers and, as someone already mentioned, replicate this data to a central source. Then, if you choose to use a web interface for collection and display of this data, you can have multiple webservers, each local to the pooled data, and a master server residing over the central data. With this model, the central repository's reports could conceivably be impaired by net traffic, but the local centers, where the data is entered, will remain up to date and functioning regardless of disasters in other locations or loss of connectivity. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/12/02 01:16PM Exodus is now owned by Cable Wireless. C W also bought Digital Island, so they have some great technology for distribute web sites. Global Crossing is another Enron, so you best stay away. AboveNet, which was always owned by Metromedia Fiber Network (MFN); has been sucked back into the parent company. MFN has had and continues to have one of the best IP networks in the world. Their claim to fame is also that they run the MAEs. UUnet has a great network, but they are part of WorldCom, which is having serious trouble theses days. Savvis has some really nice offerings and has weathered the downturn thanks to their monopoly on finical services networks that their parent company Bridge gave them. Level3 Communications also has some good stuff these days. There are plenty of other ISPs and hosting providers, but they really can't compete with the above list. -Matt -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 9:59 AM To: CF-Talk Subject: RE: Geographical redundancy? You'll need to rely on one of the larger ISP/hosting providers for this, it won't be cheap. Exodus (are they still around?), is an example of a well known provider that can accommodate you. Their NOC's (network operation center) are notoriously renowned as being the biggest and the baddest (including guards armed with AR15's back in the dot com hay days). You'll also want to do a little research on your hosting provider's providers - they should have redundant uplinks to at least two of the larger pipes (abovenet, UUNet, gblX, etc). They should provide you with evidence of their uptime (MRTG charting) - as you see downtimes for one routing interface, there should be significant jumps for the others to show that they're in fact picking up the slack. This is what I believe the CCIE certifications were meant to teach people - becoming conversant with the various protocols (OSPF, RIP, HSRP, insert TLA here) and how to configure them to make the Beast happy. As for keeping your application/database transactions synchronized, that could fill a book in it's own right. You're better off dumping the responsibility onto somebody that's done it before. When everything is set up, you'll want to document and test a disaster recovery plan. Adam. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 11, 2002 1:05 PM To: CF-Talk Subject: Geographical redundancy? I have to put together a proposal for a medical office management application which will be used in an ASP (application service provider - not the MS language:) model.. one of the requirements is that the application has to be hosted in such a way that a major disaster (natural or otherwise) in 1 location can't cause the loss of any data, and only a small (maybe an hour) downtime for the application. After the Sept. 11 tragedy, my websites had connectivity problems on and off for a few days. We also had 24 hours of downtime when a hurricane knocked down a bunch of telephone poles near my ISP a few years ago. For this application, that wouldn't have been acceptable. I have no idea how to approach it. Any ideas? Al a1webs.com At 06:08 PM 5/10/2002 -0400, Justin Greene wrote: I Have to agree. Hardware based clustering for the front end... and either SQL Enterprise or Veritas on the backend to handle the database cluster. Very solid configuration. We have been hardware clustering CF with Alteons for over 3 years. Just need to keep sessions in the DB and make sure the web boxes keep the file systems synched. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:
Re: can this be done?
Yes, Just create the two new columns and do like you suggested, find the first space and insert the name into the firstname column and then copy the remaining length of the string into the lastname column minus the space. Then run a quick output to visually inspect the contents of the fields. It'll be a small pain to do but lesson learned: never let the client define the database. :) Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/13/02 12:04PM Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Question
I use where clause join syntax for more reasons that just portablity. Besides the fact that the tables involved in the query are easier to identify and my opinion that it's easier to read, I find it easier to write dynamic sql using this syntax. For example: cfset thePeopleId= cfif getdetail is 1 cfset SQLfields=, b.firstname, b.lastname cfset SQLtable=, peopleDetail b cfset SQLwhere=AND a.peopleid = b.peopleid cfelse cfset SQLfields= cfset SQLtable= cfset SQLwhere= /cfif cfquery name=myquery datasource=#dsn# SELECT a.idpeople#SQLfields# FROM people a#SQLtable# WHERE peopleid =#thePeopleId# #SQLwhere# /cfquery Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/10/02 02:38PM so are you saying that even though you use ansi joins, you should probably be using *= for portability? ~ dina - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 10, 2002 1:32 PM Subject: RE: SQL Question Is the *= universal syntax (MS SQL, Access, Oracle, MySQL ect..?) it's my understanding that the *= syntax is legacy syntax; i believe you'll want ansi syntax to effect compatibility with a most dbms's: SELECT h.id, h.header, l.link, l.link_title FROM headers h LEFT JOIN links l ON h.id = l.headerid While you're correct to point out that the *= syntax is not ANSI SQL, I suspect that it's supported by more databases than the ANSI JOIN syntax! We typically use ANSI joins, but I remember an unpleasant occurance porting something from MS T-SQL to Sybase T-SQL, and that version of Sybase didn't support ANSI join syntax. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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: Studio/DWMX comparisons
__ 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 MX
Christine, What about those of us who have yet to upgrade to CF5? Will the jump from 4.5 to MX be a larger change, should I expect more code incompatibilites? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 05/02/02 12:16PM Hi, CFMX will be the upgrade path for ColdFusion 5. We're in the process of getting the link to the CF 5 Developer Edition back up. For now, you can download it here: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-50-win-us_devrel.exe Regards, Christine Lawson Macromedia Technical Support -Original Message- From: harmony jones [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 9:22 AM To: CF-Talk Subject: Coldfusion MX When the CF MX going to be officially released? There is no mention of CF 5.0 anymore on the Macromedia site, you can't even download the CF 5.0 evaluation anymore (does anyone know where I can get that) Is CF MX and replacement for CF 5.0 ? I'm running 4.5.1 and was going to upgrade to CF5.0 but it seems like CF5.0 has been wiped off the face of MM's site so I'm thinking should I go straight to CF MX ? I'm guessing it's NOT very backward compatible with CF 4.5.1 I heard that MM was going to continue supporting CF 5.0 but they way it is represented on their site makes me think otherwise... Any suggestions here... Thanks and have a good week. The only difference between me and a madman is that I'm not mad. - Salvador Dali (1904-1989) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX Books
Bold post, Jeff. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/29/02 03:27PM At the risk of blatant self-promotion.. My new book will be out sometime in June also (ColdFusion MX: The Complete Reference). Unlike many of the other books, which are just being updated, this one was written from scratch with CFMX in mind. I have a few contributors on various topics including Simon Horwith, Chris Cortes, and Chris Graves. Michael Dinowitz is doing the tech editing. Keep watch on this forum during the next few months when I will start begging people to buy it so I can pay my mortgage. (Kidding, honest). -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! Weird E-mail problems Use use mailto:[EMAIL PROTECTED] as backup AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com -- Will I be on the streets tomorrow, Will I have to beg and Borrow Will I have to go back to the job I left behind? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: contacting congress /
That's not entirely true, David. I worked on Capitol Hill for several years as a contractor and was able to visit almost all of the offices of our elected officials. It is true that all of the offices will screen your mail, and that this process may boil your comments down to a check box in the for or against column. It is also true that a college intern may be the one screening your comments and your comments may not get the attention they deserve. But, emails or letters that raise issues that do not easily fall into column x or column y, or issues that are targeted by specific staff members tend to get routed to the next level. The next level is usually a staffmember (just out of college) who has been given an issue or area to summarize for their representative. Your mailing/emailing campaign should be targeted to enlist this person to your cause. It will be this person who will raise the issue at the weekly/daily staff meeting. Your email itself will very rarely reach the desk of your representative, it's true, but your emails and letters are not ignored. In fact, many senators file all of your correspondance. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/23/02 10:12AM Another thing to keep in mind - e-mail to our elected officials is pretty worthless. Most don't understand the medium and never look at them. Just something to consider. David Groth, Analyst/Programmer III HSC Library Informatics Center, University of New Mexico 505.272.8406 e-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] 04/23/02 07:33AM Hello- I would like to automate the process of contacting Congress a visitor's congress member. I've got a database (provided by client) which has all of congress, but not all of the congress members have email addresses. I guess this is a two part question: 1. Does anyone know of a zip code - congressional district database? 2. Has anyone automated the process of contacting congress members on a nation wide basis? With a variety of different web based contact forms, I'm wondering how to code this... I'd like to handle it on site- Instead of providing a link to whatever form the particular congress member is using. 3. Last but not least- I heard a rumor that their are databases with plain EMAIL addresses for all of congress... IF anyone knows anything about this, I'd love to know!!! It would be much easier than trying to deal with the assortment of contact forms... Thanks in advance! Louis Klepner Expressive Imaging Web Design Development 845-440-0086 [EMAIL PROTECTED] http://www.expressiveimaging.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: CF and Business Logic
I think I would have taken a different tact with your subcontractor. Beginning with the assumption that he considers himself the center of the known universe and probably has had some dealings with asking his IT department for something unnecessisarily complex in the past... I would have to agree with his statement (what else would he hear?). But, realistically [insert subcontractor name with casual smile] i'm sure it's not the language itself. In fact, most business logic that higher managment and people we hire to analyze our systems can imagine will be difficult for most web programmers to implent (compliments his intellectual prowess). But in this case, our team has me to implement whatever business logic you might need, and I'm sure that given two rocks and a sharp stick (throw in some such senseless analogy) I'd be able to give you what you want. Give me a great programming language like Cold Fusion and I might be able to get it done today! It's just that fast and easy to use. -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:17 AM To: CF-Talk Subject: CF and Business Logic More of a philosophical question. I was meeting with a potential subcontractor the other day and he made the remark that once you get into serious business logic, cold fusion is kinda hokey. Anyone care to possibly elaborate on what he might've meant? Or is this just another one of those anti-CF prejudices? Just wondering, John Venable __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: UNION vs JOIN
Union Adds the rows from a second table, Join combines the tables. It's conceivable that they produce the same result if you're using an outer join, but they're different. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/18/02 10:18AM Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ 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: UNION vs JOIN
If you have a single table with fields from other tables you can join them all fairly simply. Consider the following four tables: cars carid cartypeid carcolorid carmodelid carmodel carmodelid model carcolor carcolorid color cartype cartypeid type You can get the data from all the tables with a join: (i'm using the older syntax cause it is easier, the letters are aliases) select a.carid, b.model, c.color, d.type from cars a, carmodel b, carcolor c, cartype d where a.carmodelid = b.carmodelid and a.carcolorid = c.carmodelid and a.cartypeid = d.cartypeid and a.carid = That will get all the data for one car. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/18/02 11:14AM can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Preventing SQL injection attacks...?
This code would fail my own code review. I don't allow any url. or form. variables inside CFQUERY statements. This, however, might pass. !--- Validate ID --- cfif #isdefined(id)# is true cfset theId=#val(htmleditformat(REreplacenocase(id, [*,;^:?|\], , ALL )))# cfelse cfset theId=0 /cfif !--- update time of last visit for this user --- cfquery name=queryit datasource=#dsn# update people set updated = '#dateformat(now(), MM/DD/)#' where peopleid = cfqueryparam value=#theid# cfsqltype=cf_sql_integer /cfquery (Note: I am not using CFQueryParam here as a validation tool. I already know the variable is an integer. This query is from a header and will fire every page load so I want successive queries to run from cache on the Database server.) Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/12/02 01:44PM cfqueryparam does in fact prevent that code from running. cfqueryparam creates a prepared statement with parameters. It then compares what you've entered as a value with the datatype you've specified and, if successful, binds the parameters with what you've entered. So, if you entered: select * from table where id = cfqueryparam value=#url.id# cfsqltype=CF_SQL_DECIMAL and then in your url entered: id=12;drop table yourtable It would through you an error. As well, if you had: select * from table where id = cfqueryparam value=#url.id# cfsqltype=CF_SQL_VARCHAR It would create the equivalent SQL statement of: select * from table where id = '12;drop table yourtable' - Original Message - From: [EMAIL PROTECTED] Date: Friday, April 12, 2002 11:00 am Subject: RE: Preventing SQL injection attacks...? let's say you have a text field that is 100 characters long. you can still get a drop table tablename appended to the sql statement or write an entire sql statment. Cfqueryparam was meant to speed up cfquery, not be to a cure all. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:06 PM To: CF-Talk Subject: Re: Preventing SQL injection attacks...? [EMAIL PROTECTED] wrote: you can't forget that form fields also play a part in this. after readingthe informaiton provided in jeff's link, it did shine a light. although i have been taught from the beginning to always use val() around numbericvalues (thank Adam) and to use regex to validate text input (props Raymond). if your anal and take the time to make sure that the information that people are passing you is in the extact fomrat you want, you shouldn't have a problem. also, don't rely on javascript, i always do server-side validationeven after client side, just to make certain. i even go as far as putting as much validation as i can into my stored procedures and triggers. althoughSQL server doesn't support regular expressions , which sucks! anyone know a way it could? why not just use cfqueryparam, it validates and it makes your sql code run faster??? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crosspost: Escaping single quotes
If you're trying to perserve the quotes so that SQL will recognize them and end or begin a string, then you use perservesinglequotes(). If you are trying to escape a single quote but keep it in your database, then you need to use htmleditformat(). Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/12/02 02:54PM What is the full query? I really think that Preserve Single Quotes is supposed to handle this. I know you said that it wasn't working, but do you get the same error if you do this: ,SIZE = '#PreserveSingleQuotes(FORM.EDITTABLE.SIZE[i])#' At 01:59 PM 4/12/2002 -0400, you wrote: This is the offending line: ,SIZE = '#FORM.EDITTABLE.SIZE[i]#' and the cfoutput of that line: ,SIZE = 'Teacher's Solo' Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Teacher's Solo' ,TYPE = 'Competitive' where id = 1'. If I remove the line where Teacher's Solo occurs then it works great. - Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:37 PM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes What error are you getting? What database are you using? Have you tried outputting the data after you submit it to see what you are getting? At 01:38 PM 4/12/2002 -0400, you wrote: From the CF4.5 Language Reference - PreserveSingleQuotes - Prevents ColdFusion from automatically escaping single quotes contained in variable. What is going on is I have a CFGRID that I have to manually update because it throws an error if I use CFGRIDUPDATE. My own code which does the update and insert works perfect except when it encounters the string Teacher's. For some reason that I don't know, the single quote does not get escaped when I pull it from the variable FORM.EDITTABLE.SIZE[i]. I can't figure out what to do. I want the single quote to be escaped so that it will insert into the database without error. I've already tried the function #Replace(FORM.EDITTABLE.SIZE[i], ', '', all)# but it doesn't work for me. Anybody got any ideas what's going on? Thanks, - Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:49 PM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes I am either confused about the functionality you want, or the functionality PreserveSingleQuotes provides. PreserveSingleQuotes preserves single quotes for database inserts by automatically escaping them. It needs a variable as the value, not a string. I'm assuming you already have Teacher's Group in a variable? cfoutput cfset temp = Teacher's Group #PreserveSingleQuotes(temp)# /cfoutput You could probably try to do something more using replace: #Replace(Teacher's Group, ', '', all)# will return: Teacher''s Group At 11:55 AM 4/12/2002 -0400, you wrote: No, that preserves single quotes. I want to escape single quotes. Thanks, Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:32 AM To: CF-Talk Subject: Re: Crosspost: Escaping single quotes Isn't there a function (PreserveSingleQuotes) that does this? At 11:38 AM 4/12/2002 -0400, you wrote: Hi everybody, I'm having a problem with an update to a table - the problem is when I want to update or insert the string Teacher's Group. CF throws an error at me when I try this. I know that CF usually escapes the single quote, but it's not in this case. I know I saw a post with on this list or CFDJList about there being a bug with escaping single quotes in CF4.5. Anybody know how can I make CF escape the single quote for insertion into my table? Thanks Matt Small __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Crosspost: Escaping single quotes
Rats.. that won't work.. so much for code humor. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/12/02 03:53PM cfset theVariable = #evaluate(chr(39) Smith's shorts chr(39))# cfquery name=queryit datasource=#dsn# update items set itemname = #preservesinglequotes(htmleditformat(theVariable))# /cfquery How's that for an explanation? It must be Friday! Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/12/02 03:36PM Well, that isn't a database error, at least. It seems to be spitting up on the '[' character. It is a fairly complicated variable structure (Is it structures of structures or just variable names with dots in them? ) Maybe you need to play around with pound signs? '#PreserveSingleQuotes(FORM.EDITTABLE.SIZE[#i#])#' I'm stuck and without database / code to attempt to debug against, I don't think there is much other help I could offer. Did you try HTMLEditFormat as someone else had suggested? At 03:27 PM 4/12/2002 -0400, you wrote: Well, Jeffrey, I hadn't actually tried the function so I figured I might as well give it a shot. It didn't work. Just in time compilation error Invalid parser construct found on line 48 at position 55. ColdFusion was looking at the following text: [ Invalid expression format. The usual cause is an error in the expression structure. This is line 48 ,SIZE = '#PreserveSingleQuotes(FORM.EDITTABLE.SIZE[i])#' Thanks, Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 2:54 PM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes What is the full query? I really think that Preserve Single Quotes is supposed to handle this. I know you said that it wasn't working, but do you get the same error if you do this: ,SIZE = '#PreserveSingleQuotes(FORM.EDITTABLE.SIZE[i])#' At 01:59 PM 4/12/2002 -0400, you wrote: This is the offending line: ,SIZE = '#FORM.EDITTABLE.SIZE[i]#' and the cfoutput of that line: ,SIZE = 'Teacher's Solo' Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Teacher's Solo' ,TYPE = 'Competitive' where id = 1'. If I remove the line where Teacher's Solo occurs then it works great. - Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:37 PM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes What error are you getting? What database are you using? Have you tried outputting the data after you submit it to see what you are getting? At 01:38 PM 4/12/2002 -0400, you wrote: From the CF4.5 Language Reference - PreserveSingleQuotes - Prevents ColdFusion from automatically escaping single quotes contained in variable. What is going on is I have a CFGRID that I have to manually update because it throws an error if I use CFGRIDUPDATE. My own code which does the update and insert works perfect except when it encounters the string Teacher's. For some reason that I don't know, the single quote does not get escaped when I pull it from the variable FORM.EDITTABLE.SIZE[i]. I can't figure out what to do. I want the single quote to be escaped so that it will insert into the database without error. I've already tried the function #Replace(FORM.EDITTABLE.SIZE[i], ', '', all)# but it doesn't work for me. Anybody got any ideas what's going on? Thanks, - Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 12:49 PM To: CF-Talk Subject: RE: Crosspost: Escaping single quotes I am either confused about the functionality you want, or the functionality PreserveSingleQuotes provides. PreserveSingleQuotes preserves single quotes for database inserts by automatically escaping them. It needs a variable as the value, not a string. I'm assuming you already have Teacher's Group in a variable? cfoutput cfset temp = Teacher's Group #PreserveSingleQuotes(temp)# /cfoutput You could probably try to do something more using replace: #Replace(Teacher's Group, ', '', all)# will return: Teacher''s Group At 11:55 AM 4/12/2002 -0400, you wrote: No, that preserves single quotes. I want to escape single quotes. Thanks, Matt Small -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:32 AM To: CF-Talk Subject: Re: Crosspost: Escaping single quotes Isn't there a function (PreserveSingleQuotes) that does this? At 11:38 AM
SQL Server 2000 and @@Identity
Hi List,
I recently upgraded from SQLServer7 to 2k and the @@identity in the
code below now returns a null string. Anyone know why this might be
happening?
code block~~
!--- insert user info ---
cfquery name=insertPeople datasource=#dsn#
set nocount on
insert into people
(password, username)
values
('something', 'testuser123456')
SELECT lastid = @@identity
set nocount off
/cfquery
!--- capture the peopleid from the previous query ---
cfset thepeopleid=#insertPeople.lastid#
!--- insert associated user detail ---
cfquery name=insertDetail datasource=#dsn#
insert into people_detail
(peopleid, firstname, lastname)
values
(#thepeopleid#, 'firstname', 'lastname')
/cfquery
end code block~~~
Thanks for the help.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
DaVita Inc.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server 2000 and @@Identity
Checking on the MDAC upgrade idea.. @lastid would assume lastid is a
declared variable, it's just part of my select statement. I could have
named it anything. Thanks for the MDAC idea. It's a new server and I
forgot about that.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 04/11/02 03:08PM
try upgrading your mdac. also why aren't you delcare lastid and making
your
statement
SELECT @lastid = @@identity
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 3:02 PM
To: CF-Talk
Subject: SQL Server 2000 and @@Identity
Hi List,
I recently upgraded from SQLServer7 to 2k and the @@identity in the
code below now returns a null string. Anyone know why this might be
happening?
code block~~
!--- insert user info ---
cfquery name=insertPeople datasource=#dsn#
set nocount on
insert into people
(password, username)
values
('something', 'testuser123456')
SELECT lastid = @@identity
set nocount off
/cfquery
!--- capture the peopleid from the previous query ---
cfset thepeopleid=#insertPeople.lastid#
!--- insert associated user detail ---
cfquery name=insertDetail datasource=#dsn#
insert into people_detail
(peopleid, firstname, lastname)
values
(#thepeopleid#, 'firstname', 'lastname')
/cfquery
end code block~~~
Thanks for the help.
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
DaVita Inc.
__
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: An IMG instead of a form SUBMIT button ?
Go check out www.htmlgoodies.com. There's lots of info about simple html stuff and Joe Burns makes it very easy to understand. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/10/02 11:38AM How can I have the user click on a image of my own design to effect the 'action' page on a form rather than the standard INPUT TYPE=SUBMIT VALUE=button text ? Simpler is better and, if given the choice, I'd rather avoid Java Thanks for your help! Ed Gordon PTC International - HeLp! i'M A pRiSoNeR cHaInEd To a DeVeLoPmEnT pC In a cAvE ! ! ! ( no 'rescues' please, just send pizza ) 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 DaVita 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: CF VS ASP - let the trolling being
Honestly, If he's willing to pay you to cross train in ASP, why complain? I'm assuming that you have already written a score of reports and tools that will all need to be translated into ASP and who would know the reports better than their author. ASP isn't that different from Cold Fusion. Cold Fusion takes care of quite a few loose ends and takes far less time to produce quick apps. So, if your new boss is dead-set on using ASP pick up a few kill weight manuals on ASP coding and rewrite one of your tools. Remeber, coders survive on being able to code. Managers survive on making good business decisions. You may well see a new manager in the not so distant future. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/03/02 02:36PM But I have made up my mind that if they kill Cold Fusion here I am not staying here any longer. It is mostly because we have a new manager that seems to be such a die hard ASP fan who swears it is better then CF even though he does not even know anything about CF. A little annoying, but I think since he is not the one that is doing any of the coding, he should really go with what us developers are wanting to work with. Maybe I am living in a dream like state when I think that managers will always pick the best product. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:28 AM To: CF-Talk Subject: Re: CF VS ASP - let the trolling being and on that note you should tell your boss there is a new version of CF comingall that can be said here is WOW...wait for it...can you say coool ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Robert Bailey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:12 AM Subject: RE: CF VS ASP - let the trolling being Yeah, I thought this would get quite a bit of response, but I would really like the information to share with my current employer who wants to move from CF to ASP and get rid of CF, which I do not want to do at all, and I only know a little ASP, and from what I do know, I do not like it. Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 10:59 AM To: CF-Talk Subject: RE: CF VS ASP - let the trolling being gentlemen (and ladies) start your engines Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:03 PM To: CF-Talk Subject: CF VS ASP OK, I have been looking for some things on the net that shows the pros and cons of CF as opposed to ASP. Knowing very little ASP myself, I do not know the many differences. Anyone know where I can find this? Pretty much looking for development time differences, execution speed, security and scalability at a bare minimum. Anyone know where I can find this? Rob __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF VS ASP - let the trolling being
Agreed, it's a bitter pill to take. But, it's arguably still a recession. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/03/02 03:03PM Yes, I agree with you, but killing all of our CF is what is making me a little sour on the subject, would have no problem learning more of it, but to ask me to abandon CF totally gets to me since I am very fond of using CF Rob -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:46 AM To: CF-Talk Subject: RE: CF VS ASP - let the trolling being Honestly, If he's willing to pay you to cross train in ASP, why complain? I'm assuming that you have already written a score of reports and tools that will all need to be translated into ASP and who would know the reports better than their author. ASP isn't that different from Cold Fusion. Cold Fusion takes care of quite a few loose ends and takes far less time to produce quick apps. So, if your new boss is dead-set on using ASP pick up a few kill weight manuals on ASP coding and rewrite one of your tools. Remeber, coders survive on being able to code. Managers survive on making good business decisions. You may well see a new manager in the not so distant future. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/03/02 02:36PM But I have made up my mind that if they kill Cold Fusion here I am not staying here any longer. It is mostly because we have a new manager that seems to be such a die hard ASP fan who swears it is better then CF even though he does not even know anything about CF. A little annoying, but I think since he is not the one that is doing any of the coding, he should really go with what us developers are wanting to work with. Maybe I am living in a dream like state when I think that managers will always pick the best product. -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:28 AM To: CF-Talk Subject: Re: CF VS ASP - let the trolling being and on that note you should tell your boss there is a new version of CF comingall that can be said here is WOW...wait for it...can you say coool ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Robert Bailey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:12 AM Subject: RE: CF VS ASP - let the trolling being Yeah, I thought this would get quite a bit of response, but I would really like the information to share with my current employer who wants to move from CF to ASP and get rid of CF, which I do not want to do at all, and I only know a little ASP, and from what I do know, I do not like it. Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 10:59 AM To: CF-Talk Subject: RE: CF VS ASP - let the trolling being gentlemen (and ladies) start your engines Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:03 PM To: CF-Talk Subject: CF VS ASP OK, I have been looking for some things on the net that shows the pros and cons of CF as opposed to ASP. Knowing very little ASP myself, I do not know the many differences. Anyone know where I can find this? Pretty much looking for development time differences, execution speed, security and scalability at a bare minimum. Anyone know where I can find this? Rob __ 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: CFREPORT and Error 500
In the CF Forums you can find a lot about using CFReport. Last I checked the tag was depreciated since version 5 of Crystal Reports. Crystal has it's own webserver product now. Crystal seems to have spent a good deal of time integrating their product with ASP. I also remember some undocumented features to the CFReport tag you must use to pass parameters to the newer versions. Check the Forums. I hope the info is still there. If not, send me a direct email and I'll dig about my own archives for some of the examples I downloaded. Keep in mind that Crystal is on version 8 now. CFReport is meant to work with Version 5. Hope that helps. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/02/02 01:25PM I am trying to pass a variable to CFREPORT and I continue to receive the following. There is very little on the Allaire discussion forums about this. I am running CF 5 and CR 8.5. I thought the previous problems regarding CFREPORT has been fixed in CF 5. Anyone have an idea on this? Error Diagnostic Information Error occurred while processing CFREPORT An unexpected error occurred while using the Crystal Engine. Error number 500 ocurred (Not enough memory for operation.). Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43) DLL Version = 8.80, Engine Version = 8.80 The error occurred while processing an element with a general identifier of (CFREPORT), occupying document position (9:1) to (9:59). Date/Time: 04/02/02 11:02:09 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461) Remote Address: 129.43.39.167 Alan L. Wolf MCSE, MCP, MCP + I SAIC Frederick PO Box B Bldg 458 Frederick, Maryland 21702 [EMAIL PROTECTED] 301-846-5479 (V) 301-846-6886 (F) __ 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
MSSQL 2K Transaction Error
Hi, Anyone seen this error before? (I'm using SQL Server 2000) [[ ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] SQL = update secure.website.dbo.people set token = 'IUIHIOYNTKI', updated = getdate() where peopleid = 111 ]] I have just moved to a new database server and my existing code is bombing on the transaciton tags I have surrounding my update statements. When I remove the CFTRANSATION tags I don't get the errors and the update statement executes without errors. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita 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: What is MX
Wow that article was negative. Maybe we should just go back to using smoke signals to communicate. One day a few years from now when the HTML web as we know now seems as archaic a presentation medium as ASCII graphics of the war games era, the person who wrote that article will likely shrug and take another bitter sip of some generic coffee. The vector concept of web presentation is doubtlessly the wave of the future and Flash is the defacto player of choice. If the current search engine paradigm is holding back the development in this medium should we hold back development in Flash or should we reward the engine that gets with the program and finds a way to index flash content. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/01/02 12:39PM Interesting article today on News.com. Looks like it's going take some serious marketing to sell the concept. http://news.com.com/2100-1001-872136.html Jim - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 10:35 AM Subject: Re: What is MX In other words, it sounds cool!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 6:15 AM Subject: RE: What is MX -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:53 AM To: CF-Talk Subject: What is MX Not that 'branding everything under one banner' is a bad idea, but.. MX seems like a random 'name' to choose for branding if it doesn't mean anything. Go to this article by MM's John Dowdell and scroll down to the second question under the Q A section. http://www.macromedia.com/desdev/jd_forum/ That should give you an official answer. Regards, 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: What is MX
We'll see. One day it may be just as easy to flow text into Flash reports. We'll see. I'm sure someone at Macromedia has been scratching their chin trying to figure out how to get their hands on the business application development money. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/01/02 01:20PM I agree that flash is far superior to HTML for multimedia rich content. But when it comes to posting documents and information, HTML/XHTML/XML is far superior to flash. Different tasks require different tools. Rick Walters [EMAIL PROTECTED] 04/01/02 01:13PM Wow that article was negative. Maybe we should just go back to using smoke signals to communicate. One day a few years from now when the HTML web as we know now seems as archaic a presentation medium as ASCII graphics of the war games era, the person who wrote that article will likely shrug and take another bitter sip of some generic coffee. The vector concept of web presentation is doubtlessly the wave of the future and Flash is the defacto player of choice. If the current search engine paradigm is holding back the development in this medium should we hold back development in Flash or should we reward the engine that gets with the program and finds a way to index flash content. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/01/02 12:39PM Interesting article today on News.com. Looks like it's going take some serious marketing to sell the concept. http://news.com.com/2100-1001-872136.html Jim - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 10:35 AM Subject: Re: What is MX In other words, it sounds cool!!! Success is a journey, not a destination!! Doug Brown - Original Message - From: Dave Carabetta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 01, 2002 6:15 AM Subject: RE: What is MX -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 7:53 AM To: CF-Talk Subject: What is MX Not that 'branding everything under one banner' is a bad idea, but.. MX seems like a random 'name' to choose for branding if it doesn't mean anything. Go to this article by MM's John Dowdell and scroll down to the second question under the Q A section. http://www.macromedia.com/desdev/jd_forum/ That should give you an official answer. Regards, Dave. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DHTML Layers
Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers
The layering problem is happening in IE. Thanks for the suggestions guys. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 10:58AM You need to set the z-index property on your layers. Sounds like you're using Netscape for this, as in IE the select boxes are system object and thus override everything else on the screen. -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 8:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DHTML Layers + Flash!
I would love to do the dynamic menus in flash. I never thought to put the flash into a layer. Interesting idea. See though drop down menus could create some very cool effects, especially since you can animate of the menu. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/29/02 11:07AM This is not possible with regular DHTML layers but, I have come up with a solution, but I don't have an example for you. Try putting a flash movie in the layer. It will go over the form fields. It will even (in IE) allow transparency. You can even see the webpage behind/through the menu. Now, to do it right, you'll need a full dhtml/flash/cf solution for menus. I haven't seen one yet. Currently, I'm waiting on my new employer to buy Flash MX. When I get, it I plan on developing one. If anyone has beat me to this, let me know. I would like to see what you came up with. Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-498-0123 ext 284 -- -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 9:45 AM To: CF-Talk Subject: DHTML Layers Hi Everyone, While this is not a Cold Fusion question, someone out there might have run into this problem before. I am creating dynamic javascript to control a set of drop down menus. My problem arises when I have a page with form input fields. Whenever there are form input fields on the page the layers containing the menuitems display behind the form input elements. Naturally I want the drop down layers to appear above the form elements but I don't really know how. Any ideas? Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 DaVita 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: Creating update statements on the fly
There's always the ASP way...
!--- build the query ---
cfset sql=update tablename set
cfif condition1...
cfset sql=#sql# columname=value
/cfif
cfif condition2...
cfset sql=#sql# where columname = 1
/cfif
cfquery name=myquery datasource=#dsn#
#sql#
/cfquery
Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525
[EMAIL PROTECTED] 03/29/02 11:10AM
HI,
I wanted to create a Update statement on the fly. For creating a
Select
statement on the fly I have used
Select * from tablename
Where 0=0
cfif isDefined(attributes.String1)
and String1 = attributes.String1
/cfif
How can I achieve this for update statement as I couldn't figure
out
where to put Set statement and the last line with out coma(',') in my
statement.
Thanks in advance.
Sudheer Chakka.
__
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: Anyone from Orlando not in the CFUG?
No really, Orlando's CFUG really is quite good. I have moved about quite a lot as a contractor and have seen more than a few alternatives. It is pleasant to report that Orlando's group remains more interested in coding than marketing. While it is important that CFUG's help promote CF as the solution of choice for local business, I think that having a knowegeable and talented pool of local developers is the best way to increase the use of Cold Fusion in area businesses. Orlando's group is all about answering questions and not selling services (like some others I've seen and won't spotlight). Oh, don't get me wrong, there are other good groups out there. I just wanted to chime in and further encourage Orlando Developers to come to the meetings. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/27/02 09:30AM : whine, whine, whine: All three Connecticut ones went DOA in the past year. A quick search of the link below, Connecticut isn't even listed ( usually it is between Colorado and Delaware ) It also looks like there are no Macromedia user groups in Idaho, Maine, Mississippi, New Hampshire, North Dakota, South Dakota, and West Virginia. At 09:26 AM 3/27/2002 -0500, you wrote: As a general follow up to this - anyone NOT in a CFUG is _really_ missing out on a wonderful exprerience. I encourage everyone not attending a CFUG to go to http://www.macromedia.com/v1/usergroups/ and see if a UG is in your area. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 9:19 AM To: CF-Talk Subject: Anyone from Orlando not in the CFUG? I am co chair for our ColdFusion User Group here in Orlando, FL and I just want to make sure that I have everyone in the Orlando area signed up for our User Group. I am trying to get more user participation so that we can network and get to know each other. If you're interested in joining us go to www.cforlando.com and sign up as a member. We have monthly meetings and we will be starting something new called CF_Beer. We will all meet up once every couple of weeks for drinks, talking, and getting to know each other without having to have a formal meeting or speaker. Email me off list if you have any questions. __ 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: Closing window
Without using Javascript or another client side language? You can't. You could manually close the window or have a client event trigger some other process. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/27/02 01:17PM How can I close a window using javascript without having to click on a link or button? After my CF code runs I want the window to close. +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Closing window
Disregard this.. I read your question incorrectly. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/27/02 01:19PM Without using Javascript or another client side language? You can't. You could manually close the window or have a client event trigger some other process. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/27/02 01:17PM How can I close a window using javascript without having to click on a link or button? After my CF code runs I want the window to close. +---+ Philip Humeniuk [EMAIL PROTECTED] [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: Sprectra (WAS: KILL THE BROADVIEW!)
I don't think anyone doubted there would be patch releases to Spectra. If I have been reading this thread correctly, those of us who do not already have Spectra don't plan to buy a copy anytime soon. However, if it were handed out to developers, we would certainly help support it. :) Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 03/13/02 03:03PM Hi Guys and Gals., Contrary to popular belief, Macromedia Spectra will be having one more release in the future - 1.5.2. This will allow it to run on the next release of ColdFusion - ColdFusion MX(Neo).Neo will allow you to still use the core features of the Spectra model via ColdFusion Components. I can only tell you what I know and what is not under NDA anymore (Raymond Campden is your man to ask, but I think he is neck deep in Neo development!) But remember you can get a development copy of Spectra for single user use off your ColdFusion Studio CD (it is on the 4.5 disk, I will have to check the 5 disk) So if you want to help improve the model, you still can via http://spectrasource.macromedia.com Laters Neil __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ArrayAvg()
Has anyone ever used the ArrayAvg Function with a multi-dimensional array? I have a two dimensional array[questionnumber][answer]. The answers are all values 1-5 and I need the average for each question. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Joining Tables from Different Datasources... Possible?
If you're using SQL Server, AND the databases are on separate machines, you need to LINK the databases from within enterprise manager. Then, when you reference database.dbo.tablename, SQL Server will do the rest. If I recall correctly, it is not enough to simply register the server, they must also be Linked. To link a server in SQL Server 2000, choose new linked server under the security tab for a registered server. I believe you need to make the link on both servers, but if you don't, then the DSN that you use for the datasource property in your CFQUERY tag will need to refer to the server that defined the active link. Oh, while I have no direct proof of this, I believe it is best to weigh the size of the tables and activity of the server when choosing which server initiates the join in your CFQUERY tag. Especially when servers are separated by thousands of miles (as mine are) it seems to make a difference to let the server with the largest portion of the data crunch the join. Also, for security reasons, I have been told it may not be practical to Link a server that is behind a firewall to a server outside the firewall. Rather, a one-way link from inside to out would make better sense. This might apply if your webserver runs SQL Server locally in a DMZ. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:05 PM To: CF-Talk Subject: Joining Tables from Different Datasources... Possible? How would I do a join of tables from two different datasources? Thanks, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-Talk-list V1 #141
No no, thanks for the clarification. I didn't set up the sequences when I was working with Oracle. I'm always happy to know more. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 -Original Message- From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:26 AM To: CF-Talk Subject: Re: CF-Talk-list V1 #141 -- Date: Fri, 15 Feb 2002 10:47:47 -0500 From: Rick Walters [EMAIL PROTECTED] [snip] Oracle has a nifty little table called DUAL. It's a system table that will always have only one row. So, if you Select nextval from Dual you will have a unique id you can then store in a variable and use for inserts. If you use this for all your tables, then your ID values will be different in all of your tables, an interesting thing to play with in joins or table merges. No record will ever have the same ID. Beware, I have heard of resetting the Dual Table. Never had it happen to me. This is completely off-base. Instead of using the Identity feature which SQL Server has (which is a counter attached to a particular column on a table in the DB), Oracle has separate objects called Sequences. These are basically counter objects with extreme flexibility. Someone (usually a DBA, but it's trivial to do so) must set up a sequence for you to use before you can actually do something like: SELECT thisSq.NEXTVAL FROM SYS.DUAL. These sequences do not magically appear. Having the new row-ids selected explicitly from a separate table avoids the potential ID contention issue which SQL Server has due to the fact the IDs are implicit, and a long data insert sometimes causes SQL Server to give two requests the same ID. (One way to avoid that is insert a NULL row first, get the ID, and then do an update on that row). There is nothing special about the so-called DUAL table. It's simply a dummy table. You could just as easily select the next value in a sequence from any table (or the sysdate for that matter, as in SELECT sysdate FROM SYS.DUAL). Doing it from DUAL makes more sense since it is ever-present (and locks you into using Oracle, hahaha :). No offense Rick. I just wanted to ensure people knew what exactly the deal was with Sequences in Oracle. Cheers, Kreig FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FTP vs HTTP
Hi Everyone, I'm searching for opinions and perhaps metrics that might suggest when it is better to channel downloads using FTP vs HTTP from a single web server environment. Essentially, we have a large file (35M) that a significant number of people must download monthly. The question is: What advantage could we gain by using an FTP link vs a HTTP link? Opening an anonymous FTP channel is potentially more risky from a security standpoint. But, we are wondering if channeling this traffic on another port would possibly free up port 40 and result in a performance gain for the steady flow of *.cfm requests. Anyone out there with an opinion please chime in. Or, if you know where I could find more information on this topic, send me a note. Thanks. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FTP vs HTTP
Good Suggestions, I agree that FTP is a better way to push large files. Problem is, I need to justify opening an anonymous access. The idea that it might boost performance would be a plus, but I'm having trouble finding comparisons. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 3:39 PM To: CF-Talk Subject: RE: FTP vs HTTP Ditto to howie - http servers and processes are also usually configured to timeout long running request in order to enhance server performance and overall user experience. FTP is a better choice. Mark -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 9:55 AM To: CF-Talk Subject: Re: FTP vs HTTP For a file like that I would definitely use FTP - that is what FTP is for. Most modern ftp servers and clients support resume for one thing (only http/1.1 supports resume and I'm not sure how many web clients support it). And, although there may or may not be a risk using anonymous access to the ftp server it is no more or less of a security risk when providing anonymous http access IMHO. Regards, Howie - Original Message - From: Rick Walters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 12:37 PM Subject: FTP vs HTTP Hi Everyone, I'm searching for opinions and perhaps metrics that might suggest when it is better to channel downloads using FTP vs HTTP from a single web server environment. Essentially, we have a large file (35M) that a significant number of people must download monthly. The question is: What advantage could we gain by using an FTP link vs a HTTP link? Opening an anonymous FTP channel is potentially more risky from a security standpoint. But, we are wondering if channeling this traffic on another port would possibly free up port 40 and result in a performance gain for the steady flow of *.cfm requests. Anyone out there with an opinion please chime in. Or, if you know where I could find more information on this topic, send me a note. Thanks. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting and CFTransaction
It seems that many problems I see in this list revolve around determining
the next record for an insert and methods to use cftransaction as a form of
database locking to achieve this purpose. So, I figured I would add two
cents that might help some of you.
First, what you can do is determined by what product you are using.
Oracle has a nifty little table called DUAL. It's a system table that will
always have only one row. So, if you Select nextval from Dual you will
have a unique id you can then store in a variable and use for inserts. If
you use this for all your tables, then your ID values will be different in
all of your tables, an interesting thing to play with in joins or table
merges. No record will ever have the same ID. Beware, I have heard of
resetting the Dual Table. Never had it happen to me.
Access doesn't have any good way to prevent the multiple simultaneous insert
problem. So, by using CFCatch, and CFTransaction you can catch the error of
the second insert, rollback the changes and try again with a new value.
CFTransaction seems to suggest that your set of queries will all run
sequentially and then allow others to access the instance. But, in truth, I
don't think the tables are locked. Surrounding the code with CFLock will
supposedly single thread your server's requests, and if your server has
exclusive access to the datasource, that's great. If others also access
your datasource, then even that won't help you. But, let's get realistic.
If you're using Access, you can achieve a more than reasonable level of
success using CFLock, CFCatch and CFTransaction. (does CFTransaction roll
back in Access, I can't remember)
SQL Server is a bit different. You could use the Access method above with
reasonable success. However, you would be better off to use something like
the following code.
cfquery name=insertPeople datasource=#dsn1#
set nocount on
insert into people
values
('#thepassword#', '#theusername#'')
SELECT lastid = @@identity
set nocount off
/cfquery
Surround this query with CFLock, CFCatch, and CFTransaction to make it
almost bulletproof. Simply refer to #insertPeople.lastid# in the subsequent
queries wherever you want to sync the new id.
Of course, the very best way to make 100% certain that you are preserving
the ID in SQL server or Oracle is to use a Stored Procedure and lock the
tables while executing the methods above.
Good Fortune,
Rick Walters
Webmaster, Davita Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting and CFTransaction (correction)
cfquery name=insertPeople datasource=#dsn1#
set nocount on
insert into people
(password, username)
values
('#thepassword#', '#theusername#'')
SELECT lastid = @@identity
set nocount off
/cfquery
Good Fortune,
Rick Walters
Webmaster, Davita Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848
-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 10:48 AM
To: CF-Talk
Subject: RE: Inserting and CFTransaction
It seems that many problems I see in this list revolve around
determining
the next record for an insert and methods to use cftransaction as a
form of
database locking to achieve this purpose. So, I figured I would add
two
cents that might help some of you.
First, what you can do is determined by what product you are using.
Oracle has a nifty little table called DUAL. It's a system table that
will
always have only one row. So, if you Select nextval from Dual you
will
have a unique id you can then store in a variable and use for inserts.
If
you use this for all your tables, then your ID values will be different
in
all of your tables, an interesting thing to play with in joins or table
merges. No record will ever have the same ID. Beware, I have heard of
resetting the Dual Table. Never had it happen to me.
Access doesn't have any good way to prevent the multiple simultaneous
insert
problem. So, by using CFCatch, and CFTransaction you can catch the
error of
the second insert, rollback the changes and try again with a new value.
CFTransaction seems to suggest that your set of queries will all run
sequentially and then allow others to access the instance. But, in
truth, I
don't think the tables are locked. Surrounding the code with CFLock
will
supposedly single thread your server's requests, and if your server has
exclusive access to the datasource, that's great. If others also
access
your datasource, then even that won't help you. But, let's get
realistic.
If you're using Access, you can achieve a more than reasonable level of
success using CFLock, CFCatch and CFTransaction. (does CFTransaction
roll
back in Access, I can't remember)
SQL Server is a bit different. You could use the Access method above
with
reasonable success. However, you would be better off to use something
like
the following code.
cfquery name=insertPeople datasource=#dsn1#
set nocount on
insert into people
values
('#thepassword#', '#theusername#'')
SELECT lastid = @@identity
set nocount off
/cfquery
Surround this query with CFLock, CFCatch, and CFTransaction to make it
almost bulletproof. Simply refer to #insertPeople.lastid# in the
subsequent
queries wherever you want to sync the new id.
Of course, the very best way to make 100% certain that you are
preserving
the ID in SQL server or Oracle is to use a Stored Procedure and lock
the
tables while executing the methods above.
Good Fortune,
Rick Walters
Webmaster, Davita Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting and CFTransaction
Thanks for the clarification on Access, I believe you're right since it's not a truly relational product. However, I always use CFTry and CFCatch with Inserts and Update queries. The majority of errors occur when modifying the data. So, even if I roll back the change, I want to catch the error and redirect the user as well as send myself a note along with the malformed query to troubleshoot the code. CFTry and CFCatch were the tags I hated the most when I first started using them since they made it harder to debug. But after I made up my own tags to handle the errors, they became my best friends. I will admit, however, that they clutter the code a bit. Good Fortune, Rick Walters Webmaster, Davita Laboratory Services Office: (800) 604-5227 Cell: (407) 491-9848 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 11:34 AM To: CF-Talk Subject: RE: Inserting and CFTransaction Access doesn't have any good way to prevent the multiple simultaneous insert problem. So, by using CFCatch, and CFTransaction you can catch the error of the second insert, rollback the changes and try again with a new value. CFTransaction seems to suggest that your set of queries will all run sequentially and then allow others to access the instance. But, in truth, I don't think the tables are locked. In Access, whenever a record within a table is modified, the entire table is exclusively locked. So, with CFTRANSACTION around both the query that modifies a record, and the query that retrieves the autonumber value, no one else will be able to access the table and insert another record until the transaction has completed. With other platforms, however, such as SQL Server, the entire table won't be locked. Note that there's no need to use CFTRY/CFCATCH in the above example, unless your intent is to check a unique index or something along those lines. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
