- Strength to Increase Rep
- +10
- Strength to Decrease Rep
- -2
- Upvotes Received
- 67
- Posts with Upvotes
- 62
- Upvoting Members
- 50
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
- Interests
- Woodworking
440 Posted Topics
 | Welcome kutta_vin, I really can't understand anything of your code and of that you are asking for. Perhaps you can give a small sample, for example on how the output of your select statement should look like (you can reduce it to the essential facts only). krs, tesu  |
| | To compute the median of discrete values continually read in, all values must be stored. (contrary to simple average where only running sum, current value and number are necessary). Also the list from where the median is to be taken must be sorted. So these steps are necessary to get … |
| | Hi There is a function LAST_INSERT_ID() what returns the last-created auto-increment value. So first insert parent data what creates a new auto-increment ID. Then insert row in child table where LAST_INSERT_ID() function is put in the values list of the insert statement, for example: [code] -- first insert parent row … |
| | Re: whats .org 100h? ORG (abbr. for ORiGin) is an assembly directive (not an instruction). It defines where the machine code (translated assembly program) is to place in memory. As for ORG 100H this deals with 80x86 COM program format (COMMAND) which consist of only one segment of max. 64k bytes. 100H says that …  |
| | [QUOTE=Noxes;629405]One more question, does anyone know how to get Dev C++ to stop deleting the next character space when using space or typing something in? I want it to space over instead of delete and write over.[/QUOTE] There is a toggle key on your keyboard labelled 0 INS. If you … |
| | This is a very common task. Seems to be appearing here every other week. If i recall correctly, about two years ago or so i posted a compact solution to this problem (Besides mine there are lots of solutions given by other people too). So seaching the forum won't be …  |
| | Hello Greetings from the hood. PL/SQL is Oracle's extention to SQL. It is similar to PSM the standardized ANSI SQL programming language. Actually many of the new features of PSM standardized in 1999 and 2003 were derived from PL/SQL. In my opinion, If one plans to work in the field … |
| | Such wrong result is quite usual, it's a painful mysql gotcha! In your query [CODE]SELECT DISTINCT mess_id, id, message, MAX(date_sent) as date_sent FROM mail GROUP BY message_id[/CODE] [B][U]ALL[/U][/B] columns not being parameters of aggregate functions (max(), sum(), count() etc.) must always be enumerated in GROUP BY clause. There is no … |
| | Hello First, variables must be initialize before using them, e.g. smallest has been defined but never been initialized. So put these two lines just before your while loop: [CODE]fin >> next; smallest = largest = next;[/CODE] Second, do not use fin.get(next) for this reads one char only, and not an … |
| | To search for strings in ascii files there exists the amazing Knuth–Morris–Pratt string searching algorithm. It is faster than anything. Try it, and you will be delighted.  |
| | Hi scapu, Don't lose heart! Pick out an algorithm, for example Newton's method seems to be rather comfortable to compute the square root of a given number. This method is also identical to the ancient method of the Babylonian to draw the square root of a given number, it s … |
| | Hi like the beautiful ladies you are planning to manage there could be found so beautiful solutions on that[URL="http://www.databaseanswers.org/data_models/dating_sites/index.htm"] web site[/URL]. -- tesu |
| | Hello arbazpathan, primary-key property is not required for table "vendor" if its "vendor_name" is already declared to be unique. If so, you can easily put a foreign-key constraint on table "purchase_order" referencing vendor(vendor_name) by means of "create table purchase_order(...)" or by "Alter table purchase_order ..." if table "purchase_order" already exists. …  |
| | Re: string reverse hi shknahs, you may also try this: [code=cpp] void rev_str(string str,int n) { if(str[n]!='\0') rev_str(str,n+1); cout<<str[n-1]; } // result: shknahs [/code] krs, tesu |
| | Hi pushl is a 32 bit instruction (suffix l = long = 32bit). So the assembly is wrong for 64bit machines, except you do special compiling and linking with gcc and ld. You need to tell the compiler and the linker that you would like to get 32bit-code. For the … |
| | Hi tucanoj is right, I agree with him. There is an another solution [CODE]void print4(int pme){ if (pme > 0) print4(pme-1); printf("%d,",pme);}[/CODE] which saves some if-branches. What's hidden? Do you mean how does recursiveness function? When print4 is called with parameter pme, say pme is 3, 3 is pushed on … |
| | Here is some code for testing palindromes: [CODE]bool isPalindrome(string s) {int i,l=s.length(); for (i=0; i<l/2; i++) if (s[i] != s[l-i-1]) return false; return true;} int main(int argc, char *argv[]){ string pal[] = {"able was I ere I saw elba", "Able was I ere I saw Elba", "Napoleon I noelopaN"}; for … |
 | Hi tuse How are you? [QUOTE=tuse;635983]Thanks a lot. Didn't see the 'mysql' database.[/QUOTE] Well, if you had access to grant table mysql.user you would have also been able to SELECT User, Password FROM mysql.user. You got it? Yes, you would be able to hack that mysql database. So it's a … |
| | Hi tanha It is always a good idea to start database design with an entity-relationship model. Depending on whom you design the ERM for, there are more or less flaws present. First, relationship student many-to-many dependent allows that a student would have many mothers and fathers. This impossibility can be … |
| | Just out of curiosity: Is there also an error message or faulty behavior of that code? Supposing your update and subselects are correct, I would replace END; by END | for you have chosen delimiter | -- tesu  |
| | hi mertucci, are in doing data modelling? Superkey is any subset of attributes that uniquely identifies the tuples of a relation. This subset need not be minimal, that is, one can remove some attributes from it and it is still uniquely identifying. If all redundant attributes are removed you get … |
| | Hi Error message is correct for book of [BOOK].[BookNo] isn't listed in from clause. Also join with bookpage which makes the many-to-many relationship is missing. [CODE]select b.bookno, a.pageno, PatientNo, FirstName, LastName from patient p join page a on p.pageno = a.pageno join bookpage bp on bp.pageno = a.pageno join book … |
| | Hi I don't have octave experience, I am using matlab. But I know there is a octave library for c/c++. Maybe this small [URL="http://wiki.octave.org/wiki.pl?CodaTutorial"]tutorial[/URL] helps a little. There is a further advanced [URL="http://wiki.octave.org/wiki.pl?CodaAdvanced"]tutorial[/URL]. -- tesu |
| | hi, you may google Joe Celko trees krs, tesu |
| | hi, ERM seems to be almost completed and sound. May I do some notes to the primary, foreign keys? For example entity friendlist has an artificial key idAddedFriendnum although the attributes (idPerson, FriendID) unequivocally identifies each entry. Therefore (idPerson, FriendID) should be primary key of friendlist. Both attributes must be … |
| | Hello You could try this: [CODE]select * from t3 where c1 || to_char(c3) in (select c1 || to_char(max(c3)) from t3 group by c1) order by c1, c2, c3;[/CODE] c1, c2, c3 are your three columns. The subselect generates a temporary key from grouped c1 column and the corresponding to_char(maximums of … |
| | Hi if you are only interested in start and end dates of leaves of a given month, you may check that month whether it is contained in those dates, as for example: [CODE]select To_Char(fromdt,'MM') as from_month, To_Char(todt,'MM') as to_month, leaveno from onleave ... etc ...[/CODE] If you like to get … |
| | Re: A/D two Hi Unfortunately, I don't know that microcontroller. However, there are things in common among mcs. As for example, how do you make your program wait until a/d conversion is completed? Usually you will get the low a/d result first, later follows high result. Therefore you need to wait until conversion … |
| | Re: Max query help hi what will happen if you omit "and CabRego='" & Me.cmbcabs.Text & "'" ? what should be the meaning of & ? Can you give all columns and their datatypes of table AccDtl? -- tesu |
 | Hi great! click on the SQL icon in the tool bar. the icon looks like a small magnifying glass or sometimes like a piece of paper with a pen (depending on the versions). I wish you good luck -- tesu |
 | There is a great book about C++ and GUI programming by [URL="http://books.google.com/books?id=tSCR_4LH2KsC&printsec=frontcover&dq=jasmin+blanchette+qt4&source=bl&ots=E60YkY14zh&sig=Z7lqDSjddD8LtsdCTKrtUWjylgQ&hl=en&ei=q8BvTP3bO5SbOIm_nLAL&sa=X&oi=book_result&ct=result&resnum=2&ved=0CBkQ6AEwAQ#v=onepage&q&f=false"]Jasmin Christian Blanchette[/URL] of trolltech dot com. His book, well, about 60 USD, also older versions are available, is great for learning QT (cute). Following his tutorial you will have learnt the very basics of GUI programming within ten …  |
| | Hi obviously is your storage engine not innodb, for example it could be myisam. If so, then foreign-key definitions are useless. Indeed, mysql allow you to define foreign keys, however they won't be processed, kinda everlasting bug or so! Except your are using storage engine innodb which know them. It … |
| | Hello again He, what about the 66 whales, could any of them be rescued? Hell yeah, '07:20:00' AND '15:19:59' evaluates to 1! I have never seen other database systems than mysql doing seriously boolean algebra on time strings! Though this be kind of compensation for the below rough violation of … |
| | Hello Greetings from the hood! Assuming you want to manage individual data for every occurrence and type of gaming machine you have installed on variuos stores you can do that by a one-to-many relationship between stores (table store) and indivudual data (table machinedata) and a many-to-many relationship between individual data … |
| | Hello If your problem is still existed, you may check whether TNSNAMES.ORA is in your directory path. There could also be discrepance between SQLNET.ORA and TNSNAMES.ORA. You could post both files here (make copy of them and replace your private data). Well, I am not an ora admin, just working … |
| | Hello srinivasan, below little code uses recursively called functions to determine min/max of an integer sequence. It works quicksort-like. I am not sure whether this is a useful solution to your problem. [CODE]int mini(int n, int ar[]) { int ml, mr, nh = n / 2; if( n == 1 …  |
| | Hello Garrett85 Congratulations that you started to learn SQL from this great book [B]Simply SQ[/B]L written by my friend Rudy Limeback! This is the finest book for beginners I ever read. Clearly and precisely written, covering all important aspects of (DML-) SQL, contains a wealth of useful examples and tips, … |
| | Re: foreign keys Hello obviously there is a one-to-many relationship between table rlbbrand and table rlbbulbs. That means from the view point of rlbbrand that there are many rows of rlbbulbs could be related to. From the view point of rlbbulbs a specific row can be related to only one row of rlbbrand. … |
| | Primarily it depends on you operating system. On 32 bit windows there are "only" 2G bytes per process. So your max. array size would be a little less that 2GB. Also visual c++ 2005 is a 32 bit system. You may also consider that a double needs 8 bytes thus … |
| | Hello Assuming that 1st, a user may have earned 0, 1 or more achievements and 2nd, an achievement may have been earned by 0, 1 or more users then a many-to-many relationship exists between user and achievement. So your data model consists of three tables: user(userID, name, etc) achievement(achievementID, description, … |
| | Re: ORG [URL="http://www.daniweb.com/forums/thread291076.html"]Here[/URL] can you find additional information about ORG directive. -- tesu |
| | Hi Glad to meet you again. In your code you only manipulate the lower 16 bits of eax, ebx and ecx by subtracting 16 bit regs. So the upper 16 bits contain random digits. You should clear them: mov eax, 0 mov ebx, 0 mov ecx, 0 ;; then your … |
| | Hi baby19 You may also have a look at [URL="http://www.databaseanswers.org/data_models"][COLOR="Green"]databaseanswers[/COLOR][/URL], especially at 108. Medical. Happy modelling ;) -- tesu |
| | You could try this: [CODE]String[] names = {"joe", "slim", "ed", "george"}; Arrays.sort(names); System.out.println(Arrays.toString(names));[/CODE] Sorry, meanwhile you have changed your posting. -- tesu |
| | Re: beginner to DBMS Well, Oracle went to the Internet with version 8i (i for Internet). That happened in 1999. Since then there were versions 9i, 10g, and 11g in 2007. So 8i is somewhat outdated. There have been dramatic improvements since 8i. If you want to stay with Oracle, I suggest free 10g … |
| | Hi >>> s for 8086 AND THE TURBO ASSEMBLER, tasm [URL="http://www.daniweb.com/forums/thread297091.html"]Here[/URL] could you find some tasm-like code what I posted related to similar problem, especially the inbuffer definition, the int 21h function 0AH and offset fit real mode tasm/masm well. Keep in mind, that code not tested. -- tesu |
 | Hi >>> Also I though I would ask is it possible to replace the callback function with just the integer 0 as I have been doing or is there something special with the callback function? The [URL="http://www.sqlite.org/cvstrac/wiki?p=SimpleCode"]link[/URL] given by gerard4143 shows an example where callback function isn't further necessary (modern … |
| | Hello in principle, it goes that way [CODE]select yourData from yourtable where datediff (day, s1, now()) <= 10;[/CODE] Now it's your turn to put some c# code around the sql statement. You may show your result for further discussions. -- tesu |
| | Hello I would suggest to use a standard sql database instead of programming all those insert/update/delete functionalities by yourselves. There was a similar question recently. You may read [URL="http://www.daniweb.com/forums/thread300619.html"]here[/URL] what I wrote. To keep it small I suggest to embed a database system into your C++ program. The most embedded …  |
 | +++ deleted +++ Sorry, you aren't allowed to use two-dimensional arrays, so my posting is useless ! +++ deleted +++ |
The End.