ACCESS FEED: Re: [MS_AccessPros] Use of "*" in a query

Sabtu, 19 Juli 2014

Re: [MS_AccessPros] Use of "*" in a query

Thanks John,

I was not prepared to gamble but it works. Now to look up ADO!

Cheers,

Robin

At 19/07/2014 08:16 PM, you wrote:

Robin-

If the code generator is using ADO in the web pages (highly likely), then your query will need to use % instead of *. It won't work locally, but try changing it to %, convert it, and see if the web page works.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Jul 18, 2014, at 11:53 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I use an Access database on a remote server and code generated pages
for data display and editing.

I have been using the same code generator in it's several versions
for nine years.

Yesterday a new query failed to provide data on the site. This is the SQL:

SELECT tCalendar.Page, tCalendar.Dayte, tCalendar.ID,
tCalendar.Status, tCalendar.Hide, tCalendar.Visits
FROM tCalendar
WHERE (((tCalendar.Page) Like "District Governor visits*") AND
((tCalendar.Status)=2) AND ((tCalendar.Hide)=No))
ORDER BY tCalendar.Page;

The advice from the support people, within 24hrs, was:
~~~~~~~~~~~~
The Jet Engine does not like SQL query of the form "[Field] LIKE
'value*'" (note the "*" in the SQL). Replace "*" with "%".

Alternatively, remove the WHERE part from the view and add it using
the table filter.
~~~~~~~~~~~~~~

I tested the first suggestion and the use of "%" in place of "*"
failed on my machine. I did not test on the remote site.

I do not understand the alternative that has been suggested. How do I
implement that advice?

Any advice is welcome.

Many thanks,

Robin Chapple

------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------

------------------------------------

Yahoo Groups Links