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
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar