Shouldn't it be
WHERE
Part_ID = 751
OR
PART_ID = 752
(Im assuming that each part can only have one Part_id)
-----Original Message-----
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 11:25 AM
To: CF-Talk
Subject: Updating multiple rows!
I am trying to update multiple rows at once and I don't seem to get any
errors but when I try to get the info I just updated nothing is there. Can
someone tell me if this Query should work?
<CFQUERY NAME="engineeringinfo" DATASOURCE="Biosreference" DBTYPE="ODBC">
Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID = 751
AND
PART_ID = 752 etc...
Thanks,
Ben
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
