Cold Fusion Error/Access Error - "Invalid precision value"

tgilbreath · Nov 7, 2003

Hi guys-

Doing a standard update, but on multiple tables....everytime the update code is ran, I get this error:

------------------
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value
------------------

I can't find anything concrete on the net about it, can someone please tell me what I'm doing wrong? Code below:

Edit Page Code:
----------------------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0054)

http://www.houstonenergycu.com/rates/savingsrates.html

-->
<HTML><HEAD><TITLE>Houston Energy Credit Union</TITLE>
<META
content="Houston Energy Credit Union - the credit union's mission is to respond to our membership's financial needs by providing sound, competitive financial products while ensuring credit union services for future generations."
name=description>
<META
content="houston, energy, HECU, texas, tx, credit, union, CU, car, truck, NCUA, CUNA, money, loan, credit card, atm, branch, deposit, withdrawal, service, member, membership, cu@home, account, credit union, financial, financing, members, services, check, checking, savings, accounts, retire, retirement, 401K, annuity, home, house, mortgage, mortgages, loans, lending, bank, banking, downtown, IRA, money market, investment, investments, investing, certificate, deposits, rate, rates"
name=keywords>
<META content="60 Days" name=revisit-after>
<META content="Business Banking" name=classification>
<META content=ALL name=robots>
<META content=GLOBAL name=distribution>
<META content=GENERAL name=rating>
<META content=en-us name=language>
<META http-equiv=reply-to content=info@houstonenergycu.org>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><LINK
href="

http://www.houstonenergycu.com/js/style.css"

type=text/css rel=STYLESHEET>
<META content="MSHTML 6.00.2800.1264" name=GENERATOR></HEAD>
<cfquery name="EffectiveDateOutput" datasource="ratesserver">
SELECT * FROM HECUEffectiveDate
</cfquery>
<cfquery name="SavingsRatesOutput" datasource="ratesserver">
SELECT * FROM HECUSavingsRates
</cfquery>
<cfquery name="MoneyMarketOutput" datasource="ratesserver">
SELECT * FROM HECUMoneyMarket
</cfquery>
<cfquery name="TermShareTextOutput" datasource="ratesserver">
SELECT * FROM HECUTermShareText
</cfquery>
<cfquery name="TermShareOutput" datasource="ratesserver">
SELECT * FROM HECUTermShare
</cfquery>
<cfquery name="TermShareDisclaimerOutput" datasource="ratesserver">
SELECT * FROM HECUTermShareDisclaimers
</cfquery>
<BODY leftMargin=0 background=

http://www.houstonenergycu.com/images/back.gif

topMargin=0 marginwidth="0"
marginheight="0">
<SCRIPT type=text/javascript>

//HV Menu- by Ger Versluis (

http://www.burmees.nl/)

//Submitted to Dynamic Drive (

http://www.dynamicdrive.com)

//Visit

http://www.dynamicdrive.com

for this script and more

function Go(){return}

</SCRIPT>

<SCRIPT src="

http://www.houstonenergycu.com/js/exmplmenu_var.js"

type=text/javascript></SCRIPT>

<SCRIPT src="

http://www.houstonenergycu.com/js/menu_com.js"

type=text/javascript></SCRIPT>
<NOSCRIPT>Your browser does not support script</NOSCRIPT>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD vAlign=top>
<TABLE height="100%" cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top width=150>
<TABLE height="100%" cellSpacing=0 cellPadding=0 width=150
border=0><TBODY>
<TR>
<TD vAlign=top bgColor=#333388 height=84><IMG height=84 alt=""
src="

http://www.houstonenergycu.com/images/bluebacklogo.gif"

width=150 border=0> </TD></TR>
<TR>
<TD vAlign=top bgColor=#ffcc00 height=30><A
href="

http://www.houstonenergycu.com/index.html"><IMG

height=30 alt="" src="

http://www.houstonenergycu.com/images/returnhome.gif"

width=150
border=0></A></TD></TR>
<TR>
<TD vAlign=top align=left bgColor=#cc0000><BR>
<P><SPAN class=yellow14>Rates</SPAN></P>
<UL>
<LI><SPAN class=blackbold10>Savings Rates</SPAN>
<LI><A
href="

http://www.houstonenergycu.com/rates/loanrates.html"><SPAN

