> I have a zipcode table that is driving me nuts... > > If I open query analyzer and say > > SELECT * FROM zip WHERE zipcode = 'valid zipcode' I get nothing back > > but if I say > > SELECT zipcode from zip I get all the zips back and the valid zipcode > from the first query is listed in there. Why cannot I not get anything > with a conditional statement in there? > > > Thanks
NEVERMIND!! I created a new table a loaded it with info and everything works fine. I guess it was corrupt or something. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
