LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to handle null numeric values in ADO recordset

For anyone interested, I didn't quite solve the problem, but it i
working now.

I had to change the format of the output to not have the missin
paramater at all.

<z:row INDEX="2004-04-05" x="1" /
<z:row INDEX="2004-04-06" x="2" /
<z:row INDEX="2004-04-07" x="3" /
<z:row INDEX="2004-04-08" x="4" /
<Z:ROW INDEX=\"2004-04-09\" /
<z:row INDEX="2004-04-12" x="6" /
<z:row INDEX="2004-04-13" x="7" /
<z:row INDEX="2004-04-14" x.="8" /
<z:row INDEX="2004-04-15" x.="9" /
<z:row INDEX="2004-04-16" x="10" /

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN ramesh k. goyal - abohar[_2_] Excel Discussion (Misc queries) 1 October 28th 09 06:50 AM
Showing NULL Command Bar handle [email protected] Excel Discussion (Misc queries) 0 June 4th 07 11:40 AM
Handle missing values Arne Hegefors Charts and Charting in Excel 1 May 8th 07 01:15 PM
Return Numeric Labels that have different Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 8 December 3rd 06 02:06 AM
Creating small "recordset" or sorting a numeric 1-dim array Anthony Cravero Excel Programming 0 December 19th 03 06:36 PM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"