Lose the single quotes around the CFQUERYPARAM ... it already handles that
for you:
UPDATE dbo.Courses
SET CourseName = '#Trim(form.coursename)#',
CourseDesc = cfqueryPARAM value=#form.coursedesc#
CFSQLType=CF_SQL_longvarchar /,
Cost = #form.cost#,
MaxStudents =
Remove single quotation marks from around the cfqueryparam tag
Matt
On 14 Jul 2009, at 19:55, Rick Sanders c...@webenergy.ca wrote:
OK, I'm updating a record in my MSSQL database table. The column that's
causing the error is an ntext column.
The error I'm getting is:
When I do that I get this error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
The only html tags in the content are p and br /.
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: July-14-09 4:00 PM
To: cf-talk
Subject: re: Weird error
Lose
in the content are p and br /.
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: July-14-09 4:00 PM
To: cf-talk
Subject: re: Weird error
Lose the single quotes around the CFQUERYPARAM ... it already handles that
for you:
UPDATE dbo.Courses
SET CourseName = '#Trim
...@yahoo.com]
Sent: July-14-09 4:13 PM
To: cf-talk
Subject: Re: Weird error
Out of interest change the datatype to cf_sql_varchar and yes cfqueryparam
all the variables.
Matt.
On 14 Jul 2009, at 20:06, Rick Sanders c...@webenergy.ca wrote:
When I do that I get this error:
[Macromedia][SQLServer JDBC
Rick Sanders c...@webenergy.ca wrote:
Tried and still getting the same error. [Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near ''.
cfquery name=upcourse datasource=cft
UPDATE dbo.Courses SET CourseName=cfqueryPARAM value = #form.coursename#
CFSQLType =
.
Thanks for all your help!
-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca]
Sent: July-14-09 4:38 PM
To: cf-talk
Subject: RE: Weird error
Tried and still getting the same error. [Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near ''.
cfquery name
]
Sent: July-14-09 4:38 PM
To: cf-talk
Subject: RE: Weird error
Tried and still getting the same error. [Macromedia][SQLServer JDBC
Driver][SQLServer]Incorrect syntax near ''.
cfquery name=upcourse datasource=cft
UPDATE dbo.Courses SET CourseName=cfqueryPARAM value = #form.coursename
Sorry I forgot to put my name. My Name is Randy. Thank you for your help.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your
I usually get this when a non-date is passed to a function needing a date.
On 5/16/06, fsu__grad [EMAIL PROTECTED] wrote:
Any one had a Null Null error?
I have had this in other pages once and I renamed them and uploaded a
new copy and it worked.
Server is windows 2000, iis, and cfmx not 7.
. If you have received this communication in error, please notify
us immediately by replying to the message and deleting it from your
computer.
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 16, 2006 11:19 AM
To: CF-Talk
Subject: Re: Weird Error
I usually get
Late to the party so I don't know if this was already resolved...
I've seen this error before as well and I've been able to figure out the
problem but haven't had time to figure out which browser(s) is/are the
culprit(s). Apparently, some clients tend to URLEncode a URL (or the query
string
It's usually hard to diagnose this error because the error logs are
usually
viewed as HTML and any escaped characters (like the amp; in the above,
misinterpreted URL) are displayed unescaped.
Ah ah, that at least a good lead indeed.
The last error of that type has gone out of the database, but
I will also check for the type of browser.
By the way, it must be some pretty cheap browsr to do so ;-/
I'll bet it's Internet Exploder. ;)
[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure
Hi,
I have this weird error in a template (CF 5). I would say
it works 99.9%
of the time, but once in a while I get this:
Error resolving parameter STAT
ColdFusion was unable to determine the value of the
parameter.
blah blah blah...
template = F:\\INDEX.CFM
the end result is that when the user clicks the link in their
email client the server receives a url like this:
http://./index.cfm?p=partenairesst
I see what you mean, but I have a module that traps all errors, and the
query string
is registered in the error table.
It shows
queryString =
the end result is that when the user clicks the link in
their
email client the server receives a url like this:
http://./index.cfm?p=partenairesst
I see what you mean, but I have a module that traps all
errors, and the
query string
is registered in the error table.
It shows
If stat was defined in another scope, then it should not be declared
undefined anyway.
When the scope is not specified, CF is supposed to look in all scopes,
including URL,
so stat should be defined here (stat=P)
I know Claude, but what if the param came in via the URL, but was scoped in the
but what if the param came in via the URL, but was scoped in the
FORM scope in the receiving template??
Hmm, yes I could look into the url and form scopes myself, just to make
sure,
but it would still be an oddity that the variable is set in the form
scope when
the template was called by GET.
I don't know about that. Granted, I'm not on CF5, but when I run the
code below, I get 1 -- not an error.
cfscript
url.a = 1;
form.a = 2;
attributes.a = 3;
WriteOutput(a);
/cfscript
So, unless it was different in CF5 (and it might have been-I don't
remember), I don't think having it defined in
Hmm, yes I could look into the url and form scopes myself, just to make
sure,
but it would still be an oddity that the variable is set in the form
scope when
the template was called by GET.
It also happens from time to time with another template and another
variable.
and I'm just saying
I don't know about that. Granted, I'm not on CF5, but when I run the
code below, I get 1 -- not an error.
cfscript
url.a = 1;
form.a = 2;
attributes.a = 3;
WriteOutput(a);
/cfscript
So, unless it was different in CF5 (and it might have been-I don't
remember), I don't think having it
just saying it could be a scoping issue for whatever reason.
If it was that, I would have an erreor every time the template is
called, not one every 1000 times ;-/
--
___
REUSE CODE! Use custom tags;
See
So, unless it was different in CF5
No, it is not different, I think the URL is the 6th scope searched, then
FORM, then ATTRIBUTES,
so it is correct.
What is not correct is that a variable passed in the url is not found at
all,... once every 1000 times...
--
OK, I'm with you on that one. I wasn't following you, as I was just
thinking the whole time that he was referencing it without scope, which
I believe is the case. Anyhow, I now see where you were trying to go.
And this bring us to the real heart of the matter. Why don't you
reference the scope
If it was that, I would have an erreor every time the template is
called, not one every 1000 times ;-/
Yes most likely that's true, but what if the offending code is in a CFIF block
that only firesd every 1000 requests
I said it was an outside shot ;-)
Bryan Stevenson B.Comm.
VP Director of
The above line would fail if the only foo was URL.foo passed in via
the URL.
Of course it would, but it would 100% of the time, and
cfif foo eq 5 should not fail ever. This is my issue.
--
___
REUSE CODE! Use custom tags;
See
why not post the code that is failingperhaps another few hundred sets of
eyes will spot something?
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web:
Not necessarily, say stat was a checkbox or some such that was added to
the form dynamically by way of selecting something in a dropdown, but it
didn't always exist in the form. Then when the form submitted it
wouldn't exist in the form scope at all for those situations - it would
for other
That's what I'm saying about adding the url. in front of it. Why
depend on should not... Why not be sure? Why not tell the app exactly
where stat will be and where to look for it? I just don't understand why
you'd elect to let CF go searching through the scopes looking for it,
when you could
Not necessarily, say stat was a checkbox or some such that was added to
the form dynamically by way of selecting something in a dropdown, but it
didn't always exist in the form. Then when the form submitted it
wouldn't exist
This discussion is going nowere :
The field is NOT in a form, it is
Why don't you reference the scope Claude?
As I said, I want the template to be callable both with POST or GET,
But I'll try to modify the code to find the variable in any scope myself,
and see if it makes any difference.
If it does, then there is a bug in the scope searching process in CF, if
cfif IsDefined(URL.stat)
cfset FORM.stat = URL.stat
/cfif
Then use the FORM scope for all references to stat in the page
crawling back under my rock now
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax:
Why not :
The page is called with ... index.cfm?p=partenairesstat=P
CFPARAM NAME=id DEFAULT=
CFQUERY DATASOURCE=#application.applicationName# NAME=GetMembers
SELECT orgs.*,
logo.fileName AS orgLogo,
users.*
FROM ((orgs LEFT JOIN images AS logo ON orgs.logo = logo.imageID)
It could be like someone said. You are only calling stat when your id
is blank. But again, if you are doing a cfcatch (I don't see that
here), and dumping the URL string, you should not get this error.
Unless 'stat' is some kind of reserved word in CF5, or something like
that. You might also
But again, if you are doing a cfcatch (I don't see that here),
Actually, it is not a catch, I use CFERROR, but the result is the same.
The queryString is found correct in error.queryString
I've made an error processor which catches and logs all errors,
it helps to debug an application.
Unless
could the stat var that it is having an issue with be scoped in another scope
from URL?
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web:
I have also seen this if the page is being fetched at the very moment
the cf server is going down.
Check the cf cerver logs to see if a restart was happening at that time.
On 3/15/06, Claude Schneegans [EMAIL PROTECTED] wrote:
Hi,
I have this weird error in a template (CF 5). I would say it
could the stat var that it is having an issue with be scoped in
another scope from URL?
If stat was defined in another scope, then it should not be declared
undefined anyway.
When the scope is not specified, CF is supposed to look in all scopes,
including URL,
so stat should be defined here
Try wrapping val(last_mail)+1 in an evaluate()
#evaluate(val(last_mail)+1)#
-Original Message-
From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 12:49 PM
To: CF-Talk
Subject: Weird error message
Any ideas anyone please?
Strange error running:
the cfc.
Jenny
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: 24 January 2006 19:08
To: CF-Talk
Subject: RE: Weird error message
Try wrapping val(last_mail)+1 in an evaluate()
#evaluate(val(last_mail)+1)#
-Original Message-
From: Jennifer Gavin-Wear [mailto
I don't really want to get into a which is better discussion, but I wanted to
share my experience with SP2. I've never had a problem with it. Mostly
because I just bought a new computer - and didn't have to deal with updating it
before all my crap got on it.
I can understand why M$ wants to
-Original Message-
From: Peter Farrell [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 06, 2005 12:13 PM
To: CF-Talk
Subject: Re: WEIRD error causing cfadmin to not work
I don't really want to get into a which is better discussion, but I wanted
to share my experience with SP2
which updater? cfm or sp2?
From: Will Tomlinson [EMAIL PROTECTED]
Sent: Saturday, February 05, 2005 9:42 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: WEIRD error causing cfadmin to not work
A while back I got my new computer, Godzilla, XP, SP2,
No CF updater currently.
It's weird man, it was all working and I added a DSN for the clothing site a
month or so ago, but haven't been in there since. Now it's broken again!
coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V
Only on DSN admin page, and settings summary page.
I already tried restarting cf, rebooting, everything. No go.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
: WEIRD error causing cfadmin to not work
No CF updater currently.
It's weird man, it was all working and I added a DSN for the clothing site a
month or so ago, but haven't been in there since. Now it's broken again!
coldfusion.tagext.lang.SettingTag.setRequestTimeout(J)V
Only on DSN admin page
Yep, everything cleared out. Still erroring.
El Bizarro!
Gotta be this damn XP/SP2!
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
-Talk cf-talk@houseoffusion.com
Subject: Re: WEIRD error causing cfadmin to not work
Yep, everything cleared out. Still erroring.
El Bizarro!
Gotta be this damn XP/SP2!
~|
Logware (www.logware.us): a new and convenient web
From: dave [mailto:[EMAIL PROTECTED]
lol totally! i swear everything is ms's fault!!!
i seriously dont know why ppl put sp2 on, doesnt make their
puters anymore secure, sure it may help a few of the old
probs but there are so many new ones with sp2 why bother? i
thinks its pretty
: Sunday, February 06, 2005 1:23 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: WEIRD error causing cfadmin to not work
From: dave [mailto:[EMAIL PROTECTED]
lol totally! i swear everything is ms's fault!!!
i seriously dont know why ppl put sp2 on, doesnt make their
puters anymore secure
From: dave [mailto:[EMAIL PROTECTED]
i doubt it Michael
its easy to diss them because they screw everything up
so its the operators fault when they dl sp2 and it shuts off
cfmx server?
yeah thats the operators fault
its also the operators fault cause of all the holes and
breaches,
their
browser? man, they are 1 messed up company
From: Michael T. Tangorre [EMAIL PROTECTED]
Sent: Sunday, February 06, 2005 1:48 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: WEIRD error causing cfadmin to not work
From: dave [mailto:[EMAIL PROTECTED]
i
John, if you are on Windows and you look in IIS MMC is there an entry for
CFDOCS?If so remove that entry.Hth.
Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net
Webapper Web Application Specialists
-Original Message-
From: John
Has anybody seen this error message?
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code. Null Pointers
are another name for undefined values.
There is this one user
Are you saying that we should never set coolie values to in MX?
GAbriel
Dave Carabetta wrote:
Has anybody seen this error message?
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or
Are you saying that we should never set coolie values to in MX?
I believe it's related to this TechNote, although you'll note that it was
last updated in November 2002.
http://www.macromedia.com/support/coldfusion/ts/documents/tn17009.htm
I think that in previous versions, you might get the
Great!! Thanks for the hint!
Gabriel
Dave Carabetta wrote:
Are you saying that we should never set coolie values to in MX?
I believe it's related to this TechNote, although you'll note that it was
last updated in November 2002.
I have clientmanagement=Yes and I think it defaults to the registry
But when I put clientmanagement=No... No more error... Any ideas?
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 6:28 AM
To: CF-Talk
Subject: Re: weird error
Has
I have clientmanagement=Yes and I think it defaults to the registry
But when I put clientmanagement=No... No more error... Any ideas?
That could be a situation where your registry is full. Can you dig into it
and see how big it is? Are you on Window? Unix? I deleted the old posts, so
I
[mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 10:58 AM
To: CF-Talk
Subject: RE: weird error
I have clientmanagement=Yes and I think it defaults to the
registry But when I put clientmanagement=No... No more error...
Any ideas?
That could be a situation where your registry is full
: RE: weird error
I'm on cfmx/win2k.. But the user is able to log onto another computer. Its
only happening on that one computer that I'm aware of. I'm also able to go
to our development site from there also.. Yes.. I'm working on moving client
vars to the db =)
-Original Message-
From
We had a similar problem but with cfdump after running an updater...
Goto your C:/CFusionMX/wwwroot/WEB-INF/cfclasses/ directory and delete the
.java and .class files relating to the cfselect and you should be alright...
HTH
Mikey
=
Citeren Shahzad.Butt [EMAIL PROTECTED]:
Today, thinking of normal day I typed in my site address. Clicked on a
link and its giving following error. Does anyone knows what this error
is all about and how come its appearing without anything being changed.
Thanks in advance
Errors reported
Thanks, it works after deleting both .class and .java files
-Original Message-
From: Jesse Houwing [mailto:[EMAIL PROTECTED]
Sent: 03 March 2003 11:45
To: CF-Talk
Subject: Re: Weird Error Message
Citeren Shahzad.Butt [EMAIL PROTECTED]:
Today, thinking of normal day I typed in my site
If you don't specify a timeout for cfexecute, it doesn't wait for it to
finish. Therefore, the process can still be running and the output file
not ready. Add a timeout to your cfexecute call.
===
Raymond Camden, ColdFusion Jedi
Try:
C:\Output.TXT
[EMAIL PROTECTED] 10/10/02 04:45PM
trying to run this,
cfset count1 = #GetTickCount()#
cfexecute name=c:\ImageMagick\identify.exe
arguments=#args#
outputfile=c:\output/cfexecute
cfset count2 = #GetTickCount()#
cfset duration = count2 - count1
cffile
PROTECTED]
Sent: Thursday, October 10, 2002 4:55 PM
Subject: RE: weird error!
If you don't specify a timeout for cfexecute, it doesn't wait for it to
finish. Therefore, the process can still be running and the output file
not ready. Add a timeout to your cfexecute call
Are you using CFMX and CFC in persistent scopes (session, application...)?
Benoit Hediard
www.benorama.com
-Message d'origine-
De : Kevin Wong [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 10 septembre 2002 17:11
À : CF-Talk
Objet : Weird Error.
This is a multi-part message in MIME
Nope, using CF5.
-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 11:27 AM
To: CF-Talk
Subject: RE: Weird Error.
Are you using CFMX and CFC in persistent scopes (session,
application...)?
Benoit Hediard
www.benorama.com
Found my problem, basically I was URL decoding it twice... my bad.
=P Doing too much at once.
Date: Fri, 26 Jul 2002 23:44:57 -0400
To: [EMAIL PROTECTED]
From: Todd [EMAIL PROTECTED]
Subject: Re: Weird error
er.. cfusion_decrypt().. and, yes, I know it's undocumented code. I
recall voting
On Friday, July 26, 2002, at 07:03 , Todd wrote:
First time I've ever seen an error message without a real error message
(errr.. Axis errors not included) since beta, this is literally all that
is
displayed, no reason why, no nothing...
...
35 : tempStruct.username =
An obscure message:
Error,jrpp-41,07/26/02,22:04:38,myApp,null The specific sequence
of files included or processed is: D:\Dev\websites\myapp\registration.cfm
At 07:11 PM 7/26/2002 -0700, you wrote:
On Friday, July 26, 2002, at 07:03 , Todd wrote:
First time I've ever seen an error message
On Friday, July 26, 2002, at 07:19 , Todd wrote:
An obscure message:
Error,jrpp-41,07/26/02,22:04:38,myApp,null The specific
sequence
of files included or processed is: D:\Dev\websites\myapp\registration.cfm
Hmm, that just repeats what we already really know. What about the other
log
Well, it's not null... I did a cfdump and there's data in there.
All I was doing was encrypting, urlencoding... urldecoding.. decrypting.
I had to switch to cfusion_encrypt() cfusion_decode() to get it to work.
~Todd
At 08:24 PM 7/26/2002 -0700, you wrote:
On Friday, July 26, 2002, at 07:19 ,
er.. cfusion_decrypt().. and, yes, I know it's undocumented code. I recall
voting for it in the beta. ;)
~Todd
At 11:42 PM 7/26/2002 -0400, you wrote:
Well, it's not null... I did a cfdump and there's data in there.
All I was doing was encrypting, urlencoding... urldecoding.. decrypting.
I
954.360.9022 X159
ICQ 417645
- Original Message -
From: Kevin Langevin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 08, 2002 5:20 PM
Subject: Re: Weird error
I saw this error once before. We got a referral from a local ISP who
didn't
have an CF experience. They got hacked
I saw this error once before. We got a referral from a local ISP who didn't
have an CF experience. They got hacked and their CF install was wrecked, so
they built a new server, and when they set it up, they didn't set the SMTP
server in the CF administrator properly, or the SMTP server didn't
I had a few errors like that once.
CF Server on our test server was taking up all the cpu time (our test server
is a bit naff and needs to be sorted out).
After a few refreshes the error seem to resolve itself but, for that whole
day I would get similar error messages now and then.
Same here restarting CF or rebooting the server stoped it.
Rick
-Original Message-
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 11:00 AM
To: CF-Talk
Subject: RE: Weird error
I had a few errors like that once.
CF Server on our test server was taking up
Typically, that's means your error's so whacked that even CF doesn't
know what's going on.
Oftentimes, it's the result of a bad assignment - perhaps using a
reserved word for a variable name, assigning to simple variable to a
complex scope, or something else really crazy.
---
Billy Cravens
Joshua, in my experience Unknown Exception and pCode errors often point to
unlocked shared scope variables (Application-Session-Server). I would check
any usage of these scopes and if they are unlocked, lock them with CFLOCK.
Hope this helps.
Kind Regards - Mike Brunt, CTO
Webapper
AFAIR PreserveSingleQuotes requires a variable name as the parameter
- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, May 13, 2001 9:41 AM
Subject: weird error
Guys, do you know why this:
cfset grEMAIL=PreserveSingleQuotes(a[5])
you tend to get this error when you have done something like this :
FORM. me
(note the space !)
N
! ---
Neil Clark
Senior Web Applications Engineer
mcb digital
Tel. +44 (0)20 8941 3232
Tel. +44 (0)20 8408 8131 [Direct]
http://www.mcbdigital.com
Yeah lol
I wuz jus playing around with some stuff one day ran across this error. I
happened to think it wuz retty funny when I got it. I wuz creating my
Complete CSS Generator had to do some complex variations of cf code
forms. Well anyone who has done any CSS before knows the syntax for
Only thing I can say is to perhaps incorporate a default parameter within
the page like so:
cfparam name="Month" default="blah" type="date"
At least this would stop the error from happening on those rare occassions
as you say.
From: "Jon Hall" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
86 matches
Mail list logo