problems with drivers

Results 1 to 2 of 2

Thread: problems with drivers

  1. #1
    Join Date
    Dec 1969

    Default problems with drivers

    We recently switched a system from Oracle 8i to Oracle 9i and now our recordset inserts don&#039;t work right. It complains about precisions of numbers and null values all over the place. The following is an example of usage:<BR><BR>var rs = Server.CreateObject("ADODB.RecordSet");<BR>var SQL_QUERY = "SELECT * FROM tablename";<BR>rs.Open(SQL_QUERY, oraConn, 3 , 3);<BR>rs.AddNew();<BR>rs("ID") = ""+nID;<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: problems with drivers

    Yeah, but you&#039;re not actually doing an insert there. Well, not exactly. Why not just do the following (it&#039;s more efficient):<BR><BR>var SQL_QUERY = "INSERT INTO tablename (col1, col2) VALUES (" + myVal1 + ", &#039;" + myVal2 + "&#039;)";<BR>var objConn = Server.CreateObject("ADODB.Connection");<BR>objCon n.Open(oraConn);<BR>objConn.Execute(SQL_QUERY);<BR >objConn.Close();<BR><BR>Bear in mind I&#039;ve not coded server-side JScript for a while... :-)<BR><BR>Craig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts