umm a very newbie question in querys

From: ali (ali4ever4_at_gmail.com)
Date: 12/31/04 

Date: 31 Dec 2004 04:36:21 -0800

well some thing is not right i think

i tried this query
recordSet = query.executeQuery("SELECT * FROM members WHERE Name LIKE
'Ali*'");

and wrote it correctly in try catch

but id didnt work

if i write my complete name instead of 'Ali*' it
works

but with the statment as it is it finds nothing

i think Stetment has some ellargy to * ( any) in sql
so can some help me with a solution for that

Relevant Pages

  • Re: Help please on Record sets
    ... I tried running it from the query builder after deleting all the ... Just because your "original SQL string was generated in a working ... I had to add a quote to your first Formated Date and Change the quotes to ... recordset or would that lead to more problems? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need help with Code Please!!!
    ... posted in response to my last post was some SQL, but this is not the SQL that ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Loading recordset at runtime
    ... difference in loading time for the entire recordset and the default 10 ... query or build the SQL string in VBA. ... Ah, ok, then use the forms "filter" option. ...
    (microsoft.public.access.forms)
  • Re: Loading recordset at runtime
    ... cases the recordset will be modified after the form is opened. ... Ah, ok, then use the forms "filter" option. ... my personal preference is to build the sql string in code and just ... advantages to using a query (the only exception here is if the "base" sql ...
    (microsoft.public.access.forms)