RE: SQL Query Question

Ah, that would work. Looks like I was making the problem too complex in my mind, thanks for your help. Adam Bishop -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: 22 January 2007 07:07 To: Adam Bishop Cc: mysql@lists.mysql.com Subject: Re: SQL Query Question In the

Re: SQL Query Question

In the last episode (Jan 22), Adam Bishop said: > If I have a dataset as below: > > Name, Age, Word > > Bob, 13, bill > Joe, 13, oxo > Alex, 14, thing > Jim, 14, blob > Phil, 14, whatsit > Ben, 15, doodah > Rodney, 15, thingy > > I want to select the first block where

Is there C API function to convert the MYSQL_ROW items from string to Language specified type?

Hi all: Is there a C API function to convert the MYSQL_ROW items from string to Language specified type? I thought there should be one, but I can't find it. Could you give me some advice? Appreciate your help! -- David

Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

The second major problem I am running into after the upgrade is the following error, which did not occur on Development. Error Executing Database Query. Cannot convert value '-00-00 00:00:00' from column 4 to TIMESTAMP. The error occurred on line 8. MySQL version is: 5.0.27 Thanks in ad

FOUND_ROWS() returns wrong result

Hi, I've installed MySQL 5.0.27 on a LIVE environment while DEVELOPMENT runs a lower version, yes I know wrong thing to do. I've run into quite a few issues which are causing me lots of problems, the main one being that FOUND_ROWS() return a wrong result. The queries in questions are SELECT

SQL Query Question

If I have a dataset as below: Name, Age, Word Bob, 13, bill Joe, 13, oxo Alex, 14, thing Jim, 14, blob Phil, 14, whatsit Ben, 15, doodah Rodney, 15, thingy I want to select the first block where the age is equal, i.e. return in the case of the above set,

Include a stored procedure ( that returns a recordset ) in another query

Hi all. I'd like to be able to define a stored procedure that returns a recordset ( I've done this bit ), and then select from this in another query, eg: CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT ) BEGIN select * from mirror_Clients where AccMan = ACCMAN; END ... and t

How to convert the the string row[i] to its real type.

Hi all: I use mysql C API , and I want generate JSON object from mysql recordset, the filed value of JSON should be real type , e.g. int, float, ect. but the value I got using mysql_fetch_row() is strings, I can get its type using field->type, and then convert the values. but it is not convin

Re: Visual Basic 6 + MySQL

Just FYI: you can get the "Express" version of the VB.Net portion of Visual Studio for free: http://msdn.microsoft.com/vstudio/express/default.aspx That way, you're much more likely to have a fully supported app. I've not tried running VB6 apps on Vista. :) I wasn't able to find the EULA for t

Re: Visual Basic 6 + MySQL

Hello John, All the links visible on the site are workink. I should have explained myself better... There are other articles that used to be there that are missing like the sshtunnel tutorial which used to be at: http://www.vbmysql.com/articles/sshtunnel.html and other links that teached to co

Re: Visual Basic 6 + MySQL

Nuno Vaz Oliveira wrote: Hello! I'm thinking to develop a database interface for our company and I thought "great" when I discovered that Visual Basic 6 was able to interact with MySQL. That's because VB6 is very easy and PHP (even being fast, but its hard for me) gets slower because the sou

Re: changing from mysql5 to mysql4

Thanks for your answer. The install of Koha fails after entering my password root for sql. This is the message error : CREATING DATABASE Creating the MySQL database for Koha... 0 ERROR 1064 (42000) at line 772: You have an error in your SQL syntax; check the manual that corresponds to your My

Re: Query skips one set of records

Peter (and Felix), Thank you, and I learned something today. Now I have a script that needs adjusting. The amount certainly is "indeterminate". The wonder is that we were able to run with this for so long. Regards - Miles At 03:57 PM 1/21/2007, Peter Brawley wrote: Miles Try it yourself w

Re: changing from mysql5 to mysql4

At 02:55 PM 1/21/2007, Thibaud Hulin wrote: Hello ! I need of koha, a software for libraries. It works with mysql 4, but it's not compatible with mysql5. How can do this changement with a Debian Etch ? Must I only remove the one and install the other ? Thanks for help, Thibaud. -- MySQL Gen

Re: Query skips one set of records

Miles Try it yourself with table tbl (id,cost) with rows (1,10),(1,50),(2,100): SELECT id, IF( cost=10, SUM(cost*2 )+ 200, SUM(cost*12)) AS Amount FROM tbl GROUP BY id,cost; +--++ | id | Amount | +--++ |1 |320 | |2 | 1200 | +--++ SELECT id,

Re: Query skips one set of records

At 03:58 AM 1/19/2007, Felix Geerinckx wrote: [EMAIL PROTECTED] (Miles Thompson) wrote in news:[EMAIL PROTECTED]: > This query: > > SELECT > member_id, > member_sub_id, > IF( ( monthly_cost = 10 ), ( SUM(( monthly_cost * 2.00 ) + 200 ) > ), ( SUM( > monthly_cost * 12.00 ) )

changing from mysql5 to mysql4

Hello ! I need of koha, a software for libraries. It works with mysql 4, but it's not compatible with mysql5. How can do this changement with a Debian Etch ? Must I only remove the one and install the other ? Thanks for help, Thibaud. -- MySQL General Mailing List For list archives: http://li

Re: Query skips one set of records

At 12:14 AM 1/19/2007, Dan Nelson wrote: In the last episode (Jan 18), Miles Thompson said: > The query displayed below performs flawlessly, except for these two records: > > 7364 M0174000250510 Invoice 2006-12-13 2006-12-13 2006-12-31 > 7365 M01740 00

Re: Visual Basic 6 + MySQL

On Sunday 21 January 2007 08:17, Nuno Vaz Oliveira wrote: > Hello Miles, > > > At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: > > > > Why VB6? This isn't an anti-Microsoft position, but that language has > > been left to die on the vine. So I'd think about .NET, or RealBASIC, > > or ... or Yo

Re: Visual Basic 6 + MySQL

Nuno Vaz Oliveira wrote: > Hello John, >> Anybody in here think of http://www.vbmysql.com? >> > > The site is not working correctly :( > > I've found a lot of references to that site but the articles are all > missing. > This article isn't missing: http://www.vbmysql.com/articles/vb6-mysql/ac

Re: Visual Basic 6 + MySQL

Hello John, Anybody in here think of http://www.vbmysql.com? The site is not working correctly :( I've found a lot of references to that site but the articles are all missing. Thanks anyway ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Visual Basic 6 + MySQL

Hello Miles, At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: Why VB6? This isn't an anti-Microsoft position, but that language has been left to die on the vine. So I'd think about .NET, or RealBASIC, or ... or You will have to decide. Why VB6? That is an easy one. First, it's the one we h

Re: Visual Basic 6 + MySQL

Anybody in here think of http://www.vbmysql.com? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Visual Basic 6 + MySQL

At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: Hello! I'm thinking to develop a database interface for our company and I thought "great" when I discovered that Visual Basic 6 was able to interact with MySQL. That's because VB6 is very easy and PHP (even being fast, but its hard for me) get