RE: info...

2002-05-23 Thread BPrice 

Peter said:
---
hi there ...

can some one point in the right direction .. other than the mysql manul for
mroe information on the INSERT SELECT statement  whether or not it can
handle date inserted from a form on a web page...
---

*Any* database can handle a date inserted from a form on a web page. The
catch
is that *you* have to insure that the date is formatted properly for
insertion
into the database by validating the information returned from the form.


Bob Price
Information Services - Programmer Analyst
ATTORNEYS' TITLE GUARANTY FUND, INC.
217.359.2042 § 800.252.5206, ext. 142
email: [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

error using IN BOOLEAN MODE

2002-02-15 Thread BPrice 

Hello all,

I searched the archives and found no similar problems, so here goes...

Using an almost straight out of the manual example, I am unable to
do a fulltext search using IN BOOLEAN MODE

using the following SQL statement:

SELECT * FROM parts
WHERE MATCH (description)
AGAINST (+brake +pad IN BOOLEAN MODE);

I receive the error:

ERROR 1064: You have an error in your SQL syntax near 'BOOLEAN MODE)' at
line 1

I get this error on both servers listed below:

server version: 3.23.39-max-nt (running on windows 2000)
server version: 3.23.40 (running on redhat 7.1)

I have no problems without the IN BOOLEAN MODE keywords in the statement.

Anything I should know? 


Bob Price
Information Services - Programmer Analyst
ATTORNEYS' TITLE GUARANTY FUND, INC.
217.359.2042 § 800.252.5206, ext. 142
email: [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