In a shared environment you have to ask yourself to what degree optimizing
the performance of your site's code is ultimately going to improve your
web site's performance. Even if you were to increase performance 10-fold
it's unlikely you'll see anywhere near that performance gain if there are
Hi,
I don't think this is particularly unusual...
While department B wants additional features and won't use some of the
existing, I am assuming that the features they share, and indeed the business
rules behind them all are common.
In that case, write an application that does everything for
Another thought.
Whatever you do, bear in mind that department C and D will be along soon with
their own requirements. You need to be able to design something whereby you can
accomodate this without multiplying the amount of code you produce. It's
probably worth thinking How will this look if
Yeah, that ought to work. CF can't see your sql if logic, so it might as
well be one giant select statement for all it cares. On the SQL Server end I
would expect it to handle that just fine.
You could also write a stored procedure for this logic.
Mark
-Original Message-
From:
From: Joe Eugene [mailto:[EMAIL PROTECTED]
We have a need to track Form Updates by users i.e. history of
updates to Forms.
Once the user submits a from after validation, we want to
track the updates done.
e.g.
User A can change their Credit card info several times on a
Form, we need to
Question for the Mach-II people on this list -
I have a dropdown box that appears on every page, in its own form on
each page of my small application. I'd like the most recently selected item
on this dropdown box to be selected whenever I move to a new page view. I
can set a variable that
I have realized that I am having a problem with client variables, but I
don't know why. I get this message when I try to set a client variable:
Message:
The requested scope client has not been enabled.
Details:
Before client variables can be used, the client state management system must
be
From: Matthew Small [mailto:[EMAIL PROTECTED]
Before client variables can be used, the client state
management system must be enabled using the CFAPPLICATION tag.
You need to set the location for storing the client vars..
Thanks, but I've already tried that and it didn't do anything for me. Here
is the present content of my CFAPPLICATION tag:
cfapplication name=mrktPromoTool sessionmanagement=yes
clientmanagement=yes clientStorage = cookie setClientCookies=yes/
I've also had the clientStorage and
I tried placing the MRU value into both session and client
variables, and enabling client and session variables in the
CFApplication tag, but I just got an error.
As Mike Tangorre mentioned, if you want to use Client variables you will
need to specify where Client variables will be stored.
While department B wants additional features and won't use some of the
existing, I am assuming that the features they share, and indeed the
business rules behind them all are common.
In my experience, this is a dangerous and unwarranted assumption. I can
think of many cases where we built
My question is with CFPARAM - what's up in this case? Will it work
fine when all of the parameters all nested in IF statements like this?
Will there just be a big long list of BIND variables and will the
statement (INSERT or RUN) use the right ones?
Am I making any sense?
Assuming that
Implement a complex DB Relational Structure to store the content and
data.
This should not be that complex: just design a table with
- user ID
- date-time
- name of table modified
- name of column modified
- modified value
--
___
REUSE CODE! Use custom tags;
Your response is the reason I asked the initial question. Each department
wants to use the same application although with modifications and features
not found in the other. I haven't done it myself, but I *think* I have
heard of inheriting forms (presentation logic) in .NET programming, and I
On Tue, 28 Dec 2004 10:14:25 -0500, Matthew Small [EMAIL PROTECTED] wrote:
Thanks, but I've already tried that and it didn't do anything for me. Here
is the present content of my CFAPPLICATION tag:
cfapplication name=mrktPromoTool sessionmanagement=yes
clientmanagement=yes clientStorage =
Thanks much guys! Really appreciated.
Jim, I appreciate the offer and I may take you up on it, I was just
sure there had to be an easier way. No offense.
It just seems that there should be a way to say with the [quote] tags
what you can say with ([^]*)...
Looping sounds alright though..
There
cfset init()
cffunction name=init access=private output=false returntype=string
displayname=Initializes my object and creates the datasource variable
cfset variables.DSN = myDataSourceName
cfreturn variables.DSN
/cffunction
I know I could make it so that you have to pass the datasource
I haven't done it myself, but I *think* I have heard of inheriting
forms (presentation logic) in .NET programming, and I thought that
there might be a process for CF.
I'm pretty sure there are forms reuse mechanisms in Windows Forms, but not
so sure about within ASP.NET. There's nothing
Yup - of course CFQUERYPARAM is what I meant. The mind does strange thigs
at three AM. ;^)
Thanks, all - it does seem to work just fine. Unfortunately it doesn't
offer as much of a speed boost as I was hoping, but I'll take what I can
get.
Jim Davis
On Tue, 28 Dec 2004 11:39:22 -0500, Jeff Small [EMAIL PROTECTED] wrote:
cfset init()
Be wary of calling functions from the pseudo-constructor - if the CFC
is accessed in any way, including the doc browser, it will execute
this and call the function. In general I recommend *not* calling
init()
Well I would say you maybe working a bit too hard.
If that is all you want to do you can just do this.
cfcomponent
cfset variables.DSN = myDataSourceName
cffunction ...
This sets a variable that can be used by all functions. Now the limitation of
this is that you can not
A few comments here:
*Typically i make my init function public so I can call it directly.
This lets me do this in code:
cfset mycfc = createObject(component,mycfc).init(arg1, arg2, arg3)
You need to make your method do a cfreturn this for it to work right.
*Your init function didn't have an
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 11:39 AM
To: CF-Talk
Subject: My Init() in my CFC...am I on the right track?
cfset init()
cffunction name=init access=private output=false
returntype=string
displayname=Initializes
You might squeak out a bit of performance by making a stored procedure out of
it and using an optimistic update strategy... Just do the update and if the
record count is zero then do an insert. This will completely remove the select.
(I guess you don't need a sp for this.)
Mark
-Original Message-
From: Tony Hicks [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 11:31 AM
To: CF-Talk
Subject: Re: Regex troubles
Thanks much guys! Really appreciated.
Jim, I appreciate the offer and I may take you up on it, I was just
sure there had to be an
charlie, jochem, mike, and joe
i upgraded the server to 6.1 patch, and all is well.
musta been something with 6.1 less the patch.
thanks for your help!
tw
On Sat, 18 Dec 2004 20:49:42 -0500, Tony Weeg [EMAIL PROTECTED] wrote:
gotcha thanks for the help, im going to get into the code
On Tue, 28 Dec 2004 11:39:22 -0500, Jeff Small [EMAIL PROTECTED] wrote:
cfset init()
cffunction name=init access=private output=false returntype=string
displayname=Initializes my object and creates the datasource variable
cfset variables.DSN = myDataSourceName
cfreturn variables.DSN
Be wary of calling functions from the pseudo-constructor - if the CFC
is accessed in any way, including the doc browser, it will execute
this and call the function. In general I recommend *not* calling
init() automatically in the CFC but requiring users of the CFC to call
init() at
Not quite.
1) The access type on an init() function should be public, or you'll
get an error saying the method doesn't exist when you invoke it in
your calling code..
Makes *total* sense...
2) If you really want to make the value of variables.DSN public (to
pass back to calling code),
A few comments here:
*Typically i make my init function public so I can call it directly.
This lets me do this in code:
cfset mycfc = createObject(component,mycfc).init(arg1, arg2, arg3)
You need to make your method do a cfreturn this for it to work right.
*Your init function didn't have
I have a form with about 40 fields in it.
My submission page has a CFINSERT statement as follows:
cfinsert datasource=QualityCompliance
tablename=tblQualityCompliance
What is happening is that when I submit the form, SOME of the fields get
populated in the database, but not all of them.
If I
Be wary of calling functions from the pseudo-constructor - if the CFC
is accessed in any way, including the doc browser, it will execute
this and call the function. In general I recommend *not* calling
init() automatically in the CFC but requiring users of the CFC to call
init() at
Whatever you plan to do, I would definitely give CrystalTech a heads
up about your expected traffic spike. They might be able to give you
a good suggestion, and if they can't, at least they won't be caught
blindsided and just unplug you or something unpleasant. Hosts tend to
get cranky when the
Jeff Small wrote:
5) One practice that has become a best practice of sorts is to
return this from your init method so that you can method chain, as
shown below. Granted, not everybody follows this practice, as it's
more personal preference, but it's just what I'm used to now.
I'm
-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 12:18 PM
To: CF-Talk
Subject: Re: My Init() in my CFC...am I on the right track?
I'm struggling with this. I don't understand even from Seans's post what
purpose it serves to return
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 11:54 AM
To: CF-Talk
Subject: RE: Dumb Question About CFPARAM
You might squeak out a bit of performance by making a stored procedure out
of it and using an optimistic update
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 12:29 PM
To: CF-Talk
Subject: Re: Slow (sorta) site issues - Ideas?
Whatever you plan to do, I would definitely give CrystalTech a heads
up about your expected traffic spike.
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 4:18 AM
To: CF-Talk
Subject: Re: Slow (sorta) site issues - Ideas?
In a shared environment you have to ask yourself to what degree optimizing
the performance of your site's code is
Do you use the SQL Profiler to monitor your sql server? (This is not the stuff
in Query Analyzer... it's a standa-alone app that shows all queries
(filterable) as they are executed.) I have found it to be extremely useful in
finding both slow and also often-used queries... some of the quick
Jim Davis wrote:
I've actually considered placing some of the site on another CrystalTech
account (on a different server of course) and using redirects to move the
traffic off. Of course there's no way I could get the URLs to stay the same
(outside of frames) and I wouldn't want it there
If you just want to *see* the data and don't want to be able to
extract it back out again you can use a more obtuse approach and store
the submitted form data in a long text field, via cfdump if your needs
(and data qty)(are very simple and via a loop and table row construct
if more complex.
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 1:05 PM
To: CF-Talk
Subject: RE: Dumb Question About CFPARAM
Do you use the SQL Profiler to monitor your sql server? (This is not the
stuff in Query Analyzer... it's a standa-alone app
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 1:20 PM
To: CF-Talk
Subject: Re: Slow (sorta) site issues - Ideas?
You can do much better on the caching of your static content. You
have zero cache headers even on your images.
Have you thought about using a web cache system like Coral?
http://www.scs.cs.nyu.edu/coral/
If you set the no-cache http header to true it caches pages for 5
minutes before requesting a new copy. With a bit of experimentation it
should be possible to track the user agent their bot uses and
From: Jochem van Dieten
Jeff Small wrote:
5) One practice that has become a best practice of sorts is to
return this from your init method so that you can method chain, as
shown below. Granted, not everybody follows this practice, as it's
more personal preference, but it's just what I'm used
cfset variables.DSN = myDataSourceName
This might be a little off the best CFC practice topic, but why not create a
second CFC to govern all contact with your database(s)? This way you don't
have to worry about each CFC that lives in your world understanding database
lingo and knowing
Jeff Small wrote:
From: Jochem van Dieten
Jeff Small wrote:
I'm struggling with this. I don't understand even from Seans's post what
purpose it serves to return this when you're using something like CFOBJECT
or CreateObject() which creates an instance of an object anyway...
Because that
Does anyone if CFX Cybercash support passing the CVVD code? I found
some info that this code is referred to as cpi.card-cic in CyberCash
realm, but I don't know if the tag itself supports it.
Thanks!
Stas
~|
Special thanks to
On Tue, 28 Dec 2004 14:18:14 -0400, Matthew Drayer [EMAIL PROTECTED] wrote:
cfset variables.DSN = myDataSourceName
This might be a little off the best CFC practice topic, but why not create
a second CFC to govern all contact with your database(s)? This way you don't
have to worry
It should be noted that you'll get slight variations from people based
on their preferences, but the code below generally covers best
practices that I've seen. Here's the cleaned up CFC and the calling
code is below it:
cfcomponent output=false
cffunction name=init access=public
If one of the things you're looking forward to doing is using some methods
with Flash Remoting down the line, and you made an insert() method say, that
was looking for a struct (insert(myStruct) for instance) can Flash provide
the method with the appropriate structure that ColdFusion (the CFC)
Replies inline...
On Tue, 28 Dec 2004 15:00:07 -0500, Jeff Small [EMAIL PROTECTED] wrote:
It should be noted that you'll get slight variations from people based
on their preferences, but the code below generally covers best
practices that I've seen. Here's the cleaned up CFC and the calling
Named:
cfset setDSN(dsName:myDatasourceName)
or
cfset setDSN(dsName=myDatasourceName)
Aha! This I got immediately. I understand it all now and once we were both
clear on what I was doing, it makes perfect sense both in what you were
doing, and syntactically what you were writing. I've seen
On Tue, 28 Dec 2004 12:08:54 -0500, Jeff Small [EMAIL PROTECTED] wrote:
Okay, this makes sense. I'm reading about 4 different sources for how to
build CFCs correctly
I hope that includes both of the Macromedia Web Team docs :)
http:/livedocs.macromedia.com/wtg/public/
Note that even tho' the
This is kind of dangerous unless you use cflocks properly, and
cflocking the application scope can slow things down. The reason
is if somewhere in your app you change the application.datsource from
CODAGenomics to something else, which you've indicated happens,
any other user loading a page will
This allows you to chain method calls, as others have noted, and will
probably help get you more into the habit of using cfset and method
calls (rather than cfinvoke which I also advise against).
Just to be clear, are you advising people to chain method calls? Personally,
I'm not crazy about
-Original Message-
From: Ben Rogers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 4:35 PM
To: CF-Talk
Subject: RE: My Init() in my CFC...am I on the right track?
This allows you to chain method calls, as others have noted, and will
probably help get you more into
Hey All,
Well while I'm searchin for it, I figured I'd see if anyone on list may have an
answer for me...
What is the date range for SQL Server dates (i.e. how far back does it goI
know a year of 1234 is not valid)??
TIA
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce
hmmm...after some quick testing...it looks like it goes back to 1754 if
anyone cares ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web:
Hi everyone, I wonder if you might be able to help me here. I am
having trouble with the following:
This is in the circuit.xml in my login/model circuit
fuseaction name=checkUser
include template=qry_checkUser.cfm/
if condition=validateUser.recordcount is 1
true
On Tue, 28 Dec 2004 15:24:36 -0500, Jeff Small [EMAIL PROTECTED] wrote:
If one of the things you're looking forward to doing is using some methods
with Flash Remoting down the line, and you made an insert() method say, that
was looking for a struct (insert(myStruct) for instance) can Flash
If parameters are not needed, I would feel the init() method
is not needed. But I'm sure that is debatable.
Hey Ian,
Not trying to debate, just giving my point of view: I'd use the
init() method regardless of the need for parameters. This way, if
parameters need to be added, the external
Not sure what that has to do with locks. Nothing at all as far as I can tell.
I'd hope the entire application uses the same datasource. If you need
a second one, just set application.otherdb = 'whatever'
-Cameron
On Tue, 28 Dec 2004 16:27:35 -0400, Larry White [EMAIL PROTECTED] wrote:
This
http://www.devx.com/tips/Tip/13898
Values for datetime data types earlier than January 1, 1753 are not
permitted in SQL Server. SQL Server rejects all values that do not
fall within the range from 1753 to .
Another SQL Server data type, smalldatetime, stores dates and times of
day with less
I'm setting up a shopping cart for a jewelry store.
I'm curious, what is performance limit for storing data in session
variables?
The following are lists:
Item No (itemID used in check out)
Item Qty (in case someone wants more than one)
Item Price
Item Description (most descriptions about 50
I'm curious, what is performance limit for storing data in session
variables?
Memory (RAM) is really your only practical limit when using session
variables. Just make sure you make your session timeout a practical
interval. and (assuming you are on CFMX) make sure you set both your
max and
Any idea why these are sprouting up all over my mx6.1(windows) logs? Users get
the standard JRun disconnect/protocol error page.
Any help is appreciated...
12/28 21:19:24 error Error while reading header HTTP-REFERER
java.net.SocketException: Connection reset by peer: socket write error
On Tue, 28 Dec 2004 21:52:26 -0400, Dov Katz [EMAIL PROTECTED] wrote:
Any idea why these are sprouting up all over my mx6.1(windows) logs? Users
get the standard JRun disconnect/protocol error page.
I'll bet you've got isDefined(someUnqualifiedVariable) in your code
- if the variable isn't
On Tue, 28 Dec 2004 21:12:58 -0500, mayo [EMAIL PROTECTED] wrote:
The following are lists:
Item No (itemID used in check out)
Item Qty (in case someone wants more than one)
Item Price
Item Description (most descriptions about 50 characters. ex: Ruby and gold
drop-earrings)
Any reason
There's no particular reason to use list. I was wondering about using arrays
instead, and then got pulled elsewhere. Thx.
-- gil
-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 10:59 PM
To: CF-Talk
Subject: Re: shopping cart, session
From: Duncan I Loxton [mailto:[EMAIL PROTECTED]
fuseaction name=checkUser
include template=qry_checkUser.cfm/
if condition=validateUser.recordcount is 1
true
set name=request.usr_id
value=#validateUser.usr_id# /
/true
Unless it's really necessary I would try not to set datasource
as an application variable, either:
cfset datasource=CODAGenomics
or
cfset request.datasource=CODAGenomics
Andrew.
I seem to have a sticky application variable. How do I get it to change?
The application.cfm file is:
72 matches
Mail list logo
