[Resolved] SQL Datatypes

JJ123

I need to have a field in my MS SQL database that is able to contain large amounts of data. It is a place where log information is kept. Right now I have this field set as a varchar and the length is set to 8000. This is not long enough.

Can some one please help me with this?

Thanks,

stolzyboy

give this a read, but in short, use "text" instead of varchar, text can hold 2 billion bytes of data

barand

Make it type TEXT or LONGTEXT

lanjoky

Have you tried making it a "text" field ... if not try that and see what happens.

JJ123

I just changed it to text and my query is now failing:

Warning: mssql_query() [function.mssql-query]: message: Invalid operator for data type. Operator equals add, type equals text. (severity 16) in c:\inetpub\wwwroot\niffer\ticketadmin.php on line 38

Warning: mssql_query() [function.mssql-query]: Query failed in c:\inetpub\wwwroot\niffer\ticketadmin.php on line 38

The code that is on line 38 is:

$query = "UPDATE tblIssues SET priority = '$priority', firstname = '$first', lastname = '$last', phone = '$phone', email = '$email', issuetype = '$type', subject = '$subject', comment = '$comment', status = '$status', assignedto = '$assignto', assigntime = '$assigntime', logdetails = logdetails + '$worklog' WHERE issuenumber='$number'";

the variable that I changed to Text in the database is logdetails.

What am I doing wrong here?

barand

Try ,

..., logdetails = CONCAT(logdetails , '$worklog' ), ...

... , logdetails = logdetails||'$worklog' , ...

hth

JJ123

When I try to use CONCAT, I get this error:

Warning: mssql_query() [function.mssql-query]: message: 'CONCAT' is not a recognized function name. (severity 15) in c:\inetpub\wwwroot\niffer\ticketadmin.php on line 39

And when I try to use ||, I get this error:

Warning: mssql_query() [function.mssql-query]: message: Line 5: Incorrect syntax near '|'. (severity 15) in c:\inetpub\wwwroot\niffer\ticketadmin.php on line 39

Here is the query with the change. Is this correct?
$query = "UPDATE tblIssues SET priority = '$priority', firstname = '$first', lastname = '$last', phone = '$phone', email = '$email', issuetype = '$type', subject = '$subject', comment = '$comment', status = '$status', assignedto = '$assignto', assigntime = '$assigntime', logdetails = logdetails||'$worklog' WHERE issuenumber = '$number'";

barand

I just consult my mssql bible and according to that, + should work.

I guess it doesn;t like concatenating text fields.

You could update all the other fields then query the file to get the logdetails. Concatenate in php then update with the new contents.

Alternatively, have a separate table of logdetails and insert new records into it.

hth

JJ123

Thanks Barand,

I took your second suggestion - "You could update all the other fields then query the file to get the logdetails. Concatenate in php then update with the new contents."

It is working great. Here is my code just in case anyone else is having this problem as well:

//This code concatenates the new log information to the bottom of the log information that is already in the database.
$querylog = "SELECT logdetails from tblIssues Where issuenumber = '$number'";
$resultlog = mssql_query($querylog);
$log = mssql_fetch_row($resultlog);
$addlog = "$log[0] \n$worklog";

//This code updates all the variables of the record in the database to the values the user has changed on the web page.
$query = "UPDATE tblIssues SET priority = '$priority', firstname = '$first', lastname = '$last', phone =

'$phone', email = '$email', issuetype = '$type', subject = '$subject', comment = '$comment', status = '$status', assignedto =

'$assignto', assigntime = '$assigntime', logdetails = '$addlog' WHERE issuenumber = '$number'";

If anyone sees a problem with this code, definately let me know.

thanks