p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: SQL in Access 98/2000


Message #1 by "Idris Mansoor" <idris.mansoor@t...> on Fri, 14 Jul 2000 10:29:39
I have the following line in my ASP script:

SELECT * FROM Name WHERE Name like 'an*';

Which runs fine in RAW access Query mode both in 98 and 2000 versions.  But 

does not work thru ASP using CreatObject ADODB object and also thru VB 

(with ref to ADO 2.5 Lib).



Have I missed a ref to somet else?

Message #2 by "Ken Schaefer" <ken.s@a...> on Sun, 16 Jul 2000 18:10:10 +1000
You should read the following:



http://www.adOpenStatic.com/FAQ/likequeries.asp



and



http://www.adOpenStatic.com/FAQ/selectstarisbad.asp



Cheers

Ken



----- Original Message -----

From: "Idris Mansoor" 

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, July 14, 2000 10:29 AM

Subject: [asp_databases] SQL in Access 98/2000





> I have the following line in my ASP script:

> SELECT * FROM Name WHERE Name like 'an*';

> Which runs fine in RAW access Query mode both in 98 and 2000 versions.

But

> does not work thru ASP using CreatObject ADODB object and also thru VB

> (with ref to ADO 2.5 Lib).

>

> Have I missed a ref to somet else?






  Return to Index