Getting Started with Stored Procedures

[fusionaire]

OK, here's the deal. I've never even used a stored proc, and I need to install one in order to resolve a text filed issue that I'm having.

I have tsweb access to the server, it's using SQL Server 7, IIS 5.0, Windows 2000 professional.

I am coding in ColdFusion, and I am using the <textarea> tag to gather and display the info. Sometimes I can have as much as 30,000 characters.

Any help will greatly be appreciated.

 

[impulse24]

I would need a little more info. You don't install a stored procedure. You create one in SQL server, and then call it from your cold fusion code. What is the text field issue you are having?

 

[fusionaire]

impulse24, Thanks for the reply.

Here's the issue:
I have an area where a user can unlimited text into a "text" field in the database.

However, on my testing, the text gets truncated rather quickly, and any time I try to add more text, the site goes thru the process without any errors, but it doesn't add any more text. I tried reporducing this error with different amounts of text as well as varied amounts of text, all with the same results.

Here is the stored procedure I found to use:

EXEC sp_tableoption 'IssueAlert', 'text in row', '7000'

Where in the code would I place this? First? After I run a query?

What other information do you need?

 

[impulse24]

few things to look at. It sounds like in the database design the field is setup to except a certain number of characters, and even if you try to use the stored procedure if the database field is designed as a varchar(30), that is the max number of characters the field will take. You will need to have the field length modified in the database in order for it to accept additional characters.

If you want to use the stored procedure it would be run when the user updates the database, or adds a new record. Also the stored procedure sp_tableoption must exist in the sql server, or you will receive an error.

First place I would look is database table design

 

[fusionaire]

Thanks, I will look into these issues. Hopefully, I'll have time to remedy all of these things...