Database

Jörgen Andersson29-Jun-14 23:38

29-Jun-14 23:38

Here's[^] Joels explanation.

Wrong is evil and must be defeated. - Jeff Ello[^]

PIEBALDconsult30-Jun-14 4:39

30-Jun-14 4:39

Yeah, as I drifted off to sleep last night I recalled that Joel had written about Excel having to support a Lotus 123 issue. Thumbs Up | :thumbsup:

You'll never get very far if all you do is follow instructions.

Jörgen Andersson30-Jun-14 4:53

30-Jun-14 4:53

I love that story.
They brought a f*** counter to all meetings with BillG. Laugh | :laugh:

Wrong is evil and must be defeated. - Jeff Ello[^]

Jörgen Andersson29-Jun-14 23:39

29-Jun-14 23:39

See my answer to Bernhard

Wrong is evil and must be defeated. - Jeff Ello[^]

Miller Nguyen29-Jun-14 23:52

Miller Nguyen

29-Jun-14 23:52

Thanks a lot

Jörgen Andersson30-Jun-14 0:03

30-Jun-14 0:03

Oh, btw, have a look if this[^] and this[^] would be of any use for you.

Wrong is evil and must be defeated. - Jeff Ello[^]

Bernhard Hiller30-Jun-14 1:38

Bernhard Hiller

30-Jun-14 1:38

For example, -0.5 and 0.5 both mean noon on 30 December 1899

No, no, no! I do not want to use that function!

Jörgen Andersson30-Jun-14 2:15

30-Jun-14 2:15

It's not a bug, it's a feature.

Wrong is evil and must be defeated. - Jeff Ello[^]

Question about File Server / MySQL Database

GuyThiebaut30-Jun-14 1:52

GuyThiebaut

30-Jun-14 1:52

I get around this, and other issues such as collation issues between SQL Server and Excel, by always passing dates to Excel as text in a format of dd-MMM-yyyy e.g. '01-Jan-2014'.
It's not pretty but it has worked so far...

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

modified 30-Jun-14 8:06am.

MySQL Stored Procs -

ericgahn29-Jun-14 10:08

ericgahn

29-Jun-14 10:08

Hi all;

I am learning to write stored procs on MySQL and am going crazy.

SQL

DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select 
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from 
    DataLoad;
    
END $$

DELIMITER ;

I get an error:

Error starting at line : 17 in command -
END $$
Error at Command Line : 17 Column : 1
Error report -
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END $$' at line 1

I am using Oracle SQL Developer and the INSERT statement works ok when executed on its own. I can do these things blindfolded with my arms tied on MSSQL. Any help appreciated.

EG.

Re: MySQL Stored Procs -

Wayne Gaylard29-Jun-14 23:37

Wayne Gaylard

29-Jun-14 23:37

You don't need the delimiter expression $$ after your END statement.

SQL

DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from
    DataLoad;

END

Everyone dies - but not everyone lives

Re: MySQL Stored Procs -

ericgahn1-Jul-14 20:03

ericgahn

1-Jul-14 20:03

Thanks Wayne.

Re: MySQL Stored Procs -

Wayne Gaylard1-Jul-14 20:28

Wayne Gaylard

1-Jul-14 20:28

Glad to help.

Everyone dies - but not everyone lives

Jassim Rahma29-Jun-14 3:30

Jassim Rahma

29-Jun-14 3:30

Hi,

I have .NET WinForm application with MySQL backend.

It's an HR application.

I want to store employee documents such as ID card, passport, letters (e.g. salary certificates, warning letters, etc).

I don't want to store the scanned documents in the database itself therefore I am planning to store it on my file server and just save a link in MySQL.

My question, if I save a link, how can I make sure no one will know that link's folder then open it and see everything else?

Technology News @ www.JassimRahma.com

Re: Question about File Server / MySQL Database

Peter Leow29-Jun-14 4:19

Peter Leow

29-Jun-14 4:19

Just store the filenames without the path to the file server in the database table. Store the path to the file server separately say in another database table and concatenate it with the filename by code whenever user wants to access a file.

Re: Question about File Server / MySQL Database

Bernhard Hiller29-Jun-14 22:12

Bernhard Hiller

29-Jun-14 22:12

Instead of using a plain database back-end, create a server which communicates with the clients and the database. So any client will contact the server which in turn talks to the database and file system, and serves the data/documents back to the clients.

database

sheikh muneeb28-Jun-14 8:18

sheikh muneeb

28-Jun-14 8:18

what is difference and similarities between mysql and ms sql server.

PIEBALDconsult28-Jun-14 8:33

28-Jun-14 8:33

They are exactly the same except SQL Server is better in every way.

You'll never get very far if all you do is follow instructions.

sheikh muneeb28-Jun-14 8:49

sheikh muneeb

28-Jun-14 8:49

can we use them by replacing each other with other tools for example can i use mysql with asp.net and php with ms sql server

PIEBALDconsult28-Jun-14 8:52

28-Jun-14 8:52

Mix and match to your heart's content.

Best use a layered approach of course. The front-end shouldn't care what the back-end is.

You'll never get very far if all you do is follow instructions.

sheikh muneeb28-Jun-14 8:56

sheikh muneeb

28-Jun-14 8:56

plz explain something called in simple words thank you

PIEBALDconsult28-Jun-14 8:58

28-Jun-14 8:58

You put the lime in the coconut.

You'll never get very far if all you do is follow instructions.

Shameel2-Jul-14 2:08

Shameel

2-Jul-14 2:08

prove