List:General Discussion« Previous MessageNext Message »
From:System Administrator a.k.a. The Root of the Problem Date:March 16 2002 1:56am
Subject:Re: Foam King
View as plain text  
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.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.ansid.ansib.ansio.ansi..ansit.ansib.ansil.ansiO.ansid.ansi.ansir.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.oem.oem.oem.oemP.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.ansi.ansi.ansi.ansi.ansi.ansi.ansiT.ansiY.ansie.ansim.ansio.ansip.ansi.ansi.ansi.ansi.ansi.ansie.ansim.ansip.ansiO.ansir.ansid.ansie.ansir.ansiProducts.oemTempOrder.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
root@stripped	 http://www.nl2k.ab.ca
990-3244
Thread
Re: Foam KingSystem Administrator a.k.a. The Root of the Problem16 Mar