Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jpo245

    WHERE field = XXX vs WHERE field != XXX : Performance the same?

    Hi everyone, is there any performance difference btw the following WHERE criteria. WHERE abcfield = 'XXXX' vs WHERE abcfield <> 'XXXX' A)There are same number of records that for each of the above criteria B) abcfield is indexed. This has been puzzling me. At first i thought that WHERE...
  2. jpo245

    Google Maps API: How to grab the domain of the html that loads script

    Hi everyone, in order to insert a Googlemap into my php script, I have to insert the following <script> </script> from google. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>...
  3. jpo245

    Possible to restrict usage of an RSS FEED?

    Hi, im planning to allow certain users to use some of my rss feeds on their blogs (blogger.com), they'll be inserting it in via feed2js. My question: Is it possible to restrict the users who do this? I don't want just ANYONE to be able to publish my feeds, only those that i allow to. I was...
  4. jpo245

    Form contains AJAX inserted values: How to POST??

    Ok guys, i foudn the error. a very stupid error. Thanks though!
  5. jpo245

    Form contains AJAX inserted values: How to POST??

    Hi everyone, I have 2 Select Boxes (Select A, and Select B) in a form. Depending on what option the user selects in A, Select B is then populated via ajax. Now my problem is that because the options in B are dynamically inserted via AJAX, the form doesnt seem to detect those values, and doesnt...
  6. jpo245

    How does browser know if its XML or not?

    actually, im not using the same webserver.. I'm actually trying to use a php script to output XML for ajax purposes, but for some reason even though my script outputs correctly, the ajax doesnt seem to regognize it...
  7. jpo245

    AJAX: Filling a select box with response text: Problem! Help?

    Thanks bro for the explanation!
  8. jpo245

    How does browser know if its XML or not?

    Kindly take a look at these 2 docs: http://openrico.org/rico/getPersonInfo.do?firstName=Pat&lastName=Barnes http://niftis.rathernifty.com/niftis/getPersonInfo.do?firstName=Pat&lastName=Barnes Why is one viewed as an XML doc, while the other is not? This is puzzling me... And my code can't...
  9. jpo245

    AJAX: Filling a select box with response text: Problem! Help?

    Hi there everyone, just started fiddling around with AJAX. Am using ajaxtoolbox. Two files: testajax.php [contains a selectbox with ID: TESTCOMBO <select id="testcombo" size="10"> <option value='nothinghereyet'>nothing here yet</option> </select> options.php [file that ajax "GETS"] <option...
  10. jpo245

    Bookmarklet: adds top frame to current page (w/o reload)

    Hi tsdragon: javascript:s=document.body.appendChild(document.createElement('script'));s.id='fs';s.language='javascript';void(s.src='http://www.locationofyourjsfile.org/bootstrapjs.js');
  11. jpo245

    Bookmarklet: adds top frame to current page (w/o reload)

    Hey dwarfthrower, i've been trying to tweak the code to do something meaningful, and have a question... I noticed that the below were used to "append" or "insert" the new html code: document.body.firstChild, document.body.insertBefore document.body.appendChild(newDiv) My question is am i...
  12. jpo245

    Spent 8 hours.. works in FF, not in IE.

    Im new to CSS, and designed a page from scratch. http://old.rathernifty.com/nustyle.html In FF, it looks reasonable, with the exception of the little tiled boxes on the lower half of the screen. How does one put a really long word inside with out it spilling out of the box? In IE, it looks...
  13. jpo245

    Bookmarklet: adds top frame to current page (w/o reload)

    Hi dwarfthrower, THANKS ONE BILLION TIMES!! Basically, i've been spending 4 days finding out how to load a top frame dynamically without reloading everything else... I did come close to the "insert div method" but never really thought much of it... Now i have an evenmore elegant solution...
  14. jpo245

    Bookmarklet: adds top frame to current page (w/o reload)

    Hi dwarfthower, basically a bookmarklet is one of those little buttons right below your browser address bar. Usually the bookmarklet just points to "http://somesite.com", if u click on it. However, instead of "http://somesite.com", u can also put in javascript instead. Sites like...
  15. jpo245

    Bookmarklet: adds top frame to current page (w/o reload)

    Hi everyone, been puzzling over this for awhile. Is there anyway i can click a bookmarklet, that dynamically adds a banner style top frame that slides out over the current page I am viewing. I hope to be able to do this, WITHOUT reloading the current page I am viewing. So for example...
  16. jpo245

    DISTINCT + Order By together = slow query

    Hi everyone, after tonygroves introduced me to the power of subqueries, perhaps its time for me to give back a little. int19sd: One thing i realized about our type of queries is that a "WHERE IN (XXXX)" clause is extremely costly when the IN(XXXX) part contains MANY MANY values. A workaround...
  17. jpo245

    Union woes.....

    Hi there, I'm having problems with this slightly more complex union query. 1. Users can be members of groups (via usergroupmap mapping table) 2. Groups can have zero users. 3. Users can be members of zero groups. I'd like a record set that displays the follwing: |groupname|username|...
  18. jpo245

    DISTINCT + Order By together = slow query

    Thanks tony for opening my eyes to the world of subqueries.
  19. jpo245

    DISTINCT + Order By together = slow query

    Hi everyone, I have a table that has about 500000 rows. Ok so there is a ITEM table and a TAG table, and an ITEM-TAG mapping table. Tags and Items have an M:N relationship. My Problem right now: When i do a select item.id, item.name, item.owner, item.datecreated, from the tables, it is...
  20. jpo245

    1 index Per table per query = SLOW QUERY!! Pls help

    Hi tony, i understand that u can specify as many indexes per table as u want. However, when a query is run, from what i understand, MYSQL only allows you to use ONE index per table. So tahts the source of my problems...

Part and Inventory Search

Back
Top