Hi jarich,

Thanks for your reply - I had no idea that Matt's script was doing all that deleting/rewriting biz - yikes!

anyhow...

I tried inserting your code as suggested but am getting "Server Error" replies. While what you're suggesting does indeed make lots of sense, it seems that it also involves really overhauling most of the script - as well as the form - to reflect the new fields and their values, right?

Since the script as it is ("code ugliness" etc., notwithstanding...), already spits out working INSERT strings (with the field values for 'rid', 'dt_create', and 'publish' all included in the "Description" field - I know this does not reflect how many fields are in the form, but since the string output matches the database fields, it "works"...), I guess I don't understand why that same data can't somehow be redirected to MySQL along the lines of CountZero's code which does successfully post INSERT strings to MySQL - just from the wrong location?

Also, since Matt's <!begin> biz is not needed for inserting into MySQL and screws things up if it's there (which is why I removed it), I'm wondering if perhaps there's a way to simply delete/replace/avoid/modify those parts of the script, yet still process the form? If so, shouldn't it then be possible to execute the strings as they output?

Thanks again jarich,

-Bob

bobafifi.com

In reply to Re: Right answer (wrong question...) by bobafifi
in thread Right answer (wrong question...) by bobafifi

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.