... "http://joellipman.com/xml_feeds/my_XML_url.xml" );
$file_xml = simplexml_load_string( $file_content ); // doesn't work and returns a load of parser errors
The tweaked command using cURL is:
function ...
... XML declaration from results
$output = substr($output, stripos($output, '?>') + 2 );
// remove leading spaces, carriage returns
$output = trim($output);
// process if type specified was xml
if($apimo_type=='xml'){
...
What?
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...
... start with a function that just converts a string of words delimited by spaces to a table:
CREATE FUNCTION dbo.[ufn_StringToTable]
(
@StringInput VARCHAR(MAX)
)
RETURNS @OutputTable TABL ...
XSD Elements
Element Explanation
all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time
annotation Specifies the top-level element for ...
... do this:
But we didn't want to do this.
How?
As a proof of concept, I created one lookup task that executes a SQL query which returns all the joined tables and displays the decode name. Let' ...
... words that you want 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);
...
Applies to:
Joomla CMS v3.2.3 (Joomla.org)
jComments v3.0.0 (JoomlaTune.com)
PlayThru v1.1.8 (AreYouAHuman.com)
What?
This article is a follow on from my article JComments 2.3 with PlayThru ...
... AS XML).query('data(/STAFF/GENDER)') AS VARCHAR(10)) AS Gender
FROM
[dbo].[XML_EVENTS]
-- Returns column GENDER for every record/row (eg. "Male")
Or
-- Using .value()
SELECT
CAST(Event_XML ...
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.