Re: Building SQL statement

2002-09-04 Thread david
Mark Wildey wrote: > '$Var1','$Var2','$Var3','$Var4' etc etc if you really have something like: @DataIn = ('$Var1','$var2','$Var3','$Var4'); #-- ...etc you are telling Perl not to(because of the single quote) interpolate on $Var1, $Var2, $Var3 .. etc foreach $word (@DataIn){ print "W

Building SQL statement

2002-09-04 Thread Mark Wildey
True beginners question…. sorry I have a MS Access database that has lots of fields in it. When I build the SQL statement to insert data retrieved from a text file, rather than build a very long SQL statement I have used a “@column = $db->FieldNames()” subroutine to build a scalar variable ( cal