MYSQL Help

General discussions V2
Post Reply
k0guz
Novice Class
Posts: 15
Joined: 22 Jan 2018, 20:06

MYSQL Help

Post by k0guz »

I know little about MYSQL, and need to write a script in order to use the automatic QSL program from N1ET, which uses the (his)SIG and (his)SIGINFO fields from Log4OM to create a customized QSL. I've been using the standard LOG4OM convention of using the Award fields when I enter the POTA information after successfully hunting an activator, since it produces some useful charts. So this is what I need to do:

IF <Awards> = "POTA" AND (Award Reference> IS NOT BLANK
THEN COPY <Awards> TO <HISSIG> AND COPY <Award Reference> to <HISSIGINFO>
ELSE GO TO NEXT RECORD

As you can tell, my coding skills atrophied after Basic and Turbo Pascal.

Thanks & 73's de K0GUZ
Post Reply