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...
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>...
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...
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...
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...
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...
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...
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');
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...
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...
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...
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...
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...
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...
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|...
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...
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...
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.