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]

...stright away, i can wait. There isnt a risk that two users could create the same file. Each user has a folder within main system/store/userid/*users store space* So two users will never write to the same file. There is however the chance that one user may click something twice (this is in...

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

...select="/example/definition"> <xsl:variable name="i" select="/example/definition/position()"/> <xsl:variable name="temp" select=$i> ****doing what i want with this definition...**** </xsl:for-each> Is this possible, i've got everything else how i want it, but if this is not possible...

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...