> Is it possible that you have ended up in SQL-state HY000 or HY004?
> If you are in HY004, then your data types are incorrect!!!
I don't understand: HY000 or HY004 ???
>
> Is really csm_hosts.subnetz a char/varchar?
> If so, what is the maximum length of csm_hosts.subnetz?
>
> E.g. is it true that:
>
> subnetz char(x) or subnetz varchar(x)
> implies
> x >= datalenght('neues_netz')?
is true : [subnetz] [varchar] (20)
the Statement ("UPDATE csm_hosts set subnetz='neues_netz' WHERE
subnetz='test' ) is correct, because when I use MSQuery all Rows will
changed.
> If you are in SQL state HY000, then, hmm... well... good luck! :)
> (In principle any ODBC function are allowed to return state HY004,
> except for SQLError(), SQLGetDiagField() and SQLGetDiagRec()).
>
> Best regards,
>
> /Anders
>
> >-----Original Message-----
> >From: Helmut Himmelstoss [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, April 10, 2001 8:15 PM
> >To: [EMAIL PROTECTED]
> >Subject: [PHP-WIN] PHPLIB, IIS5.0 , PHP404 --> MSSQL Error
> >
> >
> >Hello,
> >
> >after getting the mssql functions to work I ran into a strange
> >problem: I can do inserts, deletes, and selects on records in
> >my database.
> >
> >When I call the script:
> >------------------------------------------------><-------------
> >-------------
> >-----------------------------------
> ><?php
> > $db = new DB_Example("UPDATE csm_hosts set
> >subnetz='neues_netz' WHERE
> >subnetz='test'" );
> >?>
> >------------------------------------------------><-------------
> >-------------
> >-----------------------------------
> >
> >I got:
> >------------------------------------------------><-------------
> >-------------
> >-----------------------------------
> >Database error: Invalid SQL: UPDATE csm_hosts set
> >subnetz='neues_netz' WHERE
> >subnetz='test'
> >MSSQL Error: 1 (General Error (The MSSQL interface cannot
> >return detailed
> >error messages).)
> >Session halted.
> >------------------------------------------------><-------------
> >-------------
> >-----------------------------------
> >
> >My System: Win2000, IIS5.0, php404pl1, phplib-7.2c, SQLServer2000
> >
> >
> >WHY??!?!?!?!?!?
> >
> >THX
> >Helmut
> >
> >
> >
> >
> >--
> >PHP Windows Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail:
> >[EMAIL PROTECTED]
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
