In Progress

asp cart32 coding problem

I need someone to fix a coding problem for me.

If you click on this url <[login to view URL]> 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 [login to view URL] 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 = [login to view URL](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 = [login to view URL](ssellsql)

if not [login to view URL] then

Hope someone knows how to fix this issue.


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

9 freelancers are bidding on average $34 for this job


See private message.

$46.75 USD in 7 days
(59 Reviews)

See private message.

$8.5 USD in 7 days
(23 Reviews)

See private message.

$8.5 USD in 7 days
(7 Reviews)

See private message.

$21.25 USD in 7 days
(2 Reviews)

See private message.

$17 USD in 7 days
(30 Reviews)

See private message.

$45.05 USD in 7 days
(4 Reviews)

See private message.

$85 USD in 7 days
(0 Reviews)

See private message.

$29.75 USD in 7 days
(0 Reviews)

See private message.

$42.5 USD in 7 days
(1 Review)