Values returning 0 (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Crock -> Values returning 0 (3/8/2001 14:12:00)

My query keeps returning 0 (zero) for NETACRES when I run this SQL statement against an Oracle database. The query is giving the correct information but the value just isn't displaying correctly. I know I must be missing something but I just don't see it. Any help would be great.

SELECT ACCOUNTNO, NETACRES
FROM PUB_PARCEL_SEG_LAND
WHERE (NETACRES > '::NETACRES::')



Elecia -> RE: Values returning 0 (3/8/2001 15:27:00)

Oracle loves to pad fields. Maybe try using a trim statement to get rid of those extra spaces. Padding has been a great source of aggravation for me and many wasted hours. It's only a thought.
EE



Crock -> RE: Values returning 0 (3/8/2001 16:19:00)

The trim command worked!!!
You are the best.

Thanks!!!




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875