Jos Groot Lipman
|
| Posted: 02/20/2001, 7:45 AM |
|
Using the MS SQL Server sample database NorthWind we have tested CodeCharge
and we are very impressed, it really looks useful.
With the sample table Suppliers (and others) we have encountered a problem
with the field HomePage which is of datatype 'ntext' in SQL server. We
generate code for PHP 4.0 and get stuck with an error when we try to use the
page:
'ntext data cannot be sent to clients using DB-Library (such as ISQL) or
ODBC version 3.7 or earlier. (severity 16)'
while the code tries to execute
'select * from Suppliers where SupplierID=5'
I may understand that PHP does not support ntext data but even if I do not
include the field anywhere there is still the 'select *' that will try to
get it, which fails.
Is there a workaround?
BTW: When generating ASP everything works fine: ASP's database connection is
not limited as much as PHP.
--
Greetings,
J. Groot Lipman
Dijkoraad IT bv
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 02/20/2001, 8:53 AM |
|
I guess you should write not 'select *' , but 'select field1,field2....
fieldn'
--
Regards,
Alexey
CodeCharge Support
Jos Groot Lipman <dontspam@home.nl> wrote in message
news:96u3eu$538$1@news.codecharge.com...
> Using the MS SQL Server sample database NorthWind we have tested
CodeCharge
> and we are very impressed, it really looks useful.
> With the sample table Suppliers (and others) we have encountered a problem
> with the field HomePage which is of datatype 'ntext' in SQL server. We
> generate code for PHP 4.0 and get stuck with an error when we try to use
the
> page:
> 'ntext data cannot be sent to clients using DB-Library (such as ISQL)
or
> ODBC version 3.7 or earlier. (severity 16)'
> while the code tries to execute
> 'select * from Suppliers where SupplierID=5'
> I may understand that PHP does not support ntext data but even if I do not
> include the field anywhere there is still the 'select *' that will try to
> get it, which fails.
> Is there a workaround?
>
> BTW: When generating ASP everything works fine: ASP's database connection
is
> not limited as much as PHP.
> --
> Greetings,
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>
|
|
|
|
Jos Groot Lipman
|
| Posted: 02/20/2001, 11:23 AM |
|
In article <96u7de$csg$1@news.codecharge.com>,
alexa@codecharge.com says...
> I guess you should write not 'select *' , but 'select field1,field2....
> fieldn'
I agree but it is not me who wrote 'select *': It is
generated by CC after I used the Wizard 'Grid+Edit'
Jos
|
|
|
|
Alexey Alexapolsky
|
| Posted: 02/22/2001, 4:35 AM |
|
You can also create a view with normal name for this table , and use
this view in CodeCharge.
--
Regards,
Alexey
CodeCharge Support
Jos Groot Lipman <dontspam@home.nl> wrote in message
news:96u3eu$538$1@news.codecharge.com...
> Using the MS SQL Server sample database NorthWind we have tested
CodeCharge
> and we are very impressed, it really looks useful.
> With the sample table Suppliers (and others) we have encountered a problem
> with the field HomePage which is of datatype 'ntext' in SQL server. We
> generate code for PHP 4.0 and get stuck with an error when we try to use
the
> page:
> 'ntext data cannot be sent to clients using DB-Library (such as ISQL)
or
> ODBC version 3.7 or earlier. (severity 16)'
> while the code tries to execute
> 'select * from Suppliers where SupplierID=5'
> I may understand that PHP does not support ntext data but even if I do not
> include the field anywhere there is still the 'select *' that will try to
> get it, which fails.
> Is there a workaround?
>
> BTW: When generating ASP everything works fine: ASP's database connection
is
> not limited as much as PHP.
> --
> Greetings,
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>
|
|
|
|
Alexey Alexapolsky
|
| Posted: 02/22/2001, 9:17 AM |
|
Sorry , my previous answer is not connected with current question ,
it answers the question about table names with spaces.
Alexey Alexapolsky <alexa@codecharge.com> wrote in message
news:97311m$ci7$1@news.codecharge.com...
> You can also create a view with normal name for this table , and use
> this view in CodeCharge.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
> Jos Groot Lipman <dontspam@home.nl> wrote in message
>news:96u3eu$538$1@news.codecharge.com...
> > Using the MS SQL Server sample database NorthWind we have tested
> CodeCharge
> > and we are very impressed, it really looks useful.
> > With the sample table Suppliers (and others) we have encountered a
problem
> > with the field HomePage which is of datatype 'ntext' in SQL server. We
> > generate code for PHP 4.0 and get stuck with an error when we try to use
> the
> > page:
> > 'ntext data cannot be sent to clients using DB-Library (such as
ISQL)
> or
> > ODBC version 3.7 or earlier. (severity 16)'
> > while the code tries to execute
> > 'select * from Suppliers where SupplierID=5'
> > I may understand that PHP does not support ntext data but even if I do
not
> > include the field anywhere there is still the 'select *' that will try
to
> > get it, which fails.
> > Is there a workaround?
> >
> > BTW: When generating ASP everything works fine: ASP's database
connection
> is
> > not limited as much as PHP.
> > --
> > Greetings,
> > J. Groot Lipman
> > Dijkoraad IT bv
> >
> >
> >
>
>
|
|
|
|
CodeCharge
|
| Posted: 02/22/2001, 7:57 PM |
|
Since it is a PHP bug, a workarounds could be:
a) Use a View instead of a Table, and do not include fields of ntext type
b) Use your own custom SQL in Form Properties instead of the table. In such
SQL statement you could specify the exact fields you like to read from MS
SQL.
For example:
'select field1,field2,field3 from Suppliers where SupplierID=5'
"Jos Groot Lipman" <dontspam@home.nl> wrote in message
news:96u3eu$538$1@news.codecharge.com...
> Using the MS SQL Server sample database NorthWind we have tested
CodeCharge
> and we are very impressed, it really looks useful.
> With the sample table Suppliers (and others) we have encountered a problem
> with the field HomePage which is of datatype 'ntext' in SQL server. We
> generate code for PHP 4.0 and get stuck with an error when we try to use
the
> page:
> 'ntext data cannot be sent to clients using DB-Library (such as ISQL)
or
> ODBC version 3.7 or earlier. (severity 16)'
> while the code tries to execute
> 'select * from Suppliers where SupplierID=5'
> I may understand that PHP does not support ntext data but even if I do not
> include the field anywhere there is still the 'select *' that will try to
> get it, which fails.
> Is there a workaround?
>
> BTW: When generating ASP everything works fine: ASP's database connection
is
> not limited as much as PHP.
> --
> Greetings,
> J. Groot Lipman
> Dijkoraad IT bv
>
>
>
|
|
|
|
|
