[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-23 Thread Joseph, Smile Poet
--- Joseph, Smile Poet wrote: --- : Rudy, : : Alas, alack, I did not see : The truth of what you say to me; : For coding has, of humour, none, : So by number was I undone. : : String theory is the thing I need - : If dimensionally freed - : To tie the ends so loose at p

[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-23 Thread Stephen Caudill
--- Joseph, Smile Poet wrote: --- : Rudy, : : Alas, alack, I did not see : The truth of what you say to me; : For coding has, of humour, none, : So by number was I undone. : : String theory is the thing I need - : If dimensionally freed - : To tie the ends so loose at p

[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-23 Thread Joseph, Smile Poet
Rudy, Alas, alack, I did not see The truth of what you say to me; For coding has, of humour, none, So by number was I undone. String theory is the thing I need - If dimensionally freed - To tie the ends so loose at pres, That get me in an awful mezz. Joseph Chacha Joe For a site of laughs and a

[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-22 Thread rudy
> > hey, did you not like my poem? > > Just shows what MySql does to one - can you refresh my memory on this. soiteny ;o) > SELECT * FROM test WHERE 1 = "orange"; joseph i can see what you were trying to do if it had worked it would have been something new of course the number 1 will nev

[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-22 Thread Joseph, Smile Poet
Rudy, > > SELECT*FROM test WHERE 1="orange"; > > (after much sweat) this appears to be acceptable syntax. > > > hey, did you not like my poem? Just shows what MySql does to one - can you refresh my memory on this. > > > i suspect you want the 1 to refer to the first column > > you can do this on

[wdvltalk] Re: MySql front won't select - 2nd time

2004-01-22 Thread rudy
> SELECT*FROM test WHERE 1="orange"; > (after much sweat) this appears to be acceptable syntax. hey, did you not like my poem? i suspect you want the 1 to refer to the first column you can do this only in the ORDER BY clause in the WHERE, each item is interpreted as a literal or column yo