PHP Classes

Nek

Recommend this page to a friend!

      csv2sql  >  All threads  >  Nek  >  (Un) Subscribe thread alerts  
Subject:Nek
Summary:I find a problem in query
Messages:2
Author:Paco Nek
Date:2012-10-17 18:20:12
Update:2012-10-17 18:58:15
 

 


  1. Nek   Reply   Report abuse  
Picture of Paco Nek Paco Nek - 2012-10-17 18:20:12
Hello, this script is ok but it have a problem in sql generate.

this result example;
INSERT INTO `Atlas` (.`"SKU"`,`"EAN"`,`"MPN"`,`"Nombre"

for mysql say i can not find `"SKU"` field it is incorrect
for secuence correct is `SKU` with out " "

it is posible correct it in code class. ?

Thanks

  2. Re: Nek   Reply   Report abuse  
Picture of Paco Nek Paco Nek - 2012-10-17 18:58:15 - In reply to message 1 from Paco Nek
Excuse it is not a problem it is other,
mysql say;
#1054 - Unknown column '"SKU"' in 'field list'

but SKU field exist.

INSERT INTO `Atlas` (`"SKU"`,`"EAN"`,`"MPN"`,`"Nombre"`,`"Precio"`,`"PrecioSinOferta"`,`"Imagenes"`,`"Imagen"`,`"Disponible"`,`"Familia"`,`"SubFamilia"`,`"Marca"`,`"Descripcion"`) VALUES ('\"OCZSSDUPGDKIT1\"','\"OCZSSDUPGDKIT1\"','\"OCZSSDUPGDKIT1\"','\"Caja Externa OCZ Actualizacion Bracket + Adaptador\"','\"9,47\"','\"\"','\"1\"','\"http://www.atlasinformatica.com/media/catalog/product/ocz_kit_actualizacion_1.jpg\"','\"1\"','\"\"','\"\"','\"OCZ\"','\"Kit de actualización con caja externa, braket adaptador, cable USB, cable SATA y CD software.\"');

I need help
Thanks