Search results for query: *

Using OR will still include stores that sell only one of the two pizzas? not both? Just built the database and tried that query, it seems to return all the stores that sell either pizza but not both, but this, strangely, seems to work: SELECT store.sname,pizza.pname FROM...

no its not a homework assigment, i know about those three functions, how can they be used? I was thinking about doing something with union, but i think thats way off? You cant have multiple clauses in HAVING can you? HAVING pizza.pname = "veggie" AND pizza.pname = "cheese" doesnt seem to work!

I was looking through some example query questions are found these two: Consider the following database structure: pizza(pid, pname, size) store(sname, phone, quality) soldby(pid, sname, price) 1. Find the name of all the stores that sell both veggie and cheese pizza. 2. Find the names of all...

works a treat! thanks alot trojan

Hi all Got a problem i thought would be fairly easy to figure out :\! I've got a large string, say of 2000 characters. And a keyword phrase. What I'd like to do is find the first instance of this keyword phrase in the string, then chop the string to take 50 characters from behind the first...

Hi trojan the article doesnt seem to show how you get the element inside a tag, it only seems to establish the tag names? Also he uses the start_handler which i am trying to avoid using as i dont want to take in the entire xml document [b]and then work on it[b], i only want to grab specific...

Hi all just a quick question. I've been taking a look at the XML::Parser module, its been a while since i did! The subs style option seems intresting, when the parser hits an xml tag for example <bookname> it calls a sub routine you define as bookname. If i were to implement this, is there...

long [upsidedown]

instances of an object are created with a new method and are stored as an anonymous hash ($self = {};) as you suggested. Is this ok? I though about writing to the database at the same time, so i've created a cycle file which is set up as a cron job, this cycle file is a perl script which has...

that should read the xml files are split into sub folders which represent categories.

its essentially a really simple shop system, with an sql table to simulate products. Basically its storing products in xml files which are categorised into sub folders. A new product is a new xml file so theres never any two attempts on one file. The front end cgi scritps basically pass mysql...

Hey guys I've built a basic shop system as a small project, in object orientated perl ;)! I was just wondering what happens when multiple users call the same functions at the same time? I have cgi scripts at the front end, and they use generic back end functions, i could have 5,10,15 users...

pesky semi colons [thumbsdown]

o sorry, its meant to be &amp; try this <FL:url>"http://session.rservices.com/data/IcomServer?component=institutions&amp;root=Soccer"</FL:url> andy

& char is illegal i think, try replacing it with, '&amp' <FL:url>"http://session.rservices.com/data/IcomServer?component=institutions&amproot=Soccer"</FL:url> andy

hey guys Is there anyway i can assign the value of an element to a varible in an incremental manner? I have this xml for example <example> <definition>Business</definition> <definition>Sport</definition> </example> now these values are dynamic, so there may be more than one...

XSLT is a style sheet which XML files are passed into in order to transform XML into a HTML viewable format. I think the error you are getting means there is an error in the XSLT style sheet itself, try running the style sheet directly in your web prowser, the build in xml parser should show u...

i've just realised you cannot use xpath expressions inside xsl sort as it doesnt accept it! :( any other ideas?

ok is this close? <xsl:template match="query" mode="divs"> <div id="sortedPage{position()}" style="display: none;"> <xsl:apply-templates select="result"> <xsl:sort select="//result[@category='business']"/> </xsl:apply-templates> </div> </xsl:template> I've changed the result...

Hi guys I posted last week about splitting data up into sevral pages and got a great response that i should create divs for each page and show / hide them via hyperlinks. Well i've got a new problem :) I've applied this technique to sorting by creating more divs which display content in a...