<%@ language="jScript" %>

USER - Edit/View Parts List

Back to Main Menu <% tbl='partTbl' uid='PART_ID' count=0 fields=fieldsParts try{ uniqueId=parseInt(Request.Cookies('USER_ID')) if(!uniqueId){ Response.Write('

NO ID FOUND - CONTACT ITSAHOOT.COM

') Response.End() } Response.Write('
') // sql ='SELECT * FROM '+tbl+' ' // sql+=(uniqueId)?' WHERE USER_ID='+uniqueId+' ':'' // sql+=' ORDER BY PART_NAME' sql ='SELECT partTbl.* FROM partTbl INNER JOIN partTypeTbl ON ' sql+='(partTypeTbl.PART_TYPE=partTbl.PART_TYPE) ' sql+='WHERE USER_ID='+uniqueId+' ' sql+='ORDER BY PART_TYPE_NAME, PART_NAME' rs=new ActiveXObject('ADODB.Recordset') rs.Open(sql,dbConnect,1,3) html ='
' html+='\n\n\t\n' html+='\t\t\n' html+=headerCells(fields) html+='\t\n' fso=new ActiveXObject('Scripting.FileSystemObject'); while(!rs.EOF){ currId=String(rs(uid)) if(Request.Form('delete.'+currId)=='on'){ addDeleteLog(0,rs,fields) rs.Delete() } else { html+='' } count++ rs.moveNext() } rs.close() rs=null fso=null html+='
 
' html+='' adovbs(fields,currId,rs) html+=imageEditIcon(rs) html+=formElements(fields,currId,rs) html+='
' }catch(err){ Response.Write(err.description) } with(Response){ if(count){ Write(html) Write('
') Write('
') } else { Write('

Your list is empty

') } } %>