dcsimg
Results 1 to 6 of 6

Thread: One more thing...

  1. #1
    Join Date
    Jan 2003
    Posts
    24

    One more thing...

    After testing a little bit more, found out that the next button doesn't work either, and now I am getting this error when I click next or download:

    Error # (Get_RS_OPEN - After open TOP SQL) = 80040E07(-2147217913)
    Description = [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 22008
    Native Error = 242

    There are no char values - all datatypes al varchar, and one is datetime, and that should remain datetime.

  2. #2
    Join Date
    Jan 2003
    Posts
    24
    Adding some more...

    Figured out why getting the datatype error, date wasn't a "true" date. but now when I hit "next" or any buttong, the browser "thinks" and given me a blank where my grid should be?
    Anything else I am missing?

  3. #3
    Join Date
    Oct 2002
    Posts
    933
    a small section of code will help to debug. Do it in NWIND.

    FK

  4. #4
    Join Date
    Jan 2003
    Posts
    24
    Figured out what the problem was. I remember vaguely anytime there was a where clause, the dbReset had to be used. So added that to my code, and now both the "next" "previous" "download" (which are the only buttons I am using) are working properly. Is this a bug or is this a workaround? It is kind of cumbersome, whenever there is a where clause to have to go through these steps.

  5. #5
    Join Date
    Oct 2002
    Posts
    933
    dbReset is used to clar the variables for the next module. Depends on what your code looks like.

    FK

  6. #6
    Join Date
    Jan 2003
    Posts
    24
    Once I rememebred it it was an easy integration to the code. Asp-db still rocks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •