Our Forum Has Msgs &&> 8K

Jan 28, 2008

Hi,

Our website provide users with a forum where they can enter messages. So, typically, a user would enter a message, click submit, and their message would be displayed on the forum.

The db that stores these msgs uses a varchar field. Now, we're adding a facility to convert any urls that are entered to links by adding 'a href' tags, so that when users see messages with urls, those urls appear as links, and they can click on them. The problem is that if a user enters a message of 8K chars, then we add 'a href' tags to any urls they have, that makes the message length > 8K, preventing us from storing it in our db. (Please note that we do need to add HTML tags for other reasons as well, not just to convert urls to links.)

We thought about adding 'a href' tags during pre-render, thus avoiding storing html in the db, but found that doing such string manipulations, while a user is waiting to see their post displayed on the forum, was expensive. Timing tests revealed that the time to render such pages more than doubled.

I have solved such problems previously by adding an extra field in the db to store any overflow data, that is, data that appears after the first 8K chars.

However, I learnt of sql server 2005's varchar(max) datatype, and 'am wondering if the best way to solve this problem would be to replace the varchar field with varchar(max).

Thanks in advance for any advice.
Shefali

View 4 Replies


ADVERTISEMENT

Anyone Else Get No Body To Msgs After 10/28?

Oct 28, 1998

Anyone else get no body to msgs after 10/28?
Why admin peoples?

View 1 Replies View Related

Database Error Msgs

Jan 5, 2005

Is there a reference that describes error messages?
On line Books does not seem to contain error listings. Still using sequel 7.

View 5 Replies View Related

Maintenance Plans Error Msgs

Jun 29, 2007

This error msgs persist after installing SP2 Hotfixes.
Any ideas?? Please see below:

TLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)
------------------------------
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

View 2 Replies View Related

Service Broker:I Get An Error -8430 Msgs R Not Dilivering To Sys.transmision_queue

Jun 27, 2007

Hi all,

I m newbie in service broker(ms sql server 2005). Somehow I have get tutorial on net and created service broker but now i m getting an error

<Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error">
<Code>-8430</Code>
<Description>The message body failed the configured validation.</Description>
</Error>

can anyone help me, what this error for?

and one more thing, i m trying this on my local system so should i create route and endpoint?

thanks in advance.

regard
Hammad

View 5 Replies View Related

SSMS Express: Create TABLE &&amp; INSERT Data Into Table - Error Msgs 102 &&amp; 156

May 18, 2006

Hi all,

I have SQL Server Management Studio Express (SSMS Express) and SQL Server 2005 Express (SS Express) installed in my Windows XP Pro PC that is on Microsoft Windows NT 4 LAN System. My Computer Administrator grants me the Administror Privilege to use my PC. I tried to use SQLQuery.sql (see the code below) to create a table "LabResults" and insert 20 data (values) into the table. I got Error Messages 102 and 156 when I did "Parse" or "Execute". This is my first time to apply the data type 'decimal' and the "VALUES" into the table. I do not know what is wrong with the 'decimal' and how to add the "VALUES": (1) Do I put the precision and scale of the decimal wrong? (2) Do I have to use "GO" after each "VALUES"? Please help and advise.

Thanks in advance,

Scott Chang

///////////--SQLQueryCroomLabData.sql--///////////////////////////
USE MyDatabase
GO
CREATE TABLE dbo.LabResults
(SampleID int PRIMARY KEY NOT NULL,
SampleName varchar(25) NOT NULL,
AnalyteName varchar(25) NOT NULL,
Concentration decimal(6.2) NULL)
GO
--Inserting data into a table
INSERT dbo.LabResults (SampleID, SampleName, AnalyteName, Concentration)
VALUES (1, 'MW2', 'Acetone', 1.00)
VALUES (2, 'MW2', 'Dichloroethene', 1.00)
VALUES (3, 'MW2', 'Trichloroethene', 20.00)
VALUES (4, 'MW2', 'Chloroform', 1.00)
VALUES (5, 'MW2', 'Methylene Chloride', 1.00)
VALUES (6, 'MW6S', 'Acetone', 1.00)
VALUES (7, 'MW6S', 'Dichloroethene', 1.00)
VALUES (8, 'MW6S', 'Trichloroethene', 1.00)
VALUES (9, 'MW6S', 'Chloroform', 1.00)
VALUES (10, 'MW6S', 'Methylene Chloride', 1.00
VALUES (11, 'MW7', 'Acetone', 1.00)
VALUES (12, 'MW7', 'Dichloroethene', 1.00)
VALUES (13, 'MW7', 'Trichloroethene', 1.00)
VALUES (14, 'MW7', 'Chloroform', 1.00)
VALUES (15, 'MW7', 'Methylene Chloride', 1.00
VALUES (16, 'TripBlank', 'Acetone', 1.00)
VALUES (17, 'TripBlank', 'Dichloroethene', 1.00)
VALUES (18, 'TripBlank', 'Trichloroethene', 1.00)
VALUES (19, 'TripBlank', 'Chloroform', 0.76)
VALUES (20, 'TripBlank', 'Methylene Chloride', 0.51)
GO
//////////Parse///////////
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '6.2'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'VALUES'.
////////////////Execute////////////////////
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '6.2'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'VALUES'.

View 7 Replies View Related

Error Msgs In SQL6.5 - Error 17824, 232, 1608

Aug 16, 1999

Had to rebuild SQL server and restored SMS databases ok. But the following msgs have appeared - any clues. All help appreciated.

99/08/16 16:38:30.75 ods Error : 17824, Severity: 10, State: 0
99/08/16 16:38:30.75 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname ''.
99/08/16 16:38:30.75 ods OS Error : 232, The pipe is being closed.
99/08/16 16:38:30.77 spid16 Error : 1608, Severity: 21, State: 2
99/08/16 16:38:30.77 spid16 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.

View 2 Replies View Related

Forum Help

Jun 16, 2004

are you able to see the posts in

http://www.dbforums.com/t1001477.html

??

I am seeing a blank page.

View 4 Replies View Related

Forum Recommendation

Sep 8, 2004

Can anyone recommend me other "REALLY GOOD" msql server forums?

Thanks

View 1 Replies View Related

I Hope Its The Right Forum...

Sep 12, 2005

how to use MSSQL in asp.net?

View 2 Replies View Related

Best General SQL Forum

Apr 28, 2008

I'm not impressed with the speed/quality of responses from this forum...

Can anybody recommend a more active forum?

View 20 Replies View Related

Best Way To Design A Forum?

Nov 7, 2007

Hi everyone,

Our company plans to redesign the forum. we currently stores all posts in text files. someone suggest that we can use xml. I am not familiar with using xml. Is XML better for the forum design and data retriving?

Thanks in advance

View 4 Replies View Related

Question About Forum

Jun 6, 2007

Can anyone tell me , For instance : if someone has posted new post and If I want to answer to that post, how can I answer that. Or How do I know that there is some new post which people can response to it, please give me your feed back on this



thank you

View 5 Replies View Related

Msdn Forum

Mar 14, 2008



Where is the list for forums,
When i started to write for Sqlserver, i never searched or looked for forum. Same did when i was working with the c#.
Now I have to find the correct forum. So where is the list of those forums, thanks.

View 3 Replies View Related

This Forum Is BROKEN!!!!

Mar 8, 2007

Anyone having problems with this forum today?

 

I have had countless email alerts thru today alerting me to people replying to threads I have commented on. And I can see the person's comments.

 

1) WhenI click on the link it takes me to a page saying the post doesn't exist

2) When I try and browse to the thread manually I can't see the reply.

3) On one occasion I replied to one of these threads asking if someone had posted something and then deleted it. After I submitted the post I could see all the other posts in the thread which were supposedly missing before. The next time I browse to the thread (in a new browser window) I can't see any of the posts.

 

BROKEN!!!! I for one won't be coming back here until they fix it. Its pathetic.

I have posted something on the bug report forum by the way.

-Jamie

P.S. Its not just on this forum either.

View 8 Replies View Related

Setup Forum?

Apr 27, 2006

Where would I find this. It's not listed under SQL forums. Is this a general setup forum or specific to SQL?



Thanks......

View 1 Replies View Related

Not Sure If This Is The Correct Forum, But SQL Question

Sep 4, 2007

i have a main pallet inventory table, kinda like:
key        location         sku         qty        datercvd1            W9A03         12345       500      5/5/072            W9A04         12345       500      5/5/073            W9A05         12345       500      5/5/07
Now, if i say:Select loc,sku,qty,datercvdFrom TableWhere sku=12345
it works great, now say my order only requiers 700 of that sku,I only want to pull pallets that i need, how can i say:Select loc,sku,qty,datercvdFrom TableWhere sku=12345 (that qty summed is not more than 700?)
not sure if i can or how to make it like a formula.
Thanks in advance.
Jeff

View 4 Replies View Related

SQL And Forum On Seperate Machines....

Jan 16, 2004

Hi All,

I have got MSSQL 2000 set up on a machine in my rack at my local telehouse, and a web server set up at home on an ADSL line.

Both servers can see (ping) eachother fine , so you can rule out any kind of connectivity issues straight away, but when i try to get my forum to connect to the mssql database using the correct credentials it just fails saying that the credentials are incorrect ot the server does not exist.

I also installed an SQL database tool on my web server (Shusheng SQL Tool) and attempted to connect to my SQL server using that tool, and got the following message: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.'

The server is currently using mixed mode authentication (SQL/Windows) and has both TCP/IP and Named pipes enabled.

Is there some kind of 'Enable remote connections' option in SQL? I need to be able to allow connections to my SQL server from any system, anywhere...

Any ideas?

View 1 Replies View Related

SQL Or Access For A Small Forum

Jan 18, 2004

Hi,

I'm just about to launch a forum, and right now its built in ASP classic with an Access db. I origianlly used Access because most hosts charge extra for MS-SQL server. Recently I switched to Jodohost who offers Access, MS-SQL and MySql for at no additional cost. So now that I have the option, I would like to pick the best solution before I launch.


* My questions are...

- What is the best db solution to go with for a currently small forum?

- How problematic do you think a data migration would be in the future if I stayed with Access for now and upgraded to MS-SQL with a full forum?

- Is it just smarter to go with MS-SQL now, with an empty forum, regardless of any preformance issues because potential migration problems are a greater risk?

- At what point does the speed of MS-SQL at high volumes over come the potential lags in accessing MS-SQL if it is hosted on a different machine from the one hosting the webpages?



* And please keep in mind...

- I have no db training. I can muddle through Access well enough, but administrating MS-SQL I think might be another story

- This fourm will start off very small, but could grow to be quite large

- I may not stay with jodohost, and would therefore likely have to pay more for MS-SQL (which I woudl rather not do)

View 1 Replies View Related

Discussion Forum - Datastructure

Jul 27, 2005

I'm creating a discussion forum for my website, using Sql Server 2000. I need to display 'Number of threads', 'Number of posts', 'Last post by' (username/id and date) for each forum, and 'Number of replies' and 'Last post by' (username/id and date) for each thread.Here are a couple of ideas I have come up with to solve this problem:1) Poll the database (using a stored procedure that returns the number I'm looking for) for each forum when I loop all the fourms. - I suspect this approach isn't optimal, since it creates more traffic to the database.2) Have fields in my Forum and ForumPost tables for 'Number of threads' and so on. Now, create triggers that updates these fields every time a post is made. - I guess this would be much more effective than the first apporach, since everything is done on the database server directly.Are there any other ways that are better? Please advice! Thanks a bunch for any help!

View 7 Replies View Related

Plea To Forum Guardians

Aug 17, 2005

Can you post a FAQ and stop the continuous questions about "login failed"?

View 2 Replies View Related

Is Anyone In This Forum Discussing SQL 2000?

May 22, 2000

I have been helped greatly by people in this forum for SQL7, but I have some questions about 2000. Is this a place where 2000 is being discussed at all? If not I would appreciate someone pointing me in the right direction.

View 1 Replies View Related

SQL Server 2000 Forum

Jan 23, 2001

Looks like there is now a SQL Server 2000 forum for those of us who have been using the 7.0 forum for 2000 questions as the "next best thing."

View 2 Replies View Related

Need Help In Importing Forum Data

Jan 13, 2007

hi,

i am building a forum in asp (just for fun).
i have a mssql 2005 server, and i want to mergeimport data from another mssql 2000 server.
but i dont know how to do it correctly.

i have some tables like this
[forum_c]
forum_c_id (PK, int, not null)
forum_c_name (varchar, not null)

[forum_sc]
forum_sc_id (PK, int, not null)
forum_sc_cid (int, not null)
forum_sc_name (varchar, not null)

etc...

forum_c meaning "forum categories", and forum_sc "forum sub categories".
forum_sc_cid has the value of forum_c_id to know to what categorie it belongs to.

but i dont know how to import it and keep the correct id's.
can somebody please tell me what i need to do???

if you need anymore info to help me just ask.

View 4 Replies View Related

FRx Issue - Sorry If This Isnt The Right Forum

Mar 8, 2007

When running practically any report in FRx (we use it to generate reports in Solomon) we are getting the following error:

FRx Reporting Engine:

01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

This just recently started happening. Is anyone familiar with this? It doesnt give much information after that, it just will not generate the report after the message pops up.

View 2 Replies View Related

Favorite SQL Forum Sites

Jan 25, 2008

What are your favorite Forum sites?


SQLTeam.com
SQLSERVERCENTRAL.com
TekTips.com
MSDNSQL Forum
forums.sqlmag.com

I hate to ask for information such as this but with the low response to my questions I was wondering anyone knows of a better site for SQL Server database mail issues?

Thanks,
Thom

View 1 Replies View Related

Data Warehouse Forum

Jul 6, 2007

Hi, all,

Thanks for your kind attention.

Just have some enquries about some issues of data warehouse design and would like to hear from any of you for any prestigious forum on data warehouse?

Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

View 3 Replies View Related

Passport Sign Out From This Forum

Apr 26, 2006

Just lately I have noticed that I am periodically getting signed out of this forum. When I try and sign back in I get directed to an error page saying:

We apologize, but an unknown error has occured in the forums.

