Re: Compatibility between AutoNumber and HTML input box
From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 03/12/04
- Next message: Jose A.: "Web Services Authentication!"
- Previous message: Kevin: "Compatibility between AutoNumber and HTML input box"
- In reply to: Kevin: "Compatibility between AutoNumber and HTML input box"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Mar 2004 11:09:43 -0500
Drop the single quotes around the ID value. The single quotes are for
string data
update members set fname = '"&fname&"' where ID = "& ...
"Kevin" <anonymous@discussions.microsoft.com> wrote in message
news:3A481AB6-FD65-46F0-8961-F1D48A52C05C@microsoft.com...
> Hi guys,
> My question is:
> how do you make an AutoNumber table field compatible with HTML input
box...
> As an example, you want to update a record in a table using the AutoNumber
Column as
> the primary key.
>
> Now, I say: update members set fname = '"&fname&"' where ID(autonumber) =
'"&...&"'
>
> then, I get a message saying "DataMismatch"...when i change the AutoNumber
to TEXT, it works...
>
> I appreciate any help I can get.
>
>
>
- Next message: Jose A.: "Web Services Authentication!"
- Previous message: Kevin: "Compatibility between AutoNumber and HTML input box"
- In reply to: Kevin: "Compatibility between AutoNumber and HTML input box"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
