e_i_pi's Profile User Rating: *****

Reputation: 801 Master
Group:
Mentors
Active Posts:
1,711 (0.78 per day)
Joined:
30-January 09
Profile Views:
49,790
Last Active:
User is online 21 minutes ago
Currently:
Viewing Topic: Getting Checked Checkboxes on to...

Previous Fields

Country:
AU
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
AMD
Favorite Gaming Platform:
Playstation
Your Car:
Mitsubishi
Dream Kudos:
75
Expert In:
Databases

Latest Visitors

Icon   e_i_pi has set their status

Posts I've Made

  1. In Topic: Outputting Images from blob data

    Posted 22 Jan 2015

    View PostArtificialSoldier, on 23 January 2015 - 09:08 AM, said:

    Quote

    I copied your subject header into google (with PHP on the front), and got this result.

    That function is specifically for Firebird/Interbase, not any other database.

    Right you are. And the second google result? My point being, self-serve via google is the best way to get help on issues that are common.
  2. In Topic: Outputting Images from blob data

    Posted 22 Jan 2015

    Google is your friend. I copied your subject header into google (with PHP on the front), and got this result.
  3. In Topic: What causes this to happen?

    Posted 22 Jan 2015

    View Posthigherprimate, on 22 January 2015 - 03:45 PM, said:

    The primary key values get wonky when I insert values into tables sometimes. What causes this?

    As modi said, a range of things can cause this. Here's a couple of things to consider:
    • Auto-incremented values that act as surrogate keys are not supposed to have any business meaning. If you need a gapless range of IDs, then your design is wrong.
    • Auto-increments are not transactional. This means, if you start a transaction, insert a row that gets ID 1, then rollback the transaction, then next inset will be ID 2.

    Take this code for example:
    SET ANSI_NULLS ON
    GO
    
    SET QUOTED_IDENTIFIER ON
    GO
    
    DROP TABLE [dbo].[TestAutoincrement]
    GO
    
    CREATE TABLE [dbo].[TestAutoincrement](
    	[Autoincrement] int IDENTITY(1,1) NOT NULL,
    	[Message] varchar(255) NOT NULL
    ) ON [PRIMARY]
    GO
    
    BEGIN TRANSACTION
    GO
    
    SELECT IDENT_CURRENT('TestAutoincrement')
    
    INSERT INTO [TestAutoincrement] ([Message]) VALUES ('Test1')
    INSERT INTO [TestAutoincrement] ([Message]) VALUES ('Test2')
    GO
    
    SELECT IDENT_CURRENT('TestAutoincrement')
    
    ROLLBACK TRANSACTION
    GO
    
    SELECT IDENT_CURRENT('TestAutoincrement')
    
    

    Output:
    1
    ---
    2
    ---
    2
    
    
  4. In Topic: Javascript Exploration: AngularJS

    Posted 21 Jan 2015

    View PostBetaWar, on 22 January 2015 - 02:32 AM, said:

    How do you fight back in a rapidly changing world?

    Work for government. Anything you've learnt that's old will be brand spanking new technology to them. Honestly, people were surprised in my new job when they found out I knew jQuery. DBC is a new concept to them as well.

    Also, if you work for government, make sure you jam the word "cloud" into any and all conversations. You don't need to know what it means, or what it's for, just sprinkle it liberally in general banter and you'll be a senior manager in no time!
  5. In Topic: Using JQuery to display JSON properties

    Posted 21 Jan 2015

    Quote

    $.getJSON("/Users/dannyflynn/Desktop/Quora/Customers.json", function(data){
    

    You're trying to load from a file on your desktop, which will be a cross origin request. Try installing a local web server so you can reference the file relative to your site root.

My Information

Member Title:
= -1
Age:
40 years old
Birthday:
June 24, 1974
Gender:
Location:
Australia
Years Programming:
4
Programming Languages:
HTML, XML, jQuery, PHP, SQL, MySQL, VBA, VBScript, PostgreSQL

Contact Information

E-mail:
Private
Website URL:
Website URL  http://www.artofwar.cc/

Comments

Page 1 of 1
  1. Photo

    cupidvogel Icon

    09 Jun 2012 - 11:30
    Ha ha, I really liked your "if(navigator.appName == 'Microsoft Internet Explorer')" theme!
  2. Photo

    Duckington Icon

    04 Apr 2012 - 00:57
    It's not live yet, still developing and then going into beta test. I haven't actually decided on a name yet, so no domain for it.
  3. Photo

    modi123_1 Icon

    13 Mar 2012 - 06:56
    Ha.. well good luck with it.. it's always a good butt of a joke.
  4. Photo

    RudiVisser Icon

    08 Mar 2012 - 15:20
    You know, I only just worked out what your avatar is. Love it!
  5. Photo

    RudiVisser Icon

    06 Sep 2011 - 00:37
    Thank you very much :-D
  6. Photo

    RudiVisser Icon

    06 Sep 2011 - 00:37
    Thank you very much :-D
  7. Photo

    e_i_pi Icon

    05 Sep 2011 - 22:15
    Ah thank you :) I'm a fan of minimalism, so I wwanted something nice and simple, plus you just can't go past red and black!
  8. Photo

    no2pencil Icon

    05 Sep 2011 - 19:52
    Love your avatar!
  9. Photo

    Sayid Ahmed Icon

    13 Jul 2011 - 14:02
    thanks for the add.
  10. Photo

    Dormilich Icon

    17 Feb 2011 - 13:25
    just wanted to congratulate for the funny thread title "OOP, PDOs, pain, tears".
Page 1 of 1