This error has been logged.



I would say this has been happening for a couple of weeks now at least.

Has anyone else expereienced this?



Thanks

Jamie



View 1 Replies View Related

Forum Db Access Problem

Oct 11, 2007

Forum db access problem
I am doing a forum db job. There are two tables: ThreadInfo and ThreadReply.
One is used to store the basic info of threads,
and the other one is used to record the changes of threads€™ reply info from time to time.
I am using jdbc to connect to the sqlServer.
The connection is successful.
The codes are listed below.

try
{
conn = DriverManager.getConnection(dbURL,userName,userPwd);
stmnt=conn.createStatement();
query="SELECT thread_id, thread_title "+
"FROM ThreadInfo "+
"WHERE thread_title='"+threadTitle+"';";
resultSet=stmnt.executeQuery(query);
// The thread is not recorded.
if(!resultSet.next())
{
// Write to ThreadInfo.
query =
"INSERT INTO ThreadInfo(" +
"thread_id, " +
"thread_title, "+
"thread_hplink, "+
"thread_author, "+
"author_hplink, "+
"thread_date, "+
"thread_time, "+
"thread_chars, "+
"thread_reply, "+
"thread_click, "+
"thread_quote) "+
"VALUES("+
"'0001',"+
"'"+threadTitle+"',"+
"'"+threadHplink+"',"+
"'"+threadAuthor+"',"+
"'"+authorHplink+"',"+
"'"+threadDate+"',"+
"'"+threadTime+"',"+
"'"+threadChars+"',"+
"'"+threadReply+"',"+
"'"+threadClick+"',"+
"'"+threadQuote+"'"+
");";

resultSet=stmnt.executeQuery(query);
//Write to ThreadReply.
query=
"INSERT INTO ThreadReply("+
"thread_id,"+
"thread_title, "+
"thread_hplink, "+
"thread_pointer, "+
"crawl_time_1,"+
"thread_reply_1,"+
"thread_click_1,"+
"thread_quote_1) "+
"VALUES("+
"'0001',"+
"'"+threadTitle+"',"+
"'"+threadHplink+"',"+
"'2',"+
"'"+crawlTime+"',"+
"'"+threadReply+"',"+
"'"+threadClick+"',"+
"'"+threadQuote+"'"+
");";
resultSet=stmnt.executeQuery(query);
}

However an exception happened in executing the first sql code.
com.microsoft.sqlserver.jdbc.SQLServerException: No ResultSet object is returned.
But the info has been recorded in ThreadInfo.
As for the exception,the thread immediately goes into the Catch block.
And the info is not recorded in table ThreadReply.

Can anyone help solve the problem?

Many thanks!

View 3 Replies View Related

Forum Database Diagram / Design

Jun 4, 2008

Can any body send me a www.forums.asp.net database diagram/design or sample database....

View 2 Replies View Related

I Have 2 Options To Implement A Web Forum. Which One Is Better?? (SQL Related)

Apr 18, 2005

Hi everyone
 
 
I have 2 options to implement a  very simple web forum. Which one is better??…..
 
The first approach is as the following:
-create a Posts table which will contain all posts.
- create a replies table which will contain all replies.
- The relation between Posts table and replies table is ONE to MANY
 
Advantages of this approach:
-         It follows the rules of normalization.
-         It avoids null values which will accrued if all replies and posts where stored in 1 table.
 
Disadvantages of this approach:
-         When it comes to implementing the search operation and data retrieve against posts table and replies table, I will need to run 2 different queries which means 2 connection to my SQL database. This means a slower execution and round trip to my SQL database.     
 
The second approach is as the following:
 
-         Create one table which will contain all posts and replies.
 
Advantages of this approach:
-         one query will be executed, which means faster execution than the first mentioned approach
-          it avoids round trip to my  SQL database which happens in the first mentioned approach
 
Disadvantages of this approach:
- It does NOT follows the rules of normalization.
- You will end up with null values (for example the post title field will be empty when inserting a reply.)
 
 
 
I would appreciate any comments or thoughts.  

View 4 Replies View Related

Post Dtsx Packages To Forum

Mar 30, 2007

First off, can you post .dtsx packages to the forum? I always end up cutting and pasting code, which is by is nature incomplete, as it generally has external dependencies (connections, variables).

Perhaps you cannot do so for security reasons?

Second, is there a good blog site that allows you to post .dtsx packages?

I'd rather post .dtsx links than cut and paste code (which half the time formats the code un-recognizably), or even worse, post package xml, which contains the layout information and possibly IL that makes it all but unreadable.

View 4 Replies View Related

Where Is The Forum For DTS -&&> SSIS Migration Questions?

Jan 29, 2008

I have a question regarding a DTS (SQL server 2000 package) to SSIS (SQL SERVER 2005 package) migration.

which is the best forum to post my question ?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved