union query not displaying?

terryljsmith · Apr 20, 2007

i am using access 2003 with frontpage 2003, and i have set up the
following query

SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";

i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.

i am using one table for all data

film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....

film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |

my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".

i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.

here is the asp page code from frontpage.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>

<td>
<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>

</body>

</html>

and it reads greek to me.......

thanks,

terryl

Michel Walsh · Apr 20, 2007

Well, I don't really know why it does not work, note that your query has one
field, field with the name called actor1 (it got it from the first SELECT
statement), and it is NOT [film name]. Your front page may try to look for
[film name] but the query only find actor1, as valid field. Why not:

SEELCT [film name]
FROM [movies data]
WHERE (actor1 LIKE "a*) OR (actor2 LIKE "a*") OR ...

Hoping it may help,
Vanderghast, Access MVP

i am using access 2003 with frontpage 2003, and i have set up the
following query

SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";

i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.

i am using one table for all data

film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....

film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |

my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".

i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.

here is the asp page code from frontpage.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>

Click to expand...

<td>
<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>

</body>

</html>

and it reads greek to me.......

thanks,

terryl

Michel Walsh · Apr 20, 2007

Note that your table is not normalized; while it is good for presentation, a
somehow better approach would be to have a all vertical table:

FilmName Actor ' fields
"American Wedding", "Jason Biggs"
"American Wedding", "Seann William Scott"
"American Wedding", "Alyson Hannigan"
"American Wedding", "Eddie Kaye Thomas"
"American Wedding", "Thomas Ian Nicholas"
"American Wedding", "January Jones"
"American Wedding", "Eugene Levy"
"American Wedding", "Fred Willard"

.... data sample...

and then,

SELECT FilmName
FROM normalizedTable
WHERE Actor LIKE "A*"

would do. As for horizontal presentation, you may use a crosstab (after
having ranked the actors, by name or otherwise).

Hoping it may help,
Vanderghast, Access MVP

i am using access 2003 with frontpage 2003, and i have set up the
following query

SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";

i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.

i am using one table for all data

film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....

film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |

my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".

i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.

here is the asp page code from frontpage.

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>

Click to expand...

<td>
<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>

</body>

</html>

and it reads greek to me.......

thanks,

terryl

terryljsmith · Apr 20, 2007

Well, I don't really know why it does not work, note that your query has one
field, field with the name called actor1 (it got it from the first SELECT
statement), and it is NOT [film name]. Your front page may try to look for
[film name] but the query only find actor1, as valid field. Why not:

SEELCT [film name]
FROM [movies data]
WHERE (actor1 LIKE "a*) OR (actor2 LIKE "a*") OR ...

Hoping it may help,
Vanderghast, Access MVP

i am using access 2003 with frontpage 2003, and i have set up the
following query

Click to expand...

SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";

Click to expand...

i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -

Click to expand...

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

Click to expand...

i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.

Click to expand...

i am using one table for all data

Click to expand...

film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....

Click to expand...

film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |

Click to expand...

my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".

Click to expand...

i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.

Click to expand...

here is the asp page code from frontpage.

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

Click to expand...

<td>
<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>

</body>

Click to expand...

</html>

Click to expand...

and it reads greek to me.......

thanks,

Click to expand...

terryl

Click to expand...

thanks for your reply, but i'm trying to compile an aggregate column
list of the actors, which i can get with the union query, i just get
the error from frontpage when publishing.......

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

it's the error that i can't seem to get around....

terryl

Michel Walsh · Apr 20, 2007

Is your Access file saved in an OLD format? It should. It may be possible
that you saved it under a new format (Access 2003 format) that is
un-readable by your FrontPage version.

Vanderghast, Access MVP

Well, I don't really know why it does not work, note that your query has
one
field, field with the name called actor1 (it got it from the first SELECT
statement), and it is NOT [film name]. Your front page may try to look
for
[film name] but the query only find actor1, as valid field. Why not:

SEELCT [film name]
FROM [movies data]
WHERE (actor1 LIKE "a*) OR (actor2 LIKE "a*") OR ...

Hoping it may help,
Vanderghast, Access MVP

i am using access 2003 with frontpage 2003, and i have set up the
following query

Click to expand...

SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";

Click to expand...

i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -

Click to expand...

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

Click to expand...

i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.

Click to expand...

i am using one table for all data

Click to expand...

film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....

Click to expand...

film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |

Click to expand...

my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".

Click to expand...

i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.

Click to expand...

here is the asp page code from frontpage.

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>

</body>

Click to expand...

</html>

Click to expand...

and it reads greek to me.......

thanks,

Click to expand...

terryl

Click to expand...

Click to expand...

thanks for your reply, but i'm trying to compile an aggregate column
list of the actors, which i can get with the union query, i just get
the error from frontpage when publishing.......

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

it's the error that i can't seem to get around....

terryl

terryljsmith · Apr 20, 2007

Is your Access file saved in an OLD format? It should. It may be possible
that you saved it under a new format (Access 2003 format) that is
un-readable by your FrontPage version.

Vanderghast, Access MVP

Well, I don't really know why it does not work, note that your query has
one
field, field with the name called actor1 (it got it from the first SELECT
statement), and it is NOT [film name]. Your front page may try to look
for
[film name] but the query only find actor1, as valid field. Why not:
SEELCT [film name]
FROM [movies data]
WHERE (actor1 LIKE "a*) OR (actor2 LIKE "a*") OR ...
Hoping it may help,
Vanderghast, Access MVP

i am using access 2003 with frontpage 2003, and i have set up the
following query
SELECT [movies data].actor1
FROM [movies data]
WHERE [movies data].actor1 Like "a*";
UNION SELECT [movies data].actor2
FROM [movies data]
WHERE [movies data].actor2 Like "a*";
UNION SELECT [movies data].actor3
FROM [movies data]
WHERE [movies data].actor3 Like "a*";
UNION SELECT [movies data].actor4
FROM [movies data]
WHERE [movies data].actor4 Like "a*";
UNION SELECT [movies data].actor5
FROM [movies data]
WHERE [movies data].actor5 Like "a*";
i can view this query in access, but when i use the data results
wizard in frontpage i get the following error -
Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
i have checked, and double-checked the syntax, and i am completely
lost at this point. any, and all assistance would be appreciated.
i am using one table for all data
film name | actor1 | actor2 | actor3 | actor4 | actor 5 | and so
on.....
film 1 | tom | bob | susan | nick | steve |
film 2 | dick | tim | cathy | tom | paul |
my union query is to search for all actors by alpha, so you can link
to the film names which are associated with them. for example, i
would query "t" and get "tom", and then my results for "tom" would be
a listing of "films 1 & 2".
i use several other tables which have one item and several categories
associated with them, and i would like to be able to union these
categories as they related to the primary items. the query works fine
in access, but i will not show up when published in an asp page within
frontpage. i get the aformentioned error when processing the query.
and i have no idea why. all standard queries work within frontpage,
it seems that "union" queries do not, and that is my quandry.
here is the asp page code from frontpage.
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component.
Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>actorsa</title>
</head>
<body>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>actor1</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The
Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web
must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Copy of movies actor a"""
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="mov&ment"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&actor1=202&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<
%=FP_FieldVal(fp_rs,"actor1")%></td>
</tr>

</
tbody>
</table>
<form BOTID="1" METHOD="POST" action="actorsa.asp">
<input type="hidden" name="fpdbr_1_PagingMove" value=" |<
">
</form>
</body>
</html>
and it reads greek to me.......
thanks,
terryl

Click to expand...

Click to expand...

thanks for your reply, but i'm trying to compile an aggregate column
list of the actors, which i can get with the union query, i just get
the error from frontpage when publishing.......

Click to expand...

Database Results Wizard Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

Click to expand...

it's the error that i can't seem to get around....

Click to expand...

terryl

Click to expand...

the access 2003 is in the access 2000 format, and frontpage is
2003..... thanks for your help, i was hoping to not have to set up
the table as you suggested, but all indicators say that i just may
have to.....

terry

I am trying to understand this code...	3	Jul 26, 2008
@ my wits end	1	Sep 12, 2006
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
Database Results Error	1	Sep 9, 2004
Database Update Buttons	8	May 25, 2005
DataBase results Error continued	1	Sep 10, 2004
Problem with form validation	1	Jul 19, 2004

union query not displaying?

terryljsmith

Michel Walsh

Michel Walsh

terryljsmith

Michel Walsh

terryljsmith

Ask a Question

Similar Threads