I'm need to do some mass updating and inserting so I started
playing with cfgrid. I get this DB error because the values aren't
being passed from cfgrid to cfgridupdate so it's trying to insert
a question mark. Which generates a data type error.
----------------------------------------------------------------------
ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is
incompatible with text
Data Source = "holo_lobbytools"
SQL = "INSERT INTO "Accounts" ( "OrgName" ) VALUES ( ? ) "
The error occurred while processing an element with a general identifier of
(CFGRIDUPDATE), occupying document position (17:3) to (22:14)
----------------------------------------------------------------------
My code below is very simple. Thanks for any help.
Ric
----------------------------------------------------------------------
<cfif actiontwo EQ "update">
<cfgridupdate grid="AccountGrid"
datasource="holo_lobbytools"
tablename="Accounts"
username="ToolsUser"
password="UserTool234"
>
</cfif>
<cfquery name="Grid" datasource="holo_lobbytools">
SELECT *
FROM Accounts
</cfquery>
<cfform name="myForm" action="#SCRIPT_NAME#" method="post">
<input type="hidden" name="actiontwo" value="update">
<cfgrid name="AccountGrid"
height="400"
width="700"
align="center"
query="Grid"
insert="Yes"
delete="Yes"
sort="Yes"
font="Arial"
fontsize="14"
bold="No"
italic="No"
appendkey="Yes"
highlighthref="No"
griddataalign="LEFT"
gridlines="Yes"
rowheaders="Yes"
rowheaderalign="LEFT"
rowheaderitalic="No"
rowheaderbold="No"
colheaders="Yes"
colheaderalign="LEFT"
colheaderitalic="No"
colheaderbold="No"
bgcolor="FFFFFF"
selectcolor="0000FF"
selectmode="EDIT"
picturebar="No"
insertbutton="INSERT"
deletebutton="DELETE">
<cfgridcolumn name="OrgName">
</cfgrid>
<br>
<input type="submit" value="UPDATE">
</cfform>
----------------------------------------------------------------------
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
