Posts by wblakenc

Ok I think the answer is to use XSLT to sort the items I want..... I said I was new! Sorry for the dumb question!!!

I am very new to using XML and I have what should be an easy solution but google is failing me. I have one xml document with different data sets in it (see code below). What I want is to only work with one set of data at a time.

Here is a sample XML doc:

<CATALOG>
  <CD>
	<TITLE>Picture book</TITLE>
	<ARTIST>Simply Red</ARTIST>
	<COUNTRY>EU</COUNTRY>
	<COMPANY>Elektra</COMPANY>
	<PRICE>7.20</PRICE>
	<YEAR>1985</YEAR>
  </CD>

  <CD>
	<TITLE>Red</TITLE>
	<ARTIST>The Communards</ARTIST>
	<COUNTRY>UK</COUNTRY>
	<COMPANY>London</COMPANY>
	<PRICE>7.80</PRICE>
	<YEAR>1987</YEAR>
  </CD>

  <TAPE>
        <TITLE>Unchain my heart</TITLE>
	<ARTIST>Joe Cocker</ARTIST>
	<COUNTRY>USA</COUNTRY>
	<COMPANY>EMI</COMPANY>
	<PRICE>8.20</PRICE>
	<YEAR>1987</YEAR>
  </TAPE>
  <TAPE>
        <TITLE>The dock of the bay</TITLE>
	<ARTIST>Otis Redding</ARTIST>
	<COUNTRY>USA</COUNTRY>
	<COMPANY>Atlantic</COMPANY>
	<PRICE>7.90</PRICE>
	<YEAR>1987</YEAR> 
  </TAPE>
</CATALOG>

In the above example I would like to extract the data sets that are in the CD category first and the TAPE category second. How do I do this? I am able to parse the entire XML doc into an array that I can access using standard array syntax (i.e. xmlChildren[1]). But that gives me only one node or one specific title, how do I restrict to a specific type? Is there some way using the XML DOM to only reference a specific type?

Any suggestion or comment, or question would be greatly appreciated!

That works, well sorta...

It seems it does exactly what it should and ends the each row with a </tr>, except when it starts a new row it appends that data to all previous rows.

So lets say I type in 10 offices

So I get the first row with offices 1 - 10
second 4-10
third 7-10
fourth 10

I put some window.alert breaks in there to better see what it is doing and it is working except now it is appending to all the previous rows, which I guess makes sense because i am telling it to append to a tr inside table p.

Is there anyway make sure it is appending to the correct row by putting some sort of variable in the statement (I have tried the following and it does not work):

$("#p").append("<tr id=row" + tracking + ">");
$("#p #row" + tracking).append("<td>" + tracking + ")" + "&nbsp;&nbsp;&nbsp;<input type='text' size='50' name='Office" + tracking +"' /></td>");

Any idea?

Ok here is what I am trying to. I have a form where a user will enter in the number of input fields they need (lets call them offices) and when they click the submit button a jQuery function appends the rows to a plain html table. This works fine, except I do not want the rows to be only vertical or horizontal. I want it to put three input fields on one row before going to the next. Here is the code I have:

//This function is for adding rows to the offices table
function addOfficeRows() {
	var i = 0;
	var counter = document.getElementById("oNum").value;
	var tracking = document.getElementById("officeTracking").value;
	var tracking = parseInt(tracking);
	// second counter which helps determine if a new row should start or not //
	var second = 1;
		for(i=1;i<=counter;i++) {
			if (second == 1) {
				$("#p").append("<tr>");
				$("#p").append("<td>" + tracking + ")" + "&nbsp;&nbsp;&nbsp;<input type='text' size='50' name='Office" + tracking +"' /></td>");
				second = second + 1;
			} else if (second == 2) {
				$("#p").append("<td>" + tracking + ")" + "&nbsp;&nbsp;&nbsp;<input type='text' size='50' name='Office" + tracking +"' /></td>");
				second = second + 1;
			} else if (second == 3) {
				$("#p").append("<td>" + tracking + ")" + "&nbsp;&nbsp;&nbsp;<input type='text' size='50' name='Office" + tracking +"' /></td>");
				$("#p").append("</tr>")
				second = 1;
			}
			tracking += 1;		
		}		
	document.getElementById("officeTracking").value = tracking;
	document.getElementById("officeAddRows").value = "Add More Fields";		
	
}

What happens is the <tr></tr> are getting appended to a "tbody" tag and rest is put outside of that tag, meaning the table is formed vertically. Any idea? Am I using append incorrectly? I am by no means an expert in jQuery so I am open to suggestions.

Thanks!

Ok after doing some more research (and searching the forum) I have obviously found others asking the same thing (without much help). Just to clarify, I want to be able to print to a printer connected on the host computer because this php script is not being used on the web it is being used on a computer that is both the host and end users computer. If I cannot use PHP for this, how can I do it.

Thanks,
Will

I am currently running IIS 7 on window vista business (64 bit) with PHP 5.3.1 installed and operating correctly. I have also installed PEAR and that is running correctly. What I want to do is use the Printer functions but can't seem to figure out how to get it to work. I have tried downloading PECL extension but when I go to: http://pecl.php.net/ and click on download newest it says file not found. So it is not exactly that I cannot get it to work, just cannot find and figure out how to install the extension.

So I am wondering if this has been removed in more recent versions of PHP? If I cannot use the PECL printer function, what else can I use?

Any ideas would be greatly appreciated.

Thanks in advance.

Will

Just to make it clear here is the code for what the user clicks on a menu option a sub menu shows up with the following options.

<div id="rampsMenu">
        <a href="javascript:;" onclick="expand_ramps()"><img src="cw3/assets/images/leftNav/Ramps.jpg" border="0" /></a><br />
        <a href="javascript:;"><img src="cw3/assets/images/leftNav/ThresholdRamps.jpg" border="0" /></a><br />
        <img src="cw3/assets/images/leftNav/SuitcaseRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/SingleFoldRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/MultiFoldRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/PanelRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/PathwayRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/CurbCutRamps.jpg" border="0" /><br />
        <img src="cw3/assets/images/leftNav/ShowAllRamps.jpg" border="0" /><br />
    </div>

The first link makes the sub menu show up, and the first link on that menu (Threshold Ramps) is currently liked to nothing (i.e. javascript: ; ).

Here is the JavaScript I am using to make this happen.

function expand_ramps(value) {	
	/* check to see if menu is already open */
	if (this.RampsOpen == 'Yes') {
		document.getElementById("rampsMenu").style.height = "20px";		
		this.RampsOpen = 'No';
	/* if the menu is currently not open, send it to drawInfo to perform the draw down effect */	
	} else {		
		var res = document.getElementById("rampsMenu");
		/* element, goal size, starting size */
		drawInfo(res,160,10);
		this.RampsOpen = 'Yes';		
	}
}

function reset_all() {
	document.getElementById("rampsMenu").style.height = "20px";		
}

function drawInfo(element, goal, start) {
	var GoalPt = goal;	
	element.style.height = (start)+"px";	
	element.style.clip="rect(0px, 222px, "+start+"px"+", 0px)";		
	var newvalue = start + 10;
	var repeat = function () {		
		drawInfo(element,GoalPt,newvalue)
	};
	if (newvalue >= GoalPt) {
		return;
	} else {
	element.info = setTimeout(repeat,1);
	}
}

Hello all,
I have run into an issue with an JavaScript expand menu (you click a menu option a sub-menu shows, moving the other main navigation menu options down).

Well I have designed a nice custom script to do just this. The problem is, how do I keep that sub-menu shown when the user clicks a link and the page refreshes. Basically I need a way to check to see if the menu has been opened before, and if so, keep it open on the new page. How does one do this? URL variable? Setting some sort of cookie? I know if I were doing something like this in ColdFusion I would just set a session, or other variable that persists page after page, but JavaScript has no such function?

Any Idea?

Thanks for any and all help!

Will

Perfect! This is what i was thinking, but just wanted to make sure I fully understood why and when I would need an intermediate table.

Thanks again for the help.!

Posted this in the wrong area... Sorry!

I know this should be in the database design area, however I was too quick to select MySQL as that is what I am using.

Hello everyone,
I have a fairly simple question about database design. I have a database for county voting equipment. Each county has multiple pieces of voting equipment. I currently have two tables, one with counties and one with voting equipment. Is there any reason to have a relational table between them or is it sufficient to have a county ID field in the equipment table and link them that way. Is there any pro to having a intermediate table between counties and equipment? Any drawback with linking them directly?

Thanks in advance.