dbFormMagicCell and Custom templates

[Jim]

Another issue I can't seem to resolve is with the
dbFormMagicCell I use Format=[###,##0.00] it displays properly but when I edit the record and try and save I get the following:

Error # = 80040E14(-2147217900)
Description = Line 1: Incorrect syntax near '000.00'.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 42000
Native Error = 170

If I remove the MagicCell processing
[[max_benfit:M]] becomes [[max_benfit]]

The record saves fine.

Help............

[Mark]

Jim,

You cannot use MagicCell on edit templates. If you add dbDebug=101 you will see the SQL that ASP-db is trying to execute when the error occurs.

Mark.

------------
Jim at 3/14/00 1:38:27 PM


Another issue I can't seem to resolve is with the
dbFormMagicCell I use Format=[###,##0.00] it displays properly but when I edit the record and try and save I get the following:

Error # = 80040E14(-2147217900)
Description = Line 1: Incorrect syntax near '000.00'.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 42000
Native Error = 170

If I remove the MagicCell processing
[[max_benfit:M]] becomes [[max_benfit]]

The record saves fine.

Help............