Recent content by IanBruk

Did you ever find these repositories? This question interests me as I am also looking for data dictionaries. I have been developing a data dictionary based on xCBL and am now working to make it compatible with OAGIS. Would these qualify as EDI standards? Are you constrained by EDI or are you...

I have a customer that is using Speed-Quote for submitting quotes to large retailers such as Wal-Mart. It seems that they only accept quotes in this format. Is anyone aware of this software? Am I forced to use their software or are there alternatives?

Would you be able to share those SQL statements or examples? What we have done is written a parser to parse out the XML files and build database tables and fields based on xCBL elements. We do not, however, have any link back to the structure of the XML file.

If XML files are available on our server how do we protect them without password protecting the directory that they are in?

I have an .xdr file from xCBL which lists over 1800 XML elements which cover most all needed information for any common business process. These elements, as far as I understand, correspond to fields in database tables. I am looking for a database that has been designed using these xCBL elements...

Would it be possible to get an outline of your thesis? It seems that this would be a very good exercise. Wondering if you are limiting it to shopping carts or are also including CRM and ERP E-Commerce initiatives.

I have an application that was written using Oracle 8i as the database with triggers and stored procedures. I want to move this application to SAP DB. From what I read SAP DB supports Oracle 7 it does not expressly state that it supports Oracle 8i. As I am trying to be downward compatible...

I have an application that was written using Oracle 8i as the database with triggers and stored procedures. I want to move this application to SAP DB. From what I read SAP DB supports Oracle 7 it does not expressly state that it supports Oracle 8i. As I am trying to be downward compatible...

These message boards help to teach one to be concise in their statements. I have no problem running the SQL statement in the database when I am only using one Left Outer Join. Using 2 doesn't work in either Crystal Reports or in the MySql database. I checked and MySQL does not support stored...

I just retested after reading the responses. I can initiate one outer join and generate the correct result set. It will not however allow a second outer join. I checked the syntax by running the SQL statement in MySQL and it works.

I am using Crystal Reports Version 8.5 with an ODBC connection to a MySQL database. My report has a Primary table and numerous One to One links to secondary tables. I wish the report to generate values when one or both of the secondary tables contain no corresponding records. That is some...