Problem with characters

I have a new setup with mySql version 4.1 and myODBC version 3.51 running on Windows 2k3 standard In the database we have something like And this is £200 and when we write this out in ASP we get And this is ?200 The same happens for some other symbols like the copy write symbol (c in a

Left join is not doing what I thought it should do.

I have 3 tables A users table (userID, userName) A leaderboard table (userID, score) A friends table (userIDA, userIDB) I would like to produce the following result: userName, score, userIDA Dave, 100, 1 Simon, 200, 5 Paul, 300, NULL The 3rd record is NULL as there is no record in friends with

Re: Left join is not doing what I thought it should do.

/ FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Critters [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 12:23 PM To: MySQL General Subject: Left join is not doing what I thought it should do. I have 3 tables A users

A select for a game ranking page.

Hi I have a table with: player_name, top_score, number_of_plays When I list them out I ORDER BY top_score DESC, number_of_plays DESC, player_name to help give some sort of order to the people with the same scores. What I would like to do is find out a players position without looping

Type Mismatch

Hi, I hope someone can help me with my problem, something that has come up when moving code and DB to a new server: Connection: driver={MySQL ODBC 3.51 DRIVER};server=localhost;uid=xx;pwd=xx;database=xx;option=16387 SQL: SELECT (sum_score/sum_votes) AS 'score' FROM

Re: Type Mismatch

(score) is null). HTH! From: Critters [EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 7:44 AM To: MySQL General mysql@lists.mysql.com Subject: Type Mismatch Hi, I hope someone can help me with my problem, something that has come up when moving code and DB

stored procedure not working in legacy ASP

Hi How do you get multiple record sets from a stored procedure in legacy ASP? It doesn't seem to work for us. The question is how to return multiple record sets from a single stored procedure which myodbc doesn't seem to support? set rs = connection.execute(strSQLsp) If not rs.EOF then

Re: stored procedure not working in legacy ASP

, Critters [EMAIL PROTECTED] wrote: Hi How do you get multiple record sets from a stored procedure in legacy ASP? It doesn't seem to work for us. The question is how to return multiple record sets from a single stored procedure which myodbc doesn't seem to support? set rs = connection.execute(strSQLsp

A join I can not figure out

Hi, I am certain this is possible with a single query, but I have had not joy looking on google or using trial and error in MySQL... Table1: id, name Table2: id,member1,member2 In Table2 the member1 and member2 are the ID's from Table1 Table1: 1, Dave 2, Bob 3, Simon Table2: 1,1,2 2,2,3

I think I need a join

I think the following could be done with some sort of JOIN, but I am now sure how: [country]: id, country, number 1, Germany, 27 2, Japan, 30 3, United States, 18 [days] id, day, countryA, countryB 10, monday, 1, 3 11, tuesday, 2, 3 12, wednesday, 1, 2 [result I want] 10, monday, Germany,

1' and '1' or '1

Hi A user was able to log into my site using: 1' and '1' or '1 in the username and password box. I ran the query SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and '1' or '1' And it returned all rows. Can someone explain to me why this happens, and if the steps I

Re: 1' and '1' or '1

. http://en.wikipedia.org/wiki/SQL_injection /Johan Critters wrote: Hi A user was able to log into my site using: 1' and '1' or '1 in the username and password box. I ran the query SELECT * FROM members WHERE name = '1' and '1' or '1' AND password = '1' and '1' or '1' And it returned all rows

Group By over many colums

Hi I have a table setup like this: id, name1, name2, name3 Which has data like this: 1, Dave, Bob, Simon 2, Joe, Tim, Dave 3, Dave, Bob, Tom I can run SELECT name, count(id) FROM tablename GROUP BY name1 ORDER BY count(id) DESC Which would give me: Dave, 2 Joe, 1 But how would I go about

Re: Group By over many colums

@lists.mysql.com Cc: Critters [EMAIL PROTECTED] Sent: Thursday, January 19, 2006 3:34 PM Subject: Re: Group By over many colums Hi, To this on I just see a solution, that depends on sub-selects, so it's available from Mysql 4.1 forward: SELECT name,count(*) from ((SELECT name1 name FROM tablename) UNION ALL

Re: Group By over many colums

, f2, f3 and f4 are all in the column domain But as soon as I add GROUP BY domain to the end it fails. I have also tried GROUP BY 'domain' -- David Scott - Original Message - From: Marco Neves [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: Critters [EMAIL PROTECTED] Sent: Thursday

Re: Group By over many colums

' from sends WHERE gameID = 1) ; SELECT MID(domain,INSTR(domain,'@')+1) AS 'domain' , count(*) from t_sends GROUP by 'domain' And that does the trick Is there any way to destroy the t_sends table? -- Dave - Original Message - From: Marco Neves [EMAIL PROTECTED] To: Critters [EMAIL

Wide eyes

Hi The company I work for is putting together a quote for a site, the client has wide eyes and is proposing 5,000,000 users and other large figures for elements which we intend to use MySQL for. So the questions: Is a table with say 5,000,000+ records possible? What are the things to look out

Re: Wide eyes

Thankyou very much, at this stage we just wanted to know it *can* be done. Thanks again -- David Scott - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: Critters [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, May 23, 2005 3:39 PM Subject: RE: Wide eyes [snip

A question of joining...

Hi, I am having problems with the JOIN function. MESSAGES memberID_1, memberID_2, Message MEMBERS id, name I can only manage to replace the memberID_1 in MESSAGES with the name in MEMBERS, I can not replace both memberID_1 and memberID_2 with name. Please can someone tell me what I should be

Re: A question of joining...

Thankyou, That worked a treat! Thankyou so very much -- David Scott - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: Critters [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, May 17, 2005 5:01 PM Subject: Re: A question of joining... Critters wrote: Hi, I am

Updating one table with results from another..

Hi, I have alot of data and im trying to speed things up by making some summary tables. My summary_totals table has: id, websiteid, hits, visitors This will contain the websiteid, total hits and total visitors. My hits table has (there are many more fields, but they are not relevant to this)

A question of negative numbers..

Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also 5, so in effect all the negative (and only the negative) results are made positive to find the deviation from zero. so 5, 4, -3, 4, -1,

RE: A question of negative numbers..

Found answer to my own question: Returns the absolute value of X: mysql SELECT ABS(2); - 2 mysql SELECT ABS(-32); - 32 This function is safe to use with BIGINT values. MySQL Reference Manual (C) 2002 MySQL AB

slow select... where... order by

Hi I have a database with just over 10,000 records. with the following structure: id, compid, name, score, and about 10 other fields I have indexed id, compid, score about 10 records out of the 10,000 have a compid of 2 when i do select * from table where compid = 2 it was slow until i