Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 8th, 2006, 12:56 PM
Authorized User
 
Join Date: May 2004
Location: Chennai, Tamil Nadu, India.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to saravananedu
Default Technical Clarification Reqd.

On Access Query window, I have executed one query with like operator ...like below:

SELECT EMPNAME FROM EMP WHERE EMPGROUP LIKE '*Lead*'

and it is suceesfully executed and returns 15 rows.

When i copy & paste the same code on my asp, it is neither giving error not returning any records. so i replaced * with % symbol like below:

SELECT EMPNAME FROM EMP WHERE EMPGROUP LIKE '%Lead%'

Now, the results are coming. I wonder, why this is required? what is the logic behind that? could anybody help me out?

BTW, i have used " DRIVER={Microsoft Access Driver (*.mdb)} " in my connection string.

Thanks in Advance.

Best Regards,
Saran.
__________________
Best Regards,
Saran.
  #2 (permalink)  
Old November 26th, 2006, 06:14 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you use the Microsoft Jet interface with an OLE call, rather than ODBC, it should work OK.
-> http://www.connectionstrings.com/?carrier=access

I am a loud man with a very large hat. This means I am in charge


Similar Threads
Thread Thread Starter Forum Replies Last Post
can anyone help me with some technical code? ashokparchuri C# 2 January 10th, 2008 03:53 PM
HELP REQD FOR-EACH SOMANATHAN10 XSLT 1 February 16th, 2007 02:00 PM
technical problem rajib14 Crystal Reports 3 February 14th, 2005 03:26 PM
Reqd Tool awdhil Java GUI 0 August 3rd, 2004 01:38 AM
Websphere technical position andrewphilip J2EE 0 July 9th, 2004 11:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.