Run: SELECT * FROM dbo.Vehicles WHERE (StockNo='#form.carid#')
and see if that returns a row. On Tue, Feb 3, 2009 at 6:34 PM, Rick Sanders <r...@webenergy.ca> wrote: > > I've been trying to figure this one out. The query gets hit, but the > database isn't being updated from the values in the form. The columns seem > valid, and the table permissions are fine. > > > > I'm using SQL Server 2005. > > > > Here's the query: > > > > UPDATE dbo.Vehicles SET > > StockNo='#form.stockno#',CarMake=#form.make#,CarModel='#form.model#',ModelTr > > im='#form.trim#',CarYear=#form.caryear#,Category=#form.category#,Mileage='#f > > orm.mileage#',unit='km',VIN='#form.vin#',EngineSize='#form.engine#',Transmis > > sion='#form.trans#',Drivetrain='#form.drivetrain#',Price=#form.price#,Warran > ty='#form.warranty#',Description='#form.description#',Inspected='#form.mm# > ', > > Financing='#form.financing#',Leasing='#form.leasing#',Active='#form.active#' > > ,Featured='#form.featured#',Pic1='#pic1#',Pic2='#pic2#',Pic3='#pic3#',Pic4=' > > #pic4#',thumb1='#pic1t#',thumb2='#pic2t#',thumb3='#pic3t#',thumb4='#pic4t#', > > Sold='#form.sold#',SoldPrice=#form.soldamt#,VehicleCost=#form.cost#,MVIcost= > > #form.mvicost#,Reconditioning='#form.reconditioning#',ReconditioningCost=#fo > > rm.reconcost#,Parts='#form.parts#',PartsCost=#form.partscost#,Labour='#form. > labour#',LabourCost=#form.labourcost# WHERE (StockNo='#form.carid#') > > > > Thanks for any help! > > > > Rick Sanders > > Webenergy > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:318807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
