Here is the link of the website

http://www.smartcha­rlotte2050.com/YourT­houghts.asp

I have been told to change only the form action part of this site.which is

to "response.asp"

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.asp,an­d 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.asp 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

Here is the link of the website

http://www.smartcha­rlotte2050.com/YourT­houghts.asp

I have been told to change only the form action part of this site.which is

to "response.asp"

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.asp,an­d 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.asp 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

I forgot to add,is it because YourThoughts.asp have multiple forms,but as far

as I know ASP can have multiple form

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

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

Okay somehow I have solved the error,but now i am stuck in new error.

this is the response.asp code

<%

Set db=Server.CreateObj­ect ("ADODB.Connection"­)

db.Open "DSN=mysurvey;"

strDate=Date()

for i=1 to 4

res=Request.Form("Y­our Thoughts Q"&i)

sSQL = "INSERT INTO survey (ID,Response,Date) "

sSQL=sSQL & " VALUES ( '"

sSQL=sSQL & i & "','"

sSQL=sSQL & res & "','"

sSQL=sSQL & strDate & "')"

db.Execute sSQL

Next

db.Close

Response.Write ("Your data has been successfully send.Thanks for your

response!!!")

%>

* Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Microsoft][ODBC Microsoft Access Driver] Syntax error in

INSERT INTO statement.

/testasp/SurveyResp­onse.asp, line 13

I have even tried the following,but problem persist.

In IE, turn off the "Friendly HTTP error messages" by choosing tools -

internet options - advanced. The full error messages as well as the

line number of the error will then be displayed.

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:

thanks for reply

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

Response.End

I am getting this

INSERT INTO survey (ID,Response,todayd­ate) 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:

thanks for reply

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

Response.End

I am getting this

INSERT INTO survey (ID,Response,todayd­ate) 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:

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/SurveyResp­onse.asp, line 16

line 16 is db.Execute sSQL

"BLUESTAR" wrote: