473,668 Members | 2,318 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Why won't this for-each loop work?

I have a xslt file and it keeps giving me an EOF error when it reaches
the point
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware[lc:Genre =
$Genre]">
and
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware">

My xslt file looks like this
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:lc="http://mark/Homepage/">
<xsl:output method="html"/>
<xsl:param name="Hardware"/>
<xsl:param name="Genre"/>

<xsl:template match="/">
<xsl:choose>
<xsl:when test="$Genre = 'All'">
<xsl:call-template name="All" />
</xsl:when>
<xsl:otherwis e>
<xsl:call-template name="NotAll" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="All">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware[lc:Genre =
$Genre]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

</xsl:stylesheet>

My xml file looks like this
<Entertainmen t xmlns="http://mark/Homepage/">
<Movie>
<Title>Terminat or 1</Title>
<Description> A T100 machine comes back from the future to destroy
Sarah Connor who will give birth to a kid who will go on to save the
world.</Description>
<Genre>Action </Genre>
<Picture>images \movies\Termina tor1.jpg</Picture>
<Rating>5</Rating>
</Movie>
<Movie>
<Title>Terminat or 2</Title>
<Description>Th e T100 is back again only this time he is back to
save John Connor from a T1000</Description>
<Genre>Action </Genre>
<Picture>images \movies\Termina tor2.jpg</Picture>
<Rating>5</Rating>
</Movie>
<PS2>
<Title>Mortal Kombat Deadly Alliance</Title>
<Description>Qu an Chi and Shang Tsung join forces to destroy Lui
Kang and take over the wrold</Description>
<Genre>Fighting </Genre>
<Picture>images \ps2\MortalKomb at.jpg</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Sly Cooper</Title>
<Description> A racoon must travel around the world to get back
pieces of a book that has been in his family for
generations</Description>
<Genre>Platform er</Genre>
<Picture>images \ps2\SlyCooper</Picture>
<Rating>5</Rating>
</PS2>
</Entertainment>

I am passing my variable through a piece of Javascript code that looks
like this
xsltProc.addPar ameter("Hardwar e", Hardware);
xsltProc.addPar ameter("Genre", SelValue);
Jul 20 '05 #1
8 1981

"Mark Constant" <co*******@mi x-net.net> wrote in message
news:ce******** *************** **@posting.goog le.com...
I have a xslt file and it keeps giving me an EOF error when it reaches
the point
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware[lc:Genre =
$Genre]">
and
<xsl:for-each select="lc:Ente rtainment/lc:$Hardware">


This is not legal.

lc:$Hardware is not a QName.

Probably you wanted:

lc:*[local-name() = $Hardware]

or (,which is the same):

*[name() = concat('lc:', $Hardware)]

=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

Jul 20 '05 #2
I am still getting an error saying that Hardware is undefined. All I
want is a drop down list. If the user is on the PS2 page it will send
the parameter PS2 for Hardware and then whatever Genre they selected.
Here is what I changed my XSLT code to
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:lc="http://mark/Homepage/">
<xsl:output method="html"/>
<xsl:param name="Hardware"/>
<xsl:param name="Genre"/>

<xsl:template match="/">
<xsl:choose>
<xsl:when test="$Genre = 'All'">
<xsl:call-template name="All" />
</xsl:when>
<xsl:otherwis e>
<xsl:call-template name="NotAll" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="All">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

My Javascript code looks like this
function CallXML(dropdow n, hardware)
{
var myIndex = dropdown.select edIndex;
var SelValue = dropdown.option s[myIndex].value;
var xsltTree = new ActiveXObject(" Msxml2.FreeThre adedDOMDocument .4.0");
xsltTree.async = false;
xsltTree.load(" Entertainment.x slt")

var srcTree = new ActiveXObject(" Msxml2.DOMDocum ent.4.0");
srcTree.async = false;
srcTree.load("E ntertainment.xm l");

var xsltThread = new ActiveXObject(" Msxml2.XSLTempl ate.4.0");
xsltThread.styl esheet = xsltTree;
var xsltProc = xsltThread.crea teProcessor();
xsltProc.input = srcTree;
xsltProc.addPar ameter("Hardwar e", Hardware);
xsltProc.addPar ameter("Genre", SelValue);
xsltProc.transf orm();
GameTable.inner HTML = xsltProc.output ;
}
Jul 20 '05 #3

