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 cir

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

n, CT 06032 860.674.8796 / 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 shou

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" wit

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 throu

Re: Type Mismatch

or number of any kind (i.e. if rs("score") is null). HTH! ---- From: Critters <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2007 7:44 AM To: MySQL General Subject: Type Mismatch Hi, I hope someone can help me with my problem, something that

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 xx

Re: stored procedure not working in legacy ASP

30/07, 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 = connec

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 respons

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 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, 27

Re: 1' and '1' or '1

and several links to further info. 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'

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 too

Re: Group By over many colums

nion all (SELECT f4 as 'domain' 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

Re: Group By over many colums

nds) Works, and returns a list where f1, 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&

Re: Group By over many colums

ax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT f1 as domain from sends) union all (SELECT f2 as domain Can you spot where I am going wrong? - David Scott - Original Message - From: "Marco Neves" <[EMAIL PRO

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 GROUP BY name1 ORDER BY count(id) DESC Which would give me: Dave, 2 Joe, 1 But how would I go about getting th

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]>; Sent: Monday, May 23, 2005 3:39 PM Subject: R

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 f

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: Sent: Tuesday, May 17, 2005 5:01 PM Subject: Re: A question of joining... Critters

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 shoul

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) id,

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

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,

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 indexed