Ye Wang wrote: > We just installed CFMX on a brand new server, W2k with SQL 2000. Most > CF5 codes worked and no problems with stored procedures so far, except a > few errors on simple queries. One of them was quite weird. > > Name : VARCHAR(128) > Cost: real > tableA joins tableB on (tableA.ID = tableB.aID)
The datatypes of tableA.ID and tableB.aID are probably more relevant. Jochem ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists