Re: What is wrong with select?

[Ondrej Koala Vacha]

On Sat, 2 Apr 2005, Robert A. Rawlinson wrote:

> $StateProvince = 'PA';
> my $sql1 = "SELECT id, name_short, name_long FROM states WHERE
> name_short=$StateProvince";


This example expands to "...name_short=PA". 

You may try:

name_short='$StateProvince'


regards
--
Ondrej Koala Vacha