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
<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+unsubscribe@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.