Hell,<br /><br />After I write pdf form, when I clicked the <submit button> in pdf form, I want to save data to MS SQL SERVER.<br /><br />I use Adobe Livecycle desinger v.8.1 program.<br /><br />My question is,<br />1. How to query with <where> statment <br /> ex) SELECT * FROM pubs WHERE title_id = '<param>'<br /><br />2. How to save to MS SQL SERVER<br /> ex) INSERT INTO pubs VALUES ('<param1>','<param2>',...)<br /><br />Thanks for any help that you can give!
A warning which I hope is appropriate... even if you have taken care
of this, it may help other people who read this. The code you have
written will leave your SQL server wide open to attacks of the kind
which have compromised many web sites recently, so your server can be
used for sending spam, collecting passwords, stealing credit card
Be sure you know what "SQL injection" is. You MUST check in detail all
of the data that you insert into an SQL command, even simple SELECT
statements, or you can be attacked. See the Wikipedia entry on SQL
Injection to get started.
Thanks for your response.<br />I agree yours.<br />Then is safe method that using webservice with <where> statement.<br />And can I use filter data in livecycle designer?<br /><br />I'm sory my badly english...<br /><br />regards.