Re: Problem with SQL Server
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 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 >> 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.
Re: Problem with SQL Server
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 > > 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.
Re: Problem with SQL Server
> 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 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'marc...@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+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.
Problem with SQL Server
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'marc...@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+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.