Assuming variables is required, the following 39 results were found.
-
q ON r."Question ID" = q."ID" LEFT JOIN "Respondents (Zoho Survey)" r2 ON r."Respondent ID" = r2."ID" LEFT JOIN "Response Variables (Zoho Survey)" r3 ON r2."ID" = r3."Respondent ID" LEFT JOIN "Pages (Zoho Survey)" p ON r."Page ID" = p."ID" WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
in this example is the "mysqli_real_escape_string" function applied to a number. You will need to be more vigilent. Variables are all cleared and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION methods. Or...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
PHP template so that the first search is based on the above heuristics: This needs to be put alongside the other hidden variables in the module, core joomla file is at /modules/mod_search/tmpl/default.php and I put it just before the closing form tag "...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables. Why? In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
registered the app with the Google developers console along with the redirect URI being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... // specific to this app $CLIENT_ID = ''; //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Create a variable which is used to identify the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private byte[] emptyBytes = null; private const string DebugLogEventName = "JL...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
opposed to European Given a Campus as a text value, the SQL query was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: --...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
** ** ** ***********************************************************************************/ BEGIN -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
to replace these with events from an actual database. So I just need a table returned with the "EventDate" and the "Note" variables from the other database. If I use the hard-coded examples above, I would want a results table similar to the following:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int;...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
GO -- Create Stored Procedure CREATE PROCEDURE dbo.usp_MakeTableTemp @SchemaTableName nvarchar(100) AS BEGIN -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
BEGIN -- Declare some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
in a specific case. CREATE FUNCTION ufn_ProperCase(@Text AS VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN -- declare some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
How? So almost pure JS. I'm working out the seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds remaining and elapsed are...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
open connection $ch = curl_init(); // set the cURL options curl_setopt($ch, CURLOPT_URL, $api_url); // where to send the variables to curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml')); // specify content type of what we're sending...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
format they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key (posted variables must be key1=value1&key2=value2...) Script #3: process returned data
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following loops through directory for any file...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
by functions, classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the error in understandable and diagnosable parts?...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *