netcraft.com/whats/
rudy
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
What do you think of these conditions?
laughable
it must be really hard to get PR5 for casinos
no sympathy from this quarter
rudy
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
A client of mine was asking me about a script from Google to anazlye
traffic generated from Google ads. Does anyone know anything about
this? Is it a good idea or not?
http://www.google.com/analytics/
rudy
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email
it's a topic (thread) that has been stuck
when you visit a forum you usually see a list of threads in descending
sequence by date of last posting
if a thread gets no additional posts, it will soon sink from sight (as it
were)
a sticky thread remains stuck at the top of the list
this
Does anyone else have lists that they rely on?
a, lassie, do it need to be a list?
i've found a wonderful crew of varmints on http://sitepointforums.com
avast, ye need to see it online, it's not the same as email
;o)
The WDVL Discussion List from WDVL.COM
To Join
Anyone have the URL for the old photo gallery which used to be floating
around?
arrr, matey, what a foine scurvy crew this be...
http://www.laughing-buddha.net/wdvl/
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
Well, my client actually meant that he is looking for companies who do the
directory submissions for you. Any ideas on that?
everything i've heard is that a company which submits your site to search
engines and/or directories knows less about your client's business than your
client, and
this...
WHERE products.styleCategory LIKE '%categories.id%'
... will (a) not work like you think it will, and (b) never scale well,
since it will always require a full table scan
rudy
http://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto
scroll down, please
• The WDVL Discussion List from WDVL.COM •
To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED] or
use the web interface
http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription
Obviously my bosses aren't
too happy that they have to put up with the crap
why are bosses opening mail from the web site?
it should go through an administrative assistant, who will
purge the crap manually
purge in this case means moving the offending mail to a special archive
folder, where
Can I do this in one query?
yes
add location.location_name to the GROUP BY clause
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send
Sadly not?
happily yes, unless you added it wrong
can i see the changed query?
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your
Don't you want to GROUP BY the company name reather than the location
name? By definition, grouping by the location name will only return one
row per location...
the GROUP BY should include both
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
this could only have come up in mysql, by the way
writing this (which is what you had) --
select a, b, c, count(*) ... group by a, b
is invalid in all other databases
you will find that in the result set, there will be one row for each
combination of a,b, but the value for c in the
If I understand right, you're saying that using an aggregating function on
a field you haven't included in the GROUP BY clause is illegal in real
databases, and unpredictable in MySQL (like most things in MySQL ;) )?
no, it isn't using an aggregating function on that is the problem
you ~can~
How, she exclaims, how do I
return to that which was before?
http://www.microsoft.com/windows/ie/support/default.mspx
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
maybe a way
to replace the .js file with something else?
yeah, there is
the NOSCRIPT tag
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
linda, could you action this please --
- Original Message -
From: Louis Willhauck [EMAIL PROTECTED]
If you get this and you are operating a mailing list, you might as well just
take me off of it, 'cause ya just ain'ta gonna get through!
The WDVL Discussion List from
I need to say, optionId = 1 AND (4 or 6 or 6) etc...
that's what the HAVING clause does ;o)
I don't understand whats happening at teh bottom of the query..
can you dumb it down for me?
use the ON clause of the join to select only those rows you're interested
in --
and
I tried to adda region filter, which is in a table jsut liek the
option select..
no, sorry
asset-to-assetPropertyOption is one-to-many
if you add another join to the query with a ~different~ one-to-many
relationship, you will end up with cross join effects (each of three regions
will join
= T.userName ) = 5 )
or ( userName '$myUserName'
and ( select count(*)
from resultsTable
where userName = T.userName
and userName '$myUserName' ) = 5 )
order by userName desc
rudy
http://r937.com/
� The WDVL Discussion List from WDVL.COM
You're a clever clever man..
Yep, it is scary what someone who is really good can do in a very short
time.
To paraphrase, I am awestruck, I bow in admiration.
you guys are too kind
how about sending me some referrals, people looking for paid sql consulting?
;o)
� The WDVL
Any suggestions where to start studying up on SEO
yes, i have a really good one, and would be happy to pass it on to you, once
you understand the meaning of please trim your replies
:o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL
://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add
(string)3/MAY/07 -- (date for MySQL)2007-05-03
select str_to_date('3/MAY/07','%e/%M/%y')
from daTable...
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add
also, please be kind enough to trim your replies
awww, be kind to the guy, he's hung over...
i thought my request was actually very polite
and i'm afraid there ~is~ no excuse for ignoring list etiquette
as for your php, did you see my STR_TO_DATE solution?
why would you want to take time
In Windows\Temp
everything in Windows\Temp can be safely deleted
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send
Just ignore me. :)
you mean just this once, or always?
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To:
btw, the annoying mail from TFS that you get every time you post to
the list should stop now.
but what about this one --
From: Internet.com [EMAIL PROTECTED]
Reply-To: Internet.com [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: re: your email message
Date: Wed, 21 Feb 2007 08:40:04 -0800
This is a different test. You can ignore it too. :)
this is also a different reply (linda knows why)
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
Do you get those messages when you send mail directly to the
list, or only when you reply?
here's a new one, not a reply
we shall see
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
yup, i got it again
- Original Message -
From: Internet.com [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2007 3:25 PM
Subject: re: your email message
The following lines in your email message did not appear to be
Internet.com commands and were skipped:
Anyone care to tell me what I'm doing wrong?
probably forgot to declare a primary or unique key
rudy
http://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com
And THAT... is why they pay Rudy the big bucks..
not on this discussion list they don't
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
So you admit they do elsewhere? grin
not at all, sir
it is entirely plausible that they don't on any discussion list
but my statement is still correct -- not on this list they don't
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL
http://www.tlc-rewards.com/5629JustinBridou/terms.html
Has an ol tag and a few items...
However, it's not showing a n ordered list...
looks fine in IE6
rudy
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web
Fixed now...
oh do please share
Aren't you in Canada...? What you doing up at this hour!!! ;-p
indeed i am
i was clearing out my email while waiting for my daughter to quit primping
so i could drive her to school
;o)
� The WDVL Discussion List from WDVL.COM �
To Join
I've googled OUTER joins, but Im getting errors...?? Hm
funny, google never gave me any errors, and i've been using it since it came
out
what you want, young paduan, is a LEFT OUTER JOIN instead
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email
my bad, i meant padawan, not paduan
see http://en.wikipedia.org/wiki/Padawan#Jedi_ranks
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
It's going through the jobs table and only returning jobTypes that
have been flagged in jobs..
not ALL job types...
i tested the LEFT OUTER JOIN on the data you supplied and it works
~fabulously~
maybe you have some other conditions that are clouding the issue
� The WDVL Discussion
Ah, i'm on 4.1.11
that make a difference?
none whatsoever
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To:
Here I go again...
it really doesn't work... ? :-(
yes it does, but you have to be really careful with WHERE conditions in
outer joins
SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours,
jobs.day
FROM jobType
LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id
WHERE jobs.id
All my bookmarks and custom modules are gone... :-(
what happen
someone set up us the bomb
we get signal
what!
main screen turn on
it's you !!
how are you gentlemen !!
ALL YOUR BOOKMARKS AND CUSTOM MODULES ARE BELONG TO US
you are on the way to destruction
what you say !!
you have no
I've got a list of codes that I wanna import into a database (65k of them)
can I import that list withough adding 'INSERT INTO `code`' etc...
yes, you can
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web
linda...
i'm still getting these spurious messages when posting -- what gives?
- Original Message -
From: Internet.com [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 7:01 AM
Subject: re: your email message
The following lines in your email message did not
Heck - my twins are now 41 and our baby is 32 - what does that make
me? (Polite answers only thank you! LOL)
about my age, mebbe a couple years older
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
Where is m2b?
toronto
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription
1) Where are the recordings stored?
documents and settings \ all users \ shared documents \ recorded tv
2) Can I copy them over to a cd to take to
another computer to watch that is *not* a media
pc? I'm thinking the recordings might work in the Media Player?
no
my computer came with a
join servicedata as nay
on nay.domain = yay.domain
and nay.prefname = 'bar'
where yay.prefname = 'foo'
and yay.prefvalue = 1
and nay.domain is null
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto
I tried to design my homepage... this is as far as I got...
http://www.net-tastic.com
what are you talking about? that design is fine!
i would change the sequence of nav links, though, from
portfolio contact about code home
to
home code portfolio about contact
rudy
� The
CONCAT(field1, - , field2) as field1
there are several ways to deal with NULLs here
check each field individually --
CONCAT( COALESCE(field1,'') , ' - ' , COALESCE(field2,'') )
however, if field1 is NULL, then the result starts with the dash, so...
CONCAT(
COALESCE(CONCAT(field1,'
try crystaltech.com (where i host my sites)
200GB/month for US$17
unparalleled world-class support included
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e
Am I being a tool...?
possibly ;o)
GROUP BY offer_id ORDER BY date DESC doesn't work...
have you by any chance oversimplified the problem?
when there are only two columns the answer is easy --
select offer_id, max(date) from daTable group by offer_id
rudy
� The WDVL
tris, i would opt for the simple approach
SELECT calctype
, SUM(points)
FROM statement
GROUP
BY calctype
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
I just like to have the tv availability.
i have xp media center and i totally agree
once you have a system like this, you will never again want a system where
you cannot (a) record and watch later, (b) fast forward through commercials
~in 30-sec jumps~, (c) instant replay, (d) mute with
This may sound strange but if my computer is off,
it doesn't record. So apparently, it doesn't work
like a regular DVD recorder for a tv set, right?
are you saying a DVD recorder will record when it is off?
whoa!
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk,
to answer any more of your questions
;o)
So I'll use Jure's suggestion for now...
great
where will you be getting the rank from?
good luck
rudy
http://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web
http://www.net-tastic.com/brand/xml.php
Firstly (~Rudy ;-p ) is there a way to get all this data in an array,
from a single MySQL query?
there might be, if you could explain how the tables are related
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email
Anything that does SQL should be able to handle the LIMIT clause - even
MS SQL Server. Just stick it on the end of your query and job done :)
in a word, no
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web
I also tried using Top, and that doesn't produce the right results
(select top 5 * from table...)
this is, indeed, what you use for SQL Server
do you have an ORDER BY clause?
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email
Yeah, I do have an ORDER BY. Maybe I don't have it in the right place?
if it isn't at the end, you'd get a syntax error
could you perhaps show us the entire query? or did i miss it already?
rudy
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
Here is the original - SELECT * FROM events ORDER BY StartDate
Without anything, I will get 10 events listed on the page. If I try
SELECT TOP 5 * FROM events ORDER BY StartDate,
then I only get the first 2 events.
quite frankly, i just do not believe that
try running it in Query Analyzer or
Ugh - After I started looking at this I realized that it's an Access DB -
not SQL Server (which I'm used to working with). I'm guessing that might
be
the difference?
in general, you cannot use the same SQL in different database systems
in particular, you can almost never use the same SQL in
in the ID
is a single quote
WHERE id = '!''^'
see that? the enclosed single quote needs to be represented by two single
quotes in succession
by the way, this is the Standard SQL approach -- two consecutive single
quotes inside a string represents one single quote character
rudy
http://r937.com
http://r937.com/
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings
free to CC: r...@r937.com when
you post to the discussion list (assuming the list software allows it)
I'd try some LEFT, RIGHT, and INNER Joins and see if you get the results
you were hoping for.
cheryl, please, that's like handing a child a lighter who is playing with
matches and can't get
Basically the query is sound ...
sorry, no, not quite
here's what i saw...
WHERE icons.iconId = resourceTypes.resourceTypeIconId
AND resources.resourceTypeId = resourceTypes.resourceTypeId
AND categories.categoryId = resource2category.categoryId
AND resources.resourceId =
thanks sheila
yeah, i'm pretty pleased that it's finally been announced on sitepoint
(amazon had it listed since december, go figure)
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web
/me reckons we should all get a free copy 'coz we know Rudy and we're
just a generally nice bunch of people :oP
Whaddya say Rudy? :o)
free copies? sorry, no can do
but if you send me US$30 i will send you a signed copy
paypal preferred: http://r937.com/payments.cfm
cheque accepted
On 03/03/2009 05:45 PM, Matthew Macdonald-Wallace wrote:
Quoting Cheryl D Wise cdw...@wiserways.com:
xWDVL list
linux is the best hosting platform ever and then some...
Rudy's guide to SQL
whaaa
i must've missed some emails here (mail from wdvltalk sometimes ends up in
my spam
Is this also a chance to update the rouges gallery (is that still
hosted these days?) :oP
http://www.laughing-buddha.net/wdvl/
;o)
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change
and if anyone has an SQL question, please feel free to contact me directly
rudy
http://r937.com/
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web interface http://e-newsletters.internet.com
74 matches
Mail list logo