[sqlite] java applet access to sqlite on an arm architecture?

2006-08-10 Thread Keiichi McGuire
Hello, I was wondering if it is possible for a java applet to access sqlite2.8 databases that is installed on an arm architecture. Currently the arm system has apache, php and sqlite installed. The applet will run on windows/linux machine via a browser, but the applet file will be accessed

[sqlite] outputting select in cpp file?

2006-07-28 Thread Keiichi McGuire
This sounds like a very simple problem, but I cannot figure it out! Basically what I have is this settings table that has a boolean data type, and I want to check it via a cpp program. sqlite_exec(db,"select flag from setting",0,0,); and I want to be able to return a 0, or a 1 according to what

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Keiichi McGuire
I'm pretty sure my gcc is not broken (although I'm not sure how to check specifically for this problem). I can compile stuff with gcc without a problem as long as the sqlite stuff is not on there. -Keiichi On 7/24/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 7/24/06, Keiichi McGuire &

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Keiichi McGuire
is that the reinstalled sqlite works, however when I use gcc to compile the code, and then trying to execute, I still get the same error message. Am I missing something here? Thanks! On 7/24/06, Keiichi McGuire <[EMAIL PROTECTED]> wrote: nope, i was actually using the right sqlite, since the other one actuall

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Keiichi McGuire
nope, i was actually using the right sqlite, since the other one actually gave me an architecture error. any ideas? On 7/24/06, Keiichi McGuire <[EMAIL PROTECTED]> wrote: nope, compiler is still the same (gcc). actually... i think i might have the answer. Might have jumped t

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Keiichi McGuire
if it was a false alarm!! -Keiichi On 7/24/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 7/24/06, Keiichi McGuire <[EMAIL PROTECTED]> wrote: > test: ../sqlite-2.8.17/src/btree.c:702: sqliteBtreeOpen: Assertion > 'sizeof(ptr)==sizeof(char*)' failed. > Aborted Did you change compiler

[sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

2006-07-24 Thread Keiichi McGuire
I wrote a simple test program and it is running into a problem. I previously wrote pretty simple c programs that interface with an sqlite file, but for some reason over the weekend the program won't want to run. Here's the code: #include #include #include"sqlite.h" int main() { sqlite *db;

[sqlite] using max value

2006-07-12 Thread Keiichi McGuire
I'm a bit stuck on this one problem I have this simple table that has two fields: id and value. What I want to do is to get the largest id (the last entry) and then add an arbitrary number to the value that's in the same entry as that one, and put the result in the next entry. to make it sound

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-12 Thread Keiichi McGuire
ar cr libsqlite.a *.o ranlib libsqlite.a arm-linux-gcc -o sqlite shell.c libsqlite.a Thank you everyone for helping me out with this!!! On 7/12/06, Christian Smith <[EMAIL PROTECTED]> wrote: Keiichi McGuire uttered: > This is a bit confusing, especially since if I compile it

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-11 Thread Keiichi McGuire
ie too, I had a similar problem, but not with sqlite, and I had to recompile the lib file. After that, I was able to build my program. Perhaps you need to grab the source to sqlite and use arm-linux-gcc to compile it in to a library file. David On Tue, 2006-07-11 at 20:16 -0700, Keiichi McGuire

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-11 Thread Keiichi McGuire
youhave a clean compile,but no sqlite library. It is looking forlibsqlite.so or libsqlite.a. Seems to be finding an libsqlite.a which is incompatible with yhe object you compiled. Keiichi McGuire wrote: > still no luck:( > and yea I'm still a bit new to C. I have a few years experience

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-11 Thread Keiichi McGuire
ll have malloc'd memory for that message so you need to "free" it or suffer a memory leak.*/ if (errmsg != NUL) { ... } . } I guess you are new to C. It will get easier. The first ten years are the hardest. Keiichi McGuire wrote: > Hi John, > I still get an er

Re: [sqlite] problems compiling with arm-linux-gcc

2006-07-11 Thread Keiichi McGuire
actually got the v2 from an ipkg package, and there was an sqlite3 package available, but it was not compatible with php that is on this system. -Keiichi On 7/11/06, John Stanton <[EMAIL PROTECTED]> wrote: Keiichi McGuire wrote: > Hi everyone, > I'm still a bit new to sqlite and also to cr

[sqlite] problems compiling with arm-linux-gcc

2006-07-11 Thread Keiichi McGuire
Hi everyone, I'm still a bit new to sqlite and also to crosscompiling programs. I've been having problems with being able to compile this test c program that should just connect to the database. My program looks like this: #include #include"sqlite.h> int main() { printf("Hello!\n"); sqlite