morditech.com
06-27-07, 06:17 PM
I have made some ColdFusion custom export scripts that query the Miva database(s) and exports the information into feeds for various advertisers. I have done this for several feeds including Google base, Yahoo Submit and brokerbin. Now I am attempting to make a script for another feed that will require custom product fields to be exported as well.
The problem is this:
I know enough about database queries to get everything done except exporting more than 1 specified custom product fields. I need to make a query that will take the product id and match that to the correct custom product field then export the value field of the that record for multiple custom product fields. It is really not as simple as it sounds. You would think a query of queries could do this but apparently ColdFusion limits you to only 2 query of queries for some reason.
Please recommend someone that can help me in a timely manner. Thanks in advance.
EricM
The problem is this:
I know enough about database queries to get everything done except exporting more than 1 specified custom product fields. I need to make a query that will take the product id and match that to the correct custom product field then export the value field of the that record for multiple custom product fields. It is really not as simple as it sounds. You would think a query of queries could do this but apparently ColdFusion limits you to only 2 query of queries for some reason.
Please recommend someone that can help me in a timely manner. Thanks in advance.
EricM