N
Nicholas
I put together a news clips database and am trying to
search a field called Headline. I have an ASP-generated
pulldown by month that works, but if I add a straight FP
search form it makes the pulldown return all of the
records. So, I'm trying to add a non-FP search form with
the following. It doesn't generate errors but it doesn't
return records either. The FP database results region
comes back "No records returned".
<FORM METHOD="POST" NAME="Form2"
ACTION="index2.asp#News">
<p><input TYPE="TEXT" NAME="Headline" VALUE="<%
=Request("Headline")%>" size="20"><input type="submit"
value="Submit" name="B1">
</p>
<%
IF Request.Form("Headline") = "" Then
Else
Set objDC2 = Server.CreateObject("ADODB.Connection")
objDC2.Open Application
("clipsentry_connectionstring")
Set objRS2 = objDC2.Execute("SELECT * FROM
Results WHERE (Headline LIKE '%::Headline::%') ORDER BY
Date ASC")
objRS2.Close
Set objRS2 = Nothing
objDC2.Close
Set objDC2 = Nothing
End IF
%>
</form>
I've also tried this query with the same results:
Set objRS2 = objDC2.Execute("Select * FROM Results WHERE
Headline LIKE '" & Request.Form("Headline") & "'")
What am I missing??? It is returning the records but not
putting them into the FP table?
The query in the FP stuff amkes the pulldown work...adding
an FP search form changes the query:
fp_sQry="SELECT * FROM Results WHERE (Month
= '::Month::') ORDER BY Date ASC"
search a field called Headline. I have an ASP-generated
pulldown by month that works, but if I add a straight FP
search form it makes the pulldown return all of the
records. So, I'm trying to add a non-FP search form with
the following. It doesn't generate errors but it doesn't
return records either. The FP database results region
comes back "No records returned".
<FORM METHOD="POST" NAME="Form2"
ACTION="index2.asp#News">
<p><input TYPE="TEXT" NAME="Headline" VALUE="<%
=Request("Headline")%>" size="20"><input type="submit"
value="Submit" name="B1">
</p>
<%
IF Request.Form("Headline") = "" Then
Else
Set objDC2 = Server.CreateObject("ADODB.Connection")
objDC2.Open Application
("clipsentry_connectionstring")
Set objRS2 = objDC2.Execute("SELECT * FROM
Results WHERE (Headline LIKE '%::Headline::%') ORDER BY
Date ASC")
objRS2.Close
Set objRS2 = Nothing
objDC2.Close
Set objDC2 = Nothing
End IF
%>
</form>
I've also tried this query with the same results:
Set objRS2 = objDC2.Execute("Select * FROM Results WHERE
Headline LIKE '" & Request.Form("Headline") & "'")
What am I missing??? It is returning the records but not
putting them into the FP table?
The query in the FP stuff amkes the pulldown work...adding
an FP search form changes the query:
fp_sQry="SELECT * FROM Results WHERE (Month
= '::Month::') ORDER BY Date ASC"