updating a check box

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

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

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

updating a check box

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 >> updating a check box

Page: [1]

charlie df

Posts: 79
From: las vegas nv USA
Status: offline

updating a check box - 9/19/2001 17:27:00

I am trying to update an access field that has a check box through an update query.

I have input the following code into the custom query of DRW:

UPDATE DISTINCTROW
Users
SET NewsLetter='::NewsLetter::'
WHERE Email=::Email::

The Error on load:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Email='.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

I have an initial value of for the form entries:
<%=Request("NewsLetter")%> and
<%=Request("Email")%>

The Error on submit:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

The field is set to either True/False, and input True or False into the update field.

Where am i going wrong?


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: updating a check box - 9/19/2001 17:39:00 Is email the t/f field or newsletter? UPDATE DISTINCTROW Users SET NewsLetter=::NewsLetter:: WHERE Email='::Email::' ? (in reply to charlie df)


charlie df Posts: 79 From: las vegas nv USA Status: offline	RE: updating a check box - 9/19/2001 17:54:00 Tried so hard to get all the info in the first time. the t/f is NewsLetter (in reply to charlie df)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: updating a check box - 9/21/2001 23:41:00 Does the suggested format work for you? (in reply to charlie df)


charlie df Posts: 79 From: las vegas nv USA Status: offline	RE: updating a check box - 9/23/2001 20:52:00 Thank you so much Spooky. Hard to believe that something that simple was the problem. That with the combination of using "Null" as the defaults for the two boxes made all of the error messages go away. Sorry for the delay in getting back to you, I just got to try your suggestion this morning. Thanks again Spooky. (in reply to charlie df)