sql.asp

自己做的毕业设计

				if NAME1<>"" and SORT1<>"" and y<>"" and m<>"" and d<>"" and  WRITER<>"" and CONCERN<>"" then
				sql=sql&" where "
				end if
					i=0
					if NAME1<>"" then 
					if i<>0 then sql=sql&" and "							
					sql=sql&" [name] like '%"&name1&"%'"
					i=1+1
				    elseif SORT1<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" [SORT]="&SORT1&" "
					i=1+1
					elseif y<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" year(date) = "&y&""
					i=1+1
					elseif m<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" month(date) = "&m&""
					i=1+1
					elseif d<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" day(date) = "&d&""
					i=1+1 
					elseif WRITER<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" [WRITER] like '%"&WRITER&"%'"
					i=1+1 
					elseif CONCERN<>"" then 
					if i<>0 then sql=sql&" and "		
					sql=sql&" [CONCERN] like '%"&CONCERN&"%'"
					i=1+1
					else
				
				end if