Jon,
Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on
Windows boxes? If so, what version(s) for both the db server and windows
servers?
The cost is currently not an issue, although it certainly has the potential
to become one in the relatively near future, at the current
On Monday 08 January 2007 20:42, Anthony Cole wrote:
I started looking into this matter a little and the protocol is easy to
crack. I only coded 3 functions, but I found many other operations by
playing with IIS logs.
Cool.
What would rock would be writing up a list of which methods have been
even then, I have not seen a way to create sql injection attacks with CF
Russ,
One particularly nasty example I have seen in action is an attack against
mssql db's using EXEC sp_cmdshell.
You can then run any dos command via mssql
I agree with Matt, - its better to err on the side of caution
Matt Quackenbush wrote:
Thanks for the reply. I forgot to post his specific gripes about it. Here
is a quick summary:
- non-standard sql
I think that depends on what you call 'standard sql'. To me, standard SQL is
what is defined in ISO/IEC 9075 and few do better then PostgreSQL in that
On Friday 05 January 2007 15:59, Dwayne Cole wrote:
Thanks Tom for what ever help you can give.
Right. Try with Eclipse 3.2 and the new Flex 2.0.1 :-)
--
Tom Chiverton
Helping to efficiently administrate six-generation IPOs
This email is
Hi Mike
I would take the approach of passing the user object in as part of your DAO
save (or create and update) method.
cfset widgetDAO = application.factory.getBean(WidgetDAO)
cfset widgetDAO.save(widget,session.currentUser)
Just as you only need a singleton factory, you also only need
Matt Quackenbush wrote:
I've always used MSSQL and quite frankly am quite fond of it - except for
licensing costs. I've read a few posts here and there where people have
talked highly of PostgreSQL, so I'm thinking about giving it a shot on a new
server (windows box). I mentioned this to a
Russ wrote:
In my experience, it only slowed things down. Now, YMMV, but I've noticed
that the more cfqueryparams you have in your query, the slower it will run.
What did you test? How did you test it? How many simultaneous users?
Although theoretically the sql engine should have an easier
Andy Matthews wrote:
A query has an incoming value which is the result of a previous query:
WHERE id = #Val(getsite.id)#
Should something like this be using a cfqueryparam or is it okay to leave as
is?
What happens if getsite does not return any rows? If you have that covered and
Jochem van Dieten wrote:
wondering if the users here would care to share their personal + vs. -
arguments for PostgreSQL?
+ rich SQL support
+ easy to install / configure
+ portable
+ low resource usage
+ excellent documentation
+ great community support
+ many options for commercial
Alright! This works fine thanks.
I don't want do rewrite my variable scoping for this app, but I'll
consider having everything in Variables for the future as I write
this up as a general include.
It may be helpful to know/recall that all local variables live in a
scope structure called
Of the four versions of SQL Server 2000 that are available,
only the personal version of SQL Server 2000 can be installed
on aWinXP machine. All other versions must be installed on a
Windows server system (Win2K, Win2K3, SBS, etc.)
No, you can also install SQL Server 2000 Developer on
I agree, I think every database has some non-standard SQL.
An example in MS SQL is the isNull() function, which is
functionally equivalent to the ANSI standard coalesce(). Why
did MS make their own? Who knows, maybe because they liked
their name better?
SQL Server also supports
Hi all,
One of our CFMX 7 applications (which was working fine before) suddenly
started throwing this error - SQL Server Error 8179: Could not find prepared
statement with handle x. The funny part is, it throws the error at pretty
much any point in the application without any apparent reason in
George,
We ran into the same problem a few months ago. What we found was the
error was thrown on random queries that had CFQUERYPARAMs in them (which
was almost every query in our application). Somewhere on the net I
found an article explaining that it had something to do with the
drivers. We
I've seen this before but just worked around it with a cfif in the SQL.
SQL Server, smallmoney data type for this field.
Here's the SQL:
prodconsignmentprice = cfqueryparam cfsqltype=cf_sql_money
value=#ARGUMENTS.prodconsignmentprice#
If you submit a blank value, you get this error:
On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote:
Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on
Windows boxes? If so, what version(s) for both the db server and
windows
servers?
Both. 8.2 for Postgres and 5.1 for MySQL.XP Pro and Server 2003
for the OS.
SQL Server also supports COALESCE. And, while the two are very similar,
they
aren't identical in functionality. A Google search on coalesce vs isnull
turns up all sorts of mildly interesting stuff.
You're right on both counts, Dave. My main point was that MS even bothered
to make a
Adrian,
Sorry, I didn't get a chance to dig around the FarCry admin
yesterday. My mission for the day took me longer than I expected. :-)
I'll see if I can't help out today.
Jon
On Jan 9, 2007, at 2:01 AM, Adrian Wagner wrote:
Just to keep you in the loop. We were actually using TinyMCE
Hmm, we did have other problems with the current drivers we are using that
was shipped with the product by (then) Macromedia. Mayve we can look at this
driver you mention.
Thanks,
George
On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote:
George,
We ran into the same problem a few months ago.
I'm pretty sure you can use the brackets around the column name in
queries from Access tables also. Not so sure how far this fix would go
though--updates to the tables, etc.?
If it were me, I'd require them to rework to avoid the reserved words.
That's just plain bad practice.
It would not be
The drivers we used are located at http://jtds.sourceforge.net/
Rich Kroll
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 09, 2007 10:02 AM
To: CF-Talk
Subject: Re: SQL Server Error 8179: Could not find prepared statement
with
handle x
Have you tried using the NULL attribute of CFQUERYPARAM? I've done
something like NULL=#NOT
YesNoFormat(LEN(ARGUMENTS.prodconsignmentprice))# to handle this type
of thing.
Rich Kroll
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 09, 2007
Coalesce is a WAY cooler name. Those guys at MS must have been smoking
crack!
Andy Matthews
Senior Coldfusion Developer
Office: 877.707.5467 x747
Direct: 615.627.9747
Fax: 615.467.6249
[EMAIL PROTECTED]
www.dealerskins.com
-Original
Daniel Kessler wrote:
I don't want do rewrite my variable scoping for this app, but I'll
consider having everything in Variables for the future as I write
this up as a general include.
You wouldn't have to - his point is, every var called variablename is
also referenceable as
If you submit a blank value, you get this error:
Invalid data for CFSQLTYPE CF_SQL_DOUBLE.
An empty value is not a number. Use the NULL attribute as Richard suggested,
if your database column accepts nulls.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software
Hi Mark,
Thank you for the additional information there. I really appreciate it.
Are you aware of anyone who currently runs MS SQL in case sensitive
mode? I'd be curious to know how often that happens.
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
Blue Dragon
Hi, all.
Would it be better to identify users of a common app by
CGI.HTTP_HOST and put in my Application.cfm (yes, .cfm. CF 4.5 here)
lines such as:
CFIF CGI.HTTP_HOST contains bodaford_homes.com
CFSET DSN = bodaford_homes
CFIF
or
Should I automate the process of DSN identification by
I have a .net web service that I believe has an invalid WSDL.
I have been previously told (by Dave Watts) that you can download a WSDL
locally and create a web service form that.
This seems like the solution for me to fix and test the WSDL, but how exactly
does one do this.
Just saving the WSDL
Hi folks,
The environment is SQL Server 2000 and CFMX 7.0.1
Here's the scenario. I have two tables. One is the primary table of data
(let's call it USERS), the other is a table (say, USERS_UPDATED) with
identical columns that stores a date in each column representing the
last updated date of the
does anyone know of some good tags out there to get real time UPS shipping
rates? The tag i am currently using doesnt seem to be working well.
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7
http://cfups.riaforge.org/
On 1/9/07, Chris Musial [EMAIL PROTECTED] wrote:
does anyone know of some good tags out there to get real time UPS shipping
rates? The tag i am currently using doesnt seem to be working well.
~|
http://cfups.riaforge.org/
On 1/9/07, Chris Musial [EMAIL PROTECTED] wrote:
does anyone know of some good tags out there to get real time UPS shipping
rates? The tag i am currently using doesnt seem to be working well.
where CF 7 isnt required...
Try joining the two user tables rather than doing tons of single-row
queries on the updated table. Unfortunately you will have to alias all
of the columns from one of the tables to get unique column names. (You
might do a single query of the users table that returns zero records
just to get the
nevermind, I sorted it :-)
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
How old of a version are you looking for? I have ups script for version
4 or 5
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
From: Chris Musial [mailto:[EMAIL
Sorry if I was unclear: I'm not doing any single row queries...here's
the code which may make it clearer.
It's a bit out of context, since this is part of a CFC which is being
called as a web service. I'm making it procedural for simplicity:
The queries (no performance issues here - they
Thanks,
George
On 1/9/07, Richard Kroll [EMAIL PROTECTED] wrote:
The drivers we used are located at http://jtds.sourceforge.net/
Rich Kroll
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7
How old of a version are you looking for? I have ups script for version
4 or 5
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
From: Chris Musial [mailto:[EMAIL
I believe I have used this version for 6.1 and it works. If you are
interested how would you like me to send it to you?
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
I'm making a flash form that contains an input field of type datefield,
which puts in that cool little flash calendar date selector. The problem is
that I've got limited space in the form, and I would like to remove that
little calendar icon that shows up by the date. Is this possible? I've
In a SQL query without the dynamic column list, is this what you are
trying to achieve?
SELECT u.id
FROMusers u
INNER JOIN users_updated up
ON u.id = up.id AND up.lastupdated = cfqueryparam
cfsqltype=cf_sql_date value=#since#
WHERE u.id IN (
I believe I have used this version for 6.1 and it works. If you are
interested how would you like me to send it to you?
Steve LaBadie, Web Manager
East Stroudsburg University
200 Prospect St.
East Stroudsburg, Pa 18301
570-422-3999
[EMAIL PROTECTED]
http://www.esu.edu
-Original Message-
I have a site on my laptop under Nascar. The CFC directory is Nascar.cfc. On
the live server though the root directory is SynergyDale. So of course my
CFC's cannot be found. Do I need to change the directory name on my laptop
to SynergyDale or is there a way for me to keep my directory the same
Can you add mappings?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the
Nope. Cannot add mappings.
On 1/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
wrote:
Can you add mappings?
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number
Bruce,
Create a mapping in the CF Admin on your local machine for /
SynergyDale pointing to the /nascar/ directory.
Then use SynergyDale.cfc as your cfc object reference.
You can also do the reverse on the remote server if you wish.
HTH,
Jon
On Jan 9, 2007, at 1:39 PM, Bruce Sorge wrote:
Straight from livedocs
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/buildi12.htm
Specifying the CFC location
When you instantiate or invoke a component, you can specify the component
name only, or you can specify a *qualified* path. To specify a qualified
path, separate the directory
I figured it out. Just droped the SynergyDale and use CFC.Queries.
On 1/9/07, Jon Clausen [EMAIL PROTECTED] wrote:
Bruce,
Create a mapping in the CF Admin on your local machine for /
SynergyDale pointing to the /nascar/ directory.
Then use SynergyDale.cfc as your cfc object reference.
My particular way around this is to set a CFC path variable in the application
scope. So I call CFC's like this:
cfset application.CFCpath = cfc /
Or
cfset application.CFCpath = synergydale.cfc /
cfobject component=#application.cfcPath#.nascar name=nascarObj
Yeah it's extra typing, but is a
Thanks
Unfortunately, simply having the two tables joined doesn't help.
The issue isn't getting the correct data, it's simply that to get the
output I need, I have to loop over each column in each record to see
which column has been updated in a given time period, and output the
info about that
If anyone plans on using GoDaddy for CF hosting, be careful There are some
tags that they do not suport, like CFDUMP. I have in my Application.cfc a
cftry-catch block that does a query on a table on only the first row to make
sure that there is a connection to the database, and if not it throws a
that seems...odd.
can you just throw a template up there with a cfdump var=#cgi#
just for shits and giggles?
On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote:
If anyone plans on using GoDaddy for CF hosting, be careful There are some
tags that they do not suport, like CFDUMP. I have in my
I would look into this a little deeper. There would be no reason for a host
to block cfdump. The cfobject tag I understand though. Just so you are
aware Bruce, it is pretty common for hosts (not just GoDaddy) to block
certain tags or take the route of implementing security sandboxes.
Dan Vega
OK. I was mistaken. The error seems to be with the onApplicationStart
section of the Application.cfc. Funny thing is that it works on my laptop
and testing server. More troubleshooting. Gotta love it.
BTW, here is where you can see the error:
www.dalethemovie.com/Offers
On 1/9/07, Dan Vega
Jon,
Thanks for the clarification.
Matt
On 1/9/07, Jon Clausen [EMAIL PROTECTED] wrote:
On Jan 9, 2007, at 3:23 AM, Matt Quackenbush wrote:
Thanks for the reply. Do you currently run MySQL and/or PostgreSQL on
Windows boxes? If so, what version(s) for both the db server and
windows
Jochem,
I was hoping that you would respond. I've seen a number of your posts
regarding PostgreSQL, and certainly wanted your opinion. :-)
We all know what opinions are like, which is why I didn't want to just take
my friend's opinion as the end-all official truth. Thanks to you all, I
So if I comment out the CFDUMP tag, then all works fine. If I put the
#Arguments.Exeption# in a CFOUTPUT, I
getcoldfusion.runtime.EventHandlerException: Event Handler Exception. Any
thoughts?
Bruce
~|
Create robust enterprise,
do what Charlie said.. just do something like
cfset fooVar = Goo /
cfdump var=#fooVar# /
If that doesnt work, then it's a problem with Google.
On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote:
So if I comment out the CFDUMP tag, then all works fine. If I put the
#Arguments.Exeption# in a
cfdump var=#arguments#? see if that works and if so, what it displays.
should the variable be spelled exception (as opposed to exeption)?
On 1/9/07, Bruce Sorge [EMAIL PROTECTED] wrote:
So if I comment out the CFDUMP tag, then all works fine. If I put the
#Arguments.Exeption# in a CFOUTPUT, I
I did what Charlie said and it worked. So there is someting else wrong. I am
working on it now.
On 1/9/07, Greg Morphis [EMAIL PROTECTED] wrote:
do what Charlie said.. just do something like
cfset fooVar = Goo /
cfdump var=#fooVar# /
If that doesnt work, then it's a problem with Google.
Thanks for the extra set of eyes Charlie. It works now.
On 1/9/07, Charlie Griefer [EMAIL PROTECTED] wrote:
cfdump var=#arguments#? see if that works and if so, what it
displays.
should the variable be spelled exception (as opposed to exeption)?
On 1/9/07, Bruce Sorge [EMAIL PROTECTED]
So I need to retract the lack of support for CFDUMP. They do support it.
CFOBJECT though they do not. Not a problem though really. GoDaddy is pretty
good otherwise though. Inexpensive to host. The only complaint that I would
have is lack of support for using Enterprise Manager on the SQL Server.
Rich,
Thanks for the kick-ass reply. Somehow it got buried beneath the piles of
email, and I just now saw it; sorry about that. Your post is most
informative, and very helpful.
As of a couple of days ago, being 6+ weeks behind on a project that I was
going to run on my new framework has made
I'm not sure whether or not the 8125 has Flash, but if it does, you can
capture the signature, save the bitmapData and convert it to an image with
CF than save it to a DB.
You'd have to be clear that the signature you get no matter the interface,
won't be as good as one captured by pen.
Cheers,
Same here, I am in NY, so definitly through the Adobe Connect, if that can
get set up.
A very good idea, by the way.
On 1/3/07, Dan Vega [EMAIL PROTECTED] wrote:
If you get connect setup I would defiantly be interested in attending as
long as it doesnt conflict with current user group
Matt,
Glad I could help. Good luck on your project and the OO adventure!
Rich Kroll
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
I think this is a bit of an OOD type question. I'm developing a project for
managing structured news content that is currently done with the separate tools
for different type of news.
I've created a front end I am fairly happy with that allows me to define the
structure of each of the news
When I use CFQUERYPARAM with an Oracle database, I receive the error query not
properly ended.
ALWAYS use CFQUERYPARAM...it's not just for stopping SQL injection
attacksit
also increases query speed by using BIND variables (at least with Oracle and
MS
SQL Server.not Accessnot
When I use CFQUERYPARAM with an Oracle database, I receive the error query not
properly ended.
When I use CFQueryParam with several Oracle databases (8.x to 10g), it works
exactly is it is supposed to.
Maybe more details about your code and the exact error and we could help.
--
Are you aware of anyone who currently runs MS SQL in case
sensitive mode? I'd be curious to know how often that happens.
Quite a few people do this, in my experience. You can specify different
collations for each database within an instance. Collations determine other
things in addition to
On 1/8/07 7:29 PM, Matt Quackenbush wrote:
- non-standard sql
It is different to SQL Server, but that doesn't mean that SQL Server is
standard compliant either. In 8.x they've made many tweaks to make it even
more standards compliant in its syntax, so please have him check his facts.
-
On 1/8/07 8:40 PM, Jacob Munson wrote:
I agree, I think every database has some non-standard SQL. An example in MS
SQL is the isNull() function, which is functionally equivalent to the ANSI
standard coalesce(). Why did MS make their own?
Now() vs GetDate(), etc.
--
Damien McKenna - Web
Doug,
After seeing your intended output the query will need to change a bit,
but I think I understand what you are after.
Could you do something like this: (beware this SQL psudeo-code it's
untested)
declare @User_modify table(
UserID int,
FieldName nvarchar(50),
NewValue
On 1/9/07 6:03 AM, Jochem van Dieten wrote:
The only thing I miss in PostgreSQL is eager update-everywhere replication.
There are commercial offerings for that, but all the community offerings are
either lazy or master-slave.
I'll second that, I read through the manual and instantly wanted to
Ian,
I hope I'm understanding you correctly; but I'm assuming you mean that the
form data, taken together, essentially constitutes a record in your data
source. If so, I think you want to use a transfer object that receives and
carries that data along.
While I'm not educated enough to give you a
I have a flash menu that is being dynamically created using an XML
file with the navigation schema. The XML file is currently hard coded,
but I would like to make the url path attributes dynamic so that I
don't have to maintain two different xml files (one for my local
environment and one for the
I have a form that has two radio buttons. Their function is to show one of
two hidden divs.
The JS is this:
script language=JavaScript
function toggle('with', 'without')
{
if (document.getElementById) {
withvbm= document.getElementById('with');
withoutvbm= document.getElementById('without');
}
if
few things i can see would be a problem.
you have multiple elements with ids with and without (the radio
buttons and the divs).
the code below should work.
script language=JavaScript
function toggle(divToShow) {
if (document.getElementById) {
if
Jon,
I actually lodged a bug report on sourceforge. This is the reply I
got:
IE:s selection gets lost sometimes if you focus another iframe inside
thesame document. The inline popup plugin has this issue but it's
resolvedusing the following method: Use the var b =
I am trying to use the iText with coldfusion to dynamically generate a PDF on
the fly (cfdocument is way too limited). I have no problem setting the images
at absolute positions, however when I try to set text at absolute positions
using various methods, I get an error that says Class
Thanks - I'll give that a try.
-Original Message-
From: Richard Kroll [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 1/9/07 5:03 PM
Subject: RE: Getting changed fields from database using an audit table
Doug,
After seeing your intended output the query will need to change
Thanks Charlie. That did it.
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 09, 2007 4:20 PM
To: CF-Talk
Subject: Re: JS and Radio Button Issue
few things i can see would be a problem.
you have multiple elements with ids with and without (the
I'm trying to find the excellent breeze presentation Ray Camden gave on
Application.cfc - there's someone at my client's office i'd like to see
it.Today it seems, google is NOT my friend because i can't bring up any
reference to it.
Can anyone point me at the recording of Ray's presentation
Indeed, by their very nature you should not have dupe ids on a page.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
I've done a global search/replace with eclipse many times, but it has to be
within a project, not within an arbitrary filesystem.
Russ
-Original Message-
From: RobG [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 27, 2006 2:27 PM
To: CF-Jobs-Talk
Subject: Re: Need CF 5 Studio
Greetings!
My name is Raj I am a technical recruiter for ICONMA and have the following
position requirement with our direct client.
Pl let me know your interest in the following position and pl call me 1 888
309 7572 (24x7)for any info you may need.
Please e-mail your resume to [EMAIL
Hi Raj,
Do you prefer people from India?
Regrads,
Glence
-Original Message-
From: Raj Muppalla [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 6:05 AM
To: CF-Jobs-Talk
Subject: Coldfusion Jobs:DEV89467: Sr. Application Developer: Detroit, MI
(2positions)
Greetings!
My
88 matches
Mail list logo
