ASP Drop Down

[timdodgson]

Hi i have 2 questions

I have managed to get adrop down to populate from my access db but some of mr recordsare blank so it puts blanks in the drop down how can i filter this out
and next question is there a way i can auto xcapatilze the returned values

Many Thanks in Advaance
Tim Dodgson

http://www.timdodgson.co.uk

 

[ChrisHirst]

leave them out of the recordset,

WHERE field <> "";


set proper case function

function Proper(strIn)
' function for setting proper case 
' for a single line of text
if instr(strIn,vbCrLf) > 0 then
'	if string contains CR call MultiLine function
	Proper = MultiLineProper(strIn)
	exit function
end if
dim words
dim i
words = Split(strIn," ")
for i = 0 to ubound(words)
	words(i) = Capitalise(words(i))
next
if ubound(words) > 0 then
	for i = 0 to ubound(words)
			if i = 0 then
				Proper = Proper & words(i)
			else
				Proper = Proper & " " & words(i)
			end if			
	next
else
	Proper = Capitalise(strIn)
end if
end function

' capitalise first letter of string sent
function Capitalise(strText)
Capitalise = ucase(left(strText,1)) & lcase(mid(strText,2))
end function

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[timdodgson]

Thank you so much i should of know the first one derrrrrrrrrr i only been coding 6 weeks and using google and tek-tips as my book
Again Thanks a lot

Tim

http://www.timdodgson.co.uk

 

[ChrisHirst]

just go to W3Schools just about everything you need is there.


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.