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:
[Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).
Here's my SQL query:
cfquery name=upcourse datasource=cft
UPDATE dbo.Courses SET
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
Also, for future suggestion, choose a more specific subject line than
weird error. A subject line like this is going to make it be the
last thing I check because I don't know if it is anything I have any
knowledge of. If you are least mention that it is a problem with
cfqueryparam and database
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
Here is the errors that show up when I go to the datasource page in cf
administrator:
This just started happening recently. Any ideas what is happening?
Aug 22, 2006 2:52 PM Error 0
Exception thrown by error-handling template:
Aug 22, 20062:52 PM
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.
This page works for me but other users seem to have a error on it with
the same browser I have. The browser probably isnt
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
Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 15, 2006 7:47 PM
To: CF-Talk
Subject: Weird error
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
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
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
queryString = p
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
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
Any ideas anyone please?
Strange error running:
cfquery dbtype=query name=mail_clear
select * from mail_get
where mail_get.uid #last_mail+1#
/cfquery
Returning with:
0100(CET) must be interprettable as a valid number in the current locale.
The error occurred in
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
Hi all,
I'm trying to consume a remote .NET Web service. I've tried using cfinvoke
and cfhttp, with bad results for both.
Using cfinvoke:
cfinvoke webservice=http://companyname/webservice/service.asmx?wsdl;
method=GetAllInvoices
customerid=blahblah username=blahblah password=blahblah
[EMAIL PROTECTED]
To: CF-Talk ;
Sent: Jun 16, 2005 02:14:54 PM
Subject: Consuming .NET Web service - weird error and Windows authentication
Hi all,
I'm trying to consume a remote .NET Web service. I've tried using and , with
bad results for both.
Using :
customerid=blahblah username=blahblah
I left my Dev box running overning.
When i came back into work I saw this error at the command prompt.
27/05 07:00:44 error Event Handler Exception.
[1]java.lang.OutOfMemoryError
[0]coldfusion.runtime.EventHandlerException: Event Handler Exception.
at
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
A while back I got my new computer, Godzilla, XP, SP2, installed cf and it was
fine until I installed the updater. After that I couldn't login to cfadmin, got
an error.
I uninstalled CF (that was fun!), reinstalled with no updater and it all worked
fine again. I just now logged in to add a
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
: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message -
From: Chris Kavanagh [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February 01, 2005 2:41 PM
Subject: CFUPDATE throwing up a weird error
Dear List
Name may be a reserved word depending on your DB
Thanks very much, Bryan, but that doesn't seem to be the problem. I
renamed the field to banana, and it still doesn't work.
I'm kind of stumped. Anyone else got any ideas?
I will take your other advice about learning more SQL, but just so I
CFUPDATE and CFINSERT have historically been less than stellar
performers
If you pass the fields in the wrong order it will crap out (and the error is
vague). The vagueness is my big beef...it's supposed to be more of a set of
tags for beginnersbut the error messages are worse than
Happy new year,
our world wide web publishing service just stopped,
I checked the event viewer and found this msg,
The server was unable to add the virtual root '/cfdocs' for the directory 'x:\path_name\cfdocs' due to the following error: The system cannot find the path specified.The data is the
mccosker [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 7:18 AM
To: CF-Talk
Subject: Weird error in event viewer
Happy new year,
our world wide web publishing service just stopped,
I checked the event viewer and found this msg,
The server was unable to add the virtual root '/cfdocs
I can't seem to figure this one out.. Is is nessessary to create the xml
packet and pass it to the cfc or can it be created in the cfc but passed
arguments?
-Mike
Whitespace required before attributes.
The error occurred in D:\CFusionMX\wwwroot\modules\Synxis.cfc: line 24
Called from
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
Hello all,
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
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 by Java compiler: Found 1 semantic error
://www.phonebin.com
From Phone to Web in minutes
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Monday, March 3, 2003 11:29
To: CF-Talk
Subject: Weird Error Message
Today, thinking of normal day I typed in my site address. Clicked on a link
and its giving following error. Does
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
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 action=read file=c:\output variable=imageinfo
getting
Subject: weird error!
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 action=read file=c:\output
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
This is a multi-part message in MIME format.
--_=_NextPart_001_01C258DC.4D23E326
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
I've been getting a strange error recently on some my sites. I have an =
error=20
handler using cferror tag
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 format
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
Ye,
I am getting a VERY similar error. Did you ever get resolution on this issue?
I can solve my problem by setting up the DataSource in the CFAdmin as ODBC Socket
connection instead of SQLServer... however I was thinking that JDBC is more
efficient... faster etc.
Brian
At 10:53 AM
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
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...
The Error Occurred in
D:\Dev\websites\famtoday\_ftlibrary\cfcs\system\registration.cfc: line 35
33 :
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
We just installed CFMX on a brand new server, W2k with SQL 2000. Most
CF5 codes worked and no problems with stored procedures so far, except a
few errors on simple queries. One of them was quite weird.
Name : VARCHAR(128)
Cost: real
tableA joins tableB on (tableA.ID = tableB.aID)
Case 1:
16, 2002 10:53 AM
Subject: CFMX SQL - simple query with weird error message
We just installed CFMX on a brand new server, W2k with SQL 2000. Most
CF5 codes worked and no problems with stored procedures so far, except a
few errors on simple queries. One of them was quite weird.
Name : VARCHAR
Kinda weird, but try like so
SELECT A.Name, B.Cost
FROM tableA a
INNER JOIN tableB b
ON (A.ID = B.aID)
WHERE B.aID = 1
I don't have an MX machine handy ... curious to know what the error message
was tho... could you post it to the list?
Isaac Dealey
www.turnkey.to
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 2:15 PM
Subject: Re: CFMX SQL - simple query with weird error message
Kinda weird, but try like so
SELECT A.Name, B.Cost
FROM tableA a
INNER JOIN tableB b
ON (A.ID = B.aID)
WHERE B.aID = 1
1 - 100 of 132 matches
Mail list logo
