If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Search Forums > Search Results

Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: it-iss.com
Forum: MySQL 11-11-13, 07:46
Replies: 4
Views: 1,230
Posted By it-iss.com
Inside your stored procedure you have declared...

Inside your stored procedure you have declared the INOUT variable again. Remove that declaration of the variable.
Forum: MySQL 10-16-13, 11:27
Replies: 2
Views: 311
Posted By it-iss.com
In MySQL you need to use the function CONCAT to...

In MySQL you need to use the function CONCAT to join two strings together. Also look at the LEFT function which should be used in conjunction with the UCASE function. Here is an example:


mysql>...
Forum: MySQL 10-09-13, 08:26
Replies: 1
Views: 617
Posted By it-iss.com
Hi Jake, I would do it where the IOS...

Hi Jake,

I would do it where the IOS application talks via publicly to your system via URL's. The server side solution connects to the database and returns JSON coded data to be processed by your...
Forum: MySQL 10-07-13, 09:39
Replies: 1
Views: 723
Posted By it-iss.com
One way to see if the port is enabled is to use...

One way to see if the port is enabled is to use "telnet <hostname> 3306". This will attempt a connection. If you appear to get some data transferred back and the telnet session appears to hang then...
Forum: MySQL 07-31-13, 00:33
Replies: 2
Views: 310
Posted By it-iss.com
The error is indicating that you cannot reference...

The error is indicating that you cannot reference in the same query the average and using this result in the delete. I would break this down into 2 queries:

By the way your query does not make...
Forum: MySQL 07-28-13, 02:48
Replies: 2
Views: 318
Posted By it-iss.com
So what is your question?

So what is your question?
Forum: MySQL 07-28-13, 02:47
Replies: 2
Views: 327
Posted By it-iss.com
I would add error checking into your code....

I would add error checking into your code. Anywhere when you issue a mysql_ function call I would include or die(mysql_error());


$query = "SELECT * FROM employees WHERE 1";

// Handle keeps...
Forum: MySQL 07-25-13, 14:25
Replies: 2
Views: 357
Posted By it-iss.com
I would create a stored procedure in the...

I would create a stored procedure in the database. This will allow you to loop inserting the contents into the database. You can pass in a start and end date into the procedure and it will perform a...
Forum: MySQL 07-25-13, 14:21
Replies: 1
Views: 237
Posted By it-iss.com
Firstly if you are going to return a value then...

Firstly if you are going to return a value then you should use a stored function and not a procedure.

Second thing is that you should look in the database INFORMATION_SCHEMA which includes a table...
Forum: MySQL 07-25-13, 14:15
Replies: 1
Views: 206
Posted By it-iss.com
There are 2 things you need to be careful about: ...

There are 2 things you need to be careful about:

1. Remove spaces between the quotes
2. Add quotes around the strings that might contain commas:

For example:

Fluffy ,1995-05-15,litter,"4...
Forum: MySQL 07-24-13, 14:29
Replies: 2
Views: 283
Posted By it-iss.com
I have previously written a tutorial explaining...

I have previously written a tutorial explaining this. Try here MySQL – Update rows reversing column values IT Integrated Business Solutions...
Forum: MySQL 07-24-13, 14:27
Replies: 1
Views: 254
Posted By it-iss.com
I am not really sure about what you are asking...

I am not really sure about what you are asking here. Can you give an example based on your data. The image gives 6 records but yet you talk about rows with 4,5,6,7,8 and 9 records.
Forum: MySQL 07-24-13, 14:23
Replies: 1
Views: 464
Posted By it-iss.com
If you look at the documentation you will see...

If you look at the documentation you will see that stored procedure parameters have a slightly different format. The mode IN, OUT or INOUT must be specified first. So in your case:

create...
Forum: MySQL 07-24-13, 14:21
Replies: 1
Views: 342
Posted By it-iss.com
Firstly if you look at the code you have...

Firstly if you look at the code you have specified above:

MAX(IF(ps.name = 'logistics_sorting', ch.state, 0)) AS logistics_sorting,

Why bother having a MAX there is only a single value returned...
Forum: MySQL 07-24-13, 14:13
Replies: 2
Views: 299
Posted By it-iss.com
Not sure I understand how Pat came to the...

Not sure I understand how Pat came to the conclusion that the server is down? Looking at your query it syntactically looks correct. However, I do agree with Pat that you should pass on the error and...
Forum: MySQL 07-16-13, 17:24
Replies: 6
Views: 353
Posted By it-iss.com
An index will use the contents of the column as a...

An index will use the contents of the column as a reference which links back to the actual row of data. However, I suspect that this is an index you actually don't ever use and you could also have...
Forum: MySQL 07-16-13, 16:56
Replies: 6
Views: 353
Posted By it-iss.com
Have you tried KEY `message`...

Have you tried


KEY `message` (`message`(20))
Forum: MySQL 07-16-13, 15:08
Replies: 1
Views: 304
Posted By it-iss.com
Firstly you need a group by here: SELECT...

Firstly you need a group by here:

SELECT ClientID, sum(ABC), count(*)
FROM Table A
Where <condition>
Group by clientID

UNION

SELECT ClientID, sum(ABC), count(*)
Forum: MySQL 07-16-13, 15:03
Replies: 1
Views: 286
Posted By it-iss.com
Look at SELECT GROUP BY. In your case you would...

Look at SELECT GROUP BY. In your case you would need to issue the following statement:

SELECT pacient, MIN(charge) AS charge
FROM pacient_export
WHERE (idpacient_nit IN (SELECT idpacient FROM...
Forum: MySQL 07-16-13, 14:59
Replies: 6
Views: 353
Posted By it-iss.com
The issue here is you are creating an index on a...

The issue here is you are creating an index on a TEXT field. A TEXT type can contain up to 64k of characters. This is too large for an index. What you can do is create an index on a subset i.e. the...
Forum: MySQL 07-12-13, 00:54
Replies: 1
Views: 303
Posted By it-iss.com
Have you checked that the my.cnf has not disabled...

Have you checked that the my.cnf has not disabled InnoDB? There is a parameter --innodb=YES which if innodb has been compiled into the binaries will enable it. Check the documentation MySQL :: MySQL...
Forum: MySQL 07-12-13, 00:49
Replies: 3
Views: 378
Posted By it-iss.com
How long is your stored procedure running for?...

How long is your stored procedure running for? Could it be that there is some kind of timeout issue which is killing the process?
Forum: MySQL 07-06-13, 10:54
Replies: 2
Views: 405
Posted By it-iss.com
I understand that these have to be separate but...

I understand that these have to be separate but you can always add in a groupid field to each table which determines the groups of persons that can access the contents. So for example:

group:...
Forum: MySQL 07-06-13, 10:48
Replies: 5
Views: 466
Posted By it-iss.com
If you use GRANT you do not need to flush...

If you use GRANT you do not need to flush privileges. This is only needed when you INSERT/UPDATE or DELETE from the User table.

The way things work in MySQL is that upon connection it uses the...
Forum: MySQL 07-01-13, 15:08
Replies: 1
Views: 327
Posted By it-iss.com
When adding in the referential integrity...

When adding in the referential integrity constraint be sure to add in on delete/update cascade.


ALTER TABLE `Table` ADD CONSTRAINT `Table_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `Table` (`id`)...
Showing results 1 to 25 of 500

 
Forum Jump