Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    10

    Unanswered: :: Null - problem :::

    Hi there,

    Here is a problem, while using the MySql. I am using a third party ecommerce software for my application. This about storing the credit card details in to the 'transaction' table. It was working fine earlier untill I added two new row in to the table one is teh 'start_date' and the other is the 'issue_number' properties are set fine. But, I am unable to insert/update those values in to the table.

    If I log through my 'PhpMyAdmin', I can view the row filled with the "NULL" inthe value field. How can I update the table? any solution???

    this is the table,
    --------------------------
    CREATE TABLE `transaction` (
    `orderid` int(10) unsigned NOT NULL auto_increment,
    `name_on_card` varchar(150) default NULL,
    `card_no` varchar(50) default NULL,
    `card_type` varchar(50) default NULL,
    `start_date` varchar(25) default NULL,
    `expir_date` varchar(20) default NULL,
    `issue_number` char(2) default NULL,
    `cvv2` varchar(10) default NULL,
    `ccstatus` varchar(30) default NULL,
    `status` varchar(200) default NULL,
    PRIMARY KEY (`orderid`)
    ) TYPE=MyISAM AUTO_INCREMENT=234603 ;

    --------------------------
    Thanks & Regards,

    JD in UK
    Last edited by jduk; 01-12-04 at 14:13.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    null problem -reply

    hi,
    this should have been possible. Can I know how you tried to insert/update values into those fields?

    The following queries should work.

    For insert:
    insert into transaction set issue_number='cv' , start_date='2000-10-10'

    For update

    update transaction set issue_number='cv' , start_date='2000-10-10'
    where orderid='2'

    or

    update transaction set issue_number='cv' where issue_number is null


    Regards,
    Selin.

  3. #3
    Join Date
    Jan 2004
    Posts
    10
    Hi Selin,

    THank you, It is working fine.

    Thanks & Reagrds

    JD in UK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •