Webform won't work with sequel query

**dhabi** · 08-08-2004, 11:21 AM

Our problem relates to the table syntax questions we had. We now have the pedigree forms working but cannot get the pedigree form to return data. Is this an ASP.NET/Dreamweaver issue? If so, how do we solve it?

The sequel query works, the webform does not. It does not generate errors, just fails to return data. The test works, the form does not return data. My partner says she doesn't even know how to explain what the error is ! !

We work in MS SQL only and are using Dreamweaver. I can log in to the members area but all that comes up is Welcome Member -- nothing else.

PLEASE, ALL IDEAS/SUGGESTIONS WELCOMED.

**dhabi** · 08-24-2004, 09:37 PM

Question 1:

Why would there be no error message when trying to connect the query (which works in itself) to the dreamweaver program?

**Rawhide** · 09-10-2004, 12:14 PM

Are you running an ad hoc query from your code or executing a stored procedure?

Can you post the query or procedure and the ASP code you use to execute it?

There probably isn't an error, just a problem with the way you are executing it.

**dhabi** · 09-11-2004, 07:35 AM

Rawhide -- the query works in sequel; won't work on the webpage. Here is the whole page:

<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,culture=neutral" %>
<MM

ataSet
id="dsPedigree"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSett ings["MM_CONNECTION_STRING_ArabianData"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSett ings["MM_CONNECTION_DATABASETYPE_ArabianData"] %>'
CommandText='<%# "SELECT Horses.HorseID, Horses.regConcatNumber, Horses.regHorseName FROM Horses INNER JOIN Horses AS Horses_1 ON Horses.SireNumber = Horses_1.regConcatNumber WHERE ((Horses.regConcatNumber) = @regConcatNumber)" %>'
Debug="true"
><Parameters>
<Parameter Name="@regConcatNumber" Value='<%# ((Request.QueryString["regConcatNumber"] != null) && (Request.QueryString["regConcatNumber"].Length > 0)) ? Request.QueryString["regConcatNumber"] : "" %>' Type="BigInt" /></Parameters></MM

ataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Pedigree</title>
</head>
<body>
<table width="650" border="0" align="center" cellpadding="1" cellspacing="4">
<tr>
<td><div align="center"><img src="../Images/titlett.gif" width="492" height="121" /></div></td>
</tr>
<tr>
<td valign="top"><p> </p>
<p> </p>
<p></p>
<form name="pedigree" id="pedigree" method="get" action="">
<p> </p>
<table width="744" border="1" cellspacing="4" cellpadding="1">
<tr>
<td width="186"> </td>
<td width="173"> </td>
<td width="106"> </td>
<td width="113"> </td>
<td width="120"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><%# dsPedigree.FieldValue("regHorseName", Container) %></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</form>
<p> </p>
<p> </p></td>
</tr>
</table>

</body>
</html>

I received an email that Rawhide had answered but can't find it. I really would love to have their answer dhabi@thuntek.net if this is okay to add my email addy

Thread: Webform won't work with sequel query

Thread Tools

Display

Webform won't work with sequel query

Posting Permissions