In Progress

asp cart32 coding problem

I need someone to fix a coding problem for me.

If you click on this url <[url removed, login to view]> I get this error where the suggestive items should be I did put the items in there on the database so that isnt the prob

This is the code here it was doing the same thing when i added a shirts category to the dickies school uniforms but when i put the products up a level it didnt do that so i assume i have to code another level somehow it looks like the prob is here in the [url removed, login to view] file that i have attached goes 2 levels and i need it to go 3 but i could be wrong

(this is the part i think needs edited)

auxitms = " SELECT *" & _

" FROM tblProducts" & _

" WHERE ProductID = '"

cid2sql = " SELECT CategoryID AS cid2" & _

" FROM tblCategories" & _

" WHERE ParentID = " & pid & _

" AND CategoryID <> " & cid & ";"

Set newcid = [url removed, login to view](cid2sql)

cid2 = newcid("cid2")

ssellsql = " SELECT *" & _

" FROM tblProducts" & _

" WHERE (CategoryID = " & cid & _

" OR CategoryID = " & cid2 & ")" & _

" AND ProductID <> '" & id & "'" & _

" AND SmallPicture <> Null" & _

" ORDER BY CategoryID DESC;"

Set products = [url removed, login to view](ssellsql)

if not [url removed, login to view] then

Hope someone knows how to fix this issue.

thanks,

Steve Barringer

Best Buy Uniforms

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

windows xp

Skills: Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL

See more: server side coding, part problem, package coding, no problem part 1, how to get coding, hire coding, get coding, get a coder problem, coding web sites, coding sites, coding how to, best buy hire, best buy com, source coding, prob, eof, coding hire, best coding software, php prob, error database problem, bestbuyuniforms, asp school, school database coding, source shirts, null software

About the Employer:
( 148 reviews ) Pittsburgh, United States

Project ID: #3349569

Awarded to:

almasoft

See private message.

$20 USD in 7 days
(573 Reviews)
7.7

10 freelancers are bidding on average $32 for this job

arosoft

See private message.

$46.75 USD in 7 days
(59 Reviews)
5.9
massi69

See private message.

$8.5 USD in 7 days
(7 Reviews)
4.5
rupalikunde

See private message.

$8.5 USD in 7 days
(23 Reviews)
4.5
dev100vw

See private message.

$21.25 USD in 7 days
(2 Reviews)
4.1
snawab

See private message.

$17 USD in 7 days
(30 Reviews)
3.9
mehtavw

See private message.

$45.05 USD in 7 days
(4 Reviews)
2.0
annuji

See private message.

$85 USD in 7 days
(0 Reviews)
0.0
deepaknewton78

See private message.

$29.75 USD in 7 days
(0 Reviews)
0.0
AserBasic

See private message.

$42.5 USD in 7 days
(1 Review)
0.0