Database Error

[grndvl1]

I get this error when I run CFUDPATE but If I make the same query using
<cfquery> the update statement, the update works fine. Is this some ODBC
error?

java.util.EmptyStackException
at java.util.Stack.peek(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonGetNextRe sultSet(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeQueryInt ernal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeDatabase MetaDataQuery(Unknown
Source)
at macromedia.jdbc.base.BaseDatabaseMetaData.getColum ns(Unknown Source)
at coldfusion.tagext.sql.InsertTag.getColumns(InsertT ag.java:214)
at
coldfusion.tagext.sql.InsertTag.retrieveDatabaseMe taData(InsertTag.java:247)
at
coldfusion.tagext.sql.UpdateTag.retrieveDatabaseMe taData(UpdateTag.java:281)
at coldfusion.tagext.sql.InsertTag.doStartTag(InsertT ag.java:617)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPag e.java:1918)
at cfUpdate2ecfm2127964166._factor9(C:\Inetpub\wwwroo t\armco7\Update.cfm:280)
at cfUpdate2ecfm2127964166._factor18(C:\Inetpub\wwwro ot\armco7\Update.cfm:277)
at cfUpdate2ecfm2127964166._factor19(C:\Inetpub\wwwro ot\armco7\Update.cfm:5)
at cfUpdate2ecfm2127964166.runPage(C:\Inetpub\wwwroot \armco7\Update.cfm:1)

[mxstu]

Does this happen every time you used CFUPDATE or only when using certain values or updating certain columns? Can you post the CFUPDATE and CFQUERY code and maybe someone can help.

[grndvl1]

This happens everytime I try to update a particular form Insert from this form.
Same exact code works on the live server and both are using the same database.
The code is just:

<cfupdate datasource="armco" tablename="contacts"

formfields="ct_name,ct_haddr1,ct_haddr2,ct_hcity,c t_hstate,ct_hzip,ct_hprovince
,
ct_hcountry, ct_cellular, ct_pager, ct_password,
ct_hphctycode,ct_hphacode,ct_hphnumber,ct_hfxctyco de,
ct_hfxacode,ct_hfxnumber,ct_hemail,ct_wemail,
ct_wphctycode, ct_wphacode, ct_wphnumber, ct_extension,
ct_wfxctycode, ct_wfxacode, ct_wfxnumber, ct_birthday">

Unfortunately I can't play with this any more as we needed it to work so I had
to uninstall the CF server. Will try again to reinstall, hope I don't run into
the same problem.

[mxstu]

I would recommend using CFQUERY over CFUPDATE because it offers more control
and IMO is a little less buggy.

Does the CFQUERY work with the exact same values used with the CFUPDATE? Is
the live server running the same version/hot fixes?

If you have time to post the pertinent information: database type, the actual
values being inserted, and column data types, maybe someone can look at it and
possibly offer an explanation.