How to check if field exists in database using ASP

[melusi]

I have an access database.I want to add a info into a table only if it's not there.
I have this sample code which it's not lilanga = Request.Form("Days&quot
ummango = Request.Form("Comms&quot
lusuku = Request.Form("Tikhatsi&quot

set conn = Server.CreateObject("ADODB.Connection&quot
conn.Open "SKPE"
SQLIST="SELECT * FROM schedule"
set list=conn.execute(SQLIST)
Do While Not list.eof
If (<%=list(&quot;Day&quot%> = '&quot;& lilanga &&quot;') Then
response.write &quot;<b> A Similar Meeting has been scheduled <\b><\p>&quot;
list.movenext
Loop
Else
SQL=&quot;INSERT INTO schedule (Day,Officer,TaskToPerform,Department,ScheduledTime,DateofTask,Duration,Community) Values (&quot; &_
&quot;'&quot; & request.form(&quot;Days&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Officers&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Details&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Departments&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Tikhatsi&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Dates&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Durations&quot & &quot;', &quot; &_
&quot;'&quot; & request.form(&quot;Comms&quot & &quot;')&quot;
set cars=conn.execute(SQL)
End If

 

[Tarwn]

In case anyone sees this and starts to answer, ther is another similar post where I have already started answering, we might one to all use that one and keep the answers in one place.

-Tarwn ________________________________________________________________________________
Sometimes it is how you ask the question: faq333-2924
Many ASP questions have already been answered, please check faq333-3048 and use the search tool before posting