UPDATE DISTINCTROW ID data match problem

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

UPDATE DISTINCTROW ID data match problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> UPDATE DISTINCTROW ID data match problem

Page: [1]

wlp

Posts: 54
From: None
Status: offline

UPDATE DISTINCTROW ID data match problem - 3/26/2001 22:56:00

I successfully use UPDATE and DELETE DISTINCTROW with FIRST_NAME etc. but when I use ID which is the keycode and autonumber for almost each table. (although none of them are linked at this time) I receive specific error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers

Can you help? I have read ypur great article about exactly this and you intelgently use the ID to identify a row as opposed to other microsoft experts who use fistName and LastName to do so, I still does not work.

Help

John Stafford


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: UPDATE DISTINCTROW ID data match problem - 3/27/2001 20:03:00 Hi John, check that you have not placed any quotes around the ID eg where ID = ::ID:: (in reply to wlp)

wlp

Posts: 54
From: None
Status: offline

RE: UPDATE DISTINCTROW ID data match problem - 3/27/2001 20:04:00

I do have quotes i.e.
DELETE DISTINCTROW First_Name
FROM upctmembers
WHERE (First_Name='::First_Name::')
AND (Last_Name='::Last_Name::')

as described in all the microsoft documentation. I will try. Why no quotes?

John

(in reply to wlp)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: UPDATE DISTINCTROW ID data match problem - 3/27/2001 20:00:00 I dont see the ID in that SQL? All numeric fields dont have quotes, text fields do. (in reply to wlp)

wlp

Posts: 54
From: None
Status: offline

RE: UPDATE DISTINCTROW ID data match problem - 4/2/2001 22:18:00

Sorry to take so long to get back to you. Everything works great. I amjust learning sql stuff and that was simply not to put the quotes around a number field.

Thanks so much by farthe best and quickest help on Frontpage in hte world.

(in reply to wlp)