Printable View
Hi,
I have created a web site connected to a database table... I have used the following script to connect two drop down menus but it doesnt work...i get an error at line :
eval('var option0 = new Option("- Please Choose -", "None")');
i am using procedure builder and i get a pls-00103 error. Encountered the symbol '"var"' when expected ....
could somebody understand why???
the attached file contains the code...
thnx!!
Hi,
all the javascript code is inside a PL/SQL string eclosed by apostrophes. If you want to use an apostroph inside the string, you have to double it:
eval(''var option0 = new Option("- Please Choose -", "None")'');
well thnx, i did that and now i have no errors...it doesn t work though...do you think u could check it please???? I am really new to this and i cant find the mistake myself...:(
thnx again
No errors?
I got "PLS-00201: identifier 'F_HOST' must be declared". I changed F_HOST to a string and then it compiled. Then I created the table war_membr, inserted "111" into column mem_type. After that I got a form and I attach the screenshot.
What do you mean by "doesn't work" ?
well, first of all this is the procedure as currently used (attached)...
I have declared the host identifier in my package body thats why i dont get any errors like that. the thing is that i get a runtime error when i choose a category. my web site is: http://tiger.iso.port.ac.uk:7778/pls....memorial.home
u have to click on "find a memorial" to see it.
In addition, i m thinking that in my table the mem_type are written with spaces (ex. Stained Glass Window instead of Stained_Glass_Window as it appears in the javascript). But even when i tried the code only with the commented part (as u can see in the file) still it didnt work...hope this makes sense...
thnx
There was syntax error - right parenthesis missing:You could use replace to get proper array names:Code:eval("var option" + [L + 1] + " = new Option(" + ''"'' + NewSource[L] + ''", "'' + NewSource[L] + ''")'');
Code:htp.print('<option value="'||replace(sel_t.mem_type,' ','_')||'">'||sel_t.mem_type||'</option>');
Try this out..
you might get expected results for plague and statue..but not for the rest...as the rest have array names as Stained_Glass_WindowArray,Foundation_StoneArray etc...with "UNDERSCORES" replacing "BLANK SPACES"..
well, i did what u told me and it almost works...! could you check it out once more please?? i get a new runtime error about the browser type (says it is undefined)
thnx again for your valuable help!!!
in addition, even if i put another option at the second drop down menu, and select that, the action does not work...(but if i don t use the first drop down at all it works fine!!) does it need to be handled in a different way when the first drop down is used as well or is it the runtime error that produces the problem...??
thnx
This is javascript related issue and I don't use javascript at all. I'm sorry.
If you want to debug a web page with javascript, save the page as .html file, modify the file and open it in the browser. After every change in the .html file just refresh the browser to see result.
It doesn't look like you've defined the variable browser_type anywhere. I'm not sure but I think you need to use javascript to fetch the browser type and version into that variable before testing it in the IF statement. Maybe something like this will do the trick.
var browser_type=navigator.appName
well the script works when the page is opened from other pcs...., but the Action still does not work...do u happen to know why??? as i said before of the first drop down is ommited and an option value is manually added at the second drop down the Action passes the parameter to the "search" procedure and the appropriate images are displayed.:/
Thnx a lot Pete, that worked!!