ASP is reformating my SQL dataset

Results 1 to 3 of 3

Thread: ASP is reformating my SQL dataset

  1. #1
    John Bartlett Guest

    Default ASP is reformating my SQL dataset

    I have a sql stored procedure which runs fine and ouputs a dataset, it even outputs the dataset to the asp page. However, when the page encounters numerics (sql datatype numeric(14,5)) it drops all zeros from the end. i.e. 42.0000 becomes 42, great, but 6000.00000 becomes 6.<BR><BR>I&#039d like to have 6000<BR><BR>any ideas?

  2. #2
    sm549 Guest

    Default Sybase?

    Are you using Sybase with ADO? If so you can try:<BR>&nbsp&nbsp&nbspoADOConn.CursorLocation = adUseClient<BR>There&#039s a KB article on it.<BR><BR>Views expressed are not necessarily those of my employer.<BR>

  3. #3
    John Bartlett Guest

    Default RE: Sybase?

    Thanks, but I think I&#039ve actually got it now. For the record the output it formatted by a code in the output script. R for Right align and C for currency right align. These are currency amounts with an R on them instead of a C.

Posting Permissions

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