"Mark Constant" <co*******@mi x-net.net> wrote in message
news:ce******** *************** ***@posting.goo gle.com...
I am still getting an error saying that Hardware is undefined.
This is not a Javascript group. The error is in your script -- see below.
All I
want is a drop down list. If the user is on the PS2 page it will send
the parameter PS2 for Hardware and then whatever Genre they selected.
Here is what I changed my XSLT code to
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:lc="http://mark/Homepage/">
<xsl:output method="html"/>
<xsl:param name="Hardware"/>
<xsl:param name="Genre"/>

<xsl:template match="/">
<xsl:choose>
<xsl:when test="$Genre = 'All'">
<xsl:call-template name="All" />
</xsl:when>
<xsl:otherwis e>
<xsl:call-template name="NotAll" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="All">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

My Javascript code looks like this
function CallXML(dropdow n, hardware)
{
var myIndex = dropdown.select edIndex;
var SelValue = dropdown.option s[myIndex].value;
var xsltTree = new ActiveXObject(" Msxml2.FreeThre adedDOMDocument .4.0");
xsltTree.async = false;
xsltTree.load(" Entertainment.x slt")

var srcTree = new ActiveXObject(" Msxml2.DOMDocum ent.4.0");
srcTree.async = false;
srcTree.load("E ntertainment.xm l");

var xsltThread = new ActiveXObject(" Msxml2.XSLTempl ate.4.0");
xsltThread.styl esheet = xsltTree;
var xsltProc = xsltThread.crea teProcessor();
xsltProc.input = srcTree;
xsltProc.addPar ameter("Hardwar e", Hardware);
You don't have a variable named "Hardware" defined in your Javascript code.
The line above will raise an error due to this.
xsltProc.addPar ameter("Genre", SelValue);
xsltProc.transf orm();
GameTable.inner HTML = xsltProc.output ;
}

Jul 20 '05 #4
I fixed the Javascript error easy enough once I noticed my mistake.
Now I get an error that seems to be a FAQ that reads "Reference to
variable or parameter 'Hardware' must evaluate to a node set list. Now
from what I have been reading I have to add a function called
node-set() but where I need to add it is what I can't figure out. Here
is my XSLT code.
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:lc="http://mark/Homepage/">
<xsl:output method="html"/>
<xsl:param name="Hardware"/>
<xsl:param name="Genre"/>

<xsl:template match="/">
<xsl:choose>
<xsl:when test="$Genre = 'All'">
<xsl:call-template name="All" />
</xsl:when>
<xsl:otherwis e>
<xsl:call-template name="NotAll" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="All">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
Jul 20 '05 #5
"Mark Constant" <co*******@mi x-net.net> wrote in message news:ce******** *************** ***@posting.goo gle.com...
I fixed the Javascript error easy enough once I noticed my mistake.
Now I get an error that seems to be a FAQ that reads "Reference to
variable or parameter 'Hardware' must evaluate to a node set list. Now
from what I have been reading I have to add a function called
node-set() but where I need to add it is what I can't figure out. Here
is my XSLT code.

using the xxx:node-set() extension function won't help.

From your code it can be seen that in different places you're using
the value of the "Hardware" parameter both as a simple value (string)
and as a node-set.

Most probably you're passing a string as the value of the "Hardware"
parameter.

However in the "NotAll" template you're using it as a node-set:
<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
BTW the above hardly makes sense to me. What did you really want?
Please, say it with words.

Probably your problem is here and you have to correct it.

Anyway, should you continue to use the same parameter supposing it has
two different types at the same time, the solution is to use two
different parameters -- one string and one node-set.
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL



<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:styleshe et version="1.0"
xmlns:xsl="http ://www.w3.org/1999/XSL/Transform"
xmlns:lc="http://mark/Homepage/">
<xsl:output method="html"/>
<xsl:param name="Hardware"/>
<xsl:param name="Genre"/>

<xsl:template match="/">
<xsl:choose>
<xsl:when test="$Genre = 'All'">
<xsl:call-template name="All" />
</xsl:when>
<xsl:otherwis e>
<xsl:call-template name="NotAll" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="All">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

Jul 20 '05 #6
I can see now that the problem lies within the NotAll template. It
will take a little while to explain in words but here I go. I have an
xml file that supports three types of hardware PS2, XBOX, and Movie.
Now if the user is on the PS2 and selects that they want the genre
horror it will send two parameters. One being the Hardware (i.e. PS2)
and then the Genre which is horror. From there the template calls
NotAll and says for every instance of PS2 in the XML that has a Genre
of horror then display it. Here is my Xslt again.
<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">
<tr>
<th colspan="2" bgcolor="Green" ><xsl:value-of
select="lc:Titl e"/></th>
</tr>
<tr>
<td>
<xsl:element name="IMG">
<xsl:attribut e name="SRC">
<xsl:value-of select="lc:Pict ure"/>
</xsl:attribute>
</xsl:element>
</td>
<td>
<xsl:value-of select="lc:Desc ription"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>

It is obvious that I need to change <xsl:for-each
select="lc:Ente rtainment/lc:*[local-name() = $Hardware[lc:Genre =
$Genre]]"> but what I need to change it to is what I am wondering.
Basically I want this line to say whatever Hardware the user pass
display the xml content only if the genre is horror. Here is an
example of my xml file.

<Entertainmen t xmlns="http://mark/Homepage/">
<PS2>
<Title>Grand Theft Auto 3</Title>
<Description> An open ended enviroment where you have to take on jobs
for different mob bosses to stay alive</Description>
<Genre>TPA</Genre>
<Picture>images \ps2\GrandTheft Auto3.gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Maximo </Title>
<Description>Af ter returning from a war you find out that you must
save the love of your life from your one time friend turned
nemesis</Description>
<Genre>Platform er</Genre>
<Picture>images \ps2\Maximo.gif </Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Mortal Kombat Deadly Alliance</Title>
<Description>Qu an Chi and Shang Tsung join forces to destroy Lui
Kang and take over the world</Description>
<Genre>Fighting </Genre>
<Picture>images \ps2\MortalKomb at.gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Ratche t and Clank</Title>
<Description> In this action platformer you must play as a Cat and
Robot team that must work together to save the world from the evil
Chairman Drek</Description>
<Genre>Platform er</Genre>
<Picture>images \ps2\RatchetAnd Clank.gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Silent Hill 2</Title>
<Description>Af ter recieving a letter from a wife who you thought
was dead you travel to a huanted town to find out the
truth</Description>
<Genre>Horror </Genre>
<Picture>images \ps2\SilentHill 2.gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Sly Cooper</Title>
<Description> A racoon must travel around the world to get back
pieces of a book that has been in his family for
generations</Description>
<Genre>Platform er</Genre>
<Picture>images \ps2\SlyCooper. gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>The Getaway</Title>
<Description>Yo u play as Mark Hammond who is taken back into the mob
life to save the life of his own child</Description>
<Genre>Platform er</Genre>
<Picture>images \ps2\TheGetaway .gif</Picture>
<Rating>5</Rating>
</PS2>
<PS2>
<Title>Tribes : Ariel Assualt</Title>
<Description>Th is game is a port of a old PC game where you can fly
using jetpacks but also use vehicles</Description>
<Genre>FPS</Genre>
<Picture>images \ps2\Tribes.gif </Picture>
<Rating>3</Rating>
</PS2>
<PS2>
<Title>Virtua Fighter 4: Evolution</Title>
<Description>Tr avel around the world to fight A.I. that is
programmed after the best Virtua Fighter arcade players</Description>
<Genre>Fighting </Genre>
<Picture>images \ps2\NoGif.gif</Picture>
<Rating>5</Rating>
</PS2>
</Entertainment>
Jul 20 '05 #7

"Mark Constant" <co*******@mi x-net.net> wrote in message
news:ce******** *************** **@posting.goog le.com...
I can see now that the problem lies within the NotAll template. It
will take a little while to explain in words but here I go. I have an
xml file that supports three types of hardware PS2, XBOX, and Movie.
Now if the user is on the PS2 and selects that they want the genre
horror it will send two parameters. One being the Hardware (i.e. PS2)
and then the Genre which is horror. From there the template calls
NotAll and says for every instance of PS2 in the XML that has a Genre
of horror then display it. Here is my Xslt again.
<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">


You didn't understand the pattern -- one cannot use a string as a node-set.

Also the above doesnt make sense -- if $Hardware were a node-set it would
mean:

Select all children of lc:Entertainmen t that are in the namespace to which
the prefix "lc" is bound and that have local-name the same as the *value* of
the (first node of) the node=set of all nodes belonging to $Hardware, which
have an lc:Genre child with value $Genre

As in the previous template, once again, you have to write:

<xsl:for-each
select="lc:Ente rtainment/lc:*[local-name() = $Hardware][lc:Genre =
$Genre]]">

I think that using the XPath Visualizer may be very helpful in such cases as
it has been proven in practice to be an effective XPath learning tool.
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL

Jul 20 '05 #8
"Dimitre Novatchev" <dn********@yah oo.com> wrote in message news:<br******* ****@ID-152440.news.uni-berlin.de>...
"Mark Constant" <co*******@mi x-net.net> wrote in message
news:ce******** *************** **@posting.goog le.com...
I can see now that the problem lies within the NotAll template. It
will take a little while to explain in words but here I go. I have an
xml file that supports three types of hardware PS2, XBOX, and Movie.
Now if the user is on the PS2 and selects that they want the genre
horror it will send two parameters. One being the Hardware (i.e. PS2)
and then the Genre which is horror. From there the template calls
NotAll and says for every instance of PS2 in the XML that has a Genre
of horror then display it. Here is my Xslt again.
<xsl:template name="NotAll">
<table border="0">
<xsl:for-each select="lc:Ente rtainment/lc:*[local-name() =
$Hardware[lc:Genre = $Genre]]">


You didn't understand the pattern -- one cannot use a string as a node-set.

Also the above doesnt make sense -- if $Hardware were a node-set it would
mean:

Select all children of lc:Entertainmen t that are in the namespace to which
the prefix "lc" is bound and that have local-name the same as the *value* of
the (first node of) the node=set of all nodes belonging to $Hardware, which
have an lc:Genre child with value $Genre

As in the previous template, once again, you have to write:

<xsl:for-each
select="lc:Ente rtainment/lc:*[local-name() = $Hardware][lc:Genre =
$Genre]]">

I think that using the XPath Visualizer may be very helpful in such cases as
it has been proven in practice to be an effective XPath learning tool.
=====
Cheers,

Dimitre Novatchev.
http://fxsl.sourceforge.net/ -- the home of FXSL


Dang your good at this stuff. Thanks once again. That worked perfectly.
Jul 20 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2246
by: Scott Nichols | last post by:
Hi, I'm trying to debuf an aspnet app. When I invoke the debugger I can place a break point in any file except one. This file always gives by the circle with the question mark in it. Also the assembly doesn't take any of the changes I make in this file. So I now the file is not part of the compiled assembly and that's why I have this problem. But Why is it not part of the assembly?
4
2592
by: EoRaptor013 | last post by:
I have been successful at setting up three or four DTS packages to run using the DTSrun command line utility and the Windows scheduler until now. The latest package gives me the following error no matter what I try. Error: -2147217355 (80041035); Provider Error: 0 (0) Error string: General error -2147217355 (80041035). Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 705
5
7247
by: Julia Baresch | last post by:
Hi everyone, I haven't found any reference to this problem on this group or in Access 97 help. I hope someone here knows this - probably a simple thing, but not obvious. I designed a query to pull payment data from my database for accounting. It has 3 tables with one-to-many joins: Table1 --> one-to-many --> Table2 --> one-to-many --> Table3 The payment amount field is in Table3. I entered a few negative
1
2714
by: oraustin | last post by:
My application was set to open the Switchboard as the default startup form. It worked fine up until recently. Now it won't "remember" that the default form should be the Switchboard and the field under Tools > Startup is blank and won't retain a value. Have Access 97 on W2K Thanks in advance
3
2144
by: Footsie | last post by:
Hay guys, When I create a switchboard, everything works fine until the last step: the main (default) switchboard page won't show up. I've double-checked the macros and the individual pages (under Tools-Database utilities-Switchboard Manager) and everything else is fine. What might the problem be, and how can I fix it?
1
1433
by: Regardt | last post by:
Microsoft windows .Net 2003 I have a mayor problem! My property window won't open. I tried using the dynamic help to open the property window, but with out success. (The dynamic help window won't even display). Both windows display while debugging is process. Is there a patch to this problem?
1
1280
by: Regardt | last post by:
Microsoft windows .Net 2003 I have a mayor problem! My property window won't open. I tried using to dynamic help to open the property window, but with out success. (The dynamic help window won't even display). Both windows display while debugging is process. Is there a patch to this problem?
4
1447
by: Dot net work | last post by:
If I have got 2 web user controls on my aspx form, and one web user control has got some validator controls on it, what I find is that if I enter in some "bad data" in to some text boxes on the first web user control, then click on a link button on the second web user control to leave the aspx form, it won't let me - the validators run on the first web user control and highlight the errors and won't let me leave until I fix them. I'm...
2
3883
by: Sam Miller | last post by:
Hi, I have a button event that won't fire. I left it on Friday and it worked fine. I came back in on Monday and it won't fire. I tried putting another button and just putting a response.write on its click handler but it won't fire either telling me no button click events will fire. But my calendar control on the same page does fire. In the debugger I put a break point in the calendar event and the button
0
1120
by: Vonnie | last post by:
I have a DetailsView and the text in a text box won't wrap in the edit mode. I have the item style and editrowstyle set to wrap, but if the data is too long it still won't wrap in a text field . the field is SQL bound and an ntext datatype any help appreciated
1
8575
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8653
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7398
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6206
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5677
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4373
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2784
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2018
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1783
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.