Vill

0

votes
0

answer
4

views

saving csv file to server - seems to have (squares) limitation on saving

I'm saving data to my server using a CSV format (writing in javascript and html). and it seems that the server stops to write into the file after 1000 squares, while the number of rows\chars is not relevant (the file size is not the issue). the exact same code works for me just fine on a different s...
vill
1

votes
1

answer
1.1k

views

How to open and read files in a Windows Universal App using fopen

I'm writing a windows app (non-xaml) in c++ and trying to read files in my project directory using: FILE* mFile = fopen(filename, 'rb'); and I also tried: errno_t err = fopen_s(&mFile, filename, 'rb'); In this case, the errno is 2 and in both cases mFile is null afterwards. I'm having trouble fin...
Mina Vill
1

votes
1

answer
29

views

How to add form data to a table in the same page without having PHP or database?

I have a modal form. I've been trying to figure out that If I enter data to the form and click submit, It'll automatically display to a table on the same page. Been trying to use JQuery but it won't display.
V. Vill
1

votes
1

answer
0

views

SessionNotCreatedException: Message: session not created from disconnected: unable to connect to renderer with ChromeDriver 2.45 Chrome v71

When I'm executing this code with Selenium using Python: from selenium import webdriver from selenium.webdriver.common.by import By import time driver = webdriver.Chrome(executable_path=r'/Users/qa/Documents/Python/chromedriver') The error occurred: Traceback (most recent call last): File '/Users/qa...
Jan Vill
0

votes
0

answer
2

views

ChromeDriver 2.45 and Chrome v71 is unable to connect to render

When I'm executing this with Selenium using Python from selenium import webdriver from selenium.webdriver.common.by import By import time driver = webdriver.Chrome(executable_path=r'/Users/qa/Documents/Python/chromedriver') The error occured: selenium.common.exceptions.SessionNotCreatedException: Me...
Jan Vill
2

votes
1

answer
84

views

list record by MySQL query

I have mysql tables as below: STORES store_id, rating 10023 5 10024 5 10025 4 10026 4 PRODUCTS product_id, store_id, price 10023 10023 5.00 10045 10023 130.00 10056 10023 10.00 10057 10024 20.00 10058 10024 12.00 100...
Vill Raj
2

votes
1

answer
380

views

Hibernate envers - get audited properties of entity

Is there an easy (built-in) way to get all envers-audited properties for an entity? e.g. public class SomeClass { @Audited private String auditedString; private String otherString; // getter, setter } I'd like to know if there is some utility function in envers which returns an array of @Audited pr...
maria vill
2

votes
0

answer
1.7k

views

issue with ASP.Net Linkbutton and CSS class (visited)

I have an asp.net (.Net Framework 4.0) page with a gridview in it which contains linkbuttons. I set the cssclass property of the linkbuttons to make sure, the Color of the text changes when the link is being clicked (visited). Unfortunately that doesn't work... when i click on the linkbutton, the Co...
Sabrina Vill
2

votes
1

answer
222

views

H2 DB DAY_OF_WEEK starting Monday

I need to get the day of the week of a date in H2 as a number. There is a function DAY_OF_WEEK(date) which returns Sunday as the first day of the week. However, I need Monday to be the first day of the week. Does someone know a function in H2 to accomplish this? I need it for a 'weekday' function i...
maria vill
3

votes
1

answer
88

views

Improve MySQL query

Currently in my ecommerce website have 2 tables below: I used 2 query to generate $query = $this->db->query('SELECT count(*) AS hits, product_id FROM visitors GROUP BY product_id'); if ($query->num_rows() > 0) { foreach ($query->result() as $row){ $hits = $row->hits; $product_id = $row->product_id;...
Vill Raj
8

votes
3

answer
26.5k

views

SELECT query return 1 row from each group

This is a product table and have few million of records. I want to list record as below:Normally I use: SELECT id, product_name, store_id FROM product GROUP BY store_id ORDER BY id. Currently having SQL performance issue. I need SQL query to output result like this.
Vill Raj
3

votes
1

answer
2k

views

SQL query for list category & subcategory

This category/subcategory table for eCommerce site. The level of subcategory are unlimited that admin can create many level subcategories. Output Books Books>English Books>English>Quotes Stationary Stationary>Paper Stationary>Paper>Art Stationary>Paper>Art>Cover Stationary>Paper>Art>Cover>A4 Size Su...
Vill Raj
0

votes
1

answer
330

views

Re-create H2 schema in Hibernate programatically

I'd like to use an in-memory db (H2) to preprocess, validate, etc some import-data before persisting it to the 'real' production database. Prior to each import I'd like to recreate the H2 schema to have a clean database, as with hibernate.hbm2ddl.auto:'create'. Is there any way to call hbm2ddl progr...
maria vill