Re: "Select" & "Order By" OK- ''WHERE'' Does'nt Work !

From: ian justice (i.justice_at_onmail.co.uk)
Date: 11/01/03 

Date: 1 Nov 2003 13:56:12 -0800

"Tom Thackrey" <use.signature@nospam.com> wrote in message news:<FWHob.11451$OS5.8313@newssvr14.news.prodigy.com>...
 
> What error message did you get when you executed the query?
> Are you sure there are records in the table that match your pattern?
> If the syntax is correct, then the problem is probably with the table or
> column names. Are you using reserved words for either of these? Do they
> exist?

The error message was "could not execute query". This is my own error
message as in
$rs=mysql_query($sql, $conn) or die ("could not execute query");

The records do exist i deliberately used simple one-word requests as
well. I also
checked i got the same error message by typing in a load of random
letters in the
text field.
The table is called 'music' and the columns are headed 'song' 'folder'
format' 'artist'.

Whether it's relevant to solving the puzzle, i don't know. But, i
stress again that i am
successfully connected to mysql and the database. As, it does
correctly sort and display
the result by the chosen 'order by' command, be it song, folder,
format or artist.

Relevant Pages

  • Re: IIf dilemma
    ... John, Here is the SQL..... ... The error message I received is......"You tried to execute a query that did ...
    (microsoft.public.access.queries)
  • Re: mySQL Problem
    ... And when the query gets executed i get back the following error: ... near 'from, size, format, cat, host, link, date) VALUES ('bla', '-', ... directly into your mysql query browser...then execute it. ... practices', or, 'standards of practice'. ...
    (comp.lang.php)
  • Re: Numeric Field Overflow
    ... Change the format of any total field from what to what? ... your query please. ... If I then open it in design view and change the format of any total ... Then the error message will occur again. ...
    (comp.databases.ms-access)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... >> What error message did you get when you executed the query? ... or die ("could not execute query because ... > checked i got the same error message by typing in a load of random ... Tom Thackrey www.creative-light.com tom creative light com do NOT send email to jamesbutler@willglen.net ...
    (comp.lang.php)
  • rename a table
    ... I am trying to rename a table from a query by this statement ... Execute sp_rename 'SubMenuItem', 'Portal_MenuSubItems' ... but it gives me an error message: ... No item by the name of 'SubMenuItem' could be found in the current database ...
    (microsoft.public.sqlserver.programming)