class=white10>Loan Rates</SPAN></A>
</LI></UL></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=610>
<TABLE cellSpacing=0 cellPadding=0 width=610 border=0>
<TBODY>
<TR>
<TD vAlign=top height=22>
<DIV id=MenuPos
style="WIDTH: 87px; POSITION: relative; HEIGHT: 19px"><IMG
height=19 src="

http://www.houstonenergycu.com/images/transparent.gif"

width=1></DIV></TD></TR>
<TR>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width=610 bgColor=#ffffff
border=0>
<TBODY>
<TR>
<TD width=463><BR><IMG height=71 alt=""
src="

http://www.houstonenergycu.com/images/savratestitle.gif"

width=318
border=0></TD>
<TD vAlign=top width=147><A
href="

https://nbp1.cunetbranch.com/hefcu"

target=new><IMG height=31 alt=""
src="

http://www.houstonenergycu.com/images/homenet.gif"

width=147
border=0></A></TD></TR>
<form action="rates_update.cfm" method="post">
<TR>
<cfoutput query="EffectiveDateOutput">
<TD vAlign=top align=middle width=463 height=215><BR>
<P align=center><B><input type="text" name="EffectiveDate" size="40" value="#EffectiveDate#"></B></P>
</cfoutput>
<TABLE cellSpacing=0 cellPadding=5 width=375 border=0>
<TBODY>
<TR>
<TD align=middle colSpan=3><SPAN
class=bluebold14>Savings Account
Rates</SPAN></TD></TR>
<TR>
<TD align=middle width=225 bgColor=#ffcc66><SPAN
class=black11><B>Type of Account</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>APR</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>APY</B></SPAN></TD></TR>
<cfoutput query="SavingsRatesOutput">
<TR>
<TD width=225><SPAN class=black11><B>
<input type="text" size="25" name="AccountType" value="#AccountType#"></B></SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="APR" value="#APR# ">%</SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="APY" value="#APY# ">%</SPAN></TD></TR>
</cfoutput>
</TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=5 width=460 border=0>
<TBODY>
<TR>
<TD align=middle colSpan=5><SPAN
class=bluebold14>Money Market</SPAN></TD></TR>
<TR>
<TD align=middle width=160 bgColor=#ffcc66><SPAN
class=black11><B>Balance Tiers</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>Energy Elite<BR>APR</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>Energy Elite<BR>APY</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>IRA<BR>APR</B></SPAN></TD>
<TD align=middle width=75 bgColor=#ffcc66><SPAN
class=black11><B>IRA<BR>APY</B></SPAN></TD></TR>
<cfoutput query="MoneyMarketOutput">
<TR>
<TD width=160><SPAN
class=black11><B>
<input type="text" size="25" name="BalanceTier" value="#BalanceTier#">
</B></SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="EliteAPR" value="#EliteAPR# ">%</SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="EliteAPY" value="#EliteAPY# ">%</SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="IRAAPR" value="#IRAAPR# ">%</SPAN></TD>
<TD align=middle width=75><SPAN
class=black11>
<input type="text" size="3" name="IRAAPY" value="#IRAAPY# ">%</SPAN></TD></TR>
</cfoutput>
</TBODY></TABLE><BR>
<TABLE cellSpacing=0 cellPadding=5 width=375 border=0>
<TBODY>
<TR>
<TD align=middle colSpan=3><SPAN
class=bluebold14>Term Share
Certificates</SPAN><BR><SPAN
class=black11><cfoutput query="TermShareTextOutput">
<input type="text" name="TextLine1" size="60" value="#TextLine1#"><br>
<input type="text" name="TextLine2" size="60" value="#TextLine2#"><br>
<input type="text" name="TextLine3" size="60" value="#TextLine3#">
</cfoutput></SPAN></TD></TR>
<TR>
<TD align=middle width=125 bgColor=#ffcc66><SPAN
class=black11><B>Term</B></SPAN></TD>
<TD align=middle width=125 bgColor=#ffcc66><SPAN
class=black11><B>APR</B></SPAN></TD>
<TD align=middle width=125 bgColor=#ffcc66><SPAN
class=black11><B>APY</B></SPAN></TD></TR>
<cfoutput query="TermShareOutput">
<TR>
<TD width=125><SPAN class=black11><B>
<input type="text" size="25" name="Term" value="#Term#"></B>
<cfif Minimum IS "">
<cfelse><br>
<input type="text" size="25" name="Minimum" value="#Minimum#"> Minimum
</cfif>
</SPAN></TD>
<TD align=middle width=125 valign="top"><SPAN
class=black11><input type="text" size="3" name="APR" value="#APR# "> %</SPAN></TD>
<TD align=middle width=125 valign="top"><SPAN
class=black11><input type="text" size="3" name="APY" value="#APY# "> %</SPAN></TD></TR>
</cfoutput>
<TR>
<TD colSpan=3><SPAN class=black9><I>
<cfoutput query="TermShareDisclaimerOutput">
<textarea name="TextLine1" rows="3" cols="45">#TextLine1#</textarea><br>
<textarea name="TextLine2" rows="3" cols="45">#TextLine2#</textarea><br>
<textarea name="TextLine3" rows="3" cols="45">#TextLine3#</textarea>
</cfoutput>
</I></SPAN></TD></TR></TBODY></TABLE>
<P align=left>
<input type="submit" value="Update Rates">
<form></TD>
<TD vAlign=top align=middle width=147>
<TABLE cellSpacing=0 cellPadding=0 width=101 border=0>
<TBODY>
<TR>
<TD width=1 bgColor=#ffcc00><IMG height=1 alt=""
src="

http://www.houstonenergycu.com/images/transparent.gif"

width=1
border=0></TD>
<TD width=100><IMG height=175 alt=""
src="

http://www.houstonenergycu.com/images/nav2.gif"

width=100
useMap=#newnew border=0></TD></TR></TBODY></TABLE><AREA
shape=RECT alt="" coords=15,16,89,37
href="

http://www.houstonenergycu.com/application.html"><AREA

shape=RECT target=checks alt="" coords=18,41,88,65
href="

https://home.clarkeamerican.com/prodreorder/reorder_form.cfm"><AREA

shape=RECT alt="" coords=16,68,90,88
href="

http://www.houstonenergycu.com/contact.html"></TD></TR>

<TR>
<TD align=middle colSpan=2><BR><SPAN class=black10>©
Houston Energy Credit Union<BR><A
href="

http://www.houstonenergycu.com/privacy.html">Privacy

Statement</A></SPAN><BR><BR>
<P align=center><IMG height=54 alt=""
src="

http://www.houstonenergycu.com/images/ehlblack.gif"

width=46
border=0>   <IMG height=72 alt=""
src="

http://www.houstonenergycu.com/images/ncuablackandwhite.gif"

width=102
border=0></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><MAP
name=newnew><AREA shape=RECT alt="Apply for a Loan Online" coords=2,8,75,30
href="

https://www.houstonenergycu.com/application.html"><AREA

shape=RECT
alt="Re-order Checks Directly from Clarke American Online" coords=2,30,96,49
href="

http://www.houstonenergycu.com/interim.html"><AREA

shape=RECT
alt="Contact Us" coords=3,50,84,69
href="

http://www.houstonenergycu.com/contact.html"><AREA

shape=RECT
alt="Credit Cardholder Services" coords=1,71,100,89
href="

http://www.houstonenergycu.com/interim4.html"><AREA

shape=RECT
alt="CU Friendly ATM Network" coords=3,93,83,120
href="

http://www.houstonenergycu.com/interim2.html"><AREA

shape=RECT
alt="Select ATM Network" coords=4,122,84,145
href="

http://www.houstonenergycu.com/interim3.html"><AREA

shape=RECT
alt="CU Members Mortgage" coords=4,150,84,175
href="

http://www.houstonenergycu.com/interim11.html"></MAP></BODY></HTML>

----------------------------------------

Update Code
----------------------------------------
<cfupdate datasource="ratesserver" tablename="HECUEffectiveDate" dbtype="ODBC" formfields="DateID, EffectiveDate">

<cfupdate datasource="ratesserver" tablename="HECUSavingsRates" dbtype="ODBC" formfields="RateID, AccountType, APR, APY">

<cfupdate datasource="ratesserver" tablename="HECUMoneyMarket" dbtype="ODBC" formfields="RateID, BalanceTier, EliteAPR, EliteAPY, IRAAPR, IRAAPY">

<cfupdate datasource="ratesserver" tablename="HECUTermShareText" dbtype="ODBC" formfields="TextID, TextLine1, TextLine2, TextLine3">

<cfupdate datasource="ratesserver" tablename="HECUTermShare" dbtype="ODBC" formfields="RateID, Term, Minimum, APR, APY">

