...

View Full Version : Db & Date Questions



lse123
07-27-2007, 04:12 PM
JOIN in an sql select statement is for tables one-to-one relate ?

How to refer records in a table if private key in not auto-increment but date string ?

If two private keys may two records have one private key the same ?

Exist in asp timestamp functionality like php ?

How I compare Dates below:
1) get from a form field in format mm/dd/yyyy
with
2) dates from Access db table field
or
2) dates from MySQL db table field ?

Daemonspyre
07-27-2007, 05:37 PM
If you are using DATES as your Primary Keys, you need to look into some serious database revisions.

Primary Keys (PK) are by their very nature UNIQUE, so you can't have 1 date be the same PK on multiple records.

PHP uses UNIX_TIMESTAMP. ASP, not being built on UNIX, does not use them. You have to do a Google search for ASP UNIX_TIMESTAMP functions.

As to the rest of your post -- you just asked this in another thread. Look there for the answer.

lse123
07-28-2007, 09:50 AM
JOIN statement in an sql select statement is for tables one-to-one relate ?

Daemonspyre
07-28-2007, 02:23 PM
Sure. You are still JOINing tables together based on 1 field, correct?

lse123
07-28-2007, 03:06 PM
This field must be private key in one and foreign key to other ?

miranda
07-29-2007, 05:18 PM
Actually you can join tables where the column used for the join is a foreign key in both of the tables. Or if the database does not have any foreign keys set up you can still do the join on the tables as long as they will have the same value in each of the columns that you are doing the join on.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum