> 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 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? rudy ____ • 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.