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: 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