Assuming replace is required, the following 101 results were found.
-
+ '/01/2009 01:30:00 PM', Note = 'Event 6' As you can see, these events were hard-coded into the script. I was asked to replace these with events from an actual database. So I just need a table returned with the "EventDate" and the "Note" variables from...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= 1; -- Determine if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html
Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
= 1; -- Determine if Given Value is date (ISDATE does not recognize CAST AS DATE) IF @OrigLen=10 AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2 AND ISNUMERIC(SUBSTRING(@OrigVal, 1, 4))=1 AND ISNUMERIC(SUBSTRING(@OrigVal, 6, 2))=1 AND...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype IN VARCHAR2, p_original_range_1 IN VARCHAR2...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
DEFAULT ''; -- temporary string holder for query -- get length SET str_len=LENGTH(str); SET i = (LENGTH(str)-LENGTH(REPLACE(str, delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
of each and submit to Client Apply chosen template Design and Layout Implementation Corporate Logo Create initial logo and replace existing template logo with this one Discuss suitability and variances Convert, format, or create vector-based version of...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both instances of the text "http://my.video.com/myVideo.flv" with the full url of your own FLV. Save the HTML page and...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: *
-
a transition. Push existing slide out to the left; as soon as this is out of sight then hide it behind the displayed slide. Replace contents of the hidden slide with contents of the displayed slide. Hide currently displayed slide to expose the first...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
echo "Stored in: " . "" . $_FILES["uploaded_file"]["name"]; chmod("" . $_FILES["uploaded_file"]["name"], 0755); } Obviously replace with your full path (eg. /var/www/html/images). My Full Snippet This is the code on the receiving PHP file: /** STUFF FOR...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
hopefully, the PHP file will handle as: var $site_structure_string = $_GET['myFolder']; $site_structure_string = preg_replace('/[^a-zA-Z0-9_\\/]/', '', $site_structure_string); var $site_structure_item = $_GET['myFiles']; var $site_structure_array =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No htmlentities(): No preg_replace_callback(): No sxe(): No $xml = simplexml_load_string( utf8_encode($rss) );: No. Oh wait, yes! sorta, don't forget the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters: Control Options not in effect - Added parameters: Style for Google Maps API v3 - ALL -...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
on a budget, yes those are permanent marker color-ins the chipped smaller propeller is stock Less on a budget, let's replace the FC40 gimbal...with an AerialFreaks Cyclops 2-Axis Brushless Gimbal System designed for the DJI FC40 camera Gimbal frame...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but wouldn't it be nice if you could just replace the base64encode function with an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml = CONVERT(xml,'' + REPLACE(@myStringToParse,',','') + ''); SELECT [Value] = T.c.value('.','varchar(20)') FROM @myXml.nodes('/root/s') T(c);
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
and does not contain apostrophes -- eg. O'Brien will NOT be returned -- Other REGEXP Functions for Oracle: -- -- REGEXP_REPLACE(country_name, '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE ( '1, 2, 3, 4, 5, 6' , ',', '') || '' ) AS xmlval FROM DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB