[sqlite] unsuscribe

unsuscribe

[sqlite] Nicole J Hinderman is out of the office.

I will be out of the office starting 05/15/2006 and will not return until 05/30/2006. I will be on travel to China and will be checking my email daily so I will respond to you as soon as I can. Please contact Jon Hamann if you need immediate assistance with OMS Product Line or P30 OMS. -Nicole

[sqlite] Nicole J Hinderman is out of the office.

I will be out of the office starting 05/01/2006 and will not return until 05/05/2006. I will respond to your message when I return. Please contact Jon Hamann if you need immediate assistance with OMS Product Line or P30 OMS. -Nicole

Re: [sqlite] sqlite_column_text converting result to a c++ string

I am using C and do this: char *values; values = (char *)sqlite3_column_text(pStmt, i); and I don't have any problems.. I'm not sure if that helps you at all. Terry MacDonald

Re: [sqlite] Formatting the strftimeFunc function

To be able to have our code more internationalized is the reason why we would like this function. Currently we use the format mm/dd/ where other countries use dd/mm/. We would like to have the month abbreviation so that when the information is pulled directly from the database and then di

[sqlite] Formatting the strftimeFunc function

I am looking to be able to return a string from the function strftimeFunc() where the month can be returned as "MMM" (like "AUG"). Is this a feature that could be implemented in SQLITE in the near future? Thanks, Nicole Hinderman

Re: [sqlite] Getting a Unique column from a query

It would be ok to have duplicates of school_id. I just want to make sure that new_id is unique. Jay Sprenkle <[EMAIL PROTECTED]

[sqlite] Getting a Unique column from a query

is it possible to use a Distinct or Unique on a column such as: SELECT school.schoolID AS ID, CASE WHEN class.classtype= 2 THEN class.classtype ELSE teacher.teacherID END AS unique(new_id) FROM Region SELECT school.schoolID AS ID, CASE WHEN class.classtype= 2 THEN class.classtype ELSE teacher.

[sqlite] binding ORDER BY

I am trying to 'ORDER BY ?' in my query because I would like to bind the order by criteria later in my code. This always fails on sqlite3_prepare() with an error, "ORDER BY terms must be non-integer constants". Do you have any suggestions on how I can use a variable in my ORDER BY clause? Thanks,