Snitz Forums 2000 - populate droplist

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/O Code)

populate droplist

New Topic

Topic Locked

Printer Friendly

Previous Page | Next Page

Author

Topic

Page: of 4

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 06:39:05

Ok i've tryed it at home at it seems to populate the second dropdown list with the items of the PROVA_fault, but they don't depend from the selection of the first dropdown list. So it seems like if strGruppo is empty, and so it populates the second dropdown list with the PROVA_fault field. Could this depend from the submit() ????????? Shouldn't this submit() reload the page saving the selection of the first dropdown list??? or what else???
anyway in the afternoon i'm gonna try it at work where i've the latest version of the forum. Let you know later.

thanks a lot once again

Edited by - s80ts0465 on 25 May 2004 06:41:21

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 May 2004 : 06:52:02

~~where in your code are you getting the value from the first dropdown list that was selected in the form?~~ er, nevermind.

so the page does not reload?

instead of using onChange="Prova.submit();" try onChange="document.Prova.submit();"

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

Edited by - Nikkol on 25 May 2004 06:59:10

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 11:01:08

I've tryed it but nothing. The page isn't reloaded. Actually the code is :

Response.Write	"                <form name = ""Prova"" method=""post"" action=""post.asp"">" & vbNewLine & _
		"		 <tr>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """ noWrap vAlign=""top"" align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Event:</b></font></td>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
		"                <select name=""Injection1"" size=""1"" tabindex=""-1"" onchange=document.Prova.submit()>" & vbNewLine
  
Set objDC = Server.CreateObject("ADODB.Connection")
  strConn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/NewElogBook/logbook/database/elogbook.mdb")
  objDC.Open strConn
  Set objRs = objDC.Execute("Select PROVA_gruppo FROM FORUM_PROVA")

if NOT objRs.RecordCount = 0 then
Do While (Not objRs.EOF)		
 
Response.Write " <option value=""" & objRS("PROVA_gruppo") & """>" & objRs("PROVA_gruppo") & "</option>" & vbNewLine
	
objRs.MoveNext
Loop
End If

Response.Write	"                </select>" & vbNewLine & _
			"                </font></td>" & vbNewLine & _
			"              </form></tr>" & vbNewLine


objRs.Close
Set objRs = Nothing
objDC.Close
Set objDC = Nothing


Response.Write	"                <form name = ""Prova1"" method=""post"" action=""post.asp"">" & vbNewLine & _
		"		 <tr>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """ noWrap vAlign=""top"" align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Event:</b></font></td>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
		"                <select name=""Injection3"" size=""1"" tabindex=""-1"" onchane=Prova1.submit()>" & vbNewLine 

Set objDC = Server.CreateObject("ADODB.Connection")
  strConn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/NewElogBook/logbook/database/elogbook.mdb")
  objDC.Open strConn
  strGruppo = Trim(Request.Form("Injection1"))
If strGruppo = "" Then 
	strsql = "Select PROVA_fault FROM FORUM_PROVA"
Else
	strsql = "Select PROVA_fault FROM FORUM_PROVA WHERE PROVA_gruppo='" & strGruppo & "'"
End If
Set objRs = objDC.Execute(strSql)




if NOT objRs.RecordCount = 0 then
Do While (Not objRs.EOF)		
 
