Home | Advertising Info100 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Sunday, August 14, 2022  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
SQL Queries
 PowerASP Code Help Area : SQL Queries
Subject Info: Simple Query Assistance A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
Kranial_1
Newbie
Newbie
Avatar

Joined: September/14/2006
Location: United States
Online Status: Offline
Info: 2
Added: September/14/2006 at 8:33pm | IP Logged Quote Kranial_1

I am just starting to learn this stuff.  Currently using an Access database with 2 fields- Quote, Author

When I run this query from asp I get an empty recordset:

strSQL="SELECT Quote, Author FROM quotes WHERE Author Like ""*proverb""; "

When run in Access it returns the data I am seeking.  The problem it seems is the * wildcard in the LIKE portion of the statement.  If I remove the * the query runs fine but not all the records show up.  This is why i am using the wildcard

Any info would be helpful.

adTHANKSvance,

Ken

Back to Top View Kranial_1's Profile Search for other info by Kranial_1
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: September/15/2006 at 10:06pm | IP Logged Quote cwilliams

google is your friend

I did a search and this is the 1st thing that came up

http://www.adopenstatic.com/faq/likequeries.asp

__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
Kranial_1
Newbie
Newbie
Avatar

Joined: September/14/2006
Location: United States
Online Status: Offline
Info: 2
Added: September/16/2006 at 11:50am | IP Logged Quote Kranial_1

Thanks a bunch
Back to Top View Kranial_1's Profile Search for other info by Kranial_1
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright 1998 - 2022 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com