Viewing 15 posts - 691 through 705 (of 2,044 total)
Funny! :w00t:
Anyway the Belgium Red Devils got past the USA soccer team after a thrilling match.
July 1, 2014 at 5:46 pm
Can you elaborate further?
if you had the 3 tables grade,owner,ownergrades
it would be something like
select owner
from owners
where (
exists (select * from ownergrades inner join grades on ownergrades.grade=grades.grade and ownergrades.owner=owners.owner and...
June 26, 2014 at 1:35 am
What is exactly the problem? The acquire connection or the unicode conversion?
Have you tested the oracle connection from the server using "sqlplus" for both the clients?
June 21, 2014 at 6:49 am
Just to improve my english, what is the meaning of "Rodders..."?
Members of a hotrod club
or maintenance (access?)
or the thing you use to unclog pipes (duct rodders)
June 19, 2014 at 1:28 pm
Can you give an example of "only display the numbers after the decimal related to random"?
June 19, 2014 at 4:42 am
June 18, 2014 at 4:11 am
Hello,
The code looks like php
You'll have to construct a query with the where exist clause Koen mentioned.
Did some googlefu and ended up with:
June 17, 2014 at 2:35 am
Select *
Define all varchar's as varchar(max) to be on the safe side.
Passing strings as date-parameters: where mydate='01/06/2005' -> the first of june or the sixth of january ?
June 15, 2014 at 12:45 pm
sqlserver works best with the oracle oledb driver (OraOLEDB)
June 15, 2014 at 12:39 pm
For newbieuser: convert '18/01/2009' to a proper datetype instead of relying on the occasional dateformat of the server. By using convert?
For penny: have you checked the distiributed transaction coordinator...
June 15, 2014 at 12:37 pm
As Koen mentioned, did you install the 64-bit variant of the oracle client?
Did you reboot?
June 15, 2014 at 12:26 pm
Oracle home environment variable properly set?
June 15, 2014 at 12:24 pm
Didn't know about the bug, glad you mentioned it.
June 15, 2014 at 12:21 pm
Case sensitivity? (collaction/Oracle case sensitivity)
Mix of datatypes? trim(x)=:comp -> characters? :comp=0 -> number?
Why is the trim added in the last line?
You have supplier_country = receiver_country and :ccty = 0 (without...
June 15, 2014 at 12:13 pm
Viewing 15 posts - 691 through 705 (of 2,044 total)