View mode: basic / threaded / horizontal-split · Log in · Help
April 13, 2005
Function and variable assignment
I have the database api all setup and functioning, but now I would like 
to do something like:

Results res = db.query("SELECT * FROM people");
Row row;
char[] name, city, state, zip;

row.bind("name", name);
row.bind("city", city);
row.bind("state", state);
row.bind("zip", zip);

while((row = res.fetchRow()) != null) {
  printf("Name = %.*s, city = %.*s, state = %.*s, zip = %.*s", name, 
city, state, zip);
}


----

the row.bind function is what I do not know how to develop, or if it's 
even possible. Can someone give me a simple example? Not of how the 
database api works, but simply how I would store a reference to the char 
array for later assigning and repeat assigning in my Row class.

Thanks!

Jeremy
April 13, 2005
Re: Function and variable assignment
Hmm... maybe something like this:

# char[] name, city, state, zip;
#
# row.bind("name", &name);
# // etc

Where Row.bind is defined as:
# public void bind(char[] label, char[]* var) { ... }

Then keep a map of variables locally, something like:
# private char[]*[char[]] boundvars;

Just a 20-seconds-of-thought suggestion.

-- Chris Sauls

Jeremy Cowgar wrote:
> I have the database api all setup and functioning, but now I would like 
> to do something like:
> 
> Results res = db.query("SELECT * FROM people");
> Row row;
> char[] name, city, state, zip;
> 
> row.bind("name", name);
> row.bind("city", city);
> row.bind("state", state);
> row.bind("zip", zip);
> 
> while((row = res.fetchRow()) != null) {
>   printf("Name = %.*s, city = %.*s, state = %.*s, zip = %.*s", name, 
> city, state, zip);
> }
> 
> 
> ----
> 
> the row.bind function is what I do not know how to develop, or if it's 
> even possible. Can someone give me a simple example? Not of how the 
> database api works, but simply how I would store a reference to the char 
> array for later assigning and repeat assigning in my Row class.
> 
> Thanks!
> 
> Jeremy
Top | Discussion index | About this forum | D home