osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

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 ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v1.7 Forums > osCMax v1.7 Discussion

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 06-24-2004, 07:09 PM
Member
 
Join Date: Apr 2004
Location: Argentina
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
damnedpig
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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 07-29-2004, 09:11 AM
Member
 
Join Date: Apr 2004
Location: Argentina
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
damnedpig
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 02:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax