Bug #5097 DataReader returning NULL for time column
Submitted: 18 Aug 2004 19:03 Modified: 26 Aug 2004 5:42
Reporter: Matthew Aznoe Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:ByteFX 0.76 OS:Microsoft Windows (Windows XP)
Assigned to: Reggie Burnett

[18 Aug 2004 19:03] Matthew Aznoe
Description:
When a database column of type time contains the value "00:00:00", the DataReader returns this value as DbNull.

How to repeat:
using ByteFX.Data.MySqlClient;
using System;
using System.Data;
using System.Threading;

namespace DBTester
{
   /// <summary>
   /// Summary description for Class1.
   /// </summary>
   class Class1
   {
      /// <summary>
      /// The main entry point for the application.
      /// </summary>
      [STAThread]
      static void Main(string[] args)
      {
         MySqlConnection      clConnection   = new MySqlConnection( "Data Source=localhost;User ID=root;Database=dbtest" );
         MySqlCommand         clCommand      = new MySqlCommand();
         string               sCommand         = "SELECT * FROM testtable";
         MySqlDataReader      clReader;

         try
         {
            clCommand.Connection = clConnection;

            // Get data from the database.
            clConnection.Open();
            clCommand.CommandText = sCommand;
            clReader = clCommand.ExecuteReader();
            while( clReader.Read() )
            {
               Console.WriteLine( clReader.GetValue(0) );
               Console.WriteLine( clReader.GetValue(1) );
               Console.WriteLine( clReader.GetValue(2) );
               Console.WriteLine( clReader.GetValue(3) );
            }
            clReader.Close();
            clConnection.Close();
            Console.WriteLine("Data updated successfully.");
         }
         catch( Exception ex )
         {
            Console.WriteLine(ex.Message);
            clConnection.Close();
         }

         Console.ReadLine();
      }
   }

}

/*
create table testtable
(
   id         int unsigned auto_increment not null,
   name      varchar(255) not null,
   salary   float not null,
   start      time not null,
   primary key( id )
);
insert into testtable values( null, "Dave", 9.55, "00:00:00" );
*/

Suggested fix:
The value should be returned as "00:00:00".
[19 Aug 2004 0:27] Justin Drerup
I am having the same problem however it does not appear to be the result of an errant datetime value.

Here is the code and the complete table to recreate the problem.  Sorry for pasting such a large table but the error seems to not always fail on the same row so I thought I better provide it all.

using ByteFX.Data.MySqlClient;
using System;
using System.Data;
using System.Threading;

namespace Boardtheworld.Console.Test
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	class DBTest
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			MySqlConnection clConnection = new MySqlConnection("Server=localhost;Database=btworld;User ID=dbuser;Password=password");
			MySqlCommand clCommand = new MySqlCommand();
			string sCommand = "SELECT * FROM tblNews ORDER BY tblNews.NewsID";
			MySqlDataReader clReader;

			try
			{
				clCommand.Connection = clConnection;

				// Get data from the database.
				clConnection.Open();
				clCommand.CommandText = sCommand;
				clReader = clCommand.ExecuteReader();
				while( clReader.Read() )
				{
					System.Console.WriteLine( clReader.GetValue(0) );
					System.Console.WriteLine( clReader.GetValue(1) );
					System.Console.WriteLine( clReader.GetValue(2) );
					System.Console.WriteLine( clReader.GetValue(3) );
					System.Console.WriteLine( clReader.GetValue(4) );
					System.Console.WriteLine( clReader.GetValue(5) );
					System.Console.WriteLine( clReader.GetValue(6) );
					System.Console.WriteLine( clReader.GetValue(7) );
				}
				clReader.Close();
				clConnection.Close();
				System.Console.WriteLine("Data updated successfully.");
			}
			catch( Exception ex )
			{
				System.Console.WriteLine(ex.Message);
				clConnection.Close();
			}

			System.Console.ReadLine();
		}
	}
}

Database btworld_01 - Table tblNews running on localhost 
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 18, 2004 at 10:24 PM
# Server version: 4.0.20
# PHP Version: 4.2.3
# 
# Database : `btworld_01`
# 

# --------------------------------------------------------

#
# Table structure for table `tblNews`
#

CREATE TABLE `tblNews` (
  `NewsID` int(11) NOT NULL auto_increment,
  `CountryCode` char(2) NOT NULL default '',
  `Title` varchar(255) NOT NULL default '',
  `StartDate` date NOT NULL default '0000-00-00',
  `EndDate` date NOT NULL default '0000-00-00',
  `Text` longtext NOT NULL,
  `Active` tinyint(1) NOT NULL default '0',
  `Author` int(11) NOT NULL default '0',
  PRIMARY KEY  (`NewsID`)
) TYPE=ISAM PACK_KEYS=1 AUTO_INCREMENT=402 ;

#
# Dumping data for table `tblNews`
#

INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (1, 'US', 'One Foot of Snow overnight in Telluride', '2000-04-22', '2001-04-22', '\n<P>Telluride is reporting one of the largest snow storms of the 1999-2000 season \ntoday with a total accumulation of 11 inches overnight on the top of the \nmountain and 13 inches mid-mountain. </P>\n<P>The top of the mountain base is 56 inches and a 59-inch mid-mountain base was \nreported as of 5:00 a.m. this morning. The flakes continue to fly and according \nto the National Weather Service another four to five inches are predicted to \nfall throughout the morning. </P>\n<P>"It\'s another beautiful powder day in Telluride," said <EM>Steve \nSwenson</EM>, Telski\' s vice president of sales, marketing and airline services. \n"It\' s the perfect way to celebrate Mardi Gras!" One-hundred percent of the \nTelluride Ski Area is open today and 54 percent of the designated trails are \ngroomed. Gold Hill will open this morning after Ski Patrol conducts standard \navalanche control work.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (2, 'CH', 'Crystal Awards in St Moritz, Switzerland', '2000-04-22', '2001-04-22', '<P align=left> The Crystal Awards is the PREMIER "World actionsports photographic Award".   </P>  <P align=left>This winter in St Moritz, a worlds first in event photography will take place   from 25th to 31st March 2000. The Crystal Awards has been received as the   pinnacle in the photographic sporting events calendar. Each photographer   nominated may chose his or her own rider to participate in the two man team   structure. The 2000 categories will consist of lifestyle, landscape, sequence,   turn, resort, air, black and white, and jibbing. The principle goal is for each   team to photograph the 8 pre determined categories within the allocated terrain   during a six day period. The teams are given 100 rolls of film which are   developed daily allowing updated review of their progress. The photographers   hotel rooms are equipped with light tables and filing cabinets. Shooting may   commence from Saturday night 25th till Thursday night 30th March, 24 hours a   day. </P>  <P align=left>The Awards night on Friday 31st March in Congress Pontresina, is an   interactive extravaganza. It is open to the public ( est. 700 - 800 guests )   where the "nominees" for each category will be presented similar to an Oscar   nomination. The event will also be cybercasted globally. Judging for the best   images will consist of the 11 event photographers their 11 team riders, an   additional 22 invited industry and media guests and the cyberpublic. </P>  <P align=left><STRONG>More Info at:</STRONG><BR>The Crystal Awards Tel. 0041 81 864 8226,   Fax 0041 81 864 0951, e-Mail: <A   href=\'"info@crystalawards.com"\'>info@crystalawards.com</A></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (3, 'AU', 'Boardtheworld.com Relaunches', '2000-04-22', '2001-04-22', '<P>BTWorld has just relaunched the entire site so that it is database driven. It has also moved its hosting from NT Based WebCentral in QLD Australia to LINUX based Positive Internet in London.</P> <P>Come and see the whole site being built from a database!</P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (4, 'US', 'Colorado is going sick!', '2000-01-27', '2001-04-23', '<P></P>  <P>Just dropping you a note to let you know that Copper has received 3 feet of   fresh in the past 4 days and it keeps on snowing. Copper Bowl is opening this   week and should be outstanding. Bring a snorkle because the freshies are   here!</P>  <P><EM>Cliff Jones</EM></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (5, 'AU', 'Test with Image', '2000-04-22', '2001-04-22', '<P>this is <STRONG>another </STRONG>test.</P>  <P>Can I add this text&nbsp;and image in?&nbsp; Will the \'Switch command\' work?</P> \n<P>Update with ID set as text?</P>  <P><IMG align=baseline alt="Zeal Rapt Goggles"   border=0   hspace=5 src="http://www.boardtheworld.com/images/magazine/product_reviews/eyewear/zeal_rapt_goggles.jpg" vspace=5 style="HEIGHT: 111px; WIDTH: 250px"></P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (6, 'CA', 'What\'s going down in Whister', '2000-03-04', '2001-04-22', '<P align=left><STRONG><EM>From Anthony Crute in \nWhistler/Blackcomb</EM></STRONG></P>\n<P align=left><FONT size=2>After what seemed to be a long stretch of two weeks \nwithout fresh snow, winter conditions are back. Over the past few days Whistler \nhas received several deposits of what has amounted to knee to hip deep powder. \nThe cliffs and trees are open for business.</FONT></P>\n<P align=left><FONT size=2>The Nike Series competitions are still continuing \neach Saturday. With 3 weeks of boardercross just finished up we are now heading \ninto two weeks of halfpipe competition in the Blackcomb Pipe with the monster 17 \nfoot walls. Unfortunately yours truly will not be competing this week as there \nare powdies to be had in the backcountry.</FONT></P>\n<P align=left><FONT size=2>Not much else happening other than the fact that the \nAmerican long weekend has come and gone and the slopes were a bit quieter this \nweek.&nbsp;They will stay this way until the beginning of spring break so now is \nthe time to come visit before spring conditions hit.</FONT></P>\n<P align=left><FONT size=2>The biggest news I guess is that Sims is the major \nsponsor of the World Snowboarding Championships to be held in Whistler on April \n20-23. - Big Air, SBX, Slopestyle, Halfpipe. - with $200 000 up for grabs. The \npoor old Westbeach Classic has been shoved to the side and will be happening in \nthe middle of May.</FONT></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (7, 'US', 'World Champion Snowboarder Craig Kelly to ride with Seattle\'s Chill Program', '2000-02-24', '2001-04-22', '<P align=left><STRONG>WHAT:</STRONG> Burton Snowboards\' Chill - Kids in   Seattle\'s Chill program will get the chance to learn to snowboard from Pro Rider   Craig Kelly.&nbsp; Chill is a not-for-profit program that takes underprivileged   and at-risk youth snowboarding.</P>  <P align=left><STRONG>WHO:</STRONG> Burton team rider and avid backcountry   adventurer Craig Kelly</P>  <P align=left><EM>Competitive Titles:</EM> 4-time World Champion (7 separate   titles) 3-time World Champion (6 separate titles).</P>  <P align=left><STRONG>WHERE:</STRONG>&nbsp; Steven\'s Pass Mountain Resort,   Skykomish, WA</P>  <P align=left><STRONG>WHEN:</STRONG> Thursday, February 24</P>  <P align=left><STRONG>WHY:</STRONG> Chill was established by Burton Snowboards   as a way of "giving back" to the community and sharing the sport with troubled   youth.&nbsp;&nbsp; Chill reaches the most needy kids in Seattle through Ruth   Dykeman Children\'s Center, Orion Center, Catholic Community Services, Ryther   Child Center, STARS, I.Wa.Sil Native American Youth Program, Ground Zero Teen   Center, Seattle Children\'s Home, Highpoint YMCA, the Boys and Girls Clubs of   North Seattle, Ballard, Rainier-Vista, Rotary, Wallingford, and Redmond.</P>  <P align=left>In addition to Burton Snowboards, Chill sponsors include   Mitsubishi Motor Sales of America, Nantucket Nectars and REI.</P>  <P align=left><STRONG>For more information, contact:</STRONG><BR>Jennifer   Sweeney (212) 780-1900 / Stanton Crenshaw</P>  <P align=left><STRONG>For specific information on Chill,   contact:</STRONG>&nbsp;<BR>Jenn Davis at (802) 651-0326 or <A   href="mailto:jennd@burton.com">jennd@burton.com</A></P>  <P align=left><STRONG>For more information on Burton Snowboards,   contact:</STRONG><BR>Stanton Crenshaw Communications:&nbsp; Jennifer Sweeney   (212) 780-1900<BR>Burton Snowboards:&nbsp; Amy Barrett (802)   862-4500</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (8, 'CA', 'All the big pros visit Whislter Blackcomb', '2000-02-01', '2001-04-22', 'Well Whistler is killing is as usual.&nbsp; This last \nweek the pipe on Blackcomb with its 17 foot transitions has been the place to be \n- JP Walker, Terje, Tera Dakitis to drop a few names have been riding the pipe.\n<P align=left>The terrain park is killer also with a blue (intermediate) and \nblack (advanced) sides mixing up the action for those who dare.</P>\n<P align=left>Currently they are in the process of building the biggist hip jump \nin North America (the are expecting 60 foot airs) - stay tuned for more \ninfo.</P>\n<P align=left>Whistler also has a park and pipe and have designed the pipe with \n15 foot transitions for the new guys and gals on the block and the park also is \na little mellower for the new crew. Whistler park will be the home of the Nkie \nseries boardercross events for the next 3 weeks.Stay tuned for more.</P>\n<P align=left>Base of snow is at 2.5m and growing with a big strom sitting of \nthe coast due to hit Tuesday with Moderate to harvy snowfall.</P>\n<P align=left>If you want to see what up check <A \nhref="http://www.pro-ride.com">www.pro-ride.com</A> - pics page to see how the \nWhis crew a kicking it back</P>\n<P align=left><STRONG>Anthony Crute</STRONG><BR>Pro Ride Snowboard \nDevelopment<BR>P.O. Box 448, Whistler, BC, Canada VON1BO<BR>Telephone: (604) 932 \n8302<BR>Facsimile: (604) 932 2288<BR>website: <A \nhref="http://www.pro-ride.com">www.pro-ride.com</A><BR>email: <A \nhref="mailto:snowboard@pro-ride.com">snowboard@pro-ride.com</A></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (9, 'US', 'Avalanche claims life of Snowboarder', '2000-01-29', '2001-04-22', '<P><STRONG>LOVELAND PASS </STRONG>- A 21-year-old \nBreckenridge man was killed in an avalanche near Arapahoe Basin Ski Area Tuesday \nafternoon as he snowboarded down one of the steep National Forest gullies \nreferred to as "the beavers" or "the fingers."</P>\n<P align=left>The snowboarder was riding legally but out of bounds in the \n"fourth gully" with friends when a slide engulfed him and buried him 6 inches \nunder the snow, officials said. The extreme, steep powder inclines of the White \nRiver National Forest lie one mile west of the ski area. The three-year \nBreckenridge resident apparently died from impact with a tree, said John Reller \nof Summit County Search and Rescue. Summit County Coroner David Joslin confirmed \nthe victim died of head trauma.</P>\n<P align=left>Recent heavy snow atop the previously weak snow base led officials \nearlier this week to declare avalanche warnings in Summit and eastern Eagle \ncounties. The victim was not carrying any avalanche tools or beacons.</P>\n<P align=left>Remember to respect the backcountry folks. We all love the powder, \nbut don\'t put your life or anyone else\'s in danger. The conditions at the \nresorts right now are fantastic, so go there and rage the stashes, wait for the \nsnow to settle, and if you must go in the backcountry carry the appropriate \nsupplies and knowledge with you.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (10, 'US', 'Vail Opens Superpipe', '2000-01-22', '2001-04-22', '<P>Vail has opened its long-awaited Superpipe.&nbsp; The \npipe is a whopping <STRONG>425 feet long with 17-foot \ntransitions</STRONG>.&nbsp; It is located in Golden Peak Park. The park is \ndesigned to be free flowing so riders can hit the pipe then continue through the \nnumerous hits, tabletops and spines.</P>\n<P>Golden Peak Park was designed by snow park design experts, Chris Gunnision \nand Mike Binnel.&nbsp; There was also input from local pro riders.</P>\n<P>The most important thing is Vail\'s commitment to maintaining the quality and \nconsistency of the park and pipe. Vail has committed to grooming the area on a \ndaily basis. A crew of terrain park specialist will evaluate the area each day \nto determine what maintenance work needs to be done.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (11, 'CA', 'What\'s Happening in Whistler', '2000-04-19', '2001-04-23', '<DIV>Well its more like whats not happening. As I type, some of the best   snowboarders in the world are arriving in Whitler for the Sims World   Championships of Snowboarding. All the huge names have been billed to be here   and I will let you know who they are as I spot them over the next couple of   days.<BR>&nbsp;<BR>Today ( Tuesday ) was the first day of the Kokanee Grand   Nationals Boardercross and the weather could not have been better. The   competitors trained today on the course which is so hot ( fast ) that people   cant help but clear the 50 foot gap jump leading into the finish. Wednesday is   the Qualifier time trials where the 150-200 men compete for the top 48 starting   positions. The women also are showing there numbers and the competition will be   fierce. Thursday is the race day but unfortunately the weather department is   predicting snow so we will have to see what happens.<BR>&nbsp;<BR>Friday will   see the start of the Sims World Champs with Slopestyle being the comp of the   day. The Black side of the Blackcomb park was closed today so they could push   more snow around - the course as I saw it today is like this 1. Drop in to a 35   foot table ( the Pro Jump ) 2. head left on the landing to the next black table   (&nbsp; 60 foot ) 3. line up for a slightly shorter table or bust a 12 foot ling   rail 4. b-line and point it at the monster hip jump ( 70 foot ) and finish at   the 20 foot high quarterpipe.<BR>I cant wait to see Peter Line and Kevin Jones   bust this line up.<BR>&nbsp;<BR>Saturday is jam packed with Halfpipe all day and then the  \nBig Air in the Village at night. Everybody competing is invited so we are  \nexpecting to see Terje kicking around.</DIV><DIV>&nbsp;</DIV><DIV>Sunday is the last day with another BX - totally  \ninvitational - should be worth a look.</DIV><DIV>&nbsp;</DIV><DIV>So   thats the week as it stands - I will keep you   updated<BR><BR><EM>Anthony Crute</EM><BR>Pro Ride Snowboard   Development<BR>P.O. Box 448, Whistler, BC, Canada VON1BO<BR>Telephone: (604) 932   8302<BR>Facsimile: (604) 932 2288<BR>website: <A   href="http://www.pro-ride.com">www.pro-ride.com</A><BR>email: <A   href="mailto:snowboard@pro-ride.com">snowboard@pro-ride.com</A></DIV>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (12, 'AU', 'Snowboarding the World', '2000-01-01', '2002-04-23', '<P><STRONG>The snowboarding bible has arrived</STRONG></P>\n<P><IMG align=right alt="" border=0 hspace=5 \nsrc="http://www.boardtheworld.com/images/magazine/snowboarding_the_world/snowboarding_the_world..." \nstyle="HEIGHT: 142px; WIDTH: 115px" vspace=5>The most comprehensive snowboarding \nBOOK is now available.&nbsp; Snowboarding the world includes:</P>\n<UL>\n  <LI><STRONG>30</STRONG> Sequences and explanations of the best tricks on \n  kickers, pipes and rails</LI>\n  <LI>Terrain guide for <STRONG>50</STRONG> of the World\'s best snowboarding \n  destinations</LI>\n  <LI>6 essential artciles on snowboarding</LI>\n  <LI>over 600 <STRONG>colour</STRONG> photos in a high gloss presentation \n  across 256 pages.</LI></UL>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (13, 'AU', 'Falls Creek offers $399 Seasons Pass, Kat Boarding on Mt McKay and Australia\'s biggest snowmaking system', '2000-04-23', '2001-04-23', '<P>Falls Creek and Mt Hotham are going ballistic this  \nseason by offering a $399 seasons pass that allows you to ride everyday of the  \nseason except for Saturdays.&nbsp;&nbsp; Incredible value, especially for those  \nwanting to ride Falls and Hotham and avoid the Saturday punter mayhem, this  \nticket must be purchased before 1 June 2000. A normal seasons pass (all days  \npast) is $995 so you cant really beat this offer.</P> \n<P align=left>Massive news is that Falls will be operating a Kat Boarding  \noperation on Mt McKay.&nbsp; Two 3 hour sessions will happen daily.&nbsp; For  \n$59, you get taken to the top of Mt McKay by Kat, then ride down a vast  \nselection of steep and deep terrain the mountain. Once at the bottom of the run,  \nthe Kat will transport you up again for more of the same.</P> \n<P align=left>Finally, Falls will be tripling its Fan Gun snowmaking this season  \nestablishing Falls as having the largest snowmaking capabilities in  \nAustralia.&nbsp; Great news if this season is going to be as bad as the last  \n3!</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (14, 'NZ', 'Mt Hutt purchases a Pipe Magician II', '2000-05-08', '2000-06-08', '<P>The Pipe Magician pipe grooming machine was the talk of \nNew Zealand last year.&nbsp; It was designed and built in New Zealand by the \nhead of grooming from Coronet Peak.&nbsp;<IMG align=right border=1 hspace=5 \nsrc="/cgi-bin/images.php?id=1" \ntitle="Desc: The Pipe Magician in action. Location: Coronet Peak, NZ Photo: Coronet Peak" \nvspace=5> It\'s unique features enabled Coronet Peak to create and maintain one of the best pipes in New Zealand (if not the world).</P> <P>It was taken up to Mt Hutt several&nbsp; times to shape the pipe but this meant the Mt Hutt could vary from being down right terrible to totally amazing.</P> <P>This year the Mt Hutt pipe will be consistent throughout the whole season as Mt Hutt has purchased a Pipe Magician Mark II.&nbsp; So now you will be able to get in some quality pipe riding time whether you\'re in the north of the South Island or down around Queenstown.</P> <P>To find out more about the Pipe Magician <A href="features.php?id=3">click here</A>.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (16, 'AU', 'Balmoral Launches new Web Site', '2000-05-10', '2000-05-11', '<P>After much to and froing we\'ve got our arses into gear and put up the report from Vegetate 2000 at Mount Hood Meadows.</P> <P>This is one of the best events on the snowboarding \ncalendar and is for a damn good cause - <EM>making sure we don\'t suffocate from \nour own gases</EM> .&nbsp; <A href="competitionnews.php#3">Check out what happened here</A>.</P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (15, 'US', 'Moves and Shakes', '2000-05-09', '2000-06-09', '<P>&nbsp;Some recent rumours surfacing in the US are that  \nJeremy Jones (the freestyler) is moving from Smith Goggles to Iris.&nbsp; This  \nrepresents a pretty big coupe for Iris and it\'s team is now looking pretty  \nformidable.</P> \n<P align=left>In more eyewear news, Kip Arnet is leaving Arnet to start a new  \neyewear company in an already very saturated market.&nbsp; Word is that the  \ncompany will be Electric.</P> \n<P align=left>In other news it appears Sims has acquired the whole World  \nIndustries Team.&nbsp; With the likes of Rob "Sluggo" Boyce and Mark Frank on  \nthe Sims team things are definitely looking pretty rosy.&nbsp; Just goes to show  \nthat every cloud does has a silver lining.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (17, 'AU', 'Balmoral Launches new Web Site', '2000-05-10', '2000-05-11', '<P>test post, can be replaced with new media  \nrelease.</P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (18, 'US', 'Palmer gets his own Arcade Game', '2000-05-15', '2000-06-15', '<P>Snowboarder come mountain biker come skidoo superstar, Shaun Palmer is going   to have his very own arcade game. Judging by Palmer\'s previous successes, both   on the snow and in the business room the game will more than likely be a   hit.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (19, 'NZ', 'ISF Event comes to Cardrona, NZ', '2000-05-15', '2000-06-15', '<P>The International Snowboard Federation (ISF), the body that runs all the  \nmajor comps in Europe and the USA, is bringing an event down to New Zealand in  \n2000. The ISF event will be held at Cardrona between the 21<SUP>st</SUP> to  \n24<SUP>th</SUP> August. Some of the best riders in the world will be heading  \ndown for the event.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (20, 'US', 'Quiksilver sells worldwide trademark', '2000-05-15', '2001-05-15', '<P>The New York   based Quiksilver, Inc will purchase the worldwide trademark rights to the   Quiksilver brand name from the Australian based Quiksilver International.&nbsp;   The cost - a whopping $22 million dollars.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (21, 'NZ', 'Mt Potts reduces rate for mid-week', '2000-05-29', '2000-06-29', '<P>Because of a change in the price of transfers, a week pow pig now costs only  \n$1060 in a shared room and $1130 for a twin. For anyone who has already booked,  \na refund of the extra $40 will be settled in resort. Times for the new Shuttle  \nservice will soon be added to the updates page so keep checking please.</P> \n<P>Transfers are now available any week day as well as Saturdays.</P> \n<P>Due to demand, pencil bookings can be held for 1 week only, so firm up those  \nas soon as you can please.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (23, 'US', 'Go Mountain Biking In Sugarbush this summer', '2000-06-10', '2000-07-10', '<B><FONT face=Arial size=5></B></FONT> \n<P>The Mad River Valley is known worldwide for its challenging ski terrain. In  \nthe summer the Valley is home to an equally impressive array of mountain biking  \ntrails. Gentle, meandering dirt roads, abandoned logging trails and rugged,  \ntechnical single-track options can be found from Warren all the way north to  \nMiddlesex. The trail system is so extensive that even the most seasoned local  \nriders have not explored every single biking option the Mad River Valley has to  \noffer.</P> \n<P>Sugarbush Resort maintains the most complete mountain bike experience in the  \nMad River Valley. Obviously we’ve got trails, and lots of them. From the  \nSugarbush Cycling Center at the base of Lincoln Peak riders ages 13 and over can  \naccess a trail network that offers hundreds of acres of varying terrain. Whether  \nyou choose to ride the chairlift and take a nice mellow ride back down to the  \nbase or climb to the summit of Gadd Peak and rage back down on a twisting,  \ngnarly course through the woods, Sugarbush will send you home satisfied, and  \nmaybe even a little humbled.</P> \n<P>Our full service bike shop offers front and full-suspension Gary Fisher bike  \nrentals. The shop, located at the Cycling Center is open Saturdays &amp; Sundays  \nfrom June 24 through October 15. Shop hours are 9 a.m. to 5 p.m. and the Super  \nBravo lift runs from 10 a.m. to 4 p.m.</P> \n<P>Inertia Racing, formerly known as the Sugarbush Mountain Bike Team, is  \nentering its fourth year of competition. The team\'s reputation and presence are  \ngrowing along with the sport. Inertia Racing has 13 members of all ages and all  \nlevels of competitiveness. Last season 11 team members placed in the top five  \noverall in their class at the NORBA sanctioned Trail 66 Series, five of those  \nwon overall in their categories.</P> \n<P>Inertia Racing also works with landowners to help design and maintain trails  \nfor mountain bikers and hikers around the Mad River Valley in Vermont. </P> \n<P>This year Inertia Racing will be coming on stronger than ever. With mostly  \nSport and Expert riders, they will race the entire Trail 66 series as well as  \nthe SOBE Series. Stop by the team tent at each venue and say hello. Sugarbush  \nResort, American Skiing Company, Smith, Manitou, Shimano and Pedros proudly  \nsponsor Inertia Racing.</P> \n<P>Members of Inertia Racing will be on hand at this year’s Wicked Witch of the  \nEast Mountain Bike Race, July 15 and 16 at Sugarbush. The race, part of the  \nMobil Speedpass Trail 66 series, is being held at Lincoln Peak for the tenth  \nconsecutive year. The event has grown from a simple race to become a two-day  \nmountain bike festival. The race itself includes Trail 66 NORBA North Atlantic  \nRegional Championships in downhill, dual slalom and cross-country. This is a  \ngreat event that promises to capture the fancy of everyone from die-hard fat  \ntire junkies to first time spectators.</P> \n<P>Get the picture? Sugarbush and mountain biking go hand-in-hand all summer  \nlong and whether you’re in it for an adrenaline rush, a championship victory or  \njust some nice cruising and scenery we’ve got you covered. Give us a call at  \n(802) 583-6572, visit us online at <A  \nhref="http://www.sugarbush.com/">www.sugarbush.com</A> or throw your bike in the  \ncar and come see for yourself. It’s time you experienced mountain biking "pure  \nVermont" style. </P><B> \n<P>Rates</B></P> \n<P>1 lift ride $5.00<BR>1/2 day trail &amp; lift $15.00<BR>1/2 day trail, lift  \n&amp; bike $35.00<BR>Full day trail &amp; lift $25.00<BR>Full day trail, lift  \n&amp; bike $45.00<BR>Full day trail, lift &amp; bike full suspension  \n$55.00<BR>Bike rental only (4 hours) $20.00<BR>Bike rental only (full day)  \n$30.00<BR>Full suspension bike rental (4 hours) $30.00<BR>Full suspension bike  \nrental (full day) $40.00</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (22, 'US', 'Summer at the Canyons', '2000-05-29', '2000-06-29', '<P>If you can\'t get to a summer camp or down under to Oz or NZ this summer then  \nwhy not head to The Canyons.&nbsp;&nbsp; They have a full summer program  \nincluding:</P> \n<P><EM>Hiking and Mountain Biking</EM></P> \n<P>The Canyons offers limited mountain bike tours and guided hikes for guests.  \nHikers of all ages and abilities can explore wilderness at The Canyons. Hiking  \ntrails include Ninety-Nine-90, Tombstone and High Meadow. For more information  \ncontact the concierge at the Grand Summit Resort Hotel and Conference Center at  \n(435) 615-8042.</P> \n<P><EM>Hot-Air Balloon Rides</EM></P> \n<P>The Canyons offers hot-air balloon rides through Balloon Affaire. Take to the  \nair for a memorable experience with Balloon Affaire. Ascend with the sunrise  \nabove the Wasatch Range of the Rocky Mountains that surround The Canyons.  \nExperience the serenity as you gently drift in the winds. All pilots are FAA  \ncertified commercial pilots. For reservations or more information please contact  \nThe Canyons at (888) CANYONS or the concierge at the Grand Summit Resort Hotel  \nand Conference Center at (435) 615-8042.</P> \n<P>Check it all out at <A  \nhref="http://www.thecanyons.com">www.thecanyons.com</A>.</P> \n<P>&nbsp;</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (24, 'AU', 'Mt Buller has first halfpipe in Southern Hemisphere for 2000', '2000-06-13', '2000-07-13', '<P>It sounds too good to be true but we can assure you that it is. Mt Buller has   opened winter 2000 with a 80 meter long, 3 meter deep halfpipe. Thanks to an   abondance of natural snow, the crew at Mt Buller have been able to push together   a good quality pipe shaped by Kat and hand. This leaves traditional halfpipe   champion resort Perisher Blue with plenty to chase as Buller makes a concerted   effort to prove to snowboarders that it is the best snowboarding resort in   Australia. Also, rumour has it that Buller at looking at purchasing the "Pipe   Magician" shaping machine from New Zealand. The Pipe Magician was developed by   the staff at Coronet Peak in New Zealand and has been rated by Board the World   as being as good, if not better than the "Pipe Dragon". This being the case, it   may be that Buller will provide Aussie snowboarders what they have been dreaming   of for nearly a decade. Fingers crossed. In the meantime, head to Buller for   some early season pipe action.</P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (25, 'US', 'Jackson Hole Opens Tram Access', '2000-06-15', '2000-07-15', '<P>When the&nbsp;summer season opens at Jackson this year  \nsnowboarders will be able to access Cody Bowl and the surrounding backcountry  \nvia the aerial tram this summer. Cody Bowl is recommended for experts only and  \nis located south of the Resort in Bridger-Teton National Forest. The aerial tram  \nwill open for the summer season on&nbsp;May 26, 2000. Just another potential  \nsummer adventure</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (26, 'US', 'Mammoth Signs Deal with Gotcha Glacier', '2000-06-15', '2000-07-15', '<P>Gotcha Glacier which opens in 2002 and will be America\'s  \nfirst indoor snowboard and surf park&nbsp;has recently signed a management deal  \nwith Mammoth Mountain.&nbsp; Mammoth will be responsible for snowmaking,  \ngrooming and terrain park contruction. Judging by their on-mountain experience  \nthey certainly have the goods.</P> \n<P>If you are interested, when completed, the Glacier will house a snowboard  \nhalfpipe, surf and skate park, North America’s largest climbing wall, indoor  \nskydiving, bowling alley, scuba diving, and more than 190,000 square feet of  \nentertainment, retail, and restaurant space. Certainly sounds like a pretty  \nawesome place.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (27, 'NZ', 'Cardrona Opens First Pipe for 2000', '2000-06-26', '2000-07-26', '<P><IMG align=left border=1 hspace=5 \nsrc="/cgi-bin/images.php?id=1" \ntitle="Desc: The Pipe Magician in action. Location: Coronet Peak, NZ Photo: Coronet Peak" \nvspace=5>Cardrona opened it\'s International Halfpipe over the weekend and was \nthe first resort in NZ to open a pipe.&nbsp; Judging by this photo from Marketing Manager, Nigel Kerr things are certainly looking pretty good for the season.</P> <P>Cardrona has a current base of 20-30cm at the bottom of the double chair and 100cm at the top of the mountain.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (28, 'NZ', 'Cardrona opens the \'Super Rookie\'', '2000-07-09', '2001-11-09', '<IMG align=right border=1 hspace=5 src="/cgi-bin/images.php?id=2" title="Desc: The new Super Rookies is shaped while Jon Malcolm-Smith, head of Cardrona\'s pipe team watches on. Location: Cardona, NZ Photo: Nigel Kerr" vspace=5>Picture shows the third of Cardrona\'s four halfpipes, the so called \'Super Rookie\' being shaped up by Kassbohrer cutting blade today. The pipe is the third that Cardrona has opened already this season. The International pipe has been shaped up since opening day. The Johnny pipe joined it on the 1st of July. And now the new \'Super Rookie\' (which needs a name change) will open tomorrow. This will leave only the \'Monster\' still to be shaped up. On the snow is Jon Malcolm-Smith, 3 times NZ national snowboard champion and now head of Cardrona\'s pipe team. Driving the groomer is Dave Collett, grooming supervisor at Cardrona. <P>This pipe was rebuilt over summer and has gone from being a learners pipe to a full length ISF halfpipe. It is huge!. The shaping attachment is 3.5metres long! "It will be the competition pipe of choice. The scale of the transition and height of the walls relative to the slope of the pipe is perfect" commented Jon.</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (29, 'NZ', 'Jibbing Action At Coronet', '2000-07-09', '2000-08-09', '<IMG align=right border=1 hspace=5 src="/cgi-bin/images.php?id=3" title="Desc: A local sliding a rail in the Coronet Park Location: Coronet Peak, NZ Photo: James Helmore" vspace=5>If you\'re hanging for some jibbing action then Coronet Peak \non New Zealand\'s South Island has some pretty cool hand rails happening.&nbsp; \nCheck out the photo - trippy or what!', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (30, 'NZ', 'Cardona, NZ is fully covered', '2000-07-19', '2001-07-19', '<FONT size=2> <P>Well, yet another sunny day. Basically the weather pattern so far for all of July has been clear, sunny and pretty much calm. It has been fantastic for families with young kids as well as ensuring you go back to work with a bit of a racoon face!</P> <P>All main trails are open and being groomed daily. Conditions are best described as winter snow on a firm base. There are some patches of hard pack snow in places lower down but overall conditions are steadily improving as frosts dig in to the base. Off piste is variable and really only suitable for advanced skiers and boarders with icy patches and&nbsp; rough surface Current snow base is between 30 - 85cm with 80% total skiable cover. All lifts and facilities are operating.&nbsp;</P> <P>Three pipes are open and operating on rotation daily. The pipes are in great shape and catering for plenty of Canterbury and Queenstown refugees. Also Jim Mangan arrived over the weekend and the Wonderpark 2000 is starting to shape up. Realistically a few hits will be open this weekend with the rest of the park ready to go a week after that. So, looking white and having a pretty good time up here at present.</P></FONT>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (31, 'UK', 'Major Comp set for Manchester, England', '2000-07-25', '2000-08-25', '<FONT size=2>Manchester, England will host the worlds first</FONT> <FONT size=2>formula-f3ree ( f-f3 ) competition.</FONT> <FONT size=2>Combining freestyle boarding and freestyle ski, &nbsp;f-f3 delivers a format</FONT> <FONT size=2>clash right in the heart of one of Europe¹s major cities. <P>This unique competition takes place on the UK\'s biggest ever urban real</FONT> <FONT size=2>snow slope over three days.</FONT> <FONT size=2>The big-air festival includes :&nbsp;&nbsp;the board-it.com f-f3 snowboarding</FONT> <FONT size=2>championship,&nbsp;the 1ski.com freestyle ski \nchampionship,&nbsp;the f-f3 constructors championship,&nbsp;the f-f3 head to \nhead format clash, board v ski.. who rules?</P> <P>Not content with providing just real snow action, f-f3 will feature a</FONT> <FONT size=2>three day music festival combining all the latest in urban sounds and</FONT> <FONT size=2>beats.</FONT> <FONT size=2>The festival includes skateboard, inline and BMX, speed climbing,</FONT> <FONT size=2>abseiling, &nbsp;and interactive games.</FONT></P><FONT size=2> <P>BOARD FIELD :</P> <P>F- F3 are putting an impressive field of UK and International riders</FONT> <FONT size=2>onto the real snow slope. Each team will be made up of one international</FONT> <FONT size=2>rider and two UK boarders, encouraging the development of UK boarding by</FONT> <FONT size=2>putting it in direct \ncompetition with international stars. Riders appearing include:</P> <P>Jakob Whillemson (SWE), David Benedek (GER), Roman De Marchi (CH),</FONT> <FONT size=2>Stefan Gimpl (AUT), Arild Brun Kjeldaas (NOR), and Joachim Koffler. The</FONT> <FONT size=2>UK is represented by the likes of: James Stentiford, Simon Brass, Rhys</FONT> <FONT size=2>Crabtree, Jonno Verity, Gary Greensheilds, Sascha Hamm, Danny Wheeler,</FONT> <FONT size=2>Elliot Neave, and many more.</P> <P>THREE DAYS OF LIVE MUSIC 29.09.00 - 01.10.00</P> <P>Centre stage at the base of the slope, the f-f3 live stage is the focal</FONT> <FONT size=2>point of the arena. The slope at 100ft x 200ft provides a spectacular</FONT> <FONT size=2>backdrop for live performance. All slope activity and competition stops</FONT> <FONT size=2>while the artists and bands entertain the crowd.</FONT></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (32, 'AU', 'Falls Creek Rundown', '2000-07-28', '2000-08-28', '<P><STRONG>By Clive Dickerson (aka Dicko)</STRONG></P> <P><EM>Local Falls Creek rider, Clive Dickerson gives us the low down on the scene at Falls</EM></P> <P>As a freestyle and all-mountain Hotham rider, this is my first official Season at Falls and let me tell you, I\'m stoked !&nbsp; If you hear anyone saying Falls is not steep, by God, let them try some of the lines down Mt. McKay and that will shut them up !&nbsp;&nbsp; Six of us hiked there yesterday and it took, from leaving top of Ruined Castle, about 30 - 45 mins - depending on fitness level.&nbsp;&nbsp;&nbsp; Although great sunny day, Kat-skiing was not happening due to massive dump over the last week [ultimate dry powder snow] BUT it was worth it - steep and deep !<BR>&nbsp;<BR>What attracted me most to Falls?&nbsp; Had to be the Snowboard Park - really missing it this week, not running due again to heavy snowfall but, have to say,&nbsp; Peter Lucas is doing a great job - he\'s really on the ball catering for everyone\'s needs using our feedback to make positive things happen ...<BR>&nbsp;<BR>Besides the resident Gurus [PC still a ripping free rider !] this Season has attracted a whole bunch of different styles riding at a high standard e.g. Swedish rider Mario is into switch flat spins, switch tail grabs, 540\'s, big back flips, variations on flat spinning - an all round extreme rider.&nbsp; Its good to have him up here .. then we have a young guy Drew showing heaps of potential pinning all his rodeo\'s with a whole new bag full of tricks.&nbsp; He rides in control and an up and coming freestyler - we\'ll be seeing a lot of him in years to come ...<BR>&nbsp;<BR>Is Falls all about Boarding?&nbsp; No, the village atmosphere changes by night when the Frying Pan Inn and the Man really rock with great bands such as this month alone, BOMBA - HEADSPACE and THE WHITLAMS not forgetting the Twelfth Winter Ball when over two hundred people were partying through the night.<BR>&nbsp;<BR>Falls Creek is a very progressive mountain offering a variety of different styles and riding, its laid back, great vibes ....&nbsp; just come on up and ride.<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (33, 'AU', 'Kat Boarding at Falls', '2000-08-04', '2000-09-04', '<P><EM>Falls Creek local, Clive&nbsp;Dickerson gives us the lowdown on what it\'s like to go Kat-Boarding on Mt McKay</EM></P> <P>This week at Falls - a big one - sunny weather allowed us to enjoy the previous weeks\' huge snowfalls to the max. Stoked to have the Park so quickly re-opened thanks to the full-time efforts of two guys and daily maintenance. Everyone up there checking out the spines, a heap of assorted sized table tops and a massive<BR>quarter-pipe. </P> <P>Snow conditions excellent, Chris R still doing a series of back-country hiking with the boys a week and a half after last snowfall. </P> <P>Brett Stanley, photographer, met me to shoot at the Park and had to check out Mt. McKay [where we scored some free Kat-skiing!] For those of you not so lucky, the cost is about $59 per half day but in three hours, you could get 8 to 12 runs down the steep powder lines depending on how soon after the last snowfall you decided to go. For us, five days after the last fall, they were still taking us down fresh lines.</P> <P>There are massive expensive Kats that would cost any mountain a heap of cash but we were more impressed to see that the Falls Kat was one of their old groomers custom re-built with a 10-seater cabin, neat windows and a cool little stereo.</P> <P>We were picked up from top of Ruin Castle on the Kat and from there they took us half way up to McKay finding a few lines on the way before driving further up for two or three more runs with more fresh, then onto the top of McKay. We were&nbsp; there to shoot but, when you usually arrive at the top, you can hook up with a guide willing to help with the decision of where to go. The Xtreme dudes go down the South face and those looking for thrills have plenty of untracked runs to choose from plus there are accessible cliffs, rock drop offs, little knolls everywhere - just tell the guide how steep you want to go. By the time you get down to the bottom, the Kat will pick you up and you can bet you\'ll be ready to do it all again, and again, and again!!</P> <P>ADVICE! When you get the chance to Kat-ski McKay, bring a mixed tape of your favourite tunes to pump you up whilst you\'re amping yourself for those crazy lines! </P> <P>Socially, we had a big one on Tuesday at Cedarwood \'S.A. Night\' with half-priced&nbsp; Coopers. This coming Tuesday, Falls welcomes N.Z. band \'Shehad\' and on a local note, we\'ll be sharing birthday celebrations with Jill &amp; Mex, Raymo, Daxys and Jeremy [any excuse!]</P> <P>This weekend will be a quiet one at Falls, everyone going to Buller comp but next weekend, the Big Air back here will draw the crowds, until then .....</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (34, 'AU', 'A Big Week at Falls Creek', '2000-08-16', '2000-09-16', '<P><EM>Falls Creek correspondent, Clive Dickerson, files the latest news live from Falls Creek</EM></P> <P>This last week at Falls has been a BIG one - last Tuesday we saw \'Shihad\' the top NZ band that went off at The Man - excellent live performance.&nbsp; Wednesday we enjoyed a laid back evening at Cedarwood\'s \'percussion jam night\' listening to the talent of our local musos... followed by the HUGE snowboard events over the weekend.<BR>&nbsp;<BR>Falls Creek locals were joined by interstate and overseas competitors all eager to be part of the ANTICOL FORCE CHALLENGE, a massive turnout for Boardercross, Slopestyle, Big Air and Giant Slalom.<BR>&nbsp;<BR>The weekend started off with the Boardercross where officials have to be congratulated for constructing the course under white-out snow conditions just prior to the event but, they were rewarded on the day with the sun out and perfect blue skies - the course was spot on and the riders stoked.&nbsp; Senior winners were Damo Liddy [Shay Paxton on the podium taking 3rd] and for the women, Candice Drouin.&nbsp; Junior winners were young Drew Baker and female, Holly Crawford.&nbsp; Excellent to see the high standard coming up with our Australian juniors.<BR>&nbsp;<BR>Saturday\'s slopestyle set-up was fantastic, 2 spines, 3 tabletops and a 1/4 pipe .. the course was excellent although a long day with over 100 competitors having their two runs but, it turned out well.&nbsp;&nbsp; The juniors\' performance showed the old crew that the grommits are right up there!&nbsp;&nbsp; Ben Bright taking first place and for the junior females, Holly Crawford.&nbsp;&nbsp; Local Falls rider Christian Mariethos took fourth place in male seniors ripping it up but the day had to go to Nick Gregory - senior female was taken out by Emily Thomas.&nbsp; Overall, the riders were pretty rapped - it was tough competitively with the high standard but this made for excellent crowd appeal.<BR>&nbsp;<BR>BIG AIR contest, boy that was a good night!&nbsp;&nbsp; Saturday, under lights, outside the summit chair next to the Frying Pan - the jump was quite big with three different kickers to choose from;&nbsp; a few people got scared because the jump was quite hard but, it was nice and steep and there were still plenty of competitors.&nbsp;&nbsp; At first, the Big Air crowd was quiet but thanks to an excellent commentator who REALLY got the crowd pumped up, the second finals had the crowd going off seeing some great action with the grommits and seniors yet again.&nbsp;&nbsp;&nbsp; Senior female event was Candice first - again - and Luke Banwell took the male seniors first place - this was all the more incredible because Luke had broken his collar-bone before the training even started for slopestyle and not only rocked up for the Big Air but won the event - incredible!&nbsp;&nbsp; Shay Paxton made No. 2.<BR>&nbsp;<BR>Ski-ers were not forgotten and their event was well taken out by Aaron Place - junior male Will Slade and junior female Torah Bright - the evening finished [as far as events were concerned] with fireworks but continued [as far as most people were concerned] a few steps away at The Frying Pan Inn [both inside and out] and others chose The Man where Falls most popular percussion band THE HOAX performed to a great crowd.&nbsp;&nbsp; The patrons were definitely feeling fiesty as locals mixed with competitors and drunk more than they should of [as usual] ! !<BR>&nbsp;<BR>The weekend finished on Sunday with the Giant Slalom.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tuesday night [tonight] here at The Man we have the \'Cosmic Psychos\' and the Cedarwood \'half price Coopers\' ... and that rounds up the latest news from Falls Creek !<BR>&nbsp; </P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (35, 'UK', 'F-F3 Freestyle Festival gets closer', '2000-08-23', '2000-09-23', '<FONT face="Courier New" size=2> <P>The board-it.com F-F3 brings together the best international snowboarders and free skiers in front of a projected festival audience of 30,000 over three days in Manchester City Centre.</P> <P>The F-F3 Festival includes:</P> <P>the board-it.com F- F3 snowboarding championship</P> <P>the 1ski.com freestyle ski championship</P> <P>the F-F3 constructors\' championship</P> <P>the F-F3 head to head format clash, board v ski.. who rules ?</P> <P>Not content with the UK\'s biggest real-snow slope, and the best field of riders ever assembled in the Britain, F-F3 targets world-class sk8rs, BMX and inliners, alongside top bands and DJs to perform in this unique urban festival. </P> <P>F-F3 is platform convergence in the real world: </P> <P>MUSIC * SPORT * VISUALS * BEATS.</P> <P>They have already confirmed Goldie, Morcheeba, Smith + Mighty, Alpinestars, Justin Robertson, Graeme Park, Alistair Whitehead, Tailgunner, AIM, Only Child, Marcus Intallex, Fat City Allstars, Finga Thing, Grand Central, Elbow, Fat Lip and Immaculate.</P> <P>Club nights Bugged Out, First Light and NY Sushi have confirmed their association with F-F3 over the festival.</P> <P>F-F3 has secured some of the world\'s best skiers and boarders to compete in Manchester: Jean - Francois Cusson (CAN) - probably the biggest name in freestyle skiing and the 1999 winner of two gold medals in the X-Games, and gold at the Mad Masters event in France. He will be competing head to head with boarders such as Stefan Gimple (AUT), winner of the 1999 Innsbruck Air and Style competition, Roman di Marchi (CH), winner of the 1999 Arctic Challenge, Steve Baily, the British Big Air Champion, and Sascha Hamm, the British Half-Pipe Champion.</P></FONT><FONT size=2> <P>On the F-F3 vert ramp sk8ers such as Peter King, the Vans Amateur World No.2, and Jocka Olson, the U.G. High Air Champion, will be showing off their tricks alongside BMXrs including U.G. Vert Champion Zach Shaw, as well as top class in-liners.</P><FONT face="Courier New" size=2> <P><STRONG><U>TICKET PRICES</U></STRONG></P> <P>DAY ADULT: £ 10.00<BR>DAY NUS: £ 8.00<BR>DAY CHILD: £ 5.00<BR>DAY FAMILY: £ 20.00 (TWO ADULT + ONE CHILD UNDER15)<BR>3 DAY PASS: £ 20.00 (ADULT + NUS)</P> <P><STRONG><U>Ticket Sales</U></STRONG></P> <P>Tickets for The Board-It.com F-F3 Festival can be bought on line at:</P> <UL> <LI><A href="http://www.wayahead.com">www.wayahead.com</A> <LI><A href="http://www.aloud.com">www.aloud.com</A> <LI><A href="http://www.ticketmaster.co.uk">www.ticketmaster.co.uk</A> <LI><A href="http://www.ticketline.co.uk">www.ticketline.co.uk</A></LI></UL></FONT></FONT>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (38, 'HU', 'Creek-surfing comes to a summer slope near you', '2000-09-08', '2000-10-08', '<P><IMG align=right border=1 hspace=5 src="/cgi-bin/images.php?id=20" \ntitle="Desc: The inventor of the creek-surfer demonstrating his invention. Location: Hungary, HU Photo: Unknown" vspace=5>That\'s right, there\'s a new lifestyle sport on the \nmap and it\'s called creek-surfing.</P> \n<P>Invented in Hungary, creek-surfing involves constructing an artificial slope \nout of scaffolding. Water is then run down the slope.&nbsp; Using a special \ndevice the water is actually kept on the slope rather than running off.&nbsp; \nThus by keeping the water on the slope it is possible to ride down on a \nsnowboard.</P> \n<P>The inventors have&nbsp; said, "The invention is very simply, the result is \nthundering."&nbsp; Apparently the feeling is very like skiing or \nsnowboarding</P> \n<P>Hopefully if the invention takes off you won\'t have to pay excessively high \nfees to use the slope.</P> \n<P>To find out more about creek surfing visit the website at <A \nhref="/cgi-bin/exlink.php?url=www.creeksurfing.com">www.creeksurfing.com</A>.<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (36, 'AU', 'The Cosmic Psychos hit Falls', '2000-08-25', '2000-09-25', '<P><EM>Local Correspondent, Clive Dickerson reports from Falls Creek</EM></P> <P>Social life at Falls continues in its usual frantic way welcoming the Cosmic Psychos at the Man last Tuesday - good to see the old fellas still rockin\' on and drawing the crowds!&nbsp; The ZZ Top look-alike Mixer added to their raunchy image...<BR>&nbsp;<BR>Saturday had everyone checking out who would qualify for the the Mogul Masters and the finals were held under lights on Saturday night on the summit - the event pulled big crowds again and Frying Pan patrons had a great view that most likely grew dimmer with all the alcohol as the night progressed!<BR>&nbsp;<BR>Unfortunately [ ! ! ] there were no big bingles or mighty stacks just a few bales but the crowd were not disappointed as the competition itself was heavy duty with big international competitors [Canadians, Frenchies, Germans] not forgetting the Buller Team and the Hotham Team.&nbsp;&nbsp; Jade Vaughan, Canadian took out first place in the Men\'s moguls with local Falls rider Tom Costa taking 6th place;&nbsp;&nbsp; women\'s Moguls finalist was Jane Sexton.&nbsp;&nbsp;&nbsp; Heavy night - great ...<BR>&nbsp;<BR>Wednesday we welcomed the Quicksilver pro Team arriving for the 1/4 pipe competition for locals and pro teams - more details later.&nbsp; We have a front travelling in with a promise of an even bigger snowfall for the comp but its being held at the top of the Gully Chair so will go ahead no matter what conditions.&nbsp; Log in next week for more Falls news .....</P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (37, 'AU', 'The Snow continues to fall at Falls', '2000-08-31', '2000-10-01', '<P><EM>Local correspondent, Clive Dickerson updates us with what\'s happening at Falls</EM></P> <P>Falls Creek welcomed the Quicksilver tour last Wednesday with an enthusiastic demo at the 1/4pipe on top of the Gulley Chair;&nbsp; Jason Haynes and most of the Quicki pro\'s were down and all the crew were busting it out towed in by skiddo.&nbsp;&nbsp; The Team did not compete in the 1/4pipe comp, this was only for locals.&nbsp; Turned out well - 3rd place PC, 2nd Drew and 1st place Mario.<BR>&nbsp;<BR>While this was going on, I visited Mt. Hotham for the Heinz Ketchup Snowcross and Big Air.&nbsp; This was a competition featuring Victoria v New South Wales with both the boardercross and big air results combined.&nbsp;&nbsp; Regrettably for us, the NSW crew took out the Cup!&nbsp;&nbsp;&nbsp; For the Big Air, a heap of snow had been pushed up outside Swindlers to make a reasonable sized jump - the only problem being heavy ice leading to rock hard landings and a few injuries - some competitors pulled out because of these conditions.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; But both events were well organised and the general feel of the comps positive, the results were:&nbsp; 1st place for the Women, Emily Thomas from NSW; Sasha Ryzy 2nd place and 3rd our Karen Lyons from Victoria.&nbsp;&nbsp; With the Mens, we had John Fletcher, NSW taking out the overall 1st, 2nd Kym Christiansen from Norway representing Victoria.&nbsp;&nbsp; 3rd place was shared equally between Chris Coulter from USA representing Victoria and local Hotham rider Tony Graham.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>&nbsp;<BR>Tonight [Wednesday 30th] back at Falls all the locals are clutching their tickets and moving to The Man at 8.30 to see the popular band GROOVE TERMINATORS accompanied by ENDORPHIN - it\'ll be a good one with everyone charging!!&nbsp; <BR>&nbsp;<BR>Conditions have been snowy at Falls and at Hotham with mainly light snow for the last couple of weeks with an occasional sunny break.&nbsp; How much more snow can we get? [But whose complaining!!] Tune in next week ....</P>', 0, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (39, 'NZ', '85cm of fresh at Treble Cone', '2000-09-10', '2000-10-01', 'After 48 hours of continuous snow, the skies have cleared at Treble Cone \nNew Zealand to reveal 85cm (about 34 inches) of fresh powder.&nbsp; Spring in \nNew Zealand is going to be massive.', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (40, 'US', 'Burton joins Free the Snow', '2000-09-12', '2000-10-12', '<P><IMG align=right border=1 hspace=5 src="/cgi-bin/images.php?id=26" \nvspace=5>Burton Snowboards has joined the fight to "Free the Snow" at three of \nthe U.S.\' top ski resorts - Taos in New Mexico, Alta in Utah, and Ajax part of \nAspen Mountain Resort in Colorado.&nbsp; Two other mountains, Mad River Glenn in \nVermont, and Deer Valley in Utah also do not allow snowboarding but will not be \npursued by Free the Snow as these mountains are on private land.&nbsp; In \nsupport of the campaign, Burton is opening up its creative and legal resources \nto help Free the Snow further its cause and allow snow enthusiasts everywhere \nthe right to bear boards.</P> \n<P>Throughout most of the world, snowboarders and skiers coexist on the \nmountainside - each athlete free to pursue his or her favorite sport.&nbsp; Yet, \nout of more than 500 ski areas in North America, these five resorts still do not \nallow snowboarders, citing everything from "the terrain is too dangerous" to \n"snowboarders ruin the mountain\'s topography." </P> \n<P>During upcoming months, Burton/Free the Snow T-shirts and Stickers will be \nmade available at events across the country and riders are encouraged to pick \nthem up.&nbsp; All money from T-shirt sales will go to support Free the \nSnow.&nbsp; In addition, the company plans to include Free the Snow in future \nadvertisements and Burton catalogs.<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (41, 'NZ', 'Coronet gets huge dumps for Spring', '2000-09-12', '2000-10-12', '<P><IMG align=left border=1 hspace=5 src="/cgi-bin/images.php?id=27" \nvspace=5>Coronet Peak has received 60 to 70cm of new winter snow in the last few \ndays and has 100% cover over the entire mountain. Now is the time to get up and \nenjoy some of the best skiing and snowboarding of the season!!</P> \n<P>All the classic Coronet Peak runs are in great shape. Sarah Sue, Back Bowls \nand Exchange Drop putting smiles on the faces of advanced skiers and \nsnowboarders.&nbsp; Greengates, Wall St, Million Dollar and the M1 are providing \ngreat fun for intermediates and the Big Easy is in perfect shape for beginners \nand novices to learn on<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (42, 'AU', 'Buller Hits Spring', '2000-09-20', '2000-10-20', '<P>Local Mt Buller correspondent, Anthony Crute, provides a run down on what\'s \nhappening in the Victorian Alps</P> \n<P>Mt Buller is currently entering into the spring session with firm conditions \nin the mornings and softening by mid morning. In actuality it has been pretty \ngood with excellent boarding during the middle of the day before the snow turns \nto glue. Everything is covered. There seems to be a conspirator who has been \ngoing around the mountain building huge jumps over the cat tracks and crazy rail \nslides. The North side is starting to look like Blackcomb\'s Lakeside Bowl. The \nhalf pipe has also been worked on by hand giving the opportunity to catch some \nair every few days. </P> \n<P>For those with a little more cunning there have been a couple of backcountry \nturns placed where they haven\'t been for several years. Its worth a look so \nbring your shovel and bucket and have a great day at the beach. NB: check the \nweather map first and don\'t forget that if you are coming to Whistler check out \n<A href="/cgi-bin/exlink.php?url=www.pro-ride.com">www.pro-ride.com</A>.<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (43, 'US', 'Burton Revolutionises the Boot Fit', '2000-09-20', '2000-10-20', '<P>Burton Snowboards has revolutionized the way snowboard boots fit with the new \n1:1 Evolasts. A&nbsp; snowboard boot should be an extension of the person \nwearing it - snug fitting, stylie, and cush enough to wear all day long. \nBurton\'s new EvoLast\'s 1:1 shell-to-liner ratio raises the standard in comfort, \nfit, and rider response. A top to bottom overhaul of the entire 2001 boot line \nmeans every boot from the top of the line Ion to the entry level Moto has a \nperfectly sized fit; no more shaving down liners or placing a size 9.5 liner \ninto a size 10 shell. </P> \n<P>Boot Category Manger, Chris Kuhr, described the re-engineering best when he \nannounced, "The largest investment outside of the financial one, was the time \nand effort by the entire team. Product Managers, developers and engineers all \nworked to overhaul the entire boot program from top to bottom in record time. \nLast shapes were tried and scrapped, prototypes were tested around the world, \nand countless hours of computer engineering time went into the project. It is a \nhuge accomplishment when you consider that we developed a whole new last shape, \nadded 1:1 sizing, and designed all new shells, liners, outsoles, tested them, \nand then put them into production . . . all in one season."</P> \n<P>In 2001, Burton will feature the EvoLast in three new liner constructions. \nThe Pinnacle liner features a PU construction, custom fitting foam, and a \nmoisture wicking fleece lining for the ultimate in response and durable comfort. \nThe Matrix liner is a hybrid between a PU and stitched construction with a lace \nup internal cuff allowing the energy response demanded by our riders, and cushy \ncomfort right out of the box. The Matrix liner gives riders lightweight PU \npowered performance that won\'t break down over time.<BR></P>', 1, 0);
INSERT INTO `tblNews` (`NewsID`, `CountryCode`, `Title`, `StartDate`, `EndDate`, `Text`, `Active`, `Author`) VALUES (44, 'AU', 'Stanley\'s Spring Quarterpipe Session', '2000-09-20', '2000-10-20', '<P><IMG align=right border=1 hspace=5 src="/images/countries/australia/au_2000/au_thredbo_stanley_quarterpipe_mouse.jpg" \nvspace=5 alt="Mouse going large on the Stanley\'s Q-Pipe">The biggest quarterpipe ever built in the Aussie backcountry, or so \nthey claimed.&nbsp; Some of the local Jindabyne crew had been working feverishly \non their new jump creation in Stanleys Gully, just outside the ski area boundary \nof Thredbo.&nbsp; The word got out that they had built a monstrosity. A \nquarterpipe to challenge even some of the might q-pipes found in the Whistler \nbackcountry of British Columbia.</P> \n<P><IMG align=left border=1 hspace=5 src="/images/countries/australia/au_2000/au_thredbo_stanley_quarterpipe.jpg" \nvspace=5 alt="The Stanley\'s Quarterpipe">Well, the word eventually trickled down the grapevine and found it\'s \nway through our mass of humming web servers and in to our Outlook \nin-boxes.&nbsp; We decided the rumour was just too good to let go so we decided \nit was time to escape the hazy fluroscent lights of our offices and see this \ncreation for ourselves.</P> \n<P>As with most rumours, this one had more air than a Michaelchuck \nheave-ho.&nbsp; The quarterpipe that the Jindy crew had spent days building was \nbig, but it was not 50-foot as some people were suggesting.&nbsp; However, it \nwas easily as good as a quarterpipe you might find in the Whistler \nbackcountry.&nbsp; It stood about 12 feet high with a nice long trannie that \nalmost went to vert.&nbsp; It certainly looked intimidating.</P> \n<P><IMG align=right border=1 hspace=5 src="/images/countries/australia/au_2000/au_thredbo_stanley_quarterpipe_ben_stale.jpg" \nvspace=5 alt="Local Thredbo rider, Ben H, poking one out at Stanley\'s">With the sun out and blue sky providing the perfect backdrop we decided \nto take the quarterpipe for a test run.&nbsp; The nice smooth tranny and lofty \nlip provided consistent 15-foot airs with plenty of hang time.&nbsp; The ver
[19 Aug 2004 3:59] Matt Lord
Dear Sir,

Can you attach the dumpfile to the bug report?  If it's over 200k you can put it on ftp.mysql.com 
using the anonymous account and just let me know the name of the file.  It got cut off in your 
paste.

Best Regards
[19 Aug 2004 15:03] Justin Drerup
Hi Matthew, I have uploaded tblNews.sql to the anonymous account at ftp.mysql.com.  It is in the /pub/mysql/incoming directory.

Hope this helps and feel free to contact me again if you need any further information.

Thanks.
[23 Aug 2004 2:22] Matt Lord
Hi, I verified this using the latest ByteFX release from the bytefx website and mysql 4.1.3.

Console.WriteLine( clReader.GetValue(4) )  

This prints an empty string instead of "0000-00-00" when the column actually
contains all zeroes.

Best Regards
[26 Aug 2004 5:42] Reggie Burnett
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

This was fixed by returning a MySqlDateTime object (new) from GetValue when the underlying column type is datetime.  The reason this is necessary is that MySQL allows zeros in a datetime column but .NET (and Java) can't hold a zero value in a datetime object.  In order for generic .ToString() to work, a different object had to be used.

Also check out the RoundZeroDateTime connection string option for how to handle converting MySqlDateTime to DateTime.