first you helped my much with my insert/update problem in mysql. Now I have a little question for the select command.
I'm doing a select in my module by this command:
if ($what eq "W")
$sth = $dbh->prepare( sprintf "select * from %s where
+%s = %s",$dbh->quote_identifier($table),$dbh->quote_identifier($col),
.....and so on
My csv list is looking like this:
The first column is my primary key (customer article number). I only get the lines back when I'm looking for the article number with only number in it. In this example I get 11111:TEST:TEST:TEST:TEST. The others cause an error Unknown column 'XZ14B' in where clause. But I don't give the article numbers to the column scalar. In the column scalar is really the column name (in this case tab1).
Did I make a mistake at the columns values. First column is CHAR(30) or VARCHAR(30) right ?