stored procedures
hey this might sound lame to some of you that use stored procedures and i apologize, but what is the point or what is the benefit rather? from what i have read so far i havent seen a point, but maybe i just dont understand the concept completely. whats hard about saying cfquery.../ cfquery... / ... if 1 query sets off another, why not just write it out?? maybe im missing the concept like i said, so if anyone has an example they wish to share please enlighten me. thanks. joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Farcry x SpeckCMS: The best CMS is....
There are more CMS systems written with CFML, do not forget PaperThin. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with setting up DSN
If you've set up SQL Server to run in Windows authentication mode only, then you will get problems trying to create a DSN that points to SQL Server because the JDBC driver that ships with CFMX for SQL Server doesn't support Windows Authentication - it only supports Mixed Mode Authentication. Andy Quoting Kevin [EMAIL PROTECTED]: Hi everyone, I need some serious help. I have installed Microsoft SQL Server but when I try to setup the data source name in ColdFusion MX I get this error: Not associated with a trusted SQL Server connection I have searched the Microsoft Site and Google and have found nothing that helps. Does anyone have this setup working on Windows XP Pro and IIS 5.0? Thanks, Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
Stored procedures are not meant to replace simple queries that have negligible affect on the server - queries that return a small amount of rows, or queries on tables with few indices.However, when your application becomes heavily data-dependant and complex then moving those queries to the database layers will drastically reduce the processing time on the server versus using CFQUERY.Stored procedures are precompiled on the database layer and optimized for that particular engine. In addition, stored procedures can help maintain a better level of security and better type control on input and output parameters. For the majority of simple Internet or Intranet applications built by ColdFusion developers, stored procedures are overkill, but once you take it to the next level, they become your best friend. hey this might sound lame to some of you that use stored procedures and i apologize, but what is the point or what is the benefit rather? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Sendinf Plain Text and HTML with cfmail
Hi, i want to send both plain text and HTML in a mail. I searche dthe web and found the following code cfset boundary = CreateUUID() cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test server=localhost cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html --#boundary#-- /cfmail but it is sending blank mail. can anyone help me with this please [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Sendinf Plain Text and HTML with cfmail
Hi, i want to send both plain text and HTML in a mail. I searche dthe web and found the following code cfset boundary = CreateUUID() cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test server=localhost cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html --#boundary#-- /cfmail but it is sending blank mail. can anyone help me with this please [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
querying an array?
I've got a shopping cart that is in an array (stored in a session). It looks like this: ItemQuantityType - pepper2green avocado 1green carrot3not green eggplant1not green celery5green What I need to do is figure out the total quantity of not green items and green items (in this case, 8 green items; 4 not green items). I'm not at all sure how to go about this, as I've always used databases and queries to do this sort of thing. Am I out of luck or is there some way to query the data in an array that isn't too horribly complicated? P.S. Please forgive me if this issue has already been dealt with here. I just took a two year break from CF and my brain is a bit out of shape... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Using both Plain Text and HTML in cfmail
Hi, i want to send both plain text and HTML in a mail. I searche dthe web and found the following code cfset boundary = CreateUUID() cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test server=localhost cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html --#boundary#-- /cfmail but it is sending blank mail. can anyone help me with this please [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Both Plain Text and HTML in cfmail
Hi, i want to send both plain text and HTML in a mail. I searche dthe web and found the following code cfset boundary = CreateUUID() cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test server=localhost cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html --#boundary#-- /cfmail but it is sending blank mail. can anyone help me with this please [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Both Plain Text and HTML in cfmail
Any help? http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 3 http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid =3threadid=875453 threadid=875453 Watch for the wrap. -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Both Plain Text and HTML in cfmail
Thanks for the help but link is not working Hi, i want to send both plain text and HTML in a mail. I searche dthe web and found the following code cfset boundary = CreateUUID() cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=test server=localhost cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit This is the plain text message for the email. --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable html head titleHTML Message/title /head body This is the HTML text message for the email. /body /html --#boundary#-- /cfmail but it is sending blank mail. can anyone help me with this please [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Javascript delete confirmation
I know I've seen this on the list before, but I can't find it in the archives, and my mind is pulling a blank on this.How do I pop up a _javascript_ yes/no pop up when someone clicks on a delete button to delete a record? T [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript delete confirmation
var answer = confirm('Do you want to delete');
if (answer) {
//do delete action
}
--
dc
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Javascript delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to delete a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Both Plain Text and HTML in cfmail
http://tinyurl.com/625zp... does that work? -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Both Plain Text and HTML in cfmail
yeah that link is working but i am also facing the same problem and i am using Windows 2000 Server Cold Fusion v. MX 6.0 any help?? http://tinyurl.com/625zp... does that work? -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: stored procedures
Stored procedures are NOT pre-compiled. This is a common made mistake. Only the execution plan gets cached, but the stored procedure is compiled upon execution. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Both Plain Text and HTML in cfmail
I have a (incomplete but working) set of custom tags that I created to do this if you contact me offlist I can forward them to you (danlance at runbox dot com) Cheers Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Farcry x SpeckCMS: The best CMS is....
OK Micha but inexpensive, free, cheap maybe only Farcry and SpeckCMS On Thu, 26 Aug 2004 08:22:39 +0200, Micha Schopman [EMAIL PROTECTED] wrote: There are more CMS systems written with CFML, do not forget PaperThin. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hal Helms Java For CF Developers class?
Is there anyone on the list that has attended any of Hal Helms' training classes?I am interested in his Java For CF Developers but would like feedback from anyone who has taken it or any of his other classes. Also, the only contact info on his web site is an email address and so far I am unable to get him to respond.My employer (who is paying the tab) is starting to wonder if this training is legitimate because no one gets back to us with our questions.Does anyone know how to reach him?I know he posts here sometimes--are you out there Hal? Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
Can you really say that for Oracle? Point out any material on the net that talks about it? I'm actually curious about this. So if you have any links that talk further about this that would be great. Ian -- Ian Sheridan http://www.savagevines.com -- - Original Message - From: Micha Schopman [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 12:53:28 +0200 Subject: RE: stored procedures To: CF-Talk [EMAIL PROTECTED] Stored procedures are NOT pre-compiled. This is a common made mistake. Only the execution plan gets cached, but the stored procedure is compiled upon execution. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript delete confirmation
Or a shorter inline version...
input type=submit name=submit value=Delete >
confirm('You sure?') /
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 11:22
To: CF-Talk
Subject: Re: _javascript_ delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to delete
a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: querying an array?
why don't you just place the array in a query and query that query? (might be overkill though) or loop through the array and output only the rows that don't have Green in row[n][3] Ian -- Ian Sheridan http://www.savagevines.com -- - Original Message - From: mc [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 11:33:51 +0200 Subject: querying an array? To: CF-Talk [EMAIL PROTECTED] I've got a shopping cart that is in an array (stored in a session). It looks like this: ItemQuantityType - pepper2green avocado 1green carrot3not green eggplant1not green celery5green What I need to do is figure out the total quantity of not green items and green items (in this case, 8 green items; 4 not green items). I'm not at all sure how to go about this, as I've always used databases and queries to do this sort of thing. Am I out of luck or is there some way to query the data in an array that isn't too horribly complicated? P.S. Please forgive me if this issue has already been dealt with here. I just took a two year break from CF and my brain is a bit out of shape... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Both Plain Text and HTML in cfmail
Any reaason you're not using the built-in cfmailpart tags? cfmail from= to= subject= charset=UTF-8 cfmailpart type=text wraptext=74 /cfmailpart cfmailpart type=html /cfmailpart /cfmail -Original Message- From: simmyana a [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 11:51 To: CF-Talk Subject: Re: Both Plain Text and HTML in cfmail yeah that link is working but i am also facing the same problem and i am using Windows 2000 Server Cold Fusion v. MX 6.0 any help?? http://tinyurl.com/625zp... does that work? -- dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript delete confirmation
Yup, definately shorter but not as reusable. Fire the function I posted into a
commonfunctions .js file, and have it included in your page and you can use it
any time you need.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
Or a shorter inline version...
input type=submit name=submit value=Delete >
confirm('You sure?') /
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 11:22
To: CF-Talk
Subject: Re: _javascript_ delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to delete
a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Javascript delete confirmation
I'd have to disagree with this one. I'm all for reusable code but I think in
this instance it's not needed. I guess if the URL is being changed from that
of the action attribute of the form then maybe it's ok, but other than that
I'd rather just have the code in the onclick of the button/form tag.
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 12:52
To: CF-Talk
Subject: RE: _javascript_ delete confirmation
Yup, definately shorter but not as reusable. Fire the function I posted into
a
commonfunctions .js file, and have it included in your page and you can use
it
any time you need.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
Or a shorter inline version...
input type=submit name=submit value=Delete >
confirm('You sure?') /
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 11:22
To: CF-Talk
Subject: Re: _javascript_ delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to
delete
a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Javascript delete confirmation
That's fair enough. I've always got it in my apps because in the large majority
of cases I've got delete actions for numerous things, whether it be users,
articles, images, whatever ... so it definately comes in handier in that
situaiton.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
I'd have to disagree with this one. I'm all for reusable code but I think in
this instance it's not needed. I guess if the URL is being changed from that
of the action attribute of the form then maybe it's ok, but other than that
I'd rather just have the code in the onclick of the button/form tag.
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 12:52
To: CF-Talk
Subject: RE: _javascript_ delete confirmation
Yup, definately shorter but not as reusable. Fire the function I posted into
a
commonfunctions .js file, and have it included in your page and you can use
it
any time you need.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
Or a shorter inline version...
input type=submit name=submit value=Delete >
confirm('You sure?') /
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 11:22
To: CF-Talk
Subject: Re: _javascript_ delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to
delete
a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Photo Album Modification
Isn't this actually just using the target=_blank attribute though? All
you've done here, as I see it, is to not use the target attribute in the
tag, but use your _javascript_ to add the target attribute to the tag. Now
I haven't really gotten into xhtml compliance, but I don't understand
the logic here? Why not go ahead and use target=_blank in your code,
if you're going to use a js to put it there anyway
--Ferg
_
Yes, you can open in a new window with XHTML, just not using the
target=_blank attribute which is wicked and nasty in XHTML and will
get
you banished from the kingdom.Do not pass go and do not collect $200.
I open external links usually in a new window, and while you can't use
the
target attribute, you can do it another way that's valid XHTML1.0
Strict,
but it uses a tiny amount of _javascript_.
To open in a new window using XHTML make your links like this:
[code]
.a href="" rel=externalMacromedia/a
[/code]
And you have a tiny piece of _javascript_ that you can have as an external
file referred to in the header (I call mine 'external.js'):
[code]
function externalLinks() {
if (!document.getElementsByTagName) return;
var anchors = document.getElementsByTagName(a);
for (var i=0; ianchors.length; i++) {
var anchor = anchors[i];
if (anchor.getAttribute(href)
anchor.getAttribute(rel) == external)
anchor.target = _blank;
}
}
window.>
[/code]
Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: stored procedures
True, but coming up with the execution plan is what takes the longest and has the greatest impact on the server.So by having a SP once it is executed and that execution plan is cached they become very quick. For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables.The 1st time it is run it takes about 10-15 seconds to return 2,100 rows.If I wait a few seconds and run it again it takes about 3 seconds to return the same rows.That is where the benefit of SP's are, that once run all future runs are significantly faster. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 6:53 AM To: CF-Talk Subject: RE: stored procedures Stored procedures are NOT pre-compiled. This is a common made mistake. Only the execution plan gets cached, but the stored procedure is compiled upon execution. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Safari cache issue
We have a CFMX application which employs a frameset. A main frame for the site and a sub frame which acts like a shopping basket. The idea is that the customer clicks on items within the main frame, which in turn reloads the sub frame. This action (via a url variable) allows us to append to a session array (a list of id's in the shopping basket) and so display a revised shopping basket with the appropriate items within it. This works very well in all the browsers that we've tested (PC IE/Netscape, Mac IE). However within Safari on Mac OSX (we're trying v1.1 on OS X 10.3) the sub frame misbehaves as it will use any opportunity to display a cached version. The sub frame is updated by a _javascript_ line on the main page like this: top.subFrame.document.location.href=""> where thisUrl is the cfm page with its various URL params. In trying to solve this we have added the following META tags: META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=Mon, 26 Jul 1997 05:00:00 GMT META HTTP-EQUIV=Last-Modified CONTENT=cfoutput#DateFormat(now(), 'ddd, dd mmm hh:mm:ss')#/cfoutput GMT META HTTP-EQUIV=Cache-Control CONTENT=no-store, no-cache, must-revalidate, max-age=0 META HTTP-EQUIV=Cache-Control CONTENT=post-check=0, pre-check=0 but still to no avail! Anyone have any cunning suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
hey this might sound lame to some of you that use stored procedures and i apologize, but what is the point or what is the benefit rather? from what i have read so far i havent seen a point, but maybe i just dont understand the concept completely. whats hard about saying cfquery.../ cfquery... / ... if 1 query sets off another, why not just write it out?? maybe im missing the concept like i said, so if anyone has an example they wish to share please enlighten me. thanks. joe Asside from the mentioned performance improvement (execution plans are pre-compiled and stored), stored procedures also provide better encapsulation. In other words, if you write it out and then later discover that you need the same set of queries on several pages, you have to decide how to reuse those queries, from the worse (cut and paste) to the best alternatives (custom tag, function or cfc method and/or stored procedure -- I prefer to use a custom tag and/or function that automates the stored procedure, saves me lots and lots of keystrokes in the CF template). And then there's also the fact that stored procedures are immune to SQL injection attacks. DBA's like them in some environments where the DBA is separate from the CF scripting department (not often in my experience) because they let the DBA maintain strict control over data access -- which can also go back to that issue of better encapsulation if the CF scripts aren't the only point of access to the database - the stored procedures can be reused by multiple applications which might access that database (cf scripts, client-server apps, etc - this can be important in enterprise environments where the database is shared amongst many departments). s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Farcry x SpeckCMS: The best CMS is....
Well if cheap qualifies, there are a handfull of those... SparkPlug for instance... I don't care for any of them myself... at least none of the ones I've looked at. Haven't made the time to install FarCry yet... never heard of Speck. OK Micha but inexpensive, free, cheap maybe only Farcry and SpeckCMS On Thu, 26 Aug 2004 08:22:39 +0200, Micha Schopman [EMAIL PROTECTED] wrote: There are more CMS systems written with CFML, do not forget PaperThin. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: querying an array?
(assuming your cart is an array of structures...)
cfscript
var green = 0;
var not_green = 0;
for (i=1; i LTE arrayLen(session.cartArrayName); i=i+1) {
if (cartArrayName[i].Type is green) {
green = green + 1;
} else {
not_green = not_green + 1;
}
}
/cfscript
On Thu, 26 Aug 2004 11:33:51 +0200, mc [EMAIL PROTECTED] wrote:
I've got a shopping cart that is in an array (stored in a session). It looks
like this:
ItemQuantityType
-
pepper2green
avocado 1green
carrot3not green
eggplant1not green
celery5green
What I need to do is figure out the total quantity of not green items and
green items (in this case, 8 green items; 4 not green items).
I'm not at all sure how to go about this, as I've always used databases and
queries to do this sort of thing. Am I out of luck or is there some way to
query the data in an array that isn't too horribly complicated?
P.S. Please forgive me if this issue has already been dealt with here. I
just took a two year break from CF and my brain is a bit out of shape...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: stored procedures
That is where the benefit of SP's are, that once run all future runs are significantly faster. I think that this isn't always true. It depends what statements are within the SP. It's possible that an SP could produce various execution plans and the one that's cached might not be the best one for future calls. In the past I've seen (and been guilty of writing) SPs that do significantly different things depending on the incoming params. I did have some good links with more specific details but I can't remember/find them at the moment. Anyone care to elaborate? Ade -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 13:53 To: CF-Talk Subject: RE: stored procedures True, but coming up with the execution plan is what takes the longest and has the greatest impact on the server.So by having a SP once it is executed and that execution plan is cached they become very quick. For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables.The 1st time it is run it takes about 10-15 seconds to return 2,100 rows.If I wait a few seconds and run it again it takes about 3 seconds to return the same rows.That is where the benefit of SP's are, that once run all future runs are significantly faster. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Javascript delete confirmation
I'm going to go with Andy on this one only because I've been 'taught'
not to put an onclick event on a submit button...that a submit button
should trigger an onsubmit.
Of course, that doesn't mean you still can't keep it inline...but i'd
put it in the form tag using the onsubmit event.
On Thu, 26 Aug 2004 13:36:31 +0100, Andy Allan
[EMAIL PROTECTED] wrote:
That's fair enough. I've always got it in my apps because in the large majority
of cases I've got delete actions for numerous things, whether it be users,
articles, images, whatever ... so it definately comes in handier in that
situaiton.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
I'd have to disagree with this one. I'm all for reusable code but I think in
this instance it's not needed. I guess if the URL is being changed from that
of the action attribute of the form then maybe it's ok, but other than that
I'd rather just have the code in the onclick of the button/form tag.
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 12:52
To: CF-Talk
Subject: RE: _javascript_ delete confirmation
Yup, definately shorter but not as reusable. Fire the function I posted into
a
commonfunctions .js file, and have it included in your page and you can use
it
any time you need.
Andy
Quoting Adrian Lynch [EMAIL PROTECTED]:
Or a shorter inline version...
input type=submit name=submit value=Delete >
confirm('You sure?') /
Ade
-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED]
Sent: 26 August 2004 11:22
To: CF-Talk
Subject: Re: _javascript_ delete confirmation
function confirmDelete(aURL) {
if(confirm(Do you really want to delete?))
document.location=aURL;
}
Andy
Quoting Thane Sherrington [EMAIL PROTECTED]:
I know I've seen this on the list before, but I can't find it in the
archives, and my mind is pulling a blank on this.How do I pop up a
_javascript_ yes/no pop up when someone clicks on a delete button to
delete
a
record?
T
--
[EMAIL PROTECTED]
www.creative-restraint.co.uk
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: stored procedures
Within SQL Server the execution plan is only re-generated on request when the stored procedure contains statements which dynamically change the stored procedure. Input and output parameters, have no effect on the execution plan, they are pre-cached also even if they are not used. I have increased application performance drastically, by using stored procedures and putting some application logic in them. Recursive tree's, workflow, versioning, all handled by stored procedures and they only require one call from within CFML instead of the usally 10+ db calls. You have to experience the improvements in speed, to believe the importancy of stored procedures and you got to have the nerve to put some of the application logic into a stored procedure. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
Well, just like any programming solution, an SP can be inefficient if it is poorly written. Relational DBMS's are very good at performing just that: relational database queries. We found terrific performance enhancements when we converted long, iterative CF processes into relational stored procedures. However, when these same processes were converted into iterative stored procedures (using cursors and the like), the performance gain was virtually niland sometimes worse. Brian - Original Message - From: Adrian Lynch To: CF-Talk Sent: Thursday, August 26, 2004 8:44 AM Subject: RE: stored procedures That is where the benefit of SP's are, that once run all future runs are significantly faster. I think that this isn't always true. It depends what statements are within the SP. It's possible that an SP could produce various execution plans and the one that's cached might not be the best one for future calls. In the past I've seen (and been guilty of writing) SPs that do significantly different things depending on the incoming params. I did have some good links with more specific details but I can't remember/find them at the moment. Anyone care to elaborate? Ade -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 13:53 To: CF-Talk Subject: RE: stored procedures True, but coming up with the execution plan is what takes the longest and has the greatest impact on the server.So by having a SP once it is executed and that execution plan is cached they become very quick. For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables.The 1st time it is run it takes about 10-15 seconds to return 2,100 rows.If I wait a few seconds and run it again it takes about 3 seconds to return the same rows.That is where the benefit of SP's are, that once run all future runs are significantly faster. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript delete confirmation
Who taught you that then and why? :OD Ade -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 14:42 To: CF-Talk Subject: Re: _javascript_ delete confirmation I'm going to go with Andy on this one only because I've been 'taught' not to put an onclick event on a submit button...that a submit button should trigger an onsubmit. Of course, that doesn't mean you still can't keep it inline...but i'd put it in the form tag using the onsubmit event. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Safari cache issue
Try adding this header (which is a real header, not a meta-equiv header) cfheader name=Cache-Control value=no-cache Mark -Original Message- From: Andrzej Michalski [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:06 AM To: CF-Talk Subject: Safari cache issue We have a CFMX application which employs a frameset. A main frame for the site and a sub frame which acts like a shopping basket. The idea is that the customer clicks on items within the main frame, which in turn reloads the sub frame. This action (via a url variable) allows us to append to a session array (a list of id's in the shopping basket) and so display a revised shopping basket with the appropriate items within it. This works very well in all the browsers that we've tested (PC IE/Netscape, Mac IE). However within Safari on Mac OSX (we're trying v1.1 on OS X 10.3) the sub frame misbehaves as it will use any opportunity to display a cached version. The sub frame is updated by a _javascript_ line on the main page like this: top.subFrame.document.location.href=""> where thisUrl is the cfm page with its various URL params. In trying to solve this we have added the following META tags: META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=Mon, 26 Jul 1997 05:00:00 GMT META HTTP-EQUIV=Last-Modified CONTENT=cfoutput#DateFormat(now(), 'ddd, dd mmm hh:mm:ss')#/cfoutput GMT META HTTP-EQUIV=Cache-Control CONTENT=no-store, no-cache, must-revalidate, max-age=0 META HTTP-EQUIV=Cache-Control CONTENT=post-check=0, pre-check=0 but still to no avail! Anyone have any cunning suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: stored procedures
And then there's also the fact that stored procedures are immune to SQL injection attacks. One sidenote, it is possible to use SQL Injection attacks on SQL Server while still using stored procedures. For example using Full Text Indexing commands, it is fairly simple to provide a SQL injection as a parameter of the full text search commands. It also depends on how you build up the thing. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX 6.1 Updater Now Available
http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_updater.htm Think of this as ColdFusion MX 6.1+.It's a recommended update.We just wrapped up the Beta program, it's good solid stuff, and basically a single-click install. New for this Updater, if you're running in a deployed-on-JRun configuration, we automatically update you in a single click with this one. Regards, Damon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
You're absolutely right, Adrian. Let's say you create a stored procedure on SQL Server 2000 that takes a parameter.The first time this sp is executed, the database will settle on a lost-cost execution plan, compile it, and then reuse that plan every other time the sp is executed (until SQL2K is cycled or some directive demands otherwise). But let's say the parameter you first used was of such low selectivity that the execution plan used a table scan instead of engaging an index to do its job.Now, if you call the same sp using a parameter of high selectivity -- one that would engage an index for efficiency -- your performance will be less than if you had submitted your query as a simple batch using CFQUERY, because the sp uses the same execution plan it did for the first run, meaning it performs a full table scan to match only a few rows. You can specify a stored procedure to always recompile its execution plan by adding WITH RECOMPILE to its declaration, or you can specify a stored procedure to selectively recompile by calling it using WITH RECOMPILE, though there doesn't appear to be a direct mechanism for specifying the latter method from ColdFusion. Judging whether or not to recompile execution plans should be carefully considered based on IO statistics you gather during testing and through an understanding of how the values of parameters and indexes affect selectivity. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:44 AM Subject: RE: stored procedures That is where the benefit of SP's are, that once run all future runs are significantly faster. I think that this isn't always true. It depends what statements are within the SP. It's possible that an SP could produce various execution plans and the one that's cached might not be the best one for future calls. In the past I've seen (and been guilty of writing) SPs that do significantly different things depending on the incoming params. I did have some good links with more specific details but I can't remember/find them at the moment. Anyone care to elaborate? Ade -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 13:53 To: CF-Talk Subject: RE: stored procedures True, but coming up with the execution plan is what takes the longest and has the greatest impact on the server.So by having a SP once it is executed and that execution plan is cached they become very quick. For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables.The 1st time it is run it takes about 10-15 seconds to return 2,100 rows.If I wait a few seconds and run it again it takes about 3 seconds to return the same rows.That is where the benefit of SP's are, that once run all future runs are significantly faster. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: stored procedures
Okay... without going out of your way to provide a means of creating sql injection attacks. :P Seven years doing this work, I've only ever heard of one person actually using SQL Server's full-text indexes (and that was someone I wasn't working with)... doesn't mean that people aren't, but my experience has been that they're the exception rather than the rule. And then there's also the fact that stored procedures are immune to SQL injection attacks. One sidenote, it is possible to use SQL Injection attacks on SQL Server while still using stored procedures. For example using Full Text Indexing commands, it is fairly simple to provide a SQL injection as a parameter of the full text search commands. It also depends on how you build up the thing. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Gmail Accounts
Who wants one? I have 4. First 4 to respond get them. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Gmail Accounts
memememe -Original Message- From: Ryan Mannion [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 15:13 To: CF-Talk Subject: Gmail Accounts Who wants one? I have 4. First 4 to respond get them. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Safari cache issue
Mark, you're a star! This works perfectly... Try adding this header (which is a real header, not a meta-equiv header) cfheader name=Cache-Control value=no-cache Mark -Original Message- From: Andrzej Michalski [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:06 AM To: CF-Talk Subject: Safari cache issue We have a CFMX application which employs a frameset. A main frame for the site and a sub frame which acts like a shopping basket. The idea is that the customer clicks on items within the main frame, which in turn reloads the sub frame. This action (via a url variable) allows us to append to a session array (a list of id's in the shopping basket) and so display a revised shopping basket with the appropriate items within it. This works very well in all the browsers that we've tested (PC IE/Netscape, Mac IE). However within Safari on Mac OSX (we're trying v1.1 on OS X 10.3) the sub frame misbehaves as it will use any opportunity to display a cached version. The sub frame is updated by a _javascript_ line on the main page like this: top.subFrame.document.location.href=""> where thisUrl is the cfm page with its various URL params. In trying to solve this we have added the following META tags: META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=Mon, 26 Jul 1997 05:00:00 GMT META HTTP-EQUIV=Last-Modified CONTENT=cfoutput#DateFormat(now(), 'ddd, dd mmm hh:mm:ss')#/cfoutput GMT META HTTP-EQUIV=Cache-Control CONTENT=no-store, no-cache, must-revalidate, max-age=0 META HTTP-EQUIV=Cache-Control CONTENT=post-check=0, pre-check=0 but still to no avail! Anyone have any cunning suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: querying an array?
Instead of just incrementing the counter, wouldn't he need to add
cartArrayName[i].Number to the var?
Dan
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 06:39:17 -0700
Subject: Re: querying an array?
To: CF-Talk [EMAIL PROTECTED]
(assuming your cart is an array of structures...)
cfscript
var green = 0;
var not_green = 0;
for (i=1; i LTE arrayLen(session.cartArrayName); i=i+1) {
if (cartArrayName[i].Type is green) {
green = green + 1;
} else {
not_green = not_green + 1;
}
}
/cfscript
On Thu, 26 Aug 2004 11:33:51 +0200, mc [EMAIL PROTECTED] wrote:
I've got a shopping cart that is in an array (stored in a session). It looks
like this:
ItemQuantityType
-
pepper2green
avocado 1green
carrot3not green
eggplant1not green
celery5green
What I need to do is figure out the total quantity of not green items and
green items (in this case, 8 green items; 4 not green items).
I'm not at all sure how to go about this, as I've always used databases and
queries to do this sort of thing. Am I out of luck or is there some way to
query the data in an array that isn't too horribly complicated?
P.S. Please forgive me if this issue has already been dealt with here. I
just took a two year break from CF and my brain is a bit out of shape...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Gmail Accounts
Still got em? Ken Ferguson Fitz and Floyd http://www.fitzandfloyd.com http://www.fitzandfloyd.com http://www.exclusivelyfitz.com http://www.exclusivelyfitz.com/ http://stores.ebay.com/fitzandfloydscharmingtails _ From: Ryan Mannion [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:13 AM To: CF-Talk Subject: Gmail Accounts Who wants one? I have 4. First 4 to respond get them. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Gmail Accounts
Maybe it is just me, but honestly, I don't quite get the gmail hype. But, having said that, 3 invites available ... reply *OFF LIST* please. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:20 AM To: CF-Talk Subject: RE: Gmail Accounts memememe -Original Message- From: Ryan Mannion [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 15:13 To: CF-Talk Subject: Gmail Accounts Who wants one? I have 4. First 4 to respond get them. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mail of the G
In a mad attempt to flood Gmail with only those who write cf code, I too have a few gmail invites to offer - let me know if you want one (people who use software I help develop get preference obviously) :-D -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Gmail Accounts - Enough already
Ok just a question here. Which part of the take the gmail talk and offers to CF Community did we not understand? I'm all up for sharing, cause I learned that in kindergarten as well, but it's REALLY off topic for CF-Talk. ERJ -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:16 AM To: CF-Talk Subject: RE: Gmail Accounts Still got em? Ken Ferguson Fitz and Floyd http://www.fitzandfloyd.com http://www.fitzandfloyd.com http://www.exclusivelyfitz.com http://www.exclusivelyfitz.com/ http://stores.ebay.com/fitzandfloydscharmingtails _ From: Ryan Mannion [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:13 AM To: CF-Talk Subject: Gmail Accounts Who wants one? I have 4. First 4 to respond get them. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
Input and output parameters, have no effect on the execution plan Actually, they often have a *huge* impact on how a query execution plan is compiled.My earlier post on this explains it a little. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
In Oracle, stored procedures are compiled when you create them (i.e. run the CREATE PROCEDURE/FUNCTION/PACKAGE/TRIGGER statement). The first time you call an Oracle Stored Procedure it is loaded into Oracle's memory (shared pool of the SGA).The stored procedure will stay there until it is paged out (to make room for other stored procedures).Once the procedure has been loaded into memory, it will execute quickly and the copy in memory will be used for subsequent calls.There are some things that can be done by the DBA to keep stored procedures in memory (pinning). In Oracle, execution plans are usually associated with SQL statements not with Stored Procedures. I am not sure how stored procedures and execution plans are used in other database environments or how the term compile is defined for those environments. Janet At 07:43 AM 8/26/2004 -0400, you wrote: Can you really say that for Oracle? Point out any material on the net that talks about it? I'm actually curious about this. So if you have any links that talk further about this that would be great. Ian - Original Message - From: Micha Schopman [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 12:53:28 +0200 Subject: RE: stored procedures To: CF-Talk [EMAIL PROTECTED] Stored procedures are NOT pre-compiled. This is a common made mistake. Only the execution plan gets cached, but the stored procedure is compiled upon execution. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Calendar CFC, app, etc.
Can anyone point to a recommended Calendar CFC, app, tags, etc.? I'm looking for something that will accommodate an admin for adding and editing, and will distinguish between events that recur and those that are one-time. I have several sites with calendars now, but always looking for the next best thing! Thanks in advance, James Edmunds [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Javascript delete confirmation
Charlie Griefer wrote: I'm going to go with Andy on this one only because I've been 'taught' not to put an onclick event on a submit button...that a submit button should trigger an onsubmit. Of course, that doesn't mean you still can't keep it inline...but i'd put it in the form tag using the onsubmit event. Yeah - definately use onSubmit for events from submit buttons. onClick on a submit button _will_ do bizarre things and is not cross browser compatible. The onClick may or may not get processed (depending on which browser the user is using and how that browser is feeling that day), because the form is already in the process of being submitted. onClick on a button button is fine, but is a definate no-no on a submit button. Stephen -- Stephen Moretti - Director Moretti Consulting Limited http://www.moretticonsulting.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Gmail Accounts
I, too, have several gmail invites available, please email me offlist if anyone would like one. Matt On Thu, 26 Aug 2004 10:20:14 -0400, Ben Forta [EMAIL PROTECTED] wrote: Maybe it is just me, but honestly, I don't quite get the gmail hype. But, having said that, 3 invites available ... reply *OFF LIST* please. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:20 AM To: CF-Talk Subject: RE: Gmail Accounts memememe -Original Message- From: Ryan Mannion [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 15:13 To: CF-Talk Subject: Gmail Accounts Who wants one? I have 4. First 4 to respond get them. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Safari cache issue
Got a URL? I use routinely use frame like this on Safari without problems Dick On Aug 26, 2004, at 6:06 AM, Andrzej Michalski wrote: We have a CFMX application which employs a frameset. A main frame for the site and a sub frame which acts like a shopping basket. The idea is that the customer clicks on items within the main frame, which in turn reloads the sub frame. This action (via a url variable) allows us to append to a session array (a list of id's in the shopping basket) and so display a revised shopping basket with the appropriate items within it. This works very well in all the browsers that we've tested (PC IE/Netscape, Mac IE). However within Safari on Mac OSX (we're trying v1.1 on OS X 10.3) the sub frame misbehaves as it will use any opportunity to display a cached version. The sub frame is updated by a _javascript_ line on the main page like this: top.subFrame.document.location.href=""> where thisUrl is the cfm page with its various URL params. In trying to solve this we have added the following META tags: META HTTP-EQUIV=Pragma CONTENT=no-cache META HTTP-EQUIV=Expires CONTENT=Mon, 26 Jul 1997 05:00:00 GMT META HTTP-EQUIV=Last-Modified CONTENT=cfoutput#DateFormat(now(), 'ddd, dd mmm hh:mm:ss')#/cfoutput GMT META HTTP-EQUIV=Cache-Control CONTENT=no-store, no-cache, must-revalidate, max-age=0 META HTTP-EQUIV=Cache-Control CONTENT=post-check=0, pre-check=0 but still to no avail! Anyone have any cunning suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Javascript delete confirmation
what Stephen said (except in all lowercase for XHTML compatibility):) On Thu, 26 Aug 2004 15:29:31 +0100, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Charlie Griefer wrote: I'm going to go with Andy on this one only because I've been 'taught' not to put an onclick event on a submit button...that a submit button should trigger an onsubmit. Of course, that doesn't mean you still can't keep it inline...but i'd put it in the form tag using the onsubmit event. Yeah - definately use onSubmit for events from submit buttons. onClick on a submit button _will_ do bizarre things and is not cross browser compatible. The onClick may or may not get processed (depending on which browser the user is using and how that browser is feeling that day), because the form is already in the process of being submitted. onClick on a button button is fine, but is a definate no-no on a submit button. Stephen -- Stephen Moretti - Director Moretti Consulting Limited http://www.moretticonsulting.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: querying an array?
hmm...probably :)
Guess I didn't look at it closely enough (it was well before my first
cup of coffee...which is now sitting in front of me).
Change:
green = green + 1;
To:
green = green + cartArrayName[i].Quantity;
...and same for 'not_green'.
Good catch :)
On Thu, 26 Aug 2004 10:15:00 -0400, Dan O'Keefe [EMAIL PROTECTED] wrote:
Instead of just incrementing the counter, wouldn't he need to add
cartArrayName[i].Number to the var?
Dan
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
Date: Thu, 26 Aug 2004 06:39:17 -0700
Subject: Re: querying an array?
To: CF-Talk [EMAIL PROTECTED]
(assuming your cart is an array of structures...)
cfscript
var green = 0;
var not_green = 0;
for (i=1; i LTE arrayLen(session.cartArrayName); i=i+1) {
if (cartArrayName[i].Type is green) {
green = green + 1;
} else {
not_green = not_green + 1;
}
}
/cfscript
On Thu, 26 Aug 2004 11:33:51 +0200, mc [EMAIL PROTECTED] wrote:
I've got a shopping cart that is in an array (stored in a session). It looks
like this:
ItemQuantityType
-
pepper2green
avocado 1green
carrot3not green
eggplant1not green
celery5green
What I need to do is figure out the total quantity of not green items and
green items (in this case, 8 green items; 4 not green items).
I'm not at all sure how to go about this, as I've always used databases and
queries to do this sort of thing. Am I out of luck or is there some way to
query the data in an array that isn't too horribly complicated?
P.S. Please forgive me if this issue has already been dealt with here. I
just took a two year break from CF and my brain is a bit out of shape...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: stored procedures
As far as I know this was only the case with versions before SQL Server 2000, not with 2000, but the DBA here is gonna do some testing with it. I am curious if this is still the case. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: stored procedures
Janet Schmitt wrote: In Oracle, stored procedures are compiled when you create them (i.e. run the CREATE PROCEDURE/FUNCTION/PACKAGE/TRIGGER statement). The first time you call an Oracle Stored Procedure it is loaded into Oracle's memory (shared pool of the SGA).The stored procedure will stay there until it is paged out (to make room for other stored procedures).Once the procedure has been loaded into memory, it will execute quickly and the copy in memory will be used for subsequent calls.There are some things that can be done by the DBA to keep stored procedures in memory (pinning). In Oracle, execution plans are usually associated with SQL statements not with Stored Procedures. Regardless of what terminology is commonly used, the principles that Adam Churvis explained so eloquently apply to all databases that use cost-based optimization. (Allthough database vendors are working on technology that might change that in the future, e.g. http://www.almaden.ibm.com/software/dm/SMART/LeoVLDB01.pdf). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Open Source Poll Tag
Does anyone know of a good open source poll tag? I spent some time downloading and setting up a number of them I found on the MM Exchange and via Google, and was shocked at how bad some of them were. Most didn't function at all. Any pointers to good stuff would be much appreciated. At minimum, I'm looking for something un-encrypted and free. The best case is a open source version that I can use to integrate poll functionality into a couple of commercial apps. Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Open Source Poll Tag
iPoll ColdFusion Poll System is cool... Look in dev exchange cheers On Thu, 26 Aug 2004 10:06:42 -0500, Jake [EMAIL PROTECTED] wrote: Does anyone know of a good open source poll tag? I spent some time downloading and setting up a number of them I found on the MM Exchange and via Google, and was shocked at how bad some of them were. Most didn't function at all. Any pointers to good stuff would be much appreciated. At minimum, I'm looking for something un-encrypted and free. The best case is a open source version that I can use to integrate poll functionality into a couple of commercial apps. Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: take a long lunch today, boys and girls
Internet Meltdown taking place today: http://www.webprowire.com/summaries/855830.html Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Use CF to delete directory and files in it?
I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Unique cookie ID
Hi All, I have a situation in which we have users coming from aproxy server (using 1 IP) and we would like to know the unique users? Can this be done thru cookie or session vars. TIA, Patrick Whittingham _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Use CF to delete directory and files in it?
Create a batch file and use cfexecute. -Mark -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:36 AM To: CF-Talk Subject: Use CF to delete directory and files in it? I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Use CF to delete directory and files in it?
dependant on platform and if you have access, you could cfexecute a batch file -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF5 and CFMX storproc problem
I have a site running on CF5 that makes calls to a store procedure. I put that code on a new server running CFMX and I get a permissions problem. Executing stored procedures is not allowed. The data sources are configured the same and use the same database user account to connect. The only thing different is the version of CF. Any idea on how do I go about fixing it? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Use CF to delete directory and files in it?
cfdirectory (action="" returns a query object containing the files within the directory.You could just loop over that 'query' and use cffile with action="" prior to doing the cfdirectory with action=""> ? On Thu, 26 Aug 2004 10:36:10 -0500, Phill B [EMAIL PROTECTED] wrote: I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Use CF to delete directory and files in it?
I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. You might want to check the cf-talk archives -- I think I posted some code for this last week. It was an excerpt from the deltree.cfm tag in the onTap framework iirc. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Use CF to delete directory and files in it?
dependant on platform and if you have access, you could cfexecute a batch file Ick. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Use CF to delete directory and files in it?
Ick. Create a batch file and use cfexecute. -Mark -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 10:36 AM To: CF-Talk Subject: Use CF to delete directory and files in it? I'm trying to find a way to delete a directory with files in it. cfdirectory requires the the directory to be empty before you delete it. What is the best way to delete all the files in the folder? -- Phillip B. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript delete confirmation
lol, nice one. I use the onsubmit of the form tag, didn't think about the details earlier. Ade -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 15:56 To: CF-Talk Subject: Re: _javascript_ delete confirmation what Stephen said (except in all lowercase for XHTML compatibility):) On Thu, 26 Aug 2004 15:29:31 +0100, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Charlie Griefer wrote: I'm going to go with Andy on this one only because I've been 'taught' not to put an onclick event on a submit button...that a submit button should trigger an onsubmit. Of course, that doesn't mean you still can't keep it inline...but i'd put it in the form tag using the onsubmit event. Yeah - definately use onSubmit for events from submit buttons. onClick on a submit button _will_ do bizarre things and is not cross browser compatible. The onClick may or may not get processed (depending on which browser the user is using and how that browser is feeling that day), because the form is already in the process of being submitted. onClick on a button button is fine, but is a definate no-no on a submit button. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF5 and CFMX storproc problem
I have a site running on CF5 that makes calls to a store procedure. I put that code on a new server running CFMX and I get a permissions problem. Executing stored procedures is not allowed. The data sources are configured the same and use the same database user account to connect. The only thing different is the version of CF. Any idea on how do I go about fixing it? This may seem stupid, but are you absolutely sure the datasources are configured identically? I would recommend that you recheck your CFMX datasource - within the Advanced Settings, there's a set of checkboxes that you can use to limit what kinds of SQL statements are allowed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Using both Plain Text and HTML in cfmail
simmyana a wrote: i want to send both plain text and HTML in a mail. I searche dthe web and found the following code Are you using CF5 or CFMX?CFMX provides the ability to do this for you so you don't have to muck around with content boundaries and the like.See my May 2004 preso on SMTP and CFMAIL (slides 32 33 specifically) for more info: http://www.cfug-md.org/meetings/CF-SMTP/CF-SMTP.ppt -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: www.cfm-applications.com ???
OT here: Anyone know what happen to www.cfm-applications and/or its creator? I had it in my RSS feeds and its been erroring out for 7-10 days. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 Updater Now Available
On Thursday 26 Aug 2004 15:04 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_updater.ht m Great news, but do I really have to download it to read the install instructions ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF5 and CFMX storproc problem
Opps. I posted the old error. It is giving this one EXECUTE permission denied on object Both data sources allow stored procedures. - Original Message - From: Dave Watts [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 11:56:54 -0400 Subject: RE: CF5 and CFMX storproc problem To: CF-Talk [EMAIL PROTECTED] I have a site running on CF5 that makes calls to a store procedure. I put that code on a new server running CFMX and I get a permissions problem. Executing stored procedures is not allowed. The data sources are configured the same and use the same database user account to connect. The only thing different is the version of CF. Any idea on how do I go about fixing it? This may seem stupid, but are you absolutely sure the datasources are configured identically? I would recommend that you recheck your CFMX datasource - within the Advanced Settings, there's a set of checkboxes that you can use to limit what kinds of SQL statements are allowed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Both Plain Text and HTML in cfmail
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb3.htm#wp2732354 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Using both Plain Text and HTML in cfmail
Why not just use cfmailpart (if CFMX)?Am I missing something? Ray At 11:55 AM 8/26/2004, you wrote: simmyana a wrote: i want to send both plain text and HTML in a mail. I searche dthe web and found the following code Are you using CF5 or CFMX?CFMX provides the ability to do this for you so you don't have to muck around with content boundaries and the like.See my May 2004 preso on SMTP and CFMAIL (slides 32 33 specifically) for more info: http://www.cfug-md.org/meetings/CF-SMTP/CF-SMTP.ppt -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 Updater Now Available
FA writeup (issue coming out today) http://www.fusionauthority.com/Article1.cfm/ArticleID=4284 On Thursday 26 Aug 2004 15:04 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_updater.ht m Great news, but do I really have to download it to read the install instructions ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 Updater Now Available
BTW, one of the fixes in this update handles the obscure cfid/cftoken null null bug. Now that's an annoying one. FA writeup (issue coming out today) http://www.fusionauthority.com/Article1.cfm/ArticleID=4284 On Thursday 26 Aug 2004 15:04 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_updater.ht m Great news, but do I really have to download it to read the install instructions ? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Using both Plain Text and HTML in cfmail
Ray: That's exactly what slides 32 33 say to do (with sample code) 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ simmyana a wrote: i want to send both plain text and HTML in a mail. I searche dthe web and found the following code Mosh Teitelbaum wrote: Are you using CF5 or CFMX?CFMX provides the ability to do this for you so you don't have to muck around with content boundaries and the like.See my May 2004 preso on SMTP and CFMAIL (slides 32 33 specifically) for more info: http://www.cfug-md.org/meetings/CF-SMTP/CF-SMTP.ppt Ray Champagne wrote: Why not just use cfmailpart (if CFMX)?Am I missing something? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 Updater Now Available
No, you dont. http://www.macromedia.com/support/documentation/en/coldfusion/mx61updater/releasenotes_cfmx61_updater.html#installCFMXWindows -Adam - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] Date: Thu, 26 Aug 2004 17:01:56 +0100 Subject: Re: CFMX 6.1 Updater Now Available To: CF-Talk [EMAIL PROTECTED] On Thursday 26 Aug 2004 15:04 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_updater.ht m Great news, but do I really have to download it to read the install instructions ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Open Source Poll Tag
iPoll ColdFusion Poll System is cool... Look in dev exchange Yeah iPoll is nice, but I don't think it allows for commercial usage. Of course, the tag is 3 years old, perhaps the author would be willing to modify that. Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT- What makes a blog a blog?
Is a fully hardcode page with blog entries written in the text editor a blog? Is a CMS which allows users to create and edit files but doesn't allow comments a blog? >From a developer's perspective: what makes a blog a blog? -- just curious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
UML Modeling
Any tool recomendations for modeling a MX app's CFC's? Not the Rational Rose level, something within reach. I see Tigris has ArgoUML Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- What makes a blog a blog?
I'd say it's any ongoing communication between a person (or parties) and the general public via the Web (the via the Web part makes the 'general public' part a given).I don't think a particular format has anything to do with it, although there are obviously some formats that are significantly more popular than others. (would also suggest moving this thread to cf-community) :) On Thu, 26 Aug 2004 14:00:54 -0400, mayo [EMAIL PROTECTED] wrote: Is a fully hardcode page with blog entries written in the text editor a blog? Is a CMS which allows users to create and edit files but doesn't allow comments a blog? From a developer's perspective: what makes a blog a blog? -- just curious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- What makes a blog a blog?
google - define:blog http://www.google.com/search?q=define%3Ablog A blog is basically a journal that is available on the web. The activity of updating a blog is blogging and someone who keeps a blog is a blogger. Blogs are typically updated daily using software that allows people with little or no technical background to update and maintain the blog. Postings on a blog are almost always arranged in cronological order with the most recent additions featured most prominantly. If you want to get technical with this definition, a CMS is required (offline or online ones count), comments are not required. Though another further down the search probably defines it better: A web log: an on-line diary or frequently updated personal web page. -nathan strutz http://www.dopefly.com/techblog/-- mine mayo wrote: Is a fully hardcode page with blog entries written in the text editor a blog? Is a CMS which allows users to create and edit files but doesn't allow comments a blog? From a developer's perspective: what makes a blog a blog? -- just curious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UML Modeling
On Thu, 26 Aug 2004 14:07:33 -0400, Dan O'Keefe [EMAIL PROTECTED] wrote: Any tool recomendations for modeling a MX app's CFC's? Not the Rational Rose level, something within reach. I see Tigris has ArgoUML Posiedon for UML Community Edition[1] - supports UML 1.4 diagrams and allows for java code generation (at least it did in prior version, not totally sure about the current one.) Borland Together Community Edition[2] - supports UML 1.4 and 2.0 diagrams and also allows for data modeling. No code generation though Neither program will allow you to generate cfc code, but both will allow you to do the modeling. Both programs have limited support for outputing the diagrams, but both will allow for all diagrams to saved as images (gif, svg, jpeg, etc). [1] http://www.gentleware.com/products/descriptions/ce.php4 [2] http://www.borland.com/together/designerce/index.html -- chris johnston www.fuzzylizard.com For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk. Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- What makes a blog a blog?
I know what a blog is used for, why it's being used, etc... I was just wondering what makes a blog a blog? What features make it a blog? Is it simply a CMS or are there other features that make it a blog? Does it need the ability to comment? Does it need a cute little calendar? The reason I guess I started wondering is that my blog is a CMS I built for myself and friends and co-workers were saying that's not a blog Hence the post to the group. -- gil -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 1:12 PM To: CF-Talk Subject: Re: OT- What makes a blog a blog? google - define:blog http://www.google.com/search?q=define%3Ablog A blog is basically a journal that is available on the web. The activity of updating a blog is blogging and someone who keeps a blog is a blogger. Blogs are typically updated daily using software that allows people with little or no technical background to update and maintain the blog. Postings on a blog are almost always arranged in cronological order with the most recent additions featured most prominantly. If you want to get technical with this definition, a CMS is required (offline or online ones count), comments are not required. Though another further down the search probably defines it better: A web log: an on-line diary or frequently updated personal web page. -nathan strutz http://www.dopefly.com/techblog/-- mine mayo wrote: Is a fully hardcode page with blog entries written in the text editor a blog? Is a CMS which allows users to create and edit files but doesn't allow comments a blog? From a developer's perspective: what makes a blog a blog? -- just curious [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- What makes a blog a blog?
On Thu, 26 Aug 2004 14:25:12 -0400, mayo [EMAIL PROTECTED] wrote: I was just wondering what makes a blog a blog? What features make it a blog? Is it simply a CMS or are there other features that make it a blog? Does it need the ability to comment? Does it need a cute little calendar? I think the only thing that makes a blog a blog is that it be an online journal, i.e., weblog. The technology that drives the blog, whether that be hard coded or via a CMS, is inconsequential to the content that is being presented on the blog. In other words, what makes a blog a blog is the content and not the tech. -- chris johnston www.fuzzylizard.com For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk. Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UML Modeling
I like ArgoUML - it has the ability to export to the XMI standard (which is xml). >From there you can XSLT your way to CFCs. It also keeps you from being tied to just the one product. (As an aside, I am, amongst other things, working on a xslt to translate an XMI to CFCs.) If you want flexabilty with your modeling I would recommend you pick one that does support exporting to XMI. Argo is cool - its a bit slow and a bit non-intuitive but the best open source one I have found (aside from Dia (linux) and the one that comes free on Mac - which doesn't export to XMI) On Thu, 26 Aug 2004 14:07:33 -0400, Dan O'Keefe [EMAIL PROTECTED] wrote: Any tool recomendations for modeling a MX app's CFC's? Not the Rational Rose level, something within reach. I see Tigris has ArgoUML Dan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Regex to JS Regex
Has anyone converted this to work with _javascript_? This is the Regex from the isURL() UDF from cflib. I use the isURL on the server side and wanted to add something similar on the slient side but keep fialing to convert it correctly. ^(((https?:|ftp:|gopher:)\/\/))[-[:alnum:]\?%,\.\/##!@:=\+~_]+[A-Za-z0- 9\/]$ Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL questions
I have two questions. 1 - I have a list that I sort by last name (ORDER BY lname ASC).I don't have control over the data entry and noticed today that A-Z (uppercase) is before a-z (lowercase).Is there a way to get them to sort together (Aneka, botha,Sebrook, etc.)? 2 - I have a DEPARTMENT column which lists multiple departments. As a temporary kludge, I list all the departments in one column and separate them with a pipe |.For example, Kinesiology|Office of the DeanI need to be able to do a query for each department separately, so that I can list all the Office of the Dean people, which is it's own page.If I enter just Office of the Dean it works, but if it's Kinesiology|Office of the Dean, it doesn't show up.Here's the query: cfset people=Office of the Dean CFQUERY NAME=people_search DATASOURCE=dch SELECT id,fname,lname,type,title,dept,phone FROM PEOPLE WHERE dept LIKE '#people#' ORDER BY lname ASC /CFQUERY -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- What makes a blog a blog?
On Thu, 26 Aug 2004 14:25:12 -0400, mayo [EMAIL PROTECTED] wrote: I think the only thing that makes a blog a blog is that it be an online journal, i.e., weblog. The technology that drives the blog, whether that be hard coded or via a CMS, is inconsequential to the content that is being presented on the blog. In other words, what makes a blog a blog is the content and not the tech. I agree with that completely from the front end. From the back end, however, I wouldn't call a text editor, Dreamweaver, or a CMS is a blog. >From a developer's perspective I'd say those three things are tools that can be used for blogging, but are not blogging apps by definition. Jake --- BlogFusion - www.countersinkdg.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Regex to JS Regex
I am in a hurry, but I have two suggestions: 1) Check this reference: http://devedge.netscape.com/library/manuals/2000/_javascript_/1.5/guide/regexp .html 2) DW's search replace internally use a _javascript_ 1.5 engine, it can be handy for testing RegExp's patterns visually Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL questions
1. Try LCASE(lname) in the select statement 2. LIKE '%#people#%' -jc Daniel Kessler wrote: I have two questions. 1 - I have a list that I sort by last name (ORDER BY lname ASC).I don't have control over the data entry and noticed today that A-Z (uppercase) is before a-z (lowercase).Is there a way to get them to sort together (Aneka, botha,Sebrook, etc.)? 2 - I have a DEPARTMENT column which lists multiple departments. As a temporary kludge, I list all the departments in one column and separate them with a pipe |.For example, Kinesiology|Office of the DeanI need to be able to do a query for each department separately, so that I can list all the Office of the Dean people, which is it's own page.If I enter just Office of the Dean it works, but if it's Kinesiology|Office of the Dean, it doesn't show up.Here's the query: cfset people=Office of the Dean CFQUERY NAME=people_search DATASOURCE=dch SELECT id,fname,lname,type,title,dept,phone FROM PEOPLE WHERE dept LIKE '#people#' ORDER BY lname ASC /CFQUERY -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Webservice: argument type mismatch
Hi! I'm using a webservice to send a fax and I'm getting an error when calling one of the functions: Could not perform web service invocation SendfaxEx_2 because java.lang.IllegalArgumentException: argument type mismatch If I refresh the page a couple of times (10 to 15 times) the error message changes and I get this: Could not perform web service invocation SendfaxEx_2 because java.lang.IllegalArgumentException: [EMAIL PROTECTED] where the numbers at the end keep changing on refresh I think that the webservice is written in Asp.Net. This is the test code I'm using: !--- Create the webservice object --- cfset faxWebService = CreateObject(webservice, https://ws.interfax.net/dfs.asmx?WSDL) cfset faxID = faxWebService.SendfaxEx_2(aaa, aaa, 123123, , toBase64(), , , -00-00, 0,, , , subject, [EMAIL PROTECTED], A4, Portrait, true, false ) I've tried a lot of combinations for the parameters with no luck, the error is still there. Thanks for any help, mack / [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
