Re: Queries and Now()

Exactly, thanks. In addition, ASP settings themselves may possibly cache
some data it perceives as 'constant', avoiding a round trip to the server.
That is why I suggest to use another tool, to see the data, for yourself,
not to write your application, no, but to determine, hopefully, if the
problem is within Access, or with ASP. If the third tool shows data as in
Access, then the ASP code you use is probably the problem, not the Access
query that you use.



Vanderghast, Access MVP

"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23z0uQyQaIHA.484@xxxxxxxxxxxxxxxxxxxxxxx

"Craig" <msaccess@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uA3jNaQaIHA.5768@xxxxxxxxxxxxxxxxxxxxxxx
Could you say that again in English? ;-)


"Michel Walsh" <vanderghast@VirusAreFunnierThanSpam> wrote in message
news:ug32N0NaIHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
I suspect your ASP implementation optimizes something it should not. It
may also be version dependant, such as ASP.Net 3.5 or previous versions.
Sure, that sounds like I try to send the problem to ASP, but if the query
behaves correctly within Access... Can you try to get the data from, say,
Excel, or from MS SQL Server, or from a dataview tool from C#, to see if
it get as Access, or as your ASP implementation shows it, letting Excel
(MS SLQ Server, C#) determines who is the source of the problem, kind of
... :-)

I think what he is saying is that the problem is probably in your ASP code
and not the query. So probably in the loop where you think you've changed
what you're looking at, you're changing it for everything but the
misbehaving field. So maybe you store that field's value above the loop,
and you're always retrieving the same value.



.

Relevant Pages

  • ASP page to Display othertelephone
    ... Below is my code for my asp page. ... way to add the othertelephone array to the table that gets displayed. ... ' Next we will build the LDAP query that will be used to retrieve the ... ' We will specify which server we want to run the query against, ...
    (microsoft.public.scripting.vbscript)
  • RE: Error in IE when running ASP Page.
    ... This is an asp question in an ASP.NET group. ... active directory group for help on what is the correct ad query. ... ' Next we will build the LDAP query that will be used to retrieve the ... ' We will specify which server we want to run the query against, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error in IE when running ASP Page.
    ... an ASP page. ... oConn.Open "Ads Provider" ... ' Next we will build the LDAP query that will be used to retrieve the ... ' We will specify which server we want to run the query against, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ASP page will not load
    ... >>> using ASP. ... Why do I get a 500 Internal Server error for all ... >>Internet Services Manager. ... >>Properties, and on the Home Directory tab, click the ...
    (microsoft.public.inetserver.asp.general)
  • Re: Ecommerce Server Requires Daily Reboot
    ... Sounds like you need a good ASP developer to go through ... SQL data caching schemes, to IIS settings, etc, etc, etc. ... a file cache on the web server. ... In order for customer to access webpage login, ...
    (microsoft.public.dotnet.framework.aspnet)