Hi there i'm looking for an extension or a solution to the following topic that has allready been covered:

<b>Check if two field entries in one record exists</b>

What I am looking for is very simple - a server behaviour similar to the "Check if username exists" server behaviour. However, I would like to check for the existance of two field entries in a particular record and not only one - for example I would like to check for the existance of the person's username as well as the title of a particular article he would like to save to his list of favourites. Should this particular article allready have been saved to his list of favourites, I would like to redirect him to a page that will inform him that the article allready exists in his list of saved articles.

Any help would be brilliant, as its a bit over my head this one

Kindest Regards
Dom

I think you can create a validation page lets call it val_favarite.asp
post your form to val_favarite.asp

in val_favarite.asp, create an query to see it has records (query should be like this: select * from your_table where your_condition)
then if there is record, then redirect to the page, if not redirect to other page.
by the way, you need to let us know more detial to help you such as table names will be helpful.



John Lee

i think this is what u want :
<pre id=code><font face=courier size=2 id=code> &lt;%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%&gt;
&lt;!--#include file="file:mycheekylittlewebsite.asp" --&gt;
&lt;%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Session("MM_username" &lt;&gt; "" Then
Recordset1__MMColParam = Session("MM_username"
End If
%&gt;
&lt;%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_encams_STRING
Recordset1.Source = "SELECT * FROM dbo.tblusers WHERE strusername = '" + Replace(Recordset1__MMColParam, "'", "''" + " AND strfavourite &lt;&gt; '''"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%&gt;
&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "www.w3.org/TR/html4/loose.dtd"&gt;
&lt;html&gt;
&lt;head&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;title&gt;Untitled Document&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;% If Not Recordset1.EOF Or Not Recordset1.BOF Then %&gt;
&lt;p&gt;they have a favourite&lt;/p&gt;
&lt;% End If ' end Not Recordset1.EOF Or NOT Recordset1.BOF %&gt;
&lt;% If Recordset1.EOF And Recordset1.BOF Then %&gt;
&lt;p&gt;they dont &lt;/p&gt;
&lt;% End If ' end Recordset1.EOF And Recordset1.BOF %&gt;

&lt;/body&gt;
&lt;/html&gt;
&lt;%
Recordset1.Close()
Set Recordset1 = Nothing
%&gt;
</font id=code></pre id=code>