Perhaps you could use the CFSCHEDULE tag to programmatically schedule a job
to run (soon) which generates the file and sends the email? Then the page
that the user sees will be done as soon as the job is scheduled (should be
quick). Though some people hate CFSCHEDULE and I haven't used it much.
I need a snippet of javascript/html/dhtml/css/whatever that will cause
Netscape or IE to crash reliably so I can test something. I have certainly
managed to crash them in the past but can't find the code that did it. Any
ideas?
Martin Herbener
I mean, put the browser in such a state that its window does not update
and
it can only be made to go away by using Task Manager to kill the
process.
It's ok if the crash doesn't kill the OS.
-Original Message-
From: Ron Hornbaker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December
In the past few days I've started to get some Oracle ORA-01704 (string
literal too long) errors in my application.log file. These error entries
are NOT accompanied by the SQL statement, which is unusual, and which makes
it hard to diagnose. I do use client variables, stored in Oracle. Could
I don't know, haven't tried it yet. If you want to try it and let me know
what changes, I'll post an updated document.
-Original Message-
From: dave fauth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 8:18 AM
To: CF-Talk
Subject: RE: CF Server runs under user account
I posted some info on this at
http://www.defusion.com/articles/index.cfm?ArticleID=89
which describes using somewhat more restrictive settings than the allaire
article.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 7:36 PM
To:
Don't trust CF to auto-lock reads. It seems well-established that CF does
not catch every use of shared-scope variables when you use auto-locking.
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 3:08 PM
To: CF-Talk
Subject: RE:
In this scenario, was the SSL cert installed on the Foundry box or all the
webservers?
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2001 9:19 AM
To: CF-Talk
Subject: Re: Load balancing with hardware solution - still require
I wrote a CFX a couple of years ago to solve this very problem (mixed
alpha-numeric data that people want sorted in quasi-numeric order). C++,
Windows only. Works in 4.5 but not tested in 5. Not appropriate for huge
result sets.
Because it doesn't work. In CF 4.5x, anyway, auto read locking doesn't
catch all uses of shared-scope variables; I don't have a list of what it
does and doesn't catch, but generally it misses things like
Cfquery name=variables.myqyery datasource=#application.dsn#
and other non-cfset
Ok, I'm really confused. I just got an error that a certain variable was
not defined. Ok, I've made that mistake plenty of times, but the template
referred to by the error message doesn't use that variable. It is used in
another template, located in another directory on the same server. When
I think you need
DBVARNAME=Orderby
instead of
DBVARNAME=@Orderby
This might be helpful:
http://www.defusion.com/articles/index.cfm?ArticleID=56
-Original Message-
From: Jared Stark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 5:54 PM
To: CF-Talk
Subject: Problem
I have seen suggestions that, with CF 4.5x, the automatic read locking
setting misses some read/write situations. I can't remember the exact
situation; I think it was something other than CFSETS, such as
cfmail server=#application.mymailserver#
and similar. Anyone got confirmation or
Any info on whether CF 5 fixes this?
-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 10:17 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: CF 4.5 automatic read locking unreliable?
I can confirm that. The MM tech said
I think (haven't tried lately) even without javascript, with two forms.
form action=firstplace
input type=submit
/form
form action=secondplace
input type=submit
/form
-Original Message-
From: Mark Robinson (National Express)
[mailto:[EMAIL PROTECTED]]
Sent:
I had a problem with similar symptoms; turned out that the probe process
couldn't access cfprobe.cfm. The method ClusterCats uses to decide where to
look for cfprobe.cfm is not clear to me, and if it can't get it for any
reason it decides that the server is busy. Look in your IIS (or whatever)
I have at least one OLEDB datasource to an MS Access db that works, but it's
not a heavily used app.
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 10:10 AM
To: CF-Talk
Subject: Re: OLE-DB Client Storage Problem
Peter,
Thank
Another old approach that might work better in the
who-knows-how-long-the-user-will-take-or-even-if-they're-still-logged-in
world of the web is
1) when selecting include a magic field (explained below)
2) let user make edits with the UIl; when ready to save
3) within a db transaction check to
Probably most effective to get yourself a plain-text email client to
experiment with, assuming you have something that looks like a POP server.
An older version of Eudora (free light version at
ftp://ftp.eudora.com/eudora/eudoralight/windows/english/306/) should work.
-Original Message-
You might want to try using the tcp/ip network library instead of Named
Pipes - in general people seem to have more success with it. You have to
adjust the network library (the network protocol choice) on both the server
and the clients (including the CF server); the server can support more than
In Oracle you would use the DBMS_SQL package.
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 10, 2001 12:02 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
pass the list as a string variable and parse it in the sp. Haven't done that
with Oracle
From the CF 4.51 release notes:
Oracle Reference Cursor Support
This release supports the return of result sets via Oracle Reference Cursors
through the Oracle 8 native driver and the ColdFusion stored procedure
interface.
The example below shows both the PL/SQL necessary for creating a
I always wondered if the cfimpersonate tag would allow this to work (access
the mailbox using the credentials of the individual thru CDO). Has anyone
tried?
-Original Message-
From: Smutz, Miles A Mr DVLPRS (Contractor)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 9:16 AM
To:
I would use a series of database functions to turn the original date into a
date in the current year, like this (Oracle-ish code since I don't know what
DB you're using but am too lazy to find the exact syntax):
to_date (to_char(aniv_date_field, 'm-d') + '-' + currentyear(), 'm-d-' )
now I
I'm seeing something I've never seen before. Using CF 4.51SP2 and the
Oracle 8.1.6 client on NT 4 SP6a, accessing an Oracle 8.0.4.4 server on NT 4
SP5?, I am doing an insert followed immediately by a select for the same
data and having the select come up empty. If I put in a .3-second delay the
Does anyone know:
1) exactly what files are updated (looks like all the stubs - such as
iscf.dll - but I'm not sure)
2) the nature of the security problem - obviously MM is going for
security-thru-obscurity and is not going to describe the exact problem, but
some clue as to the possible
I asked:
What workarounds, if any, can be used instead of applying
the patch?
Adam Berry said:
There is not a work around other than the patch, which is why we released
it.
This kind of blanket statement is hard to accept. What if IIS security has
been used to only allow connections
Adam Berry said:
The security bulletin explains the potential impact of the security issues.
Since these issues were discovered through an internal audit, we decided not
to publish explicit instructions for how to exploit the issues.
I'd like a more detailed explanation of the impact. Does
A classic approach would be to put these documents in a place that is not
accessible to the public and use CFCONTENT to feed them to the (authorized)
user when needed.
-Original Message-
From: Chris Alvarado [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 10:50 AM
To: CF-Talk
I would not allow the user to wildcard at the start of the names, and
require at least one letter of each name. Any good database engine should
do fine with those restrictions.
-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 8:29 AM
To:
This looks to me as if the SMTP server that the CF server is trying to use
is not configured to relay mail. Have you talked to the administrator of
the SMTP server?
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 11:38 AM
To: CF-Talk
I think CF_SQL_REFCURSOR may only work with Oracle. An MS SQL Server SP can
return (multiple) result sets like this
create procedure myprocedure
as
select * from firsttable
select * from secondtable
end
then you use matching CFPROCRESULT subtags.
-Original Message-
From: Don
If on a shared server, and the server is not set up to use sandboxes to keep
different users from using each other's datasources, then putting the
userid/pwd in your .cfm files will better protect you from other users of
the server (assuming CFFILE is turned off). If sandboxes are in place, I
You could use wrap one of these text-emitting tags inside a module and use
the generatedcontent attribute to catch the emitted text and put it in a
variable.
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:39 AM
To: CF-Talk
Subject: RE:
Try
CFSTOREDPROC procedure=WebInterface.IsBaseCaseComplete
and the rest as you have it.
-Original Message-
From: Andrew Middleton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 9:17 AM
To: CF-Talk
Subject: Oracle 8i and CFSTOREDPROC
I have a problem trying to call a stored
Remember that each database can have multiple schemas; a schema is really
just a set of tables (and indexes, triggers, etc) that belong to a user. But
if you've got user A who owns schema B in database XYZ, and your application
needs access to the tables in schema B, then you can use user A's
I haven't done anything like this but may have to soon. Question: is there
anything stopping a user from creating an html page on their desktop with a
form that posts to the report server ASP page, just like your action page
does? If not, it appears that anyone could run any report if they can
In CF Admin for a particular datasource there is a setting maintain
database connections and another setting Connection timeout. If you
check maintain database connections, then CF will keep a connection to the
database open for as long as connection timeout after its last use. So if
you have
I just dealt with this. It seems to really mean there is something wrong
and ColdFusion can't figure out exactly what. In my case a combination of
upgrading database drivers and fixing up CFLOCKS seem to have resolved it.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Has anyone else seen an Oracle error ORA-24334 no descriptor for this
position ? I'm getting it very rarely with a query that generally works ok.
CF 4.51 SP2, oracle client 8.1.6, Oracle server 8.0.4.4.
Martin Herbener
Kentucky Department of Education
You can convert your CF tree-walking code to stored procedures, which helps
with performance - I've written implementations for both MS SQL Server and
Oracle if you want them. Or you can try Joe Celko's nested set approach
(http://www.intelligententerprise.com/001020/celko.shtml) which I've
Yes, as written this use of CFTRANSACTION is purpose-free. But if the
developer wants to roll back the transaction if the structupdate fails, I
think CFTRY/CFCATCH and CFTRANSACTION type=rollback could be useful.
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent:
Two ways I can think of in 4.5x:
1) Keep the results on a per-user basis in session variables
2) Write a custom tag wrapper for CFSTOREDPROC that mimics CFQUERY's caching
abilities.
-Original Message-
From: Darren Nickerson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:10 PM
First make sure that you can connect to the database using an Oracle tool
like SQLPlus from the console of the CF server. Oracle has its own set of
userids and passwords, so you'll have to create (or know) an oracle userid
and password. And the service name is what you will put in the host
A request scope variable must be re-set for each page load - that's how
request variables work. You could do this
cfquery name=request.colorscheme datasource=
cachedwithin=some_time_period
/cfquery
which would run this query at the internal indicated by the cachedwithin
attribute; if between
Bit masks are cool, but remember that there is a limit to how much info you
can pack in a bitmask because CF doesn't let you use the bit functions on
anything of more than 32 bits. I have taken to using lists for this sort of
thing because there's no practical limit to how many items it can
There is 4.0x info here:
http://www.defusion.com/articles/index.cfm?ArticleID=89
if you have corrections/updates to offer I'd love to see them.
-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 12:08 PM
To: CF-Talk
Subject: Re: Internal
Well, you're not limited to 5 levels, but rather 31; if you feel confident
that will be enough then you're set.
Your second approach works IF you can always assume that all the security
levels are either lesser or greater than the new one you want to add, never
equal. But if you need to have
As far as I can tell, VSS does not have very good reporting capabilities.
It is possible to declare a project version (VSS calls this a label), and
you can examine an individual file's history to see the labels and
associated file versions, and you can do a get to get all the files with a
1) In our case, we figured out that cfx_spell was not thread safe by
deploying it and watching CF crash under load :-(. I think you need to have
some decent C/C++ knowledge and access to the source to be able to be sure
in advance.
2) You need to lock them if you need to lock them; that is,
I really did search for this, but didn't find an answer. I'm moving from CF
4 to 4.5, and have turned on Automatic Read Locking in all scopes. Now
I'm going through to see what's broken as a result. Note that I'm trying to
maintain compatibility with 4.0 as much as possible.
I found a section
You can configure SQL Server (my knowledge is based on 6.5) to use a certain
amount of memory, and it will pretty much use that whether it needs it or
not. If you think it would be ok with less, you can adjust setting and
restart it.
-Original Message-
From: river [mailto:[EMAIL
That seems pretty reasonable to me. My servers run at between 120 and 150
MB of "committed bytes" (from perfmon).
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 9:53 AM
To: CF-Talk
Subject: 189,000K memory use - Way too high for CFAS
I think ftp would be a good fit. You could set up multiple ftp servers and
use DNS round-robin or some sort of load-balancing if you really need to,
but just now I connected to ftp.freebsd.org and saw "There are currently
1334 users out of 5000 possible" so I don't really think scalability is
You could download the eval if you have the hardware:
http://www.microsoft.com/exchange/productinfo/Eval.htm
-Original Message-
From: Dain Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:27 AM
To: CF-Talk
Subject: OT: Test Environment for Forta's Book
If it will always be exactly one character, instead of wildcards I would do
select blah
fromblahtable
where left(lastname, 1) in (#listqualify(form.selectbox_of_letters, "'")#)
you might have to use something other than left(lastname, 1) if your
database uses a different function for
I'm not sure what you mean by stopping the output. Do you mean that you
might start working through a query (or something) and then find that you
don't want to send the data to the user after all? If so, you could first
put all the data to download into a variable, then only do the CFCONTENT if
That is a pain. As I said, I generally put everything into a variable and
then send that, but you still have to be careful about whitespace. There's
no magic way to say "CFCONTENT only up to this point" that I know of.
-Original Message-
From: tom muck [mailto:[EMAIL PROTECTED]]
Sent:
How do you know which number gets which format? Is there some clue in
another db field, or is it based on how many digits after the decimal point,
or what?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:55 PM
To: CF-Talk
Subject:
I don't know if there are solaris-specific issues. In CF 4.0x it was only
possible to do this with ugly kludges. With CF 4.5x it can be done using
the CFSTOREDPROC tag; it's only documented in the "new features in 4.5" file
in an area titled "Oracle Reference Cursor Support". I've used the
You can CFINCLUDE a file with any extension.
-Original Message-
From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 12:21 PM
To: CF-Talk
Subject: Includes on HtML?
Hi All,
Another question.
Can you cfinclude from *.htm *.html based files? I want to be
Right, I misread the the question. If the hit counter generates an image,
you can use the same trick that many public hit counters do (for the benefit
of geocities-type sites), which is to put an img src="" in the html file
that points to a CF template. The CF template would then have to
FYI - On NT, one of the perfmon stats within the Cold Fusion object is
'Cache Pops/Sec'; if this is anything other than zero, your template cache
size is not big enough and CF is kicking templates out of cache to make room
for new ones. The performance penalty this causes is significant...
Put the user in the local administrators group. Or, see a breakdown of the
actual rights needed here:
http://www.defusion.com/articles/index.cfm?ArticleID=89
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 9:22 AM
To: CF-Talk
Subject: RE:
Are the applications she's creating Web-based, or are they "native" Windows
applications like those built with VB or suchlike? If they're native (not
designed to work with a browser) she may need to set up Windows Terminal
Services to give coworkers a way to access the apps.
-Original
I don't see why you'd need two licenses. Essentially you're putting two
websites on the same machine, which anyone who does hosting does routinely.
I am lucky enough to have a second server for development, and actually have
two sites on it - one for development and another for testers (so the
This article
(http://www.allaire.com/Handlers/index.cfm?ID=15885Method=Full) describes
an updated CFWR8040.dll file that corrects a memory leak when using an
Oracle native data source as a client variable repository. It's not clear
to me if this update should be applied to CF 4.51 SP2 or only to
No, sorry. According to
http://www.isi.edu/in-notes/iana/assignments/port-numbers, the "Well-known"
ports are 0-1023, the "registered" ports are 1024-49151, and the
"dynamic/private" ports are 49152-65535, so logically it should be that last
range. But I don't know if Oracle followed the rules.
12203 can be a lot of things, unfortunately. You might check the oracle
docs (/network.804/a58230/ch10.htm#428653) for instructions on turning on
logging on the client. The log files are not real easy to read but can
provide some clues.
-Original Message-
From: Tony Schreiber
This is actually an interesting problem. If you look in the TNSNAMES.ORA
file on a machine that connects to the Oracle database you will see an entry
for the database you care about with a "Port=" line; this port has to be
open to the database. However, by default Oracle 8 on NT does something
You could generate a CSV file (comma-separated values) which Excel can open.
Excel does have a relatively low (~ 250) limit on the number of columns that
it will handle with a CSV file, and I've only created files with ~ 1000
rows. Anyway, CF + Unix tools can easily create a valid CSV file.
For your purposes this is probably fine, but readers should realize this is
not guaranteed effective; the browser can send whatever it wants as the
referer, and I think there are some "privacy-oriented" and other customized
browsers that don't send anything at all.
-Original Message-
If you want to use a non-Admin user, there is some info here that might
help:
http://www.defusion.com/articles/index.cfm?ArticleID=89
-Original Message-
From: JayB [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 4:55 PM
To: CF-Talk
Subject: RE: CF Noting Seeing Network Drive
Random untested suggestion: Create an MS Access DB, attach/link the Excel
spreadsheet, and see if Access correctly understands the column as
character/string. If Access gets it right, create a CF datasource to the
Access DB and query the attached table, hoping that Access' field data type
will
Also, SP6A fixes this weakness of IIS (parsing the URL from right to left
instead of left to right).
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 7:55 AM
To: CF-Talk
Subject: RE: "." in urls
Have you tried escaping the '.' with
custom tags; here's one:
http://devex.allaire.com/developer/gallery/info.cfm?ID=44C48F77-35E9-11D4-83
D700508B94F85Amethod=Full
and there are others.
-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 12:20 PM
To: CF-Talk
Subject: Sorting
To somewhat answer part of this, in the past I've come to the conclusion
that IIF is slower than CFIF; I don't remember if that's based on my own
tests or someone else's reports. I still use IIF when it makes something
generally more readable, but not too often...
-Original Message-
I think it would be possible, like
cfset mycounter = 1
cfloop condition="(isdefined("queryname") and mycounter LTE
queryname.recordcount) OR (mycounter LTE listlen(listname)"
cfoutput
cfif isdefined("queryname")
#queryname.fieldname[mycounter]#
cfelse
One way is to check in the same SQL statement as your insert:
insert into mytable (field1, field2)
values (value1, value2)
where not exists
(select * from mytable where field1 = value1 and field2 = value2)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Actually I recommend using the UNC name (\\servername\sharename\dir\file)
because using the drive letter relies on that drive being mapped.
-Original Message-
From: Adrian J. Moreno [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 5:57 PM
To: CF-Talk
Subject: Re: CFContent to a
1) Did you install the Oracle client on the CF Server?
2) Can you connect to Oracle using an Oracle tool (like SQL Plus)?
-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 4:13 AM
To: CF-Talk
Subject: Connecting to an Oracle DB
Anyone help
I thought if the browser, through cookies or whatever, sends a CFID/CFTOKEN
pair that CF doesn't remember (because you've deleted it or CF has deleted
it automatically), CF would make up a new CFID/CFTOKEN pair and give it to
the browser. So if you delete the shared pair, each of your twins upon
Turn on auditing and see what userid is trying to make the connection. I
think when you use CFCONTENT it's actually IIS, and therefore the iis anon
user, that grabs the file. At any rate, it _can_ be made to work.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent:
I don't think it has anything to do with the SP. This:
CFLOOP INDEX="type"
LIST="#termtype#"
tells CF to try to treat the entire query as a list, which is why you get
the error. Try
CFLOOP INDEX="type"
LIST="#termtype.termtype#"
to pass just that field of the query as the
I don't think you'll find an easy way.
From bitter experience, let me recommend that you not lightly accept "make a
web application that works just like this" as the requirements. Even though
it will be frustrating for the user, you need to get them to specify what
each screen and report is
Perhaps
Select *
from member
where membernumber0
and active=@active
and test=@test
order by membernumber
?
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 3:47 PM
To: CF-Talk
Subject: RE: OT STORED PROCEDURES
is there anyway to do
So do you manage your production CF Server through direct registry edits?
-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 11:15 AM
To: CF-Talk
Subject: RE: DoS in coldfusion passwords
The easy and obvious way to never have to lose
And those of us still on 4.0x don't (I think) have that option.
-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 3:16 PM
To: CF-Talk
Subject: LOCKING revisited...
Ok, given that we all agree:
** Access to shared variables should
No. For structure you can use Structcopy. For Queries you're SOL in 4.0x.
I've thought about writing a QueryCopy CFX, which should be pretty easy, but
haven't done it yet.
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 20, 2000 12:26 PM
To: CF-Talk
There is a free open-source-ish ldap server available from www.openldap.org.
It currently runs on various unices; I have gotten it to work in the past
via CF but am not currently using it (or any other ldap server).
Here is what looks like a port of the previous to NT by Qualcomm:
Got curious - it looks like netscape/iplanet have a "eval" LDAP server that
runs on NT available for download:
http://www.iplanet.com/downloads/download/0103.html
-Original Message-
From: Marc Schipperheyn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 6:36 AM
To: CF-Talk
Perhaps a java servlet engine such as Tomcat
(http://jakarta.apache.org/tomcat/)? Unless that's what websphere actually
is, which Hal is rather suggesting.
Or ASP via ChiliSoft
(http://www.chiliasp.com/about/pressrel/caspaix111500.htm).
-Original Message-
From: Stephen Moretti
This is true* for 4.0x. Don't know about 4.5 but I don't think many changes
have been made to CFX support lately.
*You can actually create a DLL with multiple CFX "hooks" (multiple public
interfaces, entry points, or whatever real DLL programmers call them) which
can be accessed using
Seems like something whose practicality can be easily tested. Pick a
commonly run query and set it up to cache. In CF Admin tell CF to cache up
to 10 unique queries. Watch memory usage on the server. If memory usage is
still well within limits, try setting the limit to 20. Repeat as desired.
You're overwriting the same structure with each row. Try this:
cfquery name="thequery" datasource="datasource"
select *
from ads
/cfquery
Cfset stads = structnew()
cfoutput query="thequery"
cfset structinsert(stads, thequery.adid, structnew())
Cfset
When you say "SQL" do you mean MS SQL Server? If so, SQL Server (at least
6.5, the last version I know) doesn't have a rownum. You can either use
CFOUTPUT's startrow and rowcount abilities, or you could query for a list of
all the keys in the table, figure out using the listgetat function the
There's no nice way that I know of (putting a list in a field is a
relational database no-no); the specific kludge would depend on what sort of
database you're using.
-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 7:33 AM
To: CF-Talk
I think a simple "like" will give you false matches - %1% can match1, 11,
121, etc. This is more complicated but I believe it will work:
/*
create table test_match (the_key int, the_sought varchar(50))
create table test_find (a_key int, finder varchar(50))
insert into test_match values (1,
Has anyone written a module to compare queries? I'd just like to know if
two queries are identical or not, I don't care how they're different.
---
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education
~~
Does anyone have code (or is there a function I've overlooked) to compare
two structures and verify that they're logically identical?
Thanks
---
Martin Herbener
[EMAIL PROTECTED]
Kentucky Department of Education
~~
1 - 100 of 250 matches
Mail list logo