 |
|
|
09-22-2004, 06:49 AM
|
|
#16
|
 |
|
Catapulted
Join Date: May 2004
Location: threadid=49138
Posts: 1,131
|
Quote:
Originally posted by Horus_Kol
I can't - corporate secrets....
|
Nothing annoys me more when someone does stuff like that
Like "So, what did you do over the holiday?" "ohh...I'm not really sure if I can say...it's a bit private"
...I'm sorry I'm in an very bad mood - I'm in such a foul mood I'm not even going to explain it
BTW - This thread is a gaint spamming opportunity like
"The last thing I had in my clipboard is " MY SITE ROCKS!" Obviously ppl are a little more subtle
Last edited by Erikina : 09-22-2004 at 07:57 AM.
|
|
Add to del.icio.us
Can you digg it?
|
|
|
09-22-2004, 07:10 AM
|
|
#17
|
 |
|
Mod of the Underlay
Join Date: Jun 2002
Location: At a desk, hooked up and ready to rock
Posts: 17,242
|
it's only a spamming opportunity when people actually spam... don't do it again, please...
Quote:
From the clipboard of HK
contact the Web server's administrator if the problem persists
|
__________________
Personal Blog (and photos): HorusKol
Articles on Programming and Development (PHP/HTML/CSS, C/C++, more): RandomTweak
The great secret that no SEO agent wants you to hear: if you build your website using w3c accessibility guidelines and your content is written for people, you will do better for longer in search engines than any other method...
|
|
Add to del.icio.us
Can you digg it?
|
|
|
09-22-2004, 11:24 AM
|
|
#22
|
 |
|
Mod of the Underlay
Join Date: Jun 2002
Location: At a desk, hooked up and ready to rock
Posts: 17,242
|
//----------------------------------------------------------------------------
i use it to break up PHP code
__________________
Personal Blog (and photos): HorusKol
Articles on Programming and Development (PHP/HTML/CSS, C/C++, more): RandomTweak
The great secret that no SEO agent wants you to hear: if you build your website using w3c accessibility guidelines and your content is written for people, you will do better for longer in search engines than any other method...
|
|
Add to del.icio.us
Can you digg it?
|
|
|
09-22-2004, 12:26 PM
|
|
#25
|
 |
|
Paladin (Level 15)
Join Date: Feb 2004
Location: Finland
Posts: 336
|
let's see....
Quote:
|
The person/persons who host and or created ourhubs arenot responsible, for the actions of visitors to our hubs. If you enter our private servers and ,you are not agreeing to these terms you are violating, code 431.322.1 of the Internet Privacy Act signed by Bill Clinton in 1995 and, that means that you can NOT threaten any person(s) storing these files, cannot prosecute and person(s) affiliated ... This message was cut due to length
|
hmmm...
|
|
Add to del.icio.us
Can you digg it?
|
|
|
09-22-2004, 04:57 PM
|
|
#26
|
 |
|
Catapulted
Join Date: Sep 2004
Location: Where ever I go, there I am.
Posts: 1,112
|
ĻŽąšŊąēĐŽ·_Ī Ķ
_Ŧ
Ū ĄĢąŠĒŠĪĄĨīšĨĐĢŪ Ĩū―°Īĩ ĒŪšĢĄžđĢēŦļĐīđž§ đĶŽļĢļĄĒŪ·ĪĪšģĻĻĒĒąģ
|
|
Add to del.icio.us
Can you digg it?
|
|
|
09-23-2004, 02:47 PM
|
|
#28
|
 |
|
Ultralord (Level 42)
Join Date: Jan 2004
Location: Temple of the Dog
Posts: 1,612
|
Code:
SELECT
SubStr(PHYSICIAN.PHYS_LNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_LNAME, 30), ' ', 1)-1))
|| ', ' ||
SubStr(PHYSICIAN.PHYS_FNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_FNAME, 30), ' ', 1)-1)) AS NAME,
DOCTOR_NO,
EMPLID
FROM
PHYSICIAN
WHERE
PHYS_LNAME IS NOT NULL
AND
PHYS_FNAME IS NOT NULL
AND
EMPLID IS NULL
AND
SubStr(PHYSICIAN.PHYS_LNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_LNAME, 30), ' ', 1)-1))
|| ', ' ||
SubStr(PHYSICIAN.PHYS_FNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_FNAME, 30), ' ', 1)-1))
IN
(SELECT
SubStr(PHYSICIAN.PHYS_LNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_LNAME, 30), ' ', 1)-1))
|| ', ' ||
SubStr(PHYSICIAN.PHYS_FNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_FNAME, 30), ' ', 1)-1))
FROM
PHYSICIAN
GROUP BY
SubStr(PHYSICIAN.PHYS_LNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_LNAME, 30), ' ', 1)-1))
|| ', ' ||
SubStr(PHYSICIAN.PHYS_FNAME,1 ,(Instr(RPad(PHYSICIAN.PHYS_FNAME, 30), ' ', 1)-1))
HAVING
Count(*)>1)
ORDER BY
PHYS_LNAME,
PHYS_FNAME
|
|
Add to del.icio.us
Can you digg it?
|
|
|
KEEP TABS |
|
SPONSORS |
| |
|
| |
|
|
| |
|