Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cursor.insertRow problem in iplanet

2 views
Skip to first unread message

Bharanendra.Nallamotu

unread,
Jul 19, 2000, 3:00:00 AM7/19/00
to
We are having the following problem; we are trying to migrate a server
side Javascript application from NES v. 3.6 to iPlanet. In our legacy
code, we use the insertRow method of an updateable cursor to insert data
into an Oracle database. This was working fine in NES 3.6. When we try
to do the same on IPlanet, any number that we try to insert seems to be
"converted" into a date (a strange one at that, like 31st December,
1969). Needless to say, when the sql statement tries to insert a date
into a number or varchar field, we get an Oracle error. Has anyone else
attempted to make this move...it seems that when we use the execute
method of the connection object, this does not happen.

Thanks
Bharni

nallamotu.vcf

Janusz Mazurkiewicz

unread,
Aug 24, 2000, 3:00:00 AM8/24/00
to
Hi, I have
NT 4.0 sp 6
Oracle Server 8.0.6
iPlanet Web Server 4.1
I have the folowing problem with updating cursor.
When I call 'insertRow' or 'updateRow' on the table with number collumn -
this operation fail.
Example:
when I call 'curs.SALARY = 12' than in database appear 12000000
This problem concerns collumn with NUMBER datatype.

pls help
thanks


0 new messages