in reply to using json post in mysql stored procedure

I don't have the backend to really test this on at the moment, but a quick thought... try printing out your data before you get into the whole unless() thing:

# at the top of the script use Data::Dumper; ... # later print Dumper $input; # or, sometimes more effective to ensure # that each var doesn't have newlines or other # nonsense for (qw(to from body)){ print "\n\n>$input->{$_}<\n\n"; } unless (($input->{to}) && ($input->{from}) && ($input->{body}) && ($in +put->{id})) {

...that'll show the specific var with a '>' before the text, and a '<' immediately after it. Say $input->{to} was steveb@cpan.org, it would (ie. should) show:

>steveb@cpan.org<

If you get no output because it's a webapp, open a file and dump the info:

open my $wfh, '>', '/home/user/debug.txt' or die $!; for (qw(to from body)){ print $wfh "\n\n>$input->{$_}<\n\n"; }

Rule 1: always ensure that the data you're using is exactly as you expect to be.

Also, when dealing with a web server, check the server's error logs; they often have valuable info for wtf went sideways.

Replies are listed 'Best First'.
Re^2: using json post in mysql stored procedure
by Anonymous Monk on Jan 24, 2017 at 20:46 UTC
    Thank you for the prompt reply. With your suggestion I realized that the id column in the database was not long enough.