Search found 851 matches

by doctorized
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...
by doctorized
Mon Mar 11, 2024 6:13 pm
Forum: Coding Questions
Topic: cannot read specific xlsx files
Replies: 3
Views: 249

Re: cannot read specific xlsx files

HeX0R wrote: Mon Mar 11, 2024 1:47 pm It's from here
You are my man! So, can I please send you an xlsx file with the problem to check it out? This file makes the code run forever.
by doctorized
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...
by doctorized
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...
by doctorized
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...
by doctorized
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 ...
by doctorized
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...
by doctorized
Tue Jan 23, 2024 11:08 am
Forum: Coding Questions
Topic: read excel .xlsx file data ...
Replies: 30
Views: 4378

Re: read excel .xlsx file data ...

mk-soft wrote: Mon Jan 22, 2024 11:59 pm Is a different format.
Try with ODBC driver
Is there any example?
by doctorized
Mon Jan 22, 2024 11:09 pm
Forum: Coding Questions
Topic: read excel .xlsx file data ...
Replies: 30
Views: 4378

Re: read excel .xlsx file data ...

Tested HeX0R's code and work just fine. Is there a way to read xls files too?
by doctorized
Tue Jan 09, 2024 9:39 pm
Forum: Off Topic
Topic: .htaccess issue
Replies: 3
Views: 970

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 ...
by doctorized
Tue Jan 09, 2024 5:49 pm
Forum: Off Topic
Topic: .htaccess issue
Replies: 3
Views: 970

.htaccess issue

I am trying to change the url in browser from
to
I ve written the rule:

Code: Select all

RewriteEngine On
RewriteRule ^contact/?$ /index.php?page=contact [L]
and it is not working. What am I doing wrong?
by doctorized
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...
by doctorized
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
by doctorized
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:

Code: Select all

ABC2
ABC10
ABCD5
ABCD10
ABCDEF1
ABCDEF10
ETC
How can we order in such a case?
by doctorized
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!!