swaters86
/ Get Raw SQL in Yii 1.1
Created
May 12, 2017 19:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $schema = Yii::app()->db->schema; | |
| $builder = $schema->commandBuilder; | |
| $command = $builder->createFindCommand($schema->getTable('pos_patient_info'), $criteria); | |
| $results = $command->text; | |
| var_dump($results); | |
| exit |
swaters86
/ RoundedCornersWithASassMixin.txt
Created
November 16, 2016 04:15
An example of how to create a SASS mixin for adding different types of rounded corners to an element (i.e. top left , top right, bottom left, etc rounded corners)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| HTML | |
| ========================================================= | |
| <div class="my-element"> | |
| Hey, this is a blue rectangle with 5px rounded corners on all sides. | |
| </a> | |
| SASS/CSS | |
| ========================================================= |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
swaters86
/ react test
Created
December 2, 2015 05:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| test |
swaters86
/ round_robin.sql
Created
October 29, 2015 18:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * | |
| INTO #Temp2 | |
| FROM | |
| (Select aa.OID, ROW_NUMBER() | |
| OVER (ORDER BY aa.OID) AS RowN | |
| FROM VCG_PersonToTeam_Grid_View aa | |
| inner join CG_UserLog (nolock) bb | |
| on aa.PersonMemberOfTeams = bb.UserID | |
| Where aa.GCRecord is null AND aa.TeamName='E-mail Team' and bb.UserLoggedIn=1 )a |
swaters86
/ GetListofPropertiesForAnObject.js
Created
October 20, 2015 20:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Get list of properties for an object | |
| var dueDateControl = document.querySelectorAll('#DynamicLayoutControl1_DueDate_dtc_24_DueDate_Date_I'); | |
| console.log(Object.getOwnPropertyNames(GetDateTimeControl("DueDate"))); | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 118 All Active Incidents 0 0 All active incidents. SDInterfaces.Entities.IIncidentRequest 0 1 1 1 1 0 0 ALL Global Views 1 |
swaters86
/ RemoveReports.sql
Created
July 15, 2015 18:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Logically delete the report */ | |
| UPDATE ChangeGear.dbo.CG_ReportEntity | |
| SET GCRecord = 12345 | |
| WHERE NAME = 'New Pie Chart' | |
| /* Check the GCRecord field for the report record*/ | |
| /* If it's null, then that means it's not deleted */ | |
| /* If it's a numeric value, then that mean it is deleted */ | |
| SELECT GCRecord |
swaters86
/ SearchAllTables.sql
Created
July 14, 2015 14:23
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE [ChangeGear] | |
| GO | |
| /****** Object: StoredProcedure [dbo].[SearchAllTables] Script Date: 07/14/2015 10:22:43 ******/ | |
| SET ANSI_NULLS ON | |
| GO | |
| SET QUOTED_IDENTIFIER ON | |
| GO | |
| ALTER PROC [dbo].[SearchAllTables] | |
| ( | |
| @SearchStr nvarchar(100) |
swaters86
/ ChangeGearError2
Created
July 14, 2015 13:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2015-07-14 06:20:42,215 | ERROR | DevExpress.Xpo.DB.Exceptions.UnableToCreateDBObjectException: Unable to create 'ForeignKey' 'FK_CG_Flex1Ticket_UDF_ForwardEmail'. Parent: 'CG_Flex1Ticket'. Error: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database. | |
| Could not create constraint. See previous errors. | |
| at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) | |
| at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) | |
| at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) | |
| at S |