JerryVT
|
| Posted: 09/14/2004, 5:00 PM |
|
Hi,
I've been working on one project using Database Expression property like this one: "images/"&pic_number&".jpg"
It gives me a path to an image link control.
Everything was working fine - images were displayed but now I'm getting this error:
Form: Grid tblTemplates
Error: Characters found after end of SQL statement. (Microsoft JET Database Engine)
I've tried to change "&" for "+" and it had helped to get rid of the error but I'm getting an empty result (image source string).
src=" "
using Access/ASP/WIin XP
Any ideas why it happened?
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 09/17/2004, 4:37 AM |
|
Jerry,
Please print generated sql from Before Execute Select event, I think it can help you to find what is wrong with a query. You can use the code like:
Response.write form_name.Command.SQL & " WHERE " & Form_name.Command.Where & " Order By " & form_name.Command.Order
If there’s no default sorting on a form you can exclude Order By part
_________________
Regards,
Nicole |
 |
|
|
