Did you see my email regarding using the "cn" variable to store the connection string when you've used it to created an ADO connection object? The first thing I would check is whether there is any data in the database that matches, within Access itself. If there's a small amount of data you should be able to see very quickly, if it's a large amount of data then you probably want to create a quick query in Access. Dan
________________________________ From: AspClassicAnyQuestionIsOk@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 24 August 2005 10:15 To: AspClassicAnyQuestionIsOk@yahoogroups.com Subject: RE: [AspClassicAnyQuestionIsOk] word from data base i just use like operator,i don't know whether it is working or not,boz it didn't show any error messages as well as no result also, <%set cn=server.createobject("ADODB.connection") set rs=server.createobject("ADODB.recordset") set rs1=server.createobject("ADODB.recordset") cn="DRIVER={Microsoft Access Driver (*.mdb)}; " cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb") rs.open "select * from postpro where projecttype like '*flash*' ",cn,1,2 while not rs.eof response.write rs("username") response.write rs("projecttype") rs.movenext wend %> what is the problem with the code?! thanks in adv Jegatha Dan Powderhill <[EMAIL PROTECTED]> wrote: If you're using Access :- select * from [myTable] where [projecttype] like '*flash*'; If using SQL Server :- select * from [myTable] where [projecttype] like '%flash%; Dan ________________________________ From: AspClassicAnyQuestionIsOk@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 24 August 2005 08:44 To: Asp Subject: [AspClassicAnyQuestionIsOk] word from data base i have field name as projecttype in database. this projecttype will contain more than 5 words with commas. like projecttype=flash,photoshop,asp,html,php, /********it may have differnt combinations,like this**/ now i need to display the records where the projecttype contain flash,how to do this? how to find a particular word ? is there any idea? --------------------------------- Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots more. http://in.promos.yahoo.com/rakhi/index.html [Non-text portions of this message have been removed] SPONSORED LINKS Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmin g+languages&w2=C+programming+language&w3=Computer+programming+languages& w4=Java+programming+language&w5=C+++programming+language&w6=History+of+c omputer+programming+language&c=6&s=198&.sig=hjFSMmldhVc3zrT5SqL9xQ> C programming language <http://groups.yahoo.com/gads?t=ms&k=C+programming+language&w1=Programmi ng+languages&w2=C+programming+language&w3=Computer+programming+languages &w4=Java+programming+language&w5=C+++programming+language&w6=History+of+ computer+programming+language&c=6&s=198&.sig=td85HQ93XfErfw7wfLZ86A> Computer programming languages <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=P rogramming+languages&w2=C+programming+language&w3=Computer+programming+l anguages&w4=Java+programming+language&w5=C+++programming+language&w6=His tory+of+computer+programming+language&c=6&s=198&.sig=BMtgOo7dpsC1xzn1Ygp BPg> Java programming language <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Progra mming+languages&w2=C+programming+language&w3=Computer+programming+langua ges&w4=Java+programming+language&w5=C+++programming+language&w6=History+ of+computer+programming+language&c=6&s=198&.sig=8IuywkhSLTtpB6_iFiJoCQ> C programming language <http://groups.yahoo.com/gads?t=ms&k=C+++programming+language&w1=Program ming+languages&w2=C+programming+language&w3=Computer+programming+languag es&w4=Java+programming+language&w5=C+++programming+language&w6=History+o f+computer+programming+language&c=6&s=198&.sig=jpmDiGf8qD8AqZNqFwDO7w> History of computer programming language <http://groups.yahoo.com/gads?t=ms&k=History+of+computer+programming+lan guage&w1=Programming+languages&w2=C+programming+language&w3=Computer+pro gramming+languages&w4=Java+programming+language&w5=C+++programming+langu age&w6=History+of+computer+programming+language&c=6&s=198&.sig=9slR1_vZJ lvyOINA4iLkow> ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * 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 Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots more. http://in.promos.yahoo.com/rakhi/index.html [Non-text portions of this message have been removed] SPONSORED LINKS Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmin g+languages&w2=C+programming+language&w3=Computer+programming+languages& w4=Java+programming+language&w5=C+++programming+language&w6=History+of+c omputer+programming+language&c=6&s=198&.sig=hjFSMmldhVc3zrT5SqL9xQ> C programming language <http://groups.yahoo.com/gads?t=ms&k=C+programming+language&w1=Programmi ng+languages&w2=C+programming+language&w3=Computer+programming+languages &w4=Java+programming+language&w5=C+++programming+language&w6=History+of+ computer+programming+language&c=6&s=198&.sig=td85HQ93XfErfw7wfLZ86A> Computer programming languages <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=P rogramming+languages&w2=C+programming+language&w3=Computer+programming+l anguages&w4=Java+programming+language&w5=C+++programming+language&w6=His tory+of+computer+programming+language&c=6&s=198&.sig=BMtgOo7dpsC1xzn1Ygp BPg> Java programming language <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Progra mming+languages&w2=C+programming+language&w3=Computer+programming+langua ges&w4=Java+programming+language&w5=C+++programming+language&w6=History+ of+computer+programming+language&c=6&s=198&.sig=8IuywkhSLTtpB6_iFiJoCQ> C programming language <http://groups.yahoo.com/gads?t=ms&k=C+++programming+language&w1=Program ming+languages&w2=C+programming+language&w3=Computer+programming+languag es&w4=Java+programming+language&w5=C+++programming+language&w6=History+o f+computer+programming+language&c=6&s=198&.sig=jpmDiGf8qD8AqZNqFwDO7w> History of computer programming language <http://groups.yahoo.com/gads?t=ms&k=History+of+computer+programming+lan guage&w1=Programming+languages&w2=C+programming+language&w3=Computer+pro gramming+languages&w4=Java+programming+language&w5=C+++programming+langu age&w6=History+of+computer+programming+language&c=6&s=198&.sig=9slR1_vZJ lvyOINA4iLkow> ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * 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 Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hvh23bf/M=362335.6886445.7839731.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124884640/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/">In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> 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/