|
Get someone at the office to create a "standard" Word document, and send it to you.
Then compare it with yours - you'll probably find they use a different paper size, or margin, or dpi - and if you can duplicate your document "over the top" of the standard doc, your problem will likely go away. So next time you go for Brownie Points you don't get so much "repeat business"... 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
To be far there were actual changes to the text and graphics over the last week. AND I've just been informed that the current version is good to go...
... until the numbers change again.
veni bibi saltavi
|
|
|
|
|
Look at the bright side, after all, that's a new job.
|
|
|
|
|
I have seen this happen before. It is really bad going from Word to Open Office. Tried to do a newsletter that had been in Word when I got it and I had OO. What a mess. Finally I dug out an old copy of Word and got it imported. So I used that.
Mongo: Mongo only pawn... in game of life.
|
|
|
|
|
Nagy Vilmos wrote: If anyone at Mrs wife's office tries to open the document it reformats itself in a less than flattering way
So she says- To me, she's just found a good way to get someone do the updates for her. 
|
|
|
|
|
No good deed goes unpunished, especially when it's for your spouse/significant other.
Software Zen: delete this;
|
|
|
|
|
So I've been doing Oracle development, coming from SQL Server.
Simple string concatenation, which is + everywhere, is || in Oracle.
A little research and || seems to be the ANSI standard, which makes sense as 2 || 'A' is now unambiguous '2A' (and not a conversion error).
But now I want to write a simple SELECT statement which would work in both Oracle and SQL Server.
Oracle doesn't support + and SQL Server doesn't support ||, however both support CONCAT.
Seems too easy for something that's uneasy already, and indeed it is...
SELECT CONCAT('A', 'B') FROM TABLE works in Oracle and SQL Server.
SELECT CONCAT('A', 'B', 'C') FROM TABLE works only in SQL Server...
Seems like the only thing that works in both databases is CONCAT('A', CONCAT('B', 'C')).
And that seems like the only reasonable solution is to write two different queries, one for Oracle and one for SQL Server because it's just too friggin difficult to implement a standard FRIGGIN STRING CONCATENATION!!! 
When does the hurting stop? 
|
|
|
|
|
|
Sander Rossel wrote: When does the hurting stop?
When you stop using both dbms at the same time?
Or when you stop using them totally? 
I never finish anyth
|
|
|
|
|
phil.o wrote: When you stop using both dbms at the same time?
Well, that may be a solution(if he wants stop getting hurt )
phil.o wrote: Or when you stop using them totally?
Don't tell me that you want him to us MS access 
|
|
|
|
|
Brittle1618 wrote: Don't tell me that you want him to us MS access
No, I'm not so cruel
A simple Excel sheet will do it 
I never finish anyth
|
|
|
|
|
|
I don't think so. At that time, extensive usage of both systems during your carreer will have caused severe brain damages, displacing the moral pain to a physical, unsustainable pain.
Better stick to Excel as early as possible 
I never finish anyth
|
|
|
|
|
phil.o wrote: severe brain damages
Causing you to miss the Reply button and hit Email instead?
phil.o wrote: Better stick to Excel as early as possible
Better, I started in VB!
|
|
|
|
|
Sander Rossel wrote: Causing you to miss the Reply button and hit Email instead?
I wondered why I had to reply twice ^^ Now I know.
Sander Rossel wrote: Better, I started in VB!
Beware! VB is extremely dangerous. VB destroys ozone layer. VB causes cancer and other funny diseases.
I never finish anyth
|
|
|
|
|
BTW allready your subject does not work, it has to be "SQL <> SQL"
modified 19-Jan-21 21:04pm.
|
|
|
|
|
|
Works in SQL Server
PooperPig - Coming Soon
|
|
|
|
|
Sander Rossel wrote: When does the hurting stop
When you stop doing presentation logics in the database.
I also agree with Phil, why do you need to support more than one database?
|
|
|
|
|
Why? Layers are soooo last decade.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Our company uses Oracle and SQL Server, both from C#.
SQL Server support isn't really a requirement (now), but I was pretty sure it would work as it's SQL in it's simplest form (although apparently there is no 'simple' form of SQL)...
Anyway, screw SQL Server support.
|
|
|
|
|
It'll get even funnier when you realize that even when the SQL is completely compatible, the results may not be.
For example: Oracle doesn't have an empty string.
|
|
|
|
|
Jörgen Andersson wrote: For example: Oracle doesn't have an empty string.
Or a bit/bool data type...
Jörgen Andersson wrote: It'll get even funnier
I'm not laughing
|
|
|
|
|
Jörgen Andersson wrote: Oracle doesn't have
A GUID type.
In some databases a one-byte integer is signed; in others it's unsigned.
|
|
|
|
|
PIEBALDconsult wrote: A GUID type
Syntactic sugar. Use myguid RAW(16) default SYS_GUID()
Or rather, don't use them at all.
The only serious place where GUIDs have the edge over sequences is on distributed systems.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
