Changeset 32

Timestamp:

10/30/2008 10:37:07 PM (15 years ago)

Author:

marcus

Message:

r17 | stittgen | 2008-01-30 15:59:13 +0100 (Mi, 30 Jan 2008) | 2 lines

Changed SQL statement in sfd2db into SQL-Standard

File:

• SH_SHM/trunk/source/seed_io/sfd2db.c (modified) (3 diffs)

SH_SHM/trunk/source/seed_io/sfd2db.c

@@ -3 +3 @@
  *      ========
  *
- * $Revision: 13 $, $Date: 2008-01-18 10:01:21 +0100 (Fr, 18 Jan 2008) $
+ * $Revision: 17 $, $Date: 2008-01-30 15:59:13 +0100 (Mi, 30 Jan 2008) $
  *
  * reads lines from sfdfile and creates commands to insert into sfdb database
@@ -192 +192 @@
                         } /*endif*/
                         fclose( fp );
-                        sprintf( shellcmd, "%s \"insert into pathtab values ( \'%d\', \'%s\' )\"",
+                        sprintf( shellcmd, "%s \"insert into pathtab values ( %d, \'%s\' )\"",
                                 sfdbreq, pathid, abspath );
                         /*printf( "--> executing %s\n", shellcmd );*/
@@ -313 +313 @@
                 /*sprintf( shellcmd, "cat %s", tmpfile );*/
                 /*system( shellcmd );*/
-                sprintf( shellcmd, "mysql sfdb <%s", tmpfile );
+                sprintf( shellcmd, "sql sfdb <%s", tmpfile );
                 /*printf( "--> executing %s\n", shellcmd );*/
                 system( shellcmd );