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?
I setup a table in my Oracle DB and they works fine.<BR>could you pls post your code here?
What Oracle DB are you using??? Lite or Full?
SQL7 = "SELECT sect_total_linear, sect_total_linear_uom FROM space_loc_sect WHERE loc_id ='" & Request.Querystring("loc_id") & "' AND sect_id ='" & Request.Querystring("sect_id") & "'"<BR>Set rs7 = conn.Execute(SQL7) <BR><BR><%= rs7("sect_total_linear") %>