Re: Adding Updating empty values

2008-10-28 Thread Charlie Griefer
text fields are defined even if they are empty. the value is simply an empty string. On Tue, Oct 28, 2008 at 12:58 PM, Rick Sanders [EMAIL PROTECTED] wrote: I hear you, and already did that for checkboxes. But, I have text fields and radio buttons in my form! -Original Message-

Re: Adding Updating empty values

2008-10-28 Thread Charlie Griefer
well, cfparam name=foo default= / is shorter than: cfif structkeyExists(form, 'foo') do stuff /cfif especially over 50 iterations :) On Tue, Oct 28, 2008 at 1:36 PM, Rick Sanders [EMAIL PROTECTED] wrote: I agree, but I still have to enter all the form field names in the cfparam anyways

Re: Update Query syntax

2008-10-23 Thread Charlie Griefer
WHERE itemno IN (#preserveSingleQuotes(itemnos)#) or even better: WHERE itemno IN (cfqueryparam value=#itemno# cfsqltype=cf_sql_char list=true /) On Thu, Oct 23, 2008 at 12:21 PM, Ben Conner [EMAIL PROTECTED] wrote: Hi, I have a simple update query that is throwing an error: cfquery

Re: How to avoid is not of type query error using CFC?

2008-10-22 Thread Charlie Griefer
the problem isn't the empty query. an empty query is still a query. the problem is you're returning featured_products but your query is named get_featured_products. you're returning an empty variable. change this line: cfset var featured_products = / to: cfset var get_featured_products = /

Re: How can this CFC be improved?

2008-10-22 Thread Charlie Griefer
even if you're a solo developer, creating components that are truly black-boxed (e.g. they know nothing of the world outside them), you're creating components that you can potentially reuse yourself. Also, by passing in the information explicitly (rather than referring to outside scopes from

Re: How to avoid is not of type query error using CFC?

2008-10-22 Thread Charlie Griefer
, not a lot of the CFC stuff does, right now) The change made it work, however. Now I know. The cfreturn variable has to match the query name. Live and learn... Rick Charlie Griefer wrote: the problem isn't the empty query. an empty query is still a query. the problem is you're returning

Re: How can this CFC be improved?

2008-10-22 Thread Charlie Griefer
For now I probably wouldn't worry about DAOs and other related concepts. Build a strong foundation by encapsulating the CFC methods so that they don't rely on any external variables. That'd be a good start. Once you recoil in terror at seeing a CFC method reference application or session or form

Re: How do I use a CFC for form data validation?

2008-10-22 Thread Charlie Griefer
the keys in the struct that comprises the argumentCollection are received by the method as individual cfarguments. so if your form struct has keys 'firstName' and 'lastName', and the form was passed in as an argumentCollection, you'd have arguments.firstName and arguments.lastName. also you need

generating higher res images from PDF

2008-10-21 Thread Charlie Griefer
hey all. used cfpdf action=thumbnail scale=100 ... / to generate a full size image from a PDF. unfortunately, the image is at 72dpi and I have need for it to be slightly... larger. looked into dan switzer's UDF where he invoked jpedal directly (jpedal is, i believe, what cfpdf uses behind the

Re: cfregistry, but not really

2008-10-19 Thread Charlie Griefer
On Sun, Oct 19, 2008 at 9:33 AM, Phillip M. Vector [EMAIL PROTECTED] wrote: I have a hosting company that restricts access to cfregistry. Not a problem as I never use that tag.. They recently put me in their sandbox (which worked before) and I got the error.. Security: The requested

cfpdf action=thumbnail

2008-10-17 Thread Charlie Griefer
had a request to convert PDF to image. Used cfpdf action=thumbnail ... / and everything worked pretty well. Unfortunately, the resulting image seems a bit smaller than the original PDF. The customer wants to embed the images into an email (versus sending the PDF as an attachment), so

Re: cfselect question, simple one

2008-10-15 Thread Charlie Griefer
why not just use a select ? On Wed, Oct 15, 2008 at 7:23 PM, Azadi Saryev [EMAIL PROTECTED] wrote: create a column in your query that concatenates the data you need and use that column in the display attribute of cfselect: cfquery name=request.billingRate ... SELECT id, name, value, name +

Re: Pulling only 1 year of records

2008-10-15 Thread Charlie Griefer
On Wed, Oct 15, 2008 at 10:38 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: How do I write a query to only pull 1 year (2009 lets say) from the DB that has a date field? would I do something like where datestarting like %09 ? I mean, that MAY work, but is there a less kludgy way of

Re: Inexpensive student/developer oriented CF hosting?

2008-10-13 Thread Charlie Griefer
http://hostingatoz.com/shared_hosting.cfx Most expensive CF plan (with SQL Server) is $75 a year. If you go the MySQL route, their Plan S-III is $30 a year. I've reviewed them (and used them myself) in the past... and while I probably wouldn't put up a commercial site for a client that needs

Re: OT - Developers Needed for Paid Focus Groups in SF (SF Bay Area)

2008-10-09 Thread Charlie Griefer
i responded to this, and just got a call back that they're really trying to find VB6 (!) developers. i told the woman who called me that i don't know of any offhand, but i'd put the word out. so all you VB6 people in the Bay Area, here's your chance to make a quick $200 :) On Thu, Oct 9, 2008

Re: facebook-like interactive avatar trimmer

2008-10-02 Thread Charlie Griefer
http://cfsilence.com/blog/client/index.cfm/cfImageCropper ?http://cfsilence.com/blog/client/index.cfm/cfImageCropper On Thu, Oct 2, 2008 at 12:15 AM, Kay Smoljak [EMAIL PROTECTED] wrote: I would like to create an avatar-trimming feature like that found on Facebook and Flickr, which allows the

Re: RegEx (REMatch) experts?

2008-10-01 Thread Charlie Griefer
On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc [EMAIL PROTECTED]wrote: Hi All, Have NOT ventured into regular expressions much at all. Now I have the need for one, and wonder if anyone has one made for this scenario. Search engine, want user to be able to enter multiple words, also

Re: RegEx (REMatch) experts?

2008-10-01 Thread Charlie Griefer
On Wed, Oct 1, 2008 at 2:36 PM, Charlie Griefer [EMAIL PROTECTED]wrote: On Wed, Oct 1, 2008 at 2:09 PM, Developer MediaDoc [EMAIL PROTECTED] wrote: Hi All, Have NOT ventured into regular expressions much at all. Now I have the need for one, and wonder if anyone has one made

Re: Recordcount Summation of 2 Queries

2008-09-30 Thread Charlie Griefer
On Tue, Sep 30, 2008 at 12:45 PM, Michael Norton [EMAIL PROTECTED] wrote: Greetings, Is it possible to print the summation of two recordcounts? Bear with me if I'm being long-winded, but here's the deal: Let's say we have two queries, query_1 and query_2. In the text, I print the number of

Re: Updating 1 record randomly

2008-09-29 Thread Charlie Griefer
assuming there's some sort of unique identifier you could put a subquery in the WHERE UPDATE Werewolf_Players SET foo = bar WHERE uniqueCol = (SELECT TOP 1 uniqueCol FROM Werewolf_Players WHERE uniqueCol = newID()) i think that'd work... and i think that's MS SQL Server specific

Re: (ot) need help offlist

2008-09-29 Thread Charlie Griefer
On Mon, Sep 29, 2008 at 2:07 PM, Jochem van Dieten [EMAIL PROTECTED]wrote: Phillip Perry wrote: Hi, Can someone please help me offlist. I'm stuck and its a bit off topic but i'm in a real bind. Depends. Did an very distant relative from Nigeria just die, leave you a large amount of money

Re: 404 onMissingTemplate works with html, not with cfm

2008-09-26 Thread Charlie Griefer
you need to set a sitewide missing template handler in the cf admin. if you're on CF 8, you can add an onMissingTemplate method to your Application.cfc on a per-application basis (if need be). On Fri, Sep 26, 2008 at 8:32 AM, Paul Ihrig [EMAIL PROTECTED] wrote: ok.. i am not sure what to look

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
using your code on CF8 (8,0,0,176276), i get the structs returned in the same order (alpha by key name) each time. neither arbitrary nor random. i understand this isn't necessarily what you want... but it does seem to be consistent (for whatever that's worth). On Fri, Sep 26, 2008 at 12:21 PM,

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
On Fri, Sep 26, 2008 at 12:52 PM, C S [EMAIL PROTECTED] wrote: using your code on CF8 (8,0,0,176276), i get the structs returned in the same order (alpha by key name) each time. neither arbitrary nor random. With 8,0,1,195765 I get a different order each time. Unless I drop the argument

Re: Ordered Argument names

2008-09-26 Thread Charlie Griefer
On Fri, Sep 26, 2008 at 2:08 PM, Peter Boughton [EMAIL PROTECTED] wrote: don't believe structs are inherently meant to be 'ordered'. Yes, that is my understanding too. Interesting that it does seem to return the correct order if you do not use named arguments. Well it has to really -

Re: (ot) Best development laptop

2008-09-26 Thread Charlie Griefer
hehe i knew that bit was gonna catch a mac person's attention :) On Fri, Sep 26, 2008 at 2:47 PM, J.J. Merrick [EMAIL PROTECTED]wrote: Andy, Could you expand on the small apps that you need? I am just curious as to what they are. I made the switch back in Feb and have found that 99% of

Re: Disabling Application.cfm for a specific page

2008-09-23 Thread Charlie Griefer
are there other files in that directory? if not (or if the other files meet the same criteria and shouldn't invoke the Application.cfm), you can put an Application.cfm in that directory. CF will 'execute' that one and not the 'parent' one. Or (and this is a little fuglier), you can put

Re: capture url variable?

2008-09-16 Thread Charlie Griefer
cgi.query_string cflocation URL=somewhere_else?#cgi.query_string# addtoken=no / On Tue, Sep 16, 2008 at 3:00 PM, John P [EMAIL PROTECTED] wrote: Hi, I need to capture a url variable then add it to a redirect so my application which is changing servers will still work. Not sure where to

Re: cfcookie expires default

2008-09-16 Thread Charlie Griefer
it's been fixed for a couple of versions. as of 6.1 (maybe 6.0) :) On Tue, Sep 16, 2008 at 4:00 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: Back in CF5 (and 6 I think), if you did a cflocation on the same page as the cfcookie, the cookie didn't take. Are you doing it? If so, try removing

Re: CF, JQuery and IE

2008-09-16 Thread Charlie Griefer
yeah, to add to what Azadi said... i've not done anything yet with cfdiv, but i've worked with cfwindow. integrating jquery into a cfwindow is tricky. as per the docs, functions inside cfwindow (and maybe cfdiv as well?) need to be in the format of: myFunction = function (args) { stuff }

Re: cfmail no longer working AND scheduled tasks arent being run

2008-09-15 Thread Charlie Griefer
i'd probably log into the cf admin and verify the mail server settings, as well as take a look at the specific tasks that aren't running, to see how they're configured (or if they're even still there). On Mon, Sep 15, 2008 at 7:31 PM, Torrent Girl [EMAIL PROTECTED] wrote: hi all we had a few

Re: Function Argument Order

2008-09-11 Thread Charlie Griefer
On Thu, Sep 11, 2008 at 11:15 AM, Robert Nurse [EMAIL PROTECTED] wrote: Hi All, I've got a function that takes four (4) arguments. Two of which are not required. They both have default values set up in their cfargument... tags. When I call the function without one/both of them, I get an

Re: using dynamic variable in cfset statement

2008-09-09 Thread Charlie Griefer
try cfset application[appconfig.code_name] = appconfig.code_value / On Tue, Sep 9, 2008 at 1:53 PM, Wally Randall [EMAIL PROTECTED]wrote: Why does this fail inside a cfoutput loop over a query: cfset application.#appconfig.code_name# = '#appconfig.code_value#' It generates this message:

Re: using dynamic variable in cfset statement

2008-09-09 Thread Charlie Griefer
On Tue, Sep 9, 2008 at 2:01 PM, Wally Randall [EMAIL PROTECTED]wrote: Also, the [] is an invalid constrict in coldfusion. could you elaborate on that please? -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success.

Re: using dynamic variable in cfset statement

2008-09-09 Thread Charlie Griefer
hehe :) On Tue, Sep 9, 2008 at 2:18 PM, Patrick Santora [EMAIL PROTECTED] wrote: Ouch! Evaluate On Tue, Sep 9, 2008 at 2:15 PM, David Moore, Jr. [EMAIL PROTECTED] wrote: Would something like this work? cfset Evaluate(application.#appconfig.code_name#) = '#appconfig.code_value#'

Re: using dynamic variable in cfset statement

2008-09-09 Thread Charlie Griefer
hey i was laughing at patrick laughing at you, not laughing at you directly, so it's ok :) serious face there's probably not one of us on this list that didn't used to use evaluate() before being taught to look at other alternatives (and i'm sure some who still do use it). it's all good.

Re: Conditional CFSET based on data in array

2008-09-08 Thread Charlie Griefer
On Mon, Sep 8, 2008 at 12:54 PM, Jeff F [EMAIL PROTECTED] wrote: I've got a simple cart that stores items in an array. I keep a running total of the items in the cart looping through: cfloop collection=#session.cart# item=i cfset numberofitems = numberofitems + session.cart[i][4]

Re: form collection

2008-09-05 Thread Charlie Griefer
On Fri, Sep 5, 2008 at 11:20 AM, Chad Gray [EMAIL PROTECTED] wrote: Hello, I am using argumentCollection=form to dump all of the form fields into a CFC. I would like to add to the form collection one more variable called Alias. I tried this but the variable FORM.Alias does not appear to

