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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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
| |||
| |||
| 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 |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQl Query error | dmiles | osCMax v2 Customization/Mods | 2 | 03-05-2007 11:42 PM |
| ssl query | Lara Croft | osCMax v2 Installation issues | 2 | 12-30-2006 12:22 PM |
| Shooping Cart Query | kama_k | osCommerce 2.2 Modification Help | 3 | 12-19-2004 08:06 AM |