| Bob Barrows [MVP] 2006-07-31, 1:23 pm |
| divya wrote:
> Hi,
> I have a table tblbwday with 2 fields Name and Birthday.
> I have written
> this script for displaying evryday names of the people on that day.
>
> <%
> set objConn =server.createobject("ADODB.connection")
> objConn.open "DSN=Photo"
Nothing to do with your problem, but you should stop using DSN's:
http://www.aspfaq.com/show.asp?id=2126
> Dim sqlSELsite,ObjRSSel
>
> sqlSELsite = "SELECT Name FROM tblbwday WHERE B'day ="& date() &" " '
> Error in this line
> Set ObjRSSel = Server.CreateObject("ADODB.Recordset")
> ObjRSSel.Open sqlSELsite,objConn
> Do While Not objRS.EOF
> Response.Write "Name: " &objRSel("Name")
> Response.Write "<P><HR><P>"
> objRSel.MoveNext
> Loop
> %>
> Error is:-
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in string in
> query expression 'B'day =7/31/2006'.
> /Project1_Local/ASP Page4.asp, line 15
>
> I have added a record with today's date in the table.I know this logic
> is wrong we need to compare only day and month.and this will compare
> year also.Plz send me some tips which can help me in comparing only
> day and month.
> intDays = DatePart("y",now) will give me the curent day in the
> year.Can I compare intdays with the b'day's in the table?
>
You've got several problems:
1. The use of nonstandard characters in your field names. "B'Day"???
What's wrong with BDay, or even BirthDay?
If you can't change the name of this field (and you really should), you
are going to need to surround it with brackets when using it in queries
called by ADO:
[B'Day]
2. Is [B'Day] a Date/Time field? If so, it does not store just the date:
it stores both date and time. If no time is entered, thhen it defaults
to midnight. Dates are stored as Double numbers, with the integer
portion representing the number of days since the seed date, and the
decimal portion represnting the time of day (.0=midnight, .5 = noon)
Given that it's a date/time field this will work:
sqlSELsite =" ... WHERE [B'Day] >= Date() AND " & _
"[B'Day] < dateadd(1,'d',Date())"
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
|