Frontpage database query paramater help please

CharlesKiel · May 23, 2005

I'm using Frontpage 2003 and asp pages to try and view database
results. I'm having a problem either with the query I"m using or
getting the page to take the Paramater to insert into the query.
Can someone tell me why this query would work:

SELECT VIDEOS.* FROM VIDEOS, SHOWS WHERE SHOWS.VOLUME = 1 and
SHOWS.VIDEO = VIDEOS.ID

I can change the shows.volume value to anything I want in the query,
but when I try this;

SELECT VIDEOS.* FROM VIDEOS, SHOWS WHERE SHOWS.VOLUME = ::vol:: and
SHOWS.VIDEO = VIDEOS.ID

and use this url "site.com/page.asp?vol=1" if gives me the following.

----------

Database Results Wizard Error
Your page contains a query with user input parameters that could not be
resolved.
This could happen if your DatabaseRegionStart webbot has an empty or
missing s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

One or more form fields were empty. You should provide default values
for all form fields that are used in the query.

----------

That article it refers to give me similar results after I've followed
it's instructions. I'm using a simiar query elsewhere on the site:

SELECT * FROM Artists where ID = ::id::

on a url: site.com/artist?id=1

and it gives me no problems. Any idea?

Stefan B Rusynko · May 23, 2005

Before the Select you need to parse the parameter being passed

vol = Replace(Request.QueryString("vol"), "'", "''")

| I'm using Frontpage 2003 and asp pages to try and view database
| results. I'm having a problem either with the query I"m using or
| getting the page to take the Paramater to insert into the query.
| Can someone tell me why this query would work:
|
| SELECT VIDEOS.* FROM VIDEOS, SHOWS WHERE SHOWS.VOLUME = 1 and
| SHOWS.VIDEO = VIDEOS.ID
|
|
|
|
| I can change the shows.volume value to anything I want in the query,
| but when I try this;
|
| SELECT VIDEOS.* FROM VIDEOS, SHOWS WHERE SHOWS.VOLUME = ::vol:: and
| SHOWS.VIDEO = VIDEOS.ID
|
| and use this url "site.com/page.asp?vol=1" if gives me the following.
|
| ----------
|
| Database Results Wizard Error
| Your page contains a query with user input parameters that could not be
| resolved.
| This could happen if your DatabaseRegionStart webbot has an empty or
| missing s-columnnames or s-columntypes attributes.
| You may need to read Microsoft Knowledge Base Article 817029.
|
| One or more form fields were empty. You should provide default values
| for all form fields that are used in the query.
|
| ----------
|
| That article it refers to give me similar results after I've followed
| it's instructions. I'm using a simiar query elsewhere on the site:
|
| SELECT * FROM Artists where ID = ::id::
|
| on a url: site.com/artist?id=1
|
| and it gives me no problems. Any idea?
|

CharlesKiel · May 23, 2005

Where do I put that? At The Beginning of my custom query? In the asp
code somewhere? I'm kinda clueless with some of this stuff.

Stefan B Rusynko · May 24, 2005

Not a part of your SQL
It is a separate ASP (VBscript) code line that must be before the Select statement line
- since you are using the DBRW enter it at the top of youe page (outside of any DBRW code) as

<% vol = Replace(Request.QueryString("vol"), "'", "''") %>

| Where do I put that? At The Beginning of my custom query? In the asp
| code somewhere? I'm kinda clueless with some of this stuff.
|

CharlesKiel · May 25, 2005

ok. Thanks for your help but I still have the same problem. Here is
my page code:

<html>
<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Artist</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 Videos.Artist FROM Videos, shows WHERE shows.Volume =
::vol:: and shows.video = Videos.id"
fp_sDefault="vol="
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No
records returned.</td></tr>"
fp_sDataConn="360"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Artist"
fp_sMenuValue="Artist"
fp_sColTypes="&Artist=202&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

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

</tbody>
</table>

</body>
</html>

Also I can't figure out why it works on another page and not this one.
My query is more complicated on this page. But I'm not sure that it
could be the problem, cause if I stick the actual value in the query
instead of the parameter, it gives me exactly what I want. also i
didn't need to parse the parameter being passed there either.

Stefan B Rusynko · May 25, 2005

CharlesKiel · May 25, 2005

I fixed it. It's Frontpage 2003. I uploaded the _fpclass folder from
Frontpage 2000 to my sites directory and it works like a charm. no
screwing with the code or anything.

problem with a DISTINCT query	4	Feb 18, 2008
Error Adding Record with INSERT INTO	4	May 21, 2008
Database Update Issues	2	Sep 15, 2006
Database Results Wizard Error	3	Feb 24, 2005
Frontpage Database Error	1	Apr 5, 2004
Database Results Error	1	Oct 16, 2004
What is wrong with this	2	Mar 2, 2005
Frontpage 2003 Database Results - Insert parameter - How ?	4	May 22, 2005

Frontpage database query paramater help please

CharlesKiel

Stefan B Rusynko

CharlesKiel

Stefan B Rusynko

CharlesKiel

Stefan B Rusynko

CharlesKiel

Ask a Question

Similar Threads