Re: Queries and Now()

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"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

  • Re: ADO Recordset Update & SQL Server 2005 ??
    ... There's no 500 error (asp and iis 6) posted on the page. ... if err.number 0 then response.write err.description inside the loop, ... This error shows up ONLY when connected to a sql server 2005 server. ...
    (microsoft.public.data.ado)
  • Re: ASP Loop in wrong place????
    ... below is the code for the entire table (inc. ASP functions) ... face="Verdana, Arial, Helvetica, sans-serif"> ... >>the column data and the 3rd is where the loop for the SQL statement lies. ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP Loop in wrong place????
    ... Thanks however as i will build my ASP apps dynamically in the future. ... >>about - note the extra row for the end of loop. ... > Helvetica, sans-serif";} ... > ' Get your record set before beginning to create the table ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP, looping, and stored procedures.... error 800a0bb9 ...
    ... > page PER loop. ... The looping goes by month from and to dates selected ... > In pure ASP the page takes about 15 seconds. ... > Oh, and by the way, the test box has SQL server and IIS on it. ...
    (microsoft.public.inetserver.asp.db)
  • Dont understand flow using xmlhttp
    ... I'm building a simple newsletter application using Classic ASP. ... loop through the array and for each e-mail address do a http ... Is there a way of not continuing the loop until the response has ... var aList = new Array; ...
    (comp.lang.javascript)