Topics

SQL expression to find

Email Service
 

Band=40m

RTTY

FT8

 

I have tried

 

(Band='40m') and Mode='RTTY' and Mode='FT8"

 

Which results in error

 

Please correct my “grammar.”

 

Thank you,

Jack ak7o

 

Sent from Mail for Windows 10

 

Dave AA6YQ
 

+ AA6YQ comments below

Band=40m

RTTY

FT8

+ Assuming you mean

"Show all 40m QSOs made in either RTTY or FT8", then the desired SQL expression is

(Band='40m') and ((Mode='RTTY' ) or (Mode='FT8'))

73,

Dave, AA6YQ

Email Service
 

Thank you, Dave.

jack

 

Sent from Mail for Windows 10

 

From: Dave AA6YQ
Sent: Thursday, January 16, 2020 7:33 PM
To: DXLab@groups.io
Subject: Re: [DXLab] SQL expression to find

 

+ AA6YQ comments below

 

Band=40m

 

RTTY

 

FT8

 

+ Assuming you mean

 

"Show all 40m QSOs made in either RTTY or FT8", then the desired SQL expression is

 

(Band='40m') and ((Mode='RTTY' ) or (Mode='FT8'))

 

      73,

 

             Dave, AA6YQ

 

 

 

 

iain macdonnell - N6ML
 

On Thu, Jan 16, 2020 at 6:26 PM Email Service <jfriend31@...> wrote:

Band=40m
RTTY
FT8
I have tried
(Band='40m') and Mode='RTTY' and Mode='FT8"
Which results in error
For educational purposes...

If that's a direct copy/paste, the error was because you used a
double-quote on the end and single quotes everywhere else. You can use
either, but must be consistent.

That aside; the mode can't be both RTTY *and* FT8, so that filter
would never match anything.

My preferred solution would be:

Band='40m' and Mode in ('RTTY','FT8')

73,

~iain / N6ML

Email Service
 

Thank you
Jack

Sent from XFINITY Connect App



------ Original Message ------

From: iain macdonnell - N6ML
To: DXLab@groups.io
Sent: January 16, 2020 at 10:42 PM
Subject: Re: [DXLab] SQL expression to find

On Thu, Jan 16, 2020 at 6:26 PM Email Service wrote: > > Band=40m > RTTY > FT8 > I have tried > (Band='40m') and Mode='RTTY' and Mode='FT8" > Which results in error For educational purposes... If that's a direct copy/paste, the error was because you used a double-quote on the end and single quotes everywhere else. You can use either, but must be consistent. That aside; the mode can't be both RTTY *and* FT8, so that filter would never match anything. My preferred solution would be: Band='40m' and Mode in ('RTTY','FT8') 73, ~iain / N6ML