SELECT * FROM... statement gives problem

I run an Access database 2000

I have a database, containing emailadresses stored in a text formated
column named mailadr.

I have declared as follows - part of my code

Del1 = Cstr(RecSet("mailadr"))


Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)};dbq=" &
Server.MapPath("adresser.mdb")

Set RecSet = Server.CreateObject("ADODB.Recordset")
Radera = "SELECT * FROM Mail WHERE mailadr ='" & Del1 & "'"

RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic
%>Wish to delete this<%=Del1%>
<%
%>SELECT produces this<%=Radera%>
<%

This generates this on my screen

Wish to delete this: boj@isplanket.com
SELECT produces this: SELECT * FROM Mail WHERE mailadr
='boj@isplanket.com'

meaning that the ' ' surrounding the textstring that i want to search
my database column mailadr for finds nothing

HOW CAN I PRINT MY CODE TO GET A CLEAN RESULT IN RETURN

Thankfully hoping...

Re: SELECT * FROM... statement gives problem

Sorry - it all was OK - I had just forgone myself having reloaded
another version of my database - so the code was OK all along...


On Tue, 01 Feb 2005 17:08:08 +0100, Bob The ASP Builder
wrote:

>I run an Access database 2000
>
>I have a database, containing emailadresses stored in a text formated
>column named mailadr.
>
>I have declared as follows - part of my code
>
>Del1 = Cstr(RecSet("mailadr"))
>
>
>Set Connect = Server.CreateObject("ADODB.Connection")
>Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)};dbq=" &
>Server.MapPath("adresser.mdb")
>
>Set RecSet = Server.CreateObject("ADODB.Recordset")
>Radera = "SELECT * FROM Mail WHERE mailadr ='" & Del1 & "'"
>
>RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic
>%>Wish to delete this<%=Del1%>
<%
>%>SELECT produces this<%=Radera%>
<%
>
>This generates this on my screen
>
>Wish to delete this: boj@isplanket.com
>SELECT produces this: SELECT * FROM Mail WHERE mailadr
>='boj@isplanket.com'
>
>meaning that the ' ' surrounding the textstring that i want to search
>my database column mailadr for finds nothing
>
>HOW CAN I PRINT MY CODE TO GET A CLEAN RESULT IN RETURN
>
>Thankfully hoping...