You need to use OR instead of AND...you are asking it to find a row where
Part_ID is both 751 AND 752...
You could also say WHERE part_ID IN (751,752)
D
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-----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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
