2 Questions
1. How do you know if a cfx tag is thread safe
2. Do you need to lock cfx tags?
Cheers
KOla
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 04 May 2001 14:06
To: CF-Talk
Subject: RE: Spell Checking??
I have a customer who is insisting
I am passing a query object which consists of 1000 records in a hidden form
field between pages as a
WDDX packet, are there any reasons why this is a bad idea, such as limits to
the amount of data which can be held in a form field or passed in a form?
The reason for this is to save a trip to
the database server. You're still making a trip
to the *web* server for every page - and sending a lot of data.
Without knowing exactly what you're trying to achieve, I'd guess
cacheing the query would be better, yes.
Nick
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent
Thanks i'll give it a try
KOla
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 13:36
To: CF-Talk
Subject: Re: using WDDX for next 'n' style browsing
I do search diffrently,
I first get ALL the results (as COUNT(*)) into a variable, which I
AM Kola Oyedeji wrote:
I am passing a query object which consists of 1000 records in a hidden
form
field between pages as a
WDDX packet, are there any reasons why this is a bad idea, such as limits
to
the amount of data which can be held in a form field or passed in a form?
I did a similar
Someone on another list proposed creating a unique id for each search query
executed and then
using this as a file name and writing the query as a WDDX packet to this
file. Then on every page this id can be used
to retreive the correct query object - and display it.
Any one see any problemes
-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 5:53 AM
To: CF-Talk
Subject: using WDDX for next 'n' style browsing
I am passing a query object which consists of 1000 records in a hidden form
field between pages as a
WDDX packet, are there any reasons why
Sorry for the crosspost (had conflicting answers from other lists)
but is there a consensus on which method of looping over a query is fastest?
cfloop or cfoutput..
Cheers
KOLa
~~
Structure your ColdFusion code with Fusebox. Get the official
wouldn't be possible, you'd
have to use CFLOOP
Gregory Harris
Web Developer
The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534 FAX: (949) 707-1535
- Original Message -
From: Kola Oyedeji [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED
Seems to me no-ones 100% sure.
I've found cfloop to execute better overall in most situations when I am
working with very large amounts of data, Chris. I don't generally see much
difference in execution time between the two, in any other situation (and
cfoutput
Thanks for clearing that up for me
KOla
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2001 12:03
To: CF-Talk
Subject: RE: cfloop vs cfoutput
Sorry for the crosspost (had conflicting answers from other lists)
but is there a consensus on which
after a short while thus freeing
memory that way.
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 11:44 AM
To: CF-Talk
Subject: RE: using WDDX for next 'n' style browsing
But wont that mean each query would be held in the server RAM?
KOla
Have you got cookies switched on?
incidentaly you dont need ## signs inside cfset.
KOla
-Original Message-
From: Kronenberger, Douglas [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2001 14:50
To: CF-Talk
Subject: Session Variables - I don't get it
Greetings,
I'm not getting how to
Am i right in saying that the certification study guide only covers 4.5?
When does coldfusion 5 certification come into effect?
Thanks
KOla
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: 11 May 2001 18:27
To: CF-Talk
Subject: RE: New Cold Fusion book, O'riely
Would be grateful...
Thanks
KOla
-Original Message-
From: Mike Brunt [mailto:[EMAIL PROTECTED]]
Sent: 13 May 2001 16:55
To: CF-Talk
Subject: RE: Session/Application Locking
Thank you and my apologies to all on the list, the attachment is only 21kb,
if anyone wants it, please let me
I have this code in my application tag:
cfif NOT isDefined(application.name)
cfapplication name=myapp
sessionmanagement=Yes
sessiontimeout=#CreateTimeSpan(0,4,0,0)#
cfset
document)
I think you will experience an overall performance improvement and
better use of the server, internet connection, and the client...
. kind of an *environmentally-friendly* program design!
And, the user experience will be much improved too.
Dick
At 11:52 AM +0100 5/8/01, Kola
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 11:08
To: CF-Talk
Subject: RE: Does application tag need to be executed every time?
It's only going to execute if application.name is not defined.
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent
Can anyone please remind me how i get the value of a record
which was just inserted into a sql database. I know its called @@identidy.
I had a snippet but i cant find it,Thanks
KOla
~~
Structure your ColdFusion code with Fusebox. Get the
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
One man's magic is another man's engineering. ---Lazarus Long
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 11:42 AM
To: CF-Talk
Subject: OT: @@identidy in sql server 7
is it possible to use flash to update the client's display with data bieng
pulled by cf from a database if so how is this done?
Thanks
KOla
-Original Message-
From: Paul Mone [mailto:[EMAIL PROTECTED]]
Sent: 18 May 2001 00:28
To: CF-Talk
Subject: RE: CF and Flash classes?
I've done
A bit OT but while we're on the subject does c# have anything to offer that
existing languages
do not have?
Thanks
KOla
-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 10:35
To: CF-Talk
Subject: RE: the big export...ColdFusion.NET?
C# is
I havent used CF5 yet but is it true that you are limited to the same tags
available
for use in cfscript tags? Doesn't this mean no database related functions
are not possible?
What exactly can you do inside UDFs?
Thanks
KOla
-Original Message-
From: Steve Reich [mailto:[EMAIL
Hi
Just a quick questions regarding the Maintain Database Connections in
Access,
should this be checked or unchecked and if it is unchecked what are the
performance
implications?
Thanks
KOla
~~
Structure your ColdFusion code with Fusebox. Get
Does the first query return any results? i noticed that you dont have a =,
IN, !=, OR having
before the subquery in getWaitingStudent, im no sql expert but does this
still work like this?
KOla
-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 14:58
To:
hi hope someone here can give me a hand with this:(sorry for the cross post)
I have a table called categories, the key bieng an int, with a field for the
category name.
Another table called adverts, an advert has a category feild which is a
foreign key which links to the category table.
I
Hi
I have an app which lets users upload a file, is there anyway to stop a
malicious user
uploading say a 2gig file before it gets to my server? Also if i wanted the
upload to have a maximum time out how would i do it? Would I need to use
cflock?
Thanks in advance
Kola
I would like to hear an alternative as well as i have been told by many that
the scheduler is
unreliable!
Kola
-Original Message-
From: PEREZ, RICHARD D (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 09:23
To: CF-Talk
Subject: RE: Alternative to CFSchedule?
I think your best
Is there an industry standard tool used by people with disablities to browse
web sites, i've just brought this issue to the attention of my boss, and we
may want to purchase such a package to test our sites.
Thanks
Kola
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
slight;y related... what about file uploads?
If i want an upload operation to time out to stop users uploading huge files
can i use cflock?
Kola
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 13:15
To: CF-Talk
Subject: RE: cfhttp/cffile locking?
://www.usdoj.gov/crt/508/web.htm
Brian
- Original Message -
From: Kola Oyedeji [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, June 04, 2001 5:02 AM
Subject: RE: Your site's easy to navigate? You Think so?
Is there an industry standard tool used by people with disablities
After many many attempts i still have not got it working this may be due to
the fact that i'm not sure exactly how it is supposed to work. Do you have
an tips/pointers?
Thanks
Kola
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:24
To:
Massimo , how would i use this cgi variable to check for the length of a
file bieng uploaded?
Thanks
Kola
-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:34
To: CF-Talk
Subject: Re: cfhttp/cffile locking?
Kola Oyedeji [EMAIL PROTECTED] wrote
Massimo thanks a lot, i'll check out you're site for the javascript ...
KOla
-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 16:35
To: CF-Talk
Subject: Re: cfhttp/cffile locking?
Kola Oyedeji [EMAIL PROTECTED] wrote in message
Massimo , how would i
.
Thanks in advance
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http
Not sure, i didnt do the installation. Stranegly it now works again?
Bit of a mystery.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED
I used cf_buster from centrasoft - really helped me, managed 87%:
http://www.centrasoft.com/default.cfm
HTH
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Jerry Staple [mailto
This may shed a bit more light
http://www.allaire.com/Handlers/index.cfm?ID=21011Method=Full
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Carol Bluestein [mailto:[EMAIL
Ray,
Out of curiosity what is it about this code in particular that makes it
throw an error if you have strict attribute validation turned on? Is that on
CF4.x or CF5
Thanks
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020
Cheers
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 14 September 2001 13:12
To: CF-Talk
Subject: RE: Duplicate and StructCopy
first thing i would do is check for whitespace, some databases pad out
certain type of fields,trim the value retreived from the db and see if it
makes a difference.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
To test the solution I only added one other query (so there's
four more to
go) and it slowed the process down considerably Do you
see any way
around this?
using stored procedures should improve the performance. Not sure if you can
nest stored procedure calls, just a thought.
Kola
be
easily matched to other dates using a query not a coldfusion function?
Thanks in advance
KOla
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Dennis Powers [mailto:[EMAIL PROTECTED
This may or may not be relevant but i've just deleted an email from someone
i dont know which I'm sure had a virus attached. It has a exe. file
attached called readme.exe. I recieved a virus warning and jsut deleted it!
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5
Hi
I have a site which I would like to move from Access to SQl server are there
any things I need to be aware of code wise things like dates perhaps?
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
I have come across some wierd behaviour and wondered if anyone else
had run into this. I have a from with a file field which allows a user
to upload an image. On the action page I use the cffile tag to upload
an image which
is saved to a directory and then i cflocate to confirmation page.
Now
Out of curiosity what elements do your applications require of IIS that
O'Reilly may or may not have? It just that I'm looking at O'Reilly as an
alternative.
Cheers
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
Probably because images dont end with .cfm therefore they're not passed
to the cf engine.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Tony Hicks [mailto:[EMAIL PROTECTED
I would love to have a look at that as well.
Cheers
Kola
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 4:11 PM
To: CF-Talk
Subject: RE: How to find out the page to send 'em back to
Yes please! This seems such a simple answer. I had
Greg
Try the following - should work.
SELECT*
FROM messages
WHERE message_date = #CreateODBCDate(attributes.datebox)#
one word of warning this may or may not take the time into consideration, if
you test this and it
still does not work correctly you'll actually have to use the
I'm kinda interested in this as well anyone have any resources where I can
read up on this?
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED
Joseph please.
My boss explained it to me and showed it to me recently but it all didnt
click with me.
Thanks
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Joseph DeVore
You can also export to an access database then you could write a utility to
enable
you to search them.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Paul Mone [mailto:[EMAIL
If you do move to cf5
there is an article by Ray Camden on how to do something along thses lines:
http://www.coldfusion.com/handlers/index.cfm?id=21216method=full
HTH
Kola
-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 6:39 AM
To:
displayed.
So the question is, is this a feature or a bug?
Thanks
Kola
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
~~
Get the mailserver that powers this list at http
That is one of the most useful sites i've been to . Why is this site not
publicised??
I have loads of additional notes and tips scrawled on pages of my paper
documentation which I would love to inform allaire of.
cheers
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5
The green Forta book (advanced coldfusion application development) has some
good info on this. Not sure if theres a more recent version of the book than
the one that covers CF 4.0
HTH
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
The houseoffusion mailing group is no longer the active mailing list - join
[EMAIL PROTECTED] I think you'll find this mailing list far from dormant.
HTH
KOla Oyedeji
web developer
http://www.alexandermark.com
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Sunday
Because of this problem and the fact that you
cant set cookies with cflocation there are a numbser of replacements
available
in the tag gallery:
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=cf_loc
ation
HTH
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high
Hi - sorry for the cross post
I hope someone can shed some light on the best way to do this. I have a
structure which is turned into a wddx packet and then encrypted. However
when I try save it to the database I get an error:
SQL = UPDATE sales SET serializedStruct = 'ML0?@(.FF/?2CD718NI3'.
Does anyone know if i set a maxrow value of 1 in a select query,
if just one record is passed to coldfusion by the database or
all matching results are returned by the database but only one is made
available?
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx
Thanks guys
I was actuall trying to work out the most efficient way to determine if a
key exists in the
db and then do some processing if it does, without searhing the rest of the
records. I'm thinking that using Exists would be more efficient.
Kola Oyedeji |Web Developer |ekeda
elthorne gate
Michael
Is that chart upto date? Does it compare cf5 with the latest version of asp?
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
-Original Message-
From: Michael Dinowitz [mailto
session.basket
WHERE
session.basket.ProductID = #URL.productID#
/cfquery
unknown exception condition
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
is this the way Qs of Qs are supposed to work?
Thanks
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
is this the way Qs of Qs are supposed to work?
Thanks
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk
Use isDefined(thistag.executionmode) I believe this variable only exists
if the template is bieng run as a custom tag.
Also cgi.script_name give you the name of the template a page is included
in. if it is different to the name of the included file (check from within)
then it must be an include.
Hi Does anyone actually use the isolation level Serializable with
cftransaction? I understand that using it can impede performance, is the
trade of worth it to ensure no dirty reads, nonrepeatable reads and phantom
reads?
What are the chances of these data consistency problems occuring with say
ah, but what if they're allaire certified, brainbench certified and
already
own the Forta
study guide? ;-)
KOla
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 13:58
To: CF-Talk
Subject: RE: Questions to ask for CF developer
By an anual
Hi does anyone have a list of recommended settings in the coldfusion
administrator for production or live servers?I also have some
additional
questions:
How large should the template cache be?
Also if i enable trusted cache and i want to update some pages,
inorder for
the changes to reflect
Chris, thanks
KOla
-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 16:28
To: CF-Talk
Subject: Re: cf administrator settings
-- Original Message --
from: Kola Oyedeji [EMAIL PROTECTED]
Hi does anyone have
Philip
Any particular reason why the template cache should be 4 times the total
size of all your
templates?
ps. you seem to always win something at all the meetings! ;-)
KOla
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 17:28
To: CF-Talk
There is a presentation on the figleaf site:
http://www.figleaf.com/figleafhome/cfug/figpubs.htm
I still havent sussed it out though!
HTH
KOla
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 04:57
To: CF-Talk
Subject: CF Studio debugger tutorials?
administrator settings,
I realise this is a potentially broad topic but any pointers, tips etc would
be greatly appreciated - thanks.
(sorry about the cross post)
Kola Oyedeji
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
It is funny this came up as i posted a question today to the fusebox list
regarding the performance of fusebox here are 2 responses:(hopefully they
dont mind me reposting them here)
---
This is a very grey area, where I think you'll find
Fusebox wins
Hi
Is there anyway to backup the settings in the coldfusion administrator?
Thanks in advance
Kola Oyedeji
Web Developer
www.ekeda.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
Thanks guys..
KOla
Kola Oyedeji
Web developer
Allaire Certified ColdFusion Developer
http://www.ekeda.com
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 23 July 2001 13:18
To: CF-Talk
Subject: Re: Backing up coldfusion administrator
Kola
Hi
I couldnt find anything in the KB regarding backing up the administrator for
CF4.5. To do this manually do i need to back up the registery key?
Thanks
Kola Oyedeji
Web developer
Allaire Certified ColdFusion Developer
http://www.ekeda.com
-Original Message-
From: Thomas Chiverton
Thomas
Thanks again, incidentally how did you find that article? I find the allaire
web site to be a bit of a mess. I searched under
support/knowledgebase/search but no joy!
Kola Oyedeji
Web developer
Allaire Certified ColdFusion Developer
http://www.ekeda.com
-Original Message
;-)
Kola Oyedeji
Web developer
Allaire Certified ColdFusion Developer
http://www.ekeda.com
0208-429-7323
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: 26 July 2001 14:07
To: CF-Talk
Subject: RE: Blatant advertising (you have been warned)
That is being debated, I'll
I think this one beats them all hands down, the only cf book youll ever
need:
http://www.amazon.com/exec/obidos/ASIN/9056621750/ref=pd_sbs_b_3/102-421497
7-0920132
Kola Oyedeji
Web developer
Allaire Certified ColdFusion Developer
http://www.ekeda.com
0208-429-7323
-Original Message
I think only yhe developers version is free.
HTH
http://www.tagservlet.com/download/download.cfm
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Billy Cravens [mailto:[EMAIL
about, which i believe do not suffer from the same
problem are actually undocumented and unofficial functions. Bear this in
mind when you use them as they are NOT guaranteed to be supported in future
versions/releases/service packs etc.
HTH
Kola Oyedeji
Web developer
Macromedia Certified Advanced
Interestingly, I thought it was just me who stopped using the official
forums since they changed the format!
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Will Swain [mailto
Oh it should also be noted that while the product only works
on IE, it only
works on intel/MS installations of IE. This should be obvious as it
utilizes activeX, but not everyone seems to get that.
slightly off topic but are you saying active x only works on Intel chips?
Kola Oyedeji
Thanks..
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2001 15:59
To: CF-Talk
Subject: RE: (OT) Activeedit 2.5
Hi
The short answer is, you can't The longer (and more useful) answer is to
simply pass the value that the constant represents, instead of trying to
pass the constant itself Just look up what wdRowHeightExactly contains
(it's probably an integer) and pass that instead
just wondered, is
If its any help there are free installer programs around. I found one but
cant remember the name which allows you to save a site as an executable -
customize the installation pages and prompts, allow the user to specify
where to put files when setting up, where to read in a terms condition file,
AFAIK I think you can only do distinct on 1 field. Try it with just one
field - (not the key as this should be distinct anyway)
Kola
-Original Message-
From: cftalk [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2002 18:32
To: CF-Talk
Subject: OT: count(distinct) in MS Access
Hi,
Hi
I am trying to use cfexecute to call SQL server from the command line.
The following command works on the command line it executes the query script
and
displays the results of the query however when i call it using cfexecute it
returns a list of parameters as if the parameters being sent are
Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 3:08 AM
To: CF-Talk
Subject: Using cfexecute to call SQL server fron the command line
Hi
I am trying to use cfexecute to call SQL server from the command line.
The following command works
Hi
I often have an application which allows a user to edit a record. Even if
the user only updates one field all fields are resaved in the database. Its
occured to me that this may be inefficient. I wondered if I could store the
fields in hidden form fields, check on the update page which fields
application as sql
out-performs CF hands down.
Success is a journey, not a destination!!
Doug Brown
- Original Message -
From: Kola Oyedeji [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 11:27 PM
Subject: Efficient database inserts
Hi
I
Hi
Could anyone tell me the best way to execute dynamic queries using stored
procedures?
Thanks
Kola
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Hi
I have a table which holds orders. The productid and the quantity of items
purchased are held in this table amongst other things such as the order
date, customer id etc. Orders are calculated by getting the product cost and
multiplying it by quantity. Its occured to me that if the price of
Surely in this case the function is to increase dev time lost by cross
browser compatibly and perhaps to have modular GUI components and to
decrease the amount of trips to the server...
just my 2pence
Kola
-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 01
I've often wondered about this is there really a need for a third tier, what
would you put in the third tier that you *couldn't* put in a stored proc
apart from file operations?
Thanks
Kola
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 15:02
To:
Sorry i should have better phrased my question what would you do in a third
tier that you wouldnt put in the database or in the client?
Kola
What would happen if someone decided to update your database using Excel
ODBC connection? The stored procedure wouldn't run. But if you had your
Try
cfset cleanString = RereplaceNoCase(dirtyString,
[:space:]+ass[:space:]+, *** , all )
it should replace ass if it is preceded or followed by one or more
spaces/tabs but not as part of a word with *** .
Let me know if that works.
KOla
-Original Message-
From: James
I think there was also a custom tag called cfsleep in the developers
exchange which acheived this.
Kola
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2002 22:54
To: CF-Talk
Subject: RE: Pausing using CF
Forcing a CFLOCK deadlock does not seem
To go one better you could move it to the request scope so that any
custom tags on the page will still have access to it as if it was a session
var.
Kola
Kola Oyedeji |Web Developer |ekeda
elthorne gate |64 high street |pinner |middx |ha55qa
t +44(208)429 7333 f +44(208)429 7339
1 - 100 of 403 matches
Mail list logo