Click here to Skip to main content
15,849,030 members
Home / Discussions / Database
   

Database

 
GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 15:20
professionaljkirkerx9-Apr-21 15:20 
GeneralRe: Convert date, did I go too far Pin
Richard Deeming11-Apr-21 22:10
mveRichard Deeming11-Apr-21 22:10 
AnswerRe: Convert date, did I go too far, Sort of solved Pin
jkirkerx10-Apr-21 15:06
professionaljkirkerx10-Apr-21 15:06 
QuestionExcel Spreadsheet To Database Migration Assistance Pin
Glen McHale7-Apr-21 0:55
Glen McHale7-Apr-21 0:55 
SuggestionRe: Excel Spreadsheet To Database Migration Assistance Pin
CHill607-Apr-21 1:57
mveCHill607-Apr-21 1:57 
AnswerRe: Excel Spreadsheet To Database Migration Assistance Pin
Mycroft Holmes7-Apr-21 13:54
professionalMycroft Holmes7-Apr-21 13:54 
QuestionSQLite query Pin
David Crow23-Mar-21 11:02
David Crow23-Mar-21 11:02 
AnswerRe: SQLite query Pin
k505423-Mar-21 15:42
mvek505423-Mar-21 15:42 
David Crow wrote:
String sQuery2 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed) AND vehicle_id="+id;

This appears to be missing a + ")". Also, what's the value of id. Just doing a string concatenation could result in SQL injection, so that seems like a bad idea.
Keep Calm and Carry On

GeneralRe: SQLite query Pin
David Crow23-Mar-21 17:10
David Crow23-Mar-21 17:10 
AnswerRe: SQLite query Pin
Richard Deeming24-Mar-21 0:31
mveRichard Deeming24-Mar-21 0:31 
GeneralRe: SQLite query Pin
David Crow24-Mar-21 4:16
David Crow24-Mar-21 4:16 
QuestionDisallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx18-Mar-21 12:56
professionaljkirkerx18-Mar-21 12:56 
AnswerRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
Victor Nijegorodov18-Mar-21 22:15
Victor Nijegorodov18-Mar-21 22:15 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx19-Mar-21 7:58
professionaljkirkerx19-Mar-21 7:58 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jsc4219-Mar-21 8:45
professionaljsc4219-Mar-21 8:45 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jkirkerx19-Mar-21 9:54
professionaljkirkerx19-Mar-21 9:54 
GeneralRe: Disallowed implicit conversion from data type smalldatetime to data type float Pin
jsc4219-Mar-21 12:17
professionaljsc4219-Mar-21 12:17 
GeneralKearning Python Pin
Lumbeta Aquirok18-Mar-21 0:50
Lumbeta Aquirok18-Mar-21 0:50 
GeneralRe: Kearning Python Pin
Richard MacCutchan18-Mar-21 1:01
mveRichard MacCutchan18-Mar-21 1:01 
QuestionSystem.NullReferenceException: Pin
H. Martins23-Feb-21 15:28
H. Martins23-Feb-21 15:28 
AnswerRe: System.NullReferenceException: Pin
Richard MacCutchan23-Feb-21 23:04
mveRichard MacCutchan23-Feb-21 23:04 
GeneralRe: System.NullReferenceException: Pin
Richard Deeming23-Feb-21 23:19
mveRichard Deeming23-Feb-21 23:19 
GeneralRe: System.NullReferenceException: Pin
Richard MacCutchan23-Feb-21 23:31
mveRichard MacCutchan23-Feb-21 23:31 
QuestionGeneral advice about simple table storage. Pin
H. Martins19-Feb-21 10:34
H. Martins19-Feb-21 10:34 
AnswerRe: General advice about simple table storage. Pin
Eddy Vluggen20-Feb-21 8:04
professionalEddy Vluggen20-Feb-21 8:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.