| Author |
 Topic  |
|
s80ts0465
Junior Member
Italy
290 Posts |
 Posted - 27 May 2004 : 09:53:49
|
i've tryed ur last string, but it doesn't work.
compilation error of Microsoft VBScript (0x800A03EE) Expect ')'
the form retrive from the databse simply text |
Edited by - s80ts0465 on 27 May 2004 09:57:02 |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 28 May 2004 : 02:36:16
|
I've also tryed without the db connection using this code:
Response.Write " <form name = ""Prova"" method=""post"" action=""post.asp?" & Request.ServerVariables("QUERY_STRING") & """>" & 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 & _
" <option value=""" & """>no value</option>" & vbNewLine & _
" <option value=""ciao"">ciao</option>" & vbNewLine & _
" <option value=""hallo"">hallo</option>" & vbNewLine & _
" <option value=""hi"">hi</option>" & vbNewLine & _
" <option value=""no"">no</option>"
Response.Write " </select>" & vbNewLine & _
" </font></td>" & vbNewLine & _
" </form></tr>" & vbNewLine
and it finally gave me a good thing.
so the page reload to the right page (always post.asp) and it seems that also the submitting() function works fine, in fact the second dropdown list is populated by the right value (in function of the first selection). The only problem is that in the first dropdown list doesn't compare the item selected....why???
thanksssss a lot |
Edited by - s80ts0465 on 28 May 2004 05:55:48 |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 28 May 2004 : 06:03:06
|
the data retrived from the databse are simply text.
About the link, i'm sorry the forumn is on localhost, and i still don't find a webspace. anyway above i posted a link to the post.asp file
i've also edited the above post. I've got good results :-) check it |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 28 May 2004 : 06:29:27
|
ok i resolved it with this line
" <option value=""" & Request.Form("Injection1") & """>" & Request.Form("Injection1") & "</option>" & vbNewLine & _
soooo why didn't it work before??? is it due to the double connection to the databse?? is it a problem for the future????
Anyway apart all this thanks to alllll for the help
bye stefano and stay tune for the next time  |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 28 May 2004 : 08:24:17
|
I'm still making some test, and i've noted that at the same time i create another droplist that get the where value from the second one (that is connectes to thr database) the third droplist doesn't work.
so i really start to think that the problem is in the double database connection. In fact the second dropdown list, that gets the where value from a dropdown list that isn't connected to the database, works perfectly, instead the third one, that get the value from the second droplist (connected to the databse) , doesn't work. Could it be??? |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 28 May 2004 : 08:45:08
|
ok but in the evening
i've noted some other problems. I wanted to insert the items selected in the droplists in the message body (like the Injection mod), but it doesn't work now. With the Injection mod i modified also post_info.asp and it works, but using the dropdown list it doesn't work anymore. Why??
How could i paste the selection directly to the message body in the post.asp?? like the list bottom..... or the code one.....????
The code in post_info.asp at line 878 is
'#Inject Message text MOD - start
txtMessage = "Event : " & ChkString(Request.Form("Injection1"),"message") & vbNewline
txtMessage = txtMessage & ChkString(Request.Form("Message"),"message")
' txtMessage = ChkString(Request.Form("Message"),"message")
'#Inject Message text MOD - end
txtSubject = ChkString(Request.Form("Subject"),"SQLString") & vbNewLine
txtSubject1 = txtSubject & ChkString(Request.Form("Injection2"),"message") & vbNewLine
txtSubject2 = txtSubject1 & ChkString(Request.Form("Injection1"),"message") |
Edited by - s80ts0465 on 28 May 2004 11:08:27 |
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 30 May 2004 : 03:14:45
|
So i've finally found a working ftp space. the two files are:
http://s80ts0465.greatnow.com/snitz/post.asp
http://s80ts0465.greatnow.com/snitz/post_info.asp
In post.asp at line 585 there is the new code (faults mod) we're working on and at line 745 there is the normal injection mod.
In post_info.asp at line 878 there is the injection mod stings.
The code in post.asp create 3 dropdownlist:the first one gets the values from a normal dropdown list (without db connection);
the second dropdownlist is connected to the db and populates the list in base of the value selected in the first dropdown list. All this works, at least the values of the second dropdown are correct;
the third dropdown list (connected to the same db but to another table) gets the WHERE value from the selection of the second dropdown list, and it doesn't work !! the third list is empty.
The items selected should be save in the message body as the Injection mod does, but in this case it doesn't work.
Hope somebody can help me 
Thanks Stefano
|
|
|
|
s80ts0465
Junior Member
Italy
290 Posts |
Posted - 03 June 2004 : 08:38:08
|
Could the form be the reason that i cannot export the selction?? Becasuse the only diferent thing respect the injection mod is thta my code is within a form??
any suggest?? |
|
|
|
Topic |
|
Topic Locked
