|
Hai,
I have been able to develop database applications using Recordsets technology. I worry is that this approach is a bit cumbersome for large database applications.
I want to use an approache were I will be able to access a single or set of records directly from a Database without having to search in the resulting recordset.
In short I want to be able to use SQL in my database programs in VC++.
How should I connect to the database. What specific coding and setup is needed.
Lloyd.
|
|
|
|
|
Hai,
I'am a new VC++ developer, I have been able to develop applications using
MFC Single/Mutiple Doments and manipulating recordsets.
I want to access records in a database using Dialogue Boxes instead of document forms. I do not like the appearance of a Document based database apllication.
What procedures should I follow to be able to access a database using Dialogue Boxes.
Lloyd.(Zambia)
|
|
|
|
|
Hello. I have tried to build my project which references msxml4.dll but when I try to build it I get the following error:
Cannot open type library file: 'msxml4.dll'
I can manage to find this on the Internet I think but should I just put it somewhere in my path or is there a proper way of installing it along with maybe an SDK? I have tried installing the Internet SDK but it does not install the file I want. I have tried searchig for it on my hard disk after installing the SDK but it is not there.
Thank you for any help.
|
|
|
|
|
Hi,
Here is the link to MS for the msxml4 install.
Are you using it from VC or VB ?
The msxml4.dll should end up in the System32 directory of your system.
Hope this helps,
Andy
|
|
|
|
|
Hi Everyone,
I'm new to this forum and I have quite a probleem here!!! Iam
looking for an XSL or even Java Script that will allows me to view a table in a normal
view and an extended view. See here below..
|Table (Go to Extended View)|
_______________________________________________________________
Thing |property| |Extra stuff|
_____ |________|______|___________|__________________________
blabla |blabla |blabl | blabla |blabla
________|________|______|___________|___________________________
This is an example of the table, when you click the extended view
link you can view the extended view and vice versa here below….
Table (Back to Normal View)
_______________________________________________________________
Thing |property| |Extra stuff|Extra column
_____ |________|______|___________|__________________________
blabla |blabla |blabl | blabla |Extra blabla
________|________|______|___________|___________________________
ExtraRow|blabla |blabl | blabla |Extra blabla
________|________|______|___________|___________________________
ExtraRow|blabla |blabla|blablblabla|Extra blabla
________|________|______|___________|___________________________
Does anyone have anything like this? It has given me nuch headache
|
|
|
|
|
Hi Everyone,
I solve the problem by letting Microsoft's new software InfoPath generate it for me... It looks very complicated but it works.. I think Microsoft has just taken away the fun in writing XSLT scripts... very powerfull tool.. that Infopath...generates the xsd, xsl, xslt, jscript name it.....and saves a lot of time.
Thanks,
|
|
|
|
|
hi my dear
i use xslt template to transform xml content to html file.
but i have some problem ,that is the inner text of P tag in generated html file(p tag is contained with a cell of an absolute table) don't wrap
automatically!and it cause to resize the container table and when
i open that html file in VS .NET environment and changes any thing likee a tag property the text of p tag becomes true!
even i used nowrap property of p tag to false but it didn't work!
how i can fix this bug in my product?
thanks a lot
hassan azizi
|
|
|
|
|
hi my dear
i use xslt template to transform xml content to html file.
but i have some problem ,that is the inner text of P tag in generated html file(p tag is contained with a cell of an absolute table) don't wrap
automatically!and it cause to resize the container table and when
i open that html file in VS .NET environment and changes any thing likee a tag property the text of p tag becomes true!
even i used nowrap property of p tag to false but it didn't work!
how i can fix this bug in my product?
html sample:
....
<table style=" POSITION: absolute; top:147; left:173" width="398" height="292" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0">
<tr width="100%">
<td width="100%" dir="ltr">
<p align="left">
<font face="Tahoma" color="#000000" style="font-size:8pt">aaaaaaaaaaaaaaa aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaa aaaaaaaaaaaaa ddddddddddd dddddddddd dddddddddddddd dddddddddddddd dddddddddddddd dddddddddd sssssssssss sssssssssssssssssssssssssssssssss </font>
</p>
</td>
</tr>
</table>
.....
problem : the text in p tag don't wrap!
xslt partial template:
....
<font face="{$font}" color="{$color}" style="font-size:{$size}pt">
<xsl:call-template name="InnerText">
<xsl:with-param name="text" select="translate(.,' ',' ')" />
</xsl:call-template>
</font>
.....
thanks a lot
hassan azizi
|
|
|
|
|
I am doing a simple task where I am trying to create a table of cars with co
lumn headers such as model, make, color etc and then have details of the dif
ferent cars underneath ..... and I have to create a dtd, xml and xls file fo
r them. I have tried entering one set of data for a Mercedes car but the dat
a just all comes out together on one line and doesn't create the table as I
had hoped! My output looks like this:
Cars for Sale
makemodelyearcolorengineradioair conditioningpower windowspower steeringpowe
r brakes1Mercedes BenzE2402003Black8fuel_injected yes yes yes yes yes
Any help MUCH appreciated. Thanks
Here is my code:
cars_for_sale.DTD:
<?xml version="1.0"?>
<!ELEMENT cars (car+)>
<!ELEMENT car (make, model, year, color, engine, number_of_doors, transmissi
on_type, accessories*)>
<!ELEMENT engine (number_of_cylinders+, fuel_system)>
<!ELEMENT make (#PCDATA)>
<!ELEMENT model (#PCDATA)>
<!ELEMENT year (#PCDATA)>
<!ELEMENT color (#PCDATA)>
<!ELEMENT number_of_doors (#PCDATA)>
<!ELEMENT transmission_type (#PCDATA)>
<!ELEMENT accessories (#PCDATA)>
<!ELEMENT number_of_cylinders (#PCDATA)>
<!ELEMENT fuel_system (#PCDATA)>
<!ATTLIST accessories radio CDATA #REQUIRED>
<!ATTLIST accessories air_conditioning CDATA #REQUIRED>
<!ATTLIST accessories power_windows CDATA #REQUIRED>
<!ATTLIST accessories power_steering CDATA #REQUIRED>
<!ATTLIST accessories power_brakes CDATA #REQUIRED>
<!ENTITY bmw "B M W">
<!ENTITY me "Mercedes Benz">
<!ENTITY fo "Ford">
<!ENTITY v "Volvo">
<!ENTITY mi "Mini">
<!ENTITY j "Jaguar">
<!ENTITY p "Peugeot">
<!ENTITY rr "Rolls Royce">
cars_for_sale.XML:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE cars_for_sale SYSTEM "cars_for_sale.dtd">
<?xml-stylesheet type="text/xsl" href="cars_for_sale.xsl"?>
<cars_for_sale>
<car id = "1">
<make>&me;</make>
<model>E240</model>
<year>2003</year>
<color>Black</color>
<engine>
<number_of_cylinders>8</number_of_cylinders>
<fuel_system>fuel_injected</fuel_system>
</engine>
<number_of_doors>5</number_of_doors>
<transmission_type>Diesel</transmission_type>
<accessories>
<radio>yes</radio>
<air_conditioning>yes</air_conditioning>
<power_windows>yes</power_windows>
<power_steering>yes</power_steering>
<power_brakes>yes</power_brakes>
</accessories>
</car>
</cars_for_sale>
cars_for_sale.XSL:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version = "1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match = "/">
<h1>Cars for Sale</h1>
<car border = "border">
<tr>
<th></th>
<th>make</th>
<th>model</th>
<th>year</th>
<th>color</th>
<th>engine</th>
<th>radio</th>
<th>air conditioning</th>
<th>power windows</th>
<th>power steering</th>
<th>power brakes</th>
</tr>
<xsl:for-each select = "cars_for_sale/car">
<tr>
<th><xsl:value-of select = "@id" /></th>
<td><xsl:value-of select = "make" /></td>
<td><xsl:value-of select = "model" /></td>
<td><xsl:value-of select = "year"/></td>
<td><xsl:value-of select = "color"/></td>
<td><xsl:value-of select = "engine/number_of_cylinders"/></td>
<td><xsl:value-of select = "engine/fuel_system"/></td>
<td><xsl:value-of select = "accessories"/></td>
</tr>
</xsl:for-each>
</car>
</xsl:template>
</xsl:stylesheet>
|
|
|
|
|
I'm assuming that you are trying to write out a html table.
If you are then you need to output a table tag as well as the rows and cells.
|
|
|
|
|
I'm building an application, using C# and SQL 2000, where based on the user identity I wish to present different views of data and XSLT is an ideal solution for this application. If when I call the Load method of XslTransform I reference an on-disk file everything works as expected.
XslTransform transform = new XslTransform ();
transform.Load (@"D:\WorkDir\test.xslt");
However, I want to store different XSLT's in the database and retrieve it based upon the user's identity. (Interesting enough I could find no sample code anywhere that did this, although I would think it would be fairly common).
When I try to read back the XSLT from SQL - if I do not put in a FOR XML I cannot load the result into an XmlReader class. I get an exception of:
"Invalid command sent to ExecuteXmlReader. The command must return an Xml result."
Putting in a FOR XML AUTO or RAW allows it to load the reader, but the transform.Load subsequently fails with:
"Missing mandatory attribute 'version'."
although there is a version tag in my XSLT.
sqlConn.Open ();
SqlCommand sqlCommandXSL = new SqlCommand ("sp_GetUserTransform 0", sqlConn);
XmlTextReader xmlReadTransform = (XmlTextReader) sqlCommandXSL.ExecuteXmlReader ();
XPathDocument doc = new XPathDocument(xmlReadTransform, XmlSpace.Preserve);
XPathNavigator xpn = doc.CreateNavigator ();
XslTransform xslTransform = new XslTransform ();
xslTransform.Load (xpn, null, null); <-- throws exception here.
I'd appreciate any insights as to what I'm doing incorrectly and links to samples that show how to do this.
Thanks.
|
|
|
|
|
I am using the classes and methods from the Msxml2.DOMDocument.4.0 namespace to dynamically create an XML file using VBScript. (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/htm/xml_mth_sz_3jol.asp). I was able to successfully create the XML and load it into memory for parsing. However, for some reason, I am not able to use the SelectSingleNode() method of the IXMLDOMNode object. The error I get is: "Object doesnt support this property or method. Error code: 800A01B6".
Any ideas?
|
|
|
|
|
hi
I try to send data as xml bitween client/server
help me i don`t need to enconing it byte`s
thank you
|
|
|
|
|
Erm, what language / platform / protocol are you using?
Ryan
|
|
|
|
|
1- thank you
2- language c# ,platform 2003 server ,protocol ip
hmd.....
|
|
|
|
|
Do someone no how to open/load an empty file in IXMLDOM? I want to export data from a program to a xml-file. To do so I have to open a empty file and then start creating Elements ant attributes and stuff. Anyone who could help me...please, I'm stucked
|
|
|
|
|
im a college student, being asked to implement an xml signature.
i have a very basic knowledge on xml signature.
theoretically,i understood that one of its method involves SHA and DSA.
but practically, how do i use those SHA and DSA?
what platform and software do i need?
can anyone suggest a very basic and simple one so i can generate and verify xml signature.
akima
|
|
|
|
|
|
I'm working on an App that will transfer info via XML to Microsoft project 2002.
How can I find info about the XML-file I should create?
...and justice for all
APe
|
|
|
|
|
Hi Friends
I have to call 1 of the 2 child XSLT files from the Main XSLT file based on some criteria. I want one child XSLT file will be executed by version 1 of XSLT processor and the other by version 2 of XSLT processor based on some condition.
Q) How and where shall I write logic or import desirable XSLT on the Fly ?
Q) When we call AAA.XSLT then it will be processed by XSLT Processor 1 and when we call BBB.XSLT,it will be called by XSLT processor 2. (This is what I want to happen). Is this statement correct? Is it possible?
---Main.XSLT-----
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<!-- This functionality is not supported. -->
<xsl:choose>
<xsl:when test = "X = AAA">
<xsl:include href=".\AAA.xslt"/>
</xsl:when>
<xsl:when test = "X = BBB">
<xsl:include href=".\BBB.xslt"/>
</xsl:when>
</xsl:choose>
</xsl:stylesheet>
----------------
---AAA.XSLT----------
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<!----some code here for version 1 of xslt---->
</xsl:template>
</xsl:stylesheet>
---BBB.XSLT-----------
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<!------some code here for version 2 of xslt---->
</xsl:template>
</xsl:stylesheet>
Thanks
Mohit
mohitfl@hotmail.com
|
|
|
|
|
I am sorry for My English is poor
i want to ask that
i have a .XSD file which have an complexType
the complexType have some element
can i use fill method to fill these element
study everyday
|
|
|
|
|
I am a student and i got assignment to do which is the title is
"An XML browser-based electronic medical record"
So, anyone can help me to this project?
I really-really need any help from others because i don't know how to do it.
Any question just email me at: alyssahaskell@yahoo.com
Thank you
|
|
|
|
|
Hi, i think you just have to document contacts physician-patient in med. terms. Well, an then do some XSL-Transofrmation into HTML to view the content?
some med. standards (for google): HL7 , CDA, ICD, sciphox, ..
I mean/suggest some xml like:
<?xml version="1.0"?>
<record xmlns:myns="my/medrecord">
<head>
<patient id="2534">
<name> .. </name>
<insurence> .. </insurance>
</patient>
</head>
<body>
<contact date="2004-01-30" med="Dr. Mabuse">
<anamnesis>
problems with stomach, often tired
</anamnesis>
<finding>
high bloosugar values,low bloodpressure
</finding>
<diagnoses icd10="B20.4"> <!-- International Code of diseases -->
diabetes mellitus typ II
<diagnoses>
<prescription>
antisugar 100 mg N1
</prescription>
</contact>
<contact date="2004-02-04" med="Dr. Mabuse">
<laboratory>
<value name="LEUK" unit="count">263</value>
<value name="BIL" unit="mg/dl">23.4</value>
</laboratory>
...
</contact>
...
</body>
</record>
good luck!
|
|
|
|
|
Please
can some one tell me whats Inner XML and Outer XML
Every is Illusion
|
|
|
|
|
OuterXML refers to the xml representation of the current node and its contents. InnerXML refers to the xml representation of the contents of the current node only, and not the current node itself.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
