Problem running query from web using asterick

[rmcompute]

I set up a query in Access with a where block of: Model Like "*470*". It
runs successfully. I embedded the same code in a web page and it does not
pull any data. It works if the astericks are removed and the full model
number is typed. Does anyone know of any quirks using the asterick with
Access when embeding it on a web page? Also, does anyone know of a more
appropriate place to place this question.

 

[Jeff Boyce]

What is the back-end data source? If it is SQL-Server, you'll need to use
the SQL-Server wildcard ("%") instead of the wildcard you would use from
within Access ("*").

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[rmcompute]

Jeff,

Thanks for the response. The backend datasource is Access and the query
works when it runs directly in access. When it is embeded on the web page,
it works without the wild card and the full model typed out so that proves we
are connecting and querying successfully. There must be a problem about
using an asterick from an ASP web page. Have you heard of any such thing or
do you know a website which might be more likely to address such an issue?

Thanks.

 

[Jeff Boyce]

I've not worked in that area. Hopefully another newsgroup reader can offer
insight.

Have you posted to an ASP-related newsgroup?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[rmcompute]

Will Try that.

Thanks.

I've not worked in that area. Hopefully another newsgroup reader can offer
insight.

Have you posted to an ASP-related newsgroup?

Regards

Jeff Boyce
Microsoft Office/Access MVP