You don't say which DBMS your using or what the specific error message
(sometimes they are helpful - although sometimes useless) is but I
think what your after is:
where status = 'i'
Notice that you must quote the values for string or characters. Try
this on your DBMS's command line (no we
It's probably a table definition thing. Is your 'netreceipts' column an
ENUM ? How about your status column - is it a CHAR ? ENUM ? Send us the
table definition for the misbehaving table. Also, send us the error message
before asking what's the solution, we're not mind readers :-))
Your query
SELECT ..
WHERE status IN ('i', 'c', 'o') ;
ORDER BY $sort_field $sort_order";
>>$get_data_query = "select state, cd, representative, status, party,
>>netreceipts,
>>individualcontributions, paccommcontributions, candidatesupport,
>>netdisbursements
>> from fec33104
>>
>>where s
$get_data_query = "select state, cd, representative, status, party,
netreceipts,
individualcontributions, paccommcontributions, candidatesupport,
netdisbursements
from fec33104
where status = i
order by $sort_field $sort_order";
**
On Sat, 29 May 2004 07:50:52 -0700, Daniel Clark <[EMAIL
Can you post the code?
Something like:
WHERE status IN ('i', 'c', 'o') ;
>>This should be ultimately simple; it just doesn't work. I want to limit
>>display to rows from a single table in which the status column contains
>>i. Only options are i, c, o. After the select line I have "
This should be ultimately simple; it just doesn't work. I want to limit
display to rows from a single table in which the status column contains
i. Only options are i, c, o. After the select line I have "where status
= i" (no quote marks). I get an error message to the "while" line that
cal
