In Feburary 2016 28,
Open a text editor and create a new file named 'changeTextVars.html.' Type six HTML tags in the file:
Save 'changeTextVars.html.'
Place a JavaScript open script tag -- '' tag:
Add a JavaScript function between the '' tags named 'changeText().' The 'changeText()' function takes a variable named 'monsterName' as an argument:
Edit the 'changeText' function. Use the 'document.getElementById' function to change the 'innerHTML' property for the field named 'textToChange.' The 'textToChange' field holds the text updated with the variable 'monsterName':
Add a '' tag between the HTML '
' and '
' tags. Enter some text that displays the message -- such as 'My favorite monster is: ' -- and close the '' tag. Be sure to include a space after the colon and before the '' tag to separate the message from the dynamic text:
My favorite monster is:
Enter an open '' tag between the '' and '' tags after the 'My favorite monstor is: ' message. Assign an 'id' to the '' tag and set its value to 'textToChange.' For example, type the text 'Dracula' after the '' tag and close the '' tag:
My favorite monster is:
Dracula
Add an HTML '
' tag after the '' tag. Set the input type to 'button' and add an 'onclick()' event that calls the 'changeText' function and passes the value 'Frankenstein.' Set the input field 'value' attribute to 'Change Text.' Save and close 'changeTextVars.html.'
My favorite monster is:
Dracula
Open 'changeTextVars.html' in a Web browser. Click the 'Change Text' button to use the 'monsterName' variable to change the 'textToChange' field from 'Dracula' to 'Frankenstein.'
In Feburary 2016 28,
Showing posts with label field. Show all posts
Showing posts with label field. Show all posts
Sunday, 28 February 2016
Friday, 26 February 2016
How to Sync Outlook to DrupalIn Feburary 2016 26,
In Feburary 2016 26,
Direct your browser to the iCalendar Feed module's project page at drupal.org/project/civicrm_activity_ical and copy the module's code link at the bottom of the page.
Log into your Drupal site as administrator.
Open Drupal's 'Modules' menu and click on 'Install New Modules.'
Paste the module code link into the 'Install from a URL' field and click the 'Install' button.
Check the box next to the iCalendar Feed module's name in the modules listing. The iCalendar Feed module will be found in the list of modules related to the CiviCRM module.
Click on the 'Set Permissions' link to the right of the iCalendar module name.
Place a check mark in the boxes next to the the types of users you want to have access to the iCalendar feed and click the 'Save Configuration' button.
Open the 'Structure' menu and select 'Blocks.' In the list of unassigned blocks, you'll see a new one for the iCalendar Feed.
Assign the block to a region that will be visible to your users on your home page and click the 'Save Blocks' button.
Navigate to your home page by clicking the home icon in the administrative menu bar.
Click on the iCalendar Feed link which now appears on the home page. Copy the iCalendar Feed address that is displayed.
Open Outlook 2010 and open the Calendar module. Click the 'Open Calendar' button and select 'From Internet' from the drop-down menu.
Paste the iCalendar Feed URL into the field in the dialog box and click 'OK.' Your CiviCRM events will now appear in your Outlook calendar.
In Feburary 2016 26,
Direct your browser to the iCalendar Feed module's project page at drupal.org/project/civicrm_activity_ical and copy the module's code link at the bottom of the page.
Log into your Drupal site as administrator.
Open Drupal's 'Modules' menu and click on 'Install New Modules.'
Paste the module code link into the 'Install from a URL' field and click the 'Install' button.
Check the box next to the iCalendar Feed module's name in the modules listing. The iCalendar Feed module will be found in the list of modules related to the CiviCRM module.
Click on the 'Set Permissions' link to the right of the iCalendar module name.
Place a check mark in the boxes next to the the types of users you want to have access to the iCalendar feed and click the 'Save Configuration' button.
Open the 'Structure' menu and select 'Blocks.' In the list of unassigned blocks, you'll see a new one for the iCalendar Feed.
Assign the block to a region that will be visible to your users on your home page and click the 'Save Blocks' button.
Navigate to your home page by clicking the home icon in the administrative menu bar.
Click on the iCalendar Feed link which now appears on the home page. Copy the iCalendar Feed address that is displayed.
Open Outlook 2010 and open the Calendar module. Click the 'Open Calendar' button and select 'From Internet' from the drop-down menu.
Paste the iCalendar Feed URL into the field in the dialog box and click 'OK.' Your CiviCRM events will now appear in your Outlook calendar.
In Feburary 2016 26,
Wednesday, 24 February 2016
How to Make Checkboxes in DreamweaverIn Feburary 2016 24,
In Feburary 2016 24,
Open your HTML document in Dreamweaver.
Click wherever on the page you want the check box to appear.
Click 'Insert,' 'Form' and 'Checkbox.'
Enter a name for your check box in the 'ID' field. This allows you to reference the check box with programming code, should you need it.
Enter a 'Label' for your check box, which is the text that appears next to the check box on your HTML page. Click 'Before form item' or 'After form item' from the Position section to place the label before or after the check box.
Click 'OK.'
Click the newly created check box and enter a value in the 'Checked Value' field of the Property window. If you cannot see the Property window, hold the 'Ctrl' button and press 'F3.' The value determines the entered value for a checked box. If no value is entered, a checked box defaults to 'Yes.'
Click 'Insert,' 'Form' and 'Button' to create a Submit button, which is commonly used to submit the form.
Click '
Hold the 'Ctrl' button and press 'S' to save your changes.
In Feburary 2016 24,
Open your HTML document in Dreamweaver.
Click wherever on the page you want the check box to appear.
Click 'Insert,' 'Form' and 'Checkbox.'
Enter a name for your check box in the 'ID' field. This allows you to reference the check box with programming code, should you need it.
Enter a 'Label' for your check box, which is the text that appears next to the check box on your HTML page. Click 'Before form item' or 'After form item' from the Position section to place the label before or after the check box.
Click 'OK.'
Click the newly created check box and enter a value in the 'Checked Value' field of the Property window. If you cannot see the Property window, hold the 'Ctrl' button and press 'F3.' The value determines the entered value for a checked box. If no value is entered, a checked box defaults to 'Yes.'
Click 'Insert,' 'Form' and 'Button' to create a Submit button, which is commonly used to submit the form.
Click '
Hold the 'Ctrl' button and press 'S' to save your changes.
In Feburary 2016 24,
How to Check a String to See if the Value Is Numeric in SQLIn Feburary 2016 24,
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
How to Change a Directory in FTPIn Feburary 2016 24,
In Feburary 2016 24,
Open the Start menu and click on the 'Run' button.
Type 'cmd' into the text field and hit the 'Enter' key. A command prompt window will now open on the screen.
Type 'ftp server.com' into the command prompt window, replacing 'server.com' with the address of your FTP server, and hit 'Enter.'
Enter your FTP username and password when prompted to log in to the server.
Type 'cd' followed by the path of the directory that you want to switch to and hit 'Enter.' The 'cd' command stands for change directory, and if you provide a valid directory path to change to, you will receive a confirmation message.
In Feburary 2016 24,
Open the Start menu and click on the 'Run' button.
Type 'cmd' into the text field and hit the 'Enter' key. A command prompt window will now open on the screen.
Type 'ftp server.com' into the command prompt window, replacing 'server.com' with the address of your FTP server, and hit 'Enter.'
Enter your FTP username and password when prompted to log in to the server.
Type 'cd' followed by the path of the directory that you want to switch to and hit 'Enter.' The 'cd' command stands for change directory, and if you provide a valid directory path to change to, you will receive a confirmation message.
In Feburary 2016 24,
Monday, 22 February 2016
How to Give Someone FTP AccessIn Feburary 2016 22,
In Feburary 2016 22,
Log into the control panel of your Web host by entering your domain name, user name and password.
Select “FTP Accounts” under the “Files” section.
Enter a user name for the designer to use in the “Login” field.
Select a strong password. Make the password six to eight characters long and be sure that it contains a combination of letters, numbers and special characters. Enter this password twice.
Specify the directory to which you want to grant the person access. This allows the person to access only a specific portion of your account. The directory might be a subdomain or add-on domain, but it will not be your entire domain. If you do wish to provide unrestricted access, leave the directory field blank.
Click “Create” to create the FTP account.
Provide the user name and password to the person. Ask the person to notify you when he finishes the work. Check your website to make sure that the work is done correctly.
Delete the FTP account after the person no longer needs access. Log into the control panel of your Web host, select “FTP Accounts” and then select “Accounts Management.” Click “Delete” next to the FTP account that you wish to delete.
In Feburary 2016 22,
Log into the control panel of your Web host by entering your domain name, user name and password.
Select “FTP Accounts” under the “Files” section.
Enter a user name for the designer to use in the “Login” field.
Select a strong password. Make the password six to eight characters long and be sure that it contains a combination of letters, numbers and special characters. Enter this password twice.
Specify the directory to which you want to grant the person access. This allows the person to access only a specific portion of your account. The directory might be a subdomain or add-on domain, but it will not be your entire domain. If you do wish to provide unrestricted access, leave the directory field blank.
Click “Create” to create the FTP account.
Provide the user name and password to the person. Ask the person to notify you when he finishes the work. Check your website to make sure that the work is done correctly.
Delete the FTP account after the person no longer needs access. Log into the control panel of your Web host, select “FTP Accounts” and then select “Accounts Management.” Click “Delete” next to the FTP account that you wish to delete.
In Feburary 2016 22,
Saturday, 20 February 2016
How to Connect Sharepoint Designer With Sharepoint ServerIn Feburary 2016 20,
In Feburary 2016 20,
Open SharePoint Designer. The program is most commonly found in the Windows Start menu at the following location: 'Programs' > 'Microsoft Office' > 'Microsoft Office SharePoint Designer.'
Click 'File' in the menu near the top of the SharePoint Designer screen. Select 'Open Site.'
Enter the URL of your SharePoint site in the 'Site name' field near the bottom of the 'Open Site' dialog box. Click the 'Open' button.
Choose your editing option. Depending on the configuration of your SharePoint site, you can choose to edit the live site, or edit a local copy and publish that copy to the server at a later time. Click the button next to your desired option and select 'OK.'
Enter your username and password when prompted and click 'OK.' SharePoint Designer is now connected with your SharePoint Server site.
In Feburary 2016 20,
Open SharePoint Designer. The program is most commonly found in the Windows Start menu at the following location: 'Programs' > 'Microsoft Office' > 'Microsoft Office SharePoint Designer.'
Click 'File' in the menu near the top of the SharePoint Designer screen. Select 'Open Site.'
Enter the URL of your SharePoint site in the 'Site name' field near the bottom of the 'Open Site' dialog box. Click the 'Open' button.
Choose your editing option. Depending on the configuration of your SharePoint site, you can choose to edit the live site, or edit a local copy and publish that copy to the server at a later time. Click the button next to your desired option and select 'OK.'
Enter your username and password when prompted and click 'OK.' SharePoint Designer is now connected with your SharePoint Server site.
In Feburary 2016 20,
SQL Scripting TutorialIn Feburary 2016 20,
In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,
Labels:
created,
field,
field_name,
query,
returns,
Select,
table,
table_name,
typing,
Write
Sunday, 14 February 2016
How to Transfer Photos From a Computer to an EmailIn Feburary 2016 14,
In Feburary 2016 14,
Log in to your email account. Click the 'Compose' or 'New' option to set up a new email draft.
Type your own email address in the 'To:' field. Type 'Photos' in the subject field, which is usually two data forms below where your email address has been placed.
Click the option that reads either 'Attach' or 'Photo.'
Click 'My Documents' and select the 'Pictures' tab folder in the pop-up dialog box to locate the photos you want to transfer from the computer.
Hold down the 'CTRL' key and click each picture only once.
Click 'Open' to attach the pictures into your email draft.
Click 'Send' once all of the pictures have attached to the email successfully.
In Feburary 2016 14,
Log in to your email account. Click the 'Compose' or 'New' option to set up a new email draft.
Type your own email address in the 'To:' field. Type 'Photos' in the subject field, which is usually two data forms below where your email address has been placed.
Click the option that reads either 'Attach' or 'Photo.'
Click 'My Documents' and select the 'Pictures' tab folder in the pop-up dialog box to locate the photos you want to transfer from the computer.
Hold down the 'CTRL' key and click each picture only once.
Click 'Open' to attach the pictures into your email draft.
Click 'Send' once all of the pictures have attached to the email successfully.
In Feburary 2016 14,
Friday, 5 February 2016
How to Display Text From MySQL in PHPIn Feburary 2016 05,
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Subscribe to:
Comments (Atom)