473,560 Members | 2,851 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

repost, sort of--dynamic checkboxes

Hate to post this in a separate post, but felt that the last thread was too
far down to get noticed. It is called dynamic checkboxes, and it contained
some good advice for me, but it led to another question, and I wanted to go
ahead and post my question here in hopes of getting an answer.

The advice given to me about having a number of checkboxes which are put
onto the page from the database, was to name them all the same thing, and
then, on the next page, do a request.form of that form field name, and it
would return a string.

This worked very well, and I confirmed that if I checked boxes 3, 5, and 9,
I would get (3,5,9) returned to me. However, I am not sure how I can get
these values stored into my database. In my case, I'll want to store the
person's ID, called PersonalID, which I will get another way. Let's assume I
have that value, and it's '1'. I want to insert 1,3 then 1,5, then 1,9 into
the table, into the fields PersonalID and PeopleID, respectively. That's 3
rows in that table, and it is dynamic, so a user could enter 0 to many rows
into this table.

Can someone help me get this syntax? There was a suggestion in the last post
offered to me, but I didn't get it at all.


Jul 19 '05 #1
1 1616
something like....

dim sChecks, arrChecks, personId, x, sSQL

personId=[whereever you get it from]
sChecks=request .form("checkbox _name") & ""

if len(sChecks)>0 then

arrChecks=split (sChecks,",")

for x=lbound(arrChe cks) to ubound(arrCheck s)

sSQL="insert into ....." 'insert SQL using arrChecks(x) and
personId
oConn.execute sSQL...
next
end if

tim

"middletree " <mi********@hto mail.com> wrote in message
news:OO******** ******@TK2MSFTN GP12.phx.gbl...
Hate to post this in a separate post, but felt that the last thread was too far down to get noticed. It is called dynamic checkboxes, and it contained some good advice for me, but it led to another question, and I wanted to go ahead and post my question here in hopes of getting an answer.

The advice given to me about having a number of checkboxes which are put
onto the page from the database, was to name them all the same thing, and
then, on the next page, do a request.form of that form field name, and it
would return a string.

This worked very well, and I confirmed that if I checked boxes 3, 5, and 9, I would get (3,5,9) returned to me. However, I am not sure how I can get
these values stored into my database. In my case, I'll want to store the
person's ID, called PersonalID, which I will get another way. Let's assume I have that value, and it's '1'. I want to insert 1,3 then 1,5, then 1,9 into the table, into the fields PersonalID and PeopleID, respectively. That's 3 rows in that table, and it is dynamic, so a user could enter 0 to many rows into this table.

Can someone help me get this syntax? There was a suggestion in the last post offered to me, but I didn't get it at all.



Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1887
by: Kate | last post by:
I have an PHP page that contains several checkboxes. I need to know if the user has check all of the checkboxes before they can proceed to the next page. How do I check there status? And can I put a conditon on a Submit button so that when they press Submit it will only open the next page if all boxes are checked?? TIA Kate
3
1654
by: Toboja | last post by:
Hello, I have two select lists: Available Sort Options and Selected Sort Options. The user clicks on any of the available sort options and can move them to the selected sort options box. I use the typical MoveOption javascript functions to achieve this. I need to enable the user to also decide whether they want to also subtotal using any of...
2
1287
by: NotYetaNurd | last post by:
Hi, I have a panel under which i have lot of checkboxes added during runtime...which can have three values for priority(low,high,medium) i have set docking = top ; now my problem is i have to sort these checkboxes according to their priority ... any optimal way to do it... Regards, ....
2
1533
by: Lincoln Yeoh | last post by:
Sorry for the repost. Just wondering if anyone has a workaround for 7.4? At 11:25 AM 1/27/2004 -0500, Tom Lane wrote: >Martijn van Oosterhout <kleptog@svana.org> writes: > > I'm afraid I'll have to defer to someone else (Tom?) as why the > estimate was > > out by three orders of magnitude. > >I'd like to know that, too. >
48
4423
by: Alex Chudnovsky | last post by:
I have come across with what appears to be a significant performance bug in ..NET 2.0 ArrayList.Sort method when compared with Array.Sort on the same data. Same data on the same CPU gets sorted a lot faster with both methods using .NET 1.1, that's why I am pretty sure its a (rather serious) bug. Below you can find C# test case that should...
9
2911
by: martin DH | last post by:
I've seen similar posts to what I am looking for but have not been able to successfully use what I have read. I have a form with 4 checkboxes: CkQ1 CkJan CkFeb CkMar I would like to be able to select CkQ1, and in doing so, Access would select the other three checkboxes (sort of an "all of the above" option). These checkboxes are not in an...
1
1345
by: JavaCoder999 | last post by:
I need to create a GUI for a seating plan and I plan on using several rows of checkboxes to create a layout. The only problem is that I don't know how to code these checkboxes over several rows. Also I need to generate this checkbox layout from a prespecified number of checkboxes for each row. So I need to create some sort of loop that...
0
910
by: apattin | last post by:
Hi, I have been trying to find a reasonable GUI SQL client that displays results without rounding them. I was pointed to IBM's Data Studio, which we've FINALLY installed, but sadly it seems it also rounds. If I do this query from the command line: SELECT * FROM TARGET WHERE file_id = 8237 and accession_id = '200928_s_at'
8
6024
by: PeteOlcott | last post by:
http://archive.dojotoolkit.org/nightly/dojotoolkit/dojox/grid/tests/test_change_structure.html I would like to completely understand how GUI controls such as this one are constructed. In the ideal case I would like to see all of the source code for a complete working example of a ListBox of CheckBoxes.
0
7631
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7551
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7840
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8063
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7916
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3605
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3584
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2046
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
874
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.