Dug a little deeper and turned on the -verbose command. It says
Skipping key [http://127.0.0.1:8500/mysite/ because of mime-type
If I change it to include the index.cfm it still says the same thing.
Anyone familiar with what could be causing this mime-type problem?
I've experimented
With SQLServer (2000 I believe) if that matters, which it may well.
I have a data column that contains titles. I desire the titles to be
sorted alphabetically as a human would not a computer. The records I'm
currently concerned with start with a quote () and need to start with a
quote.
HISTORY|BACKGROUND
I am in the process of reworking a ColdFusion and Oracle 11g
application. At one point this application sends some files it
generates to another server with FTP. For various reasons, the FTP is
being done with the Oracle database management system. Thus we are
running
If you'd like to keep things simple, create a new column and enter the title
as you'd like it to be ordered by. Would love to hear if someone has an idea
about this also.
Adrian
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: 16 March 2009 14:27
To: cf-talk
I'm not sure if I follow you, completely, but you can use string
manipulation functions in the ORDER BY clause to sort your data. For
example, you can use the replace function to remove quotes, for sorting.
Thanks,
Mike
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
FTP typically uses port 21.
--
Scott Stewart
ColdFusion Developer
4405 Oakshyre Way
Raleigh, NC 27616
(h) 919.874.6229 (c) 703.220.2835
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, March 16, 2009 10:37 AM
To: cf-talk
Subject: (ot) FTP and the ports it
Scott Stewart wrote:
FTP typically uses port 21.
For the control commands and another port for the data.
http://en.wikipedia.org/wiki/File_Transfer_Protocol
~|
Adobe® ColdFusion® 8 software 8 is the most important and
Ian, you could do something like this...
select * from footest
order by (case when title like '%' then substr(title, 2, length(title))
when title like 'a %' then substr(title, 3, length(title))
when title like 'an %' then substr(title, 4, length(title))
when title like 'the %' then substr(title,
but you can use string
manipulation functions in the ORDER BY clause to sort your data.
That would prevent the query from using an index, and it may have some
impact on performance.
An alternative would be to apply these functions once for all on the
titles,
store the result in an extra
Rick Faircloth wrote:
Hmmm... let me look at ServerPronto's site...
- Intel Pentium 4, 3 GHz (as opposed to a Quad Core Pentium)
You don't get a quad core pentium, you get a time-slice off a quad core
pentium.
- Only 6 email support tickets per month ($15 each for extra!)
- 6 reboots
I've kinda lost track of who I'm responding to...did you just
reply to this to get the topic back in the loop, Mike? I didn't
see any comments by you below. I assume that means you're just
re-asking the question does anyone have any experience with KickAssVPS.com.
If so, I've had about 9
PS - and from Jochems remarks awhile back, you do
just get a slice of a quad-core Pentium, but that beats
a slice of a Pentium 4!
That is not necessarily true.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
Doing any PDF or image creation/manipulation? If so how are you finding it
for speed?
Adrian
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: 16 March 2009 16:04
To: cf-talk
Subject: RE: Anybody have exerience with KickAssVPS.com?
I've kinda lost
I'm with Claude on this one, your best bet it probably to generate another
column such as sortTitle that you can then sort on.
On Mon, Mar 16, 2009 at 11:39 AM, Claude Schneegans
schneeg...@internetique.com wrote:
but you can use string
manipulation functions in the ORDER BY clause to sort
Sorry for the long post but I've been working on this for a few days
and have got nowhere
I'm working with flex and cf and I have a bean.. it looks okay but
just testing it with an init() function is giving me an error
The argument HEADLINE_ID passed to function init() is not of type numeric
I'm
I would agree with Brian and Claude on adding the column for sorting. It
would be easy enough to adjust your INSERT / UPDATE calls to auto-create
the sort version, like this:
cfset sortTitle = replace(reReplaceNoCase(form.title, (A|An|The) (.*),
\2, \1), , , all) /
UPDATE ...
SET title =
never mind, the other bean uses string for everything.. so my problem
isnt in the bean
On Mon, Mar 16, 2009 at 11:42 AM, Greg Morphis gmorp...@gmail.com wrote:
Sorry for the long post but I've been working on this for a few days
and have got nowhere
I'm working with flex and cf and I have a
I and the wife have some family obligations in Denver Co from March 23rd
Through
April 4nd. That being said we should have lots of free time in the
evening/weekend and are hoping to hop into some conferences, seminars, classes
or
even a meet-up group or two. I am big into ColdFusion, CSS,
On Mon, Mar 16, 2009 at 1:54 PM, Richard Dillman rdill...@gmail.com wrote:
I and the wife have some family obligations in Denver Co from March 23rd
Through
April 4nd. That being said we should have lots of free time in the
evening/weekend and are hoping to hop into some conferences,
Your default is an empty string. Set the default to 0.
~Lori
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Monday, March 16, 2009 12:42 PM
To: cf-talk
Subject: bean? anything wrong?
Sorry for the long post but I've been working on this for a few days
and
Check out the SQL PATINDEX function. In combination with SUBSTRING and
REPLACE, you could retrieve a column that omits the leading words and then
ORDER BY that column.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, March 16, 2009 9:27 AM
To: cf-talk
Can you explain, Dave?
It makes sense to me that a VPS would only be getting
a part of the processing potential of whatever processor
it's running on...is the quad-core different? Could I be
getting an entire core to myself of the quad?
Or is it not necessarily true that a slice of a quad core
Virtually every site I have running on it does image creation/
manipulation. Upload, rename, resize, create multiple sizes, etc.
I'm doing all that with cffile and cfimage.
Speed seems fine. I haven't done any actual speed tests to compare.
Speed for me is not much of an issue, since
Hi All,
I have a page that loads a modal popup using ShowModalDialog. To get around
issues with submitting data inside a modal dialog, I have an iframe to
handle posts within in the modal dialog.
The popup gets triggered two minutes before the session is about to timeout.
They assume that
I forgot the code snippet.
cfquery name=qTransCheck datasource=#DSN# dbtype=odbc
select distinct(count prodcode)
from product
where product.manufid = '#scan.manufid#'
cfif variables.stError.v010.occurred
AND product.famcode2 matches '#left(scan.famcode, 2)#.'
/cfif
Can anyone point me to the error in this code and the generated query?
I am kind of stuck right now as it all looks ok to me.
Thanks
--S
^
[Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC
Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL
statement at or
This is invalid:
distinct(count prodcode)
Are you trying to do a DISTINCT on the aggregate function COUNT()?
Not sure that would work, but it would have to be DISTINCT COUNT(prodcode)
if that's what you're after.
~|
Thanks. I found it finally.
The right syntax (for this issue) is select count(distinct prodcode) as prodcnt
There was a second issue with computed_field_1 the was being bounced
by the ODBC driver as well.
On Mon, Mar 16, 2009 at 3:54 PM, Jason Fisher ja...@wanax.com wrote:
This is invalid:
Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in
handy some day. Thanks!
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
COUNT(DISTINCT [fieldName] is very important to remember when using JOINS. For
example, if you have the query...
SELECT COUNT(A.code) AS total
FROM TableA A INNER JOIN TableB ON A.code = B.code
And you wanted to know how many records in TableA have records in TableB.
If this query returns 10
worked for me. Plus, that is what Adobe shows in their docs.
2009/3/16 Jason Fisher ja...@wanax.com:
Interesting ... COUNT(DISTINCT prodcode) will work, huh? That may come in
handy some day. Thanks!
~|
Adobe®
I've been trying to make my app establish a user session. I put my user
validation code in my controller's prefuseaction:
!--- authenticate against the AD ---
cfntauthenticate username=#theusername# password=#thepassword#
domain=#thedomain# result=authresult listgroups=no
I ended up getting a dedicated server from CFDynamics, the $189 a month
dedicated package. CF was included in the price as was a shared SQL server.
While it isn't a particulary fast machine (not a quad core p4), since I have it
all to myself, it runs like a champ. I have had it running for 2
try: parent.top.location.href
Andrew.
Hi All,
I have a page that loads a modal popup using ShowModalDialog. To get around
issues with submitting data inside a modal dialog, I have an iframe to
handle posts within in the modal dialog.
The popup gets triggered two minutes before the
As a KAVPS user looking for other providers (note the looking for other
providers part...), I would highly recommend you stay away from them.
Dear Anon ymous,
If you put ANYTHING of consequence on a VPS for $25-35/mo. you have simply
gotten what you paid for.
You get what you pay for.
It makes sense to me that a VPS would only be getting
a part of the processing potential of whatever processor
it's running on...is the quad-core different? Could I be
getting an entire core to myself of the quad?
Or is it not necessarily true that a slice of a quad core
beats a slice of
Hello Jeffry,
I hear that a lotI believe that there is good and bad
everywhere. In my opinion, if you are really good and you do your job
honestly, no matter who you are (native or foreigner), that you will get
paid fairly and you will not be treated as servants (not sure about
other
Interesting outlook although over here at least the CIO's message to
managers is move all development to the east(they are referring to India)
because we are not an IT company. I had a meeting last week with a local
manager and he told me they are seeing a 50% drop in efficiency by moving
things
I like Ravi's positive outlook, but I have to somewhat disagree and say
that there are lots of companies that will, without hesitation, do
what's best for them, regardless of how loyal you've been or how hard
you've worked. It's up to you to keep your eyes open, so if you see it
happening,
From what I gathered last week it is not just within their boarders. Like I
mentioned someone here is already looking into outsourcing work to an outfit
out of Brazil. About 7 years ago I worked on a project here that was with a
Brazilian. Shared an office with him for about a year before he
Hello Rob,
I agree with you. Companies will always do whats best for them no matter
what. This is the nature of capitalism. One should never take anything
for granted especially in this ever changing field of work.
Ravi.
RobG wrote:
I like Ravi's positive outlook, but I have to somewhat
Hello Aaron,
You are right. There are outsourced jobs in Brazil as there are their
own created jobs. This is what I meant to say. I also know of a
Brazilian guy that has been working for a company in the US while living
in Brazil. But he tells me that his job is somewhat vulnerable. Usually
RobG wrote:
I like Ravi's positive outlook, but I have to somewhat disagree and say
that there are lots of companies that will, without hesitation, do
what's best for them, regardless of how loyal you've been or how hard
you've worked.
If it is a publicly traded company, it is illegal
Or even themselves for the long run but in the shortrun it will make the
stock holders happy.
On Mon, Mar 16, 2009 at 12:43 PM, Jeffry Houser j...@farcryfly.com wrote:
RobG wrote:
I like Ravi's positive outlook, but I have to somewhat disagree and say
that there are lots of companies that
44 matches
Mail list logo