Distinguished Contributor
Posts: 309
Registered: ‎10-02-2003
Message 1 of 2 (274 Views)

ADOLisp - Select rows with null values

274 Views, 1 Replies
01-02-2013 10:19 AM

Hi - I'm attempting to update a database so that all fields in a specified column that have a null value and are of datatype number are allocated a value of 0 (zero), but I'm having trouble selecting the offending rows..

my statement is

"select * from crossings where pipeline_id = null"

and this returns nothing (although I know there are some in there because if i run the following:

"select * from crossings where pipeline_id <> null"

it returns all rows that have a value and omits those that don't (ie the ones that I want)

Anyone know what I'm doing wrong?

Distinguished Contributor
Posts: 309
Registered: ‎10-02-2003
Message 2 of 2 (265 Views)

Re: ADOLisp - Select rows with null values

01-03-2013 02:07 AM in reply to: petervose

Realised I should use keyword "IS" instead of using "="

select * from crossings where pipeline_id IS null

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community