--- [EMAIL PROTECTED] wrote:
> > --- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> Don't know about other database engines, but in
> MySQL, it doesn't matter
> if an int is inserted as a string, i.e., with the
> quotes. My recollection
> is that MySQL handles the type conversion
> internally. So,
> --- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> > > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> > > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo,
> > > Telecomu, City1, State1, City2, State2,
> > TravelPref,
> > > SalaryAnnual, SalaryHourly, Available) VALUES (47,
> > > '', 7, 2, 10
--- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo,
> > Telecomu, City1, State1, City2, State2,
> TravelPref,
> > SalaryAnnual, SalaryHourly, Available) VALUES (47,
> > '', 7, 2, 1015, 5, , '',
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 29 November 2004 13:19, Stuart Felenstein wrote:
> Now the printout of the query is this:
>
> 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> WorkAuth, WorkExp, CarLev, Secu,
Stuart Felenstein a écrit :
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
I know recently the server was update from PHP 4.3.8
to 4.3.9 but that shouldn't have effected anything.
Code:
$query = "INSERT INTO table1 (ProfileID, LurkID,
ProfileName, Edu,..."
VALUES (null,..
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
One last thing to add on this issue. This table was
created using tabletype InnoDB. Now I discovered
earlier that this table and (many others) had switched
over to MyISAM. I'm still trying to trace down the
cause with my ISP.
Anyway, using a mys
--- denys <[EMAIL PROTECTED]> wrote:
> hi!
> what if you try to ignore the primary key in fields
> and values list ?
> MySQL should assign a valid primary key. It's what
> I'm doing on 4.0.22
> and it's working If not, try to echo your query
> and write it in
> MySQL( GUI or console).
>
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I know recently the server was update from PHP 4.3.8
> to 4.3.9 but that shouldn't have effected anything.
>
> Code:
>
> $query = "INSERT INTO table1 (ProfileID, LurkID,
> ProfileName, Edu,..."
> VALUES (null,..
