DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Import/Export Tools  
DwZone Forum Index -> Import/Export Tools

Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 371 to 380 of 382 (Total: 233) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re:How do you get this thing to work  
View this persons public profile  [email protected]   12:09 20 Oct 2006  
   Re:How do you get this thing to work  
View this persons public profile  gianluigi   13:40 20 Oct 2006  
   Re:How do you get this thing to work  
View this persons public profile  [email protected]   16:05 20 Oct 2006  
   Re:How do you get this thing to work  
View this persons public profile  gianluigi   16:40 20 Oct 2006  
   Object doesn't support ... 'SetEncloseField'  
View this persons public profile  [email protected]   11:59 3 Oct 2006  
   Re:Object doesn't support ... 'SetEncloseField'  
View this persons public profile  gianluigi   13:30 3 Oct 2006  
   CSV with " surrounding text, how to remove "  
View this persons public profile  [email protected]   10:27 13 Sep 2006  
   Re:CSV with " surrounding text, how to remove "  
View this persons public profile  gianluigi   14:52 13 Sep 2006  
    XML import question  
View this persons public profile  [email protected]   20:17 25 Aug 2006  
 
Hello Gianluigi,

Have one question regarding your new extension Import/export tools (haven�t bought it yet).

I use ACCESS as a desktop database for parts in stock (invoice and other stuff)in a application and then export it as xml, there are several columns in the table with a unique key column that only is a row ID and the part number is in an other column (indexed).

If i will use the xml import i need to empty the table every time before i import it because there will be partnumber that will not be in stock anymore and therefor can not be left in the MySql database on the internet.

Is it only to insert this delete command below before the xml import code to make it work?
<%

Set DeleteParts = Server.CreateObject ("ADODB.Command")
DeleteParts.ActiveConnection = MM_cnSql_STRING
DeleteParts.CommandText = "DELETE * FROM PARTS"
DeleteParts.CommandType = 1
DeleteParts.CommandTimeout = 0
DeleteParts.Prepared = true
DeleteParts.Execute()

%>

Klas
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re:XML import question  
View this persons public profile  gianluigi   20:24 25 Aug 2006  
Last Visit: Saturday 18 May, 2024 5:55 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: