Questions tagged as 'sql'

Tagged questions
0
answers

ACCESS grouping by sql

Hi, I have a query with the following sql: SELECT Tabla1.Campo1, [CTrefercruz].Expr2, [CTrefercruz].[Total de Campo8], [CTrefercruz2].[Total de Campo8], [CTrefercruz3].[Total de Campo8] FROM ([CTrefercruz3] RIGHT JOIN [CTrefercruz2] ON [CTrefe...
asked by 13.06.2018 / 11:14
0
answers

Can you help me, do not execute mysql sentence in php function

Friends I have a php function, donte I have a mysql statement for data insertion, but it does not run Maybe they could help me find the error function RegistrarServicioEP($nombreser,$descripcionser,$fotoser) { //echo $fotoser; $mensa...
asked by 12.06.2018 / 19:11
0
answers

Stored Procedure executed within another with two outputs to be assigned to a variable

Dear, I am running an SP in Sybase that executes another SP according to certain conditions, this SP will have two output values but only one of them will be output in each execution, my problem is that one of the two values will be print withou...
asked by 15.06.2018 / 15:30
0
answers

Because the database engine does not allow me to add try / catch to my porceement

I need to add try/catch to the procedure and I get some errors, this is my stored procedure CREATE PROCEDURE perfilCur @opcion INT AS SET NOCOUNT ON; BEGIN TRY IF @opcion = 1 BEGIN SELECT TOP 1 (PERFIL) + 1 AS NuevoPerf...
asked by 13.06.2018 / 19:35
0
answers

How do I do this query in tables with msql

Hi, I have this code to make queries to some related tables, what I want to do is weigh the parameters but I can not find the way, the parameters that I want to pass are those of the municipality, for when searching for example, municipality lan...
asked by 10.06.2018 / 03:11
0
answers

Is there a problem in having +2000 events in mysql?

I need to create rows in the tables every so often, the way that occurred to me was to finalize Mysql EVENTS, but there must be more than 2000 events running, the execution intervals are at least 1 day and the largest operation What they do is i...
asked by 07.06.2018 / 18:15
0
answers

Catchable fatal error: Object of class User could not be converted to string in

I have that error and I can not find the problem. The error is generated when you try to generate a PDF. It gives me problems in this line- >    Catchable fatal error: Object of class User could not be converted   to string in   /Applic...
asked by 08.06.2018 / 19:23
0
answers

I / O error: The Network Adapter could not establish the connection

I have already restarted services I have seen that they are correctly in the listener.ora but it still marks me as if it does not detect it. This keeps coming to me    An error occurred while performing the requested operation:   ...
asked by 11.06.2018 / 18:50
2
answers

Fatal error: Call to a member function fetch_assoc () on boolean

I'm trying to make a php page with a login by copying a fragment that a partner passed me but at the time of executing it I skip that error:    Fatal error: Call to a member function fetch_assoc () on boolean. I do not know how to solve i...
asked by 10.06.2017 / 19:35
0
answers

Auto-generated field in Oracle

I have problems to create a column that auto-generates its code, I think it could be done with a trigger but I would like not to have to do it like that and use identity but it always generates this error and does not I know how to solve it....
asked by 07.06.2018 / 05:17