Hi guys,
Im still fairly new to XML and need help on the following problem.
I know how to sort elements alphabetically using my XSL stylesheet. All I do is use <xsl:sort> in the template.
I want some buttons or links on my XML page that will dynamically change the sort order.
For example, if...
Hi,
I have the following DTD and XML data. It uses ATTLIST to describe the attributes of 'name'. I want to display the attlist contents using an XSL file.
For example, using the XSL template, I need it to be displayed as:
Fred
25
15th Dec 1962
0123428374
Is this possible? A sample of the...
Internet Explorer will not automatically validate (check) your XML for you, you need a special validator which will do it.
Here's a site that does it for you...
http://www.stg.brown.edu/service/xmlvalid/
Just enter the location of the file and it will find any mistakes for you.
Hi,
I have the following extract from my XML:
<bookentry>
<authorgroup>
<author>
<firstname>Rebecca</firstname>
<surname>Mills</surname></author>
</authorgroup>
</bookentry>
<bookentry>
<authorgroup>
<author>
<firstname>Gary</firstname>...
I need to know how to create a table/view using an already existing table.
Is it possible to use something like:
CREATE VIEW newTable AS
SELECT * FROM oldTable
WHERE field1 = 1;
Which will then allow me to use
SELECT * FROM newTable;
Any ideas?
To be more specific, here is the table BOOKING
+------------+-------------+----------------+------------+
| car_ref_no | mechanic_id | job_name | date |
+------------+-------------+----------------+------------+
| CR3 | 1 | Brake Pad | 2000-02-28 |
| CR6...
I have the set of tables:
MECHANIC (mechanic_id, name, competence_level)
CAR (car_ref_no, make, model, owner_name, value_category, car_reg_no)
BOOKING (car_ref_no, mechanic_id, job_name, date)
And I need to list the car_reg_no and make of any car that was worked on by all the mechanics.
For...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.