Member Avatar for andydeans

hi,

i am struggling and it will prob be a simple answer but cannot figure it out at all today.

checked online but no use.

my to create my view i need to compare a column to a yes or no.

at the moment i have tried this but no joy:

where (isnull(`p`.`Date`) and (`p`.`True` = N))

I need the view to return only the true = N but cannot get this.

hope someone can help, sure you guys will.

many thanks

  • 2 Contributors
  • 3 Replies
  • 84 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by andydeans
Member Avatar for darkagn

You need to quote your string N like so:

WHERE p.DATE IS NULL and p.TRUE = 'N'
Member Avatar for andydeans

hi,

yes i thought that would be the case as when i do a select query that is how i would type it however when create the view with ='N' it throws a syntax error.

does not create the view.

anyone else know how i add the where clause to match 'N' in my crete view? it works if i take that line out so i know the rest of the query works i just cant get it to compare to a value.

thanks again

Member Avatar for andydeans

its ok, managed to solve it. syntax error higher up in code.

thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.