Squirrel Success

Never found a straight answer to my problem on Uncle Google so I thought I would blog it. When creating a 'Log In User' Server Behaviour (within Dreamweaver), you might notice that when logging in, the case for the password is not case sensitive. In order to make the login page case sensitive for passwords, adjust the following code; MM_loginSQL = MM_loginSQL & " FROM tblLogin WHERE username = ? AND password = ? to MM_loginSQL = MM_loginSQL & " FROM tblLogin WHERE username = ? AND strComp(password, ?,0)=0 It seems difficult to tell above, but the o's are numbers, not letters. Happy logging in!

Made your repeaters hidden and then you get an index error within Visual Studio? 1. The repeater needs to be visible to bind data to the textboxes. 2. You cannot extract text from a textbox repeater once the website is running. - The way around this is to copy the contents of the textbox repeater to another textbox object. You can also use validation instead of manually creating validation as textboxes within repeater controls are not visable and the find control code has to be utilized. See code below to extract contents of textbox within repeater. Change name of textbox control to read contents of a button control. rptYourRepeater.Items[0].FindControl("txtYourTextBox")

Before attemping this, ensure Outlook 2010 is closed. This method is only really necessary if you are installing Office 2010 from scratch on a new machine. If you are installing over Office 2007, as far as I am aware the installer will convert the NK2 into a DAT file. 1. Download NK2Edit from http://www.nirsoft.net 2. Open the old Nk2 file (associating the file with NK2 does not work with version v1.12 3. Click Save As, Change the Save as type to "Outlook 2010 AutoComplete .dat file". 4. Navigate to the following directory in the address bar within the Save As Window. %AppData%\Local\Microsoft\Outlook\RoamCache 5. Save over the current Stream_Autocomplete file. 6. Test the AutoComplete feature. Provided with no Warranty.

Are you experiencing problems upgrading your iPhone 3G to the latest OS4, then read on. When initially attempting to upgrade the iPhone to the latest version, my phone was struggling with backing up the the contents of the phone. An error message appeared later on but unfortunately I didn't make a note of the error however, I couldn't find the error code in the log files for iTunes either. 1. Open iTunes, right click "Your iPhone" and click Transfer Apps. Unfortunately, this will mess up the order the apps are laid out on the phone but this enables you to backup your apps and remove it from the phone and return it at a later date. This is helpful if you want to keep the app but are short for space. Also, under the Apps tab, tick Sync Apps if it is not already ticked. 2. Untick Sync Music under the Music tab, this will significantly increase upgrade time as the music won't be backed up. (Its on your computer anyway - if its not then, then I wouldn't complete th