RE: Blocking HTML code in inserts?

2008-08-02 Thread Martin Gainty
I'm seeing this more and more I'm hearing the justification that its easier to put an pre-formatted anchor tag or href but you're right if html is stored in the DB then javascript can easily follow of course the overseas contractors sticking in href to their own sites sure does'nt help Glad to

Re: Blocking HTML code in inserts?

2008-08-02 Thread Shannon Wade
assuming php from your sig strip_tags http://www.php.net/manual/en/function.strip-tags.php shannon On Aug 2, 2008, at 5:16 PM, Skip Evans wrote: Hey all, What is the most effective way to block HTML code in insert statements? I have a client with a comments form that is being bombarde

Re: Blocking HTML code in inserts?

2008-08-02 Thread chaim . rieger
Doubt this can be done easily if at all. Accept only text and no html. But even that should be the job of the form validator --Original Message-- From: Skip Evans To: mysql@lists.mysql.com Sent: Aug 2, 2008 14:16 Subject: Blocking HTML code in inserts? Hey all, What is the most effect

Re: Blocking HTML code in inserts?

2008-08-02 Thread Mark Goodge
Skip Evans wrote: Hey all, What is the most effective way to block HTML code in insert statements? I have a client with a comments form that is being bombarded with people inserting references to their own sites, etc, and I need an effective way to filter basically any HTML tags at all. You

Re: Blocking HTML code in inserts?

2008-08-02 Thread Mr. Shawn H. Corey
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote: > Hey all, > > What is the most effective way to block HTML code > in insert statements? > > I have a client with a comments form that is being > bombarded with people inserting references to > their own sites, etc, and I need an effective w

Blocking HTML code in inserts?

2008-08-02 Thread Skip Evans
Hey all, What is the most effective way to block HTML code in insert statements? I have a client with a comments form that is being bombarded with people inserting references to their own sites, etc, and I need an effective way to filter basically any HTML tags at all. Thanks, Skip -- Ski

Re: reset auto increment to a lesser value

2008-08-02 Thread Mark Goodge
Chris W wrote: Mark Goodge wrote: On a more general note, if the actual value of the primary key matters for anything other than simply existing as a primary key, then you shouldn't be using auto-increment at all. You should generate the value through some other means and insert it with the v

Re: reset auto increment to a lesser value

2008-08-02 Thread Chris W
Mark Goodge wrote: On a more general note, if the actual value of the primary key matters for anything other than simply existing as a primary key, then you shouldn't be using auto-increment at all. You should generate the value through some other means and insert it with the value that you w

Re: reset auto increment to a lesser value

2008-08-02 Thread Mark Goodge
abhishek jain wrote: On Sat, Aug 2, 2008 at 10:49 But as per a thread on this link, if the resetted value is less than the highest value already in table then the effective increment value will start from highest number and not from 100. I have deleted some rows and i want the increment to start

Re: reset auto increment to a lesser value

2008-08-02 Thread abhishek jain
On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia <[EMAIL PROTECTED]> wrote: > http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html > > mysql> *ALTER TABLE tbl AUTO_INCREMENT = 100;* > > > > On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain <[EMAIL PROTECTED]> wrote: > >> Hello friends, >> I

reset auto increment to a lesser value

2008-08-02 Thread abhishek jain
Hello friends, I need to reset auto increment to a lesser value, is there a metod to do so in any version of mysql. Pl. help me. Thanks abhi