WHILE ID='::ID::' has me confused 
Author Message
 WHILE ID='::ID::' has me confused

I've just started working with datadata bases ( 2 days now) and am getting
confused.
I've figured out how to create, add and show records to a database via html/asp
pages.
It's pretty cool. Instead of editing 100 pages, I can extract the information I
want from a data base and stuff it into a generic webpage.
The problem comes when I want to edit a record.

I'm tring to use:
UPDATE Results
 SET name='::NewName::'
 WHERE ID='::ID::'

if I leave out the where statement, it works, althouogh every record gets
changed...
I'd like to be able to use the ID column in the where statement so only ONE
record get s changed, but It won't work.
Any suggestions ??
Wally



Sun, 07 Dec 2003 21:43:33 GMT
 WHILE ID='::ID::' has me confused

Quote:

> I've just started working with datadata bases ( 2 days now) and am getting
> confused.
> I've figured out how to create, add and show records to a database via html/asp
> pages.
> It's pretty cool. Instead of editing 100 pages, I can extract the information I
> want from a data base and stuff it into a generic webpage.
> The problem comes when I want to edit a record.

> I'm tring to use:
> UPDATE Results
>  SET name='::NewName::'
>  WHERE ID='::ID::'

> if I leave out the where statement, it works, althouogh every record gets
> changed...
> I'd like to be able to use the ID column in the where statement so only ONE
> record get s changed, but It won't work.
> Any suggestions ??
> Wally

what's the error message by the way?

Imran



Mon, 08 Dec 2003 00:20:53 GMT
 WHILE ID='::ID::' has me confused

Quote:

>what's the error message by the way?

>Imran

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 DriversOn 20 Jun 2001 09:20:53

One of the FAQ's at MS said this error is caused by the date field.
But I'm only changing a text field called "name"
Wally



Mon, 08 Dec 2003 06:24:38 GMT
 WHILE ID='::ID::' has me confused
ID is probably an integer field.  So you should have

ID = ::ID:: instead of ID = '::ID::'

Remember not to put numeric values inside a quote.

Quote:


> >what's the error message by the way?

> >Imran

> 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 DriversOn 20 Jun 2001 09:20:53

> One of the FAQ's at MS said this error is caused by the date field.
> But I'm only changing a text field called "name"
> Wally



Tue, 09 Dec 2003 07:21:18 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. How to modify fields linked to id's when the id's change

2. Linking Unix Process Id's back to Session Id's

3. Replication Job ID's don't match

4. runtime error object required 'id'

5. 'navigation' through records by id

6. 'navigating' through records by ID

7. Seeking list of login id's with write permission on a table

8. Generating unique ID's

9. Help with web assistant jobs and step id's

10. Trouble removing Login ID's in SQL65

11. Problem with ID'S in multiple DB

12. SQL/Access97/Replication ID's


 
Powered by phpBB® Forum Software