Blog Stats
  • Posts - 10
  • Articles - 1
  • Comments - 11
  • Trackbacks - 0

 

Friday, October 21, 2011

Ajaxtoolkit HTMLEditor color picker position not visible off screen


I was working with the built in ajaxtooljit HTMLEditor and for some odd reason, the color picker was showing off the screen. I noticed that the "TextEditorDivContainer" class of the control had position absolute.

To solve this problem, I had to wrap the editor in a div with a class named "EditorWrapper" and change the position of the "TextEditorDivContainer" class to static.

 

.EditorWrapper .TextEditorDivContainer {     position: static !important; }

 

Thursday, September 22, 2011

jwplayer file not found or access denied checklist


A common problem when using jwplayer is "file not found or access denied".

Here are a few things to check for:

1.       If you are using mp4, be sure to have the MIME type added in IIS. The MIME type for .mp4 is video/mp4. The video will work in a test html page without a MIME type, but you’ll need to add one when working with ASP.net

2.       Be sure the file location is correct and that the file exist and is named correctly. You may want to try using an absolute web path name inside the javascript for testing purposes.

3.       Check your relative file path. Some versions of the player (v5.3), a relative path must be relative to the SWF file, other versions, the relative path must be relative to the html which the SWF is embedded (v5.4) . See here http://www.longtailvideo.com/support/forums/jw-player/video-encoding/12978/mp4h274-video-not-found-or-access-denied

4.       Be sure you are using forward slashes instead of backslashes in the file name

5.       View the source of the javascript to confirm it's correct.

Wednesday, September 14, 2011

The tail of the log for the database "%ls" has not been backed up.


I was working locally and trying to restore a databse backup from the server for development purposes. I was recieving this error when I tried to restore and overwrite an existing databse:

The tail of the log for the database "%ls" has not been backed up. Use BACKUP LOG WITH NORECOVERY to back up the log if it contains work that you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

An easy fix (if you aren't too concerned about backups) is to click on the Options page and click 'Overwrite the existing database (WITH REPLACE).

More info here: http://msdn.microsoft.com/en-us/library/bb283410.aspx

 

 

Tuesday, July 12, 2011

jQuery UI Progressbar 1.8.7 transparent / height fix


I noticed while using the jQuery UI Progressbar 1.8.7 that there was some extra space at the bottom of the progress bar. Turns out there was a bug in the jQueryUI/aristo/jquery-ui.css file, and adding a white background fixed the problem.

.ui-progressbar { height: 12px; text-align: left; background: url(images/progress_bar.gif) 0 -14px repeat-x; }

 should be
 

.ui-progressbar { height: 12px; text-align: left; background: url(images/progress_bar.gif) 0 -14px repeat-x #ffffff; }

 

Monday, June 06, 2011

SQL Specific Order By


order by

(case

      when id = 5 then 1

      when id = 2 then 2

      when id = 3 then 3

      when id = 1 then 4

      when id = 4 then 5

end) asc

Friday, May 27, 2011

jquery fullcalendar disable prev previous button


I'm using the fullcalendar from: arshaw.com/fullcalendar/ version 1.5.1

I'm only using the month view and wanted to disable the previous buttons so that the user could not view months in the past.

Inside the renderView(inc) function in the FullCalendar.js file, I added this on line 408:


  //This disables the previous buttons so that the user cannot view previous months/years 

                if (today.getMonth() >= parseDate(currentView.start).getMonth() && today.getFullYear() >= parseDate(currentView.start).getFullYear())

                {

                    header.disableButton('prev');

                    header.disableButton('prevYear');

                }

                else if (parseDate(currentView.start).getFullYear() <= today.getFullYear())

                {

                    header.enableButton('prev');

                    header.disableButton('prevYear');

                }

                else if(parseDate(currentView.start).getFullYear() > today.getFullYear() &&  parseDate(currentView.start).getMonth() >= today.getMonth())

                {

                    header.enableButton('prev');

                    header.enableButton('prevYear');

                }

Friday, May 13, 2011

NUnit: system.badimageformatexception


I was receiving a system.badimageformatexception when I went to run NUnit test.

The problem was that even though the solution platform was set to ‘Any CPU’, the platform target for the test project was set to 64bit. Setting the platform target to ‘Any CPU’ solved the problem.

 

 

Friday, May 06, 2011

SQL Convert to Date if possible


-- use this case statement to convert a value (column) to a date in the format mm/dd/yyyy. If converting to a date is not possible, the column will be null

 

select

      case

            when isdate(value) =1  then

                  convert(varchar,convert(datetime, value, 101), 101)

      end as [Date]

from

      MyTable

Thursday, April 21, 2011

SQL Functions for Numeric Only, Alpha Only, and Alpha Numeric Only Characters


---These functions will strip away unwanted characters from a string, leaving only numeric, alpha, or alpha numeric values

create function dbo.NumericOnly(@string varchar(max))

returns varchar(max)

begin

   While PatIndex('%[^0-9]%', @string) > 0

        Set @string = Stuff(@string, PatIndex('%[^0-9]%', @string), 1, '')

return @string

end

 

GO --------------------------------

 

create function dbo.AlphaOnly(@string varchar(max))

returns varchar(max)

begin

   While PatIndex('%[^a-z]%', @string) > 0

        Set @string = Stuff(@string, PatIndex('%[^a-z]%', @string), 1, '')

return @string

end

 

GO --------------------------------

 

create function dbo.AlphaNumericOnly(@string varchar(max))

returns varchar(max)

begin

   While PatIndex('%[^a-z0-9]%', @string) > 0

        Set @string = Stuff(@string, PatIndex('%[^a-z0-9]%', @string), 1, '')

return @string

end

 

GO --------------------------------

 

select

    dbo.NumericOnly('123ABC!!!') as [NumericOnly],

    dbo.AlphaOnly('123ABC!!!') as [AlphaOnly],

    dbo.AlphaNumericOnly('123ABC!@#') as [AlphaNumericOnly]

Wednesday, April 20, 2011

Remove Files and Directorys in WinCvs (2.0.2.4)


I'm currently using WinCvs 2.0.2.4 from http://cvsgui.sourceforge.net/download.htm

 

Delete a file:

  1. Select the file or files that you want to remove.
  2. Click the right mouse button on the selection, and choose the Remove selection menu item.
  3. As the files are only marked for removal, you have to commit them to remove them from the repository.

Beware, this will send your file to the recycle bin. When you commit the file, it will pernamently remove it from your harddrive.

The files will now be removed from the repository. Note that files are not physically removed, but rather marked as "dead" and live in the Attic. By this way it will still be possible to retrieve the files if you choose to check out an old version of the module.

 

Delete a directory:

Once all the files have been removed from the directory, CVS will optionally remove empty directories when you update one of its parent directories.

  1. Select the parent directory of the empty directory you want to remove.
  2. Click the right mouse button on the selection, and choose the Update selection menu item.
  3. Select the Globals tab.
  4. Make sure Prune (remove) empty directories is checked (it is by default).
  5. Press the OK button.

The directory will be removed if all its files were previously removed from your local copy and from the repository.

 

 

 

Copyright © BenAdler