Problem fixed! My dumb error! I was trying to update by vehicle ID using the stock number! Vehicle ID's and stock numbers are different, so no wonder why it didn't update.
Time to step away from the puter. Thanks for listening! -----Original Message----- From: Charlie Griefer [mailto:[email protected]] Sent: February-03-09 9:02 PM To: cf-talk Subject: Re: No SQL Update! StockNo is a char/varchar datatype? On Tue, Feb 3, 2009 at 4:55 PM, <[email protected]> wrote: > > What do you get when you run: > > SELECT * > FROM dbo.Vehicles > WHERE (StockNo='3') > > ~Brad > > -------- Original Message -------- > Subject: RE: No SQL Update! > From: "Rick Sanders" <[email protected]> > Date: Tue, February 03, 2009 6:46 pm > To: cf-talk <[email protected]> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
