Help with set RS = myconn.execute code

[gregomva]

Okay folks I need your help:

 

This is what I have right now in my code:

 

set RS = MyConn.Execute("SELECT * FROM signaturecardtbl WHERE " & fielder & " like '" & name & "%'" & " ORDER BY Branch,AccountNumber,CustomerLastName")

 

I need to add in anothe item where it tells it to exclude where DateExceptionCleared is completed.

 

I have tried this many ways with no luck 

 

Your help is greatly appreciated. I hope I am in the right place.

 

 

[trq]

Firstly, you have posted your code within the HTML help board, this is not HTML.

 

Secondly, you have posted your code on a PHP web site, this is not PHP.

 

You need to find yourself an ASP web site.

[gregomva]

First there is no need to be rude. Secondly you should check your google search options for your site as when I entered the code for this it directed me to your site. I will definetly never visit your site again.