Try using PART_ID =751 OR PART_ID =752 instead of PART_ID =751 AND PART_ID =752 or try
PART_ID IN ('751,752')
not sure if that is correct syntax off the top of my head.
Mark Smyth wrote:
>
> Ben
>
> your code there is trying to update a product which has a productId of 751
> AND 752
>
> it won't find it
> HTH
> Mark
>
> -----Original Message-----
> From: Ben Densmore [mailto:[EMAIL PROTECTED]]
> Sent: 01 June 2001 16:25
> 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
