Tag Archives: value

Get difference between the value in one row and the next

I have some students with report marks over a number of reporting periods. I use the following SQL statement to get those report marks SELECT DISTINCT ID, thePeriod, MeritRank FROM ( SELECT ID, cast(fileyear as varchar) + cast(filesemester as varchar) … Continue reading

Get difference between the value in one row and the next

I have some students with report marks over a number of reporting periods. I use the following SQL statement to get those report marks SELECT DISTINCT ID, thePeriod, MeritRank FROM ( SELECT ID, cast(fileyear as varchar) + cast(filesemester as varchar) … Continue reading

Get difference between the value in one row and the next

I have some students with report marks over a number of reporting periods. I use the following SQL statement to get those report marks SELECT DISTINCT ID, thePeriod, MeritRank FROM ( SELECT ID, cast(fileyear as varchar) + cast(filesemester as varchar) … Continue reading

Unable to get property ‘value’ of FileUpload in a UserControl using javascript

I have a UserControl (with FileUpload) included on a Master Page as follows: Master Page <uc:uploadFiles ID=”UC1″ runat=”server”/> uploadFiles.ascx <script type=”text/javascript”> function ValidateUpload() { var FileUpload_function = document.getElementById(‘myfile’); if (FileUpload_function.value == ”) { return false; } else { //do stuff … Continue reading

searching for a string value pair in json object using mysql

I have a json object in my database table field like following : [{"user_id":"xyz","viewed":"false","answered":"false","denied":"false"}]. the other fields are id, q_id and stuff. I want to search for the user xyz in the table!how can i do that using mysql?