Hi rhowell

Have you got a solution to your add cat problem. If so, would you be so kind to share the solution with me. I'm receiving:

Failed to execute query: 'INSERT INTO lsql_Category (Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Changed_Links,Full_Name,Meta_Keywords,FatherID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1)

It appears to be exactly the same error message you received.

cheers
helgi

PS for the veterans: The entire error message:

GT::SQL::Driver::ODBC::sth (2000): Executing query: SELECT ID FROM lsql_Category WHERE FatherID = 0 AND Name = 'Medier' from

Links::Category::can_add at d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 101 GT::SQL::Driver::ODBC::sth (2000): Executing

query: INSERT INTO lsql_Category

(Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Cha

nged_Links,Full_Name,Meta_Keywords,FatherID) VALUES ('bla','','default','2003-02-25

12:28:51','bla','Medier','footer.txt','header.txt','No',0,'No','Medier','bla',0) from Links::Category::_plg_add at

d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 54 GT::SQL::Table (2000): Failed to execute query: 'INSERT INTO lsql_Category

(Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Cha

nged_Links,Full_Name,Meta_Keywords,FatherID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]Invalid

character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1) at

d:\www2\asp.stiften\cgi-bin\links/admin/GT/SQL/Driver/ODBC.pm line 395. GT::SQL::Driver::ODBC::sth (2000): Executing query: SELECT

DISTINCT Full_Name, ID FROM lsql_Category from Links::Category::HTML::disp_fatherid_form at

d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 590