What does the code look like where you call save? Also, what do you get with $this->log($your_array) in the error log?
Is Cake running on the same machine as the DB? On Thu, Mar 14, 2013 at 7:41 AM, rogerbenevento <rogerbeneve...@gmail.com> wrote: > 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 >> <rogerbe...@gmail.com> 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'ma...@forepoint.com.br', 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 cake-php+u...@googlegroups.com. >> > To post to this group, send email to cake...@googlegroups.com. >> > 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 cake-php+unsubscr...@googlegroups.com. > To post to this group, send email to cake-php@googlegroups.com. > 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 cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
