Re: Inline html editor

2000-03-29 Thread Judah McAuley
At 03:19 PM 3/29/00 -0500, you wrote: Are you saying you got cfa_htmleditor to work in netscape? No, I'm saying that I was told that it worked. I didn't do anything, I sat and watched the people demonstrating do things. I was also saying that, with creative use of javascript to tweak the

Re: Studio RDS Problems

2000-04-12 Thread Judah McAuley
I'm also working with Jeff, and I wanted to add that when RDS goes down, you cannot stop and start the service. It doesn't respond to any control signals, even if both CF server and CF Exec are shutdown. The only thing the brings RDS back up is a full reboot of the server. Judah At 01:37

Re: Query Caching

2000-04-13 Thread Judah McAuley
At 11:23 AM 4/13/00 -0400, you wrote: Yes. You can save the query to SESSION scope. cfif NOT IsDefined("SESSION.QueryName") cflock name="#SESSION.SessionID#" timeout="30" cfquery name="SESSION.QueryName" datasource="#dsn#" SQL STUFF

Re: simple createODBCdate question

2000-04-19 Thread Judah McAuley
Here is the code: CFSET NewDate=CreateODBCDate(#dateformat(Now(),"mm/dd/yy")#) Should be cfset NewDate = #CreateODBCDate(Now())# Pound signs always go on the outside, any text not escaped (inside single or double quotes) insides the pound signs are interpreted as variables. And creating a

RE: What's the use of structures, anyway?

2000-04-20 Thread Judah McAuley
At 02:24 PM 4/20/2000 -0500, you wrote: Alright, I think it's beer:30 again. We're getting cranky. Myself included. Yeah, I agree. Even though it's only 1 something in my time zone. Good thing I work only 2 block from a fantastic pub... Judah

RE: MSIE 4.01

2000-05-03 Thread Judah McAuley
At 10:55 AM 5/3/2000 -0700, chris wrote: Leave it to Microsoft to make it so the escaped HTML entities are essentially reserved words. Pretty pathetic. To be completely fair, the W3C specs for HTML say that if you are going to use in the url, you are supposed to use the character entity. If

Caching: Browser vs. Proxy

2000-05-03 Thread Judah McAuley
iginating server has requested no caching Can anyone tell me what the difference between these two are and if they would effect browser and proxy caching differently? I looked through the http 1.1 spec and could get a really solid grasp on caching and proxy vs. browser implementations. T

Re: Webtrends CommerceTrends

2000-05-08 Thread Judah McAuley
I can't tell you about CommerceTrends, but I used Webtrends for awhile and was not terribly impressed. The biggest problem was that a combination of Webtrends, IIS, and CF reliably crashed CF once every couple days (or more often). Since uninstalling Webtrends, my CF stability has increased

Re: Processor Question

2000-05-11 Thread Judah McAuley
At 08:40 AM 5/11/2000 -0700, you wrote: We spec our CF boxes (NT/2000) at 2 PIIIs (not Xeon), mirrored disks and 512 MB. We generally buy the fastest processors available, lately 733s and, as tempting as those little IBMs may be, we currently favor Dell 2450s. We've got much the same setup,

RE: Processor Question

2000-05-11 Thread Judah McAuley
At 12:42 PM 5/11/2000 -0400, you wrote: Well with database more RAM is always better. Though on the list it has been posted many times that if you're going to get a multiprocessor do 2 computers with 2 processors instead of one 4 processor. Not only do you get clustering, but the performance

RE: Slightly OT: Lighten things up a little

2000-05-15 Thread Judah McAuley
At 01:14 PM 5/15/2000 -0400, you wrote: I completely agree with you. The main thing I got out of my comp sci degree was the ability to think more logically. And, boy, do I know how to sort (bubble, merge, radix, quicksort)! Woo Hoo!! Let the fun begin! Stephanie Cunningham Web System

Re: SPECTRA: Embed an object within itself...

2000-05-17 Thread Judah McAuley
We don't use Spectra at the moment (wish I had a spare $15,000 laying around...), but I can tell you the way that we tackled that problem. We defined a table of option types (color, size, fabric, etc) and a table of option values with foreign keys to the option types (color, red; color,

Re: Cold Fusion Search tools

2000-05-17 Thread Judah McAuley
At 11:13 AM 5/17/2000 -0700, you wrote: Now, if you need to perform a search on the db in real time, Verity's not the answer. Easy enough, however, to "almost" query in real time: everytime you update/insert to the db, you re-run your collection page (of course, that can be a bit excessive

Re: Web Cameras and CF

2000-05-29 Thread Judah McAuley
I had to set up a system like this for a client. Basically, the process needs to work by attaching the web cam to a video board (like the Winnov) and having software that snags a jpg from the video feed every 20 minutes. Generally speaking, as long as the video board supports Video for

Re: I want my #$# on the first of the month.

2000-06-01 Thread Judah McAuley
Not very elegant, but here it is... cfset new_date = #CreateODBCDate(Evaluate(Month(Now())+1)'/1/'Year(Now()))# Currently outputs: {d '2000-06-01'} Good luck. Judah At 04:32 PM 5/31/00 -0400, Timothy C. Hill wrote: I have been on a 23 hour coding spree to finish up a project. How do you

RE: Question: Where Is Cold Fusion 404 Page?

2000-06-17 Thread Judah McAuley
At 05:51 PM 6/17/2000 -0400, you wrote: We're in the midst of a minor disagreement about the location of the default 404 error message delivered by CF (_not_ the web server default; we started abusing that one long ago). I'm pretty sure that it's being spat directly out of the application

Re: FW: Search Engine Friendly URLS: One More Time

2000-06-20 Thread Judah McAuley
If you are implementing form2urlattributes, it doesn't like pages in sub-folders. It has a few built-in assumptions (if I recall correctly), two of which are that the page being called is index.cfm and the second being that it is at the top level of the web directory (i.e.,

Re: Oracle vs SQL server

2000-06-21 Thread Judah McAuley
At 01:18 PM 6/21/2000 +0200, you wrote: Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? Just to be contrary, I'd put my vote in for Sybase. Great

RE: OT: IIS sharing on IP address

2000-06-21 Thread Judah McAuley
At 01:27 PM 6/21/2000 -0400, Zac wrote: Hope that's helpful. Do be careful using host headers, tho. They're far less reliable than using separate IPs. I'd consider them accessable for internal stuff or for personal sites, but I would NEVER rely on them for a publicly accessable site that

Re: My experience with Sybase

2000-06-22 Thread Judah McAuley
At 10:04 AM 6/22/2000 -0700, Karl Simanonok wrote: My experience with Sybase has been that the company is incompetent about technical matters regarding their own products, nonresponsive to support issues and even to potential buyers, and their database is a dinosaur that performs poorly

Re: MySQL on UNIX w/ CF on NT4

2000-06-29 Thread Judah McAuley
At 04:55 PM 6/29/2000 -0400, you wrote: Hello, We are about to start a fairly large project using mysql on Unix as our DB. I hear there is no transaction support, you can't do 'sub selects' (Is that the same thing as a sub-query?), and that it is in some way 'single threaded' and/or unsuitable

Re: Last post: How do I Optimize Win 2000 (IIS) for Warp speed with C old

2000-07-07 Thread Judah McAuley
At 04:47 PM 7/6/2000 -0400, you wrote: On Win2000, be forewarned that you'll experience about a 17-20% performance degradation over NT 4.0. This is with the ZDLabs ServerBench 4.1 CPU suite of tests in our labs. Any ideas why? I've been pondering moving some servers to W2K as I've like W2K

RE: Testing Assignment

2000-07-10 Thread Judah McAuley
Looks good, although I have one thought to throw in... At 05:47 PM 7/10/00 -0400, you wrote: sniped !--- Can convert multiple IP's using large dim arrays?? *shrug* --- CFLOOP LIST="#ipAddress1#" DELIMITERS="." INDEX="i" CFSET ipAddress1Arr[loopCnt] = i CFSET loopCnt = loopCnt

Re: Urgent

2000-07-11 Thread Judah McAuley
At 11:00 AM 7/12/2000 +1000, you wrote: Hai, can i get information how to display alphabetical order from a query cfquery SELECT id, blah, moreblah FROM sometable ORDER BY blah /cfquery Assuming that blah is some sort of character field, this will sort it alphabetically. Options

Re: OT: mail transfer agents

2000-07-14 Thread Judah McAuley
At 04:27 PM 7/14/2000 -0700, you wrote: Watch out when using cfmail on solaris (and more than likely linux as well) when sending via a qmail SMTP server. I recently found that the messages wouldn't go out because of bare linefeeds. CF would return the messages to the coldfusion/mail/undelivr

unable to run executables

2000-07-21 Thread Judah McAuley
We recently purchased Macromedia Generator 2 and have been attempting to use cfx_generate in order to use the offline generation features. The problem is, that when we run cfx_generate, nothing noticable happens. It doesn't generate an error, doesn't log anything when cfx_generates logging

Re: Parsing URLs on IIS 4

2000-07-25 Thread Judah McAuley
At 11:18 AM 7/25/2000 +, you wrote: Late last week, the server began coughing on the slash-delimited query strings. It appears that the server believes the slashes indicate folders, and it gives 404 errors whenever a slash-delimited URL query string is accessed. You have to tell IIS to

RE: cookies: where does CF store them?

2000-07-28 Thread Judah McAuley
At 02:32 PM 7/28/2000 -0700, you wrote: However, that brings me to my next question - what is user.dmp? Isn't that a user-sensitive file? In other words, am I sure that CF is writing to that file? or is it possible that some service crashed and the machine wrote to that file everything that

Re: How to handle the transition period to a new host?

2007-06-05 Thread Judah McAuley
First thing I do is ratchet down the TTL (time to live) on the dns records. As I recall, the default TTL for an A record is 48 hours. When I'm going to move hosts, I'll bring it down to usually an hour or two. It means that you'll get more traffic to your dns servers, checking the address, but

Re: Execute a batch file with CFEXECUTE

2007-06-20 Thread Judah McAuley
I haven't done exactly what you are attempting to do, but we move files over to our db server for bulk insert using cffile and UNC paths. So you would use a cffile call with the action move and the destination \\{db ip}\{share}\ The big gotcha (and possibly what's wrong with your current

Re: CF Editor

2007-06-26 Thread Judah McAuley
Wil Genovese wrote: snip This is the sort of thing I posted about earlier. Eclipse/CFEclipse has chosen to not follow defined usability and accessibility keyboard shortcuts. For you (Eclipse community) to just shrug it off as well that's just their defaults is wrong. For the Eclipse

reading page dimensions with activepdf

2007-06-27 Thread Judah McAuley
We are currently using ActivePDF Toolkit version 4 for a small pdf-related need. The function currently reads in an existing pdf, adds some text to it, then writes it out to a new file. I need to make a slight change to the process and for it to work, I need to be able to get the page height

Re: Time Question

2007-07-02 Thread Judah McAuley
Well, since its hockey, you know that there are 20 minutes in a period, so any numbers greater than 20 (ie 36) are going to be seconds (00:36) but two digit numbers 20 or less are going to be an area that needs more definition. Is 18 supposed to be 18:00 or 00:18? I think that needs to get

Re: FTPS

2007-07-03 Thread Judah McAuley
FTPS is not the same thing as SFTP. FTPS is ftp over SSL. It typically runs on port 990. SFTP is ftp running over SSH. It typically runs on port 22. I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP in the

Re: FTPS

2007-07-03 Thread Judah McAuley
Dan G. Switzer, II wrote: I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP in the server product. Actually, FileZilla Server only support FTPS on the server. :) This is the problem with having FTPS and

Re: CF8 Pricing

2007-07-26 Thread Judah McAuley
Dale Fraser wrote: Ok, I'm officially sick of waiting, someone please give me the inside Goss on CF8 pricing, I'm dying here. $2.15 Anyone know where that number comes from, for a cookie? :) Judah ~| Get the

Re: Generate Random Number 1000 - No Duplicates

2007-07-26 Thread Judah McAuley
Claude Schneegans wrote: this was a quiz question on cf weekly Then, if it was a quiz question, the quiz is dummy, because true random number with no duplicates cannot exist ;-) That's not true. You can have true random numbers without duplicates. Each successive iteration of the

Re: Complex query for experts?

2007-08-22 Thread Judah McAuley
I'm pretty sure that you want count(products.id) not sum. If the product id is 100 then sum(product.id) is going to be 100 even though there is only one record. But Rick knows that, he just needs to fire his typist ;-) Judah Rick Root wrote: That should be: having sum(products.id)

Re: CFMBB and Locking

2007-08-22 Thread Judah McAuley
It is a potential race condition, but that doesn't automatically mean that a lock is needed. The data being updated is a list of forums and threads. It may be the case that it doesn't need to accurate to the millisecond. If I create a new thread and someone has a page view at the exact time I

paper forms to pdf forms

2007-08-23 Thread Judah McAuley
A project I am working on has the opportunity to leverage some of the new integration between CF 8 and PDF, particularly creating and filling out forms. However, a number of customers on this project are going to have existing forms that need to be imported into the system, preferably in as

Re: Difficulty with forms and dynamically named variables

2007-08-30 Thread Judah McAuley
Chris Martin wrote: When you do the database update, you'll have to run the select query again and then use... cfoutput query=jss cfset theSubCat = #Evaluate(form. SUBCAT)# /cfoutput Evaluate is almost never, ever needed. SUBCAT is a dynamic key in the struct FORM. Happily, Coldfusion

Re: SQL - dupicate table

2007-08-31 Thread Judah McAuley
INSERT INTO tbl2 (col1, col2, etc) SELECT col1, col2, etc FROM tbl1 Should copy everything from tbl1 to tbl2. This presumes that tbl2 is empty. Cheers, Judah daniel kessler wrote: I have a table and I'd like to duplicate all of it's data to another table. I've set the second table to have

Re: List of Coldfusion Bloggers

2007-09-07 Thread Judah McAuley
Raymond Camden wrote: And in case you can't find it on the site, you can see a visual list here: http://www.coldfusionbloggers.org/feeds.cfm and an OPML feed here: http://www.coldfusionbloggers.org/opml.cfm I can also get you the list spelled out on a cake. But that may take longer.

Re: [CF-Dev] Adobe Max 2007

2007-09-12 Thread Judah McAuley
I'm working for a new boss that happens to have family in Edinburgh and its looking promising so far that I may be able to use this fact as leverage to get him to send me to Scotch 2008. Now I just have to finish this project so we have the money... Judah Sean Corfield wrote: On 9/12/07, Tom

Re: NOT 0 = quot;noquot;?!?! and NOT 1 = quot;yesquot;?!?!

2007-09-27 Thread Judah McAuley
It should be noted that CF treats Yes and 1 and True (boolean value, not the string) as logical equivalents. So !0 might return Yes when output to the screen but that is the same thing to CF as 1 when it comes to boolean logic. Take the result and format for display as you wish using Int, Val,

Re: Apache config

2007-01-20 Thread Judah McAuley
Dave Watts wrote: snip Well, if you're using CF, you don't need to do that at the web server level at all: http://www.doughughes.net/index.cfm/page-blogLink/entryId-37 You'll notice that this is an SES URL, on an IIS 6 server, that points to a simple description of how to set up SES URLs

Re: Apache config

2007-01-20 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: Granted, while it is a cleaner URL it is in no way friendly, it's an ugly hack. An ugly hack? How so? A URL (or more properly a URI) is meant to provide a descriptive and permanent location for a piece of content. The url I provided does exactly that. One of

Re: Apache config

2007-01-20 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: Well, your URL is simple a rewrite of index.cfm?foo=foo, it is not a permanent location for this document in that if I bookmark this page and you delete foo, I will be 100% guaranteed to get it again. This is simple a facade onto the normal query string

Re: Apache config

2007-01-22 Thread Judah McAuley
Dave Watts wrote: You'll notice that this is an SES URL, on an IIS 6 server ... I would argue that in fact that's not a search engine friendly url at all. That url gives me no context for what I'm going to find on the page if I follow the link. Note the acronym: SES. Not SEF. The last S

Re: Apache config

2007-01-22 Thread Judah McAuley
Dave Watts wrote: If you say that URLs are more properly called URIs, that's not semantic hair-splitting, it's an error, in the same way that it would be an error to tell someone they shouldn't say car or truck or bicycle, but should instead say vehicle. When you use the term URL, you are

Re: Apache config

2007-01-22 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: I always thought URLs were different than URIs W3C work on Addressing schemes: http://www.w3.org/Addressing And in particular, URIs, URLs, and URNs: Clarifications and Recommendations: http://www.w3.org/TR/uri-clarification/ Judah

Re: Apache config

2007-01-22 Thread Judah McAuley
Dave Watts wrote: Now, a reasonable reading of any of that doesn't lead me to the conclusion that if I say URL, you'd be right to correct me by saying, no, URI. And that's essentially what you did in your original response. You said that URLs are more properly called URIs. You didn't provide

Re: Inserting current date into a data table

2007-01-23 Thread Judah McAuley
Dates aren't supposed to be in quotes. Remove the single quotes and that should work. If its a column, like date_created, that should always have the time it was created, then I'd just add the value to the default on that column in the database. For mssql, you can set the default to getdate()

Re: Inserting current date into a data table

2007-01-23 Thread Judah McAuley
Richard Cooper wrote: Also, you didn't use the cfqueryparam tag Like this: '#session.lname#', cfqueryparam value=#createodbcdatetime(now())# cfsqltype=cf_sql_date /) There's no need to use cfqueryparam (as far as I know) in this situation because its not user supplied data. Now() is a

Re: Inserting current date into a data table

2007-01-23 Thread Judah McAuley
Charlie Griefer wrote: don't forget that preventing SQL injection attacks is only one benefit of cfqueryparam. creating bind variables to increase performance is another :) Fair enough, although I believe that this is true only if the query is used in a loop. In this particular instance,

Re: Getting the sum of all rows for one column

2007-01-26 Thread Judah McAuley
One method to do this is use the ValueList function, which returns a list of all the values in a query column, then convert the list to an array and use the ArraySum function. expense_total = ArraySum(ListToArray(ValueList(getexpenses.expensevalue))); Judah Steve Good wrote: I'm back with

RDS not working in Eclipse was: Re: CFEclipse / Eclipse question

2007-01-27 Thread Judah McAuley
I just installed Eclipse 3.2.1, CFEclipse 1.3 and I downloaded the most recent version of the Flex Builder trial (2.0.1). I ran the extraction for the trial and but didn't run the installer. I did get the ColdFusion Extensions folder with the CF_FB_Extensions.zip file in it. Eclipse seemed

Re: RDS not working in Eclipse was: Re: CFEclipse / Eclipse question

2007-01-29 Thread Judah McAuley
Dwayne Cole wrote: When configuring the RDS connection did you get the connection successs message? I had a similar problem but on Friday I finally upgraded to 3.2 Eclipse/ 1.3 CFEcplise and set the connection port to 80 (localhost), it all worked just fine and I really like the results

Re: RDS not working in Eclipse was: Re: CFEclipse / Eclipse question

2007-01-29 Thread Judah McAuley
Thanks Jeff, I'll try going back to 3.2 and see how that goes, then report back here. Judah Jeff Fleitz wrote: I upgraded my Eclipse build to 3.2.1 about a month ago (with the CFEclipse 1.3 beta build) when the Flex Builder 2.01 update came out, and my RDS stopped working. It would display

Re: RDS not working in Eclipse was: Re: CFEclipse / Eclipse question

2007-01-30 Thread Judah McAuley
RobG wrote: Found it! And best of all, IT WORKS!! Amazing! Thank you! Finally, functional RDS on Eclipse 3.2.1. Rob Hmm..still doesn't work for me. Perhaps I need to try this on a machine with no other versions of Eclipse installed. But so long as I install to a new folder and have it

Re: Dynamic variable syntax question

2007-01-31 Thread Judah McAuley
Evaluate is almost never needed. Best CF programming practice discourages its use. Try this: cfloop from=1 to=8 index=i pValue #i# = #MyField[value i _a]#/p /cfloop Judah Scott Weikert wrote: I think you need: cfloop from=1 to=8 index=i pValue #i# =

Re: Take a minute to Digg this story about the Smith Project

2007-02-05 Thread Judah McAuley
I would expect an open source version of CF to implement a strong subset of the CF that most developers use on a daily basis and to implement it with excellent performance. I suspect that open sourcing the core of CF would make it so that you had a stable, lower footprint server that would run

Re: jQuery??

2007-02-07 Thread Judah McAuley
For those of you that are interested in jQuery, I might suggest that you take a look at DomQuery by Jack Slocum. http://www.jackslocum.com/blog/2007/01/11/domquery-css-selector-basic-xpath-implementation-with-benchmarks/ I like DomQuery better than jQuery and its 2 to 3 times faster than

Re: jQuery??

2007-02-07 Thread Judah McAuley
Rey Bango wrote: Hi Judah. This is a bad comparison. DomQuery is a DOM/CSS selector which can be used as an extension to YUI. A true comparison would be DomQuery to jQuery's DOM methods, Dojo's dojo.query() or Dean Edward's cssQuery. Yes, DomQuery is the DOM/CSS selector portion of the

Re: jQuery??

2007-02-07 Thread Judah McAuley
Dan G. Switzer, II wrote: The size of jQuery is also considerably smaller than loading the DomQuery library w/its dependencies. So, if you're working on a large application where you're going be heavily relying on lots of DOM manipulation the size of the library may not be that big of a

Re: jQuery??

2007-02-07 Thread Judah McAuley
You should check out the library again if you haven't recently. Jack has removed most (I believe now all, but I'm not 100% certain) of the dependencies on YUI. Its really more of its own library now. If you click on the Download link on the yui-ext site, you can build your own set of scripts

Re: jQuery??

2007-02-07 Thread Judah McAuley
That's great to hear Rey. I think it will be a good resource for all involved. I'm really excited to see all the progress that the various ajax libraries have made. If you asked me two years ago that we would be at this point with Javascript and XMLHttpRequest, I would have laughed. Ajax does

Re: jQuery??

2007-02-07 Thread Judah McAuley
I love the comment system too. I was reading the most recent blog posting the other day and looking at the comments when I found this one: Jezza: Quite apart from the rest of this goodness, this commenting system makes me moist Honestly, as a developer, I cannot think of a higher compliment :)

Re: Change Log on database updates - need some ideas

2007-02-20 Thread Judah McAuley
Dave Watts wrote: I shouldn't complain too much, as they don't care how much it costs and pay quickly - but, is there a more efficient way of doing this? triggers. AJAX. Field-based editing with a simple log. =] I'm sorry, but that, by itself, is a very silly answer. AJAX is display

Re: Change Log on database updates - need some ideas

2007-02-21 Thread Judah McAuley
Just so my previous email doesn't get drowned out in a debate over ajax, if I were tackling this problem, I would have a hidden form field on each page that lists the fields that have been changed. Attach an onChange handler to each form field that the sys managers can change. Have it call a

Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism

2007-02-27 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: Indeed and a Google for sites using it is just as good... Google allinurl:.cfm Note though that that won't catch sites, like mine, that use url rewriting and don't have a .cfm anywhere in the address. Netcraft is throwing some errors for me, but perhaps

Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism

2007-02-27 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: You are just using URL rewriting, you still have .cfm in the address? It's just obfuscated by / etc? No, I use uris such as http://www.somesite.com/articles/decor/how-to-use-drapes-to-good-effect/ No file extension anywhere. The rewriter takes the incomming

Re: Fizzbuzz. Simple programming problems.

2007-02-27 Thread Judah McAuley
I would do it almost exactly the same way that you did it, except that I read the requirements differently. You are outputting fizzbuzz, buzz and fizz instead of i. I don't see anything in the spec that says instead of, so I presume that its in addition to. I would print out the number on

Re: Fizzbuzz. Simple programming problems.

2007-02-27 Thread Judah McAuley
Good call. Just goes to show that I shouldn't interpret specs at the end of the day :) Judah Paul Vernon wrote: snip I don't see anything in the spec that says instead of snip It's on line three below... Here's the specific one he mentioned: Write a program that prints the numbers

cftransaction and roll your own transactions

2007-02-28 Thread Judah McAuley
We're investigating performance issues in a db app that is throwing lock contention errors. One of the things we are looking into is using the UPDLOCK optimizer hint (this is for SQL Server 2000). However, we have a situation where a number of queries are run inside a cftransaction tag. We

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Judah McAuley
For what its worth, we have a couple of sites for a company that sells porn dvds. They are really well done, high end content management systems with a very sophisticated e-commerce setup, affiliate system, search engine optimization, etc. The fact that they are selling porn dvds is

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Judah McAuley
a potentially like the one that Judah McAuley wrote in his recent post. Cheers, Chris ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion

Re: GotCFM.com - Need Opinion on Whether to Approve a Site

2007-03-05 Thread Judah McAuley
Rick Faircloth wrote: I would have to respond that due to the sensitivity of corporations to their image, that most would immediately instruct their IT departments to change their technology usage rather than be associate with *any* industry which would negatively affect their image.

Re: Can't my SQL right on this

2007-03-06 Thread Judah McAuley
I think you might need some parentheses to group your search fields correctly. I've also rewritten the query to use the more explict join syntax, hope you don't mind, but try this: SELECT tblMusicProducts.musicprodID , tblMusicProducts.musicprodname , tblMusicProducts.musicprodprice

Re: OT ISAPI Rewrite

2007-04-02 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: AFAIK the example and the latter are the same URL and will be treated as such. I can understand the others, I don't agree with them, which I why you should publish pages out like that straight off the bat, with no URL rewriting required. For what its worth

Re: XML Vs. CSV/Text

2007-04-13 Thread Judah McAuley
You don't mention what db you are using but I've had good success on MS SqlServer writing to a csv file and then doing all the processing to the database entirely in SQL using the BULK INSERT INTO command. If you're able to go that route with whatever db you are using, I'd opt for csv (or tab

Re: Client-side validation or Server-side Validation?

2007-04-16 Thread Judah McAuley
Rick you might be right in some audiences but I think you may be wrong in many other audiences. Larger corporations, for instance, do much more extensive security filtering. They can block javascript/activeX/etc at the firewall and they can also enforce browser settings at the desktop level.

Re: Client-side validation or Server-side Validation?

2007-04-16 Thread Judah McAuley
Rick Faircloth wrote: snip It's like coding for users of the Opera browser. If they want to be able to have the best experience on my sites, then install IE. It's just too much work to cater to every minority group in the virtual universe. And this is where I fundamentally disagree. Its

Re: A very unusual HTTP 500 Null Error

2007-04-26 Thread Judah McAuley
T Lux wrote: No, the error happens before any code is run. Tracking down the issue with IEHTTPHeaders as well as Etheral running on the server itself, it seems that for some reason CF was not receiving the packets either in the right order or malformed or ... most likely something in the

Re: Session Security

2007-05-14 Thread Judah McAuley
Is there a good run down somewhere of the pros/cons of cfid/cftoken versus J2EE session management? I'm realizing that this is an area I really ought to brush up on. Thanks, Judah Dave Watts wrote: Thanks for that information guys, I'll go into the admin and switch it over to J2EE session

Re: Multidimensional Array Vs. Array of Structs

2007-05-23 Thread Judah McAuley
I pretty much always use an array of structs for this sort of situation. I like the descriptive name of the key names in the struct (user.name, user.lastseen, user.event) and I like the ease of the array functions for looping over, appending and counting. That way I can just loop from 1 to

Re: CF8 on existing JRun

2007-05-31 Thread Judah McAuley
Robertson-Ravo, Neil (RX) wrote: Has it? I thought JRun didn't support 1..5? Page 18 of the What's New in CF 8 guide (http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf) says Scorpio supports JDK 1.6 as the runtime environment. By default, Scorpio installs and

Re: I need some help figuring this out...

2008-09-05 Thread Judah McAuley
Mark is right about the fax really being an image (most likely a TIFF). I've had to do some rather ugly things like this before and what I did was use ImageMagick to convert the pdf to a tiff, place the second image atop it in the correct spot, then merge the layers and save it out as a another

Re: Why won't this query run in MySQL 5?

2008-09-08 Thread Judah McAuley
I'd also suggest rewriting the query to use ANSI SQL-92 syntax to be more explicit and likely have it be more portable across db engines and versions. cfquery name=get_client datasource=#dsn# select c.*, fg.*, e.* fromclients c inner join family_groups fg on

Re: How NOT to Evaluate (moved from cfset so not to confuse topic)

2008-09-10 Thread Judah McAuley
Untested but should work: cfquery name=getPhysicianRecords datasource=#DSN# SELECT * FROM Contacts WHERE Contacts.ContactType = 'Physician' cfif Len(form.field) AND StructKeyExists(form,form.field) AND Contacts.#FORM.Field# = '#Trim(form[form.field])#' cfelse 1 = 0 /cfelse ORDER BY

Re: How NOT to Evaluate (moved from cfset so not to confuse topic)

2008-09-10 Thread Judah McAuley
Ah, sorry, didn't explain fully. I did a StructKeyExists and a Len to make sure that the field you are going to evaluate really exists in the form. If it doesn't, you don't want your cfquery to throw a gnarly error (most likely) so if the assertion is false, the WHERE clause becomes WHERE 1 = 0

Re: using dynamic variable in cfset statement

2008-09-10 Thread Judah McAuley
I just consider Evaluate to be sloppy coding. It is (almost) never needed as it basically tells coldfusion to do something it already is doing: look at this and see if its a variable. It is by no means the worst thing in the world but to the extent that you can cut it out of your code, I think

Re: REACTOR adn SQL injection

2008-09-13 Thread Judah McAuley
That's a nice list Isaac, but I'm curious about two things. 1) what is the sort versus order by. I'm quite familiar with the order by clause but I've never heard of a sort clause. Perhaps you mean something else? 2) You say to not put ANY user-supplied variables into the content property of a

