I am very needing yours about asp

trungsonqlkd · #1 Aug 23, 2006, 11:34 PM

Hi,
I am VIetnammes i am studying informatic technonogy. I am studing shopping cart, I downed this demo ones is acart2_0 , but i have problem in error.
In eacht pages that have SQL inner join that it don't run
this code example
<%@ LANGUAGE = "VBScript" %>





<%
productid=valid_sql(request.querystring("productid "))

if productid=null or productid="" or not(isnumeric(productid)) then
response.redirect("error.asp?msg=" & Server.URLEncode("We have no record of the product you are looking for."))
end if

'get the relevant products details
set rsprod=db.execute("SELECT * FROM products INNER JOIN categories ON products.catcode = categories.catcode WHERE products.productid = " & productid)

if rsprod.eof then
response.redirect("error.asp?msg=" & Server.URLEncode("We have no record of the product you are looking for."))
end if

if request.querystring("wish")="add" then
WISHLIST_add(productid)
end if

'get names and codes of all products in that category
set rscatlist=db.execute("select name,productid from products where catcode=" & rsprod("catcode") & " order by name")
%>
<html>

<head>
<title>
<%= storename %>
</title>

<body bgcolor="<%= bgcolor %>" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" text="<%= text %>" alink="<%= COLlight %>" link="<%= COLlight %>" vlink="<%= vlink %>">

<%
header

categorymenu
%>

<table>
<td valign=top align=right>
"><%= rsprod("catname") %>
 
<%

'Display list of other products in category
if not rscatlist.eof then
rscatlist.movefirst
while not rscatlist.eof
%>
">
<a href="product.asp?productid=<%= rscatlist("productid")%>"><%=rscatlist("name")%></a>
 
<%
rscatlist.movenext
wend
end if
%>
</td>

<td>
<% = rsprod("image") %>
</td>

<td width=180 align="left">
">
<%= rsprod("name") %>
 
<table width=180 border=0>
<tr>
<td align="left">
">
Price:
</td>
<td align="right">
">
<% if rsprod("saleprice")="" or rsprod("saleprice")=0 then %>
<% =cursymbol & formatnumber(rsprod("price")) %>
<% else %>
<strike>
<% =cursymbol & formatnumber(rsprod("price")) %>
</strike>
</tr>
<tr>
</td>
<td>">
Sale Price:
</td>
<td align="right">
">
<% =cursymbol & formatnumber(rsprod("saleprice")) %>
">
<% end if %>

</td>
</tr>
</table>
 


<%= rsprod("description") %>
 
<center>
<a href="addprod.asp?productid=<%= rsprod("productid")%>"><img src="http://www.askmehelpdesk.com/images/purchase.gif" border=0></a>
<% if not(WISHLIST_element(rsprod("productid"))) then %>
 
<a href="product.asp?productid=<%= rsprod("productid")%>&wish=add"><img src="http://www.askmehelpdesk.com/images/addwish.gif" border=0></a>
<% end if %>
</td>

</table>

<% footer %> 

</body>
</html>

<%
db.close
set db=nothing
%>
----------------------
while run it have error in row :

set rscatlist=db.execute("select name,productid from products where catcode=" & rsprod("catcode") & " order by name")

-------------------------
i think it don't run in : &rsprod("cacode") because SQL inner join don' runt
i think this Stament is fasle...

i thank who can help me?

trungsonqlkd · Aug 23, 2006, 11:46 PM

http://www.alanward.net/acart/acart20.asp

i downloald this shooping cart but it don't run.
i want help
i code error in SQL that have inner jion

you try down and find error help me
thank you.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!