hi
I work in my project and I have a problem in the page that will add the order to database here is my code
can anyone help me
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
hi
I change my code but the same problem appear
<%
'Check if user is logged in
if Session("name") = "" then
'If not, go to login page
response.write("<center><p> sorry you should login</p><a href='login.asp' target='main'>login</a></cente
else
'add the order to the database
%>
<html>
<body>
<%
desc = request.querystring("descr
pr = request.querystring("price
set myconn=server.createobject
myconn.open "DSN=myconn"
sql = "INSERT INTO order(description, price) values('"&desc&"','"&pr&"'
myconn.execute sql
%>
<h2>your order have been added<h2>
<center><a href="basket.asp" target="main">go to basket </a></center>
</body>
</html>
<%
end if
%>
One thing that we have neglected to ask in this question.
What is the error that you are getting?
If this is hosted on your own computer, it could be a problem with Permissions.
As the code should work (or) give you an accurate error and code to go by.
So please give this Error to us so we can better assist you in resolving this issue.
Carrzkiss
I change the language but it doesn't work
Requested URL http://localhost:80/projec
Physical Path C:\inetpub\project\server.
Logon Method Anonymous
Logon User Anonymous
OK
sts901
I need to know the error that you are getting
>>HTTP Error 404.0 - Not Found
Only means that it cannot be found, which means that the page is not there.
Which means that it is not working.
Are you using a form?
Please provide the entire form that you are using to pass the variables to the Insert page.
And since it is a QueryString Insert that you are doing, it should be a method="get".
Once again, we need to know the error
(You have set the proper permission, what permission did you assign?)
Carrzkiss
Okay this is the code in Previous page
<html>
<head></head>
<body background="background.jpg
<h2>hometools<h2>
<%
set myconn=server.createobject
myconn.open "DSN=myconn"
SQL_query="SELECT * FROM hometools"
set rs = myconn.execute(SQL_query)
response.write("<table border=1 >")
while not rs.eof
response.write("<tr>")
response.write("<td><img src =" & rs("image") & ".bmp width=100 height=100 ></td>")
response.write("<td>" & rs("description") & "</td>")
response.write("<td> price " & rs("price") & "</td>")
response.write("<td><a href=""checklogin.asp?desc
response.write("</tr>")
rs.movenext
wend
response.write("</table>")
myconn.close
set myconn=nothing
%>
</body>
</html>
You are not passing a Form, how are you getting your information sent to the next page?
Lets look at your code ok. It is not properly done.
You need to have a Form, it needs to be a form in order for you to submit into the database.
The below code is a sample of what you need to do. You need to have a form.
Run this and you should be able to do the Insert without a problem.
---
Permission - IIS7
IIS7 Should have it set already, but we will deal with that, after we correct your non-working code.
Carrzkiss
Sorry for the trouble I make it to you because I am beginner at asp
I change the code but still it doesn't work
response.write("<table border=1 >")
response.write("<form action="checklogin.asp" method="get">")
while not rs.eof
response.write("<tr><td>")
response.write("<input name="price" type="hidden" value="<%=rs("price")%>" /></td></tr><tr><td>")
response.write("<input name="description" type="hidden" value="<%=rs("description")
response.write("<input name="" type="submit" value="add to cart"></td></tr></table></form>")
rs.movenext
wend
response.write("</table>")
sorry like this
while not rs.eof
response.write("<table border=1 >")
response.write("<form action='checklogin.asp' method='get'>")
response.write("<tr><td>")
response.write("<input name='price' type='hidden' value='<%=rs("price")%>' /></td></tr><tr><td>")
response.write("<input name='description' type='hidden' value='<%=rs("description")
response.write("<input name='' type='submit' value='add to cart'></td></tr>"")
response.write("</table></for
rs.movenext
wend
May I also suggest?
If you are going to be passing a lot of information in the [description]
You really need to do a
request.form
Instead of
request.querystring.
2 reasons
#1: Makes your URL look crappy with a lot of %20 and all the other mess that is in the string.
#2: There is less confusion with interpreting the values when it is done through a form.
Anyway.
Good Luck
Carrzkiss
Simple over site.
You are using a reserved word. order
(More about reserved words) http://support.microsoft.c
As your Table name.
So. we have to change the INSERT code to reflect this issue
order
to
[order]
All statements that you make have to use the table name in Brackets. [order]
(or) to get away from this issue, you can simple change your table name to MyOrder or something
Else that is not a reserved word.
http://ee.cffcs.com/Q_2444
code
http://ee.cffcs.com/Q_2444
This is an example of doing this in a Request.form and request.querystring.
(This example does not use your hometools table)
Good Luck
Carrzkiss
Business Accounts
Answer for Membership
by: carrzkissPosted on 2009-05-27 at 18:03:37ID: 24488995
you need an INSERT statement like this.
Not what you are trying to use.
This gathers the information from a form and then INSERT into the database
Give it a shot
Carrzkiss
Select allOpen in new window