Caveat: I don't use MS Windows - nobody has yet offered to pay enough.

it does not INSERT the new record. But, what is really odd, is that if I try and submit the same data again, I get a Unique Constraint error.

This suggests that it is indeed writing to a database, just not the same database where you go looking for the results. Perhaps your IIS is running your CGI script chrooted somewhere? Have a search through your system for other database files of the same name - maybe you will find your data there.

PS. You could also try writing a second CGI script which just reads from the database and displays the table contents. If that magically finds the data then it proves that the above suggestion is valid.

In reply to Re: Trouble writing to SQLite from CGI on Windows by hippo
in thread Trouble writing to SQLite from CGI on Windows by RedJeep

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.