I have a question.. Even if you can join on those two databases using fully
qualified paths, how do u create a dsn that you will have to use to execute teh
query?
what does it use for the db? will it work just if you point the dsn to either
of the databases and use full paths?
On 3/26/06, Adam Churvis [EMAIL PROTECTED] wrote:
And one more thing... SSL really doesn't matter because you're not going to
use it everywhere on your site, only in some places, so everywhere else that
doesn't use SSL is still exposed.
The whole application will use HTTPS.
Regards.
Thank you very much. cheers :)
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236232
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
On 3/26/06, Adam Churvis [EMAIL PROTECTED] wrote:
It doesn't work that way. Since your CFLOGINUSER call is inside a CFLOGIN
call, that CFLOGIN call *won't* run when the second server sees your
authentication cookie because CFLOGIN only runs when you are *not*
authenticated.
Actually,
On 3/27/06, Srinivasa Teja Palla [EMAIL PROTECTED] wrote:
I have a question.. Even if you can join on those two databases using fully
qualified paths, how do u create a dsn that you will have to use to execute
teh query?
what does it use for the db? will it work just if you point the dsn to
This is how I did it:
SELECT db1t1.listing_id, db1t1.listing_mlsnumber,db1t1.listing_type,
db2t2.pLisPric
FROM db1.table1 db1t1
INNER JOIN db2.t2 db2t2
ON db2t2.pMlsNum = db1t1.listing_mlsnumber
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
Hi, there. I am creating my first Java CFX tag, and I am getting the
following error:
PullNTID (Unsupported major.minor version 49.0) null
The error occurred on line 1.
(PullNTID is the name of the class.)
Any thoughts?
TIA,
Matthieu
What is a text editor I can use to turn on a feature that will let me
see the difference between a CR and LF?
Thanks!
Jon
This electronic message transmission contains information from Collegiate
Funding Services, LLC or its subsidiaries or affiliates that may be
confidential or privileged.
Subversion is the most useful software tool I've used in the last 3
years I've found that it works *very* well with my coldfusion web
projects...
Jon
-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 8:25 AM
To: CF-Talk
Subject: Re:
Hi All,
I am wondering what the best way to handle the following situation is. I
have a database with approx 100,000 records. Users can search on these
records with multiple criteria. Some result sets can contain 10,000 records
or more. Also, there is a possibility of sorting the results.
Doesn't MS Word to that with the little paragraph symbol button?
I know it differentiates between returns and paragraph breaks...
~Brad
-Original Message-
From: Jon Block [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 9:36 AM
To: CF-Talk
Subject: Can I see line feed vs.
binhex32 (in hex mode)
On 3/27/06, Brad Wood [EMAIL PROTECTED] wrote:
Doesn't MS Word to that with the little paragraph symbol button?
I know it differentiates between returns and paragraph breaks...
~Brad
-Original Message-
From: Jon Block [mailto:[EMAIL PROTECTED]
Sent: Monday,
Out of the blue a week ago, a page that I have been using for years started
giving me this error message.
Invalid connection specified.
The connection attribute you specified, getFileNames, is invalid or does not
exist
Nothing has change in the code. It will grab one file and then throw the
The connection value actually returns an object with the name you specify.
You have called it 'filename' and I'm guessing that you also have a query
called 'getFileNames' with a column of filename.
I think the two variables are then getting confused - I would just rename
the connection to
I assume SQL Server's Invalid object name error is typically a result of a
missing table or mistyped table name. But I'm seeing it at a rather odd
time.
When I run a certain query as part of a CFC function, I receive the error
Invalid object name 'dbo.tecSOLine'. But if I pull the
MS Word will do it.
-Original Message-
From: Jon Block [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 9:36 AM
To: CF-Talk
Subject: Can I see line feed vs. carriage return?
What is a text editor I can use to turn on a feature that will let me
see the difference between a CR and
Are you using SQL Server 2005?
Respectfully,
Adam Phillip Churvis
Certified Advanced ColdFusion MX 7 Developer
BlueDragon Alliance Founding Committee
Get advanced intensive Master-level training in
C# ASP.NET 2.0 for ColdFusion Developers at
ProductivityEnhancement.com
- Original
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 11:05 AM
To: CF-Talk
Subject: Re: Can I see line feed vs. carriage return?
binhex32 (in hex mode)
On 3/27/06, Brad Wood [EMAIL PROTECTED] wrote:
Doesn't MS Word to that with the
Students qualify for a special student 60% discount on CFUNITED. This is
ONLY for full time students at a recognized college, university or high
school. Email liz (at) teratech.com if you want a code.
Come to the premier ColdFusion conference of 2006 in Washington DC area
6/28-7/1/06
(Four
No,
MSSQL 2000
-Original Message-
From: Adam Churvis [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 1:14 PM
To: CF-Talk
Subject: Re: DB Pagination Question
Are you using SQL Server 2005?
Respectfully,
Adam Phillip Churvis
Certified Advanced ColdFusion MX 7 Developer
Hi all, i have a weird problem with a page that has an execution time of
46031 milliseconds. There is only one file that is causing the
problem. If i comment out the cfinclude tag that includes the file,
the page loads fine naturally. However, if I erase the contents of the
file so that it
Jim Curran wrote:
what is the most efficient way to paginate through the results,
without hogging memory or re-running the entire query for each page view?
Unfortunately, I believe those are your only two options. You either
cache the query into resident memory (memory hog) or you run the
Sorry. I had actually changed the name to see if it didn't like my connection
name fileName with the error I posted. All the connection names are the same.
I added a timeout of 500 to the connection and it did not help.
The connection value actually returns an object with the name you specify.
Charles Cruise wrote:
Hi all, i have a weird problem with a page that has an execution time of
46031 milliseconds. There is only one file that is causing the
problem. If i comment out the cfinclude tag that includes the file,
the page loads fine naturally. However, if I erase the contents
I'm currently a CrystalTech customer. For $27/month I get 1GB of disk space
and 100GB of bandwidth to name a few. The only thing thats missing is access
to a folder above my webroot so I can store docs outside of my site for
security. This way I can retrieve them with cfcontent and keep the
I believe this was talked about a couple of months back and some people
suggested using a method of selecting not only max rows but to find do a
hack to get the start row by using the IN keyword to somehow filter out
the ones for the pages you're already past. That would do it on the DB
side
Jordan Michaels wrote:
Charles Cruise wrote:
Hi all, i have a weird problem with a page that has an execution time of
46031 milliseconds. There is only one file that is causing the
problem. If i comment out the cfinclude tag that includes the file,
the page loads fine naturally.
I'm a big fan of Dantor.com. I know for a fact you have access above your web
root. as for the space and bandwidth, they have different packages, most of
them below the $27 you're spending now. I've been using them for projects for
about 6 years...stable, responsive, nicely priced.
And as
Oh, and they've always proven themselves to be very good about keeping up with
version updates. They are using MX7 and sql 2005.
I'm a big fan of Dantor.com. I know for a fact you have access above
your web root. as for the space and bandwidth, they have different
packages, most of them
Does anyone know of a CFhost provider that has access to folder above the
clients webroot and offer cfdirectory and cffile along with high storage and
bandwidth?
I have a site with CFDynamics and they have all you request, with their
49.95/month plan. Their less expensive plans do restrict
Doug, maybe you've already done this little check, but can you use the same ftp
settings outside of cfftp (like in Leech or some other ftp utility) and
successfully make the connection?
Sorry. I had actually changed the name to see if it didn't like my
connection name fileName with the error
I can do that for you. My standard packages dont cater for that big a site
but that doesnt mean i couldnt do it. I can configure a package for you
however you like .
And I think its almost essential ot have access to a level above the web
root, for teh very purpose you're talking about.
And
I assume SQL Server's Invalid object name error is
typically a result of a
missing table or mistyped table name. But I'm seeing it
at a rather odd
time.
When I run a certain query as part of a CFC function, I
receive the error
Invalid object name 'dbo.tecSOLine'. But if I pull the
This morning, my site just... stopped...
I restarted all cf services, on both Load-balanced web servers.. That didn't
help... I restarted the servers themselves, and that still didn't help,
though it turns out html pages work fine, just not cfm.. php pages also work
fine.
My hosting guys are
What if the problem isnt the table name but the owner name?
I've had similar issues, and replaced SELECT * from dbo.tecSOLine
with SELECT * from tecSOLine
IF that works where the other doesnt, then you probably need to either
change your query code, or change the object owner. Look in Books
That's too bad. With SQL Server 2005 you can do this:
With Books AS
(select
isbn,
title,
ROW_NUMBER() OVER(order by Title) as RowNumber
from
book)
select
*
from
Books
where
RowNumber between 2 and 14
and then just use a simple calculation for the starting and ending row
I am getting the  character appearing when I am outputting data from a mysql
database (where carriage returns should be located), I take it this is
something to do with the charset for my website. The data that is stored in the
database is entered through fckeditor, is this problem caused
You can just search the archives for your name and/or email address:
http://www.houseoffusion.com/cf_lists/threads.cfm/4
-Original Message-
From: Srinivasa Teja Palla [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 25, 2006 1:28 PM
To: CF-Talk
Subject: reg ex for url extraction..
Hello all,
We are currently working on implementing a new source control system and are
turning to SVN as our original VSS system was not meeting out needs. We
have the development side worked out, but our problem comes when we start to
consider QA. The way our codebase and development works is
h... does getFileNames mean something in your code? I still suspect that
could be the key to the error. but on the other hand could be a change on
the ftp server you are connecting to as Doug suggests.
On 3/27/06, Doug Bedient [EMAIL PROTECTED] wrote:
Sorry. I had actually changed the name
The only thing thats missing is access to a folder above my webroot
so I can store docs outside of my site for security.
The is a way to get around this problem:
- store your docs in a special directory, but change the name to
whatever.cfm
- save the true name and type in your database.
- put
You can do it with w/pure SQL server, but it can be pretty expensive
depending on the query.
The idea is to do:
select top 10
*
from
(
select top 40
*
from
table
order by
Hi Rich, You need to consider using branches. These let you isolate a set of
changes from the trunk. A branch can be developed and tested and QA'd
separately then when signed off can be merged back to the trunk. At this
point it does need retesting because of an subsequent changes. Small issues
Claude has a good solution there, but you could also have them create a
secure directory that only you and the CF user has access to. Throw in
an .htaccess file (or it's equivalent in the windows world if that's
what you're on), so spiders don't try to index it.
-Original Message-
I meant to remove the email address suggestion, but forgot. HOF doesn't
list the email address in the archives (thankfully).
-Original Message-
From: Munson, Jacob
Sent: Monday, March 27, 2006 1:00 PM
You can just search the archives for your name and/or email address:
Good catch, Mike. I knew that too and either it didn't occur to me or
I forgot to mention it... I think it falls into the category of things
that I sort of assume have already been checked.
What if the problem isnt the table name but the owner
name?
I've had similar issues, and replaced
If only! The solution may well be something as simple, but unfortunately
that's not it...
-Original Message-
From: Michael Traher [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 2:05 PM
To: CF-Talk
Subject: Re: Invalid object name
this is probably way to obvious but is the
Search the House of Fusion for captcha. Tons of stuff there.
M!ke
-Original Message-
From: Mike Garner [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 3:51 PM
To: CF-Talk
Subject: Security image based on string
Anyone know of any CF code out there that will allow me to create
test
Hello all!
This is probably easy stuff for most.
How do I handle null values in the source csv file when importing into db.
The following lines of code work only when there is no null value in the
source file.
Also how do I handle commas that are in the data itself.
Is there a custom tag or
I second that. There are a number of functions out there, some free and
some not. A search for captcha will wrangle you some good results.
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 3:53 PM
Search the House of Fusion for
You're serious about this? are you sure you didn't just setup your default
dreamweaver site to show from www/
I took a look at the hosting plan and of course there is nothing there about
this except the following. They allow you to host unlimited Microsoft Access
Databases on your site. Are they
I have been around and around fighting for a potential client on this
Issue and they are dead set there is no directory access outside the
root web folder.
-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 6:57 PM
To: CF-Talk
Subject: Re: CF
I've been wondering why the CF team has not switched over to using
J2EE security. A rewrite of cflogin code that can use JAAS would be
just swell and allow integration with non CF J2EE products without
messing with web.xml files and such, eh?
DK
On 3/27/06, wolf2k5 [EMAIL PROTECTED] wrote:
On
HostMySite provides access to the account root, serving web content
from a folder under that.
For your $27.95 you could get 4GB of space and 60GB of bandwidth.
http://www.hostmysite.com/hosting/builder/
On 3/28/06, Coldfusion [EMAIL PROTECTED] wrote:
I have been around and around fighting for
http://www.fusionlink.com/ ck'em out
On 3/27/06, James Holmes [EMAIL PROTECTED] wrote:
HostMySite provides access to the account root, serving web content
from a folder under that.
For your $27.95 you could get 4GB of space and 60GB of bandwidth.
will admit upfront: i haven't a clue about CF.
which is why i'm here.
i'm trying to design an application where:
user fills out some forms
(submits)
then their input is gathered + spit back out in a flash movie
i've seen this accomplished in both .php and .cfm but don't know what the
I don't know a lick of Java and have played with Flash Remoting and AS 2. I
can see the future in either Ajax of Flex. I'm sorta leaning towards Ajax
cause from my understanding its cheaper, now, and I think it can be deployed on
any hosting services.
Also correct me if I'm wrong but Flex
thanks eric - this helps.
while i now clearly see the CF light...there's gotta be a darkside lurking
somewhere. yeah? maybe just a little bitty one?
scenario: i'm a designer trying to steer our team in a good direction but i
stop at HTML.
to me, the applications i've seen done in PHP aren't as
I think its a question of money. PHP is free, and most hosting services offer
it.
thanks eric - this helps.
while i now clearly see the CF light...there's gotta be a darkside lurking
somewhere. yeah? maybe just a little bitty one?
scenario: i'm a designer trying to steer our team in a good
Exactly. To quote Heinlein, The answer to any question that begins
with 'Why don't they' is invariably 'Money'.
On 3/28/06, j s [EMAIL PROTECTED] wrote:
I think its a question of money. PHP is free, and most hosting services offer
it.
thanks eric - this helps.
while i now clearly see the
I've been very happy with CFAJAX - it offes a good feature set and it
can be deployed without mappings or any other admin changes. AjaxCFC
is similar in some ways, and there are other options like JSMX and
Neuromancer.
In general I've found AJAX techniques to be relatively easy to use
(via
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 28, 2006 12:38 AM
To: CF-Talk
Subject: Re: cfm vs. php?
Exactly. To quote Heinlein, The answer to any question that begins
with 'Why don't they' is invariably 'Money'.
And this works on both
Hey, they can buy Websphere and then deploy CF Enterprise in it - that
makes it even more expensive so it has to be even better!
On 3/28/06, Jim Davis [EMAIL PROTECTED] wrote:
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 28, 2006 12:38 AM
-Original Message-
From: j s [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 11:21 PM
To: CF-Talk
Subject: where to start Ajax or Flex?
I haven't see or notice much talk about CF and Ajax. Can someone point me
in the right direction on how to get started and their
I know this will be simple for some .. but it isn't for me .. I have tried to
find something for this.
I need to remove all punctuation except for spaces between words. I only want
alpha and numeric (plus spaces) left.
Example:
Str = I don't remember, if it was 12 or 12'?
Result = I dont
Backbase: http://www.backbase.com/ It's a server-side engine thing
that requires J2EE or .NET, rather than directly supporting CF in the
way that CFAJAX and ajaxCFC (etc) do. All in all it looks like a pain,
but I haven't tried it so I can't have an opinion.
BTW, I mentioned YODEL in the FA
rereplacenocase(string, '[a-z0-9 ]+', '', 'all')
This will remove every occurences of a character that is NOT within the range
of A-Z (both cases), 0-9 or a space. This will include ANY non-number/letter
character so if there is something you want to keep, it has to be included
within the
67 matches
Mail list logo
