|
 |
asp_databases thread: Access 2000 query problem
Message #1 by maheshmn@l... on Mon, 19 Aug 2002 17:10:34 +0530
|
|
Dear All,
I am facing a problem in sql query with Access 2000. when i run this query
" select * from customers where customername like 'al*' " in sql view of
Access 2000, it's working fine and giving the results. but when i include
the above query in ASP code, it doesn't return any records.
Could any one tell me what is the problem with this code. i think "like"
keyword is giving problem.
thanks in advance.
Regards,
Mahesh kumar M N
Message #2 by Colin.Montgomery@C... on Mon, 19 Aug 2002 12:30:56 +0100
|
|
you need to use % rather than *
HTH,
Col
-----Original Message-----
From: maheshmn@l...
[mailto:maheshmn@l...]
Sent: 19 August 2002 12:41
To: ASP Databases
Subject: [asp_databases] Access 2000 query problem
Dear All,
I am facing a problem in sql query with Access 2000. when i run this query
" select * from customers where customername like 'al*' " in sql view of
Access 2000, it's working fine and giving the results. but when i include
the above query in ASP code, it doesn't return any records.
Could any one tell me what is the problem with this code. i think "like"
keyword is giving problem.
thanks in advance.
Regards,
Mahesh kumar M N
*******
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.
Message #3 by maheshmn@l... on Mon, 19 Aug 2002 17:20:27 +0530
|
|
Thanks very much Colin. it's working now.
Regards,
Mahesh kumar M N
Colin.Montgomery@C...
Chance.com To: "ASP Databases" <asp_databases@p...>
cc:
08/19/2002 05:00 PM Subject: [asp_databases] RE: Access 2000 query problem
Please respond to "ASP
Databases"
you need to use % rather than *
HTH,
Col
-----Original Message-----
From: maheshmn@l...
[mailto:maheshmn@l...]
Sent: 19 August 2002 12:41
To: ASP Databases
Subject: [asp_databases] Access 2000 query problem
Dear All,
I am facing a problem in sql query with Access 2000. when i run this query
" select * from customers where customername like 'al*' " in sql view of
Access 2000, it's working fine and giving the results. but when i include
the above query in ASP code, it doesn't return any records.
Could any one tell me what is the problem with this code. i think "like"
keyword is giving problem.
thanks in advance.
Regards,
Mahesh kumar M N
*******
This message and any attachment are confidential and may be privileged or
otherwise protected from disclosure. If you are not the intended
recipient, please telephone or email the sender and delete this message and
any attachment from your system. If you are not the intended recipient you
must not copy this message or attachment or disclose the contents to any
other person.
For further information about Clifford Chance please see our website at
http://www.cliffordchance.com or refer to any Clifford Chance office.
Message #4 by "Drew, Ron" <RDrew@B...> on Mon, 19 Aug 2002 08:09:48 -0400
|
|
" select * from customers where customername like 'al%' "
-----Original Message-----
From: maheshmn@l...
[mailto:maheshmn@l...]
Sent: Monday, August 19, 2002 7:41 AM
To: ASP Databases
Subject: [asp_databases] Access 2000 query problem
Dear All,
I am facing a problem in sql query with Access 2000. when i run this
query " select * from customers where customername like 'al*' " in sql
view of Access 2000, it's working fine and giving the results. but when
i include the above query in ASP code, it doesn't return any records.
Could any one tell me what is the problem with this code. i think "like"
keyword is giving problem.
thanks in advance.
Regards,
Mahesh kumar M N
|
|
|
View Cart
