[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