Re: SQL Help

2008-09-16 Thread Judah McAuley
Are the other fields in your table the same when the email is the same? Meaning, are the records really duplicate? Or is it just the email that is duplicate and the other fields may have varying values for two rows that have the same email? If they do vary, do you care which of the duplicate rows

Re: JRun issues on Vista 64 bit?

2008-09-17 Thread Judah McAuley
As a test case, can you create a datasource with the built in DB (Derby)? It would probably help to figure out if the issue is with datasources in general or with mssql 2005 in particular. Judah On Wed, Sep 17, 2008 at 1:26 PM, Jeff Chastain [EMAIL PROTECTED] wrote: And as a follow on, a

Re: JRun issues on Vista 64 bit?

2008-09-17 Thread Judah McAuley
, Jeff Chastain [EMAIL PROTECTED] wrote: Judah, Creating a data source to Derby works just fine. I can verify the existing data sources as well as create a new one. The issue only appears when I am trying to connect to SQL 2005. Thanks -- Jeff -Original Message- From: Judah

mssql 2008 dev tools

2008-09-17 Thread Judah McAuley
To take this to a new thread... Does anyone know how to write sql that will return the results in an editable grid? If I do a right click on a table I can choose to edit top 200 rows and it returns the results in an editable grid and then I can open up the sql pane above and rewrite the sql and

Re: JRun issues on Vista 64 bit?

2008-09-17 Thread Judah McAuley
Short of reinstalling CF (which seems like a good idea at this point) I'd suggest perhaps looking at your JRE version and reinstalling/upgrading the JRE version and see if that fixes the obviously borked jdbc driver for mssql. If you really want to get to the bottom of this and figure out the

Re: How do I extract session.id value

2008-09-19 Thread Judah McAuley
jsessionid only exists if you are using J2EE session variables instead of traditional coldfusion session variables (cfid and cftoken). So you have either cfid/cftoken or you have jsessionid, depending on which type of session variables you decide to use. To set which type you use, you go into the

Re: Sessions and more info

2008-09-20 Thread Judah McAuley
If this is for an internal application, then I'd suggest creating your own SSL certs which you can do for free. Your users will get a warning about a untrusted certificate the first time around, but you can explain to them that they need to trust it permanently adn then the error will not recur

  1   2   3   4   5   >