Java scrip

D

Don Schmidt

Publisher 2000
Windows XP

The test site I'm attempting to make the drop down menu is:
http://www.pacifier.com/~dschmidt/osia_vancouver_usa/

Publisher MVP folks what am I doing wrong? Or better yet what do I do to
repair this Java script? The sites with LCID= don't come up.
Below script is the error message.

Thanks in advance.


--
Don
Vancouver, USA

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1/" >Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1/>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3/" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3/>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13/" >Mille
Cugini Lodge
#2659</option<ttp://www.osiaglnw.org/localunitsite.cfm?LCID=13/>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>





Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'LCId = 1/'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:60).


Date/Time: 10/28/05 18:58:01
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322)
Remote Address: 198.145.73.7
Query String: LCID=1/
 
D

DavidF

Hey Don,

I am not an MVP, but perhaps the following script would allow you to racket
it back to Defcon 1. Make your HTML box wider on your Pub page if you want
the label to the left of the drop down box, or change

<label>Websites of O.S.I.A.

to

<label>Websites of O.S.I.A.<p>

if you want the label above the drop down box, and insert the modified code:



<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1" >Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella Rosa
Portland #2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button
onclick="goToPage(document.dropdown.list.options(document.dropdown.list.sele
ctedIndex).value)">Go</button>
</form>



DavidF

Don Schmidt said:
Publisher 2000
Windows XP

The test site I'm attempting to make the drop down menu is:
http://www.pacifier.com/~dschmidt/osia_vancouver_usa/

Publisher MVP folks what am I doing wrong? Or better yet what do I do to
repair this Java script? The sites with LCID= don't come up.
Below script is the error message.

Thanks in advance.


--
Don
Vancouver, USA

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1/"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1/>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3/" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3/>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13/" >Mille
Cugini Lodge
#2659</option<ttp://www.osiaglnw.org/localunitsite.cfm?LCID=13/>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>





Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'LCId = 1/'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:60).


Date/Time: 10/28/05 18:58:01
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; ..NET
CLR 1.1.4322)
Remote Address: 198.145.73.7
Query String: LCID=1/
Click to expand...
 
D

DavidF

Hummm. Just to double check, I tested the code I just posted, and it doesn't
work after being wrapped in the message. When I copied your code and pasted
it into the Insert HTML code fragment box, I 'unwrapped' it so I could see
each option value on one line. I then removed the forward slash after each
address that used LCID, made a couple typo corrections, and copied and
posted the code. Some where along the line, I went back to defcon 5. If the
following 'wrapped' code doesn't work for you, then just make the changes I
described above.

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1" >Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>

DavidF

DavidF said:
Hey Don,

I am not an MVP, but perhaps the following script would allow you to racket
it back to Defcon 1. Make your HTML box wider on your Pub page if you want
the label to the left of the drop down box, or change

<label>Websites of O.S.I.A.

to

<label>Websites of O.S.I.A.<p>

if you want the label above the drop down box, and insert the modified code:



<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella Rosa
Portland #2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button
onclick="goToPage(document.dropdown.list.options(document.dropdown.list.sele
ctedIndex).value)">Go</button>
</form>



DavidF

Don Schmidt said:
Publisher 2000
Windows XP

The test site I'm attempting to make the drop down menu is:
http://www.pacifier.com/~dschmidt/osia_vancouver_usa/

Publisher MVP folks what am I doing wrong? Or better yet what do I do to
repair this Java script? The sites with LCID= don't come up.
Below script is the error message.

Thanks in advance.


--
Don
Vancouver, USA

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1/"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1/>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3/" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3/>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13/" Mille
Cugini Lodge
#2659</option<ttp://www.osiaglnw.org/localunitsite.cfm?LCID=13/>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>





Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'LCId = 1/'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:60).


Date/Time: 10/28/05 18:58:01
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322)
Remote Address: 198.145.73.7
Query String: LCID=1/
Click to expand...
Click to expand...
 
D

Don Schmidt

I just got back from a Grand Lodge Council meeting in Wenatchee WA. Your
script below was a welcome sight and works great. I thank you and 'hope I
can repay the help.

Don
Vancouver, WA


DavidF said:
Hummm. Just to double check, I tested the code I just posted, and it
doesn't
work after being wrapped in the message. When I copied your code and
pasted
it into the Insert HTML code fragment box, I 'unwrapped' it so I could see
each option value on one line. I then removed the forward slash after each
address that used LCID, made a couple typo corrections, and copied and
posted the code. Some where along the line, I went back to defcon 5. If
the
following 'wrapped' code doesn't work for you, then just make the changes
I
described above.

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
Beaverton
Click to expand...
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>

DavidF

DavidF said:
Hey Don,

I am not an MVP, but perhaps the following script would allow you to racket
it back to Defcon 1. Make your HTML box wider on your Pub page if you
want
the label to the left of the drop down box, or change

<label>Websites of O.S.I.A.

to

<label>Websites of O.S.I.A.<p>

if you want the label above the drop down box, and insert the modified code:



<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella Rosa
Portland #2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button
onclick="goToPage(document.dropdown.list.options(document.dropdown.list.sele
ctedIndex).value)">Go</button>
</form>



DavidF

Don Schmidt said:
Publisher 2000
Windows XP

The test site I'm attempting to make the drop down menu is:
http://www.pacifier.com/~dschmidt/osia_vancouver_usa/

Publisher MVP folks what am I doing wrong? Or better yet what do I do
to
repair this Java script? The sites with LCID= don't come up.
Below script is the error message.

Thanks in advance.


--
Don
Vancouver, USA

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1/"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1/>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3/"
Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3/>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo
Lodge
1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13/" Mille
Cugini Lodge
#2659</option<ttp://www.osiaglnw.org/localunitsite.cfm?LCID=13/>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>





Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'LCId = 1/'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:60).


Date/Time: 10/28/05 18:58:01
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322)
Remote Address: 198.145.73.7
Query String: LCID=1/
Click to expand...
Click to expand...
Click to expand...
 
D

DavidF

Glad it worked out and glad I retested the first effort...

DavidF

Don Schmidt said:
I just got back from a Grand Lodge Council meeting in Wenatchee WA. Your
script below was a welcome sight and works great. I thank you and 'hope I
can repay the help.

Don
Vancouver, WA


DavidF said:
Hummm. Just to double check, I tested the code I just posted, and it
doesn't
work after being wrapped in the message. When I copied your code and
pasted
it into the Insert HTML code fragment box, I 'unwrapped' it so I could see
each option value on one line. I then removed the forward slash after each
address that used LCID, made a couple typo corrections, and copied and
posted the code. Some where along the line, I went back to defcon 5. If
the
following 'wrapped' code doesn't work for you, then just make the changes
I
described above.

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
Beaverton
Click to expand...
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" >Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>

DavidF

DavidF said:
Hey Don,

I am not an MVP, but perhaps the following script would allow you to racket
it back to Defcon 1. Make your HTML box wider on your Pub page if you
want
the label to the left of the drop down box, or change

<label>Websites of O.S.I.A.

to

<label>Websites of O.S.I.A.<p>

if you want the label above the drop down box, and insert the modified code:



<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1"
Beaverton
Lodge #2645</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=1>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3" >Bella Rosa
Portland
Click to expand...
#2734 said:
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo Lodge
#1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13" Mille
Cugini Lodge
#2659</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=13>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button
Click to expand...
onclick="goToPage(document.dropdown.list.options(document.dropdown.list.sele
ctedIndex).value)">Go</button>
</form>



DavidF

Publisher 2000
Windows XP

The test site I'm attempting to make the drop down menu is:
http://www.pacifier.com/~dschmidt/osia_vancouver_usa/

Publisher MVP folks what am I doing wrong? Or better yet what do I do
to
repair this Java script? The sites with LCID= don't come up.
Below script is the error message.

Thanks in advance.


--
Don
Vancouver, USA

<script language="JavaScript">
function goToPage(url)
{
if (url != "")
{
window.open(url);
}
}
</script>

<form name="dropdown">
<label>Websites of O.S.I.A.
<select name="list" accesskey="W">
<option selected>Please select one</option>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=1/"
Beaverton
Lodge
Click to expand...
#2645 said:
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=3/"
Bella
Rosa Portland
#2734</option<http://www.osiaglnw.org/localunitsite.cfm?LCID=3/>
<option value="http://www.iinet.com/~k1294lodge/" >Camelia-Columbo
Lodge
1294</option<http://www.iinet.com/~k1294lodge//>
<option value="http://www.osiaglnw.org/localunitsite.cfm?LCID=13/"
Mille
Cugini Lodge
#2659</option<ttp://www.osiaglnw.org/localunitsite.cfm?LCID=13/>
<option value="http://www.vanusa.org/" >The Wine
Cellar</option<http://www.vanusa.org/>
</select>
<button onclick="goToPage(document.dropdown.list.options(
document.dropdown.list.selectedIndex).value)">Go</button>
</form>





Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression 'LCId = 1/'.



The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (2:1) to (2:60).


Date/Time: 10/28/05 18:58:01
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
.NET
CLR 1.1.4322)
Remote Address: 198.145.73.7
Query String: LCID=1/
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form / java question 7

Top