Re: Feeling Noobish

2009-10-26 Thread Francois Levesque
Hey Brett, The only things cfqueryparam does is pretty much escape single quotes and bind the strings as parameters, preventing injection attacks. If you want to replace underscores with spaces you will have to do it manually (like you did ;)). hth Francois Lévesque on the road On 2009-10-26,

Re: Ok...I give...what's wrong with this code?

2009-10-20 Thread Francois Levesque
You're using imagesW200 in your cffile replace. This is a query object (which you're looping against). You would need to use it's columns to get the correct value. Francois Levesque http://blog.critical-web.com/ On Tue, Oct 20, 2009 at 2:02 PM, Rick Faircloth r...@whitestonemedia.comwrote

Re: Sending XML Post via cfhttp

2009-10-19 Thread Francois Levesque
You shouldn't have a cfsavecontent in there. Just use the xml variable (declared in your cfxml tag) in your cfhttp call. Francois Lévesque on the road On 2009-10-19, at 8:22, Chuka Anene anene.quor...@yahoo.com wrote: cfset server=http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx

Re: Sending XML Post via cfhttp

2009-10-19 Thread Francois Levesque
. This was possible in ColdFusion 2.0 but creates an error in later versions. Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Francois Levesque cfab...@gmail.com To: cf-talk cf-talk@houseoffusion.com

Re: Sending XML Post via cfhttp

2009-10-19 Thread Francois Levesque
recipients gsm messageId=clientmsgID12347032696113/gsm /recipients /SMS /EngineDoc /EngineDocList /XML /cfxml cfhttp method=post url=#server# cfhttpparam type=xml value=#toString( XML )# name=anything /cfhttp Francois Levesque

Re: (ot) Detect OS and CPU Architecture

2009-09-26 Thread Francois Levesque
This has gone on for far too long. This kind of behavior / language is completely inappropriate. People come to this list to learn CF and ask for help, not to be witnesses to this school-yard level of bickering and insulting. If you have nothing good to say in response to someone's post, please

Re: (ot) Detect OS and CPU Architecture

2009-09-26 Thread Francois Levesque
The problem with that reasoning is that this list is also available offline and is indexed by search engines. Most people won't know the rest of the story and could interpret it as the norm. Francois Levesque http://blog.critical-web.com/ On Sat, Sep 26, 2009 at 11:27 PM, Matt Quackenbush

Re: (ot) Detect OS and CPU Architecture

2009-09-26 Thread Francois Levesque
Obviously by offline I meant ONline, it must be the time of day (or night, whatever) Francois Levesque http://blog.critical-web.com/ On Sat, Sep 26, 2009 at 11:30 PM, Francois Levesque cfab...@gmail.comwrote: The problem with that reasoning is that this list is also available offline

Re: Form Output Iteration/Looping Question

2009-09-23 Thread Francois Levesque
You could always use bracket notation: form[vendor_id#i#], where i is the index of your iteration. On 2009-09-23, at 11:05, patrick buch patrick.b...@verizon.com wrote: Hi, Thank you for taking a minute to look at my post... In the form output section below, I'm wondering how to

Re: url-write and global error handling

2009-09-05 Thread Francois Levesque
*sigh* this isn't funny anymore... Sent from my iPhone On 2009-09-05, at 12:25, Don L do...@yahoo.com wrote: I've REPEATEDLY asked this scumbag, to f off! Were the being born of a human mother it would know what to do. List manager and everyone else, my apologies for the fact that

Re: Illudium PU36, queryRowToStruct?

2009-08-16 Thread Francois Levesque
on success or false on error. The object's properties are still available in the bean through the get*X* methods. hth, Francois Levesque http://blog.critical-web.com/ On Sun, Aug 16, 2009 at 1:56 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: Hi, Thank you to everyone on house of fusion

Re: valueList not giving me what i want.. quick look

2009-08-11 Thread Francois Levesque
Valuelist returns all the results of the query, so you don't need cfoutput query=: aid: cfoutput#valueList(getAce.aid)#/cfoutput Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:17 AM, Paul Ihrig pih...@gmail.com wrote: i know i know this. but it escapes me

Re: valueList not giving me what i want.. quick look

2009-08-11 Thread Francois Levesque
The valuelist returns all the values in that column, regardless of any cfoutput group used. You might want to use a query of query to get the values for that name, and then use valuelist on that new query. Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:46 AM, Paul

Reading / writing ANSI escaped strings

2009-08-05 Thread Francois Levesque
again to save them back in the file. Any ideas? Francois Levesque http://blog.critical-web.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive

Re: Reading / writing ANSI escaped strings

2009-08-05 Thread Francois Levesque
Paul, This is awesome. Thanks for the tip! Francois Levesque http://blog.critical-web.com/ On Wed, Aug 5, 2009 at 9:37 AM, Paul Hastings p...@sustainablegis.comwrote: Francois Levesque wrote: I'm trying to build a web interface to an i18n resource bundle. The problem ah a man after my

Re: Converting Year to Integer

2009-07-24 Thread Francois Levesque
You'll need some hash signs around that currYear variable in your cfloop: CFLOOP index=yearCnt from='2000' to='#currYear#' tr tdCFOUTPUT#yearCnt#/CFOUTPUT/td /tr /cfloop Francois Levesque http://blog.critical-web.com/ On Fri, Jul 24, 2009 at 9:31 AM, N K neetukais...@gmail.com wrote: I am

Re: Converting Year to Integer

2009-07-24 Thread Francois Levesque
cfset currYear= Year((now())) cfset currYear=int(currYear) CFLOOP index=yearCnt from='2000' to='#currYear#' tr tdCFOUTPUT#yearCnt#/CFOUTPUT/td /tr /cfloop is working fine on my end. If you're still getting an error there must be a typo somewhere. Francois Levesque http://blog.critical-web.com

Re: getDirectoryFromPath Question

2009-07-20 Thread Francois Levesque
Are you specifying a file name? I believe that comma is part of the phrase, and not actually in the variable. Francois Levesque http://blog.critical-web.com/ On Mon, Jul 20, 2009 at 9:23 AM, Hunsaker, Michael Scott mhuns...@indiana.edu wrote: Hello - I've noticed something strange when

Re: iif

2009-07-20 Thread Francois Levesque
IIF is a ColdFusion method, you can't use it in SQL like that. What you're probably looking for is CASE: CASE WHEN u.userid = s.lead_mgr THEN u.first ELSE s.lead_note END AS leadMgr Francois Levesque http://blog.critical-web.com/ On Mon, Jul 20, 2009 at 9:31 AM, RamaDevi Dobbala ramadobb

Re: Passing a query object to a CFC and then using that for a query of queries?

2009-07-20 Thread Francois Levesque
BY #arguments.orderby# /cfquery cfreturn getData /cffunction Should work. Francois Levesque http://blog.critical-web.com/ On Mon, Jul 20, 2009 at 1:00 PM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: I'm stuck. Actually, I'm probably just being stupid. I want to pass a query object into a CFC

Re: cfif help

2009-07-13 Thread Francois Levesque
You can try something like this: cfif listFind( 1,2, type ) a href= ... /a /cfif or, a more verbose way, but it can end up being much longer if you add possibilities: cfif type EQ 1 OR type EQ 2 a href= ... /a /cfif Francois Levesque http://blog.critical-web.com/ On Mon, Jul 13, 2009

Re: cfif help

2009-07-13 Thread Francois Levesque
Juste replace type by schoolTypeID cfif listFind( 1,2, schoolTypeID ) a href= ... /a /cfif or, a more verbose way, but it can end up being much longer if you add possibilities: cfif schoolTypeID EQ 1 OR schoolTypeID EQ 2 a href= ... /a /cfif Francois Levesque http://blog.critical-web.com

Re: script.js file inside cfoutput

2009-07-10 Thread Francois Levesque
=#anchorGo to this section/a /cfoutput This would not: cfoutput a href=##anchorGo to this section/a /cfoutput Francois Levesque http://blog.critical-web.com/ On Fri, Jul 10, 2009 at 8:15 AM, RamaDevi Dobbala ramadobb...@gmail.comwrote: hi frnds, i have a problem like cfoutput . . .Here i

Re: Reality check

2009-07-07 Thread Francois Levesque
Is the app installed at the same place than on his machine relative to the root? The error seems to say that the object isn't returning in the right type, probably because it's missing the path (or mapping). Francois Levesque http://blog.critical-web.com/ On Tue, Jul 7, 2009 at 12:24 PM

Re: Sitewide Error Handler and IFrames

2009-06-09 Thread Francois Levesque
Is the site-wide error template displayed when you hit the URL of the iframe directly? Francois Levesque http://blog.critical-web.com/ On Tue, Jun 9, 2009 at 4:53 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I am not seeing signs of that Dave. That is what is odd. One would

Re: CFHTTP Problem - maybe with URL

2009-06-03 Thread Francois Levesque
Hi Jerry, If you go to the address in the browser, do you get the expected result? Francois Levesque http://blog.critical-web.com/ On Wed, Jun 3, 2009 at 1:25 PM, Gerald Weir malleth...@att.net wrote: Hello, Running CF8 on Win2003/IIS. I have the following simple code to check a value

Re: Invalid ColdFusion 8 License

2009-04-23 Thread Francois Levesque
Are you sure you checked developper and not trial when you installed? On 4/23/09, Don L do...@yahoo.com wrote: My developer edition cf8 starts fine and it seems working, url, http://localhost/blabla. But this morning I noticed that it's not working as expected, so, looked into the log and

Re: Setting the index number to a variable

2009-04-21 Thread Francois Levesque
cfloop from=1 to=12 index=ii Query cfset variables[ MTDPREV_ii ] = #MTD_PREV_REPORT.MTDPREV# / /cfloop hth Francois Levesque http://blog.critical-web.com/ On Tue, Apr 21, 2009 at 11:28 AM, Keith McGee kpmc...@frontiernet.netwrote: I am looping a query getting monthly numbers

Re: BOLT!

2009-04-17 Thread Francois Levesque
I also haven't received any news, but if it's anything like with other Adobe NDA's anyone in the beta wouldn't be able to tell you that they are :P. Francois Levesque http://blog.critical-web.com/ On Fri, Apr 17, 2009 at 9:07 AM, Jose Diaz bleached...@gmail.com wrote: Hello All, I have

Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread Francois Levesque
it pretty much for all my dynamic values in my queries. It just helps me sleep better at night. hth Francois Levesque http://blog.critical-web.com/ On Thu, Apr 16, 2009 at 10:49 AM, BobSharp bobsh...@ntlworld.com wrote: I have been searching for some explanation of the different Types used

Re: Newbie ... CFSQLTYPE of CFQueryParam

2009-04-16 Thread Francois Levesque
multiple cfqueryparam statements: cfquery ... declare @p1 nvarchar(50) set @p1 = cfqueryparam cfsqltype=cf_sql_varchar value=#userSuppliedValue# / select * from tableName where column = @p1 and othercolumn @p1 /cfquery Francois Levesque http://blog.critical-web.com/ On Thu, Apr 16, 2009 at 2:29

Re: would you consider this a bug, CF8

2009-04-03 Thread Francois Levesque
where we'd need them, but then again we're used to sacrifice some features to ensure the more important ones are left in. Francois Levesque http://blog.critical-web.com/ On Fri, Apr 3, 2009 at 8:51 AM, Ras Tafari rastaf...@gmail.com wrote: im just saying, that BEGIN and END of month are KNOWN

Re: would you consider this a bug, CF8

2009-04-02 Thread Francois Levesque
' / cfoutput cfloop from=1 to=6 index = i cfset date2 = dateAdd('m', i, date1) / #dateFormat(date2,'mm')#/#daysInMonth( date2 )#/#dateFormat(date2,'')#br / /cfloop /cfoutput Francois Levesque http

Re: would you consider this a bug, CF8

2009-04-02 Thread Francois Levesque
, or increment by month and keep day. Francois Levesque http://blog.critical-web.com/ On Thu, Apr 2, 2009 at 11:28 AM, Tony tonyw...@gmail.com wrote: couple things... 1. its easy as pie to code around, i was actually doing first of next month, less 1 day... which works as well as your idea

Re: Concatenate Multiple Lines of Code

2009-03-23 Thread Francois Levesque
If you're trying to use line feeds to space out your code, there is no actual character for that in ColdFusion. However, CF is smart enough to keep reading until the closing tag, so this cfset foo = bar somethingelse / Is as valid as cfset foo = bar somethingelse / Francois Levesque

Re: List of CfQueryParam cfsqltypes for TYPE_NAME as returned by cfdbinfo.

2009-03-22 Thread Francois Levesque
Try this for MSSQL: http://www.cfquickdocs.com/cf8/#cfqueryparam. I have no idea why MySQL isn't on there, but it should at least get you started. Francois Levesque http://blog.critical-web.com/ On Sun, Mar 22, 2009 at 7:38 PM, Gerald Guido gerald.gu...@gmail.comwrote: Does anyone have

Re: I give...anything inherently wrong with this code that would cause this error?

2009-03-06 Thread Francois Levesque
argumentCollection in the cffunction tag? I don't see that in the docs. You can use it when calling the function, but not while defining it. Maybe that's what's throwing the weird error. Francois Levesque http://blog.critical-web.com/ On Fri, Mar 6, 2009 at 1:28 PM, Rick Faircloth r

Re: Googlebot got me good last night...

2009-02-19 Thread Francois Levesque
the user (or bot) to the appropriate page. Francois Levesque http://blog.critical-web.com/ On Thu, Feb 19, 2009 at 3:09 PM, Les Mizzell lesm...@bellsouth.net wrote: This happened on a small site with a user admin system that's password protected. Seems Googlebot managed to get into the admin system

Re: Using FileExists function in a CFIF tag

2009-02-03 Thread Francois Levesque
FileExists takes an absolute path as argument: http://www.cfquickdocs.com/cf8/#FileExists So you'd need to pass something like D:\wwwroot\images\photo\ Photo89255-2.jpeg. Francois Levesque http://blog.critical-web.com/ On Mon, Feb 2, 2009 at 1:24 PM, Dave Long d...@northgoods.com wrote: I

Re: Acces a record count in javascript

2009-02-03 Thread Francois Levesque
Hi Jason, If your javascript block is within cfoutput tags, you can just put #myquery.recordcount# in there. Francois Levesque http://blog.critical-web.com/ On Tue, Feb 3, 2009 at 5:47 AM, Jason Congerton ja...@jasoncongerton.co.ukwrote: Hi I need to access a recordcount from within

Wrong label appearing with cfchart

2009-02-03 Thread Francois Levesque
=20 / /cfchartseries /cfchart Normally, the legend would have one item: label 1, corresponding to the one and only series. However, the legend actually shows two elements in the legend: item 1 and item 2, both with the same color. Any ideas? Francois Levesque http://blog.critical-web.com

Re: Just checking

2009-01-30 Thread Francois Levesque
There was a problem with the mail server's hard drive: http://www.coldfusionjedi.com/index.cfm/2009/1/29/CFTalk-Status. Everything seems back to normal now, though. Francois Levesque http://blog.critical-web.com/ On Thu, Jan 29, 2009 at 7:58 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote

Re: ColdFusion Components: Setting dynamic arguments dynamically

2008-12-31 Thread Francois Levesque
You can actually use the session key in your argumentCollection: methodName( argumentCollection = session.NODA09_formStruct ) Enjoy! Francois Levesque http://blog.critical-web.com/ On Wed, Dec 31, 2008 at 10:37 AM, Scott Stewart saste...@email.unc.eduwrote: Here's a little more background

Re: CF Sum

2008-12-18 Thread Francois Levesque
You could use a query of query (QoQ) cfquery name=qSum dbtype=query select sum(quantity) as total_fruits from fruits /cfquery Other than that, there's looping ;) Francois Levesque http://blog.critical-web.com/ On Thu, Dec 18, 2008 at 1:46 PM, patrick buch patrick.b...@verizon.comwrote

Re: CFEclipse Show Line Numbers

2008-12-17 Thread Francois Levesque
-web.com/blog/index.cfm/2008/8/3/Enabling-Line-Numbers-In-CFEclipse-1316-On-Eclipse-Ganymede-34(shameless plug) Francois Levesque http://blog.critical-web.com/ On Wed, Dec 17, 2008 at 11:09 AM, Phillip Molaro pmol...@earthlink.netwrote: My CFEclipse doesn't have the show line numbers option. My