|
The MessageBoard fairies strike again!
If I change the SQL to the much simpler:
"SELECT * FROM Components WHERE (Components.[Database Number])=15 AND Components.[Component Key] NOT IN (SELECT [Nozzle Key] FROM Nozzles)"
it all works.
|
|
|
|
|
Hi!
I've to read each name in a field from a table and do some string mangling and update each name into another field. I've to query the database from C++. I'm using SQLite. I used the following code to do this:
SQLManager SQLdb;
SQLdb.init("../../data/config/playerDatabase.db");
array<stringc> ctyLst = SQLdb.Query("Select DISTINCT Team from Test ORDER BY Team DESC");
array<stringc> playerLst;
core::stringc queryStr,updateTest;
for(u32 i = 0; i<ctyLst.size();i++)
{
queryStr = L"Select Name From Test WHERE Team ='";
queryStr += ctyLst[i].trim();
queryStr += L"'";
array<stringc> playerTmpLst;
playerTmpLst = SQLdb.Query(queryStr);
for(u32 j = 0; j < playerTmpLst.size(); j++)
{
playerLst.push_back(playerTmpLst[j].c_str());
}
}
I'm doing string mangiling an updating as follows:
for(int j = 0; j<playerLst.size(); j++)
{
updateTest = L"UPDATE Test SET MangledName ='";
unsigned int t = time(NULL);
srand(t);
playerLst[j] = playerLst[j].trim();
int index = playerLst[j].findLast(' ');
stringc subStr1 = playerLst[j].subString(0,index);
stringc subStr2 = playerLst[j].subString(index+1,15);
subStr1.append(" ",1);
subStr1.append(swapChars(subStr2).c_str(),subStr2.size());
updateTest += subStr1.trim();
updateTest += L"'";
SQLdb.Query(updateTest);
Sleep(10);
cout<<subStr1.c_str()<<endl;
t++;
}
While printing the result to a file, it prints correctly. But only the last name in the array is updated to all the records in the field. How to Select a single name at a time and do the string mangling and update the name to the database?
|
|
|
|
|
One normally uses a WHERE clause to specify which record(s) get updated.
Remarks:
- what is the purpose of Sleep(10)?
- what would happen if a player's name contained a quote?
- why don't you use SqlParameters instead of string concatenation?
|
|
|
|
|
plzz give me the code for inserting the data in the database through msAccess DataBase.
|
|
|
|
|
No problem[^].
You can skip all the CodeProject articles, since I trust you've read them before.
|
|
|
|
|
On a side note... I couldn't remember a particular .net class this week so I went on a Binge and found not only a CP article, but one of mine!
|
|
|
|
|
and was it satisfactory?
|
|
|
|
|
Ohhh yeahhh. Most times I need to use the particular class I simply pull up that article anyway. This time I didn't because I was at work. (I try not to access CP from my new job.)
|
|
|
|
|
I hate when that happens.
|
|
|
|
|
Pay no attention to Luc. Try this link instead[^].
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
further reading is available here[^].
|
|
|
|
|
Hmmmm, cheap competitor in town, huh.
|
|
|
|
|
what do you mean?
Is Google expensive and Bing cheap?
If yes send codez to proove it!
I bug
|
|
|
|
|
Troll
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You guys got it all wrong.
Except maybe for Mycroft Holmes.
He wants codez for inserting the data in the database through the database
No codez needed for that. Just quick fingers
I bug
|
|
|
|
|
Hi,
I'm a freelance developer, I have a database application i developed for a client. I have deployed the database on my client server.
My client uses the builtin\administrator to login into the database server.
My Question is I will like to protect my database from the builtin\administrator from accessing it, because i don't want them to access it from the backend. am a novice to sql server security. Note: its on Sql Server 2000. How do i protect my Database?
|
|
|
|
|
saltcode wrote: client uses the builtin\administrator
Start by changing that (and its password). Give the client his own username, then apply whatever security you choose.
Ideally you'd be using integrated security.
|
|
|
|
|
|
i have a file_no field in my accounting_payment table and i want to run a query to see the frequency of every file, means how many times every file is listed in the table?
|
|
|
|
|
use the count() and group by operators
Select count(*),file_no from accounting_payment group by file_no
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But I also want to assign the Top number#? For example
Select TOP 5 count(*), file_no from accounting_payment
But to show the TOP (frequency) not the Top (position)
Similarly I want to do it for the amount, for example:
Select TOP 5 max(amount_paid), file_no from accounting_payment
|
|
|
|
|
Do some research in BOL into rownumber() and partition. Using these and a sub select you can get the top N records grouped by yourcriteria and ranked according to your sort requirements.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
May be you can do like this,
SELECT TOP 5 FREQUENCY, FILE_NO
FROM
(SELECT COUNT(*) FREQUENCY, FILE_NO
FROM ACCOUNTING_PAYMENT
GROUP BY FILE_NO) A
ORDER BY FREQUENCY DESC
|
|
|
|
|
I'm doing a bit of searching about these ID's and came across this gem from an Oracle FAQ[^].
If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be
sure who they really are. With terminals, you can rely on operating system passwords, with
Windows, you cannot.
In the absense of an example, how does one intrepret this. Windows passwords are unreliable? What could someone possibly mean by that?
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
The author was a nix nerd and nothing windows based has any validity. I wonder when that was written
I assume the OPS$ id is like the sa in sql server and should not be available to users. Still the statement as such does not make sense.
"If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user."
This seems to imply they do not trust the authentication of the remote OS, surprise, surprise.
Never underestimate the power of human stupidity
RAH
|
|
|
|