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 only in the ORDER BY clause > > in the WHERE, each item is interpreted as a literal or column > > you have two literals there, a numeric 1 and a string "orange" > > there's no way in hell that 1 will ever equal "orange" > > what are the two column names in your table? Would you believe I sent this at 13.54 and it only returned to me (and presumably reached the list) at 19.18. After a lot of swearing and making dents in the desk with my head in the intervening hours it occurred to me that numbers (oops, integers) might not be a good idea for column headings. The program picks up some things are wrong - though it give no answers - but this it didn't challenge; just didn't do anything with it. So you are spot on, I changed 1,2 to one,twop (nobody says I'm a good typist) and it worked. I have also been fooled by the difficulty in getting MySql Front to show things have happened. The refresh button does not always do it on one click. DB Manager is only a little better. So I have now made a giant leap for me, and a very tiny step for mankind. (which could still be better than the Mars probe) Thanks Rudy, Joseph Send An Email To: mailto:[EMAIL PROTECTED] > Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > ________________ http://www.wdvl.com _______________________ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > ____ • The WDVL Discussion List from WDVL.COM • ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.