<cfupdate datasource="ratesserver" tablename="HECUTermShareDisclaimers" dbtype="ODBC" formfields="TextID, TextLine1, TextLine2, TextLine3">

<cflocation url="rates.cfm">
-----------------------------------------------------

Thanks in advance!!

Tim

ecobb · Nov 7, 2003

OK,
1) Don't use SELECT * unless you really need to return every value. Specify the items you need to select.

2) Most likely, the problem is going to be with cfupdate itself, and nothing wrong with your code. Both the cfupdate and cfinsert are considered somewhat unstable and it is HIGHLY recommended (by Macromedia and most CF developers) that the actual SQL statements be used for updates and inserts. With cfupdate and cfinsert, the applications may work great for a while, then they break for no reason, and the next day they may be working again. This has literally happened to me before with both cfupdate and cfinsert. Try using the SQL update instead of the cfupdate.

Hope This Helps!

Ecobb
- I hate computers!

tgilbreath · Nov 7, 2003

I KNEW someone was going to say do it in pure SQL....I didn't think it would cause a problem like that though! But I will definitely give it a try, thanks for the input!!

tgilbreath · Nov 7, 2003

Ok, now I'm using the SQL update...my updates are looking like this:

<code>
<cfquery name="UpdateTable1" datasource="ratesserver">
UPDATE HECUEffectiveDate
SET EffectiveDate='#form.EffectiveDate#'
</cfquery>

<cfquery name="UpdateTable2" datasource="ratesserver">
UPDATE HECUSavingsRates
SET AccountType='#form.AccountType#',
APR='#APR#',
APY='#APY#'
</cfquery>
</code>

STILL getting the same error:

------------------------------
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid precision value

Please try the following:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address 66.140.4.249
Referrer

http://216.197.104.41/rates_server/rates_edit.cfm

Date/Time 07-Nov-03 08:54 AM
-------------------------------------------------

ecobb · Nov 7, 2003

Can you determine which update is giving the error? You may want to comment them all out and then add them back one at the time until you find the (first) one that's causing the problem. You may want to try checking the datatypes you're passing and make sure they are correct, look for quotes where they shouldn't be, missing quotes where they should be, etc...

BTW, I'm not sure if this is what you're trying to do or not, but your current update statements will update EVERY record in the database unless you specify a WHERE clause.

Hope This Helps!

Ecobb
- I hate computers!

tgilbreath · Nov 7, 2003

Thank you, I forgot about my WHERE statements....but I've entered them, and now I'm getting this error:

---------------
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

---------------------
Here is my edit code example (for sending the ID value)...is this right?

-------------------------
<cfoutput query="SavingsRatesOutput">
<TR>
<input type="hidden" name="RateID" value="#RateID#">
<TD width=225><SPAN class=black11><B>
<input type="text" size="25" name="AccountType" value="#AccountType#"></B></SPAN></TD>
<TD align=middle width=75><SPAN class=black11>
<input type="text" size="3" name="APR" value="#APR# ">%</SPAN></TD>
<TD align=middle width=75><SPAN class=black11>
<input type="text" size="3" name="APY" value="#APY# ">%</SPAN></TD></TR> </cfoutput>
-----------------------------------

And then here is the accompanying UPDATE code...

------------------------------
<cfquery name="UpdateTable2" datasource="ratesserver">
UPDATE HECUSavingsRates
SET AccountType='#form.AccountType#',
APR='#form.APR#',
APY='#form.APY#',
WHERE RateID='#form.RateID#',
</cfquery>
-------------------------------

Why am I getting a SQL update error? UGH.
Thanks in advance!!

ecobb · Nov 7, 2003

Don't put qoutes around numeric values (or at least for numeric datatypes). WHERE RateID='#form.RateID#' should probably be WHERE RateID=#form.RateID#

Hope This Helps!

Ecobb
- I hate computers!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Cold Fusion Error/Access Error - "Invalid precision value"

tgilbreath

Programmer

ecobb

Programmer

tgilbreath

Programmer

tgilbreath

Programmer

ecobb

Programmer

tgilbreath

Programmer

ecobb

Programmer

Similar threads

Part and Inventory Search

Sponsor

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Cold Fusion Error/Access Error - &quot;Invalid precision value&quot;

tgilbreath

Programmer

ecobb

Programmer

tgilbreath

Programmer

tgilbreath

Programmer

ecobb

Programmer

tgilbreath

Programmer

ecobb

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor

Cold Fusion Error/Access Error - "Invalid precision value"