Good morning, I am passing an array to save(), the N´s are of Cake.
Thanks Em quarta-feira, 13 de março de 2013 19h53min18s UTC-3, cricket escreveu: > > > VALUES (N'Marcelo', > > You have a stray single quote( ' ). Actually, you have several: All > your strings have N before them. Where do the Ns come from? Are you > passing an array to save() or are you using $this->query to save the > data? > > On Tue, Mar 12, 2013 at 10:57 AM, rogerbenevento > <[email protected] <javascript:>> wrote: > > Good morning, sorry by my english. > > I am trying make a insert into SQL Server but i dont't work > > > > Database Error > > > > Error: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL > > Server]Incorrect syntax near 'Marcelo'. > > > > SQL Query: INSERT INTO [tecnicos] ([nome], [email], [telefone], [admin], > > [modified], [created], [password]) VALUES (N'Marcelo', > > N'[email protected] <javascript:>', N'11 1232', 1, '2013-03-12 > 11:53:49', > > '2013-03-12 11:53:49', N'5491c11f9ee6ff22b260040f4f1b1a3442d127c4') > > > > Notice: If you want to customize this error message, create > > app\View\Errors\pdo_error.ctp > > > > > > If someone can help!! Please > > > > -- > > Like Us on FaceBook https://www.facebook.com/CakePHP > > Find us on Twitter http://twitter.com/CakePHP > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "CakePHP" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to [email protected] <javascript:>. > > To post to this group, send email to [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
