« previous next »
Pages: 1 [2] 3  All

Author Topic: New guru: kickstart  (Read 9308 times)

0 Members and 1 Guest are viewing this topic.

Offline roopurt18

  • Guru
  • Fanatic
  • *
  • Posts: 3,658
  • Gender: Male
  • le sigh
    • View Profile
    • rbredlau
Re: New guru: kickstart
« Reply #15 on: August 06, 2009, 04:50:23 PM »
You get to use Access at work?  You lucky dog!  I'll trade your Access any day of the week for my FoxPro <shudder>
Logged

Offline kickstart

  • Guru
  • Addict
  • *
  • Posts: 2,680
    • View Profile
Re: New guru: kickstart
« Reply #16 on: August 06, 2009, 06:24:58 PM »
Hi

Foxpro is one I haven't used. Have used DB2, Dataquery, Oracle, SQL Server and even had to use IMS.

Access has too many things that are non standard, and seems to have an obsession with pointless brackets when doing joins. Also won't allow you to use constants in an ON clause when doing outer joins.

And its dates are a complete nightmare as it seems to randomly decide whether you mean ddmmyyy or mmddyyyy.

All the best

Keith
Logged
There are 10 types of people in the world. Those who understand binary and those who don't

Offline PugJr

  • Devotee
  • Posts: 663
  • Gender: Male
  • Puggy!
    • View Profile
Re: New guru: kickstart
« Reply #17 on: August 07, 2009, 02:12:47 AM »
Kickstart, do you copy paste the "Hi-all the best-Kieith" every single time you make a post or is there a way to make it so it does that automatically considering every post of yours I've seen has that.
Logged

Offline kickstart

  • Guru
  • Addict
  • *
  • Posts: 2,680
    • View Profile
Re: New guru: kickstart
« Reply #18 on: August 07, 2009, 05:20:29 AM »
Hi

Type it each time, but complete habit as I have been doing that for posts on forums / bulletin boards for over 15 years.

All the best

Keith
Logged
There are 10 types of people in the world. Those who understand binary and those who don't

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: New guru: kickstart
« Reply #19 on: August 07, 2009, 08:12:12 AM »
It's not like SQL Server dates are any fun either.
Logged
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

Offline .josh

  • Administrator
  • 'Insane!'
  • *
  • Posts: 13,152
  • Grumpy Old Man
    • View Profile
Re: New guru: kickstart
« Reply #20 on: August 07, 2009, 09:26:18 AM »
Quote from: PugJr on August 07, 2009, 02:12:47 AM
Kickstart, do you copy paste the "Hi-all the best-Kieith" every single time you make a post or is there a way to make it so it does that automatically considering every post of yours I've seen has that.

Yeah...people have a tendency to put the same thing at the end of posts all the time. It would be great if there were some place we could add things like that and it gets automatically placed on the bottom of the post every time.  That way we wouldn't have to type it out every time.  I'm kind of surprised nobody has thought to do this before....we should submit a request to SMF to make such a feature. 
Logged

Did I help you? Feeling generous? Donate to me! | Donate to phpfreaks!

Offline nrg_alpha

  • Staff Alumni
  • Addict
  • *
  • Posts: 2,480
  • Gender: Male
  • PHPenchant, I haz it!
    • View Profile
    • Portfolio Site
Re: New guru: kickstart
« Reply #21 on: August 07, 2009, 11:00:57 AM »
CV, you forgot to use the  :sarcastic:  smiley...
Logged
"Build a man a fire, you warm him for a day. Set a man on fire, and he'll be warm for the rest of his life."
PHP = One cool palindrome!

Offline gevans

  • Addict
  • Posts: 2,649
  • Gender: Male
  • don't shoot the messanger
    • View Profile
    • Guernsey Web Design
Re: New guru: kickstart
« Reply #22 on: August 07, 2009, 11:15:31 AM »
Quote from: nrg_alpha on August 07, 2009, 11:00:57 AM
CV, you forgot to use the  :sarcastic:  smiley...

