Checkboxes 2

[nk9100]

After reading the FAQs, they specifically relate to a series of checkboxes which have the same group name, I am wonering how I might get the value of the checkbox from the DB, and get the box to be checked.

I tried an If Statement, which didnt work...

<%
If IsNull(rsCheckUser("educationrecruitmentdifficulties")) Then
%>
<td width="9%">
<input type="checkbox" name="educationrecruitmentdifficulties" value="Yes">
</td>
<%
Else
%>
<%
If rsCheckUser("educationrecruitmentdifficulties") = "Yes" Then
%>
<td width="9%">
<input type="checkbox" name="educationrecruitmentdifficulties" value="Yes" checked>
</td>
<%
End If
%>

Any Ideas?

Life is a journey that always ends up in the same place

 

[DotNetGnat]

may not be once it hits some particular record which needs ISNULL condition...so i would suggest you to use...

<input type="checkbox" name="educationrecruitmentdifficulties" <%If IsNull(rsCheckUser("educationrecruitmentdifficulties") OR (rsCheckUser("educationrecruitmentdifficulties")="") THEN response.write "CHECKED"%> value="Yes">

-DNG

 

[nk9100]

Thanks to you both

Tek-tips shines through again.

DotNetGnat - would this be worth making an FAQ for?

Life is a journey that always ends up in the same place

 

[DotNetGnat]

Why not? i see many people asking this type of question...go ahead and make it a FAQ..i will review it if you want to...

also do you know why we need to check ISNULL() and "" conditions...if not let me know...

-DNG

 

[DotNetGnat]

BTW let me remind you...i also suggested something in the past for your thread...but you never replied...let me pull that thread for you...

-DNG

 

[nk9100]

Well, isNull and "" are recognised differently by Access, (I dont know if same applies to MySQL/ Oracle etc), I will look into it though, i think when the table is just blank, and never been updated, it is fine, however, after the update, the update inserts a blank field as "", which then when it checks for it after the first update, looks for "" rather than isNull.

I will do an FAQ, and get back to you after I have done my site, (by end of today hopefully!!!!!)

Life is a journey that always ends up in the same place

 

[DotNetGnat]

yes you got that straight and it the same case with SQl Server, MYSQL & oracle...

-DNG

 

[nk9100]

Hi, back again...slight issue, the orignal code, as posted above, was missing a couple of )'s, at the end of the first 'educationrecruitmentdifficulties', this has now caused it not to work, and all the check boxes come checked when the db is cleared. Any ideas?

<input type="checkbox" name="educationrecruitmentdifficulties" <%If IsNull(rsCheckUser("educationrecruitmentdifficulties")) OR (rsCheckUser("educationrecruitmentdifficulties")="") THEN response.write "CHECKED"%> value="Yes">
[code]

Life is a journey that always ends up in the same place

 

[nk9100]

It needs to be selected if there IS data in the db, rather than not selected.

Life is a journey that always ends up in the same place

 

[DotNetGnat]

try this:

<input type="checkbox" name="educationrecruitmentdifficulties" <%If ( IsNull(rsCheckUser("educationrecruitmentdifficulties")) OR rsCheckUser("educationrecruitmentdifficulties")="" ) THEN response.write "CHECKED"%> value="Yes">

-DNG

 

[nk9100]

Hi, Would this be the code to 'Check' the box if the value in the DB is Yes, and not check the box if the value is "" or isNull?

<Input type="checkbox" name="fieldname" <%If (rsCheckUser("fieldname"))="Yes" THEN response.write "Checked"%> value="Yes">

Life is a journey that always ends up in the same place

 

[nk9100]

I think it might just be

Life is a journey that always ends up in the same place

 

[DotNetGnat]

YES.

-DNG