Search found 851 matches
- Mon Mar 11, 2024 9:24 pm
- Forum: Coding Questions
- Topic: Help with Query
- Replies: 4
- Views: 226
Re: Help with Query
No working code... no help. I understand that I forgot to mention it is an SQLite db.I have problem with the query so I don't think that a working code is needed. I just posted the query that returns data in wrong order. I apologize for any inconvenience. After all, DarkDragon managed to find the s...
- Mon Mar 11, 2024 6:13 pm
- Forum: Coding Questions
- Topic: cannot read specific xlsx files
- Replies: 3
- Views: 249
- Mon Mar 11, 2024 12:53 pm
- Forum: Coding Questions
- Topic: cannot read specific xlsx files
- Replies: 3
- Views: 249
cannot read specific xlsx files
Some days ago I found a code here in this forum that reads xlsx files. It reads many files like a charm but I have some files that cannot be read. I do not know the original author. Can anyone help? I can send a sample file with PM. ;original idea from Mijikai, thanks for that! ;https://www.purebasi...
- Sun Mar 10, 2024 8:41 pm
- Forum: Coding Questions
- Topic: Help with Query
- Replies: 4
- Views: 226
Help with Query
CREATE TABLE Lendings (book_id TEXT, stud_id TEXT, LDate DATE, Returned TINYINT, RDate DATE) CREATE TABLE Students (id TEXT PRIMARY KEY, Lname TEXT, Fname TEXT, Class TEXT) when I run: Select * from (select id, Lname, Fname, Class from students where id like '2023-2024%' and class = 'A2') S left jo...
- Sat Mar 09, 2024 9:41 am
- Forum: Off Topic
- Topic: Problem with SQLite query
- Replies: 3
- Views: 394
Re: Problem with SQLite query
I have: CREATE TABLE Books (id TEXT PRIMARY KEY, Title TEXT, Writer TEXT, Publisher TEXT, Year INT, Copies TINYINT, ISBN TEXT) CREATE TABLE Lendings (book_id TEXT, stud_id TEXT, LDate DATE, Returned TINYINT, RDate DATE) Your query returns the same error. On the other hand, select count(*) from books...
- Fri Mar 08, 2024 10:44 pm
- Forum: Off Topic
- Topic: Problem with SQLite query
- Replies: 3
- Views: 394
Problem with SQLite query
I make an app that handles school library. I try to run the query: Select L.book_id, B.Title, count(*) from Lendings L left join Books B on L.book_id = B.id where L.stud_id like '2023-2024%' group by L.book_id order by count(*) DESC and I get error: near "(": syntax error The exactly same ...
- Sat Mar 02, 2024 6:18 pm
- Forum: Coding Questions
- Topic: Ckeck if Excel is installed
- Replies: 2
- Views: 172
Ckeck if Excel is installed
I make an app that uses vb script to read and save Excel files. I want to know if excel is installed, if not, my app will not try to read or write. If it is installed, I want to know the version to be able to save xlsx files if version is 2007 or higher. (Yes, a client may have 2003 or earlier versi...
- Tue Jan 23, 2024 11:08 am
- Forum: Coding Questions
- Topic: read excel .xlsx file data ...
- Replies: 30
- Views: 4376
- Mon Jan 22, 2024 11:09 pm
- Forum: Coding Questions
- Topic: read excel .xlsx file data ...
- Replies: 30
- Views: 4376
Re: read excel .xlsx file data ...
Tested HeX0R's code and work just fine. Is there a way to read xls files too?
- Tue Jan 09, 2024 9:39 pm
- Forum: Off Topic
- Topic: .htaccess issue
- Replies: 3
- Views: 969
Re: .htaccess issue
...... send me a private message if you have any questions. Norm. You have a pm. The rewrite seems to be correct. Maybe a server configuration issue? redirect 301 rules work like a charm but no RewriteRule seems to work. What configuration could be done in plesk? (Plesk is the only tool that I use ...
- Tue Jan 09, 2024 5:49 pm
- Forum: Off Topic
- Topic: .htaccess issue
- Replies: 3
- Views: 969
.htaccess issue
I am trying to change the url in browser from
and it is not working. What am I doing wrong?
to
I ve written the rule:
Code: Select all
RewriteEngine On
RewriteRule ^contact/?$ /index.php?page=contact [L]
- Fri Dec 08, 2023 5:49 pm
- Forum: Off Topic
- Topic: Problem with shortcuts in Word 2013
- Replies: 1
- Views: 877
Problem with shortcuts in Word 2013
Purchased Office 2013 was installed on two computers. One computer has Win 10 and the other 7. On both, every now and then, the keyboard shortcuts are replaced with other ones. Eg instead of Ctrl + V for pasting, it has Ctrl + Insert. All shortcuts, copy, cut, paste, undo, redo etc are replaced by o...
- Tue Oct 03, 2023 7:42 pm
- Forum: Off Topic
- Topic: how to order correctly in sqlite?
- Replies: 8
- Views: 585
Re: how to order correctly in sqlite?
Thank you very much! One last question. What about having words like the following?
Code: Select all
TEST.ACK.1
TEST.ACK.10
PROD.MX.2
PROD.MX.10
PROD.10
PROD.2
LOG.DAT.10
LOG.DAT.5
- Tue Oct 03, 2023 12:05 am
- Forum: Off Topic
- Topic: how to order correctly in sqlite?
- Replies: 8
- Views: 585
Re: how to order correctly in sqlite?
Kifi's solution solved one of my problems. I have a second query where the results have no known prefix like:
How can we order in such a case?
Code: Select all
ABC2
ABC10
ABCD5
ABCD10
ABCDEF1
ABCDEF10
ETC
- Mon Oct 02, 2023 11:39 pm
- Forum: Off Topic
- Topic: how to order correctly in sqlite?
- Replies: 8
- Views: 585
Re: how to order correctly in sqlite?
Actually helped as every prefix is stored in a separate table. Thanx a lot!!