Response.Write " <option value=""" & PROVA_fault & """>" & objRs("PROVA_fault") & "</option>" & vbNewLine
	
objRs.MoveNext
Loop
End If
Response.Write	"                </select>" & vbNewLine & _
			"                </font></td>" & vbNewLine & _
			"              </form></tr>" & vbNewLine

objRs.Close
Set objRs = Nothing
objDC.Close
Set objDC = Nothing

What to do to reload the page??

Edited by - s80ts0465 on 25 May 2004 12:05:40

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 May 2004 : 11:44:42

document should be lowercase, javascript is case sensitive.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 12:04:59

i've tryed it too, but the page is reloaded

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 May 2004 : 12:18:29

are you getting any javascript errors when you change the dropdown? do you have a link to the page you are working on so we can see?

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 12:27:16

any error!!!
at the moment the forum is in localhost but when u want i can send u or attach the files.

what about to try to make a little javascript to reload the page??I've seen on the web a lot of guys who launch a javascript that reload the page and add to the url something like ?Group &selectiondroplist It's used in default.asp for the group category menu. Do u know this method??

bye stefano

Edited by - s80ts0465 on 25 May 2004 12:28:17

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 25 May 2004 : 12:30:12

the problem is that the form isn't submitting, so reloading the page won't do any good.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 12:40:08

so i'll check everything once gain later.
I've just noted that all my submitting function in post.asp doesn't work at the moment (also the screensize selection doesn't work now). Probably i did something of wrong.

thanks a lot

Edited by - s80ts0465 on 25 May 2004 12:44:26

s80ts0465
Junior Member

Italy
290 Posts

Posted - 25 May 2004 : 15:05:15

so i've reinstalled the original snitz forum so the basics of the page works fine once again.
At the same time i inserted this code at the line 534:

If strRqMethod = "Topic" then
Response.Write	"                <form name = ""Prova"" method=""post"" action=""post.asp"">" & vbNewLine & _
		"		 <tr>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """ noWrap vAlign=""top"" align=""right""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Event:</b></font></td>" & vbNewLine & _
		"                <td bgColor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & vbNewLine & _
		"                <select name=""Injection1"" size=""1"" tabindex=""-1"" >" & vbNewLine
  
Set objDC = Server.CreateObject("ADODB.Connection")
  strConn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/NewElogBook/logbook/database/elogbook.mdb")
  objDC.Open strConn
  Set objRs = objDC.Execute("Select PROVA_gruppo FROM FORUM_PROVA")

if NOT objRs.RecordCount = 0 then
Do While (Not objRs.EOF)		
 
Response.Write " <option value=""" & objRS("PROVA_gruppo") & """>" & objRs("PROVA_gruppo") & "</option>" & vbNewLine
	
objRs.MoveNext
Loop
End If

Response.Write	"                </select>" & vbNewLine & _
			"                </font></td>" & vbNewLine & _
			"              </form></tr>" & vbNewLine


objRs.Close
Set objRs = Nothing
objDC.Close
Set objDC = Nothing


end If

i get these error when open the page:
Line 240
Error: 'document.PostTopic.Subject' is null or it isn't an object

if i try to change the screensize i get:
Line 473
Error: 'document.PostTopic.Message' is null or it isn't an object

end changing the new droplist get:
Line 155
Error: 'document.Prova' is null or it isn't an object

and the mod we are working around doesn't work too.

I'm also using a Image 2001 Mod snitz forum and when i modify the post.asp file i don't get the errors, but the submit() doesn't work for our mod and also for the screensize.

So could it help?????

Edited by - s80ts0465 on 25 May 2004 15:09:59

s80ts0465
Junior Member

Italy
290 Posts

Posted - 26 May 2004 : 10:37:46

any idea about my problem??
please don't leave me alone with this

byeeeee

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 26 May 2004 : 11:14:39

post a LINK to a text version of the file so we can see the whole thing.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

s80ts0465
Junior Member

Italy
290 Posts

Posted - 26 May 2004 : 12:15:36

ok thanks a lot. this is the link
http://digilander.libero.it/s80ts0465/post.asp

i've noted in my test, that the problem starts at the same time i create the form. From that moment any submit() (also the screensize one) doesn't work fine.

thankssss a lot once again and let me know when you find something

bye stafano

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 26 May 2004 : 12:33:34

one thing, which I don't know if it is causing the problem or not, you don't have quotes around your onchange statement. you also misspelled document. make it:

onchange=""document.Prova.submit();""

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

s80ts0465
Junior Member

Italy
290 Posts

Posted - 26 May 2004 : 12:39:43

no no sorry i've tryed onchange=""document.Prova.submit();"" too but the results doesn't change

Page: of 4

Topic

Previous Page | Next Page

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.91 seconds.