Ask a Question related to Coldfusion Database Access, Design and Development.
-
TrevJames #1
Invalid data error for CFSQLTYPE CF_SQL_VARBINARY
I'm testing out our news release posting application with our new CF MX 7
server and I'm getting an error posting a news release:
Invalid data Testing. for CFSQLTYPE CF_SQL_VARBINARY.
The error occurred in
E:\Inetpub\wwwroot\news\admin\form_add_featureActi on.cfm: line 11
9 : <cfelse>
10 :
11 : <cfinsert datasource="newsInfo" tablename="features" dbtype="ODBC">
12 : <cflocation url="index.cfm?pageID=_list_features.htm" addtoken="No">
13 :
If I post the same news release on our CF 5.1 server it works without issue.
Is my datatype set correctly? Is the dbtype causing the problem? I'm
attaching the code from the action page I use for this posting application.
Thanks in advance for any assistance!
-Trevor
Action page code:
<cfparam name="form.active" type="boolean" default="0">
<cfif isDefined('form.featureID')>
<cfupdate datasource="newsInfo" tablename="features" dbtype="ODBC"
formfields="type,active,releaseMonth,releaseDay,re leaseYear,eventTypeID,eventSub
TypeID,title,story,homepage,gender">
<cflocation url="index.cfm?pageID=_list_features.htm" addtoken="No">
<cfelse>
<cfinsert datasource="newsInfo" tablename="features" dbtype="ODBC">
<cflocation url="index.cfm?pageID=_list_features.htm" addtoken="No">
</cfif>
TrevJames Guest
-
#39014 [NEW]: php.ini data.timezone invalid
From: deepseath at gmail dot com Operating system: Win2000 PHP version: 5.1.6 PHP Bug Type: IIS related Bug description: ... -
CFQUERYPARAM CFSQLTYPE Datatype Sizes?
Hi, This is probably come up before, but I'm not having any luck tracking down info on it. Does anyone have a list of datatype sizes for each type... -
Problem with cfsqltype attribute of cfprocparam
I am using Microsoft SQL server 2000. The cfsqltype attribute of cfprocparam supports the following as shown below (extract from in its... -
boolean cfsqltype
Can someone please advise what cfsqltype should I used for boolean (true/false)? I've tried cf_sql_bit, but my results were inconsistent. i.e. ... -
#24705 [Opn->Fbk]: Invalid Data return in mysql_fetch_object
ID: 24705 Updated by: sniper@php.net Reported By: malko at the-ring dot homelinux dot net -Status: Open...



Reply With Quote

