Holdings Prepared Statement Test

DB: crypto | table: cryptocurrencies

$php__symbol = ADA

$cryptocurrency_name = Cardano

DB: holdings | table: crypto_info__summary

Sell Date for ETH

2024-01-01
2024-08-02

[1] DB: holdings | table: holdings__info

$php__account_type = TFSA CAD
$php__holding_type = common shares

CNQ
WFC
FD
LSPD
QETH.UN
CNC
SU
LPEN
BNXA
FUSE
GPH
MN
ELBM
ENB
TOI
PPL
SCR
MUSK
MG
ASTL
LSPD
RY
BNS
NWH.UN
WELL
ATH
CJ
PXT

[2] DB: holdings | table: holdings__info

$php__account_type = TFSA CAD
$php__holding_type = common shares

CNQ
WFC
FD
LSPD
QETH.UN
CNC
SU
LPEN
BNXA
FUSE
GPH
MN
ELBM
ENB
TOI
PPL
SCR
MUSK
MG
ASTL
LSPD
RY
BNS
NWH.UN
WELL
ATH
CJ
PXT

[3] DB: holdings | table: holdings__info

$php__account_type = TFSA CAD
$php__holding_type = common shares

SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: 'IS NULL'

[4] DB: holdings | table: holdings__info

$php__account_type = TFSA CAD
$php__holding_type = common shares

SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: 'IS NULL'