Re: PHPLIB, IIS5.0 , PHP404 --> MSSQL Error
| From: | Helmut Himmelstoss | Date: | Tue, 10 Apr 2001 19:45:03 +0000 |
| Subject: | Re: PHPLIB, IIS5.0 , PHP404 --> MSSQL Error | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-6613@lists.php.net to get a copy of this message | ||
> 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:Helmut.Himmelstoss@t-online.de]
> >Sent: Tuesday, April 10, 2001 8:15 PM
> >To: php-windows@lists.php.net
> >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: php-windows-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-windows-help@lists.php.net
> >To contact the list administrators, e-mail:
> >php-list-admin@lists.php.net
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>