in reply to perl win32:odbc exceution of query with unions
Also, I am seeing the following in your code
I think you might want to escape your date properly. In Access you usually do like so --$db-> Sql( "execute Sp2 2004/05/16" )
Note the use of the # signs bookending the date.my $date = "#2004/05/16#"; $db-> Sql( "execute Sp2 $date" )
|
|---|