Ask a Question related to Coldfusion Database Access, Design and Development.
-
sacu300 #1
Attribute validation error for tag CFQUERYPARAM.
I have a page that lets the user upload an image to change the logo of the
website. It works fine on ColdFusion MX7 but on earlier versions I get the
following error;
Attribute validation error for tag CFQUERYPARAM.
The value of the attribute VALUE is invalid. The value cannot be converted to
a string because it is not a simple value.Simple values are booleans, numbers,
strings, and date-time values.
The Error Occurred in E:\Websites\Caracas\adm\upload_action.cfm: line 17
15 : <cfquery name="insImg" datasource="#Application.dsname#">
16 : UPDATE siteconfiguration
17 : SET logo = <cfqueryparam value="#MyBinary#" cfsqltype="cf_sql_blob">
18 : WHERE (coname = '#Application.coname#')
19 :
Here is the code that I'm using:
<cffile action="readbinary" file="#form.upload#" variable="logo"
accept="image/*">
<cfquery name="insImg" datasource="#Application.dsname#">
UPDATE siteconfiguration
SET logo = <cfqueryparam value="#logo#" cfsqltype="cf_sql_blob">
WHERE (coname = '#Application.coname#')
</cfquery>
Any ideas?
sacu300 Guest
-
Error With CFQUERYPARAM
Here is an error that only exists when cfqueryparam is used. The code below throws an error in the *second* query if the *first* query contains... -
Attribute validation error for tag cfloop
I am trying to dynamically generate a "photo album" output into a table with corresponding captions: The out put should be 1 2 1.c 2.c... -
CFQUERYPARAM Error
Hello, I am using MX7 and am having problems with cfqueryparam. I am new to a project and the old code does not use them and everything I have... -
attribute validation error for tag cfchartdata
Hello world! I'm trying to use a variable in my chart, but I'm getting the error: "Attribute validation error for tag cfchartdata. The value of... -
cfmail - Attribute validation error for tag CFMAIL.
I'm getting the error ' Attribute validation error for tag CFMAIL.' on the code below. All its doing is outputting a text string to the TO: field. ... -
jdeline #2
Re: Attribute validation error for tag CFQUERYPARAM.
I'm not sure when cf_sql_blob was added, but it is not a valid cfsqltype in version 5.
jdeline Guest
-
C-Ramey #3
Re: Attribute validation error for tag CFQUERYPARAM.
Is your data really binary?
C-Ramey Guest



Reply With Quote

