Searching HTML Data
Mar 29, 2004
Hi,
I have question, sorry if it is very basic, as SQL is not my thing!
Iam allowing visitors on my IBS site to (lets say) create HTML post. This is enabled by allowing the user to use WYISWG text editor component. This means that users can create all sorts of HTML tags.
Before storing this HTML in the SQL Server, I encode it.
I also need to provide users with searching ability. So what is the best way in achieving this? Can I write search SQL normally, as in, with LIKE operators or do I need to something special?
Thanks
View 6 Replies
ADVERTISEMENT
Jul 25, 2006
hi ;
I am abut searching in a database that html data stored in it, I want to search something like this: search me
And it stored like this: search <b> me </b>
I don’t know how to remove html tags on stored procedure,
It will be great if you direct me to a search stored procedure that handle this it rather make the sorting and paging stuff too .
tanks
View 4 Replies
View Related
Jan 15, 2008
I am retrieving a field from SQL and displaying that data on a web page.
The data contains a mixture of text and html codes, like this "<b>test</b>".
But rather than displaying the word test in bold, it is displaying the entire sting as text.
How do I get it to treat the HTML as HTML?
View 6 Replies
View Related
Aug 19, 2007
Hi friends I want to add HTML to the SQL server as data please can anyone help me. which data type . & how to store the data. Thanks for all your support Thanks & regardsASPFreak
View 3 Replies
View Related
Aug 10, 2006
I just finished reading an article on how to search encrypted data efficiently and they suggested creating a new column with a Message Auhtentication Code. To be honest, reading the aritcle makes my head hurt. I can hardly understand what they were doing myself and I can't begin to explain it to a developer.
Are there any easier ways to search encrypted columns for a speciifc match? If not, does any have some stored procs that implement this messy MAC stuff?
TIA,
Barkingdog
View 5 Replies
View Related
Feb 19, 2004
I need to store some HTML, well over 8000 chars in SQL Server, what would be the best data type to use?
Thanks
Simon
View 1 Replies
View Related
Oct 17, 2007
Hi,
I want to import data from .html files to SQL Server 2005 tables using SSIS. Can somebody help me by directing me on how to achieve this.
I tried to many ways but couldn't succeed.
Any help on this will be very helpful.
Thanks
View 1 Replies
View Related
Jul 20, 2005
Hello All,SQL 2000, case insensitive databaseI have a situation where I need to find abbreviations in the rows in atable. The rule i came up is, get all the rows from the table wherethere is more than one character is capitalized consequtively eg."USA", "TIMS", "AIR"Here is the sample data:create table test (mystring varchar(100))goinsert into test (mystring) values ('I live in USA')insert into test (mystring) values ('this is a test row. usa(abbreviated wrongly).')go--expected result setmystring----------------------I live in USAHere is the query which I tried.select * from test where mystring collate SQL_Latin1_General_CP1_CS_ASlike '%[A-Z][A-Z]%'But the above query returns both the records. Any help?Thanks
View 2 Replies
View Related
May 26, 2006
Hi!
I try to use Data Mining HTML Tree Viewer, but has some problem. In the Connection property, i can't set a new connection to this property.
Help me!!!
View 1 Replies
View Related
Dec 14, 2007
I have a decision tree model and I am trying to view the tree using the DMDecisionTreeViewer control as in this sample http://www.sqlserverdatamining.com/MovieSurveyDemo/ . I followed the instructions at this site http://msdn2.microsoft.com/en-us/library/ms160727.aspx and set the following properties:
Server My analysis services server
Database My analysis services catalogue
Model My decision tree model name
ViewType Tree
TargetTree My decision tree's predictable attribute
When I run my application, the component does not display anything and the webpage produces two errors:
1. Syntax Error
2. 'NodeData' is undefined
Furthermore, when I run the query that is expected to give me the TargetTree property value, I get nothing as a result.
SELECT NODE_UNIQUE_NAME, ATTRIBUTE_NAME
FROM [Model].CONTENT
WHERE NODE_TYPE=2
I managed to view my decision tree using windows viewers without problems. Do you have any idea on what I have done wrong, and is the MovieSurveyDemo source code available?
View 1 Replies
View Related
Feb 14, 2008
Hi,
Small problem here. I have successfully installed the Data Mining Web Controls in my pc. I can use it to display the result that i want, the problem is the expand image and collapse image did not show out in the column, by the way I can click the blank column to expand or collapse the tree node, it function completely.
How can i display the expand image and Collapse image?
Can anyone help?
Thanks!
best rgds,
xuenly
View 1 Replies
View Related
Jul 23, 2005
hihere is a problem:i have a databes with many, many tablesthe problem is that i dont know where 'abcd' string is (but it is for surein one of that table)is there any SELECT that could help me with finding this string in database?--greets
View 1 Replies
View Related
Feb 6, 2006
KRFeb 6, 1:48 pm show optionsNewsgroups: microsoft.public.access.formsFrom: "KR" <kra...@bastyr.edu> - Find messages by this authorDate: 6 Feb 2006 13:48:00 -0800Subject: Extract Number from Fields - SQLReply | Reply to Author | Forward | Print | Individual Message | Showoriginal | Remove | Report AbuseI am new to the SQL world, and I am trying to come up with a scriptthat will extract only the numerical data from a column of varchardata type . There is not a pattern to the data entered, except thatthe data thatI am looking to extract is a three digit number. If someone couldpoint me in the right direction that would be great.Thanks in advanceKR
View 5 Replies
View Related
Feb 17, 2008
I have a database which contains time series data (historical stock prices) which I have to search for patterns on a day to day basis. But searching this historical data for patterns is very time consuming not only in writing the complex t-sql scripts but also executing them.
Table structure for one min data:
[Date] [Time] [Open] [High], [Low], [Close], [Adjusted_Close], [MA], [DI].....
Tick Data:
[Date] [Time] [Trade]
Most time consuming queries are with lots of inner joins. So for example if I have to compare first few mins data then I have to do inner join like:
With IntervalData AS
(
SELECT [Date], Sum(CASE WHEN 1430 = [Time] THEN [PriceRange] END) AS '1430',
Sum(CASE WHEN 1431 = [Time] THEN [PriceRange] END) AS '1431',
Sum(CASE WHEN 1432 = [Time] THEN [PriceRange] END) AS '1432'
FROM [INDU_1] GROUP BY [Date]
)
SELECT [Date] ,[1430], [1431], [1432], [1431] - [1430] As 'Range' from IntervalData
WHERE ([1430] > 0 AND [1431] < 0 AND [1432] < 0) OR ([1430] < 0 AND [1431] > 0 AND [1430] > 0)
------------------------------------------------------------------------
select ind1.[Time], ind1.PriceRange,ind2.[Time], ind2.PriceRange from INDU_1 ind1
INNER JOIN INDU_1 ind2 ON ind1.[Time] = ind2.[Time] - 1 AND ind1.[Date] = ind2.[Date]
where (ind1.[Time] = 2058) AND ((ind1.PriceRange > 0 AND ind2.PriceRange >0) OR (ind2.PriceRange < 0 AND ind1.PriceRange < 0))
ORDER BY ind1.[Date] DESC;
Is there anyway I can use Sql 2005 Data mining models to make this searching faster?
View 1 Replies
View Related
Dec 16, 2007
Hello there,
Don't know if this is the right forum to be asking this, but I'll give it a try...
I'm relativelly a beginner in SQL Server and T-SQL in general. The problem I'm trying to solve is the following:
The big picture is that I have data coming from different data sources which I need to store on a database for later reference. Each data source might have a different set of measurements. For example, data source 1 might log Pressure and Humidity while data source 2 logs Pressure and Temperature. Once the data is present on the DB, the users can go ahead and retrieve data for a given [datasource/measurement/time interval] to generate reports or charts.
My implementation so far consists of two tables: series_info and series_data. series_info holds general information for a given series of measurements for a given data source (Pressure for data source 1, Pressure for data source 2, Humidity for data source 1 and Temperature for data source 2, in our example). Each series has a bigint index as primary key.
The table series_data contains all data relative to the series from series_info. Each piece of data has a bigint as a primary key, an associate time (which is always crescent) and a foreign key to the series it represents (in series_info).
Alright, everything is cool so far. However, whenever a user wants to retrieve data for given [data source/measurement/time interval], this takes very long, since all data is interposed in series_data and for every search it's necessary to find where the desired data actually lies.
One obvious solution for this would be to dynamically create a new table to hold the data for each series, but that would just make my database disorganized, since there would be thousands and thousands of tables.
Another thing that comes to my mind is to create a table with information of where lies the data for a given [data source / measurement] for given dates. So when the user requested data for a given [data source/measurement] between, say, january and february, we would first look at this intermediate table and find out that the data lies between indexes 1000 and 2000 on the series_data table, so the next SELECT command to series_data would already contain a restriction like WHERE index>=1000 and index<=2000. This should probably improve the speed of retrieval.
What do you guys (or girls) think? Maybe there's simply a classical solution for such a case.
Thanks in advance!
View 6 Replies
View Related
Oct 22, 2015
I need to export some Database data into a text file. My Query looks like this:
SELECT Category1, Category2, Category3
FROM dbo.tbl1
WHERE Category1 = 'JP-4'
AND Category2> 4;
This works fine to get the data, however there is some html formatting in the table entries such as
`<p>,</p>,
,</br>` etc.
So ideally I need to remove those when exporting the data to the text file. I've tried to do it with a simple replace query but that didn't work. I've also got an issue with line splits and would need to remove the ( ).
The Data format is something like this:
Category1: JP-4
Category2: 4
Category3:<p>Neque porro quisquam est qui dolorem ipsum quia dolor</p> <p>amet, consectetur, adipisci velit</p>
Category4:<p>Neque porro quisquam est qui dolorem ipsum quia dolor</p>
I got it to work like this with the replace function:
SELECT REPLACE(REPLACE("PHOTOGRAPHS",'<p>',''),'</p>','')
FROM dbo.khia_tbl
WHERE Category1= 'JP-4'
AND Category2> 4;
But the issue is that I've got 15 columns in total and that I need to do it for several different tags for each column so
,
</br>,
as well as "" and different spaces so that would be a lot and I thought there must be a better/more efficient way of doing it...
View 1 Replies
View Related
Nov 29, 2006
menardo writes "Hi there!
I'm a very newbie in SQL programming. Can anybody help me how do I start to learn scriptings.
Can you give me the process or scripts on how to export it??
Thanks in advance.
-menardo"
View 2 Replies
View Related
Jul 17, 2007
I am going through the data mining web control viewer tutorial and its going great. I have been able to build and setup the viewer. The problem I am having is when I publish the site out to my web server, it gives me the following error:
Code Snippet
Error: Either the user, <domain><computerName>$, does not have access to the prospectDataMining database, or the database does not exist.
When I debug this on my local machine via Visual Studio 2005, it works GREAT! It is just when I publish the site to the web server.
I have a dedicated SSAS server along w/ a dedicated web server. To test, I published the site to the SSAS server to see if it was a connection issue. I received the same error w/ a different <domain><computerName>$.
I looked at trying to put in the optional connection info for the dataMining html tree viewer properties... but apparently dont know how to do that properly. I also checked the IIS directory security and enabled Integrated security.
What am i doing wrong? ANY help is much appreciated.
Thanks,
Cameron
View 3 Replies
View Related
Jan 30, 2007
I have a comments field in database table which holds all html data, like bold chars and underline and with fonts etc.
Is it possible to show that data in the report or do i have to extract the data only by excluding all html / font tags etc.
Please help thank you very much.
View 1 Replies
View Related
Jul 20, 2005
I am new to database programming and was curious how others solve theproblem of storing encrypted in data in db table columns and thensubsequently searching for these records.The particular problem that I am facing is in dealing with (privacy)critical information like credit-card #s and SSNs or business criticalinformation like sales opportunity size or revenue in the database. Therequirement is that this data be stored encrypted (and not in theclear). Just limiting access to tables with this data isn't sufficient.Does any database provide native facilities to store specific columns asencrypted data ? The other option I have is to use something like RC4 toencrypt the data before storing them in the database.However, the subsequent problem is how do I search/sort on these columns? Its not a big deal if I have a few hundred records; I couldpotentially retrieve all the records, decrypt the specific fields andthen do in process searches/sorts. But what happens when I have (say) amillion records - I really don't want to suck in all that data and workon it but instead use the native db search/sort capabilities.Any suggestions and past experiences would be greatly appreciated.much thanks,~s
View 10 Replies
View Related
Oct 8, 2014
I have someone who is sending me .htm documents, with a table in them, and I was wondering if there is a way to import the data from those tables into a SQL table, probably using an SSIS Package.
View 4 Replies
View Related
Jun 8, 2006
Hi.
I've got a question regarding record inserts via a from (textbox, multiple lines) on a web page.
I'm using a textbox within a form to enter data for a record. When this box contains several lines and the data is inserted into the database (SQL2005 Ent.) it separates each line with a character similar to a square (probably a line break symbol or something). This is all fine for storage, but retrieving the data and displaying it on a web page, just displays one long line, not at all how I entered it in my textbox.
Is there a way to "replace" all of the line breaks with.. say.. "<br>", so that it displays more correctly? Or perhaps I need to implement a HTML-based editor on my form (I've seen them out there, but should this really be necessary?).
I'm using ASP.NET (*.asp pages) and VBScript..
Not sure if this is the right forum for this, so please move if necessary.
Best regards,
Egil
View 1 Replies
View Related
Apr 21, 1999
I heard there is a way to publish the results of SQL 7 jobs to HTML files.
has anyone tried this
View 1 Replies
View Related
Oct 19, 2001
I would like to know if someone has any idea on how to make a "<select></select>" tag hidden. for a textbox it's simply:
<input type="hidden" id="textCustom2" name="textCustom2" value>.
Is there such a thing for options? a javascript perharps?
thanks.
View 1 Replies
View Related
Feb 9, 2006
Hi
I am very new to sql...
I want to export the results of this query
select count(*) from mail where Completed='c'
to an html file.
Can this be done?
Thanks
Terence
View 2 Replies
View Related
Apr 14, 2008
So I have a stored procedure that returns rows that look similer to this
Code:
<a href="~/Manage/ManageVersion.aspx?viewstate=MTgwNywzMTc0LDguOSAgICAgICA=">DPF-13</a>
Unfortunatly when it is bound to the gridview it seems to convert the value to HTML safe.
The value it prints on the page is
Code:
<a href="~/Manage/ManageVersion.aspx?viewstate=MTgwNywzMTc0LDguOSAgICAgICA=">DPF-13</a>
Hit quote to look at the actual values
How can I fix the output to the gridview to print the actual link and the the html safe value?
Can I accomplish this in SQL or am I going to have to do it all in the c# code (which will be a less clean solution and alot more work).
tia
View 1 Replies
View Related
Oct 25, 2007
hello,
Im not really sure if this is the right thing to do. But i want to save a copy of the html from my invoice to sql so that i can keep a history of the invoices in case their are changes done to them. Anybody know what would be the best way to do this?
Thank you,
~ Mauricio
View 3 Replies
View Related
Nov 29, 2007
Is anyone using a SP or Trigger to Create a HTML formated e-mail and send it useing DBmail?
If so could I see a sample of the code?
Jim
Users <> Logic
View 4 Replies
View Related
Feb 17, 2006
http://www.testyourabilities.com/it/IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
View 2 Replies
View Related
Jul 20, 2005
Hi!I want to write a function or stored procedure such that it will useADO2.6 or better so I can use the XMLhttpServer.When this function is invoked it will execute a URL and gather thehtml code and store it in the Db.So one thought would be how can I write a Stored Proc or function inSQL to instantiate a DLL and use it? In this case I want to use ADOdll and use the xmlhttp functions. I pass some parameters to this dlland it will return data and the SP will store the results in the DB.Thanks
View 1 Replies
View Related
Apr 29, 2008
Hello, If HTML is written as textbox value, this one is not interpreted in viewer as HTML but in text (tags displayed). Is it possible to apply HTML style (bold, underline...) in a same zone please ?
View 1 Replies
View Related
Jun 20, 2007
I have a report which uses for one of its columns, a text field that contains HTML formatting. FreeTextBox is used to enter the rich-text data and is bound to a dataset, in this type of format : <BR><B>the title</B><P>Some stuff...</P>. Needless to say, when this prints out it does not look very useful. Is there any way to embed a rich-text type field in a report?
View 1 Replies
View Related
Apr 2, 2007
Hi,
Does anyone know if it's possible to read data from an HTML page using SSIS.
Thanks
View 1 Replies
View Related
