Re: CFScript help

2011-08-22 Thread morgan l
If you're displaying this in a browser, then HTML is likely the culprit, condensing multiple spaces into just one. Use non-breaking spaces (or wrap your output in pre tags) to get HTML to output multiple spaces. On Mon, Aug 22, 2011 at 11:19 AM, Josh Cesana joshuaces...@yahoo.comwrote: I'm

Re: CFFILE / CFCATCH

2011-06-30 Thread morgan l
Looks like you're the victim of scenario #2 in this KB article: http://kb2.adobe.com/cps/181/tn_18171.html On Thu, Jun 30, 2011 at 6:57 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Thanks Michael, I looked for the dump first. The only problem is the session variable not

Re: cfinput type=datefield won't follow my CSS rules

2011-06-01 Thread morgan l
The datefield type is applying floats to the elements it creates, 'removing' them from their containers. I don't have an example of a fix, but that bit of info will hopefully point you at a solution. ~| Order the Adobe

Re: cfhttp response with non-english characters gets cut off

2011-05-20 Thread morgan l
I agree that the encoding is the likely culprit, but we're calling a 3rd party service and can't control what they're sending us. Their response to our inquiry was that they are sending utf-8 encoded responses. Outside of calling this 3rd party service, I've been unable to duplicate the problem,

Re: cfhttp response with non-english characters gets cut off

2011-05-19 Thread morgan l
, 2011 at 1:01 PM, Paul Hastings p...@sustainablegis.comwrote: On 5/18/2011 10:35 PM, morgan l wrote: characters, Greek letters etc). As far as I can tell, all the characters are valid utf-8, but the cfhttp call fails with Connection Failure in the how do you know that these are valid UTF-8

Re: cfhttp response with non-english characters gets cut off

2011-05-19 Thread morgan l
Andrei, one of my coworkers had much the same thought. The headers are reporting utf-8, and I've created a test document containing an omega character I've saved as plain text utf-8 encoded and it still truncates. I believe this may still be the actual problem, but I'm not seeing a solution. Our

cfhttp response with non-english characters gets cut off

2011-05-18 Thread morgan l
I'm running into a strange issue here. CF8: (8,0,1,195765) JVM: 1.6.0_16 Windows Server 2003 We're implementing a resume parsing service, posting the resumes to the service using cfhttp. All was going well until we ran across a handfull of our test resumes, all with non-English special

Re: cfhttp response with non-english characters gets cut off

2011-05-18 Thread morgan l
Out of the box, no, I wasn't setting a different encoding, but as a course of trying to find a solution, I did try multiples. Nothing seemed to affect the situation, so I went back to the defaults. I also did play with the getasbinary, but I didn't try 'never'; I actually tried 'yes', thinking I

Re: cfhttp response with non-english characters gets cut off

2011-05-18 Thread morgan l
: Morgan: Have you tried using cfprocessingdirective pageEncoding=utf-8 / to the page with your CFHTTP call? -Dan On Wed, May 18, 2011 at 11:35 AM, morgan l greyk...@gmail.com wrote: I'm running into a strange issue here. CF8: (8,0,1,195765) JVM: 1.6.0_16 Windows Server 2003

Re: Converting regular date to a Spectra formatted database date?

2011-03-24 Thread morgan l
cfset readableDate = '03/24/2011 08:58:48 AM' cfdump var=#NumberFormat(readableDAte,.00)# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: why is cf_builder so slow? (was: expensive)

2011-01-26 Thread morgan l
I've lobbied for years to get a setup like that here, but it's a no-go. Either way, CFBuilder in both the beta and 1st release version was dog slow randomly. Not all the time, not always on the same template even, just randomly jrun would peg the cpu to 100%. CFEclipse doesn't cause that problem

Re: why is cf_builder so slow? (was: expensive)

2011-01-26 Thread morgan l
Not offhand; we haven't messed with it around here since the 1st release version. On Wed, Jan 26, 2011 at 1:56 PM, Adrocknaphobia adrocknapho...@gmail.comwrote: Morgan, Do you have any bug numbers I can look into? -Adam On Wed, Jan 26, 2011 at 2:39 PM, morgan l greyk...@gmail.com wrote

Re: Is this expected behaviour for a table in a cfc passed back?

2010-12-08 Thread morgan l
Are you doing a 'view source' in the browser, or 'inspect element' in Firebug? Firebug will report the HTML as what you posted as your results. It's reporting the HTML as what Firefox rendered; the fieldset will either need to include the entire table, or be entirely inside a td/td to render

Re: cfselect and autosuggest

2010-11-17 Thread morgan l
I'm pretty sure cfselect doesn't have a built-in autosuggest. On Wed, Nov 17, 2010 at 10:08 AM, Azadi Saryev azadi.sar...@gmail.comwrote: On 17/11/2010 22:13 , fun and learning wrote: without using javascript or javascript libraries without *using* js - no. wihtout *writing any js

Re: Problem with undefined js variable set via cf...

2010-11-17 Thread morgan l
Won't that just make it null instead of undefined when the url: line of the included .js file runs? Not that I have a better answer. On Wed, Nov 17, 2010 at 2:20 PM, Michael Grant mgr...@modus.bz wrote: Define your var outside of the function. script type=text/javascript var

Re: Problem with undefined js variable set via cf...

2010-11-17 Thread morgan l
I guess not. Still strikes me as odd, but if it works, that's great. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Problem with undefined js variable set via cf...

2010-11-17 Thread morgan l
, 2010 at 2:33 PM, Michael Grant mgr...@modus.bz wrote: No, because you are defining it outside of the function, making it global. Then setting it to cfActiveWebrootDirectory when the DOM reports it's in a ready state. On Wed, Nov 17, 2010 at 3:30 PM, morgan l greyk...@gmail.com wrote

Re: Dynamically resizing a cfwindow?

2010-10-18 Thread morgan l
Where does this js code reside? Are you trying to do this inline in the cfwindow's source code, or calling it as a function? Are you getting any js errors (use Firebug in Firefox to get good js error information)? I use the resizeTo() method, and the code you provided looks like it should work

Re: Trying to set cfform focus in an Ajax window

2010-10-01 Thread morgan l
Abbot and Costello. On Fri, Oct 1, 2010 at 9:10 AM, Michael Grant mgr...@modus.bz wrote: like this a Laurel and Hardy skit. Who's on first? Precisely! ~| Order the Adobe Coldfusion Anthology now!

Re: Trying to set cfform focus in an Ajax window

2010-09-29 Thread morgan l
File this under slick code: it works! I just hope I remember this when the situation arises again. On Tue, Sep 28, 2010 at 7:25 AM, Michael Grant mgr...@modus.bz wrote: AjaxOnLoad cannot pass in any parameters to the function specified. Wondering out loud here and currently no way to

Re: Trying to set cfform focus in an Ajax window

2010-09-27 Thread morgan l
AjaxOnLoad is probably the way to go. Set up your .focus() line inside a function: init = function(){ document.LoginForm.AccessID.focus(); } and add : cfset AjaxOnLoad('init') to the page where you now have the document.LoginForm.AccessID.focus(); line . AjaxOnLoad cannot pass in any

Re: CFTEXTAREA onClick

2010-07-20 Thread morgan l
If you examine the source created by instantiating the fck editor, you'll see that it's not just a CSS height on a textarea anymore. You'll find that you're inside an iframe. If this line from Den's example works: ColdFusion.RichText.getEditorObject('your_textarea_id'); then you would do

Re: CFTEXTAREA onClick

2010-07-20 Thread morgan l
The new docs don't seem as complete as the old ones, but the developer seems to have done a good job purging the olds ones. Hopefully you can at least find what you need over there. On Tue, Jul 20, 2010 at 4:02 PM, Bryan Stevenson br...@electricedgesystems.com wrote: re-read one of

Re: CFTEXTAREA onClick

2010-07-19 Thread morgan l
TinyMCE has event handlers you can setup to fire onfocus, etc. I was pretty sure the stand-alone fck editor did, as well, but I can't find the docs on it. On Mon, Jul 19, 2010 at 4:24 PM, Bryan Stevenson br...@electricedgesystems.com wrote: On Mon, 2010-07-19 at 17:09 -0400, Michael Grant

Re: Problem with ColdFusion.Window.destroy

2010-07-16 Thread morgan l
Many of the built-in CF stuff requires your javascript function declarations to be in the form of: destroyWin = function(){ //stuff } Not sure if that's the case here, but worth a shot. On Fri, Jul 16, 2010 at 2:15 PM, Peter Terhorst nouveau.gl...@gmail.comwrote: I'm opening a modal window

Re: Problem with ColdFusion.Window.destroy

2010-07-16 Thread morgan l
Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com morgan l wrote: Many of the built-in CF stuff requires your javascript function declarations to be in the form

Re: Cfwindow

2010-06-22 Thread morgan l
Check out the code here: http://www.coldfusionguy.com/ColdFusion/blog/index.cfm/2007/12/20/JavaScript-to-Identify-Current-CFWindows http://www.coldfusionguy.com/ColdFusion/blog/index.cfm/2007/12/20/JavaScript-to-Identify-Current-CFWindowsIt doesn't close them, but it's simple enough to remove

Re: Select List: in edit mode, multiple selections - Stumped!

2010-05-11 Thread morgan l
This is like outputting url_sizes.attributeId outside a cfoutput tag, it only gets the first item. You need to set the attributeId column into a list: cfset myAttribList = ValueList(url_sizes.attributeId) On Tue, May 11, 2010 at 12:04 PM, Dan Sullivan coldfusiondevelope...@gmail.com wrote:

Re: CF9 Local scope issues

2010-04-29 Thread morgan l
Use array notation: cfif isDefined(local[Filter_#LoopCount#]) On Thu, Apr 29, 2010 at 2:08 PM, Dan Crouch stario...@yahoo.com wrote: cfif isDefined(local.Filter_#LoopCount#) ~| Want to reach the ColdFusion community with

Re: What's wrong with this QoQ?

2010-04-29 Thread morgan l
It appears section is a reserved word. Your WHERE clause should work if you use: WHERE [section] = #i# On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote: cfloop from=1 to=3 index=i cfquery name=section dbtype=query SELECT * FROM questions WHERE section = #i# /cfquery

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-04-15 Thread morgan l
Same problem here, also on Win 7 64 bit. Went back to CFEclipse less than 2 weeks after CFBuilder was officially released with no fix to this or the page jumping while editing long lines problem. On Thu, Apr 15, 2010 at 10:03 AM, Brandon brandonregis...@gmail.com wrote: I am also having the

Re: what is wrong with this code

2010-04-15 Thread morgan l
I think this'll work: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\fileName\)'Link1/a; On Thu, Apr 15, 2010 at 3:58 PM, fun and learning funandlrnn...@gmail.comwrote: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ( + fileName + )'Link1/a;

Re: what is wrong with this code

2010-04-15 Thread morgan l
Oops, put the +'s back in: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at 4:07 PM, fun and learning funandlrnn...@gmail.comwrote: I think this'll work: callURL = a href='##' onClick='javascript:return

Re: what is wrong with this code

2010-04-15 Thread morgan l
My brain is fried, it's late. I needed to escape the quotes, then terminate the string, then insert the variables, then restart the string, then escape the closing quotes: callURL = a href='##' onClick='javascript:return parent.frames[1].XYZ(\ + fileName + \)'Link1/a; On Thu, Apr 15, 2010 at

Re: Anyone else have the latest CFBuilder crashing constantly?

2010-03-11 Thread morgan l
That's good to hear, thanks for the info. I don't know the exact schedule, but beta 3 expires March 31, so a new build should be available by then, at least. On Thu, Mar 11, 2010 at 12:46 PM, Mary Jo Sminkey mary...@cfwebstore.comwrote: I'll try a delete and re-install, too. Anyone know of

Re: date calculations driving me batty!!

2010-03-02 Thread morgan l
Datediff returns the number of complete units between the dates given. Daylight savings time starts inside your 'incorrect' ranges in the US-and thus the host server, and you're coming up 1 hour short for that time change. Off the top of my head, you could change the Datediff unit to hours,

Re: CKEditor

2009-11-11 Thread morgan l
CKEditor is the name of the newest version. I assume by integrate into CF you mean the file manager? If so, you'll either have to buy their file manager, or merge it with some other file manager.I've been investigating CFFM, but it looks like we're going to use TinyMCE instead of CKEditor in

Re: CKEditor

2009-11-11 Thread morgan l
It was actually the initials (F.C.K.) of the developer. On Wed, Nov 11, 2009 at 9:45 AM, Phillip Vector vec...@mostdeadlygame.comwrote: So that wasn't their intention before? I always saw the extra letter myself as well. Thought it was some kind of subliminal marketing ploy. On Wed, Nov

Re: How do I reduce scam attempts on my website. Arghh!

2009-08-26 Thread morgan l
http://akismet.com/faq/ http://akismet.com/faq/Fourth question down. On Wed, Aug 26, 2009 at 11:17 AM, Rick King kingric...@hotmail.com wrote: My site is not WordPress blog. Can I still use the API key that WP generates, and use Akismet?

Re: How to prevent JSON data Yes and No being returned to calling page as true and false...

2009-08-07 Thread morgan l
It's an inline if: (condition) ? true-value : false-value;I think the row[18], as the condition being checked, needs to be in parens: out.push('lispan class=spanLeftPets Allowed/spanspan class=spanRight' + (row[18]) ? 'Yes' : 'No' + '/span/li'); On Fri, Aug 7, 2009 at 2:32 PM, Rick Faircloth

Re: ColdFusion.Window.create problems..

2009-03-06 Thread morgan l
This is the js I am currently using, courtesy of quirksmode.com: var posx = 0; var posy = 0; if (!e) var e = window.event; if (e.pageX || e.pageY) { posx = e.pageX; posy = e.pageY; } else if (e.clientX || e.clientY) { posx = e.clientX + document.body.scrollLeft +

Re: setting a var from Inside cfoutput group

2009-02-27 Thread morgan l
You're restarting the variable by setting it inside the output group. Try: cfset myList = cfoutput group=n1 cfset myListx = ListAppend(myList, n1Id) /cfoutput On Fri, Feb 27, 2009 at 11:10 AM, Paul Ihrig pih...@gmail.com wrote: cfoutput group=n1 cfset myList = #n1Id#, cfset myListx =

Re: cfinclude template issues

2009-02-19 Thread morgan l
You need to add the filename of the page you're adding to the PageInclude column of the database table (dbo.ProductPages), and a then pass the pageID code of the new item to index.cfm (index.cfm?p=[PageID]). On second glance, it looks like you may have already done this part--your message says it

Re: Loop and Variable Names

2009-01-08 Thread morgan l
#guestdetail[guest idx]# should work. On Thu, Jan 8, 2009 at 10:04 AM, Les Mizzell lesm...@bellsouth.net wrote: I always seem to get this wrong. For query results fields guestdetail.guest1 to guestdetail.guest10, why isn't the following working? cfloop from=1 to=10 index=idx Guest

Re: Quickbooks and CF

2008-11-13 Thread morgan l
I'd suggest checking out http://idnforums.intuit.com for information. What you're going to be looking for will depend on several factors: what version of QB you're connecting to, if you're using a desktop or web app to connect etc., and I don't know the ins and outs of all the variables. Their OSR

Re: Quickbooks and CF

2008-11-13 Thread morgan l
.. that's the thing. I looked through the entire guide and site and I couldn't find 1 URL that I can send this data to.. Intuits cloud per say. morgan l wrote: I'd suggest checking out http://idnforums.intuit.com for information. What you're going to be looking for will depend on several

Re: cfqueryparam vs cfstoredproc?

2008-10-30 Thread morgan l
We call stored procedures using cfqueryparam: cfquery datasource=DSN name=SomeQuery EXEC StoredProcName @ParamName = cfqueryparam cfsqltype=cf_sql_integer value=#session.value# /cfquery On Thu, Oct 30, 2008 at 10:49 AM, Marie Taylore [EMAIL PROTECTED]wrote: Question... the more I read about

Re: not ignoring empty list elements

2008-09-03 Thread morgan l
Pre-CF8, just run a replace on your list, and replace ,, with , ,, and no more empty element. CF8, as I understand it, can be told to count empty elements somehow. On Wed, Sep 3, 2008 at 1:08 PM, Matthew Smith [EMAIL PROTECTED] wrote: My understanding is that the list functions in CF ignore

Re: list and ListContainsNoCase

2008-08-06 Thread morgan l
ListFind will check for an exact match on list items, ListContains checks if the string exists at all in any list element (thus, Black matches Black/White). On Wed, Aug 6, 2008 at 1:24 PM, Chad Gray [EMAIL PROTECTED] wrote: Why is this happening? I don't want to display the variable ColorName

Re: cfswitch

2008-08-04 Thread morgan l
The value or values must be simple constants or constant expressions, not variables. The root of the problem then is: CF doesn't allow declaration of constants, only variables. ~| Adobe® ColdFusion® 8 software 8 is the most

Re: writing protected CF with CFStoredProc

2008-07-22 Thread morgan l
What's wrong with using: cfquery ... exec sps_testproc cfif whichvar = A @aid=cfqueryparam value=123 cfsqltype=cf_sql_integer cfelse @bid=cfqueryparam value=456 cfsqltype=cf_sql_integer /cfif /cfquery

Re: Mystery Character

2008-07-21 Thread morgan l
Try here: http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/specialcharacters.html It lists decimal and hex values for corresponding mac keystrokes. On Mon, Jul 21, 2008 at 3:43 PM, Robert Harrison [EMAIL PROTECTED] wrote: I don't see that character in the ASCII list, but it's

Re: url scope and variables named url

2008-07-17 Thread morgan l
What about using the Struct/Array type reference: cfif IsDefined(url[foo]).../cfif? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Simple cfmail driving me crazy!

2008-07-01 Thread morgan l
Looks like you're posting the form to itself, but not carrying over the URL.ProdID used in the where clause of the query in the form, so the second time through, nothing is returned by the query. On Tue, Jul 1, 2008 at 1:32 PM, Rick King [EMAIL PROTECTED] wrote: hmm...that didn't seem to work.

Re: Simple cfmail driving me crazy!

2008-07-01 Thread morgan l
I'd pass it as a hidden field in the form, and then check at the top of the page for it in the url or form scope, throw it in a variables.ProdID, and use that in the query: cfif StructKeyExists(form,ProdID) cfset variables.ProdID = form.ProdID cfelseif StructKeyExists(URL,ProdID) cfset

Re: use of IN operator in CFIF tag

2008-06-30 Thread morgan l
Look into the Find() or FindNoCase() functions to do this. On Mon, Jun 30, 2008 at 3:47 PM, Roberto Perez [EMAIL PROTECTED] wrote: 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

Re: cfkeditor rewriting cfif

2008-06-11 Thread morgan l
The parser in FCK is rewriting the code. I'm not sure if there's any way to get it to stop, though; I've never tried to put CFML code inside the source view before. On Wed, Jun 11, 2008 at 3:34 PM, Gerald Guido [EMAIL PROTECTED] wrote: any ways to stop it from rewriting code in source? What

Re: listtoarray?

2008-06-05 Thread morgan l
The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest =

Re: recursive functions and cfqueries

2008-06-02 Thread morgan l
This was also my first inclination. We sometimes add a cfset var local = StructNew() to open a function, then anything that needs to be var'd is just 'scoped' as 'local' (cfset local.myVarredVariable = ) On Mon, Jun 2, 2008 at 4:09 PM, Brad Wood [EMAIL PROTECTED] wrote: I'll admit, I only

Re: Rank names on Forums

2008-05-30 Thread morgan l
Paranoia? The computer is your friend Paranoia? Seriously? Cool. '80s RPG flashback moment there. On Fri, May 30, 2008 at 12:46 PM, Phillip Vector [EMAIL PROTECTED] wrote: It's based off a game called Paranoia.. There are 7 ranks representing the colors of the rainbow (ROY G BIV) and one

Re: Rank names on Forums

2008-05-30 Thread morgan l
? On Fri, May 30, 2008 at 11:25 AM, morgan l [EMAIL PROTECTED] wrote: Paranoia? The computer is your friend Paranoia? Seriously? Cool. '80s RPG flashback moment there. ~| Adobe® ColdFusion® 8 software 8 is the most important

Re: Syntax Error In Update Statement

2008-05-23 Thread morgan l
The query you posted (UPDATE HomeCareCompany) is not the query reporting the error ( UPDATE Physician ) On Fri, May 23, 2008 at 3:28 PM, [EMAIL PROTECTED] wrote: One that is not very helpful :( Error Executing Database Query. Syntax error in UPDATE statement. The error occurred in

Re: limit file upload size in fckeditor

2008-05-21 Thread morgan l
We use this code in the filemanager's upload.cfm template: cfelseif cffile.FileSize gt 1048576!--- Disallow files over 1MB --- cfset errorNumber = 1 cfset customMsg = An error occured. The file uploaded has a size of #(NumberFormat((cffile.FileSize / 1048576), '9.99'))#MB which is larger than

Re: Stupid Select Issue

2008-05-20 Thread morgan l
Change select name=SiteID id=SiteID onchange=Populate(this.selectedIndex) to select name=SiteID id=SiteID onchange=Populate(this.value) selectedIndex only works if there are no gaps in SiteID, and what you want is the value of that selectedIndex, no matter where it falls in the option list.

Re: SSN

2008-05-15 Thread morgan l
Looks like CF's IsValid() will accept a type of SSN ( http://www.houseoffusion.com/documentation/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0534.htm), which would suggest that there is some sort of check-sum or other algorithm available, which will give

Re: problem with form field undefined

2008-04-23 Thread morgan l
Your error is Element PID is undefined in TESTFORM, meaning you are referenceing Testform.PID somewhere. That reference isn't in your posted code, so you'll need to check your pages and see where that is coming from. ~| Adobe®

Re: problem with form field undefined

2008-04-23 Thread morgan l
Ok, so it was debug text...I'll ignore that part then, no problem. The next thing I see is that the error is in template db\db1.cfm, which is not the action page of the form (which is action.cfm). The question now is, how are you getting to db1.cfm? Is it a UDF call, a cfinclude, or maybe even a

Re: problem with form field undefined

2008-04-23 Thread morgan l
On Wed, Apr 23, 2008 at 10:02 AM, alex poyaoan [EMAIL PROTECTED] wrote: yes the error occurs in action.cfm but if you cfdump form all of the required variables has values as what i posted earlier From your first post: The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 So the

Re: how handle emails not exists or inactive before sending out

2008-04-23 Thread morgan l
You can set a failto attribute. Some mail servers choose to bounce to the from, however. On Wed, Apr 23, 2008 at 10:37 AM, Phillip Vector [EMAIL PROTECTED] wrote: Probably a noob question. :) How do you set a bounce back address in cfmail? I mean, seperate from the From field. Is there a

Re: cfquery with array

2008-04-22 Thread morgan l
Does the IN clause need to be enclosed in parens?: SELECT subjectID, firstName, lastName from subjects where subjectID in (cfqueryparam value=#arraytolist(subjectIDArray)# list=yes cfsqltype=cf_sql_integer) ~| Adobe®

Re: cfquery with array

2008-04-22 Thread morgan l
Glad you got it sorted. Gmail delivered your message saying you'd fixed it as I hit send. On Tue, Apr 22, 2008 at 10:03 AM, Richard White [EMAIL PROTECTED] wrote: yes thanks morgan :) Does the IN clause need to be enclosed in parens?: SELECT subjectID, firstName, lastName from subjects

Re: Some JS help please

2008-04-17 Thread morgan l
Yep, I think this is the problem as well. If you take the code posted @ http://www.nomorepasting.com/getpaste.php?pasteid=14631 and move the entire script section to the bottom, the error goes away. On Wed, Apr 16, 2008 at 4:55 PM, Matt Williams [EMAIL PROTECTED] wrote: On Wed, Apr 16, 2008

Re: Disable Image Button in IE

2008-04-15 Thread morgan l
Should be as simple as an onclick=this.disabled = true : input type=image src=/images/buttons/button_save.gif onclick=this.disabled=true / Works for me in IE7 in my quick test. ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Multiple forms on same page and client side data validation

2008-04-15 Thread morgan l
Unless I'm missing something, or you're doing something you've not mentioned (eg an Ajax call to handle the data of each 'step'), what he's saying is, when your final step gets submitted, all the data from the prior steps is lost. Only the submitted form's data is available to the action page. On

Re: NumberForamt Issue with csv file

2008-04-10 Thread morgan l
You'll have to surround each data column with quotes, either one at a time in the cfset CONTENT=#employee#, #jobcode# line ( cfset CONTENT= '#employee#,#jobcode#'), or with a cfset CONTENT = ListQualify(CONTENT,'',,,all) statement before the cffile append line.

Re: NumberForamt Issue with csv file

2008-04-10 Thread morgan l
ListQualify() can't be made to only affect certain elements, no. And if setting them inline didn't work, hmm... Some DB's will allow concatenation in the select: MySQL would be something like: SELECT Concat('', employee, '') as textEmployee, Concat('', jobcode, '') as textJobcode or maybe

Re: Problem outputing The table

2008-04-09 Thread morgan l
You've got to help us help you out here: What's the problem? Is there an error, or does it just not display what you expect? Are your querys and QofQs returning the correct data? I'm sure I'm not alone in thinking that there are lots of people on this list that are happy to help, but we need

Re: Order by question

2008-04-03 Thread morgan l
If I understand right, he wants the alpha order, not the numeric order. To that end, I have no suggestions, db sql stuff are not my strong skills. On Thu, Apr 3, 2008 at 3:55 PM, Ian Skinner [EMAIL PROTECTED] wrote: Paul Ihrig wrote: 1 101 101010 2 201 202 201010 201020 3

Re: Checkboxes not passing variables correctly

2008-03-25 Thread morgan l
If you just want the list of names, separated by comma and space, then use: Faculty Supervisor: #Replace(form.fac ,all)# On Tue, Mar 25, 2008 at 9:12 AM, Steve LaBadie [EMAIL PROTECTED] wrote: Is there a list of all possible delimiters value? If I use your suggestion there are no spaces

Re: cfcalendar

2008-03-11 Thread morgan l
It strikes me that mm-dd- is an illogical way to write a date, but that's just me being provocative ;) Which is, of course, precisely why we use it here in the US. Yes, please, let's place the most oft changed value of the date between the other parts.

Re: FckEditor kills FF2's built-in speller

2008-02-22 Thread morgan l
Looks like there's an option, FCKConfig.FirefoxSpellChecker, in the fckconfig.js file that *should* control that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: Aaack! What does this error message mean?

2008-02-20 Thread morgan l
Using cfset Email.To = whatever is trying to set a key called To in a Structure called Email. The error seems to indicate that Email is not actually a Structure, though. cfset Email = StructNew() will declare Email as a Structure. On Wed, Feb 20, 2008 at 10:55 AM, Rick Faircloth [EMAIL PROTECTED]

Re: CF MX8: This is driving me nuts!!!

2008-01-23 Thread morgan l
Ok, so now you've got me in troubleshoot mode. First, does the query run outside of CF? I just noticed the *[ODBC Microsoft Access Driver]* part; I'm not a db guy, maybe this would change the syntax, even slightly? Second, are the DB fields both type 'varchar'? The cfqueryparam being used marks

Re: stuck with a loop count

2008-01-04 Thread morgan l
I'm not entirely sure I follow where it is you want the total to display and/or reset to 0. If you want to track each manager grouping separately, you'll need another count running as well as the overall total count. !--- overall Total; init at 0 --- cfset sumTotal = 0 cfoutput query=get_Sales

Re: another date format problem

2008-01-02 Thread morgan l
If I read you right (add 7 days, then format the new value), something like this should work: #DateFormat(DateAdd(d, 7, startdate), 'yyy.mm.dd')# On Jan 2, 2008 3:49 PM, Mark Fuqua [EMAIL PROTECTED] wrote: This works #DateAdd(d, 7, 1/28/2008)# And this works #DateFormat(startdate,

Re: Problem with SQL Insert

2007-12-05 Thread morgan l
Shouldn't it be INSERT INTO CDN100? On Dec 5, 2007 1:26 PM, Dave Francis [EMAIL PROTECTED] wrote: CF5.0 - SQL2k I am getting a Base table not found error on a table that I know (and can prove) is there. In the following code, the SELECT apparently works as the cfdump displays the column

Re: sql and order by ?

2007-11-28 Thread morgan l
If ordering by the Left() and Right() don't work, can you Select Left(SerialNum,4) as sYear, Right(SerialNum,Length(SerialNum)-4) as sNum and then order by sYear, sNum? Been a while since I've worked in mysql, but several of the suggestions here look like they should be working.

Re: cffile upload issue

2007-11-15 Thread morgan l
Or CFIF IsDefined(form.update.x) if you are trying to check that the submit image was clicked. On Nov 15, 2007 10:53 AM, Brian McCairn [EMAIL PROTECTED] wrote: Where you say CFIF IsDefined(form.upload.x) I think should just be CFIF IsDefined(form.upload)

Re: query columnCount

2007-11-13 Thread morgan l
ListLen(queryName.ColumnList) On Nov 13, 2007 1:38 PM, Richard White [EMAIL PROTECTED] wrote: Hi, hopefully this is a very simple question. i cant find the answer on google :( how do i count how many columns were returned in a cfquery thanks

Re: SeeFusion vs. FusionReactor

2007-10-24 Thread morgan l
I don't believe that CF8 Standard comes with the server monitoring tools. On 10/24/07, Peterson, Chris [EMAIL PROTECTED] wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on

Re: What can PHP do that CF can't?

2007-10-19 Thread morgan l
As I recall, BASIC used $ to denote a variable as a string type. a var defined without was numericbut it's been in the 20+ year range for me, as well...may have changed, and I may be mis-remembering. On 10/19/07, Josh Nathanson [EMAIL PROTECTED] wrote: There are $ signs in front of

Re: Replace spaces with dashes

2007-10-18 Thread morgan l
Trim(String) will get rid of leading or trailing spaces. You may need a RegEx and use ReReplace() if you want to replace multiple connsecutive spaces with just a single dash though. RegEx is not my bag, so I can't help with specifics. On 10/18/07, Steve Sequenzia wrote: I need to take a string

Re: Replace spaces with dashes

2007-10-18 Thread morgan l
that should have been turned into dashes. On 10/18/07, morgan l [EMAIL PROTECTED] wrote: Trim(String) will get rid of leading or trailing spaces. You may need a RegEx and use ReReplace() if you want to replace multiple connsecutive spaces with just a single dash though. RegEx is not my bag

Re: String validation HELP!!!!

2007-09-25 Thread morgan l
Kenny, I replied off-list, so as not to clutter things around here with a personal conversation. -morgan On 9/25/07, Kenny Kinds wrote: WOW! Small world. Where are you at now. How are things? As you've probably guessed, i'm not at CWC anymore. left there about 2 1/2 years ago. nvmd.