This is the expected behavior for sqlite. It does the same thing if
you do it at the console:
sqlite> CREATE TABLE test(id int, name varchar[256],primary key(id));
sqlite> INSERT INTO test(name) VALUES ('foo');
sqlite> SELECT * FROM test;
|foo
You have to keep in mind that sqlite is not Postgres or Oracle; it
serves a different purpose. :) Postgres is a good choice if you want
those kinds of guarantees.
On Wed, Aug 20, 2008 at 8:15 PM, WalterCool <[EMAIL PROTECTED]> wrote:
>
> Hi there
>
> im using sqlite, and have this parameters:
>
> CREATE TABLE test(id int, name varchar[256],primary key(id));
>
> And using that with web.py:
>
> value = web.insert('test', name = params.nombres), where nombres is a
> value given from a form.
>
> And that the results:
>
> "| hello"
>
> Whats with that??!! My id, a primary key... without value??!!
>
> Using web.py 0.23
> >
>
--
Gary
http://blog.extracheese.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
