CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 ntext not supported by PHP-->Table cannot be used by CodeCharge

Print topic Send  topic

Author Message
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
>
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.