| 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_goggle
s.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_th
e_world_cov_small.jpg" \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.
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".