Upgraded to SQL 2000 from 6.5 getting query error now

[paladin256]

After upgrading to SQL server 2000 our cold fusion site give me the following error:

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.

select * from prop_desc where prop_item_id= and belongs_to='x' order by it_level


I am not a SQL programmer and searches on google has as of yet yeilded no helpful information.

Can anyone tell me what the issue is. I thought it might be a reservered word but so far have found nothing.

Thank you.

 

[MDXer]

select *
from prop_desc
where prop_item_id= ?
and belongs_to='x'
order by it_level

the error is being thrown because you are using a where clause on prop_item_id but no criteria is being specified for prop_item_id.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck