On Fri, Jan 16, 2009 at 2:11 AM, Craigsell wrote:
We are working on one of our CF webservers and noticed something strange. A
user was running a very long query which subsequently displays on the browser
(10+ minutes, tons of data - don't ask it's a mess). It was chewing up huge
amounts
hi all,
Is it possible to call a cfm page from cfc?
i.e, My requirement is to call a cfm page and store the output in a variable
all inside cfc.
Please help me if this is possible.
Thanks,
Dev
~|
Adobe® ColdFusion® 8
hi all,
Is it possible to call a cfm page from cfc?
i.e, My requirement is to call a cfm page and store the output in a variable
all inside cfc.
Please help me if this is possible.
Thanks,
Dev
~|
Adobe® ColdFusion® 8
Can someone please show me how to load a class file in ColdFusion. I've tried
everything from copying the .class file to the C:\CFusionMX7\lib directory to
copying it to the C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even
know if just by dropping the file to a specific directory
Can someone please show me how to load a class file in ColdFusion. I've tried
everything from copying the .class file to the C:\CFusionMX7\lib directory to
copying it to the C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even
know if just by dropping the file to a specific directory
This:
cfsavecontent variable=myPage
cfinclude template=my-page.cfm
/cfsavecontent
cfdump var=#HTMLEditFormat(myPage)#
Or this:
cfhttp url=http://www.adrianlynch.co.uk/;
cfdump var=#HTMLEditFormat(CFHTTP.FileContent)#
Adrian
-Original Message-
From: dev losh
Can someone please show me how to load a class file in ColdFusion.
I've tried everything from copying the .class file to the
C:\CFusionMX7\lib directory to copying it to the
C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if
just by dropping the file to a specific
Can someone please show me how to load a class file in ColdFusion.
I've tried everything from copying the .class file to the
C:\CFusionMX7\lib directory to copying it to the
C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if
just by dropping the file to a specific
What is the best way to join tables across two databases servers?
Say I have one MS SQL server that has a database that stores ERP product data.
I have our website MS SQL server that stores extra data about the product
records in the ERP database.
Is it possible to hook each datasource up in
We maintain sessions for a variety of reasons. Our sites contain
multiple user facing applications, typically dealing with product detail
or directly reviewing client inventory. Sessions are used to track a
site user's full path through a site. Page views, lead submissions, app
level review
You can reference the database by name in the query
Ex:
select t1.Field1, t2.Field2, t2.Field3
fromdatabase1.dbo.Table1 t1
inner join database2.dbo.Table2 t2 on t1.Field = t2.Field
you might need to put that into a stored procedure or use a dsnless
connection
What is the best way to join tables across two databases servers?
Say I have one MS SQL server that has a database that stores ERP product
data. I have our website MS SQL server that stores extra data about the
product records in the ERP database.
Is it possible to hook each datasource
You need to link your SQL Server instances. Google SQL Server Linked.
You can link the servers both directions, if needed.
With the server linked in SQL, you can create cross-server queries in
the Query Analyzer/New Query editor.
mike
-Original Message-
From: Chad Gray
Thanks for everyone who commented. Love the community here at HoF!
-Original Message-
From: Andy Matthews [mailto:andymatth...@comcast.net]
Sent: Thursday, January 15, 2009 4:21 PM
To: cf-talk
Subject: ColdFusion method to fade hex color a specific % or amount
Does anyone have a CFC
I can see this working when you have two databases on the same server. I have
two databases on completely different servers.
Can you preface the database name with the server name/IP?
Server1.database1.dbo.table1?
I would think you would need login credentials stored somewhere to do this.
Or
Ah.. so there is a way in MS SQL to link two servers together.
Then I would just add one DSN in CF Admin. How do you write your SQL in
CFQuery?
SELECT *
FROM server1.database1.table1 AS a
JOIN server2.database2.table2 AS b on b.index = a.index
Thanks, I will go read up on linking two
You need to link your SQL Server instances. Google SQL Server Linked.
You can link the servers both directions, if needed.
With the server linked in SQL, you can create cross-server queries in
the Query Analyzer/New Query editor.
Well would ya look at that! Learn something new every day,
You can join different tables that are both in the same db in a query
(through a union or join). You can't, through a query, join tables from
two entirely different databases. That will require some back-end DBA
re-architecting. I'm not familiar with ms-sql (I do oracle) but somebody
mentioned
Yes you can do it in oracle too and it works in both directions. In fact
you can even do the link with non-oracle databases.
*
Use the CREATE DATABASE LINK statement to create a database link. A
database link is a schema object in one database that enables you to
access objects on another
You first link your server and give it a name. The name is arbitrary,
but should be meaningful.
Then, a query would look like
SELECT *
FROM Database.dbo.Table A
JOIN MyLinkedServer.Database.dbo.Table B ON A.id = B.id
No need to specify the linked server name for the local server or the
server
Here is something else fer ya.
If you are linking a 64-bit version of SQL to a 32-bit, you will need to
run a script on the 32-bit server that updates the system stored
procedures.
http://support.microsoft.com/?id=906954
mike
-Original Message-
From: C. Hatton Humphrey
Thanks, Michael, that put me on the right track. However, I also had
to disable the anonymous user access in order for it to work as
expected.
Thanks again,
Pete
On Thu, Jan 15, 2009 at 2:12 PM, Dawson, Michael m...@evansville.edu wrote:
I forget the actual option, but it's not Basic
500 Event Handler Exception. That's all it says. I've turned on
debugging but it doesn't display any debugging information either.
What do your log files say?
Leigh
~|
Adobe® ColdFusion® 8 software 8 is the most important
We are running CF7.0.2 Enterprise on a Windows 2003 Server. We are trying to
use CFSlider on one of our pages and some of our support staff is getting the
following error: The application's digital signature has an error. Do you want
to run this application?Name:
That's the sort of thing I was thinking of. I've always done that sort
of thing via cookies with a db recording page atctivity until the user
logs in. And, obviously, you could make a user id part of the cookie
so as to track individual user behavior even prior to a login. Just
cuts down on the
I'm in the process of finalizing my blog and working on setting up the RSS
feed:
http://www.andymatthews.net/rss/
I'm getting an error when I try to validate the feed:
http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss/
I've gone through and added cdata nodes where
I've been looking for a good while now, and so far haven't found
anything great...
Is there a good guide out there on styling CFWINDOW? Not the window
contents - the window itself...
Or is there a better way I need to be looking at to start with?
Window(s) in question my contain query
We track backend user activity as well, to see which apps are getting
the most usage, which helps us target priority areas and allows us to
customize user experience.
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
Co-Author of Learning Ext JS
I had issue at one time with my feed. Turned out to be an invalid,
non-display character appearing in the feed. Something from copy and
pasting something into the backend editor. C P from direct from some
code editors might do this...
Steve Cutter Blades
Adobe Certified Professional
Advanced
This was typed straight in. If you look at the second link, it's a
validation attempt at my feed. It dies on apos; which is straight out of
XMLFormat.
andy
-Original Message-
From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com]
Sent: Friday, January 16, 2009 10:54 AM
To:
If you are on CF8, you should probably use the builtin CFFEED instead
of my CFC. Not saying my CFC is broken (it happens), but it may be
simpler. I'll take a look at your feed validation results next. Cutter
definitely has a point too about watching out for 'bad' chars.
On Fri, Jan 16, 2009 at
This was typed straight in. If you look at the second link, it's a
validation attempt at my feed. It dies on apos; which is straight out of
XMLFormat.
It looked like it was dying on the unknown character immediately after
that, actually.
Dave Watts, CTO, Fig Leaf Software
The Ext site (http://www.extjs.com) has additional 'skins' for their
apps listed in the 'Learning Center' area of the site. You'll want to
make sure you look at the items in their 1.1 version area, as that's
what Adobe's using under the hood. It's all stylesheet controlled.
Steve Cutter Blades
Ah yep, that's the issue:
lt;ligt;Whoapos;s the guy who got tboned? What happened to his daughter? .
See the crap after apos?
rss.cfc tries to clean input as much as possible, but it missed this
one. Just edit and remove the bad char.
On Fri, Jan 16, 2009 at 10:32 AM, Andy Matthews
Yep...
I ended up pasting the post in question into EditPlus and saw the problem
immediately. I have no clue where that character came from.
Thanks all. Ray, I'll look into using cffeed, I thought it was only for
reading in feeds, not generating them. Thanks for the pointer.
-Original
Yeah ditto Dave. It's the funky char. I bet its a long dash or somesuch.
On Fri, Jan 16, 2009 at 11:06 AM, Dave Watts dwa...@figleaf.com wrote:
This was typed straight in. If you look at the second link, it's a
validation attempt at my feed. It dies on apos; which is straight out of
XMLFormat.
Sure enough it does, and it was super easy to convert over to cffeed. Thanks
for the tip Ray!
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Friday, January 16, 2009 11:16 AM
To: cf-talk
Subject: RE: Using Ray's RSS.cfc and getting invalid feed
Yep...
I
I am trying to set up a kinda on the fly page for converting video to flash via
coldfusion and ffmpeg.
cfsearch has a cfexacute that converts the video but you have to put the file
name in the code.
http://cfsearching.blogspot.com/2008/01/cfexecute-ffmpeg-and-mencoder-mystery.html
!---
Start at the beginning by doing the upload.
Then write a function that takes the path to the file you wish to convert a
path for the newly converted file to be saved.
Just because the first example has the file name hardcoded, doesn't mean you
can't just replace it with a variable.
Don't
I have a client site that was working great. The machine got a worm and the
CF was reinstalled as CF 8.01. Now the webservice on the site fails with an
error of:
java.lang.ClassNotFoundException: _.redirect.RemotenumbersService
The webservice is:
cfobject type=WebService
Just keep in mind that CFFEED has a few... um... issues. Search my
blog for cffeed and you will see me ranting a bit.
On Fri, Jan 16, 2009 at 11:33 AM, Andy Matthews
li...@commadelimited.com wrote:
Sure enough it does, and it was super easy to convert over to cffeed. Thanks
for the tip Ray!
Of course. All I meant was that my apps are all behind a login and
have a smaller number of users than a public facing web app that could
be spidered would. Demands on sessions and web server resources are
just different for the different types of apps.
Judah
On Fri, Jan 16, 2009 at 8:48 AM,
Error CFUPDATE using formfields parameter. I have a CFM page for sending a
form with 7 input type fields. The action page update a table with 3 columns
by CFUPDATE. CFMX 8.0.1 send me next error:
The NAMEORG fieldname cannot be found in the ait table
The form field NAMEORG is in the FORM,
I have a client site that was working great. The machine got a worm and the
CF was reinstalled as CF 8.01. Now the webservice on the site fails with an
error of:
java.lang.ClassNotFoundException: _.redirect.RemotenumbersService
The webservice is:
cfobject type=WebService
cffile
action=upload
destination = c:\ffmpeg
nameconflict=overwrite
filefield=VideoFile /
cftry !--- using a large file and a short timeout value --- cfset
argString = '/c c:\ffmpeg\ffmpeg.exe -i c:\ffmpeg\#cffile.SERVERFILE# -g
One more CFWINDOW question...
If it possible to specify the coordinates where the window appears in
relation to the link that opened the window, and not the browser upper
left window?
~|
Adobe® ColdFusion® 8 software 8 is the
I cant' seem to find the current recommendation on java version for
CF8. I just installed 8.0.1 and it is using 1.6.0_04 The machine I'm
running it on is 32-bit W2K3 and has 1.6.0_11-b03 installed (from
Sun). Any good reason to point CF8 at the machine-installed version
instead of the one
In general, you want to make sure you are using an Adobe-approved JVM
for that version of CF.
In your case, I would recommend using at least updater 10 due to the
class loader bug fixes. (The updater, is the number immediately after
the underscore)
I personally like install the JVM I am using
To be fair, here is Adobe's list of supported JVM's.
http://www.adobe.com/products/coldfusion/pdfs/cf8_systemsupportmatrix.pdf
Technically, updater 10 isn't on the list, but it wasn't released when
CF8 came out.
I'm not sure if Adobe has made any official addendums to the
interoperability.
I
I personally like install the JVM I am using under my CF install/bin
directory. That's mostly because I don't trust some automatic Windows
or Sun update to jack with it.
You don't have to worry about that. JDK installs are not updated
automatically by anything.
Dave Watts, CTO, Fig Leaf
I have a cfform flash in an application. I want to be able to set the
required=yes on a form field after a user checks the checkbox above it. SO
for
example, if the user checks the I have my keys box, then the keydate form
field becomes required.
I've tried it the same way for the enable
I'm doing this query in Oracle and am encountering the error:
Encountered student_id = OR. Incorrect conditional expression, Expected one of
[like|null|between|in|comparison] condition,
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM
Error CFUPDATE using formfields parameter. I have a CFM page for
sending a form with 7 input type fields. The action page update a
table with 3 columns by CFUPDATE. CFMX 8.0.1 send me next error:
The NAMEORG fieldname cannot be found in the ait table
The form field NAMEORG is in the
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM passport_attendance
WHERE student_id = cfqueryparam
value=#passport_registration.student_id[pr]# cfsqltype=CF_SQL_INTEGER
null=#YesNoFormat(passport_registration.student_id[pr] is '')#
OR people_id = cfqueryparam
Would probably help if you could post some abbreviated code.
Make sure the attribute is set as formfields (note it's plural). If
the attribute is formfield (singular), it will be ignored, and will
attempt to update with whatever it finds in the form collection. Note
that the table's primary key
Wonderful. Thanks
I have a client site that was working great. The machine got a worm
and the
CF was reinstalled as CF 8.01. Now the webservice on the site fails
with an
error of:
java.lang.ClassNotFoundException: _.redirect.RemotenumbersService
The webservice is:
cfobject
Well I just upgraded the JVM on a few of our servers and saw some really
nice speed improvements. Upto 20% in some cases. Win 2k3 32 bit.
Paul Kukiel
http://blog.kukiel.net/2009/01/coldfusion-and-jvm-16011.html
On Fri, Jan 16, 2009 at 2:29 PM, Judah McAuley ju...@wiredotter.com wrote:
I
I have an intranet server named 'report' that serves up an app to a
touchscreen thin client. Every now and then a user on the thin client will
put in the address for the intranet app, but get our public website instead.
I have them restart the thin client and then all is well. I'm assuming this
is
What are the respective URLs?
Are they different domains? Is one just a sub-domain?
~Brad
Original Message
Subject: (OT) - DNS misbehavior?
From: Billy Cox bi...@oldworldspices.com
Date: Fri, January 16, 2009 3:50 pm
To: cf-talk cf-talk@houseoffusion.com
I have an
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM passport_attendance
WHERE student_id = cfqueryparam
value=#passport_registration.student_id[pr]# cfsqltype=CF_SQL_INTEGER
null=#YesNoFormat(passport_registration.student_id[pr] is '')#
OR people_id = cfqueryparam
Yep, just capture the mouse clicks page X, Y:
cfajaximport tags=cfwindow
script
function makeWin(x,y) {
ColdFusion.Window.create('mywin','Windows Rules','win.cfm',{x:x,y:y});
}
/script
h2Content to push stuff down/h2
h2More content to push stuff down the page vertically.../h2
p
This
Oops. Try this:
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM passport_attendance
WHERE
cfif passport_registration.student_id[pr] is
people_id = cfqueryparam value=#passport_registration.people_id[pr]#
cfsqltype=CF_SQL_INTEGER
cfelse
student_id = cfqueryparam
Hi Billy,
Are the two sites pointing to the same IP address or different ones?
The first thing you need to narrow down is whether the problem is a DNS
issue, a web server issue, or a thin client issue. What type of server
software are the two sites on? Are they assigned to specific IP
I have a host(a) record called 'report' that points to an internal IP
address corresponding to the intranet server. Server software is Windows
Server 2003. The web browser on the thin client (Win Xpe) points to
http://report and that occasionally sends them to the public website.
-Original
I have a host(a) record called 'report' that points to an internal IP
address corresponding to the intranet server. Server software is Windows
Server 2003. The web browser on the thin client (Win Xpe) points to
http://report and that occasionally sends them to the public website.
If you only
CFQUERY NAME=passport_attendance dbtype=query
SELECT passport_attendance_id
FROM passport_attendance
WHERE
cfif passport_registration.student_id[pr] is
people_id = cfqueryparam value=#passport_registration.people_id[pr]#
cfsqltype=CF_SQL_INTEGER
cfelse
student_id = cfqueryparam
Basically, I'm looking how to do the below:
In the middle of an existing form, there's a dropdown with 1 to 10 as
possibe values.
How Many guests do you wish to bring?
If I select 5, I then need firstNAME_1, lastNAME_1 through
firstNAME_5, lastNAME_5 input boxes to appear in place
On Sun, Jan 4, 2009 at 11:36 AM, Andy wrote:
Updating my wife's business from Peachtree to QB. Have any of you written a
Web Connector for QB? They use SOAP. Are they examples out there that I
can use to short-cut the development?
I've had a lot of fun compiling the WSDL into a jar and then
I'm trying to have CF write a painfully simple xml file, basically
just a list of sequentially numbered image tags. I keep getting this
error:
The markup in the document following the root element must be well-formed.
Can anyone help?
Thanks,
Les
cfxml variable=GalDoc
?xml version=1.0 ?
cfloop
You don't have a root element in your XML document. The output will
be something like this:
?xml version=1.0 ?
img ... /
img ... /
img ... /
XML documents can only have a single top-level tag, so you'll need to
wrap your img tags with a container of some sort.
cheers,
barneyb
On Fri, Jan 16,
it should have a root element.
cfxml variable=GalDoc
xmldoc
?xml version=1.0 ?
cfloop index=LC from=1 to=20
cfoutput
img src=../160_#z#.jpg width=540 height=360 /
cfset z=z+1
/cfoutput
/cfloop
/xmldoc
/cfxml
you really dont use it but this is how you write.
On Fri, Jan 16, 2009 at 7:28 PM,
You can do this all with JavaScript, it works really slick. I just did this a
few weeks ago and wrote a blog post about
it:http://www.stillnetstudios.com/2009/01/05/dynamically-adding-and-removing-form-elements/
Or you can go the route you are heading, where you ask for how many, then
submit
72 matches
Mail list logo