in reply to Managing Dynamic SQL
Then set $Have_Date=1; or $Have_Time=1; when the user enters the info. Then when its time to do the query:my $Have_Date=0; my $Have_Time=0;
You get the idea...if ($Have_Date) { # # Bind Date Param Stuff # } if ($Have_Time) { # # Bind Time Param Stuff # }
|
|---|