If SMF had a system in place for this, CV wouldn't have to add the smiley everytime, it would be there automatically!
Logged
I like starting my code with session_start();

Code: [Select]
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
Quote from: mo on May 28, 2009, 10:09:48 AM
Son of a biscuit eating bulldog
Use [code][/code] tags!!

Offline roopurt18

  • Guru
  • Fanatic
  • *
  • Posts: 3,658
  • Gender: Male
  • le sigh
    • View Profile
    • rbredlau
Re: New guru: kickstart
« Reply #23 on: August 07, 2009, 01:28:26 PM »
I've not had any problems with SQL dates fenway, so I'm not sure what you're on about?

FoxPro dates can sometimes have the year portion set to 0, which really caught me off guard the first time I encountered it extracting data from FoxPro.

It took me a year and a half to reach this conclusion, but if you ever have to extract data from FoxPro, do it with FoxPro.  Nothing else works 100% of the time.
Logged

Offline kickstart

  • Guru
  • Addict
  • *
  • Posts: 2,680
    • View Profile
Re: New guru: kickstart
« Reply #24 on: August 07, 2009, 05:05:30 PM »
Hi

Down side of an automatic sig is the odd time when you really do not want to use it.

Have used SQL server a bit but never had major issues with the dates with it. But then never had to do much date processing with it.

Oh for the simplicity of storing a yymmdd date in a fixed decimal(7,0) field.

All the best

Keith
Logged
There are 10 types of people in the world. Those who understand binary and those who don't

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: New guru: kickstart
« Reply #25 on: August 08, 2009, 01:54:17 PM »
MySQL is perfectly happy storing zeros in dates too -- which is sometimes quite useful -- but the ugly way to extract a date from a datetime in SQL Server always makes me barf.
Logged
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

Offline MadTechie

  • Guru
  • Freak!
  • *
  • Posts: 9,374
  • Gender: Male
  • I try to F1
    • View Profile
Re: New guru: kickstart
« Reply #26 on: August 10, 2009, 05:46:40 AM »
a little late but still congratulates kickstart


All the best

Keith Richard
Logged
Computers are good at following instructions, but not at reading your mind.
Quote from: Maq on March 11, 2009, 01:10:25 PM
The quality of a response, is usually directly related to the quality of the question. ©2009 mjdamato
Quote from: Nightslyr on February 03, 2010, 06:35:48 PM
I dunno about that.  A regular expression has a 0% chance of touching my penis.
Quote from: redarrow on October 09, 2009, 06:56:35 AM
the code is professionally made up but not working
Remember to Click Solved, how to ask questions - the smart way

Offline corbin

  • Guru
  • Freak!
  • *
  • Posts: 7,951
  • Gender: Male
    • View Profile
Re: New guru: kickstart
« Reply #27 on: August 10, 2009, 01:55:56 PM »
Errrrrr....  Don't we have automatic signatures?  They just happen to have a HR before them and a couple buttons ;p.
Logged
Why doesn't anyone ever say hi, hey, or whad up world?

Offline keeB

  • Nick Stinemates
  • Staff Alumni
  • Devotee
  • *
  • Posts: 1,130
  • Gender: Male
  • I'm no good at this
    • View Profile
    • A little dash of life..
Re: New guru: kickstart
« Reply #28 on: October 20, 2009, 12:19:21 PM »
Welcome :)
Logged
Come visit my site to see my latest projects
http://nick.stinemates.org/wordpress/

Offline Gayner

  • Devotee
  • Posts: 548
    • View Profile
Re: New guru: kickstart
« Reply #29 on: October 31, 2009, 08:00:44 PM »
Quote from: kickstart on August 07, 2009, 05:20:29 AM
Hi

Type it each time, but complete habit as I have been doing that for posts on forums / bulletin boards for over 15 years.

All the best

Keith

Your almost as old as me!
Logged
http://Pray4Life.com - Lending Gods Hand in a Virtual World!  Public and Private Prayer Requests!
Pages: 1 [2] 3  All
« previous next »