Here is the schema: create table find_retransmissions(InsTimeStamp int NOT NULL, SrcIp char[16] NOT NULL, DstIp char[16] NOT NULL, TimeStamp char[50] NOT NULL, SrcPort int NOT NULL, DstPort int NOT NULL, SeqNum int NOT NULL, MD5Sum char[33] NOT NULL)
Hemant Shah E-mail: hj...@yahoo.com --- On Mon, 9/27/10, Timothy A. Sawyer <tsaw...@mybowlingdiary.com> wrote: > From: Timothy A. Sawyer <tsaw...@mybowlingdiary.com> > Subject: Re: [sqlite] sqlite cannot find the row > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Monday, September 27, 2010, 6:35 PM > Without seeing the original schema > and more information on what you changed, no idea. > > ** Sent from my mobile device with the tiny keys ** > > Timothy A. Sawyer, CISSP > Managing Director > MBD Consulting, LLC > 55 Madison Av., Suite 400 > Morristown, NJ 07960 > Phone: (973) 285-3261 | Fax: (973) 538-0503 > Web: http://www.mybowlingdiary.com > Email: tsaw...@mybowlingdiary.com > > > -----Original Message----- > From: Hemant Shah <hj...@yahoo.com> > Sender: sqlite-users-boun...@sqlite.org > Date: Mon, 27 Sep 2010 16:14:02 > To: General Discussion of SQLite Database<sqlite-users@sqlite.org> > Reply-To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] sqlite cannot find the row > > Sorry, > > I keep replying to my own posts, but I keep trying > different things to figure out the problem. > > I ran select for all other columns in the table and I was > able to get data, but when I run select for MD5Sum column I > do not get anything. > > > I ran .dump command to dump the data to a file, and ran > .read command to read it into a different database. Now, I > could do a select based upon MD5Sum column. > > Next I edited the output file and changed the table name. I > ran .read and loaded the data into new table in original > database. Now, I could do a select based upon MD5Sum > column. > > Any idea what could be wrong? > > > > Hemant Shah > E-mail: hj...@yahoo.com > > > --- On Mon, 9/27/10, Hemant Shah <hj...@yahoo.com> > wrote: > > > From: Hemant Shah <hj...@yahoo.com> > > Subject: Re: [sqlite] sqlite cannot find the row > > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > > Date: Monday, September 27, 2010, 5:43 PM > > Instead of in-memory database, I > > created database in a file and tried to do select with > same > > results. > > > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.521968|10101|10101|4801345|fd5cb2d226b48d5dd4645d4fe7ca12cf > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.522843|10101|10101|4801345|48cc79ae3c9029c82883843737f98ca1 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.523982|10101|10101|4801345|2522b8b56698cb805170497ebdab5858 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.524920|10101|10101|4801345|4ae983c9b1946dbc905d12333353b71a > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.525914|10101|10101|4801345|7d081eda7db33ea363b6c6655688f08d > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.526910|10101|10101|4801345|105344cb171ecaf81798df75b8d3562e > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.527911|10101|10101|4801345|34ab03b3543b1f0b2ca2f505fc6330f7 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.528910|10101|10101|4801345|8c72bd2c854598f9e817f9d85282aae8 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.529911|10101|10101|4801345|69b5c4d087a270b5b671a1765123ae8b > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.530910|10101|10101|4801345|28c45b4ab9414819bb4c75ff37bf5a7e > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.531911|10101|10101|4801345|2c726e0c63bda2d30e3f9ea38df5ece0 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.532920|10101|10101|4801345|77ac658bcc98321e298cd52d07dcc8d5 > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.534031|10101|10101|4801345|0a41725b5b1a183ebf40489f2037f00d > > > > 1285625918|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.535178|10101|10101|4801345|652575b633b6f4aefe5b6ddb5b085c06 > > > > 1285625919|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.536085|10101|10101|4801345|3a632902e3e07bc7c20e130baf941a33 > > > > 1285625919|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.537085|10101|10101|4801345|5a44897aef3d81d70dee8246d4a7748f > > > > 1285625919|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.538077|10101|10101|4801345|fd6a9a130a5c3bb46ee0e20bf6f02b52 > > > > 1285625919|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.539090|10101|10101|4801345|2efba1c039c0f41361945a27a3e651cd > > > > 1285625919|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.37.540077|10101|10101|4801345|1fde5a8f289b299139c26260c75a6df0 > > > > 1285625920|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.40.481153|10101|10101|4801345|6d7fd3d66e0eb709c38440546a9e3a15 > > > > 1285625920|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.40.481746|10101|10101|4801345|f236a2ecf56f038ff132b91ba94287f4 > > > > sqlite> > > > > sqlite> > > > > sqlite> > > > > sqlite> select * from find_retransmissions where > > InsTimeStamp=1285625920; > > > > 1285625920|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.40.481153|10101|10101|4801345|6d7fd3d66e0eb709c38440546a9e3a15 > > > > 1285625920|10.208.54.32|239.90.91.101|2010-09-27 > > > 17.18.40.481746|10101|10101|4801345|f236a2ecf56f038ff132b91ba94287f4 > > > > sqlite> select * from find_retransmissions where > > MD5Sum='f236a2ecf56f038ff132b91ba94287f4'; > > > > sqlite> > > > > select * displays whole table. If I do select using > another > > column I get appropriate rows, but if I do select on > MD5Sum > > column it returns nothing. > > > > > > > > Hemant Shah > > E-mail: hj...@yahoo.com > > > > > > --- On Mon, 9/27/10, Hemant Shah <hj...@yahoo.com> > > wrote: > > > > > From: Hemant Shah <hj...@yahoo.com> > > > Subject: Re: [sqlite] sqlite cannot find the row > > > To: "General Discussion of SQLite Database" > <sqlite-users@sqlite.org> > > > Date: Monday, September 27, 2010, 4:22 PM > > > Sorry about that. No I do not have > > > single quotes around ?. > > > > > > strcpy(SqlString, "INSERT INTO > > > find_retransmissions(InsTimeStamp, SrcIp, DstIp, > > TimeStamp, > > > SrcP ort, DstPort, SeqNum, MD5Sum) VALUES > > > (?,?,?,?,?,?,?,?)"); > > > > > > sprintf(SqlString, "SELECT SrcIp, DstIp, > TimeStamp, > > > SrcPort, DstPort, SeqNum FROM > find_retransmissions > > WHERE > > > MD5Sum = ?"); > > > > > > > > > I do not have quotes in both statemens, but > insert > > > statement works. > > > > > > > > > Hemant Shah > > > E-mail: hj...@yahoo.com > > > > > > > > > --- On Mon, 9/27/10, Black, Michael (IS) <michael.bla...@ngc.com> > > > wrote: > > > > > > > From: Black, Michael (IS) <michael.bla...@ngc.com> > > > > Subject: Re: [sqlite] sqlite cannot find the > row > > > > To: "General Discussion of SQLite Database" > > <sqlite-users@sqlite.org> > > > > Date: Monday, September 27, 2010, 2:27 PM > > > > Your code is chopped off and I > > > > suspect the problem is on the remainder of > this > > line: > > > > > > > > sprintf(SqlString, "SELECT SrcIp, DstIp, > > TimeStamp, > > > > SrcPort, DstPort, SeqNum > > > > > > > > For example, did you put single quotes > around the > > ? > > > > parameter? > > > > > > > > > > > > Michael D. Black > > > > Senior Scientist > > > > Advanced Analytics Directorate > > > > Northrop Grumman Information Systems > > > > > > > > > > > >________________________________ > > > > > > > > From: sqlite-users-boun...@sqlite.org > > > > on behalf of Hemant Shah > > > > Sent: Mon 9/27/2010 2:22 PM > > > > To: General Discussion of SQLite Database > > > > Subject: EXTERNAL:Re: [sqlite] sqlite cannot > find > > the > > > row > > > > > > > > > > > > > > > > Here is the snippet of code: > > > > > > > > int GetMessageFromDB(char *MD5Sum, struct > > ReceiveNode > > > > *FromDb) > > > > { > > > > int ReturnCode; > > > > sqlite3_stmt *SelectStmtHandle; > > > > > > > > sprintf(SqlString, "SELECT SrcIp, > DstIp, > > > > TimeStamp, SrcPort, DstPort, SeqNum > > > > ReturnCode = > sqlite3_prepare(DbHandle, > > > > SqlString, -1, &SelectStmtHandle, NULL > > > > if (ReturnCode != SQLITE_OK || > > > > SelectStmtHandle == NULL) > > > > { > > > > sqlite3_reset(SelectStmtHandle); > > > > printf("Cannot prepare select > > > > statement. %s\n", > sqlite3_errmsg(DbHandle)); > > > > return(2); > > > > } > > > > > > > > sqlite3_bind_text(SelectStmtHandle, > 1, > > > > MD5Sum, strlen(MD5Sum), SQLITE_TRANSIE > > > > ReturnCode = > > > > sqlite3_step(SelectStmtHandle); > > > > if (ReturnCode != SQLITE_ROW) > > > > { > > > > sqlite3_reset(SelectStmtHandle); > > > > printf("Row not found. ReturnCode: > %d, > > > > Error Message:%s, Error Code: %d\n" > > > > > > > > ReturnCode, sqlite3_errmsg(DbHandle), > > > > sqlite3_errcode(DbHandle)); > > > > return(2); > > > > } > > > > > > > > strcpy(FromDb->SourceIP, > > > > sqlite3_column_text(SelectStmtHandle, 0)); > > > > strcpy(FromDb->DestIP, > > > > sqlite3_column_text(SelectStmtHandle, 1)); > > > > strcpy(FromDb->TimeStamp, > > > > sqlite3_column_text(SelectStmtHandle, 2)); > > > > FromDb->SourcePort = > > > > sqlite3_column_int(SelectStmtHandle, 3); > > > > FromDb->DestPort = > > > > sqlite3_column_int(SelectStmtHandle, 4); > > > > FromDb->SeqNum = > > > > sqlite3_column_int(SelectStmtHandle, 5); > > > > strncpy(FromDb->MD5Sum, MD5Sum, > > > > MD5SUMLEN); > > > > sqlite3_finalize(SelectStmtHandle); > > > > return(1); > > > > } > > > > > > > > int GetMessageFromDB(char *MD5Sum, struct > > ReceiveNode > > > > *FromDb) > > > > { > > > > int ReturnCode; > > > > sqlite3_stmt *SelectStmtHandle; > > > > > > > > sprintf(SqlString, "SELECT SrcIp, > DstIp, > > > > TimeStamp, SrcPort, DstPort, SeqNum > > > > ReturnCode = > sqlite3_prepare(DbHandle, > > > > SqlString, -1, &SelectStmtHandle, NULL > > > > if (ReturnCode != SQLITE_OK || > > > > SelectStmtHandle == NULL) > > > > { > > > > sqlite3_reset(SelectStmtHandle); > > > > printf("Cannot prepare select > > > > statement. %s\n", > sqlite3_errmsg(DbHandle)); > > > > return(2); > > > > } > > > > > > > > sqlite3_bind_text(SelectStmtHandle, > 1, > > > > MD5Sum, strlen(MD5Sum), SQLITE_TRANSIE > > > > ReturnCode = > > > > sqlite3_step(SelectStmtHandle); > > > > if (ReturnCode != SQLITE_ROW) > > > > { > > > > sqlite3_reset(SelectStmtHandle); > > > > printf("Row not found. ReturnCode: > %d, > > > > Error Message:%s, Error Code: %d\n" > > > > > > > > ReturnCode, sqlite3_errmsg(DbHandle), > > > > sqlite3_errcode(DbHandle)); > > > > return(2); > > > > } > > > > > > > > strcpy(FromDb->SourceIP, > > > > sqlite3_column_text(SelectStmtHandle, 0)); > > > > strcpy(FromDb->DestIP, > > > > sqlite3_column_text(SelectStmtHandle, 1)); > > > > strcpy(FromDb->TimeStamp, > > > > sqlite3_column_text(SelectStmtHandle, 2)); > > > > FromDb->SourcePort = > > > > sqlite3_column_int(SelectStmtHandle, 3); > > > > FromDb->DestPort = > > > > sqlite3_column_int(SelectStmtHandle, 4); > > > > FromDb->SeqNum = > > > > sqlite3_column_int(SelectStmtHandle, 5); > > > > strncpy(FromDb->MD5Sum, MD5Sum, > > > > MD5SUMLEN); > > > > sqlite3_finalize(SelectStmtHandle); > > > > return(1); > > > > } > > > > > > > > if (FindDuplicateMessage(ReceiveBuf) == 1) > > > > { > > > > GetMessageFromDB(ReceiveBuf.MD5Sum, > > > > &FromDb); > > > > } > > > > > > > > > > > > > > > > When I execute this functions I get > following > > output. > > > > > > > > > > > > Cannot insert into database. column MD5Sum > is > > not > > > unique > > > > error code = SQLITE_CONSTRAINT > > > > Row not found. ReturnCode: 101, Error > Message:not > > an > > > error, > > > > Error Code: 0 > > > > > > > > > > > > 101 is SQLITE_DONE. So I get SQLITE_DONE > instead > > of > > > > SQLITE_ROW. > > > > > > > > > > > > > > > > Hemant Shah > > > > E-mail: hj...@yahoo.com > > > > > > > > > > > > > > > > > > > > > > > > -----Inline Attachment Follows----- > > > > > > > > >_______________________________________________ > > > > sqlite-users mailing list > > > > sqlite-users@sqlite.org > > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > > > > > >_______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > >_______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users