Added: July/09/2008 at 10:13am | IP Logged

Hi Chris,

This is my first post so i wish myself good luck. ;-)

-----

I added a customized Checkbox(es) on each of the Users table and Groups table.

For instance the new field is "Group_Public_View" in groups table.

I added the following code into the "edit_group.asp" page:

<input type="checkbox" name="Group_Public_View" value="True" <% If CmdEditGroup("Group_Public_View") then %><% Response.Write (" checked")%><% End If %>>

I did the similar for the Users table as below:

<input type="checkbox" name="Group_Leader" value="True" <% If Group_Leader then %><% Response.Write (" checked")%><% End If %>>

The problem is; when I save these pages, it saves the info fine as long as I check these boxes (True), but if I uncheck a box (on edit_group.asp for instance) I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/account/admin/save_group.asp, line 445

and the following on "edit.asp"

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/account/admin/save.asp, line 420

------

So, please tell me how I can get around these errors and make these checkboxes work seamlessly.

Btw, I am not an ASP programmer, as you can image. I wish i was.

Thanks a million for your help.

Cheers,
A. ;-)

Added: July/09/2008 at 10:22am | IP Logged

Dear Chris,

Please disregard my post regarding the custom checkbox.

To my much surprise, I just figured it out. A miracle from my end.

I guess I had to post this messgae in order for my brain start working or something like that.

But thnak you anyway. Hope this didn't take any of your time already.

Cheers.

Added: January/09/2009 at 9:29am | IP Logged

Hi Chris,

It's actually very easy.... Open up the page that saves the info you're updating.... such as "save.asp" and find the line that generates that error.

It must be something like this:

   CmdEditUser.Fields("Your New Field's Name") = NULL

And the just replace "NULL" with the word "False" (minus the quotes of course).

And it should take care of that annoying problem.

Hope this helps.

Again, I'm not a ASP programmer but i've learned a lot frm this particluar application so if you need any further help, i'll do my best to send you some sugeestions, advice etc.

Good luck.

Anthony ;-)

Added: January/09/2009 at 10:00am | IP Logged

Hey Chris,

I'm glad you have solved your problem. I know it feels great when you finally do that. ;-)

I'm just curious. What page is this that you had the problem in. Part of ASP Protect version 8.0 or no?

Good luck on the rest of your project.

Anthony ;-)