Results 1 to 2 of 2

Mdb -> Insert Query -> mySQL -> I Happy !

This is a discussion on Mdb -> Insert Query -> mySQL -> I Happy ! within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; hi osc Fans I got a mdb file. I list all the articles store in that mdb like follows <?php ...

      
  1. #1
    Member
    Join Date
    Apr 2004
    Location
    Argentina
    Posts
    61
    Rep Power
    0


    Default Mdb -> Insert Query -> mySQL -> I Happy !

    hi osc Fans
    I got a mdb file.
    I list all the articles store in that mdb like follows

    <?php
    $db_connection = new COM("ADODB.Connection");
    $db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath("AbcPelado2000.mdb")." ;DefaultDir=". realpath("");
    $db_connection->open($db_connstr);
    $rs = $db_connection->execute("SELECT Descripcion FROM Articulos");
    $rs_campo0 = $rs->Fields(0);
    while (!$rs->EOF) {
    echo 'Articulo: '.$rs_campo0->value.'<br>';
    $rs->MoveNext();
    }
    $rs->Close();
    $db_connection->Close();
    echo '<br>Finished';

    Well, now comes the difficult question:

    Which SQL code does osc use for inserting a new product into the system?
    I'd modify the above code so i can move the articles from mdb to osc

    That mdb also has a categories table, but i'll be happy just to know how to insert the articles, then i create manually the categories and pass the whole day moving stuff...

    thanks alot...

  2. #2
    Member
    Join Date
    Apr 2004
    Location
    Argentina
    Posts
    61
    Rep Power
    0


    Default

    i'm mad ...
    cannot get this to work.
    the categories and the products don't have an autoinc field so i could do batch inserts in the oscommerce db from access mdb...

    any ideas?
    Henry Becerra
    ICQ: 18048153
    MSN: qbecerra@hotmail.com
    Yahoo: qbecerra
    http://www.beza.com.ar

    San Juan - Argentina

Similar Threads

  1. SQl Query error
    By dmiles in forum osCmax v2 Customization/Mods
    Replies: 2
    Last Post: 03-05-2007, 11:42 PM
  2. ssl query
    By Lara Croft in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 12-30-2006, 12:22 PM
  3. Shooping Cart Query
    By kama_k in forum osCommerce 2.2 Modification Help
    Replies: 3
    Last Post: 12-19-2004, 08:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •