Re: Multiple field updates

2003-08-14 Thread Rudi Ahlers
Great thanx, this one worked wonders Kind Regards Rudi Ahlers +27(82) 926 1689 "The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse." - Origin

Advanced text search

2003-08-14 Thread Rudi Ahlers
f "+27-21-564 7389" or "+27-11-661 9000" My statement is as follows: select compid,company,phone from companies where (phone="+27-21-*"); And it doesn't return any records. What am I doing wrong? Kind Regards Rudi Ahlers +27(82) 926 1689 "The basic di

Multiple field updates

2003-08-12 Thread Rudi Ahlers
Hi Can someone please tell me howto update a field (which is auto_increment) for a range from say 4000 - 8000? I only want to change info for listings in that range, if my database has about 75000 listings Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 "The basic diffe