parsing update command with spaces

Bhargav Coca

I am trying to update by db using a simple update command in my perl script.

For some reason perl picks up the double quotes into the db too, is there a work around for this.

This works :

$myvar ="Test";

my $query = "UPDATE tbl_necus_generic SET areavpath='\templatedata\process\data\Test1',class='$myvar' WHERE areavpath='\templatedata\process\data\Test1";

This doesn't work

$myvar = "Test & Discard"

my $query = "UPDATE tbl_necus_generic SET areavpath='\templatedata\process\data\Test1',class='$myvar' WHERE areavpath='\templatedata\process\data\Test1";

here the db is updates with only Test for class.

I tried all other ways of parsing double quotes, so that it would consider the spaces but no luck. Can anyone point me in right direction.

Thank You

Adam Stoller

Try this:

...
$myvar = "Test & Discard"

my $query = qq(UPDATE tbl_necus_generic SET areavpath='\templatedata\process\data\Test1',class="$myvar" WHERE areavpath='\templatedata\process\data\Test1);
...