RE: MySQL Customer Survey :: an exercise in frustration

Well, there was some other parameters with a special "XDHFSKL324234234" style code at the end, which I figured was tied to me directly somehow, so I didn't want to post that -- for exactly this reason below. *wink* The survey was emailed to "us". > -Original Message- > From: Chris Sansom

Re: Maybe a bit OT: MySQL forum recommendation?

On 12/3/07, Chris Sansom <[EMAIL PROTECTED]> wrote: > > My apologies in advance if this is a bit off topic, but... > > On a rather old site we have a dreadful old bulletin board system > based on Matt Wright's WWWBoard - all horrid text files and ancient > Perl code. We want to replace that with a

Maybe a bit OT: MySQL forum recommendation?

My apologies in advance if this is a bit off topic, but... On a rather old site we have a dreadful old bulletin board system based on Matt Wright's WWWBoard - all horrid text files and ancient Perl code. We want to replace that with a decent forum system based on MySQL and PHP, but there's no

Re: MySQL Customer Survey :: an exercise in frustration

At 13:19 -0800 3/12/07, Jeremy Cole wrote: I just finished it. There were 56 questions, not counting the final "give us your name" stuff for the prize. Most of the questions were mandatory. This seems to be a "fill out the form" type of survey system rather than a self-adjusting system base

RE: speical characters in text column

You need to escape the data read from the form. I'm sure that whatever programming language you are using has some function to do this. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infos

Re: MySQL Customer Survey :: an exercise in frustration

I just finished it. There were 56 questions, not counting the final "give us your name" stuff for the prize. Most of the questions were mandatory. This seems to be a "fill out the form" type of survey system rather than a self-adjusting system based on the answers to your previous questions.

Re: MySQL Customer Survey :: an exercise in frustration

Hi, And, what's up with the vertical white lines on dark blue background as a section divider? My eyes actually hurt looking at the survey page. It makes it *very* difficult to read the questions. Regards, Jeremy Daevid Vincent wrote: I started to take this but gave up, here's a few sug

Re: MySQL Customer Survey :: an exercise in frustration

It occurs to me that this sounds very much like my experience the last couple of times I tried to take the survey... As a long-time user of MySQL, I want to make my contribution, but this survey is a dog's breakfast every time. Perhaps someone at AB might take notice this round and try to fix it

RE: MySQL Customer Survey :: an exercise in frustration

I started to take this but gave up, here's a few suggestions: 1. you have questions that need a "none" option 2. NEVER make the questions mandatory. like #32. I don't give a shit about most of those things, but you force me to check '1' for all of them. that's wasting my time. 3. how many damn qu

speical characters in text column

hi friends, i searched on google but not file a solution. is there a way that i can store special characters (return, new line, tab, etc) into mysql (ver. 4.1.12) table with text type? i use textarea tag for user to enter the text. my goal is to store/display EXACTLY what user entered in the

Re: how to "drop index if exists"

I actually suggested that last night, and thought better of it because the alter ignore was so much simpler... On Dec 3, 2007 11:18 AM, Rolando Edwards <[EMAIL PROTECTED]> wrote: > You may want to check to see if the index exists first. > Just query the table INFORMATION_SCHEMA.STATISTICS: > > SEL

RE: how to "drop index if exists"

You may want to check to see if the index exists first. Just query the table INFORMATION_SCHEMA.STATISTICS: SELECT COUNT(1) FROM INFORMATION_SCHEMA.STATISTICS WHERE table_schema = '' AND table_name = '' AND index_name = ''; This returns the number of columns the index contains. If this query ret

Re: how to "drop index if exists"

On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote: > Folks > > > How can one conditionally drop an index in MySQL? > > Googling shows that the "drop index" does not support an "if exists" > qualifier - apparently a bug > has been raised but as far as I know its not fixed yet. > > D

MySQL University session on December 6

Hi, this Thursday, Sergey Petrunia will give a MySQL University session on: Interaction Between Optimizer and Storage Engine Please register for this session by filling in your name on the session Wiki page that you can find here: http://forge.mysql.com/wiki/Interaction_Between_Optimizer_and

Re: Help with SQL query construction

Marcus, I've managed to do this with a Perl-DBI script, but would much prefer to do it completely with MySQL instead. You could port it to a recursive stored procedure. It would probably be slower, and what would you have gained? PB Marcus Claesson wrote: Hi! I have a "SQL query constru

RE: Help with SQL query construction

> -Original Message- > From: Marcus Claesson [mailto:[EMAIL PROTECTED] > Sent: Monday, December 03, 2007 7:49 AM > To: mysql@lists.mysql.com > Subject: Help with SQL query construction > > Hi! > > I have a "SQL query construction" question that I hope someone can help > me with. After c

Help with SQL query construction

Hi! I have a "SQL query construction" question that I hope someone can help me with. After comparing a bunch of DNA fragments (see name below) with a larger reference sequence I get a ordered list ranked according to similarities, and with start/stop co-ordinates where the fragments map to the ref

Replication error with stored proc and triggers

>Description: I am using MySQL server as backend database supporting a telecomm platform providing voice over ip services. tables involved: acc, cdr, account, location2 Partial processing flow: 1. When a phone call is started. A record will be inserted into table acc (method=INVITE). This will