Access DB Update Problems
Posted: Fri May 04, 2007 2:58 am
feyd | Please use
and it is saying that the id = 1160 <- that is where the datatype mismatch is coming. any other number seams to be going through just fine. I have no idea why or whatever. The datatype is set to 'AutoNumber' and it auto increments.
Any ideas would be awesome.
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Ok so sadly I am trying to fix this old site that uses an access DB for its database (/me puking green slime). For some reason I can not update this one row, it keeps saying 'data type mismatch' but when any other ID it works fine. This is the query that won't run:
[syntax="sql"]UPDATE members SET `northhills`='off',`southhills`='off',`downtown`='off',`monroeville`='on', `airportarea`='off',`cranberry`='off',`beaver`='off',`washington`='off', `westmoreland`='off',`sewickley`='off',`status`='active',`employees`='',`discountspecial`='', `contact`='Josh Gross',`company`='Aurora Electrical & Data Services',`street`='2740 Smallman Street',`address2`='Suite 600',`city`='Pittsburgh', `state`='PA',`zip`='15222-4720',`phone`='412-255-4060',`fax`='412-255-4089',`email`='jgross@franklininteriors.com',`url`='', `bd`='',`category`='Electricians',`challenge`='',`membersince`='', `lead`='',`highlight1`='',`highlight2`='', `highlight3`='',`highlight4`='',`highlight5`='',`username`='**',`password`='**' WHERE `id` = 1160Any ideas would be awesome.
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]