Dynamic dropdown not fit in column

**guddu** · guddu, August 19th, 2008 01:11 PM

hi
i m creating dropdown on the fly.i m calling this function FillProtocolSettingNo see bold line.but problem is my dropdown is not creating at that column.it create drop down outside of that table.why this happening?

Code:

StrDisplay = StrDisplay & "<TR class=""HeaderRow"">"					
			StrDisplay = StrDisplay & "<TD align=""left"">"& FillProtocolSettingNo()& "</TD>"
			StrDisplay = StrDisplay & "<TD align=""left"">"& FillDocumentTypeNo()& "</TD>"
			StrDisplay = StrDisplay & "<TD align=""left""><INPUT type=""text""></TD>"
			StrDisplay = StrDisplay & "<TD align=""left""><INPUT type=""text"" ></TD>"
			StrDisplay = StrDisplay & "<TD align=""left""><INPUT type=""text"" ></TD>"
			StrDisplay = StrDisplay & "<TD align=""right"" colspan=""2""><input type=""button"" name='btnAdd_"& vlMemberID &"' value=""Add Settings""></TD>"
			StrDisplay = StrDisplay & "</TR>"
			StrDisplay = StrDisplay & "</TBODY>"
			StrDisplay = StrDisplay & "</TABLE>"
			Response.write StrDisplay

Code:

Function FillProtocolSettingNo()
	Dim rstProtocolSettingNo
	On Error Resume Next 
	Set objData = Server.CreateObject("ProtocolSettings.clsSearcher")		
	Set rstProtocolSettingNo = objData.FillProtocolSettingNo()
	If Not rstProtocolSettingNo.EOF Then 		
		Response.write "<select id=""cboProtocolSettingNo"" name=""cboProtocolSettingNo"" style=""width:180px"">"
		Response.write "<option>---- Select ProtocolSettingNo ----</option>"
			While Not rstProtocolSettingNo.EOF
				Response.write "<option value="& rstProtocolSettingNo("ProtocolSettingNo") & ">" & rstProtocolSettingNo("Description") &"</option>"
				rstProtocolSettingNo.movenext
			Wend 
		Response.write "</select>"
	End If 
	If (err.number <> 0) Then strMsg = "Please resolve this error  " & err.description
	Set objData = Nothing
End Function

same probelm with this dropdown also.

Thanks

**mehere** · mehere, August 19th, 2008 01:14 PM

remove the On Error Resume Next and see if you get an error.

**guddu** · guddu, August 19th, 2008 01:17 PM

i m not getting any error .drop down is populating well.only dropdown not fix up with in that column of table.it goes to outside of the table.

**guddu** · guddu, August 19th, 2008 01:18 PM

dropdown should bind in this column of table
StrDisplay = StrDisplay & "<TD align=""left"">"& FillProtocolSettingNo()& "</TD>"

**mehere** · mehere, August 19th, 2008 01:19 PM

do you have an opening table and tbody tag? i don't see them in your code. just trying to narrow this down. i see nothing in the code i've seen so far that would render it outside the table.

**richyrich** · richyrich, August 19th, 2008 01:20 PM

I think if you're using a function you'll need to return the code rather than just using response.write, which just writes it to the screen. Something like:-

Code:

Function FillProtocolSettingNo()
	Dim rstProtocolSettingNo, returnddl
	On Error Resume Next 
	Set objData = Server.CreateObject("ProtocolSettings.clsSearcher")		
	Set rstProtocolSettingNo = objData.FillProtocolSettingNo()
	If Not rstProtocolSettingNo.EOF Then   
  returnddl =  "<select id=""cboProtocolSettingNo"" name=""cboProtocolSettingNo"" style=""width:180px"">"
    returnddl = returnddl & "<option>---- Select ProtocolSettingNo ----</option>"
			While Not rstProtocolSettingNo.EOF
    returnddl = returnddl & "<option value="& rstProtocolSettingNo("ProtocolSettingNo") & ">" & rstProtocolSettingNo("Description") &"</option>"
				rstProtocolSettingNo.movenext
			Wend 
returnddl = returnddl & "</select>"
	End If 
	If (err.number <> 0) Then strMsg = "Please resolve this error  " & err.description
	Set objData = Nothing
 
return returnddl
'or I think you can also set the name of the function to the value to return FillProtocolSettingNo=returnddl

End Function

Then if you use:-

Code:

response.write(FillProtocolSettingNo)

that should write out the code...I think...

Hope that helps.

**guddu** · guddu, August 19th, 2008 01:27 PM

yup u are rite.Thanks a lot RR.

Thread: Dynamic dropdown not fit in column

LinkBack

Thread Tools

Display

Dynamic dropdown not fit in column

Similar Threads

Dropdown list

Dynamic dropdown list with multiple records

Concatenation of Column Data function

Creating Dynamic Dropdown Menu!?

Concatenation of Column data function....

Bookmarks

Bookmarks

Posting Permissions