RE: urgent help needed on replication on windows 2000
Hi,
I am using release 5.
What is the release you recommend for such a scenario.
Regards,
Anup Mahansaria
"Dathan Vance
Pattishall"
<[EMAIL PROTECTED] To
r.com><[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
04/01/04 11:40 AM cc
Subject
RE: urgent help needed on
replication on windows 2000
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help needed on replication on windows 2000
>
>
>
>
>
> Hi,
>
> I am working on mysql repliction on windows 2000.
>
> I am trying to make the slave as master when the master goes down. When I
> execute the io thread shutdown on slave after master goes down, it hangs.
> Even the slave server does not stop on executing the shutdown command
> using
> mysqladmin and root user.
>
>
> Regards,
> Anup Mahansaria
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: urgent help needed on replication on windows 2000
What version of mySQL are you using, 4.0.19 (not yet released) fixes something similar to what you have described. -- DVP > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 31, 2004 7:49 PM > To: [EMAIL PROTECTED] > Subject: urgent help needed on replication on windows 2000 > > > > > > Hi, > > I am working on mysql repliction on windows 2000. > > I am trying to make the slave as master when the master goes down. When I > execute the io thread shutdown on slave after master goes down, it hangs. > Even the slave server does not stop on executing the shutdown command > using > mysqladmin and root user. > > > Regards, > Anup Mahansaria > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote: > Hi, > > I could not find the binary for SCO Unixware (Intel based) in download > section. I suppose mysql supports this environment too. May I know as to > where can I find this binary. Do I need to build this myself? There are some version on ftp.zenez.com in the pub/zenez/prgms directory. You may want to try one of them. -- Boyd Gerber <[EMAIL PROTECTED]> ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Thanks Chris. Will get back to you if I get some problem.
Regards,
Anup Mahansaria
Chris Nolan
<[EMAIL PROTECTED]
> To
[EMAIL PROTECTED]
02/11/04 09:32 AM cc
[EMAIL PROTECTED]
Subject
Re: Urgent help needed - SCO Unix
binary
Basically, the stability of the build is dependant on the following
factors:
* Suitable functions in your C library for threaded applications.
UnixWare is apparently fine in this category and doesn't require any
workarounds. Installing the latest patches and things would be in your
best interest though.
* The compiler you use.
I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the
recommended compilers for building MySQL binaries. If you install this
and can get a clean compile, you'll probably be fine.
Regards,
Chris
[EMAIL PROTECTED] wrote:
>
>
>Hi Chris,
>
>I want it on SCO Unixware 7.1.1 (intel based)
>
>I did see it in the installation manual of MySQL where they give some
>instructions for building the binaries for SCO Unixware. Can I go ahead
and
>build it. How do you see the stability factor of such builds.
>
>Regards,
>Anup Mahansaria
>
>
>
>
>
> Chris Nolan
> <[EMAIL PROTECTED]
> > To
> [EMAIL PROTECTED]
> 02/10/04 07:47 PM cc
> [EMAIL PROTECTED]
> Subject
> Re: Urgent help needed - SCO Unix
> binary
>
>
>
>
>
>
>
>
>
>
>Hi!
>
>If memory serves me correctly, MySQL AB have stopped issuing SCO
>OpenServer and SCO UnixWare binaries publicly and will only be providing
>them to customers who take out commercial licences. This is probably due
>to the fact that OpenServer and UnixWare cost a lot compared ot other
>OSes, don't represent a huge percentage of the MySQL userbase and that
>the UDK for each is some disgusting amount to purchase.
>
>Which version of UnixWare is it? A workaround might be available in the
>form of the Linux Kernel Personality. Additionally, the Skunkware
>repository might be able to help you out if SCO's servers are currently
>accessible in this virus-infested internet we all wade in.
>
>I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1
>(they had a copy that a mate sold them cheap) for this and a few other
>reasons (including "Wow! The Redhat desktop looks pretty!").
>
>Regards,
>
>Chris
>
>[EMAIL PROTECTED] wrote:
>
>
>
>>Hi,
>>
>>I could not find the binary for SCO Unixware (Intel based) in download
>>section. I suppose mysql supports this environment too. May I know as to
>>where can I find this binary. Do I need to build this myself?
>>
>>TIA
>>
>>Regards,
>>Anup Mahansaria
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Basically, the stability of the build is dependant on the following factors:
* Suitable functions in your C library for threaded applications.
UnixWare is apparently fine in this category and doesn't require any
workarounds. Installing the latest patches and things would be in your
best interest though.
* The compiler you use.
I'm pretty sure that Skunkware includes GCC 2.95.x . This is one of the
recommended compilers for building MySQL binaries. If you install this
and can get a clean compile, you'll probably be fine.
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi Chris,
I want it on SCO Unixware 7.1.1 (intel based)
I did see it in the installation manual of MySQL where they give some
instructions for building the binaries for SCO Unixware. Can I go ahead and
build it. How do you see the stability factor of such builds.
Regards,
Anup Mahansaria
Chris Nolan
<[EMAIL PROTECTED]
> To
[EMAIL PROTECTED]
02/10/04 07:47 PM cc
[EMAIL PROTECTED]
Subject
Re: Urgent help needed - SCO Unix
binary
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes, don't represent a huge percentage of the MySQL userbase and that
the UDK for each is some disgusting amount to purchase.
Which version of UnixWare is it? A workaround might be available in the
form of the Linux Kernel Personality. Additionally, the Skunkware
repository might be able to help you out if SCO's servers are currently
accessible in this virus-infested internet we all wade in.
I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1
(they had a copy that a mate sold them cheap) for this and a few other
reasons (including "Wow! The Redhat desktop looks pretty!").
Regards,
Chris
[EMAIL PROTECTED] wrote:
Hi,
I could not find the binary for SCO Unixware (Intel based) in download
section. I suppose mysql supports this environment too. May I know as to
where can I find this binary. Do I need to build this myself?
TIA
Regards,
Anup Mahansaria
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent help needed - SCO Unix binary
Hi! If memory serves me correctly, MySQL AB have stopped issuing SCO OpenServer and SCO UnixWare binaries publicly and will only be providing them to customers who take out commercial licences. This is probably due to the fact that OpenServer and UnixWare cost a lot compared ot other OSes, don't represent a huge percentage of the MySQL userbase and that the UDK for each is some disgusting amount to purchase. Which version of UnixWare is it? A workaround might be available in the form of the Linux Kernel Personality. Additionally, the Skunkware repository might be able to help you out if SCO's servers are currently accessible in this virus-infested internet we all wade in. I recently migrated a customer from UnixWare 7.1.1 to Redhat AS 2.1 (they had a copy that a mate sold them cheap) for this and a few other reasons (including "Wow! The Redhat desktop looks pretty!"). Regards, Chris [EMAIL PROTECTED] wrote: Hi, I could not find the binary for SCO Unixware (Intel based) in download section. I suppose mysql supports this environment too. May I know as to where can I find this binary. Do I need to build this myself? TIA Regards, Anup Mahansaria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent Help needed
> It looks like you have a dynamic IP your end and the mysql > server is looking > for a fixed IP. Nope, you read it wrong, both of you. MySQL is printing out YOUR IP address, not the address of the server. It's complaining that you don't have permission to access the data you want. sql, query. - 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
RE: Urgent Help needed
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Try name based DNS form your PC. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net] Sent: 18 October 2002 09:38 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Urgent Help needed Hi all, I have used the following script to connect our remote database from my local machine. The PHP script is at my local machine. When I tried to connect the database, instead of connecting to the IP provided in the script, it is searching the Dynamic IP of my Internet Service Provider. and getting the following error. Script in my local machine is : The IP 216.180.237.200 is the IP provided by my Web space provider. The error message is, Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php on line 2 Warning: MySQL Connection Failed: Access denied for user:'[EMAIL PROTECTED]' (Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php on line 2 cannot connect to mysqld The IP 203.100.234.139 is the Dynamic IP of my Internet Service Provider. Please help me to sort out the problem. Regards, Vinod. - 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 - 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
Re: Urgent Help needed
Hi Srinivas,
Here is some info, may meet ur requirement.
ALTER TABLE syntax :-
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
orADD INDEX [index_name] (index_col_name,...)
orADD PRIMARY KEY (index_col_name,...)
orADD UNIQUE [index_name] (index_col_name,...)
orALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
orCHANGE [COLUMN] old_col_name create_definition
orMODIFY [COLUMN] create_definition
orDROP [COLUMN] col_name
orDROP PRIMARY KEY
orDROP INDEX key_name
orRENAME [AS] new_tbl_name
ortable_option
ALTER TABLE allows you to change the structure of an existing table. For
example, you can add or delete columns, create or destroy indexes, change
the type of existing columns, or rename columns or the table itself. You can
also change the comment for the table and type of the table. See section 7.6
CREATE TABLE syntax.
If you use ALTER TABLE to change a column specification but DESCRIBE
tbl_name indicates that your column was not changed, it is possible that
MySQL ignored your modification for one of the reasons described in section
7.6.1 Silent column specification changes. For example, if you try to change
a VARCHAR column to CHAR, MySQL will still use VARCHAR if the table contains
other variable-length columns.
ALTER TABLE works by making a temporary copy of the original table. The
alteration is performed on the copy, then the original table is deleted and
the new one is renamed. This is done in such a way that all updates are
automatically redirected to the new table without any failed updates. While
ALTER TABLE is executing, the original table is readable by other clients.
Updates and writes to the table are stalled until the new table is ready.
To use ALTER TABLE, you need select, insert, delete, update, create and drop
privileges on the table.
IGNORE is a MySQL extension to ANSI SQL92. It controls how ALTER TABLE works
if there are duplicates on unique keys in the new table. If IGNORE isn't
specified, the copy is aborted and rolled back. If IGNORE is specified, then
for rows with duplicates on a unique key, only the first row is used; the
others are deleted.
You can issue multiple ADD, ALTER, DROP and CHANGE clauses in a single ALTER
TABLE statement. This is a MySQL extension to ANSI SQL92, which allows only
one of each clause per ALTER TABLE statement.
CHANGE col_name, DROP col_name and DROP INDEX are MySQL extensions to ANSI
SQL92.
MODIFY is an Oracle extension to ALTER TABLE.
The optional word COLUMN is a pure noise word and can be omitted.
If you use ALTER TABLE tbl_name RENAME AS new_name without any other
options, MySQL simply renames the files that correspond to the table
tbl_name. There is no need to create the temporary table.
create_definition clauses use the same syntax for ADD and CHANGE as for
CREATE TABLE. Note that this syntax includes the column name, not just the
column type. See section 7.6 CREATE TABLE syntax.
You can rename a column using a CHANGE old_col_name create_definition
clause. To do so, specify the old and new column names and the type that the
column currently has. For example, to rename an INTEGER column from a to b,
you can do this:
mysql> ALTER TABLE t1 CHANGE a b INTEGER;
If you want to change a column's type but not the name, CHANGE syntax still
requires two column names even if they are the same. For example:
mysql> ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;
However, as of MySQL 3.22.16a, you can also use MODIFY to change a column's
type without renaming it:
mysql> ALTER TABLE t1 MODIFY b BIGINT NOT NULL;
If you use CHANGE or MODIFY to shorten a column for which an index exists on
part of the column (for instance, if you have an index on the first 10
characters of a VARCHAR column), you cannot make the column shorter than the
number of characters that are indexed.
When you change a column type using CHANGE or MODIFY, MySQL tries to convert
data to the new type as well as possible.
In MySQL 3.22 or later, you can use FIRST or ADD ... AFTER col_name to add a
column at a specific position within a table row. The default is to add the
column last.
ALTER COLUMN specifies a new default value for a column or removes the old
default value. If the old default is removed and the column can be NULL, the
new default is NULL. If the column cannot be NULL, MySQL assigns a default
value. Default value assignment is described in section 7.6 CREATE TABLE
syntax.
DROP INDEX removes an index. This is a MySQL extension to ANSI SQL92.
If columns are dropped from a table, the columns are also removed from any
index of which they are a part. If all columns that make up an index are
dropped, the index is dropped as well.
DROP PRIMARY KEY drops the primary index. If no such index exists, it drops
the first UNIQUE index in the table. (MySQL marks the first UNIQUE key as
the PRIMARY KEY if no PRIMARY KEY was
Re: Urgent Help needed for installing
>>> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired >with both the binary distro and source distro with no luck. The install seems to go >OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 >system. >>> >>> Please disregard this posting, after blowing everything out and starting from >>> scratch I was finally able to get the source distro successfully installed now! >>> :) >>> >>> Just one other question, I thought that the source distro 3.23.40 came with BDB >>> table handlers enabled by default?? Come find out it doesn't!! Is there >>> something else that needs to be done during the install to enable BDB table >>> handlers?? Thanks Matt! I looked all over the manual, and I'll be damn if I could find that! Oh well :) Thx's >>On Wed, 25 Jul 2001 16:08:52 -0500, Matt Wagner <[EMAIL PROTECTED]> wrote: >>Hi, >> >>Please read: >> >> http://www.mysql.com/doc/B/D/BDB_install.html >> >> >>Regards, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Re: Urgent Help needed for installing
At 4:08 PM -0500 7/25/01, MikeBlezien wrote: >On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > >>>Source distributions don't really come with any table handler enabled >>>by default, because there are no binaries included in the distribution. >>>To see what options control the table handlers, run this command: >>> >>> ./configure --help | more > >Paul, > >So this would have to be done thur the install of the source distro?? Yes. That's what you were asking about, weren't you? Binary distributions don't include a configure script. > >Do I need to re-install the source again to use BDB tables?? You need to recompile, then reinstall the binaries that the recompilation builds, yes. > >Mike(mickalo)Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Thunder Rain Internet Publishing >Providing Internet Solutions that work! >http://www.thunder-rain.com >Tel: 1(225)686-2002 >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- Paul DuBois, [EMAIL PROTECTED] - 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
Re: Urgent Help needed for installing
"MikeBlezien" <[EMAIL PROTECTED]> writes: > Hello All, > > >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired >with both the binary distro and source distro with no luck. The install seems to go >OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 >system. > > Please disregard this posting, after blowing everything out and starting from > scratch I was finally able to get the source distro successfully installed now! > :) > > Just one other question, I thought that the source distro 3.23.40 came with BDB > table handlers enabled by default?? Come find out it doesn't!! Is there > something else that needs to be done during the install to enable BDB table > handlers?? Hi, Please read: http://www.mysql.com/doc/B/D/BDB_install.html Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA <___/ www.mysql.com - 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
Re: Urgent Help needed for installing
On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: >>Source distributions don't really come with any table handler enabled >>by default, because there are no binaries included in the distribution. >>To see what options control the table handlers, run this command: >> >> ./configure --help | more Paul, So this would have to be done thur the install of the source distro?? Do I need to re-install the source again to use BDB tables?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Re: Urgent Help needed for installing
At 2:55 PM -0500 7/25/01, MikeBlezien wrote: >Hello All, > >>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 >>>I have tired with both the binary distro and source distro with no >>>luck. The install seems to go OK, but I can't start the mysql >>>server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686 system. > >Please disregard this posting, after blowing everything out and starting from >scratch I was finally able to get the source distro successfully >installed now! >:) > >Just one other question, I thought that the source distro 3.23.40 >came with BDB >table handlers enabled by default?? Come find out it doesn't!! Is there >something else that needs to be done during the install to enable BDB table >handlers?? Source distributions don't really come with any table handler enabled by default, because there are no binaries included in the distribution. To see what options control the table handlers, run this command: ./configure --help | more > >THX's > >Mike(mickalo)Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Thunder Rain Internet Publishing >Providing Internet Solutions that work! >http://www.thunder-rain.com >Tel: 1(225)686-2002 >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- Paul DuBois, [EMAIL PROTECTED] - 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
Re: Urgent Help Needed
Hi,
Tried that and also got an error, I just hope someone has had to do this type
of search!! Would have thought so!
Just need to search a MATCH and others at the same time. Thanks all.
Barry
In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes:
<< > The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
> score DESC";
>
> From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Have you tried:
SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo,
wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE
employment_type = '$employment_type' AND location = '$location' AND
related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score
DESC
-
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
--- Headers
Return-Path: <[EMAIL PROTECTED]>
Received: from rly-yc04.mx.aol.com (rly-yc04.mail.aol.com [172.18.149.36])
by air-yc05.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:16
2000
Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by
rly-yc04.mx.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 05:54:11 -0400
Received: (qmail 8607 invoked by uid 7797); 14 May 2001 09:49:46 -
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
List-ID:
Precedence: bulk
List-Help: <mailto:[EMAIL PROTECTED]>
List-Unsubscribe: <mailto:[EMAIL PROTECTED]>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <mailto:[EMAIL PROTECTED]>
Delivered-To: mailing list [EMAIL PROTECTED]
Received: (qmail 8567 invoked from network); 14 May 2001 09:49:45 -
From: "Chris Bolt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Urgent Help Needed
Date: Mon, 14 May 2001 03:52:32 -0600
Message-ID: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
In-Reply-To: <[EMAIL PROTECTED]>
Importance: Normal
>>
-
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
Re: Urgent Help Needed
Hi I escape all the characters as the values are passed to the page.
It is driving me mad, just to get this to work! Not many people I know have
the solution. I would have thought searching FULLTEXT and other fields at
the same time would be easy. Any help again appreciated.
Barry
In a message dated 14/5/01 11:02:42 am, [EMAIL PROTECTED] writes:
<< Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTECTED] wrote:
>
> Hi Group,
>
> I posted this question before, and need help urgently. The problem is using
a
> specific search! What we are trying to do is intially search 3 fields and
> then once the results are found it needs to be able to narrow down the
> results by searching the intial 3 criteria and also a keywords search on a
> full text index. I have tried but got no success as I keep getting SYNTAX
> error. Can anyone please help, this is most urgent.
>
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>
> >From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
>
> Is there a specific way we need to do this query! Basically we are trying to
> do a MATCH and additional query on the same. Your help is truly appreciated.
>
> Thanks
>
> Barry Zimmerman
>
> -
> 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
--- Headers
Return-Path: <[EMAIL PROTECTED]>
Received: from rly-zd02.mx.aol.com (rly-zd02.mail.aol.com [172.31.33.226])
by air-zd01.mail.aol.com (v77_r1.36) with ESMTP; Mon, 14 May 2001 06:02:42
2000
Received: from smtp-gw.netclub.com (home.paris.trader.com [195.68.19.162])
by rly-zd02.mx.aol.com (v78.43) with ESMTP; Mon, 14 May 2001 06:02:30 -0400
Received: from [127.0.0.1] (helo=trader.com)
by smtp-gw.netclub.com with esmtp (Exim 3.13 #1)
id 14zFBm-Mi-00; Mon, 14 May 2001 12:02:54 +0200
Sender: jbueno
Message-ID: <[EMAIL PROTECTED]>
Date: Mon, 14 May 2001 12:02:54 +0200
From: Joseph Bueno <[EMAIL PROTECTED]>
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdkfb i686)
X-Accept-Language: en
MIME-Version: 1.0
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Urgent Help Needed
References: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
>>
-
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
Re: Urgent Help Needed
Hi,
Does $keywords contain a quote ?
You must escape special characters in strings before using them in SQL
statements. If you are using Perl DBI look use 'quote' function otherwise,
check MySQL API for your programming language.
Hope this helps
--
Joseph Bueno
NetClub/Trader.com
[EMAIL PROTECTED] wrote:
>
> Hi Group,
>
> I posted this question before, and need help urgently. The problem is using a
> specific search! What we are trying to do is intially search 3 fields and
> then once the results are found it needs to be able to narrow down the
> results by searching the intial 3 criteria and also a keywords search on a
> full text index. I have tried but got no success as I keep getting SYNTAX
> error. Can anyone please help, this is most urgent.
>
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY score DESC";
>
> >From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
>
> Is there a specific way we need to do this query! Basically we are trying to
> do a MATCH and additional query on the same. Your help is truly appreciated.
>
> Thanks
>
> Barry Zimmerman
>
> -
> 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
-
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
RE: Urgent Help Needed
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
> score DESC";
>
> From this we get the following error:
>
> You have an error in your SQL syntax near ' MATCH specific_work_profile,
> wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('CE' at line 1
Have you tried:
SELECT * FROM cvtemplate, MATCH (specific_work_profile, wxcdone, wxcdtwo,
wxcdthree, wxcdfour) AGAINST ('$keywords') AS score FROM cvtemplate WHERE
employment_type = '$employment_type' AND location = '$location' AND
related_discipline = '$related_discipline' HAVING score != 0 ORDER BY score
DESC
-
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
