Software development technology changes too fast for people to rest their
laurels and not keep up. That's why I always recommend looking at the past 3
years experience on a candidate's resume since anything after that for the
most part may not be helpful to me or the intended client.
If
Pete
Does JSP have an analogue to the application.cfc file?
No, at least not a standard analogue (some JSP containers like JRun
have/had a non-standard thing called global.jsa.) You can initialise
simple global variables using web.xml.
Any other tips for a CF guy teaching himself JSP?
Jay
Which of these two methods would be faster?
- Method 1 -
cfquery
SELECT * FROM table WHERE someID = #someVar#
/cfquery
cfif query.recordCount IS 1
cfqueryUPDATE table.../cfquery
cfelse
cfqueryINSERT INTO table.../cfquery
/cfif
- Method 2
Hugh
I'm trying to create a query based form which reads it's elements from a
database table, then populates itself. Each input element would have be
dynamically named via the DB query.
Creating the form isn't so bad, but handling the insert query the other side
is becoming a headache.
Aaron
Here is the error message:
Query Error: Data truncation: Out of range value adjusted for column
'ordernumber' at row 1
Here is the SQL statement:
INSERT INTO orders(ordernumber, tax, shipping, total)
VALUES(558972266568040,0.0,4.75,24.7)
In my database (MySQL 5) I have the
Hello everyone, long time time since I was here.
I'm trying to read a CSV file with CFQUERY using the ODBC
text driver as described at
http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv.
I get this error:
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Text Driver] The
Have you tried using CFHTTP? It can also return a
CSV/Text file as a query.
Thanks for the suggestion Matthew. I was hoping to get the
CFQUERY approach working because presumably it's the most
efficient, and I may have a lot of data to process.
Nick
Mark
Is the file unlocked and does the driver have permissions
to access it?
It should be unlocked - it's been uploaded by a CFFILE just
before the CFQUERY is run. As regards whether the driver has
permissions to access it - CF certainly has, but I don't
know about the driver itself, if that's
Dave
Actually, if you uploaded it in the same request as the
CFQUERY, it is
probably locked by CF, so you won't be able to use it
through ODBC (which
runs as a separate process).
It's not the same request, but a subsequent request in the
same session - do you think it would still be locked by
Ryan
I'm surprised you would get a file not found error if the
file was there
but locked? Are you 100% sure the file exists at
C:\test\testfile.csv ?
Yes, 110%.
Nick
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2
I am aware (somewhat!) of the asynchronous Web services capability with CFCs
in ColdFusion. What would listers recommend if I simply want to call a
ColdFusion action page asynchronously. The asychronous call is a one-way trip
and does not require data back to the caller.
The really simple
This is not an SP per se, it is just how SQL handles these dynamic SQL
strings.
Upon further research this is a SP.
sp_prepare() and sp_execute() are system stored procedures which respectively
prepare and execute the SQL. The SQL code from your cfquery does not become a
stored procedure,
The results are great but in some instances a country will appear twice,
with two different count values, I want the country to appear once with
the total count of both results.
select COUNTRY, sum(NB_PROFILES) from
(your entire select statement here)
group by COUNTRY
should do it?
Nick
Martin
Thanks for the reply. Yeah I just came up with the same myself as a Q of Qs.
I tried it in the original union query, which would be the ideal solution for me
having it all in the same query, but Oracle throws me an inconsistent data types
error?? Can SUM be used in a union on oracle?
I
Heres a real world scenario I've come across:
Code throughout the app is using data returned from a query that has
select *, and pulls data from more than one table.
Someone adds a column to one of the tables in the query that has the
same name as a column in another of the tables in the
Anyone use CF with jfreechart? I'm trying to create a MeterPlot, but it's
coming up blank.
Yes, but we don't use MeterPlot.
I'd RTFM if there was a better FM :)
I know what you mean. Have you tried the forum? I've always managed to get
answers there.
We have an application that allows users to specify (at initial setup time)
to specify what kind of metadata they want to enter when they work with
digital media within the application. For example, one user may want to
upload a bunch of Word doc files and then enter a set of metadata (say
How do you guys go about technical documentation, how do you write docs that
tell other people (not necessarily technical, but project participants) how
your code works, what the rules are, what the re-use potential is, how the
UI works etc.
What tools do you use for the job? Word? Visio?
Is anyone out there using any kind of generic database management
scripts...something that could be plugged in to a homegrown CMS to
provide easy management of those other tables that must be dealt
with? Basically something where you can define a schema, and it
will
produce the pages/forms
I have recently found a bizarre situation where numbers are not
calculating correctly when the values are stored in FLOAT data types.
This is not just a database-related issue - it's found in computer
systems in general.
Floating point numbers are by definition approximations. This often
Tomcat J2ee server is indeed a true j2ee server and not just a servlet
container. To run CF you need the J2EE version.
Tomcat is a servlet container. It is a true J2EE server to the extent that
it supports parts of the J2EE specification such as servlets and JSPs, but
it is not an EJB server.
It is not clear from what
I've read on ASP.Net if their canned form controls are actually necessary
or
not.
No, they're not necessary, but as you say, you would never guess that from
most of the stuff written about ASP.NET.
Nick
Anyone have any quick code to retrieve the number of bytes in a string
/without/ writing the string to a file first? I'm trying to do a
little debugging and I'd like to know the size of a string that is
being returned to the browser.
The number of bytes occupied in the application's memory
Is there a time when evaluate should be used?
If you want to dynamically build an unpredictable string which contains
logic, rather than just variable names, then afaik you can only invoke the
logic using Evaluate(). But then again, that's not something that people
need to do very often.
Nick
Last year you gave $#lsnumberformat(lastyear, 9.99)# to support our
work.
This year we hope you'll give $#lsnumberformat(lastyear*2, 9.99)#.
My mailer routine uses evaluate against the string to parse out those
values, then it is sent out via cfmail inside a loop. If Evaluate() isn't
So then I try with just the domain:
ftp://tgftp.nws.noaa.gov
And get the same error. Then I tried copying the code directly from the MM
docs and I get the same error. We're running CFMX 6.1 on a *nix server. Is
there something I'm doing wrong?
Take out the ftp://;
Nick
Looks like it is hard to find data modelers in the CF community.
Well, one here, but...
First, what exactly are the characteristics that you want to test?
Functionality, usability, performance...? For the purposes of this test, why
does it matter if it's the type of data model you describe, or
I don't think anyone mentioned an off-the-shelf data model.
That's what the OP was asking for, in fact. The original thread was called
CF interacting with Teradata Server:
There is an application that is built entirely in Coldfusion for doing ETL
(Extraction Transformation and Loading) of data
When you search a collection in a language other than English, you
must translate operators such as AND and OR into the language of the
collection.
Where do we find these operators? Does anyone have an exhaustive list
they would like to share?
Google for localized query language
Some of
I have been searching for a method (and here is where I am stumped at
the terminology to search for!) to dynamically add properties to some
record.
snip
Any pointers? This must be a problem that has been addressed a number
of times
Yes, certainly have addressed it a number of times.
With a
How does it compare to SeeFusion?
U might want to have a look at fusion reactor.
I haven't used either of them yet - if anyone has used both, it would be
great to hear what you think.
Nick
~|
Message:
Russ
U might want to have a look at fusion reactor.
Have you used this does it do what it says? It looks fantastic.
Nick
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230167
Archives:
Have you tried ArgoUML? There is also an Eclipse plugin, EclipseUML, though
I haven't tried it.
What do you mean by database uml diagrams and full program diagrams?
Nick
sorry for the somewhat off topic post, but does anyone know of or can
recommend a good free (hopefully open source) uml
Try either ArgoUML or Poseidon - they're closely related. No little icons
like that though, at least not in ArgoUML.
Nick
No, havent tried argoUML yet. I looked at eclipseUML, but when I
downloaded it, it had the entire eclipse program along with it, not
just the plugin, and I wasn't sure
Lol, interesting. I guess it's not mentioned anywhere that iTEXT ships
with
CFMX7 then. Which is a tad lame.
I gues sthat effectively means it would be easy to write a better
cfdocument
tag.
Not too easy to do the FlashPaper part! But if you wanted to produce RTF for
example, then yes.
Nick
Russ
I have been asked to install iText on a shared server, but it seems that
it
could potentially be unsafe to do so as I would imagine iText has the
ability to read/file files anywhere on the server seeing as java
components
are not affected by a security sandbox.
I don't think iText
Russ
Are there any docs anywhere for installing it on CF, can't see anything on
the site
You just need to get hold of the jar file and drop it in somewhere on the
Java classpath.
Nick
~|
Find out how CFTicket can increase
does anyone have a listreverse udf kicking around or know of one?
http://cflib.org/udf.cfm?ID=51
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
someone knows a CFX or Custom Tag to create a XML structure from a XSD?
How could you do that, given that there can be all sorts of optionality and
alternatives built in to a schema?
Nick
~|
Logware (www.logware.us): a new
We have recently had three CF7/IIS2003 servers set up for us at a third
party hosting company. These are brand new installs on brand new
machines. All is well except that cfchart is not working for us. It
works fine for us on our local CF7/IIS2003 machine. We've been unable to
spot the
I have a client who wants some data represented by boxplots.
I've been unable to find software for CF which will automatically
calculate
and graph the required information (upper quartile, lower quartile,
median)
from raw data passed, so I need to find a way of performing these
calculations
I'm getting this error, whenever I'm trying to update the database, I'm
using CFMX 7, this is my query
UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 ,
Person.lstno = 20050427 , Person.LstUser = 'blopez5955' , Person.MarSta =
'M' WHERE Person.Objectno = 2005
Are you using
What is the built-in server in standalone ColdFusion MX? Is it JRun 4?
I asked someone and they said no but the I used the variable
server.coldfusion.appserver, it displays JRun 4. So can you tell me whether
the built-in server is the same as the appServer?
It's not the same, no - at least, it
Someone I work with uses CFCs for UI. For instance, something he did is
make a CFC that runs a query and returns a recordset. He then passes the
recordset to a UI CFC and it formats the results in a datagrid fashion.
We do something similar. We have a set of report-building CFCs where you can
Thanks again Dave.
OK. In general, you shouldn't need to have two different enterprise
applications within the same JRun server instance. Each one can be
deployed
within its own server. The CF EAR can handle JSP and servlet requests if
you
want to run a Java web app within the same server
In that case, you might want to try using a different user agent, to see
the
raw error message returned by the server. If you can get into the CF
Administrator, you might also enable robust exception information.
It's an HTTP status 503. Here's the IIS log
#Fields: c-ip cs-username s-sitename
The file version of my jrun.dll is 4.0.3.19147. It's not working for .cfm
files (.jsp files seem OK) on IIS5.1/JRun4/CFMX7.
Can anyone tell me if this is the correct version for CF7? I guess maybe
not, since it was created by the wsconfig tool which is part of JRun4 which
pre-dates CF7. If not,
However, when I try to hit a .cfm page that's located under
wwwroot I get Cannot find server or DNS error. Or
sometimes, it just hangs.
I'm not sure what problem you're running into, but in any case you'll want
to disable friendly HTTP error messages in Internet Explorer to see more
I have a similar problem, though I arrived at it a different way.
IIS 5 on Windows XP. CF running in J2EE mode on top of JRun4.
Befor installing CF7 I decided to re-install JRun. That went fine. I
downloaded the J2EE version of CF 7 installed the cfusion server in
JRun. That's also fine. I can
Mike
No I haven't. Why? Wouldn't that mean IIS wouldnt be running and
therefore my non-CF sites woudlnt work?
No, you can run IIS and JRun's builtin server simultaneously on different
ports. JRun will automatically choose a port that's free.
However, using the builtin server isn't really
What happened to the idea of cfdocument supporting RTF? Clearly it didn't
make it into this release - can anyone say if it'll be in a future one?
Thanks
Nick
~|
Logware (www.logware.us): a new and convenient web-based time
Has anyone noticed that the isCreditCard fuction from cflib.org
(http://www.cflib.org/udf.cfm?ID=49) doesn't work with Mastercards?
Guess I need to double-check its validation routines.
It did work for Mastercard when I wrote it, but that was during the CF5
beta, so maybe their format has
If anyone is interested, I wrote a validation function based on the LUHN
formula to validate card numbers.
I may be wrong but I think this is exactly what the first part of
IsCreditCard() does.
Nick
~|
Discover CFTicket -
Getting the following error from my ocde below, any ideas folks?
What does your XML look like?
Nick
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
Is it best to leave Coldfusion alone when it comes to dealing with XSLT
and XML ?
No, you can do this very neatly in CFMX using the XmlTransform() function.
Also, the xml2query suggestion was a good one if you want to minimise lines
of code.
However, if efficiency is an issue and the XML is
This should be pretty easy for one of you SQL gurus out there...
That depends on what you want to achieve!
SELECT * FROM ORDERS
WHERE SUM(SubTotal + Shipping) = #FORM.TotalCharge#
Maybe you mean
SELECT * FROM ORDERS
WHERE SubTotal + Shipping = #FORM.TotalCharge#
?
Nick
comparative testing of these aspects as well as performance, or do you
know
of any such testing that's been done?
nope. are you volunteering?
Well... we'll start by trying it out in a couple of apps if we find out
anything interesting will post it.
Thanks
Nick
Paul
pretty much everybody knows better than ms when it comes to JDBC sql
server. ms's JDBC driver originally came from datadirect hasn't really
progressed that far. and my own testing is exactly the opposite of your
findings, ms's JDBC driver was the 3rd slowest i tested:
#1 jTDS
Can anybody recommend any good resources on tried and true definitions
of the process? That is where we are stuck at. Our organization lacks
the
experience of large software design so we have no real process. But we
are
getting more and more of it. I've been tasked with learning how this
Just curious as to what applications people use when designing their
DB's - Visio? Pen and Paper? Bueller?
My current shop likes to wing it and frankly that's not so good. I'd
like to recommend something a little more standardized, and if I can
ascertain what might be considered an industry
If I run the following code...
cfoutput#Config.SiteConfig.SiteSections.UserManager#/cfoutput
The expected result...
True
Is output to the browser, however the following code samples...
cfif Config.SiteConfig.SiteSections.UserManager
cfif Config.SiteConfig.SiteSections.UserManager IS TRUE
And I have a hard time trusting anything that goes from diagram to DB
FOR you, mostly because I've never seen anything auto-generated by
anything that auto-generates that was really as well-done as it could
have been.
What type of shortcomings do you have in mind?
Nick
Here's a conceptual question. Lets say you have a query with multiple rows
in it. There is a few calculations that will take place between items in a
row to get some additional values per row (i.e. a discount price, etc.).
One way of doing this is when outputting the query, you send the
Mario
Does anyone know if this can be done with the SWITCh statement in JSP.
Can
switch be used on strings --- I have been told yes and no by different
people
No, afaik the switch statement in Java needs a simple scalar type such as
int or char.
I suggest you use if...else if.
Nick
It seems to be kind of poor not to be able to use switch on a string. If
I
use the dept number say (0305) instead of the name would this work or
would
Java freak on the 0 (zero). Our database treats these fields as varchar
since
the zero in front has meaning to the accounting people.
Yes,
I'm trying to parse an RSS feed and I'm at a loss as to what to do
with data in this format.
CF pukes when it hits the colon
The name would be like rss.channel.item.itms:artist.xmltext
Is the namespace for itms defined in the document's root element?
Like for example
rdf:RDF
John
For the most part it validates. The lines that don't pass muster are
date elements.
Here's the link in case anyone wants to take a look. Thanks a lot.
1: I think they call it brute force, where data access is in the
business objects themselves (queries right in the classes). This is
generally frowned upon.
It's correct to say that many OO-pattern-bandwagon-jumpers frown on this.
IMO it's also correct to say that for the majority
Does someone now ways to do some CFC caching?
Storing CFCs, including instance data, in the Session scope certainly seems
to work for me - I imagine Application would be the same.
I do it very simply like this:
cfif not isDefined(Session.cfcInstanceName)
cfobject component=cfcName
This works (assignment to an explicitly named array cell):
cfset ary = ArrayNew(3)
cfset ary[1][1][1] = 99
This works (assignment to a dynamically referenced scalar variable):
cfset scl = scalar
cfset #scl# = 99
This (assignment to a dynamically referenced array cell) throws an error:
cfset
What am I missing when trying to
access the pattern node?
cfdump.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
The types of functions you are describing need not be client based.
You could do this by just selecting an area of an image (a fairly easy
dhtml or flash function), then submitting the results to the server with the
imagename, function and select area.
Yes, this is exactly what we do. We have
I am looking for a tool/software so that I can create graphical
respresentation of processes.I guess something like Visio.
If you're looking for something on the desktop, SmartDraw works for me.
If you want something to integrate into a web app, there are 2 possibilities
worth mentioning:
-
Is there a problem with this Insert? I get an Incorrect syntax near the
keyword 'Where' error.
You can't have a where clause on an insert statement.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
You bulit this in Flash?
Yes.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
D'oh!*project* management, not *content* management.My bad.
Does anyone know of good project management system written in CF or maybe
JSP.
I could write my own but I just do not have the time as usually.
Funnily enough we have a project management system built into our content
management
1) didn't Netscape have a flaver of _javascript_ that supported push
technology -- called LiveScript?
You're thinking of LiveConnect, but that was simply an interface for
client-side communication between JS and applets.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast
Does anyone have a view on which of these is a better tool for stress
testing a Java-based web app on a remote Linux server and/or on local
Windows dev boxes? And why? Or is there a better free tool (eg MS WAS)?
What I'd like to achieve is an integrated approach where we can generate
HTTP
Is it possible to create a file system link or symlink with CFMX/Java?
The built-in java.io package doesn't provide any way to do this, because
it's a 'nix-specific thing.
Can be done in Perl though.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
i'm looking for any help to do this query works fine
SELECT
`groups`.`groupsDescr`,
`roles`.`roles_Agroup`,
`roles`.`rolesDescr`,
COUNT(`roles`.`rolesDescr`) AS TOTAL
FROM
`roles`
INNER JOIN `groups_roles` ON (`roles`.`rolesID` =
`groups_roles`.`fkrolesID`)
INNER JOIN `groups` ON
anybody heard of the Intranet/Hosting Toolkit for Coldfusion ?
Yes. A lot of people have used Lewis' tags over the years. Have you tried
mailing him? His address is on the site.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and
Can Awstats be used on a Shared server where I do not have access
to install application but to FTP files?
I think as long as there's a Perl interpreter installed and you have a
cgi-bin and your log files are in the right format you'll be OK.
You can definitely update the stats over the web as
Based on your signature Kev, is Sky Active etc running on CF?
If Kev won't comment, then I'd better not either. But this is what Jeremy
Allaire says:
http://www.meetthemakers.com/conversations/allaire/2/
(second-last paragraph)
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast
Jeff
I guess I am having an off day with SQL. I think technically this should
work but I get a syntax error
UPDATE Account a
SET a.last_update = (SELECT TOP 1 h.tranDate
FROM History h
WHERE a.Account_Number = h.Account_Number
ORDER BY h.tranDate DESC)
I would think this is likely to
Dave
I think I need to send an XML feed back to a client from the server, the
client machine is a touch screen that will remotely make a call to, I
think, a file on our webserver that will run a query on the database and
return the results - which I believe have to be in the form of an XML
Anybody recommend any good forums for XSL/XSLT beginners?
Books and all recommendations welcome.
I have a Wrox book by Michael Kay, who knows a thing or two about XSLT.
There used to be a related forum on wrox.com which Michael was on, so you
could always get an answer if your question was
Hello everybody. Thebelow code works, however when I
don't know how to put the same code in the
windows.open.
Put it in a function
script language=_javascript_
function openPopup(number, otherNumber) {
x = window.open(...);
}
/script
... >
Nick
[Todays Threads]
[This Message]
You should use numeric or decimal. Both are exact numeric types
which allows you to specify the precision. The main reason not to
use money is that it is not completely standardized, i.e. there
is no money type in the JDBC spec. Also, depending on your
requirements, using numeric and a
Now, I want to select only the latest article from each issue in a
single query. Any ideas how I would do this?
Kind of sneaky, but something like this will do it (substitute the relevant
type conversion string concatenation functions for your DBMS)
SELECTarticleIssueId, articleTitle,
Does anyone know of a simple visual representation of _javascript_
objects, properties, methods, etc. in a simple table view?
Mozilla Firefox DOM Inspector (in the custom install Developer Tools)
Or of course, ahem, Visual Interdev ;-)
Nick
[Todays Threads]
[This Message]
[Subscription]
Do a google search on 'Server Side Includes'.You should get a wealth of
information on it.
Or from a client-side perspective, there are many possibilities with
object, script (in conjunction with document.write) and iframe.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast
I imagine isDefined() works by using try/catch internaly
Since all the variable scopes are structs, I guess it just looks for the key
in the relevant struct(s).
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Just to play devil's advocate and also enjoy the unusual experience of
disagreeing with Dave - your proposed approach of adding a surrogate key is
our standard way of doing things. Even when the table is a simple
intersection table consisting of nothing but 2 foreign keys, we always make
the
Mozilla Firefox. Check out the extensions.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
My companies live hosting server was recently upgraded to Coldfusion
MX6.1 .. and the latest MDAC / Jet Drivers have been updated also.
The problem is that all coldfusion sites on the server using access
db's stop working every 2 days or so (more often if traffic is high)..
the only way to
Jochem
Have you tried the unicode driver?
Any particular reason why this might help?
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
BackOrder NOT LIKE '%HR%'could be causing you problems even if that field
is indexed, because you're not looking at the beginning of the field. Is
there anothere way of doing it?
For the title fields also, have you considered full text indexing?
Nick
[Todays Threads]
[This Message]
Jochem
It doesn't use the ODBC workaround. People have also reported dramatic
speed improvements with large datasets using this driver.
OK, very interesting, thanks.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Just curious, cause I don't know Sql Server... In oracle, those null
checks
on URL and BackOrder would also cause problems because they would negate
any
indexes on those fields.Is that the case in Sql Server?
I don't think they would make the index unusable, but obviously IS NULL and
IS NOT
The proper way to do this is to perform the syntax check yourself, and
only call CFMAIL if necessary.If anything, CFMX should be kind enough
to add a new function isValidEmail() since most webapps do it pretty
often.
Does cflib count?
http://www.cflib.org/udf.cfm?ID=216
Nick
[Todays
1 - 100 of 202 matches
Mail list logo