... you. > Save
Upload the files to \components\com_jcomments\libraries\ayah
STEP #3: Enable admin option dropdown
This is a code change to allow the admin to select PlayThru.
Open the file ...
...
STEP #3: Enable admin option dropdown
This is a code change to allow the admin to select PlayThru.
Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066)
Replace ...
... to the ReportServer.
Hover the mouse cursor over it and click on the dropdown arrow to its right
Select "Manage" in the dropdown menu
Select "Data Sources" in the left menu
Specify a "custom data ...
... "Back Up Now" button.
When that's done, Right-click on the new phone and select "Restore from Backup..."
Select the backup you just made (might default to a different backup so click on the dropdown to ...
What?
I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom ...
... a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form:
-- where @ThisSearch is a posted (and sanitized) variable
SET @ThisSearch:="Brains";
SELECT
...
...
All SQL
-- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
ALTER TABLE myTable ADD myColumn CHAR(2) NULL
-- Delete a column
ALTER TABLE myTable DROP COLUMN ...
What?
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this.
How?
Taken from the best forum for programming Qs&As:
http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
...
Run the SQL script against a test database,
Modify the table name to use if necessary.
Uncomment the drop statement if running for the second time.
Modify the PHP file to use database login ...
... in use
Cannot drop database because it is currently in use
Restoring a SQL Database Backup Using SQL Server Management Studio
Unable to restore database "..because it is in use by this session." ...
... all files in TEST folder.
Drop all tables in TEST database.
Copy all files from LIVE to TEST (Do not overwrite configuration.php !!!)
Copy database from LIVE to TEST (Operations > Copy to... > untick ...
... 1964-08-08
How?
Precursor
You will need to be able to create the following view to generate random numbers on SQL Server.
-- Drop the view if it already exists
IF OBJECT_ID ('vwRandom', ...
... and now copy events over by dragging and dropping (TIP: I right-click and hold and drag and this then gives you other options as well as the "copy").
Where's the automation?
All-Day ...
... 'P') IS NOT NULL
DROP PROCEDURE [usp_CountRecordsPerTablePerColumn];
GO
CREATE PROCEDURE [usp_CountRecordsPerTablePerColumn]
(
@p_Value int,
@p_Column varchar(max)
)
AS
/***********************************************************************************
** ...
... columns.
How?
IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL
DROP PROCEDURE [usp_ListDistinctValuesAndCounts];
GO
CREATE PROCEDURE [usp_ListDistinctValuesAndCounts]
(
...
... - Sorna Kumar
IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL
DROP PROCEDURE usp_SearchDB
GO
CREATE PROCEDURE usp_SearchDB
@Tablenames VARCHAR(500)
,@SearchStr NVARCHAR(60)
,@GenerateSQLOnly ...
... I wouldn't need to post this note on my website.
Thinking outside of the box
Hooray for you non-sheep! This is what I've come up with:
-- Drop Stored Procedure if already exists
IF OBJECT_ID ( ...
... you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it.
-- Drop the function if it already exists
IF ...
... type "Stored Procedure"
Click on the radio button when adding your dataset and then select the stored procedure from the dropdown list.
4b. Add a dataset: the "Refresh fields..." button
Click on ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.