Recusive lookup needed. DB vs C# GUI

I currently have a program in which I want to list 'support tickets' in a grid. The tickets are coming from a SQL DB out of a ticketing system. A ticket has an activity, example: I have a fully functional design but have a problem to list the ...
more »

2017-11-09 22:11 (2) Answers

SQL Server: Round Date Up

I want to round a datetime value up to the nearest full day. UPDATE [DB].[dbo].[TABLE] -- I'm unsure how to take the DepartureDate and round it up SET DepartureDate = DepartureDate + ?? WHERE DATEPART(HOUR, DepartureDate) = 23 The DepartureDate is...
more »

2017-11-09 17:11 (3) Answers

How to interpret the RDB$FORMATS query result

To get the history of a table schema changes I ran the query: select CAST(SUBSTRING(f.rdb$descriptor FROM 1 FOR 32000) AS VARCHAR(32000)) log from rdb$formats f join rdb$relations r on r.rdb$relation_id = f.rdb$relation_id where r.rdb$relation_name...
more »

2017-11-08 16:11 (1) Answers

Use auto incremented ID in another column

I have two columns in my DB table, where the first one is auto incremented ID. In the second one I would like to have that ID mirrored. (I know it sound like design error, but I really need it) Is it possible to configure it that way? ...
more »

2017-11-08 13:11 (3) Answers

Error loading CSV to table

My CSV file contains details about employees of company. One column contains salary of employees (eg- $4,000). So when I write a script to load data into a table by ',' delimited it takes my salary column as 4 & 000 seperately. How to deal with t...
more »

2017-11-08 10:11 (1) Answers

Saving mutiple integer in mysql database laravel

when I try to save my data into the database, for some reason I can only save 1 integer and not multiple integer inside. Can anyone tell me why? I was thinking it might be because I am using FamilyAge as an integer in the database instead of a string...
more »

2017-11-07 01:11 (1) Answers

Initialize multiple databases in Spring

I'm using AbstractRoutingDatasource to route between databases in runtime. In real condition on the informix database everything works just fine. For tests I created a spring profile to use in memory H2 databases. After running the spring app whith ...
more »

2017-11-06 14:11 (0) Answers

How to do a parameter search in Prolog?

For example, a have a "database" like this: processor(pentium_g4400) :- brand('intel'), family('pentium'), series('g4400'), clock(3.3), socket('lga1151'), ram('ddr4'), cores(2), threads(2),!. If I, for instance, wou...
more »

2017-11-06 11:11 (1) Answers

join, union 3 tables in sql

Please, help me to solve my sql problem. In my DB I have 3 tables as following I have wrote a query that display the total refunded and total invoiced and the method has been used to refund or invoice (cash, credit card or checkout) for a specific ...
more »

2017-11-05 18:11 (1) Answers

How to search a word in comma separated column PHP

I'm quite new. Can you help me with this problem? I have a database with several columns. I want to search a name in a column of names separated by comma (title of the columns is colours). Now I'm using FIND_IN_SET(name_to_find,title of column), the ...
more »

2017-11-05 16:11 (0) Answers

Python dask iterate series.unique() values lazily

I am using python 2.7 with dask dataframe I have a df that is too big for memory but fits into disk beautifully. I group by an index, and than need to iterate over the groups, I found here how to do it. When I try to use the suggested code: for...
more »

2017-11-05 09:11 (1) Answers