Method POST not working

[=?Utf-8?B?QkxVRVNUQVI=?=]

Here is the link of the website
http://www.smartcharlotte2050.com/YourThoughts.asp

I have been told to change only the form action part of this site.which is
to "response.a sp"
Here the method POST is not working,and I dont know how to solve this
problem

I have tried making my own sample. asp page with 4 textareas as in
YourThoughts.as p,and also I have kept the textarea name and ID same as that.

My sample asp is working perfectly fine,in my page method POST is working. I
need to insert content of textarea in database,

But in YourThoughts.as p nothing is being inserted in database .after
clicking the submit button, the page just redirects to response.asp.

Please please help me, how to solve this problem.
Thank You

[Bob Barrows [MVP]]

No, assuming todaydate is a date/time field and not a Text field, it is
not correct. In Access, date literals need to be delimited by #, not '.
You should read my links and parameterize this statement. Not only will
that make you immune to sql injection, but it will also allow you to
forget about delimiters.

BLUESTAR wrote:

thanks for reply

but after adding Response.Write sSQL & "<BR>"
Response.End

I am getting this
INSERT INTO survey (ID,Response,to daydate) VALUES (
'1','s','7/16/2008') but i have used for loop which will insert 4
datas,but here i am showed only one.

so what do you think ,my INSERT query is correct?????
but nothing is being inserted in database.
my problem is i am not use to Microsoft Access,

Please do reply

Thanks
"BLUESTAR" wrote:

>>
one more thing to add,the insert statement is working perfectly fine
and even response.asp is working correctly when i run it in sql
server 2005.but when i used Access 2007 the problem occurs.and i
will have use Access only..no escape.

i have configured my connection string same as before,but i don no
where am i wrong
"Old Pedant" wrote:

>>So where is the code for "response.asp"? ????

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[=?Utf-8?B?QkxVRVNUQVI=?=]

Problem solved!!!
Thanks
"BLUESTAR" wrote:

>
Now I am getting this error
rror Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/testasp/SurveyResponse. asp, line 16

line 16 is db.Execute sSQL

"BLUESTAR" wrote:

thanks for reply

but after adding Response.Write sSQL & "<BR>"
Response.End

I am getting this
INSERT INTO survey (ID,Response,to daydate) VALUES ( '1','s','7/16/2008')
but i have used for loop which will insert 4 datas,but here i am showed only
one.

so what do you think ,my INSERT query is correct?????
but nothing is being inserted in database.
my problem is i am not use to Microsoft Access,

Please do reply

Thanks
"BLUESTAR" wrote:

>
one more thing to add,the insert statement is working perfectly fine and
even response.asp is working correctly when i run it in sql server 2005.but
when i used Access 2007 the problem occurs.and i will have use Access
only..no escape.
>
i have configured my connection string same as before,but i don no where am
i wrong
"Old Pedant" wrote:
>
So where is the code for "response.asp"? ????