Questions tagged as 'sql'

Tagged questions
2
answers

links between tables

$sql = "SELECT * FROM Inscricao WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM Aluno WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM EncarregadoDeEducacao WHERE ee_id = ee_id.inscricao where al_id = ".$_GET['idc']; tables: CREATE TA...
asked by 14.04.2015 / 12:32
1
answer

SQL in Genexus and GxFlow

Is it possible to return the result of a SQL query in a Genexus transaction? I need to create a WorkFlow through Genexus, where using DBRET, I was able to read data from an external DB and now I need to return some information in GxFlow. I...
asked by 30.01.2015 / 12:00
0
answers

Db2 query with between and partition by

I need a help with this query below, it is not doing what I like. She makes everything perfect. But when I use the between it returns an error. I would like an help on the query. SELECT UNIDADE, MATRICULA, NOME, CURSO, ESCOLA, DTATU, HRATU, ST...
asked by 20.01.2015 / 00:09
1
answer

I can not create table in SQL SERVER

I have a SQL SERVER instance installed locally where I am an administrator, I can create databases but I can not create tables. Home Here is a photo of the error that SQL displays. More Some Details: ===================================...
asked by 29.12.2014 / 18:33
2
answers

Query assembly query with INNER JOIN

Hello ... I have the following query: $conexao = connect(); $consulta3 = mysql_query("SELECT meu.id, f.idfollowed, eu_sigo.fname, eu_sigo.id, eu_sigo.profile, eu_sigo.photoperf, p.id, p.title, p.link, p.description, p.descr, p.url, p.photo...
asked by 29.12.2014 / 19:46
4
answers

Help with PHP and MSSql special characters

I'm making a form, and when I write the information with special characters, it records good ... only that when I retrieve the information it comes encoded ... I've already used it, utf8_encode / decode and nothing I do not know if it's in php o...
asked by 04.02.2015 / 21:27
1
answer

Relate products from different stores automatically

I have a question in comparing product prices from different stores, I have no idea which component to use or how to do this. The idea is to do something like Buscapé and Zoom (relate the same product to different stores), and then use this rela...
asked by 07.12.2014 / 01:23
1
answer

Error using sql command Insert (SQL Server), via classic ASP

Good evening, I'm having a problem executing a sql command through an ASP application. The command is this: strSql = " INSERT INTO movimento_tef_nsu ( "&_ " identificador "&_...
asked by 25.07.2014 / 14:07
1
answer

MS Access - how to get date range of 30 days [closed]

I need to collect registered orders from a table named OrdersOn the last 30 days.     
asked by 24.07.2014 / 15:30
2
answers

How to read and open files from a byte column in SQL Server?

My question is the continuation of this question: Link to another question I was able to transform my file into bytes and insert it inside a table in SQL Server, however now I want from within an application that I'm doing in C # I want to...
asked by 09.12.2014 / 14:03