MySQL + ODBC + palm + security?

2001-08-13 Thread A. Chris Nichols
Hey everyone, Has anyone had any experience establishing a secure connection between a palm device and MySQL database that's on the net? I've setup secure web pages on our webserver that are visible on the web and viewable by wireless palms (securely). Scripts on that interface provide a way

1030: Got error 127 from table handler

2001-06-20 Thread A. Chris Nichols
Hi folks! I have a question for you all... I've got two separate mysql servers running on one machine. Both are 3.22.23b but used for separate instances of separate webservers. I'm having trouble with the "1030: Got error 127 from table handler" error on only one of the servers. Here's the sc

Ideas?: ERROR 1030: Got error 127 from table handler

2001-06-08 Thread A. Chris Nichols
Is there a common cause to the following problem?: mysql> select parent_referral from referral; ERROR 1030: Got error 127 from table handler I can run a describe on the table and I can sucessfully run: select count(*) from referral but if I try to actually query the data in the table I get

Replacing Special / Foreign characters

2001-05-17 Thread A. Chris Nichols
I need to write a replace statement in a query that will replace the lower case e with an accent over it and the uppercase A with an accent over it. Anyone have any suggestions? I'm having trouble with those characters ending up in HTML forms. Thanks, -Chris --

Re: Looking for info on Fuzzy Searching with MySQL

2001-05-14 Thread Chris Nichols
Here's the approach I used for searching through a table that needed to search 7 different fields in the table and weight them differently: I run through this expression for each word that's split from the searchstring and through each field with different weights given to each field. Then th

Re: MySQL FullText improvements in V4.0

2001-05-14 Thread Chris Nichols
I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris On Mon, 14 May 2001, David Simmons - EliteUKServe.Net wrote: > > H

ANSI SQL or MySQL Functions?

2001-05-10 Thread Chris Nichols
Can anyone help point me to a good resource for finding out if particular functions supported by MySQL are ANSI SQL standard functions or if they are MySQL specific? I'm particularly wondering about: concat() if() length() Thanks, -Chris --- [EMAIL PROTECTED]

Re: Removing Bad Characters from Database

2001-05-09 Thread A. Chris Nichols
You can also condense this into one statement if you nest the replace statements: UPDATE table_name SET field_name1=replace(replace(field_name1, '>', ''), '<', '') etc. -Chris At 01:49 PM 5/9/2001, Eric Fitzgerald wrote: >http://www.mysql.com/doc/S/t/String_functions.html > >REPLACE(str,from_s

FILE Permission Security Question

2001-05-08 Thread A. Chris Nichols
Hello everyone, I was wondering if anyone could help me out and explain a bit about the FILE permissions and how they relate to two particular scenarios: In both cases MySQL is running on SunOS 5.7 and running MySQL client version 3.22.23b MySQL UserA has permissions only on DatabaseA and is