Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Error iin the Coldfusion Site

I have one site which is giving me constant error in the page!

the Error code is: Invalid data 783ChromeHTML\Shell\Open\Command for CFSQLTYPE CF_SQL_NUMERIC.

i am getting it continously, if this is some kind of hacing, can anyone guide me or provide me some help in that regards
0
Gurpreet Singh Randhawa
Asked:
Gurpreet Singh Randhawa
  • 6
  • 5
1 Solution
 
gdemariaCommented:

Do you have a cfqueryparam  statement in that area?
Or a function you're calling where you pass a value?

The variable in the value is not a number and needs to be.

Can you show the code in that area where the error is?


0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
i am using cfquery everywhere in my page,m but whay it is apssing like this
i do not know

is someone tampering with url
0
 
gdemariaCommented:

If the variable is EMPTY, it is not a number and will throw the error

One way to fix it is to wrap val() around the variable you use in the cfqueryparam


   <cfqueryparam cfsqltype="CF_SQL_NUMERIC" value="#val(form.theNumber)#">

0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
but it will still throuw an error and email will come to me again
0
 
gdemariaCommented:

Are you saying that you put in val() and it still throws an error?

Can you show the rest of the error, which shows which line it is on
and then show the code around that line ?

0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
Here is what i get!

Detail      [empty string]
ErrorCode      n/a
Message      Invalid data 157ChromeHTML\Shell\Open\Command for CFSQLTYPE CF_SQL_NUMERIC.
NativeErrorCode      0
SQLState      n/a

0
 
gdemariaCommented:

Why do I have to ask you the same question more than once?

Did you put in the val() ?

Can you show the code around that area..

0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
no i did not used val, ok here it is:

 WHERE
    request_ID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.ID#">
0
 
gdemariaCommented:
You can test to see if your ID is empty, by putting this just before the CFQUERY

<cfif arguments.ID is "">
  <cfthrow message="ID IS EMPTY">
</cfif>




> no i did not used val

why not?   I said that would fix it...


WHERE
    request_ID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#val(arguments.ID)#">

or you can try this...

WHERE
    request_ID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.ID#" NULL="#NOT len(arguments.ID)#">


0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
k its late here, i will try

but my question there are many such calls in thispag, all will need val and extra handling, and whenever user tries to pass something irrelavant to the url, it will throw an error and email me the same time

0
 
gdemariaCommented:

 cfqueryparam  tests to see if the VALUE is of that type.

 Unfortunately, cfqueryparam does not consider EMPTY (null)  to be a  NUMBER.

 So cfqueryparam will throw an error if the value is empty.  It seems this is the problem.  That arguments.ID is empty.

But, if you feel that the ID passed into your function should never be empty (null) then, you need to fix why it is empty and you will not have a problem.  

However, if it can be empty, then you need to handle it.   The two ways I showed above are commonly used to handle if the Value of cfqueryparam is empty.

Yes, in time that your value of cfqueryparam might be empty, you need to handle it in one of these ways, or there are a couple others...


0
 
Brijesh ChauhanStaff IT EngineerCommented:
WHERE
    request_ID = <cfqueryparam cfsqltype="cf_sql_numeric" value="#arguments.ID#">


You are passing the argument ID to a function, check before passing the ID as argument to function call that it is NOT NULL...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now