jediokie - Viewing Profile

jediokie's Profile User Rating:

Reputation: 2 Apprentice

Group:: Active Members
Active Posts:: 215 (0.11 per day)
Joined:: 07-February 08
Profile Views:: 2,177
Last Active:: Feb 06 2013 08:54 AM
Currently:: Offline

Previous Fields

Country:: US
OS Preference:: Windows
Favorite Browser:: Chrome
Favorite Processor:: Intel
Favorite Gaming Platform:: PC
Your Car:: Chevrolet
Dream Kudos:: 0

Latest Visitors

DarenR
13 Aug 2012 - 07:08
just.beginner
21 Sep 2010 - 10:23
Adsa
16 May 2010 - 21:16

jediokie has not set their status

Posts I've Made

In Topic: Optimizing query

Posted 1 Feb 2013

It appears after talking with him, he was looking at a different revision of the code than the one with my change on it. After further review he feels the above query is as efficient as it could be.
In Topic: File handling from the web

Posted 21 Aug 2012
I had to change the code as shown below to get out of that error:
```
Dim NewPath As String = System.IO.Path.GetFileName(FilePath & Me.ListID.ToString & "a.jpg")
```
Just adding the System.IO.Path resolved it. Now I'm fighting permission issues.
In Topic: Locking data

Posted 6 Aug 2012

RudiVisser, on 06 August 2012 - 08:54 AM, said:
What happens if you simply don't modify it?

There's no real way (in any database engine as far as I'm aware) to lock a row natively, but it can be done by the likes of a stored procedure that would be called to update the row, and either only updates certain columns on the row, or detects if the date field has been changed and rolls it back in that case.

Thanks! I kinda figured it would have to be done in the stored procedure. Now to learn more about stored procedure verbiage!
In Topic: Locking data

Posted 6 Aug 2012

DarenR, on 06 August 2012 - 08:48 AM, said:
what do you mean by locking?

Making it read only. It's a date field that shows when a task/item was completed and we need it to be set in stone. Once they say the task/item is done, that's it.

In Topic: Javascript function only works sometimes.

Posted 13 Jul 2012

The line below was in the provider = true type:

jediokie, on 12 July 2012 - 02:12 PM, said:

   if ((RTrim(LTrim(document.RequestForm.RequestorEmployeeID.value))=='') || (RTrim(LTrim(document.RequestForm.DepartmentAccount.value))=='') || (RTrim(LTrim(document.RequestForm.Description.value))=='') || (document.RequestForm.ProjectTitle.value=='')) {

Here:

Quote

	If Session("ProviderType") <> clsWorkOrder.ProviderTypeNone Then
		WriteDataEntryRow "Date of Request:", "<input type='text' name='Submitted' value='" & FormatDateTime(Now(),vbShortDate) & "' size='10' maxlength='10' onblur='return ValidateSubmittedDate()'>"
		WriteDataEntryRow "Project Title:", "<input type='text' name='ProjectTitle' value='' size='50' maxlength='125'>"
		WriteDataEntryRow "Requested By:", "<select name='RequestorEmployeeID'>" & objEmployee.FillEmployeeList(objEmployee.EmployeeID) & "</select>"
		WriteDataEntryRow "Assigned To:", "<select name='AssignedToProviderID'>" & clsWorkOrder.FillAssignedToProviderIDList(Session("Provider")) & "</select>"
		WriteDataEntryRow "Escalated To:", "<select name='EscalatedToProviderID'>" & clsWorkOrder.FillEscalatedToProviderIDList(-1) & "</select>"
		WriteDataEntryRow "Category:", "<select name='CategoryID'>" & clsWorkOrder.FillCategoryIDList(-1) & "</select>"
    Else
        WriteDataEntryRow "Project Title:", "<input type='text' name='ProjectTitle' value='' size='50' maxlength='125'>"
	End If
    
    WriteDataEntryRow "Deparment Account:", "<input type='text' name='DepartmentAccount' value='' size='4' maxlength='4' onblur='return ValidateAccount()'>"
	WriteDataEntryRow "Requested Completion Date:", "<input type='text' name='Requested' onblur='return ValidateRequestedCompletionDate()'>"
	WriteDataEntryRow "Required Completion Date:", "<input type='text' name='RequiredDate' onblur='return ValidateRequiredDate()'>"
	WriteDataEntryRow "Description of question or<br>topic to be discussed:", "<textarea name='Description' rows='5' cols='65'></textarea>" & WriteSpellCheckButton("Description")
    WriteJoinedRow "<input type='hidden' name='ServiceUnits' value='0'>"

But not in the provider type=false type so it skipped the check completely.