asp checkbox and update to Microsoft Access

Leo · 06-02-2004, 05:28 PM

I have a Access database. I have a field yes/no checkbox.

How can I then make a page which lists say news then i can tick or untick the checkbox on my asp page then the checkboxs will update the value in my Access Database?

I am using Access Database and asp pages in Macromedia Dreamweaver mx 2004.

Thanks,

danielmichel · 06-02-2004, 06:41 PM

Code:

unction getCBValue(strCB) if strCB = "1" then getCBValue = 1 else  getCBValue = 0 end if end function   Function isChecked(x) if x = 1 then isChecked = "Checked" else isChecked = "" end if end Function   Your form will look like this    >   Code to retrieve data from db "&getCBValue(request("display"))&")"    The database column details :- Datatype = number Field size = byte default value = 0

Leo · 06-02-2004, 07:07 PM

Hi, where exactly do I add this code?

Amit · 06-03-2004, 01:36 PM

Post the structure of the table in which this data is going.

danielmichel · 06-04-2004, 01:42 AM

You got that bro?

textbooksword · 11-17-2004, 11:50 PM

Damn, Leo got that code and was never seen or heard from again. :upanddown

danielmichel · 02-23-2006, 04:59 AM

Quote:

Originally Posted by TextBookSword

Damn, Leo got that code and was never seen or heard from again. :upanddown

took the code and ran!

Leo · 04-21-2006, 05:17 PM

I was experimenting with ASP really and not used the forum fir a while as lost my pass. But now I'm back and going to be posting regular.

Leo

CyCL3 · 04-22-2006, 05:43 AM

Glad to hear that

06-02-2004, 05:28 PM	#1 (permalink)
Leo Junior Member Casual Browser Join Date: Mar 2003 Age: 28 Posts: 20	asp checkbox and update to Microsoft Access I have a Access database. I have a field yes/no checkbox. How can I then make a page which lists say news then i can tick or untick the checkbox on my asp page then the checkboxs will update the value in my Access Database? I am using Access Database and asp pages in Macromedia Dreamweaver mx 2004. Thanks,

06-02-2004, 06:41 PM	#2 (permalink)
danielmichel Administrator Disciple Join Date: Feb 2003 Age: 29 Posts: 728 Images: 16	Code: unction getCBValue(strCB) if strCB = "1" then getCBValue = 1 else getCBValue = 0 end if end function Function isChecked(x) if x = 1 then isChecked = "Checked" else isChecked = "" end if end Function Your form will look like this > Code to retrieve data from db "&getCBValue(request("display"))&")" The database column details :- Datatype = number Field size = byte default value = 0 __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - A list of resources for 3D Developers To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - A list of resources for design in motion with Adobe After Effects To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Usefully resources for freelance web developers To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Tips and discussion about search engine optimization To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Tutorials submitted by ny-dev members

06-02-2004, 07:07 PM	#3 (permalink)
Leo Junior Member Casual Browser Join Date: Mar 2003 Age: 28 Posts: 20	asp code Hi, where exactly do I add this code?

06-03-2004, 01:36 PM	#4 (permalink)
Amit Junior Member Casual Browser Join Date: Mar 2003 Age: 26 Posts: 23	Post the structure of the table in which this data is going. __________________ Amit To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. ~~ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

06-04-2004, 01:42 AM	#5 (permalink)
danielmichel Administrator Disciple Join Date: Feb 2003 Age: 29 Posts: 728 Images: 16	You got that bro? __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - A list of resources for 3D Developers To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - A list of resources for design in motion with Adobe After Effects To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Usefully resources for freelance web developers To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Tips and discussion about search engine optimization To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. - Tutorials submitted by ny-dev members

11-17-2004, 11:50 PM	#6 (permalink)
textbooksword Member Enthusiast Join Date: Nov 2004 Posts: 97	Re: asp checkbox and update to Microsoft Access Damn, Leo got that code and was never seen or heard from again. :upanddown

04-21-2006, 05:17 PM	#8 (permalink)
Leo Junior Member Casual Browser Join Date: Mar 2003 Age: 28 Posts: 20	I was experimenting with ASP really and not used the forum fir a while as lost my pass. But now I'm back and going to be posting regular. Leo

04-22-2006, 05:43 AM	#9 (permalink)
CyCL3 Member Enthusiast Join Date: Feb 2006 Posts: 89	Glad to hear that

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to update multimedia audio controller driver in xp ?	Angelica	General Conversation	0	05-05-2009 06:18 AM
Microsoft proposes piracy amnesty	SHP	General Conversation	0	12-05-2004 07:49 PM
everybody gets cheap internet access by 2007	danielmichel	General Conversation	4	04-08-2004 02:49 AM