Comments by Valentine1993 (Top 35 by date)

oh yeah. Hey mark mine as solved? i'm newbie

The proper question is "Returning time interval intersection"

SELECT *
FROM reservation
WHERE (startDateTime BETWEEN '2013-06-01 02:00:00' AND '2013-06-01 03:00:00')
Return 2 Query. 00002, 00003. Although the returned query is correct. But I don't want the 3:00:00 because 03:00:00 to 06:00:00 is not part of 02:00:00 to 03:00:00. 00003 just touched the range of 02:00:00 to 03:00:00

SELECT *
FROM reservation
WHERE (startDateTime BETWEEN '2013-06-01 02:00:00' AND '2013-06-01 03:00:00') OR (endDateTime BETWEEN '2013-06-01 02:00:00' AND '2013-06-01 03:00:00')

Return 3 Query. 00001, 00002, 00003

okok. SA (:

Why the conversation turn soooooo bad. The reason I'm saying I'm from college is because I never work at any IT company. I'm soooo "fresh". I hope you guys can understand

ok I just checked my sense of humor. It seems ok. I'm sorry about that. Can I ask you again. Do you normally "steal" image/icon/ any graphics for your own program? I'm just wondering because I'm still a college student.

Respect? So you guys normally "steal"? Sorry if i offended you!

Yup i try it and it's working now. I just confused myself previously. Thanks!

JScrollPane works? I want user to switch between different GUI, not scrolling.

the problem is, there is not enough documentation and most tutorial are out of date

Can you correct the file for me? I think it's due to netbean because i don't know how to use...

Ya ya. I just did it with inheritance. Thanks guys!

ok. thanks for the reply. Inheritance seems working for me. (:

1) Because in order to manipulate any data from a database, first and last we need to establish and close connection. And it's repeating task. I don't want to see repeated stuff again and again in my code. Extending a base class works? Because manipulation of data is different on every task. Hmmmm.....

2) Is it common for application to frequently connect and close connection just to perform a single task. Example: Select* FROM state. Or do programmer, open a connection on the moment the program is executed then close only when the program has quit?

oh ok thank you

May I ask 1 more question? If I store the user in a table, would the security be compromised?

oh ok. thank you!

Oh. You know what I mean. Thanks. Then what is the purpose of creating user in a database(Not table)? I mean in phpMyAdmin.

Thx for reply. I will try to learn this new technique. It's tough!

Oh. I had already Installed SQlite and VB. I'm so sorry because I was a bit of the stubborn kind.

That tutorial is great. I think i should read this instead of ignoring it. The main reason I ignore it because it's started in Linux environment and it's a bit of weird.

Sorry. I don't really know what I'm doing. I'm confused and I just code. Sorry about that. My college sux. That's why I'm here.

aw aw aw aw aw ... ... ... ...

I think I would be using SQLite. Also, I will not be storing image inside the database. It's just the location path. Thanks ya!

Hi. Thanks for helping me.

Thanks. I just figured out the way to get the location path.

The link to library is http://mka-soft.com/downloads/Accessing%20Twain%203.zip[^]

I know that, videossss are not library. Doing stuff like scanning image to VB is a hard to find stuff. So what is a generic type?

Seriously. I didn't know how to use all of them.....

TWAIN32D.DLL ?? Wroking..Having bad time searching for this