***Oracle 8i Number Data-Type Conversion***

Results 1 to 4 of 4

Thread: ***Oracle 8i Number Data-Type Conversion***

  1. #1
    CapoRegime Guest

    Default ***Oracle 8i Number Data-Type Conversion***

    I have been having difficulty finding a solution to a data-type conversion for an Oracle number (x,x). Each time I reference it, it displays as a 0. Does anyone have any ideas? <BR><BR>Here is some code:<BR><BR>SQL7 = "SELECT sect_total_linear, sect_total_linear_uom FROM space_loc_sect WHERE loc_id =&#039;" & Request.Querystring("loc_id") & "&#039; AND sect_id =&#039;" & Request.Querystring("sect_id") & "&#039;" <BR>Set rs7 = conn.Execute(SQL7) <BR><BR>&#060;%= rs7("sect_total_linear") %&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: ***Oracle 8i Number Data-Type Conversion***

    Perhaps a decode() clause in your SQL statement might help. Having trouble trying to figure out exactly what you are doing though.

  3. #3
    Capo Guest

    Default RE: ***Oracle 8i Number Data-Type Conversion***

    What exactly do you mean by a decode clause? The objective is to retrieve data to display and/or manipulation. The problem is I retrieve only 0&#039;s when in actuality the data is stored 5417236.876 Numbers (x,x) ... ????

  4. #4
    New ASP Guest

    Default RE: ***Oracle 8i Number Data-Type Conversion***

    I use Oracle 8.1.7 Enterprise Edition.<BR>The SQL should work and I have no idea why you can&#039;t do that!!<BR>

Posting Permissions

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