Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  Other Topics  value of a record not showing - Pleeeeeeease help!

Author  Topic  meeta Starting Member 45 Posts Posted - 2001-09-04 : 15:44:47 datatype of a field is "nvarchar" This questions is more of progamming topic, but I assume someone on this forum might help me out, I did post on other board but none of the suggestion worked... when i want to show a screen to modify a record off the table resume. Its not checking any condition, eventhough its has a value in the table. below is my code: salary = cstr(RS("SalaryPer")) If salary="Per Year" Then response.write "<input type=radio name=SalaryPer Checked value=""Per Year"">Yearly" response.write "<input type=radio name=SalaryPer value=""Per Hour"">Hourly" elseif salary="Per Hour" Then response.write "<input type=radio name=SalaryPer value=""Per Year"">Yearly" In the table it has value "Per Year" . Looking from browser my code looks like <input type=radio name="SalaryPer" value="Per Year">Yearly <input type=radio name="SalaryPer" value="Per Hour">Hourly response.write "<input type=radio name=SalaryPer Checked value=""Per Hour"">Hourly" end if thanks in advance