Discuss "Dynamic dropdown not fit in column" in the ASP Development forum.

guddu · #1 August 19th, 2008, 12: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 · #2 August 19th, 2008, 12:14 PM

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

guddu · #3 August 19th, 2008, 12: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 · #4 August 19th, 2008, 12:18 PM

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

mehere · #5 August 19th, 2008, 12: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 · #6 August 19th, 2008, 12: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 · #7 August 19th, 2008, 12:27 PM

yup u are rite.Thanks a lot RR.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dropdown list	Shem	.Net Development	5	May 27th, 2008 01:39 PM
Dynamic dropdown list with multiple records	Rebelle	ASP Development	4	April 30th, 2008 05:33 AM
Concatenation of Column Data function	AOG123	Microsoft Access	0	March 25th, 2008 06:53 AM
Creating Dynamic Dropdown Menu!?	jarvelous	ASP Development	1	March 20th, 2008 12:30 PM
[SQL] Concatenation of Column data function....	Lauramc	Code Samples	0	March 17th, 2008 12:32 PM

The Following User Says Thank You to richyrich For This Useful Post:
guddu (August 19th, 2008)

Discuss "Dynamic dropdown not fit in column" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.