Re: Help with MySQL Query

2007-10-20 Thread Jon Clausen
Peter, The reason it's not working is not because of the alias, but because you are trying to use the alias in the SELECT clause. MySQL only allows you to reference aliases in the GROUP BY, ORDER BY, or HAVING clauses. (http://dev.mysql.com/doc/refman/5.0/en/problems-with- alias.html)

Re: error with long form post

2007-10-25 Thread Jon Clausen
Is your form action set to GET (or not defined) instead of set to POST? If you're getting a URL too long error it sounds like your form data/text is being passed in the URL string. Jon On Oct 25, 2007, at 11:00 AM, William Seiter wrote: I get a error that says url too long. this appears

Re: weird message on logs (CF8)

2007-10-25 Thread Jon Clausen
These error messages are being generated when Coldfusion writes the client data to the Windows Registry - a setting which is adjusted in the Client Variables section of the CF Administrator. It could be a permissions issue with Coldfusion writing to the Registry. I did a search for this

Re: Problem with login in the Application.cfc (saving additional info in the session scope)

2007-10-25 Thread Jon Clausen
Placing the following in the onSessionEnd method should solve the problem: cfif getAuthUser() NEQ cflogout/ /cfif Option B is to persist some cookie data which will re-login the user when the session ends. As a side note, you can also use the cflogin name to create a list. The you can

Re: Query of Queries causing server to hang

2007-10-29 Thread Jon Clausen
Graham, I haven't seen this exact error before, but do you perchance have a cflock around the QoQ code? Query of queries are very expensive on the server and grow more so as the record set being manipulated increases. Many times, the same functions performed in QoQ can be performed by

Re: fixing a piece of code

2007-10-30 Thread Jon Clausen
That's a common problem for men who spend too much time on their computer. :-) Seriously, though, The missing variable means you have failed to define it earlier in the template or didn't return it properly if you are using a CFC to take care of your business logic. From your previous

Re: Cached Web Pages

2007-10-31 Thread Jon Clausen
Steve, The likely reason is that you have the Trusted Cache option checked in your CF Admin caching settings. If you continue leave that setting on, you can press the Clear Template Cache button in the CF Admin and the cached version of your page will disappear. HTH, Jon On Oct 31,

Re: Cached Web Pages

2007-10-31 Thread Jon Clausen
. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] http://www.esu.edu -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 11:07 AM To: CF-Talk Subject: Re: Cached Web Pages Steve, The likely reason is that you have the Trusted

Re: Wierd regex problem (isn't it always)

2007-11-07 Thread Jon Clausen
Andy, I'm not a regex ninja, like some, but I think what you're looking for is this. Escape the space character (using ^) so that any backreferences stop at the space character. cfset reg = @([a-zA-Z0-9][^ ]+) / Then you can use the first backreference: cfset usernamePos = reReplace(str,

Using reReplace Backreference as StructKey or Argument

2007-11-14 Thread Jon Clausen
I'm sure it's something simple that I'm missing, but I want to use a regex backreference as the struct key (i.e. - struct[key]) or as an argument (i.e. - function(argument) ) but I've failed in all my attempts so far. For now I've written the code out using a loop with reFind(),

Re: Using reReplace Backreference as StructKey or Argument

2007-11-15 Thread Jon Clausen
-REMatchGroups-ColdFusion-User-Defined- Function.htm Or- http://bennadel.com/index.cfm?dax=blog:1040.view .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Jon

Re: Using reReplace Backreference as StructKey or Argument

2007-11-15 Thread Jon Clausen
to used functions, variables, etc. in the string, but it executes them *before* the regex runs. So, in your first code sample, it's trying to find the literal key \1 in appSettings, and then passing the result as the replace value. --Ben Doom Jon Clausen wrote: I'm sure it's

Re: blocking spambots

2007-11-15 Thread Jon Clausen
For a quick and dirty fix, Mike, you might try something like this on one of your inputs: script type=text/javascript language=javascript function makeHuman(input,element){ if(!document.getElementById(ishuman)){ var formText = element.innerHTML; var ivalue = input.value; var iid =

Re: Using reReplace Backreference as StructKey or Argument

2007-11-16 Thread Jon Clausen
Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 8:17 PM To: CF-Talk Subject: Re: Using reReplace Backreference

Re: query help

2007-12-09 Thread Jon Clausen
Looks like CEIL() or CEILING() is the function you're looking for: http://db.apache.org/derby/docs/10.2/ref/refderby.pdf HTH, Jon On Dec 8, 2007, at 11:18 PM, Dave l wrote: if i change the select statement to: SELECTcenter_id, address1, city, state, postalcode, state,

Re: form problem

2007-12-09 Thread Jon Clausen
Richard, I appears that you're using JQuery so some of your questions might be more appropriate on the forums over there, but a couple of things: You need to pass the pound symbol in with your field so that JQuery knows to specifically to look for an HTML element with that id attribute:

Re: form problem

2007-12-09 Thread Jon Clausen
=columnIDsArray; :) Jon On Dec 9, 2007, at 4:04 PM, Jon Clausen wrote: Richard, I appears that you're using JQuery so some of your questions might be more appropriate on the forums over there, but a couple of things: You need to pass the pound symbol in with your field so that JQuery knows

Re: FCKEditor / CF8 Issues

2007-12-11 Thread Jon Clausen
Todd, For clarification, are you creating the FCKEditor instance using cfmodule on the fckeditor.cfm (downloaded from the FCKEditor site) or are you using pure javascript to create the editor instance? If using cfmodule, you should have params being passed that look something like this:

Re: Clarification about FCKEditor Use on websites...

2007-12-11 Thread Jon Clausen
Not at all Rick. Unless you plan to do major modifications to the source and wish to keep those modifications to yourself, you can use the free version. Since you're running on CF8 now, you could just use cftextarea richtext=true rather than mess with a separate installation. HTH, Jon On

Re: Clarification about FCKEditor Use on websites...

2007-12-11 Thread Jon Clausen
Ah, good point, Michael. Thanks for the clarification. Jon On Dec 11, 2007, at 1:45 PM, Michael MacDonald wrote: Just a point of clarification Jon, if you use the FCKEditor under the LGPL license you can freely modify the code to your hearts content. Its only if you wish to distribute

Re: Reading NMEA-183 Messages off Com Port w CF?

2007-12-17 Thread Jon Clausen
Matthew, I would suggest using something like GPS Babel ( http://www.gpsbabel.org/ ). It's very easy to use in conjunction with CFEXECUTE it supports real-time tracking. It's available for Win/Linux/OS X. The benefit is the data can then be manipulated into a variety of formats to

Re: Best way to do this...

2007-12-20 Thread Jon Clausen
Lori, Here's my thoughts on your problem: 1) Have the static elements of the tickets and ID's printed professionally by a printer on blanks - it will be much cheaper than paying for ink outright. It will also take less time to print. Maybe a perforated blank with the ticket on once

Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting in Crash

2006-09-19 Thread Jon Clausen
Ken, I had the same problem with almost exactly the same setup. Since I didn't know it was a known issue, I installed Fusion Reactor to see if I could diagnose the problem after looking through the IIS and Coldfusion logs with no result. While I was in the Fusion Reactor admin, I enabled

Re: Validation is being ignored

2006-09-20 Thread Jon Clausen
Are /CFIDE/scripts/cfform.js and /CFIDE/scripts/masks.js available from the root of the site? If the CFIDE virtual directory is missing and those two scripts are 404'ing, that's usually a common cause. If the form fields are critical, you should consider adding some server-side validation

Re: CFForm inside HTML form

2006-09-20 Thread Jon Clausen
Jake, I'm not sure I understand. Why can't you contain all of your data you want submitted inside your cfform? You can use the cfform and still use HTML form elements inside without having to convert them to cfinput,cfselect, etc. Unless you want to write a bunch of javascript to create

Re: CFInput text and onclick functionality

2006-09-20 Thread Jon Clausen
Scott, As Dave said, if you're using a Flash/Flex form you will need to use Actionscript to control any form elements. The .swf file which is generated to create the form cannot be accessed through the javascript DOM. For what you want to do, you can just include the AS function in the

Re: CFinput submit Action page

2006-09-21 Thread Jon Clausen
Richard, Here's an example of a form using the same page to post data using only Coldfusion to give the user feedback that the form has been submitted: !--- Call our component which handles database updates--- cfset mycomponent = createObject(component,components.component)/ !--- If we're

Re: CFinput submit Action page

2006-09-21 Thread Jon Clausen
Bobby, This is kind of expanding the scope of the initial question, but using http.request_method can cause other problems down the road - especially when pages have multiple forms, or multiple submits (i.e. - an Update and Delete submits). Better always to use the

Re: URL Parameter

2006-09-22 Thread Jon Clausen
I know you're looking for a CF solution to this and it may be that a dynamic 404 template may be the right solution in your case. You won't be able to get any stats out of the site, however, as your logs will be all 404's unless you use cfhttp in the 404 template to deliver the content

RE: URL Parameter

2006-09-22 Thread Jon Clausen
Ben, That is a cool method! I guess that was too much of a blanket statment for me to say the logging would be all messed up. Google Analytics would definitely a good way to go with the CF only method. I use Smarter Stats on my server and it removes all of the 404's from the stats when

Re: SSL Certificate Changed, CFHTTP broken

2006-09-25 Thread Jon Clausen
Having two certs on the server sounds like it could be the CF issue. On the length of the public key, though, depending on the type of application, you may have other problems with a cert that is shorter than 1024. For example, if the site is doing any type of e- commerce, using a public

Re: credit cards

2006-09-25 Thread Jon Clausen
Richard, I highly advise against storing credit card information in your database, if you can help it.It's a liabiltiy issue for you and/ or your client. If you're using a payment processor, they can handle that for you once you're transmitted the card data. Both Verisign and

Re: credit cards

2006-09-25 Thread Jon Clausen
Oops. Didn't see Alan's response before I sent mine. In that case: Ditto. :-) - Jon On Sep 25, 2006, at 12:49 PM, Alan Rother wrote: Ideally you should use an online Credit Card Processor such as Authorize.net, in this case you do not need to store or send the CC details to

Re: Javascript vs. cfscript

2006-09-25 Thread Jon Clausen
the only way i can make it actually display an alert within javascript is if i do the following code: alert(cfoutput#student.name#/cfoutput); if i do the following it doesnt work: alert(#student.name#); am i doing something wrong Not at all. You can't use a string in Javascript

Re: dreamweaver CF application Var for images/ root web folder

2006-09-26 Thread Jon Clausen
Paul, It's been awhile since I've used DW and I don't have it on my machine anymore, but in the Application panel there is a way your can specify site-specific variables for data display and preview.I think it's the Server Behaviors tab. HTH Jon On Sep 26, 2006, at 12:58 PM, Paul

Re: credit cards

2006-09-26 Thread Jon Clausen
using PGP, GNUPG, or another alternative would be an even more secure way to go if you have full access to the server. Jon On Sep 26, 2006, at 10:39 AM, Matt Robertson wrote: On 9/25/06, Jon Clausen wrote: cfscript key1 = myUniversalKey; key2 = customerSpecificKey; theKey = hash(key1 key2

Re: Cfdocument question

2006-09-26 Thread Jon Clausen
If all of your CSS and images are embedded, I would suggest taking a look at the client viewers. Since this is happening on client computers and not on the server (if I'm understanding correctly), I would suspect an Acrobat issue on the client side. Are they all using the latest version

Re: how can query input to DB 4 times in 1 second

2006-09-27 Thread Jon Clausen
Gerald, It looks to me like a SPAM bot. Many times they will send multiple POST requests at once to gather vailid emails or attempt to use your forms to spam others. If that is the case it may be that your checkEmail isn't working because the add to Email query hasn't run. Have you

Re: how can query input to DB 4 times in 1 second

2006-09-27 Thread Jon Clausen
I would suggest wrapping from the before the beginning of the e-mail check query to the end of the insert query. You simply want to lock that block from being executed by another user. Then your cfmail transaction, which may take a bit longer, isn't under lock if you have concurrent

Re: access photoshop metadata via CF - XMP

2006-09-28 Thread Jon Clausen
For general EXIF metadata, Drew Noakes' Java library is the best I've seen at delivering consistent data from all makes/mfrs of cameras (http://www.drewnoakes.com/code/exif/). You will need access to the server to install the library, though. I haven't really tested it with Photoshop XMP

Re: Webservice hell

2006-09-28 Thread Jon Clausen
Mark, This is just a shot in the dark, but you have a wildcard application mapping configured for the site containing the webservice? I've run into something similar with Flash Remoting accessing a cfc service. Something to do with the way that IIS implements the local security

RDS CFC Explorer and Application.cfc

2006-10-04 Thread Jon Clausen
As soon as I implemented the onRequest() method in Application.cfc, RDS stopped CFC redirects to the CFC Explorer and simply treats outputs a blank page. Does anyone know of a way to I might be able to bypass the onRequest method when calling a CFC directly? I know I can dump the object

Re: RDS CFC Explorer and Application.cfc

2006-10-04 Thread Jon Clausen
Thanks, Dave. Since I need access to variables in the application scope in my model and controllers, that's not an option. I think I'm just going to forego using that method anyway, since I found a few other instances in which the way it intercepts page requests makes my life harder

Re: What's Your Favorite Add-On or Extension

2006-10-06 Thread Jon Clausen
I'd have to say Subeclipse - by a delta. A distant second is XMLBuddy - I use it for XHTML validation too. I'm won't count CFEclipse since that is my IDE and where I pretty much spend my day :-). -Jon On Oct 6, 2006, at 9:39 AM, [EMAIL PROTECTED] wrote: All, I thought it would be

Re: cfdocument underline in Linux

2006-10-06 Thread Jon Clausen
Brad, I saw you got the bug fix in another reply. I'm not sure there is a fix for the tags themselves, but have you tried using CSS styles in place of the tags? I have a client that runs almost exclusively on SUSE boxes and the cfdocument work I've done has all been CSS-based. I've had

Re: CF - Javascript Monitor Resolution help

2006-10-08 Thread Jon Clausen
Just a suggestion, but since Flash is vector based and scales exceptionally well, why don't you just use the javascript to change the height/width in your object tag, or pass it as a script var if you're using FlashObject(http://blog.deconcept.com/flashobject/). That would seem to be a bit

Re: cfblog.com

2006-10-10 Thread Jon Clausen
Sorry about that, Phil. We added domain aliasing a couple of days ago for blogs(http://cfblog.com/cfblog/index.cfm/id/ A_Place_of_Your_Own) and something in our automated job that handles the DNS updates locked up Apache after running fine for several days. It's all up and running again.

Re: cfblog.com

2006-10-10 Thread Jon Clausen
Loathe, What problem are you having. I just checked login functions and it's working fine. Please feel free to mail me off-list. -Jon On Oct 10, 2006, at 4:09 PM, loathe wrote: Still won't let me log in :( -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED]

Re: Using CFHTTP, loading bar?

2006-10-11 Thread Jon Clausen
Andy, I hope you don't mind me butting into the conversation, but I just caught this thread and took a look at your page. Just a suggestion, but there is an easier way to accomplish this using JSMX and it doesn't require the hiding of the div. JSMX is a lightweight solution for stuff

Re: Money no Object - Best Online Editor for dealing with cut'n paste from Word

2006-10-12 Thread Jon Clausen
I'm a big fan of Asbru's Web Content Editor (http:// editor.asbrusoft.com/page.php/id=702) . A big bonus is that it is the only full-featured WYSIWYG editor that supports Safari. It's not lightweight, but it's very nice on the features set. It also has quite a few features for

Re: Money no Object - Best Online Editor for dealing with cut'n paste from Word

2006-10-12 Thread Jon Clausen
. :-( Asbru releases patches for Safari updates within 24-48 hours of the release so that helps. - Jon On Oct 12, 2006, at 11:58 AM, John Cox wrote: TinyMCE: http://tinymce.moxiecode.com/ I believe it cleans word files, and supports safari as well. On 10/12/06, Jon Clausen [EMAIL PROTECTED] wrote

Re: Distinguishable Markers in CF OO Methodologies

2006-10-12 Thread Jon Clausen
D, Design Patterns: The Elements of Reusable Object-Oriented Software is probably the first word in all OO methodologies. Here's a pretty good list that's more directly applicable to Coldfusion: http://www.remotesynthesis.com/blog/index.cfm/2006/7/18/Objects-and-

Re: mySql connector J

2006-10-12 Thread Jon Clausen
Your config is correct and is the same as mine. Did you restart CF after installing the MySQL driver? I assume it's already been installed in the WEB-INF/lib/ directory. Jon On Oct 12, 2006, at 8:04 PM, Doug Brown wrote: Can someone tell me what they have listed in CF for the mySql

Re: mySql connector J

2006-10-12 Thread Jon Clausen
Oh, one other note. Some of the newer connector J drivers are known not to work with CF. The 3.1 drivers are compatible. The one I'm running is: mysql-connector-java-3.1.10-bin.jar Jon On Oct 12, 2006, at 8:13 PM, Jon Clausen wrote: Your config is correct and is the same as mine. Did

Re: Serving Japanese text on IIS/CFMX

2006-10-13 Thread Jon Clausen
Is the text coming from the database or is it in the template (or both)? If it's the database, you may need to adjust the Charset of the database. How you do that depends on the DBMS type. If it's in the template, there may a problem with the server settings - possibly the languages

Re:Homesite Problem

2006-10-16 Thread Jon Clausen
Have you tried changing FTP mode from passive to active or vice versa? This has happend to me on Linux servers from time to time where a configuration in the FTP params only allowed connections in active mode. Another thing to check for is whether you have a preceeding / in your intial

RE: Homesite Problem

2006-10-16 Thread Jon Clausen
(Crystaltech, etc.). -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Monday, October 16, 2006 11:13 AM To: CF-Talk Subject: Re:Homesite Problem Have you tried changing FTP mode from passive to active or vice versa? This has happend to me on Linux servers from

Re: Announce: RIAForge

2006-10-18 Thread Jon Clausen
Trully awesome stuff, once again, Ray! I am so not worthy :-) Suggestion: I'm sure you're already on this, but are you going to incorporate some sort of tags or subcategories method for keeping projects organized and easy to find within their group? My biggest beef with many open

Re: Strange URL pointing to CFM page

2006-10-18 Thread Jon Clausen
It's pointing to a directory and would resolve to /coupons/index.cfm? subscriberemail=yadayada - assuming index.cfm is your default index page. Jon On Oct 18, 2006, at 10:00 AM, [EMAIL PROTECTED] wrote: All, I've never seen this type of hyperlink before. It resolves to a cfm page.

Re: Mac OSX, Coldfusion 7, Intel Chips, OH MY!!!

2006-10-18 Thread Jon Clausen
Yeah, it's pretty much a PIA to get going, but once you set it up and get it integrated with Apache, it's a very nice development environment. I used this reference and it made my life much easier: http:// webmages.com/cfmxIntelOSXguide.html If you want to run your development environment on

Re: Recommendations for a mail server...

2006-10-19 Thread Jon Clausen
I second SmarterMail if you're running Windows. On Oct 19, 2006, at 2:27 PM, Coldfusion wrote: SmarterMail www.smartertools.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date

Re: Recommendations for a mail server...

2006-10-19 Thread Jon Clausen
(still :o) Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 19, 2006 2:49 PM To: CF-Talk Subject: Re: Recommendations for a mail server... I second SmarterMail if you're running Windows

Re: Recommendations for a mail server...

2006-10-19 Thread Jon Clausen
- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 19, 2006 2:49 PM To: CF-Talk Subject: Re: Recommendations for a mail server... I second SmarterMail if you're running Windows. On Oct 19, 2006, at 2:27 PM, Coldfusion wrote: SmarterMail www.smartertools.com

Re: Recommendations for a mail server...

2006-10-19 Thread Jon Clausen
could use CFPOP and by-pass SMTP Auth... /CFOUTPUT /LOOKING Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 19, 2006 4:16 PM To: CF-Talk Subject: Re: Recommendations for a mail server... Rick, Not at all. The from in CFMAIL can

Invoking CFIDE.adminapi.base components

2006-10-25 Thread Jon Clausen
I'm trying to create a Coldfusion datasource on the fly using the RDSInvoker method in the CFIDE.adminapi.base component. Here's what I've got for the creation code: cfscript dbname = thenewdsn; dsnArgs.name = dbname; dsnArgs.url = application.jdbcURL dbname; dsnArgs.class =

Re: Invoking CFIDE.adminapi.base components

2006-10-25 Thread Jon Clausen
(myCFAdminPassword); //Create the Datasource createObject(component,cfide.adminapi.datasource).setOther (dsnName,dsnURL,dbdriver,PostgresDriver,dbowner,dbownerpass); /cfscript - Jon On Oct 25, 2006, at 2:46 PM, Jon Clausen wrote: I'm trying to create a Coldfusion datasource on the fly using the RDSInvoker

Re: OT: authorize.net

2006-10-25 Thread Jon Clausen
I'm on Payflow Pro as a Gateway with Moneris/Vital as a Processor, but they validate everything, every time, including the CCV code. I think you need to take this issue further, though. It sounds like it's an issue with your Processor, not the Gateway. If Authorize.net is passing the exp

Re: OT: authorize.net

2006-10-26 Thread Jon Clausen
You're right! I just ran a test with one of my own cards and a bogus exp date and it went through. I used to use a bogus expiration date to check the processor on live sites, but I haven't needed to for awhile. That stinks. Good thing I pay for the fraud protection, I guess... -Jon On

Re: images not respecting clear in cfdocument PDF

2006-10-26 Thread Jon Clausen
Zoe, I'm looking at your source code for the page that the PDF is based on along with the PDF and, this is just a guess, but I think the PDF image styling may be choking on the designated list (dl/dl) elements in your XHTML. At least that seems to coincide with the clearing issues. The

Re: Constructing multi-user/multi-site applications...

2006-10-26 Thread Jon Clausen
Rick, I do, but I'm not sure it's what you want to hear - sorry. Before retiring and doing my own thing a couple of years ago, I spent the previous 13 years with a Fortune 100 company on the Operations end of the business. When I started with them, they weren't even in the Fortune

Re: Converting from SQL to mySql

2006-10-28 Thread Jon Clausen
Doug, I just migrated most of my databases from MSSQL to MySQL 5 a few weeks ago.The Intelligent Converter Toolkit ( http://www.convert- in.com/sqlkit.htm ) was a lifesaver and made it pretty painless overall. It did a great job of converting the datatypes over and transferring the

Re: I know it sounds crazy ...

2006-10-30 Thread Jon Clausen
I'm kind of confused to as to the end game of what D's trying to accomplish exactly, but I think Ben's code is on the right track. Probably better to use a cfhttp tag during the Post process to get the job done, though and then use the response to determine the page action. cfif

OT: Paymentech Documentation

2006-10-30 Thread Jon Clausen
Would anyone, by chance, have a copy of the Paymentech Orbital Gateway API documentation they could e-mail me off-list? I have a client who is waiting to finalize their account through Chase and it seems that Paymentech only makes their API specs available to the account holders directly

Re: Managing more than one site and growing

2006-11-03 Thread Jon Clausen
I'll add another vote for FarCry. IMHO, the biggest part of the learning curve with FarCry is coming to terms with the unique and sometimes non-standard vocabulary that Daemon came up with when they created it. Once you start figuring out all of the naming conventions, it's like making

Re: Extensions

2006-11-11 Thread Jon Clausen
Jason, You can post directly to a function from within a CFC if you specify 'access=remote' in the function tag (then set your form to post to mycfc.cfc?method=postMyData), but for many reasons, in most cases, it's better to call the function from within your .cfm. Something like this:

Re: Advice about query caching

2006-11-12 Thread Jon Clausen
Paul, I think your method would certainly work, however my experience with e-commerce has been that the full recordset of products is almost never used. By using QoQ against your full recordset, you do limit yourself in some of the functions like true full-text searching that the

Re: cffile question

2006-11-12 Thread Jon Clausen
On Nov 12, 2006, at 11:57 AM, Bob Imperial wrote: 1.)In outputting my datetime here, how would I go about adding the AM/PM designation for output? cfset myDate = now() cffile action=write file=#BaseDir#\index.cfm output=Website directories were created successfully on

Re: I need some help

2006-11-13 Thread Jon Clausen
Peter, One thing I can think of: If you can find a way to get into the admin check to see that the Timeout requests after.. is checked in the Settings. I once accidentally unchecked that box and had something similar happen to me . If you can't get into the Admin after restarting CF,

Re: I need some help

2006-11-13 Thread Jon Clausen
Glad I could help. 60 seconds is fine, though depending on the sites that run on the server and whether they deal with uploads and post- processing of user data, you can probably go with 30. If you have scheduled tasks or long-running queries in your code, you can always increase the

Re: I need some help

2006-11-13 Thread Jon Clausen
Peter, On Nov 13, 2006, at 12:09 PM, PETER SHEATS wrote: Well I got the new site up for awhile (we're using CommonSpot from Paperthin) and it was ok for awhile but then started slowing down after awhile. So I took it back down. - Just a thought: Check your server logs for a Spam Bot

Re: Lyla Captcha, height and width

2006-11-13 Thread Jon Clausen
Lines 58 and 59 of captcha.xml. You can pass arguments manually, though it's fewer lines of code just to duplicate and pass an alternate config file when you create the object - that is if you want the captcha to appear differently than what's in your config file: i.e. - cfset captcha =

Re: Best CF7 Hosting company

2006-11-14 Thread Jon Clausen
Check out Enterhost as well : http://enterhost.com They don't offer managed hosting in the sense that you have to take care of your own server patches and hotfixes, but they have good support when you need it and have a solid infrastructure. I've been very pleased with them. My only beef

Re: Image BLOB Trouble

2006-11-14 Thread Jon Clausen
Kevin, Try this: cfsilent cfquery name=q datasource=webdb Your query here... /cfquery /cfsilent cfheader name=Content-Disposition value=inline cfcontent type=image/jpg variable=#q.image_data# reset=false / In CF7, you can stream directly from the database. Jon On Nov 14, 2006, at 11:52 AM,

Re: Image BLOB Trouble

2006-11-14 Thread Jon Clausen
Kevin, You may need to convert the image data to Binary in order to stream it if the field is being returned as a string. Check the value of the data you're getting back: cfdump var=#isBinary(q.image_data)# cfabort If it dumps false, use toBinary() to convert the string data. I'm sorry,

IE7, cflogin, and JSMX

2006-11-14 Thread Jon Clausen
I've found a weird bug that I'm stuck on. The problem does not occur with any other browser (FF,IE6, Safari, Opera). When IE7 hits a page where JSMX is used to generate any content, CF logs out the user, I receive an Operation aborted message, and the page redirects to the IE7 connection

Re: IE7, cflogin, and JSMX

2006-11-14 Thread Jon Clausen
Internet Explorer (not!), -Jon On Nov 14, 2006, at 2:18 PM, Jon Clausen wrote: I've found a weird bug that I'm stuck on. The problem does not occur with any other browser (FF,IE6, Safari, Opera). When IE7 hits a page where JSMX is used to generate any content, CF logs out the user, I receive

Re: CF admin api security..

2006-11-14 Thread Jon Clausen
You'll need to have sandbox security on but this should work once you do (Otherwise you'll get a sandbox not found error): cfscript //Set our sandbox directory sandbox = expandPath(/); //Instantiate the Admin API createObject(component,cfide.adminapi.administrator).login

Re: CF admin api security..

2006-11-14 Thread Jon Clausen
On Nov 14, 2006, at 6:23 PM, Jon Clausen wrote: You'll need to have sandbox security on but this should work once you do (Otherwise you'll get a sandbox not found error): cfscript //Set our sandbox directory sandbox = expandPath(/); //Instantiate the Admin API createObject(component

Re: Mixing CF and JavaScript.

2006-11-14 Thread Jon Clausen
To cake or not to bake, that is the question... Whether 'tis nobler in the kitchen to suffer the slings and arrows of outrageous icing or to bear arms against a sea of debugging - and by opposing, to make a sandwich... - Will Bakespeare -Jon*needs to eat some dinner* On Nov 14, 2006,

Re: Image BLOB Trouble

2006-11-15 Thread Jon Clausen
Kevin, Glad to hear you got it up and running! Best regards, Jon On Nov 15, 2006, at 10:23 AM, Kevin Cundick wrote: Jon, I thought I should mention to you that it turns out that the problem I was having was related to the image not being stored properly in the database. I had our

Re: CFC (Object) Composition Question.

2006-11-15 Thread Jon Clausen
Ian, You can simplify your code, IMHO by using inheritance between your CFC objects.For example, here's how one might apply an MVC structure and inheritance to your CFC's: Controller: Table DECK Array of Players addPlayer() removePlayer() deal() Player: (extends controller.Table) HAND

Re: CFC (Object) Composition Question.

2006-11-15 Thread Jon Clausen
Ian, I see what you're saying. The way I see the object model for the application, I'm thinking more of what is an extension of what. Table Has Players, Player Has Hand, Deck Has Card, etc. In the case of the card game, using specificity as an inheritance qualifier means that it would

Re: CF 7.02 on an Intel Mac?

2006-11-16 Thread Jon Clausen
Unfortunately, his server seems to be down right now, but Mark Andrachek has a great how-two on how to get this going: http://webmages.com/cfmxIntelOSXguide.html Here's Google's cache of it: http://72.14.203.104/search?q=cache:sy7BOWImDEgJ:webmages.com/ cfmxIntelOSXguide.html

Re: ColdFusion blogging software?

2006-11-16 Thread Jon Clausen
Ryan, I'm a bit biased, but you may want to check out CFBlog.com. It's currently running on the final beta of the Blogfusion 5 codebase, but it has quite a few of the features you requested below and it's free for CF Developers. Plus you can point your own domain name at your blog, if

Re: Same Datasource over 2 IP addresses (CF-5)

2006-11-16 Thread Jon Clausen
Are the IP addresses pointing to the same server or different boxes? Same server: No problem. Different boxes: Upgrade to MSSQL and share the database between the two - You could do it as long as the other server was within the network, but it would be a pain. Jon On Nov 16, 2006, at

Re: Apache Jrun connector / Intel Mac?

2006-11-17 Thread Jon Clausen
I'm still running Apache 1.3 on my Macbook Pro, but here's a technote about the connector for Apache 2: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8001e97 I remembered seeing something about it from this blog post:

Re: Shared Hosting Mappings

2006-11-17 Thread Jon Clausen
One suggestion: Your problem is going to be common with about any Shared CF Hosting environment - especially with MG:U since it requires three mappings.You might ask the host provider if they can move your account files to another server. I used to use Intermedia.net and ran into a

Re: OT: Employee Satisfaction

2006-11-21 Thread Jon Clausen
In a former life I was a Gallup-certified facilitator for their Q12 program for my company: http://gmj.gallup.com/content/default.aspx?ci=811 Marcus Buckingham's book First Break All The Rules is an excellent book on helping to understand how to fully engage (and appropriately

Re: OT: Employee Satisfaction

2006-11-22 Thread Jon Clausen
, Jon Clausen [EMAIL PROTECTED] wrote: In a former life I was a Gallup-certified facilitator for their Q12 program for my company: http://gmj.gallup.com/content/default.aspx?ci=811 Marcus Buckingham's book First Break All The Rules is an excellent book on helping to understand how to fully

Re: cferror on application.cfm not working (?)

2006-11-22 Thread Jon Clausen
Michael, A template error is thrown before anything else. You'll need to handle those through your missing template handler - which you can set in the CFAdmin. Jon On Nov 22, 2006, at 3:58 PM, Michael E. Carluen wrote: On testing it however (by using a .cfm file name that does not

  1   2   3   4   >