sage v6 to mysql

2001-10-31 Thread AJDIN BRANDIC
Has anyone played with extracting data from sage version 6 on Windows to MySQL? What is the easyest way of extracting data from sage? Their support will not help sing my contract with them expired and I have decided to use a different product. Regards Ajdin --

UPDATE IGNORE

2001-10-18 Thread AJDIN BRANDIC
I am running MySQL 3.22.30 and UPDATE IGNORE is failing. Was this function introduced in some later version? Error is "You have an error next to 'IGNORE mytable .'. As soon as I remove ignore it works OK. What is a work around? Ajdin -

Re: inserting images

2001-10-03 Thread AJDIN BRANDIC
I have never done it but have seen posts on this topic. From what I understand you need to create a BLOB field in your DB (MySQL) then upload file to your server, read it with fopen (or ...) into a variable then insert that variable into the BLOB field you have in your DB. Hope I am right her

Re: find mysql

2001-08-17 Thread AJDIN BRANDIC
hi i found it /var/lib/mysql/ regards Ajdin On Fri, 17 Aug 2001, AJDIN BRANDIC wrote: > Hi, > > I have received mysql db files with extensions .frm, .ISD, .ISM > > I was told that all I need to do is to put them in mysql data directory > and it should work ok. I have RH

find mysql

2001-08-17 Thread AJDIN BRANDIC
Hi, I have received mysql db files with extensions .frm, .ISD, .ISM I was told that all I need to do is to put them in mysql data directory and it should work ok. I have RH6.2 with mysql rpm and I cannot locate where mysql data directory is. Any idea how to locate it. I wish I had received

istalling

2001-05-22 Thread AJDIN BRANDIC
Hi, I have just installed RH6.2 as server and now want to install Apache+MySQL+PHP4. Is it better to download MySQL rpm version OR src.rpm OR .tar.gz? I think Apache needs to be installed first them MySQL (does MySQL need to be aware of Apache) then PHP with mysql and with apache extensions

Re: Computer Exploded!!!

2001-05-01 Thread AJDIN BRANDIC
On Tue, 1 May 2001, Gerald Clark wrote: > 1. Read the manual > 2. Read the manual > 3. get a book on SQL > > > Selvin Sakal wrote: > > > My computer didn't explode i just wrote that to get attention. My question > > is this - I have a database with a table which looks like this - > > > > CREA

Re: Link to pictures outside database

2001-03-29 Thread AJDIN BRANDIC
I am doing similar thing and it works fine, never had any probs. In your example you are missing a ' insert into pictures values ('c:\pictures\computer.gif'); Ajdin On Thu, 29 Mar 2001, Roy Wasse wrote: > Hello MySQL fanatics, > > My problem is the following: > > I want to store a filelink

Re: Free Hosting

2001-03-09 Thread AJDIN BRANDIC
Try www.f2s.com Ajdin On Fri, 9 Mar 2001, Cally wrote: > Does anyone know where to get a hosting that is free to support MySql with PHP. > I need to try out first before purchase a parking space at internet. > > Regards > Cally > --

Re: Some newbie question...

2001-01-30 Thread AJDIN BRANDIC
Check lock/unlock table in the manual http://www.mysql.com/doc/L/O/LOCK_TABLES.html ie. LOCK TABLES tbl_name WRITE (or READ) insert ... select ... UNLOCK TABLES On Tue, 30 Jan 2001, Nino Katic wrote: > Hi, > > How to solve this: > TABLE: shop > FIELD: article int unsigned auto_increment > >