I usually have great success with this module but lately, I am running into all sorts of problems. This is one is killing me. If anyone can tell me what what's wrong, I would really appreciate it. It's possible it's me now though, I have been at this one for 28 hours straight.
I have simplified the problem but here it is: SQL Statement is this. "SELECT DISTINCT ProductLineName FROM SBR" Here is a sample of the CSV file. ############################################################# "ProductID","Category","CategoryName","ProductLineName","ProductLine" 159,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 160,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 161,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 163,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 164,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 165,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 166,"sbr","Silicon Bridge Rectifiers","3PB2500","3PB2500" 167,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" 168,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" 169,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" 170,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" 171,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" 172,"sbr","Silicon Bridge Rectifiers","3PB3500","3PB3500" The code only returns the 3PB2500. Not included in the sample is many other entries in the ProductLineName field. They all are returned, but never both of these two 3PB3500 & 3PB2500. What is it....is it something obvious I am not seeing?
