[ic] splitting out mv_ad seperate ship to values for labels table
Scott Andreas
joscan at comcast.net
Tue Jun 8 20:31:44 EDT 2004
hello group
Using the standard separate ship to fucntions of userdb how can I have
the data split out for input into a labels database. Right now I have a
labels database that when an order is made it creates an entry into the
labels database with the following column definitions
Database label COLUMN_DEF "name=varchar(25)"
Database label COLUMN_DEF "bus_name=varchar(25)"
Database label COLUMN_DEF "address=varchar(40)"
Database label COLUMN_DEF "city=varchar(20)"
Database label COLUMN_DEF "state=varchar(15)"
Database label COLUMN_DEF "zip=varchar(10)"
Database label COLUMN_DEF "country=varchar(10)"
Database label COLUMN_DEF "phone=varchar(15)"
Database label COLUMN_DEF "email=varchar(30)"
Database label COLUMN_DEF "from_name=varchar(25)"
Database label COLUMN_DEF "from_bname=varchar(25)"
Database label COLUMN_DEF "from_address=varchar(25)"
Database label COLUMN_DEF "from_city=varchar(20)"
Database label COLUNN_DEF "from_state=varchar(15)"
Database label COLUMN_DEF "from_zip=varchar(10)"
Database label COLUMN_DEF "from_country=varchar(10)"
Database label COLUMN_DEF "from_phone=varchar(15)"
Database label COLUMN_DEF "from_email=varchar(15)"
All the from* columns is the standard user data
name,bus_name, address, city, state, zip, country, phone, email is the separate
user data (not the bill to data). According to the code it is associated with mv_ad.
function.
But, my problem is how do I separate out the mv_ad value so it can be inserted
into this table properly
Any thoughts, example, how-to's would be appreciated
Thank in adv
Scott
IC 5.0
Redhat 7.2
postgressql
As another inquiry has anyone use the Redhat (taroon) advances server 3 (betas) yet?
I'm thinking of switching to this (as it is free and has iso for download) from RH 7.2
More information about the interchange-users
mailing list