Hi,
i've just gone through a day of debugging a problem i have with my spectra
application connecting
through oracle client 8.1.7 to a oracle 8i database.
It seems that somewhere inserts with numbers formatted with . (points) on
oracle datatype number(18,9)
cause a 'invalid number' error.
i hacked three files in the /customtags/system/coapi/utils directory to make
sure these
data type contain comma's instead of points.
However i still do not know what causes these errors, is it the oracle
client or some locale settings perhaps ?
If anyone has similir experiences , plz reply, in the meanwhile here is my
workaround:
(this goes in /customtags/system/coapi/utils/_recordinsert_bp.cfm line #19 ,
and should be applied only on lDateTimeFields)
<cfif IsNumeric(attributes.stFields[field]) >
<cfset attributes.stFields[field] =
replace(attributes.stFields[field],'.',',',"ALL")>
</cfif>
same code goes in _recordupdate_bp.cfm and _recordselect_bp.cfm
Vincent Egt
e-dynamics
t: +31 181643684
f: +31 181649951
m:+31 651601420
http://www.e-dynamics.nl
http://coldfusion.pagina.nl
http://www.VincentEgt.com
http://asp.pagetostart.nl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
