Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-23 : 07:37:47
|
| bharath writes "Hi,I am creating a table ##t1 through a Store Procedure in mssql. When i compile the procedure and run it from Query Analyzer the table gets created successflly. But when i call the procedure from the php page i am getting the folloing message on my page.Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'Project Name', table 'tempdb.dbo.##t1'; column does not allow nulls. INSERT fails. (severity 16) in D:\development\CustomizedReport.php on line 112 When creating the the table i am not specifying the fields as 'not null'. Still i am getting the above error. I need HelpBharath" |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-09-23 : 08:37:58
|
| >>When creating the the table i am not specifying the fields as 'not null'I don't know anything about mySql or php pages, but can you create the column as nullable? ie: [Project Name] varchar(50) NULLBe One with the OptimizerTG |
 |
|
|
|
|
|
Table Creation through Procedure