Hi Andrew,
could you post your model and controller?.
MSSQL is indeed supported (I use it every day) and from your
description it sounds like it should work but without the code it is
impossible to say where the problem might be.
Also, which version of web2py are you using?.
Denes.
On Aug 8, 12:33 am, Andrew <awillima...@gmail.com> wrote:
> Hello, I'm doing the most simple form to test out Keyed Table
> Functionality. I've followed some examples from the examples app and
> some code from the web2py book. My DBMS is MS SQL.
>
> When I enter some data on my basic entry form and press submit,
> nothing happens. In order to debug I added the following from the
> book to my view:
>
> <h2>Submitted variables</h2>
> {{=BEAUTIFY(request.vars)}}
> <h2>Accepted variables</h2>
> {{=BEAUTIFY(form.vars)}}
> <h2>Errors in form</h2>
> {{=BEAUTIFY(form.errors)}}
>
> The request.vars has the values I've entered, but the keyed column in
> form.vars is "None". Nothing in form.errors.
> From Ch7, I understand that the form.accepts in the controller filters
> the request.vars (by validators) and populates form.vars. So why is
> my key column not validating ? My table definition doesn't have any
> validators except for:
> primarykey=['LoadID'],
> migrate=False
>
> I've tried an integer Key, a string Key but no difference.
>
> Am I missing something ? Thanks.
