Even if it is a date field In IF condition u dont need to put #s. directly take that date field from input box and compare as u r doing with the remaining recordset fields.
I can work out if doping like this : k=CDate(e) while not rs.eof if rs(1)=a and rs(3)=c and rs(4)=d and rs(2)=b and rs(5)=k then --------- -------- Even if u cannot get try using FormatDateTime function to convert both the dae fields into the same type. On 6/9/05, Jegatha <[EMAIL PROTECTED]> wrote: > thankz Dan > > There is no space between the #'s .See my coding is > > k=CDate(e) > while not rs.eof > if(rs(1)=a) and (rs(3)=c) and (rs(4)=d) and (rs(2)=b) and (rs(5)=#"&k&"#) > then > ---- > > the error is > > Microsoft VBScript compilation error '800a03ea' > Syntax error > /sodal/submit2.asp, line 52 > if(rs(1)=a) and (rs(3)=c) and (rs(4)=d) and (rs(2)=b) and (rs(5)=#"&k&"#) > then-----------------------------------------------------------------^ > Jegatha > > > Dan Powderhill <[EMAIL PROTECTED]> wrote: > What's the code you're using at the moment? There shouldn't be spaces > between the #s and the date itself, although whether that'd cause a data > type mismatch. > > Dan > > ________________________________ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On > Behalf Of Jegatha > Sent: 09 June 2005 07:14 > To: Asp > Subject: [AspClassicAnyQuestionIsOk] Need to check date field > > > Hi > > I need to check the date in the textbox with date inside the > database,how to compare? > used CDate function it shows an error message, if i use # "&textname&" # > it shows data type mismatch error. > plz help me. > > thankz > > regards, > Jegatha > > > --------------------------------- > Free antispam, antivirus and 1GB to save all your messages > Only in Yahoo! Mail: http://in.mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > ________________________________ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] > subscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > > [Non-text portions of this message have been removed] > > > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > --------------------------------- > Too much spam in your inbox? Yahoo! Mail gives you the best spam protection > for FREE! > http://in.mail.yahoo.com > > [Non-text portions of this message have been removed] > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- Balaji V Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
