|
Dear Sir and Madam
I create a webboard.
After User Post, the message will be added to the table in Sql database.
My webboard allow user to post html tag.
This is the example of my problem.
when search the row that contain 'td',
the row that contain '<td>hello</td>'
and 'hello td' are returned.
Do you know how to return the the row that contains 'hello td' only?
Please give me an idea.
Thank You.
Sorry for bad English.
|
|
|
|
|
god4k wrote: Do you know how to return the the row that contains 'hello td' only?
SELECT * FROM mytable WHERE myfield = 'hello td'
But this doesn't make sense. 'hello td' isn't valid HTML markup.
Is this definitely what you want to do?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: But this doesn't make sense. 'hello td' isn't valid HTML markup.
Is this definitely what you want to do?
Your guess is probably as good as mine...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
You don't understand me.
Please see this example.
When user search the rows that contain 'a' in webboard,
only the following row should returend.
1. I see a dog run
2. give me my bag
3. I will pass this message on
4. .....
5. .....
and the following row should not returned.
6. <a href="codeproject.com">codeproject</a>
7. <a href="link.com">hello</a>
8. .....
9. .....
Please give me any idea.
Thank You.
|
|
|
|
|
You would have to perform some pattern matching, checking whether the string of characters formed part of a tag. T-SQL pattern matching doesn't have the capability to do this. However you could write a CLR stored procedure and invoke the regular expression functionality in the .NET framework to perform the match.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
delete from table1,table2 where uid='abc'
the conditon ( where uid='abc') is same for both table.
that uid field are present in both table.
I got error that Comma(,) should not be there
is there any other syntax that can work?
|
|
|
|
|
You can only delete from one table at a time. You'll need to write two statements.
Many providers can handle multiple statements in the same batch.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
You can only delete from one table at a time. If you want to delete from more than one at a time, using only one command, then try using a stored procedure that executes the individual table deletes in one call.
---modified
If there is a relationship between table1 and table2 with uid, then you could always setup a cascading delete based on that field.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".
|
|
|
|
|
sami_pak wrote: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".
Did you try Googling[^] for information?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi friends I want to create a oracle Stored Procedure that stores data in table Employee_Info which is in a dataBase that is named Garments. But I d not know how to create a stored procedure that stores data. Oh! I want to access those procedure using C# & Oracleconnection. Can any one tell me how can I do that? Plz It will really help me a lot.
|
|
|
|
|
Saiyed Alam wrote: But I d not know how to create a stored procedure that stores data.
Then maybe you should buy a book and learn how to do it. Or read the online Oracle documentation. Seriously, basic questions like this aren't suitable for forums. You should at least learn the fundamentals of the technologies you are using.
Saiyed Alam wrote: Oh! I want to access those procedure using C# & Oracleconnection.
The System.Data.OracleClient namespace contains classes for working with an Oracle database in .NET. I suggest you read the MSDN documentation to learn how to use it.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Google or buy a book 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
hi there,
i have a question that i used this query to clear the LOG file of my database :
DBCC SHRINKDATABASE ('MYDATABASE', 0,TRUNCATEONLY)
and when i executed it, it reduced the size of all 4 files(.ldf, .mdf, Static_Data, Dynamic_data)
i want to execute this query when my application closed.
so i wanna know that, i do everything correct? and there will be any lack of something in future except of LOG FILE ?
im afraid that it reduced the size of .mdf file...
thanks and hope for good replies
Becoming Programmer...
|
|
|
|
|
i have three textbox in the windows application forms.. i ve created database with 3 columns fields in access.. i want to fetch that data in the respective 3 textboxes. i want the code in c#
|
|
|
|
|
mon***z wrote: i want the code in c#
I want doesn't get 
Have you tried to solve the problem yourself? There are plenty of resources available online which explain how to connect and retrieve data from an Access database. Are you too lazy/incompetent to search for it?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: I want doesn't get
Nice. I like it.
|
|
|
|
|
That's what I was taught, growing up in Doncaster. It's grim up north 
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
I have a table (call it Part) listing our products and their prices. Prices change every once in a while and my boss made a new entry for each product every time its price changed. A simplified illustration:
<br />
ID Name PriceEffectiveDate Price<br />
---- ---- -------------------- -----<br />
1 Shoe 1-1-2006 $1<br />
2 Glove 1-1-2006 $2<br />
...<br />
41 Shoe 1-1-2007 $2<br />
<br />
(etc)<br />
(I should mention there is no priceEffectivedate column, he used a col that was intended for something else!)
Obviously this is horrible design, so I created a second table (PartPrice) with columns partID,Price,and EffectiveDate.
Now I need to remove the later entries for each product, but keep the original ones, and make the corresponding entries in the PartPrice table... I'm not an experienced SQL developer, anyone have any ideas? There are two things to make the problem simpler: Every part has a unique name, and the amount of parts have stayed constant, so each part has its entries a constant amount apart (i.e. Shoe will have ID's 1, 41, 81; glove will have 2,42,82 etc)
Any hints/tips/ideas?
|
|
|
|
|
Assuming SQL Server -
I would suspect that the queries would look something like these:
INSERT INTO PartPrice
(
partID,
Price,
EffectiveDate
)
SELECT
(SELECT MIN(ID) FROM Part WHERE Name = p.Name) AS ID,
Price,
WrongDateColumn
FROM
Part p
DELETE
Part
WHERE
PartId NOT IN (SELECT MIN(ID) FROM Part GROUP BY Name)
|
|
|
|
|
I'm trying to write a generic Ling to SQL GetObjectById() method for getting a data object from the database based on a primary key id value, so that instead of having to write...
MyDataContext dataContext = new MyDataContext();<br />
Product myProduct = dataContext.Products.SingleOrDefault<Product>(p => p.Id == productId);
...I instead write...
Product myProduct = Product.FromId(productId);
...which I think is much cleaner.
Now I could simply write individual 'FromId' methods in each mapped data class, but where's the fun in that. So I tried to write a more generic one size fits all method for doing this and came up with the following...
public abstract class BaseTable<T>
{
public static T FromId(int id)
{
MyDatabaseDataContext dataContext = DatabaseContextHelper.GetDatabaseContext();
StringBuilder sql = new StringBuilder();
sql.Append("SELECT ");
MetaTable metaTable = dataContext.Mapping.MappingSource.GetModel(typeof(TopicDatabaseDataContext))
.GetMetaType(typeof(T)).Table;
foreach (MetaDataMember dm in metaTable.RowType.DataMembers)
{
if (dm.DbType != null)
{
sql.Append(dm.MappedName).Append(",");
}
}
sql.Remove(sql.Length - 1, 1);
sql.Append(" FROM ").Append(metaTable.TableName).Append(" WHERE Id = ").Append(id);
return dataContext.ExecuteQuery<T>(sql.ToString()).FirstOrDefault<T>();
}
}
I need to ensure all the mapped data classes extend BaseTable<T> but this does seem to work, however, I was wondering if this was the best way of doing this. Wouold this method create any problems, and is there a more efficient way of doing it.
I know this is probably overkill just so I can go from dataContext.Products.SingleOrDefault<Product>(p => p.Id == productId) to Product.FromId(productId) but it's just for a bit of fun, I enjoy the challenge.
Many thanks!
|
|
|
|
|
Nothing wrong with that. Diamond Binding puts these static methods in our own class heirachy, and provides an optional base class that wraps them.
Most people choose to use the base class for convenience (its easy, and the 'Inherit from ActiveRecordBase' defaults to checked in the UI) - but some people don't like to 'burn a base class' just to get a bunch of methods that don't really have to be there.
Linq might be cool, but theres no point using it for a simple get by ID. To be honest we haven't had a lot of demand for it - OQL and Expressions seems to handle most queries people would need - and most queries are either .FindById(), .FindByProperty() or .FindAll()
|
|
|
|
|
This is all well and good, but could you consider buying some advert space here at CodeProject? You seem to spend an awful lot of time telling us what your product does (and I assume you're not giving it away for free). If it's that good, pay for some space rather than posting replies to questions that (in effect) say don't use this, buy our product and use it instead.
|
|
|
|
|
We do look at our traffic analytics fairly often and would advertise here if the projected ROI figures changed. At the moment we're happy letting codeproject folks download the free personal edition.
|
|
|
|
|
Hi,
I have a stored procedure that is basically as follows:
SELECT ColumnA, ColumnB, ColumnC
FROM TableA
WHERE
(@ValueA IS NULL OR ColumnA = @ValueA) AND
(@ValueB IS NULL OR ColumnB = @ValueB) AND
(@ValueC IS NULL OR ColumnC = @ValueC)
So each of the input values can either have a value or is null. If it has a value it has to be included in the filter, otherwise there will not be a filter on that column.
Let's say that I have 3 indexes: 1) ColumnA, 2) ColumnA and ColumnB, 3) ColumnA and ColumnC
Now on the first run of this sproc, if let's say columnA and ColumnB have values, it will use index 2. On the next runs it will continue using index 2, even if now ColumnA and ColumnC have values (thus actually it should have used index 3).
I know that one can tell SQL what index to use using WITH(INDEX XXXX) but can the use of an index be conditioned, or do i have to write 3 different stored procedures?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
