I'm building a query object for a search page:
!--- original query here ---
cfloop query=results startrow=1 endrow=#n#
!--- Count the number of times the search keyword
appears in our narrative ---
cfset req.keyCOUNT =
ListValueCountNoCase(results.narrative,#req.srch#,' ')
!--- Add
Thanks, Mike! Looking forward to it!
Rick
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 22, 2008 10:47 PM
To: CF-Talk
Subject: Re: Waaa! Why won't my CFC work!
Rick, I havent forgotten my promise to get you a sample app. I'm
nearly
Yes, it looks like ColdSpring will a be a great addition!
Rick
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 22, 2008 10:52 PM
To: CF-Talk
Subject: Re: Waaa! Why won't my CFC work!
Oh and can i add, Rick , yes you DO want to use ColdSpring,
Hi all,
i want to send data with a post form. In the next step i want to check which
entry of an array includes the selected data.
For example:
In the form the user selected the 2nd entry which includes XYZ in an dropdown
(select) field and submit the form.
How can i check which entry of the
Hi Nic, are you trying to pass through the array used to create the select
box along with the selected item?
If so, you need to convert the array into text before you can send it. If I
am off base, please clarify the original problem maybe there is a better way
to solve it.
cfif
We are starting to build a new application. We are having major confusion
issues regarding the use of cfc's. My boss has a java background but not a
coldfusion background. I have been using cfc's since mx came out but not to
their full advantage. We have been reading about setter/getter
Lori,
The reason that some people discourage the use of a query object as a return
type is due to the fact that it binds whatever uses that query object
directly to the database (more specifically, to the columns in the
database).
The use of setter/getter beans should be familiar to your boss;
Been playing more with my first model glue app and I realize how awesome it is,
just from tinkering.
I built a reqUsername method that simply set a randRang() and tacked it onto an
email username, just for the fun of it. I hard-coded those values in the
randRange().
Then I thought hm, that's
I hear you, Will.
Now don't overload my rowboat with motorboat power! :o)
Rick
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2008 10:44 AM
To: CF-Talk
Subject: MG is so cool!
Been playing more with my first model glue app and I realize
This may be a hand grenade for your ant, but I've got to throw it out
there since no one else has.
Flex LiveCycle Data Services
(http://www.adobe.com/products/livecycle/dataservices/) allows the
server to push messages to the client which means a users page could
refresh data without having to be
Is there a definitive list of what CF SQL type goes with what column data
type?
I have a few I'm not sure of (CF_SQL_ below). Can anyone fill some of
these in? These are all SQL 2005 data types.
int CF_SQL_INTEGER
nchar(10) CF_SQL_CHAR
ntext
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_18.html
about 1/2 down the page. smalldatetime is cf_sql_timestamp (i only
knew that one 'cuz it bit me in the ass a couple of weeks ago) :)
On Mon, Jun 23, 2008 at 8:33 AM, Adrian Lynch [EMAIL PROTECTED] wrote:
Is there a definitive
On Mon, Jun 23, 2008 at 8:36 AM, Lori Stone [EMAIL PROTECTED] wrote:
I have always returned query objects but apparently that is not the best
practice. I don't understand the problem with returning query
objects. I would love to understand the reasoning and what the return type
should be.
As others have mentioned... don't fight OO. :) It takes a bit of time
to adjust but it will all come together and you'll be a more productive
developer as a result.
As someone mentioned, the variable scope is local to the page (doesn't
matter if the file ends in cfc or cfm). You aren't
Thank you both for the info.
John
You need to add the data sources into each instance if you plan on
actually using them.
Unless you have a site using the default instance, you shouldn't need
any data sources set up there.
I may be wrong, but I seemed to remember if you added data sources
Sounds good, Jason.
Thanks for the overview and examples!
This is making more and more sense each hour!
Rick
-Original Message-
From: Jason Durham [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2008 11:55 AM
To: CF-Talk
Subject: RE: Clarification Required Concerning CFC...
As
Since we are talking about multiple instances, I thought I'd pass along a
couple of things that have caused me much grief:
1) Be sure that IIS sites need to be assigned to CF instances using the Web
Server Configuration tool (installation driver\JRun4\bin\wsconfig.exe)
2) When you apply CF hot
I'm definitely not the authority on ColdFusion and OO, however I have
asked lots and lots of questions. The answer is almost always, 'it
depends.' I return query objects all of the time. Sometimes I'll
return a struct with a couple of variables and the query object inside.
Do what makes sense
Qing brings up some very good points. You must treat each individual
instance of CF as an individual server, and as such upgrades and changes
to one will typically not be automatically applied to another. One
advantage is that each instance also gets it's own JVM instance, but you
must think
I'm just not understanding why I'd need a getter and a setter in my cfc.
My app works just fine without setting anything in the variables scope of my
cfcs. You submit a form, it adds the values to my db. You run a query and get
all the values back out.
What is the value of keeping each value
One of the things that the other posters (particularly Matt) were getting at
is that many times when you return a query object with a number of records,
you're not looking to manipulate any of the records (yet).
You're often listing records from the database so that one can be chosen for
Short answer... You don't
You CAN build CFCs pretty much anyway you want to. Frankly, in CF if it
works, and you like how it works, then it's perfect.
Using getters and setters is really more of an OO habit than anything else
in CF.
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7
hi
we are using the JExcelAPI to populate a spreadsheet and wondering if anyone
knows how to group rows using the group and outline function in ms excel
through the JExcelAPI.
thanks
richard
~|
Adobe® ColdFusion® 8
Wow! This is advanced stuff! I have not done anything for the JVM tuning
yet--so I imagine everything is at its default value now. Time to dig in
and see what I can do with them... We have 4 CF 8 instances running on one
(pretty powerful) virtual server. So far there has been no performance
I think the primary reason for using get/set is to extract the specific
variable from the larger picture. This way, if something even happens to
your code and you change the source location of the variable's value, you
only have to change it in one place.
I personally don't use get/set as I don't
The theory behind getters and setters is abstraction. You are not
supposed to deal with the data directly nor are you supposed to know
how the data is stored and how the object works. You create an object
and let it do the work for you. Getters and Setters hide implementation
details of the
One word: encapsulation.
The variables scope allows you to have instance data that is specific to a
particular instantiation of an object. So does the this scope, but this
is less preferred, as it makes the properties directly available outside the
CFC.
You cannot set or get the variables
Just to be difficult,
You cannot set or get the variables scope directly, so you need the getter
and setter to do this.
Actually, in Coldfusion you can. Of course, you have to reference them
somewhere else in you CFC if you want to access them from outside your CFC,
but it doesnt HAVE to be
Will,
Many of the ideas within OO are to promote encapsulation, easy reuse, and
increased maintainabilty. In your example, it may be much easier to submit
a form to a page that takes those values and adds them to the database. But
for example lets say you are storing a customer, and that you
As others have pointed out, getters and setters are there for encapsulation.
For example, if you have a getPrice() method on a Product, right now it
might return just a price instance variable. But later you may need to add
in much more complex logic such as tiered pricing for certain customers,
The value 3C26C422-BCD2-35D3-DDB3F69250F4848F cannot be converted to
a number
Still scratching my head over this.
Two questions that may or may not have anything to do with my odd problem:
1. What happens if Descript below is a NULL value?
cfset Temp = QuerySetCell(GetCourses, Descript,
Les,
the datatyping may occur in your first query, especially if you are building on
to a query that initially retrieves records from the database.
If you are specifically creating a query and have a combination of
numeric/alpha being returned, you should attempt to type the query columns
I've been searching everywhere for a Flash Remoting solution that uses AS3 in
Flash using Coldfusion. So far I've struck out on solutions. Seems like all the
tutorials/examples on the web all use AS2 and the methods are very different. I
can't use AS2 cause the flash movie is very processor
I hate verity, for so many reasons. Mostly because it's a pain to administer.
I'm setting up some CF8 instances for our customers to start testing on, but
I'm again having issues moving verity collections. Is there some secret that
I'm missing when exporting verity collections? It looks
I've been searching everywhere for a Flash Remoting solution
that uses AS3 in Flash using Coldfusion. So far I've struck
out on solutions. Seems like all the tutorials/examples on
the web all use AS2 and the methods are very different. I
can't use AS2 cause the flash movie is very
I am not sure why you would put both an integer and UUID in the
same column
The former owner of the database had an id (integer - auto increment)
column, and an atty_id column that had integers in it, but was type
varCHAR. No idea why he did that. In reprogramming the site, I had no
choice
Thanks Qing. We just went through a major datacenter migration, brought
on by growing pains (all outlined in my most recent blog post), so I've
learned more about CF, JRun, and the JVM in the last nine months than I
ever thought I would need to know. Mike Brunt's blog postings, on the
Alagad
I think your problem may stem from the old behavior of ColdFusion query
columns guessing what type they are based on values in the first several
rows.
If the first few records lead CF to believe that a column is an integer,
things can blow up later when it encounters letters in that column.
If
Brad Wood wrote:
I think your problem may stem from the old behavior of ColdFusion query
columns guessing what type they are based on values in the first several
rows.
Ugly because of line breaks, but here ya go:
!---First, we create the query object, q_atty:---
cfset q_atty =
Thank you all for the info. It's most helpful!
Will
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
Yeah, change this line here:
cfset q_atty = queryNew(atty_id, first_name, middle_name, last_name,
suffix, atty_type, bus_number, office_id, keyCOUNT)
Read up here:
http://livedocs.adobe.com/coldfusion/7/htmldocs/0600.htm
Change the line to:
cfset q_atty = queryNew(atty_id, first_name,
If you are using querynew() and you are on CF7 or later, use the second
attribute which is a comma-separated list of data types.
That fixed it. I didn't realize the CF would *guess* a datatype!
So, that's why queries that returned only a few record sets would work!
Not enough info to guess
You need to work with your interaction as form data and strings. If you are
outputting data to a CF query, submit the flash strings to your cfquery as
form.variables.
If you are outputting CF data to Flash, output your data to a string, like
this:
Hey everyone i need some help.
I'm currently interfacing with the NCBI Entrez Utilities Web Service
(version 1.5) -
http://eutils.ncbi.nlm.nih.gov/entrez/query/static/esoap_help.html.
I've tried to implement the 2.0 version but they broke out the eutili
and efetch functionality. So for version
I've got it working pretty darned good - except for one problem. If
there's a NULL cell in the Excel sheet, it's throwing an error
Element CELL is undefined in LOCAL.
LOCAL.CellType = LOCAL.Cell.GetCellType();
If I go into my Excel sheet and just enter a space in the cells, no error.
So, I'm
I was about to try some gzip compression of CSS files, but found that
CF's GetHttpRequestData().headers doesn't include the Accept-Encoding
field when I hit the page from windows with Firefox (2 or 3) or IE7, but
when I use Firefox Add-on Live Http Headers, I see Accept-Encoding:
gzip,deflate
Hi Les,
Are you working with Excel 2007 files? I've had issues with reading the
latest version of Excel files using the version of the POI library included
in CF. After upgrading to the newer 3.0.2 version I had less issues.
HTH,
t
On Mon, Jun 23, 2008 at 1:46 PM, Les Mizzell [EMAIL
I was about to try some gzip compression of CSS files, but
found that CF's GetHttpRequestData().headers doesn't include
the Accept-Encoding
field when I hit the page from windows with Firefox (2 or 3)
or IE7, but when I use Firefox Add-on Live Http Headers, I
see Accept-Encoding:
You need to work with your interaction as form data and
strings.
I don't think that's Flash Remoting (RemoteObject).
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
Dave Watts wrote:
I was about to try some gzip compression of CSS files, but
found that CF's GetHttpRequestData().headers doesn't include
the Accept-Encoding
field when I hit the page from windows with Firefox (2 or 3)
or IE7, but when I use Firefox Add-on Live Http Headers, I
see
Dave Watts wrote:
I was about to try some gzip compression of CSS files, but
found that CF's GetHttpRequestData().headers doesn't include
the Accept-Encoding
field when I hit the page from windows with Firefox (2 or 3)
or IE7, but when I use Firefox Add-on Live Http Headers, I
see
Thanks Dave, I see that now ... So it's not a CF problem,
that part is good. If only I could track down where it's
coming from. I think it's from McAfee, but I have no Proxy
settings in McAfee I just tried turning it all off and
still get the X-McProxyFilter header. I'm heading out
This will either return 0 if the string isn't found or the array position in
which it was found
cfscript
function searchArray(arr,str)
{
var retVal = 0;
for(i=1; i lte arraylen(arr); i=i+1)
{
if (arr[i] is str)
{
Thats the macro/polo version. Problem I had with bringing in variables that way
is they don't compare properly. My if statements will not properly compare them
so I can actually do something with them. Like i could set
value1=mystringvalue2=mystring, and try to compare them if (value1==value2)
Thats the macro/polo version. Problem I had with bringing in variables that way
is they don't compare properly. My if statements will not properly compare them
so I can actually do something with them. Like i could set
value1=mystringvalue2=mystring, and try to compare them if (value1==value2)
Tom,
If your only need is to have clients in sync but with no data-conflict
resolution, you can try BlazeDS which provides you messaging support
using an AMF channel. With Messaging you can push changes to clients and
with some logic at the client, you could update your application and get
the
You can also use the underlying Java object's indexOf() method:
cfset theIndex = myArray.indexOf(XYZ)
Just remember to add 1 to the result.
On Tue, Jun 24, 2008 at 6:08 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote:
This will either return 0 if the string isn't found or the array position in
Just to be difficult,
You mean like this:
cfcomponent displayname=spy output=false
cffunction name=init access=public output=false
cfargument name=obj type=any required=true /
cfset obj.leak = variables.leak /
cfset this.tradeSecrets = obj.leak() /
cfset
I am still interested to hear back from Nic on what the original
problem/task was. Is the Array something in session or is it value that
needs to be passed through the form?
Fred
On Mon, Jun 23, 2008 at 8:26 PM, James Holmes [EMAIL PROTECTED]
wrote:
You can also use the underlying Java
Just remember to add 1 to the result.
And remember java will perform a case sensitive search. So indexOf(XYZ) may
return different results than indexOf(xyz).
cfset myArray = [ apple, xyz, orange, pear]
cfset index1 = myArray.indexOf(XYZ) + 1
cfset index2 = myArray.indexOf(xyz) + 1
cfoutput
I'm just not understanding why I'd need a getter and a setter
in my cfc.
...
What is the value of keeping each value in its own variables
scoped variable? Where does it come in handy? Where are you
supposed to use it?
As many people have mentioned, you don't need getters and setters.
Tyler Fitch wrote:
Hi Les,
Are you working with Excel 2007 files?
Yea, darnit! Weird - one file will import fine, the next will toss an
error. I can create all the spreedsheet files I want in Open Office,
save them as Excel files and every single one of them works. Go figure.
Client has
After upgrading to the newer 3.0.2 version I had less issues.
Heh - gotta love this:
The Jakarta POI (Poor Obfuscation Implementation) API is a fantastic
way for Java programmers to access Microsoft document formats. The most
mature API from Jakarta POI is the HSSF (Horrible Spreadsheet
I'm trying to create a cfc in my application scope but the variables I set in
the init method don't seem to be persistent.
Here is the init method:
cfcomponent displayname=coupons hint=Checks validity and type of coupon and
applies it to order.
cffunction name=init
I'm trying to create a cfc in my application scope but the variables I
set in the init method don't seem to be persistent.
Start dumping everything. Dump application scope, etc. see what's in there.
Will
~|
Adobe®
The cfc is in the application scope. How can I tell if variables.ds is
persistent?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
The cfc is in the application scope. How can I tell if variables.ds is
persistent?
Have you made sure the app was restarted after any changes you may have made?
You either need to restart cf, run onApplicationStart() again, etc.
If you make changes and don't restart your app, you'll get
I restarted CF several times to make sure.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
I restarted CF several times to make sure.
I don't know that I've ever had a problem with this, other than forgetting to
restart it.
You can try this. Setup a method like so
cffunction name=retVariables access=public returntype=Struct
output=false
cfreturn variables
/cffunction
Run it
I'm just beginning to work with CFC's, so I'm in no position
to be able to validate your code, however (and it's probably
just a typo in your email), I did notice a missing at the
end of this line:
cfargument name=ds required=true type=string
That could be throwing off the setting of the
cfset
You've dumped application.admin.ds to make sure something is in that?
On Tue, Jun 24, 2008 at 11:55 AM, Ian Rutherford
[EMAIL PROTECTED] wrote:
I restarted CF several times to make sure.
--
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
Further to this, in which method in Application.cfc is this code being run?
On Tue, Jun 24, 2008 at 12:04 PM, James Holmes [EMAIL PROTECTED] wrote:
You've dumped application.admin.ds to make sure something is in that?
On Tue, Jun 24, 2008 at 11:55 AM, Ian Rutherford
[EMAIL PROTECTED] wrote:
I'm just beginning to work with CFC's, so I'm in no position
to be able to validate your code, however (and it's probably
just a typo in your email), I did notice a missing at the
end of this line:
Hey Rick, I started playin around with Coldbox today. Man you gotta give it a
whirl. It kicks
Yep, it is defined there.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
OnApplicationStart
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
!--- contact.cfc ---
cfcomponent
cfset this.name =
cfset this.address =
cfset this.city =
cfset this.state =
cfset this.zip =
/cfcomponent
Thanks dave! Oops Dave (ahemm)
One thing that's messin' up my head is, these cfc's are usually stored in
That was a typo. I need the argument because I feed in the ds name when I run
the init code.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
One thing that's messin' up my head is, these cfc's are
usually stored in application scope. This information looks
more like personalized info, which is usually stored in
session scope.
I'm not understanding how info doesn't get crossed up between
users. lol!
Well, the example I
There's a version of the POI library buried in the CF installation and you
could replace it with the newer version from the Apache group. But I
wouldn't recommend that as it could unexpectedly break some of CF in built
functionality. Personally I've used Mark Mandel's JavaLoader to reference
the
Okay, I figured out the problem but don't know the answer. I am getting this
problem when I try to bind the cfc in a grid because the grid is binding a new
copy of the cfc instead of the one created in the application scope:
cfgrid format=html name=getCouponList pagesize=#attributes.pageSize#
You need to write a static wrapper CFC that has inside it a reference
to your application scoped CFC. It mirrors the methods and proxies the
calls to your app scoped object.
On Tue, Jun 24, 2008 at 1:22 PM, Ian Rutherford
[EMAIL PROTECTED] wrote:
Okay, I figured out the problem but don't know
81 matches
Mail list logo
