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