| Bug #5097 | DataReader returning NULL for time column | ||
|---|---|---|---|
| Submitted: | 18 Aug 2004 21:03 | Modified: | 26 Aug 2004 7:42 |
| Reporter: | Matthew Aznoe | ||
| Status: | Closed | ||
| Category: | Connector/Net | Severity: | S3 (Non-critical) |
| Version: | ByteFX 0.76 | OS: | Microsoft Windows (Windows XP) |
| Assigned to: | Reggie Burnett | Target Version: | |
[19 Aug 2004 2: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 and image
in? 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. 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.
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> 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.
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> <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: Jennifer Sweeney (212) 780-1900<BR>Burton Snowboards: 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. 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. The \npipe is a whopping <STRONG>425
feet long with 17-foot \ntransitions</STRONG>. 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. 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> <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> <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 ( 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> <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> </DIV><DIV>Sunday is the last day with another BX - totally
\ninvitational - should be worth a look.</DIV><DIV> </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. 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. 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. Two 3 hour sessions will happen daily. 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. 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. It was designed and built in New Zealand by the \nhead of
grooming from Coronet Peak. <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 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. 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> . <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> Some recent rumours surfacing in the US are that \nJeremy Jones (the
freestyler) is moving from Smith Goggles to Iris. 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. 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. With the likes of Rob "Sluggo" Boyce and Mark Frank on \nthe Sims team
things are definitely looking pretty rosy. 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. 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 & 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
& lift $15.00<BR>1/2 day trail, lift \n& bike $35.00<BR>Full day trail &
lift $25.00<BR>Full day trail, lift \n& bike $45.00<BR>Full day trail, lift &
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. 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> </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 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 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 has recently signed a management deal \nwith
Mammoth Mountain. 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. 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. \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 rough surface Current snow base is between 30 - 85cm with 80%
total skiable cover. All lifts and facilities are operating. </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, 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
: the board-it.com f-f3 snowboarding</FONT> <FONT
size=2>championship, the 1ski.com freestyle ski \nchampionship, the f-f3
constructors championship, 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, 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 ! 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 ! Six of us
hiked there yesterday and it took, from leaving top of Ruined Castle, about 30 - 45 mins
- depending on fitness level. 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> <BR>What attracted me most to Falls? Had
to be the Snowboard Park - really missing it this week, not running due again to heavy
snowfall but, have to say, 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> <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. 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. He rides in control and an up and coming
freestyler - we\'ll be seeing a lot of him in years to come ...<BR> <BR>Is Falls all
about Boarding? 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> <BR>Falls Creek is a very progressive mountain
offering a variety of different styles and riding, its laid back, great vibes ....
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 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 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 Coopers. This coming Tuesday,
Falls welcomes N.Z. band \'Shehad\' and on a local note, we\'ll be sharing birthday
celebrations with Jill & 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. 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> <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> <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. Senior winners were Damo Liddy [Shay Paxton on the podium
taking 3rd] and for the women, Candice Drouin. Junior winners were young Drew Baker
and female, Holly Crawford. Excellent to see the high standard coming up with our
Australian juniors.<BR> <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. The juniors\'
performance showed the old crew that the grommits are right up there! Ben
Bright taking first place and for the junior females, Holly Crawford. 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.
Overall, the riders were pretty rapped - it was tough competitively with the high
standard but this made for excellent crowd appeal.<BR> <BR>BIG AIR contest, boy that
was a good night! Saturday, under lights, outside the summit chair next to the
Frying Pan - the jump was quite big with three different kickers to choose from; a
few people got scared because the jump was quite hard but, it was nice and steep and
there were still plenty of competitors. 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. 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! Shay Paxton made
No. 2.<BR> <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. The patrons were definitely feeling fiesty as locals mixed with
competitors and drunk more than they should of [as usual] ! !<BR> <BR>The weekend
finished on Sunday with the Giant Slalom. 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> </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. Using a special \ndevice the
water is actually kept on the slope rather than running off. \nThus by keeping the
water on the slope it is possible to ride down on a \nsnowboard.</P> \n<P>The inventors
have said, "The invention is very simply, the result is \nthundering."
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! The ZZ Top look-alike Mixer added to their raunchy
image...<BR> <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> <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. Jade Vaughan, Canadian took out first place in the Men\'s moguls with
local Falls rider Tom Costa taking 6th place; women\'s Moguls finalist was
Jane Sexton. Heavy night - great ...<BR> <BR>Wednesday we welcomed
the Quicksilver pro Team arriving for the 1/4 pipe competition for locals and pro teams -
more details later. 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. 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;
Jason Haynes and most of the Quicki pro\'s were down and all the crew were busting it out
towed in by skiddo. The Team did not compete in the 1/4pipe comp, this was
only for locals. Turned out well - 3rd place PC, 2nd Drew and 1st place
Mario.<BR> <BR>While this was going on, I visited Mt. Hotham for the Heinz Ketchup
Snowcross and Big Air. This was a competition featuring Victoria v New South Wales
with both the boardercross and big air results combined. Regrettably for us,
the NSW crew took out the Cup! 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. But both events were well organised and
the general feel of the comps positive, the results were: 1st place for the Women,
Emily Thomas from NSW; Sasha Ryzy 2nd place and 3rd our Karen Lyons from
Victoria. With the Mens, we had John Fletcher, NSW taking out the overall
1st, 2nd Kym Christiansen from Norway representing Victoria. 3rd place was
shared equally between Chris Coulter from USA representing Victoria and local Hotham
rider Tony Graham. <BR> <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!! <BR> <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. 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. 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. 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. 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. 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. All money from T-shirt sales will go to support Free the \nSnow. 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. 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 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. 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. 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. 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. The quarterpipe that the Jindy crew had spent days building was \nbig,
but it was not 50-foot as some people were suggesting. However, it \nwas easily as
good as a quarterpipe you might find in the Whistler \nbackcountry. It stood about
12 feet high with a nice long trannie that \nalmost went to vert. 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. The nice smooth tranny and lofty \nlip provided consistent 15-foot airs
with plenty of hang time. The ver
[19 Aug 2004 5:59]
Matthew 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 17: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 4:22]
Matthew 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 7: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.
![http://www.boardtheworld.com/images/magazine/product_reviews/eyewear/zeal_rapt_goggles.jpg...](http://www.boardtheworld.com/images/magazine/product_reviews/eyewear/zeal_rapt_goggles.jpg"){kind=link}
![http://www.boardtheworld.com/images/magazine/snowboarding_the_world/snowboarding_the_world...](http://www.boardtheworld.com/images/magazine/snowboarding_the_world/snowboarding_the_world_cov_small.jpg"){kind=link}
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".