Member Avatar
Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …
by cereal 1,078 in Databases ()
Member Avatar
<?xml version="1.0"?> <License version="1"> <ActivationInfo> <ActivationDate></ActivationDate> <IssueDate>22-Dec-2015</IssueDate> </ActivationInfo> <MachineInfo> <MachineName></MachineName> <SoftwareIds></SoftwareIds> </MachineInfo> <LicenseKeys> <LicenseKey> <LicenseVersion>1</LicenseVersion> <FeatureName>PLI_FEATURE1</FeatureName> <LicenseType>PERMANENT</LicenseType> <CustomProperties> <CustomProperty> <key>LICENSETYPE</key> <value>EVAL</value> </CustomProperty> <CustomProperty> <key>CAPACITY</key> <value>10</value> </CustomProperty> <CustomProperty> <key>CAPACITY_UNIT</key> <value>TB</value> </CustomProperty> </CustomProperties> </LicenseKey> <LicenseKey> <FeatureName>PLI_FEATURE2</FeatureName> <LicenseType expirationDate="01-Jan-2017">EVALUATION</LicenseType> <CustomProperties> <CustomProperty> <key>LICENSETYPE</key> <value>EVAL</value> </CustomProperty> <CustomProperty> <key>CAPACITY</key> <value>10</value> </CustomProperty> <CustomProperty> <key>CAPACITY_UNIT</key> <value>TB</value> </CustomProperty> </CustomProperties> …
by kkvk in Software Development ()
Member Avatar
Hi, **Python script** from xml.dom import minidom doc = minidom.parse("wind7.xml") Ts = doc.getElementsByTagName("TimeStep") for Ts in TimeStep: Part = TimeStep.getElementsByTagName("Particle")[0] for Part in Particle: Pcid = Particle.getAttribute("Nr") Lat = Particle.getAttribute("x") Long = Particle.getAttribute("y") print("Pcid:%s,Lat:%s,Long:%s" % (Nr,x.firstChild.data,y.firstChild.data)) I have written this python script to extract XY data, but am getting lot …
by Ketaki_2 in Software Development ()
Member Avatar
This is php code at https://developers.google.com/maps/articles/phpsqlajax_v3#putting-it-all-together. <?php $username="xxxx"; $password="xxx"; $database="xxx"; ?> <?php function parseToXML($htmlStr) { $xmlStr=str_replace('<','&lt;',$htmlStr); $xmlStr=str_replace('>','&gt;',$xmlStr); $xmlStr=str_replace('"','&quot;',$xmlStr); $xmlStr=str_replace("'",'&#39;',$xmlStr); $xmlStr=str_replace("&",'&amp;',$xmlStr); return $xmlStr; } // Opens a connection to a MySQL server $connection=mysql_connect ('localhost', $username, $password); if (!$connection) { die('Not connected : ' . mysql_error()); } // Set the active MySQL …
by Seung Hwan in Programming ()
Member Avatar
I want to mark some data on google map. I use eclipse Java EE and xml file is in the same workspace;(workspace_jsp). xml file: <csv_data> <row> <time>10:01:43</time> <latitude>37.4805016667</latitude> <longitude>126.952741667</longitude> <pdistance>0.000555</pdistance> <totaldistance>0.000555</totaldistance> <sectionspray>3343.0</sectionspray> </row> <row> <time>10:01:57</time> <latitude>37.4807483333</latitude> <longitude>126.952753333</longitude> <pdistance>0.027396</pdistance> <totaldistance>0.027951</totaldistance> <sectionspray>3320.0</sectionspray> </row> my code is <!DOCTYPE html > <head> <meta name="viewport" …
by Seung Hwan in Programming ()
Member Avatar
I have a MySQL database which contains a text field which contains well formed xml. I want to export this data as an xml file named result_new.xml on the fly. I have made the tmp folder and have set the permissions on the folder to 0777. If I run this …
by facarroll in Web Development ()
Member Avatar
Hi there, I am an undergraduate studying computer science. Our lecturer gave us an assignmnet to use Dapfor grid control display both authors name and their book. I don't know where to begin from. Can anyone put me through; maybe with an example.
by emilyjackson in Programming ()
c c# xml
Member Avatar
I am attempting to add a custom function to my schematron rule stylesheet to aid in looking up values in code tables. I continue to receive an error message: 'XPST0017 XPath syntax at char 0 on line 545 near (...ookupExpression('SEX'): Cannot find a matching 1-argument function named (functions:1.0)BuildLookupExpression())' At the …
by cjhukill in Software Development ()
Member Avatar
Hi there to all I'm trying to make application which should extract certain data from XML files. I'm using form, combobox and button. If someone could guide me because I'm not so familiar with programming... here is code example To populate Combobox1 and it works fine Private Sub form1_load(sender As …
by SoftBa in Software Development ()
Member Avatar
First let me confess that I'm a beginner with little knowledge of Java. I'm facing a problem with XML to JSON conversion. The XML that I need to covert is complex with elements that will repeat throughout the document. And the order in which the elements appear need to be …
by newprogrammer14 in Programming ()
Member Avatar
<select id="keyEquipmentShiftAutomatedModelData" parameterType="java.util.Map" resultType="java.util.Map"> SELECT ID, SUM(VALUE1 + VALUE2) Total FROM tableName GROUP BY ID </select> Returns below result in sql ID, Total 1 (null) But when returned in Map result in myBatis returns {ID=1} where as Total is missing. How to get the column with null into the result …
by Siddharth_6 in Programming ()
Member Avatar
Hi, I am struggling with xml layout in my android app... please help here is what I want: I have to display two poarts in one activity - image part and login component part which are in one linearLayout. When the device is landscape, I want it to be 30% …
by 9tontruck in Mobile Development ()
Member Avatar
Hello guys so i'm quite new to C++ but i already learned OOP and other things so i want to use this little knowledge yet to create some basic program. I wanted to make a program that uses some API's but the problem is i'm not famillar how API's work …
by justine_1 in Programming ()
Member Avatar
I just want to know whether the ROR sitemap is still an effective choice for SEO? Because, nowadays no one is using ror sitemap.
by Piers Rollins in Search Engine Strategies ()
Member Avatar
I am very much interested in learning programing and software development skills. However i know sotware testing skills, knowledge of hardware, software applications, information security, networking. I do lot or research to learn to develop and desing website with databse integration. I am not financially fit to invest in all …
by SHANTHA_MH in Software Development ()
Member Avatar
I am trying to build a web application that can also run on mobile phones. Is the html code generated by imgmap_desktop can be run on both web and mobile? or rather web responsive type?
by Anoopgupta in Programming ()
Member Avatar
xml output: <balance> <credits>39660</credits> </balance> how to fetch the xml output from url and store the credits i.e. 39660 into php variable. the above xml output is coming from following url http://www.xyz.com/check-balance.php?username=ssgent&password=ssgentr check-balance.php code: <?php require('dbcon.php'); include('encrypt.php'); include('functions.php'); $username = $_GET['username']; $password = $_GET['password']; $password = encrypt($password, 'riffre'); $url = …
by blueguy777 in Web Development ()
Member Avatar
Dear all, I am looking for guideline to read data from website[photon](http://www.photon.info/photon_site_db_solarmodule_en.photon) . & load into csv file. Whenever new supplier selection or typesection change data should recorded into same excel with new sheet. Can some guide how to get started using python This code to develop for database. Is …
by ajit.nayak in Software Development ()
Member Avatar
I am using XML:twig to extract some attributes from an XML file using Perl; Here is my code: use XML::Twig; my $file = $ARGV[0]; $file =~ /(.+)\.xml/; my $outfile = $1.".snp" ; open my $out,'>',$outfile or die "Could not open file '$outfile' $!"; my $twig = XML::Twig->new ( twig_handlers => …
by Ahmed_65 in Programming ()
Member Avatar
I am work in my seo site do all seo techniq is use but not in google index page.
by harishprakash -3 in Search Engine Strategies ()
Member Avatar
Hi, I've recently been assigned a task in a new job where I have to compare XML paths against Acord XML paths to find out what the ancestor path is. I've never done anything like this before and just want to check that I am doing it correctly because i've …
by coder91 in Software Development ()
xml
Member Avatar
I have an xml structure : <Pages> <!--This is the root node--> <Home> <url>...</url> <menu> <item>Help</item> <item>About</item> <item>Contact</item> </menu> </Home> <Help> <url>...</url> <menu> <!--i need to select this if its parent(Help) is listed in Home/menu/item above--> <item>Business Help</item> <item>Web Help</item> <item>Tour Help</item> </menu> </Help> <About> <url>...</url> <menu> <!--And Or select …
by Osagie_1 in Software Development ()
Member Avatar
I have an xml structure : <Home> <url>...</url> <menu> <item>Help</item> <item>About</item> <item>Contact</item> </menu> </Home> <Help> <url>...</url> <menu> <!--i need to select this if its parent(Help) is listed in Home/menu/item above--> <item>Business Help</item> <item>Web Help</item> <item>Tour Help</item> </menu> </Help> <About> <url>...</url> <menu> <!--And Or select this if its parent(About) is listed …
by Osagie_1 in UI / UX Design ()
Member Avatar
Hi I have a php script which creates an xml file //Select the Database mysql_select_db("personeelsbestand",$db); $result = mysql_query("select * from XMLAfdeling", $db); //Create SimpleXMLElement object $xml = new SimpleXMLElement('<xml/>'); //Add each column value a node of the XML object while($row = mysql_fetch_assoc($result)) { echo $row['Afdelingnaam']."\n"; $mydata = $xml->addChild('mydata'); $mydata->addChild('AfdelingID',$row['AfdelingID']); $mydata->addChild('Afdelingnaam',$row['Afdelingnaam']); …
by nevek in Web Development ()
Member Avatar
I have been trying since long to extract data using xpath in google sheets but everytime 'am getting message 'imported content is empty'. i need help . The url is http://reports.ieso.ca/public/IntertieScheduleFlow/PUB_IntertieScheduleFlow.xml
by krofox in Software Development ()
Member Avatar
Here is the CSV file that I am working with: `"A","B","C","D","E","F","G","H","I","J" "88",18,1,"<Req TID=""34"" ReqType=""MS""><IISO /><CID>2</CID><MemID>0000</MemID><MemPass /><RequestData><S>[REMOVED]</S><Na /><La /><Card>[REMOVED]</Card><Address /><HPhone /><Mail /></ReqData></Req>","<Response T=""3"" RequestType=""MS""><MS><Memb><PrivateMembers /><Ob>0-12-af</Ob><Locator /></Memb><S>[REMOVED]</S><CNum>[REMOVED]</CNum><FName /><LaName /><Address /><HPhone /><Email /><IISO /><MemID /><MemPass /><T /><CID /><T /></MS></Response>",0-JAN-10 12.00.02 AM,27-JUN-15 12.00.00 AM,"26",667,0 "22",22,1,"<Req TID=""45"" ReqType=""MS""><IISO /><CID>4</CID><MemID>0000</MemID><MemPass /><RequestData><S>[REMOVED]</S><Na /><La /><Card>[REMOVED]</Card><Address /><HPhone /><Mail /></ReqData></Req>","<Response …
by Saran_1 in Software Development ()
Member Avatar
<Error> <Code>AccessDenied</Code> <Message>Access Denied</Message> <RequestId>E9F449356111EF63</RequestId> <HostId> rQvhUyG5YcEhWAybnmeDjIofcdmbmua7vkr/7v16J7EK3oQZPaQwBBlDFRZb54w7h3wz/F wfWA= </HostId> </Error>
by BiBi_2 in Software Development ()
xml
Member Avatar
My XSLT is like: <!DOCTYPE stylesheet [ <!ENTITY hyphen "<xsl:text>-</xsl:text>"> <!ENTITY cr "<xsl:text> </xsl:text>"> ]> <xsl:stylesheet id="test" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ext="http://exslt.org/common" exclude-result-prefixes="ext" version="1.0"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:variable name="vc_NDCROI" select="'NDC05'" /> <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <xsl:template match="node()|@*" mode="mPass2"> <xsl:copy> <xsl:apply-templates select="node()|@*" mode="mPass2"/> </xsl:copy> </xsl:template> <xsl:template match="/"> <xsl:variable name="vrtfPass1Result"> …
by can-mohan in Software Development ()
xml
Member Avatar
I'm trying to convert this xml to json or array. first this is what i did: $response = simplexml_load_string($xml_test); and i got error: < not found, anyone can help me? HTTP/1.1 200 OK Date: Wed, 03 Jun 2015 10:19:38 GMT Server: Apache-Coyote/1.1 Pragma: no-cache Cache-Control: no-cache Expires: Thu, 01 Jan …
by old_apache 15 in Software Development ()
Member Avatar
Help me how to write persian language (utf-8) in xml file?
by Hanif1993 3 in Software Development ()