Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD

2002-11-25 Thread FlashGuy
Hi,

Currently I have the following fields in my database:

Database name: test
table: tblprofiles
fields: strUser_ID (auto-generated)
   strUserName
   strGroup
   strSelect
   strSelectFlag
   strShow

Contents of above fields for example purposes:

   strUser_ID (auto-generated) = '1'
   strUserName = 'test'
   strGroup = ''
   strSelect = 
'D:\documents\dir1,D:\documents\dir2,D:\documents\dir3,D:\documents\dir4,D:\documents\dir5,D:\mywork\dir1,D:\mywork\dir2,
  
D:\mywork\dir3,D:\mywork\dir4,D:\mywork\dir5,D:\temp\dir2,D:\temp\dir3,D:\temp\dir4,D:\temp\dir5'
   strSelectFlag  = 'Yes'
   strShow = 'D:\temp\dir1,D:\temp\dir3'


I read in the strSelect string and display only those fields that don't match the 
strShow field. The above would display the following on my template page:


Select the directory(s) to SHOW:

[  ] dir2
[  ] dir4
[  ] dir5


Select the directory(s) to ADD:

[  ] dir1
[  ] dir3 

[ UPDATE ]

What I would like to do is rather than have the listing appear in the ADD are above 
I would like those selections to appear under the SHOW listing but have only those 
items that have been selected 
marked with a checkbox.

Example:

[x] dir1
[  ] dir2
[x] dir3
[  ] dir4
[  ] dir5

If additional items are selected then the database is updated accordingly and a list 
created with those check boxes checked based on the selection.

I am willing to send my code and database to anyone willing to give me a hand.?

Thanks








---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD

2002-11-25 Thread FlashGuy
Hi everyone,

Sorry,

Please ignore this posting.



On Mon, 25 Nov 2002 09:55:11 -0500, FlashGuy wrote:

 Hi,
 
 Currently I have the following fields in my database:
 
 Database name: test
 table: tblprofiles
 fields: strUser_ID (auto-generated)
strUserName
strGroup
strSelect
strSelectFlag
strShow
 
 Contents of above fields for example purposes:
 
strUser_ID (auto-generated) = '1'
strUserName = 'test'
strGroup = ''
strSelect = 
'D:\documents\dir1,D:\documents\dir2,D:\documents\dir3,D:\documents\dir4,D:\documents\dir5,D:\mywork\dir1,D:\mywork\dir2,
   
D:\mywork\dir3,D:\mywork\dir4,D:\mywork\dir5,D:\temp\dir2,D:\temp\dir3,D:\temp\dir4,D:\temp\dir5'
strSelectFlag  = 'Yes'
strShow = 'D:\temp\dir1,D:\temp\dir3'
 
 
 I read in the strSelect string and display only those fields that don't match the 
strShow field. The above would display the following on my template page:
 
 
 Select the directory(s) to SHOW:
 
 [  ] dir2
 [  ] dir4
 [  ] dir5
 
 
 Select the directory(s) to ADD:
 
 [  ] dir1
 [  ] dir3 
 
 [ UPDATE ]
 
 What I would like to do is rather than have the listing appear in the ADD are 
above I would like those selections to appear under the SHOW listing but have only 
those 
items that have been selected 
 marked with a checkbox.
 
 Example:
 
 [x] dir1
 [  ] dir2
 [x] dir3
 [  ] dir4
 [  ] dir5
 
 If additional items are selected then the database is updated accordingly and a list 
created with those check boxes checked based on the selection.
 
 I am willing to send my code and database to anyone willing to give me a hand.?
 
 Thanks
 

 
 
 
 
 
 
 
 ---
 Colonel Nathan R. Jessop
 Commanding Officer
 Marine Ground Forces
 Guatanamo Bay, Cuba
 ---
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm