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. 1 1617
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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...
|
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,
....
|
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.
>
|
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...
| |
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...
|
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...
|
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'
|
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.
|
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...
|
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...
| |
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| | |