Re: not ignoring empty list elements

2008-09-03 Thread Charlie Griefer
On Wed, Sep 3, 2008 at 11:08 AM, Matthew Smith [EMAIL PROTECTED]wrote: My understanding is that the list functions in CF ignore empty elements. Is this true? If so, How can I make the functions count the empty elemants when evaluating? I have a csv file from the history downlolad at

Re: not ignoring empty list elements

2008-09-03 Thread Charlie Griefer
that won't account for an empty list element at the end of the list (e.g. 1,2,3,4,) i believe there's a regex out there that'll do it tho... On Wed, Sep 3, 2008 at 11:12 AM, morgan l [EMAIL PROTECTED] wrote: Pre-CF8, just run a replace on your list, and replace ,, with , ,, and no more empty

Re: not ignoring empty list elements

2008-09-03 Thread Charlie Griefer
On Wed, Sep 3, 2008 at 2:02 PM, Matthew Smith [EMAIL PROTECTED] wrote: Thank you, everyone. I'l play with it tonight. TMI? :) -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success.

Re: Please Help..Confused

2008-09-02 Thread Charlie Griefer
On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith [EMAIL PROTECTED]wrote: I have 3 drop-down boxes for: Years Months Days I need to combine the values for all 3 and convert to days so I can use the total number of days with DateDiff...Any suggestions would be greatly appreciated.

Re: Please Help..Confused

2008-09-02 Thread Charlie Griefer
On Tue, Sep 2, 2008 at 11:37 AM, Laurie Smith [EMAIL PROTECTED]wrote: On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith [EMAIL PROTECTED] wrote: but... but... some months have a different number of days than others :) if that's your desired result, you'll really need to capture a start

Re: i = HTMLEditFormat( some text

2008-08-27 Thread Charlie Griefer
it is escaping them. the fact that you see them in the browser means they've been escaped. view the source and you'll see. if you have this: cfset myString = hellofoo / and you do a cfoutput#myString#/cfoutput, all you'll see is foo, because the braces around hello were not escaped and the

Re: fusebox vs model glue

2008-08-27 Thread Charlie Griefer
On Wed, Aug 27, 2008 at 1:03 PM, Richard White [EMAIL PROTECTED] wrote: hi we have just reviewed model glue, and have also looked into fusebox very briefly is fusebox similiar to model glue? and if so is it a case of using one or the other? and if so then what are your feelings on which

Re: fusebox vs model glue

2008-08-27 Thread Charlie Griefer
On Wed, Aug 27, 2008 at 5:24 PM, s. isaac dealey [EMAIL PROTECTED] wrote: Hey Ike: Hell of a well-thought out post. I was going to snip it down and keep only relevant bits, but it was all pretty relevant (so um yeah... i snipped it all) :) the one point i'd like to try and make in response is

Re: cfscript question

2008-08-26 Thread Charlie Griefer
On Tue, Aug 26, 2008 at 10:45 AM, Scott Stewart [EMAIL PROTECTED]wrote: Is it possible to do a query output loop in cfscript using something other than WriteOutput? obvious question is... why? :) for (i=1; i lt queryname.recordcount; i=i+1) { // you can pretty that up a bit if you're on CF8

Re: Here's an interesting little problem...

2008-08-26 Thread Charlie Griefer
ORDER BY CASE class WHEN 'AA' THEN 10 WHEN 'A' THEN 20 WHEN 'B' THEN 30 WHEN 'C' THEN 40 WHEN 'D' THEN 50 WHEN 'E' THEN 60 END incremented by 10 so you can add 'AAA' etc later :) On Tue, Aug 26, 2008 at 11:00 AM, Rick Faircloth [EMAIL

Re: Here's an interesting little problem...

2008-08-26 Thread Charlie Griefer
i'm not givin' back my prize. On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth [EMAIL PROTECTED]wrote: And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select

Re: What am I missing???

2008-08-25 Thread Charlie Griefer
why not name the checkboxes the same, which will result in a comma-delimited list. then you only have to check for one checkbox. cfoutput q cfif structKeyExists(form, 'shooter') cfloop list=#form.shooter# index=idx cfquery name=register_shooters datasource=#application.dsn#

Re: What am I missing???

2008-08-25 Thread Charlie Griefer
accidentally hit 'send' :\ that should have read: form page: cfoutput query=get_unregistered input type=checkbox name=shooter value=#get_unregistered.shooter_id# / /cfoutput action page: cfif structKeyExists(form, 'shooter') cfloop list=#form.shooter# index=idx cfquery

Re: Using cfargumentCollection with cfajaxproxy

2008-08-23 Thread Charlie Griefer
On Fri, Aug 22, 2008 at 11:11 PM, Lisa Lee [EMAIL PROTECTED] wrote: I used cfajaxproxy to create a JavaScript method, like so: cfajaxproxy cfc=account.InternalAccountManagement jsclassname=accountManager Then, within a script block, I have the following: var am = new accountManager();

Re: Cfgrid Javascript function not working if not put inside head/head tags

2008-08-21 Thread Charlie Griefer
cfsavecontent variable=headText your javascript stuff here /cfsavecontent cfhtmlhead text=#headText# / On Thu, Aug 21, 2008 at 1:53 PM, dev losh [EMAIL PROTECTED] wrote: I having an issue with ajaxOnLoad function to use with gfgrid. if i call a function say 'myfun' using cfset

Re: Coldfusion IDE for Linux

2008-08-20 Thread Charlie Griefer
On Wed, Aug 20, 2008 at 6:01 PM, Jesse Beckton [EMAIL PROTECTED] wrote: Is there a decent Coldfusion IDE out there for Linux? And please don't say CFEclipse because it's just broke! The line numbers in the gutter do not display and I have seen the open tickets for this issue in their bug

Re: Coldfusion IDE for Linux

2008-08-20 Thread Charlie Griefer
right... with the recently released beta, you need to implement the fix you just mentioned. that's also referenced on the wiki at http://trac.cfeclipse.org/cfeclipse/wiki/KnownIssues#Missinglinenumbers it might take some tweaking, but given what you get for the price, i think it's worth the

Re: Form submission issue

2008-08-18 Thread Charlie Griefer
to piggyback on what James said, you could just use cfif not structIsEmpty(form) the form scope/struct exists on all pages. it's just empty if the page has received no post data. On Mon, Aug 18, 2008 at 12:45 AM, James Holmes [EMAIL PROTECTED]wrote: No, in IE6 the submit button is not part of

Re: SQL injection attack on House of Fusion

2008-08-15 Thread Charlie Griefer
On Fri, Aug 15, 2008 at 1:12 PM, Don L [EMAIL PROTECTED] wrote: But I know all this, I thought the sql injection attack went beyond it, thanks anyway, Justin. it did not. -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong? Byte says Parity error. Bartender nods

Re: (ot) Radio Buttons and Subordinates

2008-08-14 Thread Charlie Griefer
via JS, you can loop over the radio button array, and set each one to selected = false... depending on your business rules, you may to do some validation to ensure that if they don't enter something for other, one of the radio buttons gets re-selected. script type=text/javascript function

Re: help!! = ColdFusion.Window.create Refresh

2008-08-07 Thread Charlie Griefer
On Thu, Aug 7, 2008 at 2:20 AM, Rakshith N [EMAIL PROTECTED] wrote: Torsten, This was an issue and has been fixed in 8.0.1. I did a quick check on it and it works fine for me. Are you on 8.0.1? Charlie, Make sure that you use the right case when you use refreshOnShow in

Re: CFwindow and jquery in source

2008-08-07 Thread Charlie Griefer
where is your script src=jquery.js/script? it needs to be in the page that creates the cfwindow... not in the page that resides in the cfwindow. On Thu, Aug 7, 2008 at 11:35 AM, Justin T [EMAIL PROTECTED]wrote: Another example: I have a global jquery field highlighter that runs for all my

Re: CFwindow and jquery in source

2008-08-07 Thread Charlie Griefer
On Thu, Aug 7, 2008 at 11:52 AM, Justin T [EMAIL PROTECTED]wrote: where is your script src=jquery.js/script? it needs to be in the page that creates the cfwindow... not in the page that resides in the cfwindow. On Thu, Aug 7, 2008 at 11:35 AM, Justin T [EMAIL PROTECTED] wrote: Hi

Re: list and ListContainsNoCase

2008-08-06 Thread Charlie Griefer
change listContains() to listFind() listContains() will find substrings in the list elements. On Wed, Aug 6, 2008 at 11:24 AM, Chad Gray [EMAIL PROTECTED] wrote: Why is this happening? I don't want to display the variable ColorName if it has a value of something in my list dontShowList. If

Re: list and ListContainsNoCase

2008-08-06 Thread Charlie Griefer
from the livedocs: ListContains: Determines the index of the first list element that contains a specified substring. ListFind: Determines the index of the first list element in which a specified value occurs. On Wed, Aug 6, 2008 at 11:36 AM, Chad Gray [EMAIL PROTECTED] wrote: Thanks

Re: help!! = ColdFusion.Window.create Refresh

2008-08-06 Thread Charlie Griefer
i'd heard (on this list) that as of 8.01, refreshonshow worked for cfwindows created via the create method... but i've not been able to get it to work :\ my workaround was to pass a unique value to the js function that created the window, and use that as the window name. On Wed, Aug 6, 2008 at

Re: SOT: Forms Generator

2008-08-05 Thread Charlie Griefer
haven't used it myself, but you might want to look at squidhead: http://squidhead.riaforge.org/ reactor also does scaffolding... http://www.alagad.com/go/products-and-projects/reactor-for-coldfusion On Tue, Aug 5, 2008 at 8:18 AM, Dave Phillips [EMAIL PROTECTED] wrote: Anyone know of a quick

Re: Java Book Recommendations?

2008-08-05 Thread Charlie Griefer
head first java java for coldfusion developers, if you can find it. On Tue, Aug 5, 2008 at 10:25 AM, Will Tomlinson [EMAIL PROTECTED] wrote: Gents, I've decided to pickup another language for my arsenal. I think it shall be Java. Do you have a good book recommendation for me? Keep in

Re: Null/empty values from the database.

2008-08-04 Thread Charlie Griefer
does the Results query return a single row? if it returns multiple rows, then the Return variable wouldn't be set for any rows where sourcename wasn't blank. What about just: cfoutput query=Results cfif sourcename is There are no available sources at the moment cfelse

Re: Javascript and Coldfusion

2008-08-02 Thread Charlie Griefer
On Fri, Aug 1, 2008 at 11:22 PM, Brad Wood [EMAIL PROTECTED] wrote: That's a pretty vague question. Never the less, one that comes up often. Basically you need to remember that ColdFusion is all excited first on the server. my ColdFusion doesn't seem all excited. maybe it needs more RAM?

Re: cfqueryparam

2008-07-31 Thread Charlie Griefer
WHERE NewsBySection.sectionID = '13' !--- is this a char/varchar? --- AND News.startDate = cfqueryparam value=#daterequestAdd# cfsqltype=cf_sql_date / AND News.endDate = cfqueryparam value=#daterequestAdd# cfsqltype=cf_sql_date / AND News.archive = 0 * depending on your

Re: cfqueryparam

2008-07-31 Thread Charlie Griefer
On Thu, Jul 31, 2008 at 12:27 PM, Robert Newhart [EMAIL PROTECTED]wrote: WHERE NewsBySection.sectionID = '13' !--- is this a char/varchar? --- AND News.startDate = cfqueryparam value=#daterequestAdd# cfsqltype=cf_sql_date / AND News.endDate = cfqueryparam

Re: cfqueryparam

2008-07-31 Thread Charlie Griefer
, Jul 31, 2008 at 2:31 PM, Charlie Griefer [EMAIL PROTECTED]wrote: in that case, it shouldn't have single quotes around it. NewsBySection.sectionID = 13 is it currently working with the single quotes? -- A byte walks into a bar and orders a pint. Bartender asks him What's wrong

Re: CFImage patch on 8.01

2008-07-30 Thread Charlie Griefer
Brian: see if this screenshot helps: http://charlie.griefer.com/cfupdate.gif On Wed, Jul 30, 2008 at 10:01 AM, Brian Dumbledore [EMAIL PROTECTED]wrote: I am trying to patch our 8.01 enterprise server with patch from here:

Re: CFImage patch on 8.01

2008-07-30 Thread Charlie Griefer
On Wed, Jul 30, 2008 at 11:59 AM, Brian Dumbledore [EMAIL PROTECTED]wrote: Brian: see if this screenshot helps: http://charlie.griefer.com/cfupdate.gif On Wed, Jul 30, 2008 at 10:01 AM, Brian Dumbledore [EMAIL PROTECTED] wrote: Charlie, Was having my lunch and was thinking about

Re: Forum software

2008-07-29 Thread Charlie Griefer
not that he's advocating such a thing... :) On Tue, Jul 29, 2008 at 1:29 PM, [EMAIL PROTECTED] wrote: Cf encrypted files have been broken for many years. There is a decryptor download you can get directly from adobe. William Seiter (mobile) Have you ever read a book that changed your

Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...

2008-07-24 Thread Charlie Griefer
On Thu, Jul 24, 2008 at 10:48 AM, Radek Valachovic [EMAIL PROTECTED] wrote: Yeah I was reading in the forum this one, that using SELECT * is not good, can u explain why on short example? What is Pro and Cons what other type of security it gonna give me? Thanks Not using SELECT * is more of a

Re: cfloop

2008-07-17 Thread Charlie Griefer
On Thu, Jul 17, 2008 at 10:58 AM, Kenny Kinds [EMAIL PROTECTED] wrote: greetings, I have some code that takes a string and breaks it into to components and set each component into a seperate variable. This code was set up to only take one string and perform this function. Now they want me

Re: cfloop

2008-07-17 Thread Charlie Griefer
On Thu, Jul 17, 2008 at 11:30 AM, Kenny Kinds [EMAIL PROTECTED] wrote: Looks like you're having a list of lists now. One solution is to use some different delimiter for the elements in one of the lists. -- ___ REUSE CODE! Use custom tags; See

Re: cfloop

2008-07-17 Thread Charlie Griefer
On Thu, Jul 17, 2008 at 11:42 AM, Kenny Kinds [EMAIL PROTECTED] wrote: Here's a sample of the list getting passed from the form ACIS---Midwest'CAMPS---Midwest'CAMPS12345678901234X---Midwest123456789012Y'SORD---Southwest'SORD---West'SUPPORT---ChangeMan'SUPPORT---MVS Support'WBS---Midwest

Re: cfcatch

2008-07-16 Thread Charlie Griefer
On Wed, Jul 16, 2008 at 6:58 AM, Brian Dumbledore [EMAIL PROTECTED] wrote: I always thought any error generated can be cfdump'd by dumping cfcatch obj. Every now and then I get [unknown type] when I dump cfcatch and that always stumped me. However, when I output cfcatch.Message and

Re: Date and Time Validation

2008-07-11 Thread Charlie Griefer
On Fri, Jul 11, 2008 at 3:37 AM, Kamru Miah [EMAIL PROTECTED] wrote: Please let me know how to validate time input in HH:MM format (i.e. not HH:MM:SS). I am using CF8. Thanks a bunch! you could give 2 dropdowns, one for hours, one for minutes. but really, without more to go on, it's hard to

Re: The value returned from the CheckPassword function is not of type query.

2008-07-07 Thread Charlie Griefer
On Mon, Jul 7, 2008 at 9:57 AM, Phillip Vector [EMAIL PROTECTED] wrote: I have the following code.. cfinvoke component=FHCcfc.Queries method=CheckPassword returnvariable=Check/cfinvoke in the cfc, I have.. cffunction name=CheckPassword returntype=query cfstoredproc

Re: Is there a way to do this?

2008-07-07 Thread Charlie Griefer
something like: select name=city option value=#cityID#cfif form.city is cityID selected=selected/cfif#city#/option /select you'll probably have to throw a cfparam name=form.city default= / out there for the initial form display. getting the 2nd select to display the appropriate cities will

Re: The value returned from the CheckPassword function is not of type query.

2008-07-07 Thread Charlie Griefer
if i'm understanding what you're asking... a cffunction doesn't have to return a value. just set the returntype=void and omit a cfreturn / value. however, sometimes on things like inserts/updates, it's advisable to return a boolean based on whether or not the insert/update succeeded (using

Re: Just a little cfcase tip...

2008-07-05 Thread Charlie Griefer
On Sat, Jul 5, 2008 at 7:02 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Tip of the Day... When using multiple values with CFCASE, e.g., cfcase value = 1,2,3 don't put a space after the comma in the value list. This works: cfcase value = red,blue,green This doesn't: cfcase value = red,

Re: cfmail cc doesn't work

2008-07-03 Thread Charlie Griefer
explain doesn't work? error? no email at all? just no email to the cc'd address? check the undeliverable mail folder ( under your CF directory in mail/undelivr ). also check the log files. On Thu, Jul 3, 2008 at 2:13 PM, Richard Steele [EMAIL PROTECTED] wrote: Why doesn't this work?

Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
for grins, try this: cfset sendEmail = #getproducts.Email[1]# On Tue, Jul 1, 2008 at 10:20 AM, Rick King [EMAIL PROTECTED] wrote: I've set up an email form (with a captcha) that will submit an email to a seller on my website. The TO attribute is simply a query variable. But for some reason,

Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
directly *after* the cfif error is , do a cfdump var=#sendEmail#cfabort /. is the value there? is it what you expected? On Tue, Jul 1, 2008 at 11:32 AM, Rick King [EMAIL PROTECTED] wrote: hmm...that didn't seem to work. As soon as I hit the submit button on the form (and don't fill in the

Re: Simple cfmail driving me crazy!

2008-07-01 Thread Charlie Griefer
oooh good catch. few ways to do it. you could stick it in the form in a hidden field, or you can append it to the form's action. form action=test2.cfm?prodID=#URL.prodID# method=post if you go the hidden form field route, i did a quickie blog post a couple weeks back on form/URL vars...

Re: Any way to make this query work like this?

2008-06-30 Thread Charlie Griefer
Aye. I had replied before your followup :) On Sun, Jun 29, 2008 at 10:43 PM, James Holmes [EMAIL PROTECTED] wrote: Agreed, hence my followup post. On Mon, Jun 30, 2008 at 1:10 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Sun, Jun 29, 2008 at 10:07 PM, James Holmes [EMAIL PROTECTED] wrote

Re: String format issue

2008-06-30 Thread Charlie Griefer
seems to me that if you're inserting Message Here with *every* insert... might not want to insert it at all. Just display it on the output page :) Message Here: cfoutput#myQuery.memo#/cfoutput On Mon, Jun 30, 2008 at 9:22 AM, Roberto Perez [EMAIL PROTECTED] wrote: Charlie Griefer wrote

Re: String format issue

2008-06-30 Thread Charlie Griefer
Faircloth [EMAIL PROTECTED] wrote: What about using br? Message herebr#getRecord_qry.memo# Rick -Original Message- From: Roberto Perez [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 12:22 PM To: CF-Talk Subject: Re: String format issue Charlie Griefer wrote: (cfqueryparam

Re: Any way to make this query work like this?

2008-06-29 Thread Charlie Griefer
WHERE p.city IN cfqueryparam value=#session.approved_cities# list=yes cfsqltype=cf_sql_varchar / On Sun, Jun 29, 2008 at 9:56 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Any way to make this kind of query work? cfquery name=get_properties datasource=c21ar

Re: Any way to make this query work like this?

2008-06-29 Thread Charlie Griefer
On Sun, Jun 29, 2008 at 10:07 PM, James Holmes [EMAIL PROTECTED] wrote: select p.street_number, p.street_name, p.city from properties p where p.city in (#session.approved_cities#) Although you should use cfqueryparam. without the cfqueryparam would probably need

Re: String format issue

2008-06-27 Thread Charlie Griefer
(cfqueryparam value=#getRecord_qry.memo# cfsqltype=cf_sql_varchar /) On Fri, Jun 27, 2008 at 1:59 PM, Roberto Perez [EMAIL PROTECTED] wrote: Hi all, I do not know what keywords I could use to investigate this in the archives, so I'll describe the issue and hopefully you'll be able to tell be

Re: Email on behalf of

2008-06-26 Thread Charlie Griefer
use the replyTo attribute of cfmail ? On Thu, Jun 26, 2008 at 10:16 AM, James Wolfe [EMAIL PROTECTED] wrote: I sometimes get email where the from reads something like: Yahoo Groups on behalf of Michael Dinowitz where the specific names are obviously irrelevant. When i his reply, it goes

Re: Email on behalf of

2008-06-26 Thread Charlie Griefer
gotcha. cool. thanks for sharing the answer (lots of folks don't do that) :) On Thu, Jun 26, 2008 at 10:51 AM, James Wolfe [EMAIL PROTECTED] wrote: Reply-To is different - it doesnt show up in the from. The actual answer is to set the Sender email header (I tore apart some email headers to

Re: Code Cleaning Tool -Removing Tab characters

2008-06-26 Thread Charlie Griefer
On Thu, Jun 26, 2008 at 12:50 PM, Will Tomlinson [EMAIL PROTECTED] wrote: The only thing I'm worried about now is bringing down the server. lol! I wouldn't worry about it. I have every confidence in you that you can bring down the server. -- A byte walks into a bar and orders a pint.

Re: Trying to read a text file of data and input into db...

2008-06-25 Thread Charlie Griefer
On Wed, Jun 25, 2008 at 8:47 PM, Rick Faircloth [EMAIL PROTECTED] wrote: I think I see what's happening... when the file is read with cffile, the variable, hmls_offices, apparently has all the chr(9)'s, chr(10)'s, and chr(13)'s stripped out. those characters aren't rendered by the browser, so

Re: Simulate click on ListBox down arrow

2008-06-24 Thread Charlie Griefer
On Tue, Jun 24, 2008 at 11:59 AM, Walter Conti [EMAIL PROTECTED] wrote: Although the purpose of a listbox is to initially hide the options, I would like to drop, open, the select element onFocus(). Any way of doing it with JS, Java? Thanks for helping. select name=foo id=foo

Re: Simulate click on ListBox down arrow

2008-06-24 Thread Charlie Griefer
Hi Walter: Sorry, I misunderstood you. I thought you were asking if there was a way to pre-select a given option. Still not sure I fully understand. Is this to allow users to select multiple options? Because otherwise the functionality you're after is the default behavior of the select

<    1   2   3   4   5   6   7   8   9   10   >