Database

FirstPrevNext

Re: How to centrally place a Database to share among internal windows form application and also to web application? Aghosh Babu27-Apr-09 19:42 Aghosh Babu 27-Apr-09 19:42  oh its really great to know that some one is hear just to count the questions and for any other --- Else.. I thought i can get some codes without doing any work at all..lol...according to your valuable stupid sugestion i will do my work lol....!If you dont know the answer better dont reply to people..and i am bloody sure that i asked the question only twice, one in C# forum and other in database forum... C# forum people suggested me to ask there lol... read the posts before comment (do your work first )... Re: How to centrally place a Database to share among internal windows form application and also to web application? Mycroft Holmes27-Apr-09 20:01 Mycroft Holmes 27-Apr-09 20:01  Oops My apologies - I did not read follow the links to the questions. Never underestimate the power of human stupidity RAH [T-SQL] How to retrieve records from start index and count Hristiyan24-Apr-09 10:31 Hristiyan 24-Apr-09 10:31  I'm searching for logic which will help me to retrieve table records based on "start index" parameter and parameter which specifies the returned records count. Example: dbo.Records num 1 2 3 4 5 SELECT num FROM dbo.Records will return 5 records. I cant find a function or something other which will help me retrieve the following logic input params : @startIndex = 2 , @recordsCount = 2 so when i perform the select statement to retrieve the 2 records (3 and 4) If there is no answer with an exact function, is there a wordaraund ? Please help. Regards Hris. Re: [T-SQL] How to retrieve records from start index and count David Mujica24-Apr-09 10:55 David Mujica 24-Apr-09 10:55  try this ... select top @recordsCount num from dbo.records where num >= @startIndex You may also be able to use something like this ... select num <br /> from dbo.records <br /> where (num >= @startIndex) and (num <= @startIndex + @recordCount) I haven't tested it, but it is probably close. How to get size of Image Stored in Database? sumit703424-Apr-09 1:57 sumit7034 24-Apr-09 1:57  Hii I am storing images in my sql server 2005 database. Is there any sql query or any other way to get the size of the image stored in my table? Thanks in Advance Re: How to get size of Image Stored in Database? sumit703424-Apr-09 2:07 sumit7034 24-Apr-09 2:07  SELECT DATALENGTH(imagecolumn) FROM sometable Need SQL query correction ! soulidentities23-Apr-09 22:44 soulidentities 23-Apr-09 22:44  Hi ppl Take a look a simple query. String sql = (@" SELECT Ins_ID, Ins_Nm FROM Institution_Profile WHERE Ins_ID = '{0}' ", combobox.Text); If the query above works perfect without no erro then why the below query is not working. String sql = (@" SELECT Ins_ID, Ins_Nm FROM '{0}' WHERE Ins_ID = '{1}' ", tableName.text, Ins_ID.Text); Anybody ans this pls Thanks Re: Need SQL query correction ! Henry Minute24-Apr-09 0:27 Henry Minute 24-Apr-09 0:27  It might be that you have made a typo. Try changing tableName.text, Ins_ID.Text to tableName.Text, Ins_ID.Text. But on the other hand it could be anything. If you ask a question about an error, tell people what the error is and which part of the posted code gives the error, otherwise most members will ignore you. Also please don't use text speak in your posts. We older folks don't understand it and once again you are cutting down the number of people willing to help you. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” Re: Need SQL query correction ! i.j.russell24-Apr-09 1:58 i.j.russell 24-Apr-09 1:58  Remove the single quotes from the tablename: FROM '{0}' becomes FROM {0}. Re: Need SQL query correction ! soulidentities24-Apr-09 3:49 soulidentities 24-Apr-09 3:49  Fantastic....Worked Thanks dude Re: Need SQL query correction ! Colin Angus Mackay24-Apr-09 7:32 Colin Angus Mackay 24-Apr-09 7:32  This continues to be vulnerable to SQL Injection attacks. *Developer Day Scotland - Free community conference Delegate Registration Open Re: Need SQL query correction ! i.j.russell24-Apr-09 9:56 i.j.russell 24-Apr-09 9:56  To paraphrase dialog from the film 'Riddick': The CPer in me says that he has only just started learning SQL and nobody has given the little bit of help that he needs to continue with his project. However, the pedant in me says that I should tar and feather him for not following established best practice at all times; Ignorance of the Law is not a defence. Re: Need SQL query correction ! Colin Angus Mackay24-Apr-09 7:31 Colin Angus Mackay 24-Apr-09 7:31  You should be using parameterised queries rather than injecting values into a SQL Statement. This is easy for data elements like the ID value, but slightly more difficult, yet doable, for the table name. As it stands your code is vulnerable to attack. *Developer Day Scotland - Free community conference Delegate Registration Open Need to retrive attribute Name Satish - Developer23-Apr-09 20:59 Satish - Developer 23-Apr-09 20:59  How to retrive attribute Name <names> <zipcode zc="*"> <rule rll="%LEIN"> Here the thing is in some Names tag the attribute of Rule is RL or RLL. <rule rll="%LEIN"> <rule rl="LE%"> I am getting error at bold line below. Bcz, i mentioned direcly RLL. If RL exists as attirbute then getting error. how to get attribute name? XmlNodeList NameList = doc.GetElementsByTagName("Names"); foreach (XmlNode node in NameList) { XmlElement nameElement = (XmlElement)node; foreach (XmlNode xnode in nameElement) { XmlElement childElement = (XmlElement)xnode; if (childElement.Name.ToLower() == "rule") { if (childElement.HasAttributes) strrule = childElement.Attributes["RLL"].InnerText.ToLower(); } } } G. Satish Don't want to give stored proc to client? devvvy23-Apr-09 20:51 devvvy 23-Apr-09 20:51  Don't want to give stored proc to client? What are your options if there is one? Thanks dev Re: Don't want to give stored proc to client? Ashfield23-Apr-09 20:58 Ashfield 23-Apr-09 20:58  devvvy wrote: Don't want to give stored proc to client Then don't Have you considerd encrypting it? Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) devvvy23-Apr-09 21:02 devvvy 23-Apr-09 21:02  I didn't know you can encrypt them? (stored proc in db owned by client) dev Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) Ashfield24-Apr-09 1:25 Ashfield 24-Apr-09 1:25  You can in SQLServer, don't know about the others, but why worry if its in their database? Have you hidden some sort of malicious timebomb code in the proc? Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) devvvy24-Apr-09 2:50 devvvy 24-Apr-09 2:50  timebomb? no, just good code i plan to charge for money (as off-the-shelf-app) I am evil yes i actually want to make money out of software sorry. dev Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) Eddy Vluggen24-Apr-09 4:23 Eddy Vluggen 24-Apr-09 4:23  Best option is to not give the password to the user. If the database is his/hers, then you should behave like a good guest within that database. They're not going to put you out of business by copying your sprocs. People don't bother with that kind of thing, they just come here to ask for the code I are troll Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) devvvy24-Apr-09 15:12 devvvy 24-Apr-09 15:12  haha that's so true though dev Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) Ashfield24-Apr-09 8:19 Ashfield 24-Apr-09 8:19  In which case why not just put your business logic in the application - which generally they will be able to de-compile anyway Its a constant battle to keep your code secure, but in my (25+ years) experience if you are selling to proper businesses they will respect your licence agreement. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) devvvy24-Apr-09 15:11 devvvy 24-Apr-09 15:11  becuase it's more optimized in stored proc dev Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) Ashfield25-Apr-09 7:35 Ashfield 25-Apr-09 7:35  Seems you are stuck then. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP Re: Can you encrypt stored proc? (M$SQL, MySQL Sybase and Oracle?) devvvy25-Apr-09 10:36 devvvy 25-Apr-09 10:36  thanks anyway, just checking to see if I've missed anything dev

Last Visit: 31-Dec-99 18:00     Last Update: 10-Jun-24 13:52 Refresh ᐊ Prev1...861862863864865866867868869870 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.