#mysql - Mon 14 May 2007 between 00:00 and 00:09

NY Lost Funds



routejp- Who are you talking to?
jp-lwizardl
lwizardljp-, ok i changed the _id fields to INT and same error when I try to add it
jp-you forgot commas
and have too many in some places
line 25, coverinker
line 33, imprint
line 44 condition
line 52, quanitity
pulpfictionjp-, i guess mysql didn't give me many options here, will have to filter the data on the programming side
jp-pulpfiction: i don't think sql server allows that either
pulpfictionnonsense :(
hehe
routeMySQL pisses me off. Why can't they have a simple boolean field like any REAL SQL?
arjenAUroute: because it doesn't like people shouting at it thinking they can make stuff work that way
routeI haven't shouted at it... yet.
But I did kick it a few times.
arjenAUnasty.
Xgcroute: WHERE NOT field <=> 1
routeXgc same incorrect results as everything else I've tried. :-(
Xgcroute: This is not standard SQL, but you can do that with MySQL.
routeI changed vesting_deed to '0' in 1 row, and that's the only row that's getting returned.
Xgcroute: Excuse me? Which wrong value did you see in that result?
routeI see 1 row instead of the 4 that I should see.
Xgcroute: I didn't see your SQL, only your last description.
routeSELECT document_type, grantor, grantee, document_date, recorded_date, book, page, instrument, comments FROM report_entries WHERE order_id = '0123400073' AND NOT vesting_deed <=> '1' ORDER BY recorded_date DESC;
Xgcroute: Which rows do you want to see that you don't?
jp-lose the quotes around the 1
routeI need to return every now that is not '1'
whether it's null, 0, or uhoe98
jp-you aren't supposed to quote integer values
routeWhith or without the quotes the results are exactly the same.
Xgcroute: Well, why doesn't your SQL reflect your requirement?
routeXgc That's what I'm tring to find out.
It works if there's a value for vesting_deed, but not if it's NULL.
Xgcroute: Ok. Post the create table statement and the insert statements for the rows in question.
arjenAUyou could ust do WHERE vesting_deed <> 1
for NULL that'd be false also, so it matches
Xgcroute: Obviously, what you descfribe does not match reality.
describe

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds