473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Method POST not working

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.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,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.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

Jul 15 '08 #1
11 2808
I forgot to add,is it because YourThoughts.asp have multiple forms,but as far
as I know ASP can have multiple form,also I tried deleting the form "which I
am not suppose to as they dont want any changes in their website" but still
the problem persist.

Please do reply!!!!!!!!

Thank You

"BLUESTAR" wrote:
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.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,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.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
Jul 15 '08 #2

"BLUESTAR" <BL******@discussions.microsoft.comwrote in message
news:4A**********************************@microsof t.com...
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.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,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.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
Since this group deals with asp (which runs on the server and is not
accessible via the browser) perhaps you should post the code that you are
trying to "get to work" and explain the symptoms that lead you to believe it
"is not working".

--
Mike Brind
MVP - ASP/ASP.NET
Jul 15 '08 #3
So where is the code for "response.asp"?????
Jul 15 '08 #4
"BLUESTAR" wrote:
I forgot to add,is it because YourThoughts.asp have multiple forms,but as far
as I know ASP can have multiple form
Nothing to do with ASP. HTML allows as many <FORMtags on a page as you
want. Only restriction is that they CAN NOT be nested (you can't have a
<FORMtag *inside* another <FORM>....</FORMrange).

And *ONLY* the <FORMthat is actually submitted by the user will be posted
to the ACTION= specified in that one <FORM>. All other forms are ignored.

This is true whether you are using ASP or PHP or JSP or even just using a
<FORMto go to another HTML page.

As Mike said, no code, no help. We can't read your mind.
Jul 15 '08 #5

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

this is the response.asp code
<%
Set db=Server.CreateObject ("ADODB.Connection")
db.Open "DSN=mysurvey;"
strDate=Date()
for i=1 to 4
res=Request.Form("Your 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!!!")

%>
this the link of the website from where data will be stored in database.
http://www.smartcharlotte2050.com/YourThoughts.asp

The error I am getting

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

* Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
/testasp/SurveyResponse.asp, line 13

* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.16)
Gecko/20080702 Firefox/2.0.0.16

* Page:
POST 93 bytes to /testasp/SurveyResponse.asp

* POST Data:

Your+Thoughts+Q1=gf&Your+Thoughts+Q2=dd&Your+Thoug hts+Q3=cc&Your+Thoughts+Q4=bb&Submit=Submit

* Time:
Wednesday, July 16, 2008,

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.
Thanks Again for your support

"Old Pedant" wrote:
So where is the code for "response.asp"?????

Jul 16 '08 #6

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"?????

Jul 16 '08 #7
BLUESTAR wrote:
Okay somehow I have solved the error,but now i am stuck in new error.

this is the response.asp code
<%
Set db=Server.CreateObject ("ADODB.Connection")
db.Open "DSN=mysurvey;"
strDate=Date()
for i=1 to 4
res=Request.Form("Your 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!!!")

%>
<snip>
* Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement.
/testasp/SurveyResponse.asp, line 13
You cannot debug a sql statement without knowing what it is. Insert the
following before the Execute statement:

'***********comment out when finished debugging*******
Response.Write sSQL & "<BR>"
Response.End
'***********comment out when finished debugging*******

Run the page and look at the resulting sql statement. The error should
stick out like a sore thumb. If not post it here.

Further points to consider:
Your use of dynamic sql is leaving you vulnerable to hackers using sql
injection:
http://mvp.unixwiz.net/techtips/sql-injection.html
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=23

See here for a better, more secure way to execute your queries by using
parameter markers (tokens):
http://groups-beta.google.com/group/...e36562fee7804e

Personally, I prefer using stored procedures, or saved parameter queries
as they are known in Access:

Access:
http://www.google.com/groups?hl=en&l...TNGP12.phx.gbl

http://groups.google.com/groups?hl=e...tngp13.phx.gbl

SQL Server:
http://groups.google.com/group/micro...09dc1701?hl=en

>
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.
Friendly Errors was already disabled
--
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.
Jul 16 '08 #8

thanks for reply

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

I am getting this
INSERT INTO survey (ID,Response,todaydate) 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"?????
Jul 16 '08 #9

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,todaydate) 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"?????
>
>
Jul 16 '08 #10
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,todaydate) 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.
Jul 16 '08 #11

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,todaydate) 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"?????
Jul 16 '08 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Asp Help | last post by:
I'm working on a ASP applicatition to create Windows 2000 users. Because I don't want everybody to have access to the site I've changed te security in IIS 5.0 which runs on a windows 2000 Sp4...
28
by: Jon Davis | last post by:
If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass();...
4
by: Paul J. Lay | last post by:
I am sending and receiving multipart messages using the WebClient UploadData method Method=Post. Everything seems to work well except when the URL contains parameters. For example:...
9
by: WJ | last post by:
I have an Asp.Net page that redirects the user to another page with a piece of data to be passed. Below is the c# instruction: Response.Redirect("mySpecialPage.aspx?go1="+strGoName); This will...
5
by: Vishal | last post by:
Hello, I already asked this question in the ASP.NET forums, but no help came. So I am hoping that somebody can help me out. This is really very URGENT me. For my e-commerce application, I...
3
by: PawelR | last post by:
Hello Group, How send few value using HttpWebReguest with POST method in one request? Thx. PawelR
6
by: James MA | last post by:
I'm now writing a small program to communicate a web server to simulate a web client. I use te httpwebrequest to talk with the server, and it works find for "POST" method, however, when i test...
4
plumpnation
by: plumpnation | last post by:
Hello one and all. I have recently been working outside of my field of expertise alot, and it is greatly distressing me. I have learned a small amount of php and actionscript, but now need to move...
5
by: rn5a | last post by:
The .NET 2.0 documentation states the following: When using a DataSet or DataTable in conjunction with a DataAdapter & a relational data source, use the Delete method of the DataRow to remove...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.