Re: Feeling Noobish
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, at 18:46, Brett Davis wrote: > > Or at at least that is the way I am feeling today. Consider this > piece of code, it is contained in a CFC that a user has entered in a > Search Term to look up against the database. > > > SELECT TOP #APPLICATION.MaxQueryRows# f.* > FROM field f > WHERE 0=0 > AND ( >f.field_logical_nm LIKE value="%#ARGUMENTS.SearchTerm#"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#%"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="#ARGUMENTS.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="#ARGUMENTS.SearchTerm#%"/> > ) > AND f.field_id NOT IN ( >SELECT TOP #ARGUMENTS.StartRow# f.field_ID >FROM field f >WHERE 0=0 >AND ( >f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#%"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="#ARGUMENTS.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#ARGUMENTS.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="#ARGUMENTS.SearchTerm#%"/> >) >ORDER BY f.field_logical_nm > ) > ORDER BY f.field_logical_nm > > > As it stands it the user enters in the following text as the Search > Term: _a_ the following results are returned: > cat > bat > bar > kat > > Instead of what was really expected like this: > in_a_boat > can run_a_mile > if_a_bird flies > > Ok I think you get the picture. It returns any three letter words > that contain an 'a' in the middle position instead of any phrase > that contains the '_a_' string. However this is not the behavior I > would expect using with the type set to varchar, then > again maybe this is a case of me just needing to RTFM for both > ColdFusion & T-SQL. > But to get the expect results I had to escape any underscores in the > parameter passed from the end user form turning the code into this: > > > (ARGUMENTS.SearchTerm,'_','[_]','all')/> > > (ARGUMENTS.FieldNameText,'_','[_]','all')/> > > > > SELECT TOP #APPLICATION.MaxQueryRows# f.* > FROM field f > WHERE 0=0 > AND ( >f.field_logical_nm LIKE value="%#VARIABLES.tmpSearchTerm#"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#%"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="#VARIABLES.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="#VARIABLES.SearchTerm#%"/> > ) > AND f.field_id NOT IN ( >SELECT TOP #ARGUMENTS.StartRow# f.field_ID >FROM field f >WHERE 0=0 >AND ( >f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#%"/> >OR f.field_logical_nm LIKE cfsqltype="cf_sql_varchar" value="#VARIABLES.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="%#VARIABLES.SearchTerm#%"/> >OR f.field_physical_nm LIKE cfsqltype="cf_sql_varchar" value="#VARIABLES.SearchTerm#%"/> >) >ORDER BY f.field_logical_nm > ) > ORDER BY f.field_logical_nm > > > This post wasn't meant to be a tutorial, more of a 'Hey ummm this is > the way I solved this problem, but somehow it feels really really > dirty like kissing my cousin at a Sadie Hawkins dance after spiking > the punch' kind of post. I would really like to know if this is the > correct way to fix the problem and is this the way that > is truly suppose to work. > > And for those of you wondering what this query is doing and why I > would do something this cluggie, well the query itself is apart of a > records pagination resolution for a client that is running IE 6. It > was some code I saw on a blog [can't remember which one] that I > modified for my own evil purposes. > > Cheers > > > ~| Want to reach the ColdFusion community w
Re: Ok...I give...what's wrong with this code?
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 wrote:
>
> I'm getting this error message.
>
>
>
> "Complex object types cannot be converted to simple values." etc.
>
>
>
>
> The error occurred in
> D:\Inetpub\webroot\holtzmanRentals\misc\updatePhotoFilenames.cfm: line 14
>
>
> 12 :
>
> 13 :
> 14 : source =
> "d:\inetpub\current_projects\holtzmanRentals\rentalPhotos200\#imagesW200#"
>
> 15 : destination =
>
> "d:\inetpub\current_projects\holtzmanRentals\rentalPhotos200Renamed\#Replace
> (imagesW200, 'w500', '', 'all')#"
>
> 16 :
>
>
>
> from this code.why?
>
>
>
>
> directory =
> "d:\inetpub\current_projects\holtzmanRentals\rentalPhotos200"
>
> type = "file"
>
> name = "imagesW200">
>
>
>
>
>
>
>
>
>
>
>
>
> source =
> "d:\inetpub\current_projects\holtzmanRentals\rentalPhotos200\#imagesW200#"
>
> destination =
>
> "d:\inetpub\current_projects\holtzmanRentals\rentalPhotos200Renamed\#Replace
> (imagesW200, 'w500', '', 'all')#"
>
> nameConflict = "overwrite" >
>
>
>
>
>
>
>
>
>
>
>
>
>
> Isn't the above cffile statement essentially the same as the following
> statement, which works?
>
>
>
>
>source =
> "#expandPath('/imprint-warehouse/images/#cffile.serverfile#')#"
>
>destination =
> "#expandPath('/imprint-warehouse/images/#Replace(cffile.serverfile, ' ',
> '_', 'All')#')#">
>
>
>
>
>
> Thanks for any feedback.
>
>
>
> Rick
>
>
>
>
>
> ---
>
> "Those who hammer their guns into plows will plow for those who do not." -
> Thomas Jefferson
>
>
>
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327396
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
This doesn't work? I was able to output the string to the screen, so cfhttp should know what to do with it. http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx";> 1.0 SMS Quorium Anene Q-sms Inc. Testing XMl Post 1 longSMS 2347032696113 Francois Levesque http://blog.critical-web.com/ On Mon, Oct 19, 2009 at 8:48 AM, Anene Isioma Wealth < anene.quor...@yahoo.com> wrote: > > same error bro: > > Error Occurred While Processing Request > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate expression > result as a simple value, however, the result cannot be converted to a > simple value. Simple values are strings, numbers, boolean values, and > date/time values. Queries, arrays, and COM objects are examples of complex > values. > The most likely cause of the error is that you are trying to use a complex > value as a simple one. For example, you might be trying to use a query > variable in a tag. 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 > To: cf-talk > Sent: Mon, October 19, 2009 1:36:50 PM > Subject: Re: Sending XML Post via cfhttp > > > Oops, forgive the brain fart. XML is a complex value, you need to > convert it to a string first. All you need to do is wrap your xml > variable with toString() and it should work. > > Francois Lévesque on the road > > On 2009-10-19, at 8:31, Anene Isioma Wealth > wrote: > > > > > even worse, after removing the cfsave tag, i get this error: > > > > Complex object types cannot be converted to simple values. > > The expression has requested a variable or an intermediate > > expression result as a simple value, however, the result cannot be > > converted to a simple value. Simple values are strings, numbers, > > boolean values, and date/time values. Queries, arrays, and COM > > objects are examples of complex values. > > The most likely cause of the error is that you are trying to use a > > complex value as a simple one. For example, you might be trying to > > use a query variable in a tag. 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 > > To: cf-talk > > Sent: Mon, October 19, 2009 1:23:54 PM > > Subject: Re: Sending XML Post via cfhttp > > > > > > 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 wrote: > > > >> > >> > >> "> > >> > >> > >> > >> > >> > >> 1.0 > >> > >> SMS > >> > >> > >> > >> Quorium > >> Anene > >> > >> > >> Q-sms Inc. > >> Testing XMl Post > >> 1 > >> longSMS > >> > >> > >> 2347032696113 > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> This above code gives this error: > >> > >> An error occured while Parsing an XML document. > >> > >> Premature end of file. > >> > >> > >> Does anyone have any ideas? > >> > >> > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sending XML Post via cfhttp
Oops, forgive the brain fart. XML is a complex value, you need to convert it to a string first. All you need to do is wrap your xml variable with toString() and it should work. Francois Lévesque on the road On 2009-10-19, at 8:31, Anene Isioma Wealth wrote: > > even worse, after removing the cfsave tag, i get this error: > > Complex object types cannot be converted to simple values. > The expression has requested a variable or an intermediate > expression result as a simple value, however, the result cannot be > converted to a simple value. Simple values are strings, numbers, > boolean values, and date/time values. Queries, arrays, and COM > objects are examples of complex values. > The most likely cause of the error is that you are trying to use a > complex value as a simple one. For example, you might be trying to > use a query variable in a tag. 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 > To: cf-talk > Sent: Mon, October 19, 2009 1:23:54 PM > Subject: Re: Sending XML Post via cfhttp > > > 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 wrote: > >> >> >> "> >> >> >> >> >> >> 1.0 >> >> SMS >> >> >> >> Quorium >> Anene >> >> >> Q-sms Inc. >> Testing XMl Post >> 1 >> longSMS >> >> >> 2347032696113 >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> This above code gives this error: >> >> An error occured while Parsing an XML document. >> >> Premature end of file. >> >> >> Does anyone have any ideas? >> >> > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending XML Post via cfhttp
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 wrote: > > http://www.infobip.com/AddOn/SMSService/XML/XMLInput.aspx > "> > > > > > > 1.0 > > SMS > > > >Quorium >Anene > > >Q-sms Inc. >Testing XMl Post >1 >longSMS > > >2347032696113 > > > > > > > > > > > > > > > This above code gives this error: > > An error occured while Parsing an XML document. > > Premature end of file. > > > Does anyone have any ideas? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Detect OS and CPU Architecture
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 wrote: > 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 > wrote: > >> >> I know I shouldn't, but I'm going to have to respectfully disagree with G! >> on this one. :D >> >> If "this sort of behavior" were the norm, then I could and would fully >> agree. But we're talking about one particular poster who just happens to >> do >> it on every list he's on. I see it as a source of entertainment for those >> who are still in possession of at least half their faculties. :D >> >> >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Detect OS and CPU Architecture
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 wrote: > > I know I shouldn't, but I'm going to have to respectfully disagree with G! > on this one. :D > > If "this sort of behavior" were the norm, then I could and would fully > agree. But we're talking about one particular poster who just happens to > do > it on every list he's on. I see it as a source of entertainment for those > who are still in possession of at least half their faculties. :D > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Detect OS and CPU Architecture
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 do everyone a favor and keep it to yourself. If you feel like you need to insult someone for whatever reason (valid or not) then please do so off-list. Let's try to at least keep this pg-13, can we? Francois Lévesque on the road On 2009-09-26, at 19:29, Don L wrote: > > You are a disgusting and despicable being and your rigidness is > beyond words. > > The question was to detect a user's OS and its CPU architecture not > the server's. Do you know how my app is run??? Got it now? f > off! Told you a 100 times! f off! I'll hunt you down one day, you > fker! > >> Common sense would dictate that you just maybe want to get this info >> from a system that actually runs in the os and not a client-side >> solution. >> >> Ok so what runs on pretty much every OS and integrates with >> coldfusion? >> >> Well hopefully even you can figure it out but here is the variables >> you'd used: >> >> os.name The name of OS name >> os.arch The OS architecture >> os.version The version of OS > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form Output Iteration/Looping Question
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 wrote: > > Hi, > Thank you for taking a minute to look at my post... > > In the form output section below, I'm wondering how to dynamically > add the number at the end of the id (form.vendor_id* & form.nvc_id*). > > I should be able to loop and dynamically create the output section > below instead of hardcoding the numbers like I have. > > The ID numbera (4-19) represents the recordkey in the db. > > * FORM INPUT * > value="#vendor##item_id##description#"> > required="yes" size="3"> > > * FORM OUTPUT * > > Plant: #form.plant# > #form.vendor_id4##form.nvc_id4# > #form.vendor_id5##form.nvc_id5# > #form.vendor_id6##form.nvc_id6# > #form.vendor_id7##form.nvc_id7# > #form.vendor_id8##form.nvc_id8# > #form.vendor_id9##form.nvc_id9# > #form.vendor_id10##form.nvc_id10# > #form.vendor_id11##form.nvc_id11# > #form.vendor_id12##form.nvc_id12# > #form.vendor_id13##form.nvc_id13# > #form.vendor_id14##form.nvc_id14# > #form.vendor_id15##form.nvc_id15# > #form.vendor_id16##form.nvc_id16# > #form.vendor_id17##form.nvc_id17# > #form.vendor_id18##form.nvc_id18# > #form.vendor_id19##form.nvc_id19# > > > Hope you have all the info you need. If you have any questions, > please ask. Thank you again for looking at this post. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: url-write and global error handling
*sigh* this isn't funny anymore... Sent from my iPhone On 2009-09-05, at 12:25, Don L 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 this note has to be public. > The scumbag's intention is obviously evil, that is, to try to make > me look bad by twisting facts and what not. > >> He did ask this on the railo list, and then got his ass handed to >> him >> again >> >> Einstein's ? isn't about url rewriting at all which I told him before >> but since we all know how well he listens, I guess when you get >> stomped on so many times this happens. >> >> His ? is how to change/hide the railo admin url location so the >> public >> can't get to it. The only part of this that's url re-wrting is that's >> what people suggest to do to hide the admin. >> >> If I was him I would probably want to hide the admin as well since >> his >> password is probably either "duck duck" or "goose". >> >> 1) disable url-write across board for Resin web server >> Why on frickin gods green earth would this be a good idea? >> Again what you are asking for REQUIRES URL RE-WRITING you twit >> >> 2) global error handling >> Well it works for the rest of us, maybe you just don't know wtf you >> are doing. > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Illudium PU36, queryRowToStruct?
That looks more like a DAO than a gateway.
Notice that the read method takes in an adminUsers object. At the end of the
method it initializes it with what the query returned, so you can access
it's properties from the calling page.
Also, typically an update method will only need to return true 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 wrote:
>
> Hi,
>
> Thank you to everyone on house of fusion who has been very helpful so far
> with my stupid questions. I have another ;)
>
> I was looking at some code I generated for a gateway by Illudium PU36. The
> read and update functions do not make any sense in that it does not have any
> return for me to get! However I noticed a function called "queryRowToStruct"
> I am assuming this has something to do with how I can return the query or
> access the query from my service layer, however this is a private function
> so my service layer cannot access it if this was true. I am just confused
> because without a way to return the query whats the point in these
> functions?
>
> Are they wrong, or should I give them a return? or I am missing the
> purpose?
>
> Thanks Glyn
>
> -
>
>
> returntype="void">
> required="true" />
>
>
>
> username="#variables.dsnBean.getusername()#"
> password="#variables.dsnBean.getpassword()#">
>
>SELECT
>
>adminId,
>
>firstname,
>
>surname,
>
>email,
>
>username,
>
>password,
>
>role,
>
>lastLogin,
>
>flag,
>
>IP,
>
>userLog,
>
>createddatetime
>
>FROMadminusers
>
>WHERE adminId = value="#arguments.adminusers.getadminId()#" CFSQLType="cf_sql_integer" />
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> returntype="struct">
>
>
>
>
>
>
>
>/**
>
> * Makes a row of a query into a structure.
>
> *
>
> * @param query The query to work with.
>
> * @param rowRow number to check. Defaults to
> row 1.
>
> * @return Returns a structure.
>
> * @author Nathan Dintenfass (
> nat...@changemedia.com)
>
> * @version 1, December 11, 2001
>
> */
>
>//by default, do this to the first row of the query
>
>var row = 1;
>
>//a var for looping
>
>var ii = 1;
>
>//the cols to loop over
>
>var cols = listToArray(qry.columnList);
>
>//the struct to return
>
>var stReturn = structnew();
>
>//if there is a second argument, use that for the
> row number
>
>if(arrayLen(arguments) GT 1)
>
>row = arguments[2];
>
>//loop over the cols and build the struct from the
> query row
>
>for(ii = 1; ii lte arraylen(cols); ii = ii + 1){
>
>stReturn[cols[ii]] = qry[cols[ii]][row];
>
>}
>
>//return the struct
>
>return stReturn;
>
>
>
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325485
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
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 Ihrig wrote: > > i need the group on the out side because i am grouping by a name that > gets trimed from many similar names and such. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: valueList not giving me what i want.. quick look
Valuelist returns all the results of the query, so you don't need cfoutput query="": aid: #valueList(getAce.aid)# Francois Levesque http://blog.critical-web.com/ On Tue, Aug 11, 2009 at 11:17 AM, Paul Ihrig wrote: > > i know i know this. but it escapes me... > > just a cfoutput inside my loop gives me exactly the list i want.. > but i need the , commas.. > > > aid: #getAce.aid# > > > Mounting Panel aid: > > 1811922492502512522532542552562572603203213223233243253263273283293303313323332435 > Wallmount Brackets aid: 36 > > > this loops through to many times but has commas.. and is wrong.. > > > aid: #valueList(getAce.aid)# > > > Mounting Panel aid: > > 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,---you > get the idea--- > Wallmount Brackets aid: > > 181,192,249,250,251,252,253,254,255,256,257,260,320,321,322,323,324,325,326,327,328,329,330,331,332,333,24,35,36 > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading / writing ANSI escaped strings
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 wrote: > > Francois Levesque wrote: > > I'm trying to build a web interface to an i18n resource bundle. The > problem > > ah a man after my own heart ;-) > > try this: > > http://www.sustainablegis.com/unicode/resourceBundle/javaRB.cfm > > but if you want a ready made, web accessible rb manager try jason sheedy's > rbManager: http://www.jmpj.net/jason/page.cfm/RbMan2 > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading / writing ANSI escaped strings
Hi all, I'm trying to build a web interface to an i18n resource bundle. The problem is that the values in these files are ANSI escaped: G\u00E9rer les r\u00F4les instead of Gérer les rôles. I need a way to unescape these strings so I can display them in an input field and then ANSI escape them 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: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converting Year to Integer
#yearCnt# 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/ On Fri, Jul 24, 2009 at 9:47 AM, N K wrote: > > Yes thats a typo in my email.Adding ## sign does not help > > The error coming up is > Attribute validation error for the CFLOOP tag. > The value of the TO attribute is invalid. The value cannot be converted to > a numeric because it is not a simple value.Simple values are booleans, > numbers, strings, and date-time values. > > > Thank You > NK > > >Is Year((now)) a typo in your email? > > > >If not, try Year(Now()) and you will need the #'s in the to attribute of > >cfloop. > > > >Adrian > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converting Year to Integer
You'll need some hash signs around that currYear variable in your cfloop: #yearCnt# Francois Levesque http://blog.critical-web.com/ On Fri, Jul 24, 2009 at 9:31 AM, N K wrote: > > I am looping the records starting from the Year 2000 to current year. > But some how the the CFLOOP gives me an error stating "Can not convert into > number" > > I tried the following ,any idea how to fix the issue:-- > > > > > > > > > #yearCnt# > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing a query object to a CFC and then using that for a query of queries?
Hi Pete, You don't need the hash signs around your table name in a QoQ: SELECT * FROM arguments.dataIn ORDER BY #arguments.orderby# Should work. Francois Levesque http://blog.critical-web.com/ On Mon, Jul 20, 2009 at 1:00 PM, Pete Ruckelshaus wrote: > > I'm stuck. Actually, I'm probably just being stupid. > I want to pass a query object into a CFC and then use query of queries to > manipulate that query object. > > Here's the contents of my db.cfc file: > > > > > SELECT top 100 * > FROM person.contact > > > > > > > > SELECT * > FROM #arguments.dataIn# > ORDER BY #arguments.orderby# > > > > > > And here's the important stuff from my calling page: > > returnvariable="getContacts"> > returnvariable="getContacts1"> > > > > > The problem is that the CFC is throwing a "Complex object types cannot be > converted to simple values." error. How do I get the sortDataFromQry > function to see dataIn as a recordset? > > Thanks > > Pete > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: iif
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 wrote: > > >select s.office_name,u.userid,s.lead_mgr,iIf(u.userid = s.lead_mgr, > u.first , s.lead_note ) as leadMgr >from sourcebook_1 s ,user_info u >where s.active = 1 >and office_id not in(36,37,38,73) >order by s.office_number > > > is this is correct comparision,please tell me > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: getDirectoryFromPath Question
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 using the getDirectoryFromPath function
> and wanted to see if anyone else has seen this. It's probably something I'm
> doing incorrectly. Here's what I'm doing:
>
> In the application.cfc, I created an application variable to hold the
> physical path of the web site files. Instead of manually entering the
> physical path (G:\ Inetpub\wwwroot), I used the getDirectoryFromPath
> function like this:
>
> #getdirectoryfrompath(expandpath('*.*'))#
>
> That returns the same thing. However, when I use the function above as the
> "destination" in the CFFILE function, it returns an error. The error says:
>
> "The value of the attribute destination, which is currently
> G:\Inetpub\wwwroot\, is invalid."
>
> For some reason it adds a comma at the end of the physical path but I can't
> figure out why. Any ideas? I would appreciate any help.
>
> Thanks!!
>
> Mike
>
> Mike Hunsaker
> Assistant Director of Information Systems
> Kelley School of Business MBA Program
> 1275 East Tenth Street, Suite 2010
> Bloomington, IN 47405
> 812.855.7024
> mhuns...@indiana.edu<mailto:mhuns...@indiana.edu>
>
> Advance your career. Enhance your life.
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324712
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfif help
Juste replace type by schoolTypeID > > ... > > >or, a more verbose way, but it can end up being much longer if you add >possibilities: > > > ... > Francois Levesque http://blog.critical-web.com/ On Mon, Jul 13, 2009 at 10:10 AM, Steven Sprouse wrote: > > >You can try something like this: > > > > > > ... > > > > > >or, a more verbose way, but it can end up being much longer if you add > >possibilities: > > > > > > ... > > > > > >Francois Levesque > >http://blog.critical-web.com/ > > > > > > > > > >> So what if I already have a field in my database called "SchoolTypeID"? > Where do I reference that? I already pulled that field out in my query of > that database. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfif help
You can try something like this: ... or, a more verbose way, but it can end up being much longer if you add possibilities: ... Francois Levesque http://blog.critical-web.com/ On Mon, Jul 13, 2009 at 9:57 AM, Steven Sprouse wrote: > > I need help figuring out how to display a link if an ID type is 1 or 2 (as > defined in by database) but not displaying the link if the ID type is 3 or > 4. I know this should be easy, but I keep screwing it up. > > The page that I'm working from is > http://www2.ccboe.com/schoolscenters/viewschool.cfm?id=22 (just picked an > ID at random). For elementary and middle schools I want to display a School > Supply link in the resources section at the bottom. For High schools and > centers, I do not want to display that link. > > Can anyone help me? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: script.js file inside cfoutput
That's not much to work with, but my guess would be that you have an opening hash sign (#) before your javascript call and that's throwing ColdFusion off. Whenever you want to display a hash sign between tags you need to escape it like so: This would throw an error: Go to this section This would not: Go to this section Francois Levesque http://blog.critical-web.com/ On Fri, Jul 10, 2009 at 8:15 AM, RamaDevi Dobbala wrote: > > hi frnds, > > i have a problem > > like > > . > . > .Here i have my date field, > where i have to insert .js file, where ever i am insert it is not taking > the file > i am calling js function like this javascript:showID(..) > error is this > > ColdFusion was looking at the following text: > > javascript > . > . > . > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reality check
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, Phillip Vector wrote: > > As for the error message.. > > The WEEKDAYDAO argument passed to the init function is not of type > ScheduleTimeDAO. > If the component name is specified as a type of this argument, its > possible that a definition file for the component cannot be found or > is not accessible. > > The error occurred in > C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc: line 6 > Called from > C:\Webpages\VinoVisit\vv_loc\cfcs\schedules\ScheduleBuilder.cfc: > line 22 > Called from C:\Webpages\VinoVisit\vv_loc\admin\application.cfc: line 22 > > 4 : > 5 : > 6 : returntype="ScheduleDAO"> > 7 : required="true"> > 8 : required="true"> > > The main thing that makes me suspect that it's code is that I'm > accessing http://127.0.0.1/Testing/vv_loc/admin/ and it's correctly > pointing to C:\Webpages\Testing\vv_loc\cfcs\schedules\ScheduleDAO.cfc > > > On Tue, Jul 7, 2009 at 9:23 AM, Phillip Vector > wrote: > > The files were given to me as is and I was told they work fine on his > > windows dev machine. The more I think about it, the more I'm wondering > > if I don't have the files that are on the server, or his remake of it > > (he said only the admin directory works currently, but on the site, > > the non-admin files work). > > > > I'm installing a virtural machine and seeing about eliminating all > > possible issues with the server config. > > > > On Tue, Jul 7, 2009 at 9:18 AM, Nathan C. Smith > wrote: > >> > >> Don't forget about case-sensitivity of filenames. Especially on > includes and such. > >> > >>> -Original Message- > >>> From: Phillip Vector [mailto:vec...@mostdeadlygame.com] > >>> Sent: Tuesday, July 07, 2009 10:25 AM > >>> To: cf-talk > >>> Subject: Reality check > >>> > >>> > >>> Just need confirmation that I'm not losing it.. > >>> > >>> I have apache running on my dev server. A client gave me his files and > >>> I'm trying to get them set up on my local server (he is running IIS). > >>> > >>> However, after I create the mappings in CF and go to the directory > >>> that in his IIS, he has set to default to, I get a ColdFusion error > >>> (some variable is a complex variable or some such). It finds the files > >>> and the cfc as well. > >>> > >>> So.. It isn't that I'm using Apache and they are using IIS.. Right? > >>> The code is just broke. > >>> > >>> or am I missing something here? > >>> > >>> > >> > >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
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 think > that the iframe would be treated the same as any other window. Usually > when > there is an error in the handler or in any associated pages to it, you get > the error that triggered the handler in the fiorst place and then > underneath > that you get a message saying that there was an internal error...makes for > a > real PIA to debug. That was one of the first things I looked for when our > team leader pointed that out. You get the same error page that you would > get if the site wide handler was not specified. > > Eric > > On Tue, Jun 9, 2009 at 3:45 PM, Dave Watts wrote: > > > > > > Is there a reason why the iframe would not pick up the sitewide error > > > handler in the iframe and display the user friendly error page and > > instead > > > just display a standard CF error? > > > > There's nothing about iframes specifically that would cause this, no. > > Perhaps there's an error in your error page when invoked from the > > iframe? > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > > > Fig Leaf Software provides the highest caliber vendor-authorized > > instruction at our training centers in Washington DC, Atlanta, > > Chicago, Baltimore, Northern Virginia, or on-site at your location. > > Visit http://training.figleaf.com/ for more information! > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Problem - maybe with URL
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 wrote: > > Hello, > > Running CF8 on Win2003/IIS. I have the following simple code to check a > value from another server: > > URL= > " > http://server.somewhere.com/websvc/util?a=doHTMLRequest&event=workgroupstat > " >throwonerror="yes"> > > > #theContent# > > > If I change the URL to http://www.google.com or whatever I get the proper > result. The URL that is shown above returns nothing. The URL works fine. > It's a simple HTML file with the following code from which I need to pull > the agents_available data: > > Agents > Availableworkgroup:Chatagents_available:1agents_logged_in:1 > > I cannot understand why I can call any other page from the internet and put > it into my theContent variable but I can't call the one I need. Could it be > something in the structure of the URL?? > > Any ideas are appreciate. Regards, Jerry > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Invalid ColdFusion 8 License
Are you sure you checked developper and not trial when you installed? On 4/23/09, Don L 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 found the following entry: > Invalid ColdFusion 8 License > > How come? > > Also, there're some other services that I don't need, for instance, > graphing, verity, FlexAssembler, could one figure the cf8 not to run them? > I think possible via some of its config xml file, yes? If so, which one or > ones? > > Thanks. > > Don > Chunshen Li > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Setting the index number to a variable
Query hth Francois Levesque http://blog.critical-web.com/ On Tue, Apr 21, 2009 at 11:28 AM, Keith McGee wrote: > > I am looping a query getting monthly numbers. > > Running the query getting the monthly numbers then outputting then to a > variable then running the next month soon and so on, > > here is a simplified version > > > > Query > > > > > > what i want is MTDPREV_1 equals January totals MTDPREV_2 equals February > and so on > > I'm sure it is something simple I am missing. Any help would be > appreciated. > > Thanks > Keith > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BOLT!
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 wrote: > > Hello All, > > I have applied to Adobe for the Bolt beta but not heard a peep. Has anybody > had any news on when we can get to play with the new shiney toy? > > Jose Diaz > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newbie ... CFSQLTYPE of CFQueryParam
Actually, I believe cfqueryparam uses bindings, which effectively passes parameters to the SQL engine. In your example, you are still open to SQL injection attacks. However, if you need to use your value several times, you can use declare / set to define a variable in SQL, rather than using multiple cfqueryparam statements: declare @p1 nvarchar(50) set @p1 = select * from tableName where column = @p1 and othercolumn <> @p1 Francois Levesque http://blog.critical-web.com/ On Thu, Apr 16, 2009 at 2:29 PM, Jason Fisher wrote: > > And for all those reading this and using MSSQL, an inline statement would > look like this: > > > declare @p1 nvarchar(50) > > set @p1 = '#userSuppliedValue#' > > select * > from tableName > where column = @p1 > > > So, basically is creating the Declare and Set for you. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newbie ... CFSQLTYPE of CFQueryParam
Hi Bob, Check here for a list of the available options and their corresponding data types for some major SQL providers (for some reason MySQL isn't there): http://www.cfquickdocs.com/cf8/#cfqueryparam. As for your question, generally using cfqueryparam is recommended for any value that could be provided by the user. The main purpose is to eliminate SQL injection attacks by binding the parameters and preventing the use of SQL commands within the values (see http://xkcd.com/327/ for a fun example). it also provides some level of optimization. Personnally I've taken the habit of putting 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 wrote: > > I have been searching for some explanation of > the different Types used in CFQueryParam. > > understand that SCALE= is used to validate the position of decimal, > but still confused by ... FLOAT, DECIMAL, MONEY, MONEY4. > > > I am usingINSERT > do I need to use for all values ? > > > > > > -- > I am using the free version of SPAMfighter. > We are a community of 6 million users fighting spam. > SPAMfighter has removed 12962 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: would you consider this a bug, CF8
I think the issue is just making sure the engine doesn't make the assumption
for us. If I want it to add a month to the 30th, I want the default behavior
be that it adds a month, and doesn't assume I want the end of the next
month.
Sure, another incrementer would be great for the couple of cases 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 wrote:
>
> im just saying, that BEGIN and END of month are KNOWN things...
> calculable things.
> constants if you will. why wouldnt a constant be available as a thing
> i can know, the java
> engine should know this... i realize i can code around it, hell i can
> code around ANYTHING
> but that does NOT mean its a good thing to code around.
>
> right?
>
> On Fri, Apr 3, 2009 at 6:29 AM, Azadi Saryev wrote:
> >
> > dateAdd('m', i, date1)
> > returns same DATE i months away. NOT same weekday, or same 3rd Thursday,
> or even end of month date - just same DATE i months away.
> >
> >> so, with that, id say a new incrementer of precise calendar month would
> be best.
> >
> > why, when you can easily get the desired result using other already
> available date functions?
> >
> >
> >
> >
> >
> > #dateFormat(createdate(year(newdate), month(newdate),
> daysinmonth(newdate)),'mm/dd/')#
> >
> >
> >
> >
> > Azadi Saryev
> > Sabai-dee.com
> > http://www.sabai-dee.com/
> >
> >
> >
> > Ras Tafari wrote:
> >> but the end of months is a KNOWN thing, calculated out forever, look
> >> at rainmain.
> >> with that known constant of dates, it would be easy to code it such
> >> that anything
> >> end of month that asks for a incrementer of "m" would be easy to assume
> that.
> >>
> >> so, with that, id say a new incrementer of precise calendar month would
> be best.
> >>
> >> tw
> >>
> >>
> >>
> >
> >
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321278
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: would you consider this a bug, CF8
Still, what if you really wanted it to be the 30th? Do we really want the engine to make this kind of assumption? I guess the best solution would be like you said: add another incrementer. That way we would have the option: increment by month and keep the position relative to end of month, or increment by month and keep day. Francois Levesque http://blog.critical-web.com/ On Thu, Apr 2, 2009 at 11:28 AM, Tony 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... and thanks! > > second, maybe there needs to be another incrementer, that does it > logically based on calendar month, rather than days, since > what is a month? its a begin on the 1st and end on a known variable > day. simply incrementing by a set number of days > to find the day next month is weird, since not all months have all > those days. maybe the JAVA should be smart enough to notice > that the date is an end of a month, and if the incrementer is "m", go > by calendar month, not by same day next month... right? > > tw > > On Thu, Apr 2, 2009 at 11:15 AM, Francois Levesque > wrote: > > > > That's odd, but not unexpected. Since you're starting on the 30th, it's > > adding a month to that and reduces when the month doesn't have 30 days in > > it. It's not taking the initiative of thinking you want the last day of > the > > month. > > > > Maybe this would work? > > > > > > > > > > > > #dateFormat(date2,'mm')#/#daysInMonth( date2 > > )#/#dateFormat(date2,'')# > > > > > > > > Francois Levesque > > http://blog.critical-web.com/ > > > > > > On Thu, Apr 2, 2009 at 11:05 AM, Tony wrote: > > > >> > >> > >> > >> > >> > >>#dateFormat(date2,'mm/dd/')# > >> /> > >> > >> > >> > >> very simple code. however, its behaving like i dont want it to. > >> id rather see it increment by a MONTH, not same day next month. > >> > >> the output of that code above is: > >> > >> 12/30/2008 > >> 01/30/2009 > >> 02/28/2009 > >> 03/30/2009 > >> 04/30/2009 > >> 05/30/2009 > >> > >> and i would rather it be > >> > >> 12/31/2008 > >> 1/31/2009 > >> 2/28/2009 > >> 3/31/2009 > >> 4/30/2009 > >> 5/31/2009 > >> > >> what should i be using? this is weird... i supply "m" to get month > >> increment, but > >> no dice... > >> > >> thanks > >> tw > >> > >> > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: would you consider this a bug, CF8
That's odd, but not unexpected. Since you're starting on the 30th, it's adding a month to that and reduces when the month doesn't have 30 days in it. It's not taking the initiative of thinking you want the last day of the month. Maybe this would work? #dateFormat(date2,'mm')#/#daysInMonth( date2 )#/#dateFormat(date2,'')# Francois Levesque http://blog.critical-web.com/ On Thu, Apr 2, 2009 at 11:05 AM, Tony wrote: > > > > > >#dateFormat(date2,'mm/dd/')# /> > > > > very simple code. however, its behaving like i dont want it to. > id rather see it increment by a MONTH, not same day next month. > > the output of that code above is: > > 12/30/2008 > 01/30/2009 > 02/28/2009 > 03/30/2009 > 04/30/2009 > 05/30/2009 > > and i would rather it be > > 12/31/2008 > 1/31/2009 > 2/28/2009 > 3/31/2009 > 4/30/2009 > 5/31/2009 > > what should i be using? this is weird... i supply "m" to get month > increment, but > no dice... > > thanks > tw > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Concatenate Multiple Lines of Code
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 Is as valid as Francois Levesque http://blog.critical-web.com/ On Mon, Mar 23, 2009 at 1:29 PM, Claude Schneegans < schneeg...@internetique.com> wrote: > > May be I don't catch it, but this will work perfectly in CF: > queryname.columname2 & > queryname.columname3> > > You need no delimiter to tell CF it s only one statement. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List of CfQueryParam cfsqltypes for TYPE_NAME as returned by cfdbinfo.
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 wrote: > > Does anyone have a list of the SQL datatypes for MySQL and MSSQL as they > are > related to CfQueryParam cfsqltype when returned by cfdbinfo's TYPE_NAME? > > I am building a function to tease those out and want to make sure I get as > many as I can matched up correctly. I thought I would ask here before going > code spelunking into On Tap, Reactor and Transfer. > > It would be nice if cfdbinfo returned that but, unless I am missing > something obvious, no deal. > > BTW I was looking though my archive and I have a bunch of MySQL databases > with the data type being Enum with either "0,1" or 'yes,no", "true, false" > as the values. Seeing that enum can have more than 2 values and can be text > values how do those work with cfsqltype? > > As always, many TIA, > > G! > -- > Gerald Guido > http://www.myinternetisbroken.com > > > "To invent, you need a good imagination and a pile of junk." > -- Thomas A. Edison > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I give...anything inherently wrong with this code that would cause this error?
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 wrote: > > Here's the error from CF: > > > > "This expression must have a constant value." > > > > The compiler was processing: > > - A cffunction tag beginning on line 72, column 10. > > The error occurred in > E:\Inetpub\webroot\wsm-dev\jQuery\ajax_file_upload_two\form_processing.cfc, > line 79. > > (Line 79 is: returnType = "struct") If I take out that line, then the > error just references the line before it: access = "remote". > > > > Without going into a thousand lines of code upfront, I was wondering if > anything was wrong with this code > > up to this point. I've never gotten this error before (but, then again, > I've never tried to do some of the things > > I'm doing with this, either.) > > > > Thanks, > > > > Rick > > > > > > > displayname = > "fnProcessForm" > > argumentCollection = "#form#" > > dsn= > "#application.dsn#" > > hint = > "Processes Submitted Form" > > output = "false" > > access = > "remote" > > returnType= "struct"> > > > > > required = "yes"> > > > > > > > > > > > > > > > > > - > > "A government big enough to give you everything you want is big enough to > take away everything you have." > > - Thomas Jefferson > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Googlebot got me good last night...
I don't believe the googlebot can be stopped by Javascript, and nevertheless
it's probably never a really good idea to prevent access to admin pages with
JS only as disabling Javascript is relatively easy.
Using cflocation would probably take care of it, though, and effectively
redirects 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 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 last
> night, started crawling admin pages, and ended up munging half the
> database:
>
> 1. Clicking "archive" or "mark inactive" buttons on admin area
> index pages
> 2. In a few cases, actually seemed to SUBMIT a form, updating data.
>
> I'm still scratching my head over how Googlebot got into the admin
> system to start with. It looks legit from the logs. The IP address,
> user-agent and everything else checks out.
>
> Luckily, this isn't a mission-critical site, and database backups are
> done nightly, but now it's got me worried for other sites. Googlebot has
> *never* caused any problems with password protected admin systems
> before, my "robots.txt" file usually excludes the admin folder (and you
> can be sure I'm checking the ones I'm not sure about right now) and the
> login stuff I use I thought was pretty standard.
>
> My login code is below. Tell me I'm a complete idiot.
>
> So,
>
> 1. Anybody else have this problem recently?
> 2. I'm an idiot I guess, how *should* I be doing my login systems?
>(One site on CF8, others still CF7)
> 4. If you're doing anything like I am, then maybe we're *all* idiots at
> this point and need to redo our login pages to use whatever somebody
> much smarter than I says to do in #2 above.
>
> -
> Application.cfm page for the admin folder:
> -
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <!---alert("You must login to access this area!");--->
> self.location="../admin_login.cfm";
>
>
>
>
> -
> login_process page:
> -
> **QUERY TO CHECK USER/PASS HERE
>
>
>
>
>
>
> self.location="idx_admin.cfm";
>
>
>
>
> alert("Your credentials could not be verified, please try
> again!!!");
> self.location="../admin_login.cfm";
>
>
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319542
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Wrong label appearing with cfchart
Hi everyone, I seem to be having a little problem with cfchart and cfchartseries. Take this example: 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/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Acces a record count in javascript
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
wrote:
>
> Hi
>
> I need to access a recordcount from within a javascript function, is this
> possible?
>
>
> function checkBoxValidate(cb) {
> for (j = 0; j < RECORD COUNT OF QUERY TO GO HERE; j++) {
> if (eval("document.addCust.ckbox[" + j + "].checked") == true) {
> document.addCust.ckbox[j].checked = false;
> if (j == cb) {
> document.addCust.ckbox[j].checked = true;
> }
> }
> }
> }
> // End -->
>
>
> Jason
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318750
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using "FileExists" function in a "CFIF" tag
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 wrote: > > I am attempting to prevent broken pictures on a page displaying details > regarding real estate listings. Agents are allowed to upload as many as 12 > pictures of a particular listing but frequently post less than twelve. When > that happens, a "broken picture" emblem appears, and we want to eliminate > that. > > An example of the (not working) test page can be found at: > > > http://www.vacationlandproperties.com/Residential_Listing.cfm?RecordID=89255 > > I have entered some extraneous code in order to determine that the correct > path is being used, thusly: > > http://mls.northernweb.net/images/Photo";> > > > #PhotoLocation#-2.jpeg > Yes, it's here.I > couldn't > find it. > > > As you can see at the test page, the path to the photo shows up correctly > but the CFIF tag is unable to produce desired results. > > Any idea of what I am doing wrong? Is there a better way to test to see if > a > file exists in order to avoid broken pictures on the page? > > Thanks, > > Dave Long > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Just checking
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 wrote: > > Not heard a peep from CF-Talk in a while. Is anybody there? :O. > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Components: Setting dynamic arguments dynamically
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 wrote:
> Here's a little more background
> This creates structure keys and populates them in the session scope
>
> session.NODA09_formStruct=StructNew();
>
> For (i=1;i LTE Form.PE_Counter; i=i+1)
>
> if(StructKeyExists(FORM,'play_'&i)){
>session.NODA09_formStruct['play_'&i] = form['play_'&i];
>
>}
>
> because there's a intermediate step before any database writes happen.
> So in the function that does the insert
> I have to loop over the structure to find the dynamic variables ('play_'
> &i) and populate argument variables ('arguments.play_' &i ?)
>
>
> Andy Matthews wrote:
> > You've got three options to pass arguments into a method.
> >
> > Specific placement: methodName('andy',42)
> > Arguments must be in the slot in which they're defined in the method.
> >
> > Named arguments: methodName(name='andy',id=42)
> > Arguments can be passed in any arrangement you like
> >
> > Argument collection: args.name = 'andy; args.id = 42; methodName(args);
> > Create a struct with a key named after each of your arguments, pass in
> the
> > struct
> >
> >
> >
> > andy
> >
> > -Original Message-
> > From: Scott Stewart [mailto:saste...@email.unc.edu]
> > Sent: Wednesday, December 31, 2008 9:19 AM
> > To: cf-talk
> > Subject: ColdFusion Components: Setting dynamic arguments dynamically
> >
> > Confused programmer is confused (just because the title sounds like
> > LOLSpeak)
> >
> > I've got this little piece of code that dynamically creates and populates
> a
> > structure key pair, based on what's sent from a form with a dynamically
> > generated set of fields (javascript "add row")
> >
> > For (i=1;i LTE Form.PE_Counter; i=i+1)
> >
> > if(StructKeyExists(FORM,'play_'&i)){
> > session.NODA09_formStruct['play_'&i] =
> form['play_'&i];
> >
> > }
> >
> > I know that the arguments in a cf function are very particular about
> their
> > placement, can I use similar code to create and populate arguments?
> >
> > --
> > Scott Stewart
> > ColdFusion Developer
> >
> > Office of Research Information Systems
> > Research & Economic Development
> > University of North Carolina at Chapel Hill
> >
> > Phone:(919)843-2408
> > Fax: (919)962-3600
> > Email: saste...@email.unc.edu
> >
> >
> >
> >
> >
> >
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317294
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Sum
You could use a query of query (QoQ) select sum(quantity) as total_fruits from fruits Other than that, there's looping ;) Francois Levesque http://blog.critical-web.com/ On Thu, Dec 18, 2008 at 1:46 PM, patrick buch wrote: > Hi, > > Now I know you can sum in the query to the db. I was wondering though, is > there a way to sum on the results you get back from a query through CF? For > instance: > > Results of query > Fruit Quantity > apple 3 > apple 2 > total: 5 > > Something like: > > cfset qSum = sum(myquery.quantity) > > Total of fruit: #qSum# > > Thanks... Hope this makes sense. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316918 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFEclipse Show Line Numbers
Hi Phillip, You have to edit a settings file. In your workspace folder, open ..metadata/.plugins/org.eclipse.core.runtime/.settings/org.cfeclipse.cfml.prefs and add this line at the end: lineNumberRuler=true Restart Eclipse and you should be on track. More details here: http://blog.critical-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 wrote: > My CFEclipse doesn't have the show line numbers option. My General-> > Editor panel does, and it's turned on, but in CFEclipse-> Editor I do NOT > have a line numbers option. I am running version 1.3.2 beta as a plugin > into standard Eclipse. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
