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