thankz Dan, but its not working, actually i need to check if the record is already exsist or not. If it is true it should come out from the program,if it s false this record should be added inside the db. how to do,here the if condition is not properly working,dn't know the reason. any one out this? Jegatha
Dan Powderhill <[EMAIL PROTECTED]> wrote: Does this not work?:- 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 Dan ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 09 June 2005 09:20 To: [email protected] Subject: RE: [AspClassicAnyQuestionIsOk] Need to check date field 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] <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: http://docs.yahoo.com/info/terms/
