Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Supplier Code Missing Fields - SOLVED?
12-13-2018, 02:23 AM (This post was last modified: 12-13-2018 02:36 AM by VortecCPI.)
Post: #1
Change Supplier Code Missing Fields - SOLVED?
Z_ChangeSupplierCode.php

This script is missing the following fields:

+ url
+ defaultshipper
+ defaultgl

I think this should do it:

PHP Code:
$sql "INSERT INTO suppliers (`supplierid`,
        `suppname`,  `address1`, `address2`, `address3`,
        `address4`,  `address5`,  `address6`, `supptype`, `lat`, `lng`,
        `currcode`,  `suppliersince`, `paymentterms`, `lastpaid`,
        `lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
        `remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
        `phn`, `port`, `email`, `fax`, `telephone`, `url`,
        `defaultshipper`, `defaultgl`)
    SELECT '" 
$newCode "',
        `suppname`,  `address1`, `address2`, `address3`,
        `address4`,  `address5`,  `address6`, `supptype`, `lat`, `lng`,
        `currcode`,  `suppliersince`, `paymentterms`, `lastpaid`,
        `lastpaiddate`, `bankact`, `bankref`, `bankpartics`,
        `remittance`, `taxgroupid`, `factorcompanyid`, `taxref`,
        `phn`, `port`, `email`, `fax`, `telephone`, `url`,
        `defaultshipper`, `defaultgl`
        FROM suppliers WHERE supplierid='" 
$oldCode "'"

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Change Supplier Code Missing Fields - SOLVED? - VortecCPI - 12-13-2018 02:23 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)