Re: query problem

2006-02-09 Thread Conor McTernan
|1 | +-+---+--+ for both results. -Sheeri On 2/8/06, Conor McTernan [EMAIL PROTECTED] wrote: Sheeri, The table I'm searching on has a composite primary key since it's mapping an N:M relationship between Cases and Sizes. Here's the create

query problem

2006-02-08 Thread Conor McTernan
Hello, I'm having a hell of a time figuring this query out, maybe someone can point me in the right direction. I have a table which lists the case configurations for cases of items. Each case will have a different combination of sizes e.g. Case 002 has 2 size 5, 2 size 7 and 2 size 8 items. What

Re: query problem

2006-02-08 Thread Conor McTernan
, The table you showed us has 2 primary keys, which is not possible. Can you do a SHOW CREATE TABLE on *each* table? -Sheeri On 2/8/06, Conor McTernan [EMAIL PROTECTED] wrote: Hello, I'm having a hell of a time figuring this query out, maybe someone can point me in the right direction. I have

Re: tutorial sites

2006-01-08 Thread Conor McTernan
If you're learning PHP I'd take a look at http://www.phpbuilder.com. They have a lot of good atricles and tutorials on setting it up and things you can do with it. I pretty much thought myself PHP through that site a couple of years back. They have pretty active forums if you have any questions

mysql/lotus approach question(sort of)

2001-08-13 Thread Conor McTernan
Hey there, sorry about the cross post, but whenever i mail the ODBC list, i tend not to get any replies. I posted a couple of weeks ago with this problem, basicially I am using lotus approach to access a mysql database through myodbc. it seems that i can only ever return approx 200 or so

strange myodbc problem

2001-07-30 Thread Conor McTernan
Hey there, Sorry for posting to this list, but I'm not so sure it's a myodbc problem exclusively. I am currently trying to get a mysql database to work with lotus approach. The plan is to port a current .dbf database over to mysql, and so far I have not had many problems. Until now. I am not

using mysql wiht lotus approach

2001-07-04 Thread Conor McTernan
sorry for asking this question here, i'm sure it's a myODBC question, but i asked there a couple of days ago and got no responce I was just wondering if anyone has much experience of using a MySql backend for an approach APR, using of course myODBC. I've been playing around wiht the idea of