On Fri, Mar 15, 2002 at 05:30:57PM -0700, Kelly Grainger wrote: > Dave, > > I'm being pressured by Don at the Foam King to get things working asap. Any >progress? >
Here is what I get. Script started on Fri Mar 15 18:52:36 2002 doctor.nl2k.ab.ca/~$ mysql dir *.ansi sh: dir: command not found doctor.nl2k.ab.ca/~$ ls -Fail *,ansi ls: *,ansi: No such file or directory doctor.nl2k.ab.ca/~$ ls -Fail *,ansiansi[K.ansi 206479 -rw------- 1 root wheel 728 Mar 15 18:51 dbo.tblOrder.ansi 206484 -rw------- 1 root wheel 658 Mar 15 18:51 dbo.tblProducts.ansi 206486 -rw------- 1 root wheel 478 Mar 15 18:51 dbo.tblTempOrder.ansi doctor.nl2k.ab.ca/~$ ls -Fail *.ansi oen ls: *.oen: No such file or directory doctor.nl2k.ab.ca/~$ ls -Fail *.oen m 206482 -rw------- 1 root wheel 728 Mar 15 18:51 dbo.tblOrder.oem 206485 -rw------- 1 root wheel 658 Mar 15 18:51 dbo.tblProducts.oem 206487 -rw------- 1 root wheel 478 Mar 15 18:51 dbo.tblTempOrder.oem doctor.nl2k.ab.ca/~$ mysql < *.ansi sh: *.ansi: ambiguous redirect doctor.nl2k.ab.ca/~$ mysql < *.ansi.ansi[Kd.ansib.ansio.ansi..ansit.ansib.ansil.ansiO.ansid.ansi.ansi[Kr.ansid.ansie.ansir.ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblOrder]'' at line 1 doctor.nl2k.ab.ca/~$ mysql < dbo.tblOrder.ansisi oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblOrder]'' at line 1 You have new mail in /var/mail/root doctor.nl2k.ab.ca/~$ mysql < dbo.tblOrder.oem.oem[K.oem[K.oem[K.oem[K.oem[KP.oemr.oemo.oemd.oemu.oemc.oemt.oems.oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblProduct' at line 1 doctor.nl2k.ab.ca/~$ mysql < dbo.tblProducts.oem ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblProduct' at line 1 doctor.nl2k.ab.ca/~$ mysql < dbo.tblProducts.ansi.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[K.ansi[KT.ansiY.ansie.ansim.ansio.ansip.ansi.ansi[K.ansi[K.ansi[K.ansi[K.ansi[Ke.ansim.ansip.ansiO.ansir.ansid.ansie.ansir.ansiProducts.oem[KTempOrder.ansi ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTempOrd' at line 1 doctor.nl2k.ab.ca/~$ mysql < dbo.tblTempOrder.ansi oem ERROR 1064 at line 1: You have an error in your SQL syntax near 'if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTempOrd' at line 1 doctor.nl2k.ab.ca/~$ exit exit Note I am using mysql. Can you fix this? Script done on Fri Mar 15 18:54:08 2002 > Kelly Grainger, > Webmaster, SSI Solutions. -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php