Hi Mark
As far as I know, you'd need to do this use cfcontent/cfheader to deliver a
file, that itself sits outside of the web root but still accessible to the
CF server. If the file is within the web root, and someone has the url, CF
(as far as i know) cant control access to it if the file-url
Myspace failed because it was full of ugly sites with content no-one
wanted to read.
Absolutely. And to add to it - then came along an alternative, facebook,
which was not full of ugly sites with content no-one wanted to read. So
myspace failed.
On Tue, Jul 26, 2011 at 6:16 AM, James Holmes
Do you have many queries (especially queries ran very often) that do not use
cfqueryparam? Those symptoms remind me of system I worked in once where most
of the queries were not using queryparam or any other form of binding - and
as a result sql's query cache was filling up too often... though
/16/11 9:50 AM, Charlie Stell wrote:
Do you have many queries (especially queries ran very often) that do not
use
cfqueryparam? Those symptoms remind me of system I worked in once where
most
of the queries were not using queryparam or any other form of binding -
and
as a result sql's query
of), no increase in traffic.
When you say request increase are you talking about behind-the-scenes
DB requests? Or an increase in usage by people with a corresponding
increase in DB traffic?
On 5/16/11 10:06 AM, Charlie Stell wrote:
Have you recently upgraded versions of MS-SQL? And/or recently had
Other than an eventual timeout thrown by CF - are you getting any SQL errors
when this situation arises? (from either cf trying to run a query or when
trying to execute a query via analyzer) Do any errors show up in the SQL
logs?
On Mon, May 16, 2011 at 12:37 PM, Charlie Stell charlie.st
- just running a simple query in the query
analyzer tool, it just spins until it finally resolves, however long it
takes.
As far as the sql logs, my server guy hasn't indicated anything special
showing up.
On 5/16/11 10:48 AM, Charlie Stell wrote:
Other than an eventual timeout thrown
Are you using any *s in your select statement?
On Mon, Apr 25, 2011 at 2:05 PM, Scott Weikert li...@alphageek.cc wrote:
I've done some digging on this and everything I'm finding is ancient
(circa 2007).
Today I started getting a corrupt table error with every query that
has a cachedwithin
You'd likely want to defined two iis sites, one for dev and one for prod.
For each site, the home directory should be the respective code base for each,
and you'd want to add a virtual directory pointing to cfide on each. The
differing drives should be no problem.
Hope that helps!
Charlie
So this was a weird one... the error is resolved, but I was wondering if
anyone could explain what was causing my error.
I had a query that was timing out (its one of those nice long monster
queries - so I'm not pasting it in its entirety) - but when I copied/pasted
out of the cfcatch.sql (from
This might be an issue I've had to deal with before.
Do something to change the fingerprint (no idea what the correct term
would be) of the query - or restart cf. By change the fingerprint, it
could be something as simple ad swapping p.* and pt.* (swapping as
in their ordinal position in the
I ran into a problem in the past where queries were getting hung - queries
that usually executed all the time without issue (and queries that I could
copy and paste into analyzer and run just fine). It turned out to be SQL
running out of memory and not being able to compile an execution plan. The
If your using MS SQL 2005 or newer, you could use the row_number() feature-
one query using a funciton:
with f(catg, nltitle, nldate, nth) as (
Select catg, nltitle, nldate, row_number() over (partition by catg order by
catg, nldate desc) as nth
from newsletters)
select * from f where nth = 1
In the long run - your best option is to create third table that will link
listsings to multiple feature codes. This is true for many many reasons.
If your looking for a quick solution that doesnt involve changing tables -
you could use a sql split function (good ex.
When I've had to deal with the same situation previously, I usually
created a lookup structure based on the column ill use as a handle -
mystruct[value I want to ref by]=row index from query (this struct
would get populated by looping over whole query) . This index then can
be used to get at that
How are #current_ListingID# and #currentow# getting set? My guess would be
that within your loop over allimages, these are never being changed, so all
these copies are to the same destination file... resulting in only the last
file in the source directory being in the destination directory.
Ive had a similar issue when working with a form with a field named
action.
On Thu, Apr 1, 2010 at 11:53 AM, Mark A. Kruger mkru...@cfwebtools.comwrote:
Yes I don't know anyone who really used that feature since CF 4.x ...
it
was actually pretty crude. Useful for intranets or whatever -
Id put my money on it somtimes not finding / - so your end is 0, your
start is 0, and your getting a negative with mid
On Wed, Feb 10, 2010 at 1:23 PM, b...@bradwood.com wrote:
CGI scoped variables always exist.
#cgi.I_like_cheese_burgers# should return an empty string-- unless of
course,
I was using EntityLoadByExample today and the behavior wasn't what I was
expecting.
I expected it would be able to replace the query I always do right before
insert (the check query) - to make sure that the insert wont conflict with
unique constraints.
Ive bee using it like this:
x =
the code is doing placing it
in
a try catch block, and checking for the exception of a constraint error
would be better and easier to read and understand in 6-12 months time.
On Thu, Dec 17, 2009 at 6:06 AM, Charlie Stell charlie.st...@gmail.com
wrote:
I was using EntityLoadByExample
First I used your example posted, so your eample has that IsNULL error to
begin with.
My example:
if(isNUll(EntityLoadByExample(x)))
x.save() //If it's not found, save it - this will cause an insert without
problem
else
x = EntityLoadByExample(x) //if it was found, use it
I think I see
Maybe ORM will do more than I originally thought... If I start with two
empty tables - domain and email, and get an email from
x...@gmail.com(curDomain-gmail.com, curUser-xyz), and the code below
runs, two records
will be inserted (one in each table).
And then later on, I get an email form
Man... I was getting excited at the prospect that CF would read the DB
structure, see the unique constraints on a table, realizes all the needed
properties were defined and try to identify it. Afterall, I just realized
the docs say ColdFusion automatically tries to find if a new record should
be
I believe you would want :
variables.errorMsg =
createObject(component, com.util.errorMessages).init();
On Wed, Nov 25, 2009 at 3:36 PM, Chung Chow cyc...@annex.net wrote:
Hi all,
I'm trying to instantiate an object either in the psuedo-contructor or
init of my cfc as a variable so I can
Id check the following:
That your referring to the CFC in the same way you are defining them. (since
you say it works when defining with teh functions, I think this is most likely)
The method-access on the other CFCs.
That the init function of external CFCs are returning this.
You could also
Id check the following: That your referring to the CFC in the same way you
are defining them. (since you say it works when defining with teh functions,
I think this is most likely)
See if there is any difference made by instantiating them within the init
function. The method-access on the other
Try the following -
Add a function to your cfc that will return variables.X - X being whatever
instantiated cfc you cant call the function of.
Dump the results of new function - this should help you debug.
~|
Want to reach
I have the following tables:
---Hierarchy 1: Table per subclass without discriminator---
T1,T2,T3
T1
PK-Identity
T2
PK- is FK from T1
T3
PK- is FK from T1
---END: Hierarchy 1---
---Hierarchy 2: Table per hierarchy---
T3
T3
PK- is FK from T1
is_simple, type = bit. (not mentioned in
28 matches
Mail list logo