27;George Pitcher'
> Subject: RE: [PHP-WIN] SQL query problem
>
>
> Try this: Pack.End > "'.date("Y-m-d").'"
>
> be sure that you have the same dateformat
>
>
>
>
> Hi,
>
> I'm having a problem with the following query (OD
Hi,
I'm having a problem with the following query (ODBC on M$ Access):
select Pack.*, Transacts.*, Extracts.* from Pack, Transacts, Extracts where
(
Pack.End > date() and Pack.Term='Lent' and Transacts.Week=1 and
Transacts.Pack_ID=Pack.Pack_ID and Extracts.ID=Transacts.Extract_ID)
ORDER BY Pack.T
I'm using IIS5.0 on W2k. I have upgraded w2k to sp4 and ms sql server to
sp3. I created a new table and just do a simple query in php program. But
it seems sql server doesn't return any query result. I'm using
mssql_fetch_array() function, but no any return. PHP program is just
pending there. I
t;[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 11:29 AM
Subject: RE: [PHP-WIN] SQL-query
> Why the hell would you want to do that?
>
> It looks ugly?
>
> I'll tell you what, when you have 8 records in the database, and
#34,501
> is missing, I wonder if you'
nt: Friday, 17 January 2003 10:14 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] SQL-query
I hope this isn't to much OT... Sorry if it is...
In my MySQL-db that I use for a php-driven site I have many tables with the
Primary Key set as an auto increment value.
If I have 4 records with id 1, 2,
;[EMAIL PROTECTED]>
> To: "Piotr Pluciennik" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Saturday, January 18, 2003 4:54 AM
> Subject: Re: [PHP-WIN] SQL-query
>
>
> > Piotr is right. SQL shouldn't let you do that, if only for possible
EMAIL PROTECTED]
Subject: Re: [PHP-WIN] SQL-query
Amen to that - I really believe you are better off (if you have the freedom
to do so) changing autoincrement fields to an integer type and managing the
incrementing yourself. In addition to the problem Dash mentions there is
yet another &q
es are
not good however).
- Original Message -
From: "Dash McElroy" <[EMAIL PROTECTED]>
To: "Piotr Pluciennik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 4:54 AM
Subject: Re: [PHP-WIN] SQL-query
> Piotr is right.
Piotr is right. SQL shouldn't let you do that, if only for possible
consistency errors. Imagine if you had id 3 referenced in some other table
and then you put new data in the primary table with id of 3. Then all the
other stuff referring to 3 would then refer to the new data. Not a good
thing.
I'
Hi,
I don't use MYSQL, but the problem is common for
databases. One of the idea of auto increment field is
to have unique identifiers, so you can't insert a
record with auto increment fields set by yourself.
It's always done by DB. So you can't fill a "hole" in
numbering after deleting record. Of
I hope this isn't to much OT... Sorry if it is...
In my MySQL-db that I use for a php-driven site I have many tables with the
Primary Key set as an auto increment value.
If I have 4 records with id 1, 2, 3 and 4 and then delete number 3 and add
one more record I get the id's 1,2,4 and 5. It isn't
11 matches